Enhancement Request: Export Profiles/Settings

Toad Data Point
1

Currently TDP allows you to export your Connections settings to an XML file and import that into another instance of TDP on a different machine - this is great.

However, I would also love the ability to export my UI configuration from one machine and import it into another - especially when I can’t quite remember how I got something the way I did.

2

It’s interesting proposal and it’s almost there.

You can go to Help|About and open Application Data Directory and copy the ModuleSetting folder . Run the Toad on another PC, open the Application Data Directory and replace the ModuleSetting directory with the copied one.

Please create a backup copy of the directory before replacing it, just in case.

Probably we should have a better way to do it. I created the CR 111636 to track your request.

Thank you for using TOAD

Aleksey

3

Sorry, I forgot to mention that you have to copy the Settings.xml from the Application Data Directory as well.

4

Is there a difference in doing this between Windows XP and Windows 7? I’ve found the respective directories in Windows 7, but after copying over just the ModuleSettings folder and the Settings.xml file, I keep getting messages about a module failing to load, and reverting to default settings.

5

Probably it’s a good idea to copy Settings.xml file while both “source” and “target” Toads are closed.

Igor.

6

Igor - I did. Still doesn’t work, or only works part-way. The only piece that works correctly is copying the connections.xml file over (not mentioned).

After copying both the “ModuleSettings” folder and the “Settings.xml” file over, I’ll initially get a UI that looks similar, but not the same (tool bars aren’t correct, extra items are still showing up that I removed from the “source” display), but upon closing TDP I get an error message about being unable to save the “AnalystSettings”, and when I reload TDP I get an error message about not being able to load the “AnalystSettings” and reverting to defaults.

This is why having an export/import facility would be greatly appreciated :slight_smile:

7

First, let me state that an Export/Import of Toad settings - or the ability to set a central configuration file, like on a Network Share - is still a highly desirable enhancement.

I’ve finally figured out what the issue is/was:

  1. Ownership. When copying files from one PC to another - with Windows 7 especially, though it occasionally has been an issue on Windows XP in the past - you may need to ensure that the Ownership of the folders and files that you’re copying is transferred to the user on the Copy-TO machine in order to allow for them to be read and written to properly.

A user with Admin rights on the Target PC must ensure that all sub-folders and files in the C:\Users<target username>\AppData\Roaming\Quest Software\Toad Data Point 3.3\ModuleSettings are owned by the named in the file path.

  1. Path Name. I’m not sure why the decision was made to hard-code a path in one of the .XML files with TDP 3.3, but that was the issue occurring when I would get the “Failed to load AnalystSettings” error message. In the AnalystSettings.xml file in C:\Users<source username>AppData\Roaming\Quest Software\Toad Data Point 3.3\ModuleSettings the paths to and are hard coded to C:\Users<source username>\AppData\Roaming\Quest Software\Toad Data Point 3.3\Toad Shared and C:\Users<source username>\AppData\Roaming\Quest Software\Toad Data Point 3.3\Toad Projects respectively.

I had to manually edit the file and change the value from what it was on the Source PC to what it is on the Target PC - I would think that it would be preferable to use the Windows Environment Variable of %USERNAME% in order to determine the path, but that may not be supported in the XML configuration.
Since it’s a bit much to ask someone to jump through all of these hoops simply to replicate settings across PC’s - not to mention User Profiles on the same PC - an Export/Import function is far more desirable.

8

It’s nice step by step instructions how to export users settings.

Thank you

Aleksey