Skip to main content

eCommons: Cornell's Digital Repository

Information and user support for eCommons, Cornell's Digital Repository.

Creating metadata for batch upload

eCommons staff will work with collection coordinators to upload multiple items to collections. Coordinators should refer to the Metadata tips page in this guide and to the README page in the metadata template for guidance on the meaning and content of metadata fields; this page provides additional information on the correct formatting of those fields. Templates employ data validation whenever possible, and we provide formatting guidelines (below) for manually entered metadata. 

Metadata templates available on the eCommons wiki (access restricted to current collection coordinators; please contact eCommons adminstrators to request access.

Metadata formatting

Some or all of the following fields (or slight variations on them) may appear in a metadata template.

File_name: REQUIRED. Copy or type the file name exactly, including the extension (.PDF, for example). See the "Create List of File Names" tab for some tips on creating an error-free list of file names.

Authors: RECOMMENDED. Format as: Lastname1, Firstname1; Lastname2, Firstname2 etc. 

Title: REQUIRED. Capitalize the first word and proper nouns; do not use all capital letters. 

Pub_year: REQUIRED. Format as YYYY, validated field.

Pub_month: OPTIONAL. Integer between 1 and 12, validated field. 

Pub_day: OPTIONAL. Integer between 1 and 31, validated field. 

Publisher: OPTIONAL. No formatting requirements. 

Citation: OPTIONAL. If previously published, enter citation information in any standard citation format. 

Language: OPTIONAL. Validated field. Codes are explained on the "Lanuage codes" tab.

Type: HIGHLY RECOMMENDED. Validated field. 

Mandatory keywords: OPTIONAL. Some collections apply a standard keyword or phrase to every item in order to improve search results. These are in addition to author-supplied keywords. Separate multiple keywords with a semi-colon.

Keywords: HIGHLY RECOMMENDED. Separate multiple keywords with a semi-colon.

Abstract: HIGHLY RECOMMENDED. No formatting requirements. 

Description: OPTIONAL. No formatting requirements.

Collection_name: REQUIRED. Copy or type the collection name exactly. Validated field in some custom templates. 

Collection_URL: REQUIRED. Copy or type the collection URL exactly. Validated field in some custom templates. 

Committee chair or advisor: RECOMMENDED IF APPLICABLE. Format as: Lastname1, Firstname1; Lastname2, Firstname2 etc. 

Committee co-chair: RECOMMENDED IF APPLICABLE. Format as: Lastname1, Firstname1; Lastname2, Firstname2 etc. 

Committee member: RECOMMENDED IF APPLICABLE. Format as: Lastname1, Firstname1; Lastname2, Firstname2 etc. 

Degree discipline: RECOMMENDED IF APPLICABLE. 

Degree level: RECOMMENDED IF APPLICABLE. 

Embargo_end_year: REQUIRED IF APPLICABLE. Format as YYYY, validated field. See eCommons Access policy.

Embargo_end_month: REQUIRED IF APPLICABLE. Integer between 1 and 12, validated field. 

Embargo_end_day: REQUIRED IF APPLICABLE. Integer between 1 and 31, validated field. 

Release_form: REQUIRED if present. Copy or type the file name exactly, including the extension (.PDF, for example). Suggested file name structure: LastnameFirstname_YYYY_FERPA.PDF, LastnameFirstname_authorrelease.PDF, as appropriate.

Creative_Commons_license: OPTIONAL. Validated field. 

In order to create an accurate list of filenames for your batch upload, we highly recommend using an automated method as opposed to manually typing the filenames or copying and pasting them one by one. You can then copy and paste the list of filenames with extensions into your template.

Please note that these methods will create a new file in your directory which must be removed before pasting the list into the metadata template.

Also note:

  • File names should not include spaces or special characters. More information on file naming best practices.
  • File names in the metadata must match actual file names exactly, and include the file extension.

Windows

 

How to create a file list at a command prompt

  1. In Windows 10, click start and type “cmd” and “Enter” to open the Command Prompt
  2. At a command prompt, locate the drive that contains the folder whose contents you want to list. For example, if you want to create a text file that contains a list of the contents of a folder on drive C, type the following command at a command prompt, and then press ENTER:

c:

  1. At a command prompt, locate the folder whose contents you want to list. For example, if you want to create a text file that contains a list of the contents in the Windows folder on drive C, type the following commands at a command prompt, and press ENTER after you type each command:

cd\
cd windows

  1. Type the following command at a command prompt, and then press ENTER, where filename is the name of the text file that you are creating:

dir /B > file.txt

For example, if you want to create a file named Windowsfolderlist.txt, type the following command at a command prompt, and then press ENTER:

dir /B > windowsfolderlist.txt

NOTE: The text file that you create is located in the folder that you are in when you follow these steps. In the earlier example, the Windowsfolderlist.txt file is located in the Windows folder.

  1. Use a text editor, such as Notepad, to view or print this file.

NOTE: You cannot export or print a list of the files that are contained in a folder in Windows Explorer.

(Source: https://support.microsoft.com/en-us/help/196158/how-to-create-a-text-file-list-of-the-contents-of-a-folder)

 

Use an application

  1. Download application “File-List-tool.bat"
  2. Copy and paste “File-List-Tool.bat” into the directory you wish to make a list of.
    1. If your computer security shows warnings, select “Run Anyways” or otherwise grant permissions to the application.
  3. After running, you will notice a new file named “file-list.txt” has been created in the directory. This is an alphabetical list of files in the directory.

Mac

 

How to make a file list with TextEdit

  1. Choose Finder (at the top of the screen) > Preferences, then click Advanced.
  2. Select “Show all filename extensions.”
  3. Open the folder whose contents you want to list.
  4. Press “Command-A” to select all items in the folder
  5. Press “Command-C” to copy the list
  6. Open TextEdit by opening the Finder, selecting “Applications” and opening TextEdit
  7. Choose Format > Make Plain Text
  8. Press “Command-V” to paste the list of files with extensions into the document.
  9. Save the document.

How to make a file list using Terminal

  1. Open the Finder, click on Applications, and open the Utilities folder
  2. Open the Terminal application
  3. In the Terminal, locate the folder whose contents you want to list. For example, if you want to create a text file that contains a list of the contents of a folder on the Desktop called “Example”, type the following commands at a command prompt, and press ENTER after you type each command:

cd Desktop
cd Example

  1. To make a list of the files in the folder “Example” type:

ls > file-list.txt

NOTE: The text file that you create is located in the folder that you are in when you follow these steps.


When a user browses a collection, items are displayed in reverse chronological order in which they are uploaded into eCommons (newest items first), even for items uploaded in batch. If default display order is important to you, you must order your items in the metadata template with those you want to appear last at the top of the spreadsheet, and those you want to appear first at the bottom of the spreadsheet. 

Please do note that the user can change the order in which items are displayed, and that with subsequent batch uploads, the newest items will always appear at the top by default.

 

Language codes

Value Language
en_US English (United States)
en English
ar Arabic
bn Bengali
my Burmese
ca Catalan
zh Chinese
da Danish
nl Dutch
fr French
de German
he Hebrew
hi Hindi
hu Hungarian
is Icelandic
it Italian
ja Japanese
jv Javanese
ko Korean
la Latin
ml Malay
mr Marathi
ne Nepali
pt Portuguese
pa Punjabi
ro Romanian
ru Russian
es Spanish
ta Tamil
te Telugu
tr Turkish
ur Urdu
vi Vietnamese
other Other language
   
Loading ...