Lisa Bishop wrote: > Hi I'm having trouble with importing raw data a .gpr file into my raw > bioassay. I'm new to base2.I click on the specific raw bioassay and > then the import button. I run the raw data importer Configuration > GenePix raw data import (cy5/cy3). > > This is the error message net.sf.basedb.core.BaseException: For input > string: "Error" on line 45: 1 11 1 "Lucid:Rat... at > net.sf.basedb.plugins.AbstractFlatFileImporter.doImport(AbstractFlatFileImporter.java:645) > at > net.sf.basedb.plugins.AbstractFlatFileImporter.run(AbstractFlatFileImporter.java:463) > at > net.sf.basedb.core.PluginExecutionRequest.invoke(PluginExecutionRequest.java:89) > at > net.sf.basedb.core.InternalJobQueue$JobRunner.run(InternalJobQueue.java:435) > 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:495) at > net.sf.basedb.core.ExtendedProperty.parseString(ExtendedProperty.java:255) > at > net.sf.basedb.plugins.RawDataFlatFileImporter.handleData(RawDataFlatFileImporter.java:598) > at > net.sf.basedb.plugins.AbstractFlatFileImporter.doImport(AbstractFlatFileImporter.java:616) > ... 4 more Error: For input string: "Error" on line 45: 1 11 1 > "Lucid:Rat... > > I'm wondering is it that strings are not allowed in the ID column and > that an integer is required.
No, the ID column may have strings. The problem here is that another (numeric) column contains the word "Error". This is not allowed unless you change the "Invalid numeric value" option to 'null' (to not insert any value for that column) or 'skip' to skip the entire data line. /Nicklas ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]
