Recently I've had to do this.  I create a Drupal Content Type using the Location Module and GMAP Module,   I created a Location CCK field and started entering (or importing) location data into the field.

Afterward, I realized that I did not really want a CCK Location Field.  Instead, I wanted to set the Locative information on the configuration page of my content type.  I did NOT want to re-key my location information, and it turns out I didn't need to.  

When you key in Location data to a location CCK field, the Location data is stored in the Location table.  It is stored in the same place when you use locative information.  The only difference is the data that is stored in the Location_Instance table.  Instead of storing a reference to the for a CCK field in genid, it stores the node id in the nid and vid fields.      

I ran the following query to take the node id from the rightmost characters of the genid and use them for the node id, and blank out the genid.  Worked like a charm... 

I found out today that the myrcpl.com site is built with Drupal.  Also found out that an old friend and co-worker from Syneractive (Scottie) helps to manage the site.  It's a great looking site and very well done. 

I love the Richland County Libary (or as Poof  would say, the lye-berry), and I love them even more now.  Next time you're in the library, tell them you love their Drupal site!

Here are the some of the blogs I've read this week and thought were worth sharing:

www.drawncloser.com - My new favorite comic strip, drawn by my friend Jimmy Steen.  You can also follow him on Twitter at @steenfamily. 

http://www.chrisbrogan.com/23-essential-elements-of-sharable-blog-posts/ - Chris has some good tips for making people want to share your blog posts.  I'm probably not following any of them right now, but for those of you trying to get started with a blog, some good advice.  Do as I say, not as I do, my Dad used to say...

https://sethgodin.typepad.com/seths_blog/2009/06/graduate-school-for-unemployed-college-students.html -  Seth Godin has some good advice for college graduates who can't find a job-- Learn something new! Volunteer!  Start a business!   Good advice for anyone, really...

I had the pleasure of listening to theDuct Tape Marketing Podcast recently, the March 23 episode featureing David Meerman Scott, who recently wrote the book called World Wide Rave.  David makes some really interesting points about how trends get started on the Internet.  He provides numerous case studies on viral videos and blog posts, and how people have used these to build their businesses. 

Examples included Blendtec, a maker of heavy-duty blenders who increased sales tenfold after creating some wacky videos and the site Will it Blend?, showing their blenders chop non-food items.  He also talks about  Helaine Smith, DMD, a Boston Dentist who quintupled her business after publishing a free e-book called "Healthy Mouth, Healthy Sex."