search

MarcusBarnes / mik

The Move to Islandora Kit is an extensible PHP command-line tool for converting source content and metadata into packages suitable for importing into Islandora (or other digital repository and preservations systems).
GNU General Public License v3.0
34 stars 11 forks source link

Add an Excel fetcher #403

Closed mjordan closed 7 years ago

mjordan commented 7 years ago

Working on some automation workflows here it is becoming apparent that having an Excel fetcher would simplify things immensely. I've played with the Spout component and it appears to work quite well. We could probably perform some magick allow a user to configure a path to an Excel file and then behind the scenes convert it to CSV for use in the existing CSV toolchains, but it might be simpler to create an entirely new Excel fetcher subclass. As long as the record object structure that the fetcher produces is compatible with the record structure produced by the Csv fetcher, all dowstream Csv* integrations should work fine.

mjordan commented 7 years ago

Tested on Linux and Windows with CsvToMods and Templated metadata parsers, and appears to work as intended. Will open a PR.

mjordan commented 7 years ago

Draft cookbook entry at https://github.com/MarcusBarnes/mik/wiki/Cookbook:-Using-the-Excel-fetcher.