archive

[#1]

hi all,

Could you suggest here

step 1

Once the report reloads everyday with new data for ex: from folder 2015.csv>>aug.csv file

Load the data into qvd.

For ex

Customers:

Load * fromm..csv

Products

Load * from ...csv

Store Customers into Customers '$(timestamp).qvd (qvd);
Store Products into Products '$(timestamp).qvd(qvd);

step 2

Check in the specific folder whether the QVD is created and filesize >0

if file size > 0 then

step 3

Delete or  move from the folder to ....some drive

[maxgro]

yes but it's just 1 line

create some file (C:\temp\test*.log)

and run it

[#3]

hi maxgro I got it right ..for me the command should be like this..its working in this way

Execute cmd /C del /Q "filepath\filename";

secondly can u tell me if fileexists is a file with timestamp how can I check for ex: products20151210.csv..so I need to check only that file.. not older files

ex:products20151210.csv..

products20151110.csv..

products20151010.csv..

[maxgro]

let d=date(today()+18, 'YYYYDDMM');     // replace +18 with your logic, which is the date you want to test? today?

trace $(d);

let vQVDExists = if(len(FileSize('c:\temp\Products$(d).qvd')) > 0, -1, 0);

trace $(vQVDExists);

[#5]

maxgro.. just to understand if multiple qvd files in a day

for products then for customers ..etc .can I add in the same below line customers also?

let vQVDExists = if(len(FileSize('c:\temp\Products$(d).qvd')) > 0, -1, 0);

[maxgro]

if you have multiple qvd (or csv) files and you want to check every file

you need to repeat the check (1 for Products, 1 for Customer, etc...........)

to check for Products and Customers of yesterday (if the reload run today)

let d=date(today()-1, 'YYYYDDMM');

let vQVDExistsProducts = if(len(FileSize('c:\temp\Products$(d).qvd')) > 0, -1, 0);          // .qvd or .csv

// .... some code maybe using QVDExistsProducts

let vQVDExistsCustomers = if(len(FileSize('c:\temp\Customers$(d).qvd')) > 0, -1, 0);

// .... some code on Customers file  

[#7]

this is maxgro..thanks

[#8]

this is good maxgro: thanks