Difference between revisions of "Importing the list of clients"

From SimplyBook.me
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
====How to import clients====
+
====How to import clients====  
 +
<span style="background-color: #26dd7d; padding:5px; border-radius:5px;">Free custom feature!</span>
 
<br><br>
 
<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:
 
:1. Enable "Import Clients" custom feature on your Custom features page:
[[File:Import clients plugin enable.png | center]]
+
[[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>
 
<br><br>
 
:2. Prepare your Excel file.  
 
:2. Prepare your Excel file.  
Line 9: Line 16:
 
:- Save file in .csv format with comma separation.
 
:- Save file in .csv format with comma separation.
 
<br><br>
 
<br><br>
:3. Go to Manage//Clients//Import from CSV.  
+
:3. Go to Manage//Clients//Import from CSV or simply click on "Settings" near this custom feature.  
[[ File:Import clients2.png| center]]
+
[[ 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. Press "Choose file" and select the prepared file.
 
:4. Press "Choose file" and select the prepared file.
[[File:Choose file.png| center]]
+
[[File:Import page redesigned.png|1200px| center|link=https://help.simplybook.me/images/0/06/Import_page_redesigned.png]]
 
<br><br>
 
<br><br>
: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".
+
: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>
[[File:Import clients file2.png| center]]
+
:(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>
 
<br><br>
:6. Press "confirm import".  
+
: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 prevents successful import. Please delete the text.<br/>
+
: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>
 
<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:
Import clients enable path redesigned.png



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.
Import csv file path redesigned.png



4. Press "Choose file" and select the prepared file.
Import page redesigned.png



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)
Assign values to columns import redesigned.png



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.