Mass upload to a table (PartPlant)

Yahoo Archive
1
Ideally, update by a SC workflow.

If not practical, it should be safe to update these values into partplant via an ODBC SQL write.

Rob




________________________________
From: "justjim@..." <justjim@...>
To: vantage@yahoogroups.com
Sent: Monday, May 11, 2009 9:25:20 PM
Subject: [Vantage] Mass upload to a table (PartPlant)





The company that I consult to is implementing a barcoded inventory solution and wants to set the Minimum and Maximum stock quantities based on an average monthly usage.

I can deliver a spreadsheet from a BAQ from PartPlant (joined to Part and Vendor) to show average monthly usage (as well as Minimum and Maximum quantities for each part), by vendor, by plant.

When the General Manager decides what the new Min and Max levels should be, how can I upload these figures to Vantage?

It's not like a price list where you can 'import'.

[Vantage 8.03.406]

Jim Campbell
Database Consultant







[Non-text portions of this message have been removed]
2
The company that I consult to is implementing a barcoded inventory solution and wants to set the Minimum and Maximum stock quantities based on an average monthly usage.

I can deliver a spreadsheet from a BAQ from PartPlant (joined to Part and Vendor) to show average monthly usage (as well as Minimum and Maximum quantities for each part), by vendor, by plant.

When the General Manager decides what the new Min and Max levels should be, how can I upload these figures to Vantage?

It's not like a price list where you can 'import'.

[Vantage 8.03.406]

Jim Campbell
Database Consultant
3
Sevice connect is your answer.
Or Epicor custom program group.

That said, you could first run a comparision of which records you need to update.
Then create a BAQ with a QUICK SEARCH that will only retrieve supplier "A" parts. (have it prompt you for Supplier ID)
Retreive all of those parts, and start keying away.
Then to a retrieve the next supplier.

If you have a few thousand records, it may take a few hours, but if you don't have Service connect and you don't want to spend the program costs for the custom group, it will be a great learning experience for someone.

Bruce
www.ERPgeek.com
bruce@...

--- In vantage@yahoogroups.com, "justjim@..." <justjim@...> wrote:
>
> The company that I consult to is implementing a barcoded inventory solution and wants to set the Minimum and Maximum stock quantities based on an average monthly usage.
>
> I can deliver a spreadsheet from a BAQ from PartPlant (joined to Part and Vendor) to show average monthly usage (as well as Minimum and Maximum quantities for each part), by vendor, by plant.
>
> When the General Manager decides what the new Min and Max levels should be, how can I upload these figures to Vantage?
>
> It's not like a price list where you can 'import'.
>
> [Vantage 8.03.406]
>
> Jim Campbell
> Database Consultant
>
4
Jim, I'm assuming they are NOT SQL customers?

Service Connect is an option but I'd bet you have no experience on creating workflows like most of us.

Custom Solutions Group could do it but you have to ship off your database to them and it'll cost about $1000 and a day of downtime unless you pay an additional premium for weekend imports.

As Bruce mentioned, sometimes manual input is less expensive then the costs and risks associated with import. I've hired a team of 10 people before from a local temp agency for two days and each averaged about 500 records per day and I had just under 10K records to update. That cost me about $1500 for the labor.

Lastly, and most risky, is the potential to use ODBC. You can update Progress recordsets via ODBC using Access or even Excel. It can be slow and it can be risky, but nevertheless it still remains as an option.

So I guess the $1M question is, how many records are you talking about?



Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email:Â Â vic.drecchio@...
Mobile:Â 704.530.3092
Office:Â 336.668.4410 x3159


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of justjim@...
Sent: Monday, May 11, 2009 9:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Mass upload to a table (PartPlant)

The company that I consult to is implementing a barcoded inventory solution and wants to set the Minimum and Maximum stock quantities based on an average monthly usage.

I can deliver a spreadsheet from a BAQ from PartPlant (joined to Part and Vendor) to show average monthly usage (as well as Minimum and Maximum quantities for each part), by vendor, by plant.

When the General Manager decides what the new Min and Max levels should be, how can I upload these figures to Vantage?

It's not like a price list where you can 'import'.

[Vantage 8.03.406]

Jim Campbell
Database Consultant



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

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/linksYahoo! Groups Links
5
We are SQL and we just did the same thing using an update statement reading the values from the spreadsheet directly into Vantage.
Worked slick!

Thanks
Patty Buechler

--- In vantage@yahoogroups.com, "brz_larson" <bl_larson@...> wrote:
>
> Sevice connect is your answer.
> Or Epicor custom program group.
>
> That said, you could first run a comparision of which records you need to update.
> Then create a BAQ with a QUICK SEARCH that will only retrieve supplier "A" parts. (have it prompt you for Supplier ID)
> Retreive all of those parts, and start keying away.
> Then to a retrieve the next supplier.
>
> If you have a few thousand records, it may take a few hours, but if you don't have Service connect and you don't want to spend the program costs for the custom group, it will be a great learning experience for someone.
>
> Bruce
> www.ERPgeek.com
> bruce@...
>
> --- In vantage@yahoogroups.com, "justjim@" <justjim@> wrote:
> >
> > The company that I consult to is implementing a barcoded inventory solution and wants to set the Minimum and Maximum stock quantities based on an average monthly usage.
> >
> > I can deliver a spreadsheet from a BAQ from PartPlant (joined to Part and Vendor) to show average monthly usage (as well as Minimum and Maximum quantities for each part), by vendor, by plant.
> >
> > When the General Manager decides what the new Min and Max levels should be, how can I upload these figures to Vantage?
> >
> > It's not like a price list where you can 'import'.
> >
> > [Vantage 8.03.406]
> >
> > Jim Campbell
> > Database Consultant
> >
>
6
Only problem with writing direct to the table, versus thru the application,is you could open yourself for a corrupt database.
I have used a "macro" program to do mouse clicks, etc. to update records in my past, but it is much slower than a quick table write.

Bruce

--- In vantage@yahoogroups.com, "bpbuechler" <pbuechler@...> wrote:
>
> We are SQL and we just did the same thing using an update statement reading the values from the spreadsheet directly into Vantage.
> Worked slick!
>
> Thanks
> Patty Buechler
>
> --- In vantage@yahoogroups.com, "brz_larson" <bl_larson@> wrote:
> >
> > Sevice connect is your answer.
> > Or Epicor custom program group.
> >
> > That said, you could first run a comparision of which records you need to update.
> > Then create a BAQ with a QUICK SEARCH that will only retrieve supplier "A" parts. (have it prompt you for Supplier ID)
> > Retreive all of those parts, and start keying away.
> > Then to a retrieve the next supplier.
> >
> > If you have a few thousand records, it may take a few hours, but if you don't have Service connect and you don't want to spend the program costs for the custom group, it will be a great learning experience for someone.
> >
> > Bruce
> > www.ERPgeek.com
> > bruce@
> >
> > --- In vantage@yahoogroups.com, "justjim@" <justjim@> wrote:
> > >
> > > The company that I consult to is implementing a barcoded inventory solution and wants to set the Minimum and Maximum stock quantities based on an average monthly usage.
> > >
> > > I can deliver a spreadsheet from a BAQ from PartPlant (joined to Part and Vendor) to show average monthly usage (as well as Minimum and Maximum quantities for each part), by vendor, by plant.
> > >
> > > When the General Manager decides what the new Min and Max levels should be, how can I upload these figures to Vantage?
> > >
> > > It's not like a price list where you can 'import'.
> > >
> > > [Vantage 8.03.406]
> > >
> > > Jim Campbell
> > > Database Consultant
> > >
> >
>