|
NO. |
SOFTWARE |
PROBLEM |
UTILTIY |
HOW
TO USE |
|
1 |
Oracle
Users |
SEBI/NSE/IT Reports |
UTILCAP10 |
Download to your Capex folder &
connect database <<<HELP>> |
|
2 |
Maind/Maindfo |
F/A
Closing of database |
FACLOSE4 |
Pls
see
"How to Close your book ( Maind Users )" |
|
3 |
Capex |
F/A
Closing & tuning of database |
FACLOSEO /
FACLOSEN |
Pls
see
"How to Close your book
( Capex Users )" |
|
4 |
Commex |
F/A
Closing & tuning of database |
FACLOSCOM
|
Pls
see
"How to Close your book(
Commex Users )" |
|
5 |
Commex |
Explorers the various
database |
DBEXPLORER |
Copy this file in commex
folder |
|
6 |
Comsql |
F/A
Closing |
SCOMCLOSE |
Pls
see
"How to Close your book(
Comsql Users )" |
|
7 |
Comsql |
Explorers the various
database |
SDBEXPLORER |
Copy this file in comsql
folder |
|
8 |
Dpora2
& Cdsl |
F/A
Closing & tuning of database |
DPCLOSE |
Create
new database and tune new database and run this file. |
|
9 |
Oracle
Users |
For extend rollback seg. &
add datafile (temp & system) |
DBUTIL.EXE |
Download
to program folder (Capex/Commex/DP), connect database
create or extend temp segment or add datafile in
table space system or tem by selecting your oracle ver.
(8i or 9i) |
|
10 |
Oracle
Users |
Adding
name and address into database |
UNAMEX |
Download
to program folder (Capex/Commex) and Connect database
and add company name & address (This is only done
after the import of data) |
|
11 |
Oracle
Users |
Space Quota Exceeded for Tablespace |
UQUOTAEXT |
Download
to program folder (Capex/Commex) and Connect database
and proceed |
|
12 |
Capex |
Clear Settlement Master(Sett. As On Jan-2000) |
USETFILE |
Download
to program folder (Capex) connect database & after
giving giving date proceed it |
|
13 |
Maind/Maindfo |
Clear Settlement Master(Sett. As On Jan-2000) |
USETFILE_15 |
Download
to program folder (dse2000) connect database & after
giving giving date proceed it |
|
14 |
Maind |
If
package is running slowly |
FAINDEX |
Download
to program folder (dse2000) connect database and select:-
1)Fresh indexes to be created also
2)Table integrity to
be checked
3)Select Table
4) Start after
completion of one table click on another table |
|
15 |
Maind/Maindfo |
Difference
in Trail balance |
UTILTB7 |
Download
to program folder (dse2000 ) connect database and
give date range and click on show you will know date where is the actual error in accounting |
|
16 |
Capex/Fopro |
Table
or view does not exists |
CAPEXMNT |
Download
to program folder (Capex) and run this exe & pls
contact us |
|
17 |
Maind/Maindfo |
Database
validity failed |
DETSET8 |
Download
to program folder (dse2000) connect database & click
on export, a file is generated in
C:\detset8.txt
pls upload it on uploader |
|
18 |
Maind/Maindfo |
Database
validity failed |
CHSETUP8 |
Download
to program folder (dse2000) connect database &
proceed it after this run MAINDLIC.EXE and upload key
no. on uploader |
|
19 |
Maind/Maindfo |
Voucher
entry & sauda transfer problem |
MAINDLIC |
Download
to program folder (dse2000) connect database &
proceed it and upload key no. on uploader |
|
20 |
Comsql |
Voucher
entry & sauda transfer problem |
COMLIC |
Download
to program folder (comsql) connect database &
proceed it and upload key no. on uploader |
|
21 |
Maind/Maindfo |
Increase field size, change
flag, Income tax report etc. |
UTILD10 |
Download
to program folder (dse2000) connect database & click on
various options
<<HELP>> |
|
- |
- |
Increase field size, change
flag, Income tax report etc. |
UTILD |
- |
|
22 |
Maind/Maindfo |
For zip the files in dos
prompt |
PKZIP |
Download this exe to the
place where you want to zip the files. |
|
23 |
Maind/Maindfo |
For unzip the files in dos
prompt |
PKUNZIP |
Download this exe to the
place where you want to unzip the files. |
|
24 |
Capex |
For login in Capex (Capexbr) |
USERADD |
Download in Capex folder,
run & connect database & click on start for new
ver update5 incorporate in UTILCAP5.ZIP |
|
25 |
Dpora2
& Cdsl |
For create/verify indexes,
extend rollback segments etc.. |
UTILDP |
Download in program folder
run & connect database & click on start |
|
26 |
Oracle
users |
FOR ROUND OFF STRIKE PRICE CL
TRADE TYPE |
UTILSTR |
Download in program folder
1.Give database name
2.Enter date
3.Give symbol
4.Give
old strike price
5.Give new strike price
6.Click on
proceed |
|
27 |
Sql users |
FOR ROUND OFF STRIKE PRICE CL
TRADE TYPE |
SUTILSTR |
Download in program folder
1.Give database name
2.Enter date
3.Give symbol
4.Give
old strike price
5.Give new strike price
6.Click on
proceed |
|
28 |
Comsql |
Database
validity failed |
CHSETUP8C |
Download
to program folder (comsql) connect database &
proceed it after this run COMLIC.EXE and upload key
no. on uploader |
|
29 |
Capex/Fopro/
Commex |
Key file generation |
OSYSINFO |
Download
to program folder (Capex/fopro/commex) and unzip it. <<<HELP>> |
|
30 |
Sql
users |
Settlement Deletion
Utility |
UTILSETT |
Delete settlement from
Settlement File above given date |
|
31 |
Oracle
users |
Settlement Deletion
Utility |
UTILSETX |
Delete settlement from
Settlement File above given date |
|
32 |
Dpora2
|
Nsdl Batch No Change |
UTILBTCH |
Enter database name then
give new batch number & click on proceed a msg appears
"Batch no. successfully updated" |
|
33 |
Dpora2
|
Update trxfile from
nsdltrx file for slip validation |
UTILTRX |
Enter database name then
period from & to click on proceed, a msg appears "Data
successfully updated, error file dump.txt created for
slips not imported" |
|
34 |
Cdsl |
Create index for DP24 in
cdsl fast |
DP24INDEX |
Enter database name &
click on proceed |
|
35 |
Dpora2
|
Delete duplicate client
code from partymst (nsdl) |
UDUPCLIENT |
Enter database name &
click on proceed |
|
36 |
Cdsl |
Delete duplicate record
from account master |
UACCTDUP |
Enter database name &
click on proceed |
|
37 |
Dpora2
|
Delete Slab from
Slabmaster of a particular FREN (NSDL) |
UFSLBDEL |
Enter database name &
Franchisee code & click on proceed |
|
38 |
Dpora2
|
Delete duplicate opening
entry from partytrn |
UOPRECT |
Enter database name &
click on proceed |
|
39 |
Dpora2
|
Delete duplicate record
from actype |
UACTYDUP |
Enter database name &
Franchisee code & click on proceed |
|
40 |
Dpora2
|
Delete unissued book from
clientslip on bookno and booktype basis |
UBOOKDEL |
For run this utility take
following steps:-
1. Enter database name
2. Select book type
3. Give book no. from-to
4.
Enter Lot size & Click on proceed |
|
41 |
Cdsl |
Update CDSL 999999 Batchno
to null |
UTBTCHC |
Enter database name &
click on proceed |
|
42 |
Comsql |
Transaction deletion from
a given expiry |
CDELTUIL |
To run this pls follow these steps : -
1. Enter database name
2. Select Exchange
3. Select Expiry Date From & To
4. Select Financial or Transaction
5. Click on proceed
then
A msg appears "Records successfully Deleted" |
|
43 |
Dpora2
|
Key file generation |
OSYSDP |
Download to your program
folder unzip it give database name & concurrent users
then click on proceed. A key file is generated in
program folder
"Key-yourcompanyname.txt", zip
it
and upload on
www.shilpisoft.net/fileuploader |
|
44 |
Dpora2
|
For create/verify indexes,
extend rollback segments etc.. |
UTILDP39 |
Download in program folder
run & connect database & click on start |
|
45 |
Dpora2
|
For branch data export
(Oracle to Oracle) |
franexp39 |
Download in program folder
run & connect database & run the various req.
options. |
|
46 |
cApexweb live |
For report printing |
rep.zip |
Download it unzip & run
this file, give the path of downloaded report file and
give the input "Y" for printing. |
|
47 |
Oracle Users |
For digital contact note |
regdll.zip |
Please following the following Step
:- unzip this file in cApex Folder & registered all dll like this.
regsvr32 chilkatCert.dll ( registered all five DLL like this.). |
|
48 |
Fopro Users |
For change the expiry date |
uexpiry.exe |
1. Delete all the Bills & MTM from
expiry date
2.
Run
Uexpiry.exe from program folder ( Fopro/Capex etc..)
3. Enter your database name and
click on connect
4. Give the Old expiry date & New expiry date
5. Click on Start |
|
49 |
Maind & Mainc Users |
For change the expiry date |
suexpiry.exe |
1. Delete all the Bills & MTM
from expiry date
2.
Select your package type
Maind or Mainc
3.
Run
suexpiry.exe from program folder ( dse2000 etc..)
4. Enter your database name and
click on connect
5. Give the Old expiry date New expiry date
6. Click on Start |
|
50 |
Commex Users |
For change the expiry date |
Ucoexpiry.exe |
1. Delete all the Bills & MTM
from expiry date
2.
Run
ucoexpiry.exe from program folder ( commex etc..)
3. Enter your database name and
click on connect
4. Give the Old expiry date & New expiry date
, keep
the symbol blank
5. Click on Start |
|
51 |
Comsql Users |
For change the expiry date
& for increase size of multiplier |
Utilsql.exe |
1. Delete all the Bills &
MTM from expiry date
2. Run
utilsql.exe from program folder ( comsql
etc..)
3. Enter your database name and
click on connect.
4.
Click on button "Expiry Date
Change"
5. Give the Old expiry date & New expiry date,
give the
symbol.
6. Click on
Start |
|
52 |
Dpora2 |
Adding
name and address into database |
Dpname.exe |
Download
to program folder (dp2000) and Connect database
and add company name & address (This is only done
after the import of data) |
|
53 |
Cdsl2 |
Adding
name and address into database |
Cdslname.exe |
Download
to program folder (cdsl2000) and Connect database
and add company name & address (This is only done
after the import of data) |
|
54 |
Dpora2 |
Slip deletion from trxfile
complete and blank isincode (NSDL) |
SLIPDEL |
Download
to program folder (dp2000) and Connect database, select
slip type and give slip number, if you want to delete
transaction which have no ISIN then tick the option and
click on delete |
|
55 |
Oracle
users |
For cheque printing |
chequeprint.zip |
Download
to program folder (capex /commex/etc..) |
|
56 |
Fopro Users |
For create risk parameter
file |
uspn.exe |
Download
to program folder (capex /fopro/etc..) |
|
57 |
Commex Users |
For create risk parameter
file |
ucomspn.exe |
Download
to program folder (commex/etc..) |
|
58 |
Oracle
users |
For find out block
corruption |
u01578.exe |
Download
to program folder (commex/capex etc..) Enter database
name, File no. & Block no. coming in error and click on
proceed. |
|
59 |
DGCX Users |
For database maintenance |
utildgcx.exe |
Download to your dgcx
folder & connect database for various requirements |
|
60 |
Capex |
For delete the data from
last year ( F/A Closing) |
Lastclos15.exe
Lastclos31.exe |
Download to your program
folder & connect database, enter last trading dates in
given fields |
|
61 |
DPOnline |
For report printing |
dprep.zip |
Download it unzip & run
this file, give the path of downloaded report file |
|
62 |
Commex |
For additional margin
deletion |
utilmgn.exe |
Download it to your
program file i.e Commex, enter database name and
click on connect, after this click start this will
delete additional margin. |
|
63 |
Capex/Fopro |
For In service tax reg. ,
brokerage wrong display (specific user) |
brok.exe |
Download it to your
program file i.e Capex/ fopro, connect your
database and click on start this will rectify the
problem. |
|
64 |
Capex/Fopro |
For delete demat entry for
a given period |
demdel.exe |
Incorporate in Utilcap5 >>
Utilities |
|
65 |
Comsql |
For enter name in database |
comname.zip |
Connect database and add
company name & address |
|
66 |
Oracle Users |
For register & license database |
licclient.exe |
1. Send request for
register your current year database
2. Update
license status for activations
3. Product Activation
for license database after reinstallation/faclosing
& from new installation |
|
|
|
|
|
|
