(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
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?
Printer-friendly version
Send to friend
Dear Andrew,
Appreciate if you send your mentioned tool also to my email: m.hosseini@yahoo.com
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
I will correct my macro excel accordingly and send it back to you.
Thanks,
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
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
Email: PPadmin@planningplanet.com
Replies