Page History

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

→ T1 = 01 jan 2018 00:00, T2 = 23 jan 2018 00:00

How to set up the interface

  1. Go in External interfaces. Create a new interface of type "Export", subtype "Files". (it may already exist by default, named "Accounting export" in that case reuse it)
  2. Setup the SFTP server to which the accounting data will be published.
  3. Create/update a schedule (as detailed below).

Fields of schedule screen

Accounting data exports are done from module tools / list of interfaces in context organization.

  1. Frequency. Recommended: 24 hours OR 1 week.
  2. Date of first export. This is not the field Date from mentionned mentioned above.
  3. Time of the exports. SecuTix tries its best to stick to this precise time. Recommended: 1 am.
  4. Date from. This is the field mentioned above. Format : dd/mm/yy hh:mm Exemple 01/02/18 00:00. By default, leave empty to have a delta export.
  5. Date to. This is the date mentioned above to compute T2.  Format Format : dd/mm/yy hh:mm Exemple 05/02/18 12:00. By default, leave empty to have a delta export. 
  6. Query used for export. Do not modifyBy default, use SIMPLE to receive the data formatted in the default format. If you need a custom format, please contact SecuTix' service team.
  7. Naming format of the produced file.
  8. File encoding (see FAQ)
  9. End of line characters for file. Possible values : Unix, Windows
  10. Field separator. Do not modify.
  11. With headers. Self explaining.
  12. Zip the file : if checked, a zipped file will be produced.
  13. Fields delimiter. Do not modify.
  14. List of emails separated by semicolumns, which will received the produced filedfile.

FAQ

Accounting data are missing

...