Skip to content

S-CURVE generation

D ArtagnanMember for 18 years
Created
175
13
0

I have made an ms access program that links the P6 database to excel. Right now, the excel file can generate s-curve and cash flow.

Anyone who’s interested please send me email at adiasanta@adcc.com.qa






 

175 replies

Oldest first
  1. 0
    R. Catalan ·
    D. Artagnan,

    Please send me the program at planning_me@yahoo.com

    Many thanks,
    R. Catalan
  2. 0
    Sujay Tawade ·
    hi,

    Can u send me the same at sujaynt@sify.com.

    Thanks alot in advance
  3. 0
    Anbin Ponnith ·
    Dear D.Artagnan,

    Thanks for the information and source provided by you.

    Its working for me.Really good stuff linking P6 with MS Access and Excel.

    Thanks a Lot

    Regards,

    Anbin Ponnith P
  4. 0
    D Artagnan ·
    I have also included columns for stored period quantities, so you can use them for the analysis.

  5. 0
    Ir. P. Jaya Chandar ·
    Dear Artagnan,

    Can you send to me also at chandar70@gmail.com.

    Thank you.


    Chandar
  6. 0
    Najib El Zoghbi ·
    Artagnan,

    Can you please send it to me as well at nzoghby@hotmail.com

    Thank you

    Najib
  7. 0
    Kaide Johar Manasi ·
    Dear Artagnan,

    Can you send to me also at johar_manasi@yahoo.com.

    Thank you in advance.


    Johar
  8. 0
    Hannes de Bruyne ·
    Hello D. Artagnan

    sounds great, could you please send me a copy to
    hannes.de-bruyne@arcor.de As I am working with suff like that as well, i’m very interested to see it

    Thanks
    Hannes
  9. 0
    D Artagnan ·
    Guys I have sent them already. I would really appreciate it if you’ll have some feedbacks.
  10. 0
    Aryan Yap ·
    Hi D Artagan,

    Can you also send me a copy at aryan063007@live.com

    Thanks in advance.

    Thank you & Best Regards,

    Aryan
  11. 0
    Kaide 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.
  12. 0
    Muhmad Elshaikh ·
    Dear Artagnan
    thank you for your cooperation soul
    can you please send to me on
    mohamedelshaikh_7@hotmail.com
  13. 0
    D Artagnan ·
    guys, i will send it tomorrow morning...

    To all who have downloaded the program, please send me feedback. Thanks.

    To anbin, thanks for the feedbacks.
  14. 0
    John Tao ·
    D. Artagnan,

    Please send me the program at johntao2006@hotmail.com

    Thanks A LOT!

    John
  15. 0
    Fayas Ahamed ·
    can you send me a copy.my id ms_fayas@yahoo.com
  16. 0
    D Artagnan ·
    Already sent to your mailboxes guys. I hope to get some feedback.
  17. 0
    Hannes de Bruyne ·
    Hello d Artagnan


    thank you for sending first impression is very good, but I have a problem: after opening, I get the error as descriped, but your solution does not help me. The menu-item tools-> database Utilities is not available at this stage yet...

    Hannes
  18. 0
    Alaa Al haj ·
    HI
    WHERE CAN I FIND TOOLS AND OPTION TO CHANGE ON ACTIVITY USAGE PROFILE LIKE CHANGE MAXIMUN VALUE ON VERTICAL AXIX ANSD SO ON


    THANKS
    ALAA
  19. 0
    D Artagnan ·
    You are talking about the excel sheet right? These are just a matter of the chart tools. Right click on the chart and see all the options.
  20. 0
    D Artagnan ·
    To Hannes: I’ve sent you another file. I think the one that I sent you is locked for Windows XP. I sent you the file which you can edit the map of the database
  21. 0
    Mimoune Djouallah ·
    men too please my email is djouallah_mimoune at yahoo dot com

    thanks very much
  22. 0
    Alaa Al haj ·
    HI Artagnan

    THANKS
    BUT I MEAN IN PRIMAVERA P6

    YOURS
    ALAA
  23. 0
    Wungyea Lee ·
    Like to get one and do the try, please send to wungyea@mail.nsysu.edu.tw, thank you!
  24. 0
    D Artagnan ·
    @wungyea

    sent you already. Hope to get some feedback.

    @alaa

    i tried to find out but i couldnt. perhaps Arnold Puy could help you.
  25. 0
    Mimoune 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
  26. 0
    D 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.
  27. 0
    Hany Esmael ·

    Hello D Artagnan

    please send me a copy of your file

    hany_c_v@yahoo.com

    Best regards,
  28. 0
    Hannes de Bruyne ·
    D Artagnan

    Thank you for the new file. Is "TASK_SPREADS" an existing Table or a view or a self generated table? I’m always looking for a table like this, but just cannot find it.

  29. 0
    Mimoune 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
  30. 0
    D Artagnan ·
    @mimoune

    you are right. you can only access task_spreads from the SDK.
  31. 0
    Ir. 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.
  32. 0
    D Artagnan ·
    no worries Jaya. I am so glad that finally, after several days of figuring out how to make it work in your computer, we were able to make it run. I will make a documentation for vista users this week if i will have some spare time.

    cheers.
  33. 0
    Amr Diab ·
    D. Artagnan,

    Please send me the program at totti4899@hotmail.com

    Many thanks,
    A.Diab
  34. 0
    D Artagnan ·
    Already sent Amr.
  35. 0
    Rola Sabbah ·
    hi there
    i would appriciate if you would send me a copy on rolfunnytears86@yahoo.com
  36. 0
    Abdul Khadeer ·
    Please send me a copy to maksabic@gmail.com

    Appreciate

    thanks
  37. 0
    D Artagnan ·
    sent you guys!

    however, i am still expecting some feedback...

    :(
  38. 0
    Rola Sabbah ·
    Sorry but i didn’t get it, could you please send it again to rolfunnytears86@yahoo.com
  39. 0
    Wilfredo Jr. Flores ·
    hi dear friends, can u please send me a copy of it.
    jamiroquai_29@yahoo.com
    im also using windows 7
    thanks.
  40. 0
    Wilfredo Jr. Flores ·
    hi dear friends, can u please send me a copy of it.
    jamiroquai_29@yahoo.com
    im also using windows 7
    thanks.
  41. 0
    Amreshwar Shukla ·
    D. Artagnan,

    Please send me the program at shukla456@gmail.com

    Many thanks,
    A.S.Shukla
  42. 0
    D Artagnan ·
    already sent guys.
  43. 0
    Akhtar Khan ·
    Please send me file

    akhtar@taisei.ae
  44. 0
    D Artagnan ·
    sent to you guys.

    Could you send me some feedbacks please...I would really appreciate it.
  45. 0
    Ahamed Jameel ·
    hai,

    Please sent the S-curve program to jameel499@yahoo.co.in

    Thanks

    Jameel
  46. 0
    Benedict Gono ·
    I am interested to have a copy of the S-Curve for the P6.

    Please send it to ebpgono@yahoo.com


    Thanks
  47. 0
    Cornelis van Klaveren ·
    I am interested to have a copy of the S-Curve for the P6.

    Please send it to cornelis.vanklaveren@sbmoffshore.com


    Thanks and regards Cornelis
  48. 0
    Ananda Vijayan ·
    Hi friend,

    Can you please sent me a copy? My email id is "anandavijayan@gmail.com"

    Thanks & Regards,

    VJ
    Qatar
  49. 0
    D Artagnan ·
    sent to you guys...

    Please post some feedbacks
  50. 0
    Sachin 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?