S-CURVE generation
In the Open Standard
DA
D ArtagnanMember for 18 years
- Created
- 175
- 13
0
175 replies
Oldest first- 0KJKaide Johar Manasi ·Working with Windows Vista SP1, MS Office 2007, Primavera 6.2.1 with SDK. Moved the mdb file to C: also.
Well the tables got connected but macros in Access return following error.
Read Only : Database has been opened read only.you can only change data in linked tables.To make design change, save a copy of database.
After extracting when you want to update either S curve or Resource, again error pops up, it says "Could not delete from Specified tables"
Where am I wrong, any help will be highly appreciated. - 0MDMimoune Djouallah ·thanks very much mr D Artagnan, that’s a beautiful solution.
the best part,when you put the access database in a shared folder, everybody can have access to the updated report without the need to have an " expensive" license of P6. after all people only wants reports.
only one small comment, is it really necessary to have the vba code and 2007 file format !!
thanks again for your work.
mimoune - 0DAD Artagnan ·@mimoune
the access can be open in 2003 and 2007 however, excel should be in 2007 because pivot charting in 2003 is not as flexible as the former. You are right, when you put the access in the shared folder and remap the excel file connection, you can have several excel files which will extract the same data.
It’s good to know you worked it out. - 0MDMimoune Djouallah ·Hannes, it seems we were in the same situation;)
those table are only included when you access P6 by sdk connection, if you access P6 directly you will not find them
check this link
http://ftp.primavera.com/docs/6.1/Technical/SDK/index.html
and spread tables
http://ftp.primavera.com/docs/6.1/Technical/SDK/SpreadTables&Fields.htm
mimoune - 0IPIr. P. Jaya Chandar ·Hi Adrianne,
Million thanks to you for your seamless help in solving the problems I had with the files to generate S-Curve. The files are working fine with my VISTA system now. I have managed to
import data from Primavera to Access and run the macro.
The output in excel sheet is just that i needed so much.
Thanks for your good work buddy. - 0SSSachin Sangai ·Hi Artgnan
Even i would like to have that program. Please if you could mail me at sachinsangai@yahoo.co.in.
I don’t know if it is right to ask before i see this program what is the diff between this and PATTLNK_632006_536-xerFileParser&Builder.xls.
The problem is i have not worked with SDK and don’t have any idea about it.. :(
Sachin
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?

