Java Code Examples for org.pentaho.di.core.Const#NVL

The following examples show how to use org.pentaho.di.core.Const#NVL . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: RepositoryImporterExtension.java From pentaho-kettle with Apache License 2.0

6 votes

String resolvePath( String rootPath, String entryPath, boolean check ) {
  boolean needToCheckPathForVariables = check;
  String extraPath = Const.NVL( entryPath, "/" );
  if ( needToCheckPathForVariables ) {
    if ( containsVariables( entryPath ) ) {
      return extraPath;
    }
  }
  String newPath = Const.NVL( rootPath, "/" );
  if ( newPath.endsWith( "/" ) && extraPath.startsWith( "/" ) ) {
    newPath = newPath.substring( 0, newPath.length() - 1 );
  } else if ( !newPath.endsWith( "/" ) && !extraPath.startsWith( "/" ) ) {
    newPath += "/";
  } else if ( extraPath.equals( "/" ) ) {
    extraPath = "";
  }
  return newPath + extraPath;
}

Example 2

Source File: ChangeFileEncodingDialog.java From pentaho-kettle with Apache License 2.0

6 votes

private void setEncodings( ComboVar var ) {
  // Encoding of the text file:
  String encoding = Const.NVL( var.getText(), Const.getEnvironmentVariable( "file.encoding", "UTF-8" ) );
  var.removeAll();
  ArrayList<Charset> values = new ArrayList<Charset>( Charset.availableCharsets().values() );
  for ( int i = 0; i < values.size(); i++ ) {
    Charset charSet = values.get( i );
    var.add( charSet.displayName() );
  }

  // Now select the default!
  int idx = Const.indexOfString( encoding, var.getItems() );
  if ( idx >= 0 ) {
    var.select( idx );
  }
}

Example 3

Source File: JobEntryWaitForSQL.java From pentaho-kettle with Apache License 2.0

6 votes

@Override
public void loadXML( Node entrynode, List<DatabaseMeta> databases, List<SlaveServer> slaveServers,
  Repository rep, IMetaStore metaStore ) throws KettleXMLException {
  try {
    super.loadXML( entrynode, databases, slaveServers );
    String dbname = XMLHandler.getTagValue( entrynode, "connection" );
    connection = DatabaseMeta.findDatabase( databases, dbname );
    schemaname = XMLHandler.getTagValue( entrynode, "schemaname" );
    tablename = XMLHandler.getTagValue( entrynode, "tablename" );
    successCondition =
      getSucessConditionByCode( Const.NVL( XMLHandler.getTagValue( entrynode, "success_condition" ), "" ) );
    rowsCountValue = Const.NVL( XMLHandler.getTagValue( entrynode, "rows_count_value" ), "0" );
    iscustomSQL = "Y".equalsIgnoreCase( XMLHandler.getTagValue( entrynode, "is_custom_sql" ) );
    isUseVars = "Y".equalsIgnoreCase( XMLHandler.getTagValue( entrynode, "is_usevars" ) );
    customSQL = XMLHandler.getTagValue( entrynode, "custom_sql" );
    isAddRowsResult = "Y".equalsIgnoreCase( XMLHandler.getTagValue( entrynode, "add_rows_result" ) );
    maximumTimeout = XMLHandler.getTagValue( entrynode, "maximum_timeout" );
    checkCycleTime = XMLHandler.getTagValue( entrynode, "check_cycle_time" );
    successOnTimeout = "Y".equalsIgnoreCase( XMLHandler.getTagValue( entrynode, "success_on_timeout" ) );
    isClearResultList = "Y".equalsIgnoreCase( XMLHandler.getTagValue( entrynode, "clear_result_rows" ) );

  } catch ( KettleException e ) {
    throw new KettleXMLException( BaseMessages.getString( PKG, "JobEntryWaitForSQL.UnableLoadXML" ), e );
  }
}

Example 4

Source File: JobEntryHTTPTest.java From pentaho-kettle with Apache License 2.0

5 votes

@BeforeClass
public static void beforeClass() throws KettleException {
  PluginRegistry.addPluginType( TwoWayPasswordEncoderPluginType.getInstance() );
  PluginRegistry.init();
  String passwordEncoderPluginID =
      Const.NVL( EnvUtil.getSystemProperty( Const.KETTLE_PASSWORD_ENCODER_PLUGIN ), "Kettle" );
  Encr.init( passwordEncoderPluginID );
}

Example 5

Source File: SimpleMappingDialog.java From pentaho-kettle with Apache License 2.0

5 votes

/**
 * Copy information from the meta-data input to the dialog fields.
 */
public void getData() {
  setSpecificationMethod( mappingMeta.getSpecificationMethod() );
  switch ( getSpecificationMethod() ) {
    case FILENAME:
      wPath.setText( Const.NVL( mappingMeta.getFileName(), "" ) );
      break;
    case REPOSITORY_BY_NAME:
      String fullPath = Const.NVL( mappingMeta.getDirectoryPath(), "" ) + "/" + Const
        .NVL( mappingMeta.getTransName(), "" );
      wPath.setText( fullPath );
      break;
    case REPOSITORY_BY_REFERENCE:
      referenceObjectId = mappingMeta.getTransObjectId();
      getByReferenceData( referenceObjectId );
      break;
    default:
      break;
  }

  addParametersTab( mappingParameters );
  wTabFolder.setSelection( 0 );

  addInputMappingDefinitionTab( inputMapping, 0 );
  addOutputMappingDefinitionTab( outputMapping, 1 );

  try {
    loadTransformation();
  } catch ( Throwable t ) {
    // Ignore errors
  }

  wStepname.selectAll();
  wStepname.setFocus();
}

Example 6

Source File: SlaveServerTest.java From pentaho-kettle with Apache License 2.0

5 votes

@BeforeClass
public static void beforeClass() throws KettleException {
  PluginRegistry.addPluginType( TwoWayPasswordEncoderPluginType.getInstance() );
  PluginRegistry.init();
  String passwordEncoderPluginID =
      Const.NVL( EnvUtil.getSystemProperty( Const.KETTLE_PASSWORD_ENCODER_PLUGIN ), "Kettle" );
  Encr.init( passwordEncoderPluginID );
}

Example 7

Source File: StringOperationsMeta.java From pentaho-kettle with Apache License 2.0

5 votes

private void readData( Node stepnode ) throws KettleXMLException {
  try {
    int nrkeys;

    Node lookup = XMLHandler.getSubNode( stepnode, "fields" );
    nrkeys = XMLHandler.countNodes( lookup, "field" );

    allocate( nrkeys );

    for ( int i = 0; i < nrkeys; i++ ) {
      Node fnode = XMLHandler.getSubNodeByNr( lookup, "field", i );

      fieldInStream[i] = Const.NVL( XMLHandler.getTagValue( fnode, "in_stream_name" ), "" );
      fieldOutStream[i] = Const.NVL( XMLHandler.getTagValue( fnode, "out_stream_name" ), "" );

      trimType[i] = Const.NVL( XMLHandler.getTagValue( fnode, "trim_type" ), "" );
      lowerUpper[i] = Const.NVL( XMLHandler.getTagValue( fnode, "lower_upper" ), "" );
      padding_type[i] = Const.NVL( XMLHandler.getTagValue( fnode, "padding_type" ), "" );
      padChar[i] = Const.NVL( XMLHandler.getTagValue( fnode, "pad_char" ), "" );
      padLen[i] = Const.NVL( XMLHandler.getTagValue( fnode, "pad_len" ), "" );
      initCap[i] = Const.NVL( XMLHandler.getTagValue( fnode, "init_cap" ), "" );
      maskXML[i] = Const.NVL( XMLHandler.getTagValue( fnode, "mask_xml" ), "" );
      digits[i] = Const.NVL( XMLHandler.getTagValue( fnode, "digits" ), "" );
      remove_special_characters[i] = Const.NVL( XMLHandler.getTagValue( fnode, "remove_special_characters" ), "" );

    }
  } catch ( Exception e ) {
    throw new KettleXMLException( BaseMessages.getString(
      PKG, "StringOperationsMeta.Exception.UnableToReadStepInfoFromXML" ), e );
  }
}

Example 8

Source File: MetaInjectDialog.java From pentaho-kettle with Apache License 2.0

5 votes

private void getByReferenceData( RepositoryElementMetaInterface transInf  ) {
  String path =
    DialogUtils.getPath( transMeta.getRepositoryDirectory().getPath(), transInf.getRepositoryDirectory().getPath() );
  String fullPath =
    Const.NVL( path, "" ) + "/" + Const.NVL( transInf.getName(), "" );
  wPath.setText( fullPath );
}

Example 9

Source File: SparkRunConfigurationExecutor.java From pentaho-kettle with Apache License 2.0

5 votes

/**
 * Installs the aries-rsa-discovery-zookeeper feature if not installed and sets the host and port for zookeeper.
 * Sets the appropriate variables on the transMeta for the spark engine
 *
 * @param runConfiguration The configuration for running on Spark
 * @param configuration    The configuration for executing a transformation
 * @param meta             Unused in this implementation
 * @param variableSpace    The variableSpace used to set the engine runtime values
 */
@Override public void execute( RunConfiguration runConfiguration, ExecutionConfiguration configuration,
                               AbstractMeta meta, VariableSpace variableSpace, Repository repository ) {

  // Check to see if the ael-security feature is installed. If it is, then install the jaas capability if it is
  // not already installed
  ICapability securityCapability = capabilityManager.getCapabilityById( AEL_SECURITY_CAPABILITY_ID );
  ICapability jaasCapability = capabilityManager.getCapabilityById( JAAS_CAPABILITY_ID );
  if ( securityCapability != null && securityCapability.isInstalled() ) {
    if ( jaasCapability != null && !jaasCapability.isInstalled() ) {
      jaasCapability.install();
    }
  }

  SparkRunConfiguration sparkRunConfiguration = (SparkRunConfiguration) runConfiguration;

  String runConfigSchema = Const.NVL( sparkRunConfiguration.getSchema(), "" );
  String runConfigURL = Const.NVL( sparkRunConfiguration.getUrl(), "" );


  // Variables for Websocket spark engine version
  String engineScheme = Const.NVL( runConfigSchema, DEFAULT_SCHEMA ).trim();
  String engineUrl = Const.NVL( runConfigURL, DEFAULT_URL ).trim();

  variableSpace.setVariable( "engine.scheme", engineScheme );
  variableSpace.setVariable( "engine.url", engineUrl );

  // Sets the appropriate variables on the transformation for the spark engine
  variableSpace.setVariable( "engine", "remote" );
  variableSpace.setVariable( "engine.remote", "spark" );
}

Example 10

Source File: SalesforceConnectionIT.java From pentaho-kettle with Apache License 2.0

5 votes

@BeforeClass
public static void setUpClass() throws KettleException {
  PluginRegistry.addPluginType( TwoWayPasswordEncoderPluginType.getInstance() );
  PluginRegistry.init();
  String passwordEncoderPluginID =
      Const.NVL( EnvUtil.getSystemProperty( Const.KETTLE_PASSWORD_ENCODER_PLUGIN ), "Kettle" );
  Encr.init( passwordEncoderPluginID );
}

Example 11

Source File: SalesforceDeleteMetaTest.java From pentaho-kettle with Apache License 2.0

5 votes

@BeforeClass
public static void setUpBeforeClass() throws KettleException {
  PluginRegistry.addPluginType( ValueMetaPluginType.getInstance() );
  PluginRegistry.addPluginType( TwoWayPasswordEncoderPluginType.getInstance() );
  PluginRegistry.init( true );
  String passwordEncoderPluginID =
    Const.NVL( EnvUtil.getSystemProperty( Const.KETTLE_PASSWORD_ENCODER_PLUGIN ), "Kettle" );
  Encr.init( passwordEncoderPluginID );
}

Example 12

Source File: TableOutputDialog.java From pentaho-kettle with Apache License 2.0

5 votes

private void getInfo( TableOutputMeta info ) {
  info.setSchemaName( wSchema.getText() );
  info.setTableName( wTable.getText() );
  info.setDatabaseMeta( transMeta.findDatabase( wConnection.getText() ) );
  info.setCommitSize( wCommit.getText() );
  info.setTruncateTable( wTruncate.getSelection() );
  info.setIgnoreErrors( wIgnore.getSelection() );
  info.setUseBatchUpdate( wBatch.getSelection() );
  info.setPartitioningEnabled( wUsePart.getSelection() );
  info.setPartitioningField( wPartField.getText() );
  info.setPartitioningDaily( wPartDaily.getSelection() );
  info.setPartitioningMonthly( wPartMonthly.getSelection() );
  info.setTableNameInField( wNameInField.getSelection() );
  info.setTableNameField( wNameField.getText() );
  info.setTableNameInTable( wNameInTable.getSelection() );
  info.setReturningGeneratedKeys( wReturnKeys.getSelection() );
  info.setGeneratedKeyField( wReturnField.getText() );
  info.setSpecifyFields( wSpecifyFields.getSelection() );

  int nrRows = wFields.nrNonEmpty();
  info.allocate( nrRows );
  //CHECKSTYLE:Indentation:OFF
  for ( int i = 0; i < nrRows; i++ ) {
    TableItem item = wFields.getNonEmpty( i );
    info.getFieldDatabase()[i] = Const.NVL( item.getText( 1 ), "" );
    info.getFieldStream()[i] = Const.NVL( item.getText( 2 ), "" );
  }
}

Example 13

Source File: SalesforceUpdateMetaTest.java From pentaho-kettle with Apache License 2.0

5 votes

@BeforeClass
public static void setUpBeforeClass() throws KettleException {
  PluginRegistry.addPluginType( ValueMetaPluginType.getInstance() );
  PluginRegistry.addPluginType( TwoWayPasswordEncoderPluginType.getInstance() );
  PluginRegistry.init( true );
  String passwordEncoderPluginID =
    Const.NVL( EnvUtil.getSystemProperty( Const.KETTLE_PASSWORD_ENCODER_PLUGIN ), "Kettle" );
  Encr.init( passwordEncoderPluginID );
}

Example 14

Source File: SalesforceConnectionTest.java From pentaho-kettle with Apache License 2.0

5 votes

@BeforeClass
public static void setUpClass() throws KettleException {
  PluginRegistry.addPluginType( TwoWayPasswordEncoderPluginType.getInstance() );
  PluginRegistry.init();
  String passwordEncoderPluginID = Const.NVL( EnvUtil.getSystemProperty( Const.KETTLE_PASSWORD_ENCODER_PLUGIN ), "Kettle" );
  Encr.init( passwordEncoderPluginID );
}

Example 15

Source File: KettleFileTableModel.java From pentaho-kettle with Apache License 2.0

5 votes

public static String getModification( ReportSubjectLocation filename ) throws KettleException {
  Date date = null;
  String user = null;
  if ( filename.isTransformation() ) {
    date = TransformationInformation.getInstance().getTransMeta( filename ).getModifiedDate();
    user = TransformationInformation.getInstance().getTransMeta( filename ).getModifiedUser();
  } else {
    date = JobInformation.getInstance().getJobMeta( filename ).getModifiedDate();
    user = JobInformation.getInstance().getJobMeta( filename ).getModifiedUser();
  }
  return Const.NVL( XMLHandler.date2string( date ), "-" ) + " by " + Const.NVL( user, "-" );
}

Example 16

Source File: CypherMeta.java From knowbi-pentaho-pdi-neo4j-output with Apache License 2.0

5 votes

@Override public void getFields( RowMetaInterface rowMeta, String name, RowMetaInterface[] info, StepMeta nextStep, VariableSpace space,
                                 Repository repository, IMetaStore metaStore ) throws KettleStepException {

  if ( usingUnwind ) {
    // Unwind only outputs results, not input
    //
    rowMeta.clear();
  }

  if (returningGraph) {
    // We send out a single Graph value per input row
    //
    ValueMetaInterface valueMetaGraph = new ValueMetaGraph( Const.NVL(returnGraphField, "graph") );
    valueMetaGraph.setOrigin( name );
    rowMeta.addValueMeta( valueMetaGraph );
  } else {
    // Check return values in the metadata...
    //
    for ( ReturnValue returnValue : returnValues ) {
      try {
        int type = ValueMetaFactory.getIdForValueMeta( returnValue.getType() );
        ValueMetaInterface valueMeta = ValueMetaFactory.createValueMeta( returnValue.getName(), type );
        valueMeta.setOrigin( name );
        rowMeta.addValueMeta( valueMeta );
      } catch ( KettlePluginException e ) {
        throw new KettleStepException( "Unknown data type '" + returnValue.getType() + "' for value named '" + returnValue.getName() + "'" );
      }
    }
  }
}

Example 17

Source File: DrawGoldenDataSetOnStepExtensionPoint.java From pentaho-pdi-dataset with Apache License 2.0

4 votes

protected void drawGoldenSetMarker( TransPainterExtension ext, StepMeta stepMeta, TransUnitTest unitTest, List<AreaOwner> areaOwners ) {

    TransUnitTestSetLocation location = unitTest.findGoldenLocation( stepMeta.getName() );
    if ( location == null ) {
      return;
    }
    String dataSetName = Const.NVL( location.getDataSetName(), "" );

    // Now we're here, draw a marker and indicate the name of the unit test
    //
    GCInterface gc = ext.gc;
    int iconsize = ext.iconsize;
    int x = ext.x1;
    int y = ext.y1;

    gc.setLineWidth( stepMeta.isSelected() ? 2 : 1 );
    gc.setForeground( EColor.CRYSTAL );
    gc.setBackground( EColor.LIGHTGRAY );
    gc.setFont( EFont.GRAPH );
    Point textExtent = gc.textExtent( dataSetName );
    textExtent.x += 6; // add a tiny bit of a margin
    textExtent.y += 6;

    // Draw it at the right hand side
    //
    int arrowSize = textExtent.y;
    Point point = new Point( x + iconsize, y + ( iconsize - textExtent.y ) / 2 );

    int[] arrow = new int[] {
      point.x, point.y + textExtent.y / 2,
      point.x + arrowSize, point.y,
      point.x + textExtent.x + arrowSize, point.y,
      point.x + textExtent.x + arrowSize, point.y + textExtent.y,
      point.x + arrowSize, point.y + textExtent.y,
    };

    gc.fillPolygon( arrow );
    gc.drawPolygon( arrow );
    gc.drawText( dataSetName, point.x + arrowSize + 3, point.y + 3 );

    // Leave a trace of what we drew, for memory reasons, just the name of the data set here.
    //
    areaOwners.add( new AreaOwner( AreaOwner.AreaType.CUSTOM, point.x, point.y, textExtent.x, textExtent.y, new Point( 0, 0 ), DataSetConst.AREA_DRAWN_GOLDEN_DATA_SET, stepMeta.getName() ) );

  }

Example 18

Source File: JobEntryGetPOP.java From pentaho-kettle with Apache License 2.0

4 votes

public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
  List<SlaveServer> slaveServers ) throws KettleException {
  try {
    servername = rep.getJobEntryAttributeString( id_jobentry, "servername" );
    username = rep.getJobEntryAttributeString( id_jobentry, "username" );
    password =
      Encr.decryptPasswordOptionallyEncrypted( rep.getJobEntryAttributeString( id_jobentry, "password" ) );
    usessl = rep.getJobEntryAttributeBoolean( id_jobentry, "usessl" );
    sslport = rep.getJobEntryAttributeString( id_jobentry, "sslport" ); // backward compatible.
    outputdirectory = rep.getJobEntryAttributeString( id_jobentry, "outputdirectory" );
    filenamepattern = rep.getJobEntryAttributeString( id_jobentry, "filenamepattern" );
    if ( Utils.isEmpty( filenamepattern ) ) {
      filenamepattern = DEFAULT_FILE_NAME_PATTERN;
    }
    retrievemails = (int) rep.getJobEntryAttributeInteger( id_jobentry, "retrievemails" );
    firstmails = rep.getJobEntryAttributeString( id_jobentry, "firstmails" );
    delete = rep.getJobEntryAttributeBoolean( id_jobentry, "delete" );

    protocol =
      Const.NVL(
        rep.getJobEntryAttributeString( id_jobentry, "protocol" ), MailConnectionMeta.PROTOCOL_STRING_POP3 );

    String sv = rep.getJobEntryAttributeString( id_jobentry, "savemessage" );
    if ( Utils.isEmpty( sv ) ) {
      savemessage = true;
    } else {
      savemessage = rep.getJobEntryAttributeBoolean( id_jobentry, "savemessage" );
    }

    String sa = rep.getJobEntryAttributeString( id_jobentry, "saveattachment" );
    if ( Utils.isEmpty( sa ) ) {
      saveattachment = true;
    } else {
      saveattachment = rep.getJobEntryAttributeBoolean( id_jobentry, "saveattachment" );
    }

    usedifferentfolderforattachment =
      rep.getJobEntryAttributeBoolean( id_jobentry, "usedifferentfolderforattachment" );
    attachmentfolder = rep.getJobEntryAttributeString( id_jobentry, "attachmentfolder" );
    attachmentwildcard = rep.getJobEntryAttributeString( id_jobentry, "attachmentwildcard" );
    valueimaplist =
      MailConnectionMeta.getValueListImapListByCode( Const.NVL( rep.getJobEntryAttributeString(
        id_jobentry, "valueimaplist" ), "" ) );
    imapfirstmails = rep.getJobEntryAttributeString( id_jobentry, "imapfirstmails" );
    imapfolder = rep.getJobEntryAttributeString( id_jobentry, "imapfolder" );
    // search term
    senderSearch = rep.getJobEntryAttributeString( id_jobentry, "sendersearch" );
    notTermSenderSearch = rep.getJobEntryAttributeBoolean( id_jobentry, "nottermsendersearch" );
    receipientSearch = rep.getJobEntryAttributeString( id_jobentry, "receipientsearch" );
    notTermReceipientSearch = rep.getJobEntryAttributeBoolean( id_jobentry, "nottermreceipientsearch" );
    subjectSearch = rep.getJobEntryAttributeString( id_jobentry, "subjectsearch" );
    notTermSubjectSearch = rep.getJobEntryAttributeBoolean( id_jobentry, "nottermsubjectsearch" );
    bodySearch = rep.getJobEntryAttributeString( id_jobentry, "bodysearch" );
    notTermBodySearch = rep.getJobEntryAttributeBoolean( id_jobentry, "nottermbodysearch" );
    conditionReceivedDate =
      MailConnectionMeta.getConditionByCode( Const.NVL( rep.getJobEntryAttributeString(
        id_jobentry, "conditionreceiveddate" ), "" ) );
    notTermReceivedDateSearch = rep.getJobEntryAttributeBoolean( id_jobentry, "nottermreceiveddatesearch" );
    receivedDate1 = rep.getJobEntryAttributeString( id_jobentry, "receiveddate1" );
    receivedDate2 = rep.getJobEntryAttributeString( id_jobentry, "receiveddate2" );
    actiontype =
      MailConnectionMeta.getActionTypeByCode( Const.NVL( rep.getJobEntryAttributeString(
        id_jobentry, "actiontype" ), "" ) );
    moveToIMAPFolder = rep.getJobEntryAttributeString( id_jobentry, "movetoimapfolder" );
    createmovetofolder = rep.getJobEntryAttributeBoolean( id_jobentry, "createmovetofolder" );
    createlocalfolder = rep.getJobEntryAttributeBoolean( id_jobentry, "createlocalfolder" );
    aftergetimap =
      MailConnectionMeta.getAfterGetIMAPByCode( Const.NVL( rep.getJobEntryAttributeString(
        id_jobentry, "aftergetimap" ), "" ) );
    includesubfolders = rep.getJobEntryAttributeBoolean( id_jobentry, "includesubfolders" );
    useproxy = rep.getJobEntryAttributeBoolean( id_jobentry, "useproxy" );
    proxyusername = rep.getJobEntryAttributeString( id_jobentry, "proxyusername" );
  } catch ( KettleException dbe ) {
    throw new KettleException(
      "Unable to load job entry of type 'get pop' exists from the repository for id_jobentry=" + id_jobentry,
      dbe );
  }
}

Example 19

Source File: KettleTwoWayPasswordEncoder.java From pentaho-kettle with Apache License 2.0

4 votes

public KettleTwoWayPasswordEncoder() {
  String envSeed = Const.NVL( EnvUtil.getSystemProperty( Const.KETTLE_TWO_WAY_PASSWORD_ENCODER_SEED ), "0933910847463829827159347601486730416058" ); // Solve for PDI-16512
  Seed = envSeed;
}

Example 20

Source File: JobEntryHTTP.java From pentaho-kettle with Apache License 2.0

4 votes

@Override
public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,
                     List<SlaveServer> slaveServers ) throws KettleException {
  try {
    url = rep.getJobEntryAttributeString( id_jobentry, "url" );
    targetFilename = rep.getJobEntryAttributeString( id_jobentry, "targetfilename" );
    fileAppended = rep.getJobEntryAttributeBoolean( id_jobentry, "file_appended" );
    dateTimeAdded = rep.getJobEntryAttributeBoolean( id_jobentry, "date_time_added" );
    targetFilenameExtension = Const.NVL( rep.getJobEntryAttributeString( id_jobentry, "targetfilename_extension" ),
      rep.getJobEntryAttributeString( id_jobentry, "targetfilename_extention" ) );

    uploadFilename = rep.getJobEntryAttributeString( id_jobentry, "uploadfilename" );

    urlFieldname = rep.getJobEntryAttributeString( id_jobentry, "url_fieldname" );
    uploadFieldname = rep.getJobEntryAttributeString( id_jobentry, "upload_fieldname" );
    destinationFieldname = rep.getJobEntryAttributeString( id_jobentry, "dest_fieldname" );
    runForEveryRow = rep.getJobEntryAttributeBoolean( id_jobentry, "run_every_row" );

    username = rep.getJobEntryAttributeString( id_jobentry, "username" );
    password =
      Encr.decryptPasswordOptionallyEncrypted( rep.getJobEntryAttributeString( id_jobentry, "password" ) );

    proxyHostname = rep.getJobEntryAttributeString( id_jobentry, "proxy_host" );
    proxyPort = rep.getJobEntryAttributeString( id_jobentry, "proxy_port" ); // backward compatible.

    nonProxyHosts = rep.getJobEntryAttributeString( id_jobentry, "non_proxy_hosts" );
    addfilenameresult =
      "Y".equalsIgnoreCase( Const
        .NVL( rep.getJobEntryAttributeString( id_jobentry, "addfilenameresult" ), "Y" ) );

    // How many headerName?
    int argnr = rep.countNrJobEntryAttributes( id_jobentry, "header_name" );
    allocate( argnr );

    for ( int a = 0; a < argnr; a++ ) {
      headerName[ a ] = rep.getJobEntryAttributeString( id_jobentry, a, "header_name" );
      headerValue[ a ] = rep.getJobEntryAttributeString( id_jobentry, a, "header_value" );
    }
  } catch ( KettleException dbe ) {
    throw new KettleException( "Unable to load job entry of type 'HTTP' from the repository for id_jobentry="
      + id_jobentry, dbe );
  }
}