Merge chat historie due number change - General Questions and Answers

Hi there,
I want to merge some chat history from contacts, which has changed their mobile numbers.
In the internet I found a solution with editing the SQLite Database (search and replace old and new number), which almost works really good for me.
But on one contact I've always a broken database error after activating WhatsApp with the new database.
I think here it is a little bit more compicated, since there are more tables affected (messages, media_streaming_sidecar, messages_links, messages_quotes and frequents).
The first are no problem, but what about the table "frequents"?
Or is there already a tool, which can merge the chat histories?
Thanks for your help,
Shadow128

You can clear the 'frequents' table, it's just your most used contacts.

Related

Contacts "File AS field"

I used to modify my Contacts "File As" field (First Name First) from my outlook in my Pc.. So,
Is there any program that let me change the "File As" filed from the pocket pc itself
thanks in advance
See bottom of this page:
http://discussion.brighthand.com/showthread.php?s=&threadid=79834
V
Dear Vijay,
Can we file two mobile nos for a single contact? assume that all other fields viz home1.2, Work1.2 etc are already occupied
hdubli - if all available number fields are full, then not easily. If you need that many telephone numbers, you could write a custom plugin or app that would store a string of telephone numbers in a text string with a seperator, eg:
+44 7870 XXX | +359 12345 | +69 546
etc. Then, save that text string in a relatively unused number or text field (eg Home Fax?) in Pocket Outlook, and have your custom plugin present an interface to choose which number from the string to dial/select, eg dial second number in the list. Your app would then parse out the second number from the list.
That would work and be relatively operating system consistent. But, it would have to be a custom written app.
V
Thanks for the reply,
Is it possible that I store the Phone nos with the sepertors as informed above and dial from contacts? You know any app else can u make such app...I am not good in coding as u are..
hdubli - I've never seen an app that can do it, and a custom plugin would have to be written to dial from contacts in this way.
I could possibly write it, but it would take time I don't have right now - do you really have that many phone numbers to store per contact?
If you've hit the limit (9 phone numbers per contact I think), try saving the contact twice, eg
Vijay (1) with 9 contact numbers
Vijay (2) with another 9 contact numbers = 18
It's not perfect, but it's easier for me :wink:
V
That's right...Just tell me can we add a custom field in the Outlook so that when we sync it adds that field in our device...
So this important 'FileAs' omission has been a problem for about 2.5 years, yet MS still haven't had the time to fix it? I am impressed
Yup, fileas is a pain in the ass, as with many of the problems with Windows Mobile and Smartphone: however, I guess we basically have to live with the problems. I lose count of how many bugs have never been fixed.
Oh, hdubli sorry for the slow response. As far as I know, we can't add custom Pocket Outlook fields.
V
It's so a shame that more 4 years have passed and there's no solution for this yet that I had to ressurrect this old, old thread.
Now in WM 6.1 there's still no default setting for 'File as' contacts. Plus I also have to complain about how WM phones display area codes.
It annoys me a lot because all these default settings seem to be made for U.S., but in most other places we choose to remember the first name and not the family name of our friends, and also 3-digit area codes don't apply.
This will fix them all at once... found it floating around
finally
works great!! (may need restart)
install
programs >> contact fix
set it as you like
done
BIG thanks (searched for a way to resolve this problem, weeks)
www.emil-studio.com
elerouxx said:
...
It annoys me a lot because all these default settings seem to be made for U.S., but in most other places we choose to remember the first name and not the family name of our friends, and also 3-digit area codes don't apply.
Click to expand...
Click to collapse
The |last name, first name| filing was probably used for business purposes. You would have many contacts that are not necessarily your friends and you would look them up by last name.
Would be nice to change it...

Unable to manually set name of merged contacts

Hi,
Sorry if this is the wrong forum, feel free to move my topic.
On my Android phone (Motorola Milestone) I have several apps that integrate into Contacts: Facebook, Twitter, LinkedIn, LastFM.
Android makes a good effort in merging the contacts automatically, or I can merge them manually. Some people compain about the automatic merge and I know about the bug reports, but for me it's good enough.
What bothers me however, is that I cannot set what type of contact has "priority". For example, I have a merged contact that consists of a Gmail contact (containing full name, address, phone, email), a Twitter contact (containing nickname, full name, profile pcture) and a Facebook contact (containg full name, phone, email, profile picture). In the Android contacts list this person may be shown as either with his full name or his nickname. It is completely random. I have not found a way to force this merged contact to be shown with full name. I just want an option to say "this person is called X, dammit".
Any ideas?
I'm sorry but... *bump* ?
same here.
It is driving me crazy.
Any solution?
Running Milestone 2.1
Yeah, would love to know this as well!
Thanks!
Sent from my T-Mobile G2 using XDA App
Would love to get a fix for this too!!
*bump*
I'm now running Froyo on my Milestone, but I still haven't found a way to do this.
Yet another *bump*
I'm going to try something incredibly dirty: install the .apk of the HTC contacts app, because this allows to set the visible name.
Is there no app on the market that allows easy editing of contacts?
Anyone tried any apps and if so then why not post the app name and whether it was useful or otherwise. That could help everyone else trying to solve their contacts cloud issues.
Sent with HTC Desire

[Q] Viber mixes up all names

After recovering viber + data with titanium backup every time I have updated my rom, it suddenly started to mix up the names in all the conversations a couple of months ago.
My fathers name is on me and my sisters conversation and my father is named some random name from my contact list that does not have viber, but still it shows an image of him.
Everytime I recover viber the names are different. I wonder what my dad is going to be named now?
This has been driving me crazy as I have sent a message to wrong person thinking I sent it to the right several times.
What to do? I don't want to remove viber completely with all it´s data because I have conversations that I want to keep.
Anyone?
boeing94 said:
After recovering viber + data with titanium backup every time I have updated my rom, it suddenly started to mix up the names in all the conversations a couple of months ago.
My fathers name is on me and my sisters conversation and my father is named some random name from my contact list that does not have viber, but still it shows an image of him.
Everytime I recover viber the names are different. I wonder what my dad is going to be named now?
This has been driving me crazy as I have sent a message to wrong person thinking I sent it to the right several times.
What to do? I don't want to remove viber completely with all it´s data because I have conversations that I want to keep.
Click to expand...
Click to collapse
This happens because Viber keeps Android contact IDs in its database and the contact IDs change when you update your ROM, wipe your contacts and then set up your contacts again (e.g. by syncing to Google)
If you know SQL then you can fix the data by hand - I had the same problem.
Install sqlite3 on your computer (it comes with Mac OS X), then pull the Viber databases in /data/data/com.viber.voip/databases and the Android contacts databases in /data/data/com.android.providers.contacts/databases onto your computer.
Look in the contacts table in /data/data/com.android.providers.contacts/databases/contacts2.db to find the new IDs of the contacts who you use Viber to send messages to. Then look in the participants table in /data/data/com.viber.voip/databases/viber_messages to find out the OLD contact IDs that viber is using. Then update viber_messages and participants, for example I needed to change old contact ID 1364 to new contact ID 683 and old contact ID 1440 to new contact ID 1666 and I used these statements:
Code:
update messages set person = 683 where person = 1364;
update messages set person = 1666 where person = 1440;
update participants set contact_name = display_name, contact_id = 683 where contact_id = 1364;
update participants set contact_name = display_name, contact_id = 1666 where contact_id = 1440;
When you're done push the Viber messages database back to your phone. Use these commands (change 10065 to the user ID for Viber on your phone):
Code:
adb shell 'rm /data/data/com.viber.voip/databases/viber_messages*'
adb push viber_messages /data/data/com.viber.voip/databases/
adb shell chmod 660 /data/data/com.viber.voip/databases/viber_messages*
adb shell chown 10065 /data/data/com.viber.voip/databases/viber_messages*
adb shell chgrp 10065 /data/data/com.viber.voip/databases/viber_messages*
Viber is crap program
caused me many problems in the past. some contacts names doesnt show up!!
Hi everyone,
This is an official member of the Viber R&D Team. I'm here to provide direct support.
About the Titanium backup issue - please note that Titanium is a third-party application that does not officially link to Viber, and so we (Viber) naturally cannot guarantee that it will smoothly work with Viber's features.
You might want to contact Titanium developers for more information and assistance
@The Prince1 -
The source of this issue could greatly vary. Please read this short page in our HelpDesk, outlining some possible workarounds that will help reboot synchronization of the contact list: http://bit.ly/rRtPqk
(The instructions refer to iPhone, but are relevant to all phones nevertheless).
Viber Team said:
Hi everyone,
This is an official member of the Viber R&D Team. I'm here to provide direct support.
About the Titanium backup issue - please note that Titanium is a third-party application that does not officially link to Viber, and so we (Viber) naturally cannot guarantee that it will smoothly work with Viber's features.
You might want to contact Titanium developers for more information and assistance
@The Prince1 -
The source of this issue could greatly vary. Please read this short page in our HelpDesk, outlining some possible workarounds that will help reboot synchronization of the contact list: http://bit.ly/rRtPqk
(The instructions refer to iPhone, but are relevant to all phones nevertheless).
Click to expand...
Click to collapse
Thanks for your answer! I really appreciate that Viber team are answering questions out on the forums cause this is not the first time I see you around. I can really notice a presence of you guys.
I will continue using Viber despite my problems(that I do not blame you for, after all Titanium backup is a third-party application) with it.
On topic: I will look further into this, probably using SQL.
It's our pleasure to help!
If you have any more questions/suggestions for us in the future, please don't hesitate to contact me again
Viber Team said:
Hi everyone,
About the Titanium backup issue - please note that Titanium is a third-party application that does not officially link to Viber, and so we (Viber) naturally cannot guarantee that it will smoothly work with Viber's features.
You might want to contact Titanium developers for more information and assistance
Click to expand...
Click to collapse
All what TB does is to backup the data folder "as it is", it has nothing to do with Viber or know how viber works, and nobody should contact TB team because the restore of Viber app doesn't work, mainly because the issue here is Viber itself. also because from the 100's of apps I backup with TB, only Viber suffer from this issue.
what frankoid described is the real issue, so the solution should be that Viber finds a different way of connecting its contacts with the Android Contacts.
anyway, thanks for the response.
@mcbyte_it -
You are right - technologically, it is not an impossible task to implement the options you mentioned into our app. However, please bear in mind that you are not the only user who requests features from us among our millions of users worldwide.
Aside from that, we also have other projects running in our company, like Viber on whole new platforms, for example.
All of the above doesn't mean we neglect our users' requests. We invite you to enter our Feature Request page and post your suggestion there, or join an existing similar suggestion. The more people join on a request, the faster it will become reality
You can find it here: http://helpme.viber.com/index.php/Knowledgebase/Article/View/43/9/have-an-idea-for-a-new-feature
I may have solved this problem..
I backed up my contacts using titanium backup.. But all of my contacts are synced in Google. Then, I restored it in titanium backup, contacts are not appearing.. Login to Google contacts synced then when I accessed Viber. Names are not mixed up!!
Anyway, Viber should have put an export and import function. I hope this will be implemented on the future
Sent from my GT-I9300 using Tapatalk 2
I have found an easier way of doing this than going thru this finding and updating.
I had the same issue, I deleted the vibers copy of contacts stored in this db /data/data/com.viber.voip/databases/viber_data
Once this is deleted, inside viber > contacts, all contacts are gone, now press menu and select update contacts.
All contacts are back and mapped correctly to conversations.
ashokjp said:
I have found an easier way of doing this than going thru this finding and updating.
I had the same issue, I deleted the vibers copy of contacts stored in this db /data/data/com.viber.voip/databases/viber_data
Once this is deleted, inside viber > contacts, all contacts are gone, now press menu and select update contacts.
All contacts are back and mapped correctly to conversations.
Click to expand...
Click to collapse
Great. This is handy, only thing that I hate is I need to root my phone just to restore my viber messages
Sent from my LT29i using Tapatalk 2
Well this buy happens only for root users and so the solution requiring root would be normal.
I mean titanium backup and restore of data directly, is possible only for root users, so this bug arises and you can fix this easily by deleting that DB and refreshing contacts
ashokjp said:
I have found an easier way of doing this than going thru this finding and updating.
I had the same issue, I deleted the vibers copy of contacts stored in this db /data/data/com.viber.voip/databases/viber_data
Once this is deleted, inside viber > contacts, all contacts are gone, now press menu and select update contacts.
All contacts are back and mapped correctly to conversations.
Click to expand...
Click to collapse
I don't know why but it doesn't work for me. I'm able to see only one contact and no names in messages that I restored from viber_messages.
boeing94 said:
After recovering viber + data with titanium backup every time I have updated my rom, it suddenly started to mix up the names in all the conversations a couple of months ago.
My fathers name is on me and my sisters conversation and my father is named some random name from my contact list that does not have viber, but still it shows an image of him.
Everytime I recover viber the names are different. I wonder what my dad is going to be named now?
This has been driving me crazy as I have sent a message to wrong person thinking I sent it to the right several times.
What to do? I don't want to remove viber completely with all it´s data because I have conversations that I want to keep.
Click to expand...
Click to collapse
Just clear app data, set up your number on viber again,and all contacts should show up with their actual name.
ashokjp said:
I have found an easier way of doing this than going thru this finding and updating.
I had the same issue, I deleted the vibers copy of contacts stored in this db /data/data/com.viber.voip/databases/viber_data
Once this is deleted, inside viber > contacts, all contacts are gone, now press menu and select update contacts.
All contacts are back and mapped correctly to conversations.
Click to expand...
Click to collapse
First of thanks (again!)
I can confirm this still works, worked for me anyways!
Only difference is before I got to press 'update contatcs'.... Viber updated them automatically on launch and problem solved
My problem was wrong contacts for existing messages, I do as many others use TB to backup app+data.
Cheers!
nerdo said:
First of thanks (again!)
I can confirm this still works, worked for me anyways!
Only difference is before I got to press 'update contatcs'.... Viber updated them automatically on launch and problem solved
My problem was wrong contacts for existing messages, I do as many others use TB to backup app+data.
Cheers!
Click to expand...
Click to collapse
There is a-lot easier way to fix this problem.
Open People app (the phone's contact manager) and edit broken contact:
1- Delete end number of mobile number and save the contact.
2- Open Viber then hit back.
3- Again edit broken contact and add deleted number at end of mobile number.
4- Open Viber you'll see broken contact-thread is fixed
This will work for non-root users too.
Hi,
We are excited and proud to announce that we have just released a major new update to our mobile application: Viber 4.0!
What's new in the new version?
- Choose from over 1,000 stickers in the brand new Sticker Market. The Sticker Market features endless possibilities for brightening up your conversations. Download themed sticker packages and enjoy the party!
- Push-to-talk voice messaging. Send messages instantly with the new push-to-talk feature that streams your voice message as you record it.
- (Android only) Supported tablet compatibility. Viber is now fully compatible with your tablet device(s). Enjoy quality conversations, wherever is most comfortable for you!
- Group capacity increased to 100 members. Whether you want to share with your nearest and dearest or just send a message to a large group of people, Viber groups let you get in touch with even more people, all in one place.
- Beautiful conversation backgrounds in the new background gallery. Choose elegant backgrounds to decorate your conversations from our new collection, designed by our very own Viber artists.
- Forward messages to your groups. Sharing is caring. The popular feature for contacts is now also available for all groups!
As usual, we will be right here to receive your thoughts and feedback. If anyone encounters any problems or would like to share their experiences from our new update, please don't hesitate to contact us.
Best regards,
the Viber Team.
nDman.sk said:
There is a-lot easier way to fix this problem.
Open People app (the phone's contact manager) and edit broken contact:
1- Delete end number of mobile number and save the contact.
2- Open Viber then hit back.
3- Again edit broken contact and add deleted number at end of mobile number.
4- Open Viber you'll see broken contact-thread is fixed
This will work for non-root users too.
Click to expand...
Click to collapse
Thanks, this worked perfectly for me :good:
Sorry for digging up and old thread but I can confirm that this is still and issue with the current versions of Viber on at least 3 separate phones that I've used.
I just fixed some rogue contact lists the other night - for some reason using Viber it merges different contacts together.

[Q] Where is the Contacts Database Boost HTC ONE SV USA

Need help locating the Contacts database on my phone with all of the contact information.
On my phone it is actually called "People".
I want to use SQLite to globally modify Add, Edit and replace data. I sure hope this is doable. When I imported my contacts from Outlook I discovered how unconventional the android list format is. The table structure is modified for each record it seems like a custom record for each contact.
Not a problem if I can find it.
Anyway Im new to Android any help find the path to the database would be greatly appreciated
Regards
Robert

WhatsApp - Merge chat history from two contacts

Hi there,
I've several contacts, who changed their phone number and now I've two chat historys.
So I want to merge both historys to the new number.
I know from the past there is a possibility to edit the database with SQLiteBrowser, but I can't remember the commands.
Or maybe there is a simple tool, which can automatically change all related stuff from old number to new number?
Hope that maybe someone can help me
Thanks and best regards,
Shadow128

Categories

Resources