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 Macros

3 replies [Last post]
Tue, 2018-12-18 21:55
Bogdan Leonte
User offline. Last seen 6 weeks 5 days ago. Offline
Joined: 18 Aug 2012
Posts: 284
Groups: Civil Engineering, Spider Project Team

Hello Vladimir,

in the latest versions of Spider Macros have been introduced as a new functionality. There are two types of macros:

  1. Internal, from what I understand these are macros applied at the project (file) level;
  2. External, from what I understant these are macros applied at the application level, for several projects (files).

Could you please elaborate more about them and maybe give us an example for both internal and external macros?

Best regards,
Bogdan

Top

Replies

Wed, 2018-12-19 20:12
#1
Vladimir Liberzon
User offline. Last seen 17 weeks 1 day ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)

It shall look like this:

<<ProjectFile = C:\Spider\arbat.201.sprj; // WBSCode = 1; // >> OpenFile (<<ProjectFile>>);//ProjCalcSchedRes ();//ProjCalcCost ();//Diagram (N);//ProjSetSpendRep (CODE : CostTotal, VER : 1);// ProjSetSpendRepCommon (CostTotal);// ProjMakeSpendRepWBS (<<WBSCode>>);//
Top
Wed, 2018-12-19 18:42
#2
Bogdan Leonte
User offline. Last seen 6 weeks 5 days ago. Offline
Joined: 18 Aug 2012
Posts: 284
Groups: Civil Engineering, Spider Project Team

It is indeed a large topic. I am familliar with scripts but I cannot say I know everything there is to know about Spiders script language, this is why I started this topic.

I will give your script a test using a project and see what happens.

Best Regards

Top
Wed, 2018-12-19 20:04
#3
Vladimir Liberzon
User offline. Last seen 17 weeks 1 day ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)

Bogdan,

this is a large topic. Spider Project includes script language that may be used for automating user actions, for launching Spider Project from the external source and doing required actions automatically, for integration with external software, etc.

An example of the script that will open Spider Project, open certain project (replace arbat.201.sprj with the path and file name of your project), calculate project schedule and budget and create total cost table report) is below:

<<ProjectFile = C:\Spider\arbat.201.sprj; // what project to openWBSCode = 1; // which WBS to select>> OpenFile (<<ProjectFile>>);// open projectProjCalcSchedRes ();// calculate scheduleProjCalcCost ();// calculate costsDiagram (N);// update diagramProjSetSpendRep (CODE : CostTotal, VER : 1);// select the reportProjSetSpendRepCommon (CostTotal);// Total Cost tableProjMakeSpendRepWBS (<<WBSCode>>);// Create the report You will need to save this text file with spsc extention and associate spsc extentions with Spider Project (default software). Then just run it.And yes, Spider can remember your actions for creating certain scripts automatically. So it may be a good start.
Top