5.2 Export Users

fmUsers

To transfer your store customer list to a .csv file use the Export Wizard tool on the Users page of Store Manager. Press the following options:


Export data option


1. The first step of Wizard is the page where you should specify the file name for exported data.


Select file to export step

Check the FTP details firstly by moving to the Preferences of Store Manager-> FTP. 'Test Connection' button helps to verify the specified FTP credentials. You should get the next message to be able to proceed:


Test FTP Connection

If you haven't access to your FTP server - please contact your hosting provider to resolve this issue.


Load configuration field - allows uploading the previously saved export configuration if any.


Upload configuration field


This significantly speeds up the passage of the following steps of the export.


Use the following ways to proceed with export:


Numbered boxes and Next button


2. 'CSV delimiter' page gives an opportunity to choose the appropriate delimiter character and quote string values.

The typical delimiters are the comma (,), semicolon (;) and tab character ( ), however other symbols can be used as well.


Select Delimiter Character

Quote string values - this field specifies the character used to separate strings in the CSV file.

Quote String Values


3. Next step is 'Fields to export'  page that divided into two panes


Two panes select fields to export


Or use the options in the middle  - Drag fields one by one - to transfer fields one by one or - Transfer fields at once - to move them all at once.


And, conversely, to return one by one field to their previous positions in the left press this option - Return fields to their previous positions or bring back all fields at once as well - Return back all fields at once..


To use the expression formula to customize the exported data open the Expression Editor form after clicking on the option at the top. 


Add simple expression formula


Expression helps you to increase/decrease the products price after export, combine some values positions in the appropriate fields of store database, send items in 'Out of Stock' mode automatically provided that their quantity


become '0' and more. Use 'Help' button  in the top for more details on expression special syntax with provided examples.


'Help' button in Expression Editor form

To add the more complex formula that allows to make changes to your store database tables requires some SQL skills and can be done by helping with the Custom SQL editor


To launch the editor form directly from this step of export use the 'Add extended expression field' option.


Add Custom SQL


Check this chapter about the Custom SQL section of Store Manager to better understand its functionality.

If the export file should contain the field names in the first row - check the corresponding field at the top toolbar.

Field Names in the first row

In other case leave it un-checked.

4. Export Options step - here you can choose a number of records you want to export:


Select records for exporting


And also check the multiple records separator  - delimiter between multiple fields value.


Check the field with multiple records separator


You can press the 'Set Default' option to recover the default settings.


'Set Default' option


After pressing 'Export' button you start transferring your data.


5. On the export results step you can see the following actions below:


After export actions


Check the one you want to be performed.


Do not forget, in order to use the current export configuration during the next export processes, to save it to the Wizard list or to a separate file. 


Use the 'Save configuration' option to choose the necessary storage location.


Save configuration option


If you have any unused or inactive configurations you can remove them from the wizard list by using the 'Delete configuration' option . To clear all configurations export list at once - press 'Clear list' command.


Delete and Clear Options


Hit 'Finish' to exit from the Wizard . Your data have been exported.  


By eMagicOne Inc.


Comments