2. PHPRunner General questions
  3. Off-line access
This topic is locked

Off-line access

 		7/28/2023 8:33:50 AM
PHPRunner General questions
G
 graham.tech4t author

Hi Sergey, will PHPR 11 give us this option please?
Can anyone suggest the best way to give field teams a way to cover poor internet connection when they are canvassing? I was wondering if the best way was to have an off-line solution, and then when internet was stronger, it would auto sync and update the databases. Any thoughts or ideas would be welcome. Thank you.
Jan K. Van Dalen
We use a product called symmetricds from JumpMind. We have extensive field operations and symmeticsds just works. If you want to build it all using phprunner, is possible (as we are testing some models) but not as straight forward
A
 		asawyer13DevClub member 7/28/2023

There has been no mention of offline, so I suspect it won't be available.
The direction I would probably head would be a desktop app written in PHPRunner and an online PHPRunner app.
The desktop version would be installed on each users Laptop or PC with a local database. They would run the app offline always.
The online PHPRunner app would of course be online with it's database.
I would either create a separate app or find an existing one, that will sync the two databases, bidirectionally. It would run in the background on the users PC or Laptop and keep everything up to date. That's the tricky part for sure,but it can be done.
The primary key on the tables could be a GUID so new records will be unique even if created on the PC/Laptop or the Server.
Alan
P
 		pmuckleDevClub member 7/28/2023

It would be very nice!
A very simple and cheap but limited method could be to have an offline data collection tool that exports to csv, and import that into phprunner when connected.
not automatic or bi-directional, but it would work.