Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If you don't want to reload your QVD each time, my solution is working.
Partial reload (stop me if I'm wrong), is a mechanism used to load a QVD (your old data) and then to partialy read our datasource (database, xls, csv...) in order to add only new informations.
But, in your case, you don't want to add information to your QVD, you just don't want to reload it.
So, I explain again because I think it wasn't clear enough but a solution is to use 2 applications:
- Create an application PriceList.QVW
- In the script just load your differents price lists:
load * from $(vQVDPath)BECKHOFF.qvd (qvd);
Concatenate
load * from $(vQVDPath)HAKKO.qvd (qvd);
Concatenate
load * from $(vQVDPath)MITSUBISHI.qvd (qvd);
- Then switch in you main application
- On the first line of your script use the following instructions:
Binary PriceList.QVW ;
So, now, you will be abble to reload only our main application, the price list will be always the same without any reload.
And, if you want to refresh your price list, reload PriceList.QVW before reloading your main application.
Regards,
Vincent
Use Partial reload.
Have a look at Add Or Replace commands which can be used before load statement.
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
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
Adding to Miguel's note, you can set up your variable value depends on your condition in Task itself.
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
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
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
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)
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