Using Tab-Delimited Text Files
Tab-delimited text files are an easy way to import metadata for multiple files. Use tab-delimited text files to import:
Metadata into a specific field
Single compound object
Multiple compound objects
- Creating a Tab-delimited Text File
- Entering Dates in a Tab-delimited Text File
- Using Microsoft Excel to Create Tab-delimited Text Files
Regardless of how you use a tab-delimited file, follow these guidelines:
One field must contain the file name of the items.
For best results, place the field that contains the file names of the imported files as the last field in your tab-delimited text file.
All collection metadata field names must appear in the first record of the tab-delimited text file.
The file names must exactly match the contents of the upload directory for the files. One single mismatch causes the entire upload to fail.
Use a tab for the delimiting character.
End each record with a carriage return.
Do not use carriage returns or tabs within a field.
The end of the document should be the very end of the last word in the last line, with no extra blank lines or spaces.
Remove special characters from file names and collection metadata field names. Special characters are: \ / : * ? " < > |
When entering file names, enter only the file name of the item, such as item.jpg. Do not enter full path names such as c:\windows\item.jpg.
When entering file names, be sure to include the extension, even if your operating system hides the extension type. Common extension types are JPG, TIF, GIF, and PDF.
When importing files, use unique file names for each item. Using capital letters in the file name does not make the file name unique. The file name item.jpg is treated the same as ITEM.jpg and ITEM.JPG.
Field name mapping need not be 1:1. Multiple tab-delimited fields may map to a single CONTENTdm collection field or you might have fewer fields in your tab-delimited file than in your CONTENTdm collection.
One or more fields must map to the Title field of your collection.
Store all of your items referred to in the tab-delimited file in one directory.
If importing dates to a Date data type field, they must be valid dates in the following supported formats:
|Supported delimiters between dates||Comma (,) and
|Supported delimiter in date range||Hyphen (-)||2008-2009|
|Leading spaces are okay but not required when using multiple dates||YYYY; YYYY; YYYY
|2007; 2008; 2009
After dates are added to the project spreadsheet, they will be displayed in a yyyy-mm-dd format.
In addition to the general guidelines highlighted above, there are specific guidelines for creating tab-delimited text files using Microsoft Excel:
Turn off the text wrap option before saving as a tab-delimited text file. Using the text wrap option sometimes places a special character at the end of the line, which then causes the import to fail.
For cleanest metadata, replace quotation marks within fields with apostrophes. Otherwise, when the spreadsheet is converted to a text file, another set of quotation marks is added next to the quotation marks. For example, if you have a field in Excel that contains the following:
Frank "Ol' Blue Eyes" Sinatra
Once the file is saved as a text file, the tab-delimited text file will read:
"Frank ""Ol' Blue Eyes"" Sinatra" unless you change the quotation marks to apostrophes.
See Troubleshooting Tab-delimited Text Files for help resolving problems.