Différences

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

--- csvimport [2020/05/06 13:34] – [2. To build your csv file, please maximum respect the options default as following :] sylvain
+++ csvimport [2022/08/31 18:44] (Version actuelle) – wikiadmin
@@ Ligne 1: / Ligne 1: @@
-====== Csv Import ======
+====== Import en CSV ======
 ==== 1. Leave default options or Select "Advanced options" ====
@@ Ligne 7: / Ligne 7: @@
 ==== 2. To build your csv file, please maximum respect the options default as following : ====
-  * cell delimiter => ; (semicolon - by default) or , (comma - by selecting Advanced options  and CSV options)
+  * 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 => **"** (double quote). 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 (in option)
+  * Data in columns : Descriptors (by default) or Items (in option)
   * **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
+  * **no cells should be empty**
 **Categoricals values**
-  * Separator between several states => & (eg: blue & green)
+  * Separator between several states => **&** eg: {blue}&{green}
-  * Categorical states should be surrounded by a hug, eg : {Dark green}
+  * States should be surrounded by a hug => **{}** eg : {Dark green} or for two states {blue}&{green}
-  * Unknown state => ? (Never leave an empty cell)
+  * Unknown state => **?** (Never leave an empty cell)
-  * Not described state => not described
+  * Not described state => **not described**
-  * Inapplicable state : not applicable
+  * Inapplicable state : **not applicable**
 **Quantitatives values**
-  * all values are formed by [min;max] separate by semi-colon
+  * 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]
+  * min and max values are integer or decimal, eg: **[1;8] or [2.46;3] or [0.791;6.24]**
-  * Into your CSV file the quantitatives values must be enclosed in double quote, eg: "[1;8]"
+  * Into your CSV file the quantitatives values must be enclosed in double quote, eg: **"[1;8]"**
-  * Unknown state => [?;?] (Never leave an empty cell)
+  * Unknown state => **[?;?]** (Never leave an empty cell)
-  * Not described state => [;]
+  * Not described state => **[;]**
-  * Inapplicable state : [not applicable]
+  * Inapplicable state : **[not applicable]**
@@ Ligne 47: / Ligne 49: @@
 "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>
+**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 ====