Hello people,
although I had set the state of
http://www.openoffice.org/issues/show_bug.cgi?id=81658 to VERIFIED, I
found the following issue in my tests (just needed other's confirmation;
if you can confirm, should we reopen it?):
the wizard mixes the column names of the source, but not the data.
Steps to reproduce it:
Destination: HSQLDB embedded
Source: dBase / OOo Calc / CSV files, all with the following structure
(of course the CSV settings are set properly)
FIRST_NAME LAST_NAME ADDRESS CITY EMAIL
Alberto Olmedo Calle 35 Nº 612 Ensenada [EMAIL PROTECTED]
Verónica García Calle 45 Nº 348 Villa Elisa [EMAIL PROTECTED]
Ana Sarmiento Calle 64 Nº 481 Villa Elisa [EMAIL PROTECTED]
Carolina O'Connor Calle 45 Nº 173 City Bell [EMAIL
PROTECTED]
José Piazzola Calle 39 Nº 122 Berisso [EMAIL PROTECTED]
Pedro Prado Calle 55 Nº 694 Berisso [EMAIL PROTECTED]
Ana Olmedo Calle 8 Nº 355 La Plata [EMAIL PROTECTED]
CTWiz. Step 1: create new table with primary key "id_customers"
CTWiz. Step 2 Apply columns:
The "Existing columns" list displays
the following columns in this [wrong] ORDER
and with these names:
ADDRESS
CITY_ [ sic. with the "_" when Source: *dBase* ! ]
EMAIL
FIRST_NAME
LAST_NAME
Add all the fields in the copied table
CTWiz. Step 3 Type formatting:
as all fields are strings, there is no much formatting
problem, BUT the length of the text fields must be changed
when Source = *dBase* because the Wiz. assigns a very small
number (in this order: 16,11,29,9,9)
that makes copying error prone,
with Source = OOoCal the length is 65535 and
with Source = CSV the length is 254
for all fields by default
The resulting copied table has WRONG column names ["CITY_" happens only
with dBase], although the data is in the right place:
id_customers ADDRESS CITY_ EMAIL FIRST_NAME LAST_NAME
1 Alberto Olmedo Calle 35 Nº 612 Ensenada [EMAIL PROTECTED]
2 Verónica García Calle 45 Nº 348 Villa Elisa [EMAIL
PROTECTED]
3 Ana Sarmiento Calle 64 Nº 481 Villa Elisa [EMAIL
PROTECTED]
4 Carolina O'Connor Calle 45 Nº 173 City Bell [EMAIL
PROTECTED]
5 José Piazzola Calle 39 Nº 122 Berisso [EMAIL PROTECTED]
6 Pedro Prado Calle 55 Nº 694 Berisso [EMAIL PROTECTED]
7 Ana Olmedo Calle 8 Nº 355 La Plata [EMAIL PROTECTED]
Be aware that the settings and my Java classes work fine, and I get from
my Listener
ERRORS : 0
COPIED ROW COUNT : 2001
so, although I only tested on Linux and with Destination=HSQLDB, I
tested with three different Sources = dBase/OOoCalc/CSV, with several
files, and in several tests... so I would say I "can confirm" this issue.
Please try to reproduce it on your own and let me know.
Regards
Ariel.
--
Ariel Constenla-Haile
La Plata, Argentina
[EMAIL PROTECTED]
[EMAIL PROTECTED]
http://www.arielconstenlahaile.com.ar/ooo/
"Aus der Kriegsschule des Lebens
- Was mich nicht umbringt,
macht mich härter."
Nietzsche Götzendämmerung, Sprüche und Pfeile, 8.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
