[6.1] Data Conversion/Import Tool

Yahoo Archive
1
As I was in the process of looking for something unrelated, I ran
across some documentation/information on the Import Integration Table
Utility (provided by Epicor). It imports ASCII data into the Vantage IM
tables, which, in turn, get written to the permanent database tables
via the Process Server. This was a 6.1 New Feature called Integration
Tables. I was interested in this because the data is validated before
being applied to the permanent tables. This looked like the right way
to migrate (and possibly integrate) data to/with Vantage.
Documentation/information was thin on this tool, we were too new to the
Vantage world and time ran out so we dropped further investigation.
Perhaps someone in the Vantage community has had some real experience
with it. Anyway, another possibility for integration.

Peter Dunbar
Halm Industries Co., Inc.
2
As part of our integration of our external quote system with Vantage (or preferably NOT) I had to offer up the Data Conversion/Import Tool as an alternative for loading our Part BoMs. On it's own I think this would not be economically justifiable but today I got a request from accounting to see if this tool would also help with importing cash receipts from a lock-box report we get form the bank - plus, while I am at it, see if the tool can handle journal entries that we already have in a spreadsheet.

My question is whether this tool handles "transaction" type data or just master tables. With cash receipts and Journal Entries entered into a group and then validated and updated I was hoping we could create a group and then populate it with an import before updating it via Vantage.

How extensive are the capabilities of this tool? I have searched the message archives and did not see any reports of huge problems with it. If we can accomplish several automated import tasks from external systems it might be justifiable, a good thing. If not....then I just might be able to get rid of the stupid external quote system, a better thing. ;)

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]
3
Are you thinking about using this as an ongoing tool? Service Connect
processes transaction type data, and if you have someone in house that can
write your own workflows, can be used for many different processes. So
far, we are only using it to transfer data from our Agile system to create
all parts and boms in Vantage, but we plan to expand it into several other
processes.

Karen





"Todd Caughey"
<caugheyt@harveyv
ogel.com> To
Sent by: <vantage@yahoogroups.com>
vantage@yahoogrou cc
ps.com
Subject
[Vantage] [6.1] Data
06/09/2006 10:03 Conversion/Import Tool
AM


Please respond to
vantage@yahoogrou
ps.com






As part of our integration of our external quote system with Vantage (or
preferably NOT) I had to offer up the Data Conversion/Import Tool as an
alternative for loading our Part BoMs. On it's own I think this would not
be economically justifiable but today I got a request from accounting to
see if this tool would also help with importing cash receipts from a
lock-box report we get form the bank - plus, while I am at it, see if the
tool can handle journal entries that we already have in a spreadsheet.

My question is whether this tool handles "transaction" type data or just
master tables. With cash receipts and Journal Entries entered into a group
and then validated and updated I was hoping we could create a group and
then populate it with an import before updating it via Vantage.

How extensive are the capabilities of this tool? I have searched the
message archives and did not see any reports of huge problems with it. If
we can accomplish several automated import tasks from external systems it
might be justifiable, a good thing. If not....then I just might be able to
get rid of the stupid external quote system, a better thing. ;)

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

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





[Non-text portions of this message have been removed]
4
I used the Epicor Data Conversion tool for our Vantage 6.1
implementation 2 years ago and your post brought back fond(?) memories.
Actually, it reminded me of how nervous the tool made me. The onus is
entirely on you for updating the proper tables in the Vantage database.
If you possess advanced knowledge of the DB and application, you can
probably mimic all kinds of transactions. The tool also has a bunch of
pre- and post-processing program hooks that allow for data manipulation
but that functionality was over my head. My reaction to your post is
that the thought is scary and I don't like it.

Peter Dunbar
Halm Industries Co., Inc.
5
Yes, ongoing and, depending on cost, only for a few years until we get to Vantage 8.0. Is Service Connect available for 6.1? We have several sources of external data (lock box spreadsheet, journal entry log spreadsheet and Access quote system) that we have a huge push going on to drive out manual re-keying of data already in electronic form.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of kknolls@...
Sent: Friday, June 09, 2006 10:21 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] [6.1] Data Conversion/Import Tool





Are you thinking about using this as an ongoing tool? Service Connect
processes transaction type data, and if you have someone in house that can
write your own workflows, can be used for many different processes. So
far, we are only using it to transfer data from our Agile system to create
all parts and boms in Vantage, but we plan to expand it into several other
processes.

Karen

"Todd Caughey"
<caugheyt@harveyv
ogel.com> To
Sent by: < vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com>
vantage@yahoogrou cc
ps.com
Subject
[Vantage] [6.1] Data
06/09/2006 10:03 Conversion/Import Tool
AM


Please respond to
vantage@yahoogrou
ps.com



As part of our integration of our external quote system with Vantage (or
preferably NOT) I had to offer up the Data Conversion/Import Tool as an
alternative for loading our Part BoMs. On it's own I think this would not
be economically justifiable but today I got a request from accounting to
see if this tool would also help with importing cash receipts from a
lock-box report we get form the bank - plus, while I am at it, see if the
tool can handle journal entries that we already have in a spreadsheet.

My question is whether this tool handles "transaction" type data or just
master tables. With cash receipts and Journal Entries entered into a group
and then validated and updated I was hoping we could create a group and
then populate it with an import before updating it via Vantage.

How extensive are the capabilities of this tool? I have searched the
message archives and did not see any reports of huge problems with it. If
we can accomplish several automated import tasks from external systems it
might be justifiable, a good thing. If not....then I just might be able to
get rid of the stupid external quote system, a better thing. ;)

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

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

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







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