Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


ggt667 last won the day on June 6 2017

ggt667 had the most liked content!

Community Reputation

9 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
  • MSN
    iMessage: ggt667@me.com and FaceTime

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    OS X, Arch linux, Joyent SmartOS, iOS

Recent Profile Visitors

9,521 profile views
  1. In which probably is good if each user intends to store that file, however if the user have no ambition to pull the file from the database before sending reduces available bandwidth. Is there a way to send from server?
  2. Are there any HOW-TOs or documentation on how to interact directly with Thrift? The DATA API is simply a detour to reach Thrift.
  3. If that's all you are asking then fine by me. In my experience one can run half the amount of cores in linux compared to windows to have same performance, in which means more stuff can be done on the same hardware. Also with a leaner OS there will be more resources freed up for core business. FileMaker may be an exception? What do I know. Not to mention the tools that are built into the system, like ssh / rsync / tar / gzip for backup purposes. For Windows I had to install something like Resilio for copying backup to separate location.
  4. Search in yum, I'm sure there are already ODBC drivers for all linux distros. For JDBC I have no idea.
  5. Mine still runs on Debian 10 chrooted in VM BHYVE What you write does not make sense to me; the overhead of running Windows is still significant AFAIK. I will run new benchmarks once FM19S for linux is released. FM19S linux runs fine on a Joyent SmartOS LX zone CentOS flavour( about 249.9 MB full system image ) + prerequisites( the stuff you have to yum prior to installing FileMaker server, i e ) to my knowledge. Prerequisites( for CentOS Joyent LX zone ) below ```BASh yum install wget unzip rh-nodejs10 centos-release-scl-rh httpd24 && yum install filemaker_server-19.0.1-21.x86_64.rpm ``` P S Some CentOS installs already have httpd24 installed from before.
  6. Why is XML being deprecated? For some cases JSON can replace XML, in some cases there are individual benefits to both formats. Is there an XML response option for DATA API? Also for certain tasks I have FileMaker generate YML through XSLT. While we are at it: do we have direct access to Thrift? Communicating with a REST-like API is not very efficient when we know there is a Thrift API behind the REST-like one. I assume importing and exporting records as FMPXMLRESULT will still be valid?
  7. Where would one put shell scripts or other unix command line script for MacOS X? Such as this script https://github.com/TyrfingMjolnir/FileMakerBackupRemoval in which I wrote to curate offline backups. This script would run anywhere in combination with an rsync # crontab -l 5 * * * * /usr/bin/rsync -av /Volumes/backup/fms03/* /Users/backup/fms03/ && /usr/bin/chown -R backup:staff /Users/backup/fms03 && /usr/bin/chmod -R 760 /Users/backup/fms03 this crontab is from a remote backup such as Synology, FreeNAS, Joyent SmartOS, docker, k8, linux, or other unixes such as MacOS X. Any nix flavour that runs SMB, SSH, or NFS really. What I'm asking is for the forum moderator to add `Unix/Linux shell script automation` under `OS Level Database Automation` next to `AppleScript & Automator` and `Windows automation`
  8. The initial issue is that I have to do 12 imports to FileMaker to import 1 real world XML document, and I have 7 real world XML document types I import multiple times pr day. Having FileMaker do the imports is backseat driving. What?!?
  9. One of the saddest parts about FileMaker is that we are not able to load XML from the command line, imagine being able to load like: /Applications/FileMaker\ Pro\ 18\ Advanced/FileMaker\ Pro\ 18\ Advanced.app/Contents/MacOS/\ FileMaker\ Pro\ 18\ Advanced layoutname bymatchingfieldnames << my.fmpxmlresult.xml from command line or even better With properly naming I would be able to load any document.
  10. Removing the need for double entry is a gain in itself.
  11. This depends on how you create the XSLTs. What is amazing about XSLT is when you dare to make more of them, and when you work with standards you can make XSLTs to split and join your other XSLTs. When I make XSLTs that are FileMaker centric, I make them in a way that I have a set of XSLTs that can build other XSLTs and specialized for each subset. Tip you can export complex XMLs from FileMaker, however you can only import them 1 table at the time; none relational. You can use the complex export as a template for how to split import data prior to import.
  12. How can I see the actual byte counter? Is there a /proc/ or similar that I can cat? As pr example: cat /proc/fmdataapi.allowance or similar. Is this done pr byte count of the raw HTTP query response? Or the body inside the HTTP response?
  13. "For inbound Data Requests (pulling data into the database on your FileMaker Server) you have unlimited API Data Transfer. For outbound Data Requests (pushing data out from the database on your FileMaker Server) you are limited to the API Data Transfer included with the Software along with any additional API Data Transfer that you purchase." sic - https://support.filemaker.com/s/article/Understanding-the-Data-API-Annual-Limits?language=en_US Does this mean that when I do a query `curl -kL -XPOST fmserver/fmi/data/v1/databases/some/params -d "more:params"` The query I send to FileMaker is for free? But its response does a countdown on my allowance?
  14. Here is the raw query( I'm not sure which parameters are required, far from all are filled in, and many appears to be double up ) that changing the Summary to XML does: This is a feature I miss in FileMaker being able to import XML using the HTTP verb _POST with a payload. It appears Brave claims to be FireFox, Safari and Chrome? The payload has been split by individual parameters below( Far from all are filled in ) ["term", "31618393+31618392%5Buid%5D+"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_PageController.PreviousPageName", "results"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_PageController.SpecialPageName", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_Facets.FacetsUrlFrag", "filters%3D"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_Facets.FacetSubmitted", "false"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_Facets.BMFacets", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.sPresentation", "xml"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.sSort", "none"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.FFormat", "docsum"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.FSort", ""] ["email_format", "docsum"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.email_sort", ""] ["email_address", ""] ["email_subj", "31618393+31618392%5Buid%5D+-+PubMed"] ["email_add_text", ""] ["EmailCheck1", ""] ["EmailCheck2", ""] ["BibliographyUser", ""] ["BibliographyUserName", "my"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.FileFormat", "docsum"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.LastPresentation", "docsum"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.Presentation", "xml"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.PageSize", "20"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.LastPageSize", "20"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.Sort", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.LastSort", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.FileSort", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.Format", "text"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.LastFormat", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.PrevPageSize", "20"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.PrevPresentation", "docsum"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.PrevSort", ""] ["CollectionStartIndex", "1"] ["CitationManagerStartIndex", "1"] ["CitationManagerCustomRange", "false"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_ResultsController.ResultCount", "2"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_ResultsController.RunLastQuery", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.EmailReport", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.EmailFormat", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.EmailCount", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.EmailStart", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.EmailSort", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.Email", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.EmailSubject", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.EmailText", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.EmailQueryKey", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.EmailHID", "1r1WD96DIMUWZetUgmuwE3ML8uzkrFTHG4KcPHT1lo9Sj7pzeetkwhsdsqevcYZ8Uvlm1NtAw_TU8ieO9udbjsyLp8l7gDN9bj"] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.QueryDescription", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.Key", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.Answer", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.Holding", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.HoldingFft", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.HoldingNdiSet", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.OToolValue", ""] ["EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.EmailTab.SubjectList", ""] ["EntrezSystem2.PEntrez.DbConnector.Db", "pubmed"] ["EntrezSystem2.PEntrez.DbConnector.LastDb", "pubmed"] ["EntrezSystem2.PEntrez.DbConnector.Term", "31618393+31618392%5Buid%5D"] ["EntrezSystem2.PEntrez.DbConnector.LastTabCmd", ""] ["EntrezSystem2.PEntrez.DbConnector.LastQueryKey", "1"] ["EntrezSystem2.PEntrez.DbConnector.IdsFromResult", ""] ["EntrezSystem2.PEntrez.DbConnector.LastIdsFromResult", ""] ["EntrezSystem2.PEntrez.DbConnector.LinkName", ""] ["EntrezSystem2.PEntrez.DbConnector.LinkReadableName", ""] ["EntrezSystem2.PEntrez.DbConnector.LinkSrcDb", ""] ["EntrezSystem2.PEntrez.DbConnector.Cmd", "displaychanged"] ["EntrezSystem2.PEntrez.DbConnector.TabCmd", ""] ["EntrezSystem2.PEntrez.DbConnector.QueryKey", ""] ["p%24a", "EntrezSystem2.PEntrez.PubMed.Pubmed_ResultsPanel.Pubmed_DisplayBar.sPresentation"] ["p%24l", "EntrezSystem2"] ["p%24st", "pubmed"]
  • Create New...

Important Information

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