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/01/15 13:08] – [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 2: | Ligne 2: | ||
==== 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 only if a semi-colon | + | * text delimiter => " (useful only if a semicolon |
+ | * 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 37: | Ligne 41: | ||
" | " | ||
- | ** 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' | + | < |
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
- | * Save your as csv | + | **Example with Data in rows : Descriptors and Data in columns : Items** |
- | * Select "Edit filter settings" | + | |
+ | < | ||
+ | ;" | ||
+ | "Body colour";" | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | "Anal plate";" | ||
+ | " | ||
+ | " | ||
+ | </ | ||
+ | |||
+ | ==== 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" | ||
{{ : | {{ : | ||
- | * Select the parameters as below. **The UTF8 character set is recommended** particularly in the case of accented characters such as French or Spanish | + | |
{{ : | {{ : |
csvimport.txt · Dernière modification : 2022/08/31 18:44 de wikiadmin