Setup Import Files

Follow these steps to proceed:

• Only alpha characters (A-Z) are allowed No numbers or special characters are allowed
• Enter one character per field
• Alpha characters can be entered in upper or lower case
• Alpha characters cannot be duplicated in different fields
• All fields not specifically annotated as optional are mandatory fields
• If headings are included in your Excel file then select the “Headings Included In File” tick box option
• When capturing a mobile, telephone or fax number into the Pay Alert Destination field, the preceding zero / zeroes
  (0722049935, 0027118589999 or 0118589999), will only be displayed in the cell, when the cell’s “Number format”
  has been set to Text.

The following action can be performed:

Once mapping is complete, click on the button

1. All column/field lengths are as follows:
   • Account Number = 13
   • Account Name = 30
   • Statement Ref = 30
   • Date = 8
   • Amount = 15
   • Hash Total Indicator = 1
   • Hash Total = 12
   • Pay Alert Type = 1
   • Pay Alert Destination = 64
   • Branch Number = 6
   • RTGS/RTC = 1



Note: A hash total is a method for ensuring the accuracy of processed data. It is a total of several fields of data in a file,
including fields not normally used in calculations, such as account number.


Note: When capturing a mobile, telephone or fax number into the Pay Alert Destination field, the preceding zero / zeroes
(0722049935, 0027118589999 or 0118589999) will only be displayed in the cell, when the cell’s “Number format” has been set to Text.


2. Valid values for all fields are as follows:
   • Account Number – numeric
   • Account Name – alpha numeric
   • Statement ref – alpha numeric
   • Branch Number - numeric
   • Date format – 20120908
   • Amount – The value may be uploaded with or without a decimal point.For example 100=R100. Only a comma will be acceptable as a thousand spacer
   • RTGS/RTC - N, Y or F
   • Hash Total Indicator – 1 or 2
   • Hash Total – non contra account * the amount
   • Pay Alert Type – S(SMS) or F(Fax) or E(Email)
   • Pay Alert Destination – 0722049935 or 0118589999 or test@test.com respectively

   Special Characters
   Permissible Characters	Invalid Characters
   {Space} Space	` acute accent
   $ doller sign	~ tilde
   & ampersand	! exclamation mark
   * asterisk	# number/hash sign
   ( left parenthesis	% percent sign
   ) right parenthesis	^ not sign
   - hyphen	_ underscore
   + plus sign	{ left curly brace
   = equals sign	} right curly brace
   ; semi-colon	? question mark
   ' apostrophe	¦ broken vertical bar
   , comma	\ back slash
   . period(full stop)	: colon
   / forward slash	" double quotation mark
   < less than	@ commercial at
   > greater than

   
   
   
   
   • The data captured onto the Excel spreadsheet per transaction must appear horizontally (in rows), each individual
     transaction must be captured vertically, i.e. data for transaction 1 will appear in row 1, data for transaction 2 will
     appear in row 2 and so on Row numbers are subject to whether headings are used or not.
   • If Excel cells are merged, mapping will detect the merged cells as one field.
   • Hidden rows in the Excel sheet will be picked up in the mapping process and pulled through during the file import.
   • The mapping process will only factor sheet 1 in your Excel sheet for the process.
   • When capturing a mobile, telephone or fax number into the Pay Alert Destination field, the preceding zero/zero's
     (0722049935, 0027118589999 or 0118589999) will only be displayed in the cell, when
     the cell's "Number format" has been set to Text.