Boogie Tools

Bounced Email Child Form

Bounced Email Detail

netFORUM integrates with BoogieTool's BounceStudio Enterprise 4.3 - Includes 5 POP Account License and tracks bounced email addresses and records them on the Bounced Email child form under the Individual profile page (no reporting or business rules based on bounces). Business rules functionality can be developed per client (extra cost). For example, set the do not contact via email flag if message bounces back.

BounceStudio Enterprise sorts your bounced email messages into a number of email bounce categories.

Setup Checklist

To configure Boogie Pop mail bounce for the Project Managers, you must get the following information from the clients:

  • Mailbox Name
  • Mailbox (POP3) User Name
  • Mailbox (POP3) Password
  • Mail Server name or IP
  • netFORUM Database Server Name
  • netFORUM Database Name
  • SQL User
  • SQL Password

Contact Boogie Tools to register the server and obtain a license.

Setup Process

  1. You can start the setup by downloading the product form Boogie Tools' Website.
  2. www.BoogieTools.com that will keep you functional for 30 days.
  3. Install the product by going through the Setup.EXE wizard.
  4. Collect the serial number information and send it for registration (Done by customer of the PM)
  5. Get the license key and install it.
  6. Create a System ODBC - data source DSN into the netForum database.
  7. Create the mailbox configuration along with this code on the SQL command. That is basically an SP that maps the bounced items into the table items.

The Simple Configuration

SQL:

co_email_bounceback_insert@ceb_to_address = '#EMAIL#', @ceb_from_address='#FROM#', @ceb_subject='#SUBJECT#', @ceb_pop_account='#POPACCOUNT#', @ceb_bounce_type='#BOUNCETYPE#', @ceb_body='#BODY#', @ceb_xbps1='#X-BPS1#', @ceb_xbps2='#X-BPS2#'

Client Tasks

Note: For Hosted clients, the client has to provide Abila with the mailbox and login/pwd to use on their mail server (and maybe open their firewall so netFORUM can connect via POP3 to their mail server).

There has to be a POP acct for BounceStudio to check. MS Exchange does not do POP by default, and it is difficult to get it to do it and allow BounceStudio to check it (this is an Exchange admin thing NOT an Abila thing). After the client has POP accounts configured, the client staff has to use them as the send 'from'/'reply to' email address on the emails that they want to have BounceStudio check for bounceback/NDR (non-delivery report) messages. BounceStudio handles the scheduling of the checking of the mailbox, and executes the SP when it finds matching bounces in the email account.

Abila Tasks

  • Setup & configuration of software. This includes the following services:
    • Install the Boogie software on a server (client types e.g. local, hosted or shared hosted clients)
    • Connect Boogie to a mailbox on the client's mail server to be used as a "bounce box". Internally, we have Boogie connected to the announcements@avectra.com mailbox
    • Connect Boogie to the netFORUM database, specify a stored procedure or SQL query to log the bounced emails. Our baseline version logs the bounces only via a stored-procedure.

Costs

Usage and Instructions

Future Functionality: (No timeframe set yet on new functionality)

  • Create reporting based on bounced emails.
  • Create auto-opt out feature for bounced emails.
  • Internal Abila document: \\av-fs01\netFORUM\Documentation\Integration\netFORUM-Boogie-Tools.doc
  • Internal Abila document: \\av-fs01\netFORUM\Documentation\boogietools\Tracking Bounced Emails.doc
  • BounceStudio Enterprise Help
  • Bounced Email child form on Individual profile that displays bounced emails tracked by Boogie Tools.
  • co_email_bounceback table.