Important Note: The DBU is a database utility
program that you can use to manipulate data directly. Great care should be taken when
working in the DBU. You may cause irreparable damage, delete or change data if you do not
know what you are doing. Make a backup before you open the DBU. Please follow the
instructions very carefully. If you are unsure of any instruction please do not hesitate
to contact Otomys directly at (012) 348 4071. Otomys will not be held accountable for any
data loss or corruption.
The stock sales reports, practice summary and any other reports that look at
stock items will be influenced if a stock item is deleted. There are two ways to restore a
deleted stock item.
1. Remove the deleted flag in DBU
2. Create a new stock item with the original stock item number
Method 1: Remove the deleted flag in the DBU
When any record is deleted in Microvet it is flagged as DELETED but
remains in the database until the database is re-indexed. If a record has been
deleted but the system has not been re-indexed, the DELETED flag can be removed and the
record will be restored. If you have re-indexed after the stock item has been deleted, use
the second method.
Exit from of Microvet on all the computers
Make a backup
Do these steps on the file server
Click on START
Click on PROGRAMS
Click on ACCESSORIES (only for windows ME/XP/NT and 2000)
Click on MS-DOS PROMPT or COMMAND PROMT
(From now on you will not be able to use your mouse, use the Enter
key and the arrows on your keyboard.)
Type the following:
CD\MFW5
DBU
F2
DATABASE
Open STOCK.DBF
OK
F3
INDEX
Type in
File STDESCR
Key STDESCR
OK (Wait for the message "file indexed")
F5
DATABASE
Scroll down, the records will now be alphabetical order, find the
deleted record.
Put the hi-lite on the deleted record. At the top it will show
<DELETED>.
Press the DELETE button ONCE on the keyboard. The
<DELETED> flag will disappear.
ESC
ESC
“Exit to DOS”
Y
DEL *.IDX
DEL *.NTX
EXIT
Start Microvet
The program will automatically start to re-index
A message may appear: ‘File is not marked with a code
page’
Click on Windows
The selection will go to Windows ANSI
Click on Select
Log in
Method 2: Create a new stock item with the
original stock item number
In this procedure we will find the original stock item number, add a new stock
item, change the change the stock item number to the original number and re-index.
2.1. 2.1 Find the original
stock item number
Open Microvet.
Print a transaction listing for any client that you have sold the
item to, e.g. cash client. Look at the number in front of the line.
2.2. 2.2
Add a new stock item
Add a new stock item in Microvet in the usual way. Fill in all
the detail of the deleted stock item.
(The item number will be a new number but we are going to change it
shortly.)
2.3. 2.3 Change the
stock item number
Exit from of Microvet on all the computers
Make a backup
Do these steps on the file server
Click on START
Click on PROGRAMS
Click on ACCESSORIES (only for windows ME/XP/NT and 2000)
Click on MS-DOS PROMPT or COMMAND PROMT
(From now on you will not be able to use your mouse, use the Enter
key and the arrows on your keyboard.)
Type the following:
CD\MFW5
DBU
F2
DATABASE
Open OLDITEM.DBF
OK
F3
INDEX
Type in
File OINUM
Key OINUM
OK (Wait for the message "file indexed")
F5
DATABASE
Look in OINUM column for the number that you have identified in the
transaction listing.
When you have found the number look in the OISTNUM column of the
same record and write this number down. This is the number of the original stock item.
F2
DATABASE
Open STOCK.DBF
OK
F5
DATABASE
Press PAGE DOWN and go to the last record in the database.
This will be the new stock item with the wrong number.
Change the STNUM to the number of the deleted stock item.
ENTER
ESC
ESC
EXIT TO DOS
Y
DEL *.IDX
EXIT
Start Microvet
The program will automatically start to re-index
A message may appear: ‘File is not marked with a code
page’
Click on Windows
The selection will go to Windows ANSI
Click on Select
Log in