How to get ESS data into an FM table, using a server schedule?

[Cortical]

How does one get ESS data into an FM table, by using a server schedule?

FM can import ESS data , when a script is run from a client. This can be done

ssh/FM9adv/open remote/fmnet, or ssh/rdc/TS/FM9/OR. The import step is not web compatible so the server can’t do it; even though the former approaches work. I find this incongruous, but then I know zip about the bts logic.

My revised approach is to push the data from the ESS table into FileMaker via an acrr rel. This doesn’t work either. A very simple test setup:

2 tables:

A. TestESS (MySQL)

B. testFM

the script: test - push ESS

Go to Layout [ “testESS - table” (TestESS) ]

Show All Records

Go to Record/Request/Page [ First ]

Set Field [ TestFM_acrr::Line; TestESS::line ]

no web incompatible steps.

run from a client , no problem

run script from FMS9 (9.0.2.151) as schedule, it fails. result script error

check Server Help; logs; control panels/admin tools/event viewer/ application

check log:

schedule completed;

Event 644 last scripting error 101

event 645: error 101... at set field

event 645: error 101 at... go to record

search FMS9 Help , Event log, no results for actual errors (eg error 101)

the script steps are web compatible

the db is on the server (the ESS db is not)

a further test, disable the go to records step this comes first...)

script error, error 101 at set field

2 questions;

1. why might this be occurring?

2. HOW do I get a server schedule, to get data out of an ESS table, and into a FileMaker table?

[Cortical]

A; corrupt FMS9 schedule handling