Thanks Irene. I'm going to import the spreadsheet as RDF so the column headings will come in as data properties.
On Aug 1, 9:26 pm, "Irene Polikoff" <[email protected]> wrote: > Have you tried simply opening your spreadsheet in TBC (by double clicking on > it)? > > Irene > > > > -----Original Message----- > From: [email protected] > > [mailto:[email protected]] On Behalf Of Karen Wright > Sent: Monday, August 01, 2011 1:40 PM > To: TopBraid Suite Users > Subject: [topbraid-users] How best to process spreadsheet cells in > SPARQLMotion (TBC ME Version: 3.5.1.v20110629-1105R)? > > What recommendations are there for processing through a 31 column > spreadsheet and pulling out the data properties? I have an imported > xls file with 31 columns of data and the ss: properties of cell, > column, row, cellContents, etc. > The first column, zero, contains the Department Name, the next column > contains the Department ID, etc. > SELECT * > WHERE { > ?ColumnHeading a ss:Cell . > ?ColumnHeading ss:column ?col . > ?ColumnHeading ss:cellContents ?ColumnValue . > FILTER (?col = "0"^^xsd:integer) . > } > Sample triple from the above SPARQL: > ColumnHeading = <@b549fb5:131851e0c2d:-101a> > Col = 0 > ColumnValue = PKPD > > SELECT * > WHERE { > ?ColumnHeading a ss:Cell . > ?ColumnHeading ss:column ?col . > ?ColumnHeading ss:cellContents ?ColumnValue . > FILTER (?col = "1"^^xsd:integer) . > } > Sample triple from the above SPARQL: > ColumnHeading = <@b549fb5:131851e0c2d:-1012> > Col = 1 > ColumnValue = 345 > > Here's part of my SPARQLMotion construct module. I'm looking for an > iterative way to process the spreadsheet so I don't have to build 31 > construct modules. > > CONSTRUCT { > :Dept a owl:Class . > :hasDeptName a owl:DatatypeProperty . > :hasDeptName rdfs:domain :Dept . > :hasDeptName rds:range xsd:string . > > ?deptUri a :Dept . > ?deptUri rdfs:label ?deptLabel . > ?deptUri :hasDeptName ?deptName . > } > WHERE { > ?ColumnHeading a ss:Cell . > ?ColumnHeading ss:column ?col . > ?ColumnHeading ss:cellContents ?deptName . > FILTER (?col = "0"^^xsd:integer) . > BIND (smf:buildURI("http://example.com/data#dept-{?1}";, ?deptName) > AS ?deptUri) . > BIND (smf:cast(fn:concat("Department ", ?deptName), xsd:string) > AS ?deptLabel) . > } > > Thanks, > Karen > > -- > You received this message because you are subscribed to the Google > Group "TopBraid Suite Users", the topics of which include TopBraid Composer, > TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. > To post to this group, send email to > [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group > athttp://groups.google.com/group/topbraid-users?hl=en- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en
