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édentesRévision précédente
Prochaine révision
Révision précédente
Dernière révisionLes deux révisions suivantes
csvimport [2020/01/15 13:10] – [2. To build your csv file, please maximum respect the options default as following :] sylvaincsvimport [2020/06/09 13:16] – [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" ==== ==== 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 : ==== ==== 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 => **"** (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 37: Ligne 41:
 "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>
  
-==== 3.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> 
 + 
 +**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 filesbut this should be possible with the Microsoft Suite.
  
   * Save your file as csv   * Save your file as csv
csvimport.txt · Dernière modification : 2022/08/31 18:44 de wikiadmin

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki