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

No one knows where Ooo stores its queries?!

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


Joined: 01 Apr 2004
Posts: 6
Location: Salt Lake City, Utah

PostPosted: Fri Apr 02, 2004 7:22 am    Post subject: No one knows where Ooo stores its queries?! Reply with quote

I thought this would be an easy one for the gurus, aparently it's a deeper mystery than I realized. Is this not the correct forum for such a question?

To recap: How does one migrate queries created with Ooo on one computer, to another? Surely there must be a better way then having to recreate them.

Thanks in advance
Back to top
View user's profile Send private message
JamesR
General User
General User


Joined: 01 Apr 2004
Posts: 6
Location: Salt Lake City, Utah

PostPosted: Fri Apr 02, 2004 10:49 am    Post subject: Found them!!! Reply with quote

Many kudos to Daniel Strome who posted this info on the gmane newsgroup:
____________________________________________________
In the file
....../user/registry/data/org/openoffice/Office/DataAccess/xcu

Queries look something like:

<node oor:name="Queries">
<node oor:name="query_save_notes_cat_to_file" oor:op="replace">
<prop oor:name="Command" oor:type="xs:string">
<value>select note_cat_id, description ....

And I guess an administrator could have added queries
to the comparable file in ..../share
so they would be available to other users.
Not sure.
Back to top
View user's profile Send private message
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Fri Apr 02, 2004 11:31 am    Post subject: Reply with quote

data source and query definitions are stored in the /user folder ... migrating that folder should be sufficient for a user moving between versions or machines. The definitions are actually in the /user/registry/data/org/openoffice/office/DataAccess.xcu ... playing around with that is at your own risk
Back to top
View user's profile Send private message
JamesR
General User
General User


Joined: 01 Apr 2004
Posts: 6
Location: Salt Lake City, Utah

PostPosted: Fri Apr 02, 2004 11:39 am    Post subject: Reply with quote

Thanks for the reply. I moved the DataAccess.xcu file from the old machine to the new one and everthing is working perfectly.

Have a great day.
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