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/01/15 13:10] – [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 " | ||
+ | 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 " | ||
==== 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 |
- | * text delimiter => " (useful | + | * text delimiter => **"** (double quote). Useful |
+ | * 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 | + | |
**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 37: | Ligne 41: | ||
" | " | ||
- | ==== 3.How to save your CSV file ==== | + | The same example but with a comma cell delimiter\\ |
+ | **Note** : in this case you need select " | ||
- | Nous suggérons l' | + | < |
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | |||
+ | **Example with Data in rows : Descriptors and Data in columns : Items** | ||
+ | |||
+ | < | ||
+ | ;" | ||
+ | "Body colour";" | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | "Anal plate";" | ||
+ | " | ||
+ | " | ||
+ | </ | ||
+ | |||
+ | ==== 3. How to save your CSV file ==== | ||
+ | |||
+ | We suggest using OpenOffice | ||
* Save your file as csv | * Save your file as csv |
csvimport.txt · Dernière modification : 2022/08/31 18:44 de wikiadmin