Skip to main content
Tesorio Connect SFTP Guide

This document describes the Tesorio SFTP implementation.

Updated over 11 months ago

Directory Structure

Each file format supplied will have its own parent dedicated directory. For example, if we are processing Customer data, then Tesorio creates a customers_with_open_balances/ directory.

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

/

├── customers_with_open_balances/ # 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

├──open_invoices/ # Multiple directories exist

│ ├── pending/

│ ├── processing/

│ ├── processed/

│ └── failed/

└── invoice_pdfs/ # Exclusive directory for Invoice PDFs

└── INV-123.pdf

File Formats

Tesorio accepts data in the form of comma-separated values (CSV files). Tesorio does NOT accept other file types (e.g. XML, JSON, XLSX).

PDFs of your invoices are accepted into the invoice_pdfs/ directory

Naming Conventions for Directories & Files

Each top-level directory name is descriptive based on the files that are transferred to the directory. For example, the open_invoices/ directory is where we add a daily file of all open invoices.

Files may be named at your discretion, however, the file type must end with .csv. This directory location supports our data ingestion process. We recommend creating a naming structure such as {record_type}-{YYYY-MM-DD}.csv. For example within the open_invoices/ directory, you would be placing a new invoices file into open_invoices/pending/invoices-2021-01-01.csv

Directories that will be created:

  • customers_with_open_balances/

  • open_invoices/

  • contacts/

  • invoice_pdfs/

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.

In which directory do I place Invoice PDFs?

Tesorio will provision an invoice_pdfs/ directory where you can place your Invoice PDFs. Tesorio requires the SFTP transfer of all Invoice PDFs with a linking field in your Invoice File. The filename of your Invoice PDF should either be the Invoice Number or another unique identifier in the Invoice File that links the record to the file.

How often does tesorio pick up the files for processing?

Tesorio ingests new files via SFTP every hour, at the top of the hour.

The frequency of updates is determined by your upload frequency.

💡Tesorio's recommendation is to SFTP all your files together.

Tesorio highly recommends daily file uploads to keep your data up to date.

Further Reading

Did this answer your question?