Skip to content

Full Implementation

Jump to bottom
newmans99 edited this page Aug 29, 2017 · 8 revisions

Description

The instructions below contain the complete implementation instructions. If you have already implemented the Basic Installation from the README file, then skip to the Advanced Installation section below.

Basic Installation

These steps will get you started quickly to explore the Multilingual Sampler application. After implementing this, you may want to consider implementing the Advanced Installation so that you can update/modify the strings and/or use the test users for testing user language preference settings.

Requirements

  • Qlik Sense Server (or Desktop) Sept/2017 Release or higher.
  • Access to QMC, to upload helper widgets and modify connection string.

Steps

  1. Download the Sampler Repository ZIP file
  2. Unzip the contents to a directory accessible to QMC or Desktop.
  3. Import Qlik Sense application & widget from zip file using one of the methods below.

Method 1: Qlik Sense Server -

  1. From QMC: Apps -> Import - "Your_Unzip_Path\app\Multilingual & Multi Tenant-Department Sampler.qvf"
  2. From QMC: Extensions -> Import - "Your_Unzip_Path\app\LanguageHelperWidgets.zip"

Method 2: Qlik Sense Desktop -
NOTE: You will not be able to implement the user language preferences testing steps using Qlik Sense Desktop.

  1. Copy "Your_Unzip_Path\app\Multilingual & Multi Tenant-Department Sampler.qvf" to "\Documents\Qlik\Sense\Apps"
  2. Unzip "Your_Unzip_Path\app\LanguageHelperWidgets.zip" to "\Documents\Qlik\Sense\Extensions"
  3. Restart Qlik Sense Desktop (if necessary).

Advanced Installation

There are two optional steps to have a full implementation of this sampler, these steps enable you to update the language strings as well as test user language preferences using groups (Qlik Sense Server ONLY). Please follow either (or both) of these steps to complete your implementation of this sampler.

Data Source Connection

This implementation step allows you to update the application with new language strings as well as add data to the application (including data translations).

Requirements

  • Qlik Sense Server (or Desktop) Sept/2017 Release or higher.
  • Access to QMC, to update modify connection string.
  • Already completed the Basic Implementation steps.

Steps

  1. From Qlik Sense Hub > My Work, Open the "Multilingual & Multi Tenant-Department Sampler"
  2. Using the Navigation Menu, select "Data Load Editor" to edit the Load Script
  3. Create a new connection named "MLRoot", Type > "Folder", Path > "Your_Unzip_Path" (NOTE: You should see the subfolders app, data, strings).
  4. After adding the connection, IF your connection is named "MLRoot (user)", instead of "MLRoot". Edit the connection in QMC > Data Connections to be just "MLRoot" and owned by one of the INTERNAL users. You will need to reload you Load Script Editor window.
  5. Test your connection by RELOADing the application from the Load Script Editor.

Test User Preferences

This implementation step allows you to assign groups to a user profile so that you can test logging in as different users.

Requirements

  • Qlik Sense Server (does not work with Desktop) Sept/2017 Release or higher.
  • Access to QMC, to update modify User Directory Connectors.
  • Already completed the Basic Implementation steps.
  • Microsoft Excel 64bit ODBC Driver Installed Download.

Steps

Setup Qlik Sense UDC:

  1. From Qlik Sense QMC > User directory connectors...
  2. Create New Connector, Type = Excel (ODBC)
  3. NAME: "Excel UDC"
  4. SYNC USER DATA FOR EXISTING USERS - Uncheck
  5. USER DIRECTORY NAME: [Provide your user directory name] - Check out "QMC > Users" to see what yours is
  6. USER TABLE NAME: [Users$]
  7. ATTRIBUTES TABLE NAME: [Attributes$]
  8. VISIBLE CONNECTION STRING: DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=Your_Unzip_Path\data\UsersUDC.xlsx
  9. Press Apply

Setup Users:

  1. In Excel, open the "Your_Unzip_Path\data\UsersUDC.xlsx"
  2. In Windows, use "Local Users and Groups" application to add users.
  3. Create a new user, for each user in the Excel file (suggestion: make password as as userid for testing purposes). Make sure to uncheck "must change password", and check "password never expires".

Update and publish application:

  1. Using your favorite text editor, open "Your_Unzip_Path\app\loadscripts\SECTION_ACCESS.qvs"
  2. Comment out the following lines: 52, 53
  3. Uncomment out the following lines: 55, 68
  4. Save the file.
  5. From Qlik Sense Hub > My Work, Open the "Multilingual & Multi Tenant-Department Sampler"
  6. Using the Navigation Menu, select "Data Load Editor" to edit the Load Script
  7. Reload application
  8. From Qlik Sense QMC > Apps...
  9. Publish the "Multilingual & Multi Tenant-Department Sampler" app to a stream available to your users (probably Everyone).

Test Setup:

  1. Open your Qlik Sense URL
  2. Log in as each user created above
  3. From the Stream, open the "Multilingual & Multi Tenant-Department Sampler"
  4. Navigate to the first sheet and see that it is in the user's preferred language.

Troubleshooting

Common problems and resolutions that others have encountered. If you do not see your problem, please raise an Issue.

  • None known at this time.
Clone this wiki locally