Jump to content

Automating the Import Facility?


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

Recommended Posts

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

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

This topic is 7830 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.