Add-in .ini file
The Add-in .ini file controls the options and connection parameters for the Promenta Add-in.
The .ini file is usually set up by an IT team and then distributed to every user via the install process. As each user must have their own copy of the .ini file then some per-user settings are possible but it is recommended that this is avoided and all users given the same .ini file.
The .ini file is an xml format file and MUST exist in the same directory as the Add-in xlsm file
An example .ini file is include in the delivery zip file
Example file with comments
The example below contain documentation comments – where a comment is “Promenta use only” these values should not be changed
<?xml version="1.0" encoding="UTF-8"?>
<Promenta_Excel_RFC_Service_Ini>
<!-- Connection node : defines the base parameters for connection
to the Webdriver executable and browser behaviour -->
<connection>
<!-- Promenta use only -->
<type>URL</type>
<!-- IE(V1 only), IEMED (V1 only) or WEBDRIVER (V2 only) -->
<browser_mode>WEBDRIVER</browser_mode>
<!-- debug options - Promenta use only -->
<debug_sapcon>OFF</debug_sapcon>
<debug_excel>OFF</debug_excel>
<!-- WD_PATH must point to the LOCAL machine and be the WebDriver folder.
The variable [UserName] will be automatically replaced with teh current users windows user name
All other parameters are Promenta use only
-->
<WD_Path>C:\Users\[UserName]\AppData\Roaming\Promenta\WebDriver\</WD_Path>
<WD_Program>WebDriver.bat</WD_Program>
<WD_Param>1 9515</WD_Param>
<WD_Port>9515</WD_Port>
<WD_Window>MINIMIZED</WD_Window>
<WD_Size>MAX</WD_Size>
<!-- Promenta use only : Override Webdriver Parameters for Portal -->
<WDP_Param>1 9515</WDP_Param>
</connection>
<!-- SYSTEMS LIST - these are connctions to the SAP landscape
- either SAP WAS (BSP/ABAP) or SAP NW Portal -->
<systems>
<!-- customer connection template for PORTAL -->
<system>
<!-- Name of connection -->
<name>Customer Template: DEV Portal</name>
<!-- Description - shown to the user at logon -->
<description>Customer Template: Dev system Portal</description>
<!-- SAP system id -->
<system_id>XX1</system_id>
<!-- SAP client id -->
<client>100</client>
<!-- URL for the connection service - may be SAP Portal -->
<serviceurl>http://portal1.promenta.internal:50000/irj/servlet/prt/portal/prtroot/com.promenta.pct.excelservice.excelservice</serviceurl>
<!-- Portal indicator -->
<portal>YES</portal>
<!-- default alias MCC_R3_SYS will be used if blank and will point to the linked server.
If you have several alias then enter the portal alias here for the SAP landscape connection
The format for specifying an alias is ?SAPALIAS=alias_id. Note the ? is important
-->
<portal_alias>?SAPALIAS=DEV</portal_alias>
</system>
<!-- customer connection template for WAS/BSP/ABAP -->
<system>
<!-- Name of connection -->
<name>Customer Template: DEV-WAS</name>
<!-- Description - shown to the user at logon -->
<description>Customer Template: Dev system via WAS</description>
<!-- SAP system id -->
<system_id>XX2</system_id>
<!-- SAP client id -->
<client>100</client>
<!-- URL for the connection service - may be SAP Portal -->
<serviceurl>http://sap2.promenta.internal:8000/sap/bc/bsp/promenta/wfbsp/excelservice.htm</serviceurl>
<!-- Portal indicators empty (not used) -->
<portal></portal>
<portal_alias></portal_alias>
</system>
</systems>
</Promenta_Excel_RFC_Service_Ini>