From wiki.ginstr.com
Revision as of 10:05, 7 March 2017 by Dejan (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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>

email

<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>