Skip to content
ProjectControls.com
Oracle Primavera - PM6

P6 R8.1

In the Open Standard
Kieran CantwellMember for 15 years 6 months
Created
6
1
0

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)

Save Follow Follow forum Report
Reply New topic

6 replies

Oldest first
  1. 0
    Alex Alex ·
    #1

    Check your activity names.

     

    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.

    Report
  2. 0
    Anning Sofi ·
    #2

    When you choose your fields

    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.
    Report
  3. 0
    Kaide Johar Manasi ·
    #3

    Kieran, As Alex has rightly

    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.

    Report
  4. 0
    Alex Alex ·
    #4

    A Sofi, Thanks for that

    A Sofi, Thanks for that useful tip.

    Report
  5. 0
    Chris Gibbons ·
    #5

    If your text is splitting

    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

    Report
  6. 0
    Chris Gibbons ·
    #6

    If your text is splitting

    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

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?