Skip to end of metadata
Go to start of metadata

Introduction

A File Share source provides access to resources (files and folders) using Microsoft Windows File Share UNC paths.

Prerequisite

Before you can use the trigger file feature of a File Share source (see the Options below), you must have enabled Local File Location on your Jitterbit Private Agent. See Enabling Local File Location for details.

Creating a File Share Source

You can choose to create a new File Share source on its own, or within an existing operation. For more information on how sources work within operations, see Creating an Operation.

Creating a New File Share Source as a Standalone Source

Within your project in Jitterbit Design Studio, you create a new File Share source by any of:

  • Go to File > New > New Source; or

  • In the tree on the left, right-click on Sources and select New Source; or
  • In the top toolbar, click the green source icon  .

In the popup, select File Share as the type:

Your new source appears in its own New Source tab in the right pane of the window.

NOTE: If you create a standalone source using any of these methods, note that it is not connected to an operation. See Using an Existing File Share Source in an Existing Operation below to use the new source.

Creating a New File Share Source in an Existing Operation

A source is usually created by default when you create a new operation. (The exception is an operation that consists only of a script.) With an existing operation, you can specify the type of its source by:

  • Double-clicking on the source icon; in the popup, select Create New Source; or

  • Right-clicking on the source icon and selecting Create New Source

In the configuration screen that appears, use the Type dropdown to select File Share, as shown above.

Using an Existing File Share Source in an Existing Operation

To use an existing File Share source in an existing operation with a source, you can set it by any of:

  • Within the operation, double-clicking on the source icon, and in the resulting popup, selecting the desired File Share source from the list; or

  • Within the operation, right-clicking on the source icon, choosing Select Existing Source, and in the resulting popup, selecting the desired File Share source from the list; or

  • Dragging the desired File Share source from the tree on the left and dropping it onto the existing source icon of the operation.

Configuring a File Share Source

After you have created a File Share source, the configuration screen will open in the main view of Design Studio. You can return to the configuration screen at any time by double-clicking on the source icon in the operation, or by double-clicking on the source in the tree on the left.

Basic Configuration

The configuration screen will appear similar to this example:

  • Name: Enter an appropriate, unique name for the source.
  • Type: Use the dropdown to select File Share, if it is not already specified.
  • Connection Parameters: Specify the details for your local file connection:
    • Path(s): Enter file share UNC paths in the Path(s) field. These paths always end in a folder and never a specific file.
      • Example: \\demo\ directs the system to look for a shared network drive called demo
      • Example: \\dropserver\incoming\po is the UNC name of the share incoming\po on the server dropserver.
      • The UNC name must begin with "\\" but a trailing backslash is optional.
      • Multiple paths can be specified, using comma-separated values.
    • Login: If a login is required (in the form of DomainName\UserName) to access a shared network drive, enter a valid username into the Login field.
    • Password: Enter a password to use with the Login to access a shared network drive referenced in the Path(s) field.
    • Get Files: Enter the desired names for the source file(s), such as BillOfSale.txt, or *.*. Wildcards and variables may be used in this field. If specifying a compressed file (ZIP), see the "Compression" section of the additional connection parameters under Options below. The compressed file can automatically be uncompressed and read.
    • Filter Options: Allows specifying if filename case should be ignored or if the Get Files information should be treated as a regular expression.
  • Test Connection: Clicking the   button will test the File Share source; it will fail if the path is not a valid UNC path that finds files on the operating system where the Jitterbit Agent is running.
  • Click the Save button in either the main toolbar or the target's toolbar to save the configuration.

Options

Additional connection parameters can be specified by clicking the Options at the bottom of the Connection Parameters section:

  • Character Encoding: Used to specify a character encoding for the source file(s). If left blank, Jitterbit will attempt to detect the encoding. To specify a different encoding than that default, insert one of the supported encodings described in Character Encoding.
  • Trigger File: Use this to specify a trigger file to initiate processing of the source file(s). The trigger file is deleted when processing starts. 
    • After selecting the Use Trigger checkbox, specify an Absolute file path to a file whose presence will trigger processing.
    • Variables (though not wildcards) may be used in this field.
    • As the trigger file is deleted as processing starts, the trigger file cannot be the same file as a source file being processed.
    • Once the operation starts, the operation will poll, looking for the trigger file. Polling time interval is fixed at one second.
    • The trigger file is deleted as processing starts. 
    • If the trigger file is not found, the operation will keep attempting to find the trigger file until the operation times out.
    • Setting a trigger file blocks any operation or script that uses the source until either the trigger file condition is satisfied or the operation times out.
  • After Processing: 
    • If the Delete File checkbox is checked, the source file(s) will be deleted after they have been processed.
    • If a value is specified in the Rename File field, the file will be renamed using the pattern supplied. Variables may be used in this field.
    • Only one of deleting or renaming is accepted; if the Delete File checkbox is checked, Rename File will be disabled and ignored. If the Rename File is empty, it will be ignored. If left as the default, no post-processing of source files will take place.
  • Ignore Lines: The indicated numbers of first and last lines that are to be ignored for each file. If there are headers or footers to be ignored, enter the number of lines into the First and Last fields as appropriate.
  • Compression: If the checkbox for The source data is compressed is checked, source files will be uncompressed using the ZIP format. A Password (for encrypted archives) can be specified. Encrypted archives are supported if a password is supplied. Only reading from the root directory of the archive is supported.
On This Page

Related Articles
Related Topics

Last updated:  Mar 27, 2019


  • No labels