Welcome, Guest. Please Login.
05/16/25 at 15:33:54
News:
Home Help Search Login


Pages: 1
Send Topic Print
Importing BOMs (Read 948 times)
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Importing BOMs
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?
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Importing BOMs
Reply #1 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Importing BOMs
Reply #2 - 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!
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
rmh148
Member
**




Posts: 84
Re: Importing BOMs
Reply #3 - 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)#
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Importing BOMs
Reply #4 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Importing BOMs
Reply #5 - 06/28/07 at 05:49:11
 
Quote from Lynn_Pantic on 06/27/07 at 16:09:48:
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....
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Importing BOMs
Reply #6 - 07/02/07 at 07:14:37
 
Quote from Lynn_Pantic on 06/26/07 at 12:34:16:
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!!!!
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Pages: 1
Send Topic Print