Contact : +44-8704467123 & US +1-3025522922
contact@promenta.com

V4 Connection file/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.

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

Generate file automatically

Transaction : /PROMENTA/EXCEL_INI

Mode : “Full file and current system”

You would run this when first needing an ini file for the project (eg in development). This will generate the full ini file containing all global settings and also the current systems specific settings (eg development system)

Mode : “Current system only”

You would run this on each subsequent system (eg QA, Test, Production). This will generate the settings for this specific system only. You would then paste into the ini file the settings. Since 6.43.2.0 you can upload your ini file and the system will perform the merge of the ini file with the new system automatically.

Additional Systems

You need to add additional systems to an existing ini file (for example – you have DEV ini file and now want to add QA and PROD to it)

The recommended approach is to use the automatic generation Transaction : /PROMENTA/EXCEL_INI as per the previous section with option “Current System only”.

Additional Systems when transaction is not available

Customers often need to generate the ini file for all systems in advance of deployment to all systems (eg you have imported Promenta SAP/ABAP into DEV but no where else yet). Hence the transaction /PROMENTA/EXCEL_INI is not available yet in the target system such as QA or PROD

Procedure : when transaction is not available

Here we will generate the URL link using existing SAP services and then manually edit the ini file to add the entries

1] Run transaction SICF

2] Navigate to service /sap/bc/ping —> check it is active and if not active then  activate it

3] Right-click and “Test Service” —> This will launch a browser 

4] Copy/Paste the Generated link into a text editor —> it will resemble

https://<YOUR SERVER>:<PORT>/sap/bc/ping?sap-client=100

Example : https://csap5.prmnt.internal:8443/sap/bc/ping?sap-client=100

5] Extract the first part of the link  —>  https://<YOUR SERVER>:<PORT>

Example : https://csap5.prmnt.internal:8443

5] Append the Promenta service url —>   /sap/bc/bsp/promenta/wfbsp/excelservice.htm

Example : https://csap5.prmnt.internal:8443/sap/bc/bsp/promenta/wfbsp/excelservice.htm

6] Open the DEV ini file in a text editor

7] Find section  <!– PROMENTA_INSERTION_POINT_1 –> in the file

8] Insert the entry described just below the section.

Replace the red parts with your information

Note that the <serviceurl> tag contains the generated link

<system>
     <name>Quality</name>
     <description>Quality System</description>
     <system_id>QU1</system_id>
     <client>100</client>
     <serviceurl>https://csap5.prmnt.internal:8443/sap/bc/bsp/promenta/wfbsp/excelservice.htm</serviceurl>
</system>

9] Repeat for PROD system

ini file : technical information

The ini file consists of global settings which affect all connections and system-specific settings for each system

Overview

The ini file consists of settings which affect all connections and system-specific settings for each system

<?xml version="1.0" encoding="UTF-8"?>
<Promenta_Excel_RFC_Service_Ini>
 <options>
     <!-- control options such as buttons etc -->
  </options
  <connection>
       <!-- Global settings -->
  </connection>
  <mapfmts>
       <!-- custom speadsheet fomats. -->
  </mapfmts>
  <systems>
             <!-- system specific parameters -->
  </systems>
</Promenta_Excel_RFC_Service_Ini>

Option Parameters

This section is used to activate buttons 

        <SendToWorkFlow>YES</SendToWorkFlow>

        <WFStatus>YES</WFStatus>

        <Inbox>YES</Inbox>

        <Validate>YES</Validate>

        <TemplateManager>YES</TemplateManager>

        <PostToSAP>YES</PostToSAP>

        <ParkInSAP>YES</ParkInSAP>

        <chg_tmpl>YES</chg_tmpl>

        <WFS_AutoAddToWbk>FIDOC</WFS_AutoAddToWbk>

        <HelpAI>YES</HelpAI>

Connection parameters

This section controls the connection settings and PCA application 


<Tmp_Path>[StdPath]\tmp</Tmp_Path>

  • Temporary file path. [STDPath] placeholder resolves to the roaming profile 

<PC_Exe>[PCAPath]\PromentaCA.exe</PC_Exe>

  • Path to the PCA application. [PCAPath] resolves to the location of the application.

<PC_Port_Check>YES</PC_Port_Check> 

  • Check the available port for PCA is open

<PC_Port_List>9515</PC_Port_List>

  • List of ports the PCA can use. For single user mode this will be a single port. For shared-server context there will be a range of ports.

<PC_Min_Delay>2</PC_Min_Delay>

  • Internal use only. Do not change.

<PC_Log_History>30</PC_Log_History>

  • Internal use only. Do not change.

mapfmts parameters

This section is used for custom formats and is for Promenta use only

Systems parameters

Each SAP system is listed here along with its parametres

<system>
<name>DEV</name>

  • Name of the SAP system

<description>Development</description>

  • Description of the SAP system shown to users

<system_id>H04</system_id>

  • Technical SYSID of the SAP system

<client>100</client>

  • SAP client

<serviceurl><http://csap5.prmnt.internal:8000/sap/bc/bsp/promenta/wfbsp/excelservice.htm></serviceurl>

  • Service connectrion url

</system>

Scroll to Top