Cookbook: Using the Excel fetcher

If using CSV files as input is inconvenient, you can replace the CSV fetcher in all CSV toolchains with the Excel fetcher. For this to work, your Excel file must follow these guidelines:

• it must be in Excel 2007/2010/2013 format (extension .xlsx)
• all cells should be formatted as text
• the first row mujst contain column labels/headings
  • all column headings must be unique, and the heading row cannot contain any empty headings
• each row in the Excel file must correspond to one Islandora object (image, PDF, etc., compound, newspaper issue, or book)
• one of the fields contains a unique identifier for each row in the file (in the [FETCHER] section's "record_key" configuration setting, as described below), and
• one of the fields contains the name of the file that is to be used in each of the created objects (in the [FILE_GETTER] section's "file_name_field" configuration setting, as described below).

To use this fetcher in the CSV toolchains, configure your .ini file like this:

[FETCHER]
class = Excel

Cookbook table of contents