Bug in Text Importer (Version 7.0.1.1066)

[shayt]

the (very good) Text Importer,
has a bug in Version 7.0.1.1066.

the script i am getting consist the record type INSIDE the name, so i getting an error, because the name is not good, example for a script produced by the text importer :

insert into xxx.yyy (CUSTOMER_ID__NUMBER_, EFFECTIVE_DATE_FROM__DATE_, BANK_ACCOUNT__VARCHAR2_)

Thanks,
Shay

 

[Marco Kalter]

I'm not sure I understand. Can you elaborate?

 

[shayt]

sure -

1.
create table tmp_s_1
(a number, b number, c number)

2.
insert the following data in XLS -
a b c
1 2 3
4 5 6
7 8 9

3.
Go to "Text Importer",
copy the XLS cells, and paste the clipboard to "Data From TextFile" tab

4.
Go to "Data To Oracle" tab in the "Text Importer"
fill the owner, and table : tmp_s_1

5.
click on "Ignore Duplicates" - so it will know that you selected a table

6.
you can already see the bug,
if you look at the fields window
Field1 a -> A__NUMBER_
Field2 b -> B__NUMBER_
Field3 c -> C__NUMBER_

7.
if you will press "Import to Script",
you will get the following script (pay attention to the fields name, the type is included in the name !) -

insert into CRMREST.TMP_S_1 (A__NUMBER_, B__NUMBER_, C__NUMBER_)
values (1, 2, '3');

insert into CRMREST.TMP_S_1 (A__NUMBER_, B__NUMBER_, C__NUMBER_)
values (4, 5, '6');

insert into CRMREST.TMP_S_1 (A__NUMBER_, B__NUMBER_, C__NUMBER_)
values (7, 8, '9');

commit;

Shay

 

[Marco Kalter]

Okay, I see. We'll fix it.

 

[shayt]

any news on this bug ?
when it should be fixed ?

Thanks,
Shay

 

[Marco Kalter]

It will be fixed for 7.0.2.