+1 (888) 319-3663 | sales@smartconnect.com

Creating a Text File Source

  • From the left side options column navigate to Date Sources > Bulk Sources > File.

    +

  • On the File Data Sources window click on the Create Bulk File button.

  • On the New File Data Source window click on the Text File.

  • This will open the Text File Data Source window.

  • Enter a Description for the data source.
  • Column Separator – choose the type of column separator from the drop down list. The options are:
    • CSV Delimited
    • Tab Delimited
    • Pipe Delimited
    • Customer Delimited – selecting this option will activate the adjoining text field where the user can enter a column separator other than CSV, Tab, or Pipe.
  • Character Set – the two options are ANSI or OEM.
  • Has Column Headers – mark this checkbox if the source file has column headers.
  • Select file at runtime – when this checkbox is marked, the uploaded file will be used as a template to define the column headers and no data from it will be processed.
  • Source File – select the text file that will be used as the data source.
  • Source Schema – if the source file does not have column headers they can be defined here by clicking on Add Column.
    • Row No – automatically populated.
    • Column Name – user enters the name of the added column here.
    • Type – user defines the data type by selecting one of the dropdown list options.
    • Length – user defines the length of the field.
  • Once all the fields have been populated, the Save button becomes active.
  • Clicking on Save will save the data source and make the data source available to be selected when creating an Integration Process.
  • After the Text File source has been saved, the Preview button will become active.
  • Click on the Preview button will open a pop-up window that displays the first few records contained in the spreadsheet.

Leave a Comment