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édenteProchaine révisionLes deux révisions suivantes | ||
csvimport [2020/05/06 13:39] – [2. To build your csv file, please maximum respect the options default as following :] sylvain | csvimport [2020/05/12 16:03] – [2. To build your csv file, please maximum respect the options default as following :] sylvain | ||
---|---|---|---|
Ligne 8: | Ligne 8: | ||
* 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 only if a semicolon (;) is present into a cell, usually present for the numerical values, in any case you can 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: | ||
" | " | ||
" | " | ||
+ | |||
+ | **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