ASP.NET: How can I group or link files uploaded together
Posted on 2014-10-05
I have been able to set up a web page that allows uploading of multiple files. Users can also download any of the files that have been uploaded. I'm storing the uploaded files in the database (SQL Server) as they are not too large.
I have been asked to enhance this functionality as follows:
If person A uploads a batch of files via this webpage, other users of the site should be able to see the files in a batch displayed together. If a second batch of files is uploaded by person A at a later date, the users should see that batch together. Here's an example of what the file listing for download should look like (roughly - it just needs to show a way to differentiate related files):
Report 1 (a report file)
supporting document1 (documentation for report 1)
supp. doc 2 (more documentation for report 1)
supp doc n
Report 2 (another report file uploaded at a different time)
supp doc 1
supp doc 2
support doc n
In other words, the report file and its related files should be grouped together in some way that would allow the end users to know which supporting files belong to any given report. My management does not want the end users to have to read a guide that tells them which files go with the report file. They also don't want the report developers to have to modify the file names to assist with programmatically grouping the files.
All I've been able to think of, (and this is a kludge and hardly a robust solution), is to instruct person A to always upload all related file together at one time, I would add a dropdown that person A would use to select an item to help me "glue" the files together. I mean that they could select a word that I would use to select files that belong together. I think I'd also have to use a datetime stamp that just looked at the date and hour (not minutes or seconds) so that I could hook files uploaded together using these two hidden fields.
Please let me know if there's better way. I sure hope there is because my solution doesn't sound too solid.
Also please let me know if I should clarify anything. I haven't started coding this yet because I want to think about whether I could come up with something better. I've done quite a bit of searching but I haven't found anything remotely like this. possibly I'm using the wrong keywords.