Teamwork export into MySQL

 

I’ve been looking at Teamwork.com as a way of managing projects but one of the things that concerned me was how I could get a copy of the data that goes onto their system. These notes help explain how to obtain a usable copy of a Teamwork project.

First go to Settings > Export and save your project as an sql file (which will be compressed within a .zip file). Then install MySQL – I used a Bitnami stack as a simple way to get everything I needed (maybe that was overkill, but it was quick and easy).

Open phpmyAdmin and log into MySQL, where in the lefthand pane you need to click New to create a new database. You don’t need to add any tables or anything. Then click on that database to select it. Go to Import on the top row of the page and choose the unzipped teamwork .sql file. Import it. It should go smoothly.

You can then expand the database in the left hand pane to see the imported tables. You can select and edit them from within the admin environment. Use Export to dump data from a selected table into a variety of formats e.g. csv, ods etc.

And that’s it!

 

Advertisements
Tagged ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: