Open Dental Forum

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.

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.

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.

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.

thank you all...i'll let him know