How should we manage files with multiple data sources in them

[jrdh]

There's a few parts to this which are interrelated but the original source was (massively paraphrased):

"I've uploaded a zip with multiple files in it and it's picked a csv in there and indexed it. Now it shows 100 records next to a zip with like 20 files in it and it's weird."

Similar scenarios to this are:

• "I've uploaded a spreadsheet with multiple sheets and it's indexed the first one and nothing else"
• "I would like to download all the files in a dataset in one zip"

And probably others!

What's the best solution here? Some initial thoughts:

• allow users to untick a "index this" checkbox when uploading a new resource
• don't try to find an indexable file from uploaded zips (same applies to spreadsheets I guess, instead of indexing the first sheet, just don't)
• an extension of the first option would be to allow users to select which file (if any) gets indexed from a zip/spreadsheet
• unzip the zip and make a resource out of each of the files automatically (then allow downloading them all via a "download this dataset" feature)

moooooore probably.