automating import (specifying filenames)

June 15, 200124 yr

I have a system where hundreds of little text files need to be imported all the time. I don't want to make my users specify a filename each time... I'd rather ask them to specify how many files they have today, and have the script do all the importing.

Is there any way to force the import script step to use the value of a field as the filename?

FYI, the files are named like this: pic0.csv, pic1.csv, pic2.csv, etc.

So I could have a loop which runs a specified number of times, and a calculation field to determine the current filename. If I could get the import script step to use this field as the filename, this would be a lot easier!

Jack

June 15, 200124 yr

Newbies

Force the import script step to use the value of a field as the filename could be great. But I doubt if it is possible.

You can use AppleScript instead. You have at least three options

A- Import from one file (for example, text, dif,..) to several fields

B- Import one entire text file to one field

C- Import files (for example, pictures into container filed) form a folder

But before all, I

June 16, 200124 yr

Author

Thanks, Alfonso!

The first solution you list will (hopefully) work. I just need to test it out. Hopefully it will work basically as you've written it, although I'll probably need to write another AppleScript to convert all the text files to Mac line breaks (they're PC text files). I don't think there's anything AppleScript-like on the PC side that I could use to tell FileMaker to perform the script.

Thanks again!