>From: Joerg Bruehe [mailto:joerg.bruehe@stripped]
>Sent: Thursday, August 19, 2010 7:25 AM
>Cc: Jerry Schwartz; 'Lord_Devi'
>Subject: Re: OpenOffice, Go-OO, ODBC, Offline Data Entry
>Jerry Schwartz wrote:
>> I deal with a somewhat similar situation. Even though we have fast VPN
>> connections among our various offices, each has been afflicted with a
>> different database structure (and software) which they cannot change.
>> What I suggest you do is use the kind of "pseudo-synchronization" that we
>> Use a local copy of the application and database on each PC (MySQL will do
>> fine on even a modest system). Timestamp each record when you create or
>> When the user is back in contact with the office, extract all of the
>> with timestamps newer than the last "synchronization" event and update the
>> central database.
>> Is this foolproof? Absolutely not, if there are conflicts between the
>> by different users. You'll be stuck with "He who write last, writes best";
>> I think that's as good as it's going to get for you.
>AIUI, you could prevent that by having a second timestamp, "based-on":
>If "based-on" in the new record is the same value as "changed-on" in the
>central data base, update - if they differ, you had somebody else come
>first and will now need some manual alignment.
[JS] That's a good thought, if manual editing is practical.
>Joerg Bruehe, MySQL Build Team, joerg.bruehe@stripped
>ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin
>Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
>Amtsgericht Muenchen: HRA 95603
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1
|• OpenOffice, Go-OO, ODBC, Offline Data Entry||Lord_Devi||18 Aug|
| • RE: OpenOffice, Go-OO, ODBC, Offline Data Entry||Jerry Schwartz||18 Aug|
| • Re: OpenOffice, Go-OO, ODBC, Offline Data Entry||Joerg Bruehe||19 Aug|
| • RE: OpenOffice, Go-OO, ODBC, Offline Data Entry||Jerry Schwartz||19 Aug|
| • RE: OpenOffice, Go-OO, ODBC, Offline Data Entry||Lord_Devi||19 Aug|