2 posts in this topic
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.
Exporting large summary file to Excel taking long time
I've got multiple Filemake databases with 4m+ records each. I've created a layout which calculates a summary using a sort, Groups and Counts. This takes 10-15 seconds, which is OK.
However, when I try to export this summary report to Excel it appears that Filemaker has to recalculate all the Groups & Counts, but for some reason this takes several hours. The last report took over 4 hours.
I can't figure out how I can simply export or copy the summary report that Filemaker creates for the Layout?
Please can someone provide assistance because I have another 20 similar reports to do and this will take me days instead of hours
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?
Import records from table to table not behaving as expected.
By gerg nnud
I am trying to copy selected line item records from one table to another as part of an intended 'recurring transactions' structure. For some reason if I perform a find on line items for that transaction and attempt to import into the recurring line items table it wants to import all records (12000) and not the found set (1-20) as I would expect.
I have just conducted some tests with other databases to confirm I have an issue with this database only. The test databases would only import the found set from table to table as expected. Is my db corrupt or is there some setting somewhere thats changes this behaviour? Any help would be appreciated. FM13.