The same rules apply to importing a list of items as when adding an item individually. The same fields are required so the user must take care to provide all of the necessary information in the document which will be uploaded. The spreadsheet validation process is sensitive to both the order of the columns and the validity of the information in each cell.
A spreadsheet template is provided to assist you with constructing the import file. Click on the spreadsheet icon (to the right of Step 1) to download this document. Detailed field requirements can be found by clicking on the double-down icon.
When filling in information about your offering, leave the column headers in row 1 and enter your items beginning in row 2. Only SuDoc Number, Title and Publication Start Year (Pub. Start Year) are required fields. The import software will provide default values for Item Format (paper), Item Condition (Good), and Item Superseded (No) unless you supply a different value. Other values, such as Comment and Pub. Start Month/Day will be left blank unless you provide a value.
Publication End Dates are not necessary unless the Offer is a multi-item offer.
When you have finished creating your spreadsheet, remember to save it in CSV format. This is the only format currently accepted by the database.
Errors: Supplying a value which does not match the Accepted Values list, will cause the item to be kicked back as an error. You may then correct the item(s) that had not successfully imported and resubmit them. Please note: Only submit the corrected items in your follow-up import. Do not resubmit records that had successfully imported from the previous file as this will cause a duplicate entry. If accidently resubmitted, please contact email@example.com for assistance.
The Import Items form
Format details for importing items.