Financial Inclusion/Accelerator
File Upload
User Guide
Information in this document is subject to change
without notice.
No part of this document may be reproduced or
transmitted in any form or by any means, for any
purpose, without the express written permission
of TEMENOS HEADQUARTERS SA.
© 2022 Temenos Headquarters SA -
all rights reserved.
File Upload User Guide
Table of Contents
Document History .................................................................................................................................................................................. 4
Introduction ............................................................................................................................................................................................. 5
Document Purpose ........................................................................................................................................................................... 5
Assumptions........................................................................................................................................................................................ 5
References ........................................................................................................................................................................................... 5
File Upload: Operations ........................................................................................................................................................................ 6
Overview .............................................................................................................................................................................................. 6
Access............................................................................................................................................................................................... 6
Procedure ........................................................................................................................................................................................ 6
Screen .............................................................................................................................................................................................. 6
Processed Files Enquiry ............................................................................................................................................................... 7
SUCCESSFUL RECORDS .................................................................................................................................................................... 8
FAILED RECORDS .............................................................................................................................................................................. 9
UNAUTHORIZED RECORDS............................................................................................................................................................... 9
ARCHIVING ..................................................................................................................................................................................... 10
File Upload: Configuration ................................................................................................................................................................. 11
Upload directory ............................................................................................................................................................................. 11
BrowserWeb war file configuration ........................................................................................................................................... 11
browserConnection.xml ........................................................................................................................................................... 11
channels.xml ............................................................................................................................................................................... 11
browserParameters.xml ........................................................................................................................................................... 12
tocfee.ear configuration ............................................................................................................................................................... 12
tcserver.xml ................................................................................................................................................................................. 12
jboss-ejb3.xml ............................................................................................................................................................................. 13
ejb-jar.xml .................................................................................................................................................................................... 14
File Upload Parameterisation ...................................................................................................................................................... 15
EB.FILE.UPLOAD.PARAM .......................................................................................................................................................... 15
DFE parameterisation .................................................................................................................................................................... 16
Create upload and archive directories ................................................................................................................................ 16
DFE.PARAMETER ........................................................................................................................................................................ 16
Service configuration..................................................................................................................................................................... 17
BATCH ........................................................................................................................................................................................... 17
TSA.SERVICE ................................................................................................................................................................................ 18
File Upload: Customization ............................................................................................................................................................... 19
Overview ........................................................................................................................................................................................... 19
2 Financial Inclusion/Accelerator File Upload
File Upload User Guide
DFE Parameter ................................................................................................................................................................................ 19
DFE Mapping.................................................................................................................................................................................... 20
File Upload Type ............................................................................................................................................................................. 23
BATCH ................................................................................................................................................................................................ 26
Notes ........................................................................................................................................................................................................ 27
3 Financial Inclusion/Accelerator File Upload
File Upload User Guide
Document History
Author Version Date
Pawel Adamczyk 1.0 4th June 2018
Pawel Adamczyk 1.2 21th June 2018
Esther Muniu 1.3 28th June 2018
Pawel Adamczyk 1.4 29th June 2018
Pawel Adamczyk 1.5 10th October 2018
Isa Omba 1.6 13th December 2022
Comments:
13th December 2022 – updated with new corporate branding
4 Financial Inclusion/Accelerator File Upload
File Upload User Guide
Introduction
Document Purpose
This document provides an overview of the File Upload functionality and describes how the functionality can be
configured to meet specific business requirements.
Assumptions
It is assumed that the reader of this guide is proficient in the Temenos Core Banking system, worked with the
Browser channel application and understands the structure and navigation of the Financial Inclusion Role Based
Home Pages. For configuring the functionality, it is assumed that the reader has prior implementation experience
and understands the technical concepts of the Temenos Core Banking system.
References
Financial Inclusion Role Based Home Pages user guide.
Data Formatting Engine (DFE) User Guide.
5 Financial Inclusion/Accelerator File Upload
File Upload User Guide
File Upload: Operations
Overview
The Financial Inclusion File Upload functionality supports the day-to-day operations of the Institution by providing
a mechanism through which bulk files may be uploaded from external applications e.g. Excel, and processed in
the Financial Inclusion. Examples include uploading of staff loan repayments in bulk deducted at source through
the payroll. Both financial and non-financial files can be uploaded with the appropriate configuration in place, as
described later in this document.
The File Upload functionality is hinged on the T24 Data Formatting Engine (DFE) which is a common interface
framework designed in such a way that it supports both uploading of messages/files received from external system
into T24 as well extract data from T24. The application supports delimiter based files and fixed position messages/
files.
Access
All in one RBHP>>Home>>File Upload
Procedure
1. Click on the Upload New File icon
2. Enter all the required data on the fields as described below
3. Commit the record and authorise
Screen
Field name Description
Description Enter a meaningful description of the file to be uploaded.
Upload Type The File upload type is defaulted.
Processing Type The DFE parameter file used to process the file upload. BNK-
EM.FU.FUNDS.TRANSFER record is set as the default but should be
amended suitably whenever different file types are to be uploaded. E.g.
Non-financial data upload. For further details please refer to the DFE
Parameterization section below.
6 Financial Inclusion/Accelerator File Upload
File Upload User Guide
File Name Click on “Choose File” to browse files and select the file to be uploaded.
The click on the icon to confirm the upload. Successful upload status
will be shown as follows:
Upon authorization, transactions are automatically generated in the target application and results presented in
the enquiry described below.
Processed Files Enquiry
Field name Description
File Name The .csv file name as saved on your PC or Server.
Target Application The T24 application where records will be created from the upload data.
Description The upload file description
Total Amount The total amount of the records uploaded and processed
Lines No. The total number of records uploaded and processed
INAU Records successfully processed (created in T24 from the uploaded file)
awaiting authorization
IHLD Records uploaded but T24 records could not be created successfully and
therefore put on hold awaiting manual intervention.
Upload Date The File upload date
File status The File processing status
7 Financial Inclusion/Accelerator File Upload
File Upload User Guide
SUCCESSFUL RECORDS
This icon drills down to the list of successfully uploaded records as shown below. In addition to the file name
and description, the enquiry displays the total number and total amount of the successfully uploaded records as
compared to the total records uploaded. Before authorization, transactions can be viewed or amended using the
icon.
8 Financial Inclusion/Accelerator File Upload
File Upload User Guide
FAILED RECORDS
This icon drills down to the list of unsuccessful records that failed processing. Meaning that the FT
transactions could not be created successfully. Such records remain in IHLD status until manually fixed through
icon or deleted.
UNAUTHORIZED RECORDS
This icon drills down to the list of records awaiting authorization. The records are presented in a Fast Path enquiry
that allows authorization (or deletion) of records in bulk. By clicking on the icon in the enquiry header, all
records are selected. Authorization action can then be triggered by committing the “Authorise FT” function as
highlighted below.
Upon authorisation
9 Financial Inclusion/Accelerator File Upload
File Upload User Guide
ARCHIVING
The list of fully processed files grow over time and may need to be archived from time to time. Click on this
icon to archive fully processed files. All records in the files must either be authorized or deleted, before file
archiving. Where this condition is not met, an error message is displayed as below.
10 Financial Inclusion/Accelerator File Upload
File Upload User Guide
File Upload: Configuration
Upload directory
Before configuring, user must first define where they want to store the uploaded files and then create the directory.
For this document's purpose, the following path is used:
C:\Temenos\R16\ENV\mcb16devTAFJ\upload
BrowserWeb war file configuration
browserConnection.xml
This file is present under …\BrowserWeb.war\WEB-INF\classes\
Edit the file and setup browser.1 channel as below.
channels.xml
File present under …\BrowserWeb.war\WEB-INF\classes\.
Please mention the NAME, PORT, & HOSTNAME parameter values as shown below. The NAME
parameter value should be the same as channel name defined in a browserConnection.xml
11 Financial Inclusion/Accelerator File Upload
File Upload User Guide
browserParameters.xml
This file is present under …\BrowserWeb.war\
Ensure that parameter value for fileUploadChannel is the same as channel name defined in a
browserConnection.xml (browser.1).
tocfee.ear configuration
Deploy appropriate tocfee.ear file
tcserver.xml
tcserver.xml file is available in tocfplugin-ra.rar present in tocfee.ear file
Edit tcserver.xml file and add new listener. Note that listener id and port number must be the same as values used
earlier in a browserConnection.xml. Download and upload paths have to point to upload directory created earlier
(C:\Temenos\R16\ENV\mcb16devTAFJ\upload in our example). As per the screenshot below.
12 Financial Inclusion/Accelerator File Upload
File Upload User Guide
jboss-ejb3.xml
jboss-ejb3.xml file is available in tocflistener-ejb.jar\META-INF present in tocfee.ear file
Edit jboss-ejb3.xml and add the same listener used earlier in a tcserver.xml (browser.1) in OFSListenerMDB tag.
As per screenshot below.
13 Financial Inclusion/Accelerator File Upload
File Upload User Guide
ejb-jar.xml
In the same location edit ejb-jar.xml and add the same listener used earlier in a tcserver.xml (browser.1) in
OFSListenerMDB tag. As per screenshot below
14 Financial Inclusion/Accelerator File Upload
File Upload User Guide
File Upload Parameterisation
EB.FILE.UPLOAD.PARAM
In EB.FILE.UPLOAD.PARAM > SYSTEM record specify the upload directory path. It has one record SYSTEM, which
will contain the path to where the tcserver/tocf will upload the file to the T24. The upload path specified here
should be the same as the one defined earlier for tcserver listener (tcserver.xml file) <UPLOAD_PATH> tag.
15 Financial Inclusion/Accelerator File Upload
File Upload User Guide
DFE parameterisation
Create upload and archive directories
In upload directory created in Upload directory section (C:\Temenos\UAT-ENV\bnk\tcupload in our example)
create EM.UPLOAD directory and second ARCH subfolder.
DFE.PARAMETER
This is the overall parameter table to define the file type, mode of transaction and corresponding upload path. This
file holds the details of the system wide parameters that are required to run the DFE Frame Work.
BNK-EM.FU.FUNDS.TRANSFER record is delivered with the T24 EM update. Please amend the record and specify
paths accordingly with created in above section.
Based on BNK record create other records for every company, each record should be prefixed by company
mnemonic e.g. CNK-EM.FU.FUNDS.TRANSFER. Based on that prefix Company Code field will be defaulted. This is
required by DFE functionality and has to be done for every company that will use file upload functionality.
16 Financial Inclusion/Accelerator File Upload
File Upload User Guide
Parameterization record will be defaulted on file upload screen
If different DFE parameterization should be defaulted please specify this in EB.PARAM>ALL-EM.FILE.UPLOAD
record
Service configuration
BATCH
Please edit BATCH record XXX/EM.DFE.FILE.PROCESS for every company (that will use file upload functionality)
updating Data.1.1 and Data.2.1 fields with appropriate DFE.PARAMETER record ID.
When using DFE parameters delivered in EM update please setup XXX-EM.FU.FUNDS.TRANSFER where XXX is
company mnemonic.
17 Financial Inclusion/Accelerator File Upload
File Upload User Guide
TSA.SERVICE
Amend TSA.SERVICE record for every company (that will use file upload functionality) and setup USER and
SERVCIE.CONTROL fields as below.
18 Financial Inclusion/Accelerator File Upload
File Upload User Guide
File Upload: Customization
Overview
Inclusive Banking File Upload functionality delivers by default FUNDS.TRANSFER upload parameterization that
allows user to upload file with payments details. The User is allowed to configure on his own new file types that
will allow upload to any T24 application.
DFE Parameter
DFE is a T24 interface that allows uploading files received from external system into T24. DFE is preconfigured to
allow its use in Islamic Banking module.
File upload DFE Parameters are available in System Parameters section > File Upload tab.
Please note that this enquiry lists only “In” type records for the company user is logged in.
New DFE Parameter can be created using button above the enquiry.
Please be aware DFE requires separate parameterization record for every company. While creating new record
system will automatically add company prefix (that user is logged in) to ID given by user. At the same time user
can create record for any other company by providing correct company mnemonic prefix (e.g. BN1-
EM.FU.CUSTOEMR.IND).
19 Financial Inclusion/Accelerator File Upload
File Upload User Guide
Some fields are defaulted by the system for the rest please refer to DFE User Guide.
Please make sure File Path and Archive Path points to directories created in Configuration section and are in line
with File Upload Type. DFE-Mapping ID is described in following section.
DFE Mapping
This table is used to define the mapping for upload file. The data which is received by DFE uses the Mapping Table
to match each field from within that raw data (from the file) with T24 field. Mapping table is used to match columns
from the file with fields from the T24 table that data is uploaded to.
DFE Mappings are available in File Upload Parameterization > DFE Mappings screen.
Please note that enquiry shows only mappings prefixed with “EM.FU”, the same prefix is used when new mapping
record is created.
20 Financial Inclusion/Accelerator File Upload
File Upload User Guide
Some fields are defaulted by the system (with the values required by InclusiveBanking process). For the rest please
refer to DFE User Guide.
21 Financial Inclusion/Accelerator File Upload
File Upload User Guide
There are few fields added for Inclusive Banking process, please note below fields from Field Mapping tab need to
be populated:
Field Description
Amount Column Defines number of column in the file that holds amount that should be
counted to show total file amount displayed on Processed Files enquiry.
Enq Authorise Lines This is the enquiry that will be used as the authorise dropdown on Processed
Files enquiry.
Enq Succeed Lines This is the enquiry that will be used as the dropdown on Processed Files
enquiry to view successful records
22 Financial Inclusion/Accelerator File Upload
File Upload User Guide
Enq Failed Lines This is the enquiry that will be used as the dropdown on Processed Files
enquiry to view failed records.
Processed enquiry that below fields refer to is available in Home section > File Upload tab.
File Upload Type
File Upload functionality allows user to upload external file in to the server. In File Upload Types
parameterization user can define below details:
23 Financial Inclusion/Accelerator File Upload
File Upload User Guide
Field Description
Upload Directory That is subdirectory of the folder defined in EB.FILE.UPLOAD.PARAM and
tcserver.xml. Please note that the path to this directory needs to be configured
in DFE Parameter so uploaded files are picked up and process by DFE.
File Extension Upload File extension
Max File Size Maximum size for upload file
Separator Column separator
Please note that different DFE parameters does not requires separate EB.FILE.UPLOAD.TYPE records. New type is
required only if different file extension or separator is required.
Single File Upload Type can have multiple DFE Parameters configured. In practice this means that different file
structures are achievable with single EB.FILE.UPLOAD.TYPE and multiple DFE.PARAMETER records. In this case
correct DFE.PARAMETER records needs to be provided in Processing Type field when file is uploaded.
Additionally Processing Type is defaulted with DFE.PARAMETER id setup in EB.PARAM>ALL-EM.FILE.UPLOAD
record. Value in the parameter should be without company mnemonic prefix which will be added during defaulting
Processing Type filed.
24 Financial Inclusion/Accelerator File Upload
File Upload User Guide
25 Financial Inclusion/Accelerator File Upload
File Upload User Guide
BATCH
For every new DFE Parameter that should be process by the system BATCH records has to be updated or new
BATCH record created.
In multi-company environment separate BATCH record for company has to be updated as shown below. Adding
DFE.INWARD.PRE.PROCESS and DFE.INWARD.FILE.PROCESS jobs (second one with DFE.INWARD.PRE.PROCESS
verification). In Data field providing DFE.PARAMETER ID for this company.
26 Financial Inclusion/Accelerator File Upload
File Upload User Guide
Notes
Use this page to record your own notes.
27 Financial Inclusion/Accelerator File Upload
