FMS 10 / FMP 10 on Windows: a scripts imports from an excel file which
is ready on the file system (shared folder).

I delete all records before I start the import. I regret that if the
import fails because a) the file isn't there or b) the user who started
the import can't access the the excel file.

The excel file I import from never changes its name. What's the most
elegant way to check whether it's there and the user can read it?

Import an refermce of the file into a global container field and then
check for errors?

--
http://clk.ch

I don't know about the most elegant way bit I use the following script
The import is for jpg's within a folder, but could be adapted for a single
file)

set errot capture [on]
import records [no dialog; File; include all enclosed; picture and movie;
import only reference; add; windows ansi]
if [ get ( lasterror ) â‰* 0
show custom dialog ["error";"No file in folder"]
exit scipt
end if
rest of script


Hou je goed / keep well,

Ursus

"Christoph Kaufmann" schreef in bericht
news:1k00sud.8f1qvbl1bej2N%clk (AT) tele2 (DOT) ch...

FMS 10 / FMP 10 on Windows: a scripts imports from an excel file which
is ready on the file system (shared folder).

I delete all records before I start the import. I regret that if the
import fails because a) the file isn't there or b) the user who started
the import can't access the the excel file.

The excel file I import from never changes its name. What's the most
elegant way to check whether it's there and the user can read it?

Import an refermce of the file into a global container field and then
check for errors?

--
http://clk.ch