ScriptMaster by 360 Works

Hi there, I was wondering if there's something out there, usable with SM, that could allow me to read / write tags from / to an mp3 file. (attention : if there is, my next question will be : how do I get it to work in SM, since I'm a complete newbie at java/groovy and writing custom modules ! But ready to learn... ) It must be able to manipulate any mp3 tag, especially non-standard, extra user defined tag input fields. Thanks for your hints.

Hello, I'm new in sendmail. I can send mail without any problem but when I want to do more I have problems : the subject is cut in the received message after 34 sings, is there any option to have a longer subject ? when I want to send to multiple email address, I've tried to make more value ligns with to in keyvalue. But when I send it's only the last value (last email address) who is taken and the ones before are not taken to send the email. and maybe one more thing : in the HTML code I want to put a ref (src) to the image which is in the attachment. in attachment I have newsletter.gif in the html code I've put src "/newletter.gif" but the ema…

Hi, I am working on a Filemaker Runtime Solution, which I want to distribute to our customer computers (windows system). I have evaluated the ScriptMaster-Plugin in order to extend Filemaker's functionality and I find it very useful for my purpose (embed the lucene search engine). Thank you for creating such a useful tool. The only critical point (from my point of view) is the necessisty to have a special JRE-Version installed on the customer computer (32Bit, >1.5). Is there a way to tell the Scriptmaster-Plugin to use the JRE-Version in a special directory. I have the idea to distribute the JRE with the FM-Runtime-Solution but without running a sec…

Hi all, inspired by the XML transform found here I created a script to validate a XML against a XSD. Enjoy. Best, Alexander RegisterGroovy( "XMLXSDValidation( xmlString ; xsdString )" ; "import javax.xml.XMLConstants import javax.xml.validation.SchemaFactory import javax.xml.transform.stream.StreamSource if( xmlString == null ) throw new Exception(\"You must supply a pathToXMLFile parameter\"); if( xsdString == null ) throw new Exception(\"You must supply a xsd parameter\"); def factory = SchemaFactory.newInstance(XMLConstants.W3C_XML_SCHEMA_NS_URI) def schema = factory.newSchema(new StreamSource(new StringReader(xsdString))) def validator = s…

Hi there, I'm trying to run a command with RunShellScript, to use PsExec on windows (win 7 pro x64 / FMP11adv / SM 4.132). (this exe allows to run a command or batch on a remote computer, allowing me to control my FileMaker Server over command line) the exe is in C:\Window\system32, and from within a system cmd window, everything is working fine. But using ScriptMaster RunShellScript (from the example file), it returns a shell error : java.lang.RuntimeException: 'psexec' is not recognized as an internal or external command, operable program or batch file. I tried some native commads, such as ipconfig, netstat, copy, systeminfo, ... : everything is …

Hello, I need to move a folder to another one to archive it. In the sample file of SM is a Move Or Rename File ; the notes says and seems what I hope. I try the following params under Windows : originalPath = /c:/GestALSH/Factures_PDF/E2011_2012 moveToPath = /c:/GestALSH/Archives/ It returns me alway 0 and I dont'see where is my error ! Thanks for help Noël Edit : a- the tries I did seem show that moving is not possible if there are subdirectories b- it runs on the mac and not the pc

In a multi file solution what would be a good method to use SM on the opening file to register a function with a few declared variables - so that in a subordinate file that value can be recalled? So as not having to pass globals thru a relationship? Thanks.

Hello, Our Filemaker application uses a third party Java application to anonimize medical data and send it to the government. We used to start this process with a shell script from Filemaker but it's not working on MacOS Lion. It's easy to reproduce with the ScriptMaster example file. If you use 'Run Shell Script' and use 'java --version' as command for example then it produces this error: 'JavaVM: failed to load JVM'. I'm afraid this is a security issue and I'm aware that this is not a ScriptMaster issue, but maybe someone knows how to fix it? Regards, Marco

Been doing this as the machines I want it to work on are PC so Applescript won't do. Can put a timed item or all-day into your calendar, just feed it your account details and Cal name, needs java 1.6, and a bunch of Google jar files gdata-base gdata-calendar gdata-calendar-meta gdata-client gdata-core guava Sure there are more elegant ways to achieve this if anyone wants to amend it... or add any error trapping // gCalMake( fm_title ; fm_content ; fm_date ; fm_startTime ; fm_endTime ; fm_place ; fm_remind ) // 2010/10/10 JR // v1 // takes fm_title, fm_content, fm_date, fm_startTime // optional fm_place // if fm_endTime is null makes …

My solution is based on FMP 12. But, my Plugin was built using ScriptMaster running in FMP 11. Do I need to convert the ScriptMaster file to FMP 12 and then rebuild the plugin? Thanks

Hello, It’s possible to run declare commands with SQL function, like this: Thanks

Small offering from today's work http://code.google.com/jodconverter/ Just got this to work on a PC to convert both doc and docx files to PDF, AND xls and xlsx adn csv You need Open Office installed, and I tell it where this is as I use a non-standard location but should therefore work just as well on Mac You need all the jars loaded from the download but works a real treat - no need to have Open Office even open so silent as far as the user is concerned Just prints with default settings, so next thing is to work out you how to change paper size etc. // DocxToPDF ( fm_fileIn ; fm_fileOut ; officeHome ) // 12_02_22 JR // v1.0 // // officeHo…

just hadn't had time to investigate the possibility but we routinely grab a federal document from a website but we only care about including the second page from this document with our document is there an easy automated way to extract just that page from the pdf and place it into a container or super container? thanks

I have created a pluging using ScriptMaster advanced that includes PopupMenu. I have found this unreliable for some reason, no values in the popup. I thought I had found the problem, and was setting a variable with the values and then using that variable as the parameter but now that I find that not working. I have even copied the 'red, green and blue' from the ScriptMaster file to try that but I am not getting a popup. Using Mac OSX 10.5.8 and 10.6.5, all obvious things -checked other plugin functions working and that it is registered. Any ideas why I am having this problem?

I don't understand why a formula field calling CheckWhetherFileExists( "/Users" ) returns ERROR My installation seems to be alright since a formula field calling GetFileSize( "/Users" ) returns 170 I am new to the SkriptMaster-PlugIns and therefore ask forgiveness if this is a silly question.

I used ScriptMaster Advanced (4.132) to make a plugin for both Mac and Windows. When I write a calculation calling one of that plugin's functions on Mac, Windows machines do not recognize it and show only "<Function Missing>" in it's place. When I use a copy on Windows to replace "<Function Missing>" with the correct function name, it works fine on Windows, but that calculation will then show "<Function Missing>" on Mac. Has anyone else run into this? Is there a fix for it?

Does anyone have an updated example of the Fedex Ship module that comes with the ScriptMaster sample file? The currently distributed file from 360Works uses version 3, but the FedEx API is already on version 10 with additional options on shipment requests.

Hello, I'am using Scripmaster 4_131 with FM10A and FM11 on Mac (10.6.8 and 10.5.8) and on windows XP. I have also tried with Scripmaster 4_132 I have no problem for registering CreateFolder, with the variable declaration in my startup script. But, when I try to register Send Email With Authentication on startup, with a variable declaration (copy to clipboard method), this function is not registered. The report with SMLastError is: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed: Script1.groovy: 10: unable to resolve class MimeMessage @ line 10, column 14. MimeMessage msg = new MimeMessage(Session.getInsta…

Hello I've created a FM10 runtime application using the free ScriptMaster plugin. It uses some basic file manipulation modules such as 'CreateFolder', 'CheckWhetherFileExists', 'ChooseFolder' and 'DeleteFileorFolder'. I have the latest Java Virtual Machine (JVM) on my MacBook ( build 1.6.0_31-b04-415-11M3635). The runtime ( with ScriptMaster modules ) works perfectly on 3 user accounts I have on my MacBook ( two are non-administrator and one administrator ). However, on the 4th account ( the one where I do all of my FileMaker development ) the ScriptMaster functions do not work - the runtime itself works but whenever I initiate a script that uses a ScriptMaster …

I want bounces to go to a different email address than the from address, so I added the line, "props.put("mail.smtp.from", "[email protected]");" to the SendEmailWithAuthentication script (with the necessary escape characters for quotation marks). But when I view the headers of the mail message, it still has the "from" address in the Return-Path. Any suggestions? RegisterGroovy( "SendEmailWithAuthentication( from ; to ; subject ; htmlBody ; attachmentPath ; smtpHost ; username ; password )" ; "import javax.mail.*;¶ import javax.mail.internet.*;¶ ¶ Properties props = new Properties();¶ props.setProperty("mail.smtp.host", smtpHost);¶ props.se…

I have a Jar that contains a swing GUI that I wish to run from a Groovy script, but when I try to make the script wait for the GUI thread in any way, Filemaker and a partially opened window for the Swing app becomes non-responsive and I have to force close it. I am working on OS X, but writing a plugin that will be used on both OS X and Windows. The Gui ends up possibly saving a file that the script needs to check whether it was made or not to continue. It's a user-choice and if the file isn't saved, the script can end, but if the file is there, the script needs to continue, but I cannot find a way to successfully open the GUI and prevent the script from finishing. …

what is the easiest way to update fields that use the Get URL as Text script, in case the websites have changed their content? Thanks!

I'm sure this is a very simple question; I just haven't found the answer. Once I have the path to a file, how do I use ScriptMaster to open the file with it's native app?

I have developed a document management system (as part of a practice management system) which as one would expect makes extensive use of various file manipulation functions (copy, move, delete, etc.). Is there a way with 360works to test if a file is in use? I could error trap on the other functions (e.g. copy) but that is inelegant and I would prefer to start off with a first check, i.e. is the file in use before embarking on what are some quite complicated and lengthy routines. Any assistance/suggestions would be much appreciated. Thanks.

Just doing some testing of FM12 and looking to make some improvements too (like a good boy should) Is it possible to run the Scriptmaster JVM or any functions 'elevated' or AsAdministrator on Windows 7? Depending on your UAC settings the nice man at Microsoft has decided that adding fonts requires permission (!!) and I would like to programatically add any fonts I need for a solution along with the jdbc sql driver into the Java folder. Getting someone to turn it off, run an FM install file, turn it back on and restart is hardly an option worth it, so just wondering?

Might be being stupid here.. I am doing some testing (like a good boy) and have a machine with 64bit Windows7 and FMPA12 on Which JVM version do I need for Scriptmaster?? 32bit or 64?

The ScriptMaster plugin does not appear to work on FMS12. Using 4.131. Same plugin, same setup working fine on FMS11. Works great on FMPA12 I am guessing that this is due to the new separate processes in 12 and that 360 Works know about this and a new version, along with some new modules (bar codes) will be released real soon! Maybe spoke too soon - the problem could have been that the opening script is no lounger called from Server 12 - thanks 360 Works for your email!

I have a working SM function for stamping Page X of Y in my footer, but I'd like to suppress the page number on the first page. Any help appreciated.

First of all thank you so much for this really awesome plugin. I couldn't figure out, if there is a way of getting a FileMaker container field into a Groovy variable. Is this possible? (seems it's always converted to a string) Thanks for any hint. Ph. Cosi

Here's a scriptmaster function I'm using to transform an XML file with supplied XSLT (as a string). This maybe useful for anyone needing to generate an XSL transform inside filemaker (as I am currently doing). Hope someone finds it useful! XSLTransform ( pathToXMLFile ; xslt ) import javax.xml.transform.TransformerFactory import javax.xml.transform.stream.StreamResult import javax.xml.transform.stream.StreamSource if( pathToXMLFile == null ) throw new Exception("You must supply a pathToXMLFile parameter"); def factory = TransformerFactory.newInstance() def transformer = factory.newTransformer(new StreamSource(new StringReader(xslt))) Writer ou…

I am trying to see if I can check first whether a user has logged on to the client LAN where the Server sits or is at home logging in remotely so wrote this little function Use as you will, or make it better... // TestLAN ( IP ) // 12/03/18 JR // v1.0 // checks if you are on the LAN where FM server is running // used to see if a user can log on locally or is remote to limit layouts via WAN skt = new Socket() sktaddr = new InetSocketAddress(IP, 16000) try{ skt.connect(sktaddr, 1) } catch (e) { return 'ERROR not on this LAN' //return false } return 'on this LAN' //return true

The scriptmaster dialog example allow you to have a dialog with dynamic buttons (Formatted Dialog with Dynamic Buttons), but in the example, it is unclear how to use the dialog to obtain user information as one can with Filemakers show custom dialog. I want to use the dialog box and have the user enter a name and other information. Is there any documentation anyone can point me to, on how to use this feature in the scriptmaster dialog. Thanks Abel

Hi guys, today I've got a new issue with script master. I make a plugin for my solution with script master for run shellscript. i tried also with script master and no plugin, but make no differences. On a mac pro running 10.6.8 is ok, but on my macbook pro (10.7.1), i receive random error when i send the same script to shell. Always in different point of the script, with errors, on debug or normal use. e.g. invoking which command or else. is it compatible on lion? Generally i send a command like this run shellscript($variable; "true";30) could be correct? have you got something to suggest me? My solution is running on a mac server with FMPRO SERVER ADV lat…

Hi All A few days ago i've discovered ScriptMaster. It seems that it is what i was looking for. I followed the tutorial but there is still one error comming again and again. Unfornunately after clicking for generating Plugin ("Make Plugin") an error is apearing: "com.prosc.license.client.InvalidLicenseException: Error registering 360Works ScriptMaster: You must purchase an Advanced Edition or Portfolio License to use this feature." I created already a plugin. Moved the Database to another Directory and now its not working anymore. Does somebody know what to do?? I have no glue where the problem could be. I'm using ScriptMaster for personal use and there shou…

hi all, i'm trying to use a script used on snow leopard (work perfectly), now i moved on lion (osx 10.7), but seems the "&&" used on the script to concatenate 2 different commands, report me an error. like this: $cmdlame" && "$cmdeyed3 something changed?

Some while ago I reported intermittent problems when using an adaption of the jFileChooser method on Mac platform. As soon as the file choice dialog box appears on screen clicking anwhere on it causes a spinning beachball of death and Filemaker has to be crashed, which as we all know is one sure fire way to damage a file. I wonder if you have made any progress on finding why? FM 11.0.3 and the latest SM plugin OSX 10.6.7 // ChooseFiltered(fm_Path, fm_Message, fm_FileType, fm_Button, fm_Select) // 11_06_02_JR WORKING // v1.2 // fm_Path startpath for dialog // fm_Message for dialog title // fm_Button sets text for default 'accept' button // fm_FileTy…

I am using the current v 4 of SM. My application uses the SelectFile function. I "Registered" it using the 3rd method (as specified in the User's Guide) and it works great in development mode. (I develope in OSX) I compiled my app for both Windows and Mac with different experiences. First, on the Mac, when the script which uses the SelectFile function is called, it acts as expected and allows me to 'browse' for the file I desire. Great. But, about 1/2 the time I get the dreaded 'spinning beach ball'. I can still select a file and select 'Open' and everything works. But, "Why the spinning beach ball?' In any event, it works but it is actign weird....…

I am trying to save a PDF to a user selected folder using the ScriptMaster Choose Folder but seem to run an issue if the volume name is not included. ScriptMaster Choose Folder returns: /Users/myUser/Desktop Trying to save a PDF using the ScriptMaster supplied path to generate a $pathVariable = filemac:/Users/myUser/Desktop/myfile.pdf generates an error 800 "Can't write file". To test my pdf path process I tried using FileMaker Get(DesktopPath) which returns: /Volume/Users/myUser/Desktop/ Save a PDF using the this path to generate a $pathVariable = filemac:/Volume/Users/myUser/Desktop/myfile.pdf works fine. Is it just the missing volume from t…

Hallo, I experience some problem with POST XML to URL plugin. I try to POST xml request to server, but there is some problem with characters - it shows in the message. The problem is only with Russian chars, no problem with English or numbers. It seems to be problem with charset, in the request it must be only UTF-8. The XML is the following: <?xml version="1.0" encoding="utf-8" ?> <package login="lik" password="XXXXXXXXXXX"> <message> <default sender="LIK"/> <msg recipient="+79161770129">test и тест</msg> </message> </package> The message i get from SMS server - "test ? ?" Pl…

Using this function on Windows If you set the format to 1 (Clipboard List tells me it is plain text http://www.ciansoft.com/cflist/default.asp ) it cuts off the last character This works, so it is somewhere in the output. fmpro.setClipboardContents( format, data + ' ' ) Any ideas?

I have SM Select File() working in both Mac and Windows in development. In both instances, I 'registered' the function by copying the code to the SelectFile function. It works. But, when I create a runtime version of my app, it doesn't seem like the SelectFile function is being 'found'. What do I need to do?

// ChooseHome() // 10_06_10_JR WORKING // v1 import javax.swing.JFileChooser chooser = new JFileChooser() chooser.setFileSelectionMode( JFileChooser.DIRECTORIES_ONLY ) chooser.setCurrentDirectory( new File(" ") ) chooser.setDialogTitle( "Select the HOME folder" ) if( chooser.showOpenDialog( null ) == JFileChooser.APPROVE_OPTION ) { home = chooser.getSelectedFile().getAbsolutePath() // comment out next line and it is fine fmpro.evaluate('Let($$' + 'homeDIR' + ' = "' + home + '"; 1)') return home } else {} return false and ideas why the above is giving me the following error?? Windows XP, FM 11.04 SM 4.131 Has been working ( I think) till the late…

This function return's an invalid result when the clipboard contains a pilcrow: ¶. Steps to reproduce: - copy a pilcrow (like the one above) - run this code. the pilcrow is replaced with some other character. When I copied the funky character it was replaced with into FileMaker's Code() function, it returned 65533, when a pilcrow is supposed to be 13.

This function does not work for custom function's. Steps to re-produce: - copy a custom function - run this code, it will fail - run: fmpro.getClipboardContents( 50213 ), and it works

Hello, working on Mac with FMP 11. I'm developping a db to help creating MS Word documents we'll have to put in some specific subfolders. To create these subfolders I'm trying to use M CreateFolder(). The db will be hosted to be accessed by internet but folders (and documents) must be created on the local hd of each user. So, I try to use absolute (instead of relative) paths in createfolder parameter but it doesn't work. My hard disk is called 'HD 2' so i've tried : - /hd 2/Users/pro/thedbase/thenewfolder - /hd 2/Users/pro/thedbase/thenewfolder/ - hd 2/Users/pro/thedbase/thenewfolder - hd 2/Users/pro/thedbase/thenewfolder/ - filemac:/hd 2/User…

I have just DL'd v 4. I got it working and have the file and path (OSX) assigned to a variable: $$SelectImportFile . I try and use $$SelectImportFile as the File Source variable specified in the Specify data source dialog. FM DOES NOT IMPORT / FIND the file? I thought perhaps I need to specify the volumeName in addition to the path and file name? If so, how can I get the volumeName to append to the path? (concatination is the method I presume). Thanks

Hello, I can get the module to work with local directories,but don't know the path syntax for remote volumes. Is the syntax going to be the same for mac and windows? Thanks, John

Has a bit of help from Sam Barnum on StackOverflow with this but have a function which either gives you three chances to enter the correct password, or returns the password you enter into the box. Just a bit of practice for me with SwingBuilder but might be a useful starting point for others. Some of this has been enabled by the latest Groovy 1.8.4 version in the current Scriptmaster // PasswordSwing ( title ; message ; type ; password ; returnPass ) // 12_02_21 JR // v1.0 // type -1 plain, 0 error, 1 information, 2 warning, 3 question // if returnPass then displays a dialogbox with a password field and returns the passsword on OK // and uses title…

HI, This is my first post...I just downloaded ScriptMaster, and am trying to wrap my head around the FedEx Ship module. Is there any documentation that I can get my hands on? Thanks for any help you can give. Thanks Chip

ScriptMaster 3.3.4. I'm getting the following error when I try to register the FedEx Rates module from within my solution: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed, Script1.groovy: 3: unable to resolve class com.prosc.ws.execution.Invoker @ line 3, column 2.Script1.groovy: 94: unable to resolve class com.prosc.ws.execution.Invoker @ line 94, column 2.Script1.groovy: 95: unable to resolve class com.prosc.ws.execution.Invoker @ line 95, column 42.Script1.groovy: 95: unable to resolve class com.prosc.ws.execution.Invoker @ line 95, column 95.Script1.groovy: 97: unable to resolve class com.prosc.ws.execution.Invoker …

Here is a slight variation of the writeToFile module, so it also accepts filemaker paths. I know it is not 100% error free. OutputStreamWriter writer; File f; try { //The path is an OS path f = new File ( filePath ); create = f.createNewFile(); } catch ( Exception E ) { //The path is a FM path f = fmpro.fileForFMPath ( filePath ); create = f.createNewFile(); } writer = new OutputStreamWriter( new FileOutputStream( f ), "utf-8" ); writer.write( textToWrite ); writer.close(); return true;

I have just downloaded ScriptMaster and have put the plugin into the correct folder but can't seem to get the external functions to work. I can run ScriptMaster.fp7 and select the "Get URL as Text" module and "run Script" which gets the URL that I have inserted. However, when I try and register the function and use it, I get the error "The specified table cannot be found" when I run it from the data viewer or from within a script. I have followed the video tutorial but can't seem to see what step I have missed.

We've built a plug-in using Scriptmaster Advanced and note that it writes a log file to a folder called 360Plugin Logs into the documents folder in the users My Documents folder. It is possible to turn this feature off? If not, can the output be directed elsewhere? Does deleteing the folder cause any problems for the plug-in? Thanks Brian

I'd like to use the new native JSON support in Groovy 1.8. Any chance of an update to ScriptMaster? http://docs.codehaus.org/display/GROOVY/Groovy+1.8+release+notes

Hi, I can make a pdf from multiple records, using sliding etc. But I want to use the company writing paper as a background. Is it possible to add the company paper (which I have as a pdf) to a new pdf using SM and iText or something? Best regards, Ruben van den Boogaard Infomatics Software

Hello, I thought I was almost an expert at FileMaker until I tried to use the ExecuteSQL function. I thought it would be simple to type in a basic SQL statement and come back with some usable data. But I was surprised to find that everytime I tried to use the WHERE clause with comparison of text as the data type I would always recieve ERROR 8310. I spent the better part of the day trying to figure out this one. It seems that the ExecuteSQL function provided in ScriptMaster cannot understand the Smart Quote character, example: ‘your text here’. By default FileMaker turns off the 'Use Smart Quotes' option, but somewhere along the way you may have forgotte…

I'm doing some simple PDF page counting and concatenation using Matt Petrowsky's ScriptMaster/iText demo file. This worked pretty much flawlessly, until recently. Depending on the particular source PDF files, my page count and PDF merge functions are now failing, but SMLastError is empty, so I don't have anything to go on in troubleshooting. Is this a ScriptMaster bug? I've checked the source PDF's (not generated by me) and it doesn't look like there's any file protection that would be interfering. Even if that were the case, shouldn't a descriptive error be generated? I'm just not sure how to proceed. Thanks in advance for any ideas! -Stu

From Website Stable Releases: Groovy 1.8 Groovy 1.8 is the latest and current stable branch. The latest version of that branch is Groovy 1.8.5. Not sure how many months we have been asking to get up to date. Any chance while the year ends in a 2??

I am sure i am just doing it wrong. My script has two output variables, result and resultCode. I am calling my script as an external function. When I attempt to access these variables I get this error: 12/27/11 1:45:36 PM [0x0-0x671671].com.filemaker.client.pro[21838] SEVERE: PluginFunction PluginFunction{name='SMGetVariable', functionID=-28360, minArgs=null, maxArgs=1} got an error with converted args [resultCode] 12/27/11 1:45:36 PM [0x0-0x671671].com.filemaker.client.pro[21838] java.lang.IllegalStateException: You can only get ScriptMaster variables after evaluating a script, and before setting any new variables. The FMP scripting looks like…

So I think this is impossible but let me ask anyhow We are building a solution that manages our small Wireless ISP (~2k customers). One of the applications we are building is a tool that lets us manage router lists for IP addresses via SSH. ScriptMaster to the rescue! However, the firewall rules these addresses are mapped to only exist on the router itself. There is no FMP equivelant. We chose this since these rules can also be managed in the field at the command line so there was no nice way to keep them in sync. Managing these would be easiest to do in a Portal layout. Is there a way to have ScriptMaster populate a portal based on the results of a scriptmaste…

I have just started using a computer with the 64-bit version of Windows 7 Professional (a Dell Optiplex 990, Intel Core i7-2600 CPU @3.40GHz, 12GB RAM) and have installed FileMaker Pro Advanced 11.0v3. If my understanding is correct, I will need to install the 32-bit version of Java for use with 360Works Java-based FileMaker plugins. Is that correct? Presumably, I would also install the 64-bit version of Java for the purposes of other, 64-bit applications or web browsers on the computer (and, presumably, for future versions of FileMaker and associated 360Works plugins). Are there any issues I should be aware of when using current 360Works FileMaker plugins on computers ru…

Does anyone know how to load the ant.jar classes dynamically rather than have to put them in the classpath for each machine you want to use them on?? Or can anyone explain WHY they need to be there ( same as mysql-connector or sqlitejdbc)???

I have a problem with the use of RunShellScript with a plugin that I created. On the Mac, it works correctly. With Windows 7, it does not work with RunShellScript, while the same command slipped into the test field of the file ScriptMaster.fp7 works. (But the script uses EvaluateGroovy and not RunShellScript). Here is my script: Set Variable [$cmd = "latex.exe -output-directory=" & $DirectoryPath & " " & $FileTexPath] Set Variable [$result = RunShellScript ($cmd, "true", 30)] ($DirectoryPath and $FileTexPath are quoted path) I get the following error message: java.lang.IncompatibleClassChangeError: the number of constructors during runtime…

This html runs just fine as a web object, but I can’t get Scriptmaster’s GetURLAsContainerpart2 to get the graphic…Am I doing something wrong? "http://chart.apis.google.com/chart?chxr=0,-43.333,98.333&chxs=0,676767,10,1,l,676767&chxt=y&chbh=a,0,0&chs=200x200&cht=bvg&chco=008000|008000|008000|008000|008000|008000|008000|008000|008000|008000|008000|008000|008000|AA0033|AA0033|AA0033|AA0033|AA0033|AA0033|008000&chxr=0,-100,159&chds=-100,159&chd=t:-74,-83,-83,-83,-86,-29,-27,-20,-17,-17,-17,-17,-61,159,138,138,138,130,99,-10&chma=|0,6&chtt= BCGC+Lab+Load+(%+diff+of+mean+load)&chts=000000,10" Just get the results …

Hello, I'm looking for a script or another way to resize a pdf A4 file to fit in a smaller sised webviewer... Is that possible ? Thanks for your answers Noël

When you call this in a loop for (i in 1..num){ a = fmpro.evaluate("GetNthRecord($fm_field; $i)") list = list + (list ? ',' : '') + a } It gets exponentially slower It has just been tested on data sets up to 175,000 today Is anyone at 360 able to give insight as to why??

Hi, I'm getting an index out of bounds exception from the fmpro object when executing a query. It seems a particular record is causing the problem, because it doesn't happen when I change the parameter in the WHERE clause. The exception originates from FMPro.java:179 java.lang.ArrayIndexOutOfBoundsException: 3 Parameters: {sql=SELECT "Record No", "Category", "Message details", "Date" FROM "Job Tracking 2" WHERE "Job Number" = '0000511'} ---Script--- Script: String[][] data = fmpro.executeSqlArray( sql ); return ""; Thanks, Ryan

I'm working with the Choose Folder function that is provided with ScriptMaster. This uses JFileChooser and says that in the chooser.setFileSelectionMode() step you can specify whether files, directories or both are shown in the Open Dialog box. My problem is that the FILES_ONLY choice gives me the same result as FILES_AND_DIRECTORIES - whichever option I use I see Directories and Files in the dialog window. DIRECTORIES_ONLY behaves correctly and only displays Directories Is there a bug in jFileChooser? I'm using Scriptmaster 4.02 (dated 3 Aug 2010) on Windows 7 with Filemaker 11 Adv. Thanks Brian

Is there any way to get a list of the functions in a Scriptmaster plug-in into Filemaker so I can see if a specific function is available to use? I realise that I could call the function to see if it returns an error, but in this case it is the ChooseFile function and I don't want to confuse the user by putting up a dialog box for no obvious reason if that function is present Thanks Brian

I created a plugin with the function ExecuteSQL with ScriptMaster and the Portfolio license. I copied the license key and the name that was generated in a var script step in the startup script of the solution. But this function shows Missing in the scripts on the other mac's (plugin's are present there) What am i doing wrong?

Hi forum I'm using this function to generate a thumbnail: ImageThumbFromURL( Substitute( $Pfad ; "\\"; "\\\\"); 140 ) This works perfectly well no matter whether $Pfad is a URL or a local path in Windows runtimes, in Filemaker Advanced on Windows an on Mac 10.6 and 10.7 The same code executed in a runtime on Mac generates nothing but the text "ERROR" in the thumbnail field. The plugin ist loaded and visible in the list of plugins. Any ideas?

Hello, Is there a list of fmpro methods that are accessible. Such as, fmpro.getContainerStream(fieldName) Or are these methods private IP owned by 360Works? There are some extremely powerful methods hidden in the fmpro class that I may be able to use if I knew the syntax of the methods. Thanks for sharing!

I have installed the current version of ScriptMaster and watched the demo which enabled me to understand how to install the function I want to call (currently RunShellScript) what I don't get is how to activate it in my solution. For example if I want to add a button to my layout that executes a specific shell script using this function, how do I define the button or what do I place in a script that the button can then call? The documentation is really clear on how to get the functions into my solution, but very muddy on how to put them into use. If there is a good location to find examples in use, I'd love to see that resource. -Thanks

Am I able to point to a file on my local hard drive in windows and set a field with the base 64 string of the file pointed to? Unable to find this in scriptmaster. Thanks Stu

... feel free to report bugs & errors // USAGE : LocalTimeStampToUTC ( fm_TimeStamp ; fm_TimeStampDateFormat ; fm_UtcOutputPattern ) // 20111115 clem // version 1.2 // // fm_TimeStampDateFormat => 1 = dd/MM/yyyy; 2 = MM/dd/yyyy; 3 = yyyy/MM/dd // fm_UtcOutputPattern => see http://download.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html // // EXAMPLE = LocalTimeStampToUTC ( 01/01/2011 00:07:20 ; 1 ; "dd/MM/yyyy HH:mm:ss" ) [ my machine is located in Time Zone GMT + 1 ] // RESULT => 31/12/2010 23:07:20 import java.text.SimpleDateFormat import static java.util.Calendar.* if (fm_TimeStamp && fm_UtcOutputPattern ){ …

Using ScriptMaster 4.1.2.4 on FMA9, OS X 10.6. I'm consistently getting this error when trying to zip an 225mb FMP file. - Am able to use OS X "compress file" to successfully zip the same file. - Am able to use SciptMaster to zip a smaller file in the same directory. So... is there a file size limit for this module?

Hello, Denmark calling! I think i´m in love with ScriptMaster - but i´m struggeling to get started.... maybe i´ll just explain: I have developed a medium sized trucking/transport solution and have been running it for apx. 2 years now and the only real problem i have had, is sending Email from the server. We have a Windows 2003 + FMS10 Adv. server with IWP running the online booking and a scheduled mailqueue to send mail though a local mailserver every 3 minutes.... It....kind of works....(all attachment to the server-side-sent mail is getting corrupted - known bug in FMS as i understand it) - so i have tested your wonderfull ScriptMaster plugin (locally) an…

Hello, I've tried to find discussions on the subject but didn't find a solution. I've seen in the sample file that it's possible to create a compressed archive (zip) of a file. But I don't know if it is a possible : to compress a folder and the files within it to extract from an archive all these files Thanks for you help Noël

Hey everyone , I have just purchased Scriptmaster in the hope that the script timer function would perform a few tricks for me , but I'm stuck. Firstly , I'm using FMPA11 on windows 7 64bit , Java Runtime version 1.6.0_24. I am having a few problems so maybe some here can help me. Firstly , when I use the ScriptMaster.fp7 file to test the CallScriptWithDelay external function , it does not trigger the script after the specified delaySeconds value. EG: fileName = ScriptMaster scriptToRun = TOC delaySeconds = 20 (or 5 or anything else) The resultcode of these tests are always "1" , which I think means no error. The script does not trigger after t…

I have been using the Execute SQL function with very simple statements for create, update and select for a year or so and enjoying the benefits. But I have one simple question that I am sure those with a ore than basic level of SQL knowledge will be able to answer: What is the difference between Execute SQL and Execute SQL Array? Surely if the statement in an Execute SQL command returns more than 1 record and has more than 1 field then the result is a two-dimensional array as described in the Execute SQL Array notes in the ScriptMaster demo file? Thanks for anyone talking the time to explain the difference. TIm

Hi, I have a ScriptMaster function that acts differently when running locally vs. running against our server. Scenario: Same exact database, one local and one on the server (obviously, FMP 11 local client has the plugin). When I run my script against the local database it works great, completing in 20 seconds or so. When I run my script against the remote database it takes about 10 minutes and hangs until this error spits to console (same exact plugin, just one on a locally opened DB and the other test on the same DB opened from FMP Server Advanced) 11/8/11 12:33:49 PM FileMaker Pro[9492] *** __NSAutoreleaseNoPool(): Object 0x3acc24f0 of class N…

Greetings, Apologies if the solution to this is obvious, but I'm not sure what approach I should take. My situation: we are using FileMaker Pro (not Advanced) in conjunction with FileMaker Server Advanced, and also use Instant Web Publishing (IWP) from the FM Server, along with Enterprise version of SuperContainer. It's because we are using SuperContainer that I would like to be able to use UUIDs to generate the directories where SuperContainer stores its files. So, ideally when client using either FM Pro, or from the web through IWP connect and create a new entry in the database hosted on FM Server, they would have access to the UUID function in the server's …

I have been using ConnectorJ Mysql-Connector-Java-xx.jar with Groovy to do SQL connecting and 'forgot' to install the jar in the classpath on a windoze machine so here's a little helper for anyone which returns a list of the places you can install it. s = System.getProperty('path.separator') j = System.getProperty('java.ext.dirs').tokenize("$s") return j //returns last value in list //return j[-1] if you use it on Mac then its the System/Library so you need to convert the path to ../../../$path to be able to use export file from container

Hi, I am running Mac OS 10.7.2, FileMaker Advanced 11.0v4 and ScriptMaster 4.124. I have successfully built a custom plugin for Mac but I changed a script and tried to rebuild the plugin and FileMaker hangs. I have built several plugins without problems for other projects but this particular one won't build at all. I have disabled networking and ScriptMaster does prompt with the message 'com.prosc.fmkit.FeedbackException: You do not have a network connection. You must be online in order to generate plugins.' However, when I am online and repeat the SMCreatePlugin function it hangs completely. Has anyone else experienced the same issue? Any ideas? Is the 360wo…

Hi! I have been trying to use the following function "Get URL as Text" on a SSL encrypted site (https). I get a question mark as a result. Is there anything I can do to get it working? Thanks for helping. R

I have created an open-source project called ooScriptMaster, which stands for object oriented ScriptMaster. You can view the project here: https://github.com/dansmith65/ooScriptMaster This project is both a repository of functions for ScriptMaster AND a framework for writing functions for ScriptMaster. If you know how to write groovy code; have a look at the groovydoc and the structure of the code, and try adding your own function to the project. If you would like to share your function, submit a pull request via GitHub. If you don't know how to write groovy code; download the ScriptMaster.fp7 file and test out the functions it includes. If you notice any bugs, …

Two interesting (for me) problems discovered tonight after hours of experimentation. I would really really love it if I am doing it wrong. 1) Using fmpro.executeSqlArray, if a field is empty it just not returned. This makes reliable parsing of the resulting array impossible. Example: String[][] site = fmpro.executeSqlArray("select id,customer,address1,address2,city,state,zip,plan,customer from site where id = " + siteIn); if address2 is empty you get this as a result [[37197, 58320, 30 Oak Dr., Napa, CA, 55555, 675, 55555]] if address2 is populated you get this as a result [[37197, 58320, 30 Oak Dr., suite 512, Napa, CA, 55555, 675, 55555]]…

Can ScriptMaster Zip File (src ; destination) unzip a file as well? Thanks Chris

Hi, is it possible to improve the jpg quality that ScriptMaster uses in the Screen Capture function? It's very pixelated for what I need. Thanks Chris

Hello, Excuse my approximate English and the repetition if the subject was treated before. To cross parameters in a Scriptmaster script I know how to use fields from FileMaker; my question is to know if we can cross variables $xx or $$yy Thank you for your answer

How would I set up this using PostXMLData : got to web page https://www.con-way....ustSpecTest.htm paste in this data to see the xml results <RateRequest> <OriginZip country='us'>49548</OriginZip> <DestinationZip country='us'>48917</DestinationZip> <CustNmbr shipcode="S">304469208</CustNmbr> <ChargeCode>P</ChargeCode> <EffectiveDate>10/14/11</EffectiveDate> <Item> <CmdtyClass>50</CmdtyClass> <Weight unit='lbs'>1895</Weight> </Item> <Accessorial>SSC</Accessorial> <Accessorial>DNC</Accessorial&…

Hi, we use the SM plugin for charting. We are running v4.124 of the plugin with v11.0.3 of FMP on OS X 10.6.7, with JRE v1.6. I have a user who has to wait nearly four minutes for FileMaker Pro app to launch. Removing the plugin from the Extensions folder fixes the issue. Any idea what is causing this? Thanks

I am trying to deploy an application cross platform using the Runtime of FileMaker 11. I have it working on the Mac. I previously had this working in Windows 7. I currently copy my FileMaker file over to Windows to make minor modifications on that platform before generating a runtime for Windows. This previously worked, I do not know what changed. I can see the ScriptMaster plugins through the Preferences dialog. When I open Scripts now in FileMaker Advanced, I only see the Basic Functions and not the library of functions like "Select a File". So the functions I inserted before on the Mac side now show "Function Missing". I used the method of Copy and Paste to add to my s…

Hi, I started working with output variables in my different tests, and I was wondering if or how I could integrate those concepts once the function was registered and it was used via the calculation dialog. first of all, is it possible ?

We have had headaches, for years, dealing with APR Calculations involving Loan Processing Fees. It is related to Fed. Regulations. Accountants use a standard IRR Calculation for this, but FileMaker is a bit limited on that front. I've written one, back in FM 6, but we prefer to go with something more standard. We currently use Excel when needed. Last night, I was Googling, out of curiosity. I saw references to a Groovy based Financial package, with an IRR Calc: FinancialService.IRR. I haven't found any reference as to where it comes from & I haven't written any plugins myself yet. Anybody know where this package comes from (part of Groovy,…

Is it possible to feed a UNC path to our shared NAS drive to the CreateFolder module? Although I receive a "1" success, I do not see the folder.

I did a demo runtime which works well in the office. Gave it to someone to test on Windows 7, they have the latest Java installed but get a 360works message saying that Scriptmaster requires at least Java 1.5 to run. Any ideas why this might happen ,or has anyone else seen this? I cant get to see the machine for a couple of days.

I need to apply the CheckWhetherFileExists function and the MoveOrRenameFile function to file names that contain a forward slash ("/"), i.e. a forward slash is part of the file name. The function CheckWhetherFileExists is not handling paths that involve such file names correctly. I presume that it interprets the "/" as the separation between a folder and the filename, when in fact that whole thing is the file name. Is there any way I can sort of "escape" the last forward slash so that the ScriptMaster plugin looks for a filename that contains a forward slash? Any thoughts on how to accomplish this? Marcelo

Same comments as the upload basically. There's some FTP code posted but here's a basic SFTP version. Feel free to correct me or add to it and post. Some elements actually might not be needed or could be better written. I'm not a programmer per se so be nice..... /********************************************************************************************************** * SFTP Download * parameters sftp_hostname, sftp_username, sftp_password, sftp_port (should be 22 I believe) * remote_directorypath, remote_filename, local_directorypath, local_filename * * JSch is licensed under BSD style license. * http://www.jcraft.com/jsch * http://…

In the ScriptMaster 4.11 sample file there was a function QuickTime Frame Capture which I no longer find in ScriptMaster 4.124. I think I had this work in 4.11, but now it fails, whether I go back to the 4.11 plugin or use the current version. I just get the spinning wheel forever, not even an error message. Does anyone have a clue about this? Anyone got a working webcam capture for ScriptMaster? I'm using FileMaker Pro Advanced 11.0v4 on Mac OS X 10.6.8, with QuickTime Player 10.0 (128).