ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Importing BOMs
http://www.istechforum.com/YaBB.pl?num=1182885558

Message started by David Waldmann on 06/26/07 at 12:19:17

Title: Importing BOMs
Post by David Waldmann on 06/26/07 at 12:19:17

I know that the way Date Import normally works is that all BOMs imported are ADDED to any that already exist. I'm wondering if there's a workaround similar to the one for importing new pieces of Item data (replace the temporary data with the live data, import just the part(s) you want, then copy the temp files to the live ones).

Or any other ideas for making a lot of BOM changes without having to manually change them all?

Title: Re: Importing BOMs
Post by Lynn_Pantic on 06/26/07 at 12:34:16

The BOM is tricky because components will be added to existing BOMs even if you copy the files and do the other tricks that have been suggested for ither files such as Inventory. If you are making a LOT of changes, I suggest exporting the BKBMMSTR file, clean up the file in Excel, then Initialize the BKBMMSTR file to delete all BOMs and then import back in the new data to the temporary file, run an error report and then transfer.

Title: Re: Importing BOMs
Post by David Waldmann on 06/26/07 at 14:07:17

Yes, I have thousands....

I'll take a look at doing it that way. I think it will work.

Thanks!

Title: Re: Importing BOMs
Post by rmh148 on 06/27/07 at 13:34:06

I have been using an SQL insert to load thousand of new BOM dynamically. I use VB to read excel or access data and create an GetBOM.sql files that I open and run in pervasive.

This is a sample of one I just ran.

INSERT INTO "BKBMMSTR" ("BKBM_PARENT", "BKBM_PROD_LINE^", "BKBM_COMPONENT", "BKBM_QTY_REQD", "BKBM_PROD_TYPE", "BKBM_PROD_SCRAP", "BKBM_PROD_OP", "BKBM_PROD_PRICE") VALUES ('207-2226-001/2',5,'FIT221V-1/4-0',0.2,'R',5,' 0',0)#
INSERT INTO "BKBMMSTR" ("BKBM_PARENT", "BKBM_PROD_LINE^", "BKBM_COMPONENT", "BKBM_QTY_REQD", "BKBM_PROD_TYPE", "BKBM_PROD_SCRAP", "BKBM_PROD_OP", "BKBM_PROD_PRICE") VALUES ('207-2226-001/2',6,'0431164281',1,'R',5,' 0',0)#
INSERT INTO "BKBMMSTR" ("BKBM_PARENT", "BKBM_PROD_LINE^", "BKBM_COMPONENT", "BKBM_QTY_REQD", "BKBM_PROD_TYPE", "BKBM_PROD_SCRAP", "BKBM_PROD_OP", "BKBM_PROD_PRICE") VALUES ('207-2226-001/2',7,'WIT-18SF',1,'R',5,' 0',0)#
INSERT INTO "BKBMMSTR" ("BKBM_PARENT", "BKBM_PROD_LINE^", "BKBM_COMPONENT", "BKBM_QTY_REQD", "BKBM_PROD_TYPE", "BKBM_PROD_SCRAP", "BKBM_PROD_OP", "BKBM_PROD_PRICE") VALUES ('207-2226-001/2',8,'50-57-9011',1,'R',0,' 0',0)#
INSERT INTO "BKBMMSTR" ("BKBM_PARENT", "BKBM_PROD_LINE^", "BKBM_COMPONENT", "BKBM_QTY_REQD", "BKBM_PROD_TYPE", "BKBM_PROD_SCRAP", "BKBM_PROD_OP", "BKBM_PROD_PRICE") VALUES ('207-2226-001/2',9,'16-02-0087',14,'R',0,' 0',0)#
INSERT INTO "BKBMMSTR" ("BKBM_PARENT", "BKBM_PROD_LINE^", "BKBM_COMPONENT", "BKBM_QTY_REQD", "BKBM_PROD_TYPE", "BKBM_PROD_SCRAP", "BKBM_PROD_OP", "BKBM_PROD_PRICE") VALUES ('207-2226-001/2',10,'641994-1',1,'R',10,' 0',0)#

Title: Re: Importing BOMs
Post by Lynn_Pantic on 06/27/07 at 16:09:48

That is fine if you are appending to existing data but I think David needs to actually edit existing boms, not add new ones. The Data Import program already exists to accomplish what you are doing and does some validation of part numbers and such in the process.

Title: Re: Importing BOMs
Post by David Waldmann on 06/28/07 at 05:49:11

Lynn_Pantic wrote:

The Data Import program already exists to accomplish what you are doing and does some validation of part numbers and such in the process.

Speaking of validation, I find it strange that the import program does not allow 0 quantities, but you can enter 0 in BM-A.

I have two reasons for 0 on BOMs. We use routings only for costing/estimating, and a LABOR item only for recording. So we don't want a LABOR amount on the BOM or it will be added to the cost, but we want the LABOR Item on the BOM so that we have a place ready to record it.

The other reason is for substitute/alternate parts. We have the normal part with normal quantity, but want the sub/alt part listed so we know what it is and have a place to record it on the traveler if used.

So I usually just put in .00000001. So far we haven't done an order that is affected by that number....

Title: Re: Importing BOMs
Post by David Waldmann on 07/02/07 at 07:14:37

Lynn_Pantic wrote:

I suggest exporting the BKBMMSTR file, clean up the file in Excel, then Initialize the BKBMMSTR file to delete all BOMs and then import back in the new data to the temporary file, run an error report and then transfer.

This worked EXCELLENTLY!!!!

Thanks!!!!