Ana Conesa wrote: > Hi all, > > I am importing .gpr data in BASE2 using a custom rawdata importer. I > set the M value field to the Log Ratio (635/532) column of the gpr file > (as in the original importer for this format). However this column has > the value "Error" at different positions (I assumed when the log could > not be computed) and this gives an error during importing: > > net.sf.basedb.core.BaseException: For input string: "Error" on line 35: > 1 1 1 1930 5680... > at > net.sf.basedb.plugins.AbstractFlatFileImporter.doImport(AbstractFlatFileImporter.java:592) > at > net.sf.basedb.plugins.AbstractFlatFileImporter.run(AbstractFlatFileImporter.java:442) > at > net.sf.basedb.core.PluginExecutionRequest.invoke(PluginExecutionRequest.java:88) > at > net.sf.basedb.core.InternalJobQueue$JobRunner.run(InternalJobQueue.java:420) > at java.lang.Thread.run(Thread.java:595) > Caused by: java.lang.NumberFormatException: For input string: "Error" > at net.sf.basedb.core.Type.parseString(Type.java:420) > at > net.sf.basedb.core.ExtendedProperty.parseString(ExtendedProperty.java:194) > at > net.sf.basedb.plugins.RawDataFlatFileImporter.handleData(RawDataFlatFileImporter.java:541) > at > net.sf.basedb.plugins.AbstractFlatFileImporter.doImport(AbstractFlatFileImporter.java:570) > ... 4 more > > > I can´t hardly imagine that this has not been taken care somewhere. > Anyone can help me??
When starting the import there is an error handling option: Invalid numeric value. The default option is that the import will fail (which happens in your case), the only other option is to skip the entire line. I know that this is not always the desired behavior. We are planning to add support for keeping the line and inserting a null value for the invalid number instead. For more information see ticket #469: http://base.thep.lu.se/ticket/469 We do not have a date yet for the 2.4 release. If you want to keep the line in the current release you have to do some manual manipulation of the data file first. Ie. remove all "Error" values and replace them with an empty string. /Nicklas ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]
