11 posts in this topic
Export and Import Same Records in a single operation
I have come across this technique severally on this forum, but I can't figure out how this really works. Right now I am faced with a situation that requires similar technique and I can't seem to get it work.
I have Table A and Table B.
1. I want to script an import Process that will first export all records in Table A into Table B (kinda A Clone Copy of Table A) Thats just my basic objective
2. Then from there, I would want to be able to do similar Process but this time, I will only update the records in Table B with that of Table A using a match field.
3. I will also love to perform the process based on a found count. ie after performing a find of specific records
I think If I can be guided on achieving NO. 1, then I can similarly script the others..
How to Identify Ipad Model
We have a database in Go 14 and users need to Import records from Filemaker Server 14, to Filemaker Go.
And it runs very good with all Users that have:
Ipad Air 2 and Ipad Pro
Import time: 8 to 9 Minutes
But all the users that have:
Ipad 3rd and Ipad 4rd Generation
Import time: + 1Hour
Both using the same wireless,
Is there any way I can identify in a script what Ipad Model the user has ?
PSOS Import Records is failing
I have a problem with server side import of records. I have a simple script which just does an import of a textile (with tab delimiters):
Set Variable [$FileList; Value: "filewin://server/folder/1795739.txt"]
Go to Layout ["files" (files)]
Import Records [No dialog; "$FileList"; Add; UTF-8]
When I run it client side, everything is fine. When I run it server side with Perform Script on Server I'm getting an error:
The previous script step, "Perform Script on Server", could not be completed because of an error....
If I run Get ( LastError), I get error code 100 (File is missing)
I have tried many different file locations for the textile. Network path, Local path (on the FM server) and Relative path (from where the database is placed on FM server).
I have tried placing the file in the FM server Databases and Documents folder AND the User Documents folder:
filewin:/C:/Program Files/FileMaker/FileMaker Server/Data/Documents/1795739.txt
filewin:/C:/Program Files/FileMaker/FileMaker Server/Data/Databases/1795739.txt
Every time I get error 100. What am I doing wrong??
FileMaker server is v14 on Windows Server 2008 and the client is running on Windows 7.
Move Records to a new Table
I have two tables Temporary and Real, the procedure is that contacts are created on the temporary table, probably by the contacts themselves. then once they have been confirmed as Clients (ie after their details have been verified by our staff), I would want to move them from the Temporary table to the Real table. Please how can I achieve this?