Skip to content

Exporting the Calendars?

Nickie LauMember for 22 years 7 months
Created
8
6
0
Is it possible to export the calendars into MSExcel or something? I am pretty new to this software and it’s driving me up the wall!

8 replies

Oldest first
  1. 0
    Dieter Wambach ·
    Nickie

    Within the Primavera database calendars are a binary block - not accessible with standard tools. I’ve heard that the API can read and transform it. But neither I’m sure nor a programmer.

    Tell what are your needs. Maybe somebody will know a work-around.

    Good luck

    Dieter
  2. 0
    Nickie Lau ·
    Actually I just wanted to have a list of non-working days for each different calendar in my programme,

    That way others without the knowledge of the software (like the client’s representative) would know why certain activities have short duration but long looking bars.
  3. 0
    Dieter Wambach ·
    Nickie

    Thank you for reply.

    A work-around may be: Testproject --> one activity per calendar - with duration=1 year - you want to show with that specific calendar assigned. Set timescale (Gantt chart) to week and day; bars: Neck for non-working time. Then either show/print the Gantt chart with those activities or create a report and export to EXCEL.

    Dieter
  4. 0
    Nickie Lau ·
    Thanks Dieter, that might just work and keep them off my neck for the time being.
  5. 0
    Mk Tse ·
    Further to Dieter’s proposed, assign a resource in 1 unit per day to that activity.
    Then export the resource assignment per day (by change the time sclae into day) on excel, the "zero" value will be non-working day.

    This easy than to ’examine’ where the necking on a bar for me. On spreadsheet, we can filter those "zero" value out quick
  6. 0
    Nickie Lau ·
    thanks for the advise, this has been great help!
  7. 0
    Kannan I ·
    If you have Primavera ERD database, you can get this details from ’Calendar’ table in ’workdayflag’ column.
  8. 0
    Montasir Abdelhalim ·

    Dears,  I would like to know

    Dears, 

     I would like to know , based on the assigned calendar, how many days (duration)  passed since BL start date till data date? is there any easy way to get this AT WBS LEVEL? 

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?