Outils pour utilisateurs

Outils du site


csvimport

Différences

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

Lien vers cette vue comparative

Les deux révisions précédentes Révision précédente
Prochaine révision
Révision précédente
csvimport [2020/05/06 11:39]
sylvain [2. To build your csv file, please maximum respect the options default as following :]
csvimport [2020/06/09 11:16] (Version actuelle)
sylvain [2. To build your csv file, please maximum respect the options default as following :]
Ligne 7: Ligne 7:
 ==== 2. To build your csv file, please maximum respect the options default as following : ==== ==== 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 semicolon (;) 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.   * **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** **Categoricals values**
  
-  * Separator between several states => & (eg: blue & green) +  * Separator between several states => **&** eg: {blue}&{green} 
-  * Categorical states ​should be surrounded by a hugeg : {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** **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    * 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 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>​ "​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 ==== ==== 3. How to save your CSV file ====
csvimport.1588765152.txt.gz · Dernière modification: 2020/05/06 11:39 par sylvain