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/01/15 12:09]
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 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>​
  
-** 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 CSVmais 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.   * Select "Edit filter settings"​ as bellow.
  
csvimport.1579090147.txt.gz · Dernière modification: 2020/01/15 12:09 par sylvain