Import of Masters - Customers Suppliers & Parts

Yahoo Archive
1
Misunderstood Table relations and no validation are the issues with ODBC. Connection should not be an issue if you do it local and not attempt it through VPN on a flaky connection. Also, an ODBC process can tie up server resources so always best to do during 'off hours'.

Kersten MacLennan <kmaclennan@...> wrote: Does Service Connect allow record update and delete or just new
addition? Also I was wondering if the table corruption would be due to
the ODBC connection or the fact that the user may not know all of the
tables that are affected by the import.


Thanks


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@...

The Standard in Optical Filters for Biotech & Analytical Instrumentation

Hundreds of Thousands of Ion Beam Sputtered filters delivered -
extensive inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Friday, April 04, 2008 1:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Import of Masters - Customers Suppliers &
Parts

> Our Epicor Consultant told us that using ODBC to update records would
> invalidate our support agreement. Is everyone else just willing to
> take that risk, or was our consultant exaggerating?

I would not take the risk. There are posts on this list where database
corruption occurred even when Epicor did the work using the Pervasive
tool.

And database corruption has become a quite popular retort while speaking
to
support these days... So me personally, I wouldn't do it.

I used the Business Objects directly but using Service connect and web
services would work too.

IMHO,

Mark W.

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






---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.

[Non-text portions of this message have been removed]
2
How is the import of masters like Customers, suppliers and Parts into Vantage 8.03 done?

Padmanabhan


____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping

[Non-text portions of this message have been removed]
3
Epicor has data mapping tools available if you choose to do the importing yourself. Ask them about it.


"Manoj K. Padmanabhan" <manusgotmail@...> wrote: How is the import of masters like Customers, suppliers and Parts into Vantage 8.03 done?

Padmanabhan

__________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping

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






---------------------------------
Never miss a thing. Make Yahoo your homepage.

[Non-text portions of this message have been removed]
4
v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}w\:* {behavior:url(#default#VML);}..shape {behavior:url(#default#VML);}
HiRobert,



Thank you for the reply. We had contactedEpicor and they had asked to use Service Connect. Unfortunately we don’thave an expertise in using Service Connect.



But we managed to find the tables that areupdated in MS SQL when, for e.g., a new part is entered into Part Maintenance.We did manage to import some parts through Excel to SQL import and put in sometransactions. Is this a normal practice to follow? Has any one already done adirect master import (parts / customer / supplier) in Vantage. We found it lesstime consuming that getting a Service Connect expert and doing the whole thing.



Thanks & regards



Padmanabhan

---------------------------------


From: vantage@yahoogroups.com[mailto:vantage@yahoogroups.com] On Behalf OfRobert Brown
Sent: 19 January 2008 19:13
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Import ofMasters - Customers Suppliers & Parts




Epicor has data mapping tools available if you chooseto do the importing yourself. Ask them about it.

"Manoj K. Padmanabhan" <manusgotmail@...>wrote: How is the import of masters like Customers, suppliers and Parts intoVantage 8.03 done?

Padmanabhan

__________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping

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





---------------------------------
Never miss a thing. Make Yahoo your homepage.

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






---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

[Non-text portions of this message have been removed]
5
Directly connecting to the database with odbc could cause data corruption
therefore i used AHK (autohotkey) and wrote keyboard macros that
imported our parts, it took a few days to program
but i was able to import thousands of parts in a night..............





Manoj K. Padmanabhan schreef:
> v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}w\:* {behavior:url(#default#VML);}..shape {behavior:url(#default#VML);}
> HiRobert,
>
>
>
> Thank you for the reply. We had contactedEpicor and they had asked to use Service Connect. Unfortunately we don’thave an expertise in using Service Connect.
>
>
>
> But we managed to find the tables that areupdated in MS SQL when, for e.g., a new part is entered into Part Maintenance.We did manage to import some parts through Excel to SQL import and put in sometransactions. Is this a normal practice to follow? Has any one already done adirect master import (parts / customer / supplier) in Vantage. We found it lesstime consuming that getting a Service Connect expert and doing the whole thing.
>
>
>
> Thanks & regards
>
>
>
> Padmanabhan
>
> ---------------------------------
>
>
> From: vantage@yahoogroups.com[mailto:vantage@yahoogroups.com] On Behalf OfRobert Brown
> Sent: 19 January 2008 19:13
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Import ofMasters - Customers Suppliers & Parts
>
>
>
>
> Epicor has data mapping tools available if you chooseto do the importing yourself. Ask them about it.
>
> "Manoj K. Padmanabhan" <manusgotmail@...>wrote: How is the import of masters like Customers, suppliers and Parts intoVantage 8.03 done?
>
> Padmanabhan
>
> __________________________________________________________
> Looking for last minute shopping deals?
> Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> ---------------------------------
> Never miss a thing. Make Yahoo your homepage.
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
>
> [Non-text portions of this message have been removed]
>
>
>
> 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
> Yahoo! Groups Links
>
>
>
>
6
I imported Parts, Customers, Suppliers, BOM, Purchase Orders,
Receipts and AP Invoices into Vantage using ODBC from Mapics on an
AS400. I have to admit it was an extremely involved process and took
several months on my part but it was worth it. It is not as
difficult a process as Epicor wants you to think it is. I have been
a programmer for years and have imported and exported data from many
systems. Vantage is just another database.
Customers are one of the easiest tables to import. The one "gotcha"
is if you have CRM you need to be concerned about salesmen and
territories during the import process. Parts are also fairly easy
but they involved lots of tables that you may be unaware of.
Suppliers are probably about the easiest to import. The rest of the
data gets very, very involved. I would not suggest importing any
thing other than master tables unless you have a really good
programmer with an excellent understanding of Vantage.

--- In vantage@yahoogroups.com, Fons van der Beek
<fons.vanderbeek@...> wrote:
>
> Directly connecting to the database with odbc could cause data
corruption
> therefore i used AHK (autohotkey) and wrote keyboard macros that
> imported our parts, it took a few days to program
> but i was able to import thousands of parts in a night..............
>
>
>
>
>
> Manoj K. Padmanabhan schreef:
> > v\:* {behavior:url(#default#VML);}o\:* {behavior:url
(#default#VML);}w\:* {behavior:url(#default#VML);}..shape
{behavior:url(#default#VML);}
> > HiRobert,
> >
> >
> >
> > Thank you for the reply. We had contactedEpicor and they had
asked to use Service Connect. Unfortunately we don’thave an
expertise in using Service Connect.
> >
> >
> >
> > But we managed to find the tables that areupdated in MS SQL when,
for e.g., a new part is entered into Part Maintenance.We did manage
to import some parts through Excel to SQL import and put in
sometransactions. Is this a normal practice to follow? Has any one
already done adirect master import (parts / customer / supplier) in
Vantage. We found it lesstime consuming that getting a Service
Connect expert and doing the whole thing.
> >
> >
> >
> > Thanks & regards
> >
> >
> >
> > Padmanabhan
> >
> > ---------------------------------
> >
> >
> > From: vantage@yahoogroups.com[mailto:vantage@yahoogroups.com] On
Behalf OfRobert Brown
> > Sent: 19 January 2008 19:13
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] Import ofMasters - Customers Suppliers &
Parts
> >
> >
> >
> >
> > Epicor has data mapping tools available if you chooseto do the
importing yourself. Ask them about it.
> >
> > "Manoj K. Padmanabhan" <manusgotmail@...>wrote: How is the import
of masters like Customers, suppliers and Parts intoVantage 8.03 done?
> >
> > Padmanabhan
> >
> > __________________________________________________________
> > Looking for last minute shopping deals?
> > Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > ---------------------------------
> > Never miss a thing. Make Yahoo your homepage.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Be a better friend, newshound, and know-it-all with Yahoo!
Mobile. Try it now.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > 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
> > Yahoo! Groups Links
> >
> >
> >
> >
>
7
Glad to help but I'm no expert - Just passing on knowledge of how our (truly gifted) IT Manager moved data from our legacy system to 8.03 (now 403D).

One caveat: If I understood your reply correctly, you mentioned (what I interpreted as) successfully importing transaction data. While most transaction records are relatively simple single of multi-table data entities, the changes transaction make to complex order, job, PO, Part data entities are quite involved (and somewhat of a moving target as subtle changes occur in release updates).

I'd avoid even attempting transaction imports.

"Manoj K. Padmanabhan" <manusgotmail@...> wrote:
v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}w\:* {behavior:url(#default#VML);}..shape {behavior:url(#default#VML);}
HiRobert,

Thank you for the reply. We had contactedEpicor and they had asked to use Service Connect. Unfortunately we don’thave an expertise in using Service Connect.

But we managed to find the tables that areupdated in MS SQL when, for e.g., a new part is entered into Part Maintenance.We did manage to import some parts through Excel to SQL import and put in sometransactions. Is this a normal practice to follow? Has any one already done adirect master import (parts / customer / supplier) in Vantage. We found it lesstime consuming that getting a Service Connect expert and doing the whole thing.

Thanks & regards

Padmanabhan

---------------------------------

From: vantage@yahoogroups.com[mailto:vantage@yahoogroups.com] On Behalf OfRobert Brown
Sent: 19 January 2008 19:13
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Import ofMasters - Customers Suppliers & Parts

Epicor has data mapping tools available if you chooseto do the importing yourself. Ask them about it.

"Manoj K. Padmanabhan" <manusgotmail@...>wrote: How is the import of masters like Customers, suppliers and Parts intoVantage 8.03 done?

Padmanabhan

__________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping

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

---------------------------------
Never miss a thing. Make Yahoo your homepage.

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

---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

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






---------------------------------
Never miss a thing. Make Yahoo your homepage.

[Non-text portions of this message have been removed]
8
I agree, Vantage is like any other database. If you do enough testing to
figure out all the tables/fields that need touched, you should be able to
import almost anything.

We used a variety of methods to get data into Vantage.
1. We imported some master tables via the copy and paste functionality...
Countries, Terms, Departments, Charts for GL, etc.

2. A couple of the items we intended to paste import did not work due to
bugs in those applications (Open AR & Open AP). Since we already had the
data setup for entry into those screens, we simply printed it as a bar coded
report and scanned it into Vantage (one bar code for each record).

3. We used Pervasive's Data Integrator to import more complex things via
ODBC...
Customers, ShipTo's, Suppliers and Purchase Points.

We'll use Data Integrator for on Parts, Contacts and other tables as we move
forward.

Pervasive's Data Integrator is a GREAT tool, I HIGHLY recommend it! We are
migrating from 2 legacy systems onto Vantage. We had to merge data from
these two systems to import it into Vantage. We also changed our chart of
accounts #, terms codes, sales rep codes, customer codes, supplier codes and
many other things during our conversion. I don't see how we could have
smoothly managed that much change in such a short time period without the
Data Integrator.

Data Integrator is the mapping tool that Epicor uses, but we chose to get it
straight from Pervasive since Epicor's version is stripped down and
Pervasive's support is much better. The "Universal" version that we
purchased is supposed to be able to create Web Services workflows just like
Service Connect. Unfortunately, after 2 days of trying we were not able to
get Vantage's web services working so we imported via ODBC. We'll try
working on the web services again later.

Here's a link for anyone interested in checking Data Integrator out...
http://ww2.pervasive.com/Integration/Products/Pages/PervasiveDataIntegrator.
aspx


Good Luck!

Dan Snyder
IT Manager
Mercury Electronics
717-428-0222 ext.224



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
charles06072006
Sent: Sunday, January 20, 2008 9:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Import of Masters - Customers Suppliers & Parts



I imported Parts, Customers, Suppliers, BOM, Purchase Orders,
Receipts and AP Invoices into Vantage using ODBC from Mapics on an
AS400. I have to admit it was an extremely involved process and took
several months on my part but it was worth it. It is not as
difficult a process as Epicor wants you to think it is. I have been
a programmer for years and have imported and exported data from many
systems. Vantage is just another database.
Customers are one of the easiest tables to import. The one "gotcha"
is if you have CRM you need to be concerned about salesmen and
territories during the import process. Parts are also fairly easy
but they involved lots of tables that you may be unaware of.
Suppliers are probably about the easiest to import. The rest of the
data gets very, very involved. I would not suggest importing any
thing other than master tables unless you have a really good
programmer with an excellent understanding of Vantage.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, Fons van
der Beek
<fons.vanderbeek@...> wrote:
>
> Directly connecting to the database with odbc could cause data
corruption
> therefore i used AHK (autohotkey) and wrote keyboard macros that
> imported our parts, it took a few days to program
> but i was able to import thousands of parts in a night..............
>
> Manoj K. Padmanabhan schreef:
> > HiRobert,
> >
> > Thank you for the reply. We had contactedEpicor and they had
asked to use Service Connect. Unfortunately we don’thave an
expertise in using Service Connect.
> >
> > But we managed to find the tables that areupdated in MS SQL when,
for e.g., a new part is entered into Part Maintenance.We did manage
to import some parts through Excel to SQL import and put in
sometransactions. Is this a normal practice to follow? Has any one
already done adirect master import (parts / customer / supplier) in
Vantage. We found it lesstime consuming that getting a Service
Connect expert and doing the whole thing.
> >
> >
> > Thanks & regards
> >
> > Padmanabhan
> >
> > ---------------------------------
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
.com[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]

> > On Behalf OfRobert Brown
> > Sent: 19 January 2008 19:13
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: Re: [Vantage] Import ofMasters - Customers Suppliers

> > & Parts
> >
> >
> > Epicor has data mapping tools available if you chooseto do the
importing yourself. Ask them about it.
> >
> > "Manoj K. Padmanabhan" <manusgotmail@...>wrote: How is the import
of masters like Customers, suppliers and Parts intoVantage 8.03 done?
> >
> > Padmanabhan


.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msgId=6
1963/stime=1200837745/nc1=4507179/nc2=5170418/nc3=5170401>



[Non-text portions of this message have been removed]
9
Fons,
Would you be willing to share what you have done in Autohotkey? Keyboard macros, etc.

Thanks,
-Karl-

Fons van der Beek <fons.vanderbeek@...> wrote:
Directly connecting to the database with odbc could cause data corruption
therefore i used AHK (autohotkey) and wrote keyboard macros that
imported our parts, it took a few days to program
but i was able to import thousands of parts in a night..............

Manoj K. Padmanabhan schreef:
> v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}w\:* {behavior:url(#default#VML);}..shape {behavior:url(#default#VML);}
> HiRobert,
>
>
>
> Thank you for the reply. We had contactedEpicor and they had asked to use Service Connect. Unfortunately we don’thave an expertise in using Service Connect.
>
>
>
> But we managed to find the tables that areupdated in MS SQL when, for e.g., a new part is entered into Part Maintenance.We did manage to import some parts through Excel to SQL import and put in sometransactions. Is this a normal practice to follow? Has any one already done adirect master import (parts / customer / supplier) in Vantage. We found it lesstime consuming that getting a Service Connect expert and doing the whole thing.
>
>
>
> Thanks & regards
>
>
>
> Padmanabhan
>
> ---------------------------------
>
>
> From: vantage@yahoogroups.com[mailto:vantage@yahoogroups.com] On Behalf OfRobert Brown
> Sent: 19 January 2008 19:13
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Import ofMasters - Customers Suppliers & Parts
>
>
>
>
> Epicor has data mapping tools available if you chooseto do the importing yourself. Ask them about it.
>
> "Manoj K. Padmanabhan" <manusgotmail@...>wrote: How is the import of masters like Customers, suppliers and Parts intoVantage 8.03 done?
>
> Padmanabhan
>
> __________________________________________________________
> Looking for last minute shopping deals?
> Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> ---------------------------------
> Never miss a thing. Make Yahoo your homepage.
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
>
> [Non-text portions of this message have been removed]
>
>
>
> 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
> Yahoo! Groups Links
>
>
>
>






---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.

[Non-text portions of this message have been removed]
10
Do you know if there is a cost to these Epicor tools?

Thanks,
Ian

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> Epicor has data mapping tools available if you choose to do the
importing yourself. Ask them about it.
>
>
> "Manoj K. Padmanabhan" <manusgotmail@...>
wrote: How is the import of masters
like Customers, suppliers and Parts into Vantage 8.03 done?
>
> Padmanabhan
>
> __________________________________________________________
> Looking for last minute shopping deals?
> Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> ---------------------------------
> Never miss a thing. Make Yahoo your homepage.
>
> [Non-text portions of this message have been removed]
>
11
You can purchase the pervasive tool for around $20,000 which lets you import data (AP, AR, Customers, Suppliers, BOMs, etc) or they will charge you for a service for each which I believe is around $2500 with a max tries of 3 before they charge again

Ian Poulsen <ianpoulsen@...> wrote: Do you know if there is a cost to these Epicor tools?

Thanks,
Ian

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> Epicor has data mapping tools available if you choose to do the
importing yourself. Ask them about it.
>
>
> "Manoj K. Padmanabhan" <manusgotmail@...>
wrote: How is the import of masters
like Customers, suppliers and Parts into Vantage 8.03 done?
>
> Padmanabhan
>
> __________________________________________________________
> Looking for last minute shopping deals?
> Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> ---------------------------------
> Never miss a thing. Make Yahoo your homepage.
>
> [Non-text portions of this message have been removed]
>






---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.

[Non-text portions of this message have been removed]
12
The Pervasive tool that Epicor sells is not the same if you buy it
directly from Pervasive.



Pervasive sells a standard and professional edition. The professional
edition is necessary because it supports multi-mode ODBC. The edition
Epicor sells supports the multi-ODBC but doesn't include support for
many of the connection types included if purchased directly from
Pervasive. The Epicor edition is less expensive to purchase but we
didn't consider it since we intended to make use of the tool for
on-going use after the implementation project was over.



John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948

(201) 843-2400 x4148

(201) 843-2931 (fax)





[Non-text portions of this message have been removed]
13
Our Epicor Consultant told us that using ODBC to update records would
invalidate our support agreement. Is everyone else just willing to
take that risk, or was our consultant exaggerating?
Thanks,
Craig

--- In vantage@yahoogroups.com, "Hatcher, John" <johnh@...> wrote:
>
> The Pervasive tool that Epicor sells is not the same if you buy it
> directly from Pervasive.
>
>
>
> Pervasive sells a standard and professional edition. The
professional
> edition is necessary because it supports multi-mode ODBC. The
edition
> Epicor sells supports the multi-ODBC but doesn't include support for
> many of the connection types included if purchased directly from
> Pervasive. The Epicor edition is less expensive to purchase but we
> didn't consider it since we intended to make use of the tool for
> on-going use after the implementation project was over.
>
>
>
> John A. Hatcher
>
> Manager of IS
>
> Versa Products Co., Inc.
>
> (201) 518-5948
>
> (201) 843-2400 x4148
>
> (201) 843-2931 (fax)
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
14
> Our Epicor Consultant told us that using ODBC to update records would
> invalidate our support agreement. Is everyone else just willing to
> take that risk, or was our consultant exaggerating?

I would not take the risk. There are posts on this list where database
corruption occurred even when Epicor did the work using the Pervasive tool.

And database corruption has become a quite popular retort while speaking to
support these days... So me personally, I wouldn't do it.

I used the Business Objects directly but using Service connect and web
services would work too.

IMHO,

Mark W.
15
I strongly agree with Mark - especially since there are other solutions.
As another example, when we did our last Cost Set Entry to roll
standards, I used Access to write an automation script using the SendKey
function. It took two minutes to load several hundred costs.



Butch



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Friday, April 04, 2008 10:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Import of Masters - Customers Suppliers &
Parts



> Our Epicor Consultant told us that using ODBC to update records would
> invalidate our support agreement. Is everyone else just willing to
> take that risk, or was our consultant exaggerating?

I would not take the risk. There are posts on this list where database
corruption occurred even when Epicor did the work using the Pervasive
tool.

And database corruption has become a quite popular retort while speaking
to
support these days... So me personally, I wouldn't do it.

I used the Business Objects directly but using Service connect and web
services would work too.

IMHO,

Mark W.





[Non-text portions of this message have been removed]
16
Thanks for the feedback. I have been using service connect, but it is
so flaky. Memory leaks, can't find any way to remove values, 2-3
weeks to get response from support. I was just hoping there was an
easier way.
--- In vantage@yahoogroups.com, "Butch Menge" <bmenge@...> wrote:
>
> I strongly agree with Mark - especially since there are other
solutions.
> As another example, when we did our last Cost Set Entry to roll
> standards, I used Access to write an automation script using the
SendKey
> function. It took two minutes to load several hundred costs.
>
>
>
> Butch
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Mark Wonsil
> Sent: Friday, April 04, 2008 10:48 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Import of Masters - Customers Suppliers &
> Parts
>
>
>
> > Our Epicor Consultant told us that using ODBC to update records
would
> > invalidate our support agreement. Is everyone else just willing to
> > take that risk, or was our consultant exaggerating?
>
> I would not take the risk. There are posts on this list where
database
> corruption occurred even when Epicor did the work using the
Pervasive
> tool.
>
> And database corruption has become a quite popular retort while
speaking
> to
> support these days... So me personally, I wouldn't do it.
>
> I used the Business Objects directly but using Service connect and
web
> services would work too.
>
> IMHO,
>
> Mark W.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
17
Does Service Connect allow record update and delete or just new
addition? Also I was wondering if the table corruption would be due to
the ODBC connection or the fact that the user may not know all of the
tables that are affected by the import.


Thanks


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@...

The Standard in Optical Filters for Biotech & Analytical Instrumentation


Hundreds of Thousands of Ion Beam Sputtered filters delivered -
extensive inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you




________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Friday, April 04, 2008 1:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Import of Masters - Customers Suppliers &
Parts



> Our Epicor Consultant told us that using ODBC to update records would
> invalidate our support agreement. Is everyone else just willing to
> take that risk, or was our consultant exaggerating?

I would not take the risk. There are posts on this list where database
corruption occurred even when Epicor did the work using the Pervasive
tool.

And database corruption has become a quite popular retort while speaking
to
support these days... So me personally, I wouldn't do it.

I used the Business Objects directly but using Service connect and web
services would work too.

IMHO,

Mark W.






[Non-text portions of this message have been removed]
18
--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> > Our Epicor Consultant told us that using ODBC to update records
would
> > invalidate our support agreement. Is everyone else just willing to
> > take that risk, or was our consultant exaggerating?
>
> I would not take the risk. There are posts on this list where
database
> corruption occurred even when Epicor did the work using the
Pervasive tool.
>
> And database corruption has become a quite popular retort while
speaking to
> support these days... So me personally, I wouldn't do it.
>
> I used the Business Objects directly but using Service connect and
web
> services would work too.
>
> IMHO,
>
> Mark W.
>


Does Service Connect allow record update and delete or just new
addition? Also I was wondering if the table corruption would be due
to the ODBC connection or the fact that the user may not know all of
the tables that are affected by the import.


Thanks

Kersten M
19
Service connect does have a delete method for each web service. Basically,
if you can do it in Vantage you can do it with Service Connect since almost
all of the Vantage business objects and methods are exposed to Service
Connect.



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
kam4085
Sent: Monday, April 07, 2008 2:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Import of Masters - Customers Suppliers & Parts



--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Mark
Wonsil" <mark_wonsil@...> wrote:
>
> > Our Epicor Consultant told us that using ODBC to update records
would
> > invalidate our support agreement. Is everyone else just willing to
> > take that risk, or was our consultant exaggerating?
>
> I would not take the risk. There are posts on this list where
database
> corruption occurred even when Epicor did the work using the
Pervasive tool.
>
> And database corruption has become a quite popular retort while
speaking to
> support these days... So me personally, I wouldn't do it.
>
> I used the Business Objects directly but using Service connect and
web
> services would work too.
>
> IMHO,
>
> Mark W.
>

Does Service Connect allow record update and delete or just new
addition? Also I was wondering if the table corruption would be due
to the ODBC connection or the fact that the user may not know all of
the tables that are affected by the import.


Thanks

Kersten M





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