Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About MSPJ

  • Rank

Profile Information

  • Industry
  • Gender
  • Location
    Boston, MA
  • Interests
    Astronomy, Photography, Martial Arts, Amateur Radio (KB1PIE)

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Win 10

Recent Profile Visitors

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

  1. Currently, I'm running a FM development server (FDS) on a WHS2011 machine (based on Server 2008). This has been working fine. From what I read, FMS 17 will no longer work on Server 2008 based platforms, so I'm assuming WHS 2011 will not work. I figure I have a few options - 1) upgrade to something like Win Server Essentials 2016 that will support FMS 17 - a lot more expensive, may require new hardware, more hassle, and overkill for my needs 2) Consider the possibility of a Win 10 Pro -based machine to run it. I know that officially FMS is not supported on Win 10, but I've seen that people have been running FMS 16 on Win 10 Pro systems, so unless this changes with FMS 17, that might still be an option. 3) Upgrade to FM client 17, but stick with version 16 of the development server, since from what I've read that will work and none of the changes to FMS in 17 are necessary or even desirable for me. If I understand what I've read correctly, the new features in 17 Advanced are dependent on the client version and should still work on files hosted in FMS 16. I'm leaning towards 3, but would value any thoughts from other folks, especially if I'm missing any key issues. Thanks, Michael
  2. In case anyone looks at this in the future, wanted to let you know that I believe I've come up with a decent workaround. I'm still working out the details, but it appears I can sell modules and have the seller use an http post to update the original account in my activation server with the new licensing info. Then, I can use Insert from URL to do an http post to retrieve license information from the server and determine if a user has the upgraded license. It isn't seamless, as the user has to manually enter their original activation key again since I still haven't figured out a way to communicate with the eleckey API from within Filemaker. (It might be that Scriptmaster could do it, but I probably won't invest the time to try right now). But it does get me a way to do a poor man's (person's) version of separately licensing modules .
  3. By the way - can fields off the layout (over on the right) impact performance? Got it isolated to one field, unstored calc with eSQL statement, where it's taking the sum of a value in another table that is itself an unstored eSQL calc.
  4. Yes - eSQL in calcs - been using those a lot to avoid extra table occurrence groups and relationships. Okay - will try what you suggested. Just for my understanding - can these cause this kind of delay even with so little data?
  5. So I have a hosted solution, with a dashboard with a couple portals. When I go to scroll a portal, scrolling even one portal screen has a delay of a few seconds, ie I click the scroll bar or try to drag it, and it takes about 3 seconds before it moves. Running locally, it's instantaneous. Running on a dev server on my LAN, there's a slight delay, but minimal. Having read various threads about this situation, my first thought was it's due to a filtered portal, so I removed filtering, but that made no difference. I also read various posts about unstored calcs and other factors that would cause all the data to have to be transferred to the client over the WAN. But here's the thing - at the moment, there are about 20 records in the database, related to the particular portal. Clearly, moving that data can't be the primary issue - right? I do have a lot of Execute SQL calculations in related tables, and I've read that can cause poor performance. But wouldn't that only be a factor when there are a lot of records? Are there design /schema choices that would cause significant lag regardless of the amount of data? Thanks, Michael
  6. Yes FMP/GO is enabled for the file. I did enable the local network sharing in the file before uploading to avoid getting errors about sharing not being enabled. Any chance that could cause problems?
  7. Hi - I've had something odd happen a few times after uploading a local file to Filemaker Server. The server instance is being hosted by Soliant in their cloud, but I'm assuming this is not an issue of their particular configuration. I had enabled the fmapp privilege for appropriate privilege sets before uploading. It worked at first, but then later, users were unable to access the hosted file. I discovered that the fmapp extended priv was disabled for their priv set. I thought maybe I hadn't set it when I thought I did. However, today - the same thing happened with my full access priv set and I was unable to get in on the server to fix it as a result. Fortunately, it's a new db and no real data was entered yet, so I could fix locally and replace on the server. What's stranger is that the local file had lost the privilege too - so it's not something that happened just to the file on the server - but rather, it appears to be something that is happening as a result of the upload process. I'm not sure yet if it's getting cleared on the local file and then impacts the server the next time I do an upload or if it happens on both. But it definitely is getting disabled. I did find a couple other mentions of this on the web but no real explanation or solution. Any thoughts from you all? Is this a bug or is their some particular way one should upload files to server that I'm not doing? Thanks, Michael
  8. Hi - I'm developing a business solution to be hosted on FM Server. It will be hosted on Soliant Cloud. This is my first time developing for Server. I read Steven and Wim's whitepaper on FM 16 security, which was very helpful. In the past, when I've created upgrades to my solution, I've imported data from the previous version into the new one. Each update is a modified version of the previous file. I read about the benefits of using File Access Protection. My solution is a single file solution so I can basically exclude any other file having access - except I'm not sure what impact that will have on import from previous versions. I assume both files will have the same ID - but not sure if that means that FM will see the older version as trusted or not. Thanks!
  9. Hi - thanks for the input and link to that (long!) discussion. Not sure this totally relates though to what I'm trying to do. I have successfully implemented a commercial exe wrapper. That is, users install the trial version, and in order to get more than 30 days use, they have to activate it with a code they get when they purchase. However, there's no way using the wrapper to interact with the solution itself so that my runtime can determine if someone paid for additional features - and enable them if they did. That's the part that must be implemented in C++, C#, etc. I suppose I could look into creating my own plugin using the code from Sciensoft. I suspect that won't be particularly easy. So I wondered if there was instead a way for Filemaker to interact with a separate program that implemented that API. I'm not sure if that even makes sense though. Michael
  10. I wasn't sure how to title this question, but here's my question: I have a software protection solution for my runtime product - I use Eleckey from Sciensoft. The basic licensing function works as an EXE wrapper. and I have that implemented fine, integrates with my software seller and my self-hosted activation server. All good. However, advanced features (such as being able to activate specific features) require adding code to the solution - they support several languages, including C#, VB.NET, VC.NET, VB, VC++, Delphi, and C++ Builder. I'm trying to figure out if there's any way a filemaker runtime could communicate with an external program built using one of these. In other words, if I could build a separate application that incorporated the advanced license code, is there some way a runtime could talk to it - as an alternative to actually incorporating that code in the filemaker solution itself. Even better would be some kind of plugin that let me incorporate that code directly in the solution in some way - but I haven't come across anything like that. Any thoughts? Thanks, Michael
  11. Thanks both! Are there any ways that multiple users could "step on each other" if I don't script something in a particular way? For instance, I have some scripted searches set up with global fields. Are globals stored per user session? So one person's search will not impact the others?
  12. Hi - I'm sure this has been asked and answered before, but I could find it by searching. So I apologize in advance and would appreciate suggestions for resources. I have a solution I've been developing for years which was intended for single user use in a runtime. I'm creating a multiuser version that will be hosted on FM server. I'm looking for information on what to look out for and what changes I need to make to avoid problems in that environment. For instance, I'm already aware of the need to load globals from single record tables with non-global variables. I assume there must be other things like that to be aware of but I haven't found a good resource yet. Thanks for your help. Michael Oh, just to add some details, I expect to have 5-10 users at most.
  13. Hi - I'm having an issue I've never had since starting with FMP 7. I'm using FM Pro Advanced 16 (latest update), working on a database that I've been working on for years. It's always been very stable. Lately, it's been crashing unpredictably. When I say crashing - the program just quits, no messages, warnings, etc. It's happened at different times - running a very simple script, going to a layout, closing the relationship graph. No apparent pattern. Is anyone aware of any particular issue like this? I am running a couple instances of chrome at the same time (quite a number of tabs) plus an SVN client and various things in background. I don't know if it could be a memory issue. I haven't tried a db recovery yet as I have no specific reason to think there's any issue with my db itself. I'm running on Windows 10. Would appreciate any thoughts, suggested trouble-shooting, etc. Thanks, Michael

Important Information

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