hello OD users,
I have a friend using OD to inventory his store stock (long story...but not using it for dentistry) by using product stock numbers instead of the cdt codes. He would like to transfer all his product stock numbers that he has input to a new computer...
Does anyone know which folder it is located in? is it procedure.txt? Which folder can he save on the new computer that won't corrupt the database.
again, no cdt codes, but his own product stock numbers, so no worries about copyright infringements. for example:
23422-2 product A $120.00
29388-3 product B $130.00
etc
Thanks for any suggestions.
transferring Procedure codes folder ???
Re: transferring Procedure codes folder ???
it is all in the mySQL database.
you can download a program called SQLYog (http://www.webyog.com/en/download_form. ... yog712.exe) and you can then access the database and copy the whole database.
you can download a program called SQLYog (http://www.webyog.com/en/download_form. ... yog712.exe) and you can then access the database and copy the whole database.
Re: transferring Procedure codes folder ???
He could also just run the query
select * from procedurecode
from within the reports users query
and export the report to a text file or xcel file.
That report is part of the original favorites list titled Table - procedure codes.
select * from procedurecode
from within the reports users query
and export the report to a text file or xcel file.
That report is part of the original favorites list titled Table - procedure codes.
____________
Cheers,
Dave Wolf
Cheers,
Dave Wolf
-
- Posts: 172
- Joined: Mon Aug 04, 2008 12:39 pm
Re: transferring Procedure codes folder ???
The best way to transfer the procedure codes if you do not need procedure descriptions would be to use the fee schedule export/import tool. http://www.open-dent.com/manual/feescheduletools.html
If you do need them with descriptions in another OD database, you could just make a divergent copy of the database, just back it up and then restore it to the other machine. IF you need the table for some other purpose, I would follow the excellent advice above with the simple query>export.
If you do need them with descriptions in another OD database, you could just make a divergent copy of the database, just back it up and then restore it to the other machine. IF you need the table for some other purpose, I would follow the excellent advice above with the simple query>export.
-
- Posts: 10
- Joined: Fri Feb 08, 2008 9:06 pm
Re: transferring Procedure codes folder ???
thank you all...i'll let him know