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,975 profile views
  1. I have no experience using: FMPXMLLAYOUT.php; can you post the file in full? Are you supposed to use this file as a starting point to generate your own php file? I used to use FM CWP w/FX.php; amongst others, to write my own php scripts, these days I mainly use node w/express and/or nginx to achieve the same due to better support with postgres, elasticsearch, and now also FileMaker DATA API
  2. Looks like styleType does not have a corresponding value in the array. For the statement not to break associatively there will have to be an entry of styleType in $V77be71a4[] Philosophical question: How are you going to fix this if you have no access to edit the code?
  3. What is on line 53? The general idea is to set an empty value first that it will not complain about for example $tmp = ""; I do not know which variable is in question. Or you can change error level to error.
  4. Raid server setup

    Note to self; never trust autocorrect.
  5. 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]
  6. Export Structure (Tables and Fields) to...??

    Perhaps making new layouts with all fields and no design will suffice in your case?
  7. [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.
  8. 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.
  9. How many machines? Why not just keep using FileMaker 15 on 1 machine if you are only 1 person?
  10. FQL? or SQL? SQL has this defined as standard: SUBSTR( columnname, 3, 2 ) // Where 3 is starting position and 2 is length of substring.
  11. 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
  12. JSON parsing performance comparison

    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?
  13. newbie looking for advice

    There are also some videos on Vimeo: https://vimeo.com/search?q=filemaker
  14. 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/
  15. 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

Important Information

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