BOM separator problem

[roboya]

Hello!
I just tried to generate a BOM. I used the simplest method, described by Rene in a FAQ. Basically it works, but the csv format is screwed up. All the commas are replaced with semicolons, and the BOM looks like this. All the items are in column A. I used a text editor and replaced all the semi colons, and it’s fixed. See second picture.
Is there a way to configure the separator as a comma?

Thanks,

Pascal

[qu1ck]

You can configure your spreadsheet software to recognize another character as separator instead.

[nhatkhai]

Or you can try my scripts:

XLST potential become a issue for very large design?

I just finish the script for my work. This is another way of doing CSV BOM <==> SCH (both direction): bom2csv script: Is use to run from eeschma Generate Bill of Material/command line tool, it just all most the same with supplied one, but some special recognized fields in the order I wanted. $ bom2csv.py Usage bom2csv.py <generic_netlist.xml> <output.csv> bom2sch script: Run on command line tool, should take any csv output files from supplied eeschema BOM scripts (full or partial) and bac…

Use the .exe file in KiCad as same way as .py files.

[Rene_Poschl]

It should not really matter which separator the file uses. You can configure it on import to excel or calc.

You did not state which bom generator script you used. Maybe there is a better one already included with kicad. (Or you might need one of the more powerful tools developed by the community.)

More info on how to use the bom generation stuff plus a list of a few scripts: How to create a bill of materials (BOM)?

[nhatkhai]

I found bom_csv_* plugins are work great, other can cause issue to excel to open correctly.

[der.ule]

I have exactly the opposite problem, excel recognizes a CSV file with a “;” separator, but if the separator is a “,” then gives me the result that you show.

I have 3 workarounds for this problem, the first one is to open the file an add the following line to the top of the line “sep=;” without the quotes, when excel tries to open the file it will use the “;” automatically as the separator.

The second approach is to change the file extension from CSV to TXT, this way, when you try to open the file in excel, the import dialog will be shown, where you can select the appropriate separator for the file.

Third approach is to edit the python script that generates this file to change the default separator from “;” to “,”.

I hope this helps you.

[nhatkhai]

The provided python script default to “,”. He must use difference script, I would think.

[roboya]

Hello!
Thanks for your replies. I didn’t know I could configure csv files. I thought it was “comma separated values” or something like that, and that it had to be a comma.
Pascal