topic Re: How to skip script if directory is empty in App Development

How to skip script if directory is empty

Fred-Zabala — Thu, 04 Nov 2021 03:48:09 GMT

Hi All

I am currently scanning a directory for certain files. How do i skip the rest of the script if it doesn't find any of the following files? Please see below for script. So if it cannot find anything in the (Lease File List), i want it to ignore the call for Documentlist_leases and skip to //SubFileLIst

// Lease file list
sub DoDir (Root)
for each Ext in 'txt', 'xlsx', 'docx', 'pdf', 'msg'

for each File in filelist (Root&'\*.' &Ext)

DocumentsList_Leases:
LOAD
'$(File)' as LeasefullPath,
SubField('$(File)', '\', 6) as PML_SEQ, //return everything after the 5th '\'
Right( '$(File)', Len( '$(File)') - FindOneOf( '$(File)', '\', 6) ) as LeaseFileName
autogenerate 1;

next File

next Ext

for each Dir in dirlist (Root&'\*' )
call DoDir (Dir)
next Dir

end sub

call DoDir ('\\AKL-SQL01.anz.corp.local\IIS_$(vClient)\F_Pm_Lease\')
Call StoreAndDrop('DocumentsList_Leases');

//Sublease file list
sub DoDir (Root)
for each Ext in 'txt', 'xlsx', 'docx', 'pdf'

for each File in filelist (Root&'\*.' &Ext)

DocumentsList_Subleases:
LOAD
'$(File)' as SubleasefullPath,
SubField('$(File)', '\', 6) as F_Pm_Sublease_SEQ, //return everything after the 5th '\'
Right( '$(File)', Len( '$(File)') - FindOneOf( '$(File)', '\', 6) ) as SubleaseFileName
autogenerate 1;

next File

next Ext

for each Dir in dirlist (Root&'\*' )
call DoDir (Dir)
next Dir

end sub

call DoDir ('\\AKL-SQL01.anz.corp.local\IIS_$(vClient)\F_Pm_Sublease\');
Call StoreAndDrop('DocumentsList_Subleases');

Re: How to skip script if directory is empty

rwunderlich — Thu, 04 Nov 2021 05:30:31 GMT

If NoOfRows('DocumentsList_Subleases') > 0 Then

Call StoreAndDrop('DocumentsList_Subleases');

EndIf

-Rob

Re: How to skip script if directory is empty

Fred-Zabala — Thu, 04 Nov 2021 21:03:12 GMT

Thank you! This works a treat!

Re: How to skip script if directory is empty

Fred-Zabala — Sun, 07 Nov 2021 20:24:47 GMT

Hey

Another question. We've pulled massive files from our network already, and its good to re-run the script every now and then so that it gets the latest files. But is there a way to skip files which we already have pulled into the qvd? LIke a skip for it, and only pull the latest ones?

Re: How to skip script if directory is empty

rwunderlich — Mon, 08 Nov 2021 03:20:28 GMT

Just to clarify. You are not actually loading data from those files, you are just building a list of filenames, correct?

-Rob

Re: How to skip script if directory is empty

Fred-Zabala — Mon, 08 Nov 2021 03:23:52 GMT

Yep. Not loading, building a list of filenames.

Basically, filenames will be put into a table, which will create links to said filename. That's all, pulling data from the files themselves

Re: How to skip script if directory is empty

rwunderlich — Mon, 08 Nov 2021 15:59:16 GMT

I can't think of ways to "skip" files that would be any faster than what you are doing. Unless your directories are by date and you could skip entire directories.

-Rob

Re: How to skip script if directory is empty

Fred-Zabala — Wed, 10 Nov 2021 02:31:08 GMT

Unfortunately, all our files our files are not by dates but by actual document name.

I'll see if we can do something about the naming, but thanks for the help on the rest 🙂