Request for a new feature: Off-line capability of OSPOS

[smehedi]

Background information

IMPORTANT: If you choose to ignore this issue report template, your issue will be closed as we cannot help without the requested information.

Please make sure you tick (add an x between the square brackets with no spaces) the following check boxes:

• Reporting an issue of an unmodified OSPOS installation
• Checked open and closed issues and no similar issue was already reported (please make sure you searched!)
• Read README, WHATS_NEW, INSTALL.md and UPGRADE
• Read the FAQ for any known install and/or upgrade gotchas (in specific PHP extensions installed)
• Read the wiki
• Executed any database upgrade scripts if an upgrade pre 3.0.0 (e.g. database/2.4_to_3.0.sql)
• Aware the installation code that GitHub master is for developers only and therefore not complete nor stable.

Installation information

• OSPOS version is: 3.3.9
• OSPOS git commit hash is:
• PHP version is:
• MySQL or MariaDB version is:
• OS and version is: Ubuntu 22.04.3 LTS
• WebServer is: Xampp 7.4.33
• Selected language is:
• (If applicable) Docker installation:
• (If applicable) Installation package for the LAMP/LEMP stack is:

Issue / Bug / Question / New Feature

Please write your issue here. If a bug, please make sure to provide as much information as possible including configuration settings (e.g. Decimals set, Tax mode), language and steps to reproduce the bug.

Request for a new feature: Off-line capability of OSPOS

1. In our country internet connection is not reliable. Whenever the internet goes off, OSPOS should continue to operate on the client device with its off-line capability and temporarily save data.
2. As the internet turns on, OSPOS should sync locally stored transaction data to the remote server.

Requested by:
Salah Uddin Mehedi
salah.mehedi@gmailcom

[meierrom]

Why don't you use it offline only. Problem solved, right?

…

On Wed, Feb 28, 2024, 17:40 smehedi ***@***.***> wrote: Background information *IMPORTANT: If you choose to ignore this issue report template, your issue will be closed as we cannot help without the requested information.* Please make sure you tick (add an x between the square brackets with no spaces) the following check boxes: - Reporting an issue of an unmodified OSPOS installation - Checked open and closed issues <https://github.com/opensourcepos/opensourcepos/issues?utf8=%E2%9C%93&q=is%3Aissue> and no similar issue was already reported (please make sure you searched!) - Read README <https://github.com/opensourcepos/opensourcepos/blob/master/README.md>, WHATS_NEW <https://github.com/opensourcepos/opensourcepos/blob/master/WHATS_NEW.txt>, INSTALL.md <https://github.com/opensourcepos/opensourcepos/blob/master/INSTALL.md> and UPGRADE <https://github.com/opensourcepos/opensourcepos/blob/master/UPGRADE.txt> - Read the FAQ <https://github.com/opensourcepos/opensourcepos#faq> for any known install and/or upgrade gotchas (in specific PHP extensions installed) - Read the wiki <https://github.com/opensourcepos/opensourcepos/wiki> - Executed any database upgrade scripts if an upgrade pre 3.0.0 (e.g. database/2.4_to_3.0.sql) - Aware the installation code that GitHub master <https://github.com/opensourcepos/opensourcepos/tree/master> is for developers only <https://github.com/opensourcepos/opensourcepos/wiki/Development-setup> and therefore not complete nor stable. Installation information - OSPOS version is: 3.3.9 - OSPOS git commit hash is: - PHP version is: - MySQL or MariaDB version is: - OS and version is: Ubuntu 22.04.3 LTS - WebServer is: Xampp 7.4.33 - Selected language is: - (If applicable) Docker installation: - (If applicable) Installation package for the LAMP/LEMP stack is: Issue / Bug / Question / New Feature Please write your issue here. If a bug, please make sure to provide as much information as possible including configuration settings (e.g. Decimals set, Tax mode), language and steps to reproduce the bug. Request for a new feature: Off-line capability of OSPOS 1. In our country internet connection is not reliable. Whenever the internet goes off, OSPOS should continue to operate on the client device with its off-line capability and temporarily save data. 2. As the internet turns on, OSPOS should sync locally stored transaction data to the remote server. Requested by: Salah Uddin Mehedi ***@***.*** — Reply to this email directly, view it on GitHub <#3938>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AIR4PO2OS2I3SXM2KQXIQYTYV5T2NAVCNFSM6AAAAABD6OX7EOVHI2DSMVQWIX3LMV43ASLTON2WKOZSGE2TSNBYHAZTOOA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[ekardian]

i had sometthing like that when i find OSPOS, so i just imported my dumped the backup/database. u can make a backup with phpamyadmin or in manual, ande import the backup with phpmyadmin again in the online server, u can create a cron job too for this tip,.
but this metod is a waste of time too, just do like @meierrom

[hoststatic]

you have to create an android app, use sqlite locally, create a column on sales for "online_upload", 1/0.
if 1 skip if 0 upload.

[meierrom]

Wow, this is probably the most nonsensical post I have read in a long time? Are you a bot?

…

On Sat, Mar 2, 2024, 13:53 hoststatic ***@***.***> wrote: you have to create an android app, use sqlite locally, create a column on sales for "online_upload", 1/0. if 1 skip if 0 upload. — Reply to this email directly, view it on GitHub <#3938 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AIR4PO2YOSDBFR54FO3PIN3YWHKW5AVCNFSM6AAAAABD6OX7EOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNZUHAYDENBUGA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[hoststatic]

Wow, this is probably the most nonsensical post I have read in a long time?
Are you a bot?

On Sat, Mar 2, 2024, 13:53 hoststatic @.***> wrote:

you have to create an android app, use sqlite locally, create a column on
sales for "online_upload", 1/0.
if 1 skip if 0 upload.

—
Reply to this email directly, view it on GitHub
#3938 (comment),
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AIR4PO2YOSDBFR54FO3PIN3YWHKW5AVCNFSM6AAAAABD6OX7EOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNZUHAYDENBUGA
.
You are receiving this because you were mentioned.Message ID:
@.***>

you can achieve this with an android app, I was in a rush but to understand logic. create a rest api in ospos webserver (secure it). then via an android app you can create an app which would have a local db (sqlite), the sales table will have an extra column both server db and sqlite (synced or uploaded whatever) with a value 1or0 or whatever. so when you make a sale from app if there is present internet you contact rest api and upload directly to db also synced=1. if not its saved on local db on android (sqlite) and synced is 0, youc create a function in libraries like volley that whenever internet present do x action. in this case upload the sales with synced=0 and change sts to 1.
that's the basic logic.
that can be done it has been done in other android projects.
other than that is with Javascript local storage and Ajax. idk how this is done but a guy was selling an ospos version with this kind of implementation in codecanyon

[smehedi]

Hi meierrom, It was great to have a response from you so quickly and at the same time I truly apologize to respond so late. I think I have not communicated clearly on request for a new feature, hence I am rephrasing it here again: 1. I want to host or deploy OSPOS on a remote server or cloud, I will access OSPOS locally over the internet. 2. Internet connection is not reliable, hence it might turn off in the middle of customer transactions, in such a case OSPOS should let the user continue with the transaction, OSPOS will complete the transaction even if it is disconnected from the server. 3. While the internet remains off, OSPOS will allow new transactions to begin and continue to checkout. 4. As the internet turns on, OSPOS should sync all such transactions with the remote server. I hope I have communicated the online-offline capability requirement of OSPOS clearly this time. If it is still unclear please let me know. Best Regards

…

On Thu, Feb 29, 2024 at 12:02 AM meierrom ***@***.***> wrote: Why don't you use it offline only. Problem solved, right? On Wed, Feb 28, 2024, 17:40 smehedi ***@***.***> wrote: > Background information > > *IMPORTANT: If you choose to ignore this issue report template, your issue > will be closed as we cannot help without the requested information.* > > Please make sure you tick (add an x between the square brackets with no > spaces) the following check boxes: > > - Reporting an issue of an unmodified OSPOS installation > - Checked open and closed issues > < https://github.com/opensourcepos/opensourcepos/issues?utf8=%E2%9C%93&q=is%3Aissue> > and no similar issue was already reported (please make sure you searched!) > - Read README > <https://github.com/opensourcepos/opensourcepos/blob/master/README.md>, > WHATS_NEW > < https://github.com/opensourcepos/opensourcepos/blob/master/WHATS_NEW.txt>, > INSTALL.md > <https://github.com/opensourcepos/opensourcepos/blob/master/INSTALL.md> > and UPGRADE > <https://github.com/opensourcepos/opensourcepos/blob/master/UPGRADE.txt> > - Read the FAQ <https://github.com/opensourcepos/opensourcepos#faq> > for any known install and/or upgrade gotchas (in specific PHP extensions > installed) > - Read the wiki <https://github.com/opensourcepos/opensourcepos/wiki> > - Executed any database upgrade scripts if an upgrade pre 3.0.0 (e.g. > database/2.4_to_3.0.sql) > - Aware the installation code that GitHub master > <https://github.com/opensourcepos/opensourcepos/tree/master> is for developers > only > <https://github.com/opensourcepos/opensourcepos/wiki/Development-setup> > and therefore not complete nor stable. > > Installation information > > - OSPOS version is: 3.3.9 > - OSPOS git commit hash is: > - PHP version is: > - MySQL or MariaDB version is: > - OS and version is: Ubuntu 22.04.3 LTS > - WebServer is: Xampp 7.4.33 > - Selected language is: > - (If applicable) Docker installation: > - (If applicable) Installation package for the LAMP/LEMP stack is: > > Issue / Bug / Question / New Feature > > Please write your issue here. If a bug, please make sure to provide as > much information as possible including configuration settings (e.g. > Decimals set, Tax mode), language and steps to reproduce the bug. > > Request for a new feature: Off-line capability of OSPOS > > 1. In our country internet connection is not reliable. Whenever the > internet goes off, OSPOS should continue to operate on the client device > with its off-line capability and temporarily save data. > 2. As the internet turns on, OSPOS should sync locally stored > transaction data to the remote server. > > Requested by: > Salah Uddin Mehedi > ***@***.*** > > — > Reply to this email directly, view it on GitHub > <#3938>, or > unsubscribe > < https://github.com/notifications/unsubscribe-auth/AIR4PO2OS2I3SXM2KQXIQYTYV5T2NAVCNFSM6AAAAABD6OX7EOVHI2DSMVQWIX3LMV43ASLTON2WKOZSGE2TSNBYHAZTOOA> > . > You are receiving this because you are subscribed to this thread.Message > ID: ***@***.***> > — Reply to this email directly, view it on GitHub <#3938 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ADJR62C2OKGQVVTSQ3HGCXDYV5WLPAVCNFSM6AAAAABD6OX7EOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNRZGU2DONJSHA> . You are receiving this because you authored the thread.Message ID: ***@***.***>