Writeback

The Writeback Extension allows users to seamlessly write or edit data within Qlik Sense applications, text files (.csv, .txt), and database connections, facilitating a more dynamic and comprehensive data management experience. This guide provides an overview of the key features and available actions.

Features

• Seamless Data Writeback: Allows direct data writing or editing within Qlik Sense applications to files or databases.
• Multiple Destination Options: Supports writing to both file-based destinations (CSV, TXT) and various databases (Oracle, MySQL, SQL Server, etc.).
• Flexible Column Selection: Enables selection of existing data model columns or creation of custom input columns for writeback.
• Customizable Data Storage: Defines specific columns to be added in the destination and supports multiple destination configurations.
• Configurable Action Triggers: Allows setting up triggers for success or failure, including email notifications and app refreshes.

Accessing Line Extension

1. Open Qlik Sense Application: Launch your Qlik Sense application where you want to work with the Line Table.
2. Enter Edit Mode: Navigate to the sheet or create a new sheet where you plan to use the Sheet Controller. Enter the edit mode to make changes to the sheet.
3. Access Custom Objects: In the left panel, click on "Custom Objects" to open the custom objects menu.
4. Select SenseOps Extension: Locate and select "SenseOps" from the custom objects menu.
5. Add SenseOps Line Object: Find the "SenseOps Line Object" extension within the SenseOps category. Click and hold the Line Object, then drag and drop it onto the sheet canvas.

After completing the above steps, to access Writeback settings, click on the highlighted icon or click settings in the property panel as shown in the image below.

Writeback configuration

Follow these four steps to configure Writeback:

1. Destination Selection

• Select the destination to store the file. Choose from file-based, database, or REST API destinations.
• For file-based: Specify the file location, file name, and file type (e.g., CSV, QVD, Text). Check the custom file location if you want to input the location.
• For database: Select from supported databases like Oracle, Postgres, MySQL, MariaDB, SQLite, and SQL Server. Specify the table name for the destination. (Coming soon)
• For REST API: Select files from REST APIs. (Coming soon)
• Select the Action either to Upload, Insert, or Delete. Then click Next for further steps.

2. Define Columns

In the Writeback extension, the "Columns" section allows users to define the data structure for the writeback operation. This section offers flexibility in selecting columns from the existing data model or defining custom input columns according to specific data requirements.

• If the columns page is empty, click (+) Add column.

• Select either Select existing to add columns from existing data or Create custom to create new columns.

Existing Data Model Columns:

• Users can select columns directly from the existing data model within Qlik Sense, typically dimensions, measures, or other fields already present in the app's data model.

Custom Input Columns:

• Alternatively, users have the option to define custom input columns based on their data input needs. These custom columns enable users to specify additional data fields or parameters relevant to their writeback operation.
• Data types for custom input columns can include dropdown selections, checkboxes, review ratings, and other value types as needed.
• Click on Add columns to add to the columns list.

• Users can add extra columns, edit the column names, hide the visibility, or delete the column after adding it to the list.

3. Define Storage

• Specify columns to be added in the destination. Optionally, add additional destinations and assign columns to each destination.
• Add table: Users can add multiple tables to the source.
• Key: Users should select a unique ID as a key for respective tables.
• Available columns: Users can add these columns to the tables.
• Audit Columns: By selecting Audit columns, users automatically add CreatedBy and CreatedAt to the source.
• After all selections, click on Next to move to the next step.

4. Trigger Actions

• Configure triggers for actions upon success or failure.
• Create actions that will activate depending on the success or failure of the modifications performed in the source.
• Trigger types include Qlik Actions for app refreshes.

• Once all the above steps are completed, click on Save and view the writeback table.

Properties of Line Extension

Appearance

This section allows the user to configure the alignment of the line.

Table Properties

Settings	Functionality
Show overall title	Allows the user to add the title for the overall table by checking.
Customize title	Allows the user to customize the title height, background color, font size, font color, and other font styles.
Show Column header	Allows the user to show or hide the column names.
Custom Column header	(check Show column header) Allows the user to customize the column name styles.
Freeze first column	Allows the user to freeze or scroll the first column.
Highlight Edited data	Allows the user to edit the background color and font color of highlighted data.
Show Strips	Allows the user to show or hide the strips for table rows with customized background color and font color.

Pagination

Settings	Functionality
Show Pagination	Allows the user to show or hide the page numbers.
Rows per page	Allows the user to select the number of rows per page.
Customize colors	Allows the user to customize text color, active color, and inactive color.
Custom styles	Allows the user to customize text styles.
Custom footer	Allows the user to customize footer height and background color.

Actions

Default actions available are Add row and Save.

Settings	Functionality
Actions	Allows the user to add multiple actions in the table.
Position	Allows the user to position the actions at the top or bottom of the table.

Quick video - How to use the SenseOps Writeback ?

The short video below will explain how to utilize the Writeback in Qlik Sense.