You should perform this upgrade at a time when you are not delivering a newsletter.  If a newsletter is currently being delivered wait until the send has completed.  It is recommended you wait until 48 hours after any newsletter has been sent and then perform the upgrade.  Click here to see what's new in this update.   

Pre-Installation Notes

• Verify that you are currently using Version 5.  If you are not using 5.0 please contact us.  The version is listed at the bottom of the administration console.
• This upgrade require .net 4.0 be installed on the server.  Please verify .net 4 has been installed.  If it is not installed it should be installed through the Windows Update utility.
• Make a backup copy of your database as this upgrade will modify the database.  

Pre-Installation Instructions

1. Modify your existing eNewsletter Pro IIS Application Folder to use .net 4.0 instead of .net 2.0.  Click here for instructions on doing so.

Installation Instructions

1. Unzip the contents of eNewsletterProEnterprise11UpgradeFrom5.zip in a temporary location somewhere on the server where eNewsletter Pro is installed.  You will now see the following folders:
   
   eNewsletterPro
   Database
   MailEngine
   
2. Next, Execute the SQL script called enewsletterpro11UpgradeFrom5.sql on your existing eNewsletter Pro Enterprise database.  The script is found in the folder where you unzipped the files in step 1.  This script is executed in SQL query analyzer.  If unsure how to do this, please review steps 6-7 of the original install instructions.  Be absolutely certain that you select the proper database in the drop-down menu before executing the script. Be patient this script may take a while to run.
   
3. Once the above script has executed, you will see a number of messages indicating various rows were affected.  For example...(89 row(s) affected)  Scan all messages and make sure no errors occurred.  If an error occurred, email us the error and discontinue the upgrade.  If an error occurred you may wish to restore the database backup until we can resolve the issue. 
   
   If the database has successfully been upgraded, proceed to the next section.
   

Install Updated Web Files and Upgrade existing Data

1. Version 11 includes changes to the Root web.config  Because this file also holds your custom database connection string, you must first enter your database connection into the web.config file before copying the updated files.  If you don't your database connection will break after the upgrade.  Also, if you added any custom tags to the web.config they should also be transferred. To do so...
   
   Open the web.config for your EXISTING installation of eNewsletter Pro.  Find this line and copy the portion shown in GREEN:
   
   <add key="DBConnectionString" value="server=(LOCAL);UID=youruserid;PWD=yourpass;DATABASE=eNewsletterPro" />
   
   Now, open the web.config found in the "eNewsletterPro" folder of the upgrade files.  Replace the sample connection string with your full connection string.
   
   <connectionStrings>
   <add name="DBConnectionString" connectionString="server=(LOCAL);UID=youruserid;PWD=yourpass;DATABASE=eNewsletterPro" />
   </connectionStrings>

   Save the file.
   

2. Before copying files, delete the entire CuteSoft_Client folder from the web site where eNewsletter Pro is installed.
   
3. Copy the files and folders from the folder called "eNewsletterPro" to the web folder where eNewsletter Pro is installed.  Typically this is http://www.yourdomain.com/enewsletterpro/.  Replace any existing files if prompted.  Be sure to include all folders and subfolders such as Admin, Bin, Images, User etc.
   
4. In order to use the charting tool, you must give the Users account WRITE permissions on the ChartImages folder.  Click here for directions on setting write permissions.
    
5. Load the Upgrade.aspx file in your browser. It is located in the root folder and has open access.
   
   For example: http://www.yourdomain.com/enewsletterpro/upgrade.aspx
   
   Click the button to upgrade your existing database. This will encrypt the proper records.
    
6. Now delete upgrade.aspx so it cannot be executed a second time. 
   
7. Login to the admin console and user console to make sure the web interface is loading properly.
   

Install Updated Mail Delivery Engine and SMTP Express Update

Note: You should be logged in as the administrator or an account with administrative privileges.  You should be logged in using the same account under which the software was originally installed.

1. Begin by first un-installing the previous version of the mail engine.  To do this, find "Add/Remove Programs" in the Windows control panel.  Find "eNewsletter Pro Enterprise Edition" and click the Remove button.
   
   
2. From the /mailengine/ folder, double-click on eNewsletterPro11.MSI to run the installation program.  Be sure to choose the folder in which your current version of the eNewsletter Pro Mail Engine was installed. 
   
   The default path is C:\program files\enewsletterpro however you may have choose a different path or drive.
   
   This installer will now update the necessary files.