barrp wrote on Saturday, January 14, 2006:
Hi,
Is there a way I could get to the mysql database from the Oemr demo site so that I could see how the underlying data structures are put together?
That would help me to answer some questions about the project structure. How big is it? could someone zip it to me?
Phil
drbowen wrote on Saturday, January 14, 2006:
The demo at oemr.org is a stock release of OpenEMR 2.8.0. OpenEMR 2.8.0 does have some minor bugs that have already been fixed and available from the SourceForge download site.
http://sourceforge.net/project/showfiles.php?group_id=60081
The table structures are unchanged.
By Zip do you use Windows and need a zipped file or is the ~tar.gz file OK?
sunsetsystems wrote on Saturday, January 14, 2006:
You might also see:
http://cvs.sourceforge.net/viewcvs.py/openemr/openemr/sql/database.sql?rev=1.23&view=markup
This will take a while to load because it includes all the ICD9 and HCPCS codes.
Be aware that most of the encounter forms create one additional table each when they are set up.
– Rod
www.sunsetsystems.com
barrp wrote on Monday, January 16, 2006:
I use mostly windows but have a linux box also.
Thanks Sam & Rod. I guess I should just bite the bullet and set up a server of my own.
Where is the best starting point for someone who has not set up apache before and has minimal experience in Linux?
pb
drbowen wrote on Monday, January 16, 2006:
It depends a lot on personal preferences. The “tar balls” can be opened in Windows. You have to be a bit careful because the end-of-line characters are different in Windows and Linux. Linux uses a \n and windows uses a control M.
Winzip can open the ~.tar.gz (~.tgz) files but there is a setting in WinZip that breaks the linux lines inappropriately. This has be turned off to open them correctly.
OpenEMR runs on Windows XP professional and Windows 2003 Server.
Your life will be simpler to learn to use Linux as a server. What distribution do you have?
Most full (possibly all) Linux distributions come with Apache and PHP already installed. The smaller ones like Peanut, Feather, and DamnSmall Linux will not have Apache. All of the major distributions SUSE, Debian, Fedora, Fedora look-a-likes, Ubuntu, Gentoo, and others have Apache installed or easily available. (RedHat is still around but the free version has not been maintained for about 3 years.)
Apache takes very minimal configuration to operate. In Slackware I just select to run Apache and PHP during the installation process and the server is already and running when it comes up the first time.
I do make one additional change to the Apache configuration file (need to add index.php to the list of recognized index files).
So, What’s your druthers?
Sam Bowen
andres_paglayan wrote on Monday, January 16, 2006:
I’ll suggest starting with ubuntu, when you are comfortable move to debian, then to gentoo,
Today’s Linux distributions are very user friendly and seting up a basic web server is now almost trivial.
sunsetsystems wrote on Monday, January 16, 2006:
Your next steps depend on how badly you want to learn more about Linux. :-) If you have the time and desire, you should set up Apache with PHP4, download the tarball and read the INSTALL file for initial instructions.
Otherwise there are consultaints like Yours Truly. I thought there was a list of them at www.oemr.org but I don’t see that right now.
– Rod
www.sunsetsystems.com
drbowen wrote on Monday, January 16, 2006:
The Commercial help list is still there. It’s under the wiki:
http://www.oemr.org/modules/wiwimod/index.php?page=CommercialHelp&back=WiwiHome
drbowen wrote on Monday, January 16, 2006:
I uploaded OpenEMR-2.8.0.zip to the oemr.org homepage at:
http://www.oemr.org/files/openemr-2.8.0.zip
There are several bug fixes since the openemr-2.8.0 release. I will package these ang make them available for download shortly.
Let me know if this helps.
Sam Bowen, MD
barrp wrote on Monday, January 16, 2006:
Got it. Thank you.
Phil