RE: [topbraid-users] RE: third issue sheet import
Also in edg/import I see: [cid:image001.png@01D7AB30.C6A43870] Why are the underscores deleted? Some special reason? And here the mu is also replaced by an M: [cid:image002.png@01D7AB30.C6A43870] 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.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> [cid:image003.gif@01D7AB30.C6A43870]<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. Van: topbraid-users@googlegroups.com Namens Irene Polikoff Verzonden: Thursday, September 16, 2021 5:40 PM Aan: topbraid-users@googlegroups.com Onderwerp: Re: [topbraid-users] RE: third issue sheet import 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 mailto:ir...@topquadrant.com>> wrote: Yes, index starts with 0 On Sep 16, 2021, at 10:23 AM, 'Bohms, H.M. (Michel)' via TopBraid Suite Users mailto:topbraid-users@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.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> <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. Van: 'Bohms, H.M. (Michel)' via TopBraid Suite Users mailto:topbraid-users@googlegroups.com>> Verzonden: Thursday, September 16, 2021 12:54 PM Aan: topbraid-users@googlegroups.com<mailto:topbraid-users@googlegroups.com> Onderwerp: [topbraid-users] third issue sheet import 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.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> <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/d0148d90da724fd2889e6100f25fa6b2%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/d0148d90da724fd2889e6100f25fa6b2%40tno
RE: [topbraid-users] RE: third issue sheet import
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.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> [cid:image001.gif@01D7AB23.0DAF3430]<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. Van: topbraid-users@googlegroups.com Namens Irene Polikoff Verzonden: Thursday, September 16, 2021 5:40 PM Aan: topbraid-users@googlegroups.com Onderwerp: Re: [topbraid-users] RE: third issue sheet import 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 mailto:ir...@topquadrant.com>> wrote: Yes, index starts with 0 On Sep 16, 2021, at 10:23 AM, 'Bohms, H.M. (Michel)' via TopBraid Suite Users mailto:topbraid-users@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.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> <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. Van: 'Bohms, H.M. (Michel)' via TopBraid Suite Users mailto:topbraid-users@googlegroups.com>> Verzonden: Thursday, September 16, 2021 12:54 PM Aan: topbraid-users@googlegroups.com<mailto:topbraid-users@googlegroups.com> Onderwerp: [topbraid-users] third issue sheet import 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.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> <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/d0148d90da724fd2889e6100f25fa6b2%40tno.nl<https://groups.go
Re: [topbraid-users] RE: third issue sheet import
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 wrote: > > Yes, index starts with 0 > > >>> On Sep 16, 2021, at 10:23 AM, 'Bohms, H.M. (Michel)' via TopBraid Suite >>> Users 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.bo...@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: 'Bohms, H.M. (Michel)' via TopBraid Suite Users >> >> Verzonden: Thursday, September 16, 2021 12:54 PM >> Aan: topbraid-users@googlegroups.com >> Onderwerp: [topbraid-users] third issue sheet import >> >> 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.bo...@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-users+unsubscr...@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-users+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/topbraid-users/d4e75bb24ee0414db65532e6a77e375a%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-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/DE421DE1-5D21-4FAE-A2F0-823208A4A0AC%40topquadrant.com.
RE: [topbraid-users] RE: third issue sheet import
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.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> [cid:image001.gif@01D7AB20.0FA31C50]<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. Van: topbraid-users@googlegroups.com Namens Irene Polikoff Verzonden: Thursday, September 16, 2021 5:26 PM Aan: topbraid-users@googlegroups.com Onderwerp: Re: [topbraid-users] RE: third issue sheet import Yes, index starts with 0 On Sep 16, 2021, at 10:23 AM, 'Bohms, H.M. (Michel)' via TopBraid Suite Users mailto:topbraid-users@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.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> <http://www.tno.nl/> <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. Van: 'Bohms, H.M. (Michel)' via TopBraid Suite Users mailto:topbraid-users@googlegroups.com>> Verzonden: Thursday, September 16, 2021 12:54 PM Aan: topbraid-users@googlegroups.com<mailto:topbraid-users@googlegroups.com> Onderwerp: [topbraid-users] third issue sheet import 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.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> <http://www.tno.nl/> <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/d0148d90da724fd2889e6100f25fa6b2%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/d0148d90da724fd2889e6100f25fa6b2%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/d4e75bb24ee0414db65532e6a77e375a%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/d4e75bb24ee0414db65532e6a77e375a%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/8DBF0191-FD21-4AEE-B9D0-9464CF9EBBA5%40topquadrant.com<https://groups.google.com/d/msgid/topbraid-users/8DBF0191-FD21-4AEE-B9D0-9464CF9EBBA5%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 gr
Re: [topbraid-users] RE: third issue sheet import
Yes, index starts with 0 > On Sep 16, 2021, at 10:23 AM, 'Bohms, H.M. (Michel)' via TopBraid Suite Users > 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.bo...@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: 'Bohms, H.M. (Michel)' via TopBraid Suite Users > > Verzonden: Thursday, September 16, 2021 12:54 PM > Aan: topbraid-users@googlegroups.com > Onderwerp: [topbraid-users] third issue sheet import > > 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.bo...@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-users+unsubscr...@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-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/d4e75bb24ee0414db65532e6a77e375a%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-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/8DBF0191-FD21-4AEE-B9D0-9464CF9EBBA5%40topquadrant.com.
