- 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


Topic revision: r1 - 13 Aug 2008 - 14:41:52 - NancyLombardo

This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Foswiki? Send feedback