MySQL Forums
Forum List  »  MySQL for Excel

Re: Migrating user profile
Posted by: Javier Treviño
Date: October 20, 2016 01:40PM

Hi Stuart,
Thanks for writing in our forums.

The column mappings for an "append data" operation are stored for each Windows user account in the "settings.config" file located at "%APPDATA%\Oracle\MySQL for Excel". The "settings.config" file is stored in XML format, the mappings are stored within the <StoredDataMappings> XML node.

The easiest thing to do is just copy the whole "settings.config" file to the new %APPDATA% location, review the XML configuration file to see if any other configuration value needs to change, and test.

Hope this helps!
Best regards.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote


Subject
Views
Written By
Posted
1414
October 18, 2016 07:23AM
Re: Migrating user profile
773
October 20, 2016 01:40PM
648
October 21, 2016 02:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.