Introduction

The purpose of this page is to outline the data format that needs to be provided to Sopht, in order to fill out their printing information.

Document versions

File format

• Character encoding: UTF-8 (without BOM)

• The line separator is the character set CRLF: Carriage Return (carriage return) and Line Feed (line feed). The last line may or may not end with this separator.

• The file must have a first "header" line reminding the names of the fields defined below.

• Columns are separated by the character ,

• Each string value can be surrounded by double quotes “. If a value contains the character , it becomes necessary. If the “ character must appear inside a surrounded value, the character must be doubled.

• For further details on the CSV format, see the RFC 4180.

• The file name must be in the form of: printing_information_YYYYMMDD.csv (ex : “printing_information_20241201.csv”).

• Sopht processes data only once, thus printing values for a specific date won’t be modified after the first shared file with those data.

• You can remove optional columns altogether, or change the order of the columns, although the names of the columns must remain unchanged.

<aside> ⚠️

Caution: Data Entry Guidelines

• We process data only once, so data processed for a specific date will not be modified later.
• We only accept one line per period. If you have multiple printers, you will need to sum the data from all printers for each period. For example, if you have 2 printers:
  • Printer 1 for the period [2024-01-01; 2024-01-31]
    • 3,000 B&W prints
    • 2,000 Color prints
  • Printer 2 for the period [2024-01-01; 2024-02-31]
    • 100 B&W prints
    • 500 Color prints
  • CSV to be transmitted:
    • line 1: 2024-01-01,2024-01-31,3050,2250
    • line 2: 2024-02-01,2024-02-31,50,250
• Please list all your periods in the same file, with one line per period (day/month/year) </aside>

Sans titre