Re: [topbraid-users] Importing a Spreadsheet from a URL
Hi Tim, I cannot think of another solution out of the box. Importing Excel files indeed currently requires local files, not URLs. We could change that in a future version, or we could add a module to download any file into the workspace, but neither of that would help you short-term. Holger On 5/28/2014 6:37, Tim Smith wrote: Hi Mark, Thanks for the suggestion. The spreadsheet sitting at the end of the URL is an Excel 2003 spreadsheet file that I need to be able to convert into instances in the spreadsheet ontology. The import as text module will bring in the contents of the file and I can save it as an XLS into the workspace but the Import Excel Cell Instances module will not import the file. It fails with the error below. Is there another approach that I'm missing? It seems ideal if the Import Excel Cell Instances module could import directly from a URL. Thanks in advance for your help, Tim java.lang.reflect.InvocationTargetException at org.topbraidcomposer.sparqlmotion.actions.AbstractExecuteSPARQLMotionAction$1.run(AbstractExecuteSPARQLMotionAction.java:153) at org.topbraidcomposer.core.util.ThreadUtil$1$1.run(ThreadUtil.java:64) at java.lang.Thread.run(Unknown Source) Caused by: org.topbraid.spin.sparqlmotion.modules.SMException: Failed to load Excel file C:\Semantic Tools\TBC-Workspaces\TBC431-5-08-14\RMQ\Data\sharepointtest.xls at org.topbraid.spreadsheets.excel.module.ImportExcelCellInstancesModule.createGraph(ImportExcelCellInstancesModule.java:33) at org.topbraid.spin.sparqlmotion.modules.AbstractSMModule.getRDFOutput(AbstractSMModule.java:863) at org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.executeModule(ExecutionEngineImpl.java:178) at org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.execute(ExecutionEngineImpl.java:120) at org.topbraidcomposer.sparqlmotion.views.console.SPARQLMotionConsole.execute(SPARQLMotionConsole.java:79) at org.topbraidcomposer.sparqlmotion.actions.AbstractExecuteSPARQLMotionAction$1.run(AbstractExecuteSPARQLMotionAction.java:142) ... 2 more Caused by: jxl.read.biff.BiffException: Unable to recognize OLE stream at jxl.read.biff.CompoundFile.init(CompoundFile.java:116) at jxl.read.biff.File.init(File.java:127) at jxl.Workbook.getWorkbook(Workbook.java:221) at jxl.Workbook.getWorkbook(Workbook.java:198) at org.topbraid.spreadsheets.excel.module.ImportExcelCellInstancesModule.createGraph(ImportExcelCellInstancesModule.java:30) ... 7 more On Fri, May 23, 2014 at 12:52 PM, Mark Graham m...@topquadrant.com mailto:m...@topquadrant.com wrote: Hi Tim, An option to try - bring it in as a text file then use sml:ConvertSpreadsheetToRDF and function sml:ImportTextFromURL. Some details of these can be found in the help menu as well - sparqlmotion function library. Thanks, Mark Thanks, Mark Mark Graham TopQuadrant Support *PRODUCT SUPPORT:* supp...@topquadrant.com mailto:supp...@topquadrant.com http://www.topquadrant.com/products/support.html On Fri, May 23, 2014 at 8:29 AM, Tim Smith smith.ts...@gmail.com mailto:smith.ts...@gmail.com wrote: Hi, I have a need to import a spreadsheet into an SM script from a URL (it's sitting in a content management system) The spreadsheet needs to be imported using the Spreadsheet Ontology. The ImportRDFFromURL module does not support any structure other than RDF/XML and the sml:ImportExcelCellInstances module only works on files in the workspace so I'm at a loss as to how I can access a file sitting at the end of a URL. Thanks in advance for your input, Tim -- -- You received this message because you are subscribed to the Google Group TopBraid Suite Users, the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to topbraid-users@googlegroups.com mailto:topbraid-users@googlegroups.com To unsubscribe from this group, send email to topbraid-users+unsubscr...@googlegroups.com mailto:topbraid-users%2bunsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en --- You received this message because you are subscribed to the Google Groups TopBraid Suite Users group. To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-users+unsubscr...@googlegroups.com mailto:topbraid-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- -- You received this message because you are subscribed to the Google
[topbraid-users] Importing a Spreadsheet from a URL
Hi, I have a need to import a spreadsheet into an SM script from a URL (it's sitting in a content management system) The spreadsheet needs to be imported using the Spreadsheet Ontology. The ImportRDFFromURL module does not support any structure other than RDF/XML and the sml:ImportExcelCellInstances module only works on files in the workspace so I'm at a loss as to how I can access a file sitting at the end of a URL. Thanks in advance for your input, Tim -- -- You received this message because you are subscribed to the Google Group TopBraid Suite Users, the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to topbraid-users@googlegroups.com To unsubscribe from this group, send email to topbraid-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en --- You received this message because you are subscribed to the Google Groups TopBraid Suite Users group. To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [topbraid-users] Importing a Spreadsheet from a URL
Hi Tim, An option to try - bring it in as a text file then use sml:ConvertSpreadsheetToRDF and function sml:ImportTextFromURL. Some details of these can be found in the help menu as well - sparqlmotion function library. Thanks, Mark Thanks, Mark Mark Graham TopQuadrant Support *PRODUCT SUPPORT:* supp...@topquadrant.com http://www.topquadrant.com/products/support.html On Fri, May 23, 2014 at 8:29 AM, Tim Smith smith.ts...@gmail.com wrote: Hi, I have a need to import a spreadsheet into an SM script from a URL (it's sitting in a content management system) The spreadsheet needs to be imported using the Spreadsheet Ontology. The ImportRDFFromURL module does not support any structure other than RDF/XML and the sml:ImportExcelCellInstances module only works on files in the workspace so I'm at a loss as to how I can access a file sitting at the end of a URL. Thanks in advance for your input, Tim -- -- You received this message because you are subscribed to the Google Group TopBraid Suite Users, the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to topbraid-users@googlegroups.com To unsubscribe from this group, send email to topbraid-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en --- You received this message because you are subscribed to the Google Groups TopBraid Suite Users group. To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- -- You received this message because you are subscribed to the Google Group TopBraid Suite Users, the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to topbraid-users@googlegroups.com To unsubscribe from this group, send email to topbraid-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en --- You received this message because you are subscribed to the Google Groups TopBraid Suite Users group. To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.