Hi,

My sketch uses XlsReader, which is ace: nicely reads in data.

http://florianjenett.de/processing/libs/xls/

Problem: upon publishing the Applet won't run it. I'm a little unclear from the console output whether it's failing through lack of finding the file (it's in the same folder as the Applet) or if its a security problem.

I note that loadString() checks in the data folder on the server. There's also this discussion which fills me with dread slightly -

http://processing.org/discourse/yabb2/num_1244746861.html

I've tried various file locations - if the file's on the same server, I shouldn't have security problems, should I Is it a path problem

Halp! Any ideas gratefully received. Perhaps XlsReader has its own security problems. Console output below. Code is here:

http://www.coveredinbees.org/processing/GISSdata_vis1/index.html

----

Reading certificates from 11 http://www.coveredinbees.org/processing/GISSdata_vis1/climatedatavis2GISS1.jar | C:\Documents and Settings\Olner Dan\Application Data\Sun\Java\Deployment\cache\6.0\16\78364ad0-6ec99131.idx
Reading certificates from 11 http://www.coveredinbees.org/processing/GISSdata_vis1/core.jar | C:\Documents and Settings\Olner Dan\Application Data\Sun\Java\Deployment\cache\6.0\27\505b551b-497d449d.idx
Reading certificates from 11 http://www.coveredinbees.org/processing/GISSdata_vis1/XlsReader.jar | C:\Documents and Settings\Olner Dan\Application Data\Sun\Java\Deployment\cache\6.0\40\553aad68-41187171.idx
Reading certificates from 11 http://www.coveredinbees.org/processing/GISSdata_vis1/poi-3.0.1-FINAL-20070705.jar | C:\Documents and Settings\Olner Dan\Application Data\Sun\Java\Deployment\cache\6.0\29\31c228dd-67ae741f.idx
Exception in thread "Animation Thread" java.lang.ExceptionInInitializerError
     at java.lang.Class.forName0(Native Method)
     at java.lang.Class.forName(Unknown Source)
     at org.apache.poi.hssf.record.RecordFactory.class$(RecordFactory.java:46)
     at org.apache.poi.hssf.record.RecordFactory.<clinit>(RecordFactory.java:44)
     at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:205)
     at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:153)
     at de.bezier.data.XlsReader.<init>(Unknown Source)
     at climatedatavis2GISS1.setup(climatedatavis2GISS1.java:85)
     at processing.core.PApplet.handleDraw(PApplet.java:1402)
     at processing.core.PApplet.run(PApplet.java:1327)
     at java.lang.Thread.run(Unknown Source)
Caused by: java.security.AccessControlException: access denied (java.util.PropertyPermission poi.deserialize.escher read)
     at java.security.AccessControlContext.checkPermission(Unknown Source)
     at java.security.AccessController.checkPermission(Unknown Source)
     at java.lang.SecurityManager.checkPermission(Unknown Source)
     at java.lang.SecurityManager.checkPropertyAccess(Unknown Source)
     at java.lang.System.getProperty(Unknown Source)
     at org.apache.poi.hssf.record.AbstractEscherHolderRecord.<clinit>(AbstractEscherHol
derRecord.java:41)
     ... 11 more

Thanks for googling for me; you always know you've not done enough work yourself when others are googling on your behalf! Sorry...

I'm in work now, where I left my copy of Ben Fry's visualising data, which has loads of ideas. I think I'll have a go at grabbing the climate data directly from its URL and parsing it in Processing.

Thanks for your help.

I added a note to the XlsReader website.

You can check progress on the issue here:
http://github.com/fjenett/xlsreader/issues/1

Best
F