User:Denis Kaffoko

Hi, I hope you are ready to take ona new skill,which i discovered in the last few days. "Data export from the openMRS"

There two ways but offcourse i will start with the simple one.

But first a question? Do you understand the data model well? Do you know why am asking you this? The answer is simple if you know the data model believe then you understand the openMRS tables. You know which table has what and this is just the starting point,After this you must ensure you have Navicat 8.0 on your computer if you don't just google navicat downloads and download the trial version or the full version at a fee of course. After downloading it will ask you to make aconnection to the openMRS,Here use the login information to openMRS, When you are done ,it will connect to the database it will display the views,tables,in the task bar there is the export wizard,click on the table you want say obs,export it,it will ask you the destination,say MS access,when you succed you can merge table through the use of relationships using the unique identifiers,and create on table give it a name zip it and its ready for transfer.

Another method,is quit technical but don't get worried?

you know the mysql database has the mysqldump,Here is what you do go to start-run-cmd-cd...(this will take you to the defualt)C:> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqldump" -u root -p openmrs>database-dump.sql;

when you press enter it will ask you for the password(this means you must have administrative rights to mysql database) when a password is given it will send your data to the directory C: of your machine zip and its ready for transfer,

For more information can reach on deniskaffoko@gmail.com or nmusinguzi@gmail.com

thanx for your attension