supernova42

I went on to use ‘Basic Google Maps Placemarks’
It works really well.
I get users of my boating website to enter the Lat and Long of where their boat is moored and I use it to generate a placemark on GoogleMaps.
The placemaps are world wide.
Cheers

Thanks for your response
I am not getting any errors
I have renewed my MailChimp Lists and all went OK

These are my selections on the User Sync page
Enable Auto Sync: YES
Sync User With This List: MQRA
Double Opt-In: NO
Role To Sync: All Roles
Send Additional Fields: None defined
Users Must Opt-In: NO
I carried out a Manual Synchronisation and all went well.

When I log into my MailChimp account the list is not being updated and is not synchronising with my WordPress site.

Does the latest Participants Database upgrade resolve this problem Roland.
i.e.
customized datatype parameters won’t be reverted when the field definition is saved #1717
Thanks

This is my finished function. Basically users input details of their boat into the website. Data is stored in Participants Database. The user also inputs the Lat and Long of their boat. The routine below creates a PlaceMarker page for the users details and the PlaceMarker is displayed on the Google Map. I have a lot of subscribers and as more users enter their details the number of PlaceMarkers grows.

[insert_php]
/* Update Members Details */
$current_user = wp_get_current_user();
$user_name = $current_user->user_login;
$user_id = Participants_Db::get_record_id_by_term(‘username’, $user_name);
$record = Participants_Db::get_participant( $user_id );
echo do_shortcode(‘[pdb_record tabs=true record_id=’.$user_id.’]’);

/* Update Najad Yacht Position and PlaceMarker */
$current_user = wp_get_current_user();
$id = $current_user->id;
$boatdata = Participants_Db::get_participant($id);
$boat_name = $boatdata[‘boat_name’];
$home_port = $boatdata[‘home_port’];
$model = $boatdata[‘model’];
$latitude = $boatdata[‘latitude’];
$longitude = $boatdata[‘longitude’];

if (!empty($boat_name) &&
!empty($home_port) &&
!empty($model) &&
!empty($latitude) &&
!empty($longitude) &&
($latitude <> ‘0’) &&
($longitude <> ‘0’) )
{

/* Find existing Post ID and delete Post */
$mypost = get_page_by_title($boat_name, ”, ‘bgmp’ );
$post_id = $mypost->ID;
wp_delete_post($post_id);

/* Create new PlaceMark */
$author_id = 1;
$post_id = wp_insert_post(
array(
‘comment_status’ =>’closed’,
‘ping_status’ =>’closed’,
‘post_author’ => $author_id,
‘post_name’ => $slug,
‘post_title’ => $boat_name,
‘post_content’ => $home_port.'<br />’.$model,
‘meta_input’ => array(
‘bgmp_address’ => $latitude.’,’.$longitude,
‘bgmp_latitude’ => $latitude,
‘bgmp_longitude’ => $longitude),
‘post_status’ => ‘publish’,
‘post_type’ => ‘bgmp’) );
}
else {echo ‘Information has not been entered…’;}
[/insert_php]

Absolutely fantastic – I can now transfer all my WordPress users to the Participants Database without using csv exports and imports. As new users join the WordPress site, I can just run this function to transfer their data to the Participants Database.

Many Thanks Roland, I really appreciate your assistance…

[insert_php]
echo ‘<b>Creating New PD Records for the following WordPress Users</b><br /> ‘;
for ($id=1; $id<=1000; $id++) {
$user = get_user_by( ‘id’, $id );
$wp_id = $user->id;
$wp_username = $user->user_login;
$wp_email = $user->user_email;
$wp_first_name = $user->user_firstname;
$wp_last_name = $user->user_lastname;

if (!empty($wp_username)) {
$user_id = Participants_Db::get_record_id_by_term(‘username’, $wp_username);
if (empty($user_id)) {
echo $wp_id.’ : ‘.$wp_username.’ : ‘.$wp_email.’ : ‘.$wp_first_name.’ ‘.$wp_last_name.'<br />’;
$data=array(‘wp_id’ => $wp_id,’username’ => $wp_username,’email’ => $wp_email,’first_name’ => $wp_first_name, ‘last_name’ => $wp_last_name);
Participants_Db::write_participant($data);
}
}
}
[/insert_php]

$wp_first_name = $user->user_firstname;
$wp_last_name = $user->user_lastname;