Hi Scott, I have played with SpinMap a few times. It looks like a great feature however the times that I have looked to use it, I found that I was unable to get it to achieve what I was after and a CONSTRUCT query worked better in these cases. Having said that, It may have been that the limitation was self inflicted due to my limit experience using SpinMap.
Regards, Mark. On Sat, Oct 6, 2012 at 12:37 AM, Scott Henninger <[email protected] > wrote: > Mark, have you looked into SPINMap? This is really a nice way to > perform transforms from one data format to another. Very useful for > spreadsheets in particular. I think you will find this help file useful: > Help > Application Development Tools > SPIN > Ontology Mapping with > SPINMap > > -- Scott > > On 10/4/2012 12:03 AM, Mark Colquhoun wrote: > > Hi Irene, > > Thanks for the detailed response. I did mention that I was reading from > an Excel spreadsheet but it was probably hidden deep in a previous post. > > Based on the example I gave, I am reading data from a spreadsheet, > performing a substring operation on one of the columns. From there, I need > to identify the distinct values from this operation and create a new type > of thing by constructing new triples where the distinct value is used to > build the subject URI for the new triples. > > I have been using SM for a while and now and have had reasonable success > however this problem has got me stumped probably because it requires me to > use a new feature that I haven't previously used. > > Regards, > Mark. > > > On Thu, Oct 4, 2012 at 2:20 PM, Irene Polikoff <[email protected]>wrote: > >> To add to Scott's reply, pretty much every SM module does one of the >> following: >> >> 1. Adds more triples into the pipeline (e.g., modules that import (load) >> RDF >> files or files that are auto-converted to RDF such as XML) >> 2. Establishes connection to external sources of triples (e.g., modules >> that >> connect to RDF databases, they are call "import" as well, but they just >> establish connection, they don't actually add triples from the external >> source into the pipeline) >> 3. Performs some processing based on triples that are passed to them as an >> input a) through the pipeline or b) from an external source (e.g, module >> that converts RDF to XML) >> 4. Does both 1 and 3 (e.g., inferencing modules or perform SPARQL update >> module) >> 5. Controls the processing (e.g., iterate over select) >> 6. Exports the results (e.g, all the "return" modules) >> >> Thus, a question to ask is what do you want to happen as a result of the >> select query? Depending on the answer, you may or may not need to run the >> select. Are you trying to return some RDF as a web service, for example? >> Then you don't really need the select query. Instead, you get to the point >> where the pipeline contains only the triples you want to return and the >> return module would return all of them. >> >> If you do need a select query and want to see modules that have it as a >> parameter, open your script, navigate to sml:selectQuery and see all the >> places it is referenced. >> >> Regards, >> >> Irene >> >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On Behalf Of Scott Henninger >> Sent: Wednesday, October 03, 2012 6:06 PM >> To: TopBraid Suite Users >> Subject: [topbraid-users] Re: SPARQLMotion Distinct >> >> Mark; Most SPARQLMotion modules include a query property. Some >> examples - that you can download - are found at >> >> http://www.topquadrant.com/products/SPARQLMotion_docs/SPARQLMotion_ex_dbpedi >> aCapitals.html<http://www.topquadrant.com/products/SPARQLMotion_docs/SPARQLMotion_ex_dbpedi%0AaCapitals.html> >> . >> >> I'd also suggest spending some time with the SPARQLMotion home page >> (http://www.topquadrant.com/products/SPARQLMotion.html) and the >> Getting Started Guide, Tutorial, and Videos provided on that page. >> >> Beyond that, if you have a more specific place you were looking to >> "use in a SPARQLMotion script to perform a SELECT query", let us >> know. A hint: IterateOverSelect is needed less often than one would >> initially believe because SPARQL's declarative nature take care of >> iteratively finding results. >> >> -- Scott >> >> On Oct 3, 3:02 pm, Mark Colquhoun <[email protected]> >> wrote: >> > Hi Scott, >> > >> > Yes that will work but I guess I'm missing something as I couldn't see >> > which module I could use in a SPARQLMotion script to perform a SELECT >> query >> > apart from an Iterate Over Select? >> > >> > Regards, >> > Mark. >> > >> > >> > >> > >> > >> > >> > >> > On Thursday, October 4, 2012 12:11:28 AM UTC+10, Scott Henninger wrote: >> > >> > > Will SELECT DISTINCT ?substr work? If not, we will need more >> > > information on what your queries and script look like, etc. >> > >> > > -- Scott >> > >> > > On Oct 2, 11:50 pm, Mark Colquhoun <[email protected]> >> > > wrote: >> > > > Hi, >> > >> > > > Within a SPARQLMotion script, I need to read a spreadsheet and find >> the >> > > > distinct values in a column based on a substring performed on the >> > > column. I >> > > > can do all of this except the distinct part and am looking for some >> > > > pointers. An example of the data might be: >> > >> > > > AI4120_0306_cH >> > > > AI4120_0306_cHH >> > > > AIC4120_0042_cSP >> > > > AIC4120_0042_sCV >> > >> > > > From these values, I want to create a substring including everything >> to >> > > the >> > > > left of the last _. >> > >> > > > AI4120_0306 >> > > > AI4120_0306 >> > > > AIC4120_0042 >> > > > AIC4120_0042 >> > >> > > > Easy enough so far but from here I want to select the distinct >> values. >> > > I'm >> > > > sure this should be easy but I haven't been able to find any build >> in >> > > > functionality to achieve this. The end result that am after should >> look >> > > > like: >> > >> > > > AI4120_0306 >> > > > AIC4120_0042 >> > >> > > > I'm sure there is something that I am overlooking so any help would >> be >> > > > greatly appreciated. >> > >> > > > Regards, >> > > > Mark. >> >> -- >> -- 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 Ensemble, SPARQLMotion, SPARQL Web Pages 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 >> >> >> -- >> -- 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 Ensemble, SPARQLMotion, SPARQL Web Pages 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 >> >> >> > -- > -- 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 Ensemble, SPARQLMotion, SPARQL Web Pages 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 > > > > > -- > -- 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 Ensemble, SPARQLMotion, SPARQL Web Pages 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 > > > -- -- 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 Ensemble, SPARQLMotion, SPARQL Web Pages 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
