Importing into vantage

Yahoo Archive
1
Jim,
Epicor has a custom import utility $2800 that we used to import data
from a UNIX system into
Vantage. You have to do this in a certain order, but all the
instructions are included with the package.
good luck!
2
Hello group,

my boss wants me to ask this group if it is possible to import specific information into vantage from another system. I'm basically a report writer and don't have a clue as how to accomplish this.We use one system for Sales orders / financials and payroll. we use vantage for job tracking / job costing / raw materials / labor entry/ etc. We would like to import info like sales order no, job no, part ordered, quantity, etc from the sales system directly (if possible) into the appropriate corresponding fields in vantage. The other system runs off of progress 7.0/8.0.
thanks



[Non-text portions of this message have been removed]
3
Vantage is not condusive to Import, though there are PRICEY aftermarket
programs IE: Epicor Custom Programing, and Consultants. I also see that
your boss, (like mine) isnt condusive to single package multi purpose
software. (IE: (heavy mexican accent) We don't need no stinken integrated
system)
Shirley Graver
Systems Administrator
Rubber Associates Inc.
Cleveland/Akron, OH

-----Original Message-----
From: Dennis Houghton [mailto:dennis@...]
Sent: Thursday, May 23, 2002 2:19 PM
To: vantage
Subject: [Vantage] Importing into vantage



Hello group,

my boss wants me to ask this group if it is possible to import specific
information into vantage from another system. I'm basically a report writer
and don't have a clue as how to accomplish this.We use one system for Sales
orders / financials and payroll. we use vantage for job tracking / job
costing / raw materials / labor entry/ etc. We would like to import info
like sales order no, job no, part ordered, quantity, etc from the sales
system directly (if possible) into the appropriate corresponding fields in
vantage. The other system runs off of progress 7.0/8.0.
thanks



[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
4
From what I understand the answer is Yes and No. With the standard Vantage product, you can import BOM's, but nothing else. You can puchase Vantage's import/export module for a couple thousand dollars which will import many of the Vantage tables down to a certain level. An external free option which is not supported by Epicor is to change fields in Vantage using ODBC along with either Excel or Access. A final option is to purchase the full Progress Language tools and you can write to the database by writing your own programs. This costs quite a few thousand dollars, I understand, but has powerful possibilities for customization.

In other words, for most companies what you are proposing to do is not an option unless you want to dish out some bucks and/or incur some risk.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Dennis Houghton
To: vantage
Sent: Thursday, May 23, 2002 2:18 PM
Subject: [Vantage] Importing into vantage


Hello group,

my boss wants me to ask this group if it is possible to import specific information into vantage from another system. I'm basically a report writer and don't have a clue as how to accomplish this.We use one system for Sales orders / financials and payroll. we use vantage for job tracking / job costing / raw materials / labor entry/ etc. We would like to import info like sales order no, job no, part ordered, quantity, etc from the sales system directly (if possible) into the appropriate corresponding fields in vantage. The other system runs off of progress 7.0/8.0.
thanks



[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
5
Epicor has an import export utility where you can import data into
over 30 different tables. price $2500. I used it to load a new company.
I imported data from an HP system. The data obviously needs to be
in the correct format, but it is not difficult to set up. If the data
is not formatted correctly, an error log records the problem.
Let me know if you need more information.
6
Can't overemphasize the words "correct format". It is easy as can be to fry
all of your Vantage data by throwing a little data into the wrong
pot. -Gary

-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Thursday, May 23, 2002 3:24 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Importing into vantage


Epicor has an import export utility where you can import data into
over 30 different tables. price $2500. I used it to load a new company.
I imported data from an HP system. The data obviously needs to be
in the correct format, but it is not difficult to set up. If the data
is not formatted correctly, an error log records the problem.
Let me know if you need more information.


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
7
----- Original M
Prophet21 is the name of our sales/inventory software. We use a purchase
order register list from this system and manually enter all purchase order
and job information from this into vantage. We use the last five numbers of
the purchase order for the job number and add the job type letter to the end
of it and add a P in front of it. It may be possible to write a crystal
report with all the fields and in the correct format and export it or
something instead of trying to use prophets canned report. We are on Vantage
4, progress 9, crystal 7. This import will be used to add new orders/jobs
into Vantage.
Thanks
essage -----
From: Gary Polvinale
To: vantage@yahoogroups.com
Sent: Friday, May 24, 2002 9:02 AM
Subject: RE: [Vantage] Importing into vantage


Can't overemphasize the words "correct format". It is easy as can be to fry
all of your Vantage data by throwing a little data into the wrong
pot. -Gary

-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Thursday, May 23, 2002 3:24 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Importing into vantage


Epicor has an import export utility where you can import data into
over 30 different tables. price $2500. I used it to load a new company.
I imported data from an HP system. The data obviously needs to be
in the correct format, but it is not difficult to set up. If the data
is not formatted correctly, an error log records the problem.
Let me know if you need more information.


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
8
Anyone have any luck getting any data imported into Vantage
We have a facility with another ERP software package That we want to
dump their info on building parts into Vantage
Custom programming?
Any ideas what something like this would cost?

James Piper
Systems Administrator
Meco Inc