Jump to content

Mike Duncan

  • Content count

  • Joined

  • Last visited

  • Days Won


Mike Duncan last won the day on August 10 2017

Mike Duncan had the most liked content!

Community Reputation

14 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. Export data in excel in multiple worksheet

    I have a sample file you can get for free that uses javascript to output an excel file with multiple sheets. You can get it here: https://github.com/SoliantMike/FM-js_ExcelSheets It uses a javascript library and is all open, so you can modify to your own needs. Mike
  2. export container contents of found set

    If you have Webdirect running, you might also be able to host a PHP file and have it do some work as well. I have some sample files that show how to zip container data and serve it to the end user as one file. You can download the sample from my github repo here: https://github.com/SoliantMike/FM-WebDirect_Zip Mike
  3. FMS 16 SSL, problem with port 5003

    I do not concatenate the intermediate cert. There is a separate field in the FMS admin console when you import the certificate to specify the intermediate.

    Is upgrading to FileMaker Server 16 an option? Because that version does support saving as PDF from the server.
  5. I suppose not, but have you looked at it with the dev tools in your browser? Just to make sure the path is correct?
  6. By default, FMS adds an extra http header to all content served from the built in web server. The extra header is "X-Frame-Options" and is set to "SAMEORIGIN". This is done to prevent webdirect being included in other pages. You can go in and modify that if you like. In IIS manager, select the FMWebSite, then the HTTP Response Headers, and you can remove it from there. Also, make sure if your main website is served via https, that the iframe references are also served via https. Mike
  7. Backing up FM Pro without closing

    You could use an onTimer Script step, but it is really not that simple. You may also need to check if there are any open records and if any users have open records, that could cause a hold up. Is your solution shared on the networks at all? If so, then moving away from FM Server is a mistake.
  8. RAM required for FMS16

    Is this a production server? If so, I would up the ram to the minimum, at least. I have seen where the server seems to run OK for a while, but then exhibits issues after days/couple weeks and getting the proper amount of RAM and processor clears it up. I have a feeling there is a certain amount required to help with caching and swap space, no matter what size solution you are hosting.
  9. Using Citrix in AWS Server

    You can. AWS also has some other services that may save on licensing costs above citrix server. Check into AWS Workspaces and Appstream 2.0.
  10. Need more input on Filemaker Cloud and AWS

    AWS has a couple of interesting alternatives. Check into Workspaces and Appstream 2.0. Appstream is particularly interesting, as it can scale automatically, so you only pay when users are connected. Also, if you FM Server (cloud or regular server) is also in AWS, then your network latency between server and client is extremely low. You can have both client and server in the same region and VPC. Mike
  11. better way to go through data

    If you have to reformat the data and handle it anyway, why not use a simpler format like CSV or Merge and skip XML or JSON? I have had issues in the past with arbitrarily large XML when importing into FM, both slow and on occasion crashing. I would avoid invoking xalan and xerces for processing and parsing XML unless that is really needed. I think they work best for smaller XML files. I would also suspect arbitrarily large JSON would exhibit performance issues as well. When I have had to deal with lots of record as fast as possible, it was to grab data via a web viewer (or insert from URL) then export out to the file system and import directly to a table. Seems like this would be the fastest for you as well, if there are consistently a lot of records.
  12. Import XML to file from container?

    With FM 14 and up, I believe, there may be another way that does not involve a round trip to the filesystem. Create a text field and use base 64 functions to get at the text from the file in the container field. You can test by setting the text field to with this: Base64Decode ( Base64Encode ( your_containter_field )) This should work if your text files in the containers are not text encoded that might throw this off. Hope this helps, Mike
  13. IIS 8.5 reverse proxy to FMPS 16

    Is this for supporting WebDirect? or custom web publishing? For WebDirect, you are limited in options, it must be from a worker machine. For CWP, you can just reference the host in your code.
  14. IIS 8.5 reverse proxy to FMPS 16

    It sounds like you could just install FM Server on the IIS machine, and configure it as a worker, connected to the master server. I think you are essentially wanting a two machine deployment, and this is how you would set that up. Mike
  15. PSOS Export Records Error 800

    FileMaker Server is not able to export in FileMaker Pro format. This is documented on the Export Records script step here: https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/export-records.html Note the "partial" support for FM Server. Mike

Important Information

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