Oct 31, 2014

Speed Net 4.2 Discrepancies Error and Solution

0 comments

Discrepancy Report in Speed Net 4.2

Error Number -2147217900 Error Message [Microsoft][odbc sql server Driver][SQL Server]Could not find stored procedure 'APN_GetOfficesDetails'.

Solution

  • Download attached APN Get Office Details.exl from PoTools.
  • Execute at once using MM Script Tool.

Download


Download


Thanks to
RABINARAYAN CHOUDHURY

Accounts : Income Tax Recovery for Financial Year 2014-2015

0 comments

Income tax Modified in Accounts as per Latest Slap

Accounts Module update for Income Tax Latest Slap recovery for the Financial Year 2014-2015.

Procedure to Update


  • Download attached file from PoTools. 
  • Extract the same, Replace Accounts Exe file with latest one.
  • Execute Income Tax exl using MM Script Tool at once.

Procedure to Recover income Tax in Accounts


  • Select correct financial year
  • Update Master configuration
  • Add other deduction other than salary recovery like  PLI, LIC,PPF etc
  • select yearly check box (Dump the salary yearly)

Download


Get mac address from command line in Windows

0 comments

Get Machine ID using Command Prompt 

We can find mac address (physical address) of a computer using the command ‘getmac‘. This can be used to get mac address for remote computers also. Below are few examples on how to use this command. It works on XP, Vista, Windows 7, Server 2003 and Server 2008 operating systems.

To get mac addresses on the local computer

Just run the command getmac to get the mac addresses. Find an example below.
C:\>getmac
Physical Address    Transport Name
=================== ==========================================================
2C-3F-45-02-1B-32   \Device\Tcpip_{7E49B486-120A-4BC2-2114-B345A4D5C5}
10-13-17-BC-12-48   Media disconnected
22-B3-C5-30-76-78   \Device\Tcpip_{213E8D2A-1DBE-4240-8301-BE6F3EACAF9D}
00-05-2A-3C-78-00   \Device\Tcpip_{F01E3FC2-A5A1-6940-D1A1-C7521AEC4296}
2C-23-45-14-23-AD   Media disconnected
C:\>
This command does not show mac addresses for the network connections which are disabled. You can run ncpa.cpl and check which NICs are disabled.

Get mac address of a remote computer.

We can run the below command to retrieve the mac addresses of a remote computer.
getmac /s remote_computer /u username /p password
remote_computer : Full name of the remote computer or IP address
username and password are of the account on the remote computer.

Example:

C:\>getmac /S remotepc.domain.com  /u administrator /p adminpassword
Physical Address    Transport Name
=================== ==========================================================
22-15-25-9C-3A-29   Media disconnected
34-11-45-7A-9C-48   \Device\Tcpip_{678DD7BB-675D-4E4C-E0AE-A261490EBE8C}
If you do not want to specify the password, you can skip /p parameter. You will be prompted to enter the password and the command execution will take place after that.

Norton Power Eraser (NPE) Google Drive Download

0 comments

Download NPE v4.3.5.28 from Google Drive

Norton Power Eraser is an easy-to-use Windows application designed to help you get rid of computer threats, thus adding an extra layer of security to your system. Beginners should have no kind of problems in figuring it out because everything's pretty intuitive, mostly thanks to the interface.
Download Latest version of NPE

Statement Tool for ePayment Transaction

0 comments

Statement Tool for ePayment  by PoTools


ePayment Statement used to generate ePayment Transaction for the particular period.
  • Download ePayment Statement tool from PoTools.
  • Provide correct Login info to generate the Report.

Download ePayment Transaction Tool


Download

Actually i want to know the Biller ID & Name, No of Bills and Total Amount, visit below link this may help you...

Oct 30, 2014

VP Intimation Tool v5.3 by PoTools

0 comments

VP Intimation Tool v5.3 : Google drive

Added Features:

  • Postman Mobile Number included in Intimation slip.
  • Article Number added in Top of the in RP55 format
  • Font type and Size has been changed.
  • Some Major issues has been fixed.

Configuration


Download


Accountant Pay Bill Drawl Error and Solution

0 comments

Accountant Module Pay draw error

While draw pay for employees in accountant module it may shows the following error

Solution

  • Download attached Script from PoTools.
  • Execute once using the MM Script Tool.

Download


Remove row editing limitation in SQL 2008

0 comments

Remove row editing limitation in SQL 2008

In SQL Server 2008 Management Studio Express , we can change the default settings that allows to edit more than the 200 rows at a time, or select more than 1000 rows.

To modify the “Edit Top 200 Rows” or “Select Top 1000 Rows” settings do the following:


1.Run the SQL Management Studio Express 2008
2.Click the Tools -> Options
3.Select SQL Server Object Explorer . Now you should be able to see the options
*Value for Edit Top Rows Command
*Value for Select Top Rows Command
4.Give the Values 0 here to select/ Edit all the Records

5.Now we can see the Edit All and Select All options on the table.

Thanks to Rajesh H

The new Google Drive : Just faster

0 comments
The new Google Drive is the same Google Drive you know and love, just faster and works more like you’re used to on your computer. You can:
  • Create, add, or upload a file with a single button.
  • Find and add files shared with you more easily.
  • Single-click a file to select it and double-click a file to open it.
  • Drag-and-drop files and folders just like you do on your desktop.
  • Improved accessibility.

What's new with Google Drive

Create, add, or upload a file or folder
Create or add a file of folder by clicking on New. Then, click on one of the icons below to take an action.
IconAction
Create a folder: Just add a folder name and click Create.
Upload a file: Choose a file and click Open.
Upload a folder: Select a folder and click Upload.
Create a new file: Just click on the file type you want to create.
Add or find files shared with you
To easily add or find files shared with you, click on Incoming on the left-hand side navigation. Then, click on one of the icons below to take an action.
IconAction
Locate a file in “My Drive”. You’ll only see this icon if you’ve already added the file to “My Drive”.
Add a file to “My Drive”.
See more actions you can take.
for more information about new google drive visit below link

Oct 29, 2014

Nothing happen while Open/Deposit RD a/c using Tools

0 comments

RD Bulk Account Open / Deposit Tool Not Working

Recently PoTools has been Provided two types of Tool for RD Bulk Account. One is for RD Bulk Account Open for same person another one for RD Account Bulk Deposit in Sanchay Post.

1. RD Bulk Account Open Tool

Using this RD Bulk account open Tool, we can open bulk number of RD accounts for same person in Sanchay Post with in a Minute.


2. RD Bulk Deposit Tool

we can post the continues number of RD account deposit with in a Seconds.


Note: Above mentioned Tool was not working in some of the Offices / Machine.

Solution

Do the following steps to Enable the Option for RD Account Bulk Open / Deposit.
  • Start > Control Panel > Regional and Language Settings.
  • Click on Languages Tab > Details to Open Text Services windows.
  • Check on Turn off advanced text services in System Configuration.
  • Click on Apply and then OK to take Effect.
Now you can Open / Deposit Bulk Number of RD using above mentioned tool.

Fix Error : Package ‘Microsoft SQL Management Studio Package’ failed to load in SQL

0 comments

SQL SERVER – Fix Error – Package 'MSMSP' failed to load

SQL SERVER – Fix Error – Package ‘Microsoft SQL Management Studio Package’ failed to load in SQL Server Management Studio

I recently formatted my computer and re installed my machine and I end up on following error:

Package ‘Microsoft SQL Management Studio Package’ failed to load

Few of the ways to fix the error:


Method 1: Reinstall .NET Framework

Method 2: Start SSMS with Admin privileges

Method 3: Reinstall SQL client with either command prompt or with wizard

Method 4: Delete the registry HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools and try to load the server again 

Note:

If above methods are not working kindly do the SQL Repair. It may surly fix your issues.

Data Profiling Tool v3.5 Google Drive Download Link

0 comments

Data Profiling Tool Download from Drive

Dear Friends, Data Profiling Tool v3.5 is only acceptable by CBS Monitoring Site. So that we have to download version 3.5. 

  • But in DMCC Chennai website latest version 4.5 only available
  • Download DPT version 3.5 from PoTools to update in CBS Monitoring

Download DPT v3.5 Google drive


Download

Oct 28, 2014

Google Drive download: Portable Query Express Tool

0 comments

Query Express - Portable version

Query Express is a simple Query Analyzer look-alike, but being small and free it can be run where the SQL Server client tools are not installed or licensed. This makes it especially useful as a query tool for MSDE and SQL Express. It also connects to Oracle and other OLE-DB compliant databases.

Query Express requires no installation and is packaged as a single 100KB executable. This is more than 300 times smaller than SQL Server Management Studio!

Download Portable SQL Query Express


Download

Thanks to Rajesh H

SQL 2000 Data Import and Export Wizard Issues and Solution

0 comments

Solution for SQL 2000 data Import and Export Issues

Error:'Could not create an instance of DTS Package' while importing or exporting the data in SQL 2000.

Solution: 

Register following DLL files
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\axscphst.dll 
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtsffile.dll 
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspkg.dll 
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspump.dll 
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtsui.dll 

Download


Batch file to register above SQL dlls

Download

Thanks to Rajesh H

Tool to Generate RD Last Balance Report in Sanchay Post

1 comments

Generate RD Last Balance report in Sanchay Post


Pre- requisite:

  • MS Office 2003 should be installed.
  • MS SQL 2000 or Higher version.
  • MSHFLGD.ocx should be registered

Procedure to Generate RD Last Balance Report

  • Tool should be executed in Sanchay Post Installed SO/HO.
  • For Sub Office enter DB Name as POST.
  • For Head Office enter DB Name as POST / SOSB database name.
  • Click to Load then Export to Generate RD Last Balance.

Download


iMO Mac Address Not Found Fixed by Maxthon

1 comments

iMO Login Problem fixed by Maxthon browser

Maxthon 
Instant Money Order - Most Common Login problem is  Mac address Not found Please Check your System Settings with Internet Explorer.

Google chrome, Mozilla Firefox Not support our IMO website.

I have Tried to Login IMO website using internet Explorer by the Following settings

Visit For Complete Settings to enable Mac address :


http://potools.blogspot.in/2013/07/imo-website-common-error-and-solution.html


I have Upgraded / Downgraded Internet explorer from 6 to 7/8 or from 8/7 to 6.

I tried Both above methods but problem persist  iMO login  with same error as "Mac Address Not Found"

Solution:



  • Change Internet settings using Internet Explorer at any version.
  • Download Maxthon Browser 3.4.5.2000 from PoTools.
  • Install Maxthon browser.
After Maxthon installation open https://indiapostimo.gov.in it shows message "Invalid certificate"

Click on Continue at Your Own Risk. After that If you trying to press any key in Maxthon browser it shows Sorr, you do not have permission to press this key.


To overcome above issues,  Click "Browser Mode" right after address bar in Maxthon 3.4.5.2000 browser.


Now You can login iMO website Without Mac address Not found error.

Download Maxthon 3.4.5.200 from Google Drive


Oct 27, 2014

SPCOD Not Received even Giving Request Resend

0 comments

SPCOD Not Received after Many Request in Supervisor

In Some of the post offices, SPCOD was not received even we have give request many times.
  • Check whether any pending files were available in "EMS Client > RXD > Data" Folder.
  • If Files are available, check the Log > Error Log for the error dated.
If you found any Issues like above
Access to the path 'C:\Program Files\SpeedNetServer\Articledata.txt is denied.

Solution

This issues may occur due to Permission issue by Operating System / Antivirus. Try to Give Full permission to the Speed Net Server Folder to access Speed Net Communication without any Issues. otherwise

  1. Uninstall Speed Net Server From you machine.
  2. Install the same in some other drive like D or E Drive.(other than C drive)
  3. Share SpeedNetServer Folder and ensure the same server path is available in SpeedNet Supervisor.
  4. Now Give SPCOD request at once from SpeedNet Module then Execute Communication.
Note: More than one request per day is lead to duplicate SPCOD received from Central server and it does not allow to upload in POSPCC database.

Speed Net Common State Issues and Solution

0 comments

Solution for Speed Net Common state issues

Speed Net Common state Issues while Opening of Bag / Closing of Bag in Speed Net Module.

Run-time error '8015':
Could not set comm state, there may be one or more invalid communications parameters.

Solution

This Issues may occur due to wrongly selection of weighing scale mode at the time of Job allocation in Speed Net Module.

  • Login as Supervisor in Speed Net Module.
  • Go to Job allocation > Modify > Unchecked the "use electronic weighing scale option".
Thanks to Rajesh H

SQL 2000 Enterprise Manager Issues and Solution

0 comments

Solution SQL 2000 Enterprise Manager opening problem

MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
Upon clicking on the SQL Server Enterprise Manager shortcut the following error occurs:MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.

This may be because the file does not exist, is not an MMC console, or was created by a later version of MMC. This may also be because you do not have sufficient access rights to the file.The msc file did exist and I definately has permissions to it. So I can only assume it some how got corrupt.

Solution 1:

The solution to this is fairly simple... either get another copy of this file, or create one, as follows:
1. Select Start - Run.
2. At the Open prompt enter: mmc
3. Click OK
4. Select File - Add/Remove Snap-in...
5. Click Add...
6. Select Microsoft SQL Enterprise Manager
7. Click Add, then Close
8. Click Ok to return to the mmc.
9. Select File - Save As...
10. Delete or rename the original (offending) file out the way.
11. Save the new msc file as C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSCNow your original shortcut should work.

Solution2:

Go to run box and run regsvr32 C:\Windows\system32\msxml3.dll when succeeded it will allow you to both opening and closing off your mmc
or 
Go to C:\Windows\system32\ folder , select the msxml3.dll , Open With -> Browse -> C:\Windows\system32\ Regsvr32.exe

Rajesh H
Thanks TO Rajesh H System Administrator from Puttur(DK) HPO-574201 Mobile Number:9480809780 .

Finacle: Solution for Applet not properly initialised error

0 comments

Solution for Applet not properly initialized error in Finacle Web Page


Java : Settings for Finacle

Open Internet explorer
Tools-->Manage Add-ons

In Oracle America, Inc following three options should be enabled.
1.Java(tm) Plug-In SSV Helper
2.Java(tm) Plug-In 2 SSV Helper
3.Sun Java Console

Rajesh H
Thanks TO Rajesh H System Administrator from Puttur(DK) HPO-574201 Mobile Number:9480809780 .

Oct 26, 2014

Useful Android Application for India Post

0 comments

Android Application for India Post : 4 India Post Employees

Features : Android Application

A Very useful Tool for India Post Employees to 
  • Search Pincode
  • SMS Tracking of Speed and eMO articles
  • Holiday List -Remaining days in Current Year
  • Meghdhoot FTP - Latest Updates with date of modification
  • News and Events - to view latest News
  • Rules and Orders 
  • Posting and Promotions 
  • Exams and Results
  • Training and courses

Download India Post .apk

Oct 25, 2014

Change SQL Server name without Uninstall

0 comments

Complete Steps to Change SQL Server Name

In PO Server Configuration, Most of the time we are forget to rename the Computer at the time of installation. it may continue in SQL Installation also.

  • Operation system may assign the computer with some letters like DOP-a754fs2g. In SQL installation server name we does not make any changes, we may choose default instance.
  • we may find this issue at the time of connect the SQL server

Easy way to Change SQL Server Name


Before do the DOP software configuration, just rename the Server / Computer Name then, SQL server name automatically change if you have selected default instance at the time of SQL Server Installation.
Note: After dop software configuration never try this one, problem may occur with link server and some other configuration.

Steps to Rename in SQL

When one changes the name of the computer running the SQL Server, one needs to perform the following steps to ensure that SQL Server also uses the new updated name. 
  • First to check whether the SQL Server has the correct name, execute the following query
SELECT @@SERVERNAME                 AS oldname,       Serverproperty('Servername') AS actual_name
  • @@Servername gives the computer name that has been set/registered with SQL Server Serverproperty('Servername') provides the newly updated name from windows.

If @@servername,Serverproperty('Servername') results are different then one should update the new name on the SQL Server. To update, follow the steps provided below.

step 1 :- sp_dropserver/sp_addserver

EXEC  Sp_dropserver   'oldservername'EXEC  Sp_addserver   'newservername' ,   'local'

step 2 :- update sysjobs

Applies only for SQL 2k.

USE msdbUPDATE sysjobsSET    originating_server = Serverproperty('Servername')

step 3 :- Restart SQL Service 

Restart SQL Services for the changes to take effect.

Java Run time Environment v8 Google Drive Download

0 comments

Download JREv8u25 from Google drive

Download Java for your desktop computer now!

Better browsing

Java is essential for many websites to work well.

Java is fast 

The new Java is faster than ever

Do more with Java

Java works behind the scenes to make McCamish software and Finacle applications work better in DOP

Download JRE from Google Drive


Download

Official Site Download Link

Group Update Provider for CSI Antivirus

0 comments
A Group Update Provider is a client computer that you designate to locally distribute content updates to clients. A Group update provider download content updates from the management server and distributes the updates to itself and other clients.
One advantages of Group Update Provider use is that it helps you to conserve bandwidth by offloading processing power from the server to the Group Update Provider. Group Update Provider are ideal for delivering content updates to clients that have limited network access to the server. You can use a Group Update Provider to conserve bandwidth to clients in a remote location over a slow link. Setting up a Group Update Provider is easier than setting up an internal Live Update server. Group Update Provider are less resource-intensive and so reduce the load on the management server.

Thanks to
PMU - MP Circle

Transfer of accounts / certificates between CBS and Non CBS

0 comments

Finacle : Transfer of accounts / certificates between finacle CBS and non finacle CBS Post Offices

Transfer of accounts/certificates between finacle CBS and non finacle CBS Post Offices.

In Sanchay Post, there is a provision to transfer any account to any post office and it generates Advice of Transfer along with Transfer Journals. Certificates issued by other offices can be discharged under the option Discharged at Other Offices after verification. 

  • In Finacle CBS application, the account can be transferred to any CBS post office only.
  • Similarly, non CBS post office can transfer account/certificate to Non CBS post Office only. 
  • In Finacle CBS Application, there is no need to generate any AT or Transfer General or do the pairing. 
  • Only, the post office, after satisfying the genuiness of depositor, has to change the home SOL (Post Office) of the account and account will be transferred instantly. 
  • A report can be generated showing accounts transferred from one SOL to another in all CBS post offices.
  • Certificates issued from non CBS Post Offices cannot be discharged at CBS Post Offices.
  • Certificates issued from CBS post offices can be discharged at any CBS post office by changing the home SOL of the certificates.
  • PPF and SCSS accounts can be transferred IN and Out from CBS post offices to Banks and from Banks to Post Office.

Google Plus Followers :: PoTools ::

Some Important Tags at PoTools

Aadhar Software ( 3) BO Account verification Tool ( 2) BO Tag ( 4) Bootable USB ( 4) Bulk eMO Payment ( 1) CBS ( 53) ccleaner ( 3) Certificate ( 3) COD ( 46) Data Profiling Tool ( 18) DB Tools ( 5) DBA Updater ( 10) DBAnalyzer ( 63) despatch ( 18) despatch error & Solution ( 21) Discrepancies tool ( 9) Discripencies tool ( 1) DOP Browser ( 3) DOP Clients Configuration ( 2) DOP Tools ( 27) Downloads ( 2) drivers backup ( 4) eMO ( 19) eMO Client ( 8) ePayment ( 10) ePayment Cheque ( 1) ePayment error ( 4) ePayment updates ( 1) ePost ( 10) IMO ( 7) interest calculator ( 10) interest Posting ( 5) interest Rate ( 5) MM 7 Update 8 ( 12) MM 7 Update 9 ( 44) MM Update ( 18) mm7.3 errors ( 24) Negative List Updation ( 13) newupdate ( 110) NREGAEMO error ( 5) Parcel Net ( 21) passbook printer ( 7) PLI Calculator ( 2) PO Tools ( 45) point of sale ( 17) POSB Calculator ( 9) Postman ( 46) postman error ( 33) printer ( 9) PT Tools ( 8) R Net Communication ( 10) RD Customer Package ( 2) RNet Communication ( 9) Sanchay Post ( 30) Sanchaypost error ( 26) SB46 Intimation tool ( 7) SBCO Utility ( 35) sdc updates ( 9) Signature Tools ( 6) softwares ( 16) SOSB Tools ( 4) SP Patch updater ( 32) SPCOD ( 14) Speed Net 4.1.1 ( 9) Speed Net 4.2 ( 29) SpeedNet error ( 17) Speednet update ( 21) SQL and windows ( 24) sql backup ( 8) SR Tools ( 15) sub accounts ( 9) tariff revision ( 4) TDS Software ( 4) treasury error ( 9) usefulpost ( 108) VP Intimation ( 6) Weblink ( 25) windows 2003 server update ( 8) windows troubleshooting ( 14)

PoTools Followers

Contact Form

Name

Email *

Message *

Useful Forms

Total Pageviews

Live Users