topic Re: How to copy database using trigger in qvw? in QlikView

How to copy database using trigger in qvw?

Tue, 29 Apr 2014 13:02:55 GMT

Hi,

Is there any way to create a trigger in qvw to copy database from one folder to another folder?

I have a access database in D folder. I need to copy the database from D folder to E folder daily. I am doing this manually . Is there any way to automate this using qvw with trigger.

can anyone suggest me please.

Thanks.

Re: How to copy database using trigger in qvw?

its_anandrjs — Tue, 29 Apr 2014 13:05:42 GMT

You can use BAT files for copy database from one folder to another folder.

Re: How to copy database using trigger in qvw?

Tue, 29 Apr 2014 13:07:52 GMT

Thanks. can you post any example path of batch file

suppose I need to copy database from D:\Access\Employee.accdb to E:\newAccess\Employee.accdb

In this case how can I create batch file?

Re: How to copy database using trigger in qvw?

Tue, 29 Apr 2014 13:12:20 GMT

Hi,

I'm using supporting tasks with a powershell script.

QMC -> System -> Supporting Tasks -> External Programs

Regards

Michael

Update:

Script check a folder recursive and copy all qvd from source (chnage at script) to destination (chnage at script). The structure of sub folders will created at destination by the script.

You can define some env vars to use the script for more than one source and destination folders.

example command line

powershell QVD_copy.ps1 \\QlikViewServer\QVData\ DailyBackup

Re: How to copy database using trigger in qvw?

sudeepkm — Tue, 29 Apr 2014 13:12:35 GMT

you can create a bat file with one command like below. Save this file as FileCopy.bat

move D:\Access\Employee.accdb E:\newAccess\Employee.accdb

Then use this bat in your QlikView Script

EXECUTE FileCopy.bat;

Re: How to copy database using trigger in qvw?

Tue, 29 Apr 2014 13:15:49 GMT

Thanks. Can you help me with sample script please.

Re: How to copy database using trigger in qvw?

Tue, 29 Apr 2014 13:17:42 GMT

Thanks. when I am using EXECUTE in qvw it is showing a message like attached. Where I need to give this?

Re: How to copy database using trigger in qvw?

its_anandrjs — Tue, 29 Apr 2014 13:19:38 GMT

Write a BAT file like

Copy D:\Access\Employee.accdb E:\newAccess\Employee.accdb

and save the Bat file as Copy.Bat

and in windows double click on the Copy.Bat or you can write Run Copy.Bat

On command prompt you have to write this.

Re: How to copy database using trigger in qvw?

Tue, 29 Apr 2014 13:25:18 GMT

Thanks. How can I change the above path if I want to copy and replace the existing database?

Re: How to copy database using trigger in qvw?

jerrysvensson — Tue, 29 Apr 2014 14:13:02 GMT

Maybe you should ask someone from IT to help you?

Re: How to copy database using trigger in qvw?

Anonymous — Tue, 29 Apr 2014 20:25:56 GMT

Thats a great idea Jerry-

Hello Amelia- it looks like you need with many steps here. Perhaps you should consult your support rep and your internal IT team for assistance to help expedite this solution.

Best Regards, Sara