how can I retrieve email attachment from database

Author Message
readonly

  • Total Posts : 1
  • Joined: 5/26/2017
  • Status: offline
how can I retrieve email attachment from database Friday, May 26, 2017 10:49 AM (permalink)
Hi,
we have a requirement which need export email attachments with specific email titles to some folders, I plan to write a script to do such stuff.( I cannot use the UI since the email numbers are huge, more than 10k emails at least)
I can find the attachments file which stored in image format in arc_sources table:
arc_sources:     id | data | compressed | signature
and basic info from arc_att table:
arc_att:  id | fileName | attSize | attId | contentId | contentLocation
 
can you please advise how to convert the file data from arc_sources to normal files then? looks like they are encrypted?
 
Thanks,
Jiang
 
#1
    Online Bookmarks Sharing: Share/Bookmark

    Jump to:

    Current active users

    There are 0 members and 1 guests.

    Icon Legend and Permission

    • New Messages
    • No New Messages
    • Hot Topic w/ New Messages
    • Hot Topic w/o New Messages
    • Locked w/ New Messages
    • Locked w/o New Messages
    • Read Message
    • Post New Thread
    • Reply to message
    • Post New Poll
    • Submit Vote
    • Post reward post
    • Delete my own posts
    • Delete my own threads
    • Rate post

    2000-2018 ASPPlayground.NET Forum Version 3.9