Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

importing an XER file with EPS activity codes

8 replies [Last post]
Wed, 2010-05-19 02:22
vito Kooij, van
User offline. Last seen 10 years 23 weeks ago. Offline
Joined: 8 Dec 2005
Posts: 12
Groups: None
Dear Members,

I have a P6.2, and the next problem.

I have a project with EPS activity codes.

I have a client who wants XER file. If he imports into his own database, then the EPS activity codes do not come along.

I also tried the XML file, but the EPS activity codes are not put in EPS structure where the project stands.

Is there a hidden setting that allows for an XER file to import all data from the project (including the EPS activity codes)
PS. in the export file, the codes are available!

thanks for your comment
Top

Replies

Sun, 2021-01-31 12:39
#1
Santosh Bhat
User offline. Last seen 1 year 3 weeks ago. Offline
Joined: 15 Apr 2005
Posts: 381
Groups: Civil Engineering

Open the XER file in a text editor like Notepad. Do a find and replace that swaps "AS_EPS" to become "AS_Global" and then all the EPS codes and assignments to activities will be imported into the destination database as a Global Activity Code.

Takes a few seconds to do and brings across all the data - as long as you're allowed to do such imports! 

Top
Sun, 2021-01-31 10:30
#2
Steven Auld
User offline. Last seen 7 weeks 3 days ago. Offline
Joined: 13 Sep 2017
Posts: 126
Groups: Petro-Chem / Oil & Gas, TURNAROUND & SHUTDOWN (T/A & S/D)

EPS Level Activity codes CAN be imported from another database, but needs a bit of work up front.

The only Requirement is that an EPS Activity Code Type with Exactly the same name must already exist in the structure above the Project being imported into.

In order to Import a list of EPS Code values, you would first need to check that the EPS Activity Code Name already exists in the Target Database prior to importing.

If this EPS Activity Code Type exists, then all the code values & assignments will import.

Top
Wed, 2021-01-27 20:53
#3
David Kelly
User offline. Last seen 1 year 38 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630
Groups: Petro-Chem / Oil & Gas
EPS level Activity codes ONLY import into a database if the database has EXACTLY the same EPS structure as the database the project(s) were exported from.
Top
Wed, 2021-01-27 13:22
#4
Santosh Bhat
User offline. Last seen 1 year 3 weeks ago. Offline
Joined: 15 Apr 2005
Posts: 381
Groups: Civil Engineering

Only Activity codes that are assigned to the activities that are being exported will be in the XER file. If you have defined them in your Global Code Dictionary, but not used them yet, they will not get exported.

Top
Wed, 2021-01-27 13:11
#5
Zoltan Palffy
User offline. Last seen 4 weeks 5 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None
during the import process when you get to the Update Project Options screen selectModify at the bottomon the Data Type:Project section under Activity code value and activity codesand Prject code assignments  in the action column change all 3 of these INSERT NEW also the other machine must have the rights to import the codes if you are taking about activity code values make sure that you have the proper rights to do this  go to admin security profiles upper left global profiles then click on the profile name that has the check mark ie.e Administrator then under Privilege make sure that ALL of the boxes are checked   if you are talking about the activity code dictionary  The only other way to get the activity CODE DICTIONARY is to use a 32 bite machine with P6 and SDK on it and then export the Global dictionary to excel
Top
Wed, 2021-01-27 09:04
#6
VIKAS KULKARNI
User offline. Last seen 38 weeks 14 hours ago. Offline
Joined: 21 Feb 2020
Posts: 29
Groups: None

Global Activity Codes are not getting exported in the xer file. I tried opening the exported xer files with Wordpad & also in another PC but the global activity codes are not present in both cases.

Top
Fri, 2010-09-24 10:55
#7
Johnny Pain
User offline. Last seen 2 years 14 weeks ago. Offline
Joined: 23 Sep 2005
Posts: 47
Groups: Petro-Chem / Oil & Gas

hi all,

 

I've got the same problem here.

I also tried using global activity codes, but they did not come along as I thought they would.

I cannot use project activity codes since I need these codes to be available for more than one project...

are you sure there isn't a way ?

I tried recreating the same EPS structure, and it worked fine on one machine and not on the other...

I'm lost !

Top
Wed, 2010-05-19 02:42
#8
Rodel Marasigan
User offline. Last seen 3 days 5 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
vito,
EPS activity codes are there even if you check your xer with any text application such as wordpad or import it back to your machine with same EPS structure. The reason it was not imported to other machine because EPS structure will not be the same as in your machine therefore it will be ignore. The correct way of exporting activity codes is either Project activity codes or global activity code.
(You can convert to global your current activity code before exporting to xer so other machine can read it.)
Top