Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
lobarbag
Contributor
Contributor

Edit data-connections by command

Hello, I have a APP with many data-connections, all are web connections with the same IP and similar pattern. I need to change ocastionally the IP for all of them and if I do it graphically I need to do it one by one. Is there any way to edit them by command  with a replace all option?  (I am using Qlik Sense Destktop)

Thanks in advance

1 Solution

Accepted Solutions
Vu_Nguyen
Employee
Employee

Hi, you can consider one of the following solutions:

  1. Disable Standard reload mode in QlikView. This allows you to load data from URLs directly without having to define webfile connections. Check https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/LoadData/disable-standa...
  2. If you're using Qlik Sense November 2018 or later, you can make only one webfile connection then change URL during runtime using "URL is" keyword. Documentation at https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifi..., example at https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/LoadData/disable-standa... (see under "Loading data from a dynamically created URL")

Both solutions aim to define URL in the reload script instead of webfile connection. With this implemented, you can use replace feature in Data Load Editor to mass-replace the URLs.

Vu Nguyen
If a post helps resolve your issue, please mark the answer as correct.

View solution in original post

1 Reply
Vu_Nguyen
Employee
Employee

Hi, you can consider one of the following solutions:

  1. Disable Standard reload mode in QlikView. This allows you to load data from URLs directly without having to define webfile connections. Check https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/LoadData/disable-standa...
  2. If you're using Qlik Sense November 2018 or later, you can make only one webfile connection then change URL during runtime using "URL is" keyword. Documentation at https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifi..., example at https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/LoadData/disable-standa... (see under "Loading data from a dynamically created URL")

Both solutions aim to define URL in the reload script instead of webfile connection. With this implemented, you can use replace feature in Data Load Editor to mass-replace the URLs.

Vu Nguyen
If a post helps resolve your issue, please mark the answer as correct.