ScriptMaster by 360 Works

I have an application that I have been working on for over 18 months. There are about 30 version developed over that period.  Yesterday I 'updated' my Mac 10.8 with Java 7.  Now, ALL copies of ALL versions will not run my import script.  Here is the 'offending line': Set Error Capture [On] Set variable [$$FilePath; Value:SelectFile]   On execution this line hangs.... ie, produces the spinning beach ball of death.  I used to have this problem until I discovered that Set Error Capture needed to be ON.... and it is.  Since ALL previous version all hang on the same line and since I only updated to a 'fixed' (ha) Java v 7 I have to ask "Is an…

Hi, I use Scriptmaster with Filemaker Server 12 on Mac OS Mountain Lion. I have 2 different server side script, both using external functions as GetURLasText and XPathParse. When the 2 scripts are executed in the same time, the FMSE process crashes and scripts are stoppped. I noticed in the data that sometimes, the result of XPathParse in script A was not what it was supposed to be, but actually it was the result of XPathParse command executed in script B. Any idea ? Julien

Hello I want to make a basic browser for harddisks. I found out, that ScriptMaster can help me with the. My example work with triggering on one field, with the result in another. Now I want to click on any folder (file in a second step, but this is another issue) and get to that path. If I could split the result in various fields and make buttons on them, I would have the solution. Any hint or help on that issue? Cheers Foldercontent 0.9.fmp12.zip

Please, could somebody explain how to solve my problem? I have to write down the amount in words in Polish. I found a java code implementing this functionality. (see attached file slownie.java) I want to use method: procKwotaSlownie (double kwota) I compiled the code and put slownie.jar in conteiner field. I used SMLoadJar to register JAR. I would like to use the method (procKwotaSlownie). To this end I used EvaluateGrovy. Unfortunately I get only ERROR. See attached the file with my example database (slownie.fmp12). Thnk you in advance. slownie.zip

Since I'm not a Java guru yet, here's a question, Can and how do I keep variables and states etc. in my java (groovy) between FMP scripts etc. Say I want to have an entire program running and that would communicate with FMP via script calls etc, how would I do that? or ... its the environment totally destroyed at the end of the current script master call once control is passed back to FMP? Charles

Hi, I'm completely new to Groovy and am trying to replace the 3 versions of the double quotes with 2 single quotes in a large CSV file. I've managed to get the script below working but the input file encoding is UTF8 and the output file comes out as "Western (Mac OS Roman)". Any help would be greatly appreciated, Thanks File myInFile = new File( myFilePathStart ); myOutFile = new File( myFilePathEnd ); myOutFile.withWriter { out -> myInFile.eachLine { line -> myOutFileText = line.replaceAll(""", "''"); myOutFileText = myOutFileText.replaceAll("“", "''"); myOutFileText = myOutFileText.replaceAll("”", "''"); myOutFileText = myOutFileText + "n";…

Hello, i run a scheduled script on ther FM Server 10. this sheduled script from File "APP_Engine.fp7" run ExecuteSQL("SELECT Field1 FROM Table1"). The result of the excecution ist "ERROR" ! Table1 exists as a Table occurence (TO) in APP_Engine und comes from an other external file "DAT_Engine.fp7". what am I doing wrong? NOTICE.: When i run the SELECT on an internal Table (in APP_Engine.fp7), it works. thanks for your help!

Trying to make this cool timeline work with scriptmaster and a web viewer. http://www.simile-widgets.org/timeline/ Downloaded the libraries from here. Timeline Libraries v2.3.0 http://code.google.com/p/simile-widgets/downloads/detail?name=timeline_libraries_v2.3.0.zip&can=2&q= Here is a listing, but no jar files. I have not done much of anything with Java programming. Any hints or clues?? Thanks! CHANGES.txt LICENSE.txt README.txt timeline_ajax content history.html images bubble-arrow-point-down.png bubble-arrow-point-left.png bubble-arrow-point-right.png bubble-arrow-point-up.png bubble-bottom-left.png bubble-bottom-right.png bubble-bottom.pn…

I have read the user guide (http://360works.com/plugins/SCRIPTMASTERPLUGIN/documentation.html) to install Scriptmaster Plugin on the filemaker server, in order to run scripts within Filemaker Server Schedule. i does the folwing steps: Install steps for FileMaker Server 9 or later You do not need to do this step unless you plan on using the plugin with scheduled script triggering, a new feature in FileMaker Server 9. You will need an Enterprise License to use this feature. Drag the plugin from the MAC (.fmplugin file) or WIN (.fmx file) folder into the FileMaker Server extensions folder. On Mac OS X, this is located at /Library/FileMaker Server/Database Ser…

HELP! I have put together an import script that uses ScriptMaster for a couple things like check for the existence of the fuel, create a folder, move it and zip it. When running this on the desktop, it works flawlessly, Now I need it to work from the server as a scheduled script. I can confirm that the plugin is indeed loading and loading all necessary scripts for the various functions, all ok. But the buck stops there. If I ask, does the files exist? I get back, NO. If I check from the data viewer on the desktop for a copy of the file in my documents folder--YES....on the sever documents? NO. I changed the permission on the files in case that was the issue...No …

Hi all I have been looking at a java library for MetaData Extractor to grab the EXIF data from images The library is here... http://drewnoakes.com/code/exif/ I added the 2 jar files from the download into Scriptmaster. I am not sure what to do next. I created a new module and called it Get EXIF I then added a new Input Variable of 'Image' (this is where a container field should be entered) And an Output variable of 'EXIFdata' The project Wiki says the code to read the metadata from an image is File jpegFile = new File("myImage.jpg"); Metadata metadata = ImageMetadataReader.readMetadata(jpegFile); And the code to Output all Metadata Tag…

Hello! I have a weird issue going on that is driving me nuts. I want to use the RunShellScript command to open an application. When I use the command in the terminal or even call it via an Applescript (via the editor) it works just fine, the app launches and NO error code for loading the SM plugin shows. HOWEVER, using the exact same code and running the RunShellScript function, the filemaker runtime will open fine, but I get an error that I need to have Java 1.5 or higher installed. And of course, once the runtime finishes loading, I get the SM error that the plugin may not have been installed properly. If I close the file and open it manually by clicking …

Hello! Just wanted to mention that I was using the UnZip feature in FM12 Mac and have had errors. When unzipping, I found that the there were extra folders created in the unzipped data (i.e. a "___MACOSX" type folder). I went to using a Shell Script instead. Just curious if others have had issues or not. Maybe I am missing something. Thanks, Stephen

Anyone have any familiarity with using statistic java classes with SM? Specifically we would like to use the JSC (Java Statistical Classes) found here: http://www.jsc.nildram.co.uk We need some heavy stats work and having access to this jar would be a big help. Ideas? By the way, we are currently interested in Fisher’s Exact test. Thanks

Hello, This is likely a simple question, but Groovy is not my normal language. I have a script to send SMS. I can get it to work using strings. But when I replace the string with the incoming parameter name, I receive an error. My incoming parameters are defined as follows: Parameters: {to=+15035551234, from=(503) 555-1111, message=testing} Here is my script: // Download the twilio-java library from http://twilio.com/docs/libraries import java.util.Map; import java.util.HashMap; import com.twilio.sdk.resource.instance.Account; import com.twilio.sdk.TwilioRestClient; import com.twilio.sdk.TwilioRestException; import com.twilio.sdk.resource…

I am trying to implement a server side script that will interface Filemaker 11 with the Zendesk API. For instance to retrieve xml for a ticket I can achieve this with Curl and an applescript call: "tell application \"FileMaker Pro Advanced\"¶set field \"XML\" of table \"XMLdump\" to do shell script \"curl -u 'username:password' http://mycompany.zendesk.com/tickets/" & Globals::ZDCurrentTicketID & ".xml | vis\"¶end tell" My question is can I do this curl call with a Scriptmaster function so that it works on a server/windows and do I have to use curl or is there an alternative? I have done some digging but with no lcuk, any pointers much appreciated :

Hello, I've a Power PC iMac with MacOS X 10.5.8 running. Filemaker 11 is installed and I'm trying to install the Scriptmaster extension version 4.1.34. I've put the extension in the extensions folder but I'm unable to activate it. The checkbox remains unchecked. This is what the logfile says: (C++ Mon Jan 14 18:34:08 2013) INIT - Appending to existing log file (C++ Mon Jan 14 18:34:08 2013) *** INIT for 360Works ScriptMaster_FMPro at Mon Jan 14 18:34:08 2013, headless mode 0, appTypeShort 1 (C++ Mon Jan 14 18:34:08 2013) ***Called Init 7.3 with version string (C++ Mon Jan 14 18:34:08 2013) Call finished (C++ Mon Jan 14 18:34:08 2013) java.lang.Number…

Is it possible to pass SMSetVariable a string of text and not have it change the ¶ character? Let me explain in more detail. My company currently uses the Troi Plugin to hash large strings of text. We developed a function with Scriptmaster/Groovy that will hash our strings. However, we need all of our previous hashes that were hashed using troi to be equal to a hash that we would be able to create with our current solution. For example if we were to go back and rehash a string, it must be equal to the previous string that was hashed by troi. This works fine until a string containing the ¶ character is involved. From what I understand, the SMSetVariable function conver…

Has anyone ever seen or implemented anything that allows Filemaker (or Java running within it) to listen for mouse events to allow the user to indicate dynamically at runtime which portion of the screen should be captured?

Need help with this function. The goal is to bypass the web form and load the resulting table direct to a field. Modified the PostDataToURL function to include the additional parameters, just hardcoded. The script returns ERROR. FM11 Adv, MAC Thanks in advance! Calling script. PostDataToURLxx( "FFX" ; "2" ; http://aa.usno.navy.mil/cgi-bin/aa_rstablew.pl ) Registration script. RegisterGroovy( "PostDataToURLxx( key ; value ; url )" ; "// Construct data¶ String data = URLEncoder.encode(key, \"UTF-8\") + \"=\" + URLEncoder.encode(value, \"UTF-8\");¶ // use something like the following to send multiple key/value pairs¶ data += \"&\" +…

Hello, I have a Filemaker runtime solution using 360ScriptMaster to make AWS requests through it . Beside that plugin I use also InsideScan (an image acquisition pi) and Doscript. It works fine on many recent iMac, on many G4 and Macbook (Pro or not) but an user said me this evening that he couldn't get infos from Amazon on Mac having G3 processors. I've just installed Tiger on an old iMac G3 500Mhz and encountered the same problem. The minimal configuration for Filemaker 9 is Mac OS X 10.4.8 PowerPC G3, G4, G5 ou Intel 256 Mo de RAM. Do you know a limitation of the 360Scriptmaster plugin ? Thanks for your help ! Noël

I have a client with 7 identical machines all bought at the same time all configured the same way with the same major applications (programmes). All using the same version of Windows 7 service pack one. All using FileMaker 12.0v3. In every single one except one the ScriptMaster plug in loads fine. In one it says: "?" failed to initialize. I have checked the firewall and a host of other settings but obviously not the right ones as I cant get it to load. Anyone have any clues what might be wrong please? The last version of windows is always better than the current one!

This code returns the canonical version of an XML document. import javax.xml.crypto.* import org.apache.xml.security.* import org.apache.xml.security.c14n.* if (inputXML!=null){ org.apache.xml.security.Init.init() def XmlBytes = inputXML.getBytes("UTF-8") as byte[] canon = Canonicalizer.getInstance(Canonicalizer.ALGO_ID_C14N_OMIT_COMMENTS) canonXmlBytes = canon.canonicalize(XmlBytes) canonXmlString = new String(canonXmlBytes) return canonXmlString } Hopefully someone else might find it useful. Ian J

After Fabrice's thinking outside the box about sort orders I decided it would be easy to make a little function that could return the record ID's for use in a ExecuteSQL( lalala IN this list ) So export a snapshot link, then use the OS path to the file in this Feel free to suggest improvements // SnapshotLinkID ( fmpsl ) // 12_12_12 JR // v1.0 // returns comma separated list of values from snapshot link file // also can get table and layout to show how it's done - amend at will fm_xml = new File( fmpsl ).getText() root = new XmlParser().parseText(fm_xml) listz = root.UIState.Rows.text().tokenize('n') a = [] listz.each{ if (it.contains('-')){ pos = it.indexO…

I've copied the Run Shell Script function from ScriptMaster into my solution with a startup script to register the function. When I try to execute a shell script with WaitForReturn set to "true" I get: "Executed Shell Command: <Shell script>" Why am I not getting the output of the shell script?

Was playing around with the new XMLtemplateEngine in the latest Groovy today and offer the following function for returning currency conversion rates via SOAP //ExRates( from ; to; amount ) // 12_02_20 JR // v1.1 // adapted from Groovy API examples // from, to -> 3 letter currency codes // if amount is null returns rate else returns converted value import groovy.text.SimpleTemplateEngine as STE import groovy.xml.Namespace XMLtext = ''' <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/…

Hello, I'm using ScriptMaster to combine two PDFs. I can combine the two PDFs just fine if they do not contain any form fields. As soon as I use a PDF that contains form fields, I receive an error that the two PDFs were unable to be combined. I've encountered this on FMP12v3 running on OSX 10.6.8 If you need additional information from me, please let me know and I will provide it.

Been playing around with InsertFromURL and XML CWP so started by writing a simple function to parse the returned result (SO much easier in Groovy than writing parse functions in FM) and realised it is also possible to to both in one go So if you are a code hoarder like me here it is... // FMurlXML ( fm_url ) // 12_12_05 JR // either runs CWP script and returns error code and version // or just parses the code from the result of InsertFromURL // fm_url is either a formed url - http://yyy.xxx.com/fmi/xml/fmresultset.xml?-db=plug&-lay=tzt&-view&-script=txt or the XML results if (fm_url[0..3] == 'http'){ root = new XmlParser().parseText(fm_url.toURL().te…

I have a client that uses a Citrix Xenapp server to provide remote access to our FileMaker application. They are having the problem their IT person describes below. Any recommendations on how to resolve this? Thanks, John I have more information as to the issue we have. The actual problem is the log folder c:360Plugin Logs. The user accesses the Filemaker program on our XENAPP server and this folder is created along with two files (360Works ScriptMaster_FMPro.txt, 360Works ScriptMaster_FMPro.log.lck). The next user that accesses Filemaker creates this folder and two files again but inside the first folder. This continues to happen until the folders are 5 le…

Anyone know if it is possible to generate sha256 encrypted text using Scriptmaster? any response is highly appreciated.

I am wanting to post status updates to Facebook using Filemaker 12. I will need to include authorization as I want to be able to post as multiple users FB accounts. (With the users permission) Thanks in advance

It encodes but not the file. When I use an online decoder the decoded result is below instead of encoding the actual contents of the container: remote:ThePDFName.pdf FILE:FMFileName/FieldName/ThePDFName.pdf

Is there any way to stop, or restrict the log file. I have a plugin created with ScriptMaster with a that is called about every 2 secs, 24 hours a day. This is creating a huge log file, and I think possibly causing the routine to hang occasionally - the last noticeable time the log file was over 1Gb. Tricky to open in NotePad! If there was a command to set the log file to record only errors rather than routine calls it would be a great help. Or a way to start a new log file without restarting FileMaker as this is not an option. Thanks Tim

I would like to be able to include a plain text version of the HTML formatted message that I can already send with Scriptworks. According to the docs, this capability is part of the EMail plugin. Is there also a way to achieve this with Scriptworks?

Hello, I have a pdf file which consists in a table like a calc sheet ; every cell can have one ore more lines. Using the iText and ScriptMaster I can read line after line but that doesn't help me enough. Is there a way to parse a pdf and get the content of every cell ? I join pdf and text file I can get now... Thanks for your help Noël PDF_INE.txt PDF_INE.pdf

Hello, I really need a progress dialog function for ScriptMaster. Anyone have one? Or can point me in the direction of one? Thanks, Jeff

Whenever, there is an attempt to pass NULL values as parameters using POSTDataToURL using 360 scriptmaster plug-in, there is an error regarding null pointer exception. Is there any way to have null values pass successfully using PostDataToURL?

Everytime I try to install the scriptmaster plugin I see a quick flash of the FMP 12 Advanced splash screen then nothing. I remove the scriptmaster extension and it opens perfectly. Is this an issue that requires some sort of update? I purchased this plugin license and wished to renew it another year but I need it to work. Please anyone...

Hi all, I cannot see it anywhere in the documentation but thought I would just ask for good measure. Does ScriptMaster have the functionality to get the volume/disk serial number? I know the Troi File Plugin can do this, but we don't need the other functionality of the plugin and for a simple job of just getting this number it does not warrant the developer cost of the Troi plug-in. Many thanks Ed

Hi all, I'm trying to set up texting from filemaker using Cdyne web service http://www.cdyne.com/ Curious how I would set up scriptmaster to connect to Cdyne.? --- or I just saw - Web Services Manager plugin - is this better to use for this? Any hints to get me started would be appreciated.... I found this page ... http://sms2.cdyne.co...s/SimpleSMSsend and they discuss the response XML body.... but I'm not sure how that would work from the plugin perspective... The following is an example response Xml body: <SMSResponse xmlns="http://sms2.cdyne.com"> <Cancelled>true</Cancelled> <MessageID&…

I am running OSX 10.8.2 and developed an app that worked great; until I updated FileMaker 12 to v3. In V3 when I run code from a popup, it crashes FileMaker. Anyone else have an experience like this? (BTW: If I 'downgrade to FileMaker 12 v 1, everything works great!)

I am pulling down the html text in to a file and i want to pull out the links I saw get image URLs My end goal monitor member sites for changes daily. When the change happen notify different members in their network so that the change can be noted on their sites also Ie a link and teaser Text Rob

I am running FM 12 Adv 03 and my SM plugin blows up FM. If I run it under v 01 it's ok. In the process of making sure that I had the current plugin installed, I find that in my Extensions folder there is no plugin. But, the function still works? (although it blows up Filemaker 12) Huh? So, I go to Users/Shared/Filemaker/Filemaker Advanced/12.0/ and it's not there either. I do a spotlight search and it doesn't show up. If I copy the latest SM 4.134 to the Applications/Filemaker etc... Extensions folder, it still blows up FM. Do you think these two phenomena are related? By the way, I tried to setup 'auto update' following the instruction on t…

Ok, I've registered the PostDataToURL in FMP and copied the code into my startup script. Now how do I use it in a script? It seems to be just a function in a calculations. I have the field I want to push waiting to go but don't know what to tell it. Obviously I am not adept a writing JS or code so any help is appreciated.

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 Upload * parameters are * sftp_hostname, sftp_username, sftp_password, sftp_port (should be 22 I believe) * remote_directorypath, local_directorypath, local_filename * * JSch is licensed under BSD style license. * http://www.jcraft.com/jsch * http://www.jcraft.com/jsch/examples/ * http://epaul.github.…

Hello, has someone managed to work with rxtx comm for accessing serial ports? (rxtx.org) Any help appreciated. Markus

I have a web viewer that is used to navigate through sites. I want to be able to get the URL that the viewer is on. I saw a suggestion that ScriptMaster could help this, but I cannot figure it out. I'm using the GetURLasText function, but it returns "ERROR" This is my script GetURLasText( GetLayoutObjectAttribute("Video Browser";"Content") ) Am I doing something wrong here? I don't really know how either the GetURL or GetLayoutObjectAttribute work, but the latter returns pretty much all of the html code about the site, but from this, I just want the URL. Edit: Nevermind, I got it!

Im tryin to post from Filemaker to Ebay my listing products I Read I need a pluging as scriptmaster to post to http, to connect with Ebay file exchange Anyone knows how I must do it? Someone has a idea? Ive fm5.5 but I can get fm7 or 10 thanks

We've just purchased the 4.132 upgrade of Scriptmaster Pro from our previous version 4.1 Our first job was to rebuild the plug-in we built in v4.1; this contained one function SelectFile, together with three other functions SelectFileLastError, SelectFileRegister() and SelectFileVersion. In the application code, we use SelectFileregister() to register the plug-in and SelecFile itself to allow users to pick files from the filing system. However, when we swapped the old plug-in for the new one, the registration failed because, as far as we can see, the SelectFileRegister() function has changed to nullRegister() so our application scripts no longer see the plug-in.…

hi some times using new JFileChooser(), the prompt is not in front of filemaker application but over an other application how can I force it ? import javax.swing.JFileChooser; JFileChooser chooser = new JFileChooser(); chooser.setFileSelectionMode( JFileChooser.DIRECTORIES_ONLY ); //You can switch this to JFileChooser.FILES_ONLY or JFileChooser.FILES_AND_DIRECTORIES if you want the user to be able to pick files if( startingPath != null ) chooser.setCurrentDirectory( new File(startingPath) ); if( prompt != null ) chooser.setDialogTitle( prompt ); if( chooser.showOpenDialog( null ) == JFileChooser.APPROVE_OPTION ) { return chooser.getSelectedFile().get…

Hi, I use scriptmaster to zip a directory, with this source code : http://fmforums.com/...ip-a-directory/ It works fine and I can unzip my archive with 7-zip for instance. Trouble comes when I use Windows browser : When I right click on file then Unzip (Extraire tout in french), I am getting a wrong file format error. When I right click on file then Open, Windows browser shows me an empty content. Anybody's getting same error ? Thanks

i am using this PostXMLData but is there any way to set a time out? sometimes some queries are just so long that there is no way to gracefully stop the process w/o force quitting. RegisterGroovy( "PostXMLData( url ; xml ; soapaction )" ; "// Send data¶ URL url = new URL(url);¶ HttpURLConnection conn = url.openConnection();¶ if( soapaction != null ) conn.setRequestProperty( \"SOAPAction\", soapaction );¶ conn.setRequestProperty( \"content-type\", \"text/xml\" );¶ conn.setDoOutput(true);¶ OutputStreamWriter wr = new OutputStreamWriter(conn.getOutputStream());¶ wr.write(xml);¶ wr.close();¶ ¶ // Get the response¶ String response;¶ InputStream response…

Hi I set a variable with RegisterGroovy( "List_All_Files_In_Directory ( path )" ; "def result = new StringBuffer(); def dir = new File(path); count = 0; listFiles( dir, result ); result.toString().trim(); void listFiles( File directory, StringBuffer buff ) { for (eachFile in directory.listFiles() ) { if (eachFile.getName().startsWith(\".\")) continue; buff.append(\"\n\" + eachFile.getPath()); if( eachFile.isDirectory() ) { buff.append( File.separator ); } count++; } } ") and get error

I can't seem to get a plugin that we have created using ScriptMaster 4.134 to work on server 12v2 (Windows) in the custom web publishing environment. I have put the plugin in the FileMaker Server/Web Publishing/publishing-engine/wpc/Plugins folder (i've also tried the publishing-engine/cwpc/Plugins folder as well) and restarted web publishing (actually, I've also tried restarting the whole FMS ). I perform a call via a valid URL using a xml grammar and perform a script. The script runs (I log internally what's happening during the script), but the plugin doesn't seem to be recognized. I log the results of the version function and i get a ? as the result of that functi…

Hi, i want to schedule a script that read and write some files into server's documents folder. Can i do that with scriptmaster? I registered my function writetofile() in startup script and it's ok locally. In server does not works. I need to buy a Enterprise Licence? Where can i buy it? Thkns

Hi there, in a scheduled server-side script, I'm trying to launch another script by specifying its name. I tried to achieve this by using the CallScriptImmediately function. The problem is the function returns "ERROR", and in the log I can see : GRAVE: PluginFunction PluginFunction{name='CallScriptImmediately'} got an error with converted args [my_file_name, Mail Test 02, null] com.prosc.fmkit.FmScriptException: Error 100: There is no file open named 'my_file_name' my_file_name is correct, it has been set using Get (FileName). Am I doing something wrong ? Win7 / FMS11 / SM 4.122 (I know it's not the last version, but I can't stop the D…

I don't want to spend $100+ for a plugin. I want to just get the emails subject field/line and either : Import into a field for parsing or Possibly append all to 1 field/file with new line separation. If a file I'm thinking to maybe stream the output as a file for import afterward ... Something like : Online Auction of property .... Important information about ... Welcome to the ... Whatever ... Whatever ... Here's some code I found import java.util.Properties; // added import javax.mail.*; import javax.mail.internet.*; // added import javax.mail.Folder; import javax.mail.Message; import javax.mail.Session; import javax.mail.St…

When will we get a 64-bit version of ScriptMaster? More specifically: I used ScriptMater with a Win FMS11 solution. It broke when the server was upgraded to FMS12/64-bit. But with the latest server version 12.0.2.232, FileMaker has included the ability to make and run 64-bit plug-ins. This specific customer is trowing stones at me for not solving the problem . I would love to have a new version so my back won't get to sore.... :idot:

Hi, Our company is looking for an FileMaker expert with experience with ScriptMaster by 360 Works. Please more in my request on Elance: https://www.elance.com/job/33711953/proposals Looking forward to hear from you! Kind regards, Jon

Ok I have a script that is working fine normally on a hosted solution - to automate the process i wanted to have fm server do this task in the wee hours of the morning but its not working... I am using ScriptMaster to perform the tasks. 1. Write out the XSL file to the Temp or Docs 2. Perform an PostXML request from 3rd party URL 3. Write XML data to Temp or Docs folder (server) 4. Import data to FMP using XSL from previous path. I have to process this in a loop and each of the files normally are several MB in size however it seems that the PostXML is timing out or the script on server is running too fast and not allowing the XML data to dow…

Thanks for the new functions... Usually just download the plugin only so grabbed the whole thing tonight to copy the new functions -- is it worth noting on the examples for SetFileMakerClipboard and GetFileMakerClipboard that they only work in that fashion in v11??? copying a similar object in 12 gives >> java.lang.IllegalStateException: The clipboard does not contain data in any recognizable format the validate XML example gives >> java.net.UnknownHostException: fmwpe.360works.com

I'd like to know how to properly construct SQL statements using ScriptMaster 4.x, because I cannot seem to get even the simplest SQL statements written in 12 to work using the plugin. For example, I'd like to implement the MagicValueList featured on filemakerhacks.com, of which a sample file was provided. The first example in that file is where a user chooses a state from a drop-down list made possible by a custom function, and a script trigger for an empty script that uses the custom function wrapped around a FM12 SQL statement: MVL_Dropdown ( ExecuteSQL ( "SELECT state FROM zipcode" ; "" ; "" ) ) The next drop-down of cities is made possible with this sta…

Hi all, I'm using Scriptmaster's 'Get File as Container' function on a server-side script to pull in user supplied files, images, PDFs, MHTML files and excel files, from a server folder, and insert them into container fields. I'm doing this since the 'Insert fill-in-the-blank' script steps aren't supported by FM Server 12. My issue is that I need the functionality of 'Insert PDF' so my PDFs can be easily viewed and printed. Without it, they just show up as generic files. So, I'm wondering if anyone has been successful in expanding the functionality of the 'Get File as Container' function so we can dictate the type of file we are inserting? Something like: Get F…

Are plugins we create 64 bit? 32bit? both?

I want to change the form of ScrptMaster "PopUp Menu" to call a FileMaker script. I state that I am a novice in Java programming. I modified the sample script but nothing happens. I really need help. Thank you.

Hello, I am trying to post a file to a server. The API we have been given describes using cURL. But Windows doesn't have cURL installed by default. I would rather include the post method in the plug-in without requiring an external utility be installed. Is there such a method? Sorry if I am missing the obvious. Thanks, Jeff

Daft question - where can I find the log file for a server plugin on FMS12 on Windows 2008 R2? Have searched but can't find - indexing turned off so searching doesn't help! Thanks

I want to get the date created from a file. I see a date modified but not created. How can I do this? return new Date(new File(filePath).lastModified()); Here is the statement Oreste

I unloaded ScriptMaster database and the script that was working in the other FileMaker Pro database stopped working (Missing function error then appears in script). If I restart the ScriptMaster database, then the script in the other FileMaker Pro database that uses it works again. So, being somewhat confused by this....do I need to purchase the $95 subscription and create and install a plug-in in FMP so the function works without the ScriptMaster database being loaded or am I missing something? I made sure I clicked the "Register" button at the bottom of the ScriptMaster database after first checking the function I wanted. However, that function is "Missing" i…

I'm trying to send a data value from a FMP form (on iPad, ideally) to a JAX-WS Web Service. Looking at the functions available, I initially thought that PostXMLData was a good choice, but now it looks like it might not work. Specifically, I am having issues trying to figure out how to translate my... "http://<path to webservice url>?wsdl" to something PostXMLData would be happy with. Also, I'm not sure about entering the XML parameter since my actual Java W/S program doesn't have anything like that that I see. Would the XML Parameter in PostXMLData just include my web service service method? --- Perhaps the PostDataToURL function would …

I have 2 server side scripts that occasionally overlap. When they do they crash the script engine. Errors are below - but there are lots of these. Aug 28, 2012 11:32:46 AM com.prosc.fmkit.Plugin setLastError SEVERE: PluginFunction com.prosc.beanshell.CompiledFunction@f39b3a got an error with converted args [uPDATE BookDetails SET LowestUsedPrice=null, LowestUsedPriceCurrency='£', AmazonTotalUsed=4 ,AmazonSalesRank= WHERE zkAmazonASIN='0216889219', |] com.prosc.fmkit.FmCalculationException: 8310 at com.prosc.fmkit.PluginContext.executeSql(PluginContext.java:180) at com.prosc.beanshell.FMPro.executeSql(FMPro.java:148) …

A: General question If I make my own plugin with Scriptmaster Advanced should I be able to install it on a server? B: Specific question If the answer to a: is yes - any idea why it is not showing up in my server admin? FMS 10.2 on MacServer 10.6.8 <<edit>>> FMS12.2....

I want to get a list of the serial numbers for connected drives on the computer. Every harddrive, USB stick etc. has a serial number. Why ? If I could get a list of currently connected drives, I could also determinate, whether a specific USB memory stick was inserted into the computer. This way, you could create an extra layer of security, like the dongle we knew from e.g. Quark Express back in the '90 So, does anyone know of a function/script that can be included in a SM generated plugin, which can get this from the OS ?

I have a set of scripts and a jar file (containing a variety of 3rd party jars) which are fully working when using them in the ScriptMaster.fp7 environment and when I use them in a sample database I created to test things out further. However after I generated the plugin using the Advanced version, I cannot get the scripts to work at all. When I go to Edit|Preferences|Plug-ins, I can see the plug-in and when I hit configure I see the license key, etc and that information is all correct. I can also see the functions properly when I look at the external functions. I'm also calling the "Register" function for my plug-in which I have setup as a script that gets trigg…

At a customer we had a problem when upgrading from FM10 to FM11 that the export in XML using XSLT became really slow. 3 seconds in FM10 -> 2 minutes in FM11. We found that the issue is not the export, but the post XSLT processing. This is a bug recognized by FileMaker. As a workaround we now export the plain xml, and perform the transformation with ScriptMaster. Maybe this is useful for someone else: /* Adapted by Andries Heylen for ScriptMaster usage BH&A v1.0. 09/2010 info: [email protected] Based on following example: http://www.rgagnon.com/javadetails/java-0407.html This script uses two JARS: - serializer.jar and - Xalan.ja…

I want the folder to be created to be names as today's date in a Month-Day-Year format. So 8-9-2012. I added calendar code to it: //Really simple version: //return new File(path).mkdirs(); //Version with decent error reporting: File dir = new File(pathToCreate); Calendar cal = new GregorianCalendar(); // Get the components of the date int year = cal.get(Calendar.YEAR); int month = cal.get(Calendar.MONTH); int day = cal.get(Calendar.DAY_OF_MONTH); if( dir.exists() ) return false; if( dir.mkdirs() ) { //Success! return true; } else { //Figure out why it failed File realParent = dir; while( realParent != null && ! realP…

Hi everybody, I use FileMaker 11 with scriptmaster. I am looking for right syntax to send a insert event POST request I write my request as follows, with OAuth2 protocol, including access_token : POST https : // www.googleapis.com/calendar/v3/calendars/myCalendar/events?access_token=myAcessToken body='{ "summary": "Test", "start": {"timeZone": "Europe/Paris","dateTime": "2012-08-09T09:00:00"}, "end": {"timeZone": "Europe/Paris","dateTime": "2012-08-09T10:00:00"} }' I have an error 400, which comes from : - my key (body), which is supposed to be a 'events resource' but I cannot find its explicit value here (it is empty) : https://developers.g...e/e…

Hello, I am trying to build a method to POST issues into MantisBT. Mantis provides a method to post using XML. However, this is my first time working with posting via XML. i am under a time crunch, so I need an answer ASAP. My Mantis installation has the XML methods described here: http://mantis.twosou...ntisconnect.php Using this, I figured the method I need to use is: mc_issue_add WIth that said, here is the calc that I constructed: Let ( [ url = "http://mantis.twosouthpaws.com/api/soap/mantisconnect.php" ; act = "mc_issue_add" ; xml = List ( "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" ; "<Envelope xmlns=\"http://…

Hello, I am using ScriptMaster for a runtime solution and registering the functions as the file starts up. I was wondering if there is any time limit with the plugin? Does it stop working after a certain amount of time or not. I am trying to track down an error where when a file is open for an extended period of time, the runtime freezes. Thanks, Stephen

Is there a smart way to convert the stream output from fmpro.getContainerStream() to a regular java InputStream ??

Really enjoy ScriptMaster! Just working through an issue now with the plugin not loading under certain circumstances (See previous posting). I am not sure if this is possible or not, but I am using the GetURLasContainer in a FMP11 solution to download a file and insert it into a container. The only problem is being able to give feedback to the user that the file is downloading. I am currently just giving a "Wait and be patient" message now. However, it would be great to say "500kb downloaded" or "1.2 MB" of "2.0 MB), etc. Is this possible? Thanks! Stephen

Is it possible to use Scriptmaster with iText to add highlight or comment annotations into a PDF from Filemaker?

I'm runing FMS ver12 on Windows server 2008 After a Windows update 1/8 ScriptMaster will not load. Any solutions?

Testing an fmp12 file on M Lion it appears that the OS does not draw the swing components properly, and clips the left hand button in the Dynamic Message function Using 1.6.0_33-bo3-424 version of Java. Screenshot attached BUT changing the buttons to something longer does John

I've started an open source project that uses ScriptMaster to implement JSON dictionaries in FileMaker. The git repository is at https://github.com/c...aker-dictionary and an article describing my thinking behind the choices I made (and a request for feedback on the solution) is at http://chivalrysoftw...ker-dictionary. I've also attached the file to this post, so feel free to simply download it here. For the time being its only in FileMaker 12 format, but if there's any interest, I'll publish a FileMaker 11 version of it as well. This is just the beginning of this project, I hope, and I'm looking forward to seeing if others find this useful and what features they wo…

Hi! Simple question, is there a max amount of parameters that can be declared when using RegisterGroovy to create a function? Is the SMSetVariable a better option the using named parameters when dealing with about 30 values that needs to be passed to the groovy syntax. If so, why? If it is only cosmetic and/or developer semantics reasons I will use named parameters in this case. It will be so much easier for the developer who will be using the functions I´m writing now. However, if there are limitations or memory issues I would be very grateful if someone would tell me about them! Thanks in advance

Watched Matt Petrowsky's video on using ScriptMaster and iText to combine PDF files instead of using FileMaker's very slow Append to PDF script step. I've tried to move the code from the example Matt provided into my code. ScriptMaster is installed and I've got the code pretty much intact from what Matt did. For some reason it won't work. Some of the code comes across commented out (sm.exist). I'm not able to un-comment the code without getting an error. What am I missing?

I am finding that when the XML contains an ampersand in the data ( e.g. <Label>David & Charles</Label> ) then the XPath Parse function returns ERROR. Is there any way to tweak the XPATH Parse code to get round this? I am already defying the inputstream to UTF=8 Thanks

Hey Folks, I was talking with John Renfrew at Devcon 2012 and he was showing me one of his projects. I noticed he was using a copy of the original ScriptMaster database that comes with the plugins. I had updated this file quite a bit - a long time ago - and I use it regularly for multiple projects. I've attached it here for those of you managing multiple scripts which may span multiple projects. Matt GroovyScripts.zip

I try to use the powershell from windows in "Run shell script", because I want to do more on the system than cmd.exe is able to handle. I tried a modified version of "Rund shell script" where I replaced the cmd.exe by powershell.exe, or used the original script where I send a common like "powershell mode" but I don't get any results back. Filemaker always hangs. when I send the commands by Run from Start button and then it works but not in Filemaker. Any ideas why this does not work? Markus

Following the instructions in this thread I adjusted the pop-up menu function to work correctly on Windows. However, whenever I select an option I get a momentary flash of the Desktop. This doesn't occur on Mac. Any way around this? Thanks

Hi guys, I run some automatic imports directly via FileMaker Server's documents folder, works fine. I'm trying to remove the files imported afterwards. But a simple RunShellScript (rm $filepath) doesn't do the job. So I'm wondering if I run a shell script via FM Server, which user will actually execute the command? It's not the logged in user in the system nor the fmsadmin, otherwise the file should be removed since both have access to the FMS Documents folder. Best, Alexander System MAC OS 10.6.6 Server FMSA 11

Hello, Is there a way to post more than one name pair using PostDataToURL? I need to post 6 values for one page. Then 11 for another. I don't think XML is an option. But I'll look into it. Thanks, Jeff

Hi guys - and thank you SOO much for making SM ! Just wandered: i´ve got some code run by a schedule, naturally including the "open" and "close" and the initialization code needed..... Or IS it needed EVERY time the schedule is run, or can you init ONE time and then just run the code somehow...?? In this setup I would like to use the Email-part of SM and send PDF´s to my customers, which performs fantastic - but im still in doubt WHATs necessary to include to be able to run... Thank you in advance, Regards, Lars

I am trying to write a script that will load a container with a file. The script will be ran from a custom web publishing after an "add new record". When I try to use the get file as container all I get is a ? in the container. I am using a set field to set the container. In the calculation for the set field I have: GetFileAsContainer( $filelocation ) (where $filelocation is "filemac:/FM Server/Library/WebServer/Documents/John/uploads/" & Medical Treament Log::filename If I have omitted any important information please let me know. Or if I am just barking up the wrong tree on how to use the GetFileAsContainer please let me know as…

I have a scanned PDF that has multiple areas of text handwritten text. I want to see if there's a way in itext to extrapolate coordinates on the page to be inserted into separate Container or viewers. Such as did this person sign the document? show the last 2 inches of the page starting 3 inches from the left.

I have a script that sends bulk emails using ScriptMaster. It runs fine as a scheduled script from the server, but I can't get it working when run through custom web publishing (php). Screen shot of the script is attached. Basically I want to run it from a button instead of as a scheduled script every 5 minutes clogging up resources & log files, so I created a php script that runs the script, and attached a button to the php page using "Go to URL". I know the script is running because it is writing the error (see script). The following debug calculation: "ERROR " & SMLastError & " Registered Modules: " & SMGetRegisteredModules & "…

I have a non-FMP solution that needs to call FMP and isolate a single record in a table. I like the fmp7script method available to FMGo, but it doesn't appear to be available on the desktop. One the desktop, is there a way to have a browser (or another app) post to the following URL: fmp7script://192.168.1.1/Records.fp7?script=JeffTest&param=1110305 With FMGo, this will run the script "JeffTest" with the parameter "1110305". Question, can ScriptMaster listen for this type of request and act? If not, anyone have any ideas? Thanks, Jeff

Hey there ScriptMaster community. I am posting this here for the benefit of anyone who may come across this issue. I may be the first, but it may also be a known issue. With FMP12 now installing plugins using the Install Plug-In File [] script step it's much easier to push ScriptMaster built plugins from solutions. However, there is an issue with how FileMaker deals with version numbers of plugins - at least in my early testing - I think. For my Theme Studio product I use ScriptMaster to build a plugin named ThemeStudio.fmplugin/fmx Using Get ( InstalledFMPlugins ) FileMaker returns a list of all plugins, their versions and status. For example. …

To whoever will read this, Hello, I installed scriptmaster on fmpa12, and everything was running fine. However I tried reopening a file into which I had installed the functions generated by the Scriptmaster file, and they have all disappeared. When trying to add them back in ( ie. pressing the add link after selecting the modules I want ), I get an Error Loading Jar File message: "Could not load jar file because of an unexpected error: com.prosc.fmkit.FeedbackException: SMLoadJar was called with an empty data parameter", and then several (one per module) "Could not load jar file because of an unexpected error: java.lang.illegalArgumentException: External li…