Invantive EstateThe next items describe how you can export data to Exact Online. The data will be imported via the XML Import of Exact Online.
The processing by a background job detects whether the processing was successful and provides a list of errors in the log, for example as follows:
2010/11/21 20:54:14 - Log Errors.0 -
2010/11/21 20:54:14 - Log Errors.0 - ------------> Linenr 1------------------------------
2010/11/21 20:54:14 - Log Errors.0 - type = 0
2010/11/21 20:54:14 - Log Errors.0 - topicCode = Accounts
2010/11/21 20:54:14 - Log Errors.0 - topicNode = Account
2010/11/21 20:54:14 - Log Errors.0 - topicDataKeyAlt = 1386
2010/11/21 20:54:14 - Log Errors.0 - date = 2010-11-21T20:51:23
2010/11/21 20:54:14 - Log Errors.0 - description = Component [Account] Een Nederlands BTW-nummer bestaat uit 14 tekens
2010/11/21 20:54:14 - Log Errors.0 - typeDescription = Error
2010/11/21 20:54:14 - Log Errors.0 -
2010/11/21 20:54:14 - Log Errors.0 - ====================
2010/11/21 20:54:14 - Log Errors.0 -
2010/11/21 20:54:14 - Log Errors.0 - ------------> Linenr 2------------------------------
2010/11/21 20:54:14 - Log Errors.0 - type = 0
2010/11/21 20:54:14 - Log Errors.0 - topicCode = Accounts
2010/11/21 20:54:14 - Log Errors.0 - topicNode = Contact
2010/11/21 20:54:14 - Log Errors.0 - topicDataKeyAlt = 5
2010/11/21 20:54:14 - Log Errors.0 - date = 2010-11-21T20:51:23
2010/11/21 20:54:14 - Log Errors.0 - description = Contact number already exists in account: 103
2010/11/21 20:54:14 - Log Errors.0 - typeDescription = Error
2010/11/21 20:54:14 - Log Errors.0 -
2010/11/21 20:54:14 - Log Errors.0 - ====================
After import of the data, you can find any error, via the menu ‘Import XML’ and then ‘Log’.
Search for ‘Error’ and ‘Warning’. By selecting the XML button, you can view the data which could not be processed:
In the log of the background job are more details about the process (note the bold and italics used for explanation):
21-10-2010 18:32:24 ETL: Script output: running ETL transformation or job.
*** Het programma is gestart om 18:32 op 21 oktober.
21-10-2010 18:32:24 ETL: Configure logger.
21-10-2010 18:32:24 ETL: Configure logger to use console.
21-10-2010 18:32:24 ETL: Init steploader.
21-10-2010 18:32:24 ETL: Load natives.
21-10-2010 18:32:26 ETL: Load plugins.
21-10-2010 18:32:26 ETL: Initialize environment.
21-10-2010 18:32:26 ETL: Init job entry loader.
21-10-2010 18:32:26 ETL: Start timer.
21-10-2010 18:32:26 ETL: determination fully qualified location of the ETL file ../etl/bubs2exactonline organisations.kjb.
*** Het ETL bestand '../etl/bubs2exactonline organisations.kjb' wordt uitgevoerd.
21-10-2010 18:32:26 ETL: PL/SQL function to determine name hard coded location for ETL file is xxinvantive_get_report_loc.
21-10-2010 18:32:26 ETL: File ../etl/bubs2exactonline organisations.kjb will be loaded from /opt/prd/estate/qbubs/web/../etl/bubs2exactonline organisations.kjb using an unpacked war.
*** Na hulp van een database functie is de uiteindelijke bestandslocatie van het ETL bestand '/opt/prd/estate/qbubs/web/../etl/bubs2exactonline organisations.kjb' wordt uitgevoerd.
21-10-2010 18:32:26 ETL: File /opt/prd/estate/qbubs/web/../etl/bubs2exactonline organisations.kjb is a Kettle Job.
*** ETL scripts kunnen zowel Transformatie (*.ktr) als Job (*.kjb) zijn. Dit is een job.
21-10-2010 18:32:26 ETL: Set ETL variable BUBS_DB_SERVER to localhost.
*** De gegevens van de huidige database verbinding wordt via de omgevingsvariabelen BUBS_DB_SERVER, BUBS_DB_PORT, BUBS_DB_NAME, BUBS_DB_USER en BUBS_DB_PASSWORD doorgegeven.
21-10-2010 18:32:26 ETL: Set ETL variable BUBS_DB_PORT to 1521.
21-10-2010 18:32:26 ETL: Set ETL variable BUBS_DB_NAME to PRD11R1.
21-10-2010 18:32:26 ETL: Set ETL variable BUBS_DB_USER to qbubs_web.
21-10-2010 18:32:27 ETL: Instantiate job.
21-10-2010 18:32:27 ETL: Set internal ETL variables.
21-10-2010 18:32:27 ETL: Copy background job parameters to ETL job parameters.
21-10-2010 18:32:27 ETL: Defined variables:
BUBS_DB_NAME, BUBS_DB_PASSWORD, BUBS_DB_PORT, BUBS_DB_SERVER, BUBS_DB_USER, Internal.Cluster.Size, Internal.Job.Filename.Directory, Internal.Job.Filename.Name, Internal.Job.Name, Internal.Kettle.Build.Date, Internal.Kettle.Build.Version, Internal.Kettle.Version, Internal.Slave.Server.Name, Internal.Slave.Transformation.Number, Internal.Step.CopyNr, Internal.Step.Name, Internal.Step.Partition.ID, Internal.Step.Partition.Number, Internal.Step.Unique.Count, Internal.Step.Unique.Number, catalina.base, catalina.home, catalina.useNaming, com.sun.management.jmxremote, common.loader, file.encoding, file.encoding.pkg, file.separator, java.awt.graphicsenv, java.awt.headless, java.awt.printerjob, java.class.path, java.class.version, java.endorsed.dirs, java.ext.dirs, java.home, java.io.tmpdir, java.library.path, java.naming.factory.initial, java.naming.factory.url.pkgs, java.rmi.server.randomIDs, java.runtime.name, java.runtime.version, java.specification.name, java.specification.vendor, java.specification.version, java.util.logging.config.file, java.util.logging.manager, java.vendor, java.vendor.url, java.vendor.url.bug, java.version, java.vm.info, java.vm.name, java.vm.specification.name, java.vm.specification.vendor, java.vm.specification.version, java.vm.vendor, java.vm.version, line.separator, os.arch, os.name, os.version, package.access, package.definition, path.separator, server.loader, shared.loader, sun.arch.data.model, sun.boot.class.path, sun.boot.library.path, sun.cpu.endian, sun.cpu.isalist, sun.io.unicode.encoding, sun.java.launcher, sun.jnu.encoding, sun.management.compiler, sun.os.patch.level, tomcat.util.buf.StringCache.byte.enabled, user.country, user.dir, user.home, user.language, user.name, user.timezone
*** Dit zijn de variabelen die binnen de ETL job bekend zijn.
21-10-2010 18:32:27 ETL: Execute job.
21-10-2010 18:37:26 ETL: Wait until job finished.
21-10-2010 18:37:26 ETL: Ended processing.
21-10-2010 18:37:26 ETL: Determine number of errors.
21-10-2010 18:37:26 ETL: Determine runtime.
21-10-2010 18:37:26 ETL: 299 seconds runtime.
ETL: No errors occurred.
*** Hieronder volgt de uitvoer van de ETL job.
2010/10/21 18:32:27 - bubs2exactonline organisations.kjb - Starting entry [bubs configuration load]
2010/10/21 18:32:27 - bubs configuration load - Loading transformation from XML file [file:///opt/prd/estate/qbubs/etl/bubs configuration load.ktr]
2010/10/21 18:32:27 - bubs configuration load - Dispatching started for transformation [bubs configuration load]
2010/10/21 18:32:27 - bubs configuration load - This transformation can be replayed with replay date: 2010/10/21 18:32:27
2010/10/21 18:32:27 - Get interface profile options.0 - Finished reading query, closing connection.
2010/10/21 18:32:27 - Get interface profile options.0 - Finished processing (I=53, O=0, R=0, W=53, U=0, E=0)
2010/10/21 18:32:27 - Set Variables.0 - Setting environment variables...
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-INTERFACE-BUBS-DIRECTORY-INPUT to value [/opt/prd/estate/qbubs/transfer/bubs/in]
*** In het begin worden profieloptiewaardes ingelezen in variabelen.
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-INTERFACE-BUBS-DIRECTORY-INPUT-PROCESSED to value [/opt/prd/estate/qbubs/transfer/bubs/in/processed]
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-INTERFACE-BUBS-DIRECTORY-INPUT-REJECTED to value [/opt/prd/estate/qbubs/transfer/bubs/in/rejected]
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-INTERFACE-BUBS-DIRECTORY-OUTPUT to value [/opt/prd/estate/qbubs/transfer/bubs/out]
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-INTERFACE-BUBS-DIRECTORY-OUTPUT-PROCESSED to value [/opt/prd/estate/qbubs/transfer/bubs/out/processed]
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-INTERFACE-BUBS-DIRECTORY-OUTPUT-REJECTED to value [/opt/prd/estate/qbubs/transfer/bubs/out/rejected]
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-RUNTIME-TRANSFORMATION-DIR-SIMPLE to value [/opt/prd/estate/qbubs/etl]
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-INTERFACE-EXACTONLINE-DIRECTORY-INPUT to value [/opt/prd/estate/qbubs/transfer/exactonline/in]
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-INTERFACE-EXACTONLINE-GEBRUIKER to value [invantive1]
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-INTERFACE-EXACTONLINE-WACHTWOORD to value [appelfl1p]
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-INTERFACE-EXACTONLINE-URL-DOWNLOAD to value [https://start.exactonline.nl/docs/XMLDownload.aspx]
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-INTERFACE-EXACTONLINE-URL-UPLOAD to value [https://start.exactonline.nl/docs/XMLUpload.aspx]
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-INTERFACE-MULTIVERS-DIRECTORY-INPUT to value []
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-INTERFACE-MULTIVERS-DIRECTORY-INPUT-PROCESSED to value []
...
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-SITE-ID to value [Invantive BV-ws35-prd11r1-QBUBS-Invantive Vision-$URL: http://subversion.invantive.com:81/repos/p104/trunk/fixes/b40_mp-005/ddl/b40_mp-005.sql $ $Rev: 6923 $]
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-START-TIJD-WS to value [2010-10-21T18:32:27]
2010/10/21 18:32:27 - Set Variables.0 - Set variable BUBS-LICENTIE-NAAM-PRODUCT to value [Invantive Vision]
2010/10/21 18:32:27 - Row denormaliser.0 - Finished processing (I=0, O=0, R=53, W=1, U=0, E=0)
2010/10/21 18:32:27 - Set Variables.0 - Finished after 1 rows.
2010/10/21 18:32:27 - Set Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2010/10/21 18:32:28 - bubs2exactonline organisations.kjb - Starting entry [Delete old Accounts files]
2010/10/21 18:32:28 - bubs2exactonline organisations.kjb - Starting entry [bubs2exactonline organisations extract]
2010/10/21 18:32:28 - bubs2exactonline organisations extract - Loading transformation from XML file [file:///opt/prd/estate/qbubs/etl/bubs2exactonline organisations extract.ktr]
2010/10/21 18:32:28 - bubs2exactonline organisations extract - Dispatching started for transformation [bubs2exactonline organisations extract]
2010/10/21 18:32:28 - bubs2exactonline organisations extract - This transformation can be replayed with replay date: 2010/10/21 18:32:28
2010/10/21 18:32:28 - XML Join.0 - Starting to run...
2010/10/21 18:32:28 - Load organisations container.0 - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
2010/10/21 18:32:28 - xmlorganisations.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
*** Regelmatig zie je statistieken (I=input, O=output, R=gelezen, W=geschreven, E=foutmeldingen).
...
2010/10/21 18:37:26 - bubs2exactonline organisations.kjb - Starting entry [Success]
2010/10/21 18:37:26 - bubs2exactonline organisations.kjb - Finished job entry [Success] (result=[true])
2010/10/21 18:37:26 - bubs2exactonline organisations.kjb - Finished job entry [bubs2exactonline webservice put] (result=[true])
2010/10/21 18:37:26 - bubs2exactonline organisations.kjb - Finished job entry [bubs2exactonline organisations generate topic Accounts] (result=[true])
2010/10/21 18:37:26 - bubs2exactonline organisations.kjb - Finished job entry [bubs2exactonline organisations extract] (result=[true])
2010/10/21 18:37:26 - bubs2exactonline organisations.kjb - Finished job entry [Delete old Accounts files] (result=[true])
2010/10/21 18:37:26 - bubs2exactonline organisations.kjb - Finished job entry [bubs configuration load] (result=[true])
*** Einde van de uitvoer van de ETL job.
21-10-2010 18:37:26 ETL: ETL Script finished.
