csvimport
Différences
Ci-dessous, les différences entre deux révisions de la page.
Les deux révisions précédentesRévision précédenteProchaine révision | Révision précédente | ||
csvimport [2020/05/12 15:59] – [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: | ||
- | ====== | + | ====== Import |
==== 1. Leave default options or Select " | ==== 1. Leave default options or Select " | ||
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 | + | * cell delimiter => **;** (semicolon - by default) or **,** (comma - by selecting Advanced options |
- | * text delimiter => " (useful | + | * text delimiter => **"** (double quote). Useful |
- | * Data in rows : Items (by default) or Descriptors | + | * Data in rows : Items (by default) or Descriptors |
- | * Data in columns : Descriptors (by default) or Items | + | * 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 | + | |
**Categoricals values** | **Categoricals values** | ||
- | * Separator between several states => & (eg: blue & green) | + | * Separator between several states => **&** eg: {blue}&{green} |
- | * Categorical states | + | * States |
- | * 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; | + | * min and max values are integer or decimal, eg: **[1;8] or [2.46; |
- | * Into your CSV file the quantitatives values must be enclosed in double quote, eg: " | + | * Into your CSV file the quantitatives values must be enclosed in double quote, eg: **" |
- | * 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 49: | Ligne 49: | ||
" | " | ||
" | " | ||
+ | |||
+ | **Example with Data in rows : Descriptors and Data in columns : Items** | ||
+ | |||
+ | < | ||
+ | ;" | ||
+ | "Body colour";" | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | "Anal plate";" | ||
+ | " | ||
+ | " | ||
+ | </ | ||
==== 3. How to save your CSV file ==== | ==== 3. How to save your CSV file ==== |
csvimport.txt · Dernière modification : 2022/08/31 18:44 de wikiadmin