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 just as if they were uploaded through Upload Dataset.  These files go through the same import scripts and remappings 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.

The accepted wildcard characters are: a question mark (?), which denotes a single wildcard character, and an asterisk (*), which denotes any number of characters.  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 only "*.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.

  Is there a separate Test SFTP?

No. To test an upload from the SFTP site into a Test Environment, use a test folder and subfolders.  A subfolder for /test/outgoing is automatically created when a scheduled export is manually run from a Test Environment.  A subfolder for /test/incoming is automatically created when a source format includes this subfolder as an Import Path/Mask.

If a file is dropped into /test/incoming, use the Force Process Pickup link from Database, since the import pickup does not occur automatically as it does in Production Environments.

Was this article helpful?
13 out of 17 found this helpful