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
Prochaine révision Les deux révisions suivantes
csvimport [2020/05/06 11:40]
sylvain [2. To build your csv file, please maximum respect the options default as following :]
csvimport [2020/05/12 14:03]
sylvain [2. To build your csv file, please maximum respect the options default as following :]
Ligne 9: Ligne 9:
   * 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 it's better if you 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.   * **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
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.txt · Dernière modification: 2020/06/09 11:16 par sylvain