Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

sudeepkm
Valued Contributor III

Removing text and other files from NAS/SAN while Publisher auto reloads

Hi All,

We have a requirement to remove files from the data sources folder (NAS/SAN) after the data is imported from the files to the QVW.

From one of the previous posts I found the given below command to remove files from our shared file server (NAS/SAN).

1. EXECUTE cmd.exe /c del abc.txt; and

2. Enable: User Preference > Security >  Script (allow Database Write and Execute statements)

This command works fine in my local system but when I tried to execute it from Publisher using manual/auto reload the files didn't get removed and I also didn't see any error message in the logs.

Given below is little bit about our environment setup.

1. Single Publisher on a dedicated machine

2. NAS/SAN is attached to Publisher through network

3. QVWs and data files are posted to NAS/SAN.

Kindly provide suggestions. Thanks in advance.

3 Replies
sudeepkm
Valued Contributor III

Re: Removing text and other files from NAS/SAN while Publisher auto reloads

Can anybody suggest please ?

Not applicable

Re: Removing text and other files from NAS/SAN while Publisher auto reloads

Hi Sudeep, If you are using QV 1 version publisher, you don't need any these in the Qlikview script.

Create the Batch file to delete the files from SAN/NAS.

Create the QV task normally in the Publisher.

Go to QEMC --> System --> Supporting Tasks --> External Commands

QEMC_External.JPG.jpg

Add the Batch file execution after successful of QV publisher Task.

sudeepkm
Valued Contributor III

Re: Removing text and other files from NAS/SAN while Publisher auto reloads

thanks a lot for your response, let me try it in our environment.

Community Browser