Importing Snomed into v4.1.1

davcreech wrote on Tuesday, September 04, 2012:

So instructions make it seem easy…download the file, put in contrib\snomed and then install.  If I don’t have the .zip file in the contrib\snomed folder it tells me that there are no installation files (which is right).  When I download the .zip file and put it in the contrib\snomed folder (like it says) then it says it’s not installed and it’s blank under staged releases.

Help???

juggernautsei wrote on Thursday, January 10, 2013:

HI,
Where did you download the zip file from?
Also, did you unzip it once you placed it in the folder?
Sorry, I am just now finding this thread. I see no one has answered but I am looking for an answer too.

Sherwin
openmedpractice.com

pfwilliams wrote on Thursday, January 10, 2013:

This sounds exactly like what I described here:
http://sourceforge.net/projects/openemr/forums/forum/202505/topic/5864204

Perhaps the same freakish fix will work for you.

pfwilliams wrote on Thursday, January 10, 2013:

Posts 10 through 12 of the thread I mentioned above would be the ones of main interest.

bradymiller wrote on Thursday, January 10, 2013:

Hi Sherwin,

There is documentation here:
http://www.open-emr.org/wiki/index.php/Import_Standard_Tables

Also, if you click on the ? in the staging screen it will provide you with detailed instructions that include where to get the account and where to download the files etc.

Let us know if still have problems after doing above.

thanks,
-brady
OpenEMR

bradymiller wrote on Thursday, January 10, 2013:

Hi pfwilliams,
What was the specific fix you did. If it’s a benign fix, then probably makes sense to get it into the official codebase.
-brady
OpenEMR

pfwilliams wrote on Friday, January 11, 2013:

Hello Brady,
Well the work-around I stumbled upon is so bat-crap crazy I’m not sure it deserves to be called a “fix”.
It was apparent that the list_staged.php module was detecting a valid rxnorm/snomed file as when one was present it would change from outputting the “No files staged…” messages to outputting nothing at all (no file version message or install button).  I was doing some cheesy debugging inserting echo() statements at strategic places and when I parked one after line 179 it cause the output to display correctly. Alternately, yanking the whitespace from between lines 180 and 181 had the same effect.  I’d described it in messages 10-12 of the linked thread above.

I decided to see if I could still recreate the bug. Since the original post, we’ve updated to 4.1.1.9 (likely irrelevant since list_staged has had no changes) and we’ve installed Firefox 18 on all our machines and use it (only) when launching OpenEMR.  I parked a valid snomed file in the appropriate /contrib folder and brought up the External Data Loads page using different browsers running under different operating systems.

Failed (the “staged releases” box contains no text or controls):
  Windows Server 2003 R2 x64 & IE8 x32
  Windows Server 2003 R2 x64 & IE8 x64
  Windows XP & IE8 x32
  Windows 7 x64 & IE9 x32
  Windows 7 x64 & IE9 x64 (remote)

Success (rxnorm/snomed file versions and “install” button displayed):
  All of the above OS’s & Firefox 18

So, whatever causes the HTML to get horked up and send STDOUT into oblivion only exhibits itself under IE.
It’s very odd, as I mentioned in the other thread adding an echo(“x”) statement after line 179 fixes it, adding an echo(" x") does not. And as I said above, crunching the whitespace between lines 180 and 181 also “fixes” it.

bradymiller wrote on Saturday, January 12, 2013:

Hi,
I just posted a “fix” to sourceforge. Can you let me know if it works. If so, then will include it in the next 4.1.1 patch also.
http://github.com/openemr/openemr/commit/ea3d7a84129181cdf52ea62c6888c7c5f035ce97

thanks,
-brady
OpenEMR

pfwilliams wrote on Monday, January 14, 2013:

I just reconfirmed, that mystery fix does (somehow) resolve the blank “staged releases” box issue for IE8 x32, IE9 x32 and IE9 x64.