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.    Note: This upgrade works only with version 3.0.  If you are not using 3.0 please contact us.  The version is listed at the bottom of the administration console.

Please verify that your server meets the following requirements for eNewsletter Pro version 7 for .NET:

• .NET Framework 2.0 (Note: this can be installed using the Windows Update tool)
• Make sure the IIS Application for eNewsletter Pro has selected .NET 2.0 on the ASP.NET Tab.  If 1.1 is selected and you change to 2.0 make sure this application pool is not shared by other applications running .net 1.1 or you will get an error.
  

1. Make a backup copy of your database as this upgrade will modify the database.  
    
2. Unzip the contents of eNewsletterProEnterprise7UpgradeFrom3.zip in a temporary location somewhere on the server where eNewsletter Pro is installed.  You will now see the following folders:
   
   eNewsletterPro
   Database
   MailEngine
   
3. Next, Execute the SQL script called enewsletterpro7UpgradeFrom3.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.
    
4. 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 you see this warning message you can ignore it as it is not fatal:  Warning: The table 'tbl_newspro_SendQueue' has been created but its maximum row size (8403) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
   
   

Install Updated Web Files and Upgrade existing Data

1. Version 7 includes changes to the Root web.config file for the Cross-Site Scripting checks.  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 and copy this line:
   
   <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.
   
   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. 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.
    
5. Now delete upgrade.aspx so it cannot be executed a second time. 
    
6. 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. From the /mailengine/ folder, double-click on eNewsletterPro7.MSI to run the installation program.  Be sure to choose the folder in which your current version of the eNewsletter Pro Mail Engine is 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.