devbisme / KiPart

Python package for generating multi-unit schematic symbols for KiCad from a CSV file.
MIT License
174 stars 46 forks source link

_csv.Error: new-line character seen in unquoted field #34

Closed bullitbd closed 6 years ago

bullitbd commented 6 years ago

getting _csv.Error: new-line character seen in unquoted field - do you need to open the file in universal-newline mode? osx 10.11, Office (Excel) for Mac 2011., Python 2.7; attempted saving as Mac, Windows, MS-DOS format as many variously have suggested. Hand-built the file in text editor - there are, of course newlines (\n)... get same error.

Here is file: `Atlas EZO

Pin,Unit,Type,Name,Side 1,1,gnd,GND,top 2,1,out,TX,top 3,1,in,RX,top 4,1,pwr,VCC,bottom 5,1,in,P+,bottom 6,1,in,P-,bottom

`

bullitbd commented 6 years ago

this was caused by a blank line at the end of the file... as the instructions suggested.

leoheck commented 6 years ago

Is it possible to ignore blank lines? Sometimes it is good to have empty lines to organize things.

Another thing, is it possible to create a command for comments? Maybe # at the beginning of the line to ignore the whole line will be a good thing.

Also, I generally use text editor to do things instead of spreadsheets (they are easier to be fast) And I like to keep comments inside the file to organize things.

bullitbd commented 6 years ago

the spreadsheet point is well taken... really no need to use one.