Jump to content

automating import (specifying filenames)


This topic is 8309 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

  • 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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 ]

Link to comment
Share on other sites

  • 2 weeks later...

This topic is 8309 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.