1. Click Configuration and select Source Configuration from the main menu:

2. Configure the Interface information.

CSV Path:  Select the path where you want the csv file to be created.

Use the Browse Button to bring up a file browser to select a directory: 

CSV Filename: Enter the name you want for the file.  Note: Optional tags can be entered which will be replaced with dates when the file is created.

• {d} or {D} Single digit day. example  1,31
• {dd} or {DD} Day with leading zero.  example  01, 31
• {m) or {M}  Single digit month.  example  1,5,11
• {mm} or {MM} Month with leading zero.  example  01, 05, 11
• {yy} or {YY}  Two digit year.  example 21
• {yyyy} or {YYYY}  Four digit year. example 2021
• {h} or {H} Single digit hour. example  1,24
• {hh} or {HH} Hour with leading zero.  example  01, 24
• {n} or {N} Single digit minute. example  1, 59
• {nn} or {NN} Minute with leading zero.  example  01,59

Examples of table name conversion for July 28, 2021 2:30 pm 

• WW_HACH_TO_WIMS_{YY}{MM}[DD} {HH} {NN}.csv    WW_HACH_TO_WIMS_210728 14 30
• WW_HACH_TO_WIMS_{yyyy}{M}[D} {H} {N}.csv          WW_HACH_TO_WIMS_2021728 14 30

Note: Tags are optional.  You can use any, all or none of the tags.

CSV File Exists:

• Overwrite: If a file of the same name exists, it will be overwritten.
• Append: If a file of the same name exists, data will be appended to that file.

Date Format for CSV file:  This is for the date written to the csv file

• Date Only:  Date (without time) will be written to csv file. example:  7/28/2021
• Date and Time:  Date/Time will be written to csv file.  example:  7/28/2021 0:00

Days to look back for data: The Interface will look back this number of days from the start date.

Note:  Only approved data that doesn't have the Additional Info field (SENT_TO_LIMS_DATE) set.

Additional Info Field to use to mark data as Sent To Lims

• User defined Additional Info Field to use in place of SENT_TO_LIMS_DATE for marking data as sent.

Test Mode:  If this is checked, the data will be collected and written to the csv file, however the SENT_TO_LIMS_DATE will not be updated.