Database Develop

Android Browser Bookmarks?

Does anybody here know where the android browser bookmarks are stored on the file system? I'm hoping to keep a backup of my bookmarks so I don't need to go thru the hassle of entering all my favorite sites each time I have to wipe my phone!
thanks in advance

They're stored in a database in the browser's data directory. Check http://forum.xda-developers.com/showpost.php?p=3223060&postcount=199 -- it gives you the command to use to retrieve them from the database, i.e.
sqlite3 /data/data/com.android.browser/databases/browser.db "SELECT * FROM bookmarks;"
You can also use the My Backup app (available from the Market) to back them up.

Thanks for the quick reply.
I'm not really familiar with sqlite, more of a mysql guy personally
The bookmarks table holds the browser history as well.

Bookmarks backup
You should check out MyBackup on the Market. It's a free app that will backup your bookmarks (plus a lot of other things) to your SD card. It works quite well. The restore feature is also very simple.

There is also my bookmarks as well that allows you to import your bookmarks to your phone from your desktop browser.

speoples20 said:
There is also my bookmarks as well that allows you to import your bookmarks to your phone from your desktop browser.
Click to expand...
Click to collapse
What I'd like to see (and I can't believe wasn't included in the OS) is automatic syncing of your Android bookmarks with Google Bookmarks. (or ones labeled as mobile in Google Bookmarks)

I had this frustration as well (not being able to sync or backup my bookmarks) so I finally just found a simple website where I could save all of my bookmarks, then I set it as the browser home page. There are tons of websites out there that allow you to store your bookmarks, but the one that I chose was murl.com.

Since I use Firefox I use foxmarks. Which is one of the best programs I have ever used. It sycs all of your bookmarks through firefox on as many computers as you want. They have a mobile site you can bookmark in your browser or steel bookmarks and access all of them. Not perfect but better then nothing.

I use Foxmarks too, and I love it! Every time I use a different computer, I just sync my bookmarks, and everything stays the same on each machine!
Now when I use my phone, I can also just go to Foxmarks and click on any bookmark there to go to a website.

No FireFox here. (Work doesn't allow it for some reason.)
I use the Google Toolbar on both my desktop and notebook pcs at home and at the office to keep track of my bookmarks. I'm still surprised that it doesn't doesn't sync with android though. Seems like about the only Google thing that doesn't at this point.

I just wish someone would write a utility that automatically alphabetized the bookmarks, why this isn't an option by default is annoying. I'm thinking about making it my first Android project.

grokdesigns said:
I just wish someone would write a utility that automatically alphabetized the bookmarks, why this isn't an option by default is annoying. I'm thinking about making it my first Android project.
Click to expand...
Click to collapse
I don't think it would be hard to sort the list and dump out all the history entries as well. You can do this all with some SQL commands.

Is there anyway to create a shortcut to list all the Bookmarks? I am using Dwang 1.12 Rom.
I have been searching and can not find anything on how to do it. I love the ability to push an icon, it will list all the bookmarks like the bookmark widget in the Hero Rom.
Thanks

i use the live bookmarks app from the market it lets you make an icon that opens a folder with all your bookmarks. Also bookmarkBR from the market backs up and restores bookmarks.

foxtrickle said:
You should check out MyBackup on the Market. It's a free app that will backup your bookmarks (plus a lot of other things) to your SD card. It works quite well. The restore feature is also very simple.
Click to expand...
Click to collapse
Seems it is pay ware now. Any alternative?

manually changing bookmarks
short/y said:
They're stored in a database in the browser's data directory. Check http://forum.xda-developers.com/showpost.php?p=3223060&postcount=199 -- it gives you the command to use to retrieve them from the database, i.e.
sqlite3 /data/data/com.android.browser/databases/browser.db "SELECT * FROM bookmarks;"
You can also use the My Backup app (available from the Market) to back them up.
Click to expand...
Click to collapse
Thanks for the info.
I used this to bookmark a url that was a google maps redirect. I used the adb shell to get on my rooted EVO and ran these commands:
Code:
sqlite3 /data/data/com.android.browser/databases/browser.db
update bookmarks set bookmark = 1 where url = ''http://goo.gl/maps/XXXX';
This url was already in my bookmarks because I had visited it. but I couldn't bookmark it because I was immediately redirected to google maps.
To list all of your urls:
Code:
select url from bookmarks;

[Q] Google calendar Sync on Autonooter-ed NC

Newbie here...
I got my Nook Color a few days ago, rooted using auto-nooter 3.0.0
It's running 1.1.0 and so far the experience has been pretty good.
One question tho has to do with syncing the calendar with my google calendars. Right now I am able to sync with a public calendar, but I can't find a way for the calendar to use my google gmail credentials to sync with my non-public calendars (altho when I go into the calendar app -> Setting -. My Calendars the list of calendars that I subscribe to in my gmail account show up, which means to me that it has connected once to get this info).
Any suggestions?
Thanks.

UP
I'va the same problem.
Someone know how to resolve this problem please ?
Thanks
(sorry for my english, i speek french)

If you open your gmail app and add your google account again, it will give you the option to sync the calander at the end.

M5Ivan said:
If you open your gmail app and add your google account again, it will give you the option to sync the calander at the end.
Click to expand...
Click to collapse
Works... Thanks!

M5Ivan said:
If you open your gmail app and add your google account again, it will give you the option to sync the calander at the end.
Click to expand...
Click to collapse
I cannot thank you enough! This is one of the biggest things I was looking to get resolved, and what a straightforward solution! I've modded my DX and feel totally comfortable working with it and CWR, but I'm really struggling with the NC and this is a win for me as I make small steps in my understanding. Thanks again

I installed Calengoo, which I have also used on my iPod Touch to sync with Google Calendar seamlessly

M5Ivan said:
If you open your gmail app and add your google account again, it will give you the option to sync the calander at the end.
Click to expand...
Click to collapse
Wohooo! Thanks!!! Amazing!

Keep in mind that to KEEP it synced, you'll need to use Synker or some other similar application. It won't sync automatically. There's a few threads with people saying they've managed to make it work one way or another, but I've never managed it myself.

khaytsus said:
Keep in mind that to KEEP it synced, you'll need to use Synker or some other similar application. It won't sync automatically. There's a few threads with people saying they've managed to make it work one way or another, but I've never managed it myself.
Click to expand...
Click to collapse
Mine is actually appearing to sync automatically!
I'll look into Synker though - sounds useful. Thanks for the tip!

bengt_a said:
Mine is actually appearing to sync automatically!
I'll look into Synker though - sounds useful. Thanks for the tip!
Click to expand...
Click to collapse
So you add an event on the web side and it syncs automatically to the NC? Damnit, why can't I get this to work.... You're using stock B&N rom with auto nooter or other rooting process, right?

bengt_a said:
Mine is actually appearing to sync automatically!
I'll look into Synker though - sounds useful. Thanks for the tip!
Click to expand...
Click to collapse
khaytsus said:
So you add an event on the web side and it syncs automatically to the NC? Damnit, why can't I get this to work.... You're using stock B&N rom with auto nooter or other rooting process, right?
Click to expand...
Click to collapse
Correct. I had to double check this today, and yes, it works! I add something on my computer (using a web browser) into Google Calendar, and almost immediately it shows up in the calendars of my Nook Color and Nexus One.
I'm using the stock ROM (1.1.0) with auto nooter (3.0.0). I followed the instructions above to re-add the Gmail account, and automagically the calendar started auto-syncing! (I have Touch Calendar, but also Jorte and Calendar Pad installed, but I don't think that has anything to do with it?)
I hope you will get yours to work too, and I'll be happy to answer any more questions you have.

[Q] Problems with Chrome

Hey guys, I have a couple of problems with chrome on One that you might be able to help with.
Before I go into that, does anyone know how to transfer my bookmarks from chrome (google) to the stock Android browser?
Chrome problems. Firstly, sometimes when browsing forums, some of the posts come in normal text and some in tiny! That is very frustrating, could it be a bug? Secondly, when I touch the address bar, sometimes it selects all of it (which allows me to go directly into searching something on Google and is awesome) but other times it doesn't, which is annoying. Can this be remedied?

Hulabaloo said:
Hey guys, I have a couple of problems with chrome on One that you might be able to help with.
Before I go into that, does anyone know how to transfer my bookmarks from chrome (google) to the stock Android browser?
Chrome problems. Firstly, sometimes when browsing forums, some of the posts come in normal text and some in tiny! That is very frustrating, could it be a bug? Secondly, when I touch the address bar, sometimes it selects all of it (which allows me to go directly into searching something on Google and is awesome) but other times it doesn't, which is annoying. Can this be remedied?
Click to expand...
Click to collapse
Through the HTC sync app there should be a setting to transfer your bookmarks from the desktop but I think the only way to transfer bookmarks on the device is copy/paste them from chromes internal folder over to the stock browsers internal folder. It's worked for me on past devices so hopefully they didn't change it and a quick search should give you the directories for both.
The forum text size is usually due to settings on that forum, it'll happen in almost any lightweight browser.
The address bar highlight always works for me unless I touch where there isn't text or move my finger during a long press, maybe reinstall chrome to make sure it's the latest version without any bugs?

Thank you for the comprehensive and helpful reply! Do you know a way to automatically sync my bookmarks on the computer (chrome) to the One stock browser? You know, for those 'I'll bookmark to read it later' moments

If you go into Chrome settings on the phone, then click your Google account and just turn everything on.

BenPope said:
If you go into Chrome settings on the phone, then click your Google account and just turn everything on.
Click to expand...
Click to collapse
Thanks for the reply, but I'm looking to sync my bookmarks at home (Chrome on the laptop) to the HTC One stock browser. Any idea how that could be done guys?

Hulabaloo said:
Thanks for the reply, but I'm looking to sync my bookmarks at home (Chrome on the laptop) to the HTC One stock browser. Any idea how that could be done guys?
Click to expand...
Click to collapse
Oh, sorry. Umm... I never tried! If you're signed into Google with Chrome (desktop) is it not in the list of bookmarks somewhere?

[Q] Email failure after disabling magazine

Month old note 3.
Disabled magazine and now get email message "unfortunately, email has stopped" I see from threads elsewhere that this is the issue.
I DO NOT WANT magazine. Is there someway to eliminate all the junk on this phone without killing the apps that work. I thought my Atrix was bad but it isn't nearly as crammed as this phone. I have 26 apps turned off, and some more that wont give me the option. I use this device for work, not play, and only want the apps I need.
Samsung please fix!!! Give us an option to unload all the crap with the next update. You are killing a really nice phone.
Anyone have a work around??????
THX

chris.nye said:
Month old note 3.
Disabled magazine and now get email message "unfortunately, email has stopped" I see from threads elsewhere that this is the issue.
I DO NOT WANT magazine. Is there someway to eliminate all the junk on this phone without killing the apps that work. I thought my Atrix was bad but it isn't nearly as crammed as this phone. I have 26 apps turned off, and some more that wont give me the option. I use this device for work, not play, and only want the apps I need.
Samsung please fix!!! Give us an option to unload all the crap with the next update. You are killing a really nice phone.
Anyone have a work around??????
THX
Click to expand...
Click to collapse
What email service are you trying to use? If it's hotmail or yahoo, use the Outlook, or yahoomail app instead of stock email app. Gmail works fine with magazine crap removed.

440bro said:
What email service are you trying to use? If it's hotmail or yahoo, use the Outlook, or yahoomail app instead of stock email app. Gmail works fine with magazine crap removed.
Click to expand...
Click to collapse
Thanks I switched to the gmail and yahoo apps and for those accounts. Need to find a suitable outlook replacement. The corporate sync that came with phone still crashes and burns.
Thanks and Peace!

I have that also... I froze Magazine with TiBU. When I get the email crash, it will often open the 2nd or 3rd time.

I am using gmail it`s work fine for me after disabling magazine

Radimus said:
I have that also... I froze Magazine with TiBU. When I get the email crash, it will often open the 2nd or 3rd time.
Click to expand...
Click to collapse
Mine also opens on the 2nd or 3rd try but it is too much of pain. I haven't had time to try another outlook app yet (don't know which is a good one).I hope they fix it soon, my wife needs a new phone for work too, and if this isn't resolved we wont get a Samsung.

chris.nye said:
Mine also opens on the 2nd or 3rd try but it is too much of pain. I haven't had time to try another outlook app yet (don't know which is a good one).I hope they fix it soon, my wife needs a new phone for work too, and if this isn't resolved we wont get a Samsung.
Click to expand...
Click to collapse
Have you tried flashing a gapps package? or just replacing the email.apk with a google version?

Radimus said:
Have you tried flashing a gapps package? or just replacing the email.apk with a google version?
Click to expand...
Click to collapse
No haven't tried anything for outlook yet. The only mail account I have to move is the one on a corporate exchange server. Need to make sure what ever I substitute is secure (as well as can be expected that is). Nothing cloud based.

chris.nye said:
No haven't tried anything for outlook yet. The only mail account I have to move is the one on a corporate exchange server. Need to make sure what ever I substitute is secure (as well as can be expected that is). Nothing cloud based.
Click to expand...
Click to collapse
Try this: you can PW protect the app and or leave out the PW.
https://play.google.com/store/apps/details?id=com.morrison.applocklite&hl=en
https://play.google.com/store/apps/details?id=com.dotcreation.outlookmobileaccesslite&hl=en

AT&T address book!

Does anyone else have the issue of "people" opening slowly? Do you access contacts in another way?
Sorry if this has been asked, been searching...
finally on Kitkat 4.4.2 from 4.2 (AT&T XT1058)
For contacts/people, it's the AT&T contacts app, but every time you open it, it takes like 10 seconds to open, not like "contacts" was
If I go through the dialer, it's quicker, but you have to then go to all contacts
Is there a "contacts" app on the phone like I'm used to? I have Nova launcher, so if it's a system "activity", I can make a shortcut for it, been looking
Thanks much!

M973 said:
Sorry if this has been asked, been searching...
finally on Kitkat 4.4.2 from 4.2 (AT&T XT1058)
For contacts/people, it's the AT&T contacts app, but every time you open it, it takes like 10 seconds to open, not like "contacts" was
If I go through the dialer, it's quicker, but you have to then go to all contacts
Is there a "contacts" app on the phone like I'm used to? I have Nova launcher, so if it's a system "activity", I can make a shortcut for it, been looking
Thanks much!
Click to expand...
Click to collapse
people app might be what you are looking for

jayboyyyy said:
people app might be what you are looking for
Click to expand...
Click to collapse
Thanks, I tried that, but it also opened the AT&T address book
Edit: just tried again, it's the people app that opens AT&T address book on the phone
Anyone with AT&T have this problem?
Thanks

Honestly I find the At&t address book extremely outdated and annoying. it surprises me they even offer it on Android devices...
I simply froze the Address Book through Titanium backup and am done with that nonsense!

Thanks. I also would gladly freeze the app, but wondering what you use for your Google contacts?
Sent from my XT1058 using xda app-developers app

M973 said:
Thanks. I also would gladly freeze the app, but wondering what you use for your Google contacts?
Sent from my XT1058 using xda app-developers app
Click to expand...
Click to collapse
I used TiBu to uninstall the ATT address book (need root). You should be able to freeze it. Google contacts works normally now.

JJHunterx said:
I used TiBu to uninstall the ATT address book (need root). You should be able to freeze it. Google contacts works normally now.
Click to expand...
Click to collapse
Thanks, I have root, and i have Titanium backup pro, I can and do freeze apps.
The app is "people" that opens AT&T address book, Is "people" the app you froze? And what did you click on for an address book then?
Thanks

M973 said:
Thanks, I have root, and i have Titanium backup pro, I can and do freeze apps.
The app is "people" that opens AT&T address book, Is "people" the app you froze? And what did you click on for an address book then?
Thanks
Click to expand...
Click to collapse
Since I uninstalled it, I don't remember what it was called exactly. I remember it being obvious what it was called in TiBu. I just use Google contacts. Same icon that has always been on the home screen.

JJHunterx said:
Since I uninstalled it, I don't remember what it was called exactly. I remember it being obvious what it was called in TiBu. I just use Google contacts. Same icon that has always been on the home screen.
Click to expand...
Click to collapse
Thanks, I couldn't find why that launches AT&T address book, and i couldn't find a shortcut to "contacts" in any system activities. I'll try it. Are you on 4.4.2?

M973 said:
Thanks, I couldn't find why that launches AT&T address book, and i couldn't find a shortcut to "contacts" in any system activities. I'll try it. Are you on 4.4.2?
Click to expand...
Click to collapse
I looked in System/Apps and couldn't find it either. Not sure where exactly it resides, but it only launches when the Contacts app is launched. And yes, I have 4.4.2. The same method worked in 4.4 as well.

JJHunterx said:
I looked in System/Apps and couldn't find it either. Not sure where exactly it resides, but it only launches when the Contacts app is launched. And yes, I have 4.4.2. The same method worked in 4.4 as well.
Click to expand...
Click to collapse
Thanks. Will try it
Thanks! That did it, interesting, that now hitting the same icon just opens Google contacts I guess it was "bundled" into one action.