Preparing Files for the Program

Using the Correct CSV headings

Depending on the function you would like to perform (Update, Mint, Reserve), there may be some adjustment to headings that you would need to make before using the python program. There may be instances where you will receive a request for a DOI Update/Mint where the headings are incorrect. The chart below will describe each heading that is required for DOIs, as well as recommended headings that you should use when possible, for DOI Updates and Minting.

Important: For all dates, format them in the 'YYYY-MM-DD' format. For all people, format their names in 'Last Name, First Name Middle Initial/Middle Name|ORCID' (ex: 'Tvrdy, Peyton C|https://orcid.org/0000-0002-9720-4725').

Required Header	Definition
ROSAP_URL	Where the DOI will redirect to
sm:Creator OR  sm:Corporate Creator	Creator of the item/resource
Title	Title of item/resource
sm:Corporate Publisher	Publisher of the item/resource
Published Date	Date of Publication of item/resource
sm:Format	Format of the item/resource
sm:Resource Type	Resource type of the item/resource from Workroom.
Optional Headings	Definition
Workroom ID	Workroom Accession Number (ex: 99001)
ROSAP ID or ROSAP_ID	CDC SWAT ID (ex: dot:23812)
sm:Collection	Collection Name [must match collection value in constants.py]
sm:Digital Object Identifier	DOI (required for updates/mints, not required for reserves)
Alternative Title	Alternative Title of item/resource
sm:Creator	Person creator of item/resource [Optional if sm:Corporate Creator recorded]; [If recording ORCID iD separate ID with | character, ex: Doe, Jane|0000-0000-0000-1234]
sm:Corporate Creator	Corporate creator of item/resource [Optional if sm:Creator recorded]
sm:Corporate Contributor	Corporate contributor of item/resource
sm:Contributor	Person contributor of item/resource [If recording ORCID iD separate ID with "|"/pipe character, ex: Doe, Jane|0000-0000-0000-1234]
Personal Publisher(s)	Used for when a personal publishes a resource independently of a corporate entity (Rare).
sm:Key words	Keywords separated by a new line character or ", "
sm:Report Number	This is the USDOT report number. If there is more than one report number, please separate with a ";" character (ex: FAA-1234;USDOT 123904)
Grants, Contracts, Cooperative Agreements	This is where you record any and all contract numbers. If there is more than one contract number, please separate with a ";" character (ex: 69123d2958DF;38902375). Please do not include any uneeded chararacters or words (ex: USDOT 69123d2958DF --> 69123d2958DF)
sm:ResearchHub ID	This is for the ResearchHub Display ID
Content Notes	This is for your Public Note/Content Note. This information is recorded as "Technical Information," so it should be information about the object's record. It should not be the abstract.
Copyright Date	This column is contains the date the resource was put into copyright or public domain in 'YYYY-MM-DD' format.
ISSN	The ISSN field is for international Standard Series Numbers (ISSN) for that resource.
TRIS	The TRIS field is for the Transportation Research Information Services (TRIS) Database Accession Number.
OCLC	The OCLC field is for OCLC Number of the resource.
ISBN	The ISBN field is for International Standard Book Number of the resource.
Date Captured	The Data Captured field contains the date the resource was initially cataloged in the NTL Workroom System in 'YYYY-MM-DD' format.
Date Modified	The Data Captured field contains the date the resource was last modified in the NTL Workroom System by NTL Staff in 'YYYY-MM-DD' format.
Description	This is for the Abstract.
Language	This is for the language of your item/resource
Rights Statement	This field is where you would include any licensing and copyright information about the resource. For works that are covered using Creative Commons licenses, include the license URI in this field. For items in the public domain, use "Public Domain."
Contracting Officer	This is the Contracting Officer for the resource. ORCIDs may be included here after a "|" pipe character.
sm:Edition	This field is for the edition/version of your item/resource
Series Name	This is where the item/resource's series information is recorded [must match series value in constants.py].