|
eNewsletter Pro
Enterprise Version 7 for ASP.NET Upgrade
(FROM 5.0) Instructions
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 5.0.
If you are not using 5.0 please contact
us. The version is listed at the bottom of
the administration console.
- Make
a backup copy of your database as this
upgrade will modify the database.
- Unzip
the contents of eNewsletterProEnterprise7UpgradeFrom5.zip
in a temporary location somewhere on the
server where eNewsletter Pro is installed.
You will now see the following folders:
eNewsletterPro
Database
MailEngine
- Next,
Execute the SQL script called
enewsletterpro7UpgradeFrom5.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.
- 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
- 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.
- Before
copying files, delete the entire CuteSoft_Client
folder from the web site where eNewsletter Pro
is installed.
- 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.
- 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.
- Now
delete upgrade.aspx so it cannot be executed a
second time.
- 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.
- 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.
|