Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(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.

Spider Project Automation

No replies
Bogdan Leonte
User offline. Last seen 2 hours 52 min ago. Offline
Joined: 18 Aug 2012
Posts: 235


I am looking for a way to do update all material and resources costs on a weekly basis.

Here is what I am thinking:
01. Use a database (doesn't matter wich one) as long as it can export a simple text file. The database will store codes of materials/resources, description, unit of measure, cost/volume or cost/hour (in case of resources), date of costs. The costs can be taken from accounting of from quotations.
02. On the last day of the week/first day of the week the database will export the latest costs for all materials and resources in a text file to a certain location.
03. I want to have a macro (internal/external) which will be triggered when opening Spider Project (maybe run in the background) that will create a reference book for materials from that text file and overwrite the existing one. (I do not need to create a new version because I have the database that can give me history of costs).
04. The macro from 03. will open a certain project portfolio/s and transfer the reference book of materials to the portfolio, perform cost calculation, save project portfolio and distribute projects.
05. In the end the macro will end by closing Spider Project.

Is this possible?

Best regards,