Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About crayfish

  • Rank

Profile Information

  • Gender
    Not Telling
  1. I've been using Daniel Smith's JSON scripts from (http://www.modularfilemaker.org/module/json/) to parse JSON. It's worked quite reliably (thanks Daniel!), but I'm wondering if anyone has compared its parsing speed to MBS's JSON plugin or the new native Filemaker 16 JSON functions? I'm still on 15. I'm working with some larger JSON files that are taking a long time to parse and hoping for a faster solution. Any data on which option parses JSON fastest? Any disadvantages/advantages to each option? Thanks!
  2. I'd like to create an IRC client for Filemaker to interact with Twitch chat. Does anyone have any general suggestions to point me in the right direction on how I might most easily create this? I know a little php and javascript and I have access to 360works and MBS plugins. Thanks for any suggestions!
  3. I'm probably missing something obvious.... If I open the attached file in a webviewer, it works as expected. "file:/" & Get(DesktopPath) & "testpopup.html" However, if I copy the code from that file and paste it into a field codeHTML and then use the following webviewer calculation "data:text/html," & codeHTML, then the popups don't work. I'm on Filemaker Pro Advanced 13.0v3 on Mac OS X 10.10.5 The code will be changing dynamically so I'd rather not have to be exporting a temp file every time in order for popups to work. Any ideas? [p.s. the code allows you to create popups using CSS only, no Javascript. credit goes to Prakash Nakrani: http://www.sevensignature.com/blog/code/pure-css-popup-without-javascript/] testpopup.html
  4. Has anyone been able to log into Facebook using Web Assistant? I've tried the following without success: WAGetURL( "http://facebook.com" ; "email=" ; "pass=[password]" ; "type=text" ) and WAGetURL( "http://facebook.com" ; "username=" ; "password=[password]" ; "type=text" )
  5. On Server 13.0.1 on a Mac, is it possible to run scheduled backups that only backup the databases and not the RC_Data_FMS folder? In our case, RC_Data_FMS is a huge folder (6+ GB). Everything in it would be easy to reproduce if necessary so we don't need to back it up as often as the databases themselves. It just contains thumbnails for images that are stored elsewhere.
  6. Awesome... that's much faster. Operation seems to have dropped down to less than a second. Thanks for your help!
  7. The below code takes 5-6 seconds to process (it's inside a webviewer). Client machine is connected to local Filemaker Server over wireless network. I'm trying to avoid creating a relationship just for this one usage, hence ExecuteSQL(). There is an intermediate table JoinClientsWebsites between Clients and Websites since some clients have the same website. Could I do something differently to improve performance? Thanks! ExecuteSQL(" SELECT url FROM Websites JOIN JoinClientsWebsites ON Websites.id=JoinClientsWebsites.id_websites JOIN Clients ON JoinClientsWebsites.id_clients=clients.id and JoinClientWebsites.primary='yes' WHERE Clients.id=?" ; "" ; "" ; Clients::id )
  8. The space bar works to select highlighted buttons. Thanks! Any ideas on these: - is there a keystroke to highlight the Data Viewer or Script Debugger? Command-Tilde only switches been database windows. - when you have a script highlighted in the Manage Scripts window, is there a shortcut to perform the script? - also in Manage Scripts, any shortcuts for New script/folder/separator and Delete script
  9. As a general question, I'm curious if there are any guides to setting up Filemaker development on a Mac to minimize mouse usage? And more specifically... When you open the Set Variable Options window, is there a keyboard shortcut to open up the Specify Calculation window? I can TAB over and highlight "Specify..." but if I press Return, it just clicks the "OK" button. And that question relates to all Filemaker windows that have buttons on them. Pressing return only executes the default button, regardless of whether or not another button is highlighted using TAB. Any general solution for this so I don't have to keep reaching for the mouse? Also... is there a keystroke to highlight the Data Viewer or Script Debugger? Command-Tilde only switches been database windows.
  10. Thanks guys! BCooney: I'll look into ExecuteSQL. Comment: The control file is also a good suggestion. BTW, Our database has 57 base tables, and also accesses 10 additional tables over ODBC. When you're using Anchor Buoy, it means relationships will appear more than once, so getting to 300+ isn't very hard. 1-time use scripts aren't needed very often, but they do come up, particularly when redesigning the overall database structure
  11. Is there a way to create a relationship between tables on the fly in a script so that you don't need to create a table occurrence. Any plugins? Our relationship graph has 300+ table occurrences (anchor buoy), and we'd prefer not having to create table occurrences unless they are going to get a lot of usage, particularly on maintenance scripts that will be only used once. I know we can create a table occurrence and then delete it, but there's a tendency to forget to delete it...
  12. Here's a great solution by Charles Ross that works with Filemaker on OS X using applescript and php, without any plugins. http://chivalrysoftware.com/index.php/blog/124-filemaker-applescript-php-oh-my
  • Create New...

Important Information

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