Import a csv of location data into Wordpress. Data is formatted to work with the SimpleMap plugin. Depends on the wordpress_xmlrpc and pygeocoder libraries.

locations.csv

locations.py

import csv
from urllib import quote_plus
from pygeocoder import Geocoder
from wordpress_xmlrpc import Client, WordPressPost
from wordpress_xmlrpc.methods.posts import NewPost, EditPost
from settings import settings


def save_row(row, wp):
    # Parse location data from row
    location = {
        'name': row.get('Name', ''),
        'category': row.get('Category', '').replace('&', '&'),
        'address': row.get('Address', ''),
        'city': row.get('City', ''),
        'zip_code': row.get('Zip Code', ''),
        'state': row.get('State', 'CA'),
        'country': row.get('Country', 'US'),
        'phone': row.get('Phone Number', ''),
        'url': row.get('URL', ''),
    }

    # Geocode address to get coordinates
    address_str = '%s, %s, %s, %s' % (location['address'], location['city'], location['state'], location['zip_code'])
    results = Geocoder.geocode(address_str)
    location['latitude'] = results[0].coordinates[0]
    location['longitude'] = results[0].coordinates[1]

    # Create the post object
    post = WordPressPost()
    post.post_status = 'publish'
    post.post_type = 'sm-location'
    post.title = location['name']

    # Set the custom field values
    post.custom_fields = []
    post.custom_fields.append({
        'key': 'location_address',
        'value': location['address']
    })
    post.custom_fields.append({
        'key': 'location_city',
        'value': location['city']
    })
    post.custom_fields.append({
        'key': 'location_zip',
        'value': location['zip_code']
    })
    post.custom_fields.append({
        'key': 'location_state',
        'value': location['state']
    })
    post.custom_fields.append({
        'key': 'location_country',
        'value': location['country']
    })
    post.custom_fields.append({
        'key': 'location_lat',
        'value': location['latitude']
    })
    post.custom_fields.append({
        'key': 'location_lng',
        'value': location['longitude']
    })
    post.custom_fields.append({
        'key': 'location_phone',
        'value': location['phone']
    })
    post.custom_fields.append({
        'key': 'location_url',
        'value': location['url']
    })

    # Set the taxonomy terms
    post.terms_names = {
        'sm-category': [location['category']]
    }

    # Save the post
    try:
        post.id = wp.call(NewPost(post))
        print 'Saved ID %s: %s' % (post.id, post.title)
    except Exception, e:
        print 'Error Saving: %s \n %s' % (post.title, e)


if __name__ == "__main__":
    wp = Client(settings['endpoint'], settings['username'], settings['password'])

    with open(settings['locations'], 'r') as f:
        reader = csv.DictReader(f)

        for row in reader:
            save_row(row, wp)

settings.py

settings = {
    'locations': 'PATH_TO_YOUR_CSV',
    'endpoint': 'URL_OF_XMLRPC_ENDPOINT',
    'username': 'YOUR_USERNAME',
    'password': 'YOUR_PASSWORD',
}