Scripted import path from a field

[blah]

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

[Colin Keefe]

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.

[blah]

Wow, that should work perfectly.

Thanks

Matt

[blah]

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, 2008 by Guest

[blah]

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.