V3 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. The installer will ensure this is the case.

Note the ini file must be named as : Promenta_Excel_RFC_Service.ini

 

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>
		<debug_sapcon>OFF</debug_sapcon>
		<debug_excel>OFF</debug_excel>
                <Tmp_Path>[IniPath]\tmp</Tmp_Path>
                <WD_Driver>[IniPath]\WebDriver\edgedriver_win64\msedgedriver_[WD_EdgeVersion].exe</WD_Driver>
                <WD_Param>--Port=[WD_Port]</WD_Param>
                <WD_Port>9515</WD_Port>
                <WD_Window>HIDE</WD_Window> <!-- DEBUG, HIDE, *MINIMIZED -->
                <WD_Size>1920x920</WD_Size> <!-- Could also just be MAX or can app add xAPPMID or xMONMID (Default) to position in middle of Excel or Monitor -->
                <WD_SessionBody></WD_SessionBody> <!-- Put [NOTHING] in to send empty capabilities string when starting session -->
	</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>
	
Scroll to Top