OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

import records from MySQL table

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
d_vineet
General User
General User


Joined: 02 Jun 2012
Posts: 9

PostPosted: Sat Jun 02, 2012 7:32 am    Post subject: import records from MySQL table Reply with quote

Preamble to my question:-

I have a stock-broker's desktop application, from which a csv file is continually being updated on the hard disk.

I am trying to append live stock quotes from the csv file to an OpenOffice Calc file (which is always kept open).
I wish to keep the file open because I will be having stock-charts in it.

A python program which, when run, would append the new data from csv file into a MySQL table.
No problem in that.

My question is---

How do I import data from MySQL table into OO Calc and thereon keep on refreshing it.
For Excel, I figured out how to do it.
In OO Calc, I configured MySQL connection through "Tools--Options--OO Base--Connections".
It opens a window & shows tables.
Can someone pl. tell me how to achieve data-import & refresh from MySQL to OO Calc?
(Copy & paste can't be a good solution).

Thanks in advance,

Vineet
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Sun Jun 03, 2012 12:44 am    Post subject: Reply with quote

Hello

http://www.oooforum.org/forum/viewtopic.phtml?t=53346&start=0&postdays=0&postorder=asc&highlight=

I think the link give you a lot information.

Romke
_________________
OOo 3.4.5 on openSUSE 12.1
Use this forum : http://user.services.openoffice.org/en/forum
Back to top
View user's profile Send private message
d_vineet
General User
General User


Joined: 02 Jun 2012
Posts: 9

PostPosted: Sun Jun 03, 2012 8:15 pm    Post subject: Reply with quote

Thank you.
It solved my query.
After drag & drop, I did 'refresh range'.

One more difficulty---
After clicking any small table (with as less as 5 rows), it takes very long time to load it (more than 5 minutes).
Any idea what may be the reason?

I am running Win 7 on Intel Core I3
OO Calc ver 3.3
Using ODBC 5.1 driver
MySQL ver 5512

All other things working speedily, except the thing I mentioned (table loading very slow).

Pl. tell me whether you need any further technical info for advising me on this issue.

Thanks in advance.
Back to top
View user's profile Send private message
dacm
Super User
Super User


Joined: 07 Jan 2010
Posts: 769

PostPosted: Sun Jun 03, 2012 8:36 pm    Post subject: Reply with quote

d_vineet wrote:
...After clicking any small table (with as less as 5 rows), it takes very long time to load it (more than 5 minutes).
Any idea what may be the reason?

Using ODBC 5.1 driver
MySQL ver 5512

If you're sure you have the latest ODBC drivers for MySQL:
Download Connector/ODBC

then try the native SDBC (Base) driver:
MySQL Connector for OpenOffice.org

or try the JDBC (Java) driver (with installed JRE):
Download Connector/J
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Splitting 'Embedded databases'
Back to top
View user's profile Send private message
d_vineet
General User
General User


Joined: 02 Jun 2012
Posts: 9

PostPosted: Sat Jun 09, 2012 8:05 pm    Post subject: Reply with quote

@dacm,
Sorry for not replying in time.
I am formatting my laptop.
After fresh installation, I will follow your instructions and let you know the result.

Thanks,

Vineet
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group