| Drag anywhere on this popup to move it
Case Study: Google Docs access to BaseCamp Data
Problem
Our client was a heavy user of BaseCamp (Projects, ToDos, Milestones) and wanted to be able to report on all activity in a Google Docs dashboard.
They had started working on the Javascript interface but had run into problems getting the data they wanted.
Solution
We created a Javascript module which accesses the BaseCamp API and extracts all the relevant data in a modular, reusable form. Projects, People, ToDo Lists, ToDos,
and Milestones are collected across all of their BaseCamp projects, and then provided to the Google Docs spreadsheet via a single "Dashboard" function which combines all
the relevant information. This includes scanning -- in a single call -- BaseCamp for all ToDos assigned to all people, and all Milestones across all Projects.
Results
Our client is now able to quickly and easly import all the required information and display the important information for all projects, rather than being limited to
the default BaseCamp approach of one person or one project at a time.
| Drag anywhere on this popup to move it
| Drag anywhere on this popup to move it
Software Company Mentoring
Problem
The company offered educational products and consulting & development services around a well-known company's product. To expand their
capabilities, the founders realized that they needed to bring new software develoment resources on board and they needed assistance in selecting the
right candidate and organizing and managing the development function.
Solution
We were initially engaged to help them identify, interview, and set direction for the software engineer, which was quickly completed through
our extensive network. We then began helping them by analyzing the company's past and current direction to make sure that the direction they
were taking was properly focused. Based on that assessment, we then facilitated a company planning process, which resulted in a working plan.
In the process, they identified the need to consolidate their efforts, reduce the number of brands they were attempting to manage (from 4 to 2) and
dropped several activities that were not profitable.
Results
The company has implemented a major new software application which has provided a 10:1 productivity improvement in their service delivery process.
This has allowed them to compete successfully for significant new business with new clients. They have instituted regular operational review meetings
in order to execute effectively against their company plan, and have increased revenues & profitability.
| Drag anywhere on this popup to move it
| Drag anywhere on this popup to move it
Web/Security Remediation
Problem
Our client ran a suite of coordinated web properties that offered collaboration, blogging, and technical resources to a large IT community. The
site had originally been buit in legacy ASP and extended over the years with little thought for security. Unfortunately, this was discovered
and attacked from several foreign sites, with the result that the code and database were all widely infected with attack code and millions of porn links uploaded.
Solution
We worked with a team of experts to locate and eradicate the various infection vectors, clean up the database, and get the site back online.
Our activities included: damage assessment and project management; bringing up and securing new servers; providing secure development access to the new environment;
SQL database scanning and cleansing; coding recommendations to prevent future SQL injection and other attacks.
Results
The client was able to rebuild the suite of web properties and bring them back online, essentially intact and with minimal loss of data.
| Drag anywhere on this popup to move it
edp consulting, inc.
3373 Guido Street
Oakland, CA 94602
Tel: 510-530-6314
Fax: 510-531-1522
Contact Us
|
|
© 1997, 2003, 2010 edp consulting inc. All rights reserved.
|
|