If you need to move your EMD installation to a new computer, simply download the evaluation of the program, then move the campaign.sto, the campaignlists.sto, and the content folder from the old installation to the new. Your SN, campaign configurations and email lists are stored in those files. Your HTML messages are stored in the content folder.
On Windows XP, the location for those files is usually:
C:\Program Files\EmailMarketingDirector
On Windows 7, the location is typically:
C:\ProgramData\EmailMarketingDirector
You can use the search feature in Windows Explorer and search for .sto. If you don't see anything, you may need to unhide the programdata folder or simply copy and paste the file path into Windows Explorer.
If you want the old Logs, you can move that folder as well.
Consider the following as a text representation of your original database source table.
ID EmailAddress FirstName LastName
1 bobsmith@yourdomain.com Bob Smith
2 janehooper@yourdomain.com Jane Hooper
To insert information into a new table use an insert statement, the built-in merge fields that can be used for Click-Throughs include: {CAMPAIGNID},{UNIQUEID}, {CLICKTHRUNUMBER}, {REMOTEADDRESS} and {EMAILADDRESS}.
Sample Syntax:
INSERT INTO ClickThroughInfo (CAMPAIGNID,UNIQUEID,Event,CLICKTHRUNUMBER,REMOTEADDRESS,EMAILADDRESS) VALUES ({CAMPAIGNID},{UNIQUEID},'Click',{CLICKTHRUNUMBER},'{REMOTEADDRESS}','{EMAILADDRESS}')
ClickThroughInfo Table - Before Bob Smith or Jane Hooper have clicked on a click through.
CAMPAIGNID UNIQUEID Event CLICKTHRUNUMBER REMOTEADDRESS EMAILADDRESS
ClickThroughInfo Table - After Bob Smith clicked on a click through number 1 from campaign number 7, and click through number 3 from campaign number 2, and Jane Hooper clicked on click through number 11 for campaign number 5.
CAMPAIGNID UNIQUEID Event CLICKTHRUNUMBER REMOTEADDRESS EMAILADDRESS
7 1 Click 1 200.235.68.74 bobsmith@yourdomain.com
5 2 Click 11 12.45.74.1 janehooper@yourdomain.com
2 1 Click 3 200.235.68.74 bobsmith@yourdomain.com
Click-Through Tracking Stored Procedure
To run a stored procedure each time a click through is recorded, create the stored procedure on the database, then execute the stored procedure from the stored procedure field for open tracking.
Example: EXECUTE dbo.ClickthroughSP
You can now also use the {URL} merge field to pass the URL for the click through back to some field in your table.