Page 1 of 2 12 LastLast
Results 1 to 20 of 27

Your favorite Apple, iPhone, iPad, iOS, Jailbreak, and Cydia site.


Thread: REQ: Mod to mark all mail as read

  1. #1
    Default REQ: Mod to mark all mail as read
    ok, i don't know about you guys but i'm completely sick of having to mark 1 by 1 all the emails to either delete or mark as read, specially when something happens with the phone that i have to start from scratch and download over 1.5k emails on 4 accounts

    is there a mod or app out there that will do it? can it be done?

    thanks

  2. #2
    Shouldn't be too hard...I'll get on it

    Ok, this will require an SSH connection:

    1) SSH into your device
    2) Run the following commands:
    Code:
    sqlite3 /private/var/mobile/Library/Mail/Envelope Index "update messages set flags = flags + 1 where flags&1 = 0;"
    sqlite3 /private/var/mobile/Library/Mail/Envelope Index "update mailboxes set unread_count = 0;"
    3) Reboot your iPhone

    This will mark all messages in the iPhone's mailbox as read.
    Last edited by jdas; 2009-02-01 at 05:59 PM. Reason: Automerged Doublepost

  3. The Following User Says Thank You to jdas For This Useful Post:

    -Blue- (2009-02-02)

  4. #3
    thanks, but how do i run a command?
    do i do it from the terminal or from winscp?
    thanks again


    ok this is what i got.. i did a copy paste from what you wrote..
    Code:
    /$ sqlite3 /private/var/mobile/Library/Mail/Envelope Index "update messages set flags = flags + 1 where flags&1 = 0;"
    SQL error: near "Index": syntax error
    /$ sqlite3 /private/var/mobile/Library/Mail/Envelope Index "update mailboxes set unread_count = 0;"
    SQL error: near "Index": syntax error
    not sure what i did wrong.. at least i figured out the commands part lol
    Last edited by -Blue-; 2009-02-02 at 04:53 PM.

  5. #4
    Oops...run these instead

    Code:
    sqlite3 "/private/var/mobile/Library/Mail/Envelope Index" "update messages set flags = flags + 1 where flags&1 = 0;"
    sqlite3 "/private/var/mobile/Library/Mail/Envelope Index" "update mailboxes set unread_count = 0;"

  6. The Following 3 Users Say Thank You to jdas For This Useful Post:

    -Blue- (2009-02-04), iRockish (2009-09-22), jjhack (2009-03-04)

  7. #5
    yay it worked.. thanks
    now hopefully someone will turn this into a mini app or something

  8. #6
    Retired Moderator bhz1's Avatar
    Join Date
    Sep 2007
    Location
    Southeastern Pennsylvania
    Posts
    2,528
    Thanks
    92
    Thanked 361 Times in 271 Posts

    I loved iDeleteMail on the old 1.1.x firmwares. Wish there was something similar. While its nice to have the command line workaround, having it as an app is better.

  9. #7
    yeah, a select all or delete all would also be great.. an app that includes or adds to the mail app the options of.. read all, delete all, select all, would be great

  10. #8
    A note on the code above, you don't have to reboot or respring the phone for the counts to reset. Just kill the "MobileMail" app. The app will automatically reload, and when it does the counts will be reset.

    Code:
    killall MobileMail
    Just be sure you are not in the middle of composing an important email!

    I'm looking for ways to automate this process, it's easy to get it into a script. But getting it to an app/icon is a bit harder.

    Thanks jdas for the SQL code!!

  11. #9
    Default New App!
    Ok I have the script above made into an application. But there are a couple of caveats.

    1. You have to have SSH enabled on your phone. If you disable the SSH service the app will not work.
    2. The app will terminate the mail app, so if you are in the middle of composing an email it will be lost.
    3. If using exchange, this will not mark the messages read on your exchange server. It will mark the messages read on the phone, but the mark will not sync back to the server.

    Download the app here: markall.tar.gz

    Just place the tar file in the /Applications folder and extract, then reboot or respring.

    When you run the app it will show a black screen then return to the springboard. Wait about 1-2 seconds and the mail unread count will clear.

    Hope this app helps, I use it all the time!

  12. #10
    hmm, the markall.app doesnt work for me, I SSH'd into my phone and tried untarring the file but winscp said it wasnt a valid gzip compression or something. So I untarred the file on my desktop and just copied over the markall.app to my applications folder, then set permissions to 775 and rebooted my iphone. The markall.app appears and it launches but the message count doesnt go down

    edit: i made sure ssh was enabled, does this only work on POP3 accounts? because I have IMAP e-mail accounts.

    edit 2: i followed this guide (http://www.modmyi.com/forums/native-...inscp-ssh.html) and set permissions back to 755 and clicked on recursive, rebooted and it worked! thanks so much!
    Last edited by fade; 2009-05-26 at 11:25 PM.

  13. #11
    I followed the instructions here and it still does not work for me. When I tap the icon, the screen goes blank for a split second and the mail.app terminates, but when I respring or reboot or anything the count has not gone down. Is there any program for this that really works? I'm on 3.0.1 3GS.

  14. #12
    Jjhack, for a new member u know a ton. Thanks or the useful tips.

  15. #13
    Default Link to markall.app
    Anyone got a different link to the markall.app??.....after extracting the 4kb linked file all I get is a blank folder entitled markall. Any ideas, really sick of seeing a hundreds of "unread emails" that I've already read on my comp.

    Thanks

  16. #14
    Default Update for 3.1.2?
    The markall.app is a great idea. However, having trouble making it work with 3.1.2. The app executes, but doesn't mark mail as read. In fact, it has the opposite effect. If I manually mark a mail as read, then run the markall.app, it actually sets it back to unread. Anyone have any suggestions? Is there something different in 3.1.2 that might cause this?

  17. #15
    Hi,

    first of all, thanks a lot for this great small app.

    But maybe someone can answer me to questions:

    1. After kill MobileMail how can i restart it? Because i think the next step is always to click on the button. But it should be automated.

    2. Can you tell me a method to delete all mails in MobileMail?

    Thanks a lot for the help.

    Cu kami23

  18. #16
    I'm running Snow Leopard on my MacBook Pro and can't seem to uncompress the markall.tar.gz properly.....I've tried Stuffit, GuiTar, unarchiver, etc.....GuiTar ends up just giving me an empty folder entitled "markall".

    So, does anyone have a link to the markall.app file already extracted or able to email me at my spam address [email protected]??? if you can email please respond so I get an email to my real address and know to check my spam account.

    Thanks

  19. #17
    [ame=http://www.youtube.com/watch?v=9UUfzqSPnsc]YouTube - popMark.mov[/ame]

  20. #18
    Green Apple
    Join Date
    Nov 2008
    Location
    New York, NY
    Posts
    44
    Thanks
    29
    Thanked 15 Times in 10 Posts

    Hello,

    Where exactly can I find this popMark app? It's not in Cydia or the app store. I need it ASAP,

    Thanks!

    -Ted.

  21. #19
    Quote Originally Posted by teddyf1 View Post
    Hello,

    Where exactly can I find this popMark app? It's not in Cydia or the app store. I need it ASAP,

    Thanks!

    -Ted.
    +1
    been looking for something like this!

  22. #20
    Hi Guys,

    I still have yet to package it properly with its dependancies.

    I thought they were going to fix this in OS4 so I hadn't worked on it since I produced the video.

Page 1 of 2 12 LastLast
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •