Skip to main content

Tesorio-Hosted SFTP

Updated over 11 months ago

If you or your bank do not have an external SFTP that Tesorio can connect to, Tesorio will configure an SFTP on your behalf.

Directory Structure

Each file format supplied will have its own parent dedicated directory. For example, if we are processing a BAI2 file, then Tesorio creates a directory like bai2_<id>/

All new files must be put in the pending/ folder under the parent dedicated directory, for Tesorio to process.

Generic example directory structure in SFTP

/

├── bai2_id/ # Name will depend on file formats

│ ├── pending/ # Where to insert files to process

│ │ └── file1.csv

│ ├── processing/ # Files that are currently processing

│ ├── processed/ # Files imported successfully into Tesorio

│ └── failed/ # Files that failed to import into Tesorio

├──camt53/ # Multiple directories exist

│ ├── pending/

│ ├── processing/

│ ├── processed/

│ └── failed/

File Naming Conventions

Files may be named at your, or the bank's, discretion. Multiple file extensions (.txt, .bai, .csv, .xml) are supported, but the file format must conform to the format configured for the directory. This directory location supports our data ingestion process. We recommend a naming structure that contains a time date stamp.

Connecting to SFTP servers

Tesorio has 2 methods to authenticate into our SFTP servers:

  1. Via username/password

  2. Via SSH key authentication

You will decide which method is preferred and Tesorio will provision the SFTP and provide credentials to authenticate.

Domain

Description

sftp.tesorio.com

Production SFTP server

sandbox.sftp.tesorio.com

Sandbox SFTP server

FAQs

Must we put the files inside the pending/ directory in order for them to be processed?

Yes, in order for Tesorio to properly import files, they must be placed within the pending/ directory.

Do I need to move the files around within the other directories or insert files into any other directory other than the pending/ directory?

No, Tesorio handles the movement of files as they are processed by our application. You only need to make sure to insert a file into the pending/ directory.

Did this answer your question?