I actually figured out what was wrong after a while, it was a problem with the field delimiter setting in the report while running it. It was set up to see commas [,] as a space and therefore shifted or split the cell data based on the amount of Commas in the activity name.
Cheers
Aidan
Member for
14 years 7 months
Member for14 years7 months
Submitted by gr*****@s***** on Mon, 2012-06-04 17:18
Try opening the xer as a text file and then import to excel, that will allow you to review the data in a raw form. Do the same with a v7.1 file and see what is different.
Member for
14 years 6 monthsThanks Forest I actually
Thanks Forest
I actually figured out what was wrong after a while, it was a problem with the field delimiter setting in the report while running it. It was set up to see commas [,] as a space and therefore shifted or split the cell data based on the amount of Commas in the activity name.
Cheers
Aidan
Member for
14 years 7 monthsTry opening the xer as a text
Try opening the xer as a text file and then import to excel, that will allow you to review the data in a raw form. Do the same with a v7.1 file and see what is different.