Data import method - SFTP

There is for now only one way to import data into Splio Telco CVM, it is to drop files on an SFTP server regularly.

⚠️ The following requirements must be followed even after the initial setup to avoid import issues.

Please ensure that your CSV files match the following specifications:

• Authentication is done using a login and a password provided by your contact at Splio
• CSV with proper Delimiter, Quotechar, and Escapechar
• Headers are mandatory
• Encoding: UTF-8
• File names and headers should not contain accented letters or spaces (é, è, ñ, etc.) and should respect the following pattern:

table_source_subsection_YYYYMMDD.csv`  

• By default, files must be submitted daily at a fixed time. If required, we can go up an import every three hours.

Note that if you plan to send more than one file per day you should respect the following file naming pattern: table_source_subsection_YYYYMMDDHHMMSS.csv

• Files can only be compressed using ZIP or Gzip format.
• Files size must not exceed 10Gb (once uncompressed).
  • Full data history can be split into separate files to ease the transfer. In this case, please respect the following name pattern: table_source_subsection_YYYYMMDDHHMMSS_1.csv, table_source_subsection_YYYYMMDDHHMMSS_2.csv
• Files must be without a password and not be partitioned and/or contained within any folder but exported as stand-alone files.
• The file structure (header, date formats, etc.) must remain stable over time.
• Files should only contain the incremental data since the last export.
  • Note that we recommend you send the last 2 days' worth of data in order to avoid gaps (we manage duplicates on our side).
  • Do not forget to send us the updated lines of your user (opt-in status update included) and product tables
• Note that we can also manage full replacement for any reference/dimension