Beezwax updates bbox
Version 0.73 is the latest, and this new release includes improved Python list & set support, and allows additional parameters to shell commands. So, what is bbox, you might ask? It’s a free FileMaker plugin from Beezwaz for Mac users:
bBox FileMaker external plug-in is a toolbox of functions freely available to all developers. Use it to extend the reach of your Mac OS X-based FileMaker solutions to programs, code libraries, or OS X functions that are normally outside your reach.
Consisting of more than 22 powerful functions, bBox extends the reach of FileMaker’s existing commands, and adds completely new functionality. This makes it easier to get your projects done, and without the need for ugly workarounds to provide functionality that should be simple…
- run Perl, PHP, AppleScript, shell, Python and Ruby scripts
- extract email or phone numbers from text
- check if a file is present
- parse XML with XPath based queries
- strip duplicate values from a return-delimited list
There’s lot’s more at the link. It’s another great tool for your developer tool box.
beezwax > products > bbox filemaker plugin.
Like
0
Liked
Liked
January 4, 2015 @ 5:04 am
Very interesting, but unfortunately, I found some errors in the demo file (field definitions, queries, etc.)
f.i. invoice::number and invoice::total must be numbers and not text.
this query is incorrect
@.sqlQuery ( List (
“SELECT”;
@(invoice::id; “. _” );
@(invoice::invoice_number; “. ,_ trim() ” );
@(invoice::_item_count ; “. ,_ upper() ” );
“FROM”;
@(invoice::id; “t _” );
“WHERE”;
@(invoice::invoice_number; “. _ >>” );
@(invoice::total; “. _ and >> >= 10000” );
“ORDER BY”;
@ ( invoice::invoice_number ; “. _ ” ) ;
“”))
The correct one is:
…
“WHERE”;
@(invoice::invoice_number; “. _ >> >= 10000” );
@(invoice::total; “. _ and >> >= 10000” );
…
February 1, 2015 @ 11:39 am
Good catch! I don’t normally have time to dig into these files until I need to use them.