TweetDeck Export and Import Group Script
Love TweetDeck and wish you could import/export your Groups? Here’s a quick SQLite script that will help.
Installation
- Create a new folder (Example: c:\sqlite\).
- Download the SQLite command line program for your system and copy sqlite3.exe to the sqlite folder.
- Download the script files and extract the files to the sqlite folder.
- 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.
- 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
- Drag and drop the file groupbld.sql onto the sqlbatch.cmd file.
- A new file will be created named, updgroups.sql.xls.
- This is a text file, but it can also be opened in Excel. You can modify it in Excel or in a text editor.
- If you run this script without any modifications, all of your friends will be added to the group.
- Remove each friend who should not be added to the group by deleting the row that contains his or her user name.
- 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
- Save the file as a text file and exit Excel.
- Open the text file again in a text editor (such as Notepad) and perform a global replace to remove all of the double-quotes (‘”’).
- Important: Backup your current TweetDeck database by copying the database file.
- 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.
swhitley (Shannon Whitley) said,
Wrote on February 19, 2009 @ 2:21 pm
Twitter Comment
Import and Export your TweetDeck Groups – [link to post]
– Posted using Chat Catcher
HighTechDad (Michael Sheehan) said,
Wrote on February 19, 2009 @ 2:27 pm
Twitter Comment
RT @swhitley: Import and Export your TweetDeck Groups – [link to post] [VERY COOL!]
– Posted using Chat Catcher
applemacbookpro (adamjones) said,
Wrote on February 19, 2009 @ 2:29 pm
Twitter Comment
RT @Avinio: RT @swhitley: Import and Export your TweetDeck Groups [link to post]
– Posted using Chat Catcher
alex_sanderson (Alex Sanderson) said,
Wrote on February 19, 2009 @ 7:34 pm
Twitter Comment
@epizoic try this to export groups [link to post]
– Posted using Chat Catcher
liborkriz (Libor Kriz) said,
Wrote on March 9, 2009 @ 1:09 am
Twitter Comment
TweetDeck: Easy Backup and Restore? http://is.gd/huGT — TweetDeck: Export and Import Group Script? [link to post] #TweetDeck
– Posted using Chat Catcher
VegasBill (♠ Vegas Bill ♣) said,
Wrote on March 9, 2009 @ 1:18 am
Twitter Comment
RT @liborkriz: TweetDeck: Backup + Restore: http://is.gd/huGT – TweetDeck: Export + Import Group Script? [link to post] #TweetDeck
– Posted using Chat Catcher
VirtualLee (Barbara McMillen) said,
Wrote on March 12, 2009 @ 2:49 am
Twitter Comment
Re: photo [link to post] Go down to SPIURL @swhitley interesting, thanks.
– Posted using Chat Catcher
CMChadwick (Chris Chadwick) said,
Wrote on March 15, 2009 @ 4:30 pm
Twitter Comment
TweetDeck Export and Import Group Script [link to post]
– Posted using Chat Catcher
Nick D said,
Wrote on March 31, 2009 @ 7:33 am
hi
great scripts.
when i drag ‘groupbuild.sql’ – and it generates the full list of users – it appears to list *everyone ive ever followed* – not everyone im following now.
any idea why?
Nick D said,
Wrote on March 31, 2009 @ 12:54 pm
The script is running without error – but nothing is appearing in the group
any ideas?
first delete command doesnt even seem to work. group name is definitely correct.
Shannon said,
Wrote on March 31, 2009 @ 1:06 pm
Hey Nick
Make sure you’re pointing to the right database. (sounds like you are)
The name of the group should not include the braces ‘{‘ or ‘}’ (hope that’s clear).
Nick D said,
Wrote on March 31, 2009 @ 1:12 pm
ahh sorry – i thought it should include the {}.
works well – thanks a lot!
Benjamin Teo said,
Wrote on April 6, 2009 @ 9:15 pm
I tried everything as mentioned step by step, but still didn’t work for exporting, it just exported my entire friends list….
Nick D said,
Wrote on April 7, 2009 @ 12:41 am
you have to edit the list thats generated leaving only the people you want.
also does it raise an error in the command window?
Mitchell McKenna said,
Wrote on April 13, 2009 @ 10:56 am
I’m unable to find the tweetdeck sqlite directory in ubuntu/linux
any ideas?
I found…
/opt/TweetDeck/share/META-INF/AIR/tweetdeckfast.f9107117265db7542c1a806c8db837742ce14c21.1.directory
but it says it’s not a folder :S
A call for twitter clients interoperability « Webtropic said,
Wrote on April 16, 2009 @ 4:06 pm
[...] Some people have
staticnrg (Robin) said,
Wrote on May 6, 2009 @ 1:48 pm
Twitter Comment
@davemunger @iwilker [link to post]
– Posted using Chat Catcher
chrysanthalbee (chrys anthalbee) said,
Wrote on May 30, 2009 @ 11:53 am
Twitter Comment
this could be very helpful if you use #tweetdeck: TweetDeck Export and Import Group Script [link to post] (via @swhitley)
– Posted using Chat Catcher
deuts said,
Wrote on May 30, 2009 @ 10:54 pm
I think that’s overkill. Too much to do. I guess I’ll just keep my customizations to the minimum with tweetdeck so that not much problem when switching from home and office machines and the various linux operating systems.
James Paden said,
Wrote on August 16, 2009 @ 11:53 am
Thanks, that was a big help!
tommytrc (thomas clifford) said,
Wrote on September 7, 2009 @ 6:02 am
Twitter Comment
@ToddBrink [link to post]
– Posted using Chat Catcher
toddbrink (Todd Brink) said,
Wrote on September 7, 2009 @ 6:37 am
Twitter Comment
@tommytrc Thanks tommy….have you used it?
– Posted using Chat Catcher
tommytrc (thomas clifford) said,
Wrote on September 7, 2009 @ 7:43 am
Twitter Comment
@ToddBrink No I have not, I just googled it for you…
– Posted using Chat Catcher