ScriptMaster by 360 Works

Had the need to find users desktop path so it could point back to a local version of a dashboard/ launch file if they were not using the hosted version, so that I don't have to try and fill the Manage External Files dialogue with the paths to each users individual desktops. That way I can then use my SM script to open a file in its default app... This seems to work on all the machines I can find, but if anyone has improvements or finds it breaks then please chip in... // DeskFolder() // 2011/01/20 JR // v1 // returns path to desktop import javax.swing.filechooser.* sep = System.getProperty("file.separator") os = System.getProperty("os.name").t…

Hi all, I am using JDBC driver sqljdbc4.jar in Filemaker 9 and connecting to SQL Server database using 360 Works Plug-in. I want to know if the following are correct: jdbcLoadDriver( "[color:yellow][color:brown]com.microsoft.sqlserver.jdbc.SQLServerDriver" ; "file:///Users/admin/Desktop/JDBC/sqljdbc4.jar" ) jdbcOpenDatabase( "jdbc:sqlserver://16x.xx.xx.xxx:1433;databasename=training;user=zzz_yyyy;password=xxxxxxx" ) Is the class path mentioned above is correct or the one below: [color:yellow][color:brown]com.microsoft.jdbc.sqlserver.SQLServerDriver

I'm having a weird problem that I hope someone has figured out. I had an old version of ScriptMaster (3.33). After deleting it from the Extensions directory and copying in the new version it still shows version 3.33. So I tried deleting the plugin file from the directory and restarting filemaker, and when I go into Preferences to view the plugins it still shows the plugin is there and it still says version 3.33. Any ideas on how to make Filemaker update the plugin list?

I have two function (GUI) in ScriptMaster Advanced, each show their own dialog (Save and Open), but if they are run in the same script (or subscript) they crash FileMaker, it does not matter whether they are registered with ScriptMaster or are from custom plugin. Also, if the same function is called in the same script (or subscript) FileMaker crashes. Here is the code for the two functions: /* Purpose: Asks a user to select a file to open. Returns: File Path Name: HIDRAOpenFileDialog ( saveTitle ; defaultDirectory ) Parameters: ( openTitle ) text ( defaultDirectory ) filepath Dependencies: NONE 2011-09-01 JPS, Created. …

Hi, Do you know if it is possible to get the type of a file or picture embedded in a FileMaker Container field using a method from the fmpro class or anyway else? I tried with fmpro.getcontainerstream but could not go farther. Thanks if someone knows about something! Jean-Philippe

I have made a ScriptMaster Advanced (4.124) plugin and when I try and use my complied function from the plugin I get this error: java.lang.RuntimeException: Unable to instantiate compiled ScriptMaster function: pdfItin2( output; orientation ) the exact same function runs perfectly when registered in ScriptMaster, but fails to instantiate when run from my plugin. I've triple checked to make sure I've included all required jars in the plugin. How can I debug this? Mac OS X 10.6.8 Sam Fisher

Hi all, I'm using runshellscript to rename ID3 Tags using lame, in some mp3 files. every time i've got some non-standard characters (eg. à or a simple '), it result a wrong character. have you got a suggest to prevent this behavior (custom function or else)? thank you in advance, best Corrado

Hi guys, i'm trying your scriptmaster. I want to run a shell script on osx that i used to convert some audio files using lame. every time i try i receive an error and no file converted. the same command works perfectly in terminal. using eg. afconvert work perfectly (not in mp3 of course, 'cause not supported). any suggest? best Corrado

I'm trying to use the ..... Check Whether File Exists - new File( pathToFile ).exists() .... to import after a file is created. The problem is the other program is still writing to the file so I don't get all the records. Any ideas on how to keep it from importing until the other program is done? Practical example: Printing postage with Endecia... Script: Print Postage.... Loop set variable [$$file_exists ; value:CheckWhetherFileExists( "C:\folder\Data-output.xml" ) exit loop if [$$file_exists = 1] pause/resume 5 seconds End Loop I thought about continuing the loop until all records come back but that wont work if 1…

I have been able to send HTML emails OK, with image links I am now trying to add inline images, but it fails with "unable to resolve class DataSource" in previous posts, you suggest I may need a jar file, but which one? I have loaded mail.jar, and activation.jar it seems something is missing thanks! Code: MimeBodyPart imagePart = new MimeBodyPart(); DataSource fds = new FileDataSource( "C:\\images\\image.jpg" ); imagePart.setDataHandler(new DataHandler(fds));

Hi there Just been playing around with the Video Thumbnail module. A couple of questions: Is it compatible with both OS 10.5 (which comes with QT7) and 10.7 (which only comes with QTX)? It depends upon the timeUnit parameter, which I presume is the number of seconds multiplied by the file's timescale. But is there a way to get the timescale of a file somehow? As always, thanks for this excellent plugin.

I have previously had no problems with fmpro.evaluate working, but just recently it started to generate errors. I have upgraded to Lion (when it first came out) and updated to 10.7.1. I have also updated to FM Adv v11.4. It seemed to be working fine with those upgrades, but I'm not positive of when the issue started. Not sure if any of this matters, but I thought I'd point it out up front. I have tested a simple script in ScriptMaster: return fmpro.evaluate ( "Get ( UserCount )"); - which in the past would work with no problem. However, I am getting an error: "java.lang.IllegalStateException: FileMaker called plugin on thread: Thread[AWT-AppKit,5,main]; but pl…

I must be really dense today Doing a test runtime on windows XP from FM11Adv If I create a runtime which I want to use a couple of SM functions with, where is the correct place for the plugin on a machine which therefore does not have FM installed? In the runtime folder structure somewhere? Or in the place I would normally find it?

Hi, This is my frist attempt at creating a new module for ScriptMaster. I want to be able to access UPS' Webservices for the freight rates. I have already done this with FedEx in C#, so I kind of know where I'm going, but ScriptMaster gives me a hard time starting it all. I came across a well-written JAVA code that does the XML parsing (I hate that part): the project is here if anybody wants to try it. I created an account to UPS' API, and configured the java code to represent my account informations. This is where it gets messy, because I haven'T done a lot of JAVA in my career. I compiled all the .java files with javac. I then created a jar…

I have been trying to use some of the file system functions provided in the ScriptMaster.fp7 demo file with a webdav, in scripts fired server-side, but with no success. FileMaker Server 11 Mac OS 10.6.6 Plugin: 4.122 • The test scripts I have created successfully fire on a FMP client (11Adv), copying files both among external drives, mounted network resources, and a webdav resource. • However, when I try to run these scripts-server (this is where they must run from for this project) targeted at the webdav, they return errors or no result. • I do modify the file paths when running server-side to correctly reference the volumes and file locations. • The ser…

Hi, I have tried to do an script to save an URL as html with "WGET" command. If I use the shell command line to put: It´s working and a "FileName.html" file is saved in my root directory but when I try to obtain this result in Filemaker with RunShellScript, it is not possible. Could anyone help me?? The URL is saved as a global variable ($$datlink). I have created the different steps in my script but I only get an message: "ERROR" STEPS into my script: Set variable [$command; value:"wget " & "--convert-links " & "-O " & DB::FileName & " " & "\"" & $$datlink & "\""] Set field [DB::Container; RunShe…

Hi, Did someone experienced solutions to export records in Excel format or PDF from IWP using Scriptmaster functions? I could do this with other third-party plug-ins, but looking forward to do it with my favorite one.. Jean-Philippe

Hello. I have a client that needs to capture people holding movie slates for a few seconds. Can Scriptmaster's videoframe capture function be modified to capture rolling video, not just a single frame? Thanks for your help. David

Recently I have had a reasonably serious play with ScriptMaster and it works well in FMP. I'm just looking for some guidance so I don't bog down potentially attempting the impossible: Can I trigger a call script from IWP that runs on the FMP machine from IWP? Specifically can I use a script that saves a PDF to the host HD? I tried it with the onLayoutLoad and failed and was wondering if I could do it by a change to a field value or similar. Also, it is not clear to me what 'param' (if any) I would use. Thanks Lyndsay

Hi, I successfully generated a custom plug-in, using the advanced version of SM. This one contains only the function ExecuteSql. The function works correctly, no problem. When I try to call the registering function that was automatically created while generating the plug-in, named sql1register, with the parameters "null" and the name"myname", I get an ERROR result. This does not occur with an other custom plug-in (that doesn't include the ExecuteSql function). Perhaps am I doing something wrong or is it a known behaviour? Thanks if you can answer! Jean-Philippe

Hi, Running filemaker server advanced 10 with latest scriptmaster version. It is using a plugin I have generated from scriptmaster advanced. Windows version. I believe I am having an issue when 2 scheduled tasks are running on the server at the same time that both use functionality from the scriptmaster plugin. Basically the server CPU usage maxes out and the server stops responding. I need to kill the task and restart the filemaker server. First of all I thought it was the function I wrote, but it runs fine from a filemaker client machine. And besides should it really be able to crash the server.? So then I thought maybe it is using too much heap space whe…

I'm using SuperContainer to store files. I'm also using Matt Petrowsky's PDF concatenation technique using ScriptMaster and Java. I can get local files to concat, but I'm having trouble with remote files. I'm not sure what a working technique is. -Feed catpdf the remote filepath: I don't know how to construct the filepath correctly, don't know what permissions should be set for the folders, and don't know if this will actually work. -Use SCGetFileURL to feed the catpdf: This looks like an undocumented function and don't know what win path to feed it as a parameter and don't know if it will work. Any thoughts?

Trying to use the prowl notification system, building the prowl functions into a plugin. I need this to work with Android devices. I am hoping someone else here has been trying to use the Prowl functions and found a way around this problem. I have found both Growl and Notify My Android which work with Growl...but how do you get Prowl to work with Growl? I can't even get my Android to register at Prowl as a registered device. This is frustrating me to no end because I have an excellent use for the prowl push notification functions, but not if I can't get this to work on Android as well as iPhone crap. Any ideas, help, suggestions are greatly appreciated and welcome.

Using Windows XP, SP3, comp is plenty beefy enough. Purchased scriptmaster pro advanced I create my custom plugin, tells me everything went perfect, I save my register code. No matter what I do Filemaker does not see my plugin. I reboot, restart FMP, etc. nothing. I remove the 360 works plugin and FMP still sees it, in fact I can't get rid of it. Yet FMP still cannot see my custom plugin I just built. Help please, I need this working yesterday... PS - and I'm not a newbie with FMP development, I am an advanced developer and a software engineer. Still puzzled...

I'm trying to use the "Send Email" script in the ScriptMaster demo to send to a comma-separated list of To addresses. But I get an exception: javax.mail.internet.AddressException: illegal address in string "[email protected], [email protected]" How do I create an InternetAddress to multiple recipients in ScriptMaster? Thanks, Larry Goldman

I am using 360Works to implement an XML Request. I have to export FileMaker Data, to implement a Stylesheet that translates the XML into the format I need. For PostXMLData ( PostXMLData( url ; xml ; soapaction ) ), the second parameter is the XML. Do we have anyway to use a FileName here, rather than importing the XML backinto FileMaker? I rarely use XML, so maybe this is an XML issue rather than a 360Works issue. Something like "?XML file='c:\360Works\testdata.xml' " maybe?

Hello, I have been using ScriptMaster successfully for about 2 weeks, and was very impressed. I was able to add the Pdfbox-App-1.3.1.Jar library easily. Debugging and using the module I created with the PdfBox library and ScriptMaster IDE worked great. Then I bought a registered copy to create a plugin. When installed, the plugin with my custom module completely crashes FileMaker on startup. Any tips or ideas? Thanks, Jeff

So I run this command RunShellScript( "ping google.com" ; "true"; 30 ) It works just fine I wait 30 seconds and run it again... It returns "ERROR". The LastError returns this... java.lang.RuntimeException: Process was interrupted; error output is: This always happens about 30 seconds after I run the command the first time. I wrote a script that ran that command once every second and it always fails in 32 seconds. Anyone have any ideas? I'm running Windows 7 64-bit. Also if I run the same command but set the timeout to 10 the same thing happens 10 seconds later so it stops working for as many seconds as the timeout is set to. Im using t…

I'm only getting 'image.jpg' returned in SM in both the text and container. Any idea why??? I tried other scripts included with the file and I got the same thing........... Latest Plugin - v4.124

Can anyone answer...? Am using 360works Scriptmaster Adv in a FMP runtime solution. Is there a way to turn the logging function OFF...? Would like to avoid the 360Plugins_xxx.log file generated in the 360Plugin Logs folder from growing. Or are there other solutions to managing this..>? Was unable to find any references in forums and docs.

SSssoooooo ... my java function works fine in SM and if registered by SM works in my file when called. My problem is that after I have it registered and I click the 'Copy to clipboard' in SM I have nothing to paste. I tried a direct copy/paste from the actual field which works though..... It's a fairly long one that requires me to escape a lot of quotes and edit (insert "¶" ??) so that somewhere along the way I've missed something and my version wont work. Suggestions on how to get what SM is registering or else what all has to be edited basically? PS - I can't post the code because it's not mine......... but something like this one from SM: …

The SMRegisterFunction has been the best thing in the world. It cuts execution time a ton over v1, not to mention script complexity. However, I got to thinking about whether or not a function might not be registered with a optional argument. My groovy would need to check if a variable is defined, but it would allow for a function "library" to be updated, with the new arguments being optional. So long as sane defaults are set when nothing is declared, the "library" could be updated without any effect on old solutions. ie. no need to update everywhere. The second thought, was whether pseudo-arrays like in FileMaker's Substitute function - Substitute( text ; search…

using SMA i am currently registering two functions. xPathParse() and GetURLasText(), I have about a dozen FM CF and they all pretty much do the same thing. However I am wondering if I could consolidate all my functions in to one plugin and include the two registered functions. This is to talk directly to MailChimp API to return xml results The first call is on startup to call a function to register or store your API key provided. you will also need the data center value which is the last 3 characters of the API key. exmaple: 0cxxef03xxx16ca5e1d09c524xxxc6acbx50-us2 Right now I have a settings table with that data in a field. The second…

Hi, I like to call call the "actionPerformed" of the button a FileMaker script in the following code This does not work! What am I doing wrong? Thanks for your help CODE: import javax.swing.*; import java.awt.event.*; new FensterWegImplementsAll(); class FensterWegImplementsAll extends JFrame implements WindowListener, ActionListener { public FensterWegImplementsAll() { setLayout(null); setSize( 400, 400 ); addWindowListener( this ); setVisible( true ); JButton btn_1 = new JButton("TOC"); btn_1.setBounds(10,10,100,25); btn_1.addActionListener(this); add(btn_1); …

I have a simple need to change the extensions of different files to be imported every day in a FM11Adv run time solution from ".xxx" to ".csv". Will the Scriptmaster plug enable me to do that? Thanks.

FMP11 ScriptMaster 4_124 MAC OSX 10.6 Okay, so, I created something silly, just a little script that took in an SQL string and made things happen with it. Then... I ran it 200x in rapid succession. Memory use spiked and held from 123.2MB Real Allocation to 164.03MB real after running the 200x script (I'm aware that I could optimize the groovy but that's beside the point.) After that, each subsequent run increases memory alloc by something relatively linear. While the memory issue isn't really a problem, once that had been completed (even once), the whole of the FIleMaker UI just CRAWLED. Menus, mode switches, layout changes, you name it. Is this a bug? Are …

Is there any chance the executeSql and executeSqlArray methods could be made to operate on another FileMaker file? I know ScriptMaster does not offer this now, but I'm wondering if it's even possible to provide that feature, given the plug-in framework provided by FileMaker.

Okay, so, we bought the Advanced version of the plugin for a number of reasons but not least was the SQL feature. Problem is, the thing isn't really working all that well. I tried messing with the demo file and then, when that didn't work, I made a one table, one field test file with a table called 'test' and a field called 'field'. When I tried to execute the following statement, I got Error 8310: INSERT INTO test field VALUES ("test") So, I pared it down to INSERT INTO test That still didn't work. What am I missing here?

I have some maps and symbols as .png files (stored in container fields) that I need to combine in a FileMaker solution. I've tried looking in to doing it using ImageMagick and the command line, but it suddenly struck me that this may be something that could be done using ScriptMaster. I've seen some code that lets you combing images and text, but not images and images ... Essentially, I need to overlay symbols at certain coordinates. I can do the coordinate calcs no problem, so the issue is more a case of, given two transparent pngs how do I combine them without losing transparency? (Both the map and the symbol may need to be transparent due to the need to overlay t…

Hi, I was wondering if there is a way to update the scriptmaster version. I have 4.02 and wanted to update it to the latest 4.124 version. I downloaded it, but how do I get all my custom scripts over from the last version without re-entering all of them?. I couldn't find anything in the documentation, or am I missing something. Thanks! Ryan

Anyone using the StockQuotePrice function? Works great, and hasn't had a hiccup for many months (year?) but recently started returning the same price. June 2, 3, and now 6 show the same results -- basing this on a mostly automated system that pulls values in each day. User has been using my script (which uses this function) successfully for quite some time, so I do not think it is user error. Anybody know the source of the values? Maybe the source is the problem and not the function itself. Thanks. Scott

Im using the following code to fetch the HTML of a url as Text. is it possible to get the text returned as a UTF-8 format so that special characters are viewed correctly? url_to_fetch= new URL(url); HttpURLConnection httpcon = (HttpURLConnection) url_to_fetch.openConnection(); httpcon.addRequestProperty("User-Agent", "Mozilla/3.6"); BufferedReader in2 = new BufferedReader(new InputStreamReader(httpcon.getInputStream())); String inputLine; String Results=""; while ((inputLine = in2.readLine()) != null) Results=Results+inputLine+"\n"; in2.close(); return Results;

I can't figure how the "do shell script" works on OS X 10.5.6. It seems it handles spaces/escaping characters differently than e.g. Terminal. In terminal I can run: open /Users/davidwikstrom/Desktop/fold der/test.txt If I use ScriptMaster, this fails, as does the same thing if I don't even try escaping but just leave the space in there. Single or double quotation marks around the path don't help either. I can of course run: open /Users/davidwikstrom/Desktop/folder/test.txt succesfully in both Terminal and ScriptMaster. This is the last piece in replacing Troi File by ScriptMaster in an existing cross-platform solution. The aim is really simple, j…

When using ScriptMaster Advanced to generate a plug-in, the generated plug-in will not load if a url was entered as help text. If I remove the help text, or enter my name, the generated plug-in works properly. I believe I got the same error when I tried putting an email, and possibly also when I entered more than one line of information in the Help Text field. To me, it seems to be a bug involving special characters (/, :, @, and possibly ¶). Can this be fixed?

I don't know if this is the correct place, or that I have to go to a Java forum to find a solution. This is the goal: connect FileMaker to AddressBook on Mac OSX by using the sqlite database behind the AddressBook. Via the terminal this is a piece of cake, but I cannot manage to get this working using ScriptMaster. I have downloaded the library "Sqlitejdbc-V056.jar", downloaded from “http://www.zentus.com/sqlitejdbc/" and loaded it into ScriptMaster. Apparently you have to load the driver class in your code in the following way: Class.forName("org.sqlite.JDBC"); However this does not seem to work in ScriptMaster. I get the following err…

Does anyone have a suggestion how I could speed up the process of finding AES Encrypted data in fields with a database with >10,000 records? Seems that each record being decrypted makes the find to take much longer than I expected. (I figured it would add some overhead…) So far the only idea I have come up with was to create another field thats encrypted using the Base64Encode function and search for records that are >= the Base64Encoded search criteria. Sometimes it returns results that are not even close to what you searched for. — In depth section— First, middle and last names are stored encrypted in the database. In order to search thes…

Hi, Same scenario as my other post. I'm using the fmpro object in a different thread than started it, from a java window that keeps running alongside filemaker. I find that when using the object it hangs for a while before anything happens. CPU usage doesn't increase, so it is just waiting. Is this because it isn't meant to be called from another thread?. Is there any way i can get it to work properly? Thanks, Ryan

Hello, I wanted to send an email with a picture in the body (not simply as an attachment). I thought it would be possible through the Scriptmaster module SendEmail - Html-Formatted. If I calculate the body to obtain the following result it works fine. Then I tried to replace the distant picture by a local one stored in a multimedia field of FileMaker ; I replaced "http://rene.sette.free.fr/affiche_verdiere.jpg" by various syntax as file:///Volumes/Data/Desktop/DSC00262.JPG but I could'nt transmit the picture ; only the symbol of a tired file... Is it impossible ? Thanks for your answers ! Noël

IMac OSX 10.4.11 + FileMaker Pro Advanced 10 + free 360Works ScriptMaster fmplugin > V4 ( V4.0 to 4.122) can not get the correct result with BarcodeJ4.jar. When I install version < V4 ScriptMaster (3.34) - BarcodeJ4.jar (V 2.0. or V2.1) works correctly. Is it possible to fix it in the next update SriptMaster? Ino

I am hoping to get some assistance in modifying Matt Petrowsky's example file that combines pdf's and add one more step to password protect the combined pdf. I would include the file but it is for subscribers only. http://www.filemakermagazine.com/videos/combining-pdfs-the-blazing-fast-method.html There is example code to do this at: http://itextpdf.com/examples/iia.php?id=219 I have zero knowledge on how to modify this to work with Matt's sample file. Any help would be appreciated. If someone wants to provide an estimate to do this please contact me at: [email protected] Thanks Jeff

Just a quick question for clarification after reading the 360Works website, this relates to using the plug-in's functions directly, rather than using the plug-in to create a new plug-in: 1. Can the free version of Scriptmaster 4 be used in RunTime solutions which are distributed to users legally, or do you need the paid-for Advanced version to allow this licensing? (The website says, "Yes, all of our plugins work in FileMaker runtimes solutions, just copy the plugin to the runtime's Extensions folder." but it doesn't mention licensing). 2. Will all versions of the plug-in (free and advanced), automatically load in a runtime solution (if placed correctly in the e…

I may not be understanding things properly so go easy on a newbie We have a database hosted on FMP Server Advanced. We also have remote clients (FMPro) and mobile clients (FMGo) connecting to it. We have developed a plugin that we need to run against the database hosted on the server. This plugin provides some discrete functionality relating to JMS queues. Works great when running in FMPro on the desktop. Question: I assume that in the Server scenario the plugin runs on the client even though the DB is loaded remotely (since the plugin is not using scheduled actions). Problem: In this case are my Go clients Out Of Luck? Meaning, Go Clients do not have ac…

Hi. We have developed a solution with creation of subfolders for each project in the database. (with SM "Create Folder") The problem is that I can do it from my Mac and PC with 100% success rate, but not from another Mac at the office (or more specific- It sometimes works, in 50% of the cases). Same plugin version (4.124), same FileMaker version (FMPA 11.0v3), same OS X (10.6.7), no left-over Keyring authentication. From the "problem Mac" I can create folders and delete folders and files with Finder. I can also access already created folders. But the creation is erratic and unreliable. The only thing that possibly could differ is that the "proble…

Hi, The subject is telling it: im a newbie. I've been working with fm since a couple of weeks and i want to use the "send email with authentication" script in fm (i just want to email some lists and i cant find a way to do that in rows not using html). The thing is that i cant understand how to install this script. I dont even know what to do with the text on the first page that starts like this: [color:green]import javax.mail.*; import javax.mail.internet.*; Properties props = new Properties(); props.setProperty("mail.smtp.host", smtpHost); props.setProperty("mail.smtp.auth", "true"); props.setProperty("mail.smtps.auth", "true"); and im not …

Hi I'm curious as to whether it would be worth getting SMA in order to port some custom functions over as plugins. First of all, is there a performance improvement to compiling a scriptmaster plugin of a scriptmaster function (for example, the XPath function)? Secondly, if I were to take a typical filemaker custom function (such as Quicksort()), rewrite it in groovy and then compile that as a plugin, would that boost performance? Thanks

If PopupMenu contains a lot of values to choose and not all of them are visible on screen, it's not possible to scroll it to choose invisible values - PopupMenu disapeers.

I just looked at the Sciptmaster plugin and it looks pretty neat. I see the function Convert URLs to Hyperlinks and thought it might be useful to do expand a little on the functionality of what I've put together. To brush up on Filemaker for some work I need to do I dusted off an old FM file, added some stuff to it, jazzed it up and offered it out to the Crossfit community. The files are here: https://public.me.com/mvasilakis (guest or 'admin' + blank pass for FP7 file) My question (finally): Is it possible to take the text in the WOD field in the WOD tab and create hyperlinks to found text using Convert URLs to Hyperlinks? For instance in my first …

Hi I have the same error: "java.lang.illegalStateException: zip file closed" in certain environments, using ScriptMaster Under Mac OS 10.4.11, Filemaker 10.0v3 runs fine with ScriptMaster BUT under OS 10.5.8, neither Filemaker 10.0v3 NOR 11.0.3 runs fine with ScriptMaster without the error: "java.lang.illegalStateException: zip file closed" - and yet Filemaker 8.5 runs it without the error Could you advise? Thank you! :R) Richard Philpott

I can't figure out how to get the "Call Script Immediately" function to work. I am working with FM 9 and am trying to highlight the active record in the list view. I set conditional formatting such that the fields change background color when $$ID = Programs::ProgramID. I then wrote a script that sets $$ID = Table::RecordID and refreshes the window: Freeze Window Commit Records/Request [No dialog] Set Variable [$$ID; Value:Programs::ProgramID] Refresh Window [] I want to trigger this script every time a record loads, but I don't know where to put the function or what I should use in the parameters. Help?

Hi all I am switching from plain Java to Groovy, and I want to start using output variables ( SMGetVariable ( name ) ). However there is something I don't really grab. To declare a variable in Groovy I use the "def" statement, however when I use this "def" statement, this variable cannot be read by the SMGetVariable ( name ) function. For example: def number1 = input1; def number2 = input2; def output1 = number1 + number2 Will return "ERROR" when I evaluate the function SMGetVariable ( "output1" ). However the following lines of code, I am able to get the value of output1. def number1 = input1; def number2 = input2; output1 = …

I am playing around with the File class, and I am trying to create files immediately in a container, without being created on the hard disk (just as an experiment, don't have a real goal yet:) ) I wrote the following lines of code: def myFile = new File ( "test.txt" ); myFile << "First Line Of text"; return myFile; When I run this 2 times the result is a text file in my container containing two times the line "First Line Of Text". When a run it three times it contains it three etc etc. (I guess you all get the picture) I know that the command "<<" will append the text if the file already exists, so this means to me that somewhere in…

Hello, I need to copy a directory and its content to an external drive. I've seen and experimented the CopyFile function of Scriptmaster. Two questions : Is there a way to adapt it to copy a directory by passing in src /Volumes/Data/Desktop/Xtine/for example ? If not is it possible to say copy all files (equivalent of use jokers *.*) ? Thanks for your answers ? Noël

All, We ran a sql call that selected two fields from a table "SELECT CATEGORY, AMOUNT FROM TABLE" where the table had 135K+ records in it. FileMaker unexpectedly quit during the evaluation of the function call. It was a function that was in a plugin that was created via ScriptMaster Advanced. The function works for all other sql queries (it basically just returns the value from fmpro.evaluateSql ( sql ; field_seperator ; row_seperator) ). The ScriptMaster logs show the function being called, but there is no information after that in the log. We ran the same sql query through a different plugin and the query took awhile, but did successfully return. We put t…

Am running Pro Advanced 11.03 on a iMac with 10.5.8 as a test machine with Scriptmaster 4.123 Yesterday I installed the latest security update and today I cannot get any Groovy functions to work on the machine Groovy console works fine, but not SM All I get is java.lang.IllegalStateException: zip file closed Closed FM, no change, rebooted, no change, made a single simple function to get a system variable, no change Attached extended screenshot of moreInfo on the Groovy error Any clues?? SPECIFIC CORRECTION Function RUN in the demo file but will not register. After this error occurs then they will no longer run

Hi there, I am running a self-made content management system in my office, and having a problem with ScriptMaster plugin on Windows. My solution utilizes ScriptMaster's "GetUrlAsText" function to fetch XML from our intranet system. It works on my MAC perfectly, but when it comes to WINDOWS, the plugin (360Works_ScriptMaster.fmx) always fails to establish network connection and shows time-out error. I am wondering if our company's firewall is blocking communication. Does the plugin use any special ports other than 80? Any ideas??? I have tried to figure out what's wrong by trying these cases: - On Showcase file (ScriptMaster.fp7) , GetUrlA…

Hi everyone. This is a weird one... I'm using ScriptMaster and trying to use the "Post XML Data" module to interact with an API that requires traffic over https. The problem is that the certificate that the site uses is issued by a non-standard authority (Starfield). As a result, I get this error: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target Apparently this is an infamous error in the Java community - Googling it will return a slew of posts about the problem, and some desc…

I have recently purchased the "pro" version of SM. Now I am playing around with it. For sending sms to a gateway, that I work with, I need to send several info. I have tried the Post Data to URL function, but that only allow 1 key. Reading in the script I see that it should be possibly to add more keys/values. However, the suggested way locks to a specific number of keys/values. I was thinking of being able to send a list to the function, where each value contains first the key, then seperated by e.g. a pipe. Anyway, I kind of gave up on that function, as I could not see how to accomplish the above mentioned method. Then I saw that I could use the get…

I am starting to use simple SQL commands to create new records and cannot find a way to return the primary key from the record that was created. Is there a combination of INSERT/SELECT that will do this for me? Thanks Tim

Does anyone know where to find script examples for other functions ? I did grab the script to create Code39 barcodes using the Barcode4j.jar and that works perfectly. However, that Barcode4j.jar supports many other barcodes such as Code128 and EAN and I would like to integrate thoose to as well as 2D barcodes. But I don't have the knowledge to write the scripts myself so I was wondering if there is a place, where you can find such scripts ?

Hi, just wondering if anyone know why println org.codehaus.groovy.runtime.InvokerHelper.getVersion() returns nothing when executed? I have some groovy code that fails to execute, but some of the error messages ( e.g. not being able to cast to a TreeSet, or no definition for java.util.LinkedHashMap.leftShift() ) seem to imply that it's not a current version. I just wanted to test see, what version of groovy is included, but I can't seem to get it to cough... ;-)

its been working fine - first I had this running as a registered plugin but then that failed then i reset everything to run native in SM and just register everything at startup just after I loaded the jar files from a URL. It worked fine for about 10 minutes - others (PC) are having no issues. But now when I run my PDF's are not merged and I get this error. java.lang.NoClassDefFoundError: Could not initialize class java.awt.Font

OSX 10.6 - FMPA 11v2 - ScriptMaster 4.122 IIf I use the Run Shell Script test in ScriptMaster DB, I do get the results displayed, but when in a script using a Set Variable [( Run Shell Script ( "my shell script" ; true ; 30 )] my results are "Executed shell command: my shell script". Not sure what I'm missing between the SM demo file and my script step? The actual shell script is checking if a file is locked by being open in another application. So I'm first using Select File get the file path, then creating a script variable of the shell script with the path embedded. The final shell script looks like this: fuser /Users/me/Desktop/test.xlsx | awk -F: '{print…

I'm writing a server-side script using ScriptMaster on FMSA11 OSX to download an image from an arbitrary URL & store in a container field, then crop it & create thumbnails, and store these in a container field. Everything is working great EXCEPTâ�¦ Get File As Container isn't working, either client- or server-side. I've confirmed that the file path and the image files themselves are valid. I re-downloaded a fresh copy of the ScriptMaster example file and I'm finding that even the simple example of Get File As Container isn't working. The function returns "?" as the container result, and the output variable "fileExists" returns "ERROR". The expected …

Hello all, I'm a newbie to hosted Filemaker solutions. However, I have created a database that uses ScriptMaster's UUID feature. I noticed that the UUID does not compute if the extension is not installed on the machine. I've purchased Filemaker hosting from 360 Works, so I figured the ScriptMaster UUID feature would work. However, it does not. Is there a step (using the Admin Panel or by making the function a part of my FM file) that I can do to make the UUID feature work? Or do I need to ask 360Works to install the ScriptMaster plugin for me? (Which they may not do...?) Thank you, Stephen

Hello all, I just discovered the free plugins from 360 by downloading scriptmaster, as I was looking for a way for fm to capture a photo taken from a webcam (logitech quickcam zoom)to be put straight into a container field. I didn't find that, but I saw the "move or rename file", so I thought I could place a button above my container field that would rename & move the picture I just took, then go to the container field & insert picture with the new name. But I cant get move or rename to work, keeps coming back with a 0 (error), both after I register the function & make a script to call it or just trying it out in scriptmaster (by clicking green …

We're testing the signature capture on iOS devices here at work and I was trying to set up the script on the server to periodically convert the Base64 data to a .png When I run it on the server I get a "Filemaker script error" and a "?" in my container fields. What I've done so far: Scriptmaster plugin installed in the extensions folder for server and the client (residing on the server) Startup script registering the function in the file where the script is run from Checked that all my script steps are server compatible Script works properly on my client machine Now, I will say that I have not restarted the server or the server software since …

Hi all, I'm a lurker for a longish while. I was trying to download Scriptmaster 4 several times today, on Safari and also Firefox with no luck. The download just hangs up on both browsers. Any tips? I have no block on the port 80 or 443 issue as far as I know. Both are set to allow java and java script. Maybe the host server at 360 is down, other than that I am having a senior moment as to what else to try.

Hi all For now I've managed to encode a text field as UTF-8 and write it to a text file, however, what I really need to do is to encode the text on-the-fly, before encoding it as Base64 and sending it to a web service. I found this script on the web but don't know Java so please tell me what are the variables here so I can declare them before using EvaluateGroovy (): import java.nio.ByteBuffer; import java.nio.charset.Charset; public class MainClass { public static void print(ByteBuffer bb) { while (bb.hasRemaining()) System.out.print(bb.get() + " "); System.out.println(); bb.rewind(); } public static void …

I recently switched workflow to Mac and found my Mooplug doesn't work. I like the premise of Scriptmaster but find myself with training wheels. Here's my example. I previously used Moo to assign a folder to a variable using the following script: Set Variable [$$jpegPath; Value:Moo_Diaglog_Folder] Set Field [iMAGES::JPEGPATH; $$jpegpath] Effectively allowing the user to choose a default folder where the images where found. From what I can tell this should be easier in Scriptmaster but I can't get it work without a prompt for a field name. When I try Set Variable [$$jpegPath; Value:ChooseFolder(prompt; startingPath) FM prompts me for the specified table.…

Hello, I have created a runtime application using Filemaker Pro Advanced 11. This application uses many scriptmaster functions and performs well on my Macbook Pro with 4 GB of ram. However, when I use it on my Mac Mini with 2GB of ram it crashes frequently. The application "Unexpectedly Quits". I don't know if it is a memory issue or not but that is the biggest difference I can think between the 2 systems. Both computers are running MacOS 10.6.5. On the mac mini I plugged in an external hard drive and installed a fresh copy of MacOS 10.6.3 and it even had the same problem on the freshly installed system. If I remove the scriptmaster plugin everything works grea…

I currently use 360 works email plugin together with an Email to SMS service to send text messages from Filemaker to my customers . Lately there have been some reliability issues due to email servers blocking traffic. The company that does the email to sms conversion suggested I use an http post method to get the message from my database to their server, bypassing email completely. I noticed that Scriptmaster has been updated to handle http post , but I am completely out of my depth regarding this. Does anyone have any experience in using this plugin. I have some information from the company here: http://www.txtlocal.co.uk/sms-api.php . I am currently using a table called…

I'm pretty new to XPath, an could use a little help with walking incoming XML strings. Focusing on the element: <birthTime value="19530215112005"/> How do I structure a query to return just the enclosed data for this type of XML element (self-closed, with attributes)? (i.e. 19530215112005). These occur throughout my XML, and I need to know how to pull them out in general. Thanks, Drew Tenenholz Sample XML <?xml version="1.0" encoding="utf-8"?> <ClinicalDocument xmlns="urn:hl7-org:v3" xmlns:sdtc="urn:hl7-org:sdtc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:hl7-org:v3 http://xreg2.nist.gov:80…

Hi there, this is my first post to FMForums! I'm working on Parsing a XML document called a CCD (an electronic medical record system's Continuity of Care Document). This is a structured XML document with a lot of elements and a rather complicated way of describing a person's medical history. I'm comparing the XPath functions from Scriptmaster and FMNexus' WebServices plug-ins and trying to see what will work best for me. (I've attached a sample CCD for a fictional person, in case anyone wants the ugly details....) For now, I'd like to know if one can use ALL XPath 1.0 functions with ScriptMaster or not. For example, there are what I'd call meta-functions in …

THe following code is an adaptation of the standard stuff supplied with ScriptMaster. I adapted it to yield a second attachment: import javax.mail.*; import javax.mail.internet.*; Properties props = new Properties(); props.setProperty("mail.smtp.host", smtpHost); MimeMessage msg = new MimeMessage(Session.getInstance(props)); Multipart content = new MimeMultipart(); // first the message body MimeBodyPart bodyPart = new MimeBodyPart(); bodyPart.setText(body, "UTF-8"); content.addBodyPart(bodyPart); // then the 1st attachment MimeBodyPart attachmentPart = new MimeBodyPart(); attachmentPart.attachFile(attachmentPath); content.addBodyPart(attachmentPa…

Any idea how to avoid the flickering? I'd very much like to use the function in an unstored calculation. Thanks Robert

Hi there, I usually work with a solution with some functions of Scriptmaker. I have installed this solution in a computer running FM9 and FM11 Advanced. But all the two versions show a message as the plugin wouldn't be installed. Trying to do it throught the autoupdate failed aslo. I can see the pluging in the FM preferences, but in grey and is it imposible to activate it. I have uninstall the two versions of FM, even cleaning the registry and install again with the same error. In the same computer we have a FM Server 9. We have this same scenary in others computers running perfectly. Any idea? Thanks ;)

ScriptMaster offers the "Send Email with Attachments" function. The notes for the function says "Here is a more advanced script for sending email with attachments." But the input variables section only shows a single attachment path. Can this SM function be used to send multiple attachments? Or is it limited in the same way that the native FMP "Send Email" function is? Sorry if this Q has been answered before. It wasn't clear to me from the other threads if the poster was talking about the ScriptMaster function or the native function. Thanks.

I'd like to be able to schedule a script to be triggered on FileMaker's idle state, similar to myFMbutler's DoScript plug-in: http://fmbutler.com/index.lasso?p=416 Does anyone know if this can be done with ScriptMaster?

Hi, I'm trying to use the XPath function of Scriptmaster, but ran into a problem when the XML string does contain umlauts or higher ASCII characters. Even declaring the XML string as <?xml version="1.0" encoding="UTF-8"?> makes no difference. Only solution I have found is encoding the characters in unicode. Due to the fact that my XML string values can contain characters from different european languages extensive encoding and decoding would be necessary before and after the actual calculation. Is there a way to use the function with a UTF-8 character set? Thanks for any response. best Martin

I love ScriptMaster and it's ability to zip a file. Does anyone have a clue on how to make it grab multiple files and zip them into one file? I'm trying avoid putting all the files into a directory and zipping them. I thought you could in the command line set your destination file and just list the files you want added or zip one file and then append it to the newly created zip file. One I do that, then I would love to see if I could rename the files either before zipping or after without effecting the master file. I know the easiest way to do this is to make a copy in a new directory and rename the file and do that with all the files needed. Just looking to cut a f…

Do you have any schedule for updating and moving to Groovy 1.7.5 or later any time soon??

Is it possible to use fmpro.getContainerStream to fill a MimeBodyPart with an image/jpeg from a Container field? If so, how? Thanks, Larry Goldman

Is there a way in ScriptMaster to pass an unknown number of parameters or a variable number of parameters to a function? I was thinking of something along the lines of a file list, or a list of people, where there could be 1 file, or 20. I understand that in the function I would have to parse these, but I would rather have them come in as separate parameters than as a comma separated, return separated, or some other list as a single parameter. Thanks, ~Mark

I would like to know of there is a way to open a specific file's location using ScriptMaster. Context: Whenever we print an invoice from FileMaker, part of the process is to create a PDF of the invoice and save it to a network drive. The invoice within FileMaker is then stored in a separate FM database that salespeople can access if needed, but this backup is not explicitly connected to the PDF that was created. In this "sent invoices" database, it would be nice to have a button that, when clicked, would open the location within windows explorer of the PDF that was created for that invoice and, ideally, highlight it. This seems like it would be a lot more natura…

How can I access 'com.prosc.beanshell.FMpro.metaClass' from my own class in my own .jar file? What I am trying to do is create all my plug-in functions in a class, so that I can integrate error handling/reporting and easily call one function from the other, without having to re-write code. This class needs to be able to save values between plug-in function calls (for example: if an error occurs, I want to set my own custom error code to a variable, then let that variable be retrieved by calling a MyPluginLastErrorNumber() function) . I have been trying to attach a storage object to the 'com.prosc.beanshell.FMpro.metaClass' object, which I was able to do when …

I have been playing with the ScriptMaster plug-in for the last few days and was stumbling through creating a .jar file with my own code, which could be accessed from any function. Since I did not find any information on how to do this in this forum, I thought I would add my findings here... I used the 'CreateFolder' function included with ScriptMaster as an example. 1. Write Class Code class MyFunctions{ def CreateFolder(path){ File dir = new File(path); if( dir.exists() ) return false; if( dir.mkdirs() ) { //Success! return true; } else { //Figure out why it failed File realParent = di…

I am trying to smtp thru Zimbra, which requires port 465, and SSL but when I edit the groovy code to use Port 465, it freezes ( beach ball ) It does work thru Outlook Express, so the account info is correct greg

I developed a filemaker database on the Mac with a plugin generated by scriptmaster 4.02 (professional version). On my Mac it works fine, but when i put the windows plugin in the extension folder on my windows xp machine, it crashes filemaker immediately I get the following error message in my log: (C++ Mon Jan 03 16:21:17 2011) *** INIT for plugin file functions_FMPro at Mon Jan 03 16:21:17 2011, headless mode 0 (C++ Mon Jan 03 16:21:17 2011) Found JVM dll at C:\Program Files\Java\jre6\bin\client\jvm.dll (C++ Mon Jan 03 16:21:17 2011) An error occurred while trying to load com.prosc.fmkit.PluginBridge. Make sure that it is loaded in a jar called 'plu…

I am working on a database that I need to sync with FM Go, and a copy will occasionally be offline. I want to use ScriptMaster for the UUID function, but obviously FM Go does not support extensions. I want to be able to use a custom function which will create a result consistent with the Scriptmaster UUID function and also not create duplicates. I know that there are various custom functions at Brian Dunning et al which will create a UUID, but I would like to know if it will be consistent (e.g. if I incorporate offline records can I be reasonably sure that none will have a duplicate UUID even if it is created at the exact same time as another record created on the prim…

Hello at 360°works.com, please can you give us information for clipboard types used in Filemaker as listed: dyn.ah62d4rv4gu8y63n2nuuhg5pbsm4ca6dbsr4gnkduqf31k3pcr7u1e3basv61a3k dyn.ah62d4rv4gk81n65yru dyn.ah62d4rv4gk81g7d3ru dyn.agk81n65yru dyn.agk81g7d3ru What clipboard type is used by Scripts, Layouts, Custom Functions, etc.? Thanks HB