I have a TSV file containing metadata I want to set for about 2400 tracks across about 150 discs. In addition to the metadata the TSV contains absolute paths to each track and its associated cover art.

I've looked through documentation and sample and can't wrap my heard around the process of opening the TSV and reading/parsing the data. I'm a programmer by background, so dealing with this once I understand the model should not be a problem.

The TSV contains disc #, track #, album, album artist title, artist, and the two paths mentioned above. There is one folder per album; each of the albums comprises a single disc.

Anyone?

Thanks,

Stu

A sample has been uploaded to:

https://2manyrobots.com/actions/ReadandProcessDatabaseBoilerplate.zip

There should be only three statements that have to be changed at the start of the action. These statements describe the name of the 'File Path' column, optionally the name of a 'Path to Artwork' column and another which describes all other columns which are to be imported. The format for the 'other' column mappings is documented. There is no assumption when processing artwork that every row has an artwork item. There are lots of other ways the reading of each row's metadata could be handled. I simply chose one.

The action is designed to be run interactively. If it runs for any length of time, progress will be displayed on the status bar. (which is another neat trick)

Load whatever files you want....none of them will be used. Run the action from the UI. Be aware that if the loaded files are modified by the action, the changes will not be reflected in the UI. The files are being loaded 'out of bounds'.

Just following up to close off this thread: the action you provided is a great help.

Now if only Excel 2016 for Mac worked as well 🙁