Part master Blank Title 60818

Yahoo Archive
1
> I'm curious how one handles company/plant selection when using the
> BOs. The web services wrappers and their DataSets include ways to
> specify the company.
>
> I created some references in VS2008 to the necessary objects and can
> see their properties. Just wasn't sure how to close the loop on
> company selection in particular.
>
> The UI and Web Services wrappers make the selected company seem like
> an essential part of the session setup, but maybe that just an illusion?

Being single company and single plant, I just made sure that my Company and
Plant fields were set appropriately in my datasets. Hmm. Time to play in the
Training database...

Mark W.
2
Hello,
I am new to the forum and to Epicor. I am trying to find a way to copy
files from excel to the part masters.I would greatly appreciate
anyones help.

Thanks,
3
Hopefully I'm wrong, but as far as I understand there is no way to do
this aside from paying Epicor to do a data migration.

We had this problem when we moved to Epicor, we wanted our parts
database from our old system and we were told the only way to do this
was to pay for data migration. Unlike many other places in the system,
there is no grid form with a paste insert/paste update option available
with Part Master.

Ken

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mccarter817
Sent: Wednesday, November 21, 2007 12:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] part master



Hello,
I am new to the forum and to Epicor. I am trying to find a way to copy
files from excel to the part masters.I would greatly appreciate
anyones help.

Thanks,






[Non-text portions of this message have been removed]
4
For 8.x Service Connect is supposed to be an option for this. It would be a trade off on the cost and learning curve versus the cost to pay for a migration. But in the end you might have a useful tool for other tables.

Another old stand-by option has been to use a scripted keyboard emulation program (ala GroundControl) to merge spreadsheet rows with simulated key-entry and move the data in via the regular interface.

-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Williams
Sent: Wednesday, November 21, 2007 1:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] part master


Hopefully I'm wrong, but as far as I understand there is no way to do
this aside from paying Epicor to do a data migration.

We had this problem when we moved to Epicor, we wanted our parts
database from our old system and we were told the only way to do this
was to pay for data migration. Unlike many other places in the system,
there is no grid form with a paste insert/paste update option available
with Part Master.

Ken

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of mccarter817
Sent: Wednesday, November 21, 2007 12:04 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] part master

Hello,
I am new to the forum and to Epicor. I am trying to find a way to copy
files from excel to the part masters.I would greatly appreciate
anyones help.

Thanks,

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





[Non-text portions of this message have been removed]
5
Depending on the quantity of parts, the sciprted keyboard emulation
could work great. We use Autohotkey for this type of work quite often.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Wednesday, November 21, 2007 12:15 PM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] part master



For 8.x Service Connect is supposed to be an option for this. It would
be a trade off on the cost and learning curve versus the cost to pay for
a migration. But in the end you might have a useful tool for other
tables.

Another old stand-by option has been to use a scripted keyboard
emulation program (ala GroundControl) to merge spreadsheet rows with
simulated key-entry and move the data in via the regular interface.

-Todd C.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Ken Williams
Sent: Wednesday, November 21, 2007 1:12 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] part master

Hopefully I'm wrong, but as far as I understand there is no way to do
this aside from paying Epicor to do a data migration.

We had this problem when we moved to Epicor, we wanted our parts
database from our old system and we were told the only way to do this
was to pay for data migration. Unlike many other places in the system,
there is no grid form with a paste insert/paste update option available
with Part Master.

Ken

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of mccarter817
Sent: Wednesday, November 21, 2007 12:04 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] part master

Hello,
I am new to the forum and to Epicor. I am trying to find a way to copy
files from excel to the part masters.I would greatly appreciate
anyones help.

Thanks,

[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]
6
> I am new to the forum and to Epicor. I am trying to find a way to copy
> files from excel to the part masters.I would greatly appreciate
> anyones help.

We loaded our parts from an Access database using VB.Net. It is NOT as fast as
a migration tool! It uses the Vantage Business Objects so all rules are
enforced. The code looks somewhat like this:

Try
objSess = New Epicor.Mfg.Core.Session("manager", "manager",
"AppServerDC://<VANTAGE SERVER>:8321",
Epicor.Mfg.Core.Session.LicenseType.Default)
' Create an object handle
objPart = New Epicor.Mfg.BO.Part(objSess.ConnectionPool)
' Create a part Dataset
dsPart = New Epicor.Mfg.BO.PartDataSet
Catch ex As Exception
Call MsgBox(ex.Message, MsgBoxStyle.OKOnly, "Error")
Application.Exit()
End Try

Try
' For each record in the ODBC source
While rdr.Read()
strPart = rdr("partnum")
' See if part exists
If Not objPart.PartExists(strPart) Then
objPart.GetNewPart(dsPart)
' Assign your fields
dsPart.Part.Item(0).PartNum = rdr("partnum")
strDescription = rdr("partdescription")
dsPart.Part.Item(0).PartDescription = strDescription
dsPart.Part.Item(0).SearchWord =
strDescription.Substring(0, 8)
dsPart.Part.Item(0).ClassID = rdr("classid"))
dsPart.Part.Item(0).TypeCode = rdr("typecode")
dsPart.Part.Item(0).NonStock = rdr("nonstock")
dsPart.Part.Item(0).PhantomBOM = rdr("phantombom")
dsPart.Part.Item(0).IUM = rdr("uom")
dsPart.Part.Item(0).PUM = rdr("uom")
dsPart.Part.Item(0).PurchasingFactor = 1.0
dsPart.Part.Item(0).PricePerCode = "E"
...
dsPart.Part.Item(0).CostMethod = "S"
' Update part
objPart.Update(dsPart)
' Clear the object for next part
dsPart.Clear()
else
' Put in some logic to update parts if you wish
End If
End While

Catch ex As Exception
Call MsgBox(strPart & ": " & ex.Message, MsgBoxStyle.OKOnly,
"Error Adding Part")
End Try

objSess.Close()
rdr.Close()


You can add plant code data etc. as well.

Mark W.
7
Paste/Insert is a dog for more than a few dozen records (although performance has supposedly improved on 8.03.403c).

Epicor isn't being honest with you. If you have the in-house IT skill, legacy data (almost all of it - not just Part master) can be exported via SQL to access (or a sql server db). There are scripted templates available from vantage to import the legacy data into vantage.

The tricky part is 'translating' the legacy data structure to suit the vantage required data structures (either or both of which might be multi-joined table views).

If you don't honestly feel you have the inhouse IT skilled resources, pay vantage to do it.

Rob Brown


Ken Williams <ken@...> wrote:
Hopefully I'm wrong, but as far as I understand there is no way to do
this aside from paying Epicor to do a data migration.

We had this problem when we moved to Epicor, we wanted our parts
database from our old system and we were told the only way to do this
was to pay for data migration. Unlike many other places in the system,
there is no grid form with a paste insert/paste update option available
with Part Master.

Ken

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mccarter817
Sent: Wednesday, November 21, 2007 12:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] part master

Hello,
I am new to the forum and to Epicor. I am trying to find a way to copy
files from excel to the part masters.I would greatly appreciate
anyones help.

Thanks,

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






---------------------------------
Get easy, one-click access to your favorites. Make Yahoo! your homepage.

[Non-text portions of this message have been removed]
8
Hey Mark, I was looking in the archives for this thread after some
discussion today on talking directly to the BOs.

I'm curious how one handles company/plant selection when using the
BOs. The web services wrappers and their DataSets include ways to
specify the company.

I created some references in VS2008 to the necessary objects and can
see their properties. Just wasn't sure how to close the loop on
company selection in particular.

The UI and Web Services wrappers make the selected company seem like
an essential part of the session setup, but maybe that just an illusion?

-bws

--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:

> We loaded our parts from an Access database using VB.Net. It is NOT
as fast as
> a migration tool! It uses the Vantage Business Objects so all rules are
> enforced. The code looks somewhat like this:
>
> Try
> objSess = New Epicor.Mfg.Core.Session("manager", "manager",
> "AppServerDC://<VANTAGE SERVER>:8321",
> Epicor.Mfg.Core.Session.LicenseType.Default)
> ' Create an object handle
> objPart = New Epicor.Mfg.BO.Part(objSess.ConnectionPool)
> ' Create a part Dataset
> dsPart = New Epicor.Mfg.BO.PartDataSet
> Catch ex As Exception
> Call MsgBox(ex.Message, MsgBoxStyle.OKOnly, "Error")
> Application.Exit()
> End Try