Import/export rules ginstr web
Format of data values per datatype
text, enum
<value>Text value</value>
iBeacon
<value>ff:ff:ff:ff:ff:ff</value>
status
<value>true</value>
allowed: true, false
number, dateTimeDiff
<value>10.36</value>
weekday
<list> <value>monday</value> <value>thursday</value> </list>
Allowed values: "monday", "tuesday", "wednesday", "thursday", "friday", "saturday", "sunday"
time
<value>10:30:00</value>
Time format: HH:mm:ss
date
<value>2016-10-30</value>
Date format: yyyy-MM-dd
dateTime
<value>2016-10-30T10:30:00+01:00</value>
DateTime format: yyyy-MM-dd'T'HH:mm:ssZZ
listOfTimes
<list> <value>10:30:00</value> <value>12:45:00</value> </list>
Time format: HH:mm:ss
listOfDates
<list> <value>2016-10-30</value> <value>2017-01-03</value> </list>
Date format: yyyy-MM-dd
listOfDateTimes
<list> <value>2016-10-30T10:30:00+01:00</value> <value>2017-01-03T10:30:00+01:00</value> </list>
DateTime format: yyyy-MM-dd'T'HH:mm:ssZZ
phone
<list> <phone> <name>Contact name 1</name> <phone>+325671265442</phone> <info>Example phone</info> </phone> <phone> <name>Contact name 2</name> <phone>+325671265443</phone> <info>Example phone</info> </phone> </list>
<list> <email> <name>Contact name 1</name> <email>john@gmail.com</email> </email> <email> <name>Contact name 2</name> <email>jane@gmail.com</email> </email> </list>
gps
<value>10.36,20.23644</value>
attachments
<list> <value>image1.jpg</value> </list>
or
<list> <value>https://my.ginstr.com/api/attachment/rowId/attachmentId</value> </list>
pointer
<ref id="rowId"> <value>cell value</value> </ref>
assignment
<list> <ref id="row1Id"> <value>cell value1</value> </ref> <ref id="row2Id"/> <value>cell value2</value> </ref> </list>
counter
<value>1</value>
Export
Export data from ginstr web exports data into a file or group of files.
Exporting file example
<tables> <table> <name>employees</name> <application>fair parken manager plus</application> <header> <column id="column1">first name</column> <!-- text --> <column id="column2">last name</column> <!-- text --> <column id="column3">manager</column> <!-- pointer --> </header> <rows> <row id="employee1"> <column id="column1"> <value>John</value> </column> <column id="column2"> <value>Smith</value> </column> <column id="column3"/> </row> <row id="employee2"> <column id="column1"> <value>Jordan</value> </column> <column id="column2"> <value>Smith</value> </column> <column id="column3"> <ref id="employee1"/> </column> </row> </rows> </table> </tables>