Différences

Ci-dessous, les différences entre deux révisions de la page.

--- csvimport [2020/01/15 13:09] – [2. To build your csv file, please maximum respect the options default as following :] sylvain
+++ csvimport [2020/05/12 16:03] – [2. To build your csv file, please maximum respect the options default as following :] sylvain
@@ Ligne 2: / Ligne 2: @@
 ==== 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 => ;
+  * cell delimiter => ; (semicolon - by default) or , (comma - by selecting Advanced options  and CSV options)
-  * 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)
+  * text delimiter => " (useful only if a semicolon (;) is present into a cell, usually present for the numerical values, in any case it's better if you leave this double quote)
+  * Data in rows : Items (by default) or Descriptors
+  * Data in columns : Descriptors (by default) or Items
   * **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
@@ Ligne 37: / Ligne 41: @@
 "Agonopteri heracliana";"{Green (yellowish)}";"{Darker green}";"{White}";"{Black}";"{Pink}";"{Concolorous}&{dots}";"{Green (yellowish)}";"[;]"</code>
-** How to save your CSV file **
+The same example but with a comma cell delimiter\\
+**Note** : in this case you need select "**Advanced options**" and select the comma cell delimiter.
-Nous suggérons l'utilisation de OpenOffice ou Libreoffice pour construire le fichiers CSV, mais cela devrait être possible avec la Suite Microsoft.
+<code>,"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)}","[;]"</code>
-  * Save your as csv
+**Example with Data in rows : Descriptors and Data in columns : Items**
+<code>
+;"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]";"[?;?]";"[;]"
+</code>
+==== 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.
+  * Save your file as csv
   * Select "Edit filter settings" as bellow.