Fixes issue 18077: Added support for login in with Google Account
authorIván Perdomo <ivan.perdomo@openbravo.com>
Mon, 01 Aug 2011 19:46:56 +0200
changeset 13377 061e041754e6
parent 13376 db596e1cae07
child 13378 7a57441f53b3
Fixes issue 18077: Added support for login in with Google Account
modules/org.openbravo.service.integration.google/src-db/database/model/functions/OBSEIG_UPDATE_ACCESS.xml
modules/org.openbravo.service.integration.google/src-db/database/model/tables/OBSEIG_DEFAULTS.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_COLUMN.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_ELEMENT.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_EP_PROCEDURES.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_FIELD.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MENU.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MESSAGE.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODEL_OBJECT.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE_DBPREFIX.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_PACKAGE.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_TAB.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_TABLE.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_TREENODE.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_WINDOW.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/OBUIAPP_MENU_PARAMETERS.xml
modules/org.openbravo.service.integration.google/src-db/database/sourcedata/OBUIAPP_VIEW_IMPL.xml
modules/org.openbravo.service.integration.google/src/org/openbravo/service/integration/google/GoogleAuthServlet.java
modules/org.openbravo.service.integration.google/src/org/openbravo/service/integration/google/GoogleIntegrationComponentProvider.java
modules/org.openbravo.service.integration.google/web/images/google.png
modules/org.openbravo.service.integration.google/web/org.openbravo.service.integration.google/js/obsegi-account-association-view.js
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/model/functions/OBSEIG_UPDATE_ACCESS.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,46 @@
+<?xml version="1.0"?>
+  <database name="FUNCTION OBSEIG_UPDATE_ACCESS">
+    <function name="OBSEIG_UPDATE_ACCESS" type="NULL">
+      <parameter name="p_ep_instance_id" type="VARCHAR" mode="in">
+        <default/>
+      </parameter>
+      <body><![CDATA[/*************************************************************************
+* The contents of this file are subject to the Openbravo  Public  License
+* Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
+* Version 1.1  with a permitted attribution clause; you may not  use this
+* file except in compliance with the License. You  may  obtain  a copy of
+* the License at http://www.openbravo.com/legal/license.html
+* Software distributed under the License  is  distributed  on  an "AS IS"
+* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
+* License for the specific  language  governing  rights  and  limitations
+* under the License.
+* The Original Code is Openbravo ERP.
+* The Initial Developer of the Original Code is Openbravo SLU
+* All portions are Copyright (C) 2011 Openbravo SLU
+* All Rights Reserved.
+* Contributor(s):  ______________________________________.
+************************************************************************/
+
+BEGIN
+
+  INSERT INTO OBUIAPP_View_Role_Access
+    (
+      OBUIAPP_View_Role_Access_ID, OBUIAPP_View_Impl_ID, AD_Role_ID, AD_Client_ID,
+      AD_Org_ID, IsActive, Created,
+      CreatedBy, Updated, UpdatedBy
+    )
+  SELECT get_uuid(), V.OBUIAPP_View_Impl_ID, R.AD_ROLE_ID, R.AD_CLIENT_ID,
+    R.AD_ORG_ID, 'Y', now(),
+    '0', now(), '0'
+  FROM OBUIAPP_View_Impl V, AD_Role R
+  WHERE R.isManual = 'N'
+  AND V.isActive = 'Y'
+  AND V.AD_Module_ID = 'FF8080813129ADA401312CA1222A0005'
+    AND NOT EXISTS (SELECT 1
+                     FROM OBUIAPP_View_Role_Access
+                    WHERE OBUIAPP_View_Impl_ID = V.OBUIAPP_View_Impl_ID
+                      AND AD_ROLE_ID = R.AD_ROLE_ID);
+END OBSEIG_UPDATE_ACCESS
+]]></body>
+    </function>
+  </database>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/model/tables/OBSEIG_DEFAULTS.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,61 @@
+<?xml version="1.0"?>
+  <database name="TABLE OBSEIG_DEFAULTS">
+    <table name="OBSEIG_DEFAULTS" primaryKey="OBSEIG_DEFAULT_KEY">
+      <column name="OBSEIG_DEFAULTS_ID" primaryKey="true" required="true" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="AD_CLIENT_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="AD_ORG_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="ISACTIVE" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
+        <default><![CDATA[Y]]></default>
+        <onCreateDefault/>
+      </column>
+      <column name="CREATED" primaryKey="false" required="true" type="TIMESTAMP" size="7" autoIncrement="false">
+        <default><![CDATA[SYSDATE]]></default>
+        <onCreateDefault/>
+      </column>
+      <column name="CREATEDBY" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="UPDATED" primaryKey="false" required="true" type="TIMESTAMP" size="7" autoIncrement="false">
+        <default><![CDATA[SYSDATE]]></default>
+        <onCreateDefault/>
+      </column>
+      <column name="UPDATEDBY" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="AD_ROLE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="ISDEFAULT" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
+        <default><![CDATA[N]]></default>
+        <onCreateDefault/>
+      </column>
+      <column name="ISNEWUSERACTIVE" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
+        <default><![CDATA[N]]></default>
+        <onCreateDefault/>
+      </column>
+      <foreign-key foreignTable="AD_CLIENT" name="OBSEIG_DEFAULT_AD_CLIENT">
+        <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
+      </foreign-key>
+      <foreign-key foreignTable="AD_ORG" name="OBSEIG_DEFAULT_AD_ORG">
+        <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
+      </foreign-key>
+      <foreign-key foreignTable="AD_ROLE" name="OBSEIG_DEFAULT_AD_ROLE">
+        <reference local="AD_ROLE_ID" foreign="AD_ROLE_ID"/>
+      </foreign-key>
+      <check name="OBSEIG_DEF_NEWUACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
+      <check name="OBSEIG_DEFAULT_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
+      <check name="OBSEIG_DEFAULT_ISDEFAULT_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
+    </table>
+  </database>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_COLUMN.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,373 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--2CE601D3765C4E93A7A754B9EE4819AD--><AD_COLUMN>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <AD_COLUMN_ID><![CDATA[2CE601D3765C4E93A7A754B9EE4819AD]]></AD_COLUMN_ID>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <NAME><![CDATA[Created By]]></NAME>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <DESCRIPTION><![CDATA[User who created this records]]></DESCRIPTION>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <HELP><![CDATA[The Created By field indicates the user who created this record.]]></HELP>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <COLUMNNAME><![CDATA[Createdby]]></COLUMNNAME>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <AD_TABLE_ID><![CDATA[FF8080813161A3D301316206A5840008]]></AD_TABLE_ID>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <AD_ELEMENT_ID><![CDATA[246]]></AD_ELEMENT_ID>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <POSITION><![CDATA[6]]></POSITION>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--2CE601D3765C4E93A7A754B9EE4819AD-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--2CE601D3765C4E93A7A754B9EE4819AD--></AD_COLUMN>
+
+<!--367B51FB95134BCC9E0AB630D1763899--><AD_COLUMN>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <AD_COLUMN_ID><![CDATA[367B51FB95134BCC9E0AB630D1763899]]></AD_COLUMN_ID>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <NAME><![CDATA[Isnewuseractive]]></NAME>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <DESCRIPTION><![CDATA[Defines if a newly created user is active by default]]></DESCRIPTION>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <HELP><![CDATA[If the Google Account used to login in Openbravo doesn't have an user associated, a new user is created. A default role is defined for this user. This flag defines if the newly created user should be active by default or not.]]></HELP>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <COLUMNNAME><![CDATA[Isnewuseractive]]></COLUMNNAME>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <AD_TABLE_ID><![CDATA[FF8080813161A3D301316206A5840008]]></AD_TABLE_ID>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <DEFAULTVALUE><![CDATA[N]]></DEFAULTVALUE>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <SEQNO><![CDATA[110]]></SEQNO>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <AD_ELEMENT_ID><![CDATA[E83520E8DFED4721BD2F8417EFEC3C07]]></AD_ELEMENT_ID>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <POSITION><![CDATA[11]]></POSITION>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--367B51FB95134BCC9E0AB630D1763899-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--367B51FB95134BCC9E0AB630D1763899--></AD_COLUMN>
+
+<!--508722B3E7184516A35F5800FB807214--><AD_COLUMN>
+<!--508722B3E7184516A35F5800FB807214-->  <AD_COLUMN_ID><![CDATA[508722B3E7184516A35F5800FB807214]]></AD_COLUMN_ID>
+<!--508722B3E7184516A35F5800FB807214-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--508722B3E7184516A35F5800FB807214-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--508722B3E7184516A35F5800FB807214-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--508722B3E7184516A35F5800FB807214-->  <NAME><![CDATA[Obseig_Defaults_ID]]></NAME>
+<!--508722B3E7184516A35F5800FB807214-->  <COLUMNNAME><![CDATA[Obseig_Defaults_ID]]></COLUMNNAME>
+<!--508722B3E7184516A35F5800FB807214-->  <AD_TABLE_ID><![CDATA[FF8080813161A3D301316206A5840008]]></AD_TABLE_ID>
+<!--508722B3E7184516A35F5800FB807214-->  <AD_REFERENCE_ID><![CDATA[13]]></AD_REFERENCE_ID>
+<!--508722B3E7184516A35F5800FB807214-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--508722B3E7184516A35F5800FB807214-->  <ISKEY><![CDATA[Y]]></ISKEY>
+<!--508722B3E7184516A35F5800FB807214-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--508722B3E7184516A35F5800FB807214-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--508722B3E7184516A35F5800FB807214-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--508722B3E7184516A35F5800FB807214-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--508722B3E7184516A35F5800FB807214-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--508722B3E7184516A35F5800FB807214-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--508722B3E7184516A35F5800FB807214-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--508722B3E7184516A35F5800FB807214-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--508722B3E7184516A35F5800FB807214-->  <AD_ELEMENT_ID><![CDATA[582E87EC64394CAF9D5DE3415B5A011B]]></AD_ELEMENT_ID>
+<!--508722B3E7184516A35F5800FB807214-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--508722B3E7184516A35F5800FB807214-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--508722B3E7184516A35F5800FB807214-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--508722B3E7184516A35F5800FB807214-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--508722B3E7184516A35F5800FB807214-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--508722B3E7184516A35F5800FB807214-->  <POSITION><![CDATA[1]]></POSITION>
+<!--508722B3E7184516A35F5800FB807214-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--508722B3E7184516A35F5800FB807214-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--508722B3E7184516A35F5800FB807214-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--508722B3E7184516A35F5800FB807214--></AD_COLUMN>
+
+<!--52A6D1BB00694B46BCC737240A27BEA1--><AD_COLUMN>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <AD_COLUMN_ID><![CDATA[52A6D1BB00694B46BCC737240A27BEA1]]></AD_COLUMN_ID>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <NAME><![CDATA[Organization]]></NAME>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <DESCRIPTION><![CDATA[Organizational entity within client]]></DESCRIPTION>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <HELP><![CDATA[An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.]]></HELP>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <COLUMNNAME><![CDATA[AD_Org_ID]]></COLUMNNAME>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <AD_TABLE_ID><![CDATA[FF8080813161A3D301316206A5840008]]></AD_TABLE_ID>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <DEFAULTVALUE><![CDATA[@AD_ORG_ID@]]></DEFAULTVALUE>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <AD_ELEMENT_ID><![CDATA[113]]></AD_ELEMENT_ID>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <POSITION><![CDATA[3]]></POSITION>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--52A6D1BB00694B46BCC737240A27BEA1-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--52A6D1BB00694B46BCC737240A27BEA1--></AD_COLUMN>
+
+<!--5887370AAF5A47C3AE119D29C4442A43--><AD_COLUMN>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <AD_COLUMN_ID><![CDATA[5887370AAF5A47C3AE119D29C4442A43]]></AD_COLUMN_ID>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <NAME><![CDATA[Role]]></NAME>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <DESCRIPTION><![CDATA[The profile of security for the user defining what windows and tabs they can see.]]></DESCRIPTION>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <HELP><![CDATA[The Role determines security and access a user who has this Role will have in the System.]]></HELP>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <COLUMNNAME><![CDATA[AD_Role_ID]]></COLUMNNAME>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <AD_TABLE_ID><![CDATA[FF8080813161A3D301316206A5840008]]></AD_TABLE_ID>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <ISPARENT><![CDATA[Y]]></ISPARENT>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <SEQNO><![CDATA[90]]></SEQNO>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <AD_ELEMENT_ID><![CDATA[123]]></AD_ELEMENT_ID>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <POSITION><![CDATA[9]]></POSITION>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--5887370AAF5A47C3AE119D29C4442A43-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--5887370AAF5A47C3AE119D29C4442A43--></AD_COLUMN>
+
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0--><AD_COLUMN>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <AD_COLUMN_ID><![CDATA[5F5AFB7517AC466EBCFA13CBB2B2EEF0]]></AD_COLUMN_ID>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <NAME><![CDATA[Updated]]></NAME>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <DESCRIPTION><![CDATA[x not implemented]]></DESCRIPTION>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <HELP><![CDATA[The Updated field indicates the date that this record was updated.]]></HELP>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <COLUMNNAME><![CDATA[Updated]]></COLUMNNAME>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <AD_TABLE_ID><![CDATA[FF8080813161A3D301316206A5840008]]></AD_TABLE_ID>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <DEFAULTVALUE><![CDATA[@#Date@]]></DEFAULTVALUE>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <SEQNO><![CDATA[70]]></SEQNO>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <AD_ELEMENT_ID><![CDATA[607]]></AD_ELEMENT_ID>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <POSITION><![CDATA[7]]></POSITION>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--5F5AFB7517AC466EBCFA13CBB2B2EEF0--></AD_COLUMN>
+
+<!--6105AABB22794402A57BF56C1EEC325E--><AD_COLUMN>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <AD_COLUMN_ID><![CDATA[6105AABB22794402A57BF56C1EEC325E]]></AD_COLUMN_ID>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <NAME><![CDATA[Default]]></NAME>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <DESCRIPTION><![CDATA[A value that is shown whenever a record is created.]]></DESCRIPTION>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <HELP><![CDATA[The Default Checkbox indicates if this record will be used as a default value.]]></HELP>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <COLUMNNAME><![CDATA[Isdefault]]></COLUMNNAME>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <AD_TABLE_ID><![CDATA[FF8080813161A3D301316206A5840008]]></AD_TABLE_ID>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <DEFAULTVALUE><![CDATA[N]]></DEFAULTVALUE>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <SEQNO><![CDATA[100]]></SEQNO>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <AD_ELEMENT_ID><![CDATA[1103]]></AD_ELEMENT_ID>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <POSITION><![CDATA[10]]></POSITION>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--6105AABB22794402A57BF56C1EEC325E-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--6105AABB22794402A57BF56C1EEC325E--></AD_COLUMN>
+
+<!--76E59140EB294155B8706CF5667A4574--><AD_COLUMN>
+<!--76E59140EB294155B8706CF5667A4574-->  <AD_COLUMN_ID><![CDATA[76E59140EB294155B8706CF5667A4574]]></AD_COLUMN_ID>
+<!--76E59140EB294155B8706CF5667A4574-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--76E59140EB294155B8706CF5667A4574-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--76E59140EB294155B8706CF5667A4574-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--76E59140EB294155B8706CF5667A4574-->  <NAME><![CDATA[Client]]></NAME>
+<!--76E59140EB294155B8706CF5667A4574-->  <DESCRIPTION><![CDATA[Client for this installation.]]></DESCRIPTION>
+<!--76E59140EB294155B8706CF5667A4574-->  <HELP><![CDATA[A Client is a company or a legal entity. You cannot share data between Clients.]]></HELP>
+<!--76E59140EB294155B8706CF5667A4574-->  <COLUMNNAME><![CDATA[AD_Client_ID]]></COLUMNNAME>
+<!--76E59140EB294155B8706CF5667A4574-->  <AD_TABLE_ID><![CDATA[FF8080813161A3D301316206A5840008]]></AD_TABLE_ID>
+<!--76E59140EB294155B8706CF5667A4574-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--76E59140EB294155B8706CF5667A4574-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--76E59140EB294155B8706CF5667A4574-->  <DEFAULTVALUE><![CDATA[@AD_CLIENT_ID@]]></DEFAULTVALUE>
+<!--76E59140EB294155B8706CF5667A4574-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--76E59140EB294155B8706CF5667A4574-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--76E59140EB294155B8706CF5667A4574-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--76E59140EB294155B8706CF5667A4574-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--76E59140EB294155B8706CF5667A4574-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--76E59140EB294155B8706CF5667A4574-->  <SEQNO><![CDATA[20]]></SEQNO>
+<!--76E59140EB294155B8706CF5667A4574-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--76E59140EB294155B8706CF5667A4574-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--76E59140EB294155B8706CF5667A4574-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--76E59140EB294155B8706CF5667A4574-->  <AD_ELEMENT_ID><![CDATA[102]]></AD_ELEMENT_ID>
+<!--76E59140EB294155B8706CF5667A4574-->  <ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
+<!--76E59140EB294155B8706CF5667A4574-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--76E59140EB294155B8706CF5667A4574-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--76E59140EB294155B8706CF5667A4574-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--76E59140EB294155B8706CF5667A4574-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--76E59140EB294155B8706CF5667A4574-->  <POSITION><![CDATA[2]]></POSITION>
+<!--76E59140EB294155B8706CF5667A4574-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--76E59140EB294155B8706CF5667A4574-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--76E59140EB294155B8706CF5667A4574-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--76E59140EB294155B8706CF5667A4574--></AD_COLUMN>
+
+<!--77EBA5E29565415A9F26C56FA285908F--><AD_COLUMN>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <AD_COLUMN_ID><![CDATA[77EBA5E29565415A9F26C56FA285908F]]></AD_COLUMN_ID>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <NAME><![CDATA[Updated By]]></NAME>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <DESCRIPTION><![CDATA[User who updated this records]]></DESCRIPTION>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <HELP><![CDATA[The Updated By field indicates the user who updated this record.]]></HELP>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <COLUMNNAME><![CDATA[Updatedby]]></COLUMNNAME>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <AD_TABLE_ID><![CDATA[FF8080813161A3D301316206A5840008]]></AD_TABLE_ID>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <SEQNO><![CDATA[80]]></SEQNO>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <AD_ELEMENT_ID><![CDATA[608]]></AD_ELEMENT_ID>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <POSITION><![CDATA[8]]></POSITION>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--77EBA5E29565415A9F26C56FA285908F-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--77EBA5E29565415A9F26C56FA285908F--></AD_COLUMN>
+
+<!--B6626495494D49829ED9450AAA8A6DCD--><AD_COLUMN>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <AD_COLUMN_ID><![CDATA[B6626495494D49829ED9450AAA8A6DCD]]></AD_COLUMN_ID>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <NAME><![CDATA[Creation Date]]></NAME>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <DESCRIPTION><![CDATA[The date that this record is completed.]]></DESCRIPTION>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <HELP><![CDATA[The Created field indicates the date that this record was created.]]></HELP>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <COLUMNNAME><![CDATA[Created]]></COLUMNNAME>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <AD_TABLE_ID><![CDATA[FF8080813161A3D301316206A5840008]]></AD_TABLE_ID>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <DEFAULTVALUE><![CDATA[@#Date@]]></DEFAULTVALUE>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <AD_ELEMENT_ID><![CDATA[245]]></AD_ELEMENT_ID>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <POSITION><![CDATA[5]]></POSITION>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--B6626495494D49829ED9450AAA8A6DCD-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--B6626495494D49829ED9450AAA8A6DCD--></AD_COLUMN>
+
+<!--FA207954D615418C8C2B34416215E698--><AD_COLUMN>
+<!--FA207954D615418C8C2B34416215E698-->  <AD_COLUMN_ID><![CDATA[FA207954D615418C8C2B34416215E698]]></AD_COLUMN_ID>
+<!--FA207954D615418C8C2B34416215E698-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FA207954D615418C8C2B34416215E698-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FA207954D615418C8C2B34416215E698-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FA207954D615418C8C2B34416215E698-->  <NAME><![CDATA[Active]]></NAME>
+<!--FA207954D615418C8C2B34416215E698-->  <DESCRIPTION><![CDATA[A flag indicating whether this record is available for use or de-activated.]]></DESCRIPTION>
+<!--FA207954D615418C8C2B34416215E698-->  <HELP><![CDATA[There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records: 
+(1) The system requires the record for auditing purposes.
+(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.]]></HELP>
+<!--FA207954D615418C8C2B34416215E698-->  <COLUMNNAME><![CDATA[Isactive]]></COLUMNNAME>
+<!--FA207954D615418C8C2B34416215E698-->  <AD_TABLE_ID><![CDATA[FF8080813161A3D301316206A5840008]]></AD_TABLE_ID>
+<!--FA207954D615418C8C2B34416215E698-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--FA207954D615418C8C2B34416215E698-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--FA207954D615418C8C2B34416215E698-->  <DEFAULTVALUE><![CDATA[Y]]></DEFAULTVALUE>
+<!--FA207954D615418C8C2B34416215E698-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--FA207954D615418C8C2B34416215E698-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--FA207954D615418C8C2B34416215E698-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--FA207954D615418C8C2B34416215E698-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--FA207954D615418C8C2B34416215E698-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--FA207954D615418C8C2B34416215E698-->  <SEQNO><![CDATA[40]]></SEQNO>
+<!--FA207954D615418C8C2B34416215E698-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--FA207954D615418C8C2B34416215E698-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--FA207954D615418C8C2B34416215E698-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--FA207954D615418C8C2B34416215E698-->  <AD_ELEMENT_ID><![CDATA[348]]></AD_ELEMENT_ID>
+<!--FA207954D615418C8C2B34416215E698-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--FA207954D615418C8C2B34416215E698-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--FA207954D615418C8C2B34416215E698-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--FA207954D615418C8C2B34416215E698-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--FA207954D615418C8C2B34416215E698-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FA207954D615418C8C2B34416215E698-->  <POSITION><![CDATA[4]]></POSITION>
+<!--FA207954D615418C8C2B34416215E698-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--FA207954D615418C8C2B34416215E698-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--FA207954D615418C8C2B34416215E698-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--FA207954D615418C8C2B34416215E698--></AD_COLUMN>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_ELEMENT.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,27 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--582E87EC64394CAF9D5DE3415B5A011B--><AD_ELEMENT>
+<!--582E87EC64394CAF9D5DE3415B5A011B-->  <AD_ELEMENT_ID><![CDATA[582E87EC64394CAF9D5DE3415B5A011B]]></AD_ELEMENT_ID>
+<!--582E87EC64394CAF9D5DE3415B5A011B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--582E87EC64394CAF9D5DE3415B5A011B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--582E87EC64394CAF9D5DE3415B5A011B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--582E87EC64394CAF9D5DE3415B5A011B-->  <COLUMNNAME><![CDATA[Obseig_Defaults_ID]]></COLUMNNAME>
+<!--582E87EC64394CAF9D5DE3415B5A011B-->  <NAME><![CDATA[Obseig_Defaults_ID]]></NAME>
+<!--582E87EC64394CAF9D5DE3415B5A011B-->  <PRINTNAME><![CDATA[Obseig_Defaults_ID]]></PRINTNAME>
+<!--582E87EC64394CAF9D5DE3415B5A011B-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--582E87EC64394CAF9D5DE3415B5A011B--></AD_ELEMENT>
+
+<!--E83520E8DFED4721BD2F8417EFEC3C07--><AD_ELEMENT>
+<!--E83520E8DFED4721BD2F8417EFEC3C07-->  <AD_ELEMENT_ID><![CDATA[E83520E8DFED4721BD2F8417EFEC3C07]]></AD_ELEMENT_ID>
+<!--E83520E8DFED4721BD2F8417EFEC3C07-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E83520E8DFED4721BD2F8417EFEC3C07-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E83520E8DFED4721BD2F8417EFEC3C07-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E83520E8DFED4721BD2F8417EFEC3C07-->  <COLUMNNAME><![CDATA[Isnewuseractive]]></COLUMNNAME>
+<!--E83520E8DFED4721BD2F8417EFEC3C07-->  <NAME><![CDATA[New User Active]]></NAME>
+<!--E83520E8DFED4721BD2F8417EFEC3C07-->  <PRINTNAME><![CDATA[New User Active]]></PRINTNAME>
+<!--E83520E8DFED4721BD2F8417EFEC3C07-->  <DESCRIPTION><![CDATA[Defines if a newly created user is active by default]]></DESCRIPTION>
+<!--E83520E8DFED4721BD2F8417EFEC3C07-->  <HELP><![CDATA[If the Google Account used to login in Openbravo doesn't have an user associated, a new user is created. A default role is defined for this user. This flag defines if the newly created user should be active by default or not.]]></HELP>
+<!--E83520E8DFED4721BD2F8417EFEC3C07-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--E83520E8DFED4721BD2F8417EFEC3C07--></AD_ELEMENT>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_EP_PROCEDURES.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,13 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF808081318454090131846F46FD001C--><AD_EP_PROCEDURES>
+<!--FF808081318454090131846F46FD001C-->  <AD_EP_PROCEDURES_ID><![CDATA[FF808081318454090131846F46FD001C]]></AD_EP_PROCEDURES_ID>
+<!--FF808081318454090131846F46FD001C-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808081318454090131846F46FD001C-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808081318454090131846F46FD001C-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808081318454090131846F46FD001C-->  <AD_EXTENSION_POINTS_ID><![CDATA[8261F79453B64AC7998873A9F81A1E5A]]></AD_EXTENSION_POINTS_ID>
+<!--FF808081318454090131846F46FD001C-->  <PROCEDURENAME><![CDATA[OBSEIG_Update_Access]]></PROCEDURENAME>
+<!--FF808081318454090131846F46FD001C-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF808081318454090131846F46FD001C--></AD_EP_PROCEDURES>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_FIELD.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,183 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--07704D7F8EC54861B176ACC4F0803A47--><AD_FIELD>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <AD_FIELD_ID><![CDATA[07704D7F8EC54861B176ACC4F0803A47]]></AD_FIELD_ID>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <NAME><![CDATA[Default Role]]></NAME>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <DESCRIPTION><![CDATA[Defines the default role used when creating a new user]]></DESCRIPTION>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <HELP><![CDATA[Defines the default role used when the process of login in with a Google Account doesn't find any Openbravo user associated with the account.]]></HELP>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <ISCENTRALLYMAINTAINED><![CDATA[N]]></ISCENTRALLYMAINTAINED>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <AD_TAB_ID><![CDATA[FF8080813161A3D30131620862BF0014]]></AD_TAB_ID>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <AD_COLUMN_ID><![CDATA[5887370AAF5A47C3AE119D29C4442A43]]></AD_COLUMN_ID>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <SEQNO><![CDATA[40]]></SEQNO>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--07704D7F8EC54861B176ACC4F0803A47-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--07704D7F8EC54861B176ACC4F0803A47--></AD_FIELD>
+
+<!--181EE3DEC27940D2A9E82C67B895AF18--><AD_FIELD>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <AD_FIELD_ID><![CDATA[181EE3DEC27940D2A9E82C67B895AF18]]></AD_FIELD_ID>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <NAME><![CDATA[Organization]]></NAME>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <DESCRIPTION><![CDATA[Organizational entity within client]]></DESCRIPTION>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <HELP><![CDATA[An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.]]></HELP>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <AD_TAB_ID><![CDATA[FF8080813161A3D30131620862BF0014]]></AD_TAB_ID>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <AD_COLUMN_ID><![CDATA[52A6D1BB00694B46BCC737240A27BEA1]]></AD_COLUMN_ID>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--181EE3DEC27940D2A9E82C67B895AF18-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--181EE3DEC27940D2A9E82C67B895AF18--></AD_FIELD>
+
+<!--37CD013C64354C66BE23525F241A3A99--><AD_FIELD>
+<!--37CD013C64354C66BE23525F241A3A99-->  <AD_FIELD_ID><![CDATA[37CD013C64354C66BE23525F241A3A99]]></AD_FIELD_ID>
+<!--37CD013C64354C66BE23525F241A3A99-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--37CD013C64354C66BE23525F241A3A99-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--37CD013C64354C66BE23525F241A3A99-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--37CD013C64354C66BE23525F241A3A99-->  <NAME><![CDATA[Active]]></NAME>
+<!--37CD013C64354C66BE23525F241A3A99-->  <DESCRIPTION><![CDATA[A flag indicating whether this record is available for use or de-activated.]]></DESCRIPTION>
+<!--37CD013C64354C66BE23525F241A3A99-->  <HELP><![CDATA[There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records: 
+(1) The system requires the record for auditing purposes.
+(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.]]></HELP>
+<!--37CD013C64354C66BE23525F241A3A99-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--37CD013C64354C66BE23525F241A3A99-->  <AD_TAB_ID><![CDATA[FF8080813161A3D30131620862BF0014]]></AD_TAB_ID>
+<!--37CD013C64354C66BE23525F241A3A99-->  <AD_COLUMN_ID><![CDATA[FA207954D615418C8C2B34416215E698]]></AD_COLUMN_ID>
+<!--37CD013C64354C66BE23525F241A3A99-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--37CD013C64354C66BE23525F241A3A99-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--37CD013C64354C66BE23525F241A3A99-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--37CD013C64354C66BE23525F241A3A99-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--37CD013C64354C66BE23525F241A3A99-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--37CD013C64354C66BE23525F241A3A99-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--37CD013C64354C66BE23525F241A3A99-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--37CD013C64354C66BE23525F241A3A99-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--37CD013C64354C66BE23525F241A3A99-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--37CD013C64354C66BE23525F241A3A99-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--37CD013C64354C66BE23525F241A3A99-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--37CD013C64354C66BE23525F241A3A99-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--37CD013C64354C66BE23525F241A3A99-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--37CD013C64354C66BE23525F241A3A99--></AD_FIELD>
+
+<!--53C51764570E43D8823135352C289B48--><AD_FIELD>
+<!--53C51764570E43D8823135352C289B48-->  <AD_FIELD_ID><![CDATA[53C51764570E43D8823135352C289B48]]></AD_FIELD_ID>
+<!--53C51764570E43D8823135352C289B48-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--53C51764570E43D8823135352C289B48-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--53C51764570E43D8823135352C289B48-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--53C51764570E43D8823135352C289B48-->  <NAME><![CDATA[Default]]></NAME>
+<!--53C51764570E43D8823135352C289B48-->  <DESCRIPTION><![CDATA[A value that is shown whenever a record is created.]]></DESCRIPTION>
+<!--53C51764570E43D8823135352C289B48-->  <HELP><![CDATA[The Default Checkbox indicates if this record will be used as a default value.]]></HELP>
+<!--53C51764570E43D8823135352C289B48-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--53C51764570E43D8823135352C289B48-->  <AD_TAB_ID><![CDATA[FF8080813161A3D30131620862BF0014]]></AD_TAB_ID>
+<!--53C51764570E43D8823135352C289B48-->  <AD_COLUMN_ID><![CDATA[6105AABB22794402A57BF56C1EEC325E]]></AD_COLUMN_ID>
+<!--53C51764570E43D8823135352C289B48-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--53C51764570E43D8823135352C289B48-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--53C51764570E43D8823135352C289B48-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--53C51764570E43D8823135352C289B48-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--53C51764570E43D8823135352C289B48-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--53C51764570E43D8823135352C289B48-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--53C51764570E43D8823135352C289B48-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--53C51764570E43D8823135352C289B48-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--53C51764570E43D8823135352C289B48-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--53C51764570E43D8823135352C289B48-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--53C51764570E43D8823135352C289B48-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--53C51764570E43D8823135352C289B48-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--53C51764570E43D8823135352C289B48-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--53C51764570E43D8823135352C289B48--></AD_FIELD>
+
+<!--930F6B0AACCA4D4B8AD5ABD90990B014--><AD_FIELD>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <AD_FIELD_ID><![CDATA[930F6B0AACCA4D4B8AD5ABD90990B014]]></AD_FIELD_ID>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <NAME><![CDATA[Obseig_Defaults_ID]]></NAME>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <AD_TAB_ID><![CDATA[FF8080813161A3D30131620862BF0014]]></AD_TAB_ID>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <AD_COLUMN_ID><![CDATA[508722B3E7184516A35F5800FB807214]]></AD_COLUMN_ID>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--930F6B0AACCA4D4B8AD5ABD90990B014--></AD_FIELD>
+
+<!--A8EAC4B766534D86887CFE4EA3E808D7--><AD_FIELD>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <AD_FIELD_ID><![CDATA[A8EAC4B766534D86887CFE4EA3E808D7]]></AD_FIELD_ID>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <NAME><![CDATA[New User Active]]></NAME>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <DESCRIPTION><![CDATA[Defines if a newly created user is active by default]]></DESCRIPTION>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <HELP><![CDATA[If the Google Account used to login in Openbravo doesn't have an user associated, a new user is created. A default role is defined for this user. This flag defines if the newly created user should be active by default or not.]]></HELP>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <AD_TAB_ID><![CDATA[FF8080813161A3D30131620862BF0014]]></AD_TAB_ID>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <AD_COLUMN_ID><![CDATA[367B51FB95134BCC9E0AB630D1763899]]></AD_COLUMN_ID>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--A8EAC4B766534D86887CFE4EA3E808D7-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--A8EAC4B766534D86887CFE4EA3E808D7--></AD_FIELD>
+
+<!--C79402A852F2439C8BB0C688C76E977D--><AD_FIELD>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <AD_FIELD_ID><![CDATA[C79402A852F2439C8BB0C688C76E977D]]></AD_FIELD_ID>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <NAME><![CDATA[Client]]></NAME>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <DESCRIPTION><![CDATA[Client for this installation.]]></DESCRIPTION>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <HELP><![CDATA[A Client is a company or a legal entity. You cannot share data between Clients.]]></HELP>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <AD_TAB_ID><![CDATA[FF8080813161A3D30131620862BF0014]]></AD_TAB_ID>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <AD_COLUMN_ID><![CDATA[76E59140EB294155B8706CF5667A4574]]></AD_COLUMN_ID>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--C79402A852F2439C8BB0C688C76E977D-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--C79402A852F2439C8BB0C688C76E977D--></AD_FIELD>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MENU.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,28 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF8080813151AEE1013151B119D10005--><AD_MENU>
+<!--FF8080813151AEE1013151B119D10005-->  <AD_MENU_ID><![CDATA[FF8080813151AEE1013151B119D10005]]></AD_MENU_ID>
+<!--FF8080813151AEE1013151B119D10005-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080813151AEE1013151B119D10005-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF8080813151AEE1013151B119D10005-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF8080813151AEE1013151B119D10005-->  <NAME><![CDATA[Google Account Association]]></NAME>
+<!--FF8080813151AEE1013151B119D10005-->  <DESCRIPTION><![CDATA[Process to associate a Openbravo user with a Google Account]]></DESCRIPTION>
+<!--FF8080813151AEE1013151B119D10005-->  <ISSUMMARY><![CDATA[N]]></ISSUMMARY>
+<!--FF8080813151AEE1013151B119D10005-->  <ACTION><![CDATA[OBUIAPP_OpenView]]></ACTION>
+<!--FF8080813151AEE1013151B119D10005-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF8080813151AEE1013151B119D10005-->  <EM_OBUIAPP_VIEW_IMPL_ID><![CDATA[FF808081314D5BAC01314D64B9920013]]></EM_OBUIAPP_VIEW_IMPL_ID>
+<!--FF8080813151AEE1013151B119D10005--></AD_MENU>
+
+<!--FF8080813161A3D3013162164AB10038--><AD_MENU>
+<!--FF8080813161A3D3013162164AB10038-->  <AD_MENU_ID><![CDATA[FF8080813161A3D3013162164AB10038]]></AD_MENU_ID>
+<!--FF8080813161A3D3013162164AB10038-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080813161A3D3013162164AB10038-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF8080813161A3D3013162164AB10038-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF8080813161A3D3013162164AB10038-->  <NAME><![CDATA[Google Integration Preferences]]></NAME>
+<!--FF8080813161A3D3013162164AB10038-->  <ISSUMMARY><![CDATA[N]]></ISSUMMARY>
+<!--FF8080813161A3D3013162164AB10038-->  <ACTION><![CDATA[W]]></ACTION>
+<!--FF8080813161A3D3013162164AB10038-->  <AD_WINDOW_ID><![CDATA[FF8080813161A3D301316208017A0011]]></AD_WINDOW_ID>
+<!--FF8080813161A3D3013162164AB10038-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF8080813161A3D3013162164AB10038--></AD_MENU>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MESSAGE.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,84 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF808081316ACC4501316ADAA4FB0006--><AD_MESSAGE>
+<!--FF808081316ACC4501316ADAA4FB0006-->  <AD_MESSAGE_ID><![CDATA[FF808081316ACC4501316ADAA4FB0006]]></AD_MESSAGE_ID>
+<!--FF808081316ACC4501316ADAA4FB0006-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808081316ACC4501316ADAA4FB0006-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808081316ACC4501316ADAA4FB0006-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808081316ACC4501316ADAA4FB0006-->  <VALUE><![CDATA[OBSEIG_AssociateAccount]]></VALUE>
+<!--FF808081316ACC4501316ADAA4FB0006-->  <MSGTEXT><![CDATA[This process links your Openbravo User with your Google Account. After completion if you access the system using your Google Account you will be logged in with you current User.]]></MSGTEXT>
+<!--FF808081316ACC4501316ADAA4FB0006-->  <MSGTYPE><![CDATA[I]]></MSGTYPE>
+<!--FF808081316ACC4501316ADAA4FB0006-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF808081316ACC4501316ADAA4FB0006--></AD_MESSAGE>
+
+<!--FF808081318513B201318519AE3C0005--><AD_MESSAGE>
+<!--FF808081318513B201318519AE3C0005-->  <AD_MESSAGE_ID><![CDATA[FF808081318513B201318519AE3C0005]]></AD_MESSAGE_ID>
+<!--FF808081318513B201318519AE3C0005-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808081318513B201318519AE3C0005-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808081318513B201318519AE3C0005-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808081318513B201318519AE3C0005-->  <VALUE><![CDATA[OBSEIG_SignIn]]></VALUE>
+<!--FF808081318513B201318519AE3C0005-->  <MSGTEXT><![CDATA[Sign in using:]]></MSGTEXT>
+<!--FF808081318513B201318519AE3C0005-->  <MSGTYPE><![CDATA[I]]></MSGTYPE>
+<!--FF808081318513B201318519AE3C0005-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF808081318513B201318519AE3C0005--></AD_MESSAGE>
+
+<!--FF808081318513B20131851A50FD000A--><AD_MESSAGE>
+<!--FF808081318513B20131851A50FD000A-->  <AD_MESSAGE_ID><![CDATA[FF808081318513B20131851A50FD000A]]></AD_MESSAGE_ID>
+<!--FF808081318513B20131851A50FD000A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808081318513B20131851A50FD000A-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808081318513B20131851A50FD000A-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808081318513B20131851A50FD000A-->  <VALUE><![CDATA[OBSEIG_SignInAltMsg]]></VALUE>
+<!--FF808081318513B20131851A50FD000A-->  <MSGTEXT><![CDATA[Sign in using your Google Account]]></MSGTEXT>
+<!--FF808081318513B20131851A50FD000A-->  <MSGTYPE><![CDATA[I]]></MSGTYPE>
+<!--FF808081318513B20131851A50FD000A-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF808081318513B20131851A50FD000A--></AD_MESSAGE>
+
+<!--FF808081318528680131852B80EF000A--><AD_MESSAGE>
+<!--FF808081318528680131852B80EF000A-->  <AD_MESSAGE_ID><![CDATA[FF808081318528680131852B80EF000A]]></AD_MESSAGE_ID>
+<!--FF808081318528680131852B80EF000A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808081318528680131852B80EF000A-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808081318528680131852B80EF000A-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808081318528680131852B80EF000A-->  <VALUE><![CDATA[OBSEIG_Activate]]></VALUE>
+<!--FF808081318528680131852B80EF000A-->  <MSGTEXT><![CDATA[Only Professional and Basic Edition subscribers can log in to application using Google Account. <a target="_blank" href="http://www.openbravo.com/product/erp/editions/">Learn more</a> about the benefits of Openbravo's commercial editions.]]></MSGTEXT>
+<!--FF808081318528680131852B80EF000A-->  <MSGTYPE><![CDATA[I]]></MSGTYPE>
+<!--FF808081318528680131852B80EF000A-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF808081318528680131852B80EF000A--></AD_MESSAGE>
+
+<!--FF80808131862F7C0131863B5AD50006--><AD_MESSAGE>
+<!--FF80808131862F7C0131863B5AD50006-->  <AD_MESSAGE_ID><![CDATA[FF80808131862F7C0131863B5AD50006]]></AD_MESSAGE_ID>
+<!--FF80808131862F7C0131863B5AD50006-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF80808131862F7C0131863B5AD50006-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF80808131862F7C0131863B5AD50006-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF80808131862F7C0131863B5AD50006-->  <VALUE><![CDATA[OBSEIG_NoDefaultConf]]></VALUE>
+<!--FF80808131862F7C0131863B5AD50006-->  <MSGTEXT><![CDATA[Google Account login configuration of this instance does not allow an access to application using @@email@@.
+Learn more about it or contact this instance System Administrator for help.]]></MSGTEXT>
+<!--FF80808131862F7C0131863B5AD50006-->  <MSGTIP><![CDATA[Don't delete the @@email@@ place-holder]]></MSGTIP>
+<!--FF80808131862F7C0131863B5AD50006-->  <MSGTYPE><![CDATA[I]]></MSGTYPE>
+<!--FF80808131862F7C0131863B5AD50006-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF80808131862F7C0131863B5AD50006--></AD_MESSAGE>
+
+<!--FF808081318644E001318647A9A20008--><AD_MESSAGE>
+<!--FF808081318644E001318647A9A20008-->  <AD_MESSAGE_ID><![CDATA[FF808081318644E001318647A9A20008]]></AD_MESSAGE_ID>
+<!--FF808081318644E001318647A9A20008-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808081318644E001318647A9A20008-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808081318644E001318647A9A20008-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808081318644E001318647A9A20008-->  <VALUE><![CDATA[OBSEIG_TooMuchConf]]></VALUE>
+<!--FF808081318644E001318647A9A20008-->  <MSGTEXT><![CDATA[Google Account login configuration of this instance does not allow an access to application using @@emai@l@.
+Learn more about it or contact this instance System Administrator for help.]]></MSGTEXT>
+<!--FF808081318644E001318647A9A20008-->  <MSGTIP><![CDATA[Don't delete the @@email@@ place-holder]]></MSGTIP>
+<!--FF808081318644E001318647A9A20008-->  <MSGTYPE><![CDATA[I]]></MSGTYPE>
+<!--FF808081318644E001318647A9A20008-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF808081318644E001318647A9A20008--></AD_MESSAGE>
+
+<!--FF808081318644E00131864951C20011--><AD_MESSAGE>
+<!--FF808081318644E00131864951C20011-->  <AD_MESSAGE_ID><![CDATA[FF808081318644E00131864951C20011]]></AD_MESSAGE_ID>
+<!--FF808081318644E00131864951C20011-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808081318644E00131864951C20011-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808081318644E00131864951C20011-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808081318644E00131864951C20011-->  <VALUE><![CDATA[OBSEIG_LinkedOK]]></VALUE>
+<!--FF808081318644E00131864951C20011-->  <MSGTEXT><![CDATA[Your user and Google Account have been successfully linked]]></MSGTEXT>
+<!--FF808081318644E00131864951C20011-->  <MSGTYPE><![CDATA[I]]></MSGTYPE>
+<!--FF808081318644E00131864951C20011-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF808081318644E00131864951C20011--></AD_MESSAGE>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODEL_OBJECT.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,16 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF808081312DCA1801312DDE6A090004--><AD_MODEL_OBJECT>
+<!--FF808081312DCA1801312DDE6A090004-->  <AD_MODEL_OBJECT_ID><![CDATA[FF808081312DCA1801312DDE6A090004]]></AD_MODEL_OBJECT_ID>
+<!--FF808081312DCA1801312DDE6A090004-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808081312DCA1801312DDE6A090004-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808081312DCA1801312DDE6A090004-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808081312DCA1801312DDE6A090004-->  <ACTION><![CDATA[M]]></ACTION>
+<!--FF808081312DCA1801312DDE6A090004-->  <CLASSNAME><![CDATA[org.openbravo.service.integration.google.GoogleAuthServlet]]></CLASSNAME>
+<!--FF808081312DCA1801312DDE6A090004-->  <ISDEFAULT><![CDATA[Y]]></ISDEFAULT>
+<!--FF808081312DCA1801312DDE6A090004-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF808081312DCA1801312DDE6A090004-->  <OBJECT_TYPE><![CDATA[S]]></OBJECT_TYPE>
+<!--FF808081312DCA1801312DDE6A090004-->  <NAME><![CDATA[GoogleAuthServlet]]></NAME>
+<!--FF808081312DCA1801312DDE6A090004--></AD_MODEL_OBJECT>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,13 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF808081312DCA1801312DDF0EB90007--><AD_MODEL_OBJECT_MAPPING>
+<!--FF808081312DCA1801312DDF0EB90007-->  <AD_MODEL_OBJECT_MAPPING_ID><![CDATA[FF808081312DCA1801312DDF0EB90007]]></AD_MODEL_OBJECT_MAPPING_ID>
+<!--FF808081312DCA1801312DDF0EB90007-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808081312DCA1801312DDF0EB90007-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808081312DCA1801312DDF0EB90007-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808081312DCA1801312DDF0EB90007-->  <AD_MODEL_OBJECT_ID><![CDATA[FF808081312DCA1801312DDE6A090004]]></AD_MODEL_OBJECT_ID>
+<!--FF808081312DCA1801312DDF0EB90007-->  <MAPPINGNAME><![CDATA[/org.openbravo.service.integration.google/auth.html]]></MAPPINGNAME>
+<!--FF808081312DCA1801312DDF0EB90007-->  <ISDEFAULT><![CDATA[Y]]></ISDEFAULT>
+<!--FF808081312DCA1801312DDF0EB90007--></AD_MODEL_OBJECT_MAPPING>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,24 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF8080813129ADA401312CA1222A0005--><AD_MODULE>
+<!--FF8080813129ADA401312CA1222A0005-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF8080813129ADA401312CA1222A0005-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080813129ADA401312CA1222A0005-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF8080813129ADA401312CA1222A0005-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF8080813129ADA401312CA1222A0005-->  <NAME><![CDATA[Integration with Google APIs]]></NAME>
+<!--FF8080813129ADA401312CA1222A0005-->  <VERSION><![CDATA[0.1.0]]></VERSION>
+<!--FF8080813129ADA401312CA1222A0005-->  <DESCRIPTION><![CDATA[Integration with Google APIs]]></DESCRIPTION>
+<!--FF8080813129ADA401312CA1222A0005-->  <TYPE><![CDATA[M]]></TYPE>
+<!--FF8080813129ADA401312CA1222A0005-->  <LICENSE><![CDATA[Licensed under the Openbravo Public License Version 1.1.
+You may obtain a copy of the License at http://www.openbravo.com/legal/license.html or in the legal folder of the Openbravo ERP core distribution.]]></LICENSE>
+<!--FF8080813129ADA401312CA1222A0005-->  <JAVAPACKAGE><![CDATA[org.openbravo.service.integration.google]]></JAVAPACKAGE>
+<!--FF8080813129ADA401312CA1222A0005-->  <AUTHOR><![CDATA[Openbravo S.L.U.]]></AUTHOR>
+<!--FF8080813129ADA401312CA1222A0005-->  <ISTRANSLATIONREQUIRED><![CDATA[Y]]></ISTRANSLATIONREQUIRED>
+<!--FF8080813129ADA401312CA1222A0005-->  <AD_LANGUAGE><![CDATA[en_US]]></AD_LANGUAGE>
+<!--FF8080813129ADA401312CA1222A0005-->  <HASCHARTOFACCOUNTS><![CDATA[N]]></HASCHARTOFACCOUNTS>
+<!--FF8080813129ADA401312CA1222A0005-->  <ISTRANSLATIONMODULE><![CDATA[N]]></ISTRANSLATIONMODULE>
+<!--FF8080813129ADA401312CA1222A0005-->  <HASREFERENCEDATA><![CDATA[N]]></HASREFERENCEDATA>
+<!--FF8080813129ADA401312CA1222A0005-->  <ISCOMMERCIAL><![CDATA[N]]></ISCOMMERCIAL>
+<!--FF8080813129ADA401312CA1222A0005--></AD_MODULE>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE_DBPREFIX.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,12 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF8080813129ADA401312CAB31DE001F--><AD_MODULE_DBPREFIX>
+<!--FF8080813129ADA401312CAB31DE001F-->  <AD_MODULE_DBPREFIX_ID><![CDATA[FF8080813129ADA401312CAB31DE001F]]></AD_MODULE_DBPREFIX_ID>
+<!--FF8080813129ADA401312CAB31DE001F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080813129ADA401312CAB31DE001F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF8080813129ADA401312CAB31DE001F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF8080813129ADA401312CAB31DE001F-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF8080813129ADA401312CAB31DE001F-->  <NAME><![CDATA[OBSEIG]]></NAME>
+<!--FF8080813129ADA401312CAB31DE001F--></AD_MODULE_DBPREFIX>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,31 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF8080813141B198013141BA0F7D0012--><AD_MODULE_DEPENDENCY>
+<!--FF8080813141B198013141BA0F7D0012-->  <AD_MODULE_DEPENDENCY_ID><![CDATA[FF8080813141B198013141BA0F7D0012]]></AD_MODULE_DEPENDENCY_ID>
+<!--FF8080813141B198013141BA0F7D0012-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080813141B198013141BA0F7D0012-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF8080813141B198013141BA0F7D0012-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF8080813141B198013141BA0F7D0012-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF8080813141B198013141BA0F7D0012-->  <AD_DEPENDENT_MODULE_ID><![CDATA[FF8080813141B198013141B86DD70003]]></AD_DEPENDENT_MODULE_ID>
+<!--FF8080813141B198013141BA0F7D0012-->  <STARTVERSION><![CDATA[0.1.0]]></STARTVERSION>
+<!--FF8080813141B198013141BA0F7D0012-->  <ISINCLUDED><![CDATA[N]]></ISINCLUDED>
+<!--FF8080813141B198013141BA0F7D0012-->  <DEPENDANT_MODULE_NAME><![CDATA[OpenID Service Integration]]></DEPENDANT_MODULE_NAME>
+<!--FF8080813141B198013141BA0F7D0012-->  <DEPENDENCY_ENFORCEMENT><![CDATA[MAJOR]]></DEPENDENCY_ENFORCEMENT>
+<!--FF8080813141B198013141BA0F7D0012-->  <USER_EDITABLE_ENFORCEMENT><![CDATA[N]]></USER_EDITABLE_ENFORCEMENT>
+<!--FF8080813141B198013141BA0F7D0012--></AD_MODULE_DEPENDENCY>
+
+<!--FF8080813151AEE1013151C4ACE6001B--><AD_MODULE_DEPENDENCY>
+<!--FF8080813151AEE1013151C4ACE6001B-->  <AD_MODULE_DEPENDENCY_ID><![CDATA[FF8080813151AEE1013151C4ACE6001B]]></AD_MODULE_DEPENDENCY_ID>
+<!--FF8080813151AEE1013151C4ACE6001B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080813151AEE1013151C4ACE6001B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF8080813151AEE1013151C4ACE6001B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF8080813151AEE1013151C4ACE6001B-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF8080813151AEE1013151C4ACE6001B-->  <AD_DEPENDENT_MODULE_ID><![CDATA[7E48CDD73B7E493A8BED4F7253E7C989]]></AD_DEPENDENT_MODULE_ID>
+<!--FF8080813151AEE1013151C4ACE6001B-->  <STARTVERSION><![CDATA[2.1.13133]]></STARTVERSION>
+<!--FF8080813151AEE1013151C4ACE6001B-->  <ISINCLUDED><![CDATA[N]]></ISINCLUDED>
+<!--FF8080813151AEE1013151C4ACE6001B-->  <DEPENDANT_MODULE_NAME><![CDATA[Openbravo 3.0 Framework]]></DEPENDANT_MODULE_NAME>
+<!--FF8080813151AEE1013151C4ACE6001B-->  <DEPENDENCY_ENFORCEMENT><![CDATA[MAJOR]]></DEPENDENCY_ENFORCEMENT>
+<!--FF8080813151AEE1013151C4ACE6001B-->  <USER_EDITABLE_ENFORCEMENT><![CDATA[N]]></USER_EDITABLE_ENFORCEMENT>
+<!--FF8080813151AEE1013151C4ACE6001B--></AD_MODULE_DEPENDENCY>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_PACKAGE.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,13 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF8080813129ADA401312CAC54900029--><AD_PACKAGE>
+<!--FF8080813129ADA401312CAC54900029-->  <AD_PACKAGE_ID><![CDATA[FF8080813129ADA401312CAC54900029]]></AD_PACKAGE_ID>
+<!--FF8080813129ADA401312CAC54900029-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080813129ADA401312CAC54900029-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF8080813129ADA401312CAC54900029-->  <NAME><![CDATA[org.openbravo.service.integration.google]]></NAME>
+<!--FF8080813129ADA401312CAC54900029-->  <JAVAPACKAGE><![CDATA[org.openbravo.service.integration.google]]></JAVAPACKAGE>
+<!--FF8080813129ADA401312CAC54900029-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF8080813129ADA401312CAC54900029-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF8080813129ADA401312CAC54900029--></AD_PACKAGE>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_TAB.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,26 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF8080813161A3D30131620862BF0014--><AD_TAB>
+<!--FF8080813161A3D30131620862BF0014-->  <AD_TAB_ID><![CDATA[FF8080813161A3D30131620862BF0014]]></AD_TAB_ID>
+<!--FF8080813161A3D30131620862BF0014-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080813161A3D30131620862BF0014-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF8080813161A3D30131620862BF0014-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF8080813161A3D30131620862BF0014-->  <NAME><![CDATA[Google Integration Defaults]]></NAME>
+<!--FF8080813161A3D30131620862BF0014-->  <AD_TABLE_ID><![CDATA[FF8080813161A3D301316206A5840008]]></AD_TABLE_ID>
+<!--FF8080813161A3D30131620862BF0014-->  <AD_WINDOW_ID><![CDATA[FF8080813161A3D301316208017A0011]]></AD_WINDOW_ID>
+<!--FF8080813161A3D30131620862BF0014-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--FF8080813161A3D30131620862BF0014-->  <TABLEVEL><![CDATA[0]]></TABLEVEL>
+<!--FF8080813161A3D30131620862BF0014-->  <ISSINGLEROW><![CDATA[N]]></ISSINGLEROW>
+<!--FF8080813161A3D30131620862BF0014-->  <ISINFOTAB><![CDATA[N]]></ISINFOTAB>
+<!--FF8080813161A3D30131620862BF0014-->  <ISTRANSLATIONTAB><![CDATA[N]]></ISTRANSLATIONTAB>
+<!--FF8080813161A3D30131620862BF0014-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--FF8080813161A3D30131620862BF0014-->  <HASTREE><![CDATA[N]]></HASTREE>
+<!--FF8080813161A3D30131620862BF0014-->  <PROCESSING><![CDATA[N]]></PROCESSING>
+<!--FF8080813161A3D30131620862BF0014-->  <IMPORTFIELDS><![CDATA[N]]></IMPORTFIELDS>
+<!--FF8080813161A3D30131620862BF0014-->  <ISSORTTAB><![CDATA[N]]></ISSORTTAB>
+<!--FF8080813161A3D30131620862BF0014-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF8080813161A3D30131620862BF0014-->  <UIPATTERN><![CDATA[STD]]></UIPATTERN>
+<!--FF8080813161A3D30131620862BF0014-->  <SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
+<!--FF8080813161A3D30131620862BF0014--></AD_TAB>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_TABLE.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,23 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF8080813161A3D301316206A5840008--><AD_TABLE>
+<!--FF8080813161A3D301316206A5840008-->  <AD_TABLE_ID><![CDATA[FF8080813161A3D301316206A5840008]]></AD_TABLE_ID>
+<!--FF8080813161A3D301316206A5840008-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080813161A3D301316206A5840008-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF8080813161A3D301316206A5840008-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF8080813161A3D301316206A5840008-->  <NAME><![CDATA[OBSEIG_Defaults]]></NAME>
+<!--FF8080813161A3D301316206A5840008-->  <TABLENAME><![CDATA[OBSEIG_Defaults]]></TABLENAME>
+<!--FF8080813161A3D301316206A5840008-->  <CLASSNAME><![CDATA[OBSEIGDefaults]]></CLASSNAME>
+<!--FF8080813161A3D301316206A5840008-->  <ISVIEW><![CDATA[N]]></ISVIEW>
+<!--FF8080813161A3D301316206A5840008-->  <ACCESSLEVEL><![CDATA[3]]></ACCESSLEVEL>
+<!--FF8080813161A3D301316206A5840008-->  <ISSECURITYENABLED><![CDATA[N]]></ISSECURITYENABLED>
+<!--FF8080813161A3D301316206A5840008-->  <ISDELETEABLE><![CDATA[Y]]></ISDELETEABLE>
+<!--FF8080813161A3D301316206A5840008-->  <ISHIGHVOLUME><![CDATA[N]]></ISHIGHVOLUME>
+<!--FF8080813161A3D301316206A5840008-->  <IMPORTTABLE><![CDATA[N]]></IMPORTTABLE>
+<!--FF8080813161A3D301316206A5840008-->  <ISCHANGELOG><![CDATA[N]]></ISCHANGELOG>
+<!--FF8080813161A3D301316206A5840008-->  <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
+<!--FF8080813161A3D301316206A5840008-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--FF8080813161A3D301316206A5840008-->  <AD_PACKAGE_ID><![CDATA[FF8080813129ADA401312CAC54900029]]></AD_PACKAGE_ID>
+<!--FF8080813161A3D301316206A5840008--></AD_TABLE>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_TREENODE.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,25 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--3478924D8D8D4282A076A83565AFABAE--><AD_TREENODE>
+<!--3478924D8D8D4282A076A83565AFABAE-->  <AD_TREENODE_ID><![CDATA[3478924D8D8D4282A076A83565AFABAE]]></AD_TREENODE_ID>
+<!--3478924D8D8D4282A076A83565AFABAE-->  <AD_TREE_ID><![CDATA[10]]></AD_TREE_ID>
+<!--3478924D8D8D4282A076A83565AFABAE-->  <NODE_ID><![CDATA[FF8080813161A3D3013162164AB10038]]></NODE_ID>
+<!--3478924D8D8D4282A076A83565AFABAE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--3478924D8D8D4282A076A83565AFABAE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--3478924D8D8D4282A076A83565AFABAE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--3478924D8D8D4282A076A83565AFABAE-->  <PARENT_ID><![CDATA[156]]></PARENT_ID>
+<!--3478924D8D8D4282A076A83565AFABAE-->  <SEQNO><![CDATA[160]]></SEQNO>
+<!--3478924D8D8D4282A076A83565AFABAE--></AD_TREENODE>
+
+<!--C6C17508B4344449982EF8BE76D34966--><AD_TREENODE>
+<!--C6C17508B4344449982EF8BE76D34966-->  <AD_TREENODE_ID><![CDATA[C6C17508B4344449982EF8BE76D34966]]></AD_TREENODE_ID>
+<!--C6C17508B4344449982EF8BE76D34966-->  <AD_TREE_ID><![CDATA[10]]></AD_TREE_ID>
+<!--C6C17508B4344449982EF8BE76D34966-->  <NODE_ID><![CDATA[FF8080813151AEE1013151B119D10005]]></NODE_ID>
+<!--C6C17508B4344449982EF8BE76D34966-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C6C17508B4344449982EF8BE76D34966-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C6C17508B4344449982EF8BE76D34966-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C6C17508B4344449982EF8BE76D34966-->  <PARENT_ID><![CDATA[367]]></PARENT_ID>
+<!--C6C17508B4344449982EF8BE76D34966-->  <SEQNO><![CDATA[80]]></SEQNO>
+<!--C6C17508B4344449982EF8BE76D34966--></AD_TREENODE>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_WINDOW.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,18 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF8080813161A3D301316208017A0011--><AD_WINDOW>
+<!--FF8080813161A3D301316208017A0011-->  <AD_WINDOW_ID><![CDATA[FF8080813161A3D301316208017A0011]]></AD_WINDOW_ID>
+<!--FF8080813161A3D301316208017A0011-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080813161A3D301316208017A0011-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF8080813161A3D301316208017A0011-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF8080813161A3D301316208017A0011-->  <NAME><![CDATA[Google Integration Preferences]]></NAME>
+<!--FF8080813161A3D301316208017A0011-->  <DESCRIPTION><![CDATA[Setup preferences for integration with Google APIs]]></DESCRIPTION>
+<!--FF8080813161A3D301316208017A0011-->  <WINDOWTYPE><![CDATA[M]]></WINDOWTYPE>
+<!--FF8080813161A3D301316208017A0011-->  <ISSOTRX><![CDATA[Y]]></ISSOTRX>
+<!--FF8080813161A3D301316208017A0011-->  <PROCESSING><![CDATA[N]]></PROCESSING>
+<!--FF8080813161A3D301316208017A0011-->  <ISDEFAULT><![CDATA[N]]></ISDEFAULT>
+<!--FF8080813161A3D301316208017A0011-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF8080813161A3D301316208017A0011-->  <ISTHREADSAFE><![CDATA[N]]></ISTHREADSAFE>
+<!--FF8080813161A3D301316208017A0011--></AD_WINDOW>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/OBUIAPP_MENU_PARAMETERS.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,27 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF8080813184D10A013184D641230006--><OBUIAPP_MENU_PARAMETERS>
+<!--FF8080813184D10A013184D641230006-->  <OBUIAPP_MENU_PARAMETERS_ID><![CDATA[FF8080813184D10A013184D641230006]]></OBUIAPP_MENU_PARAMETERS_ID>
+<!--FF8080813184D10A013184D641230006-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080813184D10A013184D641230006-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF8080813184D10A013184D641230006-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF8080813184D10A013184D641230006-->  <AD_MENU_ID><![CDATA[FF8080813151AEE1013151B119D10005]]></AD_MENU_ID>
+<!--FF8080813184D10A013184D641230006-->  <NAME><![CDATA[showsItself]]></NAME>
+<!--FF8080813184D10A013184D641230006-->  <DESCRIPTION><![CDATA[showsItSelf]]></DESCRIPTION>
+<!--FF8080813184D10A013184D641230006-->  <PARAMETERVALUE><![CDATA[true]]></PARAMETERVALUE>
+<!--FF8080813184D10A013184D641230006-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF8080813184D10A013184D641230006--></OBUIAPP_MENU_PARAMETERS>
+
+<!--FF8080813184F28A013184F550410009--><OBUIAPP_MENU_PARAMETERS>
+<!--FF8080813184F28A013184F550410009-->  <OBUIAPP_MENU_PARAMETERS_ID><![CDATA[FF8080813184F28A013184F550410009]]></OBUIAPP_MENU_PARAMETERS_ID>
+<!--FF8080813184F28A013184F550410009-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF8080813184F28A013184F550410009-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF8080813184F28A013184F550410009-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF8080813184F28A013184F550410009-->  <AD_MENU_ID><![CDATA[FF8080813151AEE1013151B119D10005]]></AD_MENU_ID>
+<!--FF8080813184F28A013184F550410009-->  <NAME><![CDATA[popup]]></NAME>
+<!--FF8080813184F28A013184F550410009-->  <DESCRIPTION><![CDATA[popup]]></DESCRIPTION>
+<!--FF8080813184F28A013184F550410009-->  <PARAMETERVALUE><![CDATA[true]]></PARAMETERVALUE>
+<!--FF8080813184F28A013184F550410009-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF8080813184F28A013184F550410009--></OBUIAPP_MENU_PARAMETERS>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src-db/database/sourcedata/OBUIAPP_VIEW_IMPL.xml	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,13 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--FF808081314D5BAC01314D64B9920013--><OBUIAPP_VIEW_IMPL>
+<!--FF808081314D5BAC01314D64B9920013-->  <OBUIAPP_VIEW_IMPL_ID><![CDATA[FF808081314D5BAC01314D64B9920013]]></OBUIAPP_VIEW_IMPL_ID>
+<!--FF808081314D5BAC01314D64B9920013-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808081314D5BAC01314D64B9920013-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808081314D5BAC01314D64B9920013-->  <AD_MODULE_ID><![CDATA[FF8080813129ADA401312CA1222A0005]]></AD_MODULE_ID>
+<!--FF808081314D5BAC01314D64B9920013-->  <NAME><![CDATA[OBSEIG_AccountAssociationView]]></NAME>
+<!--FF808081314D5BAC01314D64B9920013-->  <DESCRIPTION><![CDATA[Google Account Association]]></DESCRIPTION>
+<!--FF808081314D5BAC01314D64B9920013-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808081314D5BAC01314D64B9920013--></OBUIAPP_VIEW_IMPL>
+
+</data>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src/org/openbravo/service/integration/google/GoogleAuthServlet.java	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,439 @@
+/*
+ *************************************************************************
+ * The contents of this file are subject to the Openbravo  Public  License
+ * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
+ * Version 1.1  with a permitted attribution clause; you may not  use this
+ * file except in compliance with the License. You  may  obtain  a copy of
+ * the License at http://www.openbravo.com/legal/license.html
+ * Software distributed under the License  is  distributed  on  an "AS IS"
+ * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
+ * License for the specific  language  governing  rights  and  limitations
+ * under the License.
+ * The Original Code is Openbravo ERP.
+ * The Initial Developer of the Original Code is Openbravo SLU
+ * All portions are Copyright (C) 2011 Openbravo SLU
+ * All Rights Reserved.
+ * Contributor(s):  ______________________________________.
+ ************************************************************************
+ */
+package org.openbravo.service.integration.google;
+
+import java.io.IOException;
+import java.io.PrintWriter;
+import java.util.Map;
+
+import javax.servlet.ServletException;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+import javax.servlet.http.HttpSession;
+
+import org.apache.log4j.Logger;
+import org.codehaus.jettison.json.JSONException;
+import org.codehaus.jettison.json.JSONObject;
+import org.openbravo.base.HttpBaseServlet;
+import org.openbravo.base.VariablesBase;
+import org.openbravo.base.exception.OBException;
+import org.openbravo.base.provider.OBProvider;
+import org.openbravo.base.secureApp.VariablesSecureApp;
+import org.openbravo.dal.core.OBContext;
+import org.openbravo.dal.service.OBCriteria;
+import org.openbravo.dal.service.OBDal;
+import org.openbravo.dal.service.OBQuery;
+import org.openbravo.erpCommon.obps.ActivationKey;
+import org.openbravo.erpCommon.security.SessionLogin;
+import org.openbravo.erpCommon.utility.OBError;
+import org.openbravo.erpCommon.utility.OBVersion;
+import org.openbravo.erpCommon.utility.Utility;
+import org.openbravo.model.ad.access.Session;
+import org.openbravo.model.ad.access.User;
+import org.openbravo.model.ad.access.UserRoles;
+import org.openbravo.model.ad.module.Module;
+import org.openbravo.model.ad.system.Client;
+import org.openbravo.model.ad.system.SystemInformation;
+import org.openbravo.service.integration.openid.OBSOIDUserIdentifier;
+import org.openbravo.service.integration.openid.OpenIDManager;
+import org.openbravo.xmlEngine.XmlDocument;
+import org.openid4java.discovery.Identifier;
+
+/**
+ * @author iperdomo
+ */
+public class GoogleAuthServlet extends HttpBaseServlet {
+
+  private static final long serialVersionUID = 1L;
+
+  private static Logger log = Logger.getLogger(GoogleAuthServlet.class);
+
+  @Override
+  protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException,
+      IOException {
+    VariablesBase vars = new VariablesBase(req);
+
+    OBContext.setAdminMode();
+
+    try {
+
+      String lang = OBDal.getInstance().get(Client.class, "0").getLanguage().getLanguage();
+
+      if (!ActivationKey.getInstance().isActive()) {
+        OBError error = new OBError();
+        // messageDB escapes double-quotes
+        error.setTitle(Utility.messageBD(this, "OBSEIG_Activate", lang).replaceAll("&quot;", "\""));
+        error.setMessage("");
+        error.setType("Error");
+        vars.setSessionObject("LoginErrorMsg", error);
+        resp.sendRedirect(strDireccion);
+        return;
+      }
+
+      if ("true".equals(vars.getStringParameter("is_return"))) {
+        processReturn(req, resp);
+      } else {
+        if ("true".equals(vars.getStringParameter("is_association"))) {
+          vars.setSessionValue("is_association", "true");
+        }
+
+        OpenIDManager.getInstance()
+            .authRequest(OpenIDManager.GOOGLE_OPENID_DISCOVER_URL, req, resp);
+      }
+
+    } catch (Exception e) {
+      log4j.error(e.getMessage(), e);
+    } finally {
+      OBContext.restorePreviousMode();
+    }
+
+  }
+
+  private void processReturn(HttpServletRequest req, HttpServletResponse resp)
+      throws ServletException, IOException {
+
+    final String loginPageURL = getServletConfig().getServletContext().getInitParameter(
+        "ServletSinIdentificar");
+
+    final VariablesSecureApp vars = new VariablesSecureApp(req);
+
+    try {
+      OBContext.setAdminMode();
+
+      String lang = OBDal.getInstance().get(Client.class, "0").getLanguage().getLanguage();
+
+      Identifier oid = OpenIDManager.getInstance().getIdentifier(req);
+
+      if ("true".equals(vars.getSessionValue("is_association"))) {
+        vars.removeSessionValue("is_association");
+        OpenIDManager.getInstance().associateAccount(oid, req, resp);
+        vars.setSessionValue("startup-message", Utility.messageBD(this, "OBSEIG_LinkedOK", lang));
+        vars.setSessionValue("startup-message-title", Utility.messageBD(this, "ProcessOK", lang));
+        resp.sendRedirect(strDireccion);
+        return;
+      }
+
+      User user = OpenIDManager.getInstance().getUser(oid);
+
+      if (user == null) {
+        user = createUser(oid, req, resp);
+        if (user == null) {
+          return;
+        }
+      }
+
+      HttpSession session = req.getSession(true);
+      session.setAttribute("#Authenticated_user", null);
+
+      // TODO: Refactor LoginHandler/AuthenticationManager/HttpSecureAppServlet to make this part
+      // of the code extensible with a module
+      // Code copied from LoginHandler
+      String sessionId = createDBSession(req, user.getUsername(), user.getId());
+      session.setAttribute("#Authenticated_user", user.getId());
+      session.setAttribute("#AD_SESSION_ID", sessionId);
+      session.setAttribute("#LOGGINGIN", "Y");
+
+      checkLicenseAndGo(req, resp, vars, user.getId(), sessionId, true);
+
+    } catch (Exception e) {
+      log.error("Error processing return of Google Auth Service:" + e.getMessage(), e);
+      this.getServletContext().getRequestDispatcher(loginPageURL).forward(req, resp);
+    } finally {
+      OBContext.restorePreviousMode();
+    }
+  }
+
+  @SuppressWarnings("unchecked")
+  public User createUser(Identifier oid, HttpServletRequest req, HttpServletResponse resp)
+      throws OBException, IOException {
+    Map<String, String> attributes = (Map<String, String>) req.getAttribute("attributes");
+
+    OBSEIGDefaults newUserDefaults;
+    VariablesBase vars = new VariablesBase(req);
+
+    String lang = OBDal.getInstance().get(Client.class, "0").getLanguage().getLanguage();
+
+    if (attributes.get(OpenIDManager.ATTRIBUTE_FIRSTNAME) == null
+        || attributes.get(OpenIDManager.ATTRIBUTE_LASTNAME) == null
+        || attributes.get(OpenIDManager.ATTRIBUTE_EMAIL) == null) {
+      throw new OBException("Google Integration: OpenID identifier attributes missing");
+    }
+
+    OBCriteria<OBSEIGDefaults> defaults = OBDal.getInstance().createCriteria(OBSEIGDefaults.class);
+    defaults.setFilterOnReadableClients(false);
+    defaults.setFilterOnReadableClients(false);
+
+    if (defaults.count() == 0) {
+      OBError error = new OBError();
+      error.setTitle(Utility.messageBD(this, "OBSEIG_NoDefaultConf", lang).replaceAll("@@email@@",
+          attributes.get(OpenIDManager.ATTRIBUTE_EMAIL)));
+      error.setMessage("");
+      error.setType("Error");
+      vars.setSessionObject("LoginErrorMsg", error);
+      resp.sendRedirect(strDireccion);
+      return null;
+    }
+
+    if (defaults.count() > 1) {
+      OBError error = new OBError();
+      error.setTitle(Utility.messageBD(this, "OBSEIG_TooMuchConf", lang).replaceAll("@@email@@",
+          attributes.get(OpenIDManager.ATTRIBUTE_EMAIL)));
+      error.setMessage("");
+      error.setType("Error");
+      vars.setSessionObject("LoginErrorMsg", error);
+      resp.sendRedirect(strDireccion);
+      return null;
+    }
+
+    newUserDefaults = defaults.list().get(0);
+
+    User newUser = OBProvider.getInstance().get(User.class);
+    final String name = attributes.get(OpenIDManager.ATTRIBUTE_FIRSTNAME) + " "
+        + attributes.get(OpenIDManager.ATTRIBUTE_LASTNAME);
+
+    newUser.setName(name);
+    newUser.setEmail(attributes.get(OpenIDManager.ATTRIBUTE_EMAIL));
+    newUser.setOrganization(newUserDefaults.getRole().getOrganization());
+    newUser.setClient(newUserDefaults.getRole().getClient());
+    newUser.setActive(newUserDefaults.isNewuseractive());
+    newUser.setUsername(name);
+
+    OBDal.getInstance().save(newUser);
+
+    OBSOIDUserIdentifier userIdentifier = OBProvider.getInstance().get(OBSOIDUserIdentifier.class);
+    userIdentifier.setUserContact(newUser);
+    userIdentifier.setClient(newUserDefaults.getRole().getClient());
+    userIdentifier.setOrganization(newUserDefaults.getRole().getOrganization());
+    userIdentifier.setOpenIDIdentifier(oid.toString());
+    userIdentifier.setActive(true);
+
+    OBDal.getInstance().save(userIdentifier);
+
+    UserRoles uRoles = OBProvider.getInstance().get(UserRoles.class);
+    uRoles.setClient(newUserDefaults.getRole().getClient());
+    uRoles.setOrganization(newUserDefaults.getRole().getOrganization());
+    uRoles.setUserContact(newUser);
+    uRoles.setRole(newUserDefaults.getRole());
+
+    OBDal.getInstance().save(uRoles);
+
+    newUser.setDefaultRole(newUserDefaults.getRole());
+
+    OBDal.getInstance().flush();
+
+    return newUser;
+  }
+
+  // All the methods below are a copy and modified from LoginHandler.java
+
+  private String createDBSession(HttpServletRequest req, String strUser, String strUserAuth) {
+    try {
+      String usr = strUserAuth == null ? "0" : strUserAuth;
+
+      final SessionLogin sl = new SessionLogin(req, "0", "0", usr);
+
+      if (strUserAuth == null) {
+        sl.setStatus("F");
+      } else {
+        sl.setStatus("S");
+      }
+
+      sl.setUserName(strUser);
+      sl.setServerUrl(strDireccion);
+      sl.save();
+      return sl.getSessionID();
+    } catch (Exception e) {
+      log4j.error("Error creating DB session", e);
+      return null;
+    }
+  }
+
+  @SuppressWarnings("incomplete-switch")
+  private void checkLicenseAndGo(HttpServletRequest req, HttpServletResponse res,
+      VariablesSecureApp vars, String strUserAuth, String sessionId, boolean doRedirect)
+      throws IOException, ServletException {
+    OBContext.setAdminMode();
+    try {
+      ActivationKey ak = ActivationKey.getInstance();
+      boolean hasSystem = false;
+
+      try {
+        hasSystem = hasSystemRole(strUserAuth);
+      } catch (Exception ignore) {
+        log4j.error(ignore);
+      }
+      String msgType, action;
+      if (hasSystem) {
+        msgType = "Warning";
+        action = "../security/Menu.html";
+      } else {
+        msgType = "Error";
+        action = "../security/Login_FS.html";
+      }
+
+      // We check if there is a Openbravo Professional Subscription restriction in the license,
+      // or if the last rebuild didn't go well. If any of these are true, then the user is
+      // allowed to login only as system administrator
+      switch (ak.checkOPSLimitations(sessionId)) {
+      case NUMBER_OF_CONCURRENT_USERS_REACHED:
+        String msg = Utility.messageBD(myPool, "NUMBER_OF_CONCURRENT_USERS_REACHED",
+            vars.getLanguage());
+        String title = Utility.messageBD(myPool, "NUMBER_OF_CONCURRENT_USERS_REACHED_TITLE",
+            vars.getLanguage());
+        log4j.warn("Concurrent Users Reached - Session: " + sessionId);
+        updateDBSession(sessionId, msgType.equals("Warning"), "CUR");
+        goToRetry(res, vars, msg, title, msgType, action, doRedirect);
+        return;
+      case NUMBER_OF_SOFT_USERS_REACHED:
+        msg = Utility.messageBD(myPool, "NUMBER_OF_SOFT_USERS_REACHED", vars.getLanguage());
+        title = Utility.messageBD(myPool, "NUMBER_OF_SOFT_USERS_REACHED_TITLE", vars.getLanguage());
+        action = "../security/Menu.html";
+        msgType = "Warning";
+        log4j.warn("Soft Users Reached - Session: " + sessionId);
+        updateDBSession(sessionId, true, "SUR");
+        goToRetry(res, vars, msg, title, msgType, action, doRedirect);
+        return;
+      case OPS_INSTANCE_NOT_ACTIVE:
+        msg = Utility.messageBD(myPool, "OPS_INSTANCE_NOT_ACTIVE", vars.getLanguage());
+        title = Utility.messageBD(myPool, "OPS_INSTANCE_NOT_ACTIVE_TITLE", vars.getLanguage());
+        log4j.warn("Innactive OBPS instance - Session: " + sessionId);
+        updateDBSession(sessionId, msgType.equals("Warning"), "IOBPS");
+        goToRetry(res, vars, msg, title, msgType, action, doRedirect);
+        return;
+      case MODULE_EXPIRED:
+        msg = Utility.messageBD(myPool, "OPS_MODULE_EXPIRED", vars.getLanguage());
+        title = Utility.messageBD(myPool, "OPS_MODULE_EXPIRED_TITLE", vars.getLanguage());
+        StringBuffer expiredMoudules = new StringBuffer();
+        log4j.warn("Expired modules - Session: " + sessionId);
+        for (Module module : ak.getExpiredInstalledModules()) {
+          expiredMoudules.append("<br/>").append(module.getName());
+          log4j.warn("  module:" + module.getName());
+        }
+        msg += expiredMoudules.toString();
+        updateDBSession(sessionId, msgType.equals("Warning"), "ME");
+        goToRetry(res, vars, msg, title, msgType, action, doRedirect);
+        return;
+      }
+
+      // Build checks
+      SystemInformation sysInfo = OBDal.getInstance().get(SystemInformation.class, "0");
+      if (sysInfo.getSystemStatus() == null || sysInfo.getSystemStatus().equals("RB70")
+          || this.globalParameters.getOBProperty("safe.mode", "false").equalsIgnoreCase("false")) {
+        // Last build went fine and tomcat was restarted. We should continue with the rest of checks
+      } else if (sysInfo.getSystemStatus().equals("RB60")
+          || sysInfo.getSystemStatus().equals("RB51")) {
+        String msg = Utility.messageBD(myPool, "TOMCAT_NOT_RESTARTED", vars.getLanguage());
+        String title = Utility.messageBD(myPool, "TOMCAT_NOT_RESTARTED_TITLE", vars.getLanguage());
+        log4j.warn("Tomcat not restarted");
+        updateDBSession(sessionId, true, "RT");
+        goToRetry(res, vars, msg, title, "Warning", "../security/Menu.html", doRedirect);
+        return;
+      } else {
+        String msg = Utility.messageBD(myPool, "LAST_BUILD_FAILED", vars.getLanguage());
+        String title = Utility.messageBD(myPool, "LAST_BUILD_FAILED_TITLE", vars.getLanguage());
+        updateDBSession(sessionId, msgType.equals("Warning"), "LBF");
+        goToRetry(res, vars, msg, title, msgType, action, doRedirect);
+        return;
+      }
+
+      // All checks passed successfully, continue logging in
+      res.sendRedirect(strDireccion);
+    } finally {
+      OBContext.restorePreviousMode();
+    }
+  }
+
+  private void updateDBSession(String sessionId, boolean sessionActive, String status) {
+    try {
+      OBContext.setAdminMode();
+      Session session = OBDal.getInstance().get(Session.class, sessionId);
+      session.setSessionActive(sessionActive);
+      session.setLoginStatus(status);
+      OBDal.getInstance().flush();
+    } catch (Exception e) {
+      log4j.error("Error updating session in DB", e);
+    } finally {
+      OBContext.restorePreviousMode();
+    }
+
+  }
+
+  private void goToRetry(HttpServletResponse response, VariablesSecureApp vars, String message,
+      String title, String msgType, String action, boolean doRedirect) throws IOException,
+      ServletException {
+    String msg = (message != null && !message.equals("")) ? message
+        : "Please enter your username and password.";
+
+    if (OBVersion.getInstance().is30() && !doRedirect) {
+      // 3.0 instances show the message in the same login window, return a json object with the info
+      // to print the message
+      try {
+        JSONObject jsonMsg = new JSONObject();
+        jsonMsg.put("showMessage", true);
+        jsonMsg.put("target", "Error".equals(msgType) ? null : action);
+        jsonMsg.put("messageType", msgType);
+        jsonMsg.put("messageTitle", title);
+        jsonMsg.put("messageText", msg);
+
+        response.setContentType("application/json;charset=UTF-8");
+        final PrintWriter out = response.getWriter();
+        out.print(jsonMsg.toString());
+        out.close();
+      } catch (JSONException e) {
+        log4j.error("Error setting login msg", e);
+        throw new ServletException(e);
+      }
+    } else {
+      // 2.50 instances show the message in a new window, print that window
+      String discard[] = { "" };
+
+      if (msgType.equals("Error")) {
+        discard[0] = "continueButton";
+      } else {
+        discard[0] = "backButton";
+      }
+
+      final XmlDocument xmlDocument = xmlEngine.readXmlTemplate(
+          "org/openbravo/base/secureApp/HtmlErrorLogin", discard).createXmlDocument();
+
+      // pass relevant mesasge to show inside the error page
+      xmlDocument.setParameter("theme", vars.getTheme());
+      xmlDocument.setParameter("messageType", msgType);
+      xmlDocument.setParameter("action", action);
+      xmlDocument.setParameter("messageTitle", title);
+      xmlDocument.setParameter("messageMessage", msg.replaceAll("\\\\n", "<br>"));
+
+      response.setContentType("text/html");
+      final PrintWriter out = response.getWriter();
+      out.println(xmlDocument.print());
+      out.close();
+    }
+  }
+
+  private boolean hasSystemRole(String userId) throws Exception {
+    OBQuery<UserRoles> urQuery = OBDal.getInstance().createQuery(UserRoles.class,
+        "userContact.id = :userid and role.userLevel = 'S'");
+    urQuery.setNamedParameter("userid", userId);
+    urQuery.setFilterOnReadableClients(false);
+    urQuery.setFilterOnReadableOrganization(false);
+
+    return urQuery.count() > 0;
+  }
+
+}
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/src/org/openbravo/service/integration/google/GoogleIntegrationComponentProvider.java	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,60 @@
+/*
+ *************************************************************************
+ * The contents of this file are subject to the Openbravo  Public  License
+ * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
+ * Version 1.1  with a permitted attribution clause; you may not  use this
+ * file except in compliance with the License. You  may  obtain  a copy of
+ * the License at http://www.openbravo.com/legal/license.html
+ * Software distributed under the License  is  distributed  on  an "AS IS"
+ * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
+ * License for the specific  language  governing  rights  and  limitations
+ * under the License.
+ * The Original Code is Openbravo ERP.
+ * The Initial Developer of the Original Code is Openbravo SLU
+ * All portions are Copyright (C) 2011 Openbravo SLU
+ * All Rights Reserved.
+ * Contributor(s):  ______________________________________.
+ ************************************************************************
+ */
+package org.openbravo.service.integration.google;
+
+import java.util.ArrayList;
+import java.util.Collections;
+import java.util.List;
+import java.util.Map;
+
+import javax.enterprise.context.ApplicationScoped;
+
+import org.openbravo.client.kernel.BaseComponentProvider;
+import org.openbravo.client.kernel.Component;
+import org.openbravo.client.kernel.ComponentProvider;
+
+/**
+ * @author iperdomo
+ */
+@ApplicationScoped
+@ComponentProvider.Qualifier(GoogleIntegrationComponentProvider.GOOGLE_INTEGRATION_COMPONENT_TYE)
+public class GoogleIntegrationComponentProvider extends BaseComponentProvider {
+  public static final String GOOGLE_INTEGRATION_COMPONENT_TYE = "OBSEIG_GoogleComponentType";
+
+  @Override
+  public Component getComponent(String componentId, Map<String, Object> parameters) {
+    throw new IllegalArgumentException("Component id " + componentId + " not supported.");
+  }
+
+  @Override
+  public List<ComponentResource> getGlobalComponentResources() {
+    final List<ComponentResource> globalResources = new ArrayList<ComponentResource>();
+    globalResources
+        .add(createStaticResource(
+            "web/org.openbravo.service.integration.google/js/obsegi-account-association-view.js",
+            false));
+    return globalResources;
+  }
+
+  @Override
+  public List<String> getTestResources() {
+    return Collections.emptyList();
+  }
+
+}
Binary file modules/org.openbravo.service.integration.google/web/images/google.png has changed
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/org.openbravo.service.integration.google/web/org.openbravo.service.integration.google/js/obsegi-account-association-view.js	Mon Aug 01 19:46:56 2011 +0200
@@ -0,0 +1,64 @@
+/*
+ *************************************************************************
+ * The contents of this file are subject to the Openbravo  Public  License
+ * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
+ * Version 1.1  with a permitted attribution clause; you may not  use this
+ * file except in compliance with the License. You  may  obtain  a copy of
+ * the License at http://www.openbravo.com/legal/license.html
+ * Software distributed under the License  is  distributed  on  an "AS IS"
+ * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
+ * License for the specific  language  governing  rights  and  limitations
+ * under the License.
+ * The Original Code is Openbravo ERP.
+ * The Initial Developer of the Original Code is Openbravo SLU
+ * All portions are Copyright (C) 2011 Openbravo SLU
+ * All Rights Reserved.
+ * Contributor(s):  ______________________________________.
+ ************************************************************************
+ */
+
+isc.defineClass('OBSEIG_AccountAssociationView', isc.Dialog);
+
+isc.OBSEIG_AccountAssociationView.addProperties({
+  showMinimizeButton: false,
+  showMaximizeButton: false,
+  autoSize: true,
+
+  isSameTab: function (viewId, params) {
+    return viewId === 'OBSEIG_AccountAssociationView';
+  },
+
+  getBookMarkParams: function () {
+    var result = {};
+    result.viewId = 'OBSEIG_AccountAssociationView';
+    return result;
+  },
+
+  OK_BUTTON: isc.addProperties({},
+    isc.Dialog.OK, {
+      click: function () {
+        this.topElement.cancelClick();
+        top.location.href= OB.Application.contextUrl + 'org.openbravo.service.integration.google/auth.html?is_association=true';
+    }
+  }),
+
+  initWidget: function (args) {
+    var community = (OB.Application.licenseType === 'C'),
+        label = community ? 'OBSEIG_Activate' : 'OBSEIG_AssociateAccount';
+
+    this.title = args && args.tabTitle ? args.tabTitle : '';
+
+    this.items = isc.Label.create({
+      contents: OB.I18N.getLabel(label),
+      width: '100%'
+    });
+
+    if(community) {
+      this.toolbarButtons = [isc.Dialog.OK];
+    } else {
+      this.toolbarButtons = [this.OK_BUTTON, isc.Dialog.CANCEL];
+    }
+
+    this.Super('initWidget', arguments);
+  }
+});
\ No newline at end of file