Use with sch, pcb or csv?

[Andrewdwork]

Hi. I am a bit confused - nothing new there.

I am running win7 64 bit and most things seem to work.

I have read somewhere in these pages that the project is now Python3 so I have installed PYTHON 3.6 and its associated wxPython, and sqlalchemy.
I have a number of KiCad files with bom and sch files in there. I generally have used the BOM export from pcbNew as it seemed easier to work with. I then back annotated to the sch which hopefully embedded the details from the CvPcb file back into the sch file.

When I run BOMS-away the first thing I see is a message in the cmd window:
C:\Bomsaway\bomsaway.py:371: wxPyDeprecationWarning: Call to deprecated item. Use Append instead.
Next line is: file.AppendItem(quit)

know very little about Python, but editing the bomsaway.py script and adding a return above line 371 changes the message above to bomsaway.py:372, so I assume that the script warning I am seeing is because there is no file selected to add at that time.

Is there any way to combine the data I have (laboriously) entered into an excel file into the parts datastore, either by exporting that as a CSV or within Kicad?

I can export an excel file as CSV or html.

Is it possible to enter the CSV data direct into BOMS-away?

Any help would be appreciated.

[macsimski]

afaik there is no such thing and it is qute undoable as there is no standard form to make the spreadsheet. I fill in the datastore as i go alonge. when i start, i have to look up the spreadsheet a lot, but as time goes on, it becomes less frequent. now it is only occasional that i have to search for a part, but in the mean time, the info is sometimes obsolete as parts got obsolete or are not made anymore