Getting your Groups out of TweetDeck… Again!
If you are a regular on Twitter, you’ve probably heard about the new feature that is currently getting rolled out to more and more users: Lists. On the surface, they look pretty much like the TweetDeck groups, but once you start digging a bit deeper, there are a number of things that you can do with lists that are not possible with groups.
Even though the TweetDeck folks have indicated that lists will be added to TweetDeck soon, I did not want to wait, to get my TweetDeck groups into Twitter lists.
I’ve written a number of posts before that explained how to extract group information from TweetDeck and other Twitter applications, we can use these techniques to extract the group members and use the Twitter API to create new list and fill these lists with users.
This time, I will do this using the Mac version of TweetDeck – mainly because every Mac comes with all the parts that are necessary to accomplish this task (Perl, sqlite3), but also because I needed it for the Mac, and just did not have time to look at a Windows based solution yet.
Getting Our Hands Dirty
Download this Perl script, copy it to your Mac and rename it to TD2TL.pl:
Then edit the file and provide your Twitter username and password – potentially you also need to modify the path to the TweetDeck database file. I’ve only tried this on a few TweetDeck installations, and it seems to work, but if things go wrong, find that file and modify that path as well.
The next step is easy: Just run the program from the command line by either making it executable, or by calling Perl with the program file on the command line:
chmod 755 ./TD2TL.pl
./TD2TL.pl
perl ./TD2TL.pl
While the script is running, it will report what it’s doing (e.g. creating a list, or adding users to a list). Once it’s done, you will have these groups available as Twitter lists – without the hassle to go through all your 1000 followed Tweeters and manually assign them to lists.