Exporting the Calendars?

N
Nickie Lau 👤 Member for 22 years 3 months
M
Montasir Abdelhalim 👤 Member for 8 years 8 months

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? 

K
Kannan I 👤 Member for 16 years 5 months

If you have Primavera ERD database, you can get this details from ’Calendar’ table in ’workdayflag’ column.

M
MK TSE 👤 Member for 24 years 3 months

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

N
Nickie Lau 👤 Member for 22 years 3 months

Thanks Dieter, that might just work and keep them off my neck for the time being.

D
Dieter Wambach 👤 Member for 19 years 5 months

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

N
Nickie Lau 👤 Member for 22 years 3 months

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.

D
Dieter Wambach 👤 Member for 19 years 5 months

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

Forum Sponsor

Top Posters

sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
James Williams
74 posts