Is it possible to script "import document" using a given path saved in a field, instead of having a dialog?

I have to import multiple files where the file path is known and the files change frequently.

Thanks

matt

Assuming you're talking about Import Records...you can pass a file path dynamically by using a variable in the Specify File dialog; e.g.

Set Variable[$filepath; myfilepath]

Import Records [$filepath]

The import order however is hardcoded, so this'll only work if the import order is the same for each file imported.

Wow, that should work perfectly.

Thanks

Matt

When using the set variable call, I get an error message saying that FM cannot find the file and the error message quotes an abbreviated path.

I checked the saved path and it is correct.

What could be the cause of this error?

An example of the path format is:

"filewin:c:documentsandsettingsmattnewprofile.xls"

the error message reference says cannot find the file:

"c:documentsandsettingsmattnewprofile.xls"

Thanks for your help.

matt

Edited January 21, 200818 yr by Guest

Thanks to trial and error, I figured out the problem:

the file path format must use "/" instead of "".

how that happens or why is besides me.