Table des matières

Csv Import

1. Leave default options or Select "Advanced options"

The better choice is to respect the default options. If you want to reimport correctly a CSV file exported from xper3 with the default options, we advice to leave the default options and don't check “Advanced options”.

2. To build your csv file, please maximum respect the options default as following :

Categoricals values

Quantitatives values

Here you have a sample csv file that you can download and test ⇒ download CVS

;"Body colour";"Dorsal lines/stripes";"Lateral lines/stripes";"Pinacula";"Spiracles";"Anal plate";"Head";"Length"
"Agonopterix purpurea";"{Green (yellowish)}";"{Dark green}";"?";"not applicable";"?";"{Concolorous}";"{Black}";"[not applicable]"
"Agonopteri subpropinquella";"{Dull/greyish green}";"{Slightly darker}";"?";"{Black}";"{Pink}";"not applicable";"{Black}";"[2;3]"
"Agonopteri propinquella";"{Apple green}";"not described";"{White}";"{Dark grey}";"{Black}";"{Green}";"{Black}";"[?;?]"
"Agonopteri heracliana";"{Green (yellowish)}";"{Darker green}";"{White}";"{Black}";"{Pink}";"{Concolorous}&{dots}";"{Green (yellowish)}";"[;]"

The same example but with a comma cell delimiter
Note : in this case you need select “Advanced options” and select the comma cell delimiter.

,"Body colour","Dorsal lines/stripes","Lateral lines/stripes","Pinacula","Spiracles","Anal plate","Head","Length"
"Agonopterix purpurea","{Green (yellowish)}","{Dark green}","?","not applicable","?","{Concolorous}","{Black}","[not applicable]"
"Agonopteri subpropinquella","{Dull/greyish green}","{Slightly darker}","?","{Black}","{Pink}","not applicable","{Black}","[2;3]"
"Agonopteri propinquella","{Apple green}","not described","{White}","{Dark grey}","{Black}","{Green}","{Black}","[?;?]"
"Agonopteri heracliana","{Green (yellowish)}","{Darker green}","{White}","{Black}","{Pink}","{Concolorous}&{dots}","{Green (yellowish)}","[;]"

Example with Data in rows : Descriptors and Data in columns : Items

;"Agonopterix purpurea";"Agonopteri subpropinquella";"Agonopteri propinquella";"Agonopteri heracliana"
"Body colour";"{Green (yellowish)}";"{Dull/greyish green}";"{Apple green}";"{Green (yellowish)}"
"Dorsal lines/stripes";"{Dark green}";"{Slightly darker}";"not described";"{Darker green}"
"Lateral lines/stripes";"?";"?";"{White}";"{White}"
"Pinacula";"not applicable";"{Black}";"{Dark grey}";"{Black}"
"Spiracles";"?";"{Pink}";"{Black}";"{Pink}"
"Anal plate";"{Concolorous}";"not applicable";"{Green}";"{Concolorous}&{dots}"
"Head";"{Black}";"{Black}";"{Black}";"{Green (yellowish)}"
"Length";"[not applicable]";"[2;3]";"[?;?]";"[;]"

3. How to save your CSV file

We suggest using OpenOffice or Libreoffice to build the CSV files, but this should be possible with the Microsoft Suite.