Here is some software you can purchase if you want to do it yourself

Dry Toast Version 1.2g ThickToast Tool No. 1 more here.

View BaseCamp™ data in an Access database Description: A system to load your BaseCamp XML export/backup into an Access database. The software will load the Project information, replace all the Todo's and Milestones and append the Timesheet and Messages and handle all the other little tables correctly. Included with the software is a properly structured backend database, a compiled library file and a front-end database. Otherwise try Butter to get on top of your Todo's offline, head to a meeting with a decent printout of tasks by person

Order Software here (upto 35 projects) or Unlimited Projects or Paypal (35 projects)
(remember to follow instructions below)
 

To use this software, you will need (in order)   Microsoft Access 2002, 2003 or 2007 One of the users to be the Basecamp administrator. Windows XP operating system: Download and Install MSXML6.msi from Microsoft Windows Vista: You do not need to install MSXML6.msi (as it is installed already as part of the Operating System).   You need to Order a copy of Dry Toast. After purchasing the software we will send you the files to allow you to load all your projects.   Run the setup executable in the zip file. This installs software and databases in c:\vb123\toast\.  Open DryToast.mdb in that folder.   If using Access 2007, you will need to create a Trusted folder for the databases. More on this at Microsoft  See a picture of a trusted folder called c:\vb123 Creating and Loading a Basecamp XML Backup File   ThickToast makes use of the Basecamp XML backup system. Go to the bottom of the Accounts tab in the main dashboard to create the XML backup. The following figures show how to retrieve an XML zip Export and load it using our DryToast software          Account Tab            Create XML Export    Open and save XML into Database     Open DryToast        Select XML or ZIP file and it loads into our structure database. Once The Data Is Loaded We have programmed the loading process so that primary keys are handled correctly (see msgs sample), also we reload ToDos and Milestones so that completed information is stored correctly. Most importantly to us, we don't touch the timesheet entries so that they are never deleted accidentally and that makes us money when we bill our clients.

 

Once you open the tables, we have setup combo boxes so that you know what the integer numbers mean when you look at a record. Without this, you need to understand the database Relationship model intimately.

On the main form, you will find a number of queries that help you review the information in your database. In a Nutshell, we have been using the XML download for important tasks in our business for 12 months now. This has forced us to really understand the Basecamp XML download file and how to deploy it to our database. Click here for samples of things that we have done with the backup database. Why Bother With XML Backups? 37 Signals promise full backups and retrievals and they certainly use superb file services from RackSpace and Amazon to achieve this. But what happens when you accidentally delete a project or a message thread or a timesheet entry (5hrs *$50 per hour = $250).  I am sure that you understand the implications.

 

So to get around this you need to download the XML backups on a regular basis, if you check out the XML, it will be very large and it will look like this, good luck retrieving your lost data in that format.

The next thing you can do is import the XML into a database like MS Access. This will work for a lot of the tables but it has a few problems.  If you import again, you will get repeated records because there are no primary keys in the table or you will not get vital information such as whether the ToDos have been completed because the primary key has been added. Also if you think you can use export to CSV for timesheets, remember that BaseCamp Timesheet CSV backups are restricted to 3 months of data so managing this is tricky when it comes to recoveries.