Do you frequently need to export the same data? Would you like to create an export profile to reuse it?
Keep reading and we'll explain how to do it!
In the Data flow menu, select Profiles.
Click on the New profile button:
Complete informations:
Name.
Description.
Object type.
Product type.
Languages.
Export with inherited columns: If the inheritance of languages has been set up and the data is not entered in the export locale, then the data will be exported with the inherited content.
Once the profile has been saved, the options for Languages, Object Type, Product Type and File Format can no longer be changed.
Select the export File format:
XLSX, To export .xlsx files, the standard settings are used. You do not need to specify any settings.
CSV standard (The default settings are used. You do not need to specify any parameters.)
or custom (You must specify the following settings (you can click the ‘Fill with default values’ button to automatically select the default settings)).
Filters (optional): this section allows you to specify filters for the data to be exported. Two options are available:
No filter (default): All data of the selected object type is exported without any filtering.
Advanced filters.
The ‘Filter’ feature is only available for ‘product’ objects. It is experimental and is only recommended for advanced users with knowledge of JSON.
Quable does not currently provide support for its use.
Joins (optional), which allow you to export all the information for the product type selected previously, as well as all the information from its linked object files (Assets, Variants and child product types).
You can only attach files of child object types corresponding to the selected product type.
You can select up to 3 object types to attach.
‘Multi-level’ joins are not currently available.
If you select this option, the mapping option will no longer be available.
If you select this option, your file will be limited to 500,000 rows.
Mapping (optional). If you or your recipient do not wish to export all the available columns, or if you wish to choose the column names in the file, you will need to use mapping.
Drag and drop attributes in the desired order of appearance:
Modify columns names if needed:
When mapping is enabled, only the mapped columns are taken into account and exported.
Finally, click the Create button. The profile is immediately added to the list on the Profiles page.
From the Profiles page, you'll be able to modify the profile or launch an export.
To learn more, consult our online documentation: Export profiles
Key words: export, document, product sheet, media, asset, file, url, excel, csv, server, FTP, profile, template