- NancyLombardo, 13 Aug 2008


Using Excel to tab delimited file to create metadata and upload compound objects

  1. Create xls spreadsheet with all collection fields – Be sure filenames match actual items
  2. Import external data into xls, or create there
    Data Menu, Import External Data
  3. Export to tab delimited text file
  4. Open Acq station
  5. Import Menu - Import multiple files
  6. Choose tab delimited text file, Browse to it
  7. Browse to directory where actual matching items exist
  8. Adjust the listing of fields to match exactly the locations for each metadata field in the collection
  9. Finish to upload

Common errors:
  • Stray carriage returns in metadata
  • Titles too long

No such template def 'PROMPT:ehslbelow'

Topic revision: r1 - 13 Aug 2008, NancyLombardo
THE UNIVERSITY OF UTAHSPENCER S. ECCLES HEALTH SCIENCES LIBRARY
10 N. 1900 E. SALT LAKE CITY, UT 84112 • 801.581.5534 • IN-STATE TOLL FREE: 866.581.5534 • FAX: 801.581.3632
Ideas, requests, problems regarding Eccles Health Sciences Library wiki? Send feedback