V8.03 Mass Create New Parts

Yahoo Archive
1
Short of service connect or open edge SQL record adds, get yourself a free copy of AutoHotKey (a good desktop macro tool) & (carefully!) punch them in via copy/paste from excel into Part Entry. (I think you could do a direct read from a csv file as well but I haven't had the need to try that yet.)

600 parts (under your careful watch of macro executing) would take about 2 hours - but at least you won't need wrist splints for carpal tunnel when done.

Â



________________________________
From: Ari Footlik <ari@...>
To: vantage@yahoogroups.com
Sent: Friday, July 10, 2009 8:26:22 AM
Subject: [Vantage] v8.03 Mass Create New Parts





I'm going to be provided with a spreadsheet of approximately 600+ parts
for which we need to create new part-numbers in Vantage. The list I'll
receive will include descriptions, and we can also add class, group,
category, etc... for each of the parts listed on the spreadsheet.

Does anyone have a process by which I easily get that entire list
imported into the Vantage Part Master table without having to make 600+
parts using manual entry?

Thanks.
--Ari

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




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]
2
I'm going to be provided with a spreadsheet of approximately 600+ parts
for which we need to create new part-numbers in Vantage. The list I'll
receive will include descriptions, and we can also add class, group,
category, etc... for each of the parts listed on the spreadsheet.

Does anyone have a process by which I easily get that entire list
imported into the Vantage Part Master table without having to make 600+
parts using manual entry?

Thanks.
--Ari


[Non-text portions of this message have been removed]
3
I actually had to do this myself and I used .NET and Vantage webServices to parse through the excel file of parts.

Here's a sample of my function that I wrote in .NET to load the parts.
public void LoadParts()
{
PartServiceWse proxy = new PartServiceWse();
UsernameOverTransportAssertion userNameAssertion = new UsernameOverTransportAssertion();
userNameAssertion.UsernameTokenProvider = new UsernameTokenProvider("manager", "proman");
Policy policy = new Policy();
policy.Assertions.Add(userNameAssertion);
proxy.SetPolicy(policy);
List<string[]> parsedData = parseCSV(@"C:\InkPartsList.csv");

foreach (string[] s in parsedData)
{

PartDataSetType arType = new PartDataSetType();
PartDataSetType arType4 = new PartDataSetType();
PartDataSetTypePart arType2 = new PartDataSetTypePart();
PartDataSetTypePartPlant arType3 = new PartDataSetTypePartPlant();

arType = proxy.GetNewPart("GP", null);
arType2 = (PartDataSetTypePart)arType.PartDataSet.GetValue(0);

arType2.PartNum = s[0].ToString().ToUpper().Trim();
arType2.PartDescription = s[1].ToString().Trim();
arType2.TypeCode = s[2].ToString().Trim();
arType2.ClassID = s[3].ToString().Trim();
arType2.UnitPrice = Convert.ToDecimal(s[4].ToString().Trim());
arType2.ExpenseDisplayAccount = s[5].ToString().Trim();
arType2.CostMethod = s[6].ToString().Trim();
arType2.QtyBearing = false;
// arType2.CountryNumDescription = "United States of America";

proxy.Update("GP", arType);

arType4 = proxy.GetByID("GP", arType2.PartNum);
arType3 = (PartDataSetTypePartPlant)arType4.PartDataSet.GetValue(1);
arType3.VendorNumVendorID = s[7].ToString().Trim();

proxy.Update("GP", arType4);
}//end foreach

}//end LoadParts

Epicor also provides a data conversion template, which I have not seen yet, but I beleive it cost some $$ about 1-2K.

I would receommend using the webservices if you want to save yourself some money.


--- In vantage@yahoogroups.com, "Ari Footlik" <ari@...> wrote:
>
> I'm going to be provided with a spreadsheet of approximately 600+ parts
> for which we need to create new part-numbers in Vantage. The list I'll
> receive will include descriptions, and we can also add class, group,
> category, etc... for each of the parts listed on the spreadsheet.
>
> Does anyone have a process by which I easily get that entire list
> imported into the Vantage Part Master table without having to make 600+
> parts using manual entry?
>
> Thanks.
> --Ari
>
>
> [Non-text portions of this message have been removed]
>