Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Duplicate Lines after Export to .xml and import into Excel

Avatar

08-08-2008

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

Replies

Avatar

Avatar
Level 2
_Fisher_Zoe_
Level 2

Likes

0 likes

Total Posts

30 posts

Correct Reply

0 solutions
View profile

Avatar
Level 2
_Fisher_Zoe_
Level 2

Likes

0 likes

Total Posts

30 posts

Correct Reply

0 solutions
View profile
_Fisher_Zoe_
Level 2

23-12-2008

Please post a synopsis of your solution.

Avatar

Avatar
Level 1
monica14600
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
monica14600
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
monica14600
Level 1

03-11-2014

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

Can someone help?