#29 Import format incompatible with export format

closed-accepted
5
2003-03-05
2003-03-05
No

I was loading a data file previously exported via
cmap_admin.pl. Oracle did not recognize '.4' as a NUMBER.

Please select a map set: 2
Remove data in map set not in import file? [Y/n] y
OK to import?
File : Rice-CTIR_2000.dat
Species : Rice
Map Type : Genetic
Map Study : CT9993/IR6226 2000
Overwrite : Yes
[Y/n]
Importing map set data.
Examining map set.
'Rice-CT9993/IR6226 2000' currently has 0 maps.
Checking headers.
Column 'map_accession_id' OK.
Column 'map_name' OK.
Column 'map_start' OK.
Column 'map_stop' OK.
Column 'feature_accession_id' OK.
Column 'feature_name' OK.
Column 'feature_alt_name' OK.
Column 'feature_start' OK.
Column 'feature_stop' OK.
Column 'feature_type' OK.
Column 'feature_dbxref_name' OK.
Column 'feature_dbxref_url' OK.
Parsing file...
Created map 1 (5743).
Inserted Marker 'G107' on map 1 at 0.
Error: Value of 'feature_start' is wrong. Expected
number and got '.4'.

Discussion

  • Immanuel Yap

    Immanuel Yap - 2003-03-05

    Logged In: YES
    user_id=643119

    I forgot: the fix, of course, is to output numbers < 1.0
    with a leading '0'.

     
  • Ken Youens-Clark

    Logged In: YES
    user_id=469773

    It's not Oracle throwing the error but a failed regex in the code that verifies the data before giving it to the db. I put in a little hack to force something like ".4" into a numeric context (I just add "0" to the variable) and it seems to fix the problem better than trying to write the perfect regex to detect a valid number (this is harder than it seems). Please try again and let me know.

    ky

     
  • Ken Youens-Clark

    • assigned_to: nobody --> kycl4rk
    • status: open --> closed-accepted
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks