We have a complex XDP for Appraiser Application Form with XML Data Model (default one, nothing fancy). There is another XDP of the same Application Form, same layout, but with different model and XML Structure. The XML Structure of the 2nd form is based on format which I am not familiar with, but I can understand what is in there.
The 1st XML is plain vanilla XML, straight forward.
The 2nd XML has multiple nested sections, and the field names are specified in the attribute of the tag element. The images are specified in the attachment section, and the are references from the relevant tag element.
Thanks Bruce! There are more than 1000 fields, it'll be very hard to do such mapping. I am looking for a solution to automate this or at least introduce a step to minimize the manual work.
Steps I am thinking of:
1. Write XSL to map the structure and leave field names as is. Looks like this is doable.
2. Prepare a table in Excel Sheet to map the field names from 1st XML to the 2nd XML. It'll be simple two columns table.
3. Apply find/replace using the table rows in 2 above as input. I can write a program to perform this find/replace, but I am looking for a desktop tool to perform this find/replace. I couldn't find a way to do this using Notepad++ for example.
If you can help with the above, that would be great.