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>