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

8 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

7,220 profile views
  1. <?php $request->setField( 'WBForm_Comments', var_dump( $_POST ) ); ?> or if you just would like the web form field names: <?php unset( $tmp ); foreach( $_POST as $k => $v ) { $tmp[] = $k; } $request->setField( 'WBForm_Comments', implode( $tmp, ', ' ) ); ?>
  2. It's impossible to answer your question with the amount of data you have provided; however your post makes me wonder: Why do you not use arrays? Using arrays will reduce that piece of code to 3 lines, opposed to 25 <input name="s[fieldname]"> <input name="s[fieldname2]"> <input name="s[fieldname3]"> <input name="s[fieldname4]"> <input name="s[fieldname5]"> <input name="s[fieldname6]"> Then filling in the FileMaker data can be done as follows <?php foreach( $_POST['s'] as $k => $v ) { $request->setField( $k, $v ); } ?> You may or may not want to do a conversion between the web form field name and the FileMaker one if your strategy is using obfuscation as a security measurement. To find out what is inside $_POST do the following <?php echo '<pre>'; var_dump( $_POST ); echo '</pre>'; ?>
  3. Sounds like you are looking for one of the examples in the FX.php package: http://fx.iviking.org/
  4. Here are the cURL command lines that I use the most; just translate these to php or any other language using cURL and you should be all set( omit the s, k, and L options for production use. ) : 1) Will list the available database. curl -s -u username:password -XPOST -kL "http://localhost:8080/fmi/xml/FMPXMLRESULT.xml?-dbnames" 2) Will add a new record with specified parameters. curl -s -u username:password -XPOST -kL "http://localhost:80/fmi/xml/FMPXMLRESULT.xml?-db=databasename&-lay=layoutName&-new&field1=contentOfField1&field2=contentOfField2" | tidy -i -xml -wrap 0 3) Will select a random record from the given database & table. curl -s -u username:password -XPOST -kL "http://localhost:80/fmi/xml/FMPXMLRESULT.xml?-db=databasename&-lay=layoutName&-findany" | tidy -i -xml -wrap 0 But if you would like simple, perhaps FX.php or phpFileMaker would do you good.
  5. Virtualization works well if you can live with a mouse pointer that works quite differently. FileMaker 11 Pro also works well in WINE: https://appdb.winehq.org/objectManager.php?sClass=version&iId=19727 Not sure why it was given a bronze score. The hitting enter stuff mentioned is only a feature when the correct fonts are not installed. $ brew info wine wine: stable 4.0 (bottled), HEAD Run Windows applications without a copy of Microsoft Windows https://www.winehq.org/ Not installed From: https://github.com/Homebrew/homebrew-core/blob/master/Formula/wine.rb ==> Dependencies Build: cmake ✘, makedepend ✘, pkg-config ✔ ==> Requirements Build: macOS <= 10.12 ✘ Required: macOS >= 10.11 ✔ ==> Options --HEAD Install HEAD version ==> Caveats You may also want winetricks: brew install winetricks ==> Analytics install: 15,503 (30 days), 44,330 (90 days), 188,458 (365 days) install_on_request: 14,604 (30 days), 41,856 (90 days), 172,570 (365 days) build_error: 0 (30 days)
  6. To avoid the glitch I made a record that will always be returned. And FM11 works surprisingly well in Mojave if you do not use any of the features required from the OS that are no longer compatible with FileMaker, which always make the application crash.
  7. ggt667

    xsl Attribute issue

    Please also add an example: file.fmpxmlresult.xml file. <xsl:template match="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <RunList Class="Parameter" Run="1"> <xsl:attribute name="Pages"> <xsl:value-of select="fmp:COL[3]/fmp:DATA"/> </xsl:attribute> <LayoutElement> <FileSpec URL="file://%2a.pdf"/> </LayoutElement> </RunList> </xsl:template> <RunList Class="Parameter" ID="Link1" Locked="false" PartIDKeys="Run" Status="Available"> <xsl:apply-templates select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"/> </RunList> How many records are you working with? Template usually spends less memory than for-each
  8. Please quote the query and its output. My immediate thinking is that the default of FX.php for php7 skips repetitions. The simplest query you can do is: curl http://<<username>>:<<password>>@<<IP>>/fmi/xml/FMPXMLRESULT.xml?-dbnames | tidy -i -xml -wrap 0
  9. $ exa -lT /Library/FileMaker\ Server/Data/Scripts/ drwxrwxr-x - fmserver 7 Jan 16:20 /Library/FileMaker\ Server/Data/Scripts/ .rwxrwxr-x 48 fmserver 7 Jan 16:20 └── timestamptotmp.sh here is the content of the script: $ cat timestamptotmp.sh #!/bin/bash echo $( date ) >> /tmp/timestamp.txt The script runs fine as user fmserver when ran from command line and as any other user on the system as follows: sudo su su fmserver /Library/FileMaker\ Server/Data/Scripts/timestamptotmp.sh /Library/FileMaker\ Server/Data/Scripts/timestamptotmp.sh /Library/FileMaker\ Server/Data/Scripts/timestamptotmp.sh /Library/FileMaker\ Server/Data/Scripts/timestamptotmp.sh /Library/FileMaker\ Server/Data/Scripts/timestamptotmp.sh $exa -lT /tmp/ drwxrwxrwt - root 7 Jan 16:31 /tmp .rw-r--r-- 140 fmserver 7 Jan 16:46 └── timestamp.txt $ tail -f /tmp/timestamp.txt Mon Jan 7 16:31:22 CET 2019 Mon Jan 7 16:46:40 CET 2019 Mon Jan 7 16:46:44 CET 2019 Mon Jan 7 16:46:47 CET 2019 Mon Jan 7 16:46:55 CET 2019 When I try to run this script from the scheduler the error is "User Aborted" for type System Script; and "Script is Missing or is invalid" when ran as part of a Script Sequence. Anyone with experience in this? I have solved the issue "User Aborted" `chmod 777 /Library/FileMaker\ Server/Data/Scripts/` So I can run some "System Script"s, but for "Script Sequence" the same scripts that runs as "System Scripts" does not run. I suspect wrong error message. I find no details in FileMaker Server console logs, and`tail -f /var/log/system.log` also has no more info. However here I find the actual error: $ tail -f /Library/FileMaker\ Server/Logs/stderr fmshelper: failed to exec() '/Volumes/FMTestServer/Library/FileMaker Server/Data/Scripts/timestamptotmp.sh', error Exec format error
  10. As I was not able to make the GUI approach in beezwax blog to work; I wrote this blog / HOW-TO on how to sign your own certificate mainly on command line: https://github.com/TyrfingMjolnir/SelfSignedCert I wrote this blog / HOW-TO after doing a deployment for a KYC( Know Your Client ) system for a financial institution.
  11. How do you query the index of a FileMaker field using FileMaker Data API? The FileMaker equivalent would be to push ⌘ + I I'm not asking how to achieve a sorted unique list of 10 000 000 records, I'm asking how to extract the n possible values from the index of the field in question. Where n probably is between 5 and 20. A poor man's solution to this is obviously using a value list; delivering the ideal values of the filed, but that's like positive testing and that will not deliver what I ask for.
  12. The annoying part about launch center is that it interrupts AppleScripts; there should really be a disable launch center check box in preferences. I have tried having the AppleScript reference the file, and this is not an easy task, I have put a delay 10 between launching of the file and execution of the script; and it usually works, but not always.
  13. I chose to suppress the SSL warning for a given host in my FileMaker 16 Pro Advanced. Which file can I edit or remove for FileMaker to forget that I chose to suppress invalid SSL warning?
  • Create New...

Important Information

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