Page 1 of 1

Appending one or more rows

Posted: Thu Sep 12, 2013 6:29 pm
by RaVlaNa
Hello,
I wonder if anyone can help me with this small problem:

I know how to import a CSV file into Base, but I have a database that regularly has data added to it.

Is it possible (I tried, but it did not seem to work) to only import the new data and merge them into the existing Base table without always having to import all the data?

Here is how I do my importing:

I use Navicat to get the data out of my online MySQL database and import the data as a CSV and then just import them into Base.

However, I have tried to only import the latest data and then add this to what was already in the Base table, but that did not work.

My gut feeling tells me there is a way of doing this, if I only knew how.

Any suggestions anyone?

Thank you in advance.

Re: Appending one or more rows

Posted: Thu Sep 12, 2013 7:21 pm
by Villeroy
No need to fiddle around with MySQL, HSQL and csv. Just connect a Base document to your MySQL database.

Re: Appending one or more rows

Posted: Thu Sep 12, 2013 8:53 pm
by RaVlaNa
Thank you for your reply.
However, that is exactly an issue I had inthe beginning I started using OO, and I have not found a way out of it yet.

Here is what I posted about the problem:
http://forum.openoffice.org/en/forum/vi ... 27#p281827

Thank you again.

Re: Appending one or more rows

Posted: Thu Sep 12, 2013 10:08 pm
by Villeroy
Rudolfo is certainly right saying that your database might not be connectable.
So you have these ugly csv files and another database on your local machine.
Is that other database a HSQLDB? (see status bar)
Can you post some typical csv lines copied from an ordinary text editor?

Re: Appending one or more rows

Posted: Tue Sep 17, 2013 12:17 am
by RaVlaNa
Hi Villeroy,
yes the DB on my machine is HSQL.

I have now started importing as an .xls file, which I open in the spreadsheet and then copy and paste into the DB.

However, still not sure about getting one line out of the online MySQL DB and adding it to the rest of the OO Database.

I attach an .xls file.
(Mind you, it is not in English).
verzoekjes.xls
(7 KiB) Downloaded 258 times

Re: Appending one or more rows

Posted: Tue Sep 17, 2013 11:12 am
by Villeroy
However, still not sure about getting one line out of the online MySQL DB and adding it to the rest of the OO Database.
I think you need access to the machine where the MySQL server is running. The rest is a simple SQL statement according to the MySQL documentation.

Re: Appending one or more rows

Posted: Tue Sep 17, 2013 11:16 am
by Villeroy
Your dates and IDs are invalid. You imported them as text values.

Re: Appending one or more rows

Posted: Tue Sep 17, 2013 12:41 pm
by RaVlaNa
Invalid?
I am getting completely confused now.
Same as for accessing the machine where the MySQL is located, OO won't let me.

Thanks anyway.