Results 1 to 5 of 5

Thread: Email Database and Campaign Questions

  1. #1
    Sawtooth500 is offline Member
    Join Date
    Oct 2009
    Posts
    18

    Default Email Database and Campaign Questions

    Two questions:

    1. When sending out emails in an email campaign, does Sugar support throttling so that we don't exceed our hosting provider's hourly email quota?

    2. So if I link an external email account to Sugar via IMAP, let's say that external account has a few thousand messages in it and about 2 GB worth of attachments, is all that information going to be copied to Sugar? I'm guessing that all the emails will get stored in MySQL and the attachments will be stored in a folder somewhere in the sugar directory on our server (not in the MySQL database). Do I have that correct?

    Thanks for the help!

  2. #2
    kuske's Avatar
    kuske is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Germany
    Posts
    2,597

    Default Re: Email Database and Campaign Questions

    1. The throtteling can be found in admin - manage campaign email settings: Number of emails sent per batch

    2. In connection with an IMAP server SugarCRM only loads the headers of your Emails ( in version >= 5.1 ). Only if the Email is opened it will be loaded. BUT, if you have a great amount of emails on your server, it can take a long time to initialize your email account in SugarCRM.
    The email bodies and attachment are only stored if you start this explicitly!
    Harald Kuske
    Pre-Sales Engineer Central Europe

    SUGARCRM Deutschland GmbH
    Erika-Mann-Str. 53, 80636 Munich, Germany
    Email: hkuske@sugarcrm.com
    Home: http://www.sugarcrm.com


  3. #3
    Sawtooth500 is offline Member
    Join Date
    Oct 2009
    Posts
    18

    Default Re: Email Database and Campaign Questions

    You said the email bodies and attachments are stored only if we start this explicity - I'm not quiet sure what you mean by this. Also, would those by stored in the SQL database or as files?

  4. #4
    kuske's Avatar
    kuske is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Germany
    Posts
    2,597

    Default Re: Email Database and Campaign Questions

    All email Headers/Subjects are stored in email_cache table.

    If you archive an email it is stored in emails table.

    And if you archive an attachment of an email it's description is stored in notes table and the attachment itself is stored in the upload directory (/cache/upload).
    Harald Kuske
    Pre-Sales Engineer Central Europe

    SUGARCRM Deutschland GmbH
    Erika-Mann-Str. 53, 80636 Munich, Germany
    Email: hkuske@sugarcrm.com
    Home: http://www.sugarcrm.com


  5. #5
    Sawtooth500 is offline Member
    Join Date
    Oct 2009
    Posts
    18

    Default Re: Email Database and Campaign Questions

    Thank you!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Bugs/questions about marketing / campaign module in Sugar 5.2 CE
    By christelle75 in forum Marketing/Campaign Management
    Replies: 0
    Last Post: 2009-03-13, 12:49 PM
  2. Replies: 0
    Last Post: 2009-03-13, 12:35 PM
  3. Two email questions...
    By aaelghat in forum Help
    Replies: 1
    Last Post: 2008-01-02, 02:47 PM
  4. Campaign newsletter questions
    By gmgartner in forum Help
    Replies: 2
    Last Post: 2007-06-16, 06:14 AM
  5. Campaign questions
    By Oracledarren in forum Marketing/Campaign Management
    Replies: 1
    Last Post: 2006-01-12, 08:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •