Are you looking for database export and import kind of functionality ?
In RHOM two APIs available http://docs.rhomobile.com/rhodesapi/rhom-api#databaseexport
Just try those. Hope it will help.
We are using Fixed schema in our design. We have used active sync from the desktop to device to deploy the application to the device. Now that we have stored few records on the device how to get those records from the Device to the desktop. Please let me know if we have one table "Received_File" how to get that table data to desktop.
1 of 1 people found this helpful
Please let me know if we have one table "Received_File" how to get that table data to desktop.
You need to decide on a communications channel (email, connect to server/web service etc.) and write the necessary code on both the client and server/desktop side. You will need to write code to retrieve data from the database using Rhom, send it over your chosen communication channel, and then delete the data from the table using Rhom.
Do you expect somebody in a forum to architect your app for you and then write the code?
We are planning .net application to get the data from the device. Just wanted to know the possible channel of communication we have and to know on a high level how each channel works. We have purchased two are in the process of purchasing 100 MC9190 devices and currently working on the POC to evaluate RhoElements for our Project. We may be using RhoConnect for the actual implementation. For the POC still we need to build an end to end .
Thanks for your valuable suggestion.
I would write a simple REST service using .net, then, and you can connect to it using asyncHttp.
It's up to you to write whatever code to get the data from the database and send it. There is no generic "export".
You will need a local WiFi connection or expose your server on the Internet for mobile use.
The simplest thing to do may be export the sqlite database partition you’re interested in, by default you’ve “local” and “user”, and send via ftp the zipped archive to your server:
Your .NET app on the server can then simply check the ftp folder and then use the sqlite library to open the database and use it.
If you’re planning to use RhoConnect in the future, my suggestion is to not build complex systems to do the synchronization. But it really depends if this is feasible with your design constrains (kind of connection, cost of traffic, size of the database, number of changes that you want to transmit and so on).