AutoXchange 2024 Technical Documentation

MySQL Parameters

The following parameters define the methods for storing data in MySQL databases. Other databases can be supported, but the default is MySQL.

MYSQL Parameters
MSPORT MySQL Port
MSUSER MySQL User
MSPWD MySQL Password for the user
MSUSERN[AME] Name to use as ID in Users Table
MSEMAIL Email address to use in Users Table
MSORG[ANIZATION] Organization to use in Users Table
MSDATA[BASE] MySQL database name
MSUSERT[ABLE] Name of MySQL Users Table
MSDRAW[ING] Name of MySQL Drawing Table
MSLAYER[S] Name of MySQL Layers Table
MSLAYO[UTS] Name of MySQL Layouts Table
MSTEXT Name of MySQL Text Items Table
MSBLOCK[S] Name of MySQL Blocks Table
MSATTRIB[UTES] Name of MySQL Attributes Table

MySQL Port

PARAMETER MSPORT
Purpose This parameter specifies the port to be used for the MySQL connection. It is a string value that normally contains a URL and Port Number, separated by a colon. This parameter can also be defined by the $MYSQL_PORT Environment Variable on both Windows and Linux.
Example -MSPORT=“127.168.1.1:3306”
JSON {“MSPORT”:“127.168.1.1:3306}
Use With SVG Only

MySQL User

PARAMETER MyUser
Purpose This parameter specifies MySQL User to be used. This parameter can also be defined by the $MYSQL_USER Environment Variable on both Windows and Linux.
Example -MSUSER=scott
JSON {“MSUSER”: “scott”}
Use With SVG Only

MySQL Password

PARAMETER MSPWD
Purpose This parameter specifies MySQL Password for the User defined above. This parameter can also be defined by the $MYSQL_PWD Environment Variable on both Windows and Linux.
Example -MSPWD=ABC123
JSON {“MSPWD”: “ABC123”}
Use With SVG Only

MySQL User Name

PARAMETER MSUSERNAME
Purpose This parameter specifies User Name to be used as part of the ID in the Users Table. It combines with MSEMAIL and MSORG to identify a unique user. It can be blank, in which case the default User will be used.
Example -MSUSERNAME=“Harry Tomlinson”
JSON {“MSUSERN”: “Harry Tomlinson”}
Use With SVG Only

MySQL User Email

PARAMETER MSEMAIL
Purpose This parameter specifies Email Address to be used as part of the ID in the Users Table. It combines with MSUSERNAME and MSORG to identify a unique user. It can be blank, in which case the default User will be used.
Example -MSEMAIL=“harry@somewhere.com
JSON {“MSEMAIL”: “harry@somewhere.com”}
Use With SVG Only

MySQL User Organization

PARAMETER MSORGANIZATION
Purpose This parameter specifies User Organization to be used as part of the ID in the Users Table. It combines with MSUSERNAME and MSEMAIL to identify a unique user. It can be blank, in which case the default User will be used.
Example -MSORGANIZATION=“Logistics”
JSON {“MSORG”: “Accounting”}
Use With SVG Only

MySQL Database

PARAMETER MSDATABASE
Purpose This parameter specifies MySQL Database (Source) to be used.
Example -MSDATA=Drawing
JSON {“MSDATA”: “Drawing”}
Use With SVG Only

MySQL User Table

PARAMETER MSUSERTABLE
Purpose This parameter specifies the name of the MySQL Users Table to be used.
Example -MSUSERTABLE=Users
JSON {“MSUSERT”: “Users”}
Default users
Use With SVG Only

MySQL Drawing

PARAMETER MSDRAWING
Purpose This parameter specifies the name of the MySQL Drawing Table to be used.
Example -MSDRAWING=Drawings
JSON {“MSDRAW”: “Drawings”}
Default drawings
Use With SVG Only

MySQL Layers

PARAMETER MSLAYERS
Purpose This parameter specifies the name of the MySQL Layers Table to be used.
Example -MSLAYERS=MyLayers
JSON {“MSLAYERS”: “MyLayers”}
Default layers
Use With SVG Only

MySQL Layouts

PARAMETER MSLAYERS
Purpose This parameter specifies the name of the MySQL Layouts Table to be used.
Example -MSLAYO=MyLayouts
JSON {“MSLAYOUTS”: “MyLayouts”}
Default layouts
Use With SVG Only

MySQL Text Items

PARAMETER MSTEXT
Purpose This parameter specifies the name of the MySQL Text Items Table to be used.
Example -MSTEXT=MyText
JSON {“MSTEXT”: “MyText”}
Default textitems
Use With SVG Only

MySQL Blocks

PARAMETER MSBLOCKS
Purpose This parameter specifies the name of the MySQL Blocks Table to be used.
Example -MSBLOCKS=Lego
JSON {“MSBLOCKS”: “MyBlocks”}
Default blocks
Use With SVG Only

MySQL Attributes

PARAMETER MSATTRIBUTES
Purpose This parameter specifies the name of the MySQL Attributes Table to be used.
Example -MSATTRIB=MyAttributes
JSON {“MSATTRIBUTES”: “MyAttributes”}
Default attributes
Use With SVG Only
Last updated on 30 Jul 2022
Published on 10 Jul 2022