Note: This article can also be used to configure destinations in Vizlib Input Form.
Vizlib Writeback Table can be set up to use a range of data sources, and we're going to show you the setup options for QVD/CSV/TXT files to be used with Destinations. Data sources can be configured in the Vizlib Management Console (VMC) when they have been added to your Qlik Sense Environment. Using a VMC Configuration with data files means you can take advantage of Vizlib Server functionality to manage the data source.
Note on Destinations: While destinations can be set up in Vizlib Writeback Table without a VMC configuration, we recommend it is used only for small-scale data sets or use cases (e.g. a pilot for a project). You can find instructions on configuring destinations here.
TABLE OF CONTENTS
- Before you Start - Checklist
- Adding a Destination
- Adding Writeback Settings
- Working with Vizlib Writeback Table - Data Load Updates
Before you Start - Checklist
Before you start, you'll need to make sure you have all the information and permissions you need. Work through all the items in this list and then you'll be ready.
- VMC login / Password - to create and configure the destination. The VMC is installed as part of Vizlib Server.
- Writeback Operation / Reload Option - for configuring Writeback settings.
- Data Source name - to enter when you're adding the integration.
- File Type - choose the type of file you want to use from QVD, CSV or TXT. You can also specify a file path as an optional field.
- App name (Optional)- a writeback reload option. Refers to the app you want to reload after a writeback operation is completed. You can create a new app, or re-configure an existing one.
- Task (Optional) - a writeback reload option. Refers to the task (reload) you want to start after a writeback operation is completed. Tasks can be created and stored in the Qlik Management Console (QMC).
- Security Rule - to set up secure access for a destination, a security rule should be configured in the VMC. See our article here for more information on setting up a security rule.
Adding a Destination
Now, you'll need to add a Destination, which is the data source for your Writeback table. You can find our more about destination types in our article here.
- In the VMC menu, click on Writeback Settings, then Destinations and Security. If you've already added any destinations you should see them displayed on the page (Figure 1).
Figure 1: Destinations
- Click Add Destination and you'll create a new entry. Click on the destination ID to add your destination data.
Check: Your destination will already have an ID which is generated from the last entry in the table. You'll be able to change this in the next step.
Figure 2: Destination Settings
Check: Destination ID has to be a unique value, or you won't be allowed to save your changes.
Figure 3: Writeback Settings
n the Destination Settings panel .
Figure 4: Destination Settings
Figure 5: Using Tags
When you're using dynamic QVDs, you'll create a new file with each new writeback operation, so you can choose to vary the default destination settings.
- When a new file is created, a dialog appears to confirm the file action. If you activate Disable new file confirmation the file confirmation dialog won't be shown with every writeback.
- Disable auto-lock will turn off the auto-lock function, as data is not loaded back into the app when a new file is created with every writeback.
Check: The field name must match the writeback operation field name, or you'll return an error.
- Click Add Destination to save the destination in the VMC.
Now, you need to go to Vizlib Writeback Table and configure your app to write back to the destination. You'll find these settings in the property panel under Destinations.
- Open your Qlik Sense Hub and find the Vizlib Writeback Table sheet you'd like to work with.
- Open the sheet in Edit mode, then go to Writeback Settings > Destinations in the property panel.
- Click on Vizlib Server in Pick Destination (Figure 9).
Figure 9: QVD/CSV/TXT Destination
Working with Vizlib Writeback Table - Data Load Updates
Now you've completed the setup, you will need to update your data load script to make sure data is loaded correctly back into the app. Otherwise it will look like the operation isn't completing.
The data load script is part of the Qlik Sense environment, you can find out more about editing the data load script in a Qlik Sense app here.
Tip: Use * to specify all columns in the table should be loaded. This is especially useful when you expect the content of the table to change (e.g. by adding new columns).
When you complete these steps, the table will be loaded back into the app correctly and you can start to use Vizlib Writeback Table to help make the most of your analytics solution.