360Works

Problem with emailConnectIMAP on serverSideScript

Wed, 22 Feb 2012 21:55:13 +0000

Script that runs perfectly on client side from a remote computer, or from fmkr client installed on the server, gives me an error every time at the emailConnectIMAP script step.

The error returned is "Login failed."
There is no firewall
The plugin is installed on the server
The emailRegister step is returning properly
I'm running the script with admin privileges

SC Installation problem - can't view images remotely

Wed, 22 Feb 2012 15:47:02 +0000

I've installed SC on numerous PCs and Macs, but am having a problem getting it to work at one client site. SC works fine in the office, but we just can't see images remotely.

The only thing that is different at this site is that SC is hosted on Mac Server. The host is running FileMaker Pro 11 v4. We have the latest version of SuperContainerserver.jar, we've opened port 80 and have verified that it is open via CanYouSeeMe.org. In System Preferences we have Web Sharing turned on.

Is there some special setting for Mac Server? What setup step have I possibly overlooked?

Thank you for your time and assistance,
Will

Select File () path needs volumeName?

Wed, 22 Feb 2012 03:35:00 +0000

I have just DL'd v 4.

I got it working and have the file and path (OSX) assigned to a variable: $$SelectImportFile .

I try and use $$SelectImportFile as the File Source variable specified in the Specify data source dialog.

FM DOES NOT IMPORT / FIND the file? I thought perhaps I need to specify the volumeName in addition to the path and file name?

If so, how can I get the volumeName to append to the path? (concatination is the method I presume).

Thanks

A password dialogue input function

Tue, 21 Feb 2012 22:34:31 +0000

Has a bit of help from Sam Barnum on StackOverflow with this but have a function which either gives you three chances to enter the correct password, or returns the password you enter into the box.
Just a bit of practice for me with SwingBuilder but might be a useful starting point for others.

Some of this has been enabled by the latest Groovy 1.8.4 version in the current Scriptmaster

// PasswordSwing ( title ; message ; type ; password ; returnPass )
// 12_02_21 JR
// v1.0
// type -1 plain, 0 error, 1 information, 2 warning, 3 question
// if returnPass then displays a dialogbox with a password field and returns the passsword on OK
// and uses title and password parameters and returns entered text
// else gives three attempts to enter a password which matches password parameter
// returns true if match if not or dialog cancelled returns false


import javax.swing.JComponent
import groovy.swing.SwingBuilder

type = type.toInteger()
i = 0
left = ''
swing = new SwingBuilder()

if(returnPass){
swing.edt{
  passwordField = passwordField()
  JComponent[] components = [label(message), passwordField]
  result = optionPane().showConfirmDialog(null, components, title, 2, type)
}
return passwordField.getPassword().toString()
} else {
swing.edt{
  passwordField = passwordField()
  while(i < 3){
   JComponent[] components = [label('Password'+left), passwordField]
   result = optionPane().showConfirmDialog(null, components, title, 2, -1)
   if (passwordField.getPassword().toString() == password || result == -1 || result == 2){
    i=3
   } else if (passwordField.getPassword().toString() != password && i==2) {
    result = optionPane().showMessageDialog(null, 'WRONG PASSWORD
Script halted', 'ERROR', 2)
    i=3
   } else {
    result = -1
    i++
    message = i == 2 ? ' try':' tries'
    left = ' - ' + (3-i) + "${message}" + ' left'
    passwordField = passwordField()
   } //end if
  } //end while
} //end swing
return result == 0 ? true:false
}

JDBC Plugin Query Timeout ?

Mon, 20 Feb 2012 17:47:42 +0000

I tried adding the suggested "timeout=30" to my jdbcPerformQuery, and it fails

I tried it enclosed in quotes, and not

is this feature available?

thanks
greg

Currency converter

Mon, 20 Feb 2012 17:23:57 +0000

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 = '''\


  
	
	  ${from}
	  ${to}
	
  

'''
template = new STE().createTemplate(XMLtext)
params   = [from:from, to:to]
request  = template.make(params).toString().getBytes('UTF-8')
url  = 'http://www.webservicex.net/CurrencyConvertor.asmx'
conn = new URL(url).openConnection()
reqProps = [
	'Content-Type': 'text/xml; charset=UTF-8',
	'SOAPAction'  : 'http://www.webserviceX.NET/ConversionRate',
	'Accept'	  : 'application/soap+xml, text/*'
]
reqProps.each { key,value -> conn.addRequestProperty(key,value) }
conn.requestMethod = 'POST'
conn.doOutput	  = true
conn.outputStream << new ByteArrayInputStream(request)
if (conn.responseCode != conn.HTTP_OK) {
return "Error - HTTP:${conn.responseCode}"
}
resp   = new XmlParser().parse(conn.inputStream)
serv   = new Namespace('http://www.webserviceX.NET/')
result = serv.ConversionRateResult


if ( !amount){
return "Current " + params.from + " to " + params.to + " conversion rate: " + resp.depthFirst().find{result == it.name()}.text()
} else {
rate = resp.depthFirst().find{result == it.name()}.text()
convert = amount.toInteger() * rate.toDouble()
return 'That is ' + convert.round(2) + ' ' + cTo
}

How do you get information from a dialog box?

Sat, 18 Feb 2012 17:05:35 +0000

The scriptmaster dialog example allow you to have a dialog with dynamic buttons (Formatted Dialog with Dynamic Buttons), but in the example, it is unclear how to use the dialog to obtain user information as one can with Filemakers show custom dialog.

I want to use the dialog box and have the user enter a name and other information.

Is there any documentation anyone can point me to, on how to use this feature in the scriptmaster dialog.

Thanks

Abel

Problem with SCMove

Sat, 18 Feb 2012 00:14:31 +0000

Hello,

I am trying to use the SCMove function to move a file from one directory to another inside my SuperContainer location. Currently my function call looks something like this:

SCMove("WorkingDirectory/UniqueResourceDirectory/","TargetDirectory/"&TABLE::ID)

When I run my script, I get an error, and the supercontainer server says:

Move operation failed: java.io.FileNotFoundException: No SuperContainer file for /WorkingDirectory/UniqueResourceDirectory
No SuperContainer file for /WorkingDirectory/UniqueResourceDirectory

I have also tried my function call like this:

SCMove("WorkingDirectory/UniqueResourceDirectory/file.pdf","TargetDirectory/"&TABLE::ID)

In which case I get the same error but like this:

Move operation failed: java.io.FileNotFoundException: No SuperContainer file for /WorkingDirectory/UniqueResourceDirectory/file.pdf
No SuperContainer file for /WorkingDirectory/UniqueResourceDirectory/file.pdf

I am stumped, as I have tried many variations on the above themes, putting slashes in different places, with and without the file name, etc.

Can someone help? Or possibly provide a working example of how to call SCMove, since the companion plugin documentation does not have one.

Thanks,
Mark

Upload from iPhone : We did it!

Mon, 13 Feb 2012 05:07:03 +0000

May be old news, we were excited.

Scenario:
Our field techs use iPhones to document installations of various wireless equipment and site configurations in the field. Its really important in our business (large regional WISP) since sending a tech out to a location 50 or 100 miles removed is an expensive business. We need to be able to troubleshoot as much as possible remotely and a big part of that is equipment location/setup.

This was causing us to store tons of photos in our already huge FMP database. SuperContainer to the rescue!

Except you can't upload out of fmp go. Ouch!

Solution:
So we are using PicUp (http://picupapp.com/). This intercepts any URL requests for the space 'fileupload://' and does some magic.

Then its just a matter of embedded a button that sends the right url to an Open URL script step.

(generic example: fileupload://new?callbackURL=http://picupapp.com/done.html&referrername=Picup%20Scratchpad&referrerfavicon=http%3A//picupapp.com/favicon.ico&purpose=Select%20a%20sample%20image%20for%20the%20Picup%20Scratchpad%20tool.&debug=true)

Our specific URL posts to a listener on our server which, based on some parameters (not above) sticks the file into the right place for SuperContainer which the client then can view.

Elegant? Somewhat. Does it work? Heck yea.

Anyone have alternate solves for this?

Noisy backgrounds at different pixel sizes

Mon, 13 Feb 2012 03:22:02 +0000

Hi folks, trying to find any reference to 'noise' or 'noisy' in the SuperContainer Forums with no success, hence this post:

-- Does anyone know how to combat this noise in the thumbnail files...? It only occurs at specific pixel sizings... that is, make it a few pixels bigger or smaller, and they go away - so something to do with the rendering/downsampling process... and, you guessed it, at the size most images appear on our web catalogue, a noticeable number appear like this.

I'm working off Mac Mini Lion Server, so using the Core Image Previews - and this file was a PDF, originally out of Illustrator. Happy to provide any/all specs on request.

Pre-emptively throwing it out there: please don't suggest to make a white background behind all artwork - we have many many thousands of live and legacy files!

With many thanks,

AB