smart import excel

[Bohms, H.M. (Michel)]

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 michel...@tno.nl Location   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.

 

[David Price]

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) <michel...@tno.nl> 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 michel...@tno.nl Location

<image001.gif>

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 topbrai...@googlegroups.com
--- 
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-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Bohms, H.M. (Michel)]

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 michel...@tno.nl Location

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.

[David Price]

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) <michel...@tno.nl> 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 michel...@tno.nl Location

[Irene Polikoff]

Yes, tabular spreadsheet import approach should do what Michel is asking for –  more details are available in the Help found under: TopBraid Composer > Importing Data Sources > Import external information > Import Spreadsheets>Import Tab-Separated Spreadsheets.

Irene Polikoff

[Bohms, H.M. (Michel)]

Thx Irene, I’ll also investigate THAT option, gr 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 michel...@tno.nl Location

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.