Yes, tabular spreadsheet import approach should do what Michel is asking for more details are available in the Help found under: TopBraid Composer <http://127.0.0.1:57301/help/nav/2> > Importing Data Sources <http://127.0.0.1:57301/help/nav/2_5> > Import external information <http://127.0.0.1:57301/help/topic/org.topbraidcomposer.core/html/Import_ext ernal_information.htm> > Import Spreadsheets <http://127.0.0.1:57301/help/topic/org.topbraidcomposer.core/html/Spreadshee t_Import_Overview.htm> >Import Tab-Separated Spreadsheets.
Irene Polikoff From: David Price <[email protected]> Reply-To: <[email protected]> Date: Tuesday, September 29, 2015 at 9:30 AM To: <[email protected]> Subject: Re: [topbraid-users] smart import excel The white paper is a good summary of current capability, so when it says ³No control over URI generation² for Semantic Tables it means what it says. However, TSVs has some supported mapping capabilities, but then it¹s one file (i.e. sheet) at a time so there are trade-offs. FWIW when I need specific column(s) to be made part of the URI of instances, I typically just use TBC to triplize the ³dumb" data then SPIN to make semantic sense of the data based on an ontology I created that¹s an improvement over the spreadsheet itself. That works all the time, not just specific cases where it happens that the first column is a unique Id. Cheers, David > On 29 Sep 2015, at 13:23, Bohms, H.M. (Michel) <[email protected]> wrote: > > Thx looking into that esp. semantic tables > > Anyway to let it use first column as individual names iso ³rowx²? > > > Dr. ir. H.M. (Michel) Bohms > Sr. Research Scientist > Structural Reliability > T +31 (0)88 866 31 07 > M +31 (0)63 038 12 20 > E [email protected] <mailto:[email protected]> > Location <http://www.tno.nl/locaties/DTM> > > > <image001.gif> <http://www.tno.nl/> > This message may contain information that is not intended for you. If you are > not the addressee or if this message was sent to you by mistake, you are > requested to inform the sender and delete the message. TNO accepts no > liability for the content of this e-mail, for the manner in which you use it > and for damage of any kind resulting from the risks inherent to the electronic > transmission of messages. > > From: [email protected] [mailto:[email protected]] > On Behalf Of David Price > Sent: dinsdag 29 september 2015 13:14 > To: [email protected] > Subject: Re: [topbraid-users] smart import excel > > Best thing to do is see a recent white paper > > http://www.topquadrant.com/knowledge-assets/whitepapers/ > > Using TopBraid to Work with Spreadsheet Data > > Cheers, > David > > > >> On 29 Sep 2015, at 12:00, Bohms, H.M. (Michel) <[email protected]> wrote: >> >> When importing an .xlsx the result is data under a generic worksheet schema. >> What I would like is that the data becomes individuals under some class >> (maybe controlled by first row) >> >> Does TBC support this some way? >> >> e.g. >> >> 1. one column >> >> Device >> D1 >> D2 >> D3 >> >> >> Where Device becomes class and Dx becomes instance. >> >> Or 2. >> Multiple column where each row becomes complex instance >> >> Thx Michel >> >> >> Dr. ir. H.M. (Michel) Bohms >> Sr. Research Scientist >> Structural Reliability >> T +31 (0)88 866 31 07 >> M +31 (0)63 038 12 20 >> E [email protected] <mailto:[email protected]> >> Location <http://www.tno.nl/locaties/DTM> >> >> >> <image001.gif> <http://www.tno.nl/> >> This message may contain information that is not intended for you. If you are >> not the addressee or if this message was sent to you by mistake, you are >> requested to inform the sender and delete the message. TNO accepts no >> liability for the content of this e-mail, for the manner in which you use it >> and for damage of any kind resulting from the risks inherent to the >> electronic transmission of messages. >> >> >> -- >> You received this message because you are subscribed to the Google Group >> "TopBraid Suite Users", the topics of which include Enterprise Vocabulary >> Network (EVN), Reference Data Manager (RDM), TopBraid Composer, TopBraid >> Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. >> To post to this group, send email to [email protected] >> <mailto:[email protected]> >> --- >> 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 [email protected] >> <mailto:[email protected]> . >> For more options, visit https://groups.google.com/d/optout >> <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), Reference Data Manager (RDM), TopBraid Composer, TopBraid >> Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. >> To post to this group, send email to [email protected] >> <mailto:[email protected]> >> --- >> 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 [email protected]. >> 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), Reference Data Manager (RDM), TopBraid Composer, TopBraid >> Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. >> To post to this group, send email to [email protected] >> --- >> 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 [email protected]. >> 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), Reference Data Manager (RDM), TopBraid Composer, TopBraid Live, > TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. > To post to this group, send email to [email protected] > --- > 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 [email protected]. > 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), Reference Data Manager (RDM), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to [email protected] --- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
