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:
Via username/password
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.