No one knows where Ooo stores its queries?!

[JamesR]

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

[JamesR]

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.

[dfrench]

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

[JamesR]

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.