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
Updated by Krishna Kanth A 5 months ago
- Description updated (diff)
- Assignee set to Durga Konduru
Updated by Durga Konduru 5 months ago
- Status changed from New to In Progress
- Assignee changed from Durga Konduru to Bhanuchander Sannidhanam
Updated by Krishna Kanth A 5 months ago
- Status changed from In Progress to Ready for QA
- Deployed In set to QA Environment
Updated by prathyusha Ramisetti 5 months ago
- Status changed from Ready for QA to Ready for StgDmo
Updated by prathyusha Ramisetti 5 months ago
- Assignee changed from Bhanuchander Sannidhanam to Venkata Suryateja Thripuraribhotla
Updated by Krishna Kanth A 5 months ago
- Deployed In changed from QA Environment to Stage Environment
Updated by Krishna Kanth A 5 months ago
- File Krudi PACS EDGAR 28-10-2024-Upload(input file)_Output (1).txt Krudi PACS EDGAR 28-10-2024-Upload(input file)_Output (1).txt added
- File 1505_Devices.jpg 1505_Devices.jpg added
- File 1505_OutputFileImage.jpg 1505_OutputFileImage.jpg added
- File 1505_Version.jpg 1505_Version.jpg added
- Status changed from Ready for StgDmo to Ready for Prod
Tested in Stage Successfully.
Output Files uploaded in the attached file.
Updated by Krishna Kanth A 5 months ago
- File KrudiPACSEDGAR28-10-2024-Upload(inputfile)_Output_Prod_02Dec_2024.txt KrudiPACSEDGAR28-10-2024-Upload(inputfile)_Output_Prod_02Dec_2024.txt added
- Deployed In changed from Stage Environment to Production Environment
Tested in Production Successfully.
Updated by Redmine Admin 3 months ago
- Status changed from Ready for Prod to Closed