Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


xochi last won the day on June 15 2017

xochi had the most liked content!

Community Reputation

13 Good

About xochi

  • Rank

Profile Information

  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Some report of memory leaks in FMS 18: https://community.filemaker.com/en/s/question/0D50H0000787p8sSAA/filemaker-server-1802217-memory-leak
  2. I found this was also true with FileMaker Server 14 - you really need to run WebDirect on its own static IP address on the normal HTTPS port 443. If you don't, weird things can happen - although it may work with some clients, there may be issues for some companies that are running SSL proxy firewalls.
  3. Yes, in fact I couldn't get it working until I rebooted. I suspect that it might not survive a software update to FileMaker server, if those two files get edited during the upgrade.
  4. I figured out a way to get custom ports in FileMaker Server 17 so that it can coexist with macOS server 5.6.1 inside macOS High Sierra 10.13.6: Install macOS High Sierra + all updates. Then, install macOS server Finally, install FileMaker Server 17. If you get the "Apache is running" error, try to install again while running this terminal script (See https://community.filemaker.com/thread/156699 ) while sleep 5; do sudo killall -9 httpd; done After installation, control C the script to stop it. Then, after installation, you can change the ports that FileMaker Server is using by making 3 edits in two files: in /Library/FileMaker Server/HTTPServer/conf/httpd.conf change "Listen 80" to "Listen XXXX" (one place) in /Library/FileMaker Server/HTTPServer/conf/extra/httpd-ssl.conf change 443 to YYY (in two separate lines) (this assumes you want ports XXXX for HTTP and port YYYY for HTTPS) In theory, you should be able to restart FileMaker's apache process by : sudo fmsadmin restart httpserver But I found it didn't "take", however rebooting the entire sever seems to have fixed it. I now have a server running macOS High Sierra 10.13.6, with FileMaker Server 17.0.2, and macOS Server app 5.6.1 all running happily together. Note that macOS Server 5 does some weird things with port-mapping and proxies for services such as CalDAV which really want to run on 80 and 443. I found it much easier to change FileMaker's ports, rather than trying to change macOS server's ports. I hope this info can help others.
  5. That probably depends on their specific policies. One should note that FileMaker Server 16 can now generate PDF files, so one could probably do this in WebDirect using the "Perform Script on Server" command, and avoid needing a second "robot" user altogether.
  6. Thanks - it looks like that solution switches between Preview and Browse mode, which may be the only way to do it. I ended up scripting something somewhat similar: in Browse mode go record-by-record until I find that the RoomNumber has changed. Then make a new window, Constrain the found set to that single room number, save as PDF then close the window.
  7. I have a multi-page printout which is split with a page break for each sub summary part. Imagine for example a room inventory list where each room gets its own page. I'd like to save these as separate PDF files, so each room has it's own file, e.g. Room1Inventory.pdf Room2Inventory.pdf ... One way to do this is simply loop through the room numbers, and for each room do a Find / Sort / Preview Mode / Save as PDF. But I'm curious if this can be done a different way - what if I already am in Preview mode with a report showing all rooms (where there's a sub summary page break). Is there any way at this point to loop through in Preview mode and save each page into it's own PDF file? I can almost get it working like this: Find Record Sort Enter Preview Mode Loop set variable $roomNumber = Rooms::RoomNumber set variable $startPage = Get(PageNumber) set variable $endPage = $startPage + 1 set variable $file = "Room Number" & $roomNumber Save Records as PDF (output file=$file, options/include specific page: from $startPage to $startPage+1 go to next page, exit after last End Loop Two problems: 1. unfortunately, since I'm in Preview mode, Rooms::RoomNumber never changes, it's always showing the value on the first record in the found set, regardless of what page I'm on. 2. if the report is more than one page long for a given room, I need to figure out what $endPage should be.
  8. I'm a big fan of Arq Backup http://arqbackup.com which lets you back up to a variety of locations (onsite or offsite). I'm currently using a combination of Arq, TimeMachine AND SuperDuper backups on my Mac OS X (macOS) servers. The main thing to worry about is to avoid backing up live database files.
  9. For me, the lack of server-side-schedules is a deal-breaker. But, as you say, it's a version 1 product. Hoping they add this in the future.
  10. I have not tried it in 15, but as of 14 there is a new setting that seems to work without requiring CSS editing: Go to File / File Options / Open tab and click the Hide All Toolbars checkbox.
  11. I'm dealing with this too. What I've found is that: I ended up using the OnRecordCommit event which triggers a script which normally returns False which blocks the commit --- unless my "Save" button has been pressed. This is a common technique. What I added was this: The Save button calls a script which timestamp field indicating that the user actually pressed the Save button, and this is the flag that I use to indicate "was actually committed by the user on purpose". Then it Commits the record. So this way I can distinguish between two cases: New records that were committed on purpose, and new records that were committed on accident. You then need some additional logic to deal with records that exist but are missing the flag, but this is not that difficult. For example, you could have a server-side-script that runs every X minutes and simply deletes records in that state. Or instead of deleting the data, perhaps it emails the user to say "Hey, you left an incomplete entry, please fix it".
  12. That's always been a difference between OS X and Windows. On OS X, the scroll wheel never changes records, which is how I prefer it. So I would welcome this change, personally, although I can see how you might miss it if you were used to it.
  13. Definitely not ideal, but it will probably get the job done in the short term. I do wonder if there's some magical combination of settings I could have to make it work properly however.
  14. In Table view, if the user's Privilege set has "Available Menu Commands" set to "Editing Only" then they can not sort fields by clicking the table column header (the "Sort Ascending" and "Sort Descending" popup menu items are missing). I've tried installing a custom menu set that has the "Sort" menu item available, but "Editing Only" seems to override this. If I use a Custom Menu Set and also set Available Menu Commands to "All" then the Sort Ascending and Sort Descending popups are available in Table View, but the user also gets access to a bunch of confusing / dangerous options such as "Add Leading Grand Summary" and others. Is there way to tweak this? I want users to be locked out of all features in Table View except for Sorting by clicking the table headers.
  • Create New...

Important Information

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