From wiki.ginstr.com
Jump to: navigation, search
m (formatting)
 
Line 7: Line 7:
 
:This file contains all data which is imported into database once the tables for specific app are generated.
 
:This file contains all data which is imported into database once the tables for specific app are generated.
 
:Even the user can define data.xml for all supported languages, only data for language which is selected in ginstr web will be imported.
 
:Even the user can define data.xml for all supported languages, only data for language which is selected in ginstr web will be imported.
:If data.xml file is missing for specific language, data.xml from '''app/values/''' dir will be used.
+
:If '''data.xml''' file is missing for specific language, data.xml from '''app/values/''' dir will be used.
  
 
===<code><tables></code> node===
 
===<code><tables></code> node===
Line 21: Line 21:
 
! scope="col" | Description
 
! scope="col" | Description
 
|-
 
|-
| title="Attribute" | name
+
| title="Attribute" | <code>name</code>
 
| title="Description" | table name
 
| title="Description" | table name
 
|-
 
|-
| title="Attribute" | application
+
| title="Attribute" | <code>application</code>
 
| title="Description" | application name
 
| title="Description" | application name
 
|}
 
|}
Line 52: Line 52:
 
! scope="col" | Description
 
! scope="col" | Description
 
|-
 
|-
| title="Attribute" | id
+
| title="Attribute" | <code>id</code>
 
| title="Description" | row id
 
| title="Description" | row id
 
|-
 
|-
| title="Attribute" | created
+
| title="Attribute" | <code>created</code>
 
| title="Description" | datetime of creation
 
| title="Description" | datetime of creation
 
|}
 
|}
Line 69: Line 69:
 
! scope="col" | Description
 
! scope="col" | Description
 
|-
 
|-
| title="Attribute" | id
+
| title="Attribute" | <code>id</code>
 
| title="Description" | column id
 
| title="Description" | column id
 
|}
 
|}

Latest revision as of 20:44, 12 July 2017

data.xml

data.xml is an XML file located in app/values-XX/ folders.
This file contains all data which is imported into database once the tables for specific app are generated.
Even the user can define data.xml for all supported languages, only data for language which is selected in ginstr web will be imported.
If data.xml file is missing for specific language, data.xml from app/values/ dir will be used.

<tables> node

This node contains a list of all tables where data will be imported

<table> node

This node contains table name and all rows and column values for specific table which will be imported

XML Attributes Description

Attribute Description
name table name
application application name

<header> node

This node contains columns with customized names

Example

<header>
  <column id="column1">first name</column> <!-- text -->
  <column id="column2">last name</column> <!-- text -->
  <column id="column3">manager</column> <!-- pointer -->
</header>

<rows> node

This node contains all rows and column values for specific table which will be imported

<row> node

This node contains all column values for specific row which will be imported

XML Attributes Description

Attribute Description
id row id
created datetime of creation

<column> node

This node contains value for specific column
Column value definitions can be found here

XML Attributes Description

Attribute Description
id column id

Example

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<tables>
    <table>
        <name>buildingZones</name>
        <rows>
            <row id="8bd2373e7a35204b4f76084285e8b665">
                <column id="buildingZone_name">
                    <value>Sonderausstattungen Gebäude</value>
                </column>
                <column id="buildingZone_comments"/>
            </row>
            <row id="7a93858ca7d9d11d70aafbd87250e746">
                <column id="buildingZone_name">
                    <value>Ver- und Entsorgung</value>
                </column>
                <column id="buildingZone_comments"/>
            </row>
        </rows>
    </table>
    <table>
        <name>emailRecipients</name>
        <rows>
            <row>
                <column id="emailRecipient_email">
                    <list>
                        <email>
                            <name>hopp@riebeling.eu</name>
                            <email>test1@dev.com</email>
                        </email>
                    </list>
                </column>
                <column id="emailRecipient_firstName">
                    <value>Melanie</value>
                </column>
                <column id="emailRecipient_lastName">
                    <value>Hopp</value>
                </column>
                <column id="emailRecipient_comments">
                    <value>RA/WEG</value>
                </column>
            </row>
            <row>
                <column id="emailRecipient_email">
                    <list>
                        <email>
                            <name>zeymichael.studiom2@gmx.de</name>
                            <email>test8@dev.com</email>
                        </email>
                    </list>
                </column>
                <column id="emailRecipient_firstName">
                    <value>Michael</value>
                </column>
                <column id="emailRecipient_lastName">
                    <value>Zey</value>
                </column>
                <column id="emailRecipient_comments">
                    <value>IVR FM GmbH</value>
                </column>
            </row>
        </rows>
    </table>
    <table>
        <name>facilities</name>
        <rows>
            <row id="fe7a5736b4c750de8ca2e26428cd91fe">
                <column id="facility_name">
                    <value>0995 - Mälzereiweg 8 + 10</value>
                </column>
                <column id="facility_comments"/>
            </row>
            <row id="f2d4b8d292682da8a615bcfcc4a9bf92">
                <column id="facility_name">
                    <value>5040 - Mohnweg 7-21</value>
                </column>
                <column id="facility_comments"/>
            </row>
        </rows>
    </table>
    <table>
        <name>floors</name>
        <rows>
            <row id="ff4c80b716db3489d7ef2b3cf9183e47">
                <column id="floor_name">
                    <value>+02</value>
                </column>
                <column id="floor_comments"/>
            </row>
            <row id="f1ae2e52a9c45ba96dd62f349409c46d">
                <column id="floor_name">
                    <value>000</value>
                </column>
                <column id="floor_comments"/>
            </row>
        </rows>
    </table>
    <table>
        <name>employees</name>
        <rows>
            <row id="d6df4f64df8578eadb74936330925cdd">
                <column id="employee_matchcode">
                    <value>ClaudiaBauer</value>
                </column>
                <column id="employee_SSOusername">
                    <list>
                        <email>
                            <name>bauer@riebeling.eu</name>
                            <email>test29@dev.com</email>
                        </email>
                    </list>
                </column>
                <column id="employee_NFCtag">
                    <value>041B7E5A3F2B06</value>
                </column>
                <column id="employee_firstName">
                    <value>Claudia</value>
                </column>
                <column id="employee_lastName">
                    <value>Bauer</value>
                </column>
                <column id="employee_SEV">
                    <value>true</value>
                </column>
                <column id="employee_facility">
                    <value>true</value>
                </column>
                <column id="employee_MW">
                    <value>true</value>
                </column>
                <column id="employee_comments">
                    <value>Leitung WEG</value>
                </column>
            </row>
            <row id="c8f7f2112fef26b607f78985fb1fc9f2">
                <column id="employee_matchcode">
                    <value>GabrieleMeier-Lieb</value>
                </column>
                <column id="employee_SSOusername">
                    <list>
                        <email>
                            <name>meier-lieb@riebeling.eu</name>
                            <email>test5@dev.com</email>
                        </email>
                    </list>
                </column>
                <column id="employee_NFCtag">
                    <value>041B7E5A3F2A02</value>
                </column>
                <column id="employee_firstName">
                    <value>Gabriele</value>
                </column>
                <column id="employee_lastName">
                    <value>Meier-Lieb</value>
                </column>
                <column id="employee_SEV">
                    <value>false</value>
                </column>
                <column id="employee_facility">
                    <value>false</value>
                </column>
                <column id="employee_MW">
                    <value>false</value>
                </column>
                <column id="employee_comments">
                    <value>Buchhalterin</value>
                </column>
            </row>
        </rows>
    </table>
</tables>