I have a script where files need to be loaded one at a time. the daily file which imports compares to the data in the qvd and overwrites with the latest where the invoice no exists.
On a daily basis this is fine and working well with the file being moved to a done folder after the load.
I have an issue and all files need to be reloaded. i am looking at 15seconds per load for 8 months of files for 11 qv projects, one per site
Does anyone know of a scripting method that will load one file, save and then load the next file to save me hours of manual loading?
I would try to create a bucle that does the needed logic for each file in a bucle, using DROP Table and STORE where necesary to simulate the needed logic
for each File in filelist ('Path\*.*')
...// do stuff
next
I would try to create a bucle that does the needed logic for each file in a bucle, using DROP Table and STORE where necesary to simulate the needed logic
for each File in filelist ('Path\*.*')
...// do stuff
next
