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

Submitted by Shander on
Oracle Primavera - PM6

Member for

7 years 7 months
Member for 7 years 7 months
Submitted by CCP Magic on Sat, 2018-10-13 04:11
Permalink

For all planners who are still using the 4 sdk files:

The activity file          <ACTIVITY6v83.xls>

The project file          <PROJECTv83.xls>

The dictionary file      <Dictionary6v7.xls>

The WBS file.            <WBS6v6.xls>

you can try this tool    http://www.mediafire.com/file/ougb7bfikqdae9n/PM_Advanced.xlsm/file

where this video explains exactly how you can use it   https://youtu.be/YjVqyzOCgSE

Member for

16 years 3 months
Member for 16 years 3 months
Submitted by Zoltan Palffy on Wed, 2018-10-03 15:01
Permalink

no problem

Member for

7 years 7 months
Member for 7 years 7 months
Submitted by CCP Magic on Wed, 2018-10-03 11:24
Permalink

Hello Mr Zoltan

I think there is a misunderstanding from my side.

I apologize and thank you for all of your efforts and time in this forum.

Member for

7 years 7 months
Member for 7 years 7 months
Submitted by CCP Magic on Wed, 2018-09-26 16:21
Permalink

The file that can be used instead of  <activity.xls P6 R8.1>

That is what you wrote:

<<<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. >>>   

Member for

16 years 3 months
Member for 16 years 3 months
Submitted by Zoltan Palffy on Mon, 2018-09-24 14:14
Permalink

send you what ?

Member for

16 years 3 months
Member for 16 years 3 months
Submitted by Zoltan Palffy on Mon, 2018-08-13 14:25
Permalink

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

 

 

Member for

7 years 11 months
Member for 7 years 11 months
Submitted by Shander on Thu, 2018-08-09 20:57
Permalink

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,

 

Member for

16 years 3 months
Member for 16 years 3 months
Submitted by Zoltan Palffy on Thu, 2018-08-09 14:01
Permalink

sent 

Member for

16 years 3 months
Member for 16 years 3 months
Submitted by Zoltan Palffy on Wed, 2018-08-08 13:29
Permalink

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

Member for

16 years 3 months
Member for 16 years 3 months
Submitted by Zoltan Palffy on Tue, 2018-08-07 14:41
Permalink

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.    

Member for

7 years 11 months
Member for 7 years 11 months
Submitted by Shander on Mon, 2018-08-06 20:59
Permalink

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