[glom] Translations: Prefer non-country-specific locales, such as de.



commit 6ea1670e5a41b483804204ed5bb52b9ec917d969
Author: Murray Cumming <murrayc murrayc com>
Date:   Mon Jan 9 23:45:46 2012 +0100

    Translations: Prefer non-country-specific locales, such as de.
    
    * examples/example_film_manager.glom:
    * examples/example_lesson_planner.glom:
    * examples/example_music_collection.glom:
    * examples/example_project_manager.glom:
    * examples/example_smallbusiness.glom:
    * examples/sqlite/test_sqlite_music/test_sqlite_music.glom:
    * ldtp/database-templates/PostgresCentral/Test.glom:
    * ldtp/database-templates/SQLite/Test.glom:
    * tests/test_document_load_translations.cc:
    * tests/translations_po/test_document_export_po.cc:
    * tests/translations_po/test_document_import_po.cc:
    Replace de_DE with de.

 ChangeLog                                          |   17 +
 examples/example_film_manager.glom                 |  350 ++++++++++----------
 examples/example_lesson_planner.glom               |   52 ++--
 examples/example_music_collection.glom             |   20 +-
 examples/example_project_manager.glom              |   44 ++--
 examples/example_smallbusiness.glom                |  128 ++++----
 .../test_sqlite_music/test_sqlite_music.glom       |   20 +-
 glom/test.glom                                     |   10 +-
 ldtp/database-templates/PostgresCentral/Test.glom  |  128 ++++----
 ldtp/database-templates/SQLite/Test.glom           |  128 ++++----
 tests/test_document_load_translations.cc           |    2 +-
 tests/translations_po/test_document_export_po.cc   |    2 +-
 tests/translations_po/test_document_import_po.cc   |    2 +-
 13 files changed, 460 insertions(+), 443 deletions(-)
---
diff --git a/ChangeLog b/ChangeLog
index 321c662..f82fa2a 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,5 +1,22 @@
 2012-01-09  Murray Cumming  <murrayc murrayc com>
 
+	Translations: Prefer non-country-specific locales, such as de.
+
+	* examples/example_film_manager.glom:
+	* examples/example_lesson_planner.glom:
+	* examples/example_music_collection.glom:
+	* examples/example_project_manager.glom:
+	* examples/example_smallbusiness.glom:
+	* examples/sqlite/test_sqlite_music/test_sqlite_music.glom:
+	* ldtp/database-templates/PostgresCentral/Test.glom:
+	* ldtp/database-templates/SQLite/Test.glom:
+	* tests/test_document_load_translations.cc:
+	* tests/translations_po/test_document_export_po.cc:
+	* tests/translations_po/test_document_import_po.cc:
+	Replace de_DE with de.
+
+2012-01-09  Murray Cumming  <murrayc murrayc com>
+
 	Translations: Offer non-country-specific language locales too.
 
 	* Makefile_tests.am:
diff --git a/examples/example_film_manager.glom b/examples/example_film_manager.glom
index 3d3b115..9da1cee 100644
--- a/examples/example_film_manager.glom
+++ b/examples/example_film_manager.glom
@@ -4,61 +4,61 @@
   <table name="accommodation" title="Accommodation">
     <example_rows/>
     <trans_set>
-      <trans loc="de_DE" val="Unterkunft"/>
+      <trans loc="de" val="Unterkunft"/>
     </trans_set>
     <fields>
       <field name="accommodation_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Accommodation ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Unterkunft ID"/>
+          <trans loc="de" val="Unterkunft ID"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Beschreibung"/>
+          <trans loc="de" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentare"/>
+          <trans loc="de" val="Kommentare"/>
         </trans_set>
       </field>
       <field name="address_street" type="Text" title="Street">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Strasse"/>
+          <trans loc="de" val="Strasse"/>
         </trans_set>
       </field>
       <field name="address_town" type="Text" title="Town">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Ort"/>
+          <trans loc="de" val="Ort"/>
         </trans_set>
       </field>
       <field name="address_county" type="Text" title="County">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Bundesland/Kanton"/>
+          <trans loc="de" val="Bundesland/Kanton"/>
         </trans_set>
       </field>
       <field name="address_country" type="Text" title="Country">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Land"/>
+          <trans loc="de" val="Land"/>
         </trans_set>
       </field>
       <field name="address_postcode" type="Text" title="Postcode">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Postleitzahl"/>
+          <trans loc="de" val="Postleitzahl"/>
         </trans_set>
       </field>
       <field name="contact_id" type="Number" title="Contact ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="name" type="Text" title="Name">
@@ -68,7 +68,7 @@
     <relationships>
       <relationship name="contacts" key="contact_id" other_table="contacts" other_key="contact_id" title="Contacts">
         <trans_set>
-          <trans loc="de_DE" val="Kontakte"/>
+          <trans loc="de" val="Kontakte"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -89,7 +89,7 @@
             </data_layout_item>
             <data_layout_group name="address" title="Address">
               <trans_set>
-                <trans loc="de_DE" val="Addresse"/>
+                <trans loc="de" val="Addresse"/>
               </trans_set>
               <data_layout_item name="address_town" editable="true" use_default_formatting="true">
                 <formatting/>
@@ -109,7 +109,7 @@
             </data_layout_group>
             <data_layout_group name="contact" title="Contact">
               <trans_set>
-                <trans loc="de_DE" val="Kontakt"/>
+                <trans loc="de" val="Kontakt"/>
               </trans_set>
               <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -174,44 +174,44 @@
       </example_row>
     </example_rows>
     <trans_set>
-      <trans loc="de_DE" val="Autos"/>
+      <trans loc="de" val="Autos"/>
     </trans_set>
     <title_singular title="Car"/>
     <fields>
       <field name="car_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Car ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Auto ID"/>
+          <trans loc="de" val="Auto ID"/>
         </trans_set>
       </field>
       <field name="manufacturer" type="Text" title="Manufacturer">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Hersteller"/>
+          <trans loc="de" val="Hersteller"/>
         </trans_set>
       </field>
       <field name="model" type="Text" title="Model">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Model"/>
+          <trans loc="de" val="Model"/>
         </trans_set>
       </field>
       <field name="registration" type="Text" title="Registration">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Kennzeichnung"/>
+          <trans loc="de" val="Kennzeichnung"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Beschreibung"/>
+          <trans loc="de" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="comment" type="Text" title="Comment">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
     </fields>
@@ -221,7 +221,7 @@
         <data_layout_groups>
           <data_layout_group name="overview" columns_count="2" title="Overview">
             <trans_set>
-              <trans loc="de_DE" val="Ãbersicht"/>
+              <trans loc="de" val="Ãbersicht"/>
             </trans_set>
             <data_layout_item name="car_id" editable="true" use_default_formatting="true">
               <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -232,7 +232,7 @@
           </data_layout_group>
           <data_layout_group name="details" columns_count="2" title="Details">
             <trans_set>
-              <trans loc="de_DE" val="Details"/>
+              <trans loc="de" val="Details"/>
             </trans_set>
             <data_layout_item name="manufacturer" editable="true" use_default_formatting="true">
               <formatting/>
@@ -309,26 +309,26 @@
       </example_row>
     </example_rows>
     <trans_set>
-      <trans loc="de_DE" val="Besetzung"/>
+      <trans loc="de" val="Besetzung"/>
     </trans_set>
     <title_singular title="Character"/>
     <fields>
       <field name="character_id" primary_key="true" unique="true" type="Number" title="Cast ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Besetzung ID"/>
+          <trans loc="de" val="Besetzung ID"/>
         </trans_set>
       </field>
       <field name="character" type="Text" title="Character">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Charakter"/>
+          <trans loc="de" val="Charakter"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="contact_id" type="Number" title="Contact ID">
@@ -344,20 +344,20 @@
           </choices_related_extra_layout>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="mainpart" default_value="FALSE" type="Boolean" title="Main Part">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Hauptrolle"/>
+          <trans loc="de" val="Hauptrolle"/>
         </trans_set>
       </field>
     </fields>
     <relationships>
       <relationship name="contacts_actor" key="contact_id" other_table="contacts" other_key="contact_id" title="Actor">
         <trans_set>
-          <trans loc="de_DE" val="Schauspieler"/>
+          <trans loc="de" val="Schauspieler"/>
         </trans_set>
       </relationship>
       <relationship name="scenes" key="character_id" other_table="scene_cast" other_key="cast_id" title="Scenes">
@@ -369,7 +369,7 @@
           <data_layout_group name="main">
             <data_layout_group name="overview" columns_count="2" title="Overview">
               <trans_set>
-                <trans loc="de_DE" val="Ãbersicht"/>
+                <trans loc="de" val="Ãbersicht"/>
               </trans_set>
               <data_layout_item name="character_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -383,11 +383,11 @@
             </data_layout_group>
             <data_layout_group name="details" columns_count="2" title="Details">
               <trans_set>
-                <trans loc="de_DE" val="Details"/>
+                <trans loc="de" val="Details"/>
               </trans_set>
               <data_layout_group name="actor" title="Actor">
                 <trans_set>
-                  <trans loc="de_DE" val="Schauspieler"/>
+                  <trans loc="de" val="Schauspieler"/>
                 </trans_set>
                 <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
                   <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -458,7 +458,7 @@
             <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
               <title_custom use_custom="true" title="Actor's Contact ID">
                 <trans_set>
-                  <trans loc="de_DE" val="Schauspieler Kontakt ID"/>
+                  <trans loc="de" val="Schauspieler Kontakt ID"/>
                 </trans_set>
               </title_custom>
               <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -466,7 +466,7 @@
             <data_layout_item name="name_full" relationship="contacts_actor" editable="true" use_default_formatting="true">
               <title_custom use_custom="true" title="Actor's Name">
                 <trans_set>
-                  <trans loc="de_DE" val="Schauspieler Name"/>
+                  <trans loc="de" val="Schauspieler Name"/>
                 </trans_set>
               </title_custom>
               <formatting/>
@@ -501,7 +501,7 @@
               <data_layout_item name="name_full" relationship="contacts_actor" editable="true" use_default_formatting="true">
                 <title_custom use_custom="true" title="Actor's Name">
                   <trans_set>
-                    <trans loc="de_DE" val="Schauspieler Name"/>
+                    <trans loc="de" val="Schauspieler Name"/>
                   </trans_set>
                 </title_custom>
                 <formatting/>
@@ -581,7 +581,7 @@
               <data_layout_item name="name_full" relationship="contacts_actor" editable="true" use_default_formatting="true">
                 <title_custom use_custom="true" title="Actor">
                   <trans_set>
-                    <trans loc="de_DE" val="Schauspieler"/>
+                    <trans loc="de" val="Schauspieler"/>
                   </trans_set>
                 </title_custom>
                 <formatting/>
@@ -602,7 +602,7 @@
           </data_layout_group>
         </data_layout_groups>
         <trans_set>
-          <trans loc="de_DE" val="Besetzungsliste"/>
+          <trans loc="de" val="Besetzungsliste"/>
         </trans_set>
       </report>
     </reports>
@@ -660,14 +660,14 @@
       </example_row>
     </example_rows>
     <trans_set>
-      <trans loc="de_DE" val="Firmen"/>
+      <trans loc="de" val="Firmen"/>
     </trans_set>
     <title_singular title="Company"/>
     <fields>
       <field name="company_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Company ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Firma ID"/>
+          <trans loc="de" val="Firma ID"/>
         </trans_set>
       </field>
       <field name="name" type="Text" title="Name">
@@ -676,13 +676,13 @@
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Beschreibung"/>
+          <trans loc="de" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="logo" type="Image" title="Logo">
@@ -691,14 +691,14 @@
       <field name="website" type="Text" title="Web Site">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Website"/>
+          <trans loc="de" val="Website"/>
         </trans_set>
       </field>
     </fields>
     <relationships>
       <relationship name="staff" key="company_id" other_table="contacts" other_key="company_id" auto_create="true" allow_edit="true" title="Staff">
         <trans_set>
-          <trans loc="de_DE" val="Angestellte"/>
+          <trans loc="de" val="Angestellte"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -707,7 +707,7 @@
         <data_layout_groups>
           <data_layout_group name="overview" columns_count="2" title="Overview">
             <trans_set>
-              <trans loc="de_DE" val="Ãbersicht"/>
+              <trans loc="de" val="Ãbersicht"/>
             </trans_set>
             <data_layout_item name="company_id" editable="true" use_default_formatting="true">
               <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -718,7 +718,7 @@
           </data_layout_group>
           <data_layout_group name="details" columns_count="2" title="Details">
             <trans_set>
-              <trans loc="de_DE" val="Details"/>
+              <trans loc="de" val="Details"/>
             </trans_set>
             <data_layout_item name="description" editable="true" use_default_formatting="true">
               <formatting/>
@@ -1014,32 +1014,32 @@
       </example_row>
     </example_rows>
     <trans_set>
-      <trans loc="de_DE" val="Kontakte"/>
+      <trans loc="de" val="Kontakte"/>
     </trans_set>
     <title_singular title="Contact"/>
     <fields>
       <field name="contact_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Contact ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="name_first" type="Text" title="First Name">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Vorname"/>
+          <trans loc="de" val="Vorname"/>
         </trans_set>
       </field>
       <field name="name_middle" type="Text" title="Second Name">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Zweiter Name"/>
+          <trans loc="de" val="Zweiter Name"/>
         </trans_set>
       </field>
       <field name="name_last" type="Text" title="Last Name">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Familiename"/>
+          <trans loc="de" val="Familiename"/>
         </trans_set>
       </field>
       <field name="name_title" type="Text" title="Title">
@@ -1054,25 +1054,25 @@
           </custom_choice_list>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Titel"/>
+          <trans loc="de" val="Titel"/>
         </trans_set>
       </field>
       <field name="address_street2" type="Text" title="Street (line 2)">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Strasse (2)"/>
+          <trans loc="de" val="Strasse (2)"/>
         </trans_set>
       </field>
       <field name="address_town" type="Text" title="Town">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Ort"/>
+          <trans loc="de" val="Ort"/>
         </trans_set>
       </field>
       <field name="address_state" type="Text" title="State">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Bundesland/Kanton"/>
+          <trans loc="de" val="Bundesland/Kanton"/>
         </trans_set>
       </field>
       <field name="address_country" type="Text" title="Country">
@@ -1086,32 +1086,32 @@
           </custom_choice_list>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Land"/>
+          <trans loc="de" val="Land"/>
         </trans_set>
       </field>
       <field name="address_postcode" type="Text" title="Postcode">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Postleitzahl"/>
+          <trans loc="de" val="Postleitzahl"/>
         </trans_set>
       </field>
       <field name="date_of_birth" type="Date" title="Date Of Birth">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Geburtsdatum"/>
+          <trans loc="de" val="Geburtsdatum"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentare"/>
+          <trans loc="de" val="Kommentare"/>
         </trans_set>
       </field>
       <field name="name_full" type="Text" title="Full Name">
         <calculation>return record["name_first"] + " " + record["name_last"]</calculation>
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="VollstÃndiger Name"/>
+          <trans loc="de" val="VollstÃndiger Name"/>
         </trans_set>
       </field>
       <field name="company_id" type="Number" title="Company ID">
@@ -1127,25 +1127,25 @@
           </choices_related_extra_layout>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Firma ID"/>
+          <trans loc="de" val="Firma ID"/>
         </trans_set>
       </field>
       <field name="picture" type="Image" title="Picture">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Bild"/>
+          <trans loc="de" val="Bild"/>
         </trans_set>
       </field>
       <field name="tel_home" type="Text" title="Home Telephone">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Telefon (Privat)"/>
+          <trans loc="de" val="Telefon (Privat)"/>
         </trans_set>
       </field>
       <field name="tel_mobile" type="Text" title="Mobile Telephone">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Telefon (Handy)"/>
+          <trans loc="de" val="Telefon (Handy)"/>
         </trans_set>
       </field>
       <field name="tel_fax" type="Text" title="Fax">
@@ -1154,25 +1154,25 @@
       <field name="tel_work" type="Text" title="Work Telephone">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Telefon (Buro)"/>
+          <trans loc="de" val="Telefon (Buro)"/>
         </trans_set>
       </field>
       <field name="email" type="Text" title="Email">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="E-Mail"/>
+          <trans loc="de" val="E-Mail"/>
         </trans_set>
       </field>
       <field name="address_street1" type="Text" title="Street (line 1)">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Strasse (1)"/>
+          <trans loc="de" val="Strasse (1)"/>
         </trans_set>
       </field>
       <field name="website" type="Text" title="Web Site">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Website"/>
+          <trans loc="de" val="Website"/>
         </trans_set>
       </field>
       <field name="agent_id" type="Number" title="Agent ID">
@@ -1191,14 +1191,14 @@
       <field name="stagename" type="Text" title="Stagename">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="KÃnstlername"/>
+          <trans loc="de" val="KÃnstlername"/>
         </trans_set>
       </field>
     </fields>
     <relationships>
       <relationship name="company" key="company_id" other_table="companies" other_key="company_id" auto_create="true" allow_edit="true" title="Company">
         <trans_set>
-          <trans loc="de_DE" val="Firma"/>
+          <trans loc="de" val="Firma"/>
         </trans_set>
       </relationship>
       <relationship name="agent" key="agent_id" other_table="contacts" other_key="contact_id" title="Agent"/>
@@ -1210,7 +1210,7 @@
         <data_layout_groups>
           <data_layout_group name="overview" columns_count="2" title="Overview">
             <trans_set>
-              <trans loc="de_DE" val="Ãbersicht"/>
+              <trans loc="de" val="Ãbersicht"/>
             </trans_set>
             <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
               <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -1221,12 +1221,12 @@
           </data_layout_group>
           <data_layout_group name="details" columns_count="2" title="Details">
             <trans_set>
-              <trans loc="de_DE" val="Details"/>
+              <trans loc="de" val="Details"/>
             </trans_set>
             <data_layout_notebook name="notebook_contact">
               <data_layout_group name="name" title="Name">
                 <trans_set>
-                  <trans loc="de_DE" val="Name"/>
+                  <trans loc="de" val="Name"/>
                 </trans_set>
                 <data_layout_item name="name_title" editable="true" use_default_formatting="true">
                   <formatting/>
@@ -1243,7 +1243,7 @@
               </data_layout_group>
               <data_layout_group name="company" title="Company">
                 <trans_set>
-                  <trans loc="de_DE" val="Firma"/>
+                  <trans loc="de" val="Firma"/>
                 </trans_set>
                 <data_layout_item name="company_id" editable="true" use_default_formatting="true">
                   <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -1254,7 +1254,7 @@
               </data_layout_group>
               <data_layout_group name="address" title="Address">
                 <trans_set>
-                  <trans loc="de_DE" val="Addresse"/>
+                  <trans loc="de" val="Addresse"/>
                 </trans_set>
                 <data_layout_item name="address_street1" editable="true" use_default_formatting="true">
                   <formatting/>
@@ -1277,7 +1277,7 @@
               </data_layout_group>
               <data_layout_group name="telephone" title="Telephone">
                 <trans_set>
-                  <trans loc="de_DE" val="Telefon"/>
+                  <trans loc="de" val="Telefon"/>
                 </trans_set>
                 <data_layout_item name="tel_work" editable="true" use_default_formatting="true">
                   <formatting/>
@@ -1294,7 +1294,7 @@
               </data_layout_group>
               <data_layout_group name="agent" title="Agent">
                 <trans_set>
-                  <trans loc="de_DE" val="Agent"/>
+                  <trans loc="de" val="Agent"/>
                 </trans_set>
                 <data_layout_item name="agent_id" editable="true" use_default_formatting="true">
                   <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -1722,7 +1722,7 @@ Orientation=portrait
           </data_layout_group>
         </data_layout_groups>
         <trans_set>
-          <trans loc="de_DE" val="Kontakt Details"/>
+          <trans loc="de" val="Kontakt Details"/>
         </trans_set>
       </print_layout>
     </print_layouts>
@@ -1833,13 +1833,13 @@ Orientation=portrait
       <field name="description" type="Text" title="Description">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Beschreibung"/>
+          <trans loc="de" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="dept_id" type="Number" title="Department ID">
@@ -1855,7 +1855,7 @@ Orientation=portrait
           </choices_related_extra_layout>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Abteilung ID"/>
+          <trans loc="de" val="Abteilung ID"/>
         </trans_set>
       </field>
       <field name="contact_id" type="Number" title="Contact ID">
@@ -1871,24 +1871,24 @@ Orientation=portrait
           </choices_related_extra_layout>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
     </fields>
     <relationships>
       <relationship name="contacts" key="contact_id" other_table="contacts" other_key="contact_id" title="Contacts">
         <trans_set>
-          <trans loc="de_DE" val="Kontakten"/>
+          <trans loc="de" val="Kontakten"/>
         </trans_set>
       </relationship>
       <relationship name="departments" key="dept_id" other_table="departments" other_key="departments_id" title="Departments">
         <trans_set>
-          <trans loc="de_DE" val="Abteilungen"/>
+          <trans loc="de" val="Abteilungen"/>
         </trans_set>
       </relationship>
       <relationship name="scenes" key="crew_id" other_table="scene_crew" other_key="department_id" title="Scenes">
         <trans_set>
-          <trans loc="de_DE" val="Szenen"/>
+          <trans loc="de" val="Szenen"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -1897,7 +1897,7 @@ Orientation=portrait
         <data_layout_groups>
           <data_layout_group name="overview" columns_count="2" title="Overview">
             <trans_set>
-              <trans loc="de_DE" val="Ãbersicht"/>
+              <trans loc="de" val="Ãbersicht"/>
             </trans_set>
             <data_layout_item name="crew_id" editable="true" use_default_formatting="true">
               <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -1908,11 +1908,11 @@ Orientation=portrait
           </data_layout_group>
           <data_layout_group name="details" columns_count="2">
             <trans_set>
-              <trans loc="de_DE" val="Details"/>
+              <trans loc="de" val="Details"/>
             </trans_set>
             <data_layout_group name="department" title="Department">
               <trans_set>
-                <trans loc="de_DE" val="Abteilung"/>
+                <trans loc="de" val="Abteilung"/>
               </trans_set>
               <data_layout_item name="dept_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -1923,7 +1923,7 @@ Orientation=portrait
             </data_layout_group>
             <data_layout_group name="contact" title="Contact">
               <trans_set>
-                <trans loc="de_DE" val="Kontakt"/>
+                <trans loc="de" val="Kontakt"/>
               </trans_set>
               <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -1933,7 +1933,7 @@ Orientation=portrait
               </data_layout_item>
               <data_layout_group name="address" title="Address">
                 <trans_set>
-                  <trans loc="de_DE" val="Addresse"/>
+                  <trans loc="de" val="Addresse"/>
                 </trans_set>
                 <data_layout_item name="address_street1" relationship="contacts" editable="true" use_default_formatting="true">
                   <formatting/>
@@ -1956,7 +1956,7 @@ Orientation=portrait
               </data_layout_group>
               <data_layout_group name="agent" title="Agent">
                 <trans_set>
-                  <trans loc="de_DE" val="Agent"/>
+                  <trans loc="de" val="Agent"/>
                 </trans_set>
                 <data_layout_item name="agent_id" relationship="contacts" editable="true" use_default_formatting="true">
                   <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -2001,7 +2001,7 @@ Orientation=portrait
             <data_layout_item name="name" relationship="departments" editable="true" use_default_formatting="true">
               <title_custom use_custom="true" title="Department Name">
                 <trans_set>
-                  <trans loc="de_DE" val="Abteilungsname"/>
+                  <trans loc="de" val="Abteilungsname"/>
                 </trans_set>
               </title_custom>
               <formatting/>
@@ -2018,7 +2018,7 @@ Orientation=portrait
               <groupby name="name" relationship="departments" editable="true" use_default_formatting="true">
                 <title_custom use_custom="true" title="Department Name">
                   <trans_set>
-                    <trans loc="de_DE" val="Abteilungsname"/>
+                    <trans loc="de" val="Abteilungsname"/>
                   </trans_set>
                 </title_custom>
               </groupby>
@@ -2067,7 +2067,7 @@ Orientation=portrait
           </data_layout_group>
         </data_layout_groups>
         <trans_set>
-          <trans loc="de_DE" val="Stabliste"/>
+          <trans loc="de" val="Stabliste"/>
         </trans_set>
       </report>
     </reports>
@@ -2076,20 +2076,20 @@ Orientation=portrait
   <table name="deliveries" title="Deliveries">
     <example_rows/>
     <trans_set>
-      <trans loc="de_DE" val="Lieferungen"/>
+      <trans loc="de" val="Lieferungen"/>
     </trans_set>
     <title_singular title="Delivery"/>
     <fields>
       <field name="delivery_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Delivery ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Lieferung ID"/>
+          <trans loc="de" val="Lieferung ID"/>
         </trans_set>
       </field>
       <field name="arrival_date" type="Number" title="Arrival Date">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Lieferungsdatum"/>
+          <trans loc="de" val="Lieferungsdatum"/>
         </trans_set>
       </field>
       <field name="departure_contact_id" type="Number" title="Contact ID">
@@ -2105,7 +2105,7 @@ Orientation=portrait
           </choices_related_extra_layout>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="arrival_contact_id" type="Number" title="Contact ID">
@@ -2121,61 +2121,61 @@ Orientation=portrait
           </choices_related_extra_layout>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="arrival_time" type="Time" title="Arrival Time">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Lieferungszeit"/>
+          <trans loc="de" val="Lieferungszeit"/>
         </trans_set>
       </field>
       <field name="arrival_place" type="Text" title="Arrival Place">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Lieferungsaddresse"/>
+          <trans loc="de" val="Lieferungsaddresse"/>
         </trans_set>
       </field>
       <field name="departure_time" type="Time" title="Departure Time">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Sendungszeit"/>
+          <trans loc="de" val="Sendungszeit"/>
         </trans_set>
       </field>
       <field name="departure_date" type="Date" title="Departure Date">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Sendungsdatum"/>
+          <trans loc="de" val="Sendungsdatum"/>
         </trans_set>
       </field>
       <field name="departure_place" type="Text" title="Departure Place">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Sendungsaddresse"/>
+          <trans loc="de" val="Sendungsaddresse"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentare"/>
+          <trans loc="de" val="Kommentare"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Beschreibung"/>
+          <trans loc="de" val="Beschreibung"/>
         </trans_set>
       </field>
     </fields>
     <relationships>
       <relationship name="departure_contact" key="departure_contact_id" other_table="contacts" other_key="contact_id" title="Departure Contact">
         <trans_set>
-          <trans loc="de_DE" val="Sendungskontakt"/>
+          <trans loc="de" val="Sendungskontakt"/>
         </trans_set>
       </relationship>
       <relationship name="arrival_contact" key="arrival_contact_id" other_table="contacts" other_key="contact_id" title="Arrival Contact">
         <trans_set>
-          <trans loc="de_DE" val="Empfaengerkontakt"/>
+          <trans loc="de" val="Empfaengerkontakt"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -2192,7 +2192,7 @@ Orientation=portrait
             <data_layout_item name="name_full" relationship="departure_contact" editable="true" use_default_formatting="true">
               <title_custom use_custom="true" title="Departure Name">
                 <trans_set>
-                  <trans loc="de_DE" val="Sendername"/>
+                  <trans loc="de" val="Sendername"/>
                 </trans_set>
               </title_custom>
               <formatting/>
@@ -2206,7 +2206,7 @@ Orientation=portrait
             <data_layout_item name="name_full" relationship="arrival_contact" editable="true" use_default_formatting="true">
               <title_custom use_custom="true" title="Arrival Name">
                 <trans_set>
-                  <trans loc="de_DE" val="EmpfÃngerkontakt"/>
+                  <trans loc="de" val="EmpfÃngerkontakt"/>
                 </trans_set>
               </title_custom>
               <formatting/>
@@ -2233,7 +2233,7 @@ Orientation=portrait
           <data_layout_group name="details" columns_count="2">
             <data_layout_group name="departure" title="Departure">
               <trans_set>
-                <trans loc="de_DE" val="Departure"/>
+                <trans loc="de" val="Departure"/>
               </trans_set>
               <data_layout_item name="departure_contact_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -2253,7 +2253,7 @@ Orientation=portrait
             </data_layout_group>
             <data_layout_group name="arrival" title="Arrival">
               <trans_set>
-                <trans loc="de_DE" val="Arrival"/>
+                <trans loc="de" val="Arrival"/>
               </trans_set>
               <data_layout_item name="arrival_contact_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -2327,14 +2327,14 @@ Orientation=portrait
       </example_row>
     </example_rows>
     <trans_set>
-      <trans loc="de_DE" val="Abteilungen"/>
+      <trans loc="de" val="Abteilungen"/>
     </trans_set>
     <title_singular title="Department"/>
     <fields>
       <field name="departments_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Department ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Abteilung ID"/>
+          <trans loc="de" val="Abteilung ID"/>
         </trans_set>
       </field>
       <field name="name" type="Text" title="Name">
@@ -2343,14 +2343,14 @@ Orientation=portrait
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
     </fields>
     <relationships>
       <relationship name="department_crew" key="departments_id" other_table="crew" other_key="dept_id" auto_create="true" allow_edit="true" title="Department Crew">
         <trans_set>
-          <trans loc="de_DE" val="Abteilung Crew"/>
+          <trans loc="de" val="Abteilung Crew"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -2359,7 +2359,7 @@ Orientation=portrait
         <data_layout_groups>
           <data_layout_group name="overview" columns_count="2" title="Overview">
             <trans_set>
-              <trans loc="de_DE" val="Ãbersicht"/>
+              <trans loc="de" val="Ãbersicht"/>
             </trans_set>
             <data_layout_item name="departments_id" editable="true" use_default_formatting="true">
               <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -2370,7 +2370,7 @@ Orientation=portrait
           </data_layout_group>
           <data_layout_group name="details">
             <trans_set>
-              <trans loc="de_DE" val="Details"/>
+              <trans loc="de" val="Details"/>
             </trans_set>
             <data_layout_portal relationship="department_crew" portal_rows_count_min="6" portal_rows_count_max="6">
               <data_layout_item name="crew_id" editable="true" use_default_formatting="true">
@@ -2452,20 +2452,20 @@ Orientation=portrait
       <field name="description" type="Text" title="Description">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Beschreibung"/>
+          <trans loc="de" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
     </fields>
     <relationships>
       <relationship name="scenes" key="equipment_id" other_table="scene_equipment" other_key="equipment_id" title="Scenes">
         <trans_set>
-          <trans loc="de_DE" val="Szenen"/>
+          <trans loc="de" val="Szenen"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -2474,7 +2474,7 @@ Orientation=portrait
         <data_layout_groups>
           <data_layout_group name="overview" columns_count="2" title="Overview">
             <trans_set>
-              <trans loc="de_DE" val="Ãbersicht"/>
+              <trans loc="de" val="Ãbersicht"/>
             </trans_set>
             <data_layout_item name="equipment_id" editable="true" use_default_formatting="true">
               <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -2482,7 +2482,7 @@ Orientation=portrait
           </data_layout_group>
           <data_layout_group name="details" columns_count="2" title="Details">
             <trans_set>
-              <trans loc="de_DE" val="Details"/>
+              <trans loc="de" val="Details"/>
             </trans_set>
             <data_layout_item name="description" editable="true" use_default_formatting="true">
               <formatting/>
@@ -2536,26 +2536,26 @@ Orientation=portrait
       </example_row>
     </example_rows>
     <trans_set>
-      <trans loc="de_DE" val="Fahrten"/>
+      <trans loc="de" val="Fahrten"/>
     </trans_set>
     <title_singular title="Journey"/>
     <fields>
       <field name="journey_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Journey ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Fahrt ID"/>
+          <trans loc="de" val="Fahrt ID"/>
         </trans_set>
       </field>
       <field name="comment" type="Text" title="Comment">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Beschreibung"/>
+          <trans loc="de" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="arrival_date" type="Date" title="Arrival Date">
@@ -2589,14 +2589,14 @@ Orientation=portrait
           </choices_related_extra_layout>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
     </fields>
     <relationships>
       <relationship name="contacts" key="contact_id" other_table="contacts" other_key="contact_id" title="Contacts">
         <trans_set>
-          <trans loc="de_DE" val="Kontakte"/>
+          <trans loc="de" val="Kontakte"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -2641,7 +2641,7 @@ Orientation=portrait
           <data_layout_group name="details" columns_count="2">
             <data_layout_group name="person" title="Person">
               <trans_set>
-                <trans loc="de_DE" val="Person"/>
+                <trans loc="de" val="Person"/>
               </trans_set>
               <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -2652,7 +2652,7 @@ Orientation=portrait
             </data_layout_group>
             <data_layout_group name="departure" title="Departure">
               <trans_set>
-                <trans loc="de_DE" val="Departure"/>
+                <trans loc="de" val="Departure"/>
               </trans_set>
               <data_layout_item name="departure_place" editable="true" use_default_formatting="true">
                 <formatting/>
@@ -2666,7 +2666,7 @@ Orientation=portrait
             </data_layout_group>
             <data_layout_group name="arrival" title="Arrival">
               <trans_set>
-                <trans loc="de_DE" val="Arrival"/>
+                <trans loc="de" val="Arrival"/>
               </trans_set>
               <data_layout_item name="arrival_place" editable="true" use_default_formatting="true">
                 <formatting/>
@@ -2728,37 +2728,37 @@ Orientation=portrait
       <field name="address_street" type="Text" title="Street">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Strasse"/>
+          <trans loc="de" val="Strasse"/>
         </trans_set>
       </field>
       <field name="address_town" type="Text" title="Town">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Stadt"/>
+          <trans loc="de" val="Stadt"/>
         </trans_set>
       </field>
       <field name="address_county" type="Text" title="County">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Land"/>
+          <trans loc="de" val="Land"/>
         </trans_set>
       </field>
       <field name="address_country" type="Text" title="Country">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Staat"/>
+          <trans loc="de" val="Staat"/>
         </trans_set>
       </field>
       <field name="address_postcode" type="Text" title="Postcode">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Postleitzahl"/>
+          <trans loc="de" val="Postleitzahl"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="contact_id" type="Number" title="Contact ID">
@@ -2781,7 +2781,7 @@ Orientation=portrait
     <relationships>
       <relationship name="scenes" key="location_id" other_table="scenes" other_key="location_id" auto_create="true" allow_edit="true" title="Scenes">
         <trans_set>
-          <trans loc="de_DE" val="Szenen"/>
+          <trans loc="de" val="Szenen"/>
         </trans_set>
       </relationship>
       <relationship name="contacts" key="contact_id" other_table="contacts" other_key="contact_id" title="Contacts"/>
@@ -2800,7 +2800,7 @@ Orientation=portrait
           <data_layout_group name="details" columns_count="2">
             <data_layout_group name="address" title="Address">
               <trans_set>
-                <trans loc="de_DE" val="Addresse"/>
+                <trans loc="de" val="Addresse"/>
               </trans_set>
               <data_layout_item name="address_street" editable="true" use_default_formatting="true">
                 <formatting/>
@@ -2820,7 +2820,7 @@ Orientation=portrait
             </data_layout_group>
             <data_layout_group name="contact_person" title="Contact Person">
               <trans_set>
-                <trans loc="de_DE" val="Contact Person"/>
+                <trans loc="de" val="Contact Person"/>
               </trans_set>
               <data_layout_item name="contact_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -2892,7 +2892,7 @@ Orientation=portrait
           </data_layout_group>
         </data_layout_groups>
         <trans_set>
-          <trans loc="de_DE" val="Locations List"/>
+          <trans loc="de" val="Locations List"/>
         </trans_set>
       </report>
     </reports>
@@ -3014,19 +3014,19 @@ Orientation=portrait
       </example_row>
     </example_rows>
     <trans_set>
-      <trans loc="de_DE" val="Szene Besetzung"/>
+      <trans loc="de" val="Szene Besetzung"/>
     </trans_set>
     <fields>
       <field name="scene_cast_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Cast ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Szene Besetzung ID"/>
+          <trans loc="de" val="Szene Besetzung ID"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="cast_id" type="Number" title="Cast ID">
@@ -3042,25 +3042,25 @@ Orientation=portrait
           </choices_related_extra_layout>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Besetzung ID"/>
+          <trans loc="de" val="Besetzung ID"/>
         </trans_set>
       </field>
       <field name="scene_id" type="Number" title="Scene ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Szene ID"/>
+          <trans loc="de" val="Szene ID"/>
         </trans_set>
       </field>
     </fields>
     <relationships>
       <relationship name="cast" key="cast_id" other_table="characters" other_key="character_id" title="Cast">
         <trans_set>
-          <trans loc="de_DE" val="Besetzung"/>
+          <trans loc="de" val="Besetzung"/>
         </trans_set>
       </relationship>
       <relationship name="scene" key="scene_id" other_table="scenes" other_key="scene_id">
         <trans_set>
-          <trans loc="de_DE" val="Szene"/>
+          <trans loc="de" val="Szene"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -3217,19 +3217,19 @@ Orientation=portrait
       </example_row>
     </example_rows>
     <trans_set>
-      <trans loc="de_DE" val="Szene Crew"/>
+      <trans loc="de" val="Szene Crew"/>
     </trans_set>
     <fields>
       <field name="scene_crew_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Crew ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Szene Crew ID"/>
+          <trans loc="de" val="Szene Crew ID"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="scene_id" type="Number" title="Scene ID">
@@ -3245,7 +3245,7 @@ Orientation=portrait
           </choices_related_extra_layout>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Szene ID"/>
+          <trans loc="de" val="Szene ID"/>
         </trans_set>
       </field>
       <field name="department_id" type="Number" title="Department ID">
@@ -3266,7 +3266,7 @@ Orientation=portrait
       <relationship name="department" key="department_id" other_table="departments" other_key="departments_id" title="Department"/>
       <relationship name="scenes" key="scene_id" other_table="scenes" other_key="scene_id" title="Scenes">
         <trans_set>
-          <trans loc="de_DE" val="Szenen"/>
+          <trans loc="de" val="Szenen"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -3276,7 +3276,7 @@ Orientation=portrait
           <data_layout_group name="main">
             <data_layout_group name="overview" columns_count="2" title="Overview">
               <trans_set>
-                <trans loc="de_DE" val="Ãbersicht"/>
+                <trans loc="de" val="Ãbersicht"/>
               </trans_set>
               <data_layout_item name="scene_crew_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -3284,7 +3284,7 @@ Orientation=portrait
             </data_layout_group>
             <data_layout_group name="details" columns_count="2" title="Details">
               <trans_set>
-                <trans loc="de_DE" val="Details"/>
+                <trans loc="de" val="Details"/>
               </trans_set>
               <data_layout_item name="comments" editable="true" use_default_formatting="true">
                 <formatting/>
@@ -3352,7 +3352,7 @@ Orientation=portrait
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="equipment_id" type="Number" title="Equipment ID">
@@ -3686,26 +3686,26 @@ Orientation=portrait
       </example_row>
     </example_rows>
     <trans_set>
-      <trans loc="de_DE" val="Szenen"/>
+      <trans loc="de" val="Szenen"/>
     </trans_set>
     <title_singular title="Scene"/>
     <fields>
       <field name="scene_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Szene ID"/>
+          <trans loc="de" val="Szene ID"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
         <formatting format_text_multiline="true"/>
         <trans_set>
-          <trans loc="de_DE" val="Beschreibung"/>
+          <trans loc="de" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="location_id" type="Number" title="Location ID">
@@ -3724,19 +3724,19 @@ Orientation=portrait
       <field name="date" type="Date" title="Date">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Termin"/>
+          <trans loc="de" val="Termin"/>
         </trans_set>
       </field>
       <field name="time" type="Time" title="Time">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Zeit"/>
+          <trans loc="de" val="Zeit"/>
         </trans_set>
       </field>
       <field name="minutes" type="Number" title="Stop (minutes)">
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2"/>
         <trans_set>
-          <trans loc="de_DE" val="Stunde"/>
+          <trans loc="de" val="Stunde"/>
         </trans_set>
       </field>
       <field name="day_or_night" type="Text" title="Day/Night">
@@ -3744,12 +3744,12 @@ Orientation=portrait
           <custom_choice_list>
             <custom_choice value="Day">
               <trans_set>
-                <trans loc="de_DE" val="Tag"/>
+                <trans loc="de" val="Tag"/>
               </trans_set>
             </custom_choice>
             <custom_choice value="Night">
               <trans_set>
-                <trans loc="de_DE" val="Nacht"/>
+                <trans loc="de" val="Nacht"/>
               </trans_set>
             </custom_choice>
             <custom_choice value="Morning"/>
@@ -3758,7 +3758,7 @@ Orientation=portrait
           </custom_choice_list>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Tag/Nacht"/>
+          <trans loc="de" val="Tag/Nacht"/>
         </trans_set>
       </field>
       <field name="interior_or_exterior" type="Text" title="Interior/Exterior">
@@ -3769,13 +3769,13 @@ Orientation=portrait
           </custom_choice_list>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Interior/Exterior"/>
+          <trans loc="de" val="Interior/Exterior"/>
         </trans_set>
       </field>
       <field name="name" type="Text" title="Name">
         <formatting/>
         <trans_set>
-          <trans loc="de_DE" val="Szene"/>
+          <trans loc="de" val="Szene"/>
         </trans_set>
       </field>
       <field name="overview_name" type="Text" title="Scene">
@@ -3798,12 +3798,12 @@ else:
       </relationship>
       <relationship name="scene_crew" key="scene_id" other_table="scene_crew" other_key="scene_id" auto_create="true" allow_edit="true" title="Additional Crew">
         <trans_set>
-          <trans loc="de_DE" val="Szene Crew"/>
+          <trans loc="de" val="Szene Crew"/>
         </trans_set>
       </relationship>
       <relationship name="scene_cast" key="scene_id" other_table="scene_cast" other_key="scene_id" auto_create="true" allow_edit="true" title="Cast">
         <trans_set>
-          <trans loc="de_DE" val="Szene Besetzung"/>
+          <trans loc="de" val="Szene Besetzung"/>
         </trans_set>
       </relationship>
       <relationship name="scene_equipment" key="scene_id" other_table="scene_equipment" other_key="scene_id" auto_create="true" allow_edit="true" title="Additional Equipment">
@@ -3818,7 +3818,7 @@ else:
         <data_layout_groups>
           <data_layout_group name="overview" columns_count="2" title="Overview">
             <trans_set>
-              <trans loc="de_DE" val="Ãbersicht"/>
+              <trans loc="de" val="Ãbersicht"/>
             </trans_set>
             <data_layout_item name="scene_id" editable="true" use_default_formatting="true">
               <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -3835,7 +3835,7 @@ else:
           </data_layout_group>
           <data_layout_group name="details" columns_count="2" title="Details">
             <trans_set>
-              <trans loc="de_DE" val="Details"/>
+              <trans loc="de" val="Details"/>
             </trans_set>
             <data_layout_item name="name" editable="true" use_default_formatting="true">
               <formatting/>
@@ -3846,7 +3846,7 @@ else:
             </data_layout_text>
             <data_layout_group name="scenario" title="Scenario">
               <trans_set>
-                <trans loc="de_DE" val="Stimmung"/>
+                <trans loc="de" val="Stimmung"/>
               </trans_set>
               <data_layout_item name="interior_or_exterior" editable="true" use_default_formatting="true">
                 <formatting/>
@@ -3866,7 +3866,7 @@ else:
             </data_layout_item>
             <data_layout_group name="location" title="Location">
               <trans_set>
-                <trans loc="de_DE" val="Location"/>
+                <trans loc="de" val="Location"/>
               </trans_set>
               <data_layout_item name="location_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -4045,7 +4045,7 @@ else:
           </data_layout_group>
         </data_layout_groups>
         <trans_set>
-          <trans loc="de_DE" val="Locations List"/>
+          <trans loc="de" val="Locations List"/>
         </trans_set>
       </report>
     </reports>
diff --git a/examples/example_lesson_planner.glom b/examples/example_lesson_planner.glom
index 34774bc..5261fe7 100644
--- a/examples/example_lesson_planner.glom
+++ b/examples/example_lesson_planner.glom
@@ -78,35 +78,35 @@
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Produkt Name"/>
-          <trans loc="de_DE" val="Produkt Name"/>
+          <trans loc="de" val="Produkt Name"/>
         </trans_set>
       </field>
       <field name="product_id" type="Number" title="Product Id">
         <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true"/>
         <trans_set>
           <trans loc="de_AT" val="Produkt ID"/>
-          <trans loc="de_DE" val="Produkt ID"/>
+          <trans loc="de" val="Produkt ID"/>
         </trans_set>
       </field>
       <field name="product_price" type="Number" title="Product Price">
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Produkt Preis"/>
-          <trans loc="de_DE" val="Produkt Preis"/>
+          <trans loc="de" val="Produkt Preis"/>
         </trans_set>
       </field>
       <field name="invoice_id" type="Number" title="Invoice ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Rechnung ID"/>
-          <trans loc="de_DE" val="Rechnung ID"/>
+          <trans loc="de" val="Rechnung ID"/>
         </trans_set>
       </field>
       <field name="count" default_value="1" type="Number" title="Number Of">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Menge"/>
-          <trans loc="de_DE" val="Menge"/>
+          <trans loc="de" val="Menge"/>
         </trans_set>
       </field>
       <field name="total_price" type="Number" title="Total Price">
@@ -114,14 +114,14 @@
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamtpreis"/>
-          <trans loc="de_DE" val="Gesamtpreis"/>
+          <trans loc="de" val="Gesamtpreis"/>
         </trans_set>
       </field>
       <field name="vat_percentage" type="Number" title="VAT Percentage">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="MwST Prozent"/>
-          <trans loc="de_DE" val="MwST Prozent"/>
+          <trans loc="de" val="MwST Prozent"/>
         </trans_set>
       </field>
       <field name="total_price_vat" type="Number" title="Total VAT">
@@ -129,7 +129,7 @@
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamt MwST"/>
-          <trans loc="de_DE" val="Gesamt MwST"/>
+          <trans loc="de" val="Gesamt MwST"/>
         </trans_set>
       </field>
     </fields>
@@ -801,35 +801,35 @@
     </example_rows>
     <trans_set>
       <trans loc="de_AT" val="Kontakten"/>
-      <trans loc="de_DE" val="Kontakten"/>
+      <trans loc="de" val="Kontakten"/>
     </trans_set>
     <fields>
       <field name="teacher_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Teacher ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Kontakt ID"/>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="name_first" type="Text" title="First Name">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Vorname"/>
-          <trans loc="de_DE" val="Vorname"/>
+          <trans loc="de" val="Vorname"/>
         </trans_set>
       </field>
       <field name="name_middle" type="Text" title="Middle Name">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Zweite Name"/>
-          <trans loc="de_DE" val="Zweite Name"/>
+          <trans loc="de" val="Zweite Name"/>
         </trans_set>
       </field>
       <field name="name_last" type="Text" title="Last Name">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Familiename"/>
-          <trans loc="de_DE" val="Familiename"/>
+          <trans loc="de" val="Familiename"/>
         </trans_set>
       </field>
       <field name="name_title" type="Text" title="Title">
@@ -844,56 +844,56 @@
           </custom_choice_list>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Titel"/>
+          <trans loc="de" val="Titel"/>
         </trans_set>
       </field>
       <field name="address_street" type="Text" title="Street">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Strasse"/>
-          <trans loc="de_DE" val="Strasse"/>
+          <trans loc="de" val="Strasse"/>
         </trans_set>
       </field>
       <field name="address_town" type="Text" title="Town">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Ort"/>
-          <trans loc="de_DE" val="Ort"/>
+          <trans loc="de" val="Ort"/>
         </trans_set>
       </field>
       <field name="address_state" type="Text" title="State">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Bundesland/Kanton"/>
-          <trans loc="de_DE" val="Bundesland/Kanton"/>
+          <trans loc="de" val="Bundesland/Kanton"/>
         </trans_set>
       </field>
       <field name="address_country" type="Text" title="Country">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Land"/>
-          <trans loc="de_DE" val="Land"/>
+          <trans loc="de" val="Land"/>
         </trans_set>
       </field>
       <field name="address_postcode" type="Text" title="Postcode">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Postleitzahl"/>
-          <trans loc="de_DE" val="Postleitzahl"/>
+          <trans loc="de" val="Postleitzahl"/>
         </trans_set>
       </field>
       <field name="date_of_birth" type="Date" title="Date of Birth">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Geburtsdatum"/>
-          <trans loc="de_DE" val="Geburtsdatum"/>
+          <trans loc="de" val="Geburtsdatum"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
           <trans loc="de_AT" val="Kommentar"/>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="name_full" type="Text" title="Full Name">
@@ -901,28 +901,28 @@
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Vollname"/>
-          <trans loc="de_DE" val="Vollname"/>
+          <trans loc="de" val="Vollname"/>
         </trans_set>
       </field>
       <field name="picture" type="Image" title="Picture">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Bild"/>
-          <trans loc="de_DE" val="Bild"/>
+          <trans loc="de" val="Bild"/>
         </trans_set>
       </field>
       <field name="email" type="Text" title="Email Address">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="E-mail Addresse"/>
-          <trans loc="de_DE" val="E-mail Addresse"/>
+          <trans loc="de" val="E-mail Addresse"/>
         </trans_set>
       </field>
       <field name="website" type="Text" title="Web Site">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Website"/>
-          <trans loc="de_DE" val="Website"/>
+          <trans loc="de" val="Website"/>
         </trans_set>
       </field>
       <field name="tel_home" type="Text" title="Home Telephone">
@@ -938,7 +938,7 @@
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Fax"/>
-          <trans loc="de_DE" val="Fax"/>
+          <trans loc="de" val="Fax"/>
         </trans_set>
       </field>
     </fields>
diff --git a/examples/example_music_collection.glom b/examples/example_music_collection.glom
index c44f5e1..d7d84a1 100644
--- a/examples/example_music_collection.glom
+++ b/examples/example_music_collection.glom
@@ -94,7 +94,7 @@
         <data_layout_groups>
           <data_layout_group name="overview" columns_count="2" title="Overview">
             <trans_set>
-              <trans loc="de_DE" val="Overview"/>
+              <trans loc="de" val="Overview"/>
             </trans_set>
             <data_layout_item name="album_id" editable="true" use_default_formatting="true">
               <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -105,11 +105,11 @@
           </data_layout_group>
           <data_layout_group name="details" columns_count="2" title="Details">
             <trans_set>
-              <trans loc="de_DE" val="Details"/>
+              <trans loc="de" val="Details"/>
             </trans_set>
             <data_layout_group name="artist" title="Artist">
               <trans_set>
-                <trans loc="de_DE" val="Artist"/>
+                <trans loc="de" val="Artist"/>
               </trans_set>
               <data_layout_item name="artist_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -120,7 +120,7 @@
             </data_layout_group>
             <data_layout_group name="publisher" title="Publisher">
               <trans_set>
-                <trans loc="de_DE" val="Publisher"/>
+                <trans loc="de" val="Publisher"/>
               </trans_set>
               <data_layout_item name="publisher_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -249,7 +249,7 @@
         <data_layout_groups>
           <data_layout_group name="overview" columns_count="2" title="Overview">
             <trans_set>
-              <trans loc="de_DE" val="Overview"/>
+              <trans loc="de" val="Overview"/>
             </trans_set>
             <data_layout_item name="artist_id" editable="true" use_default_formatting="true">
               <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -260,7 +260,7 @@
           </data_layout_group>
           <data_layout_group name="details" columns_count="2" title="Details">
             <trans_set>
-              <trans loc="de_DE" val="Details"/>
+              <trans loc="de" val="Details"/>
             </trans_set>
             <data_layout_item name="description" editable="true" use_default_formatting="true">
               <formatting/>
@@ -338,7 +338,7 @@
         <data_layout_groups>
           <data_layout_group name="overview" columns_count="2" title="Overview">
             <trans_set>
-              <trans loc="de_DE" val="Overview"/>
+              <trans loc="de" val="Overview"/>
             </trans_set>
             <data_layout_item name="publishers_id" editable="true" use_default_formatting="true">
               <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -349,7 +349,7 @@
           </data_layout_group>
           <data_layout_group name="details" title="Details">
             <trans_set>
-              <trans loc="de_DE" val="Details"/>
+              <trans loc="de" val="Details"/>
             </trans_set>
             <data_layout_item name="comments" editable="true" use_default_formatting="true">
               <formatting/>
@@ -706,7 +706,7 @@
         <data_layout_groups>
           <data_layout_group name="overview" columns_count="2" title="Overview">
             <trans_set>
-              <trans loc="de_DE" val="Overview"/>
+              <trans loc="de" val="Overview"/>
             </trans_set>
             <data_layout_item name="song_id" editable="true" use_default_formatting="true">
               <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -717,7 +717,7 @@
           </data_layout_group>
           <data_layout_group name="details" columns_count="2" title="Details">
             <trans_set>
-              <trans loc="de_DE" val="Details"/>
+              <trans loc="de" val="Details"/>
             </trans_set>
             <data_layout_group name="album" title="Album">
               <data_layout_item name="album_id" editable="true" use_default_formatting="true">
diff --git a/examples/example_project_manager.glom b/examples/example_project_manager.glom
index ab6f091..b56e2d4 100644
--- a/examples/example_project_manager.glom
+++ b/examples/example_project_manager.glom
@@ -182,35 +182,35 @@
     </example_rows>
     <trans_set>
       <trans loc="de_AT" val="Kontakten"/>
-      <trans loc="de_DE" val="Kontakten"/>
+      <trans loc="de" val="Kontakten"/>
     </trans_set>
     <fields>
       <field name="contact_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Contact ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Kontakt ID"/>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="name_first" type="Text" title="First Name">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Vorname"/>
-          <trans loc="de_DE" val="Vorname"/>
+          <trans loc="de" val="Vorname"/>
         </trans_set>
       </field>
       <field name="name_middle" type="Text" title="Middle Name">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Zweite Name"/>
-          <trans loc="de_DE" val="Zweite Name"/>
+          <trans loc="de" val="Zweite Name"/>
         </trans_set>
       </field>
       <field name="name_last" type="Text" title="Last Name">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Familiename"/>
-          <trans loc="de_DE" val="Familiename"/>
+          <trans loc="de" val="Familiename"/>
         </trans_set>
       </field>
       <field name="name_title" type="Text" title="Title">
@@ -225,56 +225,56 @@
           </custom_choice_list>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Titel"/>
+          <trans loc="de" val="Titel"/>
         </trans_set>
       </field>
       <field name="address_street" type="Text" title="Street">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Strasse"/>
-          <trans loc="de_DE" val="Strasse"/>
+          <trans loc="de" val="Strasse"/>
         </trans_set>
       </field>
       <field name="address_town" type="Text" title="Town">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Ort"/>
-          <trans loc="de_DE" val="Ort"/>
+          <trans loc="de" val="Ort"/>
         </trans_set>
       </field>
       <field name="address_state" type="Text" title="State">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Bundesland/Kanton"/>
-          <trans loc="de_DE" val="Bundesland/Kanton"/>
+          <trans loc="de" val="Bundesland/Kanton"/>
         </trans_set>
       </field>
       <field name="address_country" type="Text" title="Country">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Land"/>
-          <trans loc="de_DE" val="Land"/>
+          <trans loc="de" val="Land"/>
         </trans_set>
       </field>
       <field name="address_postcode" type="Text" title="Postcode">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Postleitzahl"/>
-          <trans loc="de_DE" val="Postleitzahl"/>
+          <trans loc="de" val="Postleitzahl"/>
         </trans_set>
       </field>
       <field name="date_of_birth" type="Date" title="Date of Birth">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Geburtsdatum"/>
-          <trans loc="de_DE" val="Geburtsdatum"/>
+          <trans loc="de" val="Geburtsdatum"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
           <trans loc="de_AT" val="Kommentar"/>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="name_full" type="Text" title="Full Name">
@@ -282,28 +282,28 @@
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Vollname"/>
-          <trans loc="de_DE" val="Vollname"/>
+          <trans loc="de" val="Vollname"/>
         </trans_set>
       </field>
       <field name="picture" type="Image" title="Picture">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Bild"/>
-          <trans loc="de_DE" val="Bild"/>
+          <trans loc="de" val="Bild"/>
         </trans_set>
       </field>
       <field name="email" type="Text" title="Email Address">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="E-mail Addresse"/>
-          <trans loc="de_DE" val="E-mail Addresse"/>
+          <trans loc="de" val="E-mail Addresse"/>
         </trans_set>
       </field>
       <field name="website" type="Text" title="Web Site">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Website"/>
-          <trans loc="de_DE" val="Website"/>
+          <trans loc="de" val="Website"/>
         </trans_set>
       </field>
       <field name="tel_home" type="Text" title="Home Telephone">
@@ -319,7 +319,7 @@
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Fax"/>
-          <trans loc="de_DE" val="Fax"/>
+          <trans loc="de" val="Fax"/>
         </trans_set>
       </field>
     </fields>
@@ -333,7 +333,7 @@
             <trans_set>
               <trans loc="de_AT" val="Ubersicht"/>
               <trans loc="de_BE" val="Overview"/>
-              <trans loc="de_DE" val="Ubersicht"/>
+              <trans loc="de" val="Ubersicht"/>
               <trans loc="en_GB" val="Overview"/>
               <trans loc="en_US" val="Overview"/>
             </trans_set>
@@ -350,7 +350,7 @@
                 <trans_set>
                   <trans loc="de_AT" val="Telefon"/>
                   <trans loc="de_BE" val="Telephone"/>
-                  <trans loc="de_DE" val="Telefon"/>
+                  <trans loc="de" val="Telefon"/>
                   <trans loc="en_GB" val="Telephone"/>
                   <trans loc="en_US" val="Telephone"/>
                 </trans_set>
@@ -371,7 +371,7 @@
                 <trans_set>
                   <trans loc="de_AT" val="Addresse"/>
                   <trans loc="de_BE" val="Address"/>
-                  <trans loc="de_DE" val="Addresse"/>
+                  <trans loc="de" val="Addresse"/>
                   <trans loc="en_GB" val="Address"/>
                   <trans loc="en_US" val="Address"/>
                 </trans_set>
@@ -395,7 +395,7 @@
                 <trans_set>
                   <trans loc="de_AT" val="Name"/>
                   <trans loc="de_BE" val="Name"/>
-                  <trans loc="de_DE" val="Name"/>
+                  <trans loc="de" val="Name"/>
                   <trans loc="en_GB" val="Name"/>
                   <trans loc="en_US" val="Name"/>
                 </trans_set>
diff --git a/examples/example_smallbusiness.glom b/examples/example_smallbusiness.glom
index 9f55f7a..f85dbef 100644
--- a/examples/example_smallbusiness.glom
+++ b/examples/example_smallbusiness.glom
@@ -185,35 +185,35 @@ http://www.flickr.com/photos/mape_s/350700095/</value>
     </example_rows>
     <trans_set>
       <trans loc="de_AT" val="Kontakten"/>
-      <trans loc="de_DE" val="Kontakten"/>
+      <trans loc="de" val="Kontakten"/>
     </trans_set>
     <fields>
       <field name="contact_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Contact ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Kontakt ID"/>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="name_first" type="Text" title="First Name">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Vorname"/>
-          <trans loc="de_DE" val="Vorname"/>
+          <trans loc="de" val="Vorname"/>
         </trans_set>
       </field>
       <field name="name_middle" type="Text" title="Middle Name">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Zweite Name"/>
-          <trans loc="de_DE" val="Zweite Name"/>
+          <trans loc="de" val="Zweite Name"/>
         </trans_set>
       </field>
       <field name="name_last" type="Text" title="Last Name">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Familiename"/>
-          <trans loc="de_DE" val="Familiename"/>
+          <trans loc="de" val="Familiename"/>
         </trans_set>
       </field>
       <field name="name_title" type="Text" title="Title">
@@ -228,56 +228,56 @@ http://www.flickr.com/photos/mape_s/350700095/</value>
           </custom_choice_list>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Titel"/>
+          <trans loc="de" val="Titel"/>
         </trans_set>
       </field>
       <field name="address_street" type="Text" title="Street">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Strasse"/>
-          <trans loc="de_DE" val="Strasse"/>
+          <trans loc="de" val="Strasse"/>
         </trans_set>
       </field>
       <field name="address_town" type="Text" title="Town">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Ort"/>
-          <trans loc="de_DE" val="Ort"/>
+          <trans loc="de" val="Ort"/>
         </trans_set>
       </field>
       <field name="address_state" type="Text" title="State">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Bundesland/Kanton"/>
-          <trans loc="de_DE" val="Bundesland/Kanton"/>
+          <trans loc="de" val="Bundesland/Kanton"/>
         </trans_set>
       </field>
       <field name="address_country" type="Text" title="Country">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Land"/>
-          <trans loc="de_DE" val="Land"/>
+          <trans loc="de" val="Land"/>
         </trans_set>
       </field>
       <field name="address_postcode" type="Text" title="Postcode">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Postleitzahl"/>
-          <trans loc="de_DE" val="Postleitzahl"/>
+          <trans loc="de" val="Postleitzahl"/>
         </trans_set>
       </field>
       <field name="date_of_birth" type="Date" title="Date of Birth">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Geburtsdatum"/>
-          <trans loc="de_DE" val="Geburtsdatum"/>
+          <trans loc="de" val="Geburtsdatum"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
         <formatting format_text_multiline="true"/>
         <trans_set>
           <trans loc="de_AT" val="Kommentar"/>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="name_full" type="Text" title="Full Name">
@@ -285,28 +285,28 @@ http://www.flickr.com/photos/mape_s/350700095/</value>
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Vollname"/>
-          <trans loc="de_DE" val="Vollname"/>
+          <trans loc="de" val="Vollname"/>
         </trans_set>
       </field>
       <field name="picture" type="Image" title="Picture">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Bild"/>
-          <trans loc="de_DE" val="Bild"/>
+          <trans loc="de" val="Bild"/>
         </trans_set>
       </field>
       <field name="email" type="Text" title="Email Address">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="E-mail Addresse"/>
-          <trans loc="de_DE" val="E-mail Addresse"/>
+          <trans loc="de" val="E-mail Addresse"/>
         </trans_set>
       </field>
       <field name="website" type="Text" title="Web Site">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Website"/>
-          <trans loc="de_DE" val="Website"/>
+          <trans loc="de" val="Website"/>
         </trans_set>
       </field>
       <field name="tel_home" type="Text" title="Home Telephone">
@@ -322,7 +322,7 @@ http://www.flickr.com/photos/mape_s/350700095/</value>
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Fax"/>
-          <trans loc="de_DE" val="Fax"/>
+          <trans loc="de" val="Fax"/>
         </trans_set>
       </field>
     </fields>
@@ -334,7 +334,7 @@ http://www.flickr.com/photos/mape_s/350700095/</value>
             <trans_set>
               <trans loc="de_AT" val="Ubersicht"/>
               <trans loc="de_BE" val="Overview"/>
-              <trans loc="de_DE" val="Ubersicht"/>
+              <trans loc="de" val="Ubersicht"/>
               <trans loc="en_GB" val="Overview"/>
               <trans loc="en_US" val="Overview"/>
             </trans_set>
@@ -350,7 +350,7 @@ http://www.flickr.com/photos/mape_s/350700095/</value>
               <trans_set>
                 <trans loc="de_AT" val="Name"/>
                 <trans loc="de_BE" val="Name"/>
-                <trans loc="de_DE" val="Name"/>
+                <trans loc="de" val="Name"/>
                 <trans loc="en_GB" val="Name"/>
                 <trans loc="en_US" val="Name"/>
               </trans_set>
@@ -371,7 +371,7 @@ http://www.flickr.com/photos/mape_s/350700095/</value>
               <trans_set>
                 <trans loc="de_AT" val="Addresse"/>
                 <trans loc="de_BE" val="Address"/>
-                <trans loc="de_DE" val="Addresse"/>
+                <trans loc="de" val="Addresse"/>
                 <trans loc="en_GB" val="Address"/>
                 <trans loc="en_US" val="Address"/>
               </trans_set>
@@ -395,7 +395,7 @@ http://www.flickr.com/photos/mape_s/350700095/</value>
               <trans_set>
                 <trans loc="de_AT" val="Telefon"/>
                 <trans loc="de_BE" val="Telephone"/>
-                <trans loc="de_DE" val="Telefon"/>
+                <trans loc="de" val="Telefon"/>
                 <trans loc="en_GB" val="Telephone"/>
                 <trans loc="en_US" val="Telephone"/>
               </trans_set>
@@ -826,7 +826,7 @@ Orientation=portrait
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Produkt Name"/>
-          <trans loc="de_DE" val="Produkt Name"/>
+          <trans loc="de" val="Produkt Name"/>
         </trans_set>
       </field>
       <field name="product_id" type="Number" title="Product Id">
@@ -843,7 +843,7 @@ Orientation=portrait
         </formatting>
         <trans_set>
           <trans loc="de_AT" val="Produkt ID"/>
-          <trans loc="de_DE" val="Produkt ID"/>
+          <trans loc="de" val="Produkt ID"/>
         </trans_set>
       </field>
       <field name="product_price" type="Number" title="Product Price">
@@ -851,21 +851,21 @@ Orientation=portrait
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Produkt Preis"/>
-          <trans loc="de_DE" val="Produkt Preis"/>
+          <trans loc="de" val="Produkt Preis"/>
         </trans_set>
       </field>
       <field name="invoice_id" type="Number" title="Invoice ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Rechnung ID"/>
-          <trans loc="de_DE" val="Rechnung ID"/>
+          <trans loc="de" val="Rechnung ID"/>
         </trans_set>
       </field>
       <field name="count" default_value="1" type="Number" title="Number Of">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Menge"/>
-          <trans loc="de_DE" val="Menge"/>
+          <trans loc="de" val="Menge"/>
         </trans_set>
       </field>
       <field name="total_price" type="Number" title="Total Price">
@@ -873,7 +873,7 @@ Orientation=portrait
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamtpreis"/>
-          <trans loc="de_DE" val="Gesamtpreis"/>
+          <trans loc="de" val="Gesamtpreis"/>
         </trans_set>
       </field>
       <field name="vat_percentage" type="Number" title="VAT Percentage">
@@ -881,7 +881,7 @@ Orientation=portrait
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="MwST Prozent"/>
-          <trans loc="de_DE" val="MwST Prozent"/>
+          <trans loc="de" val="MwST Prozent"/>
         </trans_set>
       </field>
       <field name="total_price_vat" type="Number" title="Total VAT">
@@ -889,7 +889,7 @@ Orientation=portrait
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamt MwST"/>
-          <trans loc="de_DE" val="Gesamt MwST"/>
+          <trans loc="de" val="Gesamt MwST"/>
         </trans_set>
       </field>
     </fields>
@@ -897,7 +897,7 @@ Orientation=portrait
       <relationship name="products" key="product_id" other_table="products" other_key="product_id">
         <trans_set>
           <trans loc="de_AT" val="Produkten"/>
-          <trans loc="de_DE" val="Produkten"/>
+          <trans loc="de" val="Produkten"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -989,35 +989,35 @@ Orientation=portrait
     </example_rows>
     <trans_set>
       <trans loc="de_AT" val="Rechnungen"/>
-      <trans loc="de_DE" val="Rechnungen"/>
+      <trans loc="de" val="Rechnungen"/>
     </trans_set>
     <fields>
       <field name="invoice_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Invoice ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Rechnung ID"/>
-          <trans loc="de_DE" val="Rechnung ID"/>
+          <trans loc="de" val="Rechnung ID"/>
         </trans_set>
       </field>
       <field name="contact_id" type="Number" title="Contact ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Kontakt ID"/>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="date" type="Date" title="Date">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Datum"/>
-          <trans loc="de_DE" val="Datum"/>
+          <trans loc="de" val="Datum"/>
         </trans_set>
       </field>
       <field name="comment" type="Text" title="Comment">
         <formatting format_text_multiline="true"/>
         <trans_set>
           <trans loc="de_AT" val="Kommentar"/>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="price_total" type="Number" title="Total Price">
@@ -1025,7 +1025,7 @@ Orientation=portrait
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamtpreis"/>
-          <trans loc="de_DE" val="Gesamtpreis"/>
+          <trans loc="de" val="Gesamtpreis"/>
         </trans_set>
       </field>
       <field name="vat_total" default_value="16" type="Number" title="Total VAT">
@@ -1033,7 +1033,7 @@ Orientation=portrait
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamt MwST"/>
-          <trans loc="de_DE" val="Gesamt MwST"/>
+          <trans loc="de" val="Gesamt MwST"/>
         </trans_set>
       </field>
       <field name="price_total_with_vat" type="Number" title="Total Price With Vat">
@@ -1041,7 +1041,7 @@ Orientation=portrait
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamtpreis mit MwST"/>
-          <trans loc="de_DE" val="Gesamtpreis mit MwST"/>
+          <trans loc="de" val="Gesamtpreis mit MwST"/>
         </trans_set>
       </field>
     </fields>
@@ -1049,13 +1049,13 @@ Orientation=portrait
       <relationship name="invoice_lines" key="invoice_id" other_table="invoice_lines" other_key="invoice_id" auto_create="true" allow_edit="true" title="Invoice Lines">
         <trans_set>
           <trans loc="de_AT" val="Rechnung Reihen"/>
-          <trans loc="de_DE" val="Rechnung Reihen"/>
+          <trans loc="de" val="Rechnung Reihen"/>
         </trans_set>
       </relationship>
       <relationship name="contacts" key="contact_id" other_table="contacts" other_key="contact_id" title="Contacts">
         <trans_set>
           <trans loc="de_AT" val="Kontakten"/>
-          <trans loc="de_DE" val="Kontakten"/>
+          <trans loc="de" val="Kontakten"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -1066,7 +1066,7 @@ Orientation=portrait
             <trans_set>
               <trans loc="de_AT" val="Ãbersicht"/>
               <trans loc="de_BE" val="Overview"/>
-              <trans loc="de_DE" val="Ãbersicht"/>
+              <trans loc="de" val="Ãbersicht"/>
               <trans loc="en_GB" val="Overview"/>
               <trans loc="en_US" val="Overview"/>
             </trans_set>
@@ -1082,7 +1082,7 @@ Orientation=portrait
               <trans_set>
                 <trans loc="de_AT" val="Kunde"/>
                 <trans loc="de_BE" val="Customer"/>
-                <trans loc="de_DE" val="Kunde"/>
+                <trans loc="de" val="Kunde"/>
                 <trans loc="en_GB" val="Customer"/>
                 <trans loc="en_US" val="Customer"/>
               </trans_set>
@@ -1275,49 +1275,49 @@ Orientation=portrait
     </example_rows>
     <trans_set>
       <trans loc="de_AT" val="Produkten"/>
-      <trans loc="de_DE" val="Produkten"/>
+      <trans loc="de" val="Produkten"/>
     </trans_set>
     <fields>
       <field name="product_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Product ID">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Produkt ID"/>
-          <trans loc="de_DE" val="Produkt ID"/>
+          <trans loc="de" val="Produkt ID"/>
         </trans_set>
       </field>
       <field name="comment" type="Text" title="Comment">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Kommentar"/>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Beschreibung"/>
-          <trans loc="de_DE" val="Beschreibung"/>
+          <trans loc="de" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="name" type="Text" title="Name">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Name"/>
-          <trans loc="de_DE" val="Name"/>
+          <trans loc="de" val="Name"/>
         </trans_set>
       </field>
       <field name="price" type="Number" title="Price">
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Preis"/>
-          <trans loc="de_DE" val="Preis"/>
+          <trans loc="de" val="Preis"/>
         </trans_set>
       </field>
       <field name="vat_percent" default_value="16" type="Number" title="Vat Percent">
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="MwST Prozent"/>
-          <trans loc="de_DE" val="MwST Prozent"/>
+          <trans loc="de" val="MwST Prozent"/>
         </trans_set>
       </field>
     </fields>
@@ -1329,7 +1329,7 @@ Orientation=portrait
             <trans_set>
               <trans loc="de_AT" val="Overview"/>
               <trans loc="de_BE" val="Overview"/>
-              <trans loc="de_DE" val="Overview"/>
+              <trans loc="de" val="Overview"/>
               <trans loc="en_GB" val="Overview"/>
               <trans loc="en_US" val="Overview"/>
             </trans_set>
@@ -1344,7 +1344,7 @@ Orientation=portrait
             <trans_set>
               <trans loc="de_AT" val="Details"/>
               <trans loc="de_BE" val="Details"/>
-              <trans loc="de_DE" val="Details"/>
+              <trans loc="de" val="Details"/>
               <trans loc="en_GB" val="Details"/>
               <trans loc="en_US" val="Details"/>
             </trans_set>
@@ -1438,63 +1438,63 @@ Orientation=portrait
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Vorname"/>
-          <trans loc="de_DE" val="Vorname"/>
+          <trans loc="de" val="Vorname"/>
         </trans_set>
       </field>
       <field name="name_second" type="Text" title="Second Name">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Zweite Name"/>
-          <trans loc="de_DE" val="Zweite Name"/>
+          <trans loc="de" val="Zweite Name"/>
         </trans_set>
       </field>
       <field name="name_last" type="Text" title="Last Name">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Familiename"/>
-          <trans loc="de_DE" val="Familiename"/>
+          <trans loc="de" val="Familiename"/>
         </trans_set>
       </field>
       <field name="address_street" type="Text" title="Street">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Strasse"/>
-          <trans loc="de_DE" val="Strasse"/>
+          <trans loc="de" val="Strasse"/>
         </trans_set>
       </field>
       <field name="address_town" type="Text" title="Town">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Ort"/>
-          <trans loc="de_DE" val="Ort"/>
+          <trans loc="de" val="Ort"/>
         </trans_set>
       </field>
       <field name="address_state" type="Text" title="State">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Bundesland/Kanton"/>
-          <trans loc="de_DE" val="Bundesland/Kanton"/>
+          <trans loc="de" val="Bundesland/Kanton"/>
         </trans_set>
       </field>
       <field name="address_country" type="Text" title="Country">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Staat"/>
-          <trans loc="de_DE" val="Staat"/>
+          <trans loc="de" val="Staat"/>
         </trans_set>
       </field>
       <field name="address_postcode" type="Text" title="Postcode">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Postleitzahl"/>
-          <trans loc="de_DE" val="Postleitzahl"/>
+          <trans loc="de" val="Postleitzahl"/>
         </trans_set>
       </field>
       <field name="date_of_birth" type="Date" title="Date Of Birth">
         <formatting/>
         <trans_set>
           <trans loc="de_AT" val="Geburtsdatum"/>
-          <trans loc="de_DE" val="Geburtsdatum"/>
+          <trans loc="de" val="Geburtsdatum"/>
         </trans_set>
       </field>
       <field name="position" type="Text" title="Position">
@@ -1509,7 +1509,7 @@ Orientation=portrait
             <trans_set>
               <trans loc="de_AT" val="Overview"/>
               <trans loc="de_BE" val="Overview"/>
-              <trans loc="de_DE" val="Overview"/>
+              <trans loc="de" val="Overview"/>
               <trans loc="en_GB" val="Overview"/>
               <trans loc="en_US" val="Overview"/>
             </trans_set>
@@ -1528,7 +1528,7 @@ Orientation=portrait
               <trans_set>
                 <trans loc="de_AT" val="Name"/>
                 <trans loc="de_BE" val="Name"/>
-                <trans loc="de_DE" val="Name"/>
+                <trans loc="de" val="Name"/>
                 <trans loc="en_GB" val="Name"/>
                 <trans loc="en_US" val="Name"/>
               </trans_set>
@@ -1549,7 +1549,7 @@ Orientation=portrait
               <trans_set>
                 <trans loc="de_AT" val="Address"/>
                 <trans loc="de_BE" val="Address"/>
-                <trans loc="de_DE" val="Address"/>
+                <trans loc="de" val="Address"/>
                 <trans loc="en_GB" val="Address"/>
                 <trans loc="en_US" val="Address"/>
               </trans_set>
diff --git a/examples/sqlite/test_sqlite_music/test_sqlite_music.glom b/examples/sqlite/test_sqlite_music/test_sqlite_music.glom
index 8ee62a1..cd2dc4f 100644
--- a/examples/sqlite/test_sqlite_music/test_sqlite_music.glom
+++ b/examples/sqlite/test_sqlite_music/test_sqlite_music.glom
@@ -39,7 +39,7 @@
           <data_layout_group name="main">
             <data_layout_group name="overview" columns_count="2" title="Overview">
               <trans_set>
-                <trans loc="de_DE" val="Overview"/>
+                <trans loc="de" val="Overview"/>
               </trans_set>
               <data_layout_item name="album_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -50,11 +50,11 @@
             </data_layout_group>
             <data_layout_group name="details" columns_count="2" title="Details">
               <trans_set>
-                <trans loc="de_DE" val="Details"/>
+                <trans loc="de" val="Details"/>
               </trans_set>
               <data_layout_group name="artist" title="Artist">
                 <trans_set>
-                  <trans loc="de_DE" val="Artist"/>
+                  <trans loc="de" val="Artist"/>
                 </trans_set>
                 <data_layout_item name="artist_id" editable="true" use_default_formatting="true">
                   <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -65,7 +65,7 @@
               </data_layout_group>
               <data_layout_group name="publisher" title="Publisher">
                 <trans_set>
-                  <trans loc="de_DE" val="Publisher"/>
+                  <trans loc="de" val="Publisher"/>
                 </trans_set>
                 <data_layout_item name="publisher_id" editable="true" use_default_formatting="true">
                   <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -160,7 +160,7 @@
           <data_layout_group name="main">
             <data_layout_group name="overview" columns_count="2" title="Overview">
               <trans_set>
-                <trans loc="de_DE" val="Overview"/>
+                <trans loc="de" val="Overview"/>
               </trans_set>
               <data_layout_item name="artist_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -171,7 +171,7 @@
             </data_layout_group>
             <data_layout_group name="details" columns_count="2" title="Details">
               <trans_set>
-                <trans loc="de_DE" val="Details"/>
+                <trans loc="de" val="Details"/>
               </trans_set>
               <data_layout_item name="description" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
@@ -240,7 +240,7 @@
           <data_layout_group name="main">
             <data_layout_group name="overview" columns_count="2" title="Overview">
               <trans_set>
-                <trans loc="de_DE" val="Overview"/>
+                <trans loc="de" val="Overview"/>
               </trans_set>
               <data_layout_item name="publishers_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -251,7 +251,7 @@
             </data_layout_group>
             <data_layout_group name="details" title="Details">
               <trans_set>
-                <trans loc="de_DE" val="Details"/>
+                <trans loc="de" val="Details"/>
               </trans_set>
               <data_layout_item name="comments" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
@@ -318,7 +318,7 @@
           <data_layout_group name="main">
             <data_layout_group name="overview" columns_count="2" title="Overview">
               <trans_set>
-                <trans loc="de_DE" val="Overview"/>
+                <trans loc="de" val="Overview"/>
               </trans_set>
               <data_layout_item name="songs_id" editable="true" use_default_formatting="true">
                 <formatting format_thousands_separator="true" format_decimal_places="2"/>
@@ -329,7 +329,7 @@
             </data_layout_group>
             <data_layout_group name="details" columns_count="2" title="Details">
               <trans_set>
-                <trans loc="de_DE" val="Details"/>
+                <trans loc="de" val="Details"/>
               </trans_set>
               <data_layout_group name="album" title="Album">
                 <data_layout_item name="album_id" editable="true" use_default_formatting="true">
diff --git a/glom/test.glom b/glom/test.glom
index 8b8b1c4..a8fa7fc 100644
--- a/glom/test.glom
+++ b/glom/test.glom
@@ -10,14 +10,14 @@
 
 
 
-<table name="contacts" default="true" title="Contacts"><trans_set><trans loc="de_AT" val="Kontakten"/><trans loc="de_DE" val="Kontakten"/></trans_set><fields><field name="contact_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Contact ID"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Kontakt ID"/><trans loc="de_DE" val="Kontakt ID"/></trans_set></field><field name="name_first" type="Text" title="First Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Vorname"/><trans loc="de_DE" val="Vorname"/></trans_set></field><field name="name_middle" type="Text" title="Middle Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Zweite Name"/><trans loc="de_DE" val="Zweite Name"/></trans_set></field><field name="name_last" type="Text" title="Last Name"><formatting format_t
 housands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Familiename"/><trans loc="de_DE" val="Familiename"/></trans_set></field><field name="name_title" type="Text" title="Title"><formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true"><custom_choice_list><custom_choice value="Mr"/><custom_choice value="Mrs"/><custom_choice value="Ms"/><custom_choice value="Miss"/><custom_choice value="Dr"/><custom_choice value="Prof"/></custom_choice_list></formatting><trans_set><trans loc="de_DE" val="Titel"/></trans_set></field><field name="address_street" type="Text" title="Street"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Strasse"/><trans loc="de_DE" val="Strasse"/></trans_set></field><field name="address_town" type="Text" title="Town"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Ort"/><trans
  loc="de_DE" val="Ort"/></trans_set></field><field name="address_state" type="Text" title="State"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Bundesland/Kanton"/><trans loc="de_DE" val="Bundesland/Kanton"/></trans_set></field><field name="address_country" type="Text" title="Country"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Land"/><trans loc="de_DE" val="Land"/></trans_set></field><field name="address_postcode" type="Text" title="Postcode"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Postleitzahl"/><trans loc="de_DE" val="Postleitzahl"/></trans_set></field><field name="date_of_birth" type="Date" title="Date of Birth"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Geburtsdatum"/><trans loc="de_DE" val="Geburtsdatum"/></trans_s
 et></field><field name="comments" type="Text" title="Comments"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_AT" val="Kommentar"/><trans loc="de_DE" val="Kommentar"/></trans_set></field><field name="name_full" calculation="return record[&quot;name_first&quot;] + &quot; &quot; + record[&quot;name_last&quot;];" type="Text" title="Full Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Vollname"/><trans loc="de_DE" val="Vollname"/></trans_set></field><field name="picture" type="Image" title="Picture"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Bild"/><trans loc="de_DE" val="Bild"/></trans_set></field><field name="email" type="Text" title="Email Address"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="E-mail Addres
 se"/><trans loc="de_DE" val="E-mail Addresse"/></trans_set></field><field name="website" type="Text" title="Web Site"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Website"/><trans loc="de_DE" val="Website"/></trans_set></field><field name="tel_home" type="Text" title="Home Telephone"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="tel_work" type="Text" title="Work Telephone"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="tel_mobile" type="Text" title="Mobile Telephone"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="tel_fax" type="Text" title="Fax"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Fax"/><trans loc="de_DE" val="Fax"/></trans_set></field></fields><relationships/><data_layouts><data_layout name="details" p
 arent_table="contacts"><data_layout_groups><data_layout_group name="header" columns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_AT" val="Ubersicht"/><trans loc="de_BE" val="Overview"/><trans loc="de_DE" val="Ubersicht"/><trans loc="en_GB" val="Overview"/><trans loc="en_US" val="Overview"/></trans_set><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="main" columns_count="2" sequence="2"><data_layout_group name="name" columns_count="1" sequence="1" title="Name"><trans_set><trans loc="de_AT" val="Name"/><trans loc="de_BE" val="Name"/><trans loc="de_DE" val="Name"/><trans loc="en_GB" val="Name"/><trans loc="en_U
 S" val="Name"/></trans_set><data_layout_item name="name_title" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_first" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_middle" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_last" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="address" columns_count="1" sequence="2" title="Address"><trans_set><trans loc="de_AT" val="Addresse"/><trans loc="de_BE" val="Address"/><trans loc="de_DE" val="Addresse"
 /><trans loc="en_GB" val="Address"/><trans loc="en_US" val="Address"/></trans_set><data_layout_item name="address_street" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_town" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_state" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_postcode" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true
 " format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="telephone" columns_count="1" sequence="3" title="Telephone"><trans_set><trans loc="de_AT" val="Telefon"/><trans loc="de_BE" val="Telephone"/><trans loc="de_DE" val="Telefon"/><trans loc="en_GB" val="Telephone"/><trans loc="en_US" val="Telephone"/></trans_set><data_layout_item name="tel_work" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="tel_mobile" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="tel_home" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="tel_fax" editable="true" use_default_formatting="true" s
 equence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_item name="date_of_birth" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="picture" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/></data_layout_item><data_layout_item name="website" editable="true" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="email" editable="true" use_default_formatting="true" sequence="8"><fo
 rmatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_button script="# example helloworld.py&#10;&#10;import pygtk&#10;pygtk.require('2.0')&#10;import gtk&#10;&#10;class HelloWorld:&#10;&#10;    # This is a callback function. The data arguments are ignored&#10;    # in this example. More on callbacks below.&#10;    def hello(self, widget, data=None):&#10;        print &quot;Hello World&quot;&#10;&#10;    def delete_event(self, widget, event, data=None):&#10;        # If you return FALSE in the &quot;delete_event&quot; signal handler,&#10;        # GTK will emit the &quot;destroy&quot; signal. Returning TRUE means&#10;        # you don't want the window to be destroyed.&#10;        # This is useful for popping up 'are you sure you want to quit?'&#10;        # type dialogs.&#10;&#10;        # Change FALSE to TRUE and the main window will not be destroyed&#10;        # with a &quot;delete_event&quot;.&#10;        return False&#10;
 &#10;    def destroy(self, widget, data=None):&#10;        gtk.main_quit()&#10;&#10;    def __init__(self):&#10;        # create a new window&#10;        self.window = gtk.Window(gtk.WINDOW_TOPLEVEL)&#10;    &#10;        # When the window is given the &quot;delete_event&quot; signal (this is given&#10;        # by the window manager, usually by the &quot;close&quot; option, or on the&#10;        # titlebar), we ask it to call the delete_event () function&#10;        # as defined above. The data passed to the callback&#10;        # function is NULL and is ignored in the callback function.&#10;        self.window.connect(&quot;delete_event&quot;, self.delete_event)&#10;    &#10;        # Here we connect the &quot;destroy&quot; event to a signal handler.  &#10;        # This event occurs when we call gtk_widget_destroy() on the window,&#10;        # or if we return FALSE in the &quot;delete_event&quot; callback.&#10;        self.window.connect(&quot;destroy&quot;, self.destroy)
 &#10;    &#10;        # Sets the border width of the window.&#10;        self.window.set_border_width(10)&#10;    &#10;        # Creates a new button with the label &quot;Hello World&quot;.&#10;        contact_name = record[&quot;name_full&quot;];&#10;        self.button = gtk.Button(&quot;Hello World, &quot; + contact_name)&#10;    &#10;        # When the button receives the &quot;clicked&quot; signal, it will call the&#10;        # function hello() passing it None as its argument.  The hello()&#10;        # function is defined above.&#10;        self.button.connect(&quot;clicked&quot;, self.hello, None)&#10;    &#10;        # This will cause the window to be destroyed by calling&#10;        # gtk_widget_destroy(window) when &quot;clicked&quot;.  Again, the destroy&#10;        # signal could come from here, or the window manager.&#10;        self.button.connect_object(&quot;clicked&quot;, gtk.Widget.destroy, self.window)&#10;    &#10;        # This packs the button into the
  window (a GTK container).&#10;        self.window.add(self.button)&#10;    &#10;        # The final step is to display this newly created widget.&#10;        self.button.show()&#10;    &#10;        # and the window&#10;        self.window.show()&#10;&#10;    def main(self):&#10;        # All PyGTK applications must have a gtk.main(). Control ends here&#10;        # and waits for an event to occur (like a key press or mouse event).&#10;        gtk.main()&#10;&#10;# If the program is run directly or passed as an argument to the python&#10;# interpreter then create a HelloWorld instance and show it&#10;if __name__ == &quot;__main__&quot;:&#10;    hello = HelloWorld()&#10;    hello.main()&#10;" title="Test Button" sequence="9"/></data_layout_group></data_layout_groups></data_layout><data_layout name="list" parent_table="contacts"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="contact_id" use_default_formatting="true" se
 quence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_title" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_first" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_last" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="t
 rue" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports><report name="by_country" title="Contacts By Country"><data_layout_groups><data_layout_group name="" columns_count="1"><data_layout_item_groupby name="" columns_count="1" sequence="1"><groupby name="address_country" editable="true" use_default_formatting="true"><formatting format_thousands_separator="true" format_decimal_places="2"/></groupby><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_item_groupby></data_layout_group></data_layout_groups></report><report name="by_country_by_town" title="By Country, By Town"><d
 ata_layout_groups><data_layout_group name="" columns_count="1"><data_layout_item_groupby name="" columns_count="1" sequence="1"><groupby name="address_country" editable="true" use_default_formatting="true"><formatting format_thousands_separator="true" format_decimal_places="2"/></groupby><data_layout_item_groupby name="" columns_count="1" sequence="1"><groupby name="address_town" editable="true" use_default_formatting="true"><formatting format_thousands_separator="true" format_decimal_places="2"/></groupby><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_postcode" editable="true" use_default_formatting="true" sequence="3"><fo
 rmatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_item_groupby></data_layout_item_groupby></data_layout_group></data_layout_groups></report></reports>
+<table name="contacts" default="true" title="Contacts"><trans_set><trans loc="de_AT" val="Kontakten"/><trans loc="de" val="Kontakten"/></trans_set><fields><field name="contact_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Contact ID"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Kontakt ID"/><trans loc="de" val="Kontakt ID"/></trans_set></field><field name="name_first" type="Text" title="First Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Vorname"/><trans loc="de" val="Vorname"/></trans_set></field><field name="name_middle" type="Text" title="Middle Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Zweite Name"/><trans loc="de" val="Zweite Name"/></trans_set></field><field name="name_last" type="Text" title="Last Name"><formatting format_thousands_sep
 arator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Familiename"/><trans loc="de" val="Familiename"/></trans_set></field><field name="name_title" type="Text" title="Title"><formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true"><custom_choice_list><custom_choice value="Mr"/><custom_choice value="Mrs"/><custom_choice value="Ms"/><custom_choice value="Miss"/><custom_choice value="Dr"/><custom_choice value="Prof"/></custom_choice_list></formatting><trans_set><trans loc="de" val="Titel"/></trans_set></field><field name="address_street" type="Text" title="Street"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Strasse"/><trans loc="de" val="Strasse"/></trans_set></field><field name="address_town" type="Text" title="Town"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Ort"/><trans loc="de" val="Ort"/>
 </trans_set></field><field name="address_state" type="Text" title="State"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Bundesland/Kanton"/><trans loc="de" val="Bundesland/Kanton"/></trans_set></field><field name="address_country" type="Text" title="Country"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Land"/><trans loc="de" val="Land"/></trans_set></field><field name="address_postcode" type="Text" title="Postcode"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Postleitzahl"/><trans loc="de" val="Postleitzahl"/></trans_set></field><field name="date_of_birth" type="Date" title="Date of Birth"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Geburtsdatum"/><trans loc="de" val="Geburtsdatum"/></trans_set></field><field name="comments" ty
 pe="Text" title="Comments"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_AT" val="Kommentar"/><trans loc="de" val="Kommentar"/></trans_set></field><field name="name_full" calculation="return record[&quot;name_first&quot;] + &quot; &quot; + record[&quot;name_last&quot;];" type="Text" title="Full Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Vollname"/><trans loc="de" val="Vollname"/></trans_set></field><field name="picture" type="Image" title="Picture"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Bild"/><trans loc="de" val="Bild"/></trans_set></field><field name="email" type="Text" title="Email Address"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="E-mail Addresse"/><trans loc="de" val="E-mail Addresse"/><
 /trans_set></field><field name="website" type="Text" title="Web Site"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Website"/><trans loc="de" val="Website"/></trans_set></field><field name="tel_home" type="Text" title="Home Telephone"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="tel_work" type="Text" title="Work Telephone"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="tel_mobile" type="Text" title="Mobile Telephone"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="tel_fax" type="Text" title="Fax"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Fax"/><trans loc="de" val="Fax"/></trans_set></field></fields><relationships/><data_layouts><data_layout name="details" parent_table="contacts"><data_layout_groups><data_layou
 t_group name="header" columns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_AT" val="Ubersicht"/><trans loc="de_BE" val="Overview"/><trans loc="de" val="Ubersicht"/><trans loc="en_GB" val="Overview"/><trans loc="en_US" val="Overview"/></trans_set><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="main" columns_count="2" sequence="2"><data_layout_group name="name" columns_count="1" sequence="1" title="Name"><trans_set><trans loc="de_AT" val="Name"/><trans loc="de_BE" val="Name"/><trans loc="de" val="Name"/><trans loc="en_GB" val="Name"/><trans loc="en_US" val="Name"/></trans_set><data_layout_item name="name_titl
 e" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_first" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_middle" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_last" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="address" columns_count="1" sequence="2" title="Address"><trans_set><trans loc="de_AT" val="Addresse"/><trans loc="de_BE" val="Address"/><trans loc="de" val="Addresse"/><trans loc="en_GB" val="Address"/><trans loc="en_US" val="Add
 ress"/></trans_set><data_layout_item name="address_street" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_town" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_state" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_postcode" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_g
 roup><data_layout_group name="telephone" columns_count="1" sequence="3" title="Telephone"><trans_set><trans loc="de_AT" val="Telefon"/><trans loc="de_BE" val="Telephone"/><trans loc="de" val="Telefon"/><trans loc="en_GB" val="Telephone"/><trans loc="en_US" val="Telephone"/></trans_set><data_layout_item name="tel_work" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="tel_mobile" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="tel_home" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="tel_fax" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_d
 ecimal_places="2"/></data_layout_item></data_layout_group><data_layout_item name="date_of_birth" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="picture" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/></data_layout_item><data_layout_item name="website" editable="true" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="email" editable="true" use_default_formatting="true" sequence="8"><formatting format_thousands_separator="true" format_decimal_places="
 2"/></data_layout_item><data_layout_button script="# example helloworld.py&#10;&#10;import pygtk&#10;pygtk.require('2.0')&#10;import gtk&#10;&#10;class HelloWorld:&#10;&#10;    # This is a callback function. The data arguments are ignored&#10;    # in this example. More on callbacks below.&#10;    def hello(self, widget, data=None):&#10;        print &quot;Hello World&quot;&#10;&#10;    def delete_event(self, widget, event, data=None):&#10;        # If you return FALSE in the &quot;delete_event&quot; signal handler,&#10;        # GTK will emit the &quot;destroy&quot; signal. Returning TRUE means&#10;        # you don't want the window to be destroyed.&#10;        # This is useful for popping up 'are you sure you want to quit?'&#10;        # type dialogs.&#10;&#10;        # Change FALSE to TRUE and the main window will not be destroyed&#10;        # with a &quot;delete_event&quot;.&#10;        return False&#10;&#10;    def destroy(self, widget, data=None):&#10;        gtk.mai
 n_quit()&#10;&#10;    def __init__(self):&#10;        # create a new window&#10;        self.window = gtk.Window(gtk.WINDOW_TOPLEVEL)&#10;    &#10;        # When the window is given the &quot;delete_event&quot; signal (this is given&#10;        # by the window manager, usually by the &quot;close&quot; option, or on the&#10;        # titlebar), we ask it to call the delete_event () function&#10;        # as defined above. The data passed to the callback&#10;        # function is NULL and is ignored in the callback function.&#10;        self.window.connect(&quot;delete_event&quot;, self.delete_event)&#10;    &#10;        # Here we connect the &quot;destroy&quot; event to a signal handler.  &#10;        # This event occurs when we call gtk_widget_destroy() on the window,&#10;        # or if we return FALSE in the &quot;delete_event&quot; callback.&#10;        self.window.connect(&quot;destroy&quot;, self.destroy)&#10;    &#10;        # Sets the border width of the window.&#10; 
        self.window.set_border_width(10)&#10;    &#10;        # Creates a new button with the label &quot;Hello World&quot;.&#10;        contact_name = record[&quot;name_full&quot;];&#10;        self.button = gtk.Button(&quot;Hello World, &quot; + contact_name)&#10;    &#10;        # When the button receives the &quot;clicked&quot; signal, it will call the&#10;        # function hello() passing it None as its argument.  The hello()&#10;        # function is defined above.&#10;        self.button.connect(&quot;clicked&quot;, self.hello, None)&#10;    &#10;        # This will cause the window to be destroyed by calling&#10;        # gtk_widget_destroy(window) when &quot;clicked&quot;.  Again, the destroy&#10;        # signal could come from here, or the window manager.&#10;        self.button.connect_object(&quot;clicked&quot;, gtk.Widget.destroy, self.window)&#10;    &#10;        # This packs the button into the window (a GTK container).&#10;        self.window.add(self.button
 )&#10;    &#10;        # The final step is to display this newly created widget.&#10;        self.button.show()&#10;    &#10;        # and the window&#10;        self.window.show()&#10;&#10;    def main(self):&#10;        # All PyGTK applications must have a gtk.main(). Control ends here&#10;        # and waits for an event to occur (like a key press or mouse event).&#10;        gtk.main()&#10;&#10;# If the program is run directly or passed as an argument to the python&#10;# interpreter then create a HelloWorld instance and show it&#10;if __name__ == &quot;__main__&quot;:&#10;    hello = HelloWorld()&#10;    hello.main()&#10;" title="Test Button" sequence="9"/></data_layout_group></data_layout_groups></data_layout><data_layout name="list" parent_table="contacts"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="contact_id" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_de
 cimal_places="2"/></data_layout_item><data_layout_item name="name_title" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_first" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_last" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_g
 roup></data_layout_groups></data_layout></data_layouts><reports><report name="by_country" title="Contacts By Country"><data_layout_groups><data_layout_group name="" columns_count="1"><data_layout_item_groupby name="" columns_count="1" sequence="1"><groupby name="address_country" editable="true" use_default_formatting="true"><formatting format_thousands_separator="true" format_decimal_places="2"/></groupby><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_item_groupby></data_layout_group></data_layout_groups></report><report name="by_country_by_town" title="By Country, By Town"><data_layout_groups><data_layout_group name="" columns_count="1"><da
 ta_layout_item_groupby name="" columns_count="1" sequence="1"><groupby name="address_country" editable="true" use_default_formatting="true"><formatting format_thousands_separator="true" format_decimal_places="2"/></groupby><data_layout_item_groupby name="" columns_count="1" sequence="1"><groupby name="address_town" editable="true" use_default_formatting="true"><formatting format_thousands_separator="true" format_decimal_places="2"/></groupby><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_postcode" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="
 2"/></data_layout_item></data_layout_item_groupby></data_layout_item_groupby></data_layout_group></data_layout_groups></report></reports>
 
-</table><table name="invoice_lines" hidden="true"><fields><field name="invoice_lines_id" primary_key="true" unique="true" auto_increment="true" type="Number"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="product_name" type="Text" title="Product Name"><field_lookup relationship="products" field="name"/><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Produkt Name"/><trans loc="de_DE" val="Produkt Name"/></trans_set></field><field name="product_id" type="Number" title="Product Id"><formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="products" choices_related_field="product_id" choices_related_second="name"/><trans_set><trans loc="de_AT" val="Produkt ID"/><trans loc="de_DE" val="Produkt ID"/></trans_set></field><field name="product_price" type="Number" title="Product Price"><field_lookup relationship="
 products" field="price"/><formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/><trans_set><trans loc="de_AT" val="Produkt Preis"/><trans loc="de_DE" val="Produkt Preis"/></trans_set></field><field name="invoice_id" type="Number" title="Invoice ID"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Rechnung ID"/><trans loc="de_DE" val="Rechnung ID"/></trans_set></field><field name="count" default_value="1" type="Number" title="Number Of"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Menge"/><trans loc="de_DE" val="Menge"/></trans_set></field><field name="total_price" calculation="return record[&quot;count&quot;] * record[&quot;product_price&quot;];" type="Number" title="Total Price"><formatting format_thousands_separator="true" format_decimal_places_restricted="true" forma
 t_decimal_places="2" format_currency_symbol="EUR"/><trans_set><trans loc="de_AT" val="Gesamtpreis"/><trans loc="de_DE" val="Gesamtpreis"/></trans_set></field><field name="vat_percentage" type="Number" title="VAT Percentage"><field_lookup relationship="products" field="vat_percent"/><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="MwST Prozent"/><trans loc="de_DE" val="MwST Prozent"/></trans_set></field><field name="total_price_vat" calculation="return record[&quot;total_price&quot;] * (record[&quot;vat_percentage&quot;] / 100);" type="Number" title="Total VAT"><formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/><trans_set><trans loc="de_AT" val="Gesamt MwST"/><trans loc="de_DE" val="Gesamt MwST"/></trans_set></field></fields><relationships><relationship name="products" key="product_id" other_table="products" other_key="product_i
 d"><trans_set><trans loc="de_AT" val="Produkten"/><trans loc="de_DE" val="Produkten"/></trans_set></relationship></relationships><data_layouts><data_layout name="details" parent_table="invoice_lines"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="invoice_lines_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="invoice_id" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_id" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_name" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="tru
 e" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_price" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="count" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="vat_percentage" editable="true" use_default_formatting="true" sequence="8"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price_vat" use_default_formatting="true" sequence="9"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_la
 yout_groups></data_layout><data_layout name="list" parent_table="invoice_lines"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="invoice_lines_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="invoice_id" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_id" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_name" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_price" editable="true" use_default_form
 atting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="count" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price" editable="true" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>
+</table><table name="invoice_lines" hidden="true"><fields><field name="invoice_lines_id" primary_key="true" unique="true" auto_increment="true" type="Number"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="product_name" type="Text" title="Product Name"><field_lookup relationship="products" field="name"/><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Produkt Name"/><trans loc="de" val="Produkt Name"/></trans_set></field><field name="product_id" type="Number" title="Product Id"><formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="products" choices_related_field="product_id" choices_related_second="name"/><trans_set><trans loc="de_AT" val="Produkt ID"/><trans loc="de" val="Produkt ID"/></trans_set></field><field name="product_price" type="Number" title="Product Price"><field_lookup relationship="produc
 ts" field="price"/><formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/><trans_set><trans loc="de_AT" val="Produkt Preis"/><trans loc="de" val="Produkt Preis"/></trans_set></field><field name="invoice_id" type="Number" title="Invoice ID"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Rechnung ID"/><trans loc="de" val="Rechnung ID"/></trans_set></field><field name="count" default_value="1" type="Number" title="Number Of"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Menge"/><trans loc="de" val="Menge"/></trans_set></field><field name="total_price" calculation="return record[&quot;count&quot;] * record[&quot;product_price&quot;];" type="Number" title="Total Price"><formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_place
 s="2" format_currency_symbol="EUR"/><trans_set><trans loc="de_AT" val="Gesamtpreis"/><trans loc="de" val="Gesamtpreis"/></trans_set></field><field name="vat_percentage" type="Number" title="VAT Percentage"><field_lookup relationship="products" field="vat_percent"/><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="MwST Prozent"/><trans loc="de" val="MwST Prozent"/></trans_set></field><field name="total_price_vat" calculation="return record[&quot;total_price&quot;] * (record[&quot;vat_percentage&quot;] / 100);" type="Number" title="Total VAT"><formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/><trans_set><trans loc="de_AT" val="Gesamt MwST"/><trans loc="de" val="Gesamt MwST"/></trans_set></field></fields><relationships><relationship name="products" key="product_id" other_table="products" other_key="product_id"><trans_set><trans loc
 ="de_AT" val="Produkten"/><trans loc="de" val="Produkten"/></trans_set></relationship></relationships><data_layouts><data_layout name="details" parent_table="invoice_lines"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="invoice_lines_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="invoice_id" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_id" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_name" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2
 "/></data_layout_item><data_layout_item name="product_price" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="count" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="vat_percentage" editable="true" use_default_formatting="true" sequence="8"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price_vat" use_default_formatting="true" sequence="9"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout><
 data_layout name="list" parent_table="invoice_lines"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="invoice_lines_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="invoice_id" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_id" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_name" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_price" editable="true" use_default_formatting="true" sequence="5">
 <formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="count" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price" editable="true" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>
 
-</table><table name="invoices" title="Invoices"><trans_set><trans loc="de_AT" val="Rechnungen"/><trans loc="de_DE" val="Rechnungen"/></trans_set><fields><field name="invoice_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Invoice ID"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Rechnung ID"/><trans loc="de_DE" val="Rechnung ID"/></trans_set></field><field name="contact_id" type="Number" title="Contact ID"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Kontakt ID"/><trans loc="de_DE" val="Kontakt ID"/></trans_set></field><field name="date" type="Date" title="Date"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Datum"/><trans loc="de_DE" val="Datum"/></trans_set></field><field name="comment" type="Text" title="Comment"><formatting format_thousands_separator="true"
  format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_AT" val="Kommentar"/><trans loc="de_DE" val="Kommentar"/></trans_set></field><field name="price_total" calculation="return record.related[&quot;invoice_lines&quot;].sum(&quot;total_price&quot;);" type="Number" title="Total Price"><formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/><trans_set><trans loc="de_AT" val="Gesamtpreis"/><trans loc="de_DE" val="Gesamtpreis"/></trans_set></field><field name="vat_total" default_value="16" calculation="return record.related[&quot;invoice_lines&quot;].sum(&quot;total_price_vat&quot;);" type="Number" title="Total VAT"><formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/><trans_set><trans loc="de_AT" val="Gesamt MwST"/><trans loc="de_DE" val="Gesamt MwST"/></trans_set></field><field
  name="price_total_with_vat" calculation="return record[&quot;price_total&quot;] + record[&quot;vat_total&quot;];" type="Number" title="Total Price With Vat"><formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/><trans_set><trans loc="de_AT" val="Gesamtpreis mit MwST"/><trans loc="de_DE" val="Gesamtpreis mit MwST"/></trans_set></field></fields><relationships><relationship name="invoice_lines" key="invoice_id" other_table="invoice_lines" other_key="invoice_id" auto_create="true" allow_edit="true" title="Invoice Lines"><trans_set><trans loc="de_AT" val="Rechnung Reihen"/><trans loc="de_DE" val="Rechnung Reihen"/></trans_set></relationship><relationship name="contacts" key="contact_id" other_table="contacts" other_key="contact_id" title="Contacts"><trans_set><trans loc="de_AT" val="Kontakten"/><trans loc="de_DE" val="Kontakten"/></trans_set></relationship></relationships><data_layouts><data_
 layout name="details" parent_table="invoices"><data_layout_groups><data_layout_group name="header" columns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_AT" val="&#xDC;bersicht"/><trans loc="de_BE" val="Overview"/><trans loc="de_DE" val="&#xDC;bersicht"/><trans loc="en_GB" val="Overview"/><trans loc="en_US" val="Overview"/></trans_set><data_layout_item name="invoice_id" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="date" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="main" columns_count="1" sequence="2"><data_layout_group name="customer" columns_count="2" sequence="1" title="Customer"><trans_set><trans loc="de_AT" val="Kunde"/><trans loc="de_BE" val="Customer"/><trans loc="de_DE" val="Kunde"/><tran
 s loc="en_GB" val="Customer"/><trans loc="en_US" val="Customer"/></trans_set><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" relationship="contacts" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_portal relationship="invoice_lines" name="" sequence="2"><data_layout_item name="product_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_price" editable="true" use_defaul
 t_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="vat_percentage" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="count" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price_vat" editable="true" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_portal><data_layout_item name="price_total" use_default_formatting="true" sequence="3"><formattin
 g format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="CAD"/></data_layout_item><data_layout_item name="vat_total" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="price_total_with_vat" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comment" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout><data_layout name="list" parent_table="invoices"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="invoice_id" use_default_formatting="true" sequence="1"><formatting format_thousands_separator
 ="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="price_total" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="date" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comment" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></da
 ta_layout_item></data_layout_group></data_layout_groups></data_layout><data_layout name="list_related_related_invoice_lines" parent_table="invoices"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="product_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_price" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="count" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layo
 ut_item name="total_price" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="vat_percentage" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price_vat" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout><data_layout name="list_related_related_invoice_lines" parent_table="invoice_lines"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="product_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_name" editable="true
 " use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_price" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="count" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="vat_percentage" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price_vat" use_default_formatting="true" sequence="7"><formatting format_thousands_sepa
 rator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports><report name="By Customer" title="By Customer"><data_layout_groups><data_layout_group name="" columns_count="1"><data_layout_item_groupby name="" columns_count="1" sequence="1"><groupby name="contact_id" editable="true" use_default_formatting="true"><formatting format_thousands_separator="true" format_decimal_places="2"/></groupby><secondary_fields><data_layout_group name="" columns_count="1"><data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></secondary_fields><data_layout_item name="invoice_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item n
 ame="date" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="price_total" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="price_total_with_vat" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item_summary name="" columns_count="1" sequence="5"><data_layout_item_fieldsummary name="price_total" editable="true" use_default_formatting="true" sequence="1" summarytype="SUM"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item_fieldsummary><data_layout_item_fieldsummary name="price_total_with_vat" editable="true" use_default_formatting="true" sequence="2" summarytype="SUM"><formatti
 ng format_thousands_separator="true" format_decimal_places="2"/></data_layout_item_fieldsummary></data_layout_item_summary></data_layout_item_groupby></data_layout_group></data_layout_groups></report></reports>
+</table><table name="invoices" title="Invoices"><trans_set><trans loc="de_AT" val="Rechnungen"/><trans loc="de" val="Rechnungen"/></trans_set><fields><field name="invoice_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Invoice ID"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Rechnung ID"/><trans loc="de" val="Rechnung ID"/></trans_set></field><field name="contact_id" type="Number" title="Contact ID"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Kontakt ID"/><trans loc="de" val="Kontakt ID"/></trans_set></field><field name="date" type="Date" title="Date"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Datum"/><trans loc="de" val="Datum"/></trans_set></field><field name="comment" type="Text" title="Comment"><formatting format_thousands_separator="true" format_deci
 mal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_AT" val="Kommentar"/><trans loc="de" val="Kommentar"/></trans_set></field><field name="price_total" calculation="return record.related[&quot;invoice_lines&quot;].sum(&quot;total_price&quot;);" type="Number" title="Total Price"><formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/><trans_set><trans loc="de_AT" val="Gesamtpreis"/><trans loc="de" val="Gesamtpreis"/></trans_set></field><field name="vat_total" default_value="16" calculation="return record.related[&quot;invoice_lines&quot;].sum(&quot;total_price_vat&quot;);" type="Number" title="Total VAT"><formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/><trans_set><trans loc="de_AT" val="Gesamt MwST"/><trans loc="de" val="Gesamt MwST"/></trans_set></field><field name="price_total_wi
 th_vat" calculation="return record[&quot;price_total&quot;] + record[&quot;vat_total&quot;];" type="Number" title="Total Price With Vat"><formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/><trans_set><trans loc="de_AT" val="Gesamtpreis mit MwST"/><trans loc="de" val="Gesamtpreis mit MwST"/></trans_set></field></fields><relationships><relationship name="invoice_lines" key="invoice_id" other_table="invoice_lines" other_key="invoice_id" auto_create="true" allow_edit="true" title="Invoice Lines"><trans_set><trans loc="de_AT" val="Rechnung Reihen"/><trans loc="de" val="Rechnung Reihen"/></trans_set></relationship><relationship name="contacts" key="contact_id" other_table="contacts" other_key="contact_id" title="Contacts"><trans_set><trans loc="de_AT" val="Kontakten"/><trans loc="de" val="Kontakten"/></trans_set></relationship></relationships><data_layouts><data_layout name="details" parent_t
 able="invoices"><data_layout_groups><data_layout_group name="header" columns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_AT" val="&#xDC;bersicht"/><trans loc="de_BE" val="Overview"/><trans loc="de" val="&#xDC;bersicht"/><trans loc="en_GB" val="Overview"/><trans loc="en_US" val="Overview"/></trans_set><data_layout_item name="invoice_id" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="date" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="main" columns_count="1" sequence="2"><data_layout_group name="customer" columns_count="2" sequence="1" title="Customer"><trans_set><trans loc="de_AT" val="Kunde"/><trans loc="de_BE" val="Customer"/><trans loc="de" val="Kunde"/><trans loc="en_GB" val="Customer"/><trans
  loc="en_US" val="Customer"/></trans_set><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" relationship="contacts" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_portal relationship="invoice_lines" name="" sequence="2"><data_layout_item name="product_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_price" editable="true" use_default_formatting="true" sequence="3"><fo
 rmatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="vat_percentage" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="count" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price_vat" editable="true" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_portal><data_layout_item name="price_total" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" 
 format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="CAD"/></data_layout_item><data_layout_item name="vat_total" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="price_total_with_vat" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comment" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout><data_layout name="list" parent_table="invoices"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="invoice_id" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/><
 /data_layout_item><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="price_total" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="date" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comment" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><
 /data_layout_groups></data_layout><data_layout name="list_related_related_invoice_lines" parent_table="invoices"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="product_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_price" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="count" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price" use_defau
 lt_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="vat_percentage" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price_vat" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout><data_layout name="list_related_related_invoice_lines" parent_table="invoice_lines"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="product_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_name" editable="true" use_default_formatting="true" sequ
 ence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="product_price" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="count" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="vat_percentage" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="total_price_vat" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="
 2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports><report name="By Customer" title="By Customer"><data_layout_groups><data_layout_group name="" columns_count="1"><data_layout_item_groupby name="" columns_count="1" sequence="1"><groupby name="contact_id" editable="true" use_default_formatting="true"><formatting format_thousands_separator="true" format_decimal_places="2"/></groupby><secondary_fields><data_layout_group name="" columns_count="1"><data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></secondary_fields><data_layout_item name="invoice_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="date" editable="true" use_defau
 lt_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="price_total" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="price_total_with_vat" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item_summary name="" columns_count="1" sequence="5"><data_layout_item_fieldsummary name="price_total" editable="true" use_default_formatting="true" sequence="1" summarytype="SUM"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item_fieldsummary><data_layout_item_fieldsummary name="price_total_with_vat" editable="true" use_default_formatting="true" sequence="2" summarytype="SUM"><formatting format_thousands_separator="true"
  format_decimal_places="2"/></data_layout_item_fieldsummary></data_layout_item_summary></data_layout_item_groupby></data_layout_group></data_layout_groups></report></reports>
 
-</table><table name="products" title="Products"><trans_set><trans loc="de_AT" val="Produkten"/><trans loc="de_DE" val="Produkten"/></trans_set><fields><field name="product_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Product ID"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Produkt ID"/><trans loc="de_DE" val="Produkt ID"/></trans_set></field><field name="comment" type="Text" title="Comment"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Kommentar"/><trans loc="de_DE" val="Kommentar"/></trans_set></field><field name="description" type="Text" title="Description"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Beschreibung"/><trans loc="de_DE" val="Beschreibung"/></trans_set></field><field name="name" type="Text" title="Name"><formatting format_thousands_separato
 r="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Name"/><trans loc="de_DE" val="Name"/></trans_set></field><field name="price" type="Number" title="Price"><formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/><trans_set><trans loc="de_AT" val="Preis"/><trans loc="de_DE" val="Preis"/></trans_set></field><field name="vat_percent" default_value="16" type="Number" title="Vat Percent"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="MwST Prozent"/><trans loc="de_DE" val="MwST Prozent"/></trans_set></field></fields><relationships/><data_layouts><data_layout name="details" parent_table="products"><data_layout_groups><data_layout_group name="header" columns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_AT" val="Overview"/><trans loc="de_BE" val="Overview"/><trans loc="de_DE" val="Overview"/><trans
  loc="en_GB" val="Overview"/><trans loc="en_US" val="Overview"/></trans_set><data_layout_item name="product_id" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="main" columns_count="2" sequence="2" title="Details"><trans_set><trans loc="de_AT" val="Details"/><trans loc="de_BE" val="Details"/><trans loc="de_DE" val="Details"/><trans loc="en_GB" val="Details"/><trans loc="en_US" val="Details"/></trans_set><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="price" editable="true" use_default_formatting="true" seque
 nce="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="vat_percent" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comment" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout><data_layout name="list" parent_table="products"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="product_id" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"
 /></data_layout_item><data_layout_item name="price" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comment" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>
+</table><table name="products" title="Products"><trans_set><trans loc="de_AT" val="Produkten"/><trans loc="de" val="Produkten"/></trans_set><fields><field name="product_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Product ID"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Produkt ID"/><trans loc="de" val="Produkt ID"/></trans_set></field><field name="comment" type="Text" title="Comment"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Kommentar"/><trans loc="de" val="Kommentar"/></trans_set></field><field name="description" type="Text" title="Description"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Beschreibung"/><trans loc="de" val="Beschreibung"/></trans_set></field><field name="name" type="Text" title="Name"><formatting format_thousands_separator="true" for
 mat_decimal_places="2"/><trans_set><trans loc="de_AT" val="Name"/><trans loc="de" val="Name"/></trans_set></field><field name="price" type="Number" title="Price"><formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/><trans_set><trans loc="de_AT" val="Preis"/><trans loc="de" val="Preis"/></trans_set></field><field name="vat_percent" default_value="16" type="Number" title="Vat Percent"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="MwST Prozent"/><trans loc="de" val="MwST Prozent"/></trans_set></field></fields><relationships/><data_layouts><data_layout name="details" parent_table="products"><data_layout_groups><data_layout_group name="header" columns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_AT" val="Overview"/><trans loc="de_BE" val="Overview"/><trans loc="de" val="Overview"/><trans loc="en_GB" val="Overvi
 ew"/><trans loc="en_US" val="Overview"/></trans_set><data_layout_item name="product_id" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="main" columns_count="2" sequence="2" title="Details"><trans_set><trans loc="de_AT" val="Details"/><trans loc="de_BE" val="Details"/><trans loc="de" val="Details"/><trans loc="en_GB" val="Details"/><trans loc="en_US" val="Details"/></trans_set><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="price" editable="true" use_default_formatting="true" sequence="2"><formatting format_
 thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="vat_percent" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comment" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout><data_layout name="list" parent_table="products"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="product_id" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_
 layout_item name="price" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comment" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>
 
-</table><table name="staff" title="Staff"><fields><field name="staff_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Staff ID"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="name_title" type="Text" title="Title"><formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true"><custom_choice_list><custom_choice value="Mr"/><custom_choice value="Mrs"/><custom_choice value="Miss"/><custom_choice value="Dr"/><custom_choice value="Prof"/></custom_choice_list></formatting></field><field name="name_first" type="Text" title="First Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Vorname"/><trans loc="de_DE" val="Vorname"/></trans_set></field><field name="name_second" type="Text" title="Second Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Zweite N
 ame"/><trans loc="de_DE" val="Zweite Name"/></trans_set></field><field name="name_last" type="Text" title="Last Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Familiename"/><trans loc="de_DE" val="Familiename"/></trans_set></field><field name="address_street" type="Text" title="Street"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Strasse"/><trans loc="de_DE" val="Strasse"/></trans_set></field><field name="address_town" type="Text" title="Town"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Ort"/><trans loc="de_DE" val="Ort"/></trans_set></field><field name="address_state" type="Text" title="State"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Bundesland/Kanton"/><trans loc="de_DE" val="Bundesland/Kanton"/></trans_set></field><
 field name="address_country" type="Text" title="Country"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Staat"/><trans loc="de_DE" val="Staat"/></trans_set></field><field name="address_postcode" type="Text" title="Postcode"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Postleitzahl"/><trans loc="de_DE" val="Postleitzahl"/></trans_set></field><field name="date_of_birth" type="Date" title="Date Of Birth"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Geburtsdatum"/><trans loc="de_DE" val="Geburtsdatum"/></trans_set></field><field name="position" type="Text" title="Position"><formatting format_thousands_separator="true" format_decimal_places="2"/></field></fields><relationships/><data_layouts><data_layout name="details" parent_table="staff"><data_layout_groups><data_layout_group name="header" colu
 mns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_AT" val="Overview"/><trans loc="de_BE" val="Overview"/><trans loc="de_DE" val="Overview"/><trans loc="en_GB" val="Overview"/><trans loc="en_US" val="Overview"/></trans_set><data_layout_item name="staff_id" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_last" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="main" columns_count="2" sequence="2"><data_layout_item name="position" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_group name="name" columns_count="1" sequence="2" title="Name"><trans_set><trans loc="de_AT" val="Name"/><trans l
 oc="de_BE" val="Name"/><trans loc="de_DE" val="Name"/><trans loc="en_GB" val="Name"/><trans loc="en_US" val="Name"/></trans_set><data_layout_item name="name_title" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_first" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_second" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_last" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="address" columns_count="1" sequence="3" title="Address"><trans_set><
 trans loc="de_AT" val="Address"/><trans loc="de_BE" val="Address"/><trans loc="de_DE" val="Address"/><trans loc="en_GB" val="Address"/><trans loc="en_US" val="Address"/></trans_set><data_layout_item name="address_state" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_street" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_postcode" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_town" edit
 able="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_item name="date_of_birth" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout><data_layout name="list" parent_table="staff"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="staff_id" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_first" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_last" editable="true" use_default_formatting="true" sequence="3"
 ><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="position" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>
+</table><table name="staff" title="Staff"><fields><field name="staff_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Staff ID"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="name_title" type="Text" title="Title"><formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true"><custom_choice_list><custom_choice value="Mr"/><custom_choice value="Mrs"/><custom_choice value="Miss"/><custom_choice value="Dr"/><custom_choice value="Prof"/></custom_choice_list></formatting></field><field name="name_first" type="Text" title="First Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Vorname"/><trans loc="de" val="Vorname"/></trans_set></field><field name="name_second" type="Text" title="Second Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Zweite Name
 "/><trans loc="de" val="Zweite Name"/></trans_set></field><field name="name_last" type="Text" title="Last Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Familiename"/><trans loc="de" val="Familiename"/></trans_set></field><field name="address_street" type="Text" title="Street"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Strasse"/><trans loc="de" val="Strasse"/></trans_set></field><field name="address_town" type="Text" title="Town"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Ort"/><trans loc="de" val="Ort"/></trans_set></field><field name="address_state" type="Text" title="State"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Bundesland/Kanton"/><trans loc="de" val="Bundesland/Kanton"/></trans_set></field><field name="addres
 s_country" type="Text" title="Country"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Staat"/><trans loc="de" val="Staat"/></trans_set></field><field name="address_postcode" type="Text" title="Postcode"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Postleitzahl"/><trans loc="de" val="Postleitzahl"/></trans_set></field><field name="date_of_birth" type="Date" title="Date Of Birth"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_AT" val="Geburtsdatum"/><trans loc="de" val="Geburtsdatum"/></trans_set></field><field name="position" type="Text" title="Position"><formatting format_thousands_separator="true" format_decimal_places="2"/></field></fields><relationships/><data_layouts><data_layout name="details" parent_table="staff"><data_layout_groups><data_layout_group name="header" columns_count="2" sequence="1" 
 title="Overview"><trans_set><trans loc="de_AT" val="Overview"/><trans loc="de_BE" val="Overview"/><trans loc="de" val="Overview"/><trans loc="en_GB" val="Overview"/><trans loc="en_US" val="Overview"/></trans_set><data_layout_item name="staff_id" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_last" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="main" columns_count="2" sequence="2"><data_layout_item name="position" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_group name="name" columns_count="1" sequence="2" title="Name"><trans_set><trans loc="de_AT" val="Name"/><trans loc="de_BE" val="Name"/><trans 
 loc="de" val="Name"/><trans loc="en_GB" val="Name"/><trans loc="en_US" val="Name"/></trans_set><data_layout_item name="name_title" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_first" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_second" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_last" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="address" columns_count="1" sequence="3" title="Address"><trans_set><trans loc="de_AT" val="Address"/>
 <trans loc="de_BE" val="Address"/><trans loc="de" val="Address"/><trans loc="en_GB" val="Address"/><trans loc="en_US" val="Address"/></trans_set><data_layout_item name="address_state" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_street" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_postcode" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_town" editable="true" use_default_formatting="
 true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_item name="date_of_birth" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout><data_layout name="list" parent_table="staff"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="staff_id" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_first" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_last" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separa
 tor="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="position" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>
 
 </table><groups><!--These are only used when recreating a database from an example file. The actual access-control is on the server, of course.--><group name=""/><table_privs table_name="contacts" priv_view="true" priv_edit="true"/><table_privs table_name="invoice_lines" priv_view="true" priv_edit="true"/><table_privs table_name="invoices" priv_view="true" priv_edit="true"/><table_privs table_name="products" priv_view="true"/><table_privs table_name="staff" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/><group name="accounts"/><table_privs table_name="contacts" priv_view="true" priv_edit="true"/><table_privs table_name="invoice_lines" priv_view="true" priv_edit="true"/><table_privs table_name="invoices" priv_view="true" priv_edit="true"/><table_privs table_name="products" priv_view="true"/><table_privs table_name="staff" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/><group name="glom_developer"/><table_privs table_name="co
 ntacts" priv_view="true" priv_edit="true"/><table_privs table_name="invoice_lines" priv_view="true" priv_edit="true"/><table_privs table_name="invoices" priv_view="true" priv_edit="true"/><table_privs table_name="products" priv_view="true"/><table_privs table_name="staff" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/><group name="personnel_department"/><table_privs table_name="contacts" priv_view="true" priv_edit="true"/><table_privs table_name="invoice_lines" priv_view="true" priv_edit="true"/><table_privs table_name="invoices" priv_view="true" priv_edit="true"/><table_privs table_name="products" priv_view="true"/><table_privs table_name="staff" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/></groups></glom_document>
diff --git a/ldtp/database-templates/PostgresCentral/Test.glom b/ldtp/database-templates/PostgresCentral/Test.glom
index ab5b4f0..aba1388 100644
--- a/ldtp/database-templates/PostgresCentral/Test.glom
+++ b/ldtp/database-templates/PostgresCentral/Test.glom
@@ -4,7 +4,7 @@
   <table name="contacts" default="true" title="Contacts">
     <trans_set>
       <trans loc="de_AT" val="Kontakten"/>
-      <trans loc="de_DE" val="Kontakten"/>
+      <trans loc="de" val="Kontakten"/>
     </trans_set>
     <fields>
       <field name="contact_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Contact ID">
@@ -12,7 +12,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Kontakt ID"/>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="name_first" type="Text" title="First Name">
@@ -20,7 +20,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Vorname"/>
-          <trans loc="de_DE" val="Vorname"/>
+          <trans loc="de" val="Vorname"/>
         </trans_set>
       </field>
       <field name="name_middle" type="Text" title="Middle Name">
@@ -28,7 +28,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Zweite Name"/>
-          <trans loc="de_DE" val="Zweite Name"/>
+          <trans loc="de" val="Zweite Name"/>
         </trans_set>
       </field>
       <field name="name_last" type="Text" title="Last Name">
@@ -36,7 +36,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Familiename"/>
-          <trans loc="de_DE" val="Familiename"/>
+          <trans loc="de" val="Familiename"/>
         </trans_set>
       </field>
       <field name="name_title" type="Text" title="Title">
@@ -52,7 +52,7 @@
           </custom_choice_list>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Titel"/>
+          <trans loc="de" val="Titel"/>
         </trans_set>
       </field>
       <field name="address_street" type="Text" title="Street">
@@ -60,7 +60,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Strasse"/>
-          <trans loc="de_DE" val="Strasse"/>
+          <trans loc="de" val="Strasse"/>
         </trans_set>
       </field>
       <field name="address_town" type="Text" title="Town">
@@ -68,7 +68,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Ort"/>
-          <trans loc="de_DE" val="Ort"/>
+          <trans loc="de" val="Ort"/>
         </trans_set>
       </field>
       <field name="address_state" type="Text" title="State">
@@ -76,7 +76,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Bundesland/Kanton"/>
-          <trans loc="de_DE" val="Bundesland/Kanton"/>
+          <trans loc="de" val="Bundesland/Kanton"/>
         </trans_set>
       </field>
       <field name="address_country" type="Text" title="Country">
@@ -84,7 +84,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Land"/>
-          <trans loc="de_DE" val="Land"/>
+          <trans loc="de" val="Land"/>
         </trans_set>
       </field>
       <field name="address_postcode" type="Text" title="Postcode">
@@ -92,7 +92,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Postleitzahl"/>
-          <trans loc="de_DE" val="Postleitzahl"/>
+          <trans loc="de" val="Postleitzahl"/>
         </trans_set>
       </field>
       <field name="date_of_birth" type="Date" title="Date of Birth">
@@ -100,7 +100,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Geburtsdatum"/>
-          <trans loc="de_DE" val="Geburtsdatum"/>
+          <trans loc="de" val="Geburtsdatum"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
@@ -108,7 +108,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Kommentar"/>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="name_full" type="Text" title="Full Name">
@@ -116,7 +116,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Vollname"/>
-          <trans loc="de_DE" val="Vollname"/>
+          <trans loc="de" val="Vollname"/>
         </trans_set>
       </field>
       <field name="picture" type="Image" title="Picture">
@@ -124,7 +124,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Bild"/>
-          <trans loc="de_DE" val="Bild"/>
+          <trans loc="de" val="Bild"/>
         </trans_set>
       </field>
       <field name="email" type="Text" title="Email Address">
@@ -132,7 +132,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="E-mail Addresse"/>
-          <trans loc="de_DE" val="E-mail Addresse"/>
+          <trans loc="de" val="E-mail Addresse"/>
         </trans_set>
       </field>
       <field name="website" type="Text" title="Web Site">
@@ -140,7 +140,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Website"/>
-          <trans loc="de_DE" val="Website"/>
+          <trans loc="de" val="Website"/>
         </trans_set>
       </field>
       <field name="tel_home" type="Text" title="Home Telephone">
@@ -160,7 +160,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Fax"/>
-          <trans loc="de_DE" val="Fax"/>
+          <trans loc="de" val="Fax"/>
         </trans_set>
       </field>
     </fields>
@@ -172,7 +172,7 @@
             <trans_set>
               <trans loc="de_AT" val="Ubersicht"/>
               <trans loc="de_BE" val="Overview"/>
-              <trans loc="de_DE" val="Ubersicht"/>
+              <trans loc="de" val="Ubersicht"/>
               <trans loc="en_GB" val="Overview"/>
               <trans loc="en_US" val="Overview"/>
             </trans_set>
@@ -188,7 +188,7 @@
               <trans_set>
                 <trans loc="de_AT" val="Name"/>
                 <trans loc="de_BE" val="Name"/>
-                <trans loc="de_DE" val="Name"/>
+                <trans loc="de" val="Name"/>
                 <trans loc="en_GB" val="Name"/>
                 <trans loc="en_US" val="Name"/>
               </trans_set>
@@ -209,7 +209,7 @@
               <trans_set>
                 <trans loc="de_AT" val="Addresse"/>
                 <trans loc="de_BE" val="Address"/>
-                <trans loc="de_DE" val="Addresse"/>
+                <trans loc="de" val="Addresse"/>
                 <trans loc="en_GB" val="Address"/>
                 <trans loc="en_US" val="Address"/>
               </trans_set>
@@ -233,7 +233,7 @@
               <trans_set>
                 <trans loc="de_AT" val="Telefon"/>
                 <trans loc="de_BE" val="Telephone"/>
-                <trans loc="de_DE" val="Telefon"/>
+                <trans loc="de" val="Telefon"/>
                 <trans loc="en_GB" val="Telephone"/>
                 <trans loc="en_US" val="Telephone"/>
               </trans_set>
@@ -433,7 +433,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Produkt Name"/>
-          <trans loc="de_DE" val="Produkt Name"/>
+          <trans loc="de" val="Produkt Name"/>
         </trans_set>
       </field>
       <field name="product_id" type="Number" title="Product Id">
@@ -441,7 +441,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="products" choices_related_field="product_id" choices_related_second="name"/>
         <trans_set>
           <trans loc="de_AT" val="Produkt ID"/>
-          <trans loc="de_DE" val="Produkt ID"/>
+          <trans loc="de" val="Produkt ID"/>
         </trans_set>
       </field>
       <field name="product_price" type="Number" title="Product Price">
@@ -450,7 +450,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Produkt Preis"/>
-          <trans loc="de_DE" val="Produkt Preis"/>
+          <trans loc="de" val="Produkt Preis"/>
         </trans_set>
       </field>
       <field name="invoice_id" type="Number" title="Invoice ID">
@@ -458,7 +458,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Rechnung ID"/>
-          <trans loc="de_DE" val="Rechnung ID"/>
+          <trans loc="de" val="Rechnung ID"/>
         </trans_set>
       </field>
       <field name="count" default_value="1" type="Number" title="Number Of">
@@ -466,7 +466,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Menge"/>
-          <trans loc="de_DE" val="Menge"/>
+          <trans loc="de" val="Menge"/>
         </trans_set>
       </field>
       <field name="total_price" type="Number" title="Total Price">
@@ -474,7 +474,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamtpreis"/>
-          <trans loc="de_DE" val="Gesamtpreis"/>
+          <trans loc="de" val="Gesamtpreis"/>
         </trans_set>
       </field>
       <field name="vat_percentage" type="Number" title="VAT Percentage">
@@ -483,7 +483,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="MwST Prozent"/>
-          <trans loc="de_DE" val="MwST Prozent"/>
+          <trans loc="de" val="MwST Prozent"/>
         </trans_set>
       </field>
       <field name="total_price_vat" type="Number" title="Total VAT">
@@ -491,7 +491,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamt MwST"/>
-          <trans loc="de_DE" val="Gesamt MwST"/>
+          <trans loc="de" val="Gesamt MwST"/>
         </trans_set>
       </field>
     </fields>
@@ -499,7 +499,7 @@ if __name__ == "__main__":
       <relationship name="products" key="product_id" other_table="products" other_key="product_id">
         <trans_set>
           <trans loc="de_AT" val="Produkten"/>
-          <trans loc="de_DE" val="Produkten"/>
+          <trans loc="de" val="Produkten"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -571,7 +571,7 @@ if __name__ == "__main__":
   <table name="invoices" title="Invoices">
     <trans_set>
       <trans loc="de_AT" val="Rechnungen"/>
-      <trans loc="de_DE" val="Rechnungen"/>
+      <trans loc="de" val="Rechnungen"/>
     </trans_set>
     <fields>
       <field name="invoice_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Invoice ID">
@@ -579,7 +579,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Rechnung ID"/>
-          <trans loc="de_DE" val="Rechnung ID"/>
+          <trans loc="de" val="Rechnung ID"/>
         </trans_set>
       </field>
       <field name="contact_id" type="Number" title="Contact ID">
@@ -587,7 +587,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Kontakt ID"/>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="date" type="Date" title="Date">
@@ -595,7 +595,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Datum"/>
-          <trans loc="de_DE" val="Datum"/>
+          <trans loc="de" val="Datum"/>
         </trans_set>
       </field>
       <field name="comment" type="Text" title="Comment">
@@ -603,7 +603,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Kommentar"/>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="price_total" type="Number" title="Total Price">
@@ -611,7 +611,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamtpreis"/>
-          <trans loc="de_DE" val="Gesamtpreis"/>
+          <trans loc="de" val="Gesamtpreis"/>
         </trans_set>
       </field>
       <field name="vat_total" default_value="16" type="Number" title="Total VAT">
@@ -619,7 +619,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamt MwST"/>
-          <trans loc="de_DE" val="Gesamt MwST"/>
+          <trans loc="de" val="Gesamt MwST"/>
         </trans_set>
       </field>
       <field name="price_total_with_vat" type="Number" title="Total Price With Vat">
@@ -627,7 +627,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamtpreis mit MwST"/>
-          <trans loc="de_DE" val="Gesamtpreis mit MwST"/>
+          <trans loc="de" val="Gesamtpreis mit MwST"/>
         </trans_set>
       </field>
     </fields>
@@ -635,13 +635,13 @@ if __name__ == "__main__":
       <relationship name="invoice_lines" key="invoice_id" other_table="invoice_lines" other_key="invoice_id" auto_create="true" allow_edit="true" title="Invoice Lines">
         <trans_set>
           <trans loc="de_AT" val="Rechnung Reihen"/>
-          <trans loc="de_DE" val="Rechnung Reihen"/>
+          <trans loc="de" val="Rechnung Reihen"/>
         </trans_set>
       </relationship>
       <relationship name="contacts" key="contact_id" other_table="contacts" other_key="contact_id" title="Contacts">
         <trans_set>
           <trans loc="de_AT" val="Kontakten"/>
-          <trans loc="de_DE" val="Kontakten"/>
+          <trans loc="de" val="Kontakten"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -652,7 +652,7 @@ if __name__ == "__main__":
             <trans_set>
               <trans loc="de_AT" val="&#xDC;bersicht"/>
               <trans loc="de_BE" val="Overview"/>
-              <trans loc="de_DE" val="&#xDC;bersicht"/>
+              <trans loc="de" val="&#xDC;bersicht"/>
               <trans loc="en_GB" val="Overview"/>
               <trans loc="en_US" val="Overview"/>
             </trans_set>
@@ -668,7 +668,7 @@ if __name__ == "__main__":
               <trans_set>
                 <trans loc="de_AT" val="Kunde"/>
                 <trans loc="de_BE" val="Customer"/>
-                <trans loc="de_DE" val="Kunde"/>
+                <trans loc="de" val="Kunde"/>
                 <trans loc="en_GB" val="Customer"/>
                 <trans loc="en_US" val="Customer"/>
               </trans_set>
@@ -841,7 +841,7 @@ if __name__ == "__main__":
   <table name="products" title="Products">
     <trans_set>
       <trans loc="de_AT" val="Produkten"/>
-      <trans loc="de_DE" val="Produkten"/>
+      <trans loc="de" val="Produkten"/>
     </trans_set>
     <fields>
       <field name="product_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Product ID">
@@ -849,7 +849,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Produkt ID"/>
-          <trans loc="de_DE" val="Produkt ID"/>
+          <trans loc="de" val="Produkt ID"/>
         </trans_set>
       </field>
       <field name="comment" type="Text" title="Comment">
@@ -857,7 +857,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Kommentar"/>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
@@ -865,7 +865,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Beschreibung"/>
-          <trans loc="de_DE" val="Beschreibung"/>
+          <trans loc="de" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="name" type="Text" title="Name">
@@ -873,7 +873,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Name"/>
-          <trans loc="de_DE" val="Name"/>
+          <trans loc="de" val="Name"/>
         </trans_set>
       </field>
       <field name="price" type="Number" title="Price">
@@ -881,7 +881,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Preis"/>
-          <trans loc="de_DE" val="Preis"/>
+          <trans loc="de" val="Preis"/>
         </trans_set>
       </field>
       <field name="vat_percent" default_value="16" type="Number" title="Vat Percent">
@@ -889,7 +889,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="MwST Prozent"/>
-          <trans loc="de_DE" val="MwST Prozent"/>
+          <trans loc="de" val="MwST Prozent"/>
         </trans_set>
       </field>
     </fields>
@@ -901,7 +901,7 @@ if __name__ == "__main__":
             <trans_set>
               <trans loc="de_AT" val="Overview"/>
               <trans loc="de_BE" val="Overview"/>
-              <trans loc="de_DE" val="Overview"/>
+              <trans loc="de" val="Overview"/>
               <trans loc="en_GB" val="Overview"/>
               <trans loc="en_US" val="Overview"/>
             </trans_set>
@@ -916,7 +916,7 @@ if __name__ == "__main__":
             <trans_set>
               <trans loc="de_AT" val="Details"/>
               <trans loc="de_BE" val="Details"/>
-              <trans loc="de_DE" val="Details"/>
+              <trans loc="de" val="Details"/>
               <trans loc="en_GB" val="Details"/>
               <trans loc="en_US" val="Details"/>
             </trans_set>
@@ -983,7 +983,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Vorname"/>
-          <trans loc="de_DE" val="Vorname"/>
+          <trans loc="de" val="Vorname"/>
         </trans_set>
       </field>
       <field name="name_second" type="Text" title="Second Name">
@@ -991,7 +991,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Zweite Name"/>
-          <trans loc="de_DE" val="Zweite Name"/>
+          <trans loc="de" val="Zweite Name"/>
         </trans_set>
       </field>
       <field name="name_last" type="Text" title="Last Name">
@@ -999,7 +999,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Familiename"/>
-          <trans loc="de_DE" val="Familiename"/>
+          <trans loc="de" val="Familiename"/>
         </trans_set>
       </field>
       <field name="address_street" type="Text" title="Street">
@@ -1007,7 +1007,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Strasse"/>
-          <trans loc="de_DE" val="Strasse"/>
+          <trans loc="de" val="Strasse"/>
         </trans_set>
       </field>
       <field name="address_town" type="Text" title="Town">
@@ -1015,7 +1015,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Ort"/>
-          <trans loc="de_DE" val="Ort"/>
+          <trans loc="de" val="Ort"/>
         </trans_set>
       </field>
       <field name="address_state" type="Text" title="State">
@@ -1023,7 +1023,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Bundesland/Kanton"/>
-          <trans loc="de_DE" val="Bundesland/Kanton"/>
+          <trans loc="de" val="Bundesland/Kanton"/>
         </trans_set>
       </field>
       <field name="address_country" type="Text" title="Country">
@@ -1031,7 +1031,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Staat"/>
-          <trans loc="de_DE" val="Staat"/>
+          <trans loc="de" val="Staat"/>
         </trans_set>
       </field>
       <field name="address_postcode" type="Text" title="Postcode">
@@ -1039,7 +1039,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Postleitzahl"/>
-          <trans loc="de_DE" val="Postleitzahl"/>
+          <trans loc="de" val="Postleitzahl"/>
         </trans_set>
       </field>
       <field name="date_of_birth" type="Date" title="Date Of Birth">
@@ -1047,7 +1047,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Geburtsdatum"/>
-          <trans loc="de_DE" val="Geburtsdatum"/>
+          <trans loc="de" val="Geburtsdatum"/>
         </trans_set>
       </field>
       <field name="position" type="Text" title="Position">
@@ -1063,7 +1063,7 @@ if __name__ == "__main__":
             <trans_set>
               <trans loc="de_AT" val="Overview"/>
               <trans loc="de_BE" val="Overview"/>
-              <trans loc="de_DE" val="Overview"/>
+              <trans loc="de" val="Overview"/>
               <trans loc="en_GB" val="Overview"/>
               <trans loc="en_US" val="Overview"/>
             </trans_set>
@@ -1082,7 +1082,7 @@ if __name__ == "__main__":
               <trans_set>
                 <trans loc="de_AT" val="Name"/>
                 <trans loc="de_BE" val="Name"/>
-                <trans loc="de_DE" val="Name"/>
+                <trans loc="de" val="Name"/>
                 <trans loc="en_GB" val="Name"/>
                 <trans loc="en_US" val="Name"/>
               </trans_set>
@@ -1103,7 +1103,7 @@ if __name__ == "__main__":
               <trans_set>
                 <trans loc="de_AT" val="Address"/>
                 <trans loc="de_BE" val="Address"/>
-                <trans loc="de_DE" val="Address"/>
+                <trans loc="de" val="Address"/>
                 <trans loc="en_GB" val="Address"/>
                 <trans loc="en_US" val="Address"/>
               </trans_set>
diff --git a/ldtp/database-templates/SQLite/Test.glom b/ldtp/database-templates/SQLite/Test.glom
index 76de9d5..af22466 100644
--- a/ldtp/database-templates/SQLite/Test.glom
+++ b/ldtp/database-templates/SQLite/Test.glom
@@ -4,7 +4,7 @@
   <table name="contacts" default="true" title="Contacts">
     <trans_set>
       <trans loc="de_AT" val="Kontakten"/>
-      <trans loc="de_DE" val="Kontakten"/>
+      <trans loc="de" val="Kontakten"/>
     </trans_set>
     <fields>
       <field name="contact_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Contact ID">
@@ -12,7 +12,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Kontakt ID"/>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="name_first" type="Text" title="First Name">
@@ -20,7 +20,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Vorname"/>
-          <trans loc="de_DE" val="Vorname"/>
+          <trans loc="de" val="Vorname"/>
         </trans_set>
       </field>
       <field name="name_middle" type="Text" title="Middle Name">
@@ -28,7 +28,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Zweite Name"/>
-          <trans loc="de_DE" val="Zweite Name"/>
+          <trans loc="de" val="Zweite Name"/>
         </trans_set>
       </field>
       <field name="name_last" type="Text" title="Last Name">
@@ -36,7 +36,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Familiename"/>
-          <trans loc="de_DE" val="Familiename"/>
+          <trans loc="de" val="Familiename"/>
         </trans_set>
       </field>
       <field name="name_title" type="Text" title="Title">
@@ -52,7 +52,7 @@
           </custom_choice_list>
         </formatting>
         <trans_set>
-          <trans loc="de_DE" val="Titel"/>
+          <trans loc="de" val="Titel"/>
         </trans_set>
       </field>
       <field name="address_street" type="Text" title="Street">
@@ -60,7 +60,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Strasse"/>
-          <trans loc="de_DE" val="Strasse"/>
+          <trans loc="de" val="Strasse"/>
         </trans_set>
       </field>
       <field name="address_town" type="Text" title="Town">
@@ -68,7 +68,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Ort"/>
-          <trans loc="de_DE" val="Ort"/>
+          <trans loc="de" val="Ort"/>
         </trans_set>
       </field>
       <field name="address_state" type="Text" title="State">
@@ -76,7 +76,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Bundesland/Kanton"/>
-          <trans loc="de_DE" val="Bundesland/Kanton"/>
+          <trans loc="de" val="Bundesland/Kanton"/>
         </trans_set>
       </field>
       <field name="address_country" type="Text" title="Country">
@@ -84,7 +84,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Land"/>
-          <trans loc="de_DE" val="Land"/>
+          <trans loc="de" val="Land"/>
         </trans_set>
       </field>
       <field name="address_postcode" type="Text" title="Postcode">
@@ -92,7 +92,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Postleitzahl"/>
-          <trans loc="de_DE" val="Postleitzahl"/>
+          <trans loc="de" val="Postleitzahl"/>
         </trans_set>
       </field>
       <field name="date_of_birth" type="Date" title="Date of Birth">
@@ -100,7 +100,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Geburtsdatum"/>
-          <trans loc="de_DE" val="Geburtsdatum"/>
+          <trans loc="de" val="Geburtsdatum"/>
         </trans_set>
       </field>
       <field name="comments" type="Text" title="Comments">
@@ -108,7 +108,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Kommentar"/>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="name_full" type="Text" title="Full Name">
@@ -116,7 +116,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Vollname"/>
-          <trans loc="de_DE" val="Vollname"/>
+          <trans loc="de" val="Vollname"/>
         </trans_set>
       </field>
       <field name="picture" type="Image" title="Picture">
@@ -124,7 +124,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Bild"/>
-          <trans loc="de_DE" val="Bild"/>
+          <trans loc="de" val="Bild"/>
         </trans_set>
       </field>
       <field name="email" type="Text" title="Email Address">
@@ -132,7 +132,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="E-mail Addresse"/>
-          <trans loc="de_DE" val="E-mail Addresse"/>
+          <trans loc="de" val="E-mail Addresse"/>
         </trans_set>
       </field>
       <field name="website" type="Text" title="Web Site">
@@ -140,7 +140,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Website"/>
-          <trans loc="de_DE" val="Website"/>
+          <trans loc="de" val="Website"/>
         </trans_set>
       </field>
       <field name="tel_home" type="Text" title="Home Telephone">
@@ -160,7 +160,7 @@
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Fax"/>
-          <trans loc="de_DE" val="Fax"/>
+          <trans loc="de" val="Fax"/>
         </trans_set>
       </field>
     </fields>
@@ -172,7 +172,7 @@
             <trans_set>
               <trans loc="de_AT" val="Ubersicht"/>
               <trans loc="de_BE" val="Overview"/>
-              <trans loc="de_DE" val="Ubersicht"/>
+              <trans loc="de" val="Ubersicht"/>
               <trans loc="en_GB" val="Overview"/>
               <trans loc="en_US" val="Overview"/>
             </trans_set>
@@ -188,7 +188,7 @@
               <trans_set>
                 <trans loc="de_AT" val="Name"/>
                 <trans loc="de_BE" val="Name"/>
-                <trans loc="de_DE" val="Name"/>
+                <trans loc="de" val="Name"/>
                 <trans loc="en_GB" val="Name"/>
                 <trans loc="en_US" val="Name"/>
               </trans_set>
@@ -209,7 +209,7 @@
               <trans_set>
                 <trans loc="de_AT" val="Addresse"/>
                 <trans loc="de_BE" val="Address"/>
-                <trans loc="de_DE" val="Addresse"/>
+                <trans loc="de" val="Addresse"/>
                 <trans loc="en_GB" val="Address"/>
                 <trans loc="en_US" val="Address"/>
               </trans_set>
@@ -233,7 +233,7 @@
               <trans_set>
                 <trans loc="de_AT" val="Telefon"/>
                 <trans loc="de_BE" val="Telephone"/>
-                <trans loc="de_DE" val="Telefon"/>
+                <trans loc="de" val="Telefon"/>
                 <trans loc="en_GB" val="Telephone"/>
                 <trans loc="en_US" val="Telephone"/>
               </trans_set>
@@ -433,7 +433,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Produkt Name"/>
-          <trans loc="de_DE" val="Produkt Name"/>
+          <trans loc="de" val="Produkt Name"/>
         </trans_set>
       </field>
       <field name="product_id" type="Number" title="Product Id">
@@ -441,7 +441,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="products" choices_related_field="product_id" choices_related_second="name"/>
         <trans_set>
           <trans loc="de_AT" val="Produkt ID"/>
-          <trans loc="de_DE" val="Produkt ID"/>
+          <trans loc="de" val="Produkt ID"/>
         </trans_set>
       </field>
       <field name="product_price" type="Number" title="Product Price">
@@ -450,7 +450,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Produkt Preis"/>
-          <trans loc="de_DE" val="Produkt Preis"/>
+          <trans loc="de" val="Produkt Preis"/>
         </trans_set>
       </field>
       <field name="invoice_id" type="Number" title="Invoice ID">
@@ -458,7 +458,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Rechnung ID"/>
-          <trans loc="de_DE" val="Rechnung ID"/>
+          <trans loc="de" val="Rechnung ID"/>
         </trans_set>
       </field>
       <field name="count" default_value="1" type="Number" title="Number Of">
@@ -466,7 +466,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Menge"/>
-          <trans loc="de_DE" val="Menge"/>
+          <trans loc="de" val="Menge"/>
         </trans_set>
       </field>
       <field name="total_price" type="Number" title="Total Price">
@@ -474,7 +474,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamtpreis"/>
-          <trans loc="de_DE" val="Gesamtpreis"/>
+          <trans loc="de" val="Gesamtpreis"/>
         </trans_set>
       </field>
       <field name="vat_percentage" type="Number" title="VAT Percentage">
@@ -483,7 +483,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="MwST Prozent"/>
-          <trans loc="de_DE" val="MwST Prozent"/>
+          <trans loc="de" val="MwST Prozent"/>
         </trans_set>
       </field>
       <field name="total_price_vat" type="Number" title="Total VAT">
@@ -491,7 +491,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamt MwST"/>
-          <trans loc="de_DE" val="Gesamt MwST"/>
+          <trans loc="de" val="Gesamt MwST"/>
         </trans_set>
       </field>
     </fields>
@@ -499,7 +499,7 @@ if __name__ == "__main__":
       <relationship name="products" key="product_id" other_table="products" other_key="product_id">
         <trans_set>
           <trans loc="de_AT" val="Produkten"/>
-          <trans loc="de_DE" val="Produkten"/>
+          <trans loc="de" val="Produkten"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -571,7 +571,7 @@ if __name__ == "__main__":
   <table name="invoices" title="Invoices">
     <trans_set>
       <trans loc="de_AT" val="Rechnungen"/>
-      <trans loc="de_DE" val="Rechnungen"/>
+      <trans loc="de" val="Rechnungen"/>
     </trans_set>
     <fields>
       <field name="invoice_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Invoice ID">
@@ -579,7 +579,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Rechnung ID"/>
-          <trans loc="de_DE" val="Rechnung ID"/>
+          <trans loc="de" val="Rechnung ID"/>
         </trans_set>
       </field>
       <field name="contact_id" type="Number" title="Contact ID">
@@ -587,7 +587,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Kontakt ID"/>
-          <trans loc="de_DE" val="Kontakt ID"/>
+          <trans loc="de" val="Kontakt ID"/>
         </trans_set>
       </field>
       <field name="date" type="Date" title="Date">
@@ -595,7 +595,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Datum"/>
-          <trans loc="de_DE" val="Datum"/>
+          <trans loc="de" val="Datum"/>
         </trans_set>
       </field>
       <field name="comment" type="Text" title="Comment">
@@ -603,7 +603,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Kommentar"/>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="price_total" type="Number" title="Total Price">
@@ -611,7 +611,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamtpreis"/>
-          <trans loc="de_DE" val="Gesamtpreis"/>
+          <trans loc="de" val="Gesamtpreis"/>
         </trans_set>
       </field>
       <field name="vat_total" default_value="16" type="Number" title="Total VAT">
@@ -619,7 +619,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamt MwST"/>
-          <trans loc="de_DE" val="Gesamt MwST"/>
+          <trans loc="de" val="Gesamt MwST"/>
         </trans_set>
       </field>
       <field name="price_total_with_vat" type="Number" title="Total Price With Vat">
@@ -627,7 +627,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Gesamtpreis mit MwST"/>
-          <trans loc="de_DE" val="Gesamtpreis mit MwST"/>
+          <trans loc="de" val="Gesamtpreis mit MwST"/>
         </trans_set>
       </field>
     </fields>
@@ -635,13 +635,13 @@ if __name__ == "__main__":
       <relationship name="invoice_lines" key="invoice_id" other_table="invoice_lines" other_key="invoice_id" auto_create="true" allow_edit="true" title="Invoice Lines">
         <trans_set>
           <trans loc="de_AT" val="Rechnung Reihen"/>
-          <trans loc="de_DE" val="Rechnung Reihen"/>
+          <trans loc="de" val="Rechnung Reihen"/>
         </trans_set>
       </relationship>
       <relationship name="contacts" key="contact_id" other_table="contacts" other_key="contact_id" title="Contacts">
         <trans_set>
           <trans loc="de_AT" val="Kontakten"/>
-          <trans loc="de_DE" val="Kontakten"/>
+          <trans loc="de" val="Kontakten"/>
         </trans_set>
       </relationship>
     </relationships>
@@ -652,7 +652,7 @@ if __name__ == "__main__":
             <trans_set>
               <trans loc="de_AT" val="&#xDC;bersicht"/>
               <trans loc="de_BE" val="Overview"/>
-              <trans loc="de_DE" val="&#xDC;bersicht"/>
+              <trans loc="de" val="&#xDC;bersicht"/>
               <trans loc="en_GB" val="Overview"/>
               <trans loc="en_US" val="Overview"/>
             </trans_set>
@@ -668,7 +668,7 @@ if __name__ == "__main__":
               <trans_set>
                 <trans loc="de_AT" val="Kunde"/>
                 <trans loc="de_BE" val="Customer"/>
-                <trans loc="de_DE" val="Kunde"/>
+                <trans loc="de" val="Kunde"/>
                 <trans loc="en_GB" val="Customer"/>
                 <trans loc="en_US" val="Customer"/>
               </trans_set>
@@ -841,7 +841,7 @@ if __name__ == "__main__":
   <table name="products" title="Products">
     <trans_set>
       <trans loc="de_AT" val="Produkten"/>
-      <trans loc="de_DE" val="Produkten"/>
+      <trans loc="de" val="Produkten"/>
     </trans_set>
     <fields>
       <field name="product_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Product ID">
@@ -849,7 +849,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Produkt ID"/>
-          <trans loc="de_DE" val="Produkt ID"/>
+          <trans loc="de" val="Produkt ID"/>
         </trans_set>
       </field>
       <field name="comment" type="Text" title="Comment">
@@ -857,7 +857,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Kommentar"/>
-          <trans loc="de_DE" val="Kommentar"/>
+          <trans loc="de" val="Kommentar"/>
         </trans_set>
       </field>
       <field name="description" type="Text" title="Description">
@@ -865,7 +865,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Beschreibung"/>
-          <trans loc="de_DE" val="Beschreibung"/>
+          <trans loc="de" val="Beschreibung"/>
         </trans_set>
       </field>
       <field name="name" type="Text" title="Name">
@@ -873,7 +873,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Name"/>
-          <trans loc="de_DE" val="Name"/>
+          <trans loc="de" val="Name"/>
         </trans_set>
       </field>
       <field name="price" type="Number" title="Price">
@@ -881,7 +881,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2" format_currency_symbol="EUR"/>
         <trans_set>
           <trans loc="de_AT" val="Preis"/>
-          <trans loc="de_DE" val="Preis"/>
+          <trans loc="de" val="Preis"/>
         </trans_set>
       </field>
       <field name="vat_percent" default_value="16" type="Number" title="Vat Percent">
@@ -889,7 +889,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="MwST Prozent"/>
-          <trans loc="de_DE" val="MwST Prozent"/>
+          <trans loc="de" val="MwST Prozent"/>
         </trans_set>
       </field>
     </fields>
@@ -901,7 +901,7 @@ if __name__ == "__main__":
             <trans_set>
               <trans loc="de_AT" val="Overview"/>
               <trans loc="de_BE" val="Overview"/>
-              <trans loc="de_DE" val="Overview"/>
+              <trans loc="de" val="Overview"/>
               <trans loc="en_GB" val="Overview"/>
               <trans loc="en_US" val="Overview"/>
             </trans_set>
@@ -916,7 +916,7 @@ if __name__ == "__main__":
             <trans_set>
               <trans loc="de_AT" val="Details"/>
               <trans loc="de_BE" val="Details"/>
-              <trans loc="de_DE" val="Details"/>
+              <trans loc="de" val="Details"/>
               <trans loc="en_GB" val="Details"/>
               <trans loc="en_US" val="Details"/>
             </trans_set>
@@ -983,7 +983,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Vorname"/>
-          <trans loc="de_DE" val="Vorname"/>
+          <trans loc="de" val="Vorname"/>
         </trans_set>
       </field>
       <field name="name_second" type="Text" title="Second Name">
@@ -991,7 +991,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Zweite Name"/>
-          <trans loc="de_DE" val="Zweite Name"/>
+          <trans loc="de" val="Zweite Name"/>
         </trans_set>
       </field>
       <field name="name_last" type="Text" title="Last Name">
@@ -999,7 +999,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Familiename"/>
-          <trans loc="de_DE" val="Familiename"/>
+          <trans loc="de" val="Familiename"/>
         </trans_set>
       </field>
       <field name="address_street" type="Text" title="Street">
@@ -1007,7 +1007,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Strasse"/>
-          <trans loc="de_DE" val="Strasse"/>
+          <trans loc="de" val="Strasse"/>
         </trans_set>
       </field>
       <field name="address_town" type="Text" title="Town">
@@ -1015,7 +1015,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Ort"/>
-          <trans loc="de_DE" val="Ort"/>
+          <trans loc="de" val="Ort"/>
         </trans_set>
       </field>
       <field name="address_state" type="Text" title="State">
@@ -1023,7 +1023,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Bundesland/Kanton"/>
-          <trans loc="de_DE" val="Bundesland/Kanton"/>
+          <trans loc="de" val="Bundesland/Kanton"/>
         </trans_set>
       </field>
       <field name="address_country" type="Text" title="Country">
@@ -1031,7 +1031,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Staat"/>
-          <trans loc="de_DE" val="Staat"/>
+          <trans loc="de" val="Staat"/>
         </trans_set>
       </field>
       <field name="address_postcode" type="Text" title="Postcode">
@@ -1039,7 +1039,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
         <trans_set>
           <trans loc="de_AT" val="Postleitzahl"/>
-          <trans loc="de_DE" val="Postleitzahl"/>
+          <trans loc="de" val="Postleitzahl"/>
         </trans_set>
       </field>
       <field name="date_of_birth" type="Date" title="Date Of Birth">
@@ -1047,7 +1047,7 @@ if __name__ == "__main__":
         <formatting format_thousands_separator="true" format_decimal_places="2"/>
         <trans_set>
           <trans loc="de_AT" val="Geburtsdatum"/>
-          <trans loc="de_DE" val="Geburtsdatum"/>
+          <trans loc="de" val="Geburtsdatum"/>
         </trans_set>
       </field>
       <field name="position" type="Text" title="Position">
@@ -1063,7 +1063,7 @@ if __name__ == "__main__":
             <trans_set>
               <trans loc="de_AT" val="Overview"/>
               <trans loc="de_BE" val="Overview"/>
-              <trans loc="de_DE" val="Overview"/>
+              <trans loc="de" val="Overview"/>
               <trans loc="en_GB" val="Overview"/>
               <trans loc="en_US" val="Overview"/>
             </trans_set>
@@ -1082,7 +1082,7 @@ if __name__ == "__main__":
               <trans_set>
                 <trans loc="de_AT" val="Name"/>
                 <trans loc="de_BE" val="Name"/>
-                <trans loc="de_DE" val="Name"/>
+                <trans loc="de" val="Name"/>
                 <trans loc="en_GB" val="Name"/>
                 <trans loc="en_US" val="Name"/>
               </trans_set>
@@ -1103,7 +1103,7 @@ if __name__ == "__main__":
               <trans_set>
                 <trans loc="de_AT" val="Address"/>
                 <trans loc="de_BE" val="Address"/>
-                <trans loc="de_DE" val="Address"/>
+                <trans loc="de" val="Address"/>
                 <trans loc="en_GB" val="Address"/>
                 <trans loc="en_US" val="Address"/>
               </trans_set>
diff --git a/tests/test_document_load_translations.cc b/tests/test_document_load_translations.cc
index 49db72d..1ef9326 100644
--- a/tests/test_document_load_translations.cc
+++ b/tests/test_document_load_translations.cc
@@ -240,7 +240,7 @@ int main()
 
   const std::vector<Glib::ustring> locales = document.get_translation_available_locales();
   g_assert(locales.size() == 2);
-  g_assert(contains(locales, "de_DE"));
+  g_assert(contains(locales, "de"));
 
   const std::vector<Glib::ustring> table_names = document.get_table_names();
   g_assert(contains(table_names, "scenes"));
diff --git a/tests/translations_po/test_document_export_po.cc b/tests/translations_po/test_document_export_po.cc
index f9ef21c..dcbb3bb 100644
--- a/tests/translations_po/test_document_export_po.cc
+++ b/tests/translations_po/test_document_export_po.cc
@@ -109,7 +109,7 @@ int main()
 
   //std::cout << "po file URI: " << po_file_uri << std::endl;
 
-  const Glib::ustring locale = "de_DE";
+  const Glib::ustring locale = "de";
   const bool success = 
     Glom::write_translations_to_po_file(&document, po_file_uri, locale);
   if(!success)
diff --git a/tests/translations_po/test_document_import_po.cc b/tests/translations_po/test_document_import_po.cc
index 0ae3125..8c22b1f 100644
--- a/tests/translations_po/test_document_import_po.cc
+++ b/tests/translations_po/test_document_import_po.cc
@@ -89,7 +89,7 @@ int main()
 
   //std::cout << "po file URI: " << po_file_uri << std::endl;
 
-  const Glib::ustring locale = "de_DE";
+  const Glib::ustring locale = "de";
   const bool success = 
     Glom::import_translations_from_po_file(&document, po_file_uri, locale);
   if(!success)



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]