Feature #1511
Updated by Krishna Kanth A 5 months ago
Hi Bhanu Sir,
Could you please configure for new input to output file conversion process as per below.
1) Please display a new value "Balaji Structure Format" for the dropdown field Device
2) Please Create a new text field in the File Upload Screen to Enter 15 character Test by the user when the Device dropdown value is Selected as "Balaji Structure Format".
Input File:
00540,000974,197890 ,000001,16-04-24,12345678
01807,002500,GEETA G MAGI ,002600,15-04-24,000200
The Above file is a input file for the pigmy uploading process:
1.Here,the first line Defines:
00540,000974,197890 ,000001,16-04-24,12345678
MEANING OF FIRST LINE AS FOLLOWS
Field No. Field name Length of field
1 Agent’s account no. 6
2 Total No. of Receipts 6
3 Total collection amount 16(6 zero appointed)
4 Bank and Agent’s Code 6 (first 3 for bank and 3 for agent)
5 collection date (current date) 8 (DD.MM.YY)
6 Password 8 (first 4 AGENT & next 4 MANAGER)
2.Second line,Defines:
01807,002500,GEETA G MAGI ,002600,15-04-24,000200
MEANING OF 2ND LINE AS FOLLOWS
Field No. Field name Length of field
1 Account No. 6
2 1 day collection 6
3 customer name 16
4 Closing Balance 6
5 opening date 8
6 collection amount 6
===========================================================================================================================
Output File field Sequence will be as Shown below
Sequence No Field name Type of Data Length of data Input Line Number Details to pick the Field
1 Branch Id Numeric 15 To be entered by the User in the Text field
2 Category Code Numeric 1 Default to '1'
3 Scheme Code Char 5 Default to 'PIGMY'
4 Account No. AlphaNumeric 15 Line 2, Field 1
5 Customer Id Numeric 6 Default to '000000'
6 Customer Name Text 50 Line 2, Field 3
7 Closing Balance Decimal 13 Line 2, field 4
8 Agreed Amount Decimal 8 Default to '00000.00'
9 Closing Balance Date Date Format 10 Default to '31-03-2024'
10 Agent ID AlphaNumeric 15 Line 1 ,Field 1'
11 Amount Collected Decimal 10 Line 2 ,Field 6 (Ex:00000200.00)
12 Date of Collection Date format 10 Line 1 , Field 5 ("DD-MM-YYYY"--Required output format)
13 Blank Space Null 1 put one blank Space
14 Time of collection Time 5 Default to "00:00"
15 Transaction No. Numeric 4 Default to "0000"
16 Sequence Numeric 4 Default to "0000"
17 Blank Space Null 16 Default to 16 Null characters
Defining the format as below:
1.Branch Id :Here, By Default we are giving =000000000000101 (Need textbox entry in screen for Branch Id)
2.Category Code: Here, By Default we are giving =1
3.Scheme Code :Here, By Default we are giving =PIGMY
4.Account No :They have given only 5 digit account number :01807 so,based on the given structure format they have defined length as "15" so
in this case in prefix we need to adjust '0's :000000000001807 ( Account No. field from 2nd line of input file)
5.Customer Id: In progress..
6.Customer Name: For the customer name in input file they have give as:GEETA G MAGI ,the length given in input file was "17".So, based on
the given output structure file length should be "50" :GEETA G MAGI ( Customer Name: field from 2nd line of input file)
7.Closing Balance: Given closing balance was : 002600 .Based on the given struture format length defined as "13" :0000002600.00(Here,we are adding perfix to
adjust the length and also adding decimal to indicating that as an amount)-(Closing Balance: field from 2nd line of input file)
8.Agreed Amount: Here, By Default we are giving =00000.00
9.Closing Balance Date :By Default we are giving =31-03-2024
10.Agent ID : In Input fist line they given as :00540 .Here, the structure length should be "15".So here, we adding perfix :000000000000540.( Agent’s account
no: field from 1st line of input file)
11.Amount Collected:Given amount collected was :000200.Based on the given struture format length defined as "10" :0000200.00(Here,we are adding perfix to
adjust the length and also adding decimal to indicating that as an amount) and (collection amount: field from 2nd line of input file)
12.Date of Collection:we need take the date of collection in First line of the input file :16-04-2024 (collection date: field from 1st line of input file)
13.Blank Space: One Blank space
14.Time of collection: By Default we are giving = 00:00
15.Transaction No:By Default we are giving =0000
16.Sequence:By Default we are giving =0000
17.Blank Space:We need to maintain "16" Blank space on the given structure.
Output:
0000000000001011PIGMY000000000001807000000GEETA G MAGI 0000002600.0000000.0031-03-20240000000000005400000200.0016-04-2024 00:0000000000
Device name:Balaji Machine