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]> wrote: > > Finally I see the special character replacement is not as expected: > > https://w3id.org/rekkeninput#_14-06-2021T14:_41:_27.210 > <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]. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/4575BA23-E3A9-4D70-9D24-F172D9058746%40topquadrant.com.
