Scheduling Imports from SFTP

Imports can be set to be picked up automatically from the /incoming/ directory on the SFTP server.  For any source format, an import mask can be specified on the Import Automation tab of the source format. This enables other systems to deliver files directly to the SFTP that are processed as if uploaded through Upload Dataset.  These files go through the same import scripts and remap process as when they are uploaded directly.

  Files not coming in?

Check the Import Path/Mask field: it needs to include the name of the subfolder your file is stored in if you're using one.

So, for example, if your files are stored in a subfolder labeled "Banner," then the Import Path/Mask should be Banner/SisToSlate_*.txt

If an import mask has been specified, Slate scans the /incoming/ directory at least once per hour to determine if one or more files match the specified mask.

You must specify the folders/subfolders in the path, but you can use the following wildcard characters in the filename:

    • Each question mark (?) denotes a single wildcard character.
    • An asterisk (*) denotes any number of characters, and can only be used once.

For example, to identify all files that start with "SisToSlate_" and end with ".txt", the import mask could be "SisToSlate_*.txt".  A prefix or suffix should always be specified (for example, never use "*.txt" or "*_SisToSlate_*.txt" as a mask) to ensure that you're specifically targeting the files, and no spaces or special characters except for an underscore should be used.

When Slate picks up and processes a file, the file is moved into a /processed/ subdirectory within the /incoming/ directory.  If a file with that name already exists, the existing file within the /processed/ directory is overwritten.

Was this article helpful?
14 out of 19 found this helpful