Has your question already been answered?

Get a quicker response; before you post, why not search to see if it has already been answered

P6 SDK: Activity6v6.xls work partially after to upgrade Primavera P6 8.3 to 8.3.15

7 replies [Last post]
Hello everyone:I have been working with the SDK in the P6 version 8.3, and I interacted without problems between the database and the SDK spreadsheets. After to upgrade to version 8.3.15 the spreadsheet Activity6v6.xls works partially: every time I try "Set Activity Relationships", I get the following error: "Row 3: Insert new TASKPRED: Values are required for lag_hr_cnt" for each of the activities that the project has. I have verified with previous projects where I have entered this information without problems and it gives me the same result, so I conclude that it is due to the upgrade made. Does anyone have any ideas? Thanks alexander

Replies

Zoltan Palffy
User offline. Last seen 17 hours 49 min ago. Offline
Joined: 13 Jul 2009
Posts: 1896

its a 2 step process 

1st import the activities then import the relationships DO NOT do both together because if the relationship that you are referencing is toward the bottom of the activity list it wil not have been imported yet so it cant find it to make the relationship.

Start with the Rawdata tab and populate that tab 

then go to the Main tab and create the activities then select Fill Activity Sheet

then select Fill Activiy Relationship Sheet

then save the file

import activities into P6

then import relationships into P6 

in the Rawdata tab in the relationship column is you have more than one predecessor relationship you can add a comma afte rthe 1st relationship and put in the 2nd relationship\

ie 1005,1010  FS,SS

 

 

Hi Zoltan, 

With the activity6v83.xls spreadsheet received and tried to work directly with the "Set Activity Relationships" option, getting the same error: "insert new TASKPRED ..."; but with the last sample file that you also sent me, I have been able to solve this problem by loading the relationship of the activities through the option to import into Primavera P6. Is it right?

Regards,

 

Zoltan Palffy
User offline. Last seen 17 hours 49 min ago. Offline
Joined: 13 Jul 2009
Posts: 1896

sent 

Hi, my email: alexandercc@outlook.com

thanks a lot and best regards

Zoltan Palffy
User offline. Last seen 17 hours 49 min ago. Offline
Joined: 13 Jul 2009
Posts: 1896

 tell me what you email address is and I will send it to you.

Hello Zoltan and thank you for your response. I have been using "activity.xls P6 R8.1". The R8.2 version is provided by Oracle Support?. I understand that these spreadsheets have no support today. I have searched other forum posts and have not found reference to this version. Please help me to get them. Thank you
Zoltan Palffy
User offline. Last seen 17 hours 49 min ago. Offline
Joined: 13 Jul 2009
Posts: 1896

you need the newer spreadsheet for version 8.2

if you just want to add activites lisiitng  the

activity id, wbs, original duration, remaining duration, activity name, predecessor ID #, realtion type and lag

I have another spreadsheet that DOES NOT require SDK and can be used with any version

if so tell me what you email address is and I wil send it to you.