Automating the Import Facility?

[mbrightaus]

Hi There

Being a newbie to FM - I have a question - regarding importing records from a text file.

I have a Time Sheet System that loads text files each day.

I want to create a script that will use a calculated file name search for tat file in a designated folder and then proceed to upload that data automatically each day into FM.

Can some one show me how this could be done. Thanks.

Regards

Michael

[BobWeaver]

The only way to use a calculated file name is to use a plug-in such as Troi File, or if on a Macintosh, you can use Applescript.

[Anatoli]

.. or New Millennium plugin ..

[kennedy]

Well, if you know the possible values that can be computed, AND there's not too many of them, then you can compute the value and run through an If series to open the corresponding file. For example, if you have a directory of years, in each a directory of months, in each files named by the day number... then you could compute the date, break it into components, and then run it through three sets of Ifs, the largest being 31 Ifs. Ugly, but possible.

[Vaughan]

... or simplify it orders of magnitude by only having *one* import file name.