Hello,
I have a SQL database where we register data for different customers (and each customer has many tools).
I am in the process to create an automatic reports to monitor the tools performance from the SQL DB.
For one customer, I have a long script working (one long JSL) that connect to the SQL, run a query, save the table from the query, then modify/filter the table to get the data I need, then draw a few charts and save the results in a specific locations.
In order to make it more simple to use, for maintenance and upgrade, I would like create different JSL scripts and use the Customer_Tool_Info.txt file ( see example attached in the Zip file) as a configuration file.
As we have a lot of customers then I could simply use a For loop using this config file to create all the reports we need.
The Customer_Tool_Info.txt contains information for customer, tools and the infos for the ODBC connection.
What I would like is to have the main script to open the Customer_Tool_Info.txt and extract the needed infos and pass them as arguments for the other sub-scripts.
- Main_script.jsl ( Get the arguments to pass to the Sub-scripts)
- Sub-scripts :
- Get_Data_from SQL.jmpquery
- FIlter_the_Table.jsl
- Get_Charts.jsl
Is it possible to pass arguments into different jsl scripts ? how? I tried in the Main_Script.jsl to explain all I want to do.
Please let me know if you have any questions and thank you for your help.
Regards
Geof
