Configuring data export settings

The Settings page allows you to specify a number of export format settings that LI-COR Cloud uses when generating all exports. LI-COR Cloud uses these settings for both on-demand and scheduled exports (see Creating an on-demand export or Creating a scheduled export). You can override some settings when creating a specific export, such as file format and time zone, but some settings cannot be overridden at the individual export level.

Setting Description
Default File Format Select to export to a CSV or XLSX.
Time Format Select from 12- or 24-hour format.
Column Separator Select from Tab, Comma (,), or Semicolon (;)
Default Time Zone Select your time zone from the list.
Date Format Select from M D Y, D M Y, or Y M D
Positive # Format Select how you want positive numbers to appear in the export.
Date Sample Displays how your selections for Time Format, Date Format, and Date Separator appear in the export.
Negative # Format Select how you want negative numbers to appear in the export.
Date Separator Select Slash (/) or Dash (-).
Separate date and time into two columns Displays the date and time in separate columns.
Include line number in column Adds a first column that numbers the rows.
Include labels in column header if available Displays the labels you have named your measurements (if you have provided them) in the column header.
Include serial number in column header if available Displays the serial number of the device in the column header.
Include export settings in header Displays the settings you select on this page in the column header.

Specify default FTP/SFTP settings

Use the fields at the bottom of the Settings page to specify FTP/SFTP settings that LI-COR Cloud uses to communicate with your server. LI-COR Cloud uses these settings as the default for on-demand and scheduled exports delivered using FTP/SFTP. You can specify settings specific to an export while you are setting it up.

  1. Click the slider to turn on Configure FTP Settings.

    This exposes the FTP Settings.

  2. Complete the required fields and any optional fields you need.

    Table 5‑1 explains each setting.

  3. Click Test Connection to test the settings you've entered.

  4. Click Save to save your settings.

Table 5‑1. FTP and SFTP options.
Setting Description
Server The address of your FTP server. Enter a valid host name. You can use a valid public IP address or a URL.
Port The port your server uses to communicate. Leave this blank to use the default port.
Remote Folder The folder on the server where you want to place your data. Folders beginning with a slash (/) are root directory paths. Folders without a slash are relative to your home directory.
Username Your username on the server.
Password Your password on the server.
Compress uploaded files Tells LI-COR Cloud to compress the files that it sends.
Use secure connection (SFTP) Tells LI-COR Cloud that you want to send data using a secure connection. If you select this option, also select Use certificate if the server uses a digital certificate for authentication.
Use passive mode Tells LI-COR Cloud to use passive mode when making the connection (necessary if the server is running behind a firewall). This setting is not available when LI-COR Cloud is using a secure connection.

Setting up the SFTP certificate

When you check Use secure connection (SFTP), LI-COR Cloud uses public key authentication. These instructions help you install the LI-COR Cloud-generated public key on your OpenSSH server. If your SSH server uses other software or you are not authorized to log in to the server, consult your IT administrator for help.

  1. Log into the SSH server.

  2. Go to the .ssh subdirectory of your account's home directory or create one, if needed.

    You may need to enable show hidden files if you are unable to view the .ssh directory. The recommended permissions for the .ssh directory is 700.

  3. Open the authorized_keys file or create one, if needed.

    The recommended permissions for the file is 600.

  4. In LI-COR Cloud, select Settings and complete all the SFTP fields in Default FTP/SFTP Settings.

  5. Check the Use certificate box.

  6. Copy the entire contents of the Public Key field to your clipboard.

  7. Return to the authorized_keys file and paste the key into the file.

    Make sure all the text from copied key is in one line and save the file.

  8. Be sure your account home directory, your .ssh subdirectory, and the authorized keys file are not group-writable or world-writable.

  9. In LI-COR Cloud, click Test Connection.

  10. Click Save to save the SFTP settings.