Jump to content

Mike Duncan

  • Content count

  • Joined

  • Last visited

  • Days Won


Mike Duncan last won the day on February 21 2016

Mike Duncan had the most liked content!

Community Reputation

13 Good

About Mike Duncan

  • Rank

Profile Information

  • Title
  • Industry
    IT Consulting
  • Gender
  • Location
    Carmel, IN

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  1. Self signed certificates will always show this error, since they are not signed by a certificate authority. The traffic is still encrypted, but the error will be there to show you that there are issues. To get rid of all errors, you will need a real certificate that matches your fully qualified domain name. Mike
  2. Virtual list using JSON

    A couple things that come to mind if you go down this path...there is a limit to how many variables you can set with a Let statement, 1000. And if you use the "JSONFormatElements" function, it may re-sort your data unexpectedly. I would consider JSON for passing variables, possibly, over using for virtual lists. Mike
  3. HTTP POST in WebDirect 16

    The only way I was able to get the homeurl to correctly redirect me after a session was to include it as a GET parameters in the action attribute, but submit the form as POST. However, that only worked if you successfully logged into webd. If there was an error, it redirected to a malformed address. I will submit it as a bug.
  4. HTTP POST in WebDirect 16

    You can redirect a user into a webd session with an html page with a little javascript like so... <form id="myForm" action="https://your_host_name/fmi/webd/YourFile" method="post"> <input type="hidden" name="user" value="yourUser" /> <input type="hidden" name="pwd" value="yourPwd" /> </form> <script type="text/javascript"> document.getElementById('myForm').submit(); </script> However, I would only use this to enable guest type access to a hosted file, and this is not really that secure, even if you have SSL enabled since the credentials are in the html. I have yet to find a way to redirect using POST, so for now, I would use with caution. Mike
  5. Webdirect on Android random formatting loss

    What browser are you using? And what version of FM Server is serving webd? https://www.filemaker.com/products/filemaker-server/server-15-specifications.html This page states that only Chrome 48 minimum on Android 5.x and 6.x is supported. Your device also needs to meet minimum requirements for RAM, processor. Mike
  6. Webdirect stopped working

    At a minimum I would try to run the deployment wizard again. After that, you can try to reinstall FM Server. What usually works is a "clean install" of FM Server. That means back up all settings and files, stop the server, uninstall it, delete the directory from Library and reinstall it all from scratch. I have especially found this if you have the Server.app installed, as it turns on its own web server, regardless if you have it on or not. If you do have that installed, make sure you turn off web services before reinstalling FMS.
  7. You can pass multiple parameters with the same name as long as you pass them as an array. So like... name[1]=Homer&name[2]=Bart Then you can loop through that array to get the values in your web script. In php you can use a foreach to loop through. In fact, I sometimes pass delimited data in this way to keep the payload size down and break it out in php as a multi-dimensional array. so r[1]=Homer,Simpson,Dad&r[2]=Bart,Simpson,Son becomes... foreach ($_REQUEST['r] as $key => $value) { $items = explode($delimiter, $value); $this_first = $items[0]; $this_last = $items[1]; $this_role = $items[2]; # do something with this data here... } Hope this helps, Mike
  8. Export Field Contents on Server

    The Base Elements plugin has a function to export field contents. You will need to install the plugin on the server, then you can use it when performing a script on the server.
  9. Desktop Rollout

    I think what Ted S was recommending was to create a shortcut to the URL, using a FMP URL scheme that would launch FileMaker and open your remote file from the server. This is like a bookmarked URL you would use to open a web page, and not an actual FileMaker file. That could then be put on a shared file server, since FM isn't actually opening it, and it just launches FM to open the correct file. Does that make sense? Mike
  10. Email Alerts

    This will work and is easy enough to script. If you need an SMTP server and you're using AWS anyway, you can configure the SES (Simple Email Service) and send through there. No worries about configuring and establishing your own SMTP server and it is very reasonably priced. If mail volume is low enough and you have a new AWS account, it will likely fall under their free tier. Mike
  11. Does the SMTP server matter here? I have seen some strip some headers out, like gmail will only send from addresses that it is configured to work with.
  12. Does the SMTP server matter here? I have seen some strip some headers out, like gmail will only send from addresses that it is configured to work with.
  13. Load Data Local Infile SQL Query

    I am not sure that SQL command is supported in FM. Are you saying the Sequel Pro uses it to insert into it's own database, or that it inserts it into your AWS RDS hosted db? Also, does the ODBC driver support that syntax? It might be a limitation there.
  14. FilePath calculation / FMServer

    You need to figure out how the NAS drive is shared with Macs, and can you depend on that share being mounted on and Macs? You might have more luck if the place you are uploading to also has some web server running to share those files as well, then you could use a web viewer to display the contents regardless if there is a share mounted in the file system, or even if you have the drive mapped for other Win clients. Macs do not reference external drives by mapping letters to them, and even if the share were named "Z" for macs, the path would still be different. That's not to say you can't figure out the path, but start by looking at how the drive is shared on Macs. Mike
  15. I'm guessing the WPE is not installed and running correctly. That could be because this is an unsupported version of Windows for this version of FMS. You could try to run the deployment wizard again or re-installing, but it may not work.

Important Information

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