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.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> [cid:image001.gif@01D7B06F.5664E430]<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: topbraid-users@googlegroups.com <topbraid-users@googlegroups.com> On Behalf Of David Price Sent: Wednesday, September 22, 2021 2:49 PM To: topbraid-users@googlegroups.com Subject: Re: [topbraid-users] edg import xlsx 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 <topbraid-users@googlegroups.com<mailto:topbraid-users@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.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> <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: topbraid-users@googlegroups.com<mailto:topbraid-users@googlegroups.com> <topbraid-users@googlegroups.com<mailto:topbraid-users@googlegroups.com>> On Behalf Of David Price Sent: Wednesday, September 22, 2021 2:39 PM To: topbraid-users@googlegroups.com<mailto:topbraid-users@googlegroups.com> Subject: Re: [topbraid-users] edg import xlsx 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 <topbraid-users@googlegroups.com<mailto:topbraid-users@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.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> <image004.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: 'Bohms, H.M. (Michel)' via TopBraid Suite Users <topbraid-users@googlegroups.com<mailto:topbraid-users@googlegroups.com>> Sent: Wednesday, September 22, 2021 1:55 PM To: topbraid-users@googlegroups.com<mailto:topbraid-users@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.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> <image004.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: topbraid-users@googlegroups.com<mailto:topbraid-users@googlegroups.com> <topbraid-users@googlegroups.com<mailto:topbraid-users@googlegroups.com>> On Behalf Of David Price Sent: Wednesday, September 22, 2021 12:27 PM To: topbraid-users@googlegroups.com<mailto:topbraid-users@googlegroups.com> Subject: Re: [topbraid-users] edg import xlsx The message tells you “No templates have been installed yet”. Best read and understand the process: https://doc.topquadrant.com/7.0/importing/ “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 <topbraid-users@googlegroups.com<mailto:topbraid-users@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.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> <image002.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 Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-users+unsubscr...@googlegroups.com<mailto:topbraid-users+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/a52355aeac7442a99686b4c12628cf14%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/a52355aeac7442a99686b4c12628cf14%40tno.nl?utm_medium=email&utm_source=footer>. UK +44 (0) 7788 561308 US +1 (336) 283-0808 -- 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-users+unsubscr...@googlegroups.com<mailto:topbraid-users+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/274485AE-17D6-4902-BD76-C2B8003E8593%40topquadrant.com<https://groups.google.com/d/msgid/topbraid-users/274485AE-17D6-4902-BD76-C2B8003E8593%40topquadrant.com?utm_medium=email&utm_source=footer>. -- 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-users+unsubscr...@googlegroups.com<mailto:topbraid-users+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/897f7cf454a6413faecada7bc77d2e32%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/897f7cf454a6413faecada7bc77d2e32%40tno.nl?utm_medium=email&utm_source=footer>. -- 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-users+unsubscr...@googlegroups.com<mailto:topbraid-users+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/92a2c22fd91f4e53b5f73f6d5c569997%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/92a2c22fd91f4e53b5f73f6d5c569997%40tno.nl?utm_medium=email&utm_source=footer>. UK +44 (0) 7788 561308 US +1 (336) 283-0808 -- 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-users+unsubscr...@googlegroups.com<mailto:topbraid-users+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/36C87AE8-74F8-4455-971F-E89C53D1A591%40topquadrant.com<https://groups.google.com/d/msgid/topbraid-users/36C87AE8-74F8-4455-971F-E89C53D1A591%40topquadrant.com?utm_medium=email&utm_source=footer>. -- 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-users+unsubscr...@googlegroups.com<mailto:topbraid-users+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/9281599be2454b5990c3d47644deceb4%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/9281599be2454b5990c3d47644deceb4%40tno.nl?utm_medium=email&utm_source=footer>. UK +44 (0) 7788 561308 US +1 (336) 283-0808 -- 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-users+unsubscr...@googlegroups.com<mailto:topbraid-users+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/B8C55011-C1C7-459B-B4C8-CA939B5C1EB9%40topquadrant.com<https://groups.google.com/d/msgid/topbraid-users/B8C55011-C1C7-459B-B4C8-CA939B5C1EB9%40topquadrant.com?utm_medium=email&utm_source=footer>. -- 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-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/2f61eedcc67a420297cc54579067425a%40tno.nl.
