Jump to content

Tim Anderson

Members
  • Content Count

    85
  • Joined

  • Last visited

  • Days Won

    1

Tim Anderson last won the day on January 28 2013

Tim Anderson had the most liked content!

Community Reputation

2 Neutral

About Tim Anderson

  • Rank
    newbie

Profile Information

  • Gender
    Not Telling
  1. Tim Anderson

    Plugin 2.17 on Windows 10 FM17

    Thanks Ryan. makes sense!
  2. 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
  3. Tim Anderson

    iText Scripts...

    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
  4. Tim Anderson

    Selection new MacPro hardware for FMS13

    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!
  5. Tim Anderson

    Backup to NAS FMS 13

    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
  6. 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
  7. Tim Anderson

    Log File

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

    Log File

    I guess this is a 'No' then
  9. Tim Anderson

    Log File

    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
  10. Tim Anderson

    ExecuteSQL Summaries

    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 = "" ] ; "" )
  11. Tim Anderson

    ExecuteSQL Summaries

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

    post to Ebay from Filemaker

    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?
  13. Tim Anderson

    ExecuteSQL Summaries

    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
  14. Tim Anderson

    SFTP simple Upload Java with ScriptMaster

    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
  15. 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
×

Important Information

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