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:
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.
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.