[Alexandria-list] Importing data

[Cathal Mc Ginley]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sun, 5 Sep 2010 22:30:06 +0200
Putr <amonmail at gmail.com> wrote:

> I'm just interested would it be posible to parse the .xls
> file and add the books by title into alexandria.

Use OpenOffice.org or similar to export into CSV format. You should
mimic the layout of the Goodreads or LibraryThing CSV export, and then
use "Import ... *.csv" in Alexandria. The CSV import in Alexandria
decides which layout to use based on the column headers.

The Goodreads CSV file uses these column headers:

"Title"
"Author"
"Additional Authors"
"ISBN" 
"Publisher"
"Year Published"
"Binding"

  ... and optionally ...

"Private Notes"
"My Rating"
"Read Count"

The LibraryThing CSV file uses these column headers:

"'TITLE'"
"'AUTHOR (first, last'"
"'ISBN'"
"'PUBLICATION INFO'"
"'DATE'"

  ... and optionally ...

"'COMMENTS'"
"'RATING'"
"'TAGS'"

Hope this helps,

   -   Cathal.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: GnuPT 2.6.2.1 by EQUIPMENTE.DE

iEYEARECAAYFAkyEIroACgkQfMAUnRdb+8qmgwCgt0uu0a8obxPzjXNGuWEDnJEz
TNMAnivT4CbP6ihSXwHnxWKbp0wyQRpF
=HR/T
-----END PGP SIGNATURE-----