My task involves comparing the data mapped from one format to another. Formats I use are xml to edi, edi to edi, edi to lawson, xml to pdf etc. now I perform it manually by comparing each input with its corresponding output and then check for the specific entries in both the docs and yes,it is a time consuming process. Are there any tools for any of theses formats which could be used to automate the comparison???
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
No. The issue here is that these mappings are not 1-1; in other words, there is no single, definitive mapping between these formats. Each mapping requires additional heuristics that (I assume) are built into the conversion software you are interested in testing.
Still, I think there is hope. You can probably find APIs for extracting data from each of these formats. You can use those APIs, along with knowledge of how your conversion software is supposed to behave, to test your conversion software.
Adding to user246 answer- languages like Perl or Python have libraries to read textual and non-textual formats like PDF, DOC or XML. Once you read the file into a data structure comparison is relatively easy, but keep in mind that reading itself converts the file to something new, and like user246 wrote there are no simple rules for conversion.