Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.

Duplicate Lines after Export to .xml and import into Excel

Avatar

Former Community Member
Hi,



I created a read-out form for a radiologic study. This form is filled out 150 times by three different radiologists. I collect the data which is emailed back to my as a .pdf in a Dataset.pdf. When I export the Data to an ".xml-File" and afterwards import it into Excel, it gives me severeal duplicate lines. Sometimes the data is distributed over 2-3 different rows, sometimes the exact same data is duplicated in 2-4 consecutive rows, etc. I don't see a pattern. If I export it as a .csv File, there is no problem.



Has anybody had the same problems? What do I have to do, that at the end in Excel I have one row for each dataset emailed back to me?



If necessary I can upload the form and publish the Link.



It's not really too important as I can still extract Data using the .csv export. I would just like to understand, why it doesn't work with .xml Export.



Thank you for your help,



Olivio
3 Replies

Avatar

Level 2
Please post a synopsis of your solution.

Avatar

Level 1

Hi, I am looking for a solution too on this problem.

Can someone help?