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\
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 for16 years3 months
Submitted by Zoltan Palffy on Thu, 2018-08-09 14:01
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.
Member for
7 years 11 monthsHi Mohammed Ali, I sent you
Hi Mohammed Ali,
I sent you the verification code, please send me the product key. Mi email is alexandercc@outlook.com
Thanks
alexander
Member for
7 years 7 monthsFor all planners who are
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 monthsno problem
no problem
Member for
7 years 7 monthsHello Mr ZoltanI think there
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 monthsThe file that can be used
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
7 years 7 monthsHello Mr ZoltanPlease send me
Hello Mr Zoltan
Please send me a copy from this file.
This is my email address: esa32013@yahoo.com
Thank you in advance.
Member for
16 years 3 monthssend you what ?
send you what ?
Member for
16 years 3 monthsits a 2 step process 1st
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 monthsHi Zoltan, With the
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 monthssent
sent
Member for
7 years 11 monthsHi, my email:
Hi, my email: alexandercc@outlook.com
thanks a lot and best regards
Member for
16 years 3 monthstell me what you email
tell me what you email address is and I will send it to you.
Member for
16 years 3 monthsyou need the newer
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 monthsHello Zoltan and thank you