Export doesn't contain all fields
DiscussionsTalk about LibraryThing
Rejoignez LibraryThing pour poster.
1CCNHOELibrary
Notably, Genre is missing, I'd really like that one to be included, otherwise I have to duplicate that in Tags
2Foretopman
Genre is in the JSON export.
Frustratingly, there are things that are in some versions of export, but not in others.
In the JSON export, but not in excel or tsv:
ASIN
EAN
Genre
Review Language
UPC
Volumes
Other Call Number System is not in excel or tsv, I don't know if it's in JSON
Not in any export:
Genre (detailed)
LC Classification Wording
Lexile Measure
Number of tags
Inventory Status
Price
Secondary Language
Swap Sites
I don't claim that this list is complete or correct
Frustratingly, there are things that are in some versions of export, but not in others.
In the JSON export, but not in excel or tsv:
ASIN
EAN
Genre
Review Language
UPC
Volumes
Other Call Number System is not in excel or tsv, I don't know if it's in JSON
Not in any export:
Genre (detailed)
LC Classification Wording
Lexile Measure
Number of tags
Inventory Status
Price
Secondary Language
Swap Sites
I don't claim that this list is complete or correct
3thepuck
Yes, it would be great if Volumes was added to excel export, so I can calculate my total number of CDs, as I am closing to 10,000.
4bnielsen
>2 Foretopman: with a bit of pain (i.e. a script) you can add the fields from the json export to your spreadsheet (i.e. TSV or Excel).
Genre in the JSON export seems to be a bit different than what you see in the LT web catalogue. And you get both a Genre Id and a Genre, like 3805 Politics, Government, Law and Public Policy.
I'm not quite sure what you mean by Genre (detailed).
Awards and Series information is also in the JSON export. Here's an example.
{
"books_id": "227204201",
"awards": {{
"Lost Man Booker Prize"
}},
"reviewlang": "Danish",
"series": {{
"Inspektor Wexford",
"Wexford",
"Ylikomisario Wexford",
"Inspector Wexford",
"Inspector Wexford Mysteries"
}},
"volumes": "1"
}
Square brackets mess up the display here, so I've changed them to {{ and }} here.
Genre in the JSON export seems to be a bit different than what you see in the LT web catalogue. And you get both a Genre Id and a Genre, like 3805 Politics, Government, Law and Public Policy.
I'm not quite sure what you mean by Genre (detailed).
Awards and Series information is also in the JSON export. Here's an example.
{
"books_id": "227204201",
"awards": {{
"Lost Man Booker Prize"
}},
"reviewlang": "Danish",
"series": {{
"Inspektor Wexford",
"Wexford",
"Ylikomisario Wexford",
"Inspector Wexford",
"Inspector Wexford Mysteries"
}},
"volumes": "1"
}
Square brackets mess up the display here, so I've changed them to {{ and }} here.
5bnielsen
I think this is the complete list of fields in the JSON export:
asin
authors
awards
barcode
bcid
books_id
callnumber
circulation
code
collections
collections_idA
comment
copies
date
dateacquired
dateread
datestarted
ddc
dimensions
ean
entrydate
fl
format
fromwhere
genre
genre_id
height
isbn
language
language_codeA
lcc
lccn
length
lf
oclc
originalisbn
originallanguage
originallanguage_codeA
originaltitle
pages
physical_description
primaryauthor
primaryauthorrole
privatecomment
public
publication
rating
review
reviewlang
role
secondaryauthor
secondaryauthorroles
series
sortcharacter
source
subject
summary
tagidA
tags
text
thickness
title
upc
volumes
weight
wording
workcode
asin
authors
awards
barcode
bcid
books_id
callnumber
circulation
code
collections
collections_idA
comment
copies
date
dateacquired
dateread
datestarted
ddc
dimensions
ean
entrydate
fl
format
fromwhere
genre
genre_id
height
isbn
language
language_codeA
lcc
lccn
length
lf
oclc
originalisbn
originallanguage
originallanguage_codeA
originaltitle
pages
physical_description
primaryauthor
primaryauthorrole
privatecomment
public
publication
rating
review
reviewlang
role
secondaryauthor
secondaryauthorroles
series
sortcharacter
source
subject
summary
tagidA
tags
text
thickness
title
upc
volumes
weight
wording
workcode
6bnielsen
>2 Foretopman: and >4 bnielsen: Ahh, I realised that Genre (detailed) came from the list of columns you can add to your styles.
It is _almost_ the same as what you get in the JSON export. But some genres are missing. I.e. Europe on a shoestring by Tom Masters (2011) is shown as having the Genre: Travel, but Travel is missing in the JSON export of that book.
Weird.
ETA: the missing genre was an LT bug that has been fixed.
Awards, Genres, Series look like they contain useful stuff.
It is _almost_ the same as what you get in the JSON export. But some genres are missing. I.e. Europe on a shoestring by Tom Masters (2011) is shown as having the Genre: Travel, but Travel is missing in the JSON export of that book.
Weird.
ETA: the missing genre was an LT bug that has been fixed.
Awards, Genres, Series look like they contain useful stuff.
7thepuck
Indeed, JSON export contains the number of volumes for each entry. Then, I really wonder why this information is not included
in the Excel export. It would be very helpful !!
in the Excel export. It would be very helpful !!
8bnielsen
>7 thepuck: Yes! I have a script that merges the two exports and also reports oddities like unbalanced parentheses. Most of the oddities are my own errors, so they are quickly fixed, but I have a couple of records where the source is given as "Gemeinsamer Bibliotheksverbund (GBV".