Outils pour utilisateurs

Outils du site


Ceci est une ancienne révision du document !

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 :

  • cell delimiter ⇒ ;
  • text delimiter ⇒ “ (useful only if a semi-colon (;) is present into a cell, usually present for the numerical values, in any case you can leave this double quote)
  • Inapplicable state ⇒ As dependencies cannot be applied with a CSV format, inapplicable states cannot be recognized. So you have to understand that an inapplicable states will be see like a not described value. In other words put a not descrided value or an inapplicable states value will come back to the same.
  • no cells should be empty

Categoricals values

  • Separator between several states ⇒ & (eg: blue & green)
  • Categorical states should be surrounded by a hug, eg : {Dark green}
  • Unknown state ⇒ ? (Never leave an empty cell)
  • Not described state ⇒ not described
  • Inapplicable state : not applicable

Quantitatives values

  • all values are formed by [min;max] separate by semi-colon
  • the min value is less than or equal to the max value
  • min and max values are integer or decimal, eg: [1;8], [2.46;3], [0.791;6.24]
  • Into your CSV file the quantitatives values must be enclosed in double quote, eg: ”[1;8]“
  • Unknown state ⇒ [?;?] (Never leave an empty cell)
  • Not described state ⇒ [;]
  • Inapplicable state : [not applicable]

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)}","[;]"

3. How to save your CSV file

Nous suggérons l'utilisation de OpenOffice ou Libreoffice pour construire le fichiers CSV, mais cela devrait être possible avec la Suite Microsoft.

  • Save your file as csv
  • Select “Edit filter settings” as bellow.

  • Select the parameters as below. The UTF8 character set is recommended particularly in the case of accented characters such as French or Spanish

csvimport.1588764157.txt.gz · Dernière modification: 2020/05/06 11:22 par sylvain