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 support@systemweaver.com.


Prerequisites


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

ParameterDefinition
Expected value typeCommentExample
serverName
The name or IP address of SystemWeaver server
String
Required
serverName=localhost
serverPortTthe port of SystemWeaver server
IntegerRequiredserverPort=1768
serverUserNameThe SystemWeaver username to connect with.
StringIf not supplied, Windows authentication will be used.serverUserName=user
serverPasswordThe SystemWeaver password to connect with.
StringIf not supplied, Windows authentication will be used.serverPassword=pass
type
Specifies export is of a configurable Grid
gridRequired
type=grid
itemID
The xID of the Document 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
parameterTo specify a parameter name and selected valueParameter name, and item xID and valueOptionalparameter="(p0;x04000000000F3AD1)" parameter"(p1;false)"
fileNameThe name of the XLSX output file.StringRequired 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.


Example Command Lines

Using Username and Password

swExport serverName=sys7 serverPort=1345 serverUserName=john.doe serverPassword=test type="grid" itemID=x04000000000C5AD4 configItem=BIVD:ECU fileName="C:\Work\ECU_allocation.xlsx"
Generic

Using Network Authentication

swExport serverName=sys7 serverPort=1345 type="grid" itemID=x04000000000C5AD4 configItem=BIVD:ECU fileName="C:\Work\ECU_allocation.xlsx"
Generic


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