Jump to content

normanicus

Members
  • Content Count

    208
  • Joined

  • Last visited

  • Days Won

    1

normanicus last won the day on June 6

normanicus had the most liked content!

Community Reputation

2 Neutral

About normanicus

  • Rank
    member

Profile Information

  • Gender
    Male
  • Location
    France/UK/New Zealand

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    14 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    High Sierra

Recent Profile Visitors

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

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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?
  7. 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.
  8. 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?
  9. 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.
  10. 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
  11. normanicus

    Data Migration Tool : repensons le versioning

    Est-ce qu'on peut utiliser des 'wildcards' (REGEX) ? Accepte-t-il des 'pipes' ?
  12. 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."
  13. 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?
  14. 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.
  15. 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.
×

Important Information

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