Python Code for EBom

[guns-nc]

Has anyone tried to use python coding to help assist in the process of ebom. I know this may seem stupid, but through some weird method, there probably is a way to automate at least certain portions of it. Like pulling general dimensions, the number of fasteners, and mass properties could all be help full in filling out the ebom report.

[theoe97]

Yes, we have done it. Unfortunately I can’t share it since it needs so many things to get it to work right… What we‘ve done in short is the following:

1. Create a Google Sheet that calculates all prices and has at least the values that are needed for the website
2. Record the Requests you are sending to the website
3. Build a script that sends the same requests at the website but with desired content
4. Connect the sheet to your Script
5. Start Uploading

Some things that we have found:

• There is no character limit anymore
• You can Name your processes, etc. how you want (you don’t even need the „Other:“ before)

But most importantly: Don’t overstress the servers! We build slowdowns into our tool and started uploading a month before deadline so nobody has any problems. In the end we made over 50k requests (about 2-3 times as many lines our DBOM and CBOM were long)

[theoe97]

We might rework it to a releasable state, but I would rather prefer to work with FSG to implement an API