[Q] Offline database + sync - General Questions and Answers

Hello,
we have Web and desktop applications that uses MS SQL server database. Now we would like to develop iPhone/iPad application that would use the same data. However the problem is that our users are supposed to be able to use this app in the places where the internet connection is not available. We decided to use SQL lite and sync the data beetween MS SQL Server and SQL Lite.
So, my question is: Is there any framework for synchronization? Or any other solution or best practices?
I am pretty sure that this situation is quite common and we are not the first who stuck with that problem...

Related

Desktop synchronization of Android just like WM-phones

Hi friends,
Let me put these questions as simple as it can be -
1. is it possible for android to synchronize with the desktop computer
running Win XP?, if yes how? Wm phones can do it seamlessly using
MSActivesync.
2. is it possible to use the desktop's internet connection and browse
the web from the android? (just like WM-phones do with MS Activesync)
3. Is there a way to import all the Windows mobile contacts onto the
Android phone? NOT from google mail-account because I have different
contacts in my phone and gmail. And I would like to import my Phone
contacts onto Android.
THANKS to anyone who answers all/part of the queries.
arefin
arefin said:
Hi friends,
Let me put these questions as simple as it can be -
1. is it possible for android to synchronize with the desktop computer
running Win XP?, if yes how? Wm phones can do it seamlessly using
MSActivesync.
2. is it possible to use the desktop's internet connection and browse
the web from the android? (just like WM-phones do with MS Activesync)
3. Is there a way to import all the Windows mobile contacts onto the
Android phone? NOT from google mail-account because I have different
contacts in my phone and gmail. And I would like to import my Phone
contacts onto Android.
THANKS to anyone who answers all/part of the queries.
arefin
Click to expand...
Click to collapse
1. Hopefully google would release a cloud based or an application that allows this, as it would make some lives a little easier.
2. I do not believe there is an app capable of this but it may be possible via bluetooth or use the desktop as an AP. Either way, i don't think you will get any better than you would off of wifi.
3. I found this off a quick search http://www.myhtcphone.com/import-contacts. Dont know if it works or not, but it seems to be like what you want.
1. use google calendar sync.
2. use adb port forwarding with proxy or vpn.
3. export your outlook contacts as csv and import them in gmail.
Not Really!
billc.cn said:
1. use google calendar sync.
2. use adb port forwarding with proxy or vpn.
3. export your outlook contacts as csv and import them in gmail.
Click to expand...
Click to collapse
Google calender sync is at it says "for your calender only". No contacts. No idea why they can't just add it. Our lives would be so much easier.
I've had a friend report to me that Google has licensed the ActiveSync technology, so it may be added in a future build of the Android OS.
I believe that the "Hero" version that Haykuro is toying with currently also showed ActiveSync in one of the menus, but I can't vouch for that at the moment.
Hopefully it will be sooner rather than later.
TooSlo said:
I've had a friend report to me that Google has licensed the ActiveSync technology, so it may be added in a future build of the Android OS.
I believe that the "Hero" version that Haykuro is toying with currently also showed ActiveSync in one of the menus, but I can't vouch for that at the moment.
Hopefully it will be sooner rather than later.
Click to expand...
Click to collapse
It's not ActiveSync, that's Microsoft's product. The new Hero build (as well as the stock Magic ROM) have a program called HTC Sync. I don't believe anyone has obtained a copy of the desktop software for that though.
it's two separate things.
google licensed activesync to allow ms exchange clients to sync with google calendar and gmail contacts (see http://www.google.com/mobile/winmo/sync.html). you already have this on android.
the ms exchange option appeared in the mail app can only connect to ms exchange servers (not your desktop activesync clients) and can do email only.
htc sync is the only possiblility. (m$ won't be stupid enough to allow you to use activesync on any other platform.)
Your ideas of sync are outdated on Android.
My phone address book syncs to my gmail account, and my email clients address book syncs to gmail. My phone calander syncs to Google Cal, and I find the web based interface to work just fine. But I am sure you can find something to sync whatever your cal program is to google.
All this syncing happens when the phone is in my pocket and is always up to date.
As for browsing the web from the phone, over the usb connector, why? The phone has 3G and wifi.
You can import your contacts as a group into gmail, then set the phone to only display contacts from that group.
arefin said:
Hi friends,
Let me put these questions as simple as it can be -
1. is it possible for android to synchronize with the desktop computer
running Win XP?, if yes how? Wm phones can do it seamlessly using
MSActivesync.
2. is it possible to use the desktop's internet connection and browse
the web from the android? (just like WM-phones do with MS Activesync)
3. Is there a way to import all the Windows mobile contacts onto the
Android phone? NOT from google mail-account because I have different
contacts in my phone and gmail. And I would like to import my Phone
contacts onto Android.
THANKS to anyone who answers all/part of the queries.
arefin
Click to expand...
Click to collapse
as everyone else is surely noticing .. google syncs better than the mickeysoft mousesync stuff other people use .. you are automatically synced to the google server and from there you can do anything .. i pull my calendar into outlook or anything else i want .. so .. what was the question again?!?
If you have no 'net connex, 'the cloud' does 2 things: jack & shizzle.
I do, however, wish I could keep my contacts synced with GMail (after my initial .cvs port-over). GCalSync works very well, though!
-bZj
PorchG1 said:
All this syncing happens when the phone is in my pocket and is always up to date.
Click to expand...
Click to collapse
That's great, but I don't want to be beholden to a corporation, especially not to a single corp using closed protocols. If kinda defeats the purpose of having an open source phone for some of us. A mechanism to sync to my home server (not desktop), would certainly be welcomed.
PorchG1 said:
As for browsing the web from the phone, over the usb connector, why? The phone has 3G and wifi.
Click to expand...
Click to collapse
Ever heard of wireline? I guess you can't conceive of being in an environment without wifi or 3G, they do exist you know? Not to mention that it would be nice to not always have to broadcast everything you do into the ether.
Thanks to everyone who responded
PorchG1 said:
Your ideas of sync are outdated on Android.
My phone address book syncs to my gmail account, and my email clients address book syncs to gmail. My phone calander syncs to Google Cal, and I find the web based interface to work just fine. But I am sure you can find something to sync whatever your cal program is to google.
All this syncing happens when the phone is in my pocket and is always up to date.
As for browsing the web from the phone, over the usb connector, why? The phone has 3G and wifi.
You can import your contacts as a group into gmail, then set the phone to only display contacts from that group.
Click to expand...
Click to collapse
Yes, many of the suggestions sounds good for me. I am guessing many of you r not on Windows anymore. My problem is there, I am still on Windows just becoz I play lot of games, install a lots of programs which are only possible on win-ground. I do streaming - didnt find lot of freedom in this area on other OSs.
btw, I will apply your ideas considering them expert opinions becoz OI am just a noob in such things.
Thanks friends,
gSyncit Sync the calander and contacts....
arefin said:
Yes, many of the suggestions sounds good for me. I am guessing many of you r not on Windows anymore. My problem is there, I am still on Windows just becoz I play lot of games, install a lots of programs which are only possible on win-ground. I do streaming - didnt find lot of freedom in this area on other OSs.
btw, I will apply your ideas considering them expert opinions becoz OI am just a noob in such things.
Click to expand...
Click to collapse
that didn't make much sense .. "not on Windows" anymore .. my primary OS is Microsoft for the same reason that there is a lot more freedom
MartinFick said:
That's great, but I don't want to be beholden to a corporation, especially not to a single corp using closed protocols. If kinda defeats the purpose of having an open source phone for some of us. A mechanism to sync to my home server (not desktop), would certainly be welcomed.
Click to expand...
Click to collapse
Oh, you're not tied to Google. Android is made so that each of its apps can be replaced by a user-made app (of course, as with the lock screen, that's still in the process of being completed). There's a few calendar applications in the market that can do the same thing that the Google Calendar can. Or you could code your own/hire someone to do so.
I don't get G3. And Wifi is only at home. I am in Edge or GPRS most of the time. I was in GPRS when I typed that message. Syncing works just fine.
I can understand not wanting to trust your data to Google. Apps can read and write to the address book and cal. All somebody needs to do is make an on-line sync app.
After years of living with having to sync my palm, the "cloud" syncing Google provides is the next slice bread. But I do backup my phone, just in case.
I still don't see why you want to browse the web on your phone, wired to your laptop. Just use the laptop then. Or create an ad-hoc connection with ICS and do that over wireless.(Not tried it, but I assume it will work.)
MartinFick said:
That's great, but I don't want to be beholden to a corporation, especially not to a single corp using closed protocols. If kinda defeats the purpose of having an open source phone for some of us. A mechanism to sync to my home server (not desktop), would certainly be welcomed.
Click to expand...
Click to collapse
When it starts working for the Android, you could use Funambol (http://www.funambol.com/) on your PC and get both a cloud sync (if you so choose) and a desktop sync. I used to use it to sync my SE P990.
The last time I checked, it wasn't working, but maybe it's fixed now.
http://code.google.com/p/funambol/
PorchG1 said:
I still don't see why you want to browse the web on your phone, wired to your laptop. Just use the laptop then.
Click to expand...
Click to collapse
I can't speak for the original poster, but I often want to download stuff to my phone, apps, data, ... This is not surfing so to speak, but it still requires a connection. Sometimes wireless is not available for this.
os2baba said:
When it starts working for the Android, you could use Funambol (http://www.funambol.com/) on your PC and get both a cloud sync (if you so choose) and a desktop sync.
Click to expand...
Click to collapse
Yes, thanks, I am familiar with that project. Unfortunately I refuse to run a 500MB RAM gorilla (I tried it, it really does use 500MB) on my home server (I run at least 10 virtual servers on my one PC) just to provide a sync framework for one phone. I will not sacrifice that much from the other real server applications that I use. Funambol is really not a good (sane) solution for individuals. I will be investigating the syncevolution framework soon.

Sharepoint Mobile

Hello, I'm going to be posting this on several different message boards because I'm not really sure who will be able to help. If anyone has any suggestions as to other websites I can post this question on, please feel free to suggest. The other couple that I'm going to post to first is tech-forums (dot) net and msfn (dot) org
I am having problems connecting Sharepoint workspace mobile to my Sharepoint 2010 server. I have winmo 6.5 pro and the sharepoint app is running. I have an unlimited data plan, and I have tested this where my data works fine. I have tested this inside my network and outside also using wifi.
I have one standalone Sharepoint 2010 Enterprise server installed. The server is working. I can get to the website using a web browser and it is running off of port 80. I can browse to the site from outside my firewall as well as inside with no problems. So I know that Sharepoint, in and of itself, is working.
I have tried two other phones running winmo 6.5 with data plans, and office 2010 mobile and am getting the same error.
Basically, I open sharepoint mobile 2010, go to the address sharepoint.domain.com (just an example) and I get the error: "Cannot connect. Sharepoint mobile doesn't support the authentication scheme that this server requires. Do you want to open this in your web browser?"
If I click yes, it does open the sharepoint site in IE.
All I really want is to be able to sync docs between a doc library and my phone, and my PC using workspace.
Any help will be greatly appreciated.
TIA
Under the web server that you have authentication methods, I am guessing you have integrated windows auth or something like that set , and to use it with winmo it needs to be set to basic.
Now it has been a while since I set one up , but I think that is your problem ..
You will have to make sure that the main and all subwebs get changed to match the same authentication ...
One thing I have done in the past if you need integrated for your intranet, is to clone the sharepoint site, and run a second one for mobile users, just make sure you are using the same data stores .....
Moved as not software release.

[Q] Sync database of android app with web server database

I am a noob in android development, I developed an android application using sqlite database. I have same application on web server in php using mysql database. I want to sync the changes of whole database(including all six tables) on web server with my android app database. How do I do it? I need to know how do i check if there is some updation in web server database and if there is some updation then how do i get those updations to my android database automatically.
Is there a way to do it without GCM and SyncAdapter?

[Q] Sync database of android app with web server database

I am a noob in android development, I developed an android application using sqlite database. I have same application on web server in php using mysql database. I want to sync the changes of whole database(including all six tables) on web server with my android app database. How do I do it? I need to know how do i check if there is some updation in web server database and if there is some updation then how do i get those updations to my android database automatically.
Is there a way to do it without GCM and SyncAdapter?
AnilSRawat said:
I am a noob in android development, I developed an android application using sqlite database. I have same application on web server in php using mysql database. I want to sync the changes of whole database(including all six tables) on web server with my android app database. How do I do it? I need to know how do i check if there is some updation in web server database and if there is some updation then how do i get those updations to my android database automatically.
Is there a way to do it without GCM and SyncAdapter?
Click to expand...
Click to collapse
hello there, I'm not sure if this is what you are looking for but it seems to reference what you are questioning.
hope it helps. it has videos and code examples. sorry for external link.
http://programmerguru.com/android-tutorial/how-to-sync-remote-mysql-db-to-sqlite-on-android/

How to connect android chat application with web chat application?

I am developing a chat application in web as well as in android. All the things have completed on web portal, I used nodejs and redis server for that. Now on android side I have very little experience, but some how managed to create a simple chat application using XMPP and openfire and also connected my Openfire with MYsql database. I can see Openfire users and tables in my Mysql database. But what I want is to connect both web and android apps, like facebook messanger app.. But I don't know how to connect both. I don't want to create user ID's in openfire as those are already in user table.
Or m I doing this in wrong way, should I use common protocol on both web and android?
Please guide me, if someone have done this before.
IRC?

Categories

Resources