Jump to content
  • Welcome To FMForums

    Welcome to our community, full of great ideas on developing your FileMaker solutions effectively,
     for peer-to-peer support of the FileMaker Platform and related products and services. Register and join the conversation!

     

    fmf AD.jpg

     

     

All Activity

This stream auto-updates     

  1. Yesterday
  2. moved this topic under ScriptMaster360
  3. When opining the FMS localhost I try to enable the ScriptMaster Plugin. For some reason I click to enable the plugin, I sometime been able to click on save sometime.. However, each time I close the host reopen the FMS localhost, the plugin is ALWAYS disabled. Would someone have an idea? With regards! Daniel
  4. Demo file: virtual-portal-v2.zip (requires FM 18 or later) This is a quick follow up to the Virtual Portal article I posted the other day. As you may recall, the objective was to use virtual list to display disparate entities in a portal… …via an array like this… …which was auto-generated via a Hide Object calculation… Continue reading Virtual Portal, part 2 View the full article
  5. Thanks for the response sir,i'll try this right away when i got back to office.
  6. Once I re-set the permissions on the relevant folder - and rebooted the Mini - and changed the subfolder entry to ONLY the name of the subfolder - in this case - only 'DepotMaestro' - all was good. Thanks Josh, Bev, Kirk et al in Friday Night Chat
  7. Last week
  8. This was answered in a support ticket but wanted to post my response incase others had this same question
  9. Looking for instructions for Mac? Click here! Let’s Encrypt is a non-profit certificate authority with the mission of spreading the SSL love across the internet. Though they’re not officially supported, we can use Let’s Encrypt to get free SSL certificates to use with FileMaker Server. We will use a PowerShell script and the Windows Task Scheduler on Windows Server to retrieve and automatically renew SSL certificates through Let’s Encrypt to make sure our connections to FileMaker Server are secure. With this, there’s no reason anyone should have an invalid SSL certificate on their FileMaker Server deployment! FileMaker does not explicitly list Let’s Encrypt as a supported SSL vendor, but does say that “Any SSL certificate can be used with FileMaker Server as long as the corresponding intermediate certificates are imported as well.” (FM Support). This process handles the intermediary certificates as required to make the connection display as secure. Requirements: FileMaker Server deployed on Windows Server – 2012 R2, and 2016 but may work with other versions. The “FileMaker Database Server Website” page must be reachable through the public internet using a web browser at the address you wish to get an SSL certificate for, such as http://myserver.mycompany.com. This means opening or forwarding port 80 in your router, firewall, or security groups. We use the Let’s Encrypt HTTP verification challenge, so we must make sure that Let’s Encrypt is able to reach our FileMaker server through HTTP. Here’s a summary of what we’re going to need to do: Download the GetSSL.ps1 PowerShell script Download le64.exe Edit the GetSSL.ps1 file Change Windows security to allow PowerShell Scripts to run Test the PowerShell Script Disable Test Mode and Retrieve The Real Certificate Enable Admin Console External Authentication (FMS 17 or later) Set up a schedule to renew the SSL certificate 1. Download the GetSSL.ps1 PowerShell script First, you’ll need a copy of the GetSSL PowerShell script. Download the file using the link below and save it on your server where you’ll want to get the SSL certificate. Download 2. Download le64.exe This script uses the le64.exe program from https://github.com/do-know/Crypt-LE/releases. Download the le64.exe program and store it in a permanent, accessible location on your server such as C:\Program Files\FileMaker\. 3. Edit the GetSSL.ps1 file The script file needs to be edited so that it know the address you wish to get an SSL certificate for as well as some paths on your system. Right-click on the ps1 file and select edit to open a text editor. Change the certificate domain, email address, le64.exe path, and (if necessary) the FileMaker Server install path variables to reflect your server’s information and your contact information. Let’s Encrypt will use this contact information to reach out to you if there is a problem with the SSL certificate that they have issued to you. 4. Change Windows security to allow PowerShell Scripts to run Windows Server will not allow you to run PowerShell scripts by default, so you’ll need to modify your security settings to allow this. Open PowerShell or PowerShell ISE as Administrator using the “Run as Administrator” option and enter the command: Set-ExecutionPolicy -Scope LocalMachine Unrestricted Enter “y” and press enter to accept the security warnings that appear. If you’ve copied this file to your server though RDP or over a network you should be fine here, but if the file was downloaded directly to the server from this site there may be another “downloaded from the internet” warning that you’ll have to clear. Place the file in a semi-final location and unblock it using the Unblock-File command, passing in the path to the file as a parameter. Here’s an example for if the file is located on the root of the C drive: Unblock-File -Path C:\GetSSL.ps1 Note: PowerShell must be Run as Administrator for this step and all subsequent steps, or you will receive errors. Be sure you are running PowerShell or the PowerShell ISE as Administrator using the “Run as Administrator” option, not just a user named Administrator. 5. Test the PowerShell Script WARNING: Running this PowerShell script will safely restart your FileMaker Server service, abruptly disconnecting any active users. Make sure that nobody is connected to your server before you run this script. We’re now ready to test the PowerShell script and retrieve a test certificate. Make sure nobody is connected or using your FileMaker server and then run the GetSSL.ps1 PowerShell script by navigating to the directory you have it copied to in your PowerShell window and entering: .\GetSSL.ps1 A bunch of text will scroll by in the PowerShell window as the script requests, fetches, and installs your SSL certificate. Your FileMaker Server service will then be stopped and started again automatically. Watch the messages which appear on the screen and look for any errors. If you do see errors the error message may tell you where the problem is with the retrieval of your test certificate. Assuming things went smoothly, your test SSL certificate should now be installed! Go to your FileMaker Server admin console or try connecting to your FileMaker Server using FileMaker Pro. You may need to close and re-open your browser if you had the page open already. If you’re trying to use FileMaker Pro to test the connection you will need to completely quit and re-open FileMaker Pro to see the new certificate. The new certificate should show as invalid due to the an invalid certificate authority, but should show your correct domain name. This is good, and means that the test was successful. 6. Disable Test Mode and Retrieve The Real Certificate The PowerShell script comes set to run in test mode by default. If you’ve been able to successfully retrieve the test certificate it means that it is now safe to disable test mode. Change the $testMode variable in GetSSL.ps1 from 1 to 0. Save the file and run the PowerShell script again like you did in the last step. Once it’s finished installing, completely quit FileMaker Pro and your browser and then re-open to test the certificate installation. If you see the green lock icon it means you’re done! 7. Enable Admin Console External Authentication (FMS 17 or later) FileMaker Server 17 now requires entering a username and password for the process of installing a certificate through the “fmsadmin certificate install” command. This is a new feature of FileMaker 17, and is not a part of earlier versions of FileMaker Server. We need to handle this request for authentication information in our process of installing a certificate. This request can be managed in one of two ways: A. Use the external authentication for the FMS Admin console to allow the user running the GetSSL script access to the admin console. B. Include the username and password in the GetSSL script. Option B would require the admin console username and password to be stored in plain text, and would be insecure. Because of this, we recommend option A and enabling external authentication for the admin console. Configuring this feature will prevent the command from asking for authentication information if the user running the command is allowed access to the admin console. In step 9 we will need to specify a Windows user with administrator access who will run the GetSSL script to renew and install the certificate. We want to make sure that this user will also have access to the FileMaker Server Admin console using its Windows username and password. We need to configure FMS to allow this user to log in to the admin console by specifying a group that the user is part of. If you’re using Active Directory you’ll be able to select a group from AD which you want to grant access to the FMS Admin console. If your server is not part of an Active Directory domain you can use a local group on the computer for this access. A good option for this is the “Administrators” group, since our user must be an administrator anyway for other features of the script to work. In the FileMaker Server Admin console select the Administration menu at the top, then External Authentication from the list on the left side. There are two places we need to adjust. External Accounts for Admin Console Sign In – Click the “Change” option and specify the group which should be allowed to access the FMS Admin console. “Administrators” is a good value to use here if you’re not using Active Directory. Click “Save Authentication Settings” to save your entered group name. Admin Console Sign In, External Accounts – switch this to “Enabled” to allow the group specified above to log in. 8. Set up a schedule to renew the SSL certificate SSL Certificates from Let’s Encrypt are only valid for 90 days and must be renewed before that time. Let’s Encrypt does this purposefully to encourage automation and increase security. In that spirit, we should set up an automatic renewal for our SSL certificates so that we don’t need to manually re-run this every couple of months. This process is similar to setting up a scheduled script in FileMaker Server. Move the GetSSL.ps1 file to a relatively permanent location on your server and then open the Task Scheduler, which we will use to set up a new scheduled task. Once you have the Task Scheduler open, right-click on the Task Scheduler Library icon on the left side of the window and select the “Create Basic Task” option. Give your task a name and description so that you can recognize what is is and then press Next. Select a frequency for this task to run. Daily is a good setting here, and then on the next screen you can set it to recur every 80 days. The SSL certificates from Let’s Encrypt are good for 90 days at a time, so this will give us over a week’s leeway. Enter “PowerShell” in the “Program/script:” field. Enter the path to the GetSSL.ps1 script in the “Add arguments (optional)” field. This should be a full path like C:\GetSSL.ps1. Click the next button to review, and select the “Open Properties” checkbox. Complete the setup and the properties window will open for you to make final adjustments to this schedule. You can edit the triggers and scheduling here, but the important thing we need to do is change the security options. Select the “Run whether user is logged o nor not” radio button and enter your password to allow the script to run even if you’re not logged into the machine. Also be sure to check the “Run with highest privileges” option to make the script Run as Administrator, which is required for the script to work properly. For FileMaker Server 17 it is important that the user you enter here is allowed to log in to the FMS admin console through external authentication, as described in the previous step. Done! That’s all that you need to do! Your script should run automatically at your scheduled time to renew your SSL certificate with Let’s Encrypt. Do a test to make sure that it’s all working properly, that it gets a new certificate for you, and that your FileMaker Server service restarts after it has retrieved the certificate. If there is an issue, you may want to run the script manually in PowerShell or debug with the PowerShell ISE to locate any issues. Keep in mind that your FileMaker Server service will be restarted after getting the new SSL certificate, so be sure to schedule it for a time when people will not be active in your system. This is an early version of this script and there is quite surely room for improvement. Please let me know if you have any suggestions or run into any issues using this scripting. Let’s make the FileMaker community a secure one! The post How to Use Let’s Encrypt SSL Certificates with FileMaker Server for Windows v2.0 appeared first on Blue Feather - FileMaker Developer, Android, Web. View the full article
  10. @bcooney Thanks for the response. I was trying to figure out a workaround and somehow I missed the notification from the forum so apologize for my delayed response. So, the portal essentially displays 3 fields - status, symptom, and notes. on any given interaction, I will update the status and/or notes related to the name. Doing either triggers setting up a new record in the client interaction table and copies the values over to that table (status, symptom, and notes) via SetVariables, etc. However, now if I go to the same field on another interaction, the values from the previous interaction is still stored in the status, and notes field. I need this to reset for every new and unique interaction. I have attached a screenshot of to help show the issue. In the example, once this is done for one client on a unique interaction, the system will create a new record as expected/needed. But, on the next client/interaction, the values shown under the laptop category for status and notes will still be selected and I need them to reset to being blank. Category is just a linked Table and a portal of its own in this view. selecting the category filters the next portal to show the appropriate and associated status, symptom, and notes.
  11. Learn to make highly efficient FileMaker custom apps that perform well on FileMaker Server or FileMaker Cloud by utilizing "lean design". In part nine of this course, we explore how fast the List function is and how much it can speed things along. To watch the rest of the Lean Design Course and download the free sample files that go with it, visit: https://fmtraining.tv/marketplace/lean-design.html support@rcconsulting.com www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com
  12. When opining the FMS localhost I try to enable the ScriptMaster Plugin. For some reason I click to enable the plugin, I sometime able to click on save sometime not able. However, each time I go back to the FMS localhost the plugin is ALWAYS disabled. Would someone have an idea? With regards! Daniel
  13. Wim Decorte

    Login

    What do you mean by "introduces the name and password" If you are thinking of creating your own login screen keep this in mind: in order to get to your screen you have to auto-login everybody and anybody without challenge first. Which does exactly what it means: it lets *everybody* into your solution unchallenged before your scripting and UI takes over. That's called 'roll-your-own' or 'ersatz' security and has traditionally proven to be very weak and easy to break. Doubly so if you actually want to use your own table of users and passwords instead of native or external accounts. If you want to customize the login, consider using an OAuth provider where you can customize the login page, which would keep all of it part of the native security scheme.
  14. Hi Comment, Thankyou, and I did not mean to scoff at your advice. I know that such changes would be difficult to manage in a multi-user environment. I really know that a lot COULD go wrong doing this, however, the solution you put forward will work for my purposes. Cheers. Greg
  15. You ask jokingly, but I will answer in earnest. There are two things that could wrong: User A arranges records in order A. Then User B rearranges them in order B, thus defeating whatever purpose User A had in mind. User A tries to put them back in order A - to the frustration of UserB. Repeat as necessary. User A tries to arrange records, but keeps getting errors because other users happen to be editing some of the records being moved. Those are the pitfalls of re-ordering records by modifying them (plus there is the issue of "last modified" becoming meaningless). There are alternatives, but we don't know if they will fit here because we don't know the purpose of reordering.
  16. Hi Comment. Thank you again. At first I was just going to change the order_num value of the current record (being moved) to less then that of the number below it - but swapping it would be cleaner, so I will do that. it is multi-user environment so I will have to test it thoroughly to see how it goes. 'What could possibly go wrong?!" Cheers, Greg
  17. Thank you. I'm toying with the post edit todo script to add the current date so that it is time sensitive... At least it's a work around. I saw that it's not something I can add while in reminders.. So by adding the post edit (add Date) this automatically adds that date field, then I can change it. Thank you
  18. HI all - I have two folders inside of the Databases folder which contain numerous files - these are DepotMaestro and TCM. I am trying to setup backup schedules for each of the subfolders. The path I am using is for the subfolder is: filemac:/NewMiniHD/Library/FileMaker Server/Data/Databases/DepotMaestro/ filemac:/NewMiniHD/Library/FileMaker Server/Data/Databases/TCM/ Both show the Not A Valid Path error. What am I doing wrong? Mojave, 18.0.3.319
  19. lewisandrea

    Login

    Hello! How to create a personalized login system, one that introduces the name and password?
  20. Our people out in the field take photos which go directly into the container fields, we would like those photos to automatically transfer to the camera roll/gallery. I know there is an export command and that would allow the techs to export and choose the location, save image etc... But that is a tad too complicated for them. Any suggestions on how to automate this process, the script for export field contents doesn't have a choice to save to camera roll. Thank you! Caroline
  21. Knowing how to take advantage of Server Side scripting within FileMaker is quite critical when you want the best performance possible. Of course, it makes total sense that you'll get the best speeds when working with the data where it's most accessible. The trick with creating scripts which will also work on the server side is being very specific with the context of things. There's also the very important choices of which method you're going to use. In 2018 I covered a method using a dedicated table occurence which is perfectly viable today. However, I didn't show the other methods possible and we also got some newer features which allow us to do things even more differently. This video shows you how to write a script which will duplicate related record sets and do so using the method of exporting and importing. I also cover a method which uses JSON in order to replicate a set of related records. This code can be used in many more places than just duplicating related record sets. I hope the content helps you advance your level of FileMaker development knowledge. Click the title or link to this article to view the video. View the full article
  22. Knowing how to take advantage of Server Side scripting within FileMaker is quite critical when you want the best performance possible. Of course, it makes total sense that you'll get the best speeds when working with the data where it's most accessible. The trick with creating scripts which will also work on the server side is being very specific with the context of things. There's also the very important choices of which method you're going to use. In 2018 I covered a method using a dedicated table occurence which is perfectly viable today. However, I didn't show the other methods possible and we also got some newer features which allow us to do things even more differently. This video shows you how to write a script which will duplicate related record sets and do so using the method of exporting and importing. I also cover a method which uses JSON in order to replicate a set of related records. This code can be used in many more places than just duplicating related record sets. I hope the content helps you advance your level of FileMaker development knowledge. Click the title or link to this article to view the video. View the full article
  23. Spawn a regular window off-screen. Pop the card window from that. Then the user can't move. It will need to be based on it's own file, or the user won't be able to do anything else with any window. Generally, I'm not a fan of forcing things on the user, unless absolutely necessary. So you will need to consider if that's really necessary vs just having a floating window they can place where they want. You may also need to do some dancing to make sure scripts don't inadvertently take over that launcher window. A separate file can go a long way in making that management easier.
  24. Demo file: virtual-portal.zip This is a follow-up to last month’s article on virtual list, and this time we’re going to explore a way to use virtual list in a portal. Imagine you have built a system where a Company can be a parent of a Mill, Refinery, Estate, or another Company. Each of these entities… Continue reading Virtual Portal View the full article
  25. Can't you use some more "convoluted math" to prevent this from happening?
  26. A few random notes: 1. You can move a record up/down by exchanging its order_num values with the preceding/following record. 2. You can move a record to the top of the list by setting its order_num value to the minimum of order_num - 1 (in your example, that would be 0). If necessary, you can use the Replace Field Contents step to renumber the entire found set at the end. 3. Re drag and drop, see if these can help: https://fmforums.com/topic/93510-containers-drag-and-drop-script-triggers/?tab=comments#comment-427732 https://fmforums.com/topic/67781-script-triggers-and-drag-drop-incompatible/?tab=comments#comment-322507 4. Keep in mind that re-ordering records manually can be problematic in a multi-user scenario.
  27. Same thing happened to me on just one machine and simply copying the certificates over didn't fix the problem as FileMaker repeatedly overwrote root.pem with its own incomplete copy. Broken root.pem only contains a single certificate which belongs to FileMaker. Working root.pem contains a lot more certificates belonging to certification authorities. certifiedroot.pem will be completely missing as well. The band-aid fix is a bit unwieldy but it works. save a copy of root.pem and certifiedroot.pem from a working installation or attached to this post to Downloads folder, then open a terminal and issue the following commands chmod u+x ~/Library/Application\ Support/FileMaker/FileMaker\ Pro\ Advanced/18.0/ cat ~/Downloads/root.pem > ~/Library/Application\ Support/FileMaker/FileMaker\ Pro\ Advanced/18.0/root.pem cat ~/Downloads/certifiedroot.pem > ~/Library/Application\ Support/FileMaker/FileMaker\ Pro\ Advanced/18.0/certifiedroot.pem chflags uchg ~/Library/Application\ Support/FileMaker/FileMaker\ Pro\ Advanced/18.0/root.pem The cert problem has been with FM for ages, apparently. A similar problem occured in version 9 and 11. Why it had to re-appear now is anyone's guess. certifiedroot.pem root.pem
  1. Load more activity
×
×
  • Create New...

Important Information

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