Middlebury

Difference between revisions of "CONTENTdm Project Client Procedures: Import multiple files with tab-delimited text"

m
m
Line 2: Line 2:
  
 
* Convert Excel spreadsheet to tab-delimited text file (.txt)
 
* Convert Excel spreadsheet to tab-delimited text file (.txt)
* The final column in spreadsheet must be the actual file name, including extension (e.g., s10econ2012jones.pdf; starrlibrary.jpg)
+
** The final column in spreadsheet must be the actual file name, including extension (e.g., s10econ2012jones.pdf; starrlibrary.jpg)
* Spreadsheet and files must be in same folder
+
** Spreadsheet and files must be in same folder
 +
[[File:Tab delim directories.jpg]]
 
* In the Project Client, On the left task pane under Common Tasks, click Add Multiple Items. The Add Multiple Items wizard opens.
 
* In the Project Client, On the left task pane under Common Tasks, click Add Multiple Items. The Add Multiple Items wizard opens.
 
* On the Import Method screen, select Import using a tab-delimited text file and browse for the file.
 
* On the Import Method screen, select Import using a tab-delimited text file and browse for the file.
 +
[[File:Add metadata browse.jpg]]
 
* Click Open and then click Next. The Import Type screen displays.
 
* Click Open and then click Next. The Import Type screen displays.
* Specify files and then click Next. The Display Image Settings screen displays.
+
[[File:Add metadata import.jpg]]
 +
* Specify files and then click Next. The Display Image Settings screen displays. Select YES
 
* Click Next. The Map Metadata screen displays. Map the fields in your CONTENTdm collection to the imported field names. The imported field names from your tab-delimited text file appear in the left column.
 
* Click Next. The Map Metadata screen displays. Map the fields in your CONTENTdm collection to the imported field names. The imported field names from your tab-delimited text file appear in the left column.
 +
[[File:Add metadatamapping.jpg]]
 
* Click Next. The Confirm Settings screen displays.
 
* Click Next. The Confirm Settings screen displays.
 +
[[File:Add metadata confirm.jpg]]
 
* Review the settings and then click Add Items.
 
* Review the settings and then click Add Items.
 +
[[File:Add metadata summary.jpg]]
 
* A progress screen displays as the items are processed. When complete, a summary screen displays the summary and any errors or warnings.
 
* A progress screen displays as the items are processed. When complete, a summary screen displays the summary and any errors or warnings.
 +
[[File:Example.jpg]]
 
* Click Close. The items are displayed in the project spreadsheet.
 
* Click Close. The items are displayed in the project spreadsheet.

Revision as of 15:46, 4 July 2012

Instructions for adding multiple files from a spreadsheet including metadata and the file/item (pdf, image, etc.)

  • Convert Excel spreadsheet to tab-delimited text file (.txt)
    • The final column in spreadsheet must be the actual file name, including extension (e.g., s10econ2012jones.pdf; starrlibrary.jpg)
    • Spreadsheet and files must be in same folder

Tab delim directories.jpg

  • In the Project Client, On the left task pane under Common Tasks, click Add Multiple Items. The Add Multiple Items wizard opens.
  • On the Import Method screen, select Import using a tab-delimited text file and browse for the file.

Add metadata browse.jpg

  • Click Open and then click Next. The Import Type screen displays.

Add metadata import.jpg

  • Specify files and then click Next. The Display Image Settings screen displays. Select YES
  • Click Next. The Map Metadata screen displays. Map the fields in your CONTENTdm collection to the imported field names. The imported field names from your tab-delimited text file appear in the left column.

Add metadatamapping.jpg

  • Click Next. The Confirm Settings screen displays.

Add metadata confirm.jpg

  • Review the settings and then click Add Items.

Add metadata summary.jpg

  • A progress screen displays as the items are processed. When complete, a summary screen displays the summary and any errors or warnings.

Example.jpg

  • Click Close. The items are displayed in the project spreadsheet.