I want to catch errors in some XML files that I have to transmit to a rather large customer of ours. If their systems decide that some of the data is invalid or missing, I have to figure out what the corrections are supposed to be, and then resubmit the files. Sometimes, it can take a few hours to correct even the least complex files. If I can automate most of this process, I'll be able to save myself a huge amount of time since I usually upload at least 100 of these files every day.
Does anyone know of a relatively easy way that I can validate the data within the files before I ever upload them? Hopefully, there's an existing application or script that will do what I want with just a few modifications. I need to be able to check for things like spelling errors, invalid dates, missing data, and data that's invalid because of other data in the file. An added bonus would be if I could automatically correct these errors as well.
Any suggestions would be appreciated.
Does anyone know of a relatively easy way that I can validate the data within the files before I ever upload them? Hopefully, there's an existing application or script that will do what I want with just a few modifications. I need to be able to check for things like spelling errors, invalid dates, missing data, and data that's invalid because of other data in the file. An added bonus would be if I could automatically correct these errors as well.
Any suggestions would be appreciated.