PMD Database Import Instruction

CSV Import Instructions

Before we proceed to the import instruction below, we would like to express the importance of a BASIC listing import rather than a detail listing import. If your PMD site is either new or have no listings, importing this database will help with user confidence that your directory is worth using because they see existing listings. You are basically using this database as a FREE listing to populate your directory so why add anything more than the basic contact information. This way, businesses will tend to upgrade their listing to stand out from the crowd. You can also place Google Adsense codes within your free listings to help generate an extra income. Once the business upgrade their account to a PAID listing, it is suggested that you remove the Google Adsense for that membership level.

Getting Ready:

There are a few things you need to verify to make sure you don't get duplicate listings when importing to PMD. Our database is sorted with the following fields for COUNTRY, STATE and CITY.

COUNTRY: We use " USA " instead of "United States".
STATE: We use " CA " instead of California.
CITY: We use " Location Text " instead of the City field.
( To enable the location text in your admin area go to Configuration->Settings->Locations and check that "Allow Location Text" is set to "YES". )

PLEASE NOTE FOR USA DATABASE ZIP CODE State of NJ

06752 (for instance) is showing up in your database as 6752.

MYPHPAdmin code

UPDATE `pmd_listings` SET `listing_zip`= CONCAT('0',`listing_zip`) WHERE CHAR_LENGTH(listing_zip)=4

STEP 1

Log into your admin account and click on Other Tools->Import Manager (see picture below)

STEP 2

Select "No" then locate your csv file from your local computer to upload by clicking the "Browse" button..
IMPORTANT: Make sure you select a comma delimiter then cllick "Load File". (see picture below)

STEP 3

Once the file is loaded, you will see the Field Name and Column Name. By choosing the correct column name, this tells PMD which column from the database you want to put for each field in the directory. Select all the fields you see in RED outline boxes and click on "Upload" (see picture below)

For our new and improved UK please follow the image below as the UK database has extra entries.

This will begin the import process. Please allow the import to finish before closing the page. The page may refresh during the import to prevent browser timeout.

Congratulations! That's all there is to it! If you feel that you still need help to import the database. Please feel free to contact us for assistance. We charge a nominal fee of $5.00 per import.