Libreoffice Base - csv with dates import

[hafron]

Hi,
several days ago I must import to Base several csv files. To do this I’ve opened them in Calc and them copy and paste them to Base window. Nearly everything imported fine. Except date import. I’ll try to explain this by example.

I have table “test” in Base:

id -> integer
name -> varchar
date -> date with format changed to(DD-MM-YYYY)

And csv file:

1; foo;12-05-2010                        
2;bar;14-07-2003
3;test;05-04-1987

I open it in calc, select this 9 cells and copy them to Base. Then i select option append data and click “Create”. After a while the window shows, with following error message:

Warning!
Wrong data type: java.lang.IllegalArgumentExcetpion
Do you want to continue?

After pressing “Yes” my table rows looks like this:

id	imie	uro
1	zbynio	
2	jan	
3	wojtek	

How can I import date fileds from csv correctly?

[oweng]

Does using an ISO 8601 date format of YYYY-MM-DD work? Refer this answer about ISO 8601 dates and LO.

2ND EDIT: Thanks are due to @mariosv for correcting my initial answer. It will probably be easiest to manipulate the data in Calc before export to Base, however it requires a few steps. Using your example CSV:

1. Import the data into Calc. Select Detect special numbers and click on the date column and set the format to Date (DMY).
   
   
2. Format column C to use ISO 8601 date format YYYY-MM-DD.
   
   
3. This will give you the ISO date data you require.
   
4. Save and import to Base as per usual.

[hafron]

Ok in standand format it working. But if there is any simple method to convert dana in my format to ISO 8601.

[mariosv]

In the point 1 of Oweng answer, you can select what is the data format for a proper import, click on the column Title and select the column type:

or from point 2 of Oweng answer, you can select column C data and use Menu/Data/Text to column with the same option for the column as in the above image.

[oweng]

Thanks for this correction. In my haste I completely forgot about selecting the column on CSV import. I will update my post.