Database Info

Android Email Client IMAP folder workaround

Issue:
Haven't found any solid threads addressing the issue. If you are like me, you sometimes would like to use the native android email client to do perform basic functions with your IMAP email account. The problem is, your IMAP handling of certain functions do not sync correctly with the IMAP server, say Gmail for example. When you delete or send emails, your client creates new folders, and they do not go where they're supposed to. Here is a workaround, or rather an appropriate fix (for those with no interest in installing k9 or Seven).
Requires:
Root and SQL editing. Any android based operating system.
Fix:
You need to edit some values in the database. If you look under /data/data/com.android.email/databases/EmailProvider.db and go to mailbox. Under there you have all the _id and display names for your Email accounts. For 'type' you have the following integer values
0 = INBOX
1 = Folder
2 = ? (I have none set to 2)
3 = Drafts
4 = Outbox
5 = Sent
6 = Trash
7 = ? (I have none set to 7)
8 = Search
So if you reassigned 'type' 3, 5, and 6 to correct folders (e.g. [Gmail]/Sent Mail set as 'type' 5, at the same time setting wrong Sent folder to 'type' 1 to be deleted later), it should handle it properly.
This is a similar solution to correcting IMAP issues in Thunderbird (configuration editor). I am posting this here because I have found no other real working solution to the problem, and Google has refused to fix it in their OS revisions (AFAIK up to 2.3). Perhaps a patch could be designed that adds "Set to Sent", "Set to Trash", "Set to Drafts", etc., that allows a user friendly adjustment in the native client.

Interesting post.
I'm running an HTC Inspire with a custom ROM and my settings are different, which leads me to suspect that the fix requires a bit more than you indicate.
The path and file name you mention are not on my machine. I would guess it might differ based on your Android version (Froyo/Gingerbread/Honeycomb) and/or for any vendor who customizes Android, such as HTC's Sense or Motorola's Blur.
Under the VirtuousUnity ROM (a Pyramid/Sense3 port) that file is located at:
/data/data/com.htc.android.mail/databases/mail.db
In my 'accounts' table, the data seems to be organized differently than yours. I show the three IMAP accounts with 70 (yes, seventy) fields for each defining the behavior of each account for things such as (encrypted) password, refresh frequency, notification settings, and so on.
Among those 70 fields is '_sentfolderId' field, where it shows a numeric value corresponding to the below structure in the 'mailboxs' table in that same DB.
So, let's take my first IMAP address as an example. In the 'accounts' table, the '_sentfolderID' field displays '5' as the folder to use. That would seemingly correspond to the below convention in the 'mailboxs' table. If all there was to it would be to change the '5' to '7', I'd say it's a walk through the park. But I think not.
Here's where things get interesting.
In the 'mailboxs' table, the structure is far more complex. In that table, I show a minimum of 11 settings (rows) for each ID. They appear thus:
1 - INBOX
2 - Trash
3 - Drafts
4 - Outbox
5 - Sent
6 - INBOX.Drafts
7 - INBOX.Sent
8 - INBOX.Trash
9 - INBOX.Junk
10 - INBOX.Sent Items
11 - INBOX.Spam
(I say 'minimum' because one of my IMAP accounts used for business has additional folders added for organizational reasons, so I won't include them here in an effort to not confuse matters.)
However, I think there's more to it. For each record (listed above) there are 20 fields in my db corresponding thus:
_id (i.e.: 'INBOX', 'Trash', 'Drafts', etc.)
_undecodename
_decodename
_shortname
_serverfolder
_defaultfolder
_account
_movegroup
_showsender
_lastuid
_existsize
_noselect
_haschild
_serverid
_parentid
_displayname
_type
_synckey
_enablesync
_default_sync
For the first five records (a/k/a, '_id'), I show a numeric value in the '_defaultfolder' field thus:
2147483647
2147483646
2147483644
2147483643
2147483645
These '_defaultfolder' values are the same for each of my accounts - in other words, the set of 5 values appear for each of my accounts. There are also flags in other fields, but I think that the key is somewhere in the above settings. I have to believe there's a simple fix to this (like just changing the folder id settings to add or move the numeric value above to the 'INBOX.Sent' or 'INBOX.SentItems' field) but I'd like to hear from someone else before I take the plunge.
Perhaps I'll do a nandroid backup and experiment a bit, but if anyone else has some input, I'd really appreciate it because this is a problem that affects us all and is, in my view, inexcusable for Google or any phone vendor to not remedy.
Anyone else have thoughts on this?

Does this work?
I am on 2.3.5 using the default mail app with IMAP and GMAIL. I want to reassign the ANDROID SENT MAIL so it goes to the correct IMAP FOLDER. does your idea work?

I noted that on my Mail database, Junk mail seemed to be assigned to ID 7. I had nothing assigned to 2.
I have also noticed, that the edits to the database must be made while the app is still open or it will crash when you try and start it.
This did, however, work for me.

Do I access the db with a terminal app? If yes, what command(s) do I use?

mjmacky says:
If you look under /data/data/com.android.email/databases/EmailProvider.db and go to mailbox.
Click to expand...
Click to collapse
On a motorola defy running 2.3.4 I do have the EmailProvider.db databases on the path you indicated, mjmacky. But I can`t locate the `mailbox` that you recommend going to.
Where in the EmailProvider.db is it located exactly?
I pulled the EmailProvider.db out of android and into my PC (via adb) and I`m now comfortably browsing it with an sqlite manager (The `sqlite manager` firefox plugin) but I simply can`t find the `mailbox` nor any indication of strings such as `INBOX` or `sent` or `drafts` etc.
Please be more specific as to the where I can find these values.
I must say solving this issue is a big deal for me, as there`s no other way I know of being able to store emails sent via android outside of it (other then on gmail perhaps) K9 does not solve my problem as it only enables to store sent messages in either SENT folder or SENT ITEMS where as on my IMAP server (Which is on hostgator) the folder is named INBOX.sent items. (Neither does `enhanced mail` solve this problem for me.)
BillTheCat , I have followed your various posts concerning this issue and share your interest in finding a solution.

I must thank you heartily mjmacky, as this post of yours helped me solve this problem.
(Thank you,BillTheCat, as well, as the info in your various posts contributed to my understanding of my problem.)
I found the `mailbox` you indicated, mjmacky, but not in the copy of the EmailProvider.db I pulled with adb out of android into the PC, but instead with the `sqlite editor` application for android. Being prompted by sqlite editor to choose which application`s databases I would like to browse I pointed to the native Android email app. Four databases appeared, one of which is the EmailProvider.db, having entered it, `mailbox` was now visible and inside of it the folder list you specified. In my case it was id #9 that had to be edited. it was assigned to `sent` whereas on my server the right name is INBOX.Sent Items. Having edited this value inside the sqlite explorer, I have sent a test email from the android native email application and indeed, instead of saving the sent message only to the `sent` folder as it did before (a folder that does not exist on my server) it sent it also to the INBOX.Sent Items folder, a folder that does exist on my server. Having checked my IMAP account in Outlook, I can finally see messages sent by Android.
I have no words enough to thank you, mjmacky.

Glad to hear you got it sorted out. I had no luck fixing mine, but hopefully the much anticipated ICS release for Inspire will fix it.
Just as a correction, Enhanced Email WILL save sent messages to the server, you just need to tell it which folder to use.
Sent from my Inspire 4G using Tapatalk 2

For some reason I could not make enhanced mail do that, I simply couldn`t manage to change the Sent folder to the desired name, probably missed something.

In EE open the email account you want to change (the message list) then: menu - folders - press/hold the folder you want as the target - select the popup for 'set as sent folder'.
Sent from my Inspire 4G using Tapatalk 2

Thanks, now Enhanced Email works for me too. I have a problem, though, in both native email app and Enhanced Email - same behavior - message is placed now in the correct Sent folder and is synced to server properly but if it contains an Attachment - the attachments itself will not be synced. The Attachment IS being sent and is being received by the recipient but it is not stored in the INBOX.Sent Items, on the server, while with the message that contained it does get synced. As consequence the message appears without it`s attachment in all clients using this IMAP - including in the sent folder of the android client that actually sent it (Be it EE or native Android Email)
Any ideas, please?

This manner doesn't work on Xperia Mini Pro
Dear mjmacky
I've tried your manner but it did work after I changed the type to corrospond number.
But when I synchronized my imap email with the native email app, the type automatically
change back to the wrong numeric. Is there any other setting I should do? Would kindly
have your advise? Your help will be highly appreciated by me. Thank you.
Stanley

I abandoned this thread after I made the post because it didn't get any replies for awhile and I thought they would have fixed this by now. Personally, I have completely switched over to using the Gmail apps since their functionality has vastly improved over some of the native email apps. With that in mind, if you're still trying to tackle your issue, there is something to keep in mind:
My procedure could be device specific, meaning you might have to do some exploring to find the correct db file. I haven't really messed with this in 2 years, I just stumbled back and am surprised to see a post as late as December 2012.
Sent from my Nexus 10 using xda app-developers app

Thanks for the workaround, it works perfectly on nexus4

liahigh said:
Dear mjmacky
I've tried your manner but it did work after I changed the type to corrospond number.
But when I synchronized my imap email with the native email app, the type automatically
change back to the wrong numeric. Is there any other setting I should do? Would kindly
have your advise? Your help will be highly appreciated by me. Thank you.
Stanley
Click to expand...
Click to collapse
I have a Nexus 4, and I am experiencing the same problem: was able to change values, but they revert back as soon as I launch the Email app.

Concept still works and is still necessary
Hi There,
Ran into the same problem with HTC Mail on 4.3 (Viper 3.1.3 One S) and the recipe still works as in the description of BillTheCat.
I got it to work by editing /data/data/com.htc.android.mail/databases/mail.db
Summarising:
if the account with id 3 is misbehaving, find all rows in the mailboxs table with "_account" 3. You'll have the usual INBOX Trash etc. folders, but you'll see 2 rows representing a Sent folder, likely one of which INBOX.Sent. Note the id (first column) for this folder and go back to the accounts table, and change the fields "_sentfolder" = INBOX.Sent and "_sentfolderId" = <id you noted>. Commit change to database and done.
Editing was easy with dSQLiteManager (free on GPlay), because I have more accounts I first dumped the two tables to csv and opened in excel on my computer, to have a better overview which mailboxes to change.
Unbelievable that this is still necessary, but it worked like a charm
@ikeny: it may be necessary to make sure that the mail app is not running when you commit your change to the database with your editor (I just killed it by long press back or force close from the app manager)
Cheers and thanks to OP and BillTheCat

Props to powerpenguin if he's actually found a solution, but I moved on to Aquamail a long time ago. Though it irked me to spend money for a function that my phone is supposed to have natively, I find the feature set of Aquamail and it's robust ease of use (like a consolidated inbox for all email accounts) to be well worth it.
Sent from my HTC One using Tapatalk

Just an information for other people that encouter the same behaviour:
My "Drafts" folder does not sync. All other folders do. I checked the database. The "type" of my drafts folder is correctly set to "3".
Then I checked the AOSP source of the mail app. I found some comments that mentioned the drafts folder will not ever be synced in the mail app beginning with mail app version 2.
Line 351 and 1051 of: ImapService.java
Can anyone confirm the behaviour?
Sadly, I currently do not have the time to re-implement syncing of drafts.
If anybody has the time to look at this (might be really easy but I do not know whether editing the mentioned lines of code are enough) I would be very grateful.

Don't know if this applies here, I guess it is, cause it's about the IMAP folders, but I also couldn't found any "official" thread for the KitKat Stock Email app, the one that is on the play store.
So, I was using the email app, I have one IMAP account, that I really almost don't use. I entered on my email account settings (inside the email app settings) in order to see if there was something related to configure the imap folders, and for a few seconds I saw some settings that I never saw before!! You can see the attachments. You can see on the shots, Data Usage and System Folders extra settings!!
I kept going back and forward, but not always I would see those settings again and if I do, it would be for a fraction of a second. Only for a few times would stay for 3 or 4 seconds...
When those settings would stay longer, I could enable/disable the checkboxes from the sync email, contacts and calendar (it's an imap account, so I don't understand why those settings were there) but the ones from system folders I couldn't modify (enter on those). I also think that those settings only appear to me if I have the sync frequency enabled on.
Does anyone ever encountered these options?!? Does this mean that they are hiding somewhere and can be enable somehow, like with the help of some xposed addon?!
This would be very good, cause we all need to change those system folders...
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
Sent from my Nexus 5

I can't answer your questions but I strongly recommend to use K-9 Mail instead of the stock Android E-Mail-app. K-9 Mail is open source und available in the Google Play Store and also via F-Droid. K-9 Mail works well with IMAP accounts.

[req] Working wifi PC sync application

Can anyone recommend a wifi sync app for the Galaxy Tab 10.1?
I'd basically like to set up a share on my PC which automatically syncs to the tab when I connect to my home wifi... I've tried a few in the market, but they all seem to have some or other issue.

Have you tried FolderSync Lite ?

I like TheRealSync for DropBox and FTP. It takes a bit more effort to setup, since you need to first sync your files to either DropBox or an FTP location, but then you can sync from anywhere, whether you are home or not. And depending on your home setup, you can probably setup an FTP server on your home PC and just share your content via FTP. Then you don't have to sync anything at home.

the_bone_collector said:
Have you tried FolderSync Lite ?
Click to expand...
Click to collapse
I'll have a look this evening... not sure.
SolusCado said:
I like TheRealSync for DropBox and FTP. It takes a bit more effort to setup, since you need to first sync your files to either DropBox or an FTP location, but then you can sync from anywhere, whether you are home or not. And depending on your home setup, you can probably setup an FTP server on your home PC and just share your content via FTP. Then you don't have to sync anything at home.
Click to expand...
Click to collapse
I can't a dropbox type service, as the files are large, +-16GB.... and data is expensive.
I'll look into the FTP option, just don't want the hassle of setting up another server (FTP) on my server.

xrapidx said:
I'll have a look this evening... not sure.
I can't a dropbox type service, as the files are large, +-16GB.... and data is expensive.
I'll look into the FTP option, just don't want the hassle of setting up another server (FTP) on my server.
Click to expand...
Click to collapse
I just have a folder on my FTP server setup to point to my various libraries (music, photos, etc.) and have different sync jobs configured for each library (some sync once/night, others every hour, etc.). You can also set it to only sync on WiFi so you don't accidentally use data from your plan. (I didn't set that at first and accidentally went about 16GB over my plan!)

SolusCado said:
I just have a folder on my FTP server setup to point to my various libraries (music, photos, etc.) and have different sync jobs configured for each library (some sync once/night, others every hour, etc.). You can also set it to only sync on WiFi so you don't accidentally use data from your plan. (I didn't set that at first and accidentally went about 16GB over my plan!)
Click to expand...
Click to collapse
Have you had any problems with larger files? (+-1GB) - thats where I run into problems with the various software I've tried, they either time out, or end up corrupt.

xrapidx said:
Have you had any problems with larger files? (+-1GB) - thats where I run into problems with the various software I've tried, they either time out, or end up corrupt.
Click to expand...
Click to collapse
Haven't tried yet. I'm actually working on setting up a sync job for recorded tv programs today though, so I'll report back once it's ready.

SolusCado said:
Haven't tried yet. I'm actually working on setting up a sync job for recorded tv programs today though, so I'll report back once it's ready.
Click to expand...
Click to collapse
That's exactly my intended purpose with the large files... I'll see if I can also give it a go this evening.

xrapidx said:
That's exactly my intended purpose with the large files... I'll see if I can also give it a go this evening.
Click to expand...
Click to collapse
I'm sure you've already found this as well, but I successfully synced a 2GB, hour long file yesterday. It worked flawlessly!

SolusCado said:
I'm sure you've already found this as well, but I successfully synced a 2GB, hour long file yesterday. It worked flawlessly!
Click to expand...
Click to collapse
May i know the step and way to setup such connection from my PC to tab? Thanks in advance.

nikes60 said:
May i know the step and way to setup such connection from my PC to tab? Thanks in advance.
Click to expand...
Click to collapse
Setup and FTP server on your PC or network
Configure the FTP server to connect to the folder on your PC you want to synchronize
Install the app on you phone or tablet
Setup a synchronization job that synchronizes the folder from your FTP server with a folder on your phone or tablet
Sync, and enjoy!

SolusCado said:
Setup and FTP server on your PC or network
Configure the FTP server to connect to the folder on your PC you want to synchronize
Install the app on you phone or tablet
Setup a synchronization job that synchronizes the folder from your FTP server with a folder on your phone or tablet
Sync, and enjoy!
Click to expand...
Click to collapse
recommended ftp server to try this with? and could you tell me a bit more about synchro jobs or a link to read about your method please? Its been a while since i've played with FTP.

My recomendation is if u dont want to mess with setting up ftp and all that stuff just get ES file explorer all u need is to be connected to the same LAN your computers on and have shared files very easy fast and effective.

junjlo said:
My recomendation is if u dont want to mess with setting up ftp and all that stuff just get ES file explorer all u need is to be connected to the same LAN your computers on and have shared files very easy fast and effective.
Click to expand...
Click to collapse
ES FileExplorer can also do FTP. I have local and FTP configured. And then with dyndns.org, couldn't be easier to connect home and get stuff i need.
And then I found this too:
Cheetah Sync
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
http://www.jrtstudio.com/CheetahSync
https://market.android.com/details?id=com.jrtstudio.SyncFolders&feature=search_result
^-- I actually paid for the app! Its awesome!
With some port forwarding it can also communicate out of the home network (but that could pose a security risk as its not been tested in that way.) There is currently a bug that is being worked on (Perform job in pre-set order) But once that is fixed it will be a great sync app! Developer said they will try to get that fixed for the next up coming update.
Its not 100% automatic two way like i'd like (ie windows live mesh), but it can be configured to send changes or receive changes. Anyway, I HIGHLY recommend it.
I have mine configured like this:
Job 1 - send "My Pictures" changes to desktop computer.
Job 2 - receive "My Pictures" changes from desktop computer
job 3 - send changes of "DCIM" to computer.
job 4 - receive changes of DCIM from computer.

[Q] Accounts and Sync Location D2G?

{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
Can someone please tell me where I can find this on the (rooted) stock gingerbread 2.3.3 for the Verizon D2G?
On every droid device I have owned these settings have been here (all HTC tho).
I want to make some sync setting changes but cannot find anything aside from the Background Data and Auto Sync boxes. The Actually accounts, both Goggle and other social media networks are missing.
Could this be due to me using the 4 corner press to bypass the activation call at the start?
Any help here would be greatly appreciated.

Blur has Settings → Accounts (My Accounts app). You can find the sync settings there; tap an account to edit them.

Hi, thanks for the reply.
In Settings I have:
Wireless and Networks
Call Settings
Sound
Display
Battery and Data Manager
Backup Assistant
Location and Security
Applications
Privacy
Storage
Language and Keyboard
Voice input/output
Accessibility
Data and time
About Phone
The my accounts app is also missing. I have reset the phone back to default using the reset option in settings.
Any other ideas?

Update:
I may know why it is missing. I used Titanium to remove some Verizon apps, "My Accounts" included.
Restoring it does not appear to work. Since it tells me the app was not installed.
Does anyone know of a way I can slip stream the apk in there, or where I can find the APK?
Thanks!

Attached .apk and .odex.

Sorry for the n00b Q here.
Where do I place the .odex?
I have only ever installed from APK. Never seen/used .odex.
Thanks for the post though! WIll save me hopefully from an SBF.
- EDIT: I think I know what an ODEX is now, just need to know where to place it before or after installing the APK.
Since I likley need to use ADB to do this and push the files if one could provide the CMD for pushing these and to which DIR they need to go I would be great-full
Thanks

UPDATE :
I used Astro to drop these into the /system/app folder and I still have them there.
Does anyone know why I cannot find Settings → Accounts (My Accounts app).
Do I need the MyAccount.APK? Does anyone have this?
Thanks!

I don't have anything like that (“MyAccount.apk”) on my stock rooted 4.5.608.
I can make a nandroid backup and upload the /system image, though, if that's fine with you.

Sure I would love that.
Failing that, may have to SBF I guess.
Let me know when and if you post nandroid..
Thanks!

See PM.
The file is, however, is a regular TAR archive (as CWM 5 uses those now), and you can open it with Total Commander, 7-Zip, WinRAR and the likes. Inside it you can find the entire /system/app directory as it exists on my phone. Some apps are frozen; you might also be interested in some changes I made to /system/build.prop (since you're a GSM user judging by your country of residence, you can safely copy it after backing up yours) — it has some tweaks added to improve GSM performance.

So after looking through your app folder, I discovered that the missing app I was in need of was called Setup.apk.
Now when I go to settings, I have the "Accounts" option.
Can't seem to add facebook to it. But I can live with this.
Thanks again for all the help.

Do you mean the stock Facebook plugin or the official Facebook app?

When you go into Accounts from Settings (which I was missing but have now corrected) and then click on Add Account. It shows me the options. Google, Twitter, LinkedIn, Facebook etc.
I click Facebook and nothing happens, when I click the others it lets me add a new or another account.
Facebook seems like it is just dead.
The Facebook for Android App is installed and the blur.facebook,apk or whatever it was called is still there too (assuming this is the stock plugin.)
UPDATE: I giess many ROMS don't allow FB for Android to sync contacts due to some fight with Google and Facebook.
So using an app like friend caster from one louder lets me sync some data but not all.
I guess the Sense ROMS I am used to have Facebook Sync built in. This ROM does not, nor does it allow it fully.
Thanks.

barryweston said:
When you go into Accounts from Settings (which I was missing but have now corrected) and then click on Add Account. It shows me the options. Google, Twitter, LinkedIn, Facebook etc.
I click Facebook and nothing happens, when I click the others it lets me add a new or another account.
Facebook seems like it is just dead.
The Facebook for Android App is installed and the blur.facebook,apk or whatever it was called is still there too (assuming this is the stock plugin.)
UPDATE: I giess many ROMS don't allow FB for Android to sync contacts due to some fight with Google and Facebook.
So using an app like friend caster from one louder lets me sync some data but not all.
I guess the Sense ROMS I am used to have Facebook Sync built in. This ROM does not, nor does it allow it fully.
Thanks.
Click to expand...
Click to collapse
Here is how I found this out:
http://www.engadget.com/2011/02/22/google-disables-contact-sync-in-facebook-for-android-only-nexus/
The final OTA for the D2G is also 2.3.3...same as what was talked about in the article.

barryweston said:
I click Facebook and nothing happens, when I click the others it lets me add a new or another account.
Click to expand...
Click to collapse
Did you freeze/remove the Facebook plugin, blur_facebook.apk?

barryweston said:
Here is how I found this out:
http://www.engadget.com/2011/02/22/google-disables-contact-sync-in-facebook-for-android-only-nexus/
The final OTA for the D2G is also 2.3.3...same as what was talked about in the article.
Click to expand...
Click to collapse
Facebook was working for me when I was on stock 2.3.3/4.5.608
but it did change with gingerbread
but it doesn't work on most custom ROMs
the android version 2.3.3. almost doesn't matter, with all the changes verizon/motorola make to it
so you can't really compare phones made by other manufactures
I still think you need to SBF to get things working again, or at least, do a reset/ delete data
edit: when i was still on stock GB i froze a bunch of apps, and one of them broke facebook
I unfroze them but facebook would not work, tried a few different things, fix permissions, reboot, clear cache/data for apps, but ended up doing a wipe data/reset and that fixed it

[Q] how to back up / restore weixin / wechat

message history lost - happened once or twice before - on this round perhaps due to unauthorized access - don't know why anyone would want to hack to my wechat, but...
yes, i know that titanium backup can do this - only, i happen to have a backup of the app's files from the SD card that's much later than the latest titanium backup.
so i've overwritten the message directory on the SD card
\tencent\MicroMsg\b51e1101d48c856d9e55dceeb6ea2af5\*.*
with the latest backup, but the app doesn't recognize the stuff between the titanium backup / the later files. how to force it to? how does it manage these files anyway?
(the answer to this might also help in managing the app's thousands of files in order to keep the phone functioning.)

have a try?
not knowing why your wechat got hacked, maybe you`ve got spyed by ur enemies?
I accidentally downloaded Clean Master from gp,(sorry as a new member, i`m not allowed to post a link here)
and it works well on both protecting my privacy and do the cache cleaning.
have a try?

hacking is a separate issue
Iankicksass said:
not knowing why your wechat got hacked, maybe you`ve got spyed by ur enemies?
Click to expand...
Click to collapse
this thread/question is about backing up / restoring weixin based on its files on the SDcard.

Standard practices for backing up and recover Wechat history
I have gone through the below link which explain the detail procedure of backup and recover/restore Wechat history. It might help you.
ww.saveintrash.com/backup-recover-wechat-history-android-iphone-ios-windows-phone/

zdoe said:
this thread/question is about backing up / restoring weixin based on its files on the SDcard.
Click to expand...
Click to collapse
Hi, have you manage to solve the problem? Im now facing roughly the same problem. I checked the wechat directory, all my conversation and voice msgs are still there. But my new installed wechat just could not recognize it, and show a blank new wechat with no chat history whatever.
How to force it to recognize it? Thanks

backing up / restoring weixin | house cleaning / maintenance
drumhitz said:
Hi, have you manage to solve the problem? Im now facing roughly the same problem. I checked the wechat directory, all my conversation and voice msgs are still there. But my new installed wechat just could not recognize it, and show a blank new wechat with no chat history whatever.
Click to expand...
Click to collapse
turns out that the message history is NOT on the files that are on the sd card - the sd card files are thumbnails, pictures, whatnot for the visual content. the messages are in an (encrypted) sqlite database on the phone's internal flash storage.
i do not know of what logic, if any, the app uses to either open the existing database (if found) or creating a new one - i've seen it do both, despite my always wanting to use the same account / database.
if i recall right, i just bit the bullet and restored the app/data from my titanium backup, thus losing a few days of messages as that backup was not up to date.
or - on the recent versions you can backup to tencent servers / restore from there - i guess primary use for that is when moving to a new phone. they only keep the backup file 7 days, and don't let you access it locally.
as for how to access the message database in a readable format, please let me know if you figure it out - weixin (at least the old version that i'm using) destroys any device it's on by not performing any housekeeping and thus clogging all the pipes until nothing works. so would be great if the message database could be optimized/cleaned/delete oldest by an extrernal sqlite app.
(the image files you CAN delete from your sd card - which i do periodically to kill the old ones.)
some related reading:
http://support.wechat.com/cgi-bin/mmsupport-bin/readtemplate?t=weixin_unlock_self&step=0
http://blog.emaze.net/2013/09/a-look-at-wechat-security.html
http://forums.hardwarezone.com.sg/i...-backuping-up-all-messaging-apps-4108833.html
http://www.netadmin.com.tw/article_content.aspx?sn=1306280001&jump=4
http://www.bankshung.com/2013/07/ioswechat.html

turns out that the message history is NOT on the files that are on the sd card----------------this info helps me lot,thanks

generaltlt said:
-this info helps me lot,thanks
Click to expand...
Click to collapse
you could always click the thanks-button.

Where to find titanium backup
zdoe said:
message history lost - happened once or twice before - on this round perhaps due to unauthorized access - don't know why anyone would want to hack to my wechat, but...
yes, i know that titanium backup can do this - only, i happen to have a backup of the app's files from the SD card that's much later than the latest titanium backup.
so i've overwritten the message directory on the SD card
\tencent\MicroMsg\b51e1101d48c856d9e55dceeb6ea2af5\*.*
with the latest backup, but the app doesn't recognize the stuff between the titanium backup / the later files. how to force it to? how does it manage these files anyway?
(the answer to this might also help in managing the app's thousands of files in order to keep the phone functioning.)
Click to expand...
Click to collapse
Hey you said you are using titanium backup, does ot work well? let me know where do I find it

Is it possible to back up wechat messages
I want to permatenantly back up wechat messages, because all messages will lost after I re-install wechat

well, that's currently very hard to do, because tencent doesn't give you (unencrypted) access to the SQL database that contains your messages, even if you use the backup functionality in the later versions of the software.
you CAN permanently backup your messages by copying the database from your phone's flash-memory (probably needs a rooted phone). but you can't access your data due to the encryption.
someone needs to write a 3rd party app that cracks the encryption (which is easy for a geek on the know, as the encryption key is based on some device iD string on your phone). then you could actually see your messages and manage them. probably some chinaman already wrote this app, we just don't know of it.
but message history does NOT get lost on re-install (at least for me) if you install over the old install, not from scratch. or, if you've backed up your messages using the apps function for that, you can restore them from their server.
but over time weixin will destroy any device it's on as the database size and image files number grow too big for your portable gadget to handle. no real housecleaning functions are available.

I miss in wechat 1 feature. Restore of mobile chat log TO windows wechat version.
We can restore mobile chat history to new mobile but WE CAN'T restore mobile chat history to windows wechat program, or can we?
It would be cool to be able to browse my mobile wechat chat history on windows pc. As it is now, my archive is empty, lacking past conversations.
And mobile scrolling to past conversations with certain people is troublesome. It has no proper archive oh right so mb an archive in mobile too?!

Hi all
Would you please help me to unblock my wechat account?
Many thanks in advance
I need old wechat user. At least 6 months account old.
Just send me confirmation
Pleasssssssssssss

arch.fadi said:
I need old wechat user. At least 6 months account old. Pleasssssssssssss
Click to expand...
Click to collapse
if i understand correctly, you want to piggybag onto an account someone else created. likely not available, even if the other user wanted to sell his/her account, as they in most cases require real-person verification these days.
but you might try to buy an account in taobao, usually everything is available there.

Thanks for your response..
No my brother... I need "friend help login"
It's option of wechat settings.
Would you please see the link below
If you have wechat account it just took one minute
Please help me if you can
https://chinahelp4u.com/how-to-unblock-wechat-account？/
---------- Post added at 12:36 PM ---------- Previous post was at 12:35 PM ----------
zdoe said:
if i understand correctly, you want to piggybag onto an account someone else created. likely not available, even if the other user wanted to sell his/her account, as they in most cases require real-person verification these days.
but you might try to buy an account in taobao, usually everything is available there.
Click to expand...
Click to collapse

[APP][2.3+] Expense IQ - Manage your personal finance smartly and easily

Expense IQ is the long awaited successor to EasyMoney - the number one money manager app that combines an expense manager, a bill reminder, a checkbook register and a budget planner!
Available in Google Play: https://play.google.com/store/apps/details?id=com.handyapps.expenseiq
Expense IQ – Expense Manager provides a rich, detailed window into your personal finances and daily money management needs.
Track and manage daily expenses quickly & easily! Business expenses, personal expenses, travel expenses etc can all be managed rapidly using Expense IQ’s simple and intuitive user interface.
Interactive reports & graphs let you analyse income, expenses, cash flow and balance over various date ranges and accounts.
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
To more effectively manage your budgets, you need a budget planner that makes keeping track of your expenses fun and easy. The integrated budget manager within Expense IQ lets you set monthly budgets on specific accounts and/or categories and monitor them via color-coded budget health bars that warns you when you are about to exceed your budgets.
Also integrated is a bill reminder that helps you avoid nasty late fees by issuing you timely reminders to pay your bills. You can even take a picture of your bills or invoices to keep a digital record.
Extensive Features:
-Cloud synchronization via Dropbox to synchronize transaction data between multiple devices
-Split transactions supported for more detailed income & expense management
-Export captured data as QIF & CSV to desktop money managers (eg. Quicken) for expense reporting etc.
-Includes a Home Screen Widget for even faster expense management & tracking. Add transactions straight from the home page once you enable the widget - great for daily expense tracking!
-Receive notifications of upcoming and overdue bills - for both one-time payments as well as recurring bills
-Set monthly budgets on specific accounts and/or categories and monitor them via color-coded budget health bars
-Fully customizable income and expense categories for more accurate budget planning.
-Take photos of Bills & Receipts
-Integrated Checkbook Manager
-Track and manage expense and income for multiple accounts in multiple currencies
-Setup repeating transactions
-Support transfers between accounts
-Lock application using a 4-digit security pin
-Backup data onto SD card
-Daily automated backup creation
Download Expense IQ today!
This app is not just for money lovers! Whether you are looking for a better daily expense manager or trying to stay out of debt and be money wise, Expense IQ is definitely the ideal tool to stay on top of your finances.
All rights reserved by Handy Apps.

Data migration from Easymoney
A way better UI than what EasyMoney has! Is there a way to migrate the database of Easymoney to ExpenseIQ without losing the photos of bills?

I personally feel like this as one of the best expense management tool. The most required part in any tool is the usability or the navigation which talks about the compatibility and that is what I can realize in this tool. I will surely try out this tool but even I have the same question as is asked above.

Banko6 said:
A way better UI than what EasyMoney has! Is there a way to migrate the database of Easymoney to ExpenseIQ without losing the photos of bills?
Click to expand...
Click to collapse
Hi! There are some radical changes from EasyMoney to Expense IQ so there isn't a quick solution to that. However, it is possible via some manual file movements on your device. Other than the photos, you can transfer the transactions too.Here's how you can do that.
1. Install Expense IQ.
2. Launch EasyMoney, and go to Database Tools.
3. Select Export CSV and export each individual account you have. These will be exported to sdcard0/EasyMoney/csv_output folder. Copy all the files there.
4. Paste copied files to sdcard0/ExpenseIQ/csv_input.
5. Copy sdcard0/EasyMoney/photos. Then paste the folder to sdcard0/ExpenseIQ/photos and allow file overwrite.
5. Launch Expense IQ and recreate all your accounts.
6. Proceed to Import CSV, select an account and a specific CSV file to import. Make sure all formats are similar.
7. Wait for the import and the import successful message.
8. Go to accounts and check that the transactions have been imported.
Once the first import works, please continue for all other accounts. Do note that budgets and bill reminders have to be recreated manually.
If you require further assistance, email us with ‘Data porting to Expense IQ’ as subject title to [email protected].

lesliescott06 said:
I personally feel like this as one of the best expense management tool. The most required part in any tool is the usability or the navigation which talks about the compatibility and that is what I can realize in this tool. I will surely try out this tool but even I have the same question as is asked above.
Click to expand...
Click to collapse
Thanks for your kind feedback! Hope you don't mind the copied-then-pasted steps below Feel free to share any suggestion you have for Expense IQ and we will see what we can do with that!
1. Install Expense IQ.
2. Launch EasyMoney, and go to Database Tools.
3. Select Export CSV and export each individual account you have. These will be exported to sdcard0/EasyMoney/csv_output folder. Copy all the files there.
4. Paste copied files to sdcard0/ExpenseIQ/csv_input.
5. Copy sdcard0/EasyMoney/photos. Then paste the folder to sdcard0/ExpenseIQ/photos and allow file overwrite.
5. Launch Expense IQ and recreate all your accounts.
6. Proceed to Import CSV, select an account and a specific CSV file to import. Make sure all formats are similar.
7. Wait for the import and the import successful message.
8. Go to accounts and check that the transactions have been imported.
9. Tap on a transaction with an attached photo and check if the photo is visible.
Let us know if something odd pops up while you are going through the steps above and we will be happy to help you out!

Just want to know if purchase/upgrade to your Expense IQ Gold Edition, how many devices (Smartphone, Tablet, etc) that we can use?

I tried the app. Very nice.

Thank you for your response! The latest version of ExpenseIQ introduced a new import option: 'Import from EasyMoney', this way the migration from EasyMoney is very convenient - thank you HandyApps! :good: The photos folder can be manually copied to the folder of ExpenseIQ.
I have started to use and I really liked it.
Are you planning to support Google Drive based cloud sync? Is there any data encryption during cloud sync?

tomboyed said:
Just want to know if purchase/upgrade to your Expense IQ Gold Edition, how many devices (Smartphone, Tablet, etc) that we can use?
Click to expand...
Click to collapse
Hi tomboyed, the purchase is tied to your Google account, so that would depends on how many devices is allowed for one Google account. I don't know the exact number of devices Google allows, but it seems that some have up to 10 devices all connected to the same Google account.
Source: http://android.stackexchange.com/qu...evices-with-a-single-google-account/8735#8735

Banko6 said:
Thank you for your response! The latest version of ExpenseIQ introduced a new import option: 'Import from EasyMoney', this way the migration from EasyMoney is very convenient - thank you HandyApps! :good: The photos folder can be manually copied to the folder of ExpenseIQ.
I have started to use and I really liked it.
Are you planning to support Google Drive based cloud sync? Is there any data encryption during cloud sync?
Click to expand...
Click to collapse
Great to hear that! We may look into other cloud sync options in future updates. As of now, Expense IQ's Dropbox sync utilises a function called Datastore by Dropbox. Datastore is some sort of Database in the Dropbox and is owned by the user only (privacy wise secure) so it won’t appear in a folder. This provide faster synchronization than conventional file saving of an entire database. Let us know if you want the link to log in and view your data, we will drop you a PM

refaelsh said:
I tried the app. Very nice.
Click to expand...
Click to collapse
Thanks for trying out Expense IQ! We are glad to know you enjoy your experience with it

Upgrade question.
For those of us that have purchased EasyMoney, will there tbe a discount for Expense IQ? I have used EasyMoney exclusively since I got my first Android device 3 years ago. I had moved from a PalmPilot with PocketMoney when I found EasyMoney. Catamount Software said they would not port PocketMoney to Android, although, they would to iOS. :-/ So, enter EasyMoney. Thanks in advance!

Thanks for the info! Datastore by Dropbox is really interesting feature.
I am actively using ExpenseIQ, and I really like it. Although there might be some improvements that would help a lot:
In the calculator, a button to delete a mistyped digit
Photo attachment function is missing in split tranzaction
In the photo attachment screen the latest pictures should be on top
Adding categories in a split transaction, the last row is not saved, if the plus sign is not pressed on that row
There were a bunch of updates in the app, it gets even better. I hope this feedback might be usefull.

Hmmm, strangely silent about possible purchasing discount for those of us that bought EasyMoney?
Sent from my SGH-T889 using Tapatalk

Banko6 said:
In the calculator, a button to delete a mistyped digit
Click to expand...
Click to collapse
I would also like to see this feature. Except of that perfect app.

Muti device feature
Hi, I am interested in sync feature and I need to know if I can share my expenses with my wife device. It's that possible with gold versión?

Moon Shadow - NM said:
For those of us that have purchased EasyMoney, will there tbe a discount for Expense IQ? I have used EasyMoney exclusively since I got my first Android device 3 years ago. I had moved from a PalmPilot with PocketMoney when I found EasyMoney. Catamount Software said they would not port PocketMoney to Android, although, they would to iOS. :-/ So, enter EasyMoney. Thanks in advance!
Click to expand...
Click to collapse
Hi and sorry for the delay Moon Shadow, drop us an email at [email protected] and we will see if there is something we can work out

Banko6 said:
Thanks for the info! Datastore by Dropbox is really interesting feature.
I am actively using ExpenseIQ, and I really like it. Although there might be some improvements that would help a lot:
In the calculator, a button to delete a mistyped digit
Photo attachment function is missing in split tranzaction
In the photo attachment screen the latest pictures should be on top
Adding categories in a split transaction, the last row is not saved, if the plus sign is not pressed on that row
There were a bunch of updates in the app, it gets even better. I hope this feedback might be usefull.
Click to expand...
Click to collapse
Thanks for your various feedback Banko6!
1 and 3. Noted! We will look into these when designing future updates.
2. This has since been added to v1.0.4_21. Do update Expense IQ when there is an update available.
4. The + sign must be tapped to ensure that the specific category is added. We won't know whether you'd accidentally type something in the last row or genuinely wanted that last category but didn't add it when saving the entire transaction. If it was an accident, additional action on your part is needed to edit and re-save that transaction again. Thus, we decided to stop that additional action by making that + sign compulsory when adding a category in the first place.
We appreciate your feedback in helping us improve on Expense IQ!

argtine said:
Hi, I am interested in sync feature and I need to know if I can share my expenses with my wife device. It's that possible with gold versión?
Click to expand...
Click to collapse
Hello Argtine,
So long as both devices sign in to the same Dropbox account via Expense IQ's Cloud Sync and there are sufficient storage, the data of both devices can be in sync. The first device to enable sync will be the Master device which is responsible for creating repeating transactions. The data in the app will also be synced to Dropbox Cloud.
The second device to enable sync can then choose to restore data from cloud, or copy existing data to cloud. Ideally it should restore data from cloud saved by the Master device. Any changes made by either device will be synced to that one Dropbox account so that both devices will have access to the same data.
If you require further clarification, feel free to email us at [email protected]

Thanks for considering my feedback! I have already realized that the photo attachment option has been added to the split tranzactions. You are improving the app very fast!
Let me suggest one more: it would be great, if the bill reminder notifications would appear as one aggregated line in the notification bar (like the email notification) otherwise if there are a lot of due bills the ExpenseIQ floods the notification list.
There is a small FC issue: if the amount of a category line (in a split tranzaction, which was saved before) is modified, the calculator pops up, the amount is negative, any calculation causes FC.