We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


ggt667 last won the day on June 6

ggt667 had the most liked content!

Community Reputation

6 Neutral

About ggt667

  • Rank
    Street Stupid, Nerd Stupid, Geek Wiz

Profile Information

  • Title
    Philosopher, Partner, and Keyboard Masseur
  • Industry
    Logistics, horticulture production
  • Gender
  • Location
  • Interests
    Trikke T12 Roadster, bouldering, DIY woodwork

Contact Methods

  • Website URL
  • Skype
  • AIM
  • MSN
    iMessage: ggt667@me.com and FaceTime

FileMaker Experience

  • Skill Level
  • FM Application
    11 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

3,777 profile views
  1. Raid server setup

    Note to self; never trust autocorrect.
  2. Auto import with dynamic name

    What is the issue at hand? I always do my imports using a $tmp variable works for XML for sure as I use this n times pr day. May also work for the file type of your liking. Set Variable[$tmp, Get( DocumentPath ) & table::filename] Import[$tmp]
  3. Perhaps making new layouts with all fields and no design will suffice in your case?
  4. [ANN] CWP User Group - Monday at DevCon 2017

    I use crontab in combination with postgres FDW( JDBC flavour ) and FX.php for dynamic data to feed the web depending on web load of the project, FileMaker as editorial tool and single source of truth; I use FX.php for writing data from the www to FileMaker.
  5. FileMaker lingo = unix / SQL lingo --- table = table table occurance = table as seen in a specific query layout = view AND / OR CUBE valuelist = sort | uniq as in ORDER BY relationship = part of query AND / OR CUBE You will add a record through a relationship aka related record, in Filemaker there is no need to fiddle with the keys and related keys, you just need to add a record in a related table through a relationship; possibly via a portal.
  6. How many machines? Why not just keep using FileMaker 15 on 1 machine if you are only 1 person?
  7. FQL? or SQL? SQL has this defined as standard: SUBSTR( columnname, 3, 2 ) // Where 3 is starting position and 2 is length of substring.
  8. My experience with installing older FileMaker with current OS is that it does not work as expected. However if you are able to install Mavericks as an example on your hardware, then install older Filemaker this will work, and if you upgrade to current OS, it will usuall keep on working. At least that's what I do for Filemaker 11 Pro Advanced. 1) Install Mavericks 2) Install FileMaker 11 Pro Advanced 3) Upgrade OS to lastest version This may or may not work for your FM 14 S as well
  9. What is the time spent on parsing intervals of 10 000, 100 000, 1 000 000 records 10 fields, datatypes mixed( timestamp, text[5-255], number )? Did you make a benchmark between FM and MBS's methods?
  10. newbie looking for advice

    There are also some videos on Vimeo: https://vimeo.com/search?q=filemaker
  11. Raid server setup

    Numbered RAIDs are obsolete. Do yourself a favour and read up on: O3X: https://openzfsonosx.org ) AFPS may work well for a workstation, for a server you will still benefit from running ZFS. I would say the correct setup is to move as much of your solution as possible to RAM. If you move your filmmaker files to the SSD RAID in essence you have moved them to RAM. The single most effective way to improve speed of any server service on a mac regardless of drive spec is to turn off spotlight; I see from your profile that you use Yosemite: sudo launchctl unload -w /System/Library/LaunchDaemons/com.apple.metadata.mds.plist According to this link: http://recomhub.com/blog/how-to-disable-or-enable-spotlight-in-mac-os-x-yosemite-mavericks-mountain-lion/
  12. You would really like to layer this with nginx as a reverse proxy; to reduce the traffic going in to FileMaker Server as follows: My web service is currently layered like this: nginx reverse proxy with gzip( This is the public IP with HTTPS ) -> REST API written in NodeJS w/express( HTTP on localhost ) -> nginx reverse proxy( HTTP on localhost ) -> FileMaker CWP I'm in the process of altering this to become: nginx reverse proxy with gzip( This is the public IP with HTTPS ) -> REST API written in NodeJS w/express( HTTP on localhost ) -> nginx reverse proxy( HTTPS on localhost ) -> FileMaker DATA API for testing
  13. Did any of you write a grok for logstash or find a way to analyse FileMaker Server logs using elk( elasticsearch / kibana? ) Not really picky on the version. https://www.elastic.co/products/beats/packetbeat
  14. Raid server setup

    What on earth are you talking about? ZFS( the mac implementation is called O3X: https://openzfsonosx.org ) gives an amazing performance boost if you use a good HBA( RAID card in JBOD mode ) I have RAIDZ2 running with 8x 500MB/sec drives in which gives me 2800MB/sec read and write. My guess is something like this would be nice: Areca ARC-8050T2 8-Bay Thunderbolt 20Gb/s SAS/SATA/SSD Drive RAID Storage Enclosure This one I have attached to an iMac: https://eshop.macsales.com/item/OWC/TB4MJB0GB/ as an o3x RAIDZ1 Well, that may go for the old numbered RAID systems 0, 1, 5, 6, 10, 55 and 66, but for the FS level RAIDs it's a different story. ZFS provides, ciphering, RAIDZn, compression, copy on write, snapshots and all kinds of good stuff. My guess is Apple has implemented some of this stuff as well in the APFS. For RAIDZ the number is how many drives can go down without loosing data.
  15. Upgrading from FMP 6

    If this is your gut feeling; I'd say: Yes, do it. Starting over always give new approaches; and usually a better solution all in all.

Important Information

By using this site, you agree to our Guidelines.