ImportProjectEx Method

Description

Creates a new project and retrieves project properties.

Syntax

Visual Basic
Public Sub ImportProjectEx( _ ByVal DomainName As String, _ ByVal ProjectName As String, _ ByVal DbType As Integer, _ ByVal DbServerName As String, _ ByVal AdminUser As String, _ ByVal AdminPassword As String, _ ByVal TableSpace As String, _ ByVal TempTableSpace As String, _ ByVal TableSpaceSize As Long, _ ByVal TempTableSpaceSize As Long, _ ByVal CreationOptions As Long, _ ByVal replaceProject As Boolean, _ ByVal FileName As String _ )

Visual Basic

Public Sub ImportProjectEx( _
   ByVal DomainName As String, _
   ByVal ProjectName As String, _
   ByVal DbType As Integer, _
   ByVal DbServerName As String, _
   ByVal AdminUser As String, _
   ByVal AdminPassword As String, _
   ByVal TableSpace As String, _
   ByVal TempTableSpace As String, _
   ByVal TableSpaceSize As Long, _
   ByVal TempTableSpaceSize As Long, _
   ByVal CreationOptions As Long, _
   ByVal replaceProject As Boolean, _
   ByVal FileName As String _
)

Parameters

DomainName

The logical group of projects in the ALM database.

ProjectName

The name of the project in the ALM database.

DbType

The type of database. Use the following constants or their values:

SA_MSSQL_DB_TYPE (value: 2)
SA_ORACLE_DB_TYPE (value: 3)

DbServerName

The database server name.

AdminUser

The database administrator user name.

AdminPassword

The database administrator password.

TableSpace

Storage on disk of Oracle database tables. If not Oracle, pass empty string ("").

TempTableSpace

Temporary storage location on disk for Oracle. If not Oracle, pass empty string ("").

TableSpaceSize

No longer in use. Pass zero (0).

TempTableSpaceSize

No longer in use. Pass zero (0).

CreationOptions

One or more of the values:

SA_PROJECT_CREATION_NONE
SA_ACTIVATE_NEW_PROJECT
SA_CREATE_VERSION_CONTROL_DB

Of the SA_COPY_PROJECT_OPTIONS Enumeration.

To specify both ACTIVATE and CREATE_VERSION_CONTROL, OR the options together:

(SA_ACTIVATE_NEW_PROJECT Or SA_CREATE_VERSION_CONTROL_DB)

replaceProject

If true, overwrite the existing data.

FileName

The full path name of the file into which to export the project data. The file has a QCP extension.

Return Type

On success, returns an XML string containing the project properties.

Return Value Details

The properties of the XML return string:

PROJECT_ID - The ID number of the project.
PROJECT_NAME - The project name.
DESCRIPTION - The project description.
DOMAIN_ID - The domain ID number.
DOMAIN_NAME - The domain name.
DB_NAME - The database name.
DB_TYPE - The database type number: MS SQL (2), Oracle (3).
CREATE_FROM_PROJECT - The source project of the created project.
CREATE_FROM_DOMAIN - The source domain of the created project.
PHYSICAL_DIRECTORY - The physical directory of the project.
DB_NATIVE_AUTHENTICATION - Indicates if user login is handled by the operating system (MS_SQL Windows Authentication). If 'N', the authentication is handled explicitly using the user name and password.
DB_USER - The database administrator user name.
DB_USER_PASS - The database administrator password.
DBSERVER_NAME - The database server name.
DBCONNSTR_FORMAT - The database connection string.
DB_ENCRYPTED_CONNSTR - For internal use.
DB_DRIVER_CLASS_NAME - The name of the database manager connection class (JDBC driver class).
PR_EXCEPTION_FILE - The pathname of the file that defines errors that the verify process ignores.
PROJECT_VERSION - The ALM version.
PR_IS_ACTIVE - Indicates if the project is active (Y/N).
SAQ_IS_ACTIVE - Indicates if SEND ALL QUALIFIED is active (Y/N).
PR_IS_QPM_AUTO_CALC_ENABLED - Automatic KPI calculation is enabled (Y/N).
PR_HAS_VCSDB - Indicates if the project includes version control: (Y)es, (N)o, (D)isabled. This field appears only if version control is available.
USERS_QUOTA - The maximum number of concurrent connections. -1 indicates an unlimited number of connections.
PR_LANGUAGE - The search language.
PROJECT_TYPE - The type of project.
IS_TEMPLATE - Indicates whether this is a template project (Y/N).
PROJECT_UID - The project ID.
PR_SMART_REPOSITORY_ENABLED - One of: NO - not a smart repository; YES - smart repository; PENDING - offline migration completed and waiting for online migration; MIGRATING - online migration in progress.
PR_SR_GC_STATUS - Optimized repository garbage collection status.
PR_SR_GC_LAST_RUN_TIME - Optimized repository garbage collection last run time.

Return Value Example

<?xml version="1.0"?>
<CreateProject>
    <PROJECT_ID>78</PROJECT_ID>
    <PROJECT_NAME>test2</PROJECT_NAME>
    <DESCRIPTION>Created on 2007-07-02 10:12:30</DESCRIPTION>
    <DOMAIN_ID>26</DOMAIN_ID>
    <DOMAIN_NAME>DEFAULT2</DOMAIN_NAME>
    <DB_NAME>default2_test2_db</DB_NAME>
    <DB_TYPE>2</DB_TYPE>
    <CREATE_FROM_PROJECT>Empty Database</CREATE_FROM_PROJECT>
    <CREATE_FROM_DOMAIN>Templates</CREATE_FROM_DOMAIN>
    <PHYSICAL_DIRECTORY>
       C:\ProgramData\HP\ALM\Repository\qc\DEFAULT2_26\test2\
    </PHYSICAL_DIRECTORY>
    <DB_NATIVE_AUTHENTICATION>N</DB_NATIVE_AUTHENTICATION>
    <DB_USER>td</DB_USER>
    <DB_USER_PASS>TWO:59-132-191-0-59-132</DB_USER_PASS>
    <DBSERVER_NAME>dbServer06.devlab.ad</DBSERVER_NAME>
    <DB_CONNSTR_FORMAT>jdbc:serverfarm:sqlserver://dbServer06.devlab.ad:1433
    </DB_CONNSTR_FORMAT>
    <DB_ENCRYPTED_CONNSTR>jdbc:serverfarm:sqlserver://dbServer06.devlab.ad:1433
    </DB_ENCRYPTED_CONNSTR>
    <DB_DRIVER_CLASS_NAME>com.mycom.jdbc.sqlserver.SQLServerDriver
    </DB_DRIVER_CLASS_NAME>
    <PROJECT_VERSION>9.2</PROJECT_VERSION>
    <PR_IS_ACTIVE>N</PR_IS_ACTIVE>
    <SAQ_IS_ACTIVE>N</SAQ_IS_ACTIVE>
    <PR_HAS_VCSDB>N</PR_HAS_VCSDB>
    <USERS_QUOTA>-1</USERS_QUOTA>
    <PR_REPOSITORY_IN_DB>Y</PR_REPOSITORY_IN_DB>
    <PR_LANGUAGE>English</PR_LANGUAGE>
</CreateProject>

Example

Example (Visual Basic)

Private Sub ImportProjectEx() 
'The following Visual Basic example creates a 
' new project in an existing domain. 
    Dim sDomainName As String 
    Dim sProjectName As String 
    Dim sServerName As String 
                Dim sFileName as String 
    Dim CreateOptions As Long 
    Dim sReply As String 
    On Error GoTo err 
    sDomainName = "MyNewDomain" 
    sProjectName = "MyNewProject" 
    sServerName = "http://myserver/qcbin" 
                sFileName = "C:\Temp\demo_project.qcp" 
    CreateOptions = SA_ACTIVATE_NEW_PROJECT 
    sReply = m_SAClient.ImportProjectEx _ 
        (sDomainName, sProjectName, SA_ORACLE_DB_TYPE, _ 
        sServerName, "admin", "swordfish", _ 
        "", "", 0, 0, _ 
        CreateOptions, True, sFileName) 
    MsgBox sReply 
    Exit Sub 
err: 
    MsgBox "Program failed:" + err.Description 
End Sub