Tim Anderson

Unfortunately Pivot Table does not work in Windows 10 (64 bit), I suspect this might be because it needs the Edge browser but I am just guessing. I have had a look at the documentation wiki but can't see anything that indicates required browser 9at least not to my limited knowledge). Can anyone confirm if this is the case or if there is anything that can be tweaked to make it work? thanks Tim

Thanks Ryan. makes sense!

Simple question Will this work, or do we need to upgrade client to Version 3? I don't see anything in the version history to give me any guidance Thanks Tim

Hi John, Hope you are well and busy. Think you have missed a '.' and a '++' as below // PDFadd( filelist ; fm_FileOut ) // JR 14_02_12 // v2.1 // concatenate PDF files import com.itextpdf.text.Document import com.itextpdf.text.pdf.PdfCopy import com.itextpdf.text.pdf.PdfReader files = filelist.split('n') // step 1 document = new Document() // step 2 copy = new PdfCopy(document, new FileOutputStream( fm_FileOut )) // step 3 document.open() // step 4 PdfReader reader int n // loop over the documents you want to concatenate files.each { item -> reader = new PdfReader("${item}") n = reader.getNumberOfPages() for (page in 0..<n ) { copy.addPage(copy.getImportedPage(reader, ++page)) } reader.close() } // step 5 document.close() return true Cheers Tim

It would be great to see a chart of how the different factors (processor/drive/cores/network) affect the performance for an increasing number of users so we can find the optimum balance for the number of users. Problem is that there are too many variables in the way our FileMaker solutions are developed that may have a bigger influence and negate all other factors!

A very simple folder action script created from Automator on the target backup folder will do the job of copying contents to another location. Much simpler than creating a shell script (for me) and the copy doesn't appear to start until the backup is complete

I saw something like this on Windows Server 2008R2. I found the problem to be in one of the scripts, the results I was getting back from the query that I was using the XpathParse on was not what it should have been and the error trapping I was doing missed the result I was getting. I think this caused the 'cross fertilisation' of results of the scripts and eventually an FMSE crash. Since I found the undocumented response from the query and trap for it it has not happened again - that was about 4 months ago. It's tedious, but I found the 'bad' response by writing the response to a field each time it was returned - slowed the process down (which actually delayed the error!), but I did get a record of the returned xml Hope that helps Tim

Thanks SCNinja, Will give that a try when I do a new build of the plugin. TIm

I guess this is a 'No' then

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

Hi Beverly, Anyone on this forum should also join Technet if they hanen't already - as John points out it costs nothing and is a great resource. Below is a copy of my last post there I have exactly the result I was looking for thanks to the genius of Agnès Barouh and her amazing CustomList custom function ( http://www.tictac.fr/CoinFileMaker/PageCustomList.html ). I now have which scrolls beautifully as a webviewer To get this I took the SQL result ( sorted in the SELECT statement) and ran it through a custom function I modifed from her UniqueList cf as below. Fairly easy thanks to the genius of Agnès! Hope this helps some others Tim //-------------------------------------------------------------------*/ // Based on the UniqueList functon by Agnès Barouh - Juillet 2007 - //-------------------------------------------------------------------*/ // ParseHTMLForSummaryHeaders( TheList ) Let( $_TheList = TheList ; CustomList( 1 ; ValueCount( $_TheList ) ; "Let( [ TheValue = GetValue( $_TheList ; Num ); headerEnd=position(TheValue;"</B>";1;1); lVal=length(TheValue); thePrefix=left(TheValue;headerEnd); theRest=right(TheValue;(lVal-headerEnd)-3) ] ; Case( PatternCount( $_Value ; thePrefix ) < 1 ; Let ( $_Value = $_Value & " " & TheValue ; TheValue ); Let ( $_Value = $_Value & " " & TheValue ; theRest ) ))" ) ) & Let( [ $_Value = "" ; $_TheList = "" ] ; "" )

Solution found, posted on technet https://fmdev.filemaker.com/message/98648#98648%2398648

I have done this for a client. Quite a complex process and not for a novice, there are many potential areas that could catch you out. How many items are you going to be uploading and how often?

Thanks, have looked through that and, with some input from Technet, have come to the conclusion that I am going to have to post-process the results from SQL with a custom function

I have tried to use this but after a long wait I get the result 'null' and no file transfer occurs. I have local directory paths in the formats /Users/username/Desktop and /Users/username/Desktop/ and similar formats for the remote directory path. Anyone give me any pointers, the hostname, port, username and password are all correct Thanks Tim

Hi All, I have posting this on Technet, but adding here in case someone can help me here who doesn't use TechNet. I have been playing with fql for a while, using plugins before FM12, but now have come up with something that, from my reading, may not be possible! before I spend (waste?) any more time can anyone tell me if the below is possible. In the table I am looking at there are 3 fields I am interested in, ImageID, imagesize and quantity. I want to summarise the data such that I get something like below. I want to use the results in a webviewer so cannot take into another table and process Image 1 10x8 3 6x4 1 Image 2 10x8 1 6x4 2 Image 3 6x4 2 I think I am going to have to find some way of processing the results of the ExecuteSQL to get this, unless someone with a great deal more knowledge of SQL than me (Ok, that will not be difficult!) can tell me otherwise Thanks Tim

The InsertFromURL step works on server and is what I use in this scenario. The URL can point to a file in a server-accessible folder Tim

Found it in C:WindowsSysWOW64configsystemprofile

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

Thanks, But I have found the same script running on it's own on the server can also exhibit the same behaviour. It appears to only occur when the progressive backup is active as the script ran perfectly for 12 hours on a client machine, and on a different server when progressive backups were disabled

Hi John Yes. Try restarting the script engine (fmsadmin restart fmse) - no you are not on FMS12, restart the server! Tim

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) at com.prosc.beanshell.FMPro.executeSql(FMPro.java:142) at com.prosc.beanshell.FMPro$executeSql.call(Unknown Source) at scriptmaster.Module_MTYyNTQ1MjgzNgXX.run(scriptmaster.Module_MTYyNTQ1MjgzNgXX.script:1) at com.prosc.beanshell.GroovyFunction.invoke(GroovyFunction.java:110) at com.prosc.beanshell.CompiledFunction.invoke(CompiledFunction.java:78) at com.prosc.fmkit.Plugin.invokeFunction(Plugin.java:333) at com.prosc.fmkit.RegisterablePlugin.invokeFunction(RegisterablePlugin.java:77) at com.prosc.fmkit.Plugin.invokeFunctionNoErrors(Plugin.java:314) at com.prosc.fmkit.PluginBridge$3.run(PluginBridge.java:1055) at com.prosc.fmkit.PluginBridge.runTask(PluginBridge.java:1264) at com.prosc.fmkit.PluginBridge.doFunction(PluginBridge.java:1069) Aug 28, 2012 11:32:46 AM com.prosc.beanshell.BeanShellPlugin setLastError SEVERE: ScriptMaster bound variables: Parameters: And Aug 28, 2012 11:42:08 AM com.prosc.fmkit.PluginBridge pushContext WARNING: pushContext called with function (com.prosc.beanshell.CompiledFunction@1542a75) when stack size is 1; this either means it was called re-entrantly, an idle handler was called without waiting for a return from a previous call, or pop was not called from last invocation. Current thread: Thread-27875 Each script runs perfectly on it's own. The ScriptMaster log file on the server shows everything in order and no errors. Any help please?? Thanks

John, The XPath Parse function works perfectly with the code returned from the ScriptMaster function, but not from the MWS Scratchpad! Tim

Hi Beverly Done some checking and I was using the XML returned from a web tool to test parsing, but I will be using a ScriptMaster routine to get the XML in the solution - the ScriptMaster module is returning &amp; so this was a non-issue! Thanks anyway Tim

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