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


Everything posted by ggt667

  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.
  16. Does FQL actually work?

    There is also SQLEditor: http://www.malcolmhardie.com/sqleditor/ visually create SQL queries for the following dialects: generic OpenBase SQLite sybase postgres FileMaker SQLServer Redshift MySQL Oracle Rails Rails Schema Django IIRC there is free trial if you just download. See if it does what you'd like, I only used this app for presentations this far.
  17. Help with cURL

    "-H Authorization: ShippoToken " & $token & " -H Content-Type: application/json -d " & $json I believe above should make a valid string.
  18. XML Error line 1

    I export 5000-10000 records on a regular basis, and occationally millions; I have not yet seen this error before you posted this here. How much memory do you have?( all involved machines to reproduce the error ) Also how much memory is free on the bootdisk. Do you use for-each in XSLT? Then change to template. Of course the number of fields pr record also counts, both calculations and keys do spend a considerable amount of resources; Compared to plain data fields. This may or may not be a design issue, not necessarily one of XML, but I do not know enough to make any conclusion.
  19. So are you saying that if somebody searches this forum and have the same issue as you; you are not going to give them the answer?
  20. Importing a UK Govt formatted xml into Filemaker

    Sometimes XML/XSLT is better with a good tool; I bought Xmplify The moment the files are 2 MB and up you are not really interested in using for-each; you want to call template
  21. Also your code will benefit from keeping hierarchy; I do recommend 2 spaces pr tab. The error may or may not be open brackets. I put indented copy here: http://termbin.com/b8zn
  22. Did you consider FX.php? It's for free It uses 20-30% less resources compared to phpFileMaker API( architectural benefit ) It actually has good examples. That said there are benefits to using a better MVC / MVVM these days such as f ex Angular or the combination of Angular and FX.php is also a good fit.
  23. Is this really the examples out there? When we wrote FX.php at least we made sure it had complete examples.
  24. $show = 1; $skip = $_REQUEST['skip']; if( ! isset( $skip ) ) { $skip = 0; } $request->setRange( $skip, $show ); Oh, then you would make show=1 like as above