I am working on a script to get data from excel spreadsheets to a database. The data is from surveys conducted by our office where the data comes in with very little formatting. At the moment, the data is manipulated with a lot of copy and paste, then analysed 'by hand' (ie. someone clicks and drags in excel and does pivots and copy pastes into other software).This leads to messy file structures and missing or incorrect/incomprehensible data. enter the need for a database.I have got a solution working which will accept csv files. It will parse the data and insert it correctly as long as each column header is correct. But my superior is pushing me to accept xml files with an xsd schema so I can validate the data.My argument would be that whether or not I use xml, the user will have to save the original file as another file type and I can validate the data within my script based on column headers anyway.The counter argument is that if they decide to include a new data set (ie, new table layout) my script might break. Either way, if the data type is incorrect, the user will have to go back to the file and edit it before any solution will work. So the answer I'm looking for is whether or not I should bother to set up xml functionality.[note, I am using php to script as I am not familiar with vba and I'm on a student placement so I do not have enough time to learn a new language.][ASIDE - am I taking the wring approach to this?]
Should I implement functionality for an xml file+schema?
php;database;scripting;validation
If I were you, I would create the importer to work with the CSV, but include stub functionality for the XML.  Release the tool with the CSV functionality and then begin working on the XML.As far as your superior is concerned, I would point out that working with CSV is drastically simpler than working with XML, so you can get a deliverable faster, and then work on the XML portion.  This means that the rest of the team can begin using this tool, and then later on if they do decide to change, the XML functionality will be there.As to your final question, sort of.  You have an idea for something good, and your superior is trying to provide an augmentation to make that better in their mind.  This isn't a bad thing, as you get paid the same, but have more hours of work to do.  As a result, I would suggest that you try and massage their idea into yours, and make it an even better idea instead of fighting the change.