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
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...
Member for
16 years 3 months
Member for16 years3 months
Submitted by Zoltan Palffy on Tue, 2019-10-15 14:49
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!
Member for
20 years 6 months
Member for20 years6 months
Submitted by Zhang Haixiang on Tue, 2019-10-15 04:57
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
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.
Member for
16 years 3 monthsif its just assigning the
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
Member for
9 years 4 monthsThanks Zoltan, my main reason
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...
Member for
16 years 3 months1st let me ask why you want
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
Member for
9 years 4 monthsOK, so a bit of an update.It
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!
Member for
20 years 6 monthsHi,I think CSV
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.
Member for
16 years 3 monthsbuildign codes has NOTHING in
buildign codes has NOTHING in the world to do with progress
Member for
15 years 11 monthsMake sure the Impoted File is
Make sure the Impoted File is statused with In-Progress or Completed status.
Member for
16 years 3 monthssince that option is greyed
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
Member for
9 years 4 monthsHi David,Im actually
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.
Member for
21 yearsAre you importing it into the
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?
Member for
9 years 4 monthsThats basically what Ive done
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/
Member for
16 years 3 monthsnot sure you can do it that
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