Ag_Spreadsheet_ImportgraphSpreadsheetImportfileurl0year11total11Potash11Phosphate11Nitrogen11 Modified columns and rows for spreadsheet import service: Columns B to F and Rows 5 to 54. Row 5 is key as it pulls the header info to be used later in the legend on the graph. Added new ports to reflect the header: Nitrogen, Phosphate, Potash, Total and Year. 2011-09-21 12:30:28.626 EDT net.sf.taverna.t2.activitiesspreadsheet-import-activity1.3net.sf.taverna.t2.activities.spreadsheet.SpreadsheetImportActivity 1 5 4 53 D Phosphate E Potash F total G public_water_supply A over B year C Nitrogen L 2001 N 2002 H 1999 J 2000 T 2005 V 2006 P 2003 R 2004 X 2007 Z 2008 false false true EMPTY_STRING PORT_PER_COLUMN , net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeGenerateGraphURLdata2headers1years1graphURL00 Modified the script to more appropriately "scale" the output and the units: sb.append(",2|1,0,25"); sb.append("&chds=0,25000"); sb.append("&chxl=2:|1000%20nutrient%20tons"); 2011-09-21 12:42:11.142 EDT net.sf.taverna.t2.activitiesbeanshell-activity1.3net.sf.taverna.t2.activities.beanshell.BeanshellActivity title 0 text/plain java.lang.String true data 2 text/plain java.lang.String true headers 1 text/plain java.lang.String true years 1 text/plain java.lang.String true graphURL 0 0 workflow net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeGet_Image_From_URLurl0image00 gets the image using the URL from the GenerateGraphURL service. 2011-09-21 12:45:01.720 EDT net.sf.taverna.t2.activitieslocalworker-activity1.3net.sf.taverna.t2.activities.localworker.LocalworkerActivity url 0 'text/x-taverna-web-url' java.lang.String true base 0 'text/x-taverna-web-url' java.lang.String true image 0 'image/*' 0 workflow org.embl.ebi.escience.scuflworkers.java.WebImageFetcher net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeBeanshellNitrogen1Phosphate1Potash1total1year1headers11years11data22 Adds headers and data for to be added to GenerateGraphURL service: year Nitrogen Phosphate Potash total All of depth 1 as they are lists. Modified the script to reflect these new headers and the data to be imported. 2011-09-21 12:40:19.956 EDT net.sf.taverna.t2.activitiesbeanshell-activity1.3net.sf.taverna.t2.activities.beanshell.BeanshellActivity year 1 text/plain java.lang.String true Nitrogen 1 text/plain java.lang.String true Phosphate 1 text/plain java.lang.String true Potash 1 text/plain java.lang.String true total 1 text/plain java.lang.String true data 2 2 headers 1 1 years 1 1 workflow net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokeurl_valuevalue00 URL for spreadsheet to be imported: http://www.myexperiment.org/files/568/download/FertilizerUse.xls 2011-09-21 12:28:28.901 EDT net.sf.taverna.t2.activitiesstringconstant-activity1.3net.sf.taverna.t2.activities.stringconstant.StringConstantActivity http://www.myexperiment.org/files/568/download/FertilizerUse.xls net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeSpreadsheetImportfileurlurl_valuevalueGenerateGraphURLdataBeanshelldataGenerateGraphURLheadersBeanshellheadersGenerateGraphURLyearsBeanshellyearsGet_Image_From_URLurlGenerateGraphURLgraphURLBeanshellNitrogenSpreadsheetImportNitrogenBeanshellPhosphateSpreadsheetImportPhosphateBeanshellPotashSpreadsheetImportPotashBeanshelltotalSpreadsheetImporttotalBeanshellyearSpreadsheetImportyeargraphGet_Image_From_URLimage 58a4da02-d1f0-41ce-9ace-8a62b49b62d7 2010-07-13 06:22:26.72 EDT e8e06bbd-b511-4a1b-b932-1b1f16b38ede 2011-09-20 17:18:36.511 EDT 47de0484-f703-40ab-b1f7-b0826495a00d 2010-07-07 18:09:23.782 EDT 7ca4b117-111d-4605-826e-868d7d159b52 2010-07-13 06:16:32.697 EDT fd4e1cda-8259-4988-8be5-ebcd42ee1517 2011-09-20 17:59:33.136 EDT 37e47c9b-48bd-49b9-b054-08fd61a19881 2011-09-20 17:34:40.143 EDT dfa2cd09-f53d-47f4-91cd-207ec2dc2c34 2010-07-07 11:51:22.4 EDT 464013e1-0699-4e1a-bac7-047576261b33 2010-07-07 18:07:59.655 EDT 7cb60975-0ce0-425d-ac3b-ee8550ba2f8c 2011-09-20 18:09:58.425 EDT 99c992df-d200-4cda-a973-c60be723e784 2010-07-07 12:14:16.5 EDT e263e793-b394-4a57-855e-13e69b8780c2 2010-07-07 12:00:11.782 EDT 92b3e529-6de7-4436-9413-d2fec5d948dc 2011-09-20 17:27:02.674 EDT 2093b538-6e10-4d11-b9b8-82cd882e4553 2011-09-20 17:20:44.822 EDT 6d9b5609-37c3-4fb1-9eea-e6b70209427e 2010-07-07 09:05:03.421 EDT 6227da85-dde6-46d9-8a32-6baa52f82d93 2011-09-20 18:11:21.391 EDT 1cb03bb3-6259-4400-b298-4d7586eb206f 2011-09-21 12:27:42.868 EDT 14265f88-5335-4e7b-ae00-3b5703abe9b6 2011-09-20 18:05:08.524 EDT cf652fd0-e4d3-4713-93bb-0dc56f21a72f 2011-09-21 00:28:04.534 EDT 2b3b850b-5a0c-4878-854d-32c6fe81e7d3 2011-09-20 18:01:25.273 EDT Ag Spreadsheet Import 2011-09-21 12:27:42.686 EDT 27965b7c-1a89-46ac-8c9b-a4c6bf9144f0 2010-07-13 06:22:36.27 EDT c0753ab7-cd9d-400e-b483-048dcbaad5f9 2010-07-07 11:36:44.391 EDT 84be9192-4cac-4ad7-8c41-6d49c937b2ab 2011-09-21 12:45:21.724 EDT 58b3ac31-cfb3-418a-85ae-1990b2883c35 2010-07-07 17:57:04.585 EDT 8a96da98-2609-4089-a86a-ca130c18d60e 2011-09-21 12:42:21.253 EDT 27fa4d49-a284-4602-bf49-b6058ecb5aec 2011-09-20 18:07:11.695 EDT 808e3725-2a08-4907-9706-fb7f0f08f62f 2010-07-13 06:20:05.749 EDT 8614acc8-2995-4e53-bd62-648b50b7dfe0 2011-09-21 12:28:30.408 EDT 5b1cd4bb-5a76-4d54-9a0a-5406764c5a71 2011-09-20 18:00:09.798 EDT cf60043b-e08a-49d7-a150-711f413d3d18 2010-07-07 17:52:10.583 EDT 84516d8e-7110-4c0a-837b-f0113108e9fb 2011-09-20 20:28:02.524 EDT 4462bd43-bcec-4aaf-83e5-64e111668a64 2010-07-07 18:00:20.619 EDT 14724df6-fee6-4b24-8fbc-eeeeb3dc4e61 2010-07-07 11:38:21.137 EDT 24094c75-3f98-4c47-9260-6932f4515108 2011-09-20 18:08:40.157 EDT e10bf43c-7595-4190-9936-1161368c4ac2 2011-09-20 14:04:39.852 EDT aa304a23-2105-46b3-94b4-54ffe9548f76 2011-09-20 18:12:50.57 EDT e77e78ad-0601-4fbb-b6e8-c457a26456d6 2011-09-20 17:24:53.258 EDT 812e7abc-4866-43dc-b9d4-44370a399e4e 2010-07-07 12:23:44.739 EDT 980d729b-1ec7-492c-9dfd-ccb19f9e81a7 2010-07-07 17:59:09.755 EDT 6f16e5e6-7e90-44af-9e7a-f63785e5408e 2010-07-07 17:53:58.943 EDT 6e069c36-8d88-4017-96cf-c1fa87007777 2010-07-07 11:20:48.694 EDT a752e401-77c5-42ef-9bf8-a60aa8af73f5 2010-07-07 17:50:42.557 EDT 73ce4e99-6b83-45d0-8605-896d6d48b7f0 2010-07-07 12:01:14.713 EDT 1d3f0068-fe25-47b8-9228-8331aa8fcc7f 2011-09-20 13:46:26.611 EDT 71dbda93-b6ae-4bbe-ba51-d084571e7cde 2011-09-20 17:54:50.665 EDT 2c38c008-1b1f-4679-b1be-c30b3e03eb57 2011-09-20 23:43:47.695 EDT d8b96d03-8431-4cc0-b032-51e0c32092d3 2010-07-07 12:27:09.166 EDT d533c230-a40d-4f9b-9ad4-f4389d4a6f1f 2010-07-07 11:00:00.482 EDT Based on Spreadsheet Import Example by David WithersSusan Example using the SpreadsheetImport service to import data from an Excel spreadsheet. The workflow imports the file spreadsheet file WaterUse.xlsx and generates a graph from the date. The source data is from http://data.gov.uk/ 2011-09-21 12:27:18.65 EDT 41265789-c464-4ee2-b145-95ece9388305 2010-07-07 17:34:29.364 EDT 7d1166bd-dfa5-4675-918c-a880314302cb 2010-07-07 11:04:08.606 EDT a5bbe32f-ad20-4411-bc0e-d8f693e95493 2010-07-07 17:55:54.366 EDT fc31f7c0-0a66-4822-aebb-a03e4de7a19c 2011-09-20 14:02:24.114 EDT 9c2e4b9c-5f25-4416-8653-cd9198a9271e 2010-07-13 06:19:30.143 EDT ace630aa-1764-4175-b048-9c69ffe4374a 2011-09-20 18:03:03.74 EDT cca71cbe-6d97-4896-90c2-d91016f12882 2010-07-07 17:45:31.148 EDT 70c23010-0b47-424e-a1ce-73c040c3d3c6 2010-07-07 11:43:47.690 EDT 64332e24-f1d5-480d-ae0e-3c186b2d61f7 2011-09-20 17:30:42.764 EDT 9a2e5f63-ee29-42f3-810e-dc54fa9dfe3c 2010-07-07 11:59:16.81 EDT 30c2f2c6-dbd5-4e7a-9620-f6e8526fb9bc 2010-07-07 18:04:59.33 EDT 6622310c-9440-45a1-a051-729487b00b46 2010-07-13 07:32:33.863 EDT cc028740-f19a-4aa9-a30e-97c6845e8e98 2011-09-20 13:43:02.437 EDT 8af7971d-f944-4f27-b62a-437be1b99d3c 2010-07-07 11:07:29.140 EDT cee35c36-afaf-4093-bcc5-eaac292207f5 2010-07-07 11:02:30.469 EDT e28f14b3-e4ae-4d0b-893d-3a8400625069 2010-07-07 11:10:13.994 EDT 23eec6e0-9a32-461c-bd90-ba03bdc49d41 2010-07-07 12:25:28.613 EDT d7b392df-98fc-4a46-befb-53f9bedf0214 2011-09-20 13:55:40.119 EDT 92d8fa84-2553-4de1-bff5-7d2a9b53c58d 2010-07-07 12:31:19.499 EDT 2c1532f6-0ba4-48ea-9bf4-3fd3e39c6289 2010-07-07 09:00:56.585 EDT 5f61cecc-3f74-493d-8da0-e0be52641644 2011-09-20 13:58:24.16 EDT 64b51b72-af09-4842-b034-293dee7a03ff 2010-07-07 17:40:56.858 EDT Susan Borda 2011-09-21 12:27:25.348 EDT b4363407-ef56-4cf3-998f-8e780a8dc816 2010-07-07 11:41:31.230 EDT 99e82825-40e1-4fa9-8cf4-5348a8ff7b82 2010-07-07 17:38:24.439 EDT 31ac21d6-7c10-48ff-b9b2-82cac03f55c9 2010-07-07 17:43:05.458 EDT f0fe1955-23d6-41b7-b1af-b36d641429b4 2010-07-07 12:24:52.98 EDT 1c26bdac-0a69-4601-bd98-213586131c4b 2011-09-20 17:56:00.404 EDT 6c2a0ecf-5d91-4722-adf6-607c912ed54c 2010-07-07 11:54:20.460 EDT fab0b04d-ffde-4c0a-abce-c7031a47ae01 2011-09-20 18:14:57.690 EDT 486a5356-0f3e-424d-b14e-249295875f2d 2010-07-13 07:31:34.664 EDT 73c1ceb9-5c93-4082-b8f5-9c8d35ff695a 2011-09-20 17:23:59.374 EDT