Contents of the Excel file for bulk ingest into DISpace

Author: Marylène Poelaert (Université Libre de Bruxelles – Libraries – RDIB)

Contributors:

B. Pauwels (Université Libre de Bruxelles – Libraries – RDIB)

V. Delannay (Université Libre de Bruxelles – Libraries – BECS)

C. Bulté (Université Libre de Bruxelles – Libraries – BECS)

Date / Version
15/03/2006 / 1.0 / Initial document

This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.0 Belgium License. To view a copy of this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/be/ or send a letter to Creative Commons, 543 Howard Street, 5th Floor, San Francisco, California, 94105, USA.

Remarks:

-  “Contents”: implicit |a at start of field

-  No validation of data is done upon upload of Excel file into DISpace; data should be soon entered into DISpace as given in the Excel file

-  The elements in blue are mandatory.


1. BOOK

TO DO edition

Column / Field name / Contents (with subfields) / Repeatable[1] / Comments / Example / QDC field
1 / Unique offline item ID / $collectionname-[0-9]{4} / N / $collectionname: is the name of the offline collection as known by the DSpace system
This unique ID must always stay linked to the publication title. This identifier is composed of the author initials, followed by a number on four characters. / mc-0012 / identifier.other
2 / title / maintitle|bsubtitle / N / Le champagne|bUne étude sur les bulles. / title
3 / author / authorlastname, authorfirstname|=uniqueid / Y / authorlastname and authorfirstname should be separated by a comma.
Put a point after an abbreviated authorfirstname.
It's preferable to enter the full authorfirstname (not the abbreviated one).
Composed authorfirstname: J.-C. / Devroey, J.-P.|=123456 ; Lefèvre, V. ; Hellemans, Jacques / creator
4 / type[2] / Possible values:
Monographie ou partie de monographie|bMonographie|cOuvrage à titre de seul auteur
Monographie ou partie de monographie|bMonographie|cOuvrage en collaboration
Monographie ou partie de monographie|bDirection d’ouvrage
Monographie ou partie de monographie|bTraduction / N / To be applied also to :
·  published dissertations (Monographie ou partie de monographie|bMonographie|cOuvrage à titre de seul auteur)
·  special issues of serials (Monographie ou partie de monographie|bDirection d’ouvrage) / type
7 / publisher / publishername|cpublisherlocation / Y / Multiple locations should be separated by commas.
Indicate only the most accurate location (for example if you know the name of the town don't set the country)
Set the publisher name as given by the author. Don't try to unify it. / Elsevier|cNew York, Paris, Amsterdam
Elsevier|cAmsterdam ; Springer|cBerlin
Utrecht (and not Utrecht, The Netherlands) / publisher
8 / publicationstatus (year, month, day) / YYYY-MM-DD / N / Encode as ISO 8601 YYYY-MM-DD[3] / 2004
2004-10-30 / date.issued
9 / numberofpages / numberofpages / N / If monograph in multiple volumes, indicate the number of volumes and their number of pages / 206 [number only]
2 vol., 159 et 148 p. [text] / format.extent
10 / partofseries / seriesname|vseriesnumber / N / Que sais-je?|v251
CEB|v18/2003 / relation.ispartofseries
11 / alternativetitle / maintitle|bsubtitle / N / Indicate ‘Translation of:’ in front of the original title / Translation of: Champagne|ba study on the bubbles / title.alternative
14 / identifiers / idtype : id
id = {ISBN | " " | other} / Y / ISBN with or without hyphen / Example 1 ISBN : 2246670810
Example 2 ISBN : 2545612312
; other : 12345682 / identifier.*idtype
16 / language / { | en_US | en | es | de | fr | it | ja | zh | other } / N / fr / language.iso
17 / keywords / keywords / Y / economics ; politics / subject.other
18 / publication status(pubstatus) / {ULB2BPUB | ULBPUB } / N / This field aims to know the publication status of the reference indicated by the author in his CV.
Following the publication type, you will have to set there the following mention: ULB4PUB (submitted for publication), ULB2BPUB (to be published), ULBPUB (published) or ULBNPUB (not published). ULB2BPUB = To be published
ULBPUB = Published
Default: ULBPUB / ULBPUB / date.issued|t
subject.local|b
20 / themes / List of 20 Bologna themes / Y / List available at http://www.cfwb.be/ciuf/information/decretbol.pdf p.13. / Langues et lettres / subject.classification
25 / abstract / abstract / Y / abcde / description.abstract
26 / otherdescription / otherdescription / Y / abcde / description.other
27 / objfilemetadata / Defaults:
description: "Full text"
security: ULBINTERNET
version: ULBPOSTPRINT
If different values are wanted then specify as follows:
unique_offl_itemid:description|ssecuritylevel|vversion
securitylevel = { ULBINTERNET | ULBINTRANET | ULBINVISIBLE }
version = {ULBPREPRINT | ULBPOSTPRINT | ULBPUBPRINT} / Y / Description describes the content of the object file (table of contents, full text, images…).
Security describes the access restrictions for the object file (open for Internet, limited to Intranet,..).
Version describes the version of the loaded object file (ULBPREPRINT = author's version ; ULBPOSTPRINT = version accepted for publication ; ULBPUBPRINT = published version). / Examples:
mc0001:|sULBINTRANET
mc0001a:Table of Contents|sULBINTERNET ; mc0001b:Text of thesis|sULBINTRANET


2. BOOKITEM

Column / Field name / Contents (with subfields) / Repeatable[4] / Comments / Example / QDC field
1 / Unique offline item ID / $collectionname-[0-9]{4} / N / $collectionname: is the name of the offline collection as known by the DSpace system / mc-0012 / identifier.other
2 / title / maintitle|bsubtitle / N / Le champagne|bUne étude sur les bulles. / title
3 / author / authorlastname, authorfirstname|=uniqueid / Y / authorlastname and authorfirstname should be separated by a comma.
Put a point after an abbreviated authorfirstname.
It's preferable to enter the full authorfirstname (not the abbreviated one).
Composed authorfirstname: J.-C. / Devroey, J.-P.|=123456 ; Lefèvre, V. ; Hellemans, Jacques / creator
4 / type[5] / Monographie ou partie de monographie|bPartie d'ouvrage collectif / N / type
8 / publicationstatus
(year, month, day) / YYYY-MM-DD / N / Encode as ISO 8601 YYYY-MM-DD[6] / 2004 / date.issued
15 / bibcitation / maintitle|bsubtitle|hauthors|upublisher|cplace|vvolume|ppages|wcollection|icollectionnumber|sisbn / N / Follow the same rules as mentioned above for a BOOK : see title(2), author(3), publisher(7), partofseries(10) and identifier(14).
Authors: delete the editors mentions (ed or eds) because the software will differentiate this one with the name of the person cited alone.
Pages: set the page numbers separated with an hyphen, without mention of "p." or "pages"… (example : 133-156).
If several publishers and/or several publishing places, keep only the first one indicated. / European Universities|bChange and Convergence?|hDewatripont, Mathias ; Thys-Clément, Françoise ; Wilkin, Luc |uEditions de l'Université de Bruxelles|cBruxelles |d2002|s2-8004-1281-X / identifier.citation
16 / language / { | en_US | en | es | de | fr | it | ja | zh | other } / N / fr / language.iso
17 / keywords / keywords / Y / economics ; politics / subject.other
18 / publication status(pubstatus) / {ULB2BPUB | ULBPUB } / N / ULB2BPUB = To be published
ULBPUB = Published
Default: ULBPUB / ULBPUB / date.issued|t
subject.local|b
20 / themes / List of 20 Bologna themes / Y / List available at http://www.cfwb.be/ciuf/information/decretbol.pdf p.13. / Langues et lettres / subject.classification
25 / abstract / abstract / Y / abcde / description.abstract
26 / otherdescription / otherdescription / Y / description.other
27 / objfilemetadata / Defaults:
description: "Full text"
security: ULBINTERNET
version: ULBPOSTPRINT
If different values are wanted then specify as follows:
unique_offl_itemid:description|ssecuritylevel|vversion
securitylevel = { ULBINTERNET | ULBINTRANET | ULBINVISIBLE }
version = {ULBPREPRINT | ULBPOSTPRINT | ULBPUBPRINT} / Y / Description describes the content of the object file (table of contents, full text, images…).
Security describes the access restrictions for the object file (open for Internet, limited to Intranet,..).
Version describes the version of the loaded object file (ULBPREPRINT = author's version ; ULBPOSTPRINT = version accepted for publication ; ULBPUBPRINT = published version). / Examples:
mc0001:|sULBINTRANET
mc0001a:Table of Contents|sULBINTERNET ; mc0001b:Text of thesis|sULBINTRANET


3. ARTICLE

Column / Field name / Contents (with subfields) / Repeatable[7] / Comments / Example / QDC field
1 / Unique offline item ID / $collectionname-[0-9]{4} / N / $collectionname: is the name of the offline collection as known by the DSpace system / mc-0012 / identifier.other
2 / title / maintitle|bsubtitle / N / Le champagne|bUne étude sur les bulles. / title
3 / author / authorlastname, authorfirstname|=uniqueid / Y / authorlastname and authorfirstname should be separated by a comma.
Put a point after an abbreviated authorfirstname.
It's preferable to enter the full authorfirstname (not the abbreviated one).
Composed authorfirstname: J.-C. / Devroey, J.-P.|=123456 ; Lefèvre, V. ; Hellemans, Jacques / creator
4 / type[8] / Possible values:
Article|bArticle dans une revue|cAvec comité de lecture
Article|bArticle dans une revue|cSans comité de lecture
Article|bCompte-rendu / N / Review can be considered as a special form of article whose title contains the whole bibliographic reference of the reviewed publication (set in |bsubtitle). / type
8 / publicationstatus
(year, month, day) / YYYY-MM-DD / N / Encode as ISO 8601 YYYY-MM-DD[9] / 2004 / date.issued
14 / identifiers / idtype : id
id = {" " | DOI | PMID | bibcode | SICI | other } / Y / This identifier aims to identify the article itself. The journal identifier (ISSN) is put in bibcitation. / DOI : 0123456789 ;
PMID : 16502502 / identifier.*idtype
15 / bibcitation / journaltitle|vvolume|iissue|ppages|sISSN / N / Follow the same rules as these mentioned above about a BOOK for identifier(14).
If the publication is submitted for publication or to be published, set the journal title only.
If you encounter a temporal mention as winter or first trimester (generally in the reference of a serial), you set it in the subfields i. Example: Acta psychologica|d2004|v45|iWinter|p125-136. / Brussels Economic Review|v46|i3|d2003|p5-9|s0008-0195 / identifier.citation
16 / language / { | en_US | en | es | de | fr | it | ja | zh | other } / N / fr / language.iso
17 / keywords / keywords / Y / economics ; politics / subject.other
18 / publication status(pubstatus) / {ULB4PUB|ULB2BPUB | ULBPUB } / N / ULB4PUB = submitted for publication
ULB2BPUB = To be published
ULBPUB = Published
Default: ULBPUB / ULBPUB / date.issued|t
subject.local|b
20 / themes / List of 20 Bologna themes / Y / List available at http://www.cfwb.be/ciuf/information/decretbol.pdf p.13. / Langues et lettres / subject.classification
25 / abstract / abstract / Y / abcde / description.abstract
26 / otherdescription / otherdescription / Y / description.other
27 / objfilemetadata / Defaults:
description: "Full text"
security: ULBINTERNET
version: ULBPOSTPRINT
If different values are wanted then specify as follows:
unique_offl_itemid:description|ssecuritylevel|vversion
securitylevel = { ULBINTERNET | ULBINTRANET | ULBINVISIBLE }
version = {ULBPREPRINT | ULBPOSTPRINT | ULBPUBPRINT} / Y / Description describes the content of the object file (table of contents, full text, images…).
Security describes the access restrictions for the object file (open for Internet, limited to Intranet,..).
Version describes the version of the loaded object file (ULBPREPRINT = author's version ; ULBPOSTPRINT = version accepted for publication ; ULBPUBPRINT = published version). / Examples:
mc0001:|sULBINTRANET
mc0001a:Table of Contents|sULBINTERNET ; mc0001b:Text of thesis|sULBINTRANET


4. PROCEEDINGS

TO DO DISpace mapping for ‘conferencedetails’

TO DO edition

Column / Field name / Contents (with subfields) / Repeatable[10] / Comments / Example / QDC field
1 / Unique offline item ID / $collectionname-[0-9]{4} / N / $collectionname: is the name of the offline collection as known by the DSpace system / mc-0012 / identifier.other
2 / title / maintitle|bsubtitle / N / Le champagne|bUne étude sur les bulles. / title
3 / author / authorlastname, authorfirstname|=uniqueid / Y / authorlastname and authorfirstname should be separated by a comma.
Put a point after an abbreviated authorfirstname.
It's preferable to enter the full authorfirstname (not the abbreviated one).
Composed authorfirstname: J.-C. / Devroey, J.-P.|=123456 ; Lefèvre, V. ; Hellemans, Jacques / creator
4 / type[11] / Colloque ou conférence|bDirection d'actes de colloque / N / type
5 / conferencedetails / conferencename|nconferencenumber|cconferenceplace|dconferencedate / N / contributor
7 / publisher / publishername|cpublisherlocation / Y / Multiple locations should be separated by commas.
Indicate only the most accurate location (for example if you know the name of the town don't set the country) / Elsevier|cNew York, Paris, Amsterdam
Elsevier|cAmsterdam ; Springer|cBerlin
Utrecht (and not Utrecht, The Netherlands) / publisher
8 / publicationstatus (year, month, day) / YYYY-MM-DD / N / Encode as ISO 8601 YYYY-MM-DD[12] / 2004
2004-10-30 / date.issued
9 / numberofpages / numberofpages / N / If monograph in multiple volumes, indicate the number of volumes and their number of pages / 206
2 vol., 159 et 148 p. / format.extent
10 / partofseries / seriesname|vseriesnumber / N / CEB|v18/2003 / relation.ispartofseries
14 / identifiers / idtype : id
id = {ISBN | " " | other} / Y / ISBN with or without hyphen / Example 1 ISBN : 2246670810
Example 2 ISBN : 2545612312
; other : 12345682 / identifier.*idtype
16 / language / { | en_US | en | es | de | fr | it | ja | zh | other } / N / fr / language.iso
17 / keywords / keywords / Y / economics ; politics / subject.other
18 / publication status(pubstatus) / {ULB2BPUB | ULBPUB } / N / ULB2BPUB = To be published
ULBPUB = Published
Default: ULBPUB / ULBPUB / date.issued|t
subject.local|b
20 / themes / List of 20 Bologna themes / Y / List available at http://www.cfwb.be/ciuf/information/decretbol.pdf p.13. / Langues et lettres / subject.classification
25 / abstract / abstract / Y / abcde / description.abstract
26 / otherdescription / otherdescription / Y / description.other
27 / objfilemetadata / Defaults:
description: "Full text"
security: ULBINTERNET
version: ULBPOSTPRINT
If different values are wanted then specify as follows:
unique_offl_itemid:description|ssecuritylevel|vversion
securitylevel = { ULBINTERNET | ULBINTRANET | ULBINVISIBLE }
version = {ULBPREPRINT | ULBPOSTPRINT | ULBPUBPRINT} / Y / Description describes the content of the object file (table of contents, full text, images…).
Security describes the access restrictions for the object file (open for Internet, limited to Intranet,..).
Version describes the version of the loaded object file (ULBPREPRINT = author's version ; ULBPOSTPRINT = version accepted for publication ; ULBPUBPRINT = published version). / Examples:
mc0001:|sULBINTRANET
mc0001a:Table of Contents|sULBINTERNET ; mc0001b:Text of thesis|sULBINTRANET


5. CONFERENCE LECTURE