Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


jayivan last won the day on November 3 2016

jayivan had the most liked content!

Community Reputation

1 Neutral

About jayivan

  • Rank
    jay ivan

Profile Information

  • Title
    senior consultant
  • Gender
  • Location
    Brooklyn and New York
  • Interests
    Current Active Projects:
    - Artist Foundation's Catalog Raisonne, Collections Management, and Inventory Tracking
    - Museum Artwork Catalog and Library Catalog
    - Music Label Asset Management, Tour Management, and Office Admin including integration with multiple websites via MySQL ODBC and Google Calendar (Zulu)
    - Nonprofit Membership and Publication Database: membership and dues management, and publication management (using tagged exports to InDesign)
    - Art Appraisal Workflow management (tracking of works and building of complex appraisals)

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification
    Not Certified
  • Membership
    FileMaker Business Alliance

Recent Profile Visitors

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

  1. One of my FileMaker Server 18 installs has been having a recurring problem for 2 months. It's on macOS 10.14.6 on an older Mac mini (2012) with a 2.3GHz Core i7 and 16GB RAM with 71% free space on the boot volume and 375GB free (of 700GB) free on the external backup volume. Disk First Aid has been run on all volumes. This recurring problem started in late May. Since we were in a work-from-home situation, no updates had been performed on this machine for quite some time prior to this behavior starting. Essentially, some server process is shutting down all databases at the same t
  2. I was having the exact same problem today following an upgrade to Catalina and FMS18 and called Claris support. SOLUTION: Open System Preferences-->Security-->Privacy-->Full Disk Access and enable "fmserver_helperd". It's a new Catalina security measure, and unlike other application installers, the FileMaker Server installer doesn't let you know you need to enable this.
  3. My employer uses a hub and spoke system for time tracking. Staff use a local file from their workstations to record time entries, and then push that time up to the main hosted FileMaker database. These local files also download client lists and job lists from the main hosted database. When offline, spellchecking the local file hangs for some time as it tries to connect to the hosted file. The local layout has no fields from the central database present on it. All other functions of the local file work without issue when offline. Why won't spellcheck simply check the local record I'm worki
  4. The SSL mismatch and Interactive Containers errors in macOS FMP bug persists. FMP/FMPA macOS clients (v15 and forward I believe) using bonjour browsing to connect to database will see ERROR when trying to play audio files in interactive containers (or cannot play videos or work with PDFs). Connecting via FQDN does not have this problem. But why should local clients have to go out through the WAN and back in? FileMaker Go clients and Web Direct clients will be warned about mismatch but can proceed and interact with containers. Windows FMP/A clients are fine as well. Only macOS FMP/A clients hav
  5. FileMaker emailed an alert to cloud customers warning that they may not be able to login to their FM Cloud console using valid credentials. My cloud 17 client did not have a problem logging in, but my cloud 16 client did. WARNING: Their support team is requesting administrators to send an UNENCRYPTED EMAIL containing the private key file to resolve this issue. But, they do have an FTP-TLS method for delivering this file. Make sure to ask for this info if you are also locked out of your server. Now, I'd rather not send them the private key file period since it is no longer private, but there s
  6. I was looking for a tool like this to understand how my FM changes impacted the call being made. Thanks for this! I've never used it and having a bit of a learning curve, but I'll keep plugging away at it. If I can get the tool working, it sounds like it will be invaluable as I expand my solutions to involve more and more API integrations.
  7. I am working on an API integration from FileMaker 17 to Emma. Generally when I work on a new API, I get the curl working on the command line and then translate that into FM. But I've hit a roadblock with one particular API call while my other API calls to Emma are successful. (In the example below, I substituted out sensitive data with all caps.) From the command line, the code is: curl -u USER:PASS -H "Accept:application/json" -H "Content-type: application/json" -X POST -d '{"fields": {"name_first": "TESTFIRST","name_last": "TESTLAST","eligible": "false","expiration": "@D:2019-06-30
  8. I have solutions that include a local file residing on a workstation that interacts with a hosted file. The local file does not need the hosted file for data entry; the connection is to download a job list and upload time entries. In FileMaker 16 and earlier, should the local file had been connected to the hosted file and there was a network interruption, the hosted file would reconnect or fail to do so, but the Local file would not be impacted. In FileMaker 17, if the connection cannot be re-established to the hosted file, the local file is now forced to close. That in and of itself would not
  9. After banging my head for a few hours, I figured it out shortly after posting lol. So for those who also missed it... when setting a daily backup schedule, change the dropdown underneath Time from "At" to "Between" and the hourly/minute repetition options appear.
  10. In recent FMS versions before FMS17, you could create a daily backup schedule that would repeat every X hours. I need that in FMS17, but those options are no longer available in the web admin, and I have yet to find a way to do this via the CLI. If I want to run a schedule every hour of every day, do I need to create 24 backup schedules like back in the day?
  11. UPDATE/RESOLVED 360Works support walked me through using the 360Works Admin.jar tool to stop and start the MirrorSync server to resolve this error. So, for the external server address, it seems to be fully possible to use a domain name whose public IP doesn't match the public IP of the router, and to ignore the IP-mismatch warning during configuration setup. But, you may need to restart MirrorSync to avoid errors caused by cached data. Unrelated to this, if you update the internal IP of the hosting server, or update the filename of the database, you may need to make adjustments manua
  12. I was able to successfully sync an FMGo 16 iPhone instance with our FMS16 server-hosted database when all interactions were VPN/LAN based. But in setting up public WAN access, I encountered problems I cannot work around and did not find documentation to address. We opened up our firewall to not require offline users to use VPN. Since we have redundant ISP, I used a hostname as the external address so users could connect over the secondary line if our primary was down. Each of our WAN connections has multiple public IPs, and the public IP assigned to the filemaker server does not match the
  13. Thank you Wim. And thank you for emphasizing the need to keep this directory restricted to FMS use–I was surprised that this configuration is now supported since these files should never be touched by anything but the FMS.
  14. I have 2 clients with a similar problem. Each are artist foundations, each about to receive a large volume of digitized video, audio and photography. A portion will be managed by FileMaker, and a portion will simply be stored in a traditional file sharing environment. Neither client can estimate what portion of the 20+TB of expected data will be managed by FileMaker and which by file server. One option is to simply get large RAIDS for both the file server and FileMaker Server, but we were hoping for a more economical and fungible approach to storage. Expandable network storage used by both sys
  15. Ha, you're right there, Comment. Thanks so much for sharing that post. The scripting suggested by the post is relatively simple, but the caveats numerous...record locking, time to execute on thousands of items, modifying record dates...and mapping out a more reliable and efficient way of dealing with those, as you've begun to map out, doesn't look pretty at all. Certainly time to stop working and checkin with the client to see if an internal report with these particular design requirements is worth the effort and time. Thanks again!
  • Create New...

Important Information

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