third issue sheet import

[Bohms, H.M. (Michel)]

In excel i have 3 sheets

1 en 3 are empty, 2 is filled:

 

 

Result:

Data from sheet 2 is classified as sheet no 1 ..

 

 

Is this expected?

 

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

More info:

It only goes wrong when the first sheet is empty

If there is data classification is fine.

 

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

 

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

[Irene Polikoff]

Yes, index starts with 0

On Sep 16, 2021, at 10:23 AM, 'Bohms, H.M. (Michel)' via TopBraid Suite Users <topbrai...@googlegroups.com> wrote:



More info:

It only goes wrong when the first sheet is empty

If there is data classification is fine.

 

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

<image003.gif>

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.

 

Van: 'Bohms, H.M. (Michel)' via TopBraid Suite Users <topbrai...@googlegroups.com>
Verzonden: Thursday, September 16, 2021 12:54 PM
Aan: topbrai...@googlegroups.com
Onderwerp: [topbraid-users] third issue sheet import

 

In excel i have 3 sheets

1 en 3 are empty, 2 is filled:

 

<image004.png>

 

Result:

Data from sheet 2 is classified as sheet no 1 ..

 

<image005.png>

 

Is this expected?

 

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

<image003.gif>

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

[Bohms, H.M. (Michel)]

Ok, I put some fake data in this yet to fill sheet ….

 

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

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/8DBF0191-FD21-4AEE-B9D0-9464CF9EBBA5%40topquadrant.com.

[Irene Polikoff]

Just noticed your message that the 1st sheet is empty. 

This may be a reason as well. In some importers index starts with zero. In some, it starts with 1.

Overtime, several different spreadsheet importers were built. Based on our and customer’s experience with them, we are no longer actively maintaining spreadsheet import options unique to TBC. We discovered that no matter how much one tries, there will always be cases when a canned spreadsheet import does not do exactly what a user needs - because of how a particular spreadsheet is structured and the data in it  and/or because a canned import is not fully aligned with the user’s unique needs.

Spreadsheet importer available in EDG is under active maintenance. This is the only pre-canned option under active maintenance. All other options are as-is. For use cases that are outside of the current capabilities of that importer, we recommend and made available facilities for scripting a custom import as explained in https://www.datashapes.org/active/import.html#spreadsheets

Also see the video https://www.topquadrant.com/project/importing-data-using-active-data-shapes/

On Sep 16, 2021, at 11:25 AM, Irene Polikoff <ir...@topquadrant.com> wrote:

Yes, index starts with 0

[Bohms, H.M. (Michel)]

Hi Irene

 

Well the semantic import is working quite well for me.

(we generate standard/simple spreadsheets from existing PDFs)

 

The only two import-issues left now are:

 

·       Dots in numbers become commas

·       Dashes and underscores in attribute names disappear

 

Hope I can resolve/work around then then…….

 

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

 

Van: topbrai...@googlegroups.com <topbrai...@googlegroups.com> Namens Irene Polikoff
Verzonden: Thursday, September 16, 2021 5:40 PM
Aan: topbrai...@googlegroups.com
Onderwerp: Re: [topbraid-users] RE: third issue sheet import

 

Just noticed your message that the 1st sheet is empty. 

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/DE421DE1-5D21-4FAE-A2F0-823208A4A0AC%40topquadrant.com.

[Bohms, H.M. (Michel)]

Also in edg/import I see:

 

 

Why are the underscores deleted?  Some special reason?

 

And here the mu is also replaced by an M:

 

 

Some my issues seems more universal than just tbc-import 😊

 

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

 

Van: topbrai...@googlegroups.com <topbrai...@googlegroups.com> Namens Irene Polikoff

Verzonden: Thursday, September 16, 2021 5:40 PM
Aan: topbrai...@googlegroups.com
Onderwerp: Re: [topbraid-users] RE: third issue sheet import

 

Just noticed your message that the 1st sheet is empty. 

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/DE421DE1-5D21-4FAE-A2F0-823208A4A0AC%40topquadrant.com.

[Bohms, H.M. (Michel)]

Here you see my 2 issues in one:

 

As generated after edg/import:

 

smartasfalt:MonsterLaag-zanddriehoek500Μm180Μm

  a sh:PropertyShape ;

  sh:path smartasfalt:zanddriehoek500Μm180Μm ;

  sh:datatype xsd:double ;

  sh:maxCount 1 ;

  sh:name "zanddriehoek_500_µm_180_µm" ;

.

 

• In the name the mu is replaced by M
• In the name the underscores are gone

 

But now in edg I have a bigger issue:

There are no instances … hmmmmmm

 

 

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

 

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/e11a64bb134d43bfb380e4df9ca5aebc%40tno.nl.

[Bohms, H.M. (Michel)]

I will compensate by leaving underscores and mu symbol out the attribute names

 

Dot to comma also issues also solved by setting all language settings incl overrule setting to ENG

 

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

 

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/c629721aaee54d1c88b2305b095cc6b2%40tno.nl.