Imported Ins. Com. not seen from withing OEMR

Management and Administration
1

aperezcrespo wrote on Monday, December 01, 2008:

Hi
  I have exported the Insurance_companies table to an .SQL file.  When I import it to a new install, I can see them from webmin or phpMyAdmin but not from within OEMR.
Stoping and starting MySQL doesnt help either.

It sure would be nice not to have to reenter each Ins company for the same clearing house on each install.

Thanks
Alfonso

2

cfapress wrote on Tuesday, December 02, 2008:

If you upgraded OpenEMR perhaps there is a new field in the Insurance_companies table that acts as a flag to OpenEMR so they companies are shown. Or perhaps there is a setting in a config file that is different from your previous installation?

I haven’t started using the Insurance companies feature in OpenEMR but will be very soon. Sorry I can’t be more helpful in a specific way.
Jason

3

aperezcrespo wrote on Wednesday, December 03, 2008:

Thanks but
   Yes its an older install Mysql 4 but I also found that the load_icd code plx file also did not work right.  Here is whats interesting.  I can view the data via phpMyAdmin and Webmin but not through OpenEMR.  It has me puzzled.  I reloaded privleges, did a Flush, did a MS quick fix (reboot) but nothing seemed to work.  I even exported the table, dropped it, and recreated it.  I have imported data into recent installs with no problem.  I am begining to wonder if it’s something inherent to MySQL 4 and PHP4.

Thanks Again.

4

aperezcrespo wrote on Wednesday, January 07, 2009:

Hello

Well I tried it with a text file (CVS) but it’ s still a no-go.  I have a total of 42 insurance companies to import and I sure dont want to do it for each install.

Now I am working with only new installs so php4 and mysql4 has nothing to do with it.

I did a cut and paste of the portion of the database.sql which creates the database and appended the inserts after that seccion.  That procedure deletes the database, recreates it and then inserts the data.  And that did not work.

I have tried this on both opensuse and ubuntu and get the same results.

I have no Idea as to what is is.

Thanks

5

aperezcrespo wrote on Thursday, January 08, 2009:

Here is the interesting part…

This seems to be only true with the Insurance Company database.  I just ran the scripts for HCPCS, ICD9 and FDA and all went well.

Now what?

Thanks

6

cfapress wrote on Thursday, January 08, 2009:

Hi Stan,

Since I haven’t done much the Ins. Co.s in OpenEMR please bear with me. It sounds like you can use the PHPMyAdmin built into OpenEMR and browse the insurance_companies table. Right?

But when you are in the Admin section of OpenEMR and click on Practice -> Insurance Companies you don’t see anything listed. Right?

For a test I created a new Test Company in my installation. Then I checked insurance_companies table in PHPMyAdmin. Here’s what I see:

id  name         attn        cms_id         freeb_type  x12_receiver_id  x12_default_partner_id 
393 Test Company Test Person 00-00-00-00-00 1           NULL             NULL

That matches what I hand-entered into the database. I went back to the Admin->Practice->Insurace Companies page and can also see the test company I created. But the **really** curious bit is that I can’t see the insurance co’s address and phone number in the insurance_companies table. So where is that being stored? … well that stuff is stored in the addresses and phone_numbers tables. The foreign key is the ID from the insurance_companies table.

What happens if you’re missing a matching entry in the phone_numbers table? Everything is OK but the phone number disappears when looking at the Companies via Admin->Practice->Insurance Co.

What happens if you’re missing a matching entry in the addresses table?  uh oh

That’s a problem. So it seems you need to make sure you’ve got the insurance company addresses from the addresses table AND their matching data from the insurance_companies table. You also should capture the data from the phone_numbers table too but it doesn’t seem critical to the function of OpenEMR.

Does that help?

Jason

7

aperezcrespo wrote on Friday, January 09, 2009:

Jason
   You are absolutely correct.  I exported insurance_companies, addresses, and phone_numbers.  Did a little cleanup and imported them into a new install just perfectly.

This is cool, now with these 3 sql files and the x12 partners sql file I can get new setup up and running without re-entering all of these entries.

Thanks for the greatly detailed explaination.
Alfonso