New List using CSV

<< Click to Display Table of Contents >>

Navigation:  PlantExpressTools > How to use > Update Selection Lists > Setup >

New List using CSV

Previous pageReturn to chapter overviewNext page

Make sure you read through the previous two chapters, because we will leave some details out.

In this example we use a CSV file. Depending on the country you are and your windows settings the separator in a CSV file may be different than in this image.

We see a header line and then rows from 1000 to 9000 with their description in the second column. You can edit CSV files in Excel too. Just make sure that you export them as CSV.

If you use a CSV file, make sure that you have only two columns. All other data sources can have more columns, because for other data sources you can select which columns to use.

Selection Lists 26

We open the main dialog again.

Selection Lists 01

We see the configuration of the previous chapters.

Selection Lists 20

We disable it, because we will create a new configuration. After we disabled it, we will see that "State" now shows "Disabled". The line also becomes grey, but in this case we only have that one line and it is selected and therefore shows with a blue background color.

Selection Lists 24

We create a new configuration.

Selection Lists 25

This type we use "Csv files (*.csv)" and select our sample file.

Selection Lists 27

We adapt the path.

Selection Lists 28

And make it a relative path.

Selection Lists 29

On the right you recognize, that it now looks different than when we used an Excel file as a data source.

Our CSV file uses a header line, so we check this box. We define/change the delimiter if needed.

Selection Lists 30

We use the following settings and options as before.

Selection Lists 31

We see the new line.

Selection Lists 32

We update the Selection List.

Selection Lists 16

We get the result.

Selection Lists 17

When we check we see the content from our CSV file.

Selection Lists 33

Next Chapter: New List using SQLite