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.

Columns for import to P6

7 replies [Last post]
Parisa Mohsenizadeh
User offline. Last seen 3 days 10 hours ago. Offline
Joined: 29 Apr 2019
Posts: 5
Groups: None

Hello everyone,

I have a question; Is it possible to import columns with (*) to P6? I mean columns such as "Physical % Complete" or "Budgeted labor unit".

Thanks in advance

Replies

Parisa Mohsenizadeh
User offline. Last seen 3 days 10 hours ago. Offline
Joined: 29 Apr 2019
Posts: 5
Groups: None

Hello Steven,

Excuse me because of not making my question as clear as possible. Actually, I need columns such as budgeted labor unit in Primavera Risk Analysis but the problem is that I have the related information in an Excel file so first I should export from P6 into excel and match the info and then import it in P6 in order to have the columns such as budgeted labor unit in my P6 file. Then it will be ready to import the Xer file into Primavera Risk Analysis, but the problem is that columns such as budgeted labor unit have (*) in exported excel file so it is impossible to put info in them and then import it again in P6. I also have tried a user defiened field (UDF) for making a global change in P6 for budgeted labor unit column but that didn't work too. Is there any work around?

Thanks in advance

Steven Auld
User offline. Last seen 14 hours 29 min ago. Offline
Joined: 13 Sep 2017
Posts: 105
If you are importing into Primavera Risk, why are you using the excel import instead of just importing the xer file?

You may have to open the xer file in notepad first to change the P6 version if you are using a version that is not compatible with Primavera Risk.

Steven

Parisa Mohsenizadeh
User offline. Last seen 3 days 10 hours ago. Offline
Joined: 29 Apr 2019
Posts: 5
Groups: None

Hi,

Actually I want to use the Xer File of P6 in order to import it in Primavera Risk Analysis, so I need this information to be in the related columns but due to they have (*) when exporting to excel I can't put the needed information in these columns. Also I couldn't use global change in order to match these columns with the user defined field. Do you have any idea regard this problem?

Thanks in advance 

Zoltan Palffy
User offline. Last seen 1 day 10 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2263
Groups: None

whats the problem they are importable ?

Parisa Mohsenizadeh
User offline. Last seen 3 days 10 hours ago. Offline
Joined: 29 Apr 2019
Posts: 5
Groups: None

Hello,

Actually I have problem for using global change for columns such as "Budgeted Labor Unit", "Actual Labor Unit" and "Remaining Labor Unit". Is it possible for you to help me in this regard?

Thank you

Zoltan Palffy
User offline. Last seen 1 day 10 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2263
Groups: None

yes Budgeted unist is importable any coulmns are what you do is create a work around

create a udf (uder defined field) and make the field TYPE the same TYPE as the column that you cannot import

Then import that UDF

Now run a gloabl change where  the Column that is not importable equals the udf

I do this if I need to import expected fnish dates which are not importabale 

There is alwasy a work around 

Santosh Bhat
User offline. Last seen 9 hours 2 min ago. Offline
Joined: 15 Apr 2005
Posts: 192

No, fields with an asterix are calculated fields within P6 and cannot be imported.