On 08/18/2010 09:29 AM, Lord_Devi wrote: > Here is the catch. The SQL database itself exists at a 'home office', > and these workers are wanting to be able to enter this data remotely; > in an 'offline mode' as it were.
Some kind of local cache is needed. As you point out the difficulty is with updating the central database. The update could be + triggered manually, putting the onus on the user to remember to do so once connected. + attempted regularly via cron + triggered via a script launched by the interfaces configuration once network connectivity is regained > I don't know if maybe having a local SQL database running on each > worker laptop which could somehow 'sync' the data would be a viable > option or not... That is something I have never tried before. http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org > ... they may have to enter the data twice: Once on-site, and a 2nd > time when they get back to the office. Essentially copying the > offline data, into the 'live' forms essentially. Not a good choice. That wastes more than work. A central rule of time management is to touch each piece of paper only once -- ever. /Lars --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
