Jump to content

Wim Decorte

  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by Wim Decorte

  1. better way to go through data

    my guys
  2. better way to go through data

    We differ on that point. Plenty of people are already proficient in parsing JSON. Heck, most of guys are and some of them presented on it at Devcon. And I would probably direct people towards learning JSON parsing over XSLT any place where the two formats are available as outputs. That would obviously just be a generalization, the task at hand and the skills at hand would dictate what we use in what scenario. We try to have all the tools in our tool belt.
  3. better way to go through data

    What specifically would you want to be convinced of? Perhaps I can point you to some demos. 'Easier' is often and largely a matter of proficiency. Joost indicated that he is proficient at XSLT so importing from XML is a good fit. For many others it is not. Few things are as fast as importing but we do have to consider the whole mechanics. If 'insert from URL' can give you the JSON and you can parse it right there from a variable instead of having to output something like XML to disk and potentially also output the XSLT to disk before importing then perhaps just parsing the JSON could be faster. Just highlighting options.
  4. better way to go through data

    Or json if you are using FM16 and that is an available format. Parsing json is fast and easy and probably easier to pick up than XSLT if you are not already proficient in xslt.
  5. Import XML to file from container?

    But it's still a valid approach. Not everyone is good at writing an XSLT to import the XML; some prefer to use the FM text parsing functions to get through the XML. I've done both, depending on the complexity of the XML document.
  6. Import XML to file from container?

    That's the basic mechanism: export field contents to a known location (you set that, variable or otherwise), import from that same known location.
  7. IIS 8.5 reverse proxy to FMPS 16

    Can you define the "this"? That would help us out knowing what you need to achieve. For most deployments you don't need anything as fancy as reverse proxies. You'd need those if you want to hide the actual resource or have multiple inside your LAN that you need to route to, those kinds of things.
  8. IIS 8.5 reverse proxy to FMPS 16

    Did you have it working before 16 and it just now fails? Why the reverse proxy? Perhaps there is another way to achieve the same thing and work around the problem?
  9. DDR - where to focus?

    That's why I recommended starting with the FMS logs; it keeps good track of the 4 traditional machine bottlenecks: processing power, memory, disk i/o and network i/o. If those stats show strain on any of those then the consideration is: how much strain and is there a possibility of solving it with more horsepower.
  10. DDR - where to focus?

    messy file references: any file reference that has multiple entries, some of which lead nowhere; multiple file reference entries that really point to the same file,.. Portals: understanding how a portal forces FMP and FMS to exchange data is crucial. If you have multiple portals (and worse: of the portals are filtered, sorted or use a sorted relationship) then you have multiple of those interactions going on just to draw the layout. A lot of performance problems I have had to deal with over the years come from too much unneeded data being displayed on screens.
  11. DDR - where to focus?

    Collect info from the user users about what exactly is sluggish, otherwise you may be fixing things that don't need fixing. Also use the FMS stats log and the top call stats log to help put some numbers to it. While you wait for that, try to map out some of the usual suspects: - messy file references - layouts with more than 1 portal on it - sorted relationships - layouts with lots of unstored calcs and/or summary fields on it - ...
  12. Problem when I use OnLayoutKeyStroke.

    Cross-post from FM Community: https://community.filemaker.com/thread/177497
  13. need windows 10 to store filemaker 16 password

    From the menu: File > File Options > the "open" tab
  14. need windows 10 to store filemaker 16 password

    The ability to store the credentials in Windows' Credential Manager is an option set on the FM file. If the developer turned that option off then you can't use it.
  15. Does FQL actually work?

    FQL is executed on the server as a rule. It is executed on the client if that client has an open (locked, uncommitted,...) record in the target table, any table that is part of the SQL query. Only the client's open record state counts. If other users have open records then that does not matter. Obviously their data will not be in the result set since neither server nor the executing client knows about that data yet, it has not been committed yet. When the server executes the FQL, nothing is cached on the client because no actual record data was sent down. If the client executes the query then server sends *ALL THE DATA FOR ALL THE RECORDS* in the target table, and that is cached at the client as much as the client's cache allows. It is that sending of all the data from the server to the client that is responsible for the slowdown. You can actually see this in action by looking at the FMS stats log, the "Network KB Out" counter. If there are not a lot of record in that target table then the penalty is not high, but it is very linear with the record count. In that demo file I linked to earlier I have two tables to test with, one with 100,000 or so records and one with 1.5 million.
  16. File location in Mac OS (iCloud)

    Haven't looked into it specifically but the risk is real. Even if the current implementation is safe and does not touch open files, you'd still be at the mercy of the Apple Engineers changing it without you knowing it.
  17. Exporting from several fields to one filed in Excel

    Via a script: absolutely. What you are describing is often referred to as a 'scratch' table. A table whose data you will export but that is only there to transform the actual data into whatever form you need for exporting. When you are done with the export you can delete the data from the scratch table. There are other ways too, ranging from exporting from each table individually and using OS-level scripting to concatenate the 3 exports into one excel file. Or exporting to FM XML and using an XSLT style-sheet to transform that XML into an XLSX format.
  18. Subscripts

    Didn't say that it was, just how we do it and why. Doesn't matter where the "problem" comes from; our practice makes it safe no matter what someone's expectation is. For any level of developer, one of ours or one of the in-house devs. It's clear and well-understood.
  19. Subscripts

    I'll counter that. One of our standards is to always an explicit "Exit Script" and to explicitly pass an empty string "" when no real value needs to be passed out of the script. The main reason is that the Get(ScriptResult) will remember the last explicit returned result. If you don't use Exit Script in the sub script but expect Get(ScriptResult) to be empty because you didn't pass anything back then you may be surprised to see a value if a previous script did use Exist Script with a return.
  20. Story of our lives When you run the code locally are you touching that same FMS?
  21. Filemaker Go & Webdirect

    Both should work, they use different protocols. How do you try to access the file through FM Go?
  22. Yes, but no wildcards AFAIK
  23. Does FQL actually work?

    My test file from the devcon presentation a few years back can be found here: http://www.soliantconsulting.com/blog/2016/04/bag-goodies-executesql-named-buckets-relationinfo
  24. FileMaker 16 License Question

    Same deal, the connection license is included. Your users can connect with FMP, FM Go and WebDirect. But you only get 5 connections total, so if one user connects with all 3 of those then you only have 2 left.
  25. FileMaker 16 License Question

    If you use FM Cloud then your licensing will the new "FileMaker Licensing for Teams" and your license will include the FileMaker Pro licenses. So you get them with the server. You can download the installers from the FM Cloud admin console. Note that those FMP clients can not be used standalone, they can only be used to connect to the server. If you open a local database without connecting to the client the user wil get a prompt after 15 minutes that they need to connect.

Important Information

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