Import fails

[Exemplar]

I have been trying to import a 3 column csv file. It fails everytime with the error

"Imported column has not the required format" [sic]
"Line is:1, column is: 1"

I've tried lots of permutations but no success.

The csv looks like this:

"QPSK 1/4",-2.35,0.47

or the other one I tried:

QPSK 1/4,0.478577,-2.35


Any idea what is wrong ?

Log:
Logged by net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor at 15/04/08 15:11:

 Unsupported format.

Stack Trace:
net.sourceforge.squirrel_sql.plugins.dataimport.importer.UnsupportedFormatException
        at net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor.bindAutoincrementColumn(ImportDataIntoTableExecutor.java:230)
        at net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor._execute(ImportDataIntoTableExecutor.java:174)
        at net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor.access$000(ImportDataIntoTableExecutor.java:50)
        at net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor$1.run(ImportDataIntoTableExecutor.java:107)
        at java.lang.Thread.run(Unknown Source)

[manningr]

It looks like it could be a bug in the DataImport plugin
(ImportDataIntoTableExecutor.bindColumn()).  What database are you
using and can you provide a create table script?

Rob

On Tue, Apr 15, 2008 at 10:11 AM, Exemplar
<peters@...> wrote:

>
>  I have been trying to import a 3 column csv file. It fails everytime with the
>  error
>
>  "Imported column has not the required format" [sic]
>  "Line is:1, column is: 1"
>
>  I've tried lots of permutations but no success.
>
>  The csv looks like this:
>
>  "QPSK 1/4",-2.35,0.47
>
>  or the other one I tried:
>
>  QPSK 1/4,0.478577,-2.35
>
>
>  Any idea what is wrong ?
>
>  Log:
>  Logged by
>  net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor
>  at 15/04/08 15:11:
>
>   Unsupported format.
>
>  Stack Trace:
>  net.sourceforge.squirrel_sql.plugins.dataimport.importer.UnsupportedFormatException
>         at
>  net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor.bindAutoincrementColumn(ImportDataIntoTableExecutor.java:230)
>         at
>  net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor._execute(ImportDataIntoTableExecutor.java:174)
>         at
>  net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor.access$000(ImportDataIntoTableExecutor.java:50)
>         at
>  net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor$1.run(ImportDataIntoTableExecutor.java:107)
>         at java.lang.Thread.run(Unknown Source)
>
>  --
>  View this message in context: http://www.nabble.com/Import-fails-tp16700802p16700802.html
>  Sent from the squirrel-sql-users mailing list archive at Nabble.com.
>
>
>  -------------------------------------------------------------------------
>  This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
>  Don't miss this year's exciting event. There's still time to save $100.
>  Use priority code J8TL2D2.
>  http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
>  _______________________________________________
>  Squirrel-sql-users mailing list
>  Squirrel-sql-users@...
>  https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Exemplar]

manningr wrote:

It looks like it could be a bug in the DataImport plugin
(ImportDataIntoTableExecutor.bindColumn()).  What database are you
using and can you provide a create table script?

Rob

Hi Rob,

The database is HSQLDB 1.8.0 and this is the script:

create table Air_interface_modes
(
   ai_mode_id              identity
  ,jdoversion              integer
  ,jdoclass                varchar(255) default 'com.ea.albt.domain.model.comms.impl.BaseAirInterfaceMode' not null
  ,ai_standard_id          integer  not null
  ,modulation_scheme_id    integer  not null
  ,coding_scheme_id        integer  not null
  ,ideal_es_no             real
  ,per_symbol_efficiency   real
);

The two numeric values go in the last two columns.

Peter

[manningr]

On Mon, Apr 21, 2008 at 5:14 AM, Exemplar
<peters@...> wrote:

>  Hi Rob,
>
>  The database is HSQLDB 1.8.0 and this is the script:
>
>  create table Air_interface_modes
>  (
>    ai_mode_id              identity
>   ,jdoversion              integer
>   ,jdoclass                varchar(255) default
>  'com.ea.albt.domain.model.comms.impl.BaseAirInterfaceMode' not null
>   ,ai_standard_id          integer  not null
>   ,modulation_scheme_id    integer  not null
>   ,coding_scheme_id        integer  not null
>   ,ideal_es_no             real
>   ,per_symbol_efficiency   real
>  );
>
>  The two numeric values go in the last two columns.

Peter,

By looking at the stack trace and running your input myself, I was
able to get it to work.  The trick is to
not use the "Auto Increment" setting for your AutoIncrement column.
You should use the "Skip" setting
for that column.  Here is a screenshot of the setup that I used that
worked with your first quoted string example:

http://squirrel-sql.sourceforge.net/downloads/data_import_setup.png

The AutoIncrement setting will cause the plugin to attempt to
"simulate" an auto-increment column.  Since
your table's column values is managed via the database (AutoIncrement
datatype), you can just skip this
column and the insert should work fine.

Rob

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users