export list of books in a csv file

[jcarlier]

hi

i would like to export my list of books in a csv file but ..
in the options of fields , i cannot choose the order of the fields exported

i would like to have isbn,title,authors and not authors,isbn,title

How can i solve that problem ??

Many thanks for your support

J carlier
Brussels

[itimpi]

Easiest thing would be to load the CSV file created into a spreadsheet program (e.g. Excel), arrange the columns to the order you want, and then save the results.

[jcarlier]

First thanks for your answer BUT..

i take the output of export ('mes livres.csv' see 'mes livres.rar' attached)

i make a new xsl file (classeur1.xlsx) and import 'mes livres.csv'

i arrange xsl file : permutation of columns ( see classeur1.rar)

how can i produce the same layout as 'mes livres.csv' from 'classeur1.xls' for importing in collectorz ???

thanks for your answer

[doctorow]

Originally Posted by jcarlier

hi

i would like to export my list of books in a csv file but ..
in the options of fields , i cannot choose the order of the fields exported

i would like to have isbn,title,authors and not authors,isbn,title

There are various ways to control the order of exported catalogs; unfortunately there's none that would fit your needs.

--sort-by
Output field to sort on. Available fields: author_sort, id, rating, size, timestamp, title_sort Default: ‘id’ Applies to: CSV, XML output formats

link

If you're using Linux or OSX, some quick and dirty sed or awk to swap the columns of the output file could do the trick.

[theducks]

Originally Posted by jcarlier

First thanks for your answer BUT..

i take the output of export ('mes livres.csv' see 'mes livres.rar' attached)

i make a new xsl file (classeur1.xlsx) and import 'mes livres.csv'

i arrange xsl file : permutation of columns ( see classeur1.rar)

how can i produce the same layout as 'mes livres.csv' from 'classeur1.xls' for importing in collectorz ???

thanks for your answer

All I did was move column C to before column A
In Libre Office calc:
I 'Cut' The column C (done on the header, takes the whole column)
I inserted a new column before the existing A
I then Pasted into the New A Header

Save and or Export as CSV
Matches 'mes livres.csv' (Author ISBN Title)

[jcarlier]

Thanks

I have not libre office calc. Nor linux..

I am using ms excel under win 7.

Can you transform my classeur1.xls into csv in the same layout that. Meslivres.csv ?...


Thanks

[itimpi]

With Excel just arrange the columns into the order you want and then tell Excel to save the file as a CSV file.

[theducks]

Originally Posted by jcarlier

Thanks

I have not libre office calc. Nor linux..

I am using ms excel under win 7.

Can you transform my classeur1.xls into csv in the same layout that. Meslivres.csv ?...


Thanks

What does Linux have to do with anything?

[DoctorOhh]

Originally Posted by jcarlier

I have not libre office calc. Nor linux..

I am using ms excel under win 7.

It is probably best to follow itimpi's advice, but Libre Office calc or MS Excel, six of one half a dozen of the other. Essentially no difference for something like this.

Additionally Libre Office is free and runs on Windows 7.