Overview
This tool helps you quickly create solutions from spreadsheet files. The executable can be found in the following directory:
"<productPath>\fx-10\SolutionCreator.exe".
On this page:
Interface
Property | Description |
|---|---|
Solution Name | Choose the name of you solution. |
Output File Location | Choose in what path the solution will be created, if “New Folder” is checked it will create one folder to add your solution in. |
Product | Choose in what license the solution will be created. |
Platform | Define the target platform for your solution by selecting Windows or Multi-platform. |
Merge CSV Files | It enables to import the CSV files. If unchecked, it won't import anything from the files. |
Templates | Pre-built solution templates help you get started quickly. |
You can find additional details for most of the fields mentioned above in this page: Creating Solutions
Files accepted
To import data from spreadsheets, enable "Merge CSV Files" and select the folder containing the files.
The spreadsheets must have exactly these names (not all are required, but existing ones must match):
- UnsTags
- DevicesChannels
- DevicesNodes
- DevicesPoints
- DevicesAccesstypes
- UnstagProviders
You can download all spreadsheet templates above by exporting your existing solution or creating a new one. To export the spreadsheets, open your solution and click "Export Document" on the Top Main Toolbar. This will generate a .csv file that can be imported using this Solution Creator. You can find information about the Top Main Toolbar in: Designer (IDE Overview).
No User Interface
You have the option to don’t use the user interface to create the projects, follow how to use it:
1 - Create a .bat file with the content from step 2
2 - Content:
CD "<ProductPath>\fx-10"
"<ProductPath>\fx-10\SolutionCreator.exe" /logfile:"<logPath>\outputLog.log" /outputFileLocation:"<outputPath>" /solutionName:<projectName> /newFolder:<bool> /platform:<platform> /productFamily:<productFamily> /productModel:<productModel> /MergeCsvFiles:<bool> /pathCSVFiles:"<spreadsheetsPath>" /templateName:<projectTemplate>
Example tested and working:
CD "C:\Program Files (x86)\Tatsoft\00 - v10\FrameworX\fx-10"
"C:\Program Files (x86)\Tatsoft\00 - v10\FrameworX\fx-10\SolutionCreator.exe" /logfile:"C:\Users\eduar\Downloads\log1.log" /outputFileLocation:"C:\Users\eduar\Downloads" /solutionName:test1 /newFolder:true /platform:Multiplatform /productFamily:EdgeGateway /productModel:_1500_tags /MergeCsvFiles:true /pathCSVFiles:"C:\Users\eduar\Documents\03 - Tatsoft\05 - SolutionCreatorSpreadSheet\Folder1" /templateName:blank
where:
Parameter | Description |
|---|---|
/logfile | Specifies the path where the execution log file will be saved. Errors and success will be shown there |
/outputFileLocation | Defines the directory where the generated solution files will be saved |
/solutionName | Sets the name of the solution being created |
/newFolder | Indicates whether a new folder should be created for the solution |
/platform | Specifies the target platform for the solution |
/productFamily | Defines the product family used in the solution |
/productModel | Specifies the product model used in the solution |
/MergeCsvFiles | Determines if the CSV will be imported |
/pathCSVFiles | Specifies the path to the CSV files used for creating the solution |
/templateName | Sets the template that will be used to create the solution |
3 - Run the .bat file
In this section: