From the administrative control panel:

• “Setup” > “Import/Export” > “Import Users and/or Leads”

The program provides on-screen directions that can be used to help you with your import.

• Large files containing thousands of entries should be split into multiple files and imported separately.
• Any field within the database can be imported, however you should only include a field on the import file if you plan on importing that data.
• You can grant users access to newsletters and secure areas using the import, either by including the secure area ID and newsletter ID on the import file, or by using the “Secure Area Override” and “Newsletter Override” options provided on the import screen.
  • Secure Areas: You can find the secure area IDs by clicking on “Areas” from the admin control panel.
  • Newsletters: You can find the newsletter IDs by clicking on “Email” > “List Newsletters” from the admin control panel. However, unlike secure areas, you will need to place an upper-case ‘N’ before the newsletter ID. Example: “N15” or “N1”.
• If the program detects a username on the import file that currently exists in the database, it will update that user’s account.

Using the import feature, you can bulk delete users from your database by doing the following:

• Create a plain text file with the usernames (one-per-line) that you wish to delete
  • Note: The top line of this file needs to say username
  • Example file that would delete users “johndoe”, “janedoe”, and “chriskelley”:

username
johndoe
janedoe
chriskelley

• From the admin control panel, click on “Import/Export”, and then on “Import Users and/or Leads”
• Select the file from your local hard drive containing the users you wish to delete
• Tick the checkbox labeled “Delete Users?”
• Run the import.

• If the program detects a username on the file that is not currently in the database, it will create an account for that user.

From the administrative control panel:

• “Setup” > “Export Users”

Select your desired options and click on “Export Users”.

Note: If you have a large user/lead database, please be patient while the program compiles the data.

Once the export is complete, you will be asked to download a file. Save the file to your local hard drive and open in a program such as Excel. Note: Users and leads are exported in alphabetical order.

The program is equipped with a daily back-up utility that runs according to the cron job. All back-ups are stored within the following directory on your server:

• ppSD2/admin/imports

The filename will start with “backup” and contain the date on which the backup occurred.

In the event that you cannot find a back up file within the “admin/imports” folder, check the following:

1. Is the cron job running properly? Verify that the cron job is running by checking the “Cron Job Last Run” date found in the bottom right-hand corner of the admin control panel. If the cron job is NOT running properly:
   • Ensure that the files within /ppSD2/admin/cron directory are set to permissions 755.
   • Ensure that the full server path on the cron_overview.php file is set to the correct path for your server.
   • Contact your web host to ensure that the cron job has been properly setup.
2. Is the “imports” folder set to permissions 777?
3. Check the program options (”Setup”) to ensure that “Backup Timeframe” option is set to a reasonable timeframe (recommended every 1 day: 00 00 01 00 00 00).

If you are exporting a large database and your program is timing out, do the following:

• Using an FTP Client, log into your website’s FTP.
• Edit the file within the “ppSD2” directory named “.htaccess”
• Within the .htaccess file, find the following line and update it as follows:
  • Original Line: # php_value max_execution_time 600
  • Updated Line: php_value max_execution_time 600
• If you need to increase the execution time beyond the standard 600 seconds (10 minutes), set “600” to a higher number. Example:
  • 30 minutes: php_value max_execution_time 1800
    • 1800 = 30 minutes * 60 seconds
• Save the updates “.htaccess” file to your server and try your export again.