spreadsheet import issue

[Bohms, H.M. (Michel)]

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]

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

<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)]

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.

 

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/BD10F180-03B0-4A3A-95AE-5ABB33FB9746%40topquadrant.com.

[David Price]

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 Mobile +31 630381220 E-mail  michel...@tno.nl Location

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/c1761ef199de425ca416ccc070ed4da0%40tno.nl.

UK +44 (0) 7788 561308

US +1 (336) 283-0808‬

[Bohms, H.M. (Michel)]

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.

 

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/50796E15-1AB6-4622-AAEA-7E24810B5B9D%40topquadrant.com.

[David Price]

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 Mobile +31 630381220 E-mail  michel...@tno.nl Location

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/3c941c2239014c35b28e53a1db987915%40tno.nl.

UK +44 (0) 7788 561308

US +1 (336) 283-0808‬

[Bohms, H.M. (Michel)]

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.

 

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/A04959F4-E6AF-48BD-9BF2-DBE2BAADED6F%40topquadrant.com.

[Bohms, H.M. (Michel)]

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.

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/BD10F180-03B0-4A3A-95AE-5ABB33FB9746%40topquadrant.com.

[Holger Knublauch]

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 Mobile +31 630381220 E-mail  michel...@tno.nl Location

<image002.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.

<image003.png>

 

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/5a72d0ad11c14c78a8edf17ee03b235f%40tno.nl.

[Bohms, H.M. (Michel)]

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.

 

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/658C9F45-B437-4075-AC96-149BF2B82853%40topquadrant.com.