This topic is 2624 days old. Please don't post here. Open a new topic instead.
I have a calculation field in a portal which shows the value according to ActivePortalRowNumber. Each row has a special determined value.
When I manually enter the value in the field before the calculation field and thereby make a particular row active, my calculation field automatically shows the designated value. Great!
But, if when I do the import from Excel, all data gets nicely imported and the portal shows the imported data but the calculation field is without value. I guess the importing process is not making a portal rows active so the calculation is not working.
Any ideas how this can be solved?
Hi All. I have a database that is currently sitting on 760MB with 425K records and from the trend it will grow at about 200K records a year now. as it is primarily used on mobile devices I think that this growth will lead to local processing problems. I am looking for a way to "hive off" any records older than say 18 months in the distributed version of the database while keeping all records in an "archive" version and then be able to add new and modified records monthly to the "archive" and removing the oldest month from the distributed version. There are 27 tables involved. Any pointers for achieving this would be appreciated *
We have a solution to store pictures(JPEG and NEF) from a photographer. I am trying to mass import the raw files(.NEF) into containers but I have an error message saying 'This file could not be translated using the selected file type'.
It is possible to drag and drop or File->Insert the file into the container directly but I can't import them from the folder.
Is this impossible to import files from folder with extensions other than the basic ones? (jpeg, pdf, jpg, png etc)
I have a script to import an Excel file into an FM Table.
I have my FM Script setup to Import Records with Arrange by: LAST ORDER.
But it won't do this. Every time I run this script it gets the field mappings wrong. Reverts them back to before.
Ironically when I do it manually it works.
Any ideas? (I have this type of scripted import working fine for other tables)
(I tried shifting the order of the fields in the actual database table as well -- but that has no effect either.)
I am trying to open my (local) FM 14 Pro file [which has an auto-exec "Import Script"] but the script needs a variable file name.
How do I pass this variable file name into Filemaker at 1) the time of the file open or 2) at the time of running the script (if I switch to manual execution)?
Is #1 by using the fmp:// syntax from a web browser external to FM? (or is that syntax just for use when invoked from INSIDE a FM file?)