Scheduling a QV script

[#1]

Hey Members,

I have a QV script from which I daily import data. I want to schedule this task Please help me out with these simple things.

1. How to automatically update the file from which QV takes the data.

This is how it shows in script –

FROM

(txt, embedded labels);

I need it to update the date automatically so it can take the latest file.

2. After this need it to reload

3. Export the file into .csv format in some folder.

Do I need to make a BAT file to schedule it?? Or is this possible to schedule it from QV?? I do see an option of schedules in Document Properties.

I am very new in QV with very less background of coding. Your help will be much appreciated.

[#2]

That is how I am currently doing it, I was trying to automate this process.

[Peter_Cammaert]

Facts:

LOAD VariousFields

FROM YourSourceFile (options)

WHERE CompanyID = 'Company1';

You could (optionally) define an INPUT BOX in your User Interface, attach it to a variable (let's call it vCompanyToStore) and enter the company name to store during reload. The WHERE clause then becomes:

:

WHERE CompanyID = '$(vCompanyToStore)';

Peter