Jump to content

john renfrew

  • Content Count

  • Joined

  • Last visited

  • Days Won


john renfrew last won the day on September 20

john renfrew had the most liked content!

Community Reputation

33 Excellent

About john renfrew

  • Rank
    enthusiast, with a bit of geek
  • Birthday 06/21/1957

Profile Information

  • Gender
  • Location

Contact Methods

  • Website URL
  • Skype

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. john renfrew

    unhelpful error message dialog

    Hi Sean I spoke to Jesse about this at Devcon, and he understood the change in behaviour and I *think* the dev version of the plugin I have fixes this...
  2. john renfrew

    Numpty advice re scriptmaster

    this won't work with a path that starts filemac: It needs to be an O/S system path, and while I know its not that helpful, works here (although I might have tweaked my version of the function a bit)
  3. john renfrew

    Numpty advice re scriptmaster

    set a variable in a script with the calculation - TheFunction( $params...) remember that this needs to be proper O/S paths
  4. john renfrew

    ScriptMaster 5.09 hosed everything for us

    Depends on your functions... some things have changed significantly in later java versions...
  5. With the latest versions of ScriptMaster the error message java.util.concurrent.ExecutionException: java.lang.reflect.InvocationTargetException is not exactly helpful as it gives no clue as to what the error might be. And I have been getting requests from people about broken code as this gives them no clue as to what is going on. AND you can't turn it off to be able to just get the choice of being the full stack trace which gives a lot more clues as to the potential source of the error. How can this be suppressed???? I have amended my v12 file for several years now but the latest version of the plugin shows this system dialog rather than returning "ERROR" as previously which the allowed me the choice of either the last error or stack trace to be outing the result field
  6. john renfrew

    jdbc driver not loading with v5 of plugin

    Just got that working with the help of 360Works... Will post some code when I get a minute to tidy it up. In previous versions that method of loading on the fly for database drivers would not work.
  7. john renfrew

    jdbc driver not loading with v5 of plugin

    Brand new machine Latest ScriptMaster, on High Sierra downloads the 9.0.1JRE Now this is used instead of any other java path...
  8. We used to put the jdbc drivers into /Library/Java/Extensions restart FileMaker and then either of the follwing methods would connect (second is more Groovy) import groovy.sql.Sql try{ driver = Class.forName('com.filemaker.jdbc.Driver').newInstance() } catch (e) { return e.getMessage() } try{ sql = Sql.newInstance('jdbc:filemaker://myserver/file', 'user', 'pass', 'com.filemaker.jdbc.Driver') } catch (e) { return e.getMessage() } If I create an /ext folder in the JRE/lib then ScriptMaster does not load correctly, if I put the jar in the /lib or in a /lib/Extensions folder then all you get back from that is com.filemaker.jdbc.Driver meaning the driver hasn't loaded This is true with the jdbc for MySql too... not just a FIleMaker issue -we can connect using the JDBC plugin but that's not a workable solution long term This is getting to the point where this is unusable. can anyone shed light on the correct place to put the jdbc jar and the correct way to load it??
  9. john renfrew

    Merging PDF (locked files)

    There is also a way to do this without the export step, but right from the container field, but SM is a little broken on this method on high sierra at the moment. When thats fixed I'll get back on how.
  10. john renfrew

    Merging PDF (locked files)

    which version of iText??? There's abetter method using com.itextpdf.text.pdf.PdfConcatenate you need to close the reader file at the end of the while loop...
  11. john renfrew

    List manipulation

    There's a bit of a thread on the FM Community site about working with lists, to which I wrote an example SM function which I post here for interest.... https://community.filemaker.com/thread/188322 // liststest ( list1 ; list2 ; select? ; separator? ) // 18_07_10 JR // v1.1 // // JOIN = select?select.toInteger():1 LISTA = list1?list1.tokenize('\n'):[] LISTB = list2?list2.tokenize('\n'):[] SEP = separator?separator:' - ' switch(JOIN){ case 1: LISTA.addAll(LISTB) return LISTA break case 2: LISTA.removeAll(LISTB) return LISTA break case 3: LISTB.removeAll(LISTA) return LISTB break case 4: LISTA.addAll(LISTB) return LISTA.unique() break case 5: result = '' LISTA.each(){ def start = it LISTB.each(){ result += start + SEP + it + '\n' } } return result break case 6: if(LISTA.size() != LISTB.size()){ return 'lists not same size' } else { result = '' i = 0 LISTA.each(){ result += it + SEP + LISTB.getAt(i) + '\n' i++ } } return result break } return 'select out of range'
  12. john renfrew

    JSON functions seem to fail

    what answers do you get from the following?? return GroovySystem.version return System.getProperty('java.version')
  13. john renfrew

    JSON functions seem to fail

    works just fine here....
  14. john renfrew

    JSON functions seem to fail

    Marek There was a massive change to Slurper after Groovy 1.8, but having said that from the API docs >> INDEX_OVERLAY should be your parser of choice. CHAR_BUFFER is the parser of choice due to element of least surprise and need to mimic existing Slurper behavior as much as possible. Use CHARACTER_SOURCE for large file parsing. Use LAX if you want to enable relaxed JSON parsing, i.e., allow comments, no quote strings, etc. Use CHAR_BUFFER for a non-fancy but super fast parser. Parser speed in order: INDEX_OVERLAY, LAX, CHAR_BUFFER, CHARACTER_SOURCE. Use Cases: Use LAX for config files as it allows comments. Use INDEX_OVERLAY for REST calls, WebSocket messages, AJAX, inter process communication, etc. Use CHAR_BUFFER if eager parsing of ints, dates, longs, are appealing. Use CHARACTER_SOURCE if you are dealing with large JSON files over 2MB. INDEX_OVERLAY is highly tuned for object deserialization from JSON. Try the other parameters??
  15. john renfrew

    JSON functions seem to fail

    @marek that will also be fixed, same issue to do with Java 9 on Mac

Important Information

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