Configure using ​.csv files

The EdgeCmd utility recognizes content in a comma-separated value (.csv) file and can convert it. You can use the EdgeCmd utility to import data selection information to a .csv file. Additionally, you can also export the data selection information from the adapter to a .csv.

Import data selection from a .csv file

To import data selection from a .csv file:

1. Access EdgeCmd utility through the command line.

2. Enter the following in the command line, replacing <componentId> with the ID of the adapter and <PathToCsvFile> with the path to the .csv file from which you want to import the data selection and select Enter.

   edgecmd set DataSelection -cid <componentId> -file <PathToCsvFile> -csv

   Note: The .csv file needs to include a header row.

Export data selection into a .csv file

To export data selection into a .csv file:

3. Access EdgeCmd utility through the command line.

4. Type the following in the command line, replacing <componentId> with the ID of the component for which you want to export the data selection and select Enter.

   edgecmd get DataSelection -cid <componentId> [-file <PathToCsvFile>] -csv

   If you omit the optional parameter and -filePathToCsvFile, the system writes the contents to the standard output terminal or console.

Sample output

Note: EdgeCmd utility translates null values into an empty string for the get operation, while it interprets empty strings as null values for the set operation. To specify an empty string for the configuration, use double quotes "".