edg import xlsx

27 views
Skip to first unread message

Bohms, H.M. (Michel)

unread,
Sep 22, 2021, 5:45:48 AM9/22/21
to topbrai...@googlegroups.com

Trying to find my way in edg wrt the excel stuff

 

I imported by target (multiclass) ontology and now wanted to import the one table sheet:

 

Why can I not click “ Finish”?

 

Thx Michel

 

 

Dr. ir. H.M. (Michel) Bohms
Scientist Specialist
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

unread,
Sep 22, 2021, 6:26:45 AM9/22/21
to topbrai...@googlegroups.com
The message tells you “No templates have been installed yet”.

Best read and understand the process:


“using Templates” must first be done with “using Patterns”.

Cheers,
David

On 22 Sep 2021, at 10:45, 'Bohms, H.M. (Michel)' via TopBraid Suite Users <topbrai...@googlegroups.com> wrote:

Trying to find my way in edg wrt the excel stuff
 
I imported by target (multiclass) ontology and now wanted to import the one table sheet:
<image001.png>
 
Why can I not click “ Finish”?
 
Thx Michel
 
 
Dr. ir. H.M. (Michel) Bohms
Scientist Specialist
Structural Reliability
T +31 (0)88 866 31 07
M +31 (0)63 038 12 20
E michel...@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 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/a52355aeac7442a99686b4c12628cf14%40tno.nl.


Bohms, H.M. (Michel)

unread,
Sep 22, 2021, 7:54:39 AM9/22/21
to topbrai...@googlegroups.com

Ok, sorry

 

In TBC the template seems optional so I assumed etc.

Also learned that all TBC-automatic imports now need manual action…

 

Furthermore it says:

 

 

Wrt qudt: they are all online accessible, or is this another meaning for EDG?

Wrt:shacl: I would not expect this warning from a shacl-based platform…

 

But ok, I’ll try to further learn edg ….

 

Gr michel

 

 

Dr. ir. H.M. (Michel) Bohms
Scientist Specialist
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.

Bohms, H.M. (Michel)

unread,
Sep 22, 2021, 8:26:50 AM9/22/21
to topbrai...@googlegroups.com

Ok, I tried Import by Pattern

 

But then I get:

 

 

So, it does not takes, as with TBC, the worksheet name as enity type, but it expects a type already available…

 

AS I would like the system to generate the ontology from the first row…what is the minimum I have to do now?

 

 

Is it true that there is no ontology generation here because:

“ Each row in the spreadsheet will be brought into EDG as an instance of the selected class “

 

So:

  1. Each row….also the first rows typically having the attribute names
  2. Selected class, so there should be one to select already……

 

It feels like:

You have to define the ontology yourself now. And just import the DATA rows….

Please confirm, thx

 

 

Dr. ir. H.M. (Michel) Bohms
Scientist Specialist
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

unread,
Sep 22, 2021, 8:38:43 AM9/22/21
to topbrai...@googlegroups.com
The entity type is the class in the ontology that the importer will make instances of. The current EDG graph must have an ontology in its settings/includes. That’s what the documentation means:

The Entity type for the imported data field identifies what type of assets you will be importing. Each row in the spreadsheet will be brought into EDG as an instance of the selected class and you will be able to map spreadsheet columns to the declared properties of the class.

FWIW if you create an EDG Ontologies first, you will find this which does generate the properties required, just not the class itself:

If you do not yet have a suitable target class: To import property definitions from a spreadsheet, create or select a class in the Ontology editor, then use Modify > Add property shapes from Spreadsheet columns...

Cheers,
David

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

Ok, I tried Import by Pattern
 
But then I get:
 
<image002.png>
 
So, it does not takes, as with TBC, the worksheet name as enity type, but it expects a type already available…
 
AS I would like the system to generate the ontology from the first row…what is the minimum I have to do now?
 
 
Is it true that there is no ontology generation here because:
“ Each row in the spreadsheet will be brought into EDG as an instance of the selected class “
 
So:
  1. Each row….also the first rows typically having the attribute names
  2. Selected class, so there should be one to select already……
 
It feels like:
You have to define the ontology yourself now. And just import the DATA rows….
Please confirm, thx
 
 
Dr. ir. H.M. (Michel) Bohms
Scientist Specialist
Structural Reliability
T +31 (0)88 866 31 07
M +31 (0)63 038 12 20
E michel...@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: 'Bohms, H.M. (Michel)' via TopBraid Suite Users <topbrai...@googlegroups.com> 
Sent: Wednesday, September 22, 2021 1:55 PM
To: topbrai...@googlegroups.com
Subject: RE: [topbraid-users] edg import xlsx
 
Ok, sorry
 
In TBC the template seems optional so I assumed etc.
Also learned that all TBC-automatic imports now need manual action…
 
Furthermore it says:
 
<image006.png>
 
Wrt qudt: they are all online accessible, or is this another meaning for EDG?
Wrt:shacl: I would not expect this warning from a shacl-based platform…
 
But ok, I’ll try to further learn edg ….
 
Gr michel
 
 
Dr. ir. H.M. (Michel) Bohms
Scientist Specialist
Structural Reliability
T +31 (0)88 866 31 07
M +31 (0)63 038 12 20
E michel...@tno.nl

Bohms, H.M. (Michel)

unread,
Sep 22, 2021, 8:44:37 AM9/22/21
to topbrai...@googlegroups.com

Ok my idea:

 

In TBC i import the xlsx (semantic table variant)

Then I export a ttl for it

 

I strip the data off, leaving only the one class and column properties

 

I import this one in edg

 

Then I can do import by by pattern

 

Selecting the one class (and prob. the attributes in the mapping…).

 

Strange idea?

 

 

Dr. ir. H.M. (Michel) Bohms
Scientist Specialist
Structural Reliability

T +31 (0)88 866 31 07
M +31 (0)63 038 12 20
E michel...@tno.nl

Location

 

David Price

unread,
Sep 22, 2021, 8:49:29 AM9/22/21
to topbrai...@googlegroups.com
I’ve never tried that, but may work.

Cheers,
David

On 22 Sep 2021, at 13:44, 'Bohms, H.M. (Michel)' via TopBraid Suite Users <topbrai...@googlegroups.com> wrote:

Ok my idea:
 
In TBC i import the xlsx (semantic table variant)
Then I export a ttl for it
 
I strip the data off, leaving only the one class and column properties
 
I import this one in edg
 
Then I can do import by by pattern
 
Selecting the one class (and prob. the attributes in the mapping…).
 
Strange idea?
 
 
Dr. ir. H.M. (Michel) Bohms
Scientist Specialist
Structural Reliability
T +31 (0)88 866 31 07
M +31 (0)63 038 12 20
E michel...@tno.nl

Bohms, H.M. (Michel)

unread,
Sep 23, 2021, 5:37:10 AM9/23/21
to topbrai...@googlegroups.com

Worked perfectly. Thx.

So my translation (you call conversion) is now working fine.

I can read all spreadsheet data acc. to the defined simple spreadsheet ontology.

 

Next step is the data transformation to the target ontology ….

Involving the URI creation etc.

Guess will need some study/advice ….

 

 

Dr. ir. H.M. (Michel) Bohms
Scientist Specialist
Structural Reliability

T +31 (0)88 866 31 07
M +31 (0)63 038 12 20
E michel...@tno.nl

Location

 

Reply all
Reply to author
Forward
0 new messages