Thursday, February 21, 2019

New URL for Employee Self Service in CSI

A new URL has been provided by TCS for opening employee portal for working in Employee self service. Kindly circulate it among all officials.

Saturday, August 11, 2018

New version 3.0 of LIC_TEXT_TO_POS_BULK_UPLOAD_FILE_CREATOR is released on 11/08/2018

Based on feedback and suggestion from a user, LIC_TEXT_TO_POS_BULK_UPLOAD_FILE_CREATOR tool is updated and new version 3.0.0 is released.

What is new in version 3.0.0
1. Added support for BNPL.
2. Minor UI changes.

Version History : Version 2.0.0
1. New UI
2. Added support for text file creation.
3. Compatible with POS version 4.
4. Minor UI changes.
5. Added support for data entry in auto caps mode.

Version History : Version 1.0.0
1. Support for csv and xls file creation.
Thanks & Regards, Rajendran.M Postal Assistant Vaniyambadi SO - 635751.

Monday, August 6, 2018

Revised ebiller payments process in CSI Environment

Dear CIT teams,
The following instructions may please be circulated to all concerned immediately:

The amount due to be paid to a biller in e-Payment may please be generated using zfi_ereport_ebl_all

The select criteria, presently available has from………….to……. date range. It is instructed to restrict to a single date range till such time further instructions are issued. (The report should be generated for a selected date)

This out put summary for the selected date may please be matched in F-58 code

If both are matching – Please process the payment further and proceed and complete the procedures

If both are not matching – Please raise a ticket and share the ticket ID and details through email to DMCC for further action

This exercise will have to be communicated to all concerned immediately

Further communication will be issued in this regard, until such time, the nodal offices of e-payments may kindly be instructed to follow these instructions.

Yours Sincerely,
(V M Sakthivelu)
Deputy Director CEPT

Sunday, August 5, 2018

Generate City Names and PO Names from PIN codes for CSI Bulk Upload

To simplify the tedious process of typing City Names in Excel bulk template, this file is created.  If PIN CODES are pasted (To be copied from Excel template) in one column, City names and P.O. names will be populated automatically.

Just copy the data populated in those two columns and paste them in CITY , ADDRESS columns of Excel templates.

Because of this, hereafter no need to type City names and P.O. names in Excel templates for large volume of bulk articles going to be uploaded through bulk templates in CSI Point of sale.

Bulk Booking of Articles in CSI Point of Sale through Excel File Upload

Excel templates are available in CSI Point of Sale software (POS>> Business Services >> Upload Bulk/Upload Prepaid Bulk >> Click "?" help icon on the top right >> Click link in Web page) which can be copied and used for uploading of Bulk articles received from BNPL customers and Prepaid articles (affixed with PS, FM, SS) received from various bulk customers/Bulk Postal Service letters 

Most of the Data like Name, Address 1, Address 2, Destination City, PIN codes, Mobile numbers are provided by the most of the bulk BNPL customers/ prepaid bulk senders in Excel files through email/CD as these basic data are already available with them in their system/database.

Few bulk customers also include Article Barcode numbers in the Excel sheet provided by them, if barcode series already supplied to them.

Using those basic data, we may have to carry out certain COPY, PASTE, EDIT, FORMAT works only in prescribed Excel templates for making the file ready for uploading.

Only very few customers who are not using system generally refuse to provide above said basic data in Excel file. For those articles only we may be supposed to prepare Excel template. 

In such cases, 
Doing Data entry of Articles data in Excel template itself is the easier one comparing to using various data entry tools meant for creating bulk templates. 

Advantages of doing Data entry in Excel template itself: 

1) Sl.No., Reference number, weight, Prepaid mode, FM license ID, SOM Numbers all can be easily filled in Excel by using just drag down (fill series/ copy cells) option in Excel as the case may be.

2) Barcode numbers can be scanned continuously as after scanning each and every article, cursor automatically move to next cell in lower row. Scanning of articles can be easily done in Excel file (Sequence of articles should not be shuffled till successful upload of articles).

3) Moving from one cell to another is very easy (by using enter / navigation arrows) while doing Data entry in Excel template when comparing to tedious data entry process in Point of sale / Any other Data entry tool similar to point of sale booking screen.

Caution :

1) Sequence of articles while doing Data entry and scanning articles should be same. Should not be shuffled at any cost till uploading in POS bulk upload.

2) PIN code field has to be uniformely changed to number format (using format cells).

3) Always save the Excel in ".xls" file format. Please don't save in ".xlsx" file format.

4) Tally total number of articles before uploading.

5) Delete any other additional rows/columns (with any data) unknowingly available below actual rows to be uploaded.

6) Please don't type name/address more than 40 characters as prescribed.

7) All mandatory fields should be filled in the template (SL.No, Ref No., Barcode no., Name, Address 1, Address 3, City, PIN, weight). For prepaid bulk, mode of prepaid, Prepaid amount should be entered. For FM prepaid bulk, FM license ID and SOM should be additionally entered.

New version 2.0 of LIC_TEXT_TO_POS_BULK_UPLOAD_FILE_CREATOR is released


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.

What is new in version 2.0.0

1. New UI

2. Added support for text file creation.

3. Compatible with POS version 4.

4. Minor UI changes.

5. Added support for data entry in auto caps mode.

Version History : Version 1.0.0

1. Support for csv and xls file creation.

Download Link :

Thanks & Regards,
Postal Assistant
Vaniyambadi SO - 635751.