mbrightaus Posted November 15, 2002 Share Posted November 15, 2002 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 Link to comment Share on other sites More sharing options...
BobWeaver Posted November 15, 2002 Share Posted November 15, 2002 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. Link to comment Share on other sites More sharing options...
Anatoli Posted November 15, 2002 Share Posted November 15, 2002 .. or New Millennium plugin .. Link to comment Share on other sites More sharing options...
kennedy Posted November 15, 2002 Share Posted November 15, 2002 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. Link to comment Share on other sites More sharing options...
Vaughan Posted November 15, 2002 Share Posted November 15, 2002 ... or simplify it orders of magnitude by only having *one* import file name. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7968 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 accountSign in
Already have an account? Sign in here.
Sign In Now