Import Order Problem

[otari]

I'm importing many folders of JPEG images into a container field, updating existing records in a found set.

For some reason, the JPEGs aren't importing in numerical order according to file name - the portrait oriented images (taller than they are wide) are being imported after all of the landscape oriented images.

Not sure if this has anything to do with it, but the portrait oriented images were created after the landscapes, so the "creation date" on the portrait oriented images is later than the creation date of the landscape images.

Can anyone shed light on the import order of files in a folder?

[Fenton]

I'm doing this on a Mac (10.4.11), so we may or may not be seeing the same thing; but it is possible. Do your file names have numbers in them? What I'm seeing is that the window of the files, when you're looking at it, has "natural order" sorting of numbers, whereas the operating system itself does not. (This natural order sorting was added, it didn't use to be that way a few years ago.)

So, the files in the window look like:

f 01.txt

f 02.txt

f_01.txt

f_02.txt

f_010.txt

But the OS, hence FileMaker, see them as:

f 01.txt

f 02.txt

f_01.txt

f_010.txt

f_02.txt

I can tell the OS sees them that way because they return in the above order if I use AppleScript:

list folder (choose folder) without invisibles