Sellforte standards for file-based data transfers

Filename conventions

Filename should describe its contents and the target dataset. Please maintain the same filename convention during data updates, since it helps automating the data processing.

CSV files

Files transferred and shared should be in machine-readable CSV file format to minimize any errors in data ingestion

• Encoding = UTF-8

• Delimeter = Comma

• Decimal seprator = Dot

• Quote character = "Double quotes"

Encoding = UTF-8

Delimeter = Comma

Decimal seprator = Dot

Quote character = "Double quotes"

Data types

• DATE = Dates as YYYY-MM-DD (ISO 8601 standard), for instance 2021-01-24

• TIME = Times as hh:mm or hh:mm:ss (extended ISO 8601 format with 24-hour clock), for instance 18:33:00

• TEXT = Text string of any length, for instance "Black Friday mega campaign 2022"

• INT = Integer number type, for instance 12345

• FLOAT = Floating point number type, for instance 123.45

• BOOL = True or False (1 or 0 also ok)

DATE = Dates as YYYY-MM-DD (ISO 8601 standard), for instance 2021-01-24

TIME = Times as hh:mm or hh:mm:ss (extended ISO 8601 format with 24-hour clock), for instance 18:33:00

TEXT = Text string of any length, for instance "Black Friday mega campaign 2022"

INT = Integer number type, for instance 12345

FLOAT = Floating point number type, for instance 123.45

BOOL = True or False (1 or 0 also ok)

Did this answer your question?😞😐😃