Hi there.
I have a base file linked to a directory of csv files.
My problem is, I can't seem to change how the fields are read in the database.
I've read somewhere that they are decided on by reading the second line of the csv (after the headers) and then whatever datatype is present in the column will decide the field type for the whole column.
I've done some testing with this and it looks like I'm getting random results with how the data is read. I want the data as a number type so I can make a SUM with the column when imported to calc. however quite often the data is read as a TEXT field and causes problems.
the csv file is updated daily from the internet hence the csv directory structure.
Any help would be appreciated.
[Solved] Database linked csv, problem with field types
-
- Posts: 8
- Joined: Mon Feb 22, 2016 1:21 am
[Solved] Database linked csv, problem with field types
Last edited by Hagar Delest on Wed Jun 01, 2016 10:37 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
Llibreoffice 4.3 on Debian Linux
Re: database linked csv, problem with field types
A small sample file would help.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: database linked csv, problem with field types
The text driver for Base has not enough import options to meet common requirements. It works fine with unquoted numbers and all numerals according to the global setting. You can set the decimal separator independently from any locale but "special numbers" (mostly dates, times, booleans)" are interpreted in the global locale context.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 8
- Joined: Mon Feb 22, 2016 1:21 am
Re: database linked csv, problem with field types
Llibreoffice 4.3 on Debian Linux