spreadsheet import issue

12 views
Skip to first unread message

Bohms, H.M. (Michel)

unread,
Sep 15, 2022, 6:31:26 AMSep 15
to topbrai...@googlegroups.com

In the past I used Import “Spreadsheet using Pattern” in EDG co-delivered with TBC.

 

I cannot see how I can do the same now in latest TBC-only.

 

Can you advice me?

(excel import to spreadsheet ontology is not useful)

 

We have some follow up work where we need to redo/update this same process for a client.

 

Thx Michel

 

 

 

Michel Böhms
Data Scientist

Unit Buildings, Infrastructure & Maritime


Mobile +31 630381220
E-mail  
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.

 

 

 

Holger Knublauch

unread,
Sep 15, 2022, 6:47:36 AMSep 15
to topbrai...@googlegroups.com
There is IMHO no comparable feature in TBC-only.

Holger


On 15 Sep 2022, at 12:31 pm, 'Bohms, H.M. (Michel)' via TopBraid Suite Users <topbrai...@googlegroups.com> wrote:

In the past I used Import “Spreadsheet using Pattern” in EDG co-delivered with TBC.
 
I cannot see how I can do the same now in latest TBC-only.
 
Can you advice me?
(excel import to spreadsheet ontology is not useful)
 
We have some follow up work where we need to redo/update this same process for a client.
 
Thx Michel
 
 
 
Michel Böhms
Data Scientist
Unit Buildings, Infrastructure & Maritime
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.
 
<image002.png>
 
 

-- 
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/f7df3933174346d6a203ea0c947b7a85%40tno.nl.

Bohms, H.M. (Michel)

unread,
Sep 15, 2022, 7:17:55 AMSep 15
to topbrai...@googlegroups.com

That is really a pity.

 

Could I somehow be able to use an old free version or doesn’t it have edg/excellimport.

 

 

 

Michel Böhms
Data Scientist

Unit Buildings, Infrastructure & Maritime


Mobile +31 630381220
E-mail  
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

unread,
Sep 15, 2022, 7:21:47 AMSep 15
to topbrai...@googlegroups.com
No EDG in free. There are plenty of ss to rdf tools around though, so probably best use one of them.

On 15 Sep 2022, at 12:17, 'Bohms, H.M. (Michel)' via TopBraid Suite Users <topbrai...@googlegroups.com> wrote:

That is really a pity.
 
Could I somehow be able to use an old free version or doesn’t it have edg/excellimport.
 
 
 
Michel Böhms
Data Scientist
Unit Buildings, Infrastructure & Maritime

Bohms, H.M. (Michel)

unread,
Sep 15, 2022, 7:26:51 AMSep 15
to topbrai...@googlegroups.com

Any advice for such a tool (doing the same as the earlier “import by pattern”) would be really appreciated.

 

Ps still remembering earlier TQ mails advising not to use TBC-import (unstable, not maintained) but to use the EDG-variants which were up-to-date etc.). But ok, won’t go further on that…think we passed that station with 7.1

 

 

 

Michel Böhms
Data Scientist

Unit Buildings, Infrastructure & Maritime


Mobile +31 630381220
E-mail  
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

unread,
Sep 15, 2022, 7:42:25 AMSep 15
to topbrai...@googlegroups.com
I think RML is popular

On 15 Sep 2022, at 12:26, 'Bohms, H.M. (Michel)' via TopBraid Suite Users <topbrai...@googlegroups.com> wrote:

Any advice for such a tool (doing the same as the earlier “import by pattern”) would be really appreciated.
 
Ps still remembering earlier TQ mails advising not to use TBC-import (unstable, not maintained) but to use the EDG-variants which were up-to-date etc.). But ok, won’t go further on that…think we passed that station with 7.1
 
 
 
Michel Böhms
Data Scientist
Unit Buildings, Infrastructure & Maritime

Bohms, H.M. (Michel)

unread,
Sep 15, 2022, 8:14:51 AMSep 15
to topbrai...@googlegroups.com

Thx, will study https://rml.io/

 

 

 

Michel Böhms
Data Scientist

Unit Buildings, Infrastructure & Maritime


Mobile +31 630381220
E-mail  
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.

 

 

Bohms, H.M. (Michel)

unread,
Sep 15, 2022, 11:30:00 AMSep 15
to topbrai...@googlegroups.com

Hi Holger

 

I see that I can just open the excel file in tbc (no import but just doubleclick)!!

 

Resulting in what I need:

 

 

And all properties and instances….

 

 

Michel

 

 

 

Michel Böhms
Data Scientist

Unit Buildings, Infrastructure & Maritime


Mobile +31 630381220
E-mail  
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.

 

 

 

From: topbrai...@googlegroups.com <topbrai...@googlegroups.com> On Behalf Of Holger Knublauch
Sent: donderdag 15 september 2022 12:47
To: topbrai...@googlegroups.com
Subject: Re: [topbraid-users] spreadsheet import issue

 

There is IMHO no comparable feature in TBC-only.

Holger Knublauch

unread,
Sep 16, 2022, 1:43:49 AMSep 16
to topbrai...@googlegroups.com
This is the Semantic Tables loader which does a simple mapping from spreadsheet columns to properties that are generated on the fly. This however is only the very first, basic step in spreadsheet importers. The EDG importer generates SPARQL/SPIN rules that perform the further processing into the target ontology and also supports various tree patterns out of the box.

Holger



On 15 Sep 2022, at 5:29 pm, 'Bohms, H.M. (Michel)' via TopBraid Suite Users <topbrai...@googlegroups.com> wrote:

Hi Holger
 
I see that I can just open the excel file in tbc (no import but just doubleclick)!!
 
Resulting in what I need:
 
<image001.png>
 
And all properties and instances….
 
 
Michel
 
 
 
Michel Böhms
Data Scientist
Unit Buildings, Infrastructure & Maritime
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.
 
<image003.png>
 

Bohms, H.M. (Michel)

unread,
Sep 16, 2022, 3:19:45 AMSep 16
to topbrai...@googlegroups.com

Sufficient for me since I had already 2 ontologies: one basic one to import to and a final more structured one where I map to via shacl rules. The first ontology is now generated on the fly.

Only the same property’s for diff classses are now generated PER tab (manually I had only one with a union of 3 domains) so I have to adapt my where clauses of the shacl rules mapping into my final ontology.

 

thx

 

 

 

Michel Böhms
Data Scientist

Unit Buildings, Infrastructure & Maritime


Mobile +31 630381220
E-mail  
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.

 

 

Reply all
Reply to author
Forward
0 new messages