Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index

Hi Ian and all:

        Excuse me if I understood bad your problem.

        I understood that you need import a .CSV file to BASE with BASE. And
You can't do it.

        I suggest to you to open the .CSV file with CALC. Then save it as .ODS.
Finally, import from BASE the .ODS file.

        I hope this help.


Jorge Rodríguez

El mié, 16-03-2016 a las 22:19 +0200, Ian "Witty" Whitfield escribió:
Thanks all - appreciated!!

My background is 30 years in the Computer Business - Training, 
installations, support etc etc.
Since retiring I left Windows behind and changed to Linux.
What I'm not is a Programmer - except with BASIC about 20 years ago!!!

My needs are to have a SOLID, RELIABLE simple Members Database that does 
not crash all the time and take the data with it as well.
I don't even need a RDB as I have one table, one Form and a few queries, 
it is single user on a single machine. My Form only uses Text Boxes, 
Drop-Down Boxes, Check Boxes and Photos and Graphics. End of story!! i 
don't want to become a DB expert just a basic layout person and every 
day user.

I did not think this would be a big problem in Linux - how wrong I was. 
I have battled with Base for several years and after my last crash in 
January, (Data lost, as is common, even with MySQL. The file is still 
there but it can not be accessed).

I thank Jarasow for his help with Kexi but after 10 crashes in 2 weeks 
and some missing features and no help to try and get Drop-boxes to work 
I had to give up on it. It does look very promising but has a way to go 
yet I fear.

So Alexander has told me how to save my Form (that helps a lot) and I 
decided to get back into Base as it seems to be the only way to go for 
me. But MySQL is giving me up-hill. It does not seem to want to save an 
empty Table for me to import my CSV into and gives me this error ...

"#1064 - You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use 
near 'varchar(10), `NULL` varchar(10), `NULL` varchar(10), `NULL` 
varchar(21), `NULL` ' at line 1"

I seem to remember this from when I first set it up last year. It's not 
MY SQL - this is what the program did!! Also my first line of the CSV is 
the column names only and it works OK with Calc and did so as well with 
Kexi!! So where is the problem??!!
So I'm unable to populate the DB in MySQL for Base to link to it!!

Thanks all.


Jorge Rodríguez

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.