Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Auto reload multiple files

Dear community,

Im new on this comunnity so i excuse me if im posting this topic on the wrong place.

After searching for answers in this community i couldnt find the perfect solution for my problem.

First of all i will introduce my self.

As a student from Business IT and Management i am doing a internship in a small company in Holland.


My research was to find out the best solution to transform all available data from the different installations (machines) to management information.


After analyzing the different possibility's i recommended Qlikview.


A few months later i got Qlikview running in this company getting all the needed information out of the different databases from the different machines.

This by using different QVW, models and accespoints.

Because were still in the research phase we decided to buy 2 desktop licenses   of Qlikview without the Qlikview server.

(When this project is a success we will buy the server software. )

For an example we got 18 machines with different data with different databases.

To extract the data and make the data standard ( some machines use different measures ( m3, cm3 , kWh, mWh et) ) i made a workbook for each machines. These workbooks extract all the data and put the tables in QVD files. These files are named workbooks (name of machine)

This i called step 1.

Step 2 is a QVW file that loads all of the different QVD files from step 1 and adding word ,excell and text file data. The file is named Model

Step 3 is the file where all my tables , graphics , grahps are in.  This file loads the data from the Step 2 and is used for making the wanted management reports. This file is named accespoint

All above this is working good.

------------------------------------------------

Now my problem. The data needs to be reloaded out of the databases every night around 00:00 o clock.

The QVW and QVD files are all on a network disk in a windows network server accessible for the 2 computers with the license.

I managed to reload the Model perfectly using windows scheduler and the needed command.

(C:\Users\zouta1\Desktop\qv.exe" /R "Q:\Appsdata\Qlikview\file .... ( though only when my pc is online so i did not manage to schedule on the server but thats another problem :-) )

But to get all the information all the workbook QVW from step 1 need to be reloaded . When this is done the model and after that the accespoint. 

Do i need to create 21 windows scheduler taks for each file to reload or is there another solution where in example all the workbooks are loaded in 1 command then the model and then accespoint ( in that order) .

In research i found a batch file could be made but i have no idea if its possible that there are multiple commands in 1 file.

Or maby a qlikview file is the solution?

Keep in mind im not a IT specialist!

Im very curious what youre solutions are!

Thank you in advance

Arjen Zoutewelle

1 Solution

Accepted Solutions
jsn
Honored Contributor

Re: Auto reload multiple files

Hi,

It sounds like you could put a "chain" of qv.exe /r document.qvw commands in a .bat file and then schedule that batch file to run instead of running each reload as a separate windows scheduled task.

I think... that it will finish one reload before moving to the next line in the batch file.

3 Replies
jsn
Honored Contributor

Re: Auto reload multiple files

Hi,

It sounds like you could put a "chain" of qv.exe /r document.qvw commands in a .bat file and then schedule that batch file to run instead of running each reload as a separate windows scheduled task.

I think... that it will finish one reload before moving to the next line in the batch file.

Not applicable

Re: Auto reload multiple files

Hello!

Thank you for the reply.

Im going to test it out now if the do the reload in the correct order and if the reloading waits till the previos file is done reloading.

Thats important because in order for my set up to work. First the workbooks need to be loaded so they created QVD files.. then the model needs to be loaded to import these qvd files :-)

Greets Arjen

Not applicable

Re: Auto reload multiple files

Oke ,

The bat files do order up correctly and reloading the files perfectly. Only 1 error becauses i named a file Chassé and but it doenst reconize the é and transform it to ú .

but for the rest its going fine

will keep you updated

Community Browser