Welcome
Developing
Learn how to develop schemas by using the DevOps Plan Designer.
Developing Schemas
You can develop or modify schemas with the DevOps Plan Designer.
Importing and exporting data
This topic describes how to import and export data between DevOps Plan databases, and how to import data into a DevOps Plan database from another defect tracking system.
Exporting data
You can export data from a DevOps Plan database.

Overview
Learn general information about the product.
Install and deploy DevOps Plan
Find information about installing and deploying DevOps Plan client and server software.
Developing
Learn how to develop schemas by using the DevOps Plan Designer.
- Developing Schemas
  You can develop or modify schemas with the DevOps Plan Designer.
  - Understanding the functions of the DevOps Plan schema developer
    This topic provides an overview of the tasks typically performed by a schema developer.
  - Overview of the DevOps Plan Designer interface
    The DevOps Plan Designer includes several different windows, or views, that you will use to perform your schema development tasks.
  - DevOps Plan schemas
    This topic explains the concept of a DevOps Plan schema.
  - Customizing a schema
    To modify how change requests are handled, you need to use the Designer to customize the records and fields of a schema.
  - Schemas and packages
    This topic explains the concept of using schemas and packages in DevOps Plan.
  - Packages and integrations
    This topic explains the concepts of DevOps Plan packages and integrations.
  - Test Management and Requests
    You can use the DevOps Plan TestManagement and Requests feature to create and track test plans and add approval processes to the record.
  - Working with Forms
    You must create a record form for each record type in your schema. You can also define a submit form for each record type.
  - Working with charts
    Charts are essential tools for visualizing data and managing projects. You can use Gantt and timeline charts for project management based on availability in different schemas.
  - Working with approvals
    Users can use Approvals to view and manage approval requests that are either pending or completed using the Pending Requests and Completed Requests tabs.
  - Creating a security model
    This topic provides an overview of the process to create a security model.
  - Using hooks to customize your workflow
    This topic provides guidelines for using hooks to implement your workflow.
  - Record locking
    When multiple users attempt to simultaneously update a record, the database locking model ensures that the update from each user succeeds as a unit, but each update overwrites the previous update.
  - Customizing the Web
    The Designer provides many ways to customize the underlying schema and functionality that the DevOps Plan Web client accesses.
  - DevOps Plan email
    This topic provides a description of the supported DevOps Plan Web client email features.
  - Importing and exporting data
    This topic describes how to import and export data between DevOps Plan databases, and how to import data into a DevOps Plan database from another defect tracking system.
    - Overview of importing and exporting data
      Using the Import and Export wizards, you can move data such as records, history, and attachments from other change request systems and between DevOps Plan databases.
    - Adding and removing code page headers from exported files
      You can use the cpheader command to add and remove data code page header information to and from exported queries, charts, reports, report formats, and form files created by using the original DevOps Plan Web client Designer.
    - Starting the import process
      This topic explains the process for exporting and importing data in DevOps Plan Web client.
    - Testing the import process
      This topic provides an overview of the steps you should follow to test the import process.
    - Creating an import schema
      Before you can import data into a DevOps Plan database, you must create an import schema or modify an existing schema to support the data to be imported.
    - Creating a database for imported data
      Before importing data into a DevOps Plan database, you must create a user database to hold the imported data and associate this database with the import schema.
    - Creating a DevOps Plan import file
      If you are exporting data from an existing DevOps Plan database, you can use the Export feature to create the import file.
    - Configuring the Import Tool
      You can customize the behavior of the Import Tool with the Import Tool preference page.
    - Exporting data
      You can export data from a DevOps Plan database.
    - Importing data into DevOps Plan
      This topic provides an overview of the steps required to import data into DevOps Plan Web client.
  - Importing data into DevOps Plan using Import feature
    The Configuration > Import feature allows teamspace admins or userdb super-users to add data to the DevOps Plan application. There are two primary methods for bulk data import: using sample data and uploading a zip file.
  - Enhancing the Export to JSON feature
    You can use the Export to JSON feature to export detailed information related to a record into a JSON format.
  - Cloning existing records
    By cloning existing records you can create an exact copy of an existing record. This ability is useful when you have to create similar records frequently, ensuring consistency and saving time.
Integrating
You can integrate DevOps Plan with other software by adding packages to existing schema.
Extending product function
Learn how to extend the product.

Exporting data

You can export data from a DevOps Plan database.

About this task

To export data from a database-supported application other than DevOps Plan, you must use the database vendor tool. See Creating a DevOps Plan import file.

To export data from an existing DevOps Plan database, use the Export feature available in either the DevOps Plan Client. The Export wizard extracts data from a DevOps Plan database into a format optimized for the Import wizard.

To prevent data corruption, take care when exporting or importing data between databases that do not have the same data code page value. If imported data might corrupt the database, an error message is displayed. For more information, see the topics listed for exporting records and queries in the online help for the DevOps Plan Client.

Procedure

To export records from a database:

Start the Client.
Run a query.
Click File > Export > Records.
In the Export wizard, select the data to export:
1. Select a record type to export.
2. Select Export all records or Export records based on an existing query.
3. Select a query (if applicable), and click Next.
Select the fields to include in the export file. Double-click or drag the fields to add them to the export file. Click Next
Select an export format. You can choose from DevOps Plan import, delimited text, and XML formats. Click Next.
Select an export directory and file name. You can also accept the default options.
Click Finish