The swExport tool can be used to export a SystemWeaver Grid to MS Excel. Using this tool, you can implement your own application that can utilize the swExport.exe for grid export based on your organization's needs. To obtain the tool, contact your internal IT department or [email protected].
Prerequisites
- A configurable grid to export
- SystemWeaver version Bagaregården (R42) or later
- An installation of swExport
Required Meta Model
Grid export has no required meta model, or item structure. It is suitable for all configurable grid use cases.
Explanation of Settings
| Parameter | Definition | Expected value type | Comment | Example |
| serverName | The name or IP address of SystemWeaver server | String | Required | serverName=localhost |
| serverPort | Tthe port of SystemWeaver server | Integer | Required | serverPort=1768 |
| serverUsername | The SystemWeaver username to connect with. | String | If not supplied, Windows authentication will be used. | serverUsername=user |
| serverPassword | The SystemWeaver password for the provided username | String | If not supplied, Windows authentication will be used. | serverPassword=pass |
| type | Specifies export of a configurable Grid | grid | Required | type=grid |
| itemID | The xID of the item | SystemWeaver xID | Required | itemID=x0000001D04533514 |
| configItem | The configuration to be executed | Config item xID or Ref id* | Required | configItem=SREL:Release_Summary configItem=x34000000000A384D |
| parameter | To specify a parameter name and selected value | Parameter name, and item xID and value | Optional | parameter="(p0;x04000000000F3AD1)" parameter"(p1;false)" |
| filename | The name of the xlsx output file. If path is not included, file will generate in same location as executable. | String | Required | filename="C:\Work\ECU_allocation.xlsx“ |
* The difference between the two is explained in Referencing Latest vs Specific Version of Config Item View.
** Note that if you hardcode the name and do several exports, older output will be replaced. To keep the old files, make the name dynamic, e.g., Name + TimeOfExport.
The above settings can also be found in the application help:
Example Command Lines
Using Username and Password
Using Network Authentication
This command will log in the user account to the server, build and export the grid, and then log out. 
Example Result
Known Behavior
- No support for handling Parameters in release R42
- Export is of plain text only, just as it is with the Export to Excel operation in the client