Installation of Sanchay Post in Windows-7

Fresh installation of Sanchay Post in systems running Windows 7 and Sql Server 2008 R2 Express

While installing SQL Express Edition, select default instance and security as 'Mixed Mode Authentication'. 1) Install Sanchay Post Version 6.5 (from Sanchay Post new sites CD) in the server.  2) Create the databases using 'Sanchay Post > Database Operations' option. 3) Run 'Sanchay Post > Database Operations > Patch for SPUser' 4) Run 'Sanchay Post > Database Operations >BPRO Updates' 5) Run 'Sanchay Post >; Database Operations >Patch for negative list' 6) Login as 'SUPERUSER' in online module for the first time using default login (BPRO/BPROP) 7) Create new users and enter office details in 'PO Name and address' & 'Set default PO Name' forms. 8) Upgrade to Version 6.5R2 as per the instructions given in the website.      http://www.tamilnadupost.nic.in/sdc/65R2/PATCH65R2.ZIP      http://www.tamilnadupost.nic.in/sdc/65R2/Instructions_65R2.txt 9) Check for missing tables / upgradation status using DBAnalyzer with latest update.    DB Analyzer-Download Source:SDC,Chennai Site (Those who do not have  Sanchay Post new sites CD mail to dgldvn@gmail.com,mutusp23@gmail.com)

Read more...

Speednet update dated 20.5.11

Speednet Update dtd 20.5.11 had been released

Speed Net Team, Centre For Excellence In Postal Technology, PTC, Mysore is releasing Speed Net Ver 3.1.2 Updated Version on 20/05/2011.

This Release is specifically for providing EPP Booking for BNPL Articles with Circle allotted Barcode prefix validation, EPP Distance Configuration for Cities, closing separate EPP Bag with EPP Articles.

Delivery of EPP Articles was already available in the SpeedNet earlier version and the same is continued.

Note: 1: If SpeedNet 3.1.2 is not upgraded with 21/03/2011 or later updates then DB Upgradation should be first done through Database Workshop Module using the DB Updation SQl Scripts and then do the updation through Exl file.)


Note:2 :Those MBCs and BNPL Uinits who are permitted from directorate to close Direct Bags should run the Direct Bag Script received by them from PTC Mysore, after the DB Upgradation as mentioned above to get the Direct Bagging provision.


Please note that – this version can also be used by all other offices using SpeedNet 3.1.2 - which have not used earlier SpeedNet 3.1.2 updates kept in FTP and also for Fresh Installations. EPP provisions of this version is only an Add On provision to the already existing features in SpeedNet.


Download

Read more...

Adding Account Head Error

While try to Add New Account Head in Treasury an error will raise as in  below screen shot.

Solution: Download

Read more...

Automate backups of databases in SQL Server Express Editions

You need to take the following 3 steps to backup your SQL Server databases using Windows Task Scheduler

Step 1: Using SQL Server Management Studio express or Sqlcmd create the following stored procedure in your master database:       Stored Procedure:- Download

 

Step 2: In a text editor create a batch file that is named sqlbackup.bat and then copy the text from one of the following examples depending on your scenario into that file:

Example1: Full Backups of ALL databases in local named instance of SQLEXPRESS using Windows Authentication
// sqlbackup.bat
sqlcmd -S .\EXPRESS –E -Q "EXEC sp_BackupDatabases @backupLocation='D:\SQLBackups\', @backupType='F'" 
 Example2: Differential Backups of ALL databases in local named instance of SQLEXPRESS using SQLLogin and its password
// sqlbackup.bat
sqlcmd -U SQLLogin -P password -S .\SQLEXPRESS -Q "EXEC sp_BackupDatabases  @backupLocation ='D:\SQLBackups', @BackupType=’D’"
 Note: The SQLLogin should at least have Backup Operator role at SQL Server.


Example3: Log Backups of ALL databases in local named instance of SQLEXPRESS using Windows Authentication
// sqlbackup.bat
sqlcmd -S .\SQLEXPRESS -E -Q "EXEC sp_BackupDatabases @backupLocation='D:\SQLBackups\',@backupType='L'"


Example4: Full Backups of database USERDB in local named instance of SQLEXPRESS using Windows Authentication
// sqlbackup.bat
sqlcmd -S .\SQLEXPRESS -E -Q "EXEC sp_BackupDatabases @backupLocation='D:\SQLBackups\', @databaseName=’USERDB’, @backupType='F'"

Similarly you can take differential and log backup of USERDB by passing in ‘D’ and ‘L’ respectively for the @backupType parameter.

Step 3: Schedule a job using Windows Task Scheduler to execute the batch file created in Step 2. To do this use the following procedure:

1. On the computer that is running Microsoft SQL Server Express, click Start , point to All Programs , point to Accessories , point to System Tools , and then click Scheduled Tasks. 
2. Double-click Add Scheduled Task . 
3. In the Scheduled Task Wizard, click Next . 
4. Click Browse , click the sqlbackup.bat file that you created in step 2, and then click Open . 
5. Type SQLBACKUP for the name of the task, and then click Daily . Then, click Next . 
6. Specify information for a schedule to run the Task. We recommend that you run this at least once every day. Then, click Next .
7. In the Enter the user name field and in the Enter the password field, type a username and a password. Then, click Next .  Please note that this user should at least be assigned the BackupOperator role at SQL Server level if you are using one of the batch files in example 1, 3 and 4.
8. Click Finish . 
9. Execute the scheduled task at least once to ensure that the backup is created successfully.

Note: The folder for SQLCMD executable is generally in the Path variables for the server after SQL Server is installed, but in cases where the Path variable does not list this folder, you can find it under \90\Tools\Binn (For example: C:\Program Files\Microsoft SQL Server\90\Tools\Binn).
 Please note the following when using the procedure documented in this article:

• Windows Task Scheduler service must be running at the time when the job is scheduled to run. It is recommended that you set the startup type for this service as Automatic. This ensures that the service will be running even on a restart.
• There should be enough space on the drive where the backups are being written to. It is recommended that you clean the old files in the backup folder on a regular basis to ensure that you do not run out of disk space. The script does not contain the logic to cleanup old files.

Read more...

Convert FAT to NTFS

Standard Windows utility that is called CONVERT serves this purpose


Just go to the Command Prompt and execute the command:

C:\> CONVERT C: /fs:ntfs


Where C: is a name of the drive you want to convert.


After machine re-boot conversion process will start and you'll have your FAT32 converted to NTFS without of data loss.

Read more...

Speednet exl Scripts dtd 18.3.2011

Before upgrading Speednet update version dated 26.4.2011 Speednet exl Scripts dtd 18.3.2011 is to be executed.



Speednet exl Scripts dtd 18.3.2011-Download

Read more...

R Net for Post Office

R Net is mainly designed to deal with the Register Articles booked with the Barcode for the tracking like Speed Articles. R Net have two parts R Net Client (will be installed at RMS offices) and R Net Communication (at RMS and Post Offices). Both parts have separate configuration which needs to be done as per the installation site i.e. Post Office or Sorting Office. 




RNet will be implemented by end of this month.

Read more...

DB Tool

DB Tools - Features

1. To Clear the Log files single / All the Database
2. To shrink the Databases and increase the HDD free space
3. Repair the Access ( MDB ) and Foxpro (DBF) databases
4. To Take SQL Database backup from Any Where & Any Time
5. To Check and Correct some internal problem in SQL Database

Database Tools : Download Updated on 30/08/2009
Supporting DLL and OCX Files : Download


Source:sapost.blogspot.com

Read more...