mac Error 100, File Missing, when it does exist

[cgroody]

I am trying to use Import Records[] from FMS. using the same string it outputs as file path.

 

for some reason my FileMaker 13 Server keeps saying File is Missing, but when I go to the machine that the server is on and to the location of the file it is there.

 

any ideas anyone?

 

ATTATCHED : image to clear confusion/support my confusion

 

thank you for taking the time to read my problem.

[Rick Whitelaw]

I believe the client machine is giving you this error. FMS isn't doing anything.

[cgroody]

its not being ran on FileMaker Pro, that happens when its run from FileMaker Server Console.

[cgroody]

here is a SS of the script

[Rick Whitelaw]

its not being ran on FileMaker Pro, that happens when its run from FileMaker Server Console.

Are you running this as a schedule event? Where is the data being imported TO?

[cgroody]

the text file is taken into a container field using Dacon's Mailit plug in. and I am trying to export the text file from the container field, and then import the data in the text file in.

 

and yes its being ran as a schedule.

 

edit if I run the same exact thing on FileMaker Pro it runs fine.

[cgroody]

Problem Solved : FMS only has access to certain directories when being used as a schedule. I was using FileMaker Server/Document when I needed to use FileMaker Server/Data/Documents.