Skip to content

Title List Upload Format

Ian Ibbotson edited this page Sep 24, 2016 · 4 revisions

File Format

The system expectes a tab separated file, preferably encoded using UTF-8 file encoding

Columns

The columns of the tab separated file (TSV) need to be

Column Header Mandatory? Description
1 list.name Mandatory Your name for this list e.g. Aspire Export, High Use Print, History of Art Wish List
2 title.identifier.type Mandatory example: title.identifier.isbn, needs at least 1, type should be lowercase. Examples include title.identifier.doi, title.identifier.ybp, title.identifier.aspireTitleId
3 title.title Optional If provided title will be used to create a record if we don't have one. No title + no matching identifier = row ignored
4 title.publisher Optional used to enhance record if we don't know the publisher already
5 title.primary_author Optional NOT title.author - which is confusing in multi author scenarios
6 title.publication_year Optional used if we don't already have a publication year

Sample File

"list.name"     "title.identifier"      "title.title"   "title.publisher"       "title.primary_author"  "title.publication_year"
"Biosciences#1" 0071780033      "Ganong's review of medical physiology."        "McGraw-Hill"   "Barrett, K.E. and Ganong, W.F."        2012
"II Test 1"     0099455641      "Have the men had enough?."     "Vintage"       "Forster, M."   2004
"Biosciences#1" 0113222777      "Drug misuse and dependence: guidelines on clinical management."        "The Stationery Office" "Dept of Health"        1999
"II Test 2"     0117033944      "Concepts of rehabilitation for the management of common health problems"       "TSO"   "Waddell, G."   2004
"Physical Computing #1" "9783527620043" "Sensors Update 2"
"II Test 2"     "9783527620043" "Sensors Update 2"
"II Test 1"     "9783527620043" "Sensors Update 2"
"II Test 1"     "978-0-8155-1409-1"     "Biotechnology for Waste and Wastewater Treatment"