TweetDeck Export and Import Group Script

February 19, 200923 Comments

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).

excel

 

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.

Share

, , , , , Software Development

9 Responses to “TweetDeck Export and Import Group Script”

  1. swhitley (Shannon Whitley) says:
    February 19, 2009 at 2:21 pm

    Twitter Comment


    Import and Export your TweetDeck Groups – [link to post]

    – Posted using Chat Catcher

    Reply
  2. HighTechDad (Michael Sheehan) says:
    February 19, 2009 at 2:27 pm

    Twitter Comment


    RT @swhitley: Import and Export your TweetDeck Groups – [link to post] [VERY COOL!]

    – Posted using Chat Catcher

    Reply
  3. applemacbookpro (adamjones) says:
    February 19, 2009 at 2:29 pm

    Twitter Comment


    RT @Avinio: RT @swhitley: Import and Export your TweetDeck Groups [link to post]

    – Posted using Chat Catcher

    Reply
  4. alex_sanderson (Alex Sanderson) says:
    February 19, 2009 at 7:34 pm

    Twitter Comment


    @epizoic try this to export groups [link to post]

    – Posted using Chat Catcher

    Reply
  5. liborkriz (Libor Kriz) says:
    March 9, 2009 at 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

    Reply
  6. VegasBill (♠ Vegas Bill ♣) says:
    March 9, 2009 at 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

    Reply
  7. VirtualLee (Barbara McMillen) says:
    March 12, 2009 at 2:49 am

    Twitter Comment


    Re: photo [link to post] Go down to SPIURL @swhitley interesting, thanks.

    – Posted using Chat Catcher

    Reply
  8. CMChadwick (Chris Chadwick) says:
    March 15, 2009 at 4:30 pm

    Twitter Comment


    TweetDeck Export and Import Group Script [link to post]

    – Posted using Chat Catcher

    Reply
  9. Nick D says:
    March 31, 2009 at 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?

    Reply
  10. Nick D says:
    March 31, 2009 at 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.

    Reply
  11. Shannon says:
    March 31, 2009 at 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).

    Reply
  12. Nick D says:
    March 31, 2009 at 1:12 pm

    ahh sorry – i thought it should include the {}.

    works well – thanks a lot!

    Reply
  13. Benjamin Teo says:
    April 6, 2009 at 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….

    Reply
  14. Nick D says:
    April 7, 2009 at 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?

    Reply
  15. Mitchell McKenna says:
    April 13, 2009 at 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

    Reply
  16. A call for twitter clients interoperability « Webtropic says:
    April 16, 2009 at 4:06 pm

    [...] Some people have

    Reply
  17. staticnrg (Robin) says:
    May 6, 2009 at 1:48 pm

    Twitter Comment


    @davemunger @iwilker [link to post]

    – Posted using Chat Catcher

    Reply
  18. chrysanthalbee (chrys anthalbee) says:
    May 30, 2009 at 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

    Reply
  19. deuts says:
    May 30, 2009 at 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.

    Reply
  20. James Paden says:
    August 16, 2009 at 11:53 am

    Thanks, that was a big help!

    Reply
  21. tommytrc (thomas clifford) says:
    September 7, 2009 at 6:02 am

    Twitter Comment


    @ToddBrink [link to post]

    – Posted using Chat Catcher

    Reply

Leave a Reply

Twitter Tweet This

14 Trackbacks

  1. swhitley (Shannon Whitley)

    Twitter Comment


    Import and Export your TweetDeck Groups – [link to post]

    – Posted using Chat Catcher

  2. HighTechDad (Michael Sheehan)

    Twitter Comment


    RT @swhitley: Import and Export your TweetDeck Groups – [link to post] [VERY COOL!]

    – Posted using Chat Catcher

  3. applemacbookpro (adamjones)

    Twitter Comment


    RT @Avinio: RT @swhitley: Import and Export your TweetDeck Groups [link to post]

    – Posted using Chat Catcher

  4. alex_sanderson (Alex Sanderson)

    Twitter Comment


    @epizoic try this to export groups [link to post]

    – Posted using Chat Catcher

  5. liborkriz (Libor Kriz)

    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

  6. VegasBill (♠ Vegas Bill ♣)

    Twitter Comment


    RT @liborkriz: TweetDeck: Backup + Restore: http://is.gd/huGT – TweetDeck: Export + Import Group Script? [link to post] #TweetDeck

    – Posted using Chat Catcher

  7. VirtualLee (Barbara McMillen)

    Twitter Comment


    Re: photo [link to post] Go down to SPIURL @swhitley interesting, thanks.

    – Posted using Chat Catcher

  8. CMChadwick (Chris Chadwick)

    Twitter Comment


    TweetDeck Export and Import Group Script [link to post]

    – Posted using Chat Catcher

  9. A call for twitter clients interoperability « Webtropic

    [...] Some people have

  10. staticnrg (Robin)

    Twitter Comment


    @davemunger @iwilker [link to post]

    – Posted using Chat Catcher

  11. chrysanthalbee (chrys anthalbee)

    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

  12. tommytrc (thomas clifford)

    Twitter Comment


    @ToddBrink [link to post]

    – Posted using Chat Catcher

  13. toddbrink (Todd Brink)

    Twitter Comment


    @tommytrc Thanks tommy….have you used it?

    – Posted using Chat Catcher

  14. tommytrc (thomas clifford)

    Twitter Comment


    @ToddBrink No I have not, I just googled it for you…

    – Posted using Chat Catcher