A2A data feed not processing all records.
I am stuck on an issue with a data feed in 6.6 P2 where not all records are being processed correctly. My data feed is configured to target a parent application that references 5 different cross-reference questionnaires. The data feed runs correctly if there is only 1 record per cross-reference but will not update records if more than 1 record per cross-reference within the same parent record.
Hey Thomas. It's been a while since you posted this question, hopefully you figured it out by now. I don't know the answer but here are some suggestions.
This may be due to how your data feed source report is set up. You may need to set your report to start from the application and relate to the questionnaire. Or, base the report from the questionnaire. You might need to change the report format from hierarchical to flat. Ideally & obviously, you need to get the source report in the proper structure that fits the requirement of what you are trying to achieve.
Hi Nolan -
I have not yet had the chance to correct this issue as some other priorities came up. The DF report targets the application with added cross-references to the 5 questionnaires. The report display option is set to 'column -flat' to allow all records to be visible in the report. I also tried using the 'enforce relationships' option in the report for all the cross-references to see if that might help but it only limits the record display in the report.
The only other solution I can think of would be to create separate data feeds for each questionnaire to process the records, not ideal. I'll spend some more time on this next week to see if I can figure out what might be wrong in the configuration.
I would recommend starting by converting the feed to a transport only feed and then looking at the XML. My guess is you will likely need to adjust the transform (XSLT) to have the feed be able to see all the various related records (as opposed to being sub-nodes of the parent).
Without seeing your data, I'm guessing it is:
And when the data feed reads this with the standard transform, you can update Child1.1 and Child2.1 but it won't iterate through Child2.2 and Child2.3.
StackOverflow has this on flattening XML that might help: https://stackoverflow.com/questions/37730436/flatten-a-nested-xml-using-xslt
Hope that helps.
Hi Matt -
What do you mean by 'transport only' for the transport method? My data feed is currently configured with the AWS transport method. I will look into the XML transform configuration as well. I went with the default transform as a test.
A transport only will go get the file needed and put it somewhere for you (the file path you specify)… but won’t actually process the data.
On the first page of a data feed in the “Feed Information” section, you can select “Standard” or “Transport Only”. The transport will produce the exported XML from the report you specify for the AWS Transporter. That is what the data feed receives as data… so you can check the structure of the file and the contents (to make sure the data feed user can see all the records).