Feature #1505
closedEDGAR Device - Output File Conversion - ERP Format - (Requirement 2)
0%
Description
Hi Bhanu Sir,
Request you to please generate data in the output file as per the below Requirements.
This ticket is contiunation to #1496.I was mentioned that there will be multiple devices and multiple versions of input and Output Formats hence it is recommanded to update the input file page to capture requirements from multiple Devices.
Requirements
1) Add a dropdown to select Device Name. (Dropdown should be filled with DEVICEMASTR Table)
2) Both Input and Output files are .TXT files.
3) Output File Name should be "InputFileName_Output.txt".
4) Give Option to download the output file in to local System.
Create a table DEVICEMASTER with following details.
1)DEVICECODE
2)NAME
the Values in DEVICEMASTER
DEVICECODE NAME
1 Device-1
2 EDGAR-1
Sample Record from input file.
0000000000001011pigmy023001485000029101460Mr Alam Pasha 0000010500.0010500.0031/03/202423001484000001 0000500.0015/11/2024 11:5200010001 000000002500903
sample Output Format:
0000000000001011PIGMY003001485000029101460Mr Alam Pasha 0000010500.0010500.0031-03-20240030014840000010000500.0015-11-2024 11:5200010001
Instructions:
1)The output file should have all the information (fields) from the input file with below modifications.
1) From the 17th character Pick '5' characters in the input File Record and convert them to "ALL CAPS".
2) From the 22nd character, Pick all the numeric characters which are before Alphabet character in the input File Record.
3) After picking character as per above condition exclude the last 6 characters.
4) Now check if the length is 15 characters or not, incase the Length is less than 15 characters append required number of Zeros in the prefix to make it 15 characters in Length. In these 15 characters always update the 2nd character as Zero.
5) Pick 5th Character from the Second (/) character till Space in the input File Record.
6) After picking the above characters check if the length is 15 characters or not , incase the Length is less than 15 characters append required number of Zeros in the
prefix to make it 15 characters in Length and in these 15 characters always update the 2nd character as Zero.
Files