21 April 2011

PO TOOLS by Mr.Anand

ANANDA KUMAR K G, System Administrator ,Kunigal SO who has been providing useful Tools for Sanchay Post has pooled all his Tools at:http://potools.xp3.biz
The Tools developed by Mr.Anand are:
Consolidated Savings Bank statement tool:
Tool for generation of statements. It generates the consolidated New accounts opened, Deposits and withdrawals etc., of selected offices for given period. Export option exports the data to csv format file which can opened by Excel.
Database Backup (for SQL SERVER):This is a simple Database Backup tool. It displays all the databases. Only we have to select the databases and folder where the backup should generate.
Sanchay Post Data Extraction :Sanchay Post data extraction tool extracts the data from Sanchay Post in Sub Office / Head Office. Here we can get the date wise consolidation, transaction details by Agent/Bo/Counter wise also.
SO Data Import tool for SBCO :SO/HO data import tool imports the data from files generated by Sanchay Post Data Extraction tool.
Silent Account Revival Tool – Sanchay Post: This is the tool for Revive the SB silent accounts for Sanchay Post. This tool revives the accounts not found/not opened in Sanchay Post. If account no found in Sanchay Post then it skips the posting for that account no. This tool needs the Excel file(available for download) filled by the basic information like Account No, Name, DLT, Year of Silent etc (For Account creation and Interest calculation).
Discrepancy Editor:
This is the tool for edit/clear the discrepancies found in Sanchay Post. By this tool we can solve different kinds of discrepancies easily.
RD Bulk Posting (for Sanchay Post) :
This tool is useful for counter transaction. By using this tool we can post the Agent/Institution Accounts easily. To use this tool Agents should provide the soft copy of Schedule in prescribed format (MS Excel having the columns ACCNO, NAME, DEP, RPW, DF REBATE).
Signature Scan (for Sanchay Post):
Signature Scanner is a simple signature scanning tool which scans the signature by webcam. It has both B/W and Grayscale mode scanning. The size of B/W image is 5 kb and grayscale is 20 kb. Select B/W option for scanning Signatures and grayscale for scanning LTM’s. It can scan signatures/LTM’s directly to database or to a file.
It is said in the website that these tools/utilities are tested on developers system only. if you wish to use these tools, test these tools by taking backup of your data or in another dummy server/client machines. If bugs/problems found please forward the feed back through e-mail to: anand.knlpo@gmail.com

No comments: