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 michel.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> [cid:image001.gif@01D83337.DCE606B0]<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> Sent: dinsdag 8 maart 2022 21:57 To: topbraid-users@googlegroups.com 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 michel.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> [cid:image001.gif@01D83337.DCE606B0]<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: dinsdag 8 maart 2022 21:46 To: topbraid-users@googlegroups.com<mailto:topbraid-users@googlegroups.com> 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: [cid:image002.png@01D83337.DCE606B0] 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 michel.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> [cid:image001.gif@01D83337.DCE606B0]<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/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 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/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 topbraid-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/e2e195b443904924968745816248e3a6%40tno.nl.