Database Info

Having access the files where my contacts are stored in android 2.1

Hi everyone, I want to backup my contacts and the native 2.1 contact manager has a function to export my countacts but the .vcf don't actually keep the category structure that I so painstakingly setup or the contact photos that I gathered. In the iPhone, it is a simple question of getting two sqlite files that have the contacts and images in them and substituting it in your next device. Would anyone be able to tell where I could find this files??
I'm running a root t-mobile vibrant /w bionix.
Also, please let me know if you know something more functional the stock contact manager app: ie. with proper import/export and and sync functions that retains categories and contact images.

i can't post links, to find your sqlite db files try googling:
how to poke around the sqlite3 databases
And for a better contact manager google:
komodo contacts

Generally this is done via gmail. Add the pics etc to your contacts and place them in groups via gmail then no matter what phone you use these will always be there.
You can them export them as a backup to your pc etc

Method to copy Facebook contact information directly into Google Contacts

Hi everyone,
I've been searching for an app to do this but I haven't found one. I might write up one soon but I'm too busy, so today I found a relatively simple way to do it manually. Basically, this gets Facebook contact information, including email and phone numbers, of all your friends and copies them to your Gmail contacts. There are quite a few steps, but this is really something you have to do once. When this is all said and done, your Google contacts will have all the necessary information, and you don't have to worry about rejoining all the contacts if you lose the data (by flashing a new ROM, for instance).
Things this will not do:
1. Grab contact photos. There might be a way around that, but I'm not sure.
2. Link social media, like statuses and such. This is all STATIC information.
3. This only works on Galaxy S phones (I think). Other phones might be able to follow the same general procedure if they're able to import ALL facebook contact into the phonebook.
This assumes that all of your contacts on your phone are synced to your primary Gmail account.
So, here's the procedure.
1. Create a backup of your Google contacts, save them to your Desktop. You can do this by going to Gmail -> contacts -> Actions -> Export.
2. To be safe, you can export your phone's contacts as well, in case something goes wrong. To do this: Contact -> Menu -> Import/Export -> Export to SD.
3. Import ALL of your Facebook friends into your contacts. To do this: Menu-> Get friends -> Check all of them, then press Save. This part can take awhile, so be patient.
4. Export all of your contacts to your SD card again. Contacts -> Menu -> Import/Export -> Export to SD. This includes ALL your contacts, existing and facebook contacts, but the important part is that the Facebook contact information is included. The file will be named 0000x.vcf, where x is some number, and it should be located under /sdcard/external_sd.
5. Transfer that .vcf file to your computer. You'll need a file manager like Astro, and you can email the file to yourself.
6. In google contacts, create a group called "Original Contacts", and add all of your current contacts to that group.
7. Also, create another group called "Facebook" (or whatever).
8. In google contacts, import your .vcf file, which was exported from your phone. To import: Contacts -> Actions -> Import. Check the option "Add all contacts to this group:" and pick the group "Facebook".
9. When that's done, go to "My Contacts" -> Actions -> Find and merge duplicates. Check to be sure that the right contacts are being merged, then press OK. All of your existing contacts that have associated Facebook information will be merged.
10. Go to your "Original" contacts group, and remove the "Facebook" contact label from all of them.
11. Go to the "Facebook" group, select all of them contacts, and delete them.
12. Ta da!!! All of your original contacts now have Facebook information right in Google contacts, and data portability is no longer an issue! All the contacts you didn't care about are also gone as well!
13. This step is optional. By doing this, you might find that you'll get contacts that have duplicate entries for phone numbers. To fix this, you can export the "Original" contacts group as a CSV file, open it up in Excel, and quickly remove all the duplicate phone number entries. This is actually a very quick process - it took me about 2 minutes. Save that file, then go into Google and delete ALL of your contacts. Then, import that CSV file you just edited. Now, you have all of your contacts but all the duplicate data entries have been removed.
14. Clean up: you can delete the Facebook group and the 'Original' contact group, as those were just to keep things organized.
Photos are probably not preserved. They weren't for me - other people might have different results based on whether they perform the optional step or not.
I hope this helps everyone!

[GUIDE]Sync local calendar with Google account[No root]

Hi guys!
Added many calendar entries and then realized that you have added it to the local calendar? Android syncs only the calendar which is connected with your Google Account. So if you want to transfer all entries from local calendar to the Google calendar, you have come to the right place
To achieve this, kindly follow these steps and you will be good to go:good: :-
1. Download this app on your phone - https://play.google.com/store/apps/details?id=com.idea.backup.smscontacts
2. Open it and go to Calendars Backup--->Backup
3. Chose the file name and start the backup.
4. Then transfer the backup file to your pc. It will be in /sdcard/SmsContactsBackup/calendars
5. Open up the backup file on your pc. I'd highly recommend you to use Notepad++ for this. You will see multiple <Calendar entries at the top of the file. Look for the entry which has this attribute:- account_type="LOCAL"
Note down the _id attribute for this <Calendar entry.
6. Now look for <Calendar entry which has name="[email protected]" attribute and note down the _id attribute. Here xyz is your gmail username.
7. Now open Find & Replace and replace this -
Code:
calendar_id="1"
with
Code:
calendar_id="2"
Here, 1 is the _id for LOCAL <Calendar entry and 2 is the id for your Google Calendar (in my case). It could be different for you. So basically whichever calendar entry is set as local, will be converted to the google calendar's entry so that it can be synced
8. Now transfer the modified file back to /sdcard/SmsContactsBackup/calendars
9. Now open Superbackup--->Calendars and click on Delete all calendars.
10. Then restore the modified backup and re-sync your phone with the google calendar. All your local entries will now appear as google calendar entries and will get synced properly to your account.
Enjoy
Regards,
abcdjdj

I have been looking for something like this for several days now. I haven't tried it yet but I will soon and I can't wait. Thank you for sharing.

probbiethe1 said:
I have been looking for something like this for several days now. I haven't tried it yet but I will soon and I can't wait. Thank you for sharing.
Click to expand...
Click to collapse
Glad to hear that at least someone found it useful.
Sent from my Xperia S using Tapatalk

Yeah this is very useful. I know most people only use the Google Calendar and don't ever worry about this but for the people that don't know the difference and then try to switch devices this is good to know. Great find!

Great thanks, that's exactly what I was searching for !!
You saved me 2hours of re-entering many bithdays and garbage-colection-days

Entries disappear when syncing.
Hello. I tried this one for my dad's Xperia S. All went well up until I tried to sync it with his google account. After it finishes syncing, all the calendar entries just disappear. Help please?

Hello, I tried this method and everything looks like it is working, when I restore the modified backup it says it is updating 601 entries to the calendar, which is about right - but I am still not seeing them on the calendar.

Do most phones not have a method of exporting local calendars which can then be imported to Google Calendars or other calendars?

Easier way to do it:
https://play.google.com/store/apps/details?id=com.applisto.copyevents.pro
This allows to periodically move events from one calendar to another and, when using it for the first time allows to specify which time frame has to be considered (into the past and into the future).
Copy: events copied from 1 calendar to the other.
Mirror: tracking changes
Move: original event is removed, only left in target calendar.
It is powerful, be careful to read explanations and features.
Xavi

I was unable to get this guide to work at all. However, another suggestion here worked well. The basic idea is to export an existing calendar as an ICS file and then import it to Google (or wherever) using a desktop computer web browser. The free program referenced in that post worked for me. I was able to export a single calendar as an ICS without issue. However, I couldn't use the suggested program to import a calendar; I had to use the Google Calendar website instead.
you can migrate the events you've already entered on the Phone's calendar (to which you've been adding events with the Samsung Calendar App) into Google Calendar for free using a tool such as Calendar Sync Trial. Open the app and go to "Export" to create an ics (iCal) file containing the phone's calendar events, then import that file into a Google Calendar using a browser, or the same app. You can get Calendar Sync Trial from https://play.google.com/store/apps/details?id=com.icalparse.free
Click to expand...
Click to collapse
BTW, this question was also asked at a StackExchange site: https://android.stackexchange.com/questions/85089/sync-local-calendar-entries-with-google/231000

[APP][FIX] Database file does not exist (Social Contact Photo Sync & CoSy)

This thread is is related to a temporary fix for the app SCPS (Social Contact Photo Sync) & CoSy where it is unable to read the Facebook app's database file
Root Required (This fix is for the root only method)
Q. Why does this happen?
Ans. I'm not sure. I checked the logs of CoSy and it turns out it is looking for the database file in 3 locations:
[
/data/user/0/com.facebook.katana/databases/contacts_db2
/data/data/com.facebook.katana/databases/contacts_db2
/data/user/0/com.facebook.katana/databases/contacts_db2
]
The highlighted path is the storage path of the database in my phone. Since, SCPS and CoSy both have ROOT access, they were still unable to access the file. That's why I'm not sure why this error occurs. I have emailed the Developer about this and hopefully this will be fixed soon (Not even sure if it is the SCPS's problem or my phone's (OnePlus3 running Android Oreo 8.0.0 OxygenOS- 5.0.3)).
THE FIX
You will need to ROOT.
Download the official Facebook, Messenger, ES File Explorer (you can download any other root file explorer too) and SCPS apps from the PlayStore. (CoSy isn't useful because it can't import from Messenger yet)
YOU CAN SKIP THIS STEP IF YOU HAVE BEEN USING FACEBOOK FOR A WHILE
Log in Facebook and go to your profile and open the list of your friends. Scroll down a few times so it starts caching the friends data. It can take a few minutes depending on your connection and the number of your friends (You don't need to scroll all the way through all your friends, a couple of times is enough. For example, I have about a 1000 friends on Facebook and my database size was about 6MB, so it took a few seconds to cache the list).
Log in to Messenger.
Open ES or your file explorer and give it root access.
Go to /data/data/com.facebook.katana/databases/ and look for contacts_db2 file.
If the folder does not exist, check for contacts_db2 in both the paths specified above.
Copy the contacts_db2 file and go /data/data/com.facebook.orca/databases (or wherever you found your apps data to be from the above given two paths) and overwrite the contacts_db2 file over there.
Open SCPS. and click on Facebook. Select "Setup facebook" and then select "Preferred app" as "Messenger App". Let the other settings be the default and click on OK.
Click on Facebook again. This time select "Enable network".
If "Enable network" is not visible, select "Reload the network".
Voila. It should be able to read all of your Facebook friends now.
Now, you can proceed and setup Auto-Sync for your contacts.

Hi! I stumbled on your post Googling for this same problem with CoSy, but I also think I've found a simpler fix that allows CoSy to be used.
The problem appears to be a permissions issue with the Facebook app's data store. I noticed that com.facebook.orca and com.facebook.katana folders have different permissions, with the former being a more permissive 0751 (rwxr-xr-x). I changed katana's permissions to match and away it goes!

Tardeaux said:
Hi! I stumbled on your post Googling for this same problem with CoSy, but I also think I've found a simpler fix that allows CoSy to be used.
The problem appears to be a permissions issue with the Facebook app's data store. I noticed that com.facebook.orca and com.facebook.katana folders have different permissions, with the former being a more permissive 0751 (rwxr-xr-x). I changed katana's permissions to match and away it goes!
Click to expand...
Click to collapse
Oh, that makes sense why it was not able read Facebook's DB, but read Messenger's. I never bothered to check the directories' permissions.

For me basic com.facebook.orca and com.facebook.katana folders have 700 and database folder inside them has 771. Sadly can't make SCPS to sync.
Edit: set com.facebook.katana to 751 recursive and SCPS sync fine. Ty

Have same problem but... there is no "databases" in Facebook directory. I don't have Facebook directory under "root/data/data/". Why?

Restoring Facebook Messenger access through /data/data files

Hello,
A while ago my phone got bricked and I had to wipe it, however I've managed to extract all the files from /data/data. However a google authenticator got lost in the process and I cannot access some accounts, notably Facebook Messenger.
Is it possible, to restore access to it using the aforementioned files? So far I've found some suspicous strings in "shared_prefs" folder, such as "USER_ID" and "auth_token".
And no, just replacing all the files in a fresh messenger doesn't work, the app crashes instantly.
If restoring Facebook access is possible instead of messenger, it will do just fine.

Update: Solved!
After running a simple recursive grep by string "auth_token" I found a folder with the messenger auth data.
All you need to do is move "app_light_prefs" and "shared_prefs" from the old data to the messenger's fresh installation in /data/data/com.facebook.orca (Root needed)
From there you can access account settings and disable 2FA.