Creating Activity Codes values/fields from spreadsheet
In the Open Standard
Azneil Abdul MalikMember for 22 years 9 months
- Created
- 1
- 3
0
Hi there,
Need some help.
Scenario : Just came into a project, the activity codes were setup previously by my predecessor. Unfortunately, through the years, the values have been multiplying. Redundancies are evident. Need to clean up the mess.
In the company, SAP has been established with equipment tag nos built in it. During execution, SAP and P3e would have to work together. Ideally, the schedule should contain the same values of that in SAP to the exact format.
e.g. currently in SAP value is 45E-0501.
However in P3e value is 45E-501. When it should be the same.
Plan : To extract the values in SAP and import it into P3e Activity Codes (Global) as values via a spreadsheet with the description as well.
Problem : Tried it before in Ver 4.1, could not find a way to do it. Now I have ver 5.0, still no idea. Only way so far is to input it one by one.
So any bright ideas ? enlighten me.
Thanking in advance.
Need some help.
Scenario : Just came into a project, the activity codes were setup previously by my predecessor. Unfortunately, through the years, the values have been multiplying. Redundancies are evident. Need to clean up the mess.
In the company, SAP has been established with equipment tag nos built in it. During execution, SAP and P3e would have to work together. Ideally, the schedule should contain the same values of that in SAP to the exact format.
e.g. currently in SAP value is 45E-0501.
However in P3e value is 45E-501. When it should be the same.
Plan : To extract the values in SAP and import it into P3e Activity Codes (Global) as values via a spreadsheet with the description as well.
Problem : Tried it before in Ver 4.1, could not find a way to do it. Now I have ver 5.0, still no idea. Only way so far is to input it one by one.
So any bright ideas ? enlighten me.
Thanking in advance.
1 reply
Oldest first- 0Azneil Abdul Malik ·Thanks, will try that.
With regards to excel imports, I have experienced that any new activity codes’ values created in excel, when imported into P3e 5.0, new values not in the library will not be accepted.
Unlike ver 3.1, where any new values are updated in the relevant activity codes library. Off course the description won’t be there, but at least the values are.
Thanks again.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?