Self import doesn't work in hosted file

[naio]

I have a file with 2 tables: updates on table A are imported into table B using the update matching records option based on a common id.

I made the script and tested it without problem. Then I uploaded the file and scheduled the script to every x minutes. The script executes with full privileges.

The scheduled execution seems to skip the import update, so table B never gets updated.

The most surprising is that the script works as expected when executed manually but it doesn't do the import update in scheduled execution. I can't see any error code.

Is this normal?

I'm using FMS 19.0.1.103

[naio]

Although I haven't read it in any documentation, it seems that FileMaker Server cannot handle self imports, so I had to export and import to and from a temporary file.

[Joost Miltenburg]

It is very odd indeed that FM doesn’t support it’s own FM format for export.

You can just do an excel/xml export to al local server (eg. Documents) folder and then import that file. It is quite speedy. Or a create loop, that will work quite nicely if you need container data  

HTH 

Edited August 22, 2020 by Joost Miltenburg

[comment]

21 minutes ago, Joost Miltenburg said:

It is very odd indeed that FM doesn’t support it’s own import in FM format.

Actually, it does. You can import a file in any supported format, as long as it is in one of the folders that server-side scripts can access. However, you cannot export to FMP12 format.

I wouldn't use Excel as an interim format. It will probably not be problematic in this case, but too often it results in data type being misinterpreted. And it's an overkill; a plain-text format will suffice (my own preference would be XML).

 

[naio]

I didn't mean import into another file but import between tables in the same file, so shortening the "export/import" process.

Export to temporary folder and importing afterwards is fine, at least in csv format.

Edited August 22, 2020 by naio
bad writing

[Joost Miltenburg]

We understood your wish, but odly FM doesn’t seem to support this.