I don't know the direct OOS solution, but a quick workaround might be to
create a 'view' or pre-made query
in the database that contains all the info you need and then query it.
Just a thought,
Jim
----- Original Message -----
From: "Andrew Robertson" <[EMAIL PROTECTED]>
To: <[email protected]>; <[email protected]>
Sent: Friday, February 02, 2007 10:17 AM
Subject: [users] Connecting OOo to a mySQL relational database for
addressing an mail merge
Morning folks!
(cross-post to [email protected] and [email protected])
I am having trouble figuring out how to do this properly. We use XRMS for
our CRM, but the only limitation it has is that XRMS does not have an easy
method of writing letters to a contact that automatically fills in the
contacts data (name, address, etc.) but OOo does if connected to a data
source.
So, I created an ODBC connection to the XRMS mySQL database on my system.
OOo recognizes the connection, and allows me to log in, etc.
The problem is when I go to set up the field maps in the addressing; XRMS
is
a relational mySQL database, and information is stored in various tables
using key fields. For example, to create a full address for a contact, I
need to access 3 different tables in the XRMS database:
TABLE DATA IN TABLE
companies company name
contacts contact's salutation, first name and last name
addresses contact and company addresses
countries countries
So I set up the connection, setup OOo to access the database. But I can
only
seem to pull information from one table at a time, I cannot use relational
data!!!
How do I get a complete address in OOo using this scenario?
Sincerely,
Andrew Robertson
Export Manager
derma eR Natural Bodycare
ph. 805-582-2710 xt. 244
fx. 805-582-2730
[EMAIL PROTECTED]
www.dermae.net
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
