Social Graph Project – Exporting Data from Linked In (2 of 5)

In the first entry I discussed an overview of my social graphing project.  This entry will get into the first step to actually make it happen.

Of the two social networks I will discuss, LinkedIn makes exporting data quite easy, both the process to export and providing a readable, usable file. The instructions to get your data out are located on LinkedIn here or take a look the screenshot.

You then need to visit the link to “Download your data” and for this project you only need to export connections as show here:

Once you receive the data you will get a csv file that looks something like this:

Before importing this into google, you want to make some small edits:

  1. Change the column header for “Position” to “Job Title.” If you don’t position will wind up in the wrong place in your imported entries.
  2. You can’t see this in the example because the LOTR characters don’t have Professional Certifications (PhD, MPH, PE, etc.), but LinkedIn appends them to your last name.  To make merging easier remove them in the csv.  If you have a lot, you can probably write a function using RIGHT() and FIND(“,”,…).
  3. Unfortunately, there is no equivalent in google contacts for “Connected On” so you can either delete that column or it will be added to the “Notes” field after importing.

After that you can simply import this data into your google contacts by following these instructions.  Later on we will have to clean up the import with some merging, but we will touch on that in a later entry.

Next time, I will review how to get your Facebook data.  Don’t worry, it will be awful.

Social Graph Project (1 of 5)

One of the first projects I wanted to share was how I created my social graph.  This was something that I started on at my last session with ELP as a way to better understand network weaving. 

The social graph was a great exercise to keep track of connections I made throughout my career, keep track of important details about people I work with, find whether other connections existed in my social graph, and refresh my mind about connections that have not been kept up.

I am going to write a few entries outlining a step by step process for collecting data from LinkedIn and Facebook, merging that into Google Contacts, then using that in, which was the social graphing software that I relied on from this project.

And so you can get a taste for the final product, here is a screenshot from the social graph I put together.  It’s like a coral reef!

The Welcome Mat

Hello World! 

I am starting a blog.  This isn’t my first dalliance with blogging, but I think I realized that the best thing to do is not be limiting.  In the past I have had several blogs that died quickly, mostly because they were very specific topically, and when that ran out or I wanted to discuss something else I stopped writing.  The only one I have ever kept going was , which I kept pretty open.

Another impetus for starting this was my recent learning experience with the Environmental Leadership Program.  Through that program I learned a bit about strengths and communication and one realization that was made is I did have some knowledge to share, but that time was not available to implement everything that I wanted, thus the need to share. And thus this blog.

I hope to put up coding projects, ideas for social media campaigns, letters I write, and general essays.  No set scheduled, but it is my intention to write one post per fortnight.  Overall, the posts will probably be geared towards environmental work though.