Imported XER is resetting progress

not sure you can do it that way 

why not build the codes in p6 

then export to excel 

populate in excel 

then import code values from excel back into p6 

Thats basically what Ive done Zoltan - the codes come back fine, its just the progress loss thats got me confused.

I used this method:

https://tensix.com/2018/05/how-to-load-activity-code-values-into-primavera-p6-from-excel/

Are you importing it into the same project, with no changes to the project level settings?

When you say "no progress" - that is no % completes AND no start dates?

Hi David,

Im actually importing as a new project, for some reason the option to add to existing is greyed out.

and yes, 0% complete with all start dates reset (back to 2010 for some reason)

Ive attempted to save the file as a delimited CSV and renamed it as an XER (as per Barrie's instruction on Tensix) however when I try to import the file, P6 claims it is not a valid XER.

since that option is greyed out it appears thats you do not have the rights to make this change

are you the adminstrator of this datbase if so go to Admin Security profiles and go to global profiles and highlight the profile name that is checked (End user) and make sure that under Has Privilege ALL the boxes are checked. Click on the Project Profile and highlight the profile name that is checked (Project Manager) and make sure that under Has Privilege ALL the boxes are checked.

if you are not the adminstrator then have the adminstrator give you the proper rights

Make sure the Impoted File is statused with In-Progress or Completed status.

buildign codes has NOTHING in the world to do with progress

Hi,

I think CSV - Comma Separated Values is not the correct file format for a XER file.

I always use Tab delimited txt file format.

OK, so a bit of an update.

It seems that it doesnt matter if I add any codes or anything so this can be ignored - the real issue is ithat would appear that between changing the .xer file to .txt file, opening it in Excel as a tab delimited text file - saving it as a tab delimited text file and returning it to a .xer file and importing, something is going wrong as all dates are reset to Jan 00, no progress, no actuals.

Ive tried updating an exisitng schedule & creating a new one, this is on 2 separate databases from 2 separate PC's (one client and one my own) and both return the same problem.

Is there any other way of converting a file from .xer to txt other than altering the file type, as clearly something is getting corrupted when I make this change.

The strange thing is, if re-open the .xer in excel, all the dates are as they should be!

1st let me ask why you want to do this ? What is your main objective ?

2nd you can use the file parser to get what you want

here is the link to 2 different version depending on what version of excel that you use

https://www.planacademy.com/using-primaveras-xer-file-parser-import-wbs-from-excel-without-the-sdk/

P6xerFileParserBuilder.xls – MS Excel 2003 and prior

xerFileParserBuilder_2007 – MS Excel 2007 and later

Thanks Zoltan, my main reason is to save me adding around 500 activity codes manually - I have them already in an Excel table so it would just be a copy/paste.

I'll give the file parser a go, although I seem to remember the ;last time I used it I had all sorts of errors...

if its just assigning the code VALUES to the activiies that can be easily done with an export of the activites and the codes from  P6 to excel 

then populate the code values in excel and import back into P6

if you are createing NEW codes (NOT CODE VALUES) thats is a difffernt sory and depengin on what version of P6 that you are using you could possibley use SDK for that