Spider Macros

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

V
Vladimir Liberzon 👤 Member for 25 years 4 months

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>>);//
B
Bogdan Leonte 👤 Member for 13 years 9 months

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

V
Vladimir Liberzon 👤 Member for 25 years 4 months

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 open
WBSCode = 1; // which WBS to select
>>
 
OpenFile (<<ProjectFile>>);// open project
ProjCalcSchedRes ();// calculate schedule
ProjCalcCost ();// calculate costs
Diagram (N);// update diagram
ProjSetSpendRep (CODE : CostTotal, VER : 1);// select the report
ProjSetSpendRepCommon (CostTotal);// Total Cost table
ProjMakeSpendRepWBS (<<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.

Forum Sponsor

Top Posters

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
Simon Gumede
0 posts