Hoping some of the gurus out there can help with this.
I am currently trying to make use of the XML Import Templates on Datawindows in an existing legacy project. I have previous experience of using PBDOM and parsing XML file via large amounts of code, but wanted to see if the XML Import Templates could be used to simplify my development this time around.
For the moment the application is being maintained in PB 10, but this should not matter.
Below is a screenshot of my DW. I have created a test DW for this query, but the structure of the XML and premise will remain the same for more complicated data. The test DW has 4 columns per row. The XML File contains multiple groupings under multiple elements. I am attempting to populate each column for each row using the XML Import.
Below is a sample of the XML being used for the import. It is very simple data with multiple groupings.
When I import the file using the applied template, I get the following result in the DW. The uploadid does not populate, while the workid will only populate for the first row.
I am sure I am missing something in the iteration of the XML Template, but have not used it enough to understand how to get it to process as it should. I am also unable to start the detail of the import at the Upload Element, which I suspect is why the uploadid does not import.
I am trying to achieve the below result set after the import.
I have attached the test datawindow and test xml is anybody can help or provide me with the template that would allow me to import all the data on each row.
Thanks in advance