Re: PMA DataBase Not ok

Management and Administration
1

ahmed159 wrote on Wednesday, February 11, 2015:

Hello Team,

I was trying to Import CPT Code Manually for that i went to Database.

In the option Database, There it was showing me in red error. PMA data base not okkk…

What is that mean actually, How to troubleshoot that problem.

2

visolveemr wrote on Wednesday, February 11, 2015:

Hi Ahmed,
The error denotes that the PMA database has not been set. You can follow the below steps to setup the Advanced Features.

  1. Create a new database ‘pmadb’.

  2. Import the file phpmyadmin/examples/create_tables.sql to the database.

  3. Modify phpmyadmin/config.inc.php file in your OpenEMR root directory,

    /* User account for configuration storage */
    $cfg[‘Servers’][$i][‘controluser’] = ‘pmadb’;
    $cfg[‘Servers’][$i][‘controlpass’] = ‘secret’;

    /* Storage database and tables */
    $cfg[‘Servers’][$i][‘pmadb’] = ‘pmadb’;

Thanks
OpenEMR Customization/Support Team,
ViSolve Inc
services@visolve.com | Phone: 408-850-2243
Demo’s @ ViSolve Demo Library

3

fsgl wrote on Wednesday, February 11, 2015:

  1. manual method, see attachment

  2. import of entire code set, see this.

If you are unfamiliar with working in phpMyAdmin, best not to alter it until you have some expertise. Messing with the database can damage your production copy of OpenEMR very quickly.

4

ahmed159 wrote on Wednesday, February 11, 2015:

Thanks so much fsgl,

I have around 30 test, I will add one by one… Thanks again

5

fsgl wrote on Wednesday, February 11, 2015:

Glad to be of assistance.

6

ahmed159 wrote on Thursday, February 12, 2015:

Hi Fsgl,

I am adding manually as you mention earlier, I have around 25 Test i don’t want to type the Test in search for ex (CBC) and again it shows in Search and then need to select one by one.

Is it possible by One Click i can see all 25 in search button so i can select what i want.

Thanks for your support

7

fsgl wrote on Thursday, February 12, 2015:

I presume you are using the Fee Sheet to charge for the tests, not to order nor to record the test results.

The two columns, New & Established Patient, can be changed any way you want it.

You probably can have more than 2 column depending how many you can squeeze into the frame.

See attachment.

8

fsgl wrote on Thursday, February 12, 2015:

Ahmed,

The Allura software which runs these Fora “thinks” I’m a spybot, hence the funny message above. In a few hours the rest of the post will appear.