Copy last file of fileset

Automise Discussion
1

Hi, i have a little problem here...

i try to copy the latest file of a directory with a specific name so i do it that way:

FileSet : Lists all Files that match for example 20080705*.pdf

The Number is the Date and the rest is the Time so the last file is also the latest and thats what i need to copy. I use a Script at the AfterAction:

GetLatestFileCount = PDFS.Count -1
GetLatestFile = PDFS.File(GetLatestFileCount)

PDFS is the FileSet.

After that i use the Copy Action with GetLatestFile as source. But when the FileSet is Empty it gets an Error in the FileSet Script with ListIndex out of bounds. I tried to change the FileSet Script:

if PDFS.Count = 0 then GetLatestFileCount = 0 else GetLatestFileCount = PDFS.Count -1
GetLatestFile = PDFS.File(GetLatestFileCount)

But that wont work, its allways ListIndex is out of bounds.

I dont know VB very well as you can imagine and i hope someone can help here...

regards

Matthias

2

Hi Matthias,

One way to do this would be to turn on “Fail if no files found” and “Ignore failure”, and then your VB code only has to handle the case when there is actually a file.

Another solution that involves very little scripting (always a good thing in my book) would be to:

- FileSet Define [Sorted by filedate, descending]
- Iterate Fileset [with “Action.Reset” in the OnAfterEachIteration script event]
------ Do the copy here [this will only get called if at least one file found, and only for the first (most recent) file]
- Something else here

hth.
.t8

3

Hi Tate,

i have done the first solution now and it works, i know that the problem was the StringList PDFS.File.
But i will move to the second solution tomorrow couse i dont like to ignore failures.

Thank you very much for your help.

Greetings

Matthias

4

Hi Tate,

long time ago and i have to review the script.
I tried to do the second solution but i dont know how.
How can i sort the FileSet Define by filedate?
And how can i do the “Iterate Fileset [with “Action.Reset” in the OnAfterEachIteration script event]” ?

i really hope you or someone else is helping me out…

regards,

Matthias