Input comes from CSV files, so I need to be able to parse them correctly into the database. Dumping them in works for now, but it's not going to hold in the long run because I need to be able to use validation to make the database understand the data. I also need to be able to update the data that already exists from each dump... That seems like it might actually take a lot of time to code, but I'm going on the hunch that it will save hours of validating data in the future.
I suppose I could use the existing dump of multiple CSV files and just dummy the input from each one where the information from the file exists in another table.
Either way, I need to look into how to use the mysql function together with file uploads to release the need to log into the database to input the data.
