We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

animation_master

Members
  • Content count

    39
  • Joined

  • Last visited

Everything posted by animation_master

  1. 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?
  2. Exit after last... Not Working

    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
  3. Exit after last... Not Working

    You're right! I forgot all about "nth record". Thanks again.
  4. Show NOT First Related Record

    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?
  5. Show NOT First Related Record

    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. SQL Features

    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?
  7. 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.
  8. XSL Embedded in Solution File

    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?
  9. XSL Embedded in Solution File

    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. Text Parsing Bug?

    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".)
  11. Text Parsing Bug?

    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. Set Cell Bug

    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?
  13. Set Cell Bug

    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. Weird IsEmpty() Bug

    I’ve just run into a bizarre problem. The result of a Boolean calculation in Data Viewer is different from the result of the same calculation in my Layout. Here is the calculation: IsEmpty (Address::Street) I place the calculation in Data Viewer and in a Field on my Layout. IN DATA VIEWER, this calculation evaluates “True” when the field contains no data, and it evaluates “False” when the field contains data. IN THE LAYOUT, this calculation always evaluates “True”, whether or not there is data in the field! I get the same results when I use IsValid(). Is there something obvious I’m missing here?
  15. Weird IsEmpty() Bug

    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!
  16. Is there a way to tell a QT movie inside a FMP Container to go to a certain time within the movie? For example, I have a 10-second clip in the container, and I want a button to advance the clip to to the frame at the 2-second point. This is trivial with AppleScript: tell application "QuickTime Player" select movie 1 at [some frame] end tell It appears FMP is unable to control a QuickTime movie in a Layout; only the user may do that.
  17. Launch an Applet

    Try as I might, I cannot get an AppleScript application to run by launching it through the Perform AppleScript script step. Correction: It launches, appears briefly in the Dock, quits gracefully, with no error from AppleScript or from FileMaker 8. But it never does anything. I know it works, because when I launch the very same applet by double-clicking it in the Finder, it runs just beautifully. It will "tell" Finder to have the user select a folder, then it walks that folder, and will "tell" FileMaker to process each file in the folder. FileMaker inserts data correctly. However, in the Perform AppleScript script step, I have tried to name the file in a calculation, paste it in as a script, "tell" the application to launch, activate it--nothing helps. The script launches, runs and quits, never doing anything. Any ideas?
  18. Launch an Applet

    I've run into another "gotcha" with the Send Event script step. Apparently, the only way to specify a target Applet is to select a path that is hardwired to the volume you're developing on. If you move the FM database to another volume, it won't find the Applet. You can provide a relative path (for example, a file in the same folder) only for a "document" or a "do script", but then the user has to locate the target application to open the darned document. Is there any way to make a solution with "Send Event" portable from drive to drive?
  19. Launch an Applet

    I've worked it out using a combination of a Finder "tell" and the Send Event script step. Thanks for leading me in the right direction once again. (By the way, I've upgraded to 8.5, and it is sure nice being able to address Layout objects.)
  20. Launch an Applet

    Definitely odd. Where ProcessClips is the name of my applet, I have tried the following (with and without the Finder wrapper) typed into the Perform AppleScript script step: tell application "Finder" ___activate ___tell application "ProcessClips" ______launch ______activate ___end tell end tell The same thing happens. And the icon for AppleScript application clearly shows up in the dock for about 2 full seconds, then disappears as the applet gracefully quits. Once again, it works fine launched outside of FM. I suspect it has something to do with the fact that the AppleScript has more than two "tell" blocks, and they address both FM and Finder.
  21. Error with "set data cell"

    FMP8 returns the error "Object not found" for every variation of this simple AppleScript: tell application "FileMaker Pro Advanced" set MyText to "Cryptonomicon" set data cell "Book" of current record to MyText end tell The current table is named "Global", and the current record contains the global field "Book". I've tried "Global:Book" and everything I can think of, but get the same error no matter what. Any ideas?
  22. Error with "set data cell"

    I solved it. The script was asking FM to change the value of a field in a record. But there was no record. I was using a simple layout populated with just 2 fields, but... they were both global. If there is no non-global field on a layout, FM doesn't recognize it as a record EVEN IF VALUES ARE RECORDED for the fields on that layout! Even "new record" fails. You can't create a record if you don't have at least one non-global field.
  23. FM Not Honoring Namespace in XSL

    FileMaker is complaining "XML parsing error: Attribute 'xmlns:cm' is not declared for element "FMPXMLRESULT". But it is declared. I begin my XSLT sheet with xmlns:cm="urn:schemas-Professional-Plug-in:P2:ClipMetadata:v3.0"> Still, when I prefix any node reference with "cm:" For example, FMP 8 complains the prefix has not been declared. The XSLT does work in every parser I've tested, including Test=XSLT. It is only FMP that complains. I've even tried a second declaration here: 0 But FMP refuses to inherit that xmlns:cm declaration, calling it an undeclared attribute. Any ideas?
  24. FM Not Honoring Namespace in XSL

    That was it! A case of the error message reporting the wrong error. Works like a charm now. Thanks.
  25. FM Returning null from Node

    I have an XSL document that transforms my XML document just fine -- except in FileMaker 8. The whole process works fine in TestXSLT, but... FM accepts both documents, offers to map the Results to the proper Field that exists in the database, returns no errors, reports that it has added one Record, etc. But after all is said and done, the new Record has no data in the Field. There is a whole lot of nesting in the XML, so I declare exactly the element I need by using the //ElementName XPath function. Here is a snippet. 0 0 The field DataSource should contain the attribute of the node DataSource, but it contains nothing. Any ideas?
×

Important Information

By using this site, you agree to our Guidelines.