CONTENTdm® Online Help — Version 6
  Project
Client
  Compound
Objects
  Using
Collections
  Customizing
Website
  Server
Admin
  Collection
Admin
  Item
Admin
  Add Ons  
Topics
 

» Using the Home Tab

» Working with Projects

» Adding Items & Objects

» Entering Metadata

» Editing Items & Metadata

» Managing Archival Files &
   High-Resolution Images

» Uploading Items to a
   Collection

» Approving Items &
   Building the Text Index

» About the Project Client

Glossary
Site Map
Contact Us
Tutorials
User Support Center
Support FAQs

 
PreviousNext
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

  • Multiple files

  • Single compound object

  • Multiple compound objects

Learn about:

Creating a Tab-delimited Text File

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.

Entering Dates in a Tab-delimited Text File

If importing dates to a Date data type field, they must be valid dates in the following supported formats:

Supported Formats yyyy-mm-dd
yyyy-mm
yyyy
mm/dd/yyyy
mm/yyyy
yyyy-yyyy
2009-01-01
2009-01
2009
11/30/2008
11/2008
2008-2009
Supported delimiters between dates Comma (,) and
semicolon (;)
2008, 2009
2008; 2009
Supported delimiter in date range Hyphen (-) 2008-2009
Leading spaces are okay but not required when using multiple dates YYYY; YYYY; YYYY
YYYY;YYYY;YYYY
2007; 2008; 2009
2007;2008;2009

After dates are added to the project spreadsheet, they will be displayed in a yyyy-mm-dd format.

Using Microsoft Excel to Create Tab-delimited Text Files

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.


Return to top of page

PreviousNext

CONTENTdm® is a registered trademark of OCLC
© 1997-2014 OCLC. All Rights Reserved