Work offline

ijaraho wrote on Sunday, August 25, 2013:

hi,
Because the internet not available at all times, the costumer ask me if he can work offline (local host) in his PCs (PC1, PC2, PC3, …), then when the internet available Synchronizes data between offline and online openemr.
are you have any ideas, how I can do that?

blankev wrote on Sunday, August 25, 2013:

Great question! I work under same circumstances. HOW to be sure not loosing INPUT of the Local or Web-site installations. This has nothing to do with OpenEMR, but everything with implementation of a great feature. Hope “THEY” jump in to show to way.

fsgl wrote on Sunday, August 25, 2013:

Would it work to treat the 3 computers as “different sites” and synchronize the databases as described in Multiple Sites?

ijaraho wrote on Monday, August 26, 2013:

3 computers work on same database (same site) but in different locations.
My idea: install openemr locally if I have on 1 computer, or install openemr on local server and the other client computers connect to that server to work on openemr, after that the computer (or server) which has openemr may connect automatically when internet available to update database and update “sites” folder.
but the question what if 3 computers (for example) cannot connect locally because it far.

fsgl wrote on Monday, August 26, 2013:

Ok, so you really are talking about multiple locations.

The Multiple Sites Module was built for computers which are too far to connect by wire or outside the range of the router. The connection between the computers would be the Internet when it is available.

As stated in the article cited above, there are security risks associated with this method of connecting the computers.

ijaraho wrote on Monday, August 26, 2013:

Yes: multiple locations, working on same databsae, internet not available temporary: what is the solution???

fsgl wrote on Monday, August 26, 2013:

When the Internet connection becomes available, synchronization of the Default folders and MySql database would occur over an intranet or a virtual private network.

No experience setting up either.

ijaraho wrote on Monday, August 26, 2013:

I am talking about synchronization
the Default folders and MySql database on intranet or a virtual private network
and
the Default folders and MySql database on intrnet

how can done it automatically??

fsgl wrote on Monday, August 26, 2013:

Perhaps a modification of this cloud backup?

Or file synchronization software that is free, such as FreeFileSyn.

Nice chart of comparison of file synchronization software, both open source and commercial, in Wikipedia.

bradymiller wrote on Sunday, September 08, 2013:

Hi,

See here for some thoughts on how to do this:
http://sourceforge.net/p/openemr/discussion/202506/thread/44ceb9b9/#f817

-brady
OpenEMR

yehster wrote on Sunday, September 08, 2013:

A fundamental problem is that OpenEMR uses auto-increment columns for just about every single new data record. So if actions are happening at more than one site at a time, ID’s are going to conflict. There’s definitely no way to handle this problem just using “off the shelf” replication strategies at present.