How to export data

Overview

This tutorial is designed to help you create an "Export to" interaction for your Avonni Data Table. This interaction enables users to export entire data sets or selected data rows in Excel or CSV file formats.

Steps to Create an "Export to" Interaction

1

Create a Header action on the Data Table

Let's place an action button directly in the Data Table's header to handle data exports. We'll create an "Export" button that allows users to download the table content as an Excel or CSV file. This action is configured to be context-aware: it exports only the specific rows the user has selected. However, if no rows are selected, it exports all the data currently displayed in the table.

2

Create the interaction from the interaction panel

To set up the data export triggered by the action element you created, follow these steps in the Interaction Panel:

1. Go to the Interaction Panel: Look for the interaction options.

2. Choose Target: Select the action you created in Step 1 from the dropdown list.

3. Set Type to 'Export To': This enables the data export feature.

4. Default File Name: Enter a pre-filled name for the exported file, which users can change later. Select "Mapped" from the icon menu for dynamic file naming and choose one of your flow resources. This allows the file name to be generated dynamically based on your selected resource.

5. Optional - Simplify Export: To speed things up, you can hide the export dialog, limiting user choices on file format and encoding.

6. File Format: Pick the formats, like Excel or CSV, that are available for export.

7. Default Encoding: Choose a standard encoding to ensure the file works well with most software.

Wrap-Up

Following this straightforward guide, you've added an "Export to" feature to your Avonni Data Table. This enhances usability by enabling users to easily export data for analysis, sharing, or archiving beyond the confines of your application.