startimport 0 / - 2019/01/21 16:19:07.329 - 2019/01/21 16:19:07.329 databasename egs2 database name of the postgres database databaseport 5432 database port databaseschema import database schema databaseserver localhost database server as target for the data inputfile D:\temp\gjBrandingAQUO.csv path and file name of the inputdata password pg password of the database path determined by inputfile tablename determined by inputfile user pg username of the username connection1 ${databaseserver} POSTGRESQL Native ${databasename} ${databaseport} ${user} ${password} FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER ${databaseport} PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N ID_JOB Y ID_JOB CHANNEL_ID Y CHANNEL_ID JOBNAME Y JOBNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER START_JOB_ENTRY N START_JOB_ENTRY CLIENT N CLIENT ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE JOBNAME Y TRANSNAME JOBENTRYNAME Y STEPNAME LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS RESULT Y RESULT NR_RESULT_ROWS Y NR_RESULT_ROWS NR_RESULT_FILES Y NR_RESULT_FILES LOG_FIELD N LOG_FIELD COPY_NR N COPY_NR ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID N getparameters TRANS filename ${Internal.Entry.Current.Directory}\getparameters.ktr N Y N N N N N N Basic N N Y N N N Pentaho local Y N Y 0 96 176 importdata TRANS filename ${Internal.Entry.Current.Directory}\importdata.ktr N N Y N N N N N Basic N N Y N N N Pentaho local Y tablename tablename path path N Y 0 688 176 START SPECIAL Y N N 0 0 60 12 0 1 1 N Y 0 96 48 getfileheader TRANS filename ${Internal.Entry.Current.Directory}\getfileheader.ktr N N Y N N N N N Basic N N Y N N N Pentaho local Y tablename tablename path path N Y 0 320 176 reportcolumns TRANS filename ${Internal.Entry.Current.Directory}\reportcolumns.ktr N N Y N N N N N Basic N N Y N N N Pentaho local Y tablename tablename path path N Y 0 512 176 create_objects SQL F T ${Internal.Entry.Current.Directory}\create_objects.sql T connection1 N Y 0 224 48 getcolumnlist TRANS filename ${Internal.Entry.Current.Directory}\getcolumnlist.ktr N N N N N N N N Basic N N Y N N N Pentaho local Y N Y 0 384 48 report_invalid_data TRANS filename ${Internal.Entry.Current.Directory}\report_invalid_data.ktr N N Y N N N N N Basic N N Y N N N Pentaho local Y tablename tablename path path N Y 0 688 320 getparameters getfileheader 0 0 Y Y N getfileheader reportcolumns 0 0 Y Y N reportcolumns importdata 0 0 Y Y N START create_objects 0 0 Y Y Y create_objects getcolumnlist 0 0 Y Y Y getcolumnlist getparameters 0 0 Y Y Y importdata report_invalid_data 0 0 Y Y N METASTORE.pentaho Default Run Configuration {"namespace":"pentaho","id":"Default Run Configuration","name":"Default Run Configuration","description":"Defines a default run configuration","metaStoreName":null} {"_":"Embedded MetaStore Elements","namespace":"pentaho","type":"Default Run Configuration"} Pentaho local {"children":[{"children":[],"id":"server","value":null},{"children":[],"id":"clustered","value":"N"},{"children":[],"id":"name","value":"Pentaho local"},{"children":[],"id":"description","value":null},{"children":[],"id":"readOnly","value":"Y"},{"children":[],"id":"sendResources","value":"N"},{"children":[],"id":"logRemoteExecutionLocally","value":"N"},{"children":[],"id":"remote","value":"N"},{"children":[],"id":"local","value":"Y"},{"children":[],"id":"showTransformations","value":"N"}],"id":"Pentaho local","value":null,"name":"Pentaho local","owner":null,"ownerPermissionsList":[]}