PHP Application Turns MySpace Friends Into CSV – View/Mine in Excel Spreadsheet Etc

My friend threw together an app that scrapes your MySpace contacts and puts useful info into a reusable format.


UPDATE: It’s also available as a Torrent via The Pirate Bay. Please consider seeding this. It’s a tiny, tiny file.

Here’s the Read Me info I just put together to go with it:

and change those.
Save the file.
Upload these two files to your server.
point your web browser to http://where-you-put-the-file-on-your-server/ms_test.php
and what will result is a CSV file of all your MySpace friends and their demographic information. Also included is the URLs to “send message” etc, and some other useful things.
View the source of the page and copy it into a PlainText text file
Name the text file with the extension .csv
Now you should be able to work with your myspace friends in Excel

There is nothing malicious about this simple application. No viruses, spyware etc. It only does what it’s supposed to do: scrape your friends so you can more easily work with your social network data.

If you are of the camp that feels that people scraping their own myspace contacts is unethical, I suggest that you consider that all the pages are already available and the data they contain is rendered in HTML which can be freely accessed already. This is just a tool to make it easier to get the useful data separated from the clutter.

Finally, this is possibly against MySpace’s Terms Of Service, so use at your own risk.

7 Replies to “PHP Application Turns MySpace Friends Into CSV – View/Mine in Excel Spreadsheet Etc”

  1. One thing it needs is to change commas in city/states in profile. When opening in excell, some fields are off because of the commas in the profiles. Just a thought. 4Am here, I hope that made sense :P

  2. I know what you’re talking about and thanks for participating, Daniel G.
    I think the issue has to do with the grep expressions, and possibly the fact that band/filmmaker profiles might be laid out a little differently.
    My understanding is that this info is being scraped from the TITLE of the page.
    The thing is, my friend who wrote this is a full time student and doesn’t have a lot of time to devote to ongoing tweaking of this. And surely myspace will be changing their url strings soon and everything will break.
    I think maybe we should move to a forum or a work-group of some sort so we can create a distributable conversation. That way, you can get updates as coders who decide to participate in keeping the dream alive volunteer their contributions.
    Any suggestions on a preferred platform for open discussion?

  3. I think the problem with the BET profile is that they don’t have their genre listed. Normally there is a classification like “Indie / Rock / Retro”. These problems will crop up sometimes with profiles, because the TITLE data is formatted like

    “A – B – C – D – E”

    From a programming standpoint this difficult to distinguish from

    “A – C – D – E”

    and there will sometimes be issues. Luckily the overwhelming majority of profiles fit a certain structure, so it should work fine for 98% of your contacts. Let me know if you find any other issues (I just accepted your friendship on MySpace if you want to message me there).

    I wish that the foafr forum still worked.. I’m trying to work out a database error that seems to have been caused by GoDaddy upgrading (or downgrading) their MySQL installation. If I can figure that out we should move it over there.

Leave a Reply

Your email address will not be published. Required fields are marked *