importing data from (normal) cck fields for street address and city into location cck fields

Here is the code that is seems to work for me, geocoding is working too

I've created it 2h ago, please tell me if you get any problems
Please note that I have location_cck field now attached to profile node type, that replaced my plain cck fields.

  $r = db_query("SELECT * FROM {content_type_profile}");
  
  while ($profile = db_fetch_object($r)) {
    $criteria = array(
      'genid' => 'cck:field_user_location:'. $profile->vid,
      'vid' => $profile->vid,
      'nid' => $profile->nid,
    );
    
    $location = array(
      'street' => $profile -> field_profile_street_value . ' ' . $profile -> field_profile_street2_value,
      'province' => $profile -> field_profile_state_value,
      'city' => $profile -> field_profile_city_value,
      'postal_code' => $profile -> field_profile_zipcode_value,
    );    
    
    $locations = array($location);

    location_save_locations($locations, $criteria);
    
    db_query("UPDATE {content_type_profile} SET field_user_location_lid = %d WHERE vid = %d", $locations[0]['lid'], $profile -> vid);
  }

also, try the migrate extras module:
http://drupal.org/node/459236#comment-2757412

Marking as a duplicate of #570816: Convert from CCK field to Location CCK field

I have given some explanation there but there is not really any easy solution unfortunately.

Hi Restiler,

I've tried your sql query but I get an error in line 1

Error

consulta SQL: Documentación

$r = db_query(
"SELECT * FROM content_type_business"
);

MySQL ha dicho: Documentación
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$r = db_query("SELECT * FROM content_type_business")' at line 1 

Any idea what could be wrong? my content type is called "business"

I'd be happy to pay for someone to get me this done as I've got over 2000 nodes that need importing all this data.

Hi tom_gustav,

I think yuo can use the solution here http://drupal.org/node/1041632 to update geocode.

Could you please post what mysql queries did you use to import your data?

Thanks
Manuel

Also look at comment #1 in the issue linked to in #4.

The sql part of your code looks fine, but it looks like you might be somehow passing the whole lne into mysql, not just the sql?

You don't seem to be copying restyler's code exactly.

For one you are missing the curly braces.

Try copying it exactly and only changing table and field names as required.

Hi Rooby,

Thanks for pointing this out, what I silly mistake :( I did paste it directly into the sql query form of my phpmyadmnin

I've now created a page with it give it php code input format and simply open the page within a browser ... and seems to be working to some extend, however some of the data in some of the nodes isn't being copied, I can't see why, I'll have a closer look.

I got it all working except for the "province" that it was taxonomy term id therefore it's not recognizing it.

How could sort that out?

Does the term name = the province?

If so you can get the term name from the term ID via the term_data database table.

If not you have to manually map your term ID's to their corresponding province.

Yes it does, however I've noticed that the location table saves the 3 letter code instead of the whole name, I don't know if that affects.

I wouldn't know how to change the script for that (not a programmer),

any help on this?