Feature #1496
Updated by Krishna Kanth A 8 months ago
Hi Bhanu Sir, There is a Need to develop a small screen/tool to generate data as required for PACS ERP upload. Request you to consider the development of this tool as below: Requirements: 1)A page to be Developed to take a .txt file as tool. Input source is PCTX file1 (textfile) and generate another .txt file as Output as per the given Instructions. output is PCTX file2 (textfile). 2) PACS User should have access Please refer to this page. 3)User should be able to Upload the Input file from his Local System 4) Both Input and Output Attached files are .PCTX(Extension) files. 5)Output File Name should be "InputFileName_Output.pctx". 6)Give Option to download the output file in to local System. 7)Give a Provision for Administrator to Specify Number of characters per line in a file. 8)The Conversion Process should verify number of characters in each line as per the Number provided in Point 7. Any mismatch in the count should be reported to the User along with the Line Number. 9) Conversion should happen only if all lines satisfy the length Criteria. Sample Complete details. Example one record from Input File: File 0000000000001012pigmy020001185000047200028Balageri Lakshmana 0000004750.0000100.0004/11/202420001184000001 10/06/202404/11/2024 Output Format/Columns: 1) Account No.--020001185000047 -Consider 6 characters from 32nd Position No. (Account No ) --020001185000047 =MID(A1,22,6) 2)2,3 2,3 days collection --0100.00 --Consider 6 characters from 109th Position 3)customer (Agreed Amount) --00100.00 00100.00 =MID(A1,106,6) customer name (Name) --Balageri Lakshmana --Consider 16 characters from 43rd Position 4)balance Amount --750.00 --Consider 6 characters from 101th Position 5)collection date--04/11/24 Consider 10 characters from 149th Position =MID(A1,43,16) 6)Agreed balance after collection(Balance Amount ) --0000004750.00 =MID(A1,93,6) collection date (Last transaction date ) --04/11/2024 =MID(A1,149,8) collection amount of one day (Agreed Amount) --00100.00 =MID(A1,106,6) 2nd line --0100.00 Expected Output: 000047,100.00,Balageri Lakshma,4750.00,04/11/24,100.00 Kindly note that for the Last Transaction Date Field the Dev Team to trim Consider 6 characters from 109th Position. -- This is Same as 2nd Column. Other Instructions: 1) There will be total 6 Columns the Year value in output 2)Each Column is the YY Format (i.e 24 instead of 2024) to be seperated by ,(Comma) displayed in the Output file. 3)Collection date should be in DD/MM/YY Foramt (Year Kindly refer to be trimmed to the 2 digits) attached files for the Input File and the Pigmy Data Structure. Expected Output: *Note* : The Below mentioned position(Excel file) is wrt the details shared in the attached file Word Document "Pigmy Data Structure conversion" 000047,100.00,Balageri Lakshma,750.00,04/11/24,100.00 Note: =MID(A1,22,6) Sample Files are attached for reference. =MID(A1,106,6) =MID(A1,43,16) =MID(A1,93,6) =MID(A1,149,8) =MID(A1,106,6)