Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team ,
I have 12 files like AssetTrackingAug1.xlsx , AssetTrackingSep1.xlsx , AssetTrackingOct1.xlsx ,etc .
1. I want to load this dynamically and save it into QVD.
2. if AssetTrackingAug1.xlsx file modified later then this should pickup for loading
Thanks
Vikas
Does Any one have solution for this ??
Vikas
There are two script functions that may be useful:
Compare the two for all files matching a file name pattern (e.g. AsseTracking????.xlsx) and reload the Excel files that are newer than your QVD. You can use a FOR EACH loop to do that.
Best,
Peter
Idea is good , searching for code.
Thanks
Vikas
can you help me in build this code ?
Hi Vikas,
Please find the attachment. It might be helpful.
Note:
For each file the sheet name is consistent. based on this assumption, In October file, I changed the Sheet name.
Thanks,
Pradeep
Hi Vikas,
Please find the attached QVW file.
Open QVW file and go to script,
Replace the Excel file path and QVD path with your actual path (Variables are created in Main Tab)
I have divided scripts in Three parts
1 Tab - Load all excel file Code. This is first part of the code which will create the QVD file for all the excel files currently available in folder.
Note- You should comment this code once QVD is created to check the New or updated file on next reload.
2 Tab - Code to check if any New file is arrived in folder. If new file is arrived it will load Only New file and will Overwrite the existing QVD with New file data.
3 Tab - Code to check if existing file is update or not using Filetime() function. If file is updated it will load only updated file and will overwrite the existing QVD with updated data.
I hope this will help.
Hi Vikas,
Please find the updated application which works for me with the scenario I have mentioned in my above post
Thanks Kush !!
For third part it is taking to much time , can we have timestamps logic with file. if file time is changed then delete records from qvd and take whole new file into qvd.
Vikas