Reverse insert BOM to CatiaV5
Reverse insert BOM to CatiaV5
(OP)
Hello All!
I was wondering if there was a way to...
1) Export a Bill Of Materials from catia
2) Realized something was wrong and fix everything in excel
3) Reverse insert the properties back into Catia
Im sorry in advance if I sound like a master of the obvious (because it would be plastered on every forum already) if it cannot be done! LOL
I was wondering if there was a way to...
1) Export a Bill Of Materials from catia
2) Realized something was wrong and fix everything in excel
3) Reverse insert the properties back into Catia
Im sorry in advance if I sound like a master of the obvious (because it would be plastered on every forum already) if it cannot be done! LOL





RE: Reverse insert BOM to CatiaV5
If it's the former, just use a script (do a search) to export the table. Modify it in Excel. Then use the function in CATIA to import a csv file as a table into a drawing.
Drew Mumaw
www.textsketcher.com
www.drewmumaw.com
RE: Reverse insert BOM to CatiaV5
RE: Reverse insert BOM to CatiaV5
Export a BOM, fill out all blank/missing/or wrong properties then force back into Catia part/Product. It would be much easier in my mind, faster too!
RE: Reverse insert BOM to CatiaV5
RE: Reverse insert BOM to CatiaV5
RE: Reverse insert BOM to CatiaV5
It can be done, but you have to establish an exact order of how properties will be first exported, then imported back.
I suppose also it will take a little time to create those two macros (I believe there will be two, first one to export properties, then update the file manually, then second macro to import properties).
Regards
Fernando
https://picasaweb.google.com/102257836106335725208 - Romania
https://picasaweb.google.com/103462806772634246699... - EU
RE: Reverse insert BOM to CatiaV5
If my rambling makes any sense lol
RE: Reverse insert BOM to CatiaV5
Regards
Fernando
https://picasaweb.google.com/102257836106335725208 - Romania
https://picasaweb.google.com/103462806772634246699... - EU
RE: Reverse insert BOM to CatiaV5
If you filter the selection list, in the Design Table definition dialog, by the 'User Parameters' filter it will give you a listing of those. You can then add them to a design table. Once added to the design table, you could modify them directly through Excel, update the model to the default configuration to push the data, then delete the design table from the assembly.
The Excel sheet certainly wouldn't be formatted like a BOM table, but it also doesn't require the development time of a scripted solution.
--Doug
RE: Reverse insert BOM to CatiaV5
Thanks Doug you are awesome!!!!!!!!!!!!!!!!!
RE: Reverse insert BOM to CatiaV5
Regards
Fernando
https://picasaweb.google.com/102257836106335725208 - Romania
https://picasaweb.google.com/103462806772634246699... - EU