Difference between revisions of "Importing the list of clients"
From SimplyBook.me
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | ====How to import clients==== | + | ====How to import clients==== |
| − | :1. Prepare your Excel file. | + | <span style="background-color: #26dd7d; padding:5px; border-radius:5px;">Free custom feature!</span> |
| + | <br><br> | ||
| + | :'''Attention!''' It is forbidden to import a client list with emails and client information where the clients have not specifically granted you the right to do so. | ||
| + | <br> | ||
| + | :'''Please note''' that this feature is available with Standard and Premium subscriptions only(former Advanced, Gold and Platinum).<br> | ||
| + | :It is only possible to import 500 clients by default. If you need to import more please contact support for details. | ||
| + | <br><br> | ||
| + | '''How to use this option:''' | ||
| + | :1. Enable "Import Clients" custom feature on your Custom features page: | ||
| + | [[File:Import clients enable path redesigned.png|1200px | center|link=https://help.simplybook.me/images/5/55/Import_clients_enable_path_redesigned.png]] | ||
| + | <br><br> | ||
| + | :2. Prepare your Excel file. | ||
:- No text above the list of clients should be written | :- No text above the list of clients should be written | ||
:- Make sure all cells are correctly displayed | :- Make sure all cells are correctly displayed | ||
:- Save file in .csv format with comma separation. | :- Save file in .csv format with comma separation. | ||
| − | |||
| − | |||
| − | |||
<br><br> | <br><br> | ||
| − | :3. | + | :3. Go to Manage//Clients//Import from CSV or simply click on "Settings" near this custom feature. |
| − | [[File: | + | [[ File:Import csv file path redesigned.png|1200px | center|link=https://help.simplybook.me/images/c/cb/Import_csv_file_path_redesigned.png]] |
<br><br> | <br><br> | ||
| − | :4. | + | :4. Press "Choose file" and select the prepared file. |
| − | [[File:Import | + | [[File:Import page redesigned.png|1200px| center|link=https://help.simplybook.me/images/0/06/Import_page_redesigned.png]] |
<br><br> | <br><br> | ||
| − | :5. Press " | + | :5. Assign values to the columns from drop-down lists in the upper bar (above each column, marked with black arrows). Assign "name", "email" and "phone".<br> |
| + | :(if you are using [[Special:MyLanguage/Client_Fields_Custom_Feature|Client Fields Custom Feature]] you can also import some of the forms values) | ||
| + | [[File:Assign values to columns import redesigned.png|1200px | center|link=https://help.simplybook.me/images/b/bf/Assign_values_to_columns_import_redesigned.png]] | ||
| + | <br><br> | ||
| + | :6. Press "Confirm clients import". | ||
:''Please note that only 10 clients will be shown in preview, but after you import, all clients will be shown.'' | :''Please note that only 10 clients will be shown in preview, but after you import, all clients will be shown.'' | ||
<br><br> | <br><br> | ||
;If you can't import clients, please check the possible reasons: | ;If you can't import clients, please check the possible reasons: | ||
:1. Format of .csv file is incorrect. It should be saved in .csv with comma or tab separation.<br/> | :1. Format of .csv file is incorrect. It should be saved in .csv with comma or tab separation.<br/> | ||
| − | :2. There is some text above the data that | + | :2. There is some text above the data or unnecessary columns that prevent successful import. Please delete the text.<br/> |
:3. Values are not assigned. Use drop-down menus above the columns to assign values "name", "email", "phone", etc. | :3. Values are not assigned. Use drop-down menus above the columns to assign values "name", "email", "phone", etc. | ||
| + | <br><br> | ||
Latest revision as of 13:34, 13 September 2024
How to import clients
Free custom feature!
- Attention! It is forbidden to import a client list with emails and client information where the clients have not specifically granted you the right to do so.
- Please note that this feature is available with Standard and Premium subscriptions only(former Advanced, Gold and Platinum).
- It is only possible to import 500 clients by default. If you need to import more please contact support for details.
How to use this option:
- 1. Enable "Import Clients" custom feature on your Custom features page:
- 2. Prepare your Excel file.
- - No text above the list of clients should be written
- - Make sure all cells are correctly displayed
- - Save file in .csv format with comma separation.
- 3. Go to Manage//Clients//Import from CSV or simply click on "Settings" near this custom feature.
- 4. Press "Choose file" and select the prepared file.
- 5. Assign values to the columns from drop-down lists in the upper bar (above each column, marked with black arrows). Assign "name", "email" and "phone".
- (if you are using Client Fields Custom Feature you can also import some of the forms values)
- 6. Press "Confirm clients import".
- Please note that only 10 clients will be shown in preview, but after you import, all clients will be shown.
- If you can't import clients, please check the possible reasons
- 1. Format of .csv file is incorrect. It should be saved in .csv with comma or tab separation.
- 2. There is some text above the data or unnecessary columns that prevent successful import. Please delete the text.
- 3. Values are not assigned. Use drop-down menus above the columns to assign values "name", "email", "phone", etc.
