Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


normanicus last won the day on June 6

normanicus had the most liked content!

Community Reputation

2 Neutral

About normanicus

  • Rank

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.

  1. normanicus

    The file xxx could not be opened

    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.
  2. normanicus

    The file xxx could not be opened

    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.
  3. 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.
  4. normanicus

    SQL to FQL rules

    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.
  5. 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?
  6. normanicus

    User created window control

    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.
  7. 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?
  8. normanicus

    FM17 add Filemaker data source via 'Hosts'

    Thank you. I knew if must be simple but I actually searched for answers for quite a while.
  9. 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
  10. normanicus

    Data Migration Tool : repensons le versioning

    Est-ce qu'on peut utiliser des 'wildcards' (REGEX) ? Accepte-t-il des 'pipes' ?
  11. normanicus

    Realtime Developer Intelligence

    This is what google produces as a definition of realtime : "relating to a system in which input data is processed within milliseconds so that it is available virtually immediately as feedback to the process from which it is coming, e.g. in a missile guidance system."
  12. normanicus

    Realtime Developer Intelligence

    I read the article. FM Perception works with the DDR. The DDR is not a realtime thing. So how can this be a realtime tool?
  13. normanicus

    GetLayoutObjectAttribute() not working

    Apologies for being slow to report back. I recovered the file but it made no difference. I left if a couple of days and then thought to delete my Web Viewer and paste in the one from the test file Comment provided. It worked. So, it was the Web Viewer that had become dysfunctional, maybe corrupted. Thanks once again for your help.
  14. normanicus

    GetLayoutObjectAttribute() not working

    Went back to an old backup and found one that works. Did a Recover on the bad file and there were errors. Still the button didn't work. I'll paste your Web Viewer onto my layout and see what happens.
  15. normanicus

    GetLayoutObjectAttribute() not working

    Thank you. I tested your file and it works as it should. Copy/Pasted the 'Get Content' button to my file and changed the field to the one I use. Nothing. Chose another, non-global field on the same layout, nothing. So, as you said, something is going wrong. I never mentioned before but this was also failing on the client's computer so it looks like it is a corruption problem or similar. Your test has shown it is neither the browser or FM14 causing the problem. I'll try an older version of this file and then a 'Recover' and report back.

Important Information

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