Project

General

Profile

Actions

Feature #1505

closed

EDGAR Device - Output File Conversion - ERP Format - (Requirement 2)

Added by Krishna Kanth A 5 months ago. Updated 3 months ago.

Status:
Closed
Priority:
Normal
Start date:
20/11/2024
Due date:
% Done:

0%

Estimated time:
Deployed In:
Production Environment
Category:

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

Actions #1

Updated by Krishna Kanth A 5 months ago

  • Description updated (diff)
  • Assignee set to Durga Konduru
Actions #2

Updated by Krishna Kanth A 5 months ago

  • Description updated (diff)
Actions #3

Updated by Durga Konduru 5 months ago

  • Status changed from New to In Progress
  • Assignee changed from Durga Konduru to Bhanuchander Sannidhanam
Actions #4

Updated by Krishna Kanth A 5 months ago

  • Status changed from In Progress to Ready for QA
  • Deployed In set to QA Environment
Actions #5

Updated by prathyusha Ramisetti 5 months ago

  • Status changed from Ready for QA to Ready for StgDmo
Actions #6

Updated by prathyusha Ramisetti 5 months ago

  • Assignee changed from Bhanuchander Sannidhanam to Venkata Suryateja Thripuraribhotla
Actions #7

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

Tested in Stage Successfully.
Output Files uploaded in the attached file.

Actions #9

Updated by Krishna Kanth A 5 months ago

Tested in Production Successfully.

Actions #10

Updated by Redmine Admin 3 months ago

  • Status changed from Ready for Prod to Closed
Actions

Also available in: Atom PDF