naio 1 Posted August 17, 2020 Share Posted August 17, 2020 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 Link to post Share on other sites
naio 1 Posted August 18, 2020 Author Share Posted August 18, 2020 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. Link to post Share on other sites
Joost Miltenburg 0 Posted August 22, 2020 Share Posted August 22, 2020 (edited) 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 Link to post Share on other sites
comment 1,778 Posted August 22, 2020 Share Posted August 22, 2020 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). Link to post Share on other sites
naio 1 Posted August 22, 2020 Author Share Posted August 22, 2020 (edited) 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 Link to post Share on other sites
Joost Miltenburg 0 Posted August 23, 2020 Share Posted August 23, 2020 We understood your wish, but odly FM doesn’t seem to support this. Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now