spreadsheet import issue in tbc

22 views
Skip to first unread message

Bohms, H.M. (Michel)

unread,
Mar 8, 2022, 3:46:12 PM3/8/22
to topbrai...@googlegroups.com

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:

 

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...@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,
Mar 8, 2022, 3:57:30 PM3/8/22
to topbrai...@googlegroups.com

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).

--
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/c28957b4e902496caea9505d07cf6a7c%40tno.nl.

Bohms, H.M. (Michel)

unread,
Mar 8, 2022, 4:00:07 PM3/8/22
to topbrai...@googlegroups.com

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 …..

David Price

unread,
Mar 8, 2022, 5:11:47 PM3/8/22
to topbrai...@googlegroups.com
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 <topbrai...@googlegroups.com> wrote:

Finally I see the special character replacement is not as expected:
 
  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
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: dinsdag 8 maart 2022 21:57
To: topbrai...@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
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: dinsdag 8 maart 2022 21:46
To: topbrai...@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:
<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
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/c28957b4e902496caea9505d07cf6a7c%40tno.nl.
-- 
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/9fc7f6c1da594687942771209560db06%40tno.nl.

-- 
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.

Bohms, H.M. (Michel)

unread,
Mar 8, 2022, 5:19:36 PM3/8/22
to topbrai...@googlegroups.com

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  michel...@tno.nl

Location

 

Bohms, H.M. (Michel)

unread,
Mar 9, 2022, 2:56:43 AM3/9/22
to topbrai...@googlegroups.com

Hi David

 

Importing in excel, adding an extra first id column (with ids: 1,2,3,4..) and exporting again in tab-delim. txt solved the tab-delim. txt import issue:

 

And on the fly also the special character issue since now the : cause no harm in the text attribute anymore.

 

Also the subsequent shacl-af rules towards W3C SSSN/SOSA goes flawless.

 

 

Thx for your support David!

 

Seems I can still do a lot of my former TBC-EDG stuff in TBC7.1-only! (phew)

 

Michel

 

 

Michel Böhms
Data Scientist

Unit Buildings, Infrastructure & Maritime


Mobile +31 630381220
E-mail  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.

 

 


Sent: dinsdag 8 maart 2022 23:12
To: topbrai...@googlegroups.com

Reply all
Reply to author
Forward
0 new messages