Gerrick; First of all, thanks for the nice example - it was very helpful! We will suppress these warnings in a future release.
-- Scott On May 7, 2:22 pm, Gerrick Bivins <[email protected]> wrote: > Hello all, > I'm running across a strange error that I'm unable to fix. After upgrading > to 3.3.1, I noticed one of my SM scripts was throwing a datatype warning. > Initially I thought it was because of one my columns was datetime data and I > thought I was not parsing and casting it properly. > After fixing this, I noticed that the error was still being thrown but not > consistently. > So far I've only been able to replicate the error by doing the following: > 1) create a spreadsheet with a column that has decimal data. > 2) make the first non string entry in that column a decimal like 1.0 or 0.0. > Excel chops the digits after the decimal automatically. > 3) Import the spreadsheet using SM > 4) Create a spreadsheet using sml:CreateSpreadsheet. > 5) In the sml:CreateSpreadsheet module, query for the values and try to cast > them to another xsd:datatype like (xsd:string or xsd:float) > This causes the warning. > If you change the first non string entry into 1.1, the cast error goes away. > > Anyway, this is a problem for us in that we are importing spreadsheets with > 10k rows of data and mapping the data to our ontology. > The printing of this stack trace is impacting our import performance > significantly and we are unable to tune it any further. > > Is there a way to work around this? > Attached is a SM script and a sample spreadsheet that is throwing the > datatype error when trying to cast the literal value. > Gerrick > > -- > You received this message because you are subscribed to the Google > Group "TopBraid Suite Users", the topics of which include TopBraid Composer, > TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. > To post to this group, send email to > [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group > athttp://groups.google.com/group/topbraid-users?hl=en > > cast-datatype-format-warning.log > 268KViewDownload > > testcastexception.n3 > 6KViewDownload > > TestFormat.xls > 29KViewDownload -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en
