What is the best way to clean up the resource library? I need to identify all the unused resources first. Is it possible without opening all the projects at once?
Best way to identify unused resources in the resource library
Forum Sponsor
Top Posters
Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Dear Andrew,
Appreciate if you send your mentioned tool also to my email: [email protected]
I have same problem and confused how to do clean up in thousand resources that we have in our database.
Bests,
Hai Andrew
Thanks . I have mail the Sql_Instances.txt file to yahoo id
Hai Rafeel
Thanks . I have download the trial version . I will Try
Regards
Mani
Hi Mani.
I'm not sure if your system's parameters are ok to run this macro.
Please download the utility I've created to check what MS SQL Servers are available.
http://dl.dropbox.com/u/41981125/SQLServers.exe
It's not a virus. After execution - it will create file Sql_Instances.txt. If you can send this file to my email
[email protected]
I will correct my macro excel accordingly and send it back to you.
Thanks,
Andrew
http://www.acceleratedpm.com/xena-administrator
http://www.acceleratedpm.com/xena-primavera-configuration-utility
What a mess!
Hai Andrew
Can you mail me the Macro File To my mail id
[email protected]
Thanks
Mani
It can be done through direct connection to Primavera DB. I wrote excel VBA macro to do this. The point is to open recordset RSRC then check for occurrences of [rsrc_id] in the linked tables which are as per PMDB0601 schema:
DOCUMENT
PREFER
PROJEST
PROJISSU
PROJRISK
RSRCHOUR
RSRCPROP
RSRCRATE
RSRCRCAT
RSRCROLE
RSRCSEC
RSRFOLIO
TASK
TASKRSRC
TIMESHT
TRSRCSUM
TRSRCSUMFN
WBSRSRC
Those ones which don't assigned in any of the above mentioned tables can be safely removed from resources dictionary.
That's all.
Regards,
Andrew
It can be done through direct connection to Primavera DB. I wrote excel VBA macro to do this. The point is to open recordset RSRC then check for occurrences of [rsrc_id] in the linked tables which are as per PMDB0601 schema:
DOCUMENT
PREFER
PROJEST
PROJISSU
PROJRISK
RSRCHOUR
RSRCPROP
RSRCRATE
RSRCRCAT
RSRCROLE
RSRCSEC
RSRFOLIO
TASK
TASKRSRC
TIMESHT
TRSRCSUM
TRSRCSUMFN
WBSRSRC
Those ones which don't assigned in any of the above mentioned tables can be safely removed from resources dictionary.
That's all.
Regards,
Andrew