SQL Excel

Hi all

Please post up if you have any suggestions on the what addin settings we should be able to store.

Blitzoff brought this up a good while ago - thanks for that. Sorry it took so long to start looking into this.

Here is what is currently being setup in the development version of the addin. Basically, there will be 4 setting which can be stored - default formatting, default paste location, default use of headers and default use of auto filter.

Thats all I can think of but maybe there is something else we should add. If anyone has any ideas of what anything else we should add in the next release please post it up. thanks and have a nice weekend.
al


<application_settings>

<PatsteOptions>

<name>DefaultExcelFormatting</name>
<value>NoFormatting</value>

<name>DefaultExcelPasteLocation</name>
<value>ActiveWorksheet</value>

<name>ExcelHeaders</name>
<value>True</value>

<name>ExcelAutoFilter</name>
<value>True</value>

</PatsteOptions>

</application_settings>

Forgot to mention,

the way the storeage of the settings will be implemented will be via a new form that will be accessible from the SQL Excel Toolbar.

So, if you want to change your default settings you will load do this within Excel from the new form. This form will be used to change your default settings and store them in the applciation_settings.xml file. Then when you load the main SQL Excel form - the default setting will be loaded from the application_settings.xml file.

Please post up if you can think of any issues with this or have suggestions on this.
thanks very much and see you,
al

Forgot to add the path to the location of hte sql queries folder.. This will be one more setting we can store.. Please let me know if anyone thinks of any others.
Thanks, Al

hi all !

Fyi, the basic functionality of retrieving the stored setting from the settings xml file was implemented. Have to add in a form for maintaining the settings but the first part is done and seems to work very good.
If anyone has any suggestions plse chime in.
The xml for settings is below as currently setup.. Thanks, Al

<?xml version="1.0" encoding="UTF-8"?>

<application_settings>

<PasteOptions>
<ExcelPasteFormatting>
<value>Green and Black</value>
</ExcelPasteFormatting>

<ExcelPasteDestination>
<value>Activecell</value>
</ExcelPasteDestination>

<ExcelPasteHeaders>
<value>1</value>
</ExcelPasteHeaders>

<ExcelPasteAutoFilter>
<value>0</value>
</ExcelPasteAutoFilter>

</PasteOptions>

<FileSettings>
<QueryFilesPath>
<value>C:\Documents and Settings\</value>
</QueryFilesPath>
</FileSettings>


</application_settings>