Saturday, August 11, 2018

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


LIC_TEXT_TO_POS_BULK_UPLOAD_FILE_CREATOR Version 3.0.0
======================================================
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
919444227090
sakthiveluvm@indiapost.gov.in

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


LIC_TEXT_TO_POS_BULK_UPLOAD_FILE_CREATOR Version 2.0.0
===================================================

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 : http://bit.ly/2vjUKhc

Thanks & Regards,
Rajendran.M
Postal Assistant
Vaniyambadi SO - 635751.

Monday, July 30, 2018

Sunday, July 29, 2018

CSI POS BULK UPLOAD FILE Creator Version 4.0.0


New version of CSI POS BULK UPLOAD FILE Creator
=========================================================
What is new in version 4.0.0
===================================================

1. New UI.

2. Added support of file creation in TXT file format.

3. Compatible with POS version 4.

4. Batch concept is dispensed with separate screen for every category of articles.

5. Auto saving of batch with ID of every category up to 5 bulk.

6. Auto deletion of bulk older than 5.

7. Added support for bulk IPO.

8. Added support for bulk VPL/VPP.

9. Added support for either pincode or post office search in every category of data entry screen.


Version History : Version 3.0.0
===================================================

1. Added support for bulk Service RLs.

2. Added support for creation of upload file in Excel (XLS) file format.

3. Data entry in auto CAPS mode is added.

4. Auto entry in REF field is removed.

5. As XLS file is creation feature is added, this tool name is changed from "CSI POS BULK UPLOAD CSV Creator" to "CSI POS BULK UPLOAD FILE Creator".

6. Minor UI changes in data entry as well as find pincode.

Version History : Version 2.0.0
===================================================

1. Added support for bulk EMO.

2. Added support for bulk articles with cash.

3. Added support for franchise outlet.

Version History : Version 1.0.0
===================================================

1. Support for COD, BNPL, Prepaid With PS/SS/FM.

Help :
===================================================

1. This tool is provided to process bulk articles and generate CSV or XLS of TXT file to be upload in CSI POS. This tool supports BPCOD, BNPL, Prepaid bulk articles with PS/SS/FM, EMO, Bulk articles without prepaid postage, Articles presented by Franchise Outlet, Service Articles, VPL/VPP and IPO.

2. This tool is designed in such a way to enhance the speed of making data entry with ease.

3. Barcode validation is provided to avoid wrong entry of invalid barcode.

4. It is designed to support batch by batch processing of bulk articles. The batch is not bound with any particular date. That means that processing of a particular bulk of articles can be continued for more than one day. Five batches are auto saved with ID. Batch older than five will be auto deleted.

5. It will be more easy if the articles are sorted pincode and then weight and then amount wise before processing.

6. To delete any wrong entry of any article select the wrong entry and give delete.

7. To edit article menu is removed.

8. To create bulk upload file click create file and save it. The default location is desktop.

9. To find either pincode or postoffice click pincode. Searched pincode can be exported to CSV file and then can be viewed in MS-Excel.

10. This tool is not for bulk foreign articles.

That's it.

Download Link : http://bit.ly/2LYcDbM

Thanks & Regards
Rajendran.M
Postal Assistant
Vaniyambadi SO 635751.