Semantic tables use the spreadsheet ontology which is actually not so semantic….
I used to work in edg for this which is unfort. no longer possible with 7.1. I will experiment via: Import .txt in excel, add first id column, and export as tab-delimited txt again…..and import into TBC Thx Michel Michel Böhms Data Scientist Unit Buildings, Infrastructure & Maritime Mobile +31 630381220 E-mail [email protected]<mailto:[email protected]> Location<http://www.tno.nl/locations/DTS> [cid:[email protected]]<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: [email protected] <[email protected]> On Behalf Of David Price Sent: dinsdag 8 maart 2022 23:12 To: [email protected] Subject: Re: [topbraid-users] spreadsheet import issue in tbc I don’t think anyone in TQ has used this in years, so doubt anyone can offer advice. I have used the Semantic Spreadsheet approach where the Excel content is visible as triples and then you can process them using SPARQL/SPIN/SHACL rules, so guess I’d recommend trying that. Cheers, David On 8 Mar 2022, at 21:00, 'Bohms, H.M. (Michel)' via TopBraid Suite Users <[email protected]<mailto:[email protected]>> wrote: Finally I see the special character replacement is not as expected: https://w3id.org/rekkeninput#_14-06-2021T14:_41:_27.210 rdf:type ri:Meting ; ri:out_1 "-34.64"^^xsd:double ; ri:out_10 "-15.99"^^xsd:double ; ri:out_11 "-0.94"^^xsd:double ; so the : are not replaced by _ but just a _ is added ….. Michel Böhms Data Scientist Unit Buildings, Infrastructure & Maritime Mobile +31 630381220 E-mail [email protected]<mailto:[email protected]> 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: 'Bohms, H.M. (Michel)' via TopBraid Suite Users <[email protected]<mailto:[email protected]>> Sent: dinsdag 8 maart 2022 21:57 To: [email protected]<mailto:[email protected]> Subject: [topbraid-users] RE: spreadsheet import issue in tbc I did see in the help info: “In this case, the first column is not shown in the preview, because it contains the subjects”. So to get the first column also in the attribute data should I duplicate the first column as a new first say “id”? That is not a simple operation for a large existing tab-delimited text file….(without going into excel first). Michel Böhms Data Scientist Unit Buildings, Infrastructure & Maritime Mobile +31 630381220 E-mail [email protected]<mailto:[email protected]> 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: 'Bohms, H.M. (Michel)' via TopBraid Suite Users <[email protected]<mailto:[email protected]>> Sent: dinsdag 8 maart 2022 21:46 To: [email protected]<mailto:[email protected]> Subject: [topbraid-users] spreadsheet import issue in tbc I have a tab-delimted file with content like: Time out_1 out_2 out_3 out_4 out_5 out_6 out_7 out_8 out_9 out_10 out_11 out_12 out_13 out_14 out_15 out_16 out_17 out_18 out_19 out_20 out_21 14-06-2021T14:41:26.000 -0.00 -0.00 -0.00 -0.00 -0.00 -0.00 -0.00 -0.00 -0.00 -0.00 -0.00 -0.00 -0.00 -0.00 0.00 0.00 -0.00 -0.00 -0.00 -0.00 -0.00 14-06-2021T14:41:26.010 -0.21 -0.26 -0.07 -0. ……….. When I import the file (using tablimited spreadsheet import), the Time first column is skipped. This can already be seen in the preview: <image002.png> Since the dates have special characters (“:”) I did tick the box “replace special characters by _ “. The actual property Time is in the ontology as: ri:Time rdf:type owl:DatatypeProperty ; rdfs:domain ri:Meting ; rdfs:label "Time" ; rdfs:range xsd:string ; . In the next figure I replace the proposed Time for the class into ri:Meting. The instances and other attributes map fine, except Time. Any tip very much appreciated! Michel Michel Böhms Data Scientist Unit Buildings, Infrastructure & Maritime Mobile +31 630381220 E-mail [email protected]<mailto:[email protected]> 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. -- 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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/c28957b4e902496caea9505d07cf6a7c%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/c28957b4e902496caea9505d07cf6a7c%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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/9fc7f6c1da594687942771209560db06%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/9fc7f6c1da594687942771209560db06%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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/e2e195b443904924968745816248e3a6%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/e2e195b443904924968745816248e3a6%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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/4575BA23-E3A9-4D70-9D24-F172D9058746%40topquadrant.com<https://groups.google.com/d/msgid/topbraid-users/4575BA23-E3A9-4D70-9D24-F172D9058746%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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/7dbc08d8468a475ba8ab82fc470197a0%40tno.nl.
