Shannon Whitley

Love TweetDeck and wish you could import/export your Groups?  Here’s a quick SQLite script that will help.

Installation

1. Create a new folder (Example: c:\sqlite\).
2. Download the SQLite command line program for your system and copy sqlite3.exe to the sqlite folder.
3. Download the script files and extract the files to the sqlite folder.
4. Modify sqlbatch.cmd.  The default commands are for Windows XP, but they are basic commands that should convert easily for any operating system.  You’ll need to find your TweetDeck database and ensure that SQLDIR and DBNAME point to the right locations.  Replace “{Your Screen Name}” (including the braces ‘{}’) with your Twitter user name.
5. Modify groupbuild.sql.  Find “{Group Name}” and replace the text (including the braces ‘{}’) with the name of your group.  The text occurs twice in the file.  The group must already exist.

Export

1. Drag and drop the file groupbld.sql onto the sqlbatch.cmd file.
2. A new file will be created named, updgroups.sql.xls.
3. This is a text file, but it can also be opened in Excel.  You can modify it in Excel or in a text editor.
4. If you run this script without any modifications, all of your friends will be added to the group.
5. Remove each friend who should not be added to the group by deleting the row that contains his or her user name.
6. Deleting:  This script deletes the current group membership.  Remove the first row of the script if you do not want to delete current group members (you only want to add to the group).

Final Edits and Import

1. Save the file as a text file and exit Excel.
2. Open the text file again in a text editor (such as Notepad) and perform a global replace to remove all of the double-quotes (‘”’).
3. Important:  Backup your current TweetDeck database by copying the database file.
4. If you are satisfied with your new script file.  Drag and drop it onto sqlbatch.cmd and the new members will be imported into your TweetDeck group.

Rerun the process for other groups, changing the group name in the groupbuild.sql file.