[will]

After completing my first app with mobi one for my sales team i am now thinking of creating an app for the warehouse.
Basically I want to create an app which can add and remove stock either updating an external excel sheet or by using a database in local storage. This would be used to quickly add or remove items when stock arrives or orders are shipped out and allow for less time doing stock takes.

My first thought was large scrollable lists of stock items (e.g: small parts, large items etc) with a plus and minus button next to each to allow for editing.

I would greatly aprechiate an advice regarding how to achieve this. I have been looking at database examples, and php but having no coding experience don’t really know what a lot of it means.

Does mobi-one/jquery have any widgets or simple ways of doing this?
Where would you suggest I start with this project e.g. making forms, php trigers?

Thanks

[dabbelju]

Hi will,

as far as I know for now, there are no widgets available in MobiOne dealing with jquery stuff. But it is quiet easy to write your own functions.

I assuem that you have a central DB (somewhere on a server) and you want to use devices, such as iphone to update the central db and to show actual stock on the devices, right?

In this case I would suggest the following:

Data synchronisation between Server DB and device:
You should write a routine on the server (for example in php) which pulls data out of the DB and provide it to the device as XML. On the device you can decide if you want to store a copy in the local DB (would be needed if devices are not “online” all the time or if you just display the XML.

Functions to add or remove items from stock:
Write another php page, which receives a stock item ID and an opreration (add item, remove item). This is updating the DB on the server. Afterwards call the function to synchronise data again.

Display Data on the device:
Take data directly from the XML file, or from the local DB and display it as listitems in a panel.

If I am wrong with my assumption, please specify a bit more what you want.

I hope this helps.

best
dabbelju

[will]

you are pretty much correct in all your assumptions

Rather an intimidating list of coding techniques to learn but at least i know that it is possible 🙂

Better go look at some php examples now.

Thanks a lot for the advice.

[dabbelju]

Could you basically describe your planned architecture a bit more? I assume you have a server holding the stock db. What kind of db is it and is there a webserver running on it which is able to do php?

Could you provide an snippet of the db as sql dump?

Then I can see if I have some similar code snippets cause I do somethng very similar with php.

Do you plan to have a local “copy” of the stock db on the device or do you want to go for the “online” version?

Could you provide some screens in MobiOne how you want it too look like?

best
Dabbelju

[will]

dear dabbelju

thanks alot for the offer but this project has been put on haiatus due to the high oppertunity cost of time required. I may re visit it later and would be very grateful of any help then

[boater]

Hello dabbelju,

I have a question for you that does not fit on this forum but does relate to a database/PHP problem. Please contact me using the email in my profile if you are interested.

Thanks,

Ted

[dabbelju]

Hi boater,

I can not see an email address. Can you post it in here?

Thanks and best
dabbelju

[boater]

You may reach me at mailto:mobione@aresolid.com

Regards,

Ted

[aklisiewicz]

I need an App with similar scenarion
1st stage
– local database on the device
– updated from remote MySQL to the local storage (upon request)
2nd stage
– updates on the device
– two way synchronization with remote MySQL

my concern is writing a PHP to do the job on a server side. I’m not really familiar with PHP (or just ver, very little), and I wonder if there is any software or tools to create PHP code for me without (or with very little) coding ?

Arthur

[nvts]

I hate to hijack this thread also, but I have had no replies from the support team.

I am also wanting to have a offline web db, with parent child tables, multiple screens with popup data entry items and so on that is stored on the local device. Then when the employee gets into wifi range can upload and sync data from the cloud server.

I am just trying to try many different js frameworks at this time. I have the local storage working, but I want to use a sql db offline instead.

Any help of examples for a simple CRUD would be great. If I get mine working first, I will post for others to use as an example.

Cheers…

Howard

[Author]

Posts