This page provides information on the way to set up "flat file" exports from SecuTix interfaces menus.

Here is an explanation on the different fields of the schedule screen.

Fields of schedule screen

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

The fields 1 ro 11 are common to all schedule screens. 

Fields 12 to 22 are specific to exports.

  1. Launch : if "Automatic", export will start according to the frequency or rules below. If Manual, it will start only when clicking "Immediate execution".
  2. Name: name of the schedule.
  3. Frequency: if automatic launch, frequency of the executions.
  4. Next execution start time: Deprecated. For automatic executions, always choose "Computed from start date"
  5. Start date: in case of automatic launch, date of the first execution
  6. Days before first product date: in case of automatic launch related to a dated product, the start date is computed from the date of the product.
  7. Start time: in case of automatic launch, time of first execution. 
  8. End date: in case of automatic launch, date of last execution
  9. Days after first product date:  in case of automatic launch related to a dated product, the end date is computed from the date of the product.
  10. End time: in case of automatic launch, time of last execution.
  11. Batch size: if the function supports if (it is the case for flat file exports), indicates the max number of lines exported.
  12. Date from: if the exports is computing deltas, the date from used is the one of the last successful export with the same schedule. If this field is filled, this field forces the date from to the value entered.
  13. Query used for export: Indicates the name (in capitals) of the query used to process the export.
  14. Filename prefix; 
    1. Can be of two kinds. If plain characters (like MyPrefix), the files generated will have the following names : MyPrefix_190123.txt where the italic part is the date. 
    2. Else, this prefix can be replaced by a "pattern" value following the rules of SimpleDateFormat. 
      1. Exemple : 'MyPrefix'yyyy-MM-dd-HH-mm'.csv' will generate a file named : MyPrefix_2019-01-23-11-55.csv
      2. Or 'MyConstantFileName.csv' to get always the same name.
      3. The custom parameter deltaFiles=false (default value: true) prevents the system to add _1, _2, etc. to the file name if a file with the same name already exists.
  15. File format: TXT orC CSV, it does not matter for file exports. It sets up the ending of the file name in the a) case above.
  16. File encoding: Exemples : UTF-8 or Cp1252 for Windows-compatible files
  17. End of line characters for file. Possible values : Unix, Windows
  18. Field separator. Character separating the fields of a tabular export. \t means "tabulation"
  19. With headers. Self explaining.
  20. Zip the file : if checked, a zipped file will be produced.
  21. Fields delimiter. Character enclosing the fields of a tabular export. For example: ' or " or nothing
  22. List of emails separated by semicolumns, which will received the produced files.

© SecuTix 2023 - Login