Changing Export File Settings

To change the export file format settings:

1. Click User Settings and then click Export.
2. Under File Format Settings, change the following settings as desired. You can preview changes made to the date and time format in the Date Sample field.

• Default File Format. Choose one of three ways for the exported data to be saved: Text (.csv), Excel (.xlsx), or HOBOware CSV (.csv). The "HOBOware CSV" file type will set up the exported file with the preferred settings for importing into HOBOware (settings that are ignored when selecting "HOBOware CSV" are marked on this tab). Note that YAML header information will be included HOBOware CSV files, but not in Text (.csv) or Excel (.xlsx) files.
• Column Separator. Choose whether the data in the file should be separated by tabs, commas, or semi-colons.
• Date Format. Choose how the date will be listed in the exported file: Month Day Year, Day Month Year, or Year, Month, Day.
• Date Separator. Select the character that will separate the date in the exported file: Slash (/) or Dash (-).
• Time Format. Select how the time will be listed in the exported file: in 12-hour format or 24-hour format.
• Default Time Zone. Select which time zone should be used for the exported file.
• Positive # Format. Select how positive numbers will be formatted in the exported file based on these examples: 1,234.56; 1 234,56; 1.234,56; or 1.234 56.
• Negative # Format. Select how negative numbers will be formatted in the exported file based on these examples: -123; 123-; or (123).
• Separate date and time into two columns. Select this option if you want the date and time to be in two columns instead of combined into one in the exported file.
• Include line number column. Select this option if you want the exported file to contain a separate column to the left of the data that lists a line number for each data point.
• Include logger and sensor label/name in column header if available. Select this option to add any logger or sensor labels/names to the sensor column header in the exported file.
• Include logger and sensor serial number in column header if available. Select this option to add any serial numbers for the logger and sensors as well as the sensor product code to the corresponding column header in the exported file.
• Include export settings in header. Select this option to include the export name and time frame as defined in the export.

3. Click Save when done.

To change the default FTP/SFTP settings used with exported files:

1. Click User Settings and then click Export.
2. Under Default FTP (or SFTP) Settings pane, enter the following information for the server where you want exported files to be delivered:

• Server. Type the name of the server (e.g. ftp.companyname.com).
• Port. Type the port number used for the server or leave the field blank if the server uses the default port.
• Remote Folder. Type the name of the folder on the server where you want the exported files to be delivered. Folders beginning with a slash (/) are expected to be root directory paths. Folders without a slash are assumed to be relative to your home directory.
• Username. Type the username for the account used to access the server.
• Password. Type the password to access the server.
• Compress uploaded files. Select this option if you want to compress the file before delivering it to the FTP server.

• Use secure connection. Select this option if the server is secure (SFTP). If this option is selected, then click the Use certificate checkbox if the server uses a digital certificate for authentication. See SFTP Certificate Setup for more details.

• Use passive mode. Select this option if the server runs in passive mode (necessary if the server is running behind a firewall). This option is not available if you have selected the Use secure connection checkbox.

3. Click Test Connection to make sure HOBOlink can connect to the server using the settings entered.

4. Click Save when done. These FTP/SFTP settings will automatically be available for exports on the Data Delivery tab. You can override these default settings for a specific Data Delivery without impacting the defaults.

To change the default email settings used with exported files:

1. Click User Settings and then click Export.
2. Under Default Email Settings, type the email address to be used for delivering exported files. This email address is associated with exported files only. To change the email address for your HOBOlink account, click the Account Info tab.
3. Select "Compress email file attachments" if you want to minimize the size of the exported file before emailing it.
4. Click Save when done. These email settings will automatically be available for exports on the Data Delivery tab. You can override these default settings for a specific Data Delivery without impacting the defaults.