Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


normanicus last won the day on June 6 2018

normanicus had the most liked content!

Profile Information

  • Gender
  • Location
    France/UK/New Zealand

FileMaker Experience

  • Skill Level
  • FM Application
    14 Advanced

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

Recent Profile Visitors

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

normanicus's Achievements

Community Regular

Community Regular (8/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. You can get a free trial to Script Debugger here: https://latenightsw.com/sd7/download/ I have the beta 8 version which, I believe, won't be unusable until the official version 8 is released. I have found it stable. (Can't locate the link). Script Debugger really does demystify Applescript. For one, it shows you the path of the 'do shell script'. It also shows errors reported from the shell. I run python from AS and it also gave me the python generated error messages.
  2. If you use the script step 'Write to Data File' you can control just what is in the resulting file such text coding is the right type of linefeeds or whether data is enclosed in inverted commas. It's a pity that the CSV standard isn't.
  3. Looks to me like the client set this up wrongly. Each site should be a record then information directly pertaining to the record can simply be fields in that table. I believe the structure will be simpler after doing that.
  4. Just reading a review of Hot Chips 31 and saw this article: https://www.anandtech.com/show/14750/hot-chips-31-analysis-inmemory-processing-by-upmem It is about a memory technology that does some calculation tasks directly in memory. They mention 18x speed up for database tasks + the CPU is more lightly loaded. I wasn't sure if, to use this, revisions in Filemaker itself would be needed or if the technology could be used by an end user. It appears that the FM plug-in SDK does expose SQL actions to maybe it could be used. It says the memory is a drop in replacement for DDR4. Reading the comments, especially this one: https://www.anandtech.com/comments/14750/hot-chips-31-analysis-inmemory-processing-by-upmem/660097 raised many doubts about the technology and its implementation, usefulness
  5. We are having a hard time solving a problem involving one Mac (High Sierra) running Filemaker 17 (Advanced tools enabled). There is a webviewer which displays a page depending on the URL in a field. This has been working for years. The client has three Macs, all running FM17 and using FM17 Server. On two of the machines the pages show as normal. On the client's own machine the page does not show. Activity can be seen in the bottom bar of the webviewer as if the page is loading and, sometimes, one sees the URL flash up there. He has gone back to using FM16 as that works normally. This gets stranger. After many attempts to get to the root of this I put URLs from other sites into the 'Custom' box. These pages displayed correctly. I chose Google Maps (UK) and put a place in the box. Again, this displayed as normal. Reinstalled Filemaker 17. Problem still there. Copied the layout and pasted it a a new layout. Didn't work. I recreated the webviewer. No go. I'm sure we tried all kinds of other things to no avail. I have left him with the suggestion of installing FM17 on another Mac and logging in the Filemaker to see if that works. I suspect it will. Which will mean that there is an interaction between something on his computer and Filemaker which is not showing on other machines. My memory told me of log files that got to big and caused a problem. That was way back and I can find no log files for Filemaker on his machine. His company has recently moved the site from Magento 1.8 to Magento 2.xx so everything was redone. The only significant difference I can think of in relation to this is that he does most of the importing and exporting of products and stuff ie his webviewer has a lot more stuff pass through it. So, if there were to be an overfull log file it would be on his computer it would show. However, this doesn't fit with URLs from pages not on his site working normally. Has anybody else had this happen? Any ideas? Thank you if you got this far. PS He did the install on a Mac Mini and it worked as it should. Forgot to say: tried changer the default browser. No change.
  6. I tried this and the problem files still were not found. I think there is something wrong with the files. I'll try the 'Recover' process and see if anything shows up. Could I ask how Filemaker adds entries to External Data Sources and how it makes entries like the ones I noted.
  7. But, as I said, this happens when I am opening on a local copy with all the files in the same folder so I don't think it is an issue with External Data Sources. However, just to be sure I added the two files causing problems to the External Data Sources list. Problem remains. What I did notice that one of the problem files had an entry like this: fmnet:/ESVs-MacBook-Pro.local/DPD whereas all others were like this: file:DPD I changed the former to use a path like the latter but on restarting and having to open it manually again it had become this: filemac:/Macintosh HD-1/Library/FileMaker Server/Data/Databases/DPD.fmp12 Which is odd as I don't run FM Server locally. Is that information stored in the file somewhere? I changed it to the full path to the file: filemac:/Users/normanwinn/Documents/esv/021018/DPD.fmp12 but, again, to no effect.
  8. We have been having problems with some files not opening. A checkbox appears with this text: The file xxx could not be opened. Either the host is not available, or the file is not available on that host. This has been happening since we started using Filemaker 17. It is intermittent for clients to Filemaker Server 17. One user is still on 16 and, it seems, the problem is more frequent for him. It is consistently the same files that give the problem. When I have the same files as those hosted but open them locally I get the above messages for the same files giving the problems when opening files from the server. All files are in the same folder. For one of the files I added an 'Open' script step in the startup script. It gave the message. Then, when it hit a layout with a button referring to that file I got the message again. That seems pretty weird. FM has already found it but then can't find it again. I ran the verify process on all the files on the server and got no errors.
  9. Thank you for the reply. Having admitted to my mental laziness I made some progress. My breakthrough was to put the query into a global text field so I could play with less effort.
  10. I am wanting to learn to use the ExecuteSQL() function. I find I seem to take quite naturally to SQL when working through the examples on w3schools but am quickly lost in a maze when I try to translate this learning to use in Filemaker. I have seen the introductory articles but have rather a lazy mind. Are there a set of concise rules to translate from SQL to FQL? In passing, as this has become an important feature in Filemaker, would it not be reasonable to expect Filemaker to provide an SQL editor where one could enter standard SQL, use field and table references, and then give us the FQL version of the query?
  11. I didn't explain clearly enough. I'll try again. Table 'DPD' is in file Sales Items. The DPD layout is used in a window 'DPD' created with the New Window script step. When using the DPD window it is on the DPD layout. If the last action performed in the file Sales Items used the window DPD then a subsequent call to GTRR using a table other than DPD uses the DPD window , not the window of the parent file** , Sales Items. This may well be normal behaviour but means that GTRR script steps have to be followed by a Select Window to work as intended. I hope I am missing something. ** 'parent file' I'm using to mean the file containing the table DPD.
  12. I have a window, DPD, based on a table in a file, Sales Items. I am surprised that a GTTR going to a different layout in the same database takes me to the DPD window and not the parent db window. I assume this is intended behaviour? Does this mean that I have to replace all GTTRs in that database with a script that includes a 'Select Window' script step?
  13. Thank you. I knew if must be simple but I actually searched for answers for quite a while.
  14. In previous version of Filemaker I've been able, in the relationship graph, to 'add a Filemaker data source'. The dialogue, as in the image, after clicking 'Remote' showed only the 'principal' Filemaker file but I could replace the name with the file I sought to add manually. Now, with FM17 I no longer have this option. So, how do I add another of the served files as a data source? I suspect I am missing something simple
  15. Est-ce qu'on peut utiliser des 'wildcards' (REGEX) ? Accepte-t-il des 'pipes' ?
  • Create New...

Important Information

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