Innosoft GeoCoder 2.3 Oracle (Innosoft.CRM.Core 1.11 master - 27.04.2023)

  1. Version is located in its own branch: feature/oracle_geocoder ()

  2. Database preparation for 1.11

    ALTER TABLE PWUSER ADD EXTERNALUSERID NVARCHAR2 (50) NULL;
    ALTER TABLE PWUSER ADD FORGOTPASSWORD_GUID NVARCHAR2 (50) NULL;
    ALTER TABLE PWUSER ADD FORGOTPASSWORD_UTC DATE NULL;
    ALTER TABLE PWUSER ADD CLAIMS CLOB NULL;
    ALTER TABLE PWUSER ADD SECURITYSTAMP CLOB NULL;
     
    ALTER TABLE LOG ADD ID VARCHAR2 (80) NULL;
     
    ALTER TABLE VKUNZUS ADD GEOCODERINFOS VARCHAR2 (255) NULL;
    ALTER TABLE VKUNZUS ADD GOOGLEMAPSCHANGEDATE DATE NULL;
    ALTER TABLE VKUNZUS ADD USE_ADR_LOCATION NUMBER(9) NULL;
     
    ALTER TABLE RESSLIST ADD USE_RES_LOCATION NUMBER(9) NULL;
     
    ALTER TABLE MAPARK ADD GOOGLEMAPSCHANGEDATE DATE NULL;
    ALTER TABLE MAPARK ADD USE_MASCH_LOCATION NUMBER(1) NULL;
    ALTER TABLE MAPARK ADD ADVANCED_LOCATION NVARCHAR2 (2000) NULL;
    ALTER TABLE MAPARK ADD USE_ADVANCED_LOCATION NUMBER(1) NULL;
     
    CREATE TABLE GEODATA2
    (
    ID NVARCHAR2 (50) NOT NULL,
    STREET NVARCHAR2 (255) NULL,
    CITY NVARCHAR2 (255) NULL,
    POSTCODE NVARCHAR2 (255) NULL,
    COUNTRYCODE NVARCHAR2 (10) NULL,
    REQUESTSTRING NVARCHAR2 (2000) NULL,
    REQUESTUTC DATE NULL,
    RESPONSEDISPLAYNAME NVARCHAR2 (2000) NULL,
    RESPONSEERRORCODE NUMBER(9) NULL,
    RESPONSEMESSAGE NVARCHAR2 (2000) NULL,
    NEXTREQUESTUTC DATE NULL,
    SERVICEID NVARCHAR2 (20) NULL,
    LAT FLOAT NULL,
    "LONG" FLOAT NULL,
    PRIMARY KEY (ID
    ));

  3. innoconfig.xml configuration (example for database)

    <mappingAssemblies>
    <mappingAssembly>Innosoft.CRM.Core</mappingAssembly>
    </mappingAssemblies>
    <database>
    <mandant>
    <name>ORACLE</name>
    <type use2005Dialect="0">ORACLE</type>
    <connectionstring>>Provider=OraOLEDB.Oracle.1;data source=ora193/ORA193UNI;user id=user_id;persist security info=true;password=password;</connectionstring>
    <maxrows>1000</maxrows>
    <initializeindividualobjectsonstartup>0</initializeindividualobjectsonstartup>
    <loadtabledescriptions>0</loadtabledescriptions>
    <loadnhibernatemappingsfrominnosoftbase>1</loadnhibernatemappingsfrominnosoftbase>
    <maxrows>1000</maxrows>
    <trimspaces>1</trimspaces>
    <formatSql>1</formatSql>
    <overrideBatcher>0</overrideBatcher>
    <batchSize>20</batchSize>
    </mandant>
    </database>

  4. Restrictions

    • No individual data is loaded

    • LOG table is not extended

    • Table structures are not loaded, therefore no checks/validation automatically possible