Wim Decorte

Moderators
  • Content count

    5,127
  • Joined

  • Last visited

  • Days Won

    125

Wim Decorte last won the day on March 19

Wim Decorte had the most liked content!

Community Reputation

412 Excellent

4 Followers

About Wim Decorte

  • Rank
    member
  • Birthday 12/17/1968

Profile Information

  • Gender
    Male
  • Location
    Toronto

Contact Methods

  • Website URL
    www.soliantconsulting.com

FIleMaker Profile

  • FM Application
    15 Advanced
  • Platform
    Cross Platform
  • Skill Level
    Expert
  • Certification
    7
    8
    9
    10
    11
    12
    13
    14
    15
  • Membership
    TechNet
    FileMaker Business Alliance
    FIleMaker Platinum Member
  • Title
    Sr. Technical Architect
  1. If your router allows, forward based on DNS names then you can just update your DNS and have all the rest fall into place. Otherwise; yes: you would have to update the port forwarding.
  2. Passing variables is something you do between scripts and has nothing to do with TOs so there is some really fundamental confusion in your mind that needs to be cleared up, otherwise you'll come up with answers that don't fit the question
  3. You can save yourself the pause by looping and waiting until the closing HTML tag appears, that way you'll know the page has loaded and you don't need to depend on an arbitrary pause.
  4. No, it is not a FM script command, it is an OS command. So you'd use it in a batch file or a VBscript or a PowerShell scriptl whatever IT is most comfortable with. In its simplest form (a batch or cmd file) it would look something like this: fmsadmin pause -y -u soliant -p testing vssadmin create shadow /For=D: fmsadmin resume -y -u soliant -p testing soliant / testing would be the FMS admin console credentials, the /For=D: specifies that the D drive should be snapshot.
  5. By design. It treats the "-" as a dash and will increment in the number that comes after.
  6. All or nothing. FMS is not VSS-aware so it is not safe to use unless the FM files are first stopped or paused; pausing can be done without disconnecting the clients, through the command line (fmsadmin pause) so it can certainly be automated. AV requirements can be met through scheduled scans that exclude the live files and by picking a schedule time that does not interfere with FMS own backups. The one thing that can not be on is 'on access' scanning. 3rd party backup that works at the file level can be made safe that way... provided that it does not run when FMS is doing its own backup. Mind the progressive backups if you are using those; you can't control when those run. You can control the interval but they will start when the db engine starts so the exact runtimes are unpredictable from one server reboot to the next.
  7. With "hosted' they probably mean that it is a virtual machine, not a physical server. Just ask; there is no shame in asking. Certainly do ask what they mean by 'hosted'. Is it a physical or virtual machine in the cloud? (Amazon AWS, Microsoft Azure,...?). If it is a cloud machine then all your client connections will become WAN instead of LAN and that could very well impact the user's experience. If you are worried about performance then make sure you have a performance baseline. Turn on the FMS stats.log on the 'logging' tab in the FMS admin console. It is off by default and tracks performance data across the 4 traditional bottlenecks (disk i/o, processor, network throughput and memory). Safe that file when you cut over to Windows. That file will give you something measurable to compare against when you do the same monitoring on the new server. Numbers don't lie. One thing that I would insist on: since you now have an 8-core machine, I would ask for the same on the new machine. That is a more important fight than the memory. The 16GB of RAM is more than enough. Don't kid yourself on the 'optimized for db performance'. The Mac Pro is no no way optimized as a database server. It's beefed up workstation with a waste of GPU power for its role as a server. Don't use this as an argument with IT, you'll lose all credit. If this is a virtual machine changes are that they are using a SAN as the disk sub-system and that it is driven off of SSDs anyway. But ask. Fitch's point about the backups is absolutely vital. FMS is not SQL Server and has different requirements for how backups are done. No 3rd party backup or Anit-virus shoud touch the live files or the backups while they are in progress. These days, Windows backups are usually done through the Windows Volume Snapshot Service and if it is a virtual machine then often through a snapshot of the whole virtual instance itself. When you restore from such a snapshot at a minimum: - the FM files will come back as 'improperly closed' because FMS did not have a chance to put the files in the proper state before the external backup was done - at worst the FM files will not open again because they will be damaged The Windows tools can be made safe by integrating them with the FMS admin command line to first pause the files and resume them afterwards. Not too difficult but requires some work with the IT department. I mentioned anit-virus: many IT departments will configure AV and insist that 'on-access' scanning is on. That can lead to all sorts of problem as the AV tries to scan the files every time FMS writes to them. That should be turned off. There is a FM knowledge base article that you can use here to give to IT.
  8. Reconsider that. There is a huge upshot in keeping field names 'standards-safe and use only a-z, A-Z, 0-9 and the underscore. The 'dot' is the delimiter between a table name and a field name in SQL for instance.
  9. You can still buy a license of FM without a subscription... But if you make a living out of it or your business gets good value from it then going with a maintenance renewal makes a lot of sense.
  10. You've mentioned that twice but it is not clear to me what you mean. Is your goal to have just one TO per base table? And if so, why? What specific problem would that solve for you? Or is an abstract notion? Abstract notions is what gets a lot of us in trouble, premature optimization, unneeded modularity,... that kind of thing.
  11. As long as you think that you will be no closer to solving this. FMS does not change the permissions on a file or change anything at all in the file. It just does not. So something else changed: - either you or someone else with full access changed the security settings of the file - either you or someone else with FMS admin console access changed the setting to allow or disallow files with no pw to be hosted - or the deployment is flawed, doesn't follow best practices and the file got damaged in the process
  12. On windows it would be a 1-line CMD file: fmsadmin list schedules -s -u ABCD -p 1234 >"c:\program files\filemaker\filemaker server\data\documents\schedules.txt" save that CMD file in the FMS scripts folder and them make a new FMS script sequence schedule that first runs the CMD file and then the import script.
  13. Virtually impossible to troubleshoot remotely if you say that all of those things are configured. Is port 80/443 also open and forwarded? If so you could test that remotely against the sample file to see if you can even get to the server.
  14. There is no change in how you access your FMS15 from the outside, it is still the same way as it was with FMS 5.5: - no firewall on Windows blocking port 5003 - no firewall on the router blocking port 5003 - port forwarding on the router on port 5003, targeting the internal static LAN IP address or DNS name of your FMS box - remote client using the WAN IP address of the router, or some DNS name that is properly mapped. You don't need port 16000 unless you also want remote access to the admin console.
  15. The other thing you can add to your sequence is run the 'fmsadmin list schedules -s' command to get a good overview of what schedules are set up, which was are enabled and their last run status.