[Kexi] How to import to kexi from OO Base?

[Dinbandhu]

On Tue, 2008-04-22 at 09:19 +0200, Jaroslaw Staniek wrote:
> Dinbandhu said the following, On 2008-04-22 02:07:
> > Hi,
> > I have just found out about kexi and am excited to try it. I would like
> > to import one of my databases from OpenOffice Base 2.3. I opened kexi,
> > and the import option only seems to provide ready-made import of MS
> > Access files. I'm sure there must be a way to import from OO Base. Could
> > someone tell me the best way? I use OO in Linux Ubuntu 7.04 (Feisty),
> > and will be using kexi in Ubuntu Feisty as well.
> 
> Hello Dinbandhu,
> Try to export your tables to a CSV format and then import them in Kexi. No 
> import option at higher level (whole databases) is available.
> Regarding queries, you could try to copy their SQL statements.
> Regarding forms, you'd need to recreate them by hand, as there is no common 
> file or XML format now we could share.

Ok -- here is the critical point. I exported from OO Base as a CSV file,
and was able to import the CSV file into Kexi. And in Kexi's import
preview window it gives a view of the table and how it will look after
it is imported. There everything is perfect. But when I actually run the
import, then anywhere in the original table where there is an empty
cell, there Kexi is not keeping it empty as it should but is rather
bringing in data from cells in the next column to the right. So that in
the final imported table, the data are no longer in the correct columns
where they belong. In the preview version everything is perfect. But
once the import is actually executed, due to not recognizing empty cells
as empty, all the data is in the wrong columns. Is there some way to fix
this?