Jump to content

Dr. Zathras

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Dr. Zathras

  • Rank
  • Birthday 05/06/1962

Profile Information

  • Industry
  • Gender
  • Location
    Maryland, USA

FileMaker Experience

  • Skill Level
  • FM Application
    16 Client

Platform Environment

  • OS Platform
  • OS Version
    10.12 Sierra
  1. We're running FMS 16.0.4 on Windows Server 2012 R2 and Java 8 U181 and everything is fine. Unfortunately our IT security people want me to take Java to v8 U201 and I've been caught by Java updates breaking control of FMS in the past. Does anybody have any experience on using FMS 16.0.4 and Java v8 U201? Thanks. Colin Hunter
  2. We use WuFoo for data gathering over the web and then import the data on a nightly basis into a FMP database from an exported tab-delimited file. We've been doing this for a couple of years but WuFoo recently changed the way they encode attachments they no longer pull into the database. I had a simple script step using "Insert from URL" which read the URL from the exported WuFoo file and put the linked attachment into a container field but that no longer works and I can't figure out why. WuFoo tech support is unfamiliar with FileMaker so I'm hoping somebody here can help. An example URL is <https://umbforms.wufoo.com/cabinet/a060c9ed-3210-49e4-9882-55cebf863e8c>. If you run that from a web browser you get the downloaded file nttac_schedule.pdf but "Insert from URL" produces nothing in FM. Anybody have experience with pulling uploaded files from WuFoo knows why "Insert from URL" doesn't work with these URLs?
  3. FMS 11 is officially unsupported on OS X 10.9 but I've experienced no problems serving 40 databases to 25 FMP clients and 1 database over the web via custom web publishing from this Mac. Yes, at some point we will upgrade to a version of OS X which Apple is actively supporting and as you note we'll then need to convert our databases to FM 12 format to run on whichever version of FMS/FMP is compatible with the new OS. Not a trivial task and with everything stable and everybody happy (other than the security auditor) there have been no complaints. Nevertheless we need to be secure but we can't jump to OS X 10.12 on this server quite yet. I installed a new Apache/OpenSSL but was unable to persuade FMS 11 to see it so I'm going to follow ggt667's recommendation and go down the nginx path. His advice to leave what works running and have nginx serve as a reverse proxy to 10.0's Apache is an elegant solution but I'm somewhat out of my comfort zone with the necessary configuration steps. Hopefully I can figure it all out but may return for additional advice if I get stuck. In any case, many thanks for the replies and especially to ggt667 for suggesting a solution I would never have thought of myself. Colin
  4. I'm running FMS on OS X 10.9.5. It's serving forty databases, one of which is served to the web via custom web publishing. Everything is running smoothly but the campus security auditor is picking up a vulnerability with the old version of OpenSSL running on OS X 10.9.5's Apache. I addressed this on a different, non-FMS Mac by disabling Apple's bundled Apache and using MacPorts to install Apache2. How to do this on my FMS 11 Mac? Just getting MacPorts to install Apache2 is the first problem as port install apache2 fails with a conflicting ports message. I assume this is because the existing Apache is blocking installation of the new version but how to stop the existing one? I tried turning off web publishing in the FMS admin console but port install still fails with the familiar conflicting ports message. Even stopping the web server with Mark Banks' FMSControl didn't help. I therefore have a couple of questions: How do I stop the existing Apache so MacPorts will install Apache2? Once I have Apache2, how do I get FMS11 to use it instead of Apple's bundled Apache1? Thanks Colin
  5. That's perfect, and lightning fast to boot. If we ever meet I hope you'll allow me to buy you a beer or whatever liquid refreshment is your preference in thanks.
  6. I need to be able to standardize the contents of a field to just the characters after two letters, including the two letters. It's easier to give a few examples rather than describe the calculation: R01AR064810-01A1 -> AR064810-01A1 AR064810-01A1 -> AR064810-01A1 DA035813 -> DA035813 F32NS084680-01A1 -> NS084680-01A1 14SHSP603-01 -> SHSP603-01 T32AI007524 -> AI007524 In other words, the calculation needs to examine the text string, find the location of two letters next to each other (there will only be a single occurrence of two letters next to each other in the string), then delete everything to the left of the two letters. Is such a calculation possible in FMP 12 or 13? Thanks
  7. Thank you for your reply but I couldn't find the "Go to Related Record" command - is that in a FMP version after v13? In any case I did a work-around by creating another table with just one field and imported the calculated match field from Table B into the field in the new Table C. Since this is now a regular field it can be used to relate to the match field in Table A and I'm good to go. Importing 70,000 records from Table B takes a few minutes, even though it's just one field but it's definitely something I can live with. I now have another question regarding my calculation of the match field but it deserves a new topic. Again, thank you for your help.
  8. Thank you for your reply but when I define a relation between the two tables using the unique match field and display the match field on Table A it's empty for every record. In fact I don't get data in any related field from Table B displayed in Table A, even though there are matching fields. I now realize I missed an important fact: the Table A unique field calculation is stored but Table B is sourced via an ODBC link to an Oracle database so its unique field calculation is not stored and the relationship does not work. Is there a way to create a stored snapshot version of the unique match field in Table B or will I need a different approach?
  9. I have two tables - one is an import from an external source which contains the master data set and the other table contains hand-entered data overlapping the data in the first table. Sometimes people make mistakes entering data from the master table and sometimes they miss a record entirely. I have a calculated field in each table which is unique to each record, but which matches across the two tables. Is there a way to compare the records in Table B with the Records in Table A, and using the unique field determine which records are in Table A but are missing from Table B? We're mostly using FMP 12 but can go to 13 if necessary. Any help or general pointers how to approach this would be most welcome. Thanks
  10. Anybody find a fix for this problem? We have the exact same issue (FMP 12.0v5) with the background turning red in Preview mode in a database which suddenly started exhibiting the issue after months of trouble-free operation. Thanks, Colin
  11. We have a dual-server FMS 13 setup with FMS's web portion running on Mac OS X 10.8.5. We have a database using multiple SuperContainer web viewer fields accessed over FMS's WebDirect service. The WebDirect page uses SSL with a Geotrust primary + intermediate certificate setup at https://site-address/fmi/webd# and SuperContainer files are accessed over http://site-address:8020/. This all works very well, but with the major issue that the WebDirect page is secure but the SuperContainer fields are not. Web browsers throw up a warning that the page contains mixed secure and non-secure content and our users have to authorize the browser to display all content otherwise they don't get to see the SuperContainer fields. We need to simplify access for our users by making the entire page SSL-encrypted, so how do we get SuperContainer Server to use our Geotrust certificates and run everything over https? Thanks
  12. My wife is coming with me to the upcoming DevCon and wants to join in the fun for the Thursday evening attendee party. Does anybody plan to attend the conference but leave before the party and has an unwanted ticket? Thanks. Colin Hunter
  13. We're a university administration group currently running FMS 11 with FMP 11 desktop clients for our office users and a mixture of custom and IWP for people coming in over the campus network. It's time to upgrade to FMP 13 and we'd like to keep the local FMP 13 clients authenticating via the server's (running Windows Server 2012) Users/Groups but authenticate our web users via the campus' Shibboleth service. Has anybody any experience with Shibboleth and FMS 13, and can it be run alongside local Users/Groups authentication? Any information would be really appreciated. Thanks. Colin Hunter
  14. This technique is excellent and exactly what I need for a database where I have to insert a file into a container field and rename it based on the record identifier and a few other criteria. The only problem I'm seeing is with PDFs the renamed file in the container field displays as "The file cannot be displayed: filename.pdf". Every other file type I've tried (doc, docx, gif, xls, jpg, etc) renders the same before and after the file name change but PDFs do not. The file itself is fine and if I export and reinsert the file it renders correctly but I'd much rather not have to export and re-insert the file every single time I encounter a PDF. This is with FIleMaker Pro 11.0v4 running on Mac OS X 10.6.8. So what's specific to PDFs which causes this problem and can it be fixed? Thanks.
  15. We're going to port our databases from FMS 11 on Windows Server 2003 to FMS 13 on Windows Server 2008 R2. The databases currently authenticate to the server's local users and groups and we're going to keep that when we go to FMS 13. However we'd also like to add external authentication via Active Directory. Can FMS 13 be configured to look to the Windows server's local users and groups first for authentication, then fall to Active Directory if the user isn't in the local directory? Thanks.
  • Create New...

Important Information

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