Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

enable excel type export of csv #17

Open
macsimski opened this issue Jan 30, 2017 · 6 comments
Open

enable excel type export of csv #17

macsimski opened this issue Jan 30, 2017 · 6 comments

Comments

@macsimski
Copy link

My fab house is soly windowz based and they have problems importing csv files from Bombs-away. Do you think it is possible to export the cv with tabs as field delimiter, quoted text and a comma and space between the multiple parts on a row

so something like
"R101, R102, R103"\tab"100K"\tab"sweeb:0603R"\tab"3"\tab"Multicomp"\tab" etc.

As the source of Bombs-away does not have a copyright header with version number, i cannot include a version number, but I downloaded it today 30-01-2017

changing
with open(base+ext, 'w') as csvfile: wrt = csv.writer(csvfile)
on row 546
to
with open(base+ext, 'w') as csvfile: wrt = csv.writer(csvfile,dialect='excel')

did not give a change.
Unfortunately, i'm not that fluent in python. :(

@macsimski
Copy link
Author

ok. nice one. tab separated is possible with

with open(base+ext, 'w') as csvfile: wrt = csv.writer(csvfile,dialect='excel-tab')

not excel_tab as stated in the docs. read those docs really carefull. semicolon between the individual parts with the same parttype is not solved, but a simple search and replace can do it.

@Jeff-Ciesielski
Copy link
Owner

Jeff-Ciesielski commented Oct 28, 2017

So I took a quick crack at this and I'm not convinced that I want to tie all these features into the main source code since it's pretty specific to your board house.

Looking at #24 (which is also pretty specific), I'm thinking what might be a better fit is an export plugin system (which hilariously is what this was intended to replace in KiCad itself), but at least these plugins could be in the form of a python module.

I'll take a crack at it and will see what I can come up with. Out of curiosity, what board house do you use (so that I might name the export plugin)?

@macsimski
Copy link
Author

Cool. if you want me tor try things, just say so. My board house is electro-watt in Hilversum, the netherlands, But i think that it is not that inportant as the dialect='excel-tab' works fine here. :-)

@Jeff-Ciesielski
Copy link
Owner

Give this a go: d57404c (Should be the tip of the master branch).

@macsimski
Copy link
Author

hmm. ImportError: No module named 'wx'

I'm looking into this as i have /usr/lib/python2.7/dist-packages/wx-3.0-gtk2 installed

@Jeff-Ciesielski
Copy link
Owner

Project was recently updated to Python3

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants