PI DataLink settings can be stored in two places:
- piclient.ini file located in C:/Program Files/PIPC/DAT, and
- OSIsoft.PIDataLink.xml file located in different places depending on the OS
On Win XP:
cd %UserProfile%\Local Settings\Application Data\OSIsoft,_Inc\PIDataLink
On Vista/Windows 7:
The piclient.ini is what exists in the install kit and the settings in the piclient.ini file are used when PI DataLink is first installed.
After a user changes the Settings in the Settings dialog, the OSIsoft.PIDataLink.xml automatically file gets created for each individual user. Thereafter, the settings in the OSIsoft.PIDataLink.xml file are what actually get used by DataLink for that user.
For a fresh installation, the user can change the preferred settings in the piclient.ini and push the settings out to each machine. If any changes are made in the Settings dialog by the user, the xml file will get created and be used from that time forward.
For an upgrade scenario, the xml file that already exists for each user will not automatically get upgraded with the settings from the piclient.ini file after the upgrade. There are two ways to push the settings out:
- You can delete the xml files for all users before the upgrade and the settings from the piclient.ini file will be used until the user makes changes in the Settings dialog and the xml file gets created.
- You can distribute a copy of the preferred OSIsoft.PIDataLink.xml to each user. This will not get overwritten during the upgrade.
Note: The piclient.ini can only be used for settings that exist in both the Excel 2003 and Excel 2007 editions of DataLink. The “disableAutoReinit” setting does not exist in Excel 2003, so if the user wants to push out that setting to all installations, they will need to distribute the setting in the OSIsoft.PIDataLink.xml file to each user. The xml file is intended to be the new standard for storing DataLink settings in Excel 2007 and later.
Some of the setting values are different between piclient.ini and the OSIsoft.PIDataLink.xml file listing.
Here is a comparison of some of the settings in the two files:
[ADDINS] copytags=column copyserver=no servtimeopt=no displayendtimeopt=no displayNA=no localeindependent=no disableResizeMessage=no [EXCEL] nformat=General tformat=dd-mmm-yy hh:mm:ss
<?xml version="1.0" encoding="utf-8"?> <Settings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <CTPDockWidth>200</CTPDockWidth> <CTPFloatLeft>-1</CTPFloatLeft> <CTPFloatTop>-1</CTPFloatTop> <CTPFloatWidth>200</CTPFloatWidth> <CTPFloatHeight>-1</CTPFloatHeight> <CTPDockPosition>right</CTPDockPosition> <CopyItemsInRow>0</CopyItemsInRow> <CopyServerName>0</CopyServerName> <UseServerTime>0</UseServerTime> <DisplayEndTime>0</DisplayEndTime> <DisplayNA>0</DisplayNA> <LocaleIndependent>0</LocaleIndependent> <DisableAutoReinit>0</DisableAutoReinit> <DisableResizeMessage>0</DisableResizeMessage> <NFormat>General</NFormat> <TFormat>dd-mmm-yy hh:mm:ss</TFormat> <AutoUpdateCalculateMode>1</AutoUpdateCalculateMode> <AutoUpdateInterval>0</AutoUpdateInterval> </Settings>
If you need further information please contact OSIsoft regular Tech Support as they would be better equipped to answer this types of system administration questions.
Is there a way to disable the task pane through VBA?
You would have to edit the XML file above per each user on the machine; there is no programmatic exposure of the setting or property. For this specific change in settings set the following value to 1 (which is 0 by default):