Untitled :: IKAN ALM Documentation

FTP

Table Description

Key	NULL	Column	Type (Size)
P	No	OID	NUMBER
	No	NAME	VARCHAR2(50)
	Yes	DESCRIPTION	VARCHAR2(255)
	Yes	ARCHIVED	NUMBER(1)
	Yes	ARCHIVEDDATETIME	DATE
	No	VERSION	NUMBER
	No	PASSWORD	VARCHAR2(255)
	No	USERNAME	VARCHAR2(50)
	Yes	SERVERHOSTNAME	VARCHAR2(255)
	Yes	SERVERFTPPORT	NUMBER
	No	CONNECTIONMODE	NUMBER
	No	DIRECTORYLISTINGSTYLE	NUMBER
	No	WORKCOPYPATHPREFIX	VARCHAR2(512)
	No	BUILDARCHIVEPATHPREFIX	VARCHAR2(512)
	No	PHASECATALOGPATHPREFIX	VARCHAR2(512)
	No	SCRIPTPATHPREFIX	VARCHAR2(512)

Key

NULL

Column

Type (Size)

OID

NUMBER

NAME

VARCHAR2(50)

Yes

DESCRIPTION

VARCHAR2(255)

Yes

ARCHIVED

NUMBER(1)

Yes

DATE

NUMBER

VARCHAR2(255)

VARCHAR2(50)

Yes

SERVERHOSTNAME

VARCHAR2(255)

Yes

SERVERFTPPORT

NUMBER

CONNECTIONMODE

NUMBER

DIRECTORYLISTINGSTYLE

NUMBER

WORKCOPYPATHPREFIX

VARCHAR2(512)

BUILDARCHIVEPATHPREFIX

VARCHAR2(512)

PHASECATALOGPATHPREFIX

VARCHAR2(512)

SCRIPTPATHPREFIX

VARCHAR2(512)

Column Descriptions

OID

Unique table identifier.

Key	NULL	Column	Type (Size)
P	No	OID	NUMBER

NAME

Name of the FTP Transporter.

Key	NULL	Column	Type (Size)
	No	NAME	VARCHAR2(50)

Key

NULL

Column

Type (Size)

NAME

VARCHAR2(50)

DESCRIPTION

Description for the FTP Transporter.

Key	NULL	Column	Type (Size)
	Yes	DESCRIPTION	VARCHAR2(255)

Key

NULL

Column

Type (Size)

Yes

DESCRIPTION

VARCHAR2(255)

ARCHIVED

For internal use only.

Key	NULL	Column	Type (Size)
	Yes	ARCHIVED	NUMBER(1)

Key

NULL

Column

Type (Size)

Yes

ARCHIVED

NUMBER(1)

Value List

0 = no

1 = yes

ARCHIVEDDATETIME

For internal use only.

Key	NULL	Column	Type (Size)
	Yes	ARCHIVEDDATETIME	DATE

Key

NULL

Column

Type (Size)

Yes

ARCHIVEDDATETIME

DATE

VERSION

For internal use only.

Key	NULL	Column	Type (Size)
	No	VERSION	NUMBER

Key

NULL

Column

Type (Size)

VERSION

NUMBER

PASSWORD

The Password that IKAN ALM will use to access the FTP Server.

Key	NULL	Column	Type (Size)
	No	PASSWORD	VARCHAR2(255)

Key

NULL

Column

Type (Size)

PASSWORD

VARCHAR2(255)

USERNAME

The User Name.

Key	NULL	Column	Type (Size)
	No	USERNAME	VARCHAR2(50)

Key

NULL

Column

Type (Size)

USERNAME

VARCHAR2(50)

SERVERHOSTNAME

The connection name in case it is different from the IKAN ALM Server Machine DHCP name or IP address.

Example: FTP Server mapped to a hostname: ftp.ikan.be.

Key	NULL	Column	Type (Size)
	Yes	SERVERHOSTNAME	VARCHAR2(255)

Key

NULL

Column

Type (Size)

Yes

SERVERHOSTNAME

VARCHAR2(255)

SERVERFTPPORT

The Port Number of the FTP Server running on the IKAN ALM Server.

Note: This value will overwrite the value specified in the System Settings. If not specified in the System Settings nor in the FTP Transporter Settings, the default FTP Port Number 21 is used.

Key	NULL	Column	Type (Size)
	Yes	SERVERFTPPORT	NUMBER

Key

NULL

Column

Type (Size)

Yes

SERVERFTPPORT

NUMBER

CONNECTIONMODE

The connection mode.

Key	NULL	Column	Type (Size)
	No	CONNECTIONMODE	NUMBER

Key

NULL

Column

Type (Size)

CONNECTIONMODE

NUMBER

Value List

0 = Passive

1 = Active

DIRECTORYLISTINGSTYLE

The Directory Listing Style.

Key	NULL	Column	Type (Size)
	No	DIRECTORYLISTINGSTYLE	NUMBER

Key

NULL

Column

Type (Size)

DIRECTORYLISTINGSTYLE

NUMBER

Value List

0 = Unix

1 = Windows

WORKCOPYPATHPREFIX

The prefix for the Work Copy Location (the location where the VCR interface places the checked out sources on the IKAN ALM Server so that it is accessible from a remote IKAN ALM Agent handling a build process). The Server Location will be formed by concatenating this prefix together with the Relative Location defined in the System Settings.

Example:

If the FTP Server is configured to control the E:/Ikan/scm4all/system (Windows) or /ikan/scm4all/system (Linux/Unix) directory, a / will suffice as prefix.

In that case, the sources will be copied to the Agent by a GET command from a subdirectory under /workCopy from the FTP Server.

Key	NULL	Column	Type (Size)
	No	WORKCOPYPATHPREFIX	VARCHAR2(512)

Key

NULL

Column

Type (Size)

WORKCOPYPATHPREFIX

VARCHAR2(512)

BUILDARCHIVEPATHPREFIX

The prefix for the Build Archive Location (the location where the Builds are stored or retrieved from). The Server Location is formed by concatenating this prefix together with the Relative Location defined in the System Settings.

Example:

If the FTP Server is configured to control the E:/Ikan/scm4all/system (Windows) or /ikan/scm4all/system (Linux/Unix) directory, a / will suffice as prefix.

In that case, the build result will be copied from the Agent to the Build Archive by a PUT command into the subdirectory /buildArchive on the FTP Server.

Key	NULL	Column	Type (Size)
	No	BUILDARCHIVEPATHPREFIX	VARCHAR2(512)

Key

NULL

Column

Type (Size)

BUILDARCHIVEPATHPREFIX

VARCHAR2(512)

PHASECATALOGPATHPREFIX

The prefix for the Phase Catalog location (the location where newly created Phases and Phases that have been imported will be stored). A remote IKAN ALM Agent that needs to install a Phase will use this location to retrieve it.

Key	NULL	Column	Type (Size)
	No	PHASECATALOGPATHPREFIX	VARCHAR2(512)

Key

NULL

Column

Type (Size)

PHASECATALOGPATHPREFIX

VARCHAR2(512)

SCRIPTPATHPREFIX

The prefix for the Script Location (the location where the IKAN ALM Agent will retrieve the build or deploy script from if it can not be found in the sources). The Server Location will be formed by concatenating this prefix together with the Relative Location defined in the System Settings.

Example:

If the FTP Server is configured to control the E:/Ikan/scm4all/system (Windows) or /ikan/scm4all/system (Linux/Unix) directory, a / will suffice as prefix.

Key	NULL	Column	Type (Size)
	No	SCRIPTPATHPREFIX	VARCHAR2(512)

Key

NULL

Column

Type (Size)

SCRIPTPATHPREFIX

VARCHAR2(512)

Indexes

Index	Primary	Unique	Column(s)	Source Table
FTP_PK	Yes	Yes	OID

Index

Primary

Unique

Column(s)

Source Table

FTP_PK

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

No referencing tables available.

Report Labels

FTP_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

FTP_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

FTP_BUILDARCHIVEPATHPREFIX_LABEL

English:

Build Archive Path Prefix

French:

Préf. Empl. Archives Constr.

German:

Präfix des Bereitstellungsarchivverzeichnisses

FTP_CONNECTIONMODE_LABEL

English:

Connection Mode

French:

Mode de Connexion

German:

Verbindungsmodus

FTP_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

FTP_DIRECTORYLISTINGSTYLE_LABEL

English:

Directory Listing Style

French:

Style de répertoire

German:

Stil der Verzeichnisanzeige

FTP_NAME_LABEL

English:

Name

French:

Nom

German:

Name

FTP_OID_LABEL

English:

OID

French:

OID

German:

OID

FTP_PASSWORD_LABEL

English:

Password

French:

Mot de passe

German:

Passwort

FTP_PHASECATALOGPATHPREFIX_LABEL

English:

Phase Catalog Path Prefix

French:

Préfixe Chemin du Catalogue des Phases

German:

Präfix für den Phasekatalog

FTP_SCRIPTPATHPREFIX_LABEL

English:

Script Path Prefix

French:

Préf. Empl. Scripts

German:

Präfix des Skriptverzeichnisses

FTP_SERVERFTPPORT_LABEL

English:

Server FTP Port

French:

Port du Serveur FTP

German:

Server FTP Port

FTP_SERVERHOSTNAME_LABEL

English:

Server Hostname

French:

Nom du Serveur

German:

Server Hostname

FTP_USERNAME_LABEL

English:

User Name

French:

Nom d’utilisateur

German:

Benutzername

FTP_VERSION_LABEL

English:

Version

French:

Version

German:

Version

FTP_WORKCOPYPATHPREFIX_LABEL

English:

Work Copy Path Prefix

French:

Préf. Empl. Copies de travail

German:

Präfix des Arbeitskopieverzeichnisses