Rules for naming files

The used format is commonly called "CSV" (which stands for Comma Separated Values), it is notably supported by Microsoft Excel.

The names of reporting files should follow conservative guidelines and must provide 5 pieces of information all separated by the underscore character "_".

Nomenclature Description
CODE The code is made up of the original initials of the report name:
  • JO = Operations report
  • JT = Transactions report
  • JRB = Bank reconciliation report
  • JRI = Chargebacks reconciliation report
SHOP-LABEL The shop name in capital letters as it was defined in the Merchant Back Office
SHOP-ID The 8-digit shop identifier as it was defined in the Merchant Back Office
DATE or WEEK or MONTH

One of the 3 pieces of information will be used depending on the report frequency:

  • Daily frequency: DATE of report generation in the YYMMDD format
  • Weekly frequency: WEEK of report generation in the YYWXX format (W stands for Week and XX for the number of the week)
  • Monthly frequency: MONTH of report generation in the YYMXX format (YY for the last two digits of the year, M for month and XX for the number of the month).
VERSION

The display of the version depends on the report type:

  • For the Transactions report: No version
  • For the Operations report: V3
  • For the Bank reconciliation report: V1
  • For the Chargebacks reconciliation report: V1

Examples

  • Daily periodicity

    The file contains transactions made the day before. It is called:

    CODE_SHOP-LABEL_SHOP-ID_DATE_VERSION.csv

    Transactions report generated on 01/21/2019, containing transactions made on 01/20/2019 by the shop "BOUTIQUE_DE_DEMO" (ID: 12345678):

    JT_BOUTIQUE_DE_DEMO_12345678_190121.csv

  • Weekly periodicity

    The file contains transactions made the week before. It is called:

    CODE_SHOP-LABEL_SHOP-ID_WEEK_VERSION.csv

    Transactions report generated on 01/21/2019, containing transactions made on 01/14/2019 by the shop "BOUTIQUE_DE_DEMO" (ID: 12345678):

    JT_BOUTIQUE_DE_DEMO_12345678_19W03.csv

  • Monthly periodicity

    The file contains transactions made the month before. It is called:

    CODE_SHOP-LABEL_SHOP-ID_MONTH_VERSION.csv

    Transactions report generated on 2/1/2019, containing transactions made between 1/1/2019 and 1/31/2019 by the shop "BOUTIQUE_DE_DEMO" (ID: 12345678):

    JT_BOUTIQUE_DE_DEMO_12345678_19M01.csv

Note

In test mode, the filename is always prefixed with TEST_.