How to integrate with other applications

Out of the box, ProjectPipe can read and write files for:

project management - read which MS Project file formats are supported
spreadsheets - any program which can read/write csv files like MS Excel and Open Office

In general, there are two ways to integrate ProjectPipe with other applications:

Download / upload csv files
Use ProjectPipe's web service API

CSV Files

The simplest way to integrate with another application is to use csv files (comma-separated value files) as either an import or export mechanism. All major entities in ProjectPipe (i.e., Use Case, Requirement, etc.) support both importing and exporting. Exporting lets you get all your data out of ProjectPipe and accessible by any application that can read a csv file. Importing lets you bring in data from an external application. When importing, if you provide an id column then items with the corresponding id will be updated, else all new items will be added to the system.

Web Service API

Whereas integration using csv files is a manual process, integration using ProjectPipe's web services can provide an automated process. ProjectPipe's web services provides the ability to both download and upload data. In fact, you can write any type of program using your favorite programming language, including a two-way data synchronizer.