📃 Export your data in a single Excel file
In a nutshell
This job allows you to export all your items data in a single Excel file, one column per field and one line per item.
📥 Download the latest version of this jobs.
⌛ Time to setup: 5 minutes.
📋 Prerequisites: A Product-Live account with access to the Data Factory platform.
The current version is (last updated on 2023-11-03).
Generic job reference: .
Result
Once setup, a job is available in the Actions menu of your table. Select some items, and click on the job to export your data in a single Excel file. The file is available for download once the execution is complete.
Requirements
To deploy this job, you'll need a valid Product-Live account and an active Data Factory pipeline. If you don't have access to the Data Factory module, please contact our support team.
Setup
Download the last version of this job, available here
Create a new Data Factory variable named . This variable will contain the key of the table you wish to add the export capabilities to
- To learn more about Data Factory variables, please refer to the dedicated documentation
- To access the key of a table, please contact your administrator.
Optional: If the table you wish to add the export capabilities to is a shared table, you will also need to specify the key of the account owning the table in a dedicated variable named
Then simply import the downloaded Data Factory job in your account. Don't forget to make it available on the table of your choice.
Your job is now available in the Actions menu of your table. Select some items, and click on the job to export an Excel file containing all the data of the selected items.
Further information
Job design
The job is composed of 4 tasks, organized in as presented in the following diagram:
- [1]: The Data Factory task used is
table-export-items - [2]: The Data Factory task used is
table-export-schema - [3]: The transformation is done using the
file-transformation-xslttask - [4]: The Excel is created using the
file-generation-xlsxtask
Possible variations
It's possible to customize the job to fit any of your needs. Here are some examples:
- Customize the Excel file to add your own logo, or to change the color of the header
- Directly add a miniaturized image of the product in the Excel file
- Hide some fields from the Excel file
- Drop the Excel file in a specific folder of your Google Drive or a FTP server
If it's your first time using Data Factory, the Get started tutorial is a good place to start. You can also check the Tasks section to learn more about the different tasks available.
Our support team is also available to help you with the setup of your job. Don't hesitate to contact us if you need any assistance.