search

replaysMike / Binner

Open source parts inventory system for makers, electronics hobby, and professional engineers
https://binner.io
GNU General Public License v3.0
261 stars 41 forks source link

BOM import #273

Open shaun-leach opened 2 months ago

shaun-leach commented 2 months ago

Add support for importing BOMs via CSV and excel.

Curious if this is something you're interested in and if so, would love your input on this as I'm a hacker at times when it comes to stuff like this. ;) Also I want to clean up the import code to reduce the amount of duplicated code between the CSV and excel importers.

replaysMike commented 2 months ago

Hi Sean - absolutely interested in this. It's been on my todo list for a while :)

I'll review the code and see if we can get to an approval by Monday. Cheers!

shaun-leach commented 2 months ago

Excellent!

Let me know any changes you'd like.

RoyalGamerTV commented 1 month ago

Hello Jean, I am testing your pull request right now and it does not work for me. I tried to import a KiCad BOM and there was a error. Could you maybe send me a example BOM that works to upload? Thank you

shaun-leach commented 1 month ago

ContinuitySMT.csv

Ah yes that would help. I'm using the new BOM support in KiCAD 8 and then I added MPN for the manufacturer part number.

I want to make it more robust to support other styles but this was a 1st pass.

RoyalGamerTV commented 1 month ago

Hi Shaun,

Thank you for your quick reply. I successfully imported your BOM. I had an idea for supporting multiple BOM formats: When you upload your BOM, it would display the contents of each column. Above each column, there could be a button to select the type of information it contains. If there are columns with data that aren't useful for the Binner, you could simply select "skip," and the program would ignore that column. This approach would allow for the upload of various types of BOMs. I got the idea from DigiKey, where you can upload BOMs into your basket and specify the type of information for each column.

Best regards, max

shaun-leach commented 1 month ago

Yeah that's my eventual goal but it's beyond my javascript hacking skills atm. :D Plus I'm trying not to do too much yak shaving so I started with this as this is all I need for the moment. lol.

Shaun

On Fri, Aug 2, 2024 at 1:52 AM RoyalGamerTV @.***> wrote:

Hi Shaun,

Thank you for your quick reply. I successfully imported your BOM. I had an idea for supporting multiple BOM formats: When you upload your BOM, it would display the contents of each column. Above each column, there could be a button to select the type of information it contains. If there are columns with data that aren't useful for the Binner, you could simply select "skip," and the program would ignore that column. This approach would allow for the upload of various types of BOMs. I got the idea from DigiKey, where you can upload BOMs into your basket and specify the type of information for each column.

Best regards, max

— Reply to this email directly, view it on GitHub https://github.com/replaysMike/Binner/pull/273#issuecomment-2264893389, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABLXJ22QFUN5TLQWGMQCWKTZPNCFXAVCNFSM6AAAAABKDSXWP2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENRUHA4TGMZYHE . You are receiving this because you authored the thread.Message ID: @.***>

replaysMike commented 1 month ago

@shaun-leach once the conflicts are resolved I can merge this if all of your changes are complete