Search This Blog

LIC_TEXT_TO_POS_BULK_UPLOAD_FILE_CREATOR Version 1.0.0 - For Postal Department

This tool is provided to create CSI POS bulk upload file from raw text file received from LIC of India who is presenting special journal of franked registered articles. If LIC is not giving excel sheet or CSV file to be uploaded in POS, request LIC to send raw text file which is used for printing the hard copy of special journal. This tool will analyze the text file and convert the file into CSV file or XLS file there by eliminating data entry work at PO.

Step by step procedure is as follows

Main screen view

Sample text file received from LIC of India

New batch to load text file

Text file loaded

Loaded unprocessed text file view

It is needed to process every article, because the text file may not be complete in all respect. Some omission and commission will be there like omission of pincode, invalid pincode, invalid name and address, invalid barcode and so on.

Processed articles view

Creation of upload file either in CSV or Excel format

Save dialog box. Default location is desktop

Upload file created

Created upload file in xls format opened with MS-Excel

About dialog

Download Link :

Thanks & Regards,
Postal Assistant
Vaniyambadi SO - 635751.
Next Post »