Defining Sphere Data

Systems Architects and Engineers specialising in the effective use of Systems Architecture, Methods and Tools since 1982

Defining Sphere Data

New sphere data must be provided in a spreadsheet constructed like the following example. The Free Fields should be formatted within the restrictions of the available attribute types.

Struc Sequence	Struc Name	Struc Header	Struc Level	Free Field 1	Free Field 2	Free Field 3	Free Field 4	Free Field 5	Free Field 6	Struc Note
I1	Product Information	Product Information	1
I101	Product Subject	Product Subject	2
I102	Product Design Subject	Product Design Subject	2
I2	Personnel Information	Personnel Information	1
I201	Organisation Subject	Organisation Subject	2
I202	Personnel Subject	Personnel Subject	2
I20201	Employee	Employee	3
I20202	Vacancy	Vacancy	3
I20203	Job Candidate	Job Candidate	3
I20204	Job Advert	Job Advert	3	TGC	04/07/1996	Y	1	Y
I20205	Qualification	Qualification	3
I20206	Job	Job	3
I20207	Vacancy for Job	Vacancy for Job	3
I20208	Vacancy Qualification	Vacancy Qualification	3
I20214	Radio Advert for Job	Radio Job Ad	3	TGC	04/07/1996	N	2	Y

Note that if you have no data in a column, the system will ignore this with the following exceptions. You must have:

an entry in either the Struc(ture) Sequence or the Struc(ture) Level column for every row;

an entry in the Struc(ture) Name for every row.

Facilities provided in the import mechanism include the ability to generate short headers (used in matrices and reports) if they are not provided and the ability to generate either sequence codes for unsequenced items (based on the last available sequence) or level numbers based on the format of the sequence code. For more information see Sequence Codes.

Importing Sphere Data

The steps to be taken when you wish to import sphere item data from an external spreadsheet are:

Create the spreadsheet as defined above

Populate the spreadsheet either directly or by transfer from existing data

Import the spreadsheet using the spreadsheet selector

Review the data and transfer it to the desired sphere using the sphere data import form

Defining Relation Data

New relations data must be provided in a spreadsheet constructed like the following example. The Free Fields should be formatted within the restrictions of the available attribute types. At present relations data can only be imported to a pre-defined relationship.

Struc A Sequence

Struc A Level

Struc B Sequence

Struc B Level

A to B Relation

B to A Relation

Free Field 1

Free Field 2

Free Field 3

Free Field 4

Free Field 5

Free Field 6

Relation Note

FF03

O102

Performed By

Performs

FP0401

O1010102

Performed By

Performs

TGC

12-Jan-00

This note is included as a test of the import process

FP0402

O1010102

Performed By

Performs

FP0403

O1010102

Performed By

Performs

FP0404

O1010102

Audited By

Audits

FP0405

O1010102

Performed By

Performs

FP0412

O1010102

Performed By

Performs

Note that if you have no data in a column, the system will ignore this with the following exceptions. You must have:

an entry in either the Struc(ture) A Sequence column for every row;

an entry in either the Struc(ture) B Sequence column for every row;

an entry in the A to B Relation column for every row.

Facilities provided in the import mechanism include the ability to calculate the levels for relations for which they are not specified and to insert the B to A Relation value based on the A to B value.

Importing Relations Data

The steps to be taken when you wish to import relations data from an external spreadsheet are:

Create the spreadsheet as defined above

Populate the spreadsheet either directly or by transfer from existing data

Import the spreadsheet using the spreadsheet selector

Review the data and transfer it to the desired sphere using the relations data import form