7.2 Export Attributes
To export attributes to a separate file of CSV format use the option in the top toolbar. Open the Attributes section of Store Manager and press the 'Export Data' tool.
Or use the context menu to find the required command:
The export process will start from the page, where you should specify the file name for your exported data and its location. Use the button with three dots to open the drive system on your computer and select the necessary direction.
If you want to rewrite the existing file make sure it is readable and openable - try to open and preview this file previously. In case you didn't specify the necessary filename it will be created after export automatically.
You have a possibility to place attributes on the FTP server, provided that you have all necessary FTP access details.
Check the correctness of specified credentials by going to the Settings->Preferences->FTP sector of Store Manager. The 'Test connection' button helps to verify FTP connection.
In order to proceed with exporting you should get the following message:
In other case you need to contact with your hosting company to check FTP data.
In the FTP form specify also the FTP directory for your source file. Press the 'browse' button to open the FTP categories tree and find necessary location.
'Load configuration' field below allows to upload and use the previously saved export configuration from wizard list directly or from a separate file .
Press the 'triangle' to open the drop-down list and choose necessary configuration or click on the 'Open configuration' button to select desired configuration file.
To clear the whole configuration list at once - hit the 'triangle' in the 'open configuration' option and choose the appropriate command from a list.
As well as delete the selected configuration by pressing the appropriate button in the same list:
In the wizard form you have numbered steps of export procedure in the left - you can press necessary step here or use the button below which takes you to next page (step) of export.
2. On the following step of export process select delimiter characters for fields data separation. Be sure to check them to ensure proper configuration and accurate attributes exporting.
Generally, use the following delimiter characters as comma (,), semicolon (;) and tab character ( ), however other symbols can be applied as well.
Quote string values - this specifies the character used to separate strings in the CSV file. It is recommended to leave this field checked.
3. The next option moves to the 'Fields to export' step. You have determine what attributes data you want to be exported.
Drag necessary ones in the left side and drop them to the right or use the appropriate buttons in the middle:
- move all fields from the right to the left pane at once (1)
- transfer only selected data from the left to the right side (2)
- move back the displaced fields from right to the left (3)
- reverse all displaced fields to their initial positions (4)
You can find the appropriate options in the context menu as well. Use the right-mouse clicking in each parts of this step (left and right) to open the drop-down options list:
a) context menu of the left pane:
b) context menu of the right pane:
If you need to add some formula for merging columns, replacing/removing data or increasing/decreasing some values during export process use the ‘Add simple expression field’ button which calls the 'Expression Editor form'.
Expression - special formula allows to add the additional information or facilitates the changing of exported data, based upon the application of one or more logical rules, designating what action(s) should be performed on the field values that also may be determined by the evaluation of the expression. Use ‘Help’ button in the top for more details on expression special syntax with provided examples.
To check if the specified formula is workable, press ‘Execute Expression’ button in the top. You should get the result without any errors in the separate window.
‘Insert...’ option helps to choose the corresponding database field values as components of expression formula.
In case you want to customize exported data and use the SQL formula to make the changes in the field's value click on the ‘Add extended expression field’ .
You will call the Custom SQL form and need to have the appropriate SQL skills to create the correct and workable formula.
'The field names in first row, but not values' option should be checked, if the first row of the .csv file contains such data as the column titles or column names:
See the example file provided below:
Otherwise this option can be un-checked.
The next step allows to select the records for exporting. You can export all attributes or just the selected ones depending on the checked position above.
Open the advanced options fields after pressing the button in the right to check the value delimiters which will be used to separate fields data in the export file.
Also check the multiple records separator - delimiter between multiple fields value.
Use the 'Set Default' button to return the default values of these settings.
After pressing 'Export' button will start the process of data transferring from Store Manager to a file that you have specified on the first step of wizard.
On the Preview step you can see the exported data with all configured separators between the fields values from the previous step.
You can see the following actions below:
- just finish exporting and close the wizard - choose ‘Nothing’ action;
- to open the directory with your export file - choose the second action from a list;
- check exported information in a file - select ‘Open result file’ action.
Check one of the listed actions above.
In addition, save current export configuration to be able to use it in the future export process.
Specify configuration name in the appropriate field and press 'Save configuration’ button - export settings will be saved in the wizard directly.
Hit the triangle next to the current option and from the drop-down list choose the 'Save configuration to a file' command - it will be saved separately.
To remove selected configuration from the wizard list or clear all list at once - use the following options from the same list: