How to tell QV don't need to reload some of my QVD file ?

[#1]

Hi All

I have a QV doc , i want to add a command before the QVD file , so that QV will not load those QVD file. and when i want to reload , i just need to remark the line of code , so QV will load the QVD , which is the command ?

Because those QVD are price list , it don't change often.

Paul

[CELAMBARASAN]

Use Partial reload.

Have a look at Add Or Replace commands which can be used before load statement.

[vincent_ardiet]

Hi,

You can create a first application (exemple PRICELIST.QVW) which only loads your price list.

Then your main application will starts (first instruction) with a BINARY calling the PRICELIST.QVW.

So, when you want to reload your price list, you just reload the content of PRICELIST.QVW, then your main application.

Regards,

Vincent

[Miguel_Angel_Baeyens]

Hi Paul,

Use a conditional in the script, like the following example:

LET vLoadQVDFiles = 0; // change only when you want to reload

IF $(vLoadQVDFiles) = 1 THEN

Data:
LOAD *
FROM PriceData.qvd (qvd);

END IF

// Rest of the script goes here

Hope that helps.

Miguel

[gainkarthi]

Adding to Miguel's note, you can set up your variable value depends on your condition in Task itself.

[rajeshvaswani77]

Further to Miguel's note. You can check if it is 1st of a month or any such criteria and reload only on that day, as your design permits. If the pricelist is an excel file or a physical file you could check the date tiem stamp of teh file to reload it only when it changes.

thanks,

Rajesh Vaswani

[#7]

Hi Raj

I try Miguel approach , i manage to set 1 or 0 to control reload QVD.

The minute i stop reload the price data are missing from my QV doc.

what i need is retent or keep the data on QVW file . any idea how to achieve ?

Paul

[rajeshvaswani77]

I assume that you are doing  change in teh QVD Loader and not in the dashboard. So the QVD once generated would remain intact. The dashboard would however read all the QVD files. Just that it reads the old file for Price List. Bottomline is you will read all QVD files in the dashboard level however when you read pricelist data source you will create the QVD conditionally. Hope it helps.

Thanks,

Rajesh Vaswani

[CELAMBARASAN]

Hi,

Yes Miguels Approach says that to not load the Price data.

If you need the data without loading the qvd then you should go with partial reload.

For you case

Have Replace keyword before the load statement for all the tables except PriceData.

And do PartialReload(Ctrl+Shift+R)

[#10]

Hi Celam

you understood my issue very well.

Replace

PRICE:

load * from $(vQVDPath)BECKHOFF.qvd (qvd);

Concatenate

load * from $(vQVDPath)HAKKO.qvd (qvd);

Concatenate

load * from $(vQVDPath)MITSUBISHI.qvd (qvd);

But i try the above it does not work. because it still load all the above 3 QVD. i cannot use Add . i think i don't understand what is partial load.

Paul