automating import (specifying filenames)

[JackP]

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

[Alfonso Sainz]

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

[JackP]

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!

[Lee J]

You can use WHS (Windows Scripting Host) to a certain degree, go to the Filemaker website and search for articles on COM (DDE)

Or enter Article Number: 102099

If anyone else has any solutions for scripting on PC please let us know

[JPaul]

quote:

---

Originally posted by byteworks:

You can use WHS (Windows Scripting Host) to a certain degree, go to the Filemaker website and search for articles on COM (DDE)

Or enter Article Number: 102099

If anyone else has any solutions for scripting on PC please let us know

---

Hi Byteworks,

take a look to www.windoware.com and search for WINBATCH: this package allows native Windows batch creating & compiling and more ....

Greetings

[ June 18, 2001: Message edited by: JPaul ]

[Gerd Muller]

Hi Jack

Take also a look at file-plugin from Troi. It will do what you need, and it is aviable for Mac and Windows!

Gerd