BOM file --- text ?

well on second look a csv file is a text file. (can't remember this shit) --- this is what I have -------

• Partlist from file: FN2.lay6" / 3/26/2021 1:03:15 PM

*

• All coordinates in mil

*

• No Name Value Layer Pos-X Pos-Y Rot Package Comment

* 1 D1 1N4148 Top 624.95 1206.25 90 SOD123 NOTE POLARITY ON DRAWING ! 2 D2 1N4148 Top 624.95 1118.75 90 SOD123 NOTE POLARITY 3 IC1 ICS-308-T Top 993.75 1143.75 90 8 pin dip (any will suffice) 4 R1 10000 Top 1474.90 1081.25 90 0805 5 R2 10000 Top 1474.90 1206.25 90 0805

If the fields are constant-width, it's easy to write a script to add commas.

Cheers

Phil Hobbs

It has spaces between that don't show here. put in commas?

fredag den 26. marts 2021 kl. 20.16.48 UTC+1 skrev mkr5000:

what do you have? you will have to make a .csv, .xls or .xlsx file in the format they require

you'll have to massage that to make a BOM file with designators and LCSC partnumbers and CPL file with with designators, coordinates, and rotations

Use any text editor to replace every space with a comma. Then, replace all double commas with a single comma. Lather, rinse repeat.

Manually fixup the comments field (if that's important to you) to replace the commas, there, with spaces.

If the "wide spaces" are, in fact, tabs, then replace tab with comma. As above.

[smarter editors can do this in one step]

Ok thanks. The newest problem -- using ZOHO to create a spreadsheet for BOM. CAN'T do the first zero in 0805 -- it deletes it. No obvious fix.

F (%*)&^(^_(*&^_(^)(_%)_%*%*^&%$(&*$(&$(&$( ing hell.

add quotes?

That did it. Will the pcb houses take it that way? Is the BOM file something they just read manually?

on JLCPCB you upload the gerbers, the BOM, and the CPL file and you get a list of components recognised, the price and if in stock etc. and you can search for alternatives. You then get a preview of the pcb with components so you can verify rotation and placement

why don't you just try it? you have to eventually, no one here can order it for you ...

Every spread sheet program I've ever used would import such a text file with a bit of guidance from you. The note after the package is pretty much ignored by the assembler, but you should be able to get that into the spread sheet as well even with the spaces.

Use a real spread sheet program like Libreoffice and flag the column as text, preserving all chars.

Looking at line 3 compared to the others it seem you have a tab-delimited file,

They may* be able to handle that if not replace the tabs with commas (or load it into a spreadsheet and save as xls.)

(*) CSV is intepreted variously as comma or character separated values it depends who you ask, and tab is a character.

In this ZOHO it has the option to format cells. I changed the package cell to text so I could write 0805 without it dropping the first zero. Everything else was written before I knew of that option as ---

"General" "No specific format will be applied". It all looks fine -- hopefully I don't need to go back and change all the cells to text? Was just having a problem with the 0805.

That would be the obvious choice. (Excel is crap at dealing with text files, csv files, and the like. It has poor options, and half of them require you to change your Windows settings to work.)

An alternative would be a quick Python program:

#!/usr/bin/python import sys

try : fname_in = sys.argv[1] fname_out = sys.argv[2] except : print("Bad parameters") sys.exit(1)

data_in = open(fname_in, "r").readlines() file_out = open(fname_out, "w") for data in data_in : if not data.startswith("*") : file_out.write(",".join(data.strip().split()[:8]) + "\r\n") file_out.close()

David Brown snipped-for-privacy@hesbynett.no wrote in news:s3nnp4$lof$ snipped-for-privacy@dont-email.me:

It works fine for those actually using it instead of dissing it after years of not using it.

Python is great, but more difficult to use for the average PC user. Excel works and much better than you declare for csv and text files and the parsing thereof.

Johann Klammer snipped-for-privacy@NOSPAM.a.net> wrote in news:s3lfo8$1k8j$ snipped-for-privacy@gioia.aioe.org:

Since one is not performing math functions on part size nomenclature, just format the cell as text and it will keep all the characters you use in the cell. D'Oh!

I've used Excel, and I've used LibreOffice. There is no doubt that for some things - including handling csv and tsv files - LibreOffice is very much better.

(Another aspect where LibreOffice beats MS Office hands down is in international environments, but that is something that many people don't see. However, if you live in a country that has a "decimal comma", good luck using Excel for anything csv related!)

Sure, it is a programming language, not a spreadsheet program. It is not a tool for everyone. But then, nor is a electronics CAD program.

As long as you are within the limits of what Excel can handle, it will do fine. But its limits are much more restrictive than those of LibreOffice.