Showing posts with label Sanchay. Show all posts
Showing posts with label Sanchay. Show all posts

Saturday, 13 August 2011

Revised Procedure for operning of BPL Accounts in Sanchay Post

Henceforth, BPL accounts should be opened in the ONLINE MODULE only and the account number allotted will be from the regular SB block. While opening BPL accounts, counter officials should enter the following details under the Introducer particulars:

a) Select ‘Others’ in the dropdown option for Scheme.
b) Enter ‘BPL’ in the introducer name, address, city and pincode.


This is mandatory for all BPL accounts, failing which the account cannot be classified as a BPL account. The counter officials should be suitably instructed without fail. The same procedure is to be adopted for opening of BPL accounts in the SOSB Online module.

For BPL accounts already opened in NREGS Data Entry Module:
a. Open Form No. 0459 in Initialisation Group
b. Add a new block
c. Enter the starting number and the last number of the accounts opened as BPL accounts.
c. In the 'Latest Number' field, enter the last BPL account number opened.
d. Click on 'Save'

The corresponding block should be deleted from the initialisation of NREGS Account Number Blocks.

Installation of Sanchay Post systems running Windows 7 and Sql Server 2008 R2 Express

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


Download SQL Express Setup from the following link: Click Here

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.9) Check for missing tables / upgradation status using DBAnalyzer with latest update.


Source : http://www.tamilnadupost.nic.in/sdc/sblan.htm  

Thursday, 28 July 2011

SBCO Data Backup Software


This SBCO Backup.exe developed by   the R&D  Section,  Central  Region, Trichy.  This exe helps to copy the desired category of dbf files into the local, external hard drive and remote server in a closed network. 


Installation of Winrar software compulsory ( for Zipping of files)

1. copy the attached sbco backup exe in the root drive of the (may be c:\ or d:\ )sbco computer.

2. Make short cut to that sbco backup exe
3. A folder named 'sbcotempbak' must created in the c: or d: drive of the system.
4. winrar software must be installed in the system at c: drive.
5. The other information's are self explanatory.
6. Use  External storage device. If not available, give one local Hard Disk path

Saturday, 23 July 2011

NREGS/BPL Account Initialsation

1.Install Sanchay Post with NREGS option.


2.Run NREGS patch for MS SQL 2000 & MS SQL 2005 Ver 6.5


3.Give the sa password and save it.


4.And then click Execute patch and wait for confirmation message.


5.For HO and SO go to NREGS -> Data Entry.Login with Data entry supervisor login.


6.Then go to Intialisation -> Account Number -> and click Add.


7.Enter the account block details.


8. Then go to NREGS -> Data Entry. Login with Data entry operator login.


9.Then go to NREGS-> Open Account and open the accounts.


10.For transactions go to NREGS -> Transactions and give the account number and enter the
transactions.


11. For day to day LOT entries use LOT entries.


12. After entering transactions/LOT entries open DB Analyzer give the server name.


13.Go to Reports -> Zero Balance Accounts LOT.


14.Select the BPL option and also select the account block numbers and click ok.


15. LOT will be displayed click on Print.


16.LOT will be created as file in the C:\.


17.Open the file with Microsoft Excel and then print the LOT.

18. The same transaction also will be included in Sanchaypost Regular LOT

Saturday, 16 July 2011

DB Analyzer dated 14.07.2011

Recent additions in DBAnalyzer1. Agreement - Sanchay Post & V2SBCO data
2. Miscellaneous - Balance Verification List for RD accounts
3. Database Discrepancies - PPF - HUF Accounts (3 reports)
4. Reports - Signatures exceeding 150 kb
5. Reports - List of Live RD Accounts allotted to Closed Agents
6. Separate LoT for NREGS / IGNOAPS / IGNWPS / IGNDPS / BPL for HO & SOs

Download

Wednesday, 6 July 2011

DB Analyzer dated 05.07.2011

Recent additions in DBAnalyzer

1. Agreement - Sanchay Post & V2SBCO data
2. Miscellaneous - Balance Verification List for RD accounts
3. Database Discrepancies - PPF - HUF Accounts (3 reports)
4. Reports - Signatures exceeding 150 kb
5. Reports - List of Live RD Accounts allotted to Closed Agents
6. Separate LoT for NREGS / IGNOAPS / IGNWPS / IGNDPS / BPL for HO & SOs