Part import Blank Title 69842

system · October 17, 2008, 9:10am

Yes Brian, importing BOM's is tricky, and the work-flow is convoluted...

We cheat we just download BOM's from our old system into Excel, and then use
paste/insert into the BOM data grid after the parts are loaded into the
MPF... OK, you have to check that parent part out manually, but it works
fine for us...

Thanks,

Nick

From: Brian W. Spolarich [mailto:bspolarich@...]
Sent: 17 October 2008 13:46
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part import

We've used the same set of templates and workflows for data import
with Service Connect. They work very well and I would recommend the
investment if you're planning on importing lots of different kinds of
data. The standard package includes CostQty (standards and inventory
values), CustBillTo, CustCnt (contacts), Customer, Part, PartMtl (BOM),
PartOpr (routings), PartRev, ShipTo, Vendor, and VendorPP (purchase
point).

Creating a ServiceConnect workflow to take a CSV file and call
Part.Update(-) is actually pretty straightforward, and is one of the
textbook examples in the ServiceConnect training (which I thought was
quite good). So if you really only need to add Parts, you could do that
yourself. But if you also need to import BOMs I would seriously
consider investing in the template package as that workflow is decidedly
more complex.

And as Nick points out, developing against the Web Services API that
Service Connect uses is very much a matter of trial and error.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@advanced <mailto:bspolarich%40advancedphotonix.com>
-photonix.-com ~ 734-864-5618 ~
www.advancedphotoni-x.com

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> -.com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> -.com] On
Behalf
Of vantage
Sent: Friday, October 17, 2008 8:18 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> -.com
Subject: RE: [Vantage] Part import

Did you have to purchase the standard template?

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

This email and its attachments may be confidential and are intended solely
for the use of the individual to whom it is addressed. Any views or
opinions expressed are solely those of the author and do not necessarily
represent those of Kingfield Electronics Ltd. If you are not the intended
recipient of this email and its attachments, you must take no action based
upon them, nor must you copy or show them to anyone. Please contact the
sender if you believe you have received this email in error.
Kingfield Electronics Ltd., Carrwood House, Carrwood Road, Chesterfield
Trading Estate, Chesterfield S41 9QB, United Kingdom. Place of
registration: England. Company registered number: 1893903. Telephone:
+44-(0)1246-451701.

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

system · October 17, 2008, 3:02am

Hello,

V8.03
I know that if I want to import parts there is payable solution from Epicor and do it by my self.
Has anyone done part import yourself? What solution did you used? Import data to Progress database through MS SQL or directly to Progress? Also IÂ heard that is possible to this with Service connect, had anyone tried this?

Thanks,
Tom

Send instant messages to your online friends http://uk.messenger.yahoo.com

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

system · October 17, 2008, 3:32am

Hi Tom,

Yes, we use ServiceConnect all the time, and importing parts is no great
problem...

Epicor provide a standard template to do this, or, when you start learning
how to write ServiceConnect routines, you can begin writing your own...

ServiceConnect is a powerful tool, but there is a steep and frustrating
learning curve due to poor documentation...

We don't use any other method for data imports...

I hope this helps...

Thanks,

Nick

_____

From: tomas paulavicius [mailto:tpaulavicius@...]
Sent: 17 October 2008 08:02
To: vantage@yahoogroups.com
Subject: [Vantage] Part import

Hello,

V8.03
I know that if I want to import parts there is payable solution from Epicor
and do it by my self.
Has anyone done part import yourself? What solution did you used? Import
data to Progress database through MS SQL or directly to Progress? Also I
heard that is possible to this with Service connect, had anyone tried this?

Thanks,
Tom

Send instant messages to your online friends http://uk.messenger
<http://uk.messenger.yahoo.com> -.yahoo.com

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

This email and its attachments may be confidential and are intended solely
for the use of the individual to whom it is addressed. Any views or
opinions expressed are solely those of the author and do not necessarily
represent those of Kingfield Electronics Ltd. If you are not the intended
recipient of this email and its attachments, you must take no action based
upon them, nor must you copy or show them to anyone. Please contact the
sender if you believe you have received this email in error.
Kingfield Electronics Ltd., Carrwood House, Carrwood Road, Chesterfield
Trading Estate, Chesterfield S41 9QB, United Kingdom. Place of
registration: England. Company registered number: 1893903. Telephone:
+44-(0)1246-451701.

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

system · October 17, 2008, 8:17am

Did you have to purchase the standard template?

Steve

-----Original Message-----
From: Nick Taylor [mailto:n.taylor@...]
Sent: October 17, 2008 2:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part import

Hi Tom,

Yes, we use ServiceConnect all the time, and importing parts is no great
problem...

Epicor provide a standard template to do this, or, when you start learning
how to write ServiceConnect routines, you can begin writing your own...

ServiceConnect is a powerful tool, but there is a steep and frustrating
learning curve due to poor documentation...

We don't use any other method for data imports...

I hope this helps...

Thanks,

Nick

_____

From: tomas paulavicius [mailto:tpaulavicius@
<mailto:tpaulavicius%40yahoo.co.uk> yahoo.co.uk]
Sent: 17 October 2008 08:02
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Part import

Hello,

V8.03
I know that if I want to import parts there is payable solution from Epicor
and do it by my self.
Has anyone done part import yourself? What solution did you used? Import
data to Progress database through MS SQL or directly to Progress? Also I
heard that is possible to this with Service connect, had anyone tried this?

Thanks,
Tom

Send instant messages to your online friends http://uk.messenger
<http://uk.messenger <http://uk.messenger.yahoo.com> .yahoo.com> -.yahoo.com

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

This email and its attachments may be confidential and are intended solely
for the use of the individual to whom it is addressed. Any views or
opinions expressed are solely those of the author and do not necessarily
represent those of Kingfield Electronics Ltd. If you are not the intended
recipient of this email and its attachments, you must take no action based
upon them, nor must you copy or show them to anyone. Please contact the
sender if you believe you have received this email in error.
Kingfield Electronics Ltd., Carrwood House, Carrwood Road, Chesterfield
Trading Estate, Chesterfield S41 9QB, United Kingdom. Place of
registration: England. Company registered number: 1893903. Telephone:
+44-(0)1246-451701.

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

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

system · October 17, 2008, 8:33am

> V8.03
> I know that if I want to import parts there is payable solution from
> Epicor and do it by my self.
> Has anyone done part import yourself? What solution did you used? Import
> data to Progress database through MS SQL or directly to Progress? Also I
> heard that is possible to this with Service connect, had anyone tried
> this?

It is also possible using VB.Net and accessing the business objects
directly.

Mark W.

system · October 17, 2008, 8:46am

We've used the same set of templates and workflows for data import
with Service Connect. They work very well and I would recommend the
investment if you're planning on importing lots of different kinds of
data. The standard package includes CostQty (standards and inventory
values), CustBillTo, CustCnt (contacts), Customer, Part, PartMtl (BOM),
PartOpr (routings), PartRev, ShipTo, Vendor, and VendorPP (purchase
point).

Creating a ServiceConnect workflow to take a CSV file and call
Part.Update() is actually pretty straightforward, and is one of the
textbook examples in the ServiceConnect training (which I thought was
quite good). So if you really only need to add Parts, you could do that
yourself. But if you also need to import BOMs I would seriously
consider investing in the template package as that workflow is decidedly
more complex.

And as Nick points out, developing against the Web Services API that
Service Connect uses is very much a matter of trial and error.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of vantage
Sent: Friday, October 17, 2008 8:18 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part import

Did you have to purchase the standard template?

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

system · October 17, 2008, 9:06am

No, you get a few basic templates when you buy ServiceConnect Steve...

You will get one for each ServiceConnect routine that Epicor give you as
Standard.

Its not many and they are mainly associated with data take-on.

Thanks,

Nick

_____

From: vantage [mailto:vantage@...]
Sent: 17 October 2008 13:18
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part import

Did you have to purchase the standard template?

Steve

-----Original Message-----
From: Nick Taylor [mailto:n.taylor@kingfield-
<mailto:n.taylor%40kingfield-electronics.co.uk> -electronics.-co.uk]
Sent: October 17, 2008 2:32 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> -.com
Subject: RE: [Vantage] Part import

Hi Tom,

Yes, we use ServiceConnect all the time, and importing parts is no great
problem...

Epicor provide a standard template to do this, or, when you start learning
how to write ServiceConnect routines, you can begin writing your own...

ServiceConnect is a powerful tool, but there is a steep and frustrating
learning curve due to poor documentation.-..

We don't use any other method for data imports...

I hope this helps...

Thanks,

Nick

_____

From: tomas paulavicius [mailto:tpaulaviciu-s@
<mailto:tpaulaviciu-s%40yahoo.-co.uk> yahoo.co.uk]
Sent: 17 October 2008 08:02
To: vantage@yahoogroups <mailto:vantage%-40yahoogroups.-com> .com
Subject: [Vantage] Part import

Hello,

V8.03
I know that if I want to import parts there is payable solution from Epicor
and do it by my self.
Has anyone done part import yourself? What solution did you used? Import
data to Progress database through MS SQL or directly to Progress? Also I
heard that is possible to this with Service connect, had anyone tried this?

Thanks,
Tom

Send instant messages to your online friends http://uk.messenger
<http://uk.messenger>
<http://uk.messenger <http://uk.messenger> <http://uk.messenger
<http://uk.messenger.yahoo.com> -.yahoo.com> .yahoo.com> -.yahoo.com

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

This email and its attachments may be confidential and are intended solely
for the use of the individual to whom it is addressed. Any views or
opinions expressed are solely those of the author and do not necessarily
represent those of Kingfield Electronics Ltd. If you are not the intended
recipient of this email and its attachments, you must take no action based
upon them, nor must you copy or show them to anyone. Please contact the
sender if you believe you have received this email in error.
Kingfield Electronics Ltd., Carrwood House, Carrwood Road, Chesterfield
Trading Estate, Chesterfield S41 9QB, United Kingdom. Place of
registration: England. Company registered number: 1893903. Telephone:
+44-(0)1246--451701.

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

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

This email and its attachments may be confidential and are intended solely
for the use of the individual to whom it is addressed. Any views or
opinions expressed are solely those of the author and do not necessarily
represent those of Kingfield Electronics Ltd. If you are not the intended
recipient of this email and its attachments, you must take no action based
upon them, nor must you copy or show them to anyone. Please contact the
sender if you believe you have received this email in error.
Kingfield Electronics Ltd., Carrwood House, Carrwood Road, Chesterfield
Trading Estate, Chesterfield S41 9QB, United Kingdom. Place of
registration: England. Company registered number: 1893903. Telephone:
+44-(0)1246-451701.

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