Tweet
MT Importer de Mosets Tree
Bonjour
je voudrai importer un fichier csv pour créer un repertoire sous mosets tree, j'ai importer mon fichier csv qui contient des colonne nom-adresse-email-telephone-ect... le fichier est bien importer moi les champs sont vide....
dans la notice il y as une explication mais je ne comprend pas c'est en anglais
je vous la met dessus si quelqu'un peut m'expliqué comment faire pour parametrer mon fichier csv pour qu'il soit visible !!
je vous remercie
David
Step 1: Introduction
This Importer will import all listings from a .csv files. Download a sample and start by adding your listings to the file. Please bear in mind the following when adding listings:
The first line of sample.csv contains the list of column names that map to Moset Tree's database. Only the first column - link_name is compulsory. Other columns are optional and can be safely removed. If you're removing a column, make sure you remove the corresponding values for the listings.
Second line and onwards is where you insert your data. One line for each listing. In sample.csv, the second line is filled with one sample listing.
You may use Microsoft Excel or any other word processor to edit the file. Make sure you do not save the formatting when prompted.
Enter Category ID to the cat_id field. This information can be found when you're browsing the category. If no cat_id is specified, Importer will import the listing to Root category (0). To import a listing to more than one category, specify the category IDs separated by command. ie: "2,6,17"
Enter User ID to the user_id field. This information can be found from your database table called sygfe_users. If no user_id column is specified, the listing will be owned by you (username: dcrenn) by default.
If you want a particular listing to be featured, set link_featured field to 1, otherwise set it to 0.
There is no need to enter link_published or link_approved's value. All imported listings will be published and approved automatically.
If you want to import a particular column to an existing custom field, use the ID of the custom field as the column name. In the sample, the last 2 columns are mapped to custom fields with ID 25 and 26. You can locate these IDs at Custom Fields page.
Any column names that are not mapped to sygfe__mt_links table or a custom field ID will assigned to a new text-based custom field.
If you have multiple values in a column (Checkbox or Multiple select box), separate each values with the bar character. For example - value1|value2|value3
The field separator is comma (,) and the fields should be enclosed by double quote if the values contains comma.
Use the Dry Run option to check if your CSV file is properly formatted. Dry run will scan your CSV file and report any errors if it finds any. Importing using the dry-run option does not write any data to your database.
What this Importer doesn't do:
It does not support importing files or binary based data.
It does not create categories. You have to create the categories first before starting the import.
WARNING: PLEASE BACKUP YOUR DATABASE BEFORE PROCEEDING TO THE NEXT STEP. Although we have done everything possible to minimize the risk of database corruption, accident do happens once a while. Backing up your database is the best protection to this.
je voudrai importer un fichier csv pour créer un repertoire sous mosets tree, j'ai importer mon fichier csv qui contient des colonne nom-adresse-email-telephone-ect... le fichier est bien importer moi les champs sont vide....
dans la notice il y as une explication mais je ne comprend pas c'est en anglais
je vous la met dessus si quelqu'un peut m'expliqué comment faire pour parametrer mon fichier csv pour qu'il soit visible !!je vous remercie
David
Step 1: Introduction
This Importer will import all listings from a .csv files. Download a sample and start by adding your listings to the file. Please bear in mind the following when adding listings:
The first line of sample.csv contains the list of column names that map to Moset Tree's database. Only the first column - link_name is compulsory. Other columns are optional and can be safely removed. If you're removing a column, make sure you remove the corresponding values for the listings.
Second line and onwards is where you insert your data. One line for each listing. In sample.csv, the second line is filled with one sample listing.
You may use Microsoft Excel or any other word processor to edit the file. Make sure you do not save the formatting when prompted.
Enter Category ID to the cat_id field. This information can be found when you're browsing the category. If no cat_id is specified, Importer will import the listing to Root category (0). To import a listing to more than one category, specify the category IDs separated by command. ie: "2,6,17"
Enter User ID to the user_id field. This information can be found from your database table called sygfe_users. If no user_id column is specified, the listing will be owned by you (username: dcrenn) by default.
If you want a particular listing to be featured, set link_featured field to 1, otherwise set it to 0.
There is no need to enter link_published or link_approved's value. All imported listings will be published and approved automatically.
If you want to import a particular column to an existing custom field, use the ID of the custom field as the column name. In the sample, the last 2 columns are mapped to custom fields with ID 25 and 26. You can locate these IDs at Custom Fields page.
Any column names that are not mapped to sygfe__mt_links table or a custom field ID will assigned to a new text-based custom field.
If you have multiple values in a column (Checkbox or Multiple select box), separate each values with the bar character. For example - value1|value2|value3
The field separator is comma (,) and the fields should be enclosed by double quote if the values contains comma.
Use the Dry Run option to check if your CSV file is properly formatted. Dry run will scan your CSV file and report any errors if it finds any. Importing using the dry-run option does not write any data to your database.
What this Importer doesn't do:
It does not support importing files or binary based data.
It does not create categories. You have to create the categories first before starting the import.
WARNING: PLEASE BACKUP YOUR DATABASE BEFORE PROCEEDING TO THE NEXT STEP. Although we have done everything possible to minimize the risk of database corruption, accident do happens once a while. Backing up your database is the best protection to this.
