Miscellaneous

Last updated April 17th, 2018

Miscellaneous FAQ:

Can I change the domain name where my product is licensed to?

Yes. We allow one license key change per product, as long as your support on the license is current. To change the domain where your product is licensed to, please email support@interspire.com

How do I link to an archived version of my email campaigns?

Go to Contact Lists --> View Contact Lists.

Click the "RSS" icon for the relevant list, which will bring you to an RSS feed of all previously sent campaigns. You can either link your users to this page or directly to the campaign in question.

Alternatively, you can paste pre-defined fields into your emails through the WYSIWYG editor for the web version of emails, and also a link to the RSS archive of sent campaigns.

How do I choose which lists my contacts will be added to and which custom fields will appear on the form?

To create a subscription form which you can place on your web site, you need to choose which contact lists you want your subscribers to be added to when they sign up, as well as which custom fields you want to include on your subscription form.

To do this, start by ticking the list(s) you want your subscribers to be added to when they fill out your subscription form. Under each list you will see the custom fields which have been assigned to that list. To include each custom field in your subscription form, simply tick the box next to it. It will then be added to the Sort Custom Fields list below. You can change the order in which custom fields appear on your subscription form simply by dragging and dropping them.

How do I create a custom field drop down that has a list of countries quickly?

To create a dropdown custom field of countries, upload the attached files into your iem/ folder and run the import_countries.php file from your browser.

It will create a new custom field called "Countries" with all of the countries (from the CSV file) imported.

<?php

require('admin/functions/api/customfields_dropdown.php');
$customfields_dropdown = &new CustomFields_Dropdown_API();

$handle = fopen('countries.csv', 'r');

$settings = array('Key' => '', 'Value' => '');

$settings['DefaultValue'] = 'Please select one of the following options';
$settings['FieldName'] = 'Countries';
$settings['FieldRequired'] = '0';

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
	$settings['Key'][] = current($data);
	$settings['Value'][] = current($data);
}

$customfields_dropdown->Settings = $settings;

$fieldid = $customfields_dropdown->Create();

echo "Custom field created\n";

?>

Countries.csv

Download Now Instant download. No email required.

How do I know what version of Interspire Email Marketer I'm running?

If you are running Interspire Email Marketer or unsure what version you have, go to the settings page and scroll to the bottom just under "Test the sending system". There should be a complete version number.

If a version number is not there, then you are running SendStudio 2004. The version for SendStudio 2004 can be found inside the version.txt file located in the Interspire Email Marketer folder.

How do I create a MySQL database in Plesk?

Step 1. Login and select Databases

  • First, login to your Plesk account. If you don't have your username and password, you'll need to contact your web hosting provider.
  • Once you've logged in, click on the Databases icon. Keep in mind that your Plesk account may be using a skin or different theme depending on your host, so it will not always look exactly like the screenshot below.

Step 2. Create your Database and User

  • When you reach the next page, you will need to click on the 'Add New Database' icon.
  • Type in a name for your new database, make sure type is set to MySQL and click "OK".
  • On the next screen you should see a database created successfully message.
  • You now need to add a user. So select the "Add New Database User" icon below the success message.
  • Fill in the details on the form with your desired username and password.

You should now have all the details for your database. If you are not given a "host", try "localhost". If that does not work, you will need to contact your hosting provider to ask what you MySQL Host is.

How do I create a MySQL database in Cpanel?

Step 1. Login and select MySQL databases

  • First, login to your CPanel account. If you don't have your username and password, you'll need to contact your web hosting provider.
  • Once you've logged in, select MySQL databases from the list. Keep in mind that your Cpanel account may be using a skin or different theme, so it will not always look exactly like the screenshot below.

Step 2. Create your DB and User

  • Type in a name for your new database and click the "Add DB" button.
  • Then, type in a Username and a Password into the relative fields and click the "Add User" button.

Step 3. Set Permissions and finish

Once your Database and User have been created, you need to give that user permission to use that database. We do this by selecting the username we created from the drop down and the database we created from the drop down, making sure the "All" checkbox is selected and clicking the "Add User to DB" option.

The last thing you will need is the MySQL server hostname. If this hasn't been supplied to you by your web host, you can get it from this screen in this location:

Note that the Username and Database will be prepended with your Cpanel login name. For example, if you created a database called DB and your cpanel login was mysite then your new database will be mysite_db.

How do I edit the built in templates for individual users?

The only way to change the built in template is to edit the file on the server (edit the admin/resources/emailtemplates/{templatename}/index.html file).

When you create a new template based off that, it does not affect the built in one on the server, it creates a new one in the database which only that user can see (and the admin user of course).

Once the new template is created, it won't show up under "built in templates", but under "templates" (manage templates).

I tried changing the 'from' address in the database in the 'job list' table but when I resumed the schedule it

The string in the database is a serialized array so just changing the email address will break that so php can't decode it properly again.

To change this:

a:1:{s:5:"email";s:20:"chris@interspire.com";}

to have your email you need to change the number before the email as well:

a:1:{s:5:"email";s:16:"email@domain.com";}

16 is the length of the email address.

The from address can't be set if:

  1. php is running in safe-mode (ask your host if this is the case)
  2. your host has disabled changing the from address (it will be hardcoded to a particular value in their configuration files).

Can I have access to the layered Photoshop file for the menu navigation?

Layered Photoshop file for the menu navigation

Download Now Instant download. No email required.

How do I create a new user in a Jumpline MySQL account via ssh?

To set up a new MySQL user into your Jumpline account you will need to ssh into your server and run the following commands.

/etc/rc.d/init.d/mysqld stop
mysqld_safe --skip-grant-tables &
mysql> mysql
mysql> use mysql;
mysql> delete from user where user='username' and host='localhost';
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO user VALUES('localhost','username',PASSWORD('password'),
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
Query OK, 1 row affected, 5 warnings (0.00 sec)
FLUSH PRIVILEGES;
quit

/etc/rc.d/init.d/mysqld stop
/etc/rc.d/init.d/mysqld start