7.3. Export Attribute Terms

fmAttributes

To export attribute terms to a .csv file use the option on the top toolbar. In the right pane of the "Attributes" section you can see the terms list. Use the right-click to open the context menu and choose the necessary command from the drop-down list:

Export Data in Context Menu

or press [Export Data] on the top toolbar to launch the export wizard.

Export data in the top toolbar

1. "File for export"

Firstly, you should specify the filename and path to your exported data. If you want to rewrite the existing file, make sure it is accessible and readable. You can preview it previously on your computer before specifying.

Use the browse button to open drive system and choose required location.

Specify file location

Upload via FTP position helps to transfer your data on the FTP server. It could be possible in case you have FTP access details to fill the fields shown below:

Export data on the FTP

To check your FTP connection credentials go to Settings -> Preferences -> FTP and press [Test Connection] for verification.

FTP connection test button

If you have previously saved export configuration, you can load it to significantly speed up the passage of the following steps of the export. Press the arrow option to open the list with the saved in the wizard configurations

Load configuration from the wizard list

or upload necessary settings from a file, with the arrow option next to the [Open configuration] button:

Open configuration from a file

To move to the next step of the wizard press the [Next] button at the bottom of the page. On the left side, you can see the numbered boxes with the export steps. You have the possibility to go to the step you want without going through all the steps gradually.

The numbered boxes and 'Next' button

2. "CSV delimiter"

This page shows the delimiter character that will be used to separate the fields data. You can select from the basic three types of separators as comma (,), semicolon (;) and tab character ( ), however, you can specify other symbols as well.

Delimiter characters

The checkbox "Quote string values with" serves for indication the character to separate strings in the CSV file. Leave this field unchanged.

Quote string values field

3. "Fields to export"

This page is divided into two panes: the left and the right. The left one consists of all fields that can be exported; the right one - the area, where you should drag the fields you want to export.

Fields to export

Use the options in the middle:

  • To move all fields at once (1)
  • To move only selected fields (2)
  • To move back only selected fields to their previous positions (3)
  • To move back all fields (4)

If you want to add an expression formula to modify your exported data use the option at the top. It opens the Expression Editor form. Press the [Help] button for more details on expression special syntax with provided examples.

Add simple expression formula

To add more complex formula that allows to make changes to your store database tables, use the Custom SQL editor. Note: To perform this action you need some SQL skills.

Add extended expression

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

If the export file should contain the field names in the first row, check the corresponding field at the top toolbar. In other cases, leave it unchecked.

Field Names in the first row

4. "Export options"

On this stepe you can choose a number of records you want to export. Choose "Selected only" if you have already allocated some positions in the attribute terms list before exporting; if you want to transfer all attributes terms to a file, choose "All" records.

Records you would like to be exported

[Show advanced options] opens the form where you can see basic date and time separators.

'Show advanced options' button

They are used to convert a text part of a file to the numerical values and in the date format. You can set the default settings by pressing the relevant option on the right.

Base formats and separators form

Pay attention to the field, which indicates the separator between records - provided a large number of records in one row of the file the data will be automatically transferred to the new line (see ab illustration above).

After pressing the [Export] button you launch the transfer process.

'Export data' button

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

  • "Nothing" - just finish export and close the wizard
  • "Open directory containing result file" - after export completing the directory with the file with exported data will be displayed
  • "Open result file" - it gives the possibility to view the source export file right after the export process

Check the one you want to be performed.

Export methods listing

Note: in order to use current export configuration in the next export processes, save it to the Wizard list or separately to a file.

Use the [Save configuration] option to choose the necessary storage location.

Save export configuration

Click on the [Finish] button to finalize of export and exit from the wizard.