Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About animation_master

  • Rank
    The Next Step

Profile Information

  • Title
    Adjunct Professor
  • Industry
  • Gender
  • Location
  • Interests
    Higher Education, containers, animation

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Sorts are taking too long for me on FileMaker Cloud. A database solution on a local machine (no network) sorts 400 records in less than one second; the same sort via FileMaker Cloud (no Webdirect, no browser, just FileMaker Pro Advanced) takes 30-40 seconds. None of the usual suspects (such as unstored calculations) is involved. It just takes way longer. Richard Carlson says that FM Cloud (like WebDirect) forces all sorts to take place on the server. Does this mean that our AWS server is simply slow, and we have to live with that?
  2. FileMaker Pro 15 Launch Center connects to our AWS instance with no problem. But then it reports No files are currently hosted on AWS instancename. Well, there ARE files currently hosted. We access them via WebDirect, so they must be hosted. Moreover, when we launch a local copy of the file, FileMaker offers to open the remote copy with This file has previously been uploaded to FileMaker Server. Use Hosted Version? It even displays the proper address for the hosted file. However Use Hosted Version returns this error: The file “filename.fmp12“ could not be opened. (Extended privilege disabled) So, we created a privilege set that extended privileges for fmwebdirect, fmapp and fmxdbc. On the next launch of Remote Version, we got this: FileMaker cannot share a file because FileMaker network sharing is turned off. So, we turned on ODBC sharing, and on the next launch, we got this: FileMaker cannot share files because another user is already sharing files using FileMaker Pro on this computer. I’m going in circles here. Are these errors related? What am I doing wrong?
  3. You're right! I forgot all about "nth record". Thanks again.
  4. This script deletes duplicates... except if the duplicates are the last records in the table. If the last "Go to Record" step is inside the "If" statement, this script deletes all of the last records. If the last "Go to Record" step is outside the "If" statement, it leaves one duplicate! Neither outcome is good. Any ideas? Delete Duplicates Sort Records [ Restore; No dialog ] Go to Record/Request/Page [ First ] Set Variable [ $ID; Value:Table01::ID ] Go to Record/Request/Page [ Next ] Loop If [ Table01::ID = $ID ] Delete Record/Request [ No dialog ] Else Set Variable [ $ID; Value:Table01::ID ] End If Go to Record/Request/Page [ Next; Exit after last ] End Loop
  5. All I did was duplicate the Layout and change it to show records from the Class table instead. Duh! Thank you (and Dave McQueen), very much.
  6. How do I show a specific related record, not just the first matching one, in a non-portal field? I have a table Class with the Student_ID as a key. Every Student_ID appears in multiple records (once for history, math, biology, etc.). In a related table Phone, I want to say, "Show me the phone number only for students who are taking history." FileMaker does list only those students, but the field for Class::classname displays "biology" or "math" or "history", depending on which record was created first in the related table. How do I (1) restrict the list only to history students and(2) ensure that the field "classname" displays the class that I entered into the search field?
  7. I've read the announcement page on FileMaker's site pretty carefully, and I can find no reference to being able to enter data in SQL fields. Phrases such as "...add SQL data to FileMaker Pro solutions...", "...include information located in SQL systems", and "You can create new information by adding supplemental calculation and summary fields to the SQL table," imply you cannot add data to fields directly. Is this just a case of a poorly-written announcement?
  8. Because this custom function's example solution uses a return-delimited list of numbers, it is not that easy to apply to other kinds of portals. Even so, I think it might help me. The larger issue is that I believe there is a bug in FileMaker's portal behavior. Others have reported situations in which "Reset scroll bar when exiting record" is unchecked (not checked), yet the scroll bar resets anyway. In my case, I have a portal showing a list of related images. Whenever the user clicks on a row in the portal, the scroll bar resets -- even though that Reset box is unchecked. I can understand this behavior if the user clicks OUTSIDE the portal to navigate to another record. But not when the user clicks INSIDE the portal. When I click on a portal row, that row should not disappear from the portal view.
  9. Works like a charm. Two important rules not explained in the manual: (1) When you export the contents of a container field that contains a file, you must give the newly-created file the same name as the source file in the container field. (2) The file created by exporting the contents of a field replaces any existing file with the same name--unceremoniously, and without warning. Not behavior I would expect, but exactly what I need! Thank you, gentlemen.
  10. Is there a way to import data from an XML file by using an XSLT sheet that is imbedded in the FileMaker solution? The normal way to write such a script step is - (1) select an external XML file with the data; (2) select an external XSL file that tells FM how to interpret the XML file. I would like to avoid using a text file separate from the solution, so that the whole solution, including the XSL, is in one file. In the Script step "Import Records", under “Specify XML and XSL Options”, you may specify a Calculation instead of a file. I have tried to make this calculation - (1) a text field that contains the XSL text (2) a container field that contains the Style Sheet document. Both methods return a runtime error. Has anyone been able to do this?
  11. It’s not as easy as it appears. Consider the path /Volumes/Film/Video/01/0042/CAMERA 3/CLIPS/ Here are some solutions that do not work. (1) Parse with word-based functions such as RightWords(). Consecutive directories with numeric names, as in /01/0042/, are considered a single directory named “01,0042”. Note the comma. Slash, comma and hyphen are not word delimiters if they appear between two numerical characters. (2) Exploit the position and occurrence of "/" to count the words. In OS X, “Film/Video” is a legal name for folders and files! Not recommended, but the Finder allows you to do it. (3) Substitute for the "/" something you’re sure the user will never use in a folder name. That would be “:”. Guess what? “01:0042” is also considered a single word! And using a space as a delimiter fails on the name “CAMERA 3”. I am stumped. The only solution I see is to impose folder naming rules on the user: No spaces, no consecutive numbers in directory paths, etc.
  12. The result of this calculation should be "9999/STATE/CITY/STREET". RightWords("ABC/01/9999/STATE/CITY/STREET";4) Instead, it returns "01/9999/STATE/CITY/STREET". However, it returns the correct result for these 2 variations: RightWords("ABC/01x/9999/STATE/CITY/STREET";4) RightWords("ABC/01/x9999/STATE/CITY/STREET";4) How do you get around this? (I am trying to extract the name of the Folder enclosing "STATE/CITY/STREET".)
  13. I believe that is not my problem. The script requires the user to select a folder, then it loops through the files in that folder. FileMaker cannot do that, so it must rely on an AppleScript to perform the choosing of the folder, and to perform the looping. The problem is this: You must enclose the FileMaker loop inside a “Tell Finder” loop. tell application "Finder" set selectedFolder to choose folder with prompt ¬ "Choose the CLIP folder to be processed." set fileList to (every file of entire contents of selectedFolder) repeat with currentFile in fileList tell application “FileMaker Pro” do [some things with the file] end tell end repeat end tell The script returns an error immediately after tell application “FileMaker Pro” I have tried (1) removing the enclosing “tell application ‘Filemaker Pro’” (2) using “tell window 1 of application ‘FileMaker Pro’” Neither works. I believe the rule is: An AppleScript embedded in a FileMaker script, may not address FileMaker inside a Finder tell.
  14. This is apparently a big bug in the implementation of "Native AppleScript" in ScriptMaker. Consider this short loop that accepts a list of files in a folder. (The third command is a FMP 8.5 dialog that displays the value of MyGlobalField.) repeat with currentFile in fileList tell application "FileMaker Pro Advanced" display dialog "currentFile is " & POSIX path of (currentFile as string) set cell "MyGlobalField" to POSIX path of (currentFile as string) do script "Display Dialog" end tell end repeat When this is run as an external script, it works perfectly. However, when it is run as a native AppleScript (inside FileMaker), it misbehaves. (1) I see the first dialog (“currentFile is filexx”) 10 times, then I see the second dialog (FileMaker “Value of MyGlobalField is”) 10 times. In other words, AppleScript appears to be looping through this routine twice! Once to perform the first line 10 times, then again to perform the third line 10 times! (2) The "set cell" step inserts a static path DIFFERENT FROM the one displayed by the first dialog over and over. Anyone know a workaround for this?
  15. Yes, indeed, it's unstored, but... your question prompted me to click on the "Do not store results" checkbox. (I don't know, just to be sure.) When I did that I got the message, "This calculation cannot be stored, because..." That led me to look at the "Evaluate this calculation from the context of..." That's where the problem lay. Wrong context. Thanks for the brain jumpstart!
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.