Automatic Importing Loop

[Goliath]

I was playing around on the internet and found this script to auto import text files. So far it seems ok except for one problem.

The script is as follows:

Go to Layout ["ImportToDo"]

Import Records [###; Include all enclosed folders; Text files]

Go to Record [First]

Loop

Set Variable [$currFile; Value:ImportToDo::filePath]

Go to Layout ["Destination Table"]

Import Records [No Dialog; "$currFile"]

Go to Layout ["ImportToDo"]

Go to Record [Next; Exit after last]

End Loop

where ### is replaced with the folder I have all my text files saved.

ImportToDo is layout where the file names are stored.

The problem lies here Import Records [No Dialog; "$currFile"]. I keep getting a message box that says it can not find file "%&%&%&%&" and then I have to click on the file manually to proceed.

Is there a way to remove to the "" or make the file accessible? Or can I do something with the script so the users can execute this with one button push?

[Ocean West]

don't use "" in your import options just use $variable.

chances are that the issue is the path to file set by your variable may not be correct.?

[Goliath]

Thanks very much I believe that did part of the trick. I have run into another issue.

When adding new files to the database I try to use the update matching files and add new files option in the import specify page. However something goes wrong...for example certain data is misplaced or there is no updating matching files at all. (Import 20 files then when 5 more are added, instead of 25 files I get 45 files).

any ideas other than going in and deleting the files after importing them the first time.

(Actually if that is what is supposed to be done, is there a way to do that in the scripts)