Hi all,
My first post so be kind.
I am having an issue when running a weekly resource export report into excel, while the report is exporting ok the "activity name" cell is being split up creating a new cell which pushes all other cells to ther right thereby misaligning the columns in the spread sheet.
I do not think it is the lenght of the activity name as some cells are being spilt are not as long as other which remain intact.
Any ideas please drop us a note
Cheers
Kieran
(P6 R8.1)
If your text is splitting where there is a comma in the text, change the Text Qualifier option from ' to ". This solved the problem for me
If your text is splitting where there is a comma in the text, change the Text Qualifier option from ' to ". This solved the problem for me
A Sofi, Thanks for that useful tip.
Kieran, As Alex has rightly pointed out check any delimiter in your activity name. Since the export file is CSV format ie., Comma Separated Values, any comma in the Activity name will shift the values to the right cells.
When you choose your fields in the report, place the activity name at the last column.
After report export, move the activity name to its column location according to your report format.
Check your activity names. Does it have any apostrophe or quotes or some similar character that is same as the delimiter set in your report format? We do most of our exports with just activity ID without activity names.