ISO/TS 13584-35:2010

Industrial automation systems and integration - Parts library - Part 35: Implementation resources: Spreadsheet interface for parts library

ISO/TS 13584-35:2010 defines the spreadsheet data structure for both dictionary and library, where CSV (comma separated values) format is used for ISO 13584 compliant dictionary and library exchange. The unique identification of a dictionary entry allows it to be referenced unambiguously from any application. Definitions and identifications of dictionary entries consist of instances of the EXPRESS entity data types defined in the common dictionary schema, or in its extensions defined in the logical series of parts of ISO 13584.

Systèmes d'automatisation industrielle et intégration — Bibliothèque de composants — Partie 35: Ressources de mise en application: Interface de tableur pour bibliothèque de composants

General Information

• Status: Published
• Publication Date: 12-Jul-2010
• ICS: 25.040.40 - Industrial process measurement and control
• Technical Committee: ISO/TC 184/SC 4 - Industrial data
• Drafting Committee: ISO/TC 184/SC 4/JWG 24 - Joint ISO/TC 184/SC 4 - IEC SC3D WG: Use of IEC CDD for ISO data dictionaries and ontologies
• Current Stage: 9093 - International Standard confirmed
• Start Date: 08-May-2025
• Completion Date: 13-Dec-2025

Overview

ISO/TS 13584-35:2010 - "Industrial automation systems and integration - Parts library - Part 35: Implementation resources: Spreadsheet interface for parts library" defines a standardized spreadsheet data structure for exchanging parts dictionaries and libraries. The Technical Specification specifies a CSV (comma-separated values) representation that is ISO 13584‑compliant, enabling unambiguous, machine-readable identification of dictionary entries. Definitions and identifiers are based on instances of the EXPRESS entity data types from the common dictionary schema and its logical extensions.

Key topics and technical requirements

• Spreadsheet & CSV format: Defines the layout and file-naming conventions for parcels (parcelling sheets) used to represent dictionary or library content in spreadsheet/CSV form.
• Unique identification: Requires globally unambiguous identifiers for dictionary entries so any application can reference items reliably.
• Meta-dictionary approach: Describes a meta-dictionary model that represents the structure of dictionaries and enables mapping between spreadsheet data and EXPRESS-based schema.
• Parcelling formats & use scenarios: Covers both dictionary parcelling and library parcelling formats, with instructions for how parcels are organized and combined.
• Header and instruction columns: Specifies header semantics and reserved instruction keywords (e.g., Class ID, Preferred name, Definition, Property ID, Data type, Unit of measurement) used to describe meta-classes and properties in spreadsheets.
• Data types & value formats: Details handling of EXPRESS-based types (enumeration, level, string, translatable string, boolean, class-instance, aggregates, named types, entity instances) and guidance on unit identifiers, alternative units and encoding.
• Conformance & extensions: Defines conformance classes for parcelling spreadsheets and mechanisms for structural extension; normative annexes include reserved words, meta-dictionary file examples and data type descriptions.

Practical applications and users

ISO/TS 13584-35 is intended for organizations that need interoperable parts data exchange in industrial automation, including:

• Manufacturers and suppliers publishing parts catalogs and spare-parts data
• CAD, PLM and ERP vendors integrating parts libraries
• System integrators and procurement teams standardizing component data
• Technical librarians and data stewards working on classification and reuse

Benefits include easier spreadsheet-based editing, consistent CSV exchange of parts libraries, improved interoperability across tools, and reliable referencing through EXPRESS-based identifiers.

Related standards

• ISO 13584 series (Parts library / PLIB) - common dictionary schema and logical parts
• EXPRESS language standards used to model data types (referenced by ISO 13584)

Keywords: ISO/TS 13584-35:2010, ISO 13584, spreadsheet interface for parts library, parts library CSV, EXPRESS entity, parts catalog exchange, industrial automation parts library.

Standards Content (Sample)

TECHNICAL ISO/TS
SPECIFICATION 13584-35
First edition
2010-07-15
Industrial automation systems and
integration — Parts library —
Part 35:
Implementation resources: Spreadsheet
interface for parts library
Systèmes d'automatisation industrielle et intégration — Bibliothèque de
composants —
Partie 35: Ressources de mise en application: Interface de tableur pour
bibliothèque de composants
Reference number
©
ISO 2010
PDF disclaimer
This PDF file may contain embedded typefaces. In accordance with Adobe's licensing policy, this file may be printed or viewed but
shall not be edited unless the typefaces which are embedded are licensed to and installed on the computer performing the editing. In
downloading this file, parties accept therein the responsibility of not infringing Adobe's licensing policy. The ISO Central Secretariat
accepts no liability in this area.
Adobe is a trademark of Adobe Systems Incorporated.
Details of the software products used to create this PDF file can be found in the General Info relative to the file; the PDF-creation
parameters were optimized for printing. Every care has been taken to ensure that the file is suitable for use by ISO member bodies. In
the unlikely event that a problem relating to it is found, please inform the Central Secretariat at the address given below.

©  ISO 2010
All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized in any form or by any means,
electronic or mechanical, including photocopying and microfilm, without permission in writing from either ISO at the address below or
ISO's member body in the country of the requester.
ISO copyright office
Case postale 56 • CH-1211 Geneva 20
Tel. + 41 22 749 01 11
Fax + 41 22 749 09 47
E-mail [e-mail]
Web www.iso.org
Published in Switzerland
ii © ISO 2010 – All rights reserved

Blank page
Contents Page
1 Scope . 1
2 Normative references. 3
3 Terms and definitions . 4
4 Use scenario for spreadsheet interface . 9
4.1 Spreadsheet representation of dictionary or library . 9
4.2 Use scenario of dictionary parcelling format. 11
4.3 Use scenario of library parcelling format. 11
5 Structure of the spreadsheet interface. 12
5.1 Meta-dictionary approach. 12
5.2 Identification structure. 13
5.3 Structure of a parcelling sheet. 15
5.4 File name extension . 15
5.5 Library use of parcelling format . 16
5.6 Header section. 17
5.6.1 Categories of instructions. 17
5.6.2 Mandatory . 17
5.6.3 Optional - functional . 17
5.6.4 Reserved - informative. 17
5.6.5 Comment line. 18
5.6.6 Reserved words . 18
5.7 Instruction column . 18
5.7.1 General rule. 18
5.7.2 Class ID. 18
5.7.3 Preferred name of the class . 19
5.7.4 Definition of the class . 19
5.7.5 Note of the class. 20
5.7.6 Alternate class ID. 20
5.7.7 Source language . 20
5.7.8 Parcel identifier . 21
iv © ISO 2010 – All rights reserved

5.7.9 Parcel conformance class identifier. 21
5.7.10 Default supplier. 22
5.7.11 Property ID. 22
5.7.12 Preferred name of the property . 23
5.7.13 Definition . 24
5.7.14 Note. 25
5.7.15 Data type . 26
5.7.16 Unit of measurement. 27
5.7.17 Requirement . 27
5.7.18 Alternative units of measurement . 28
5.7.19 IDs of alternative units of measurement . 29
5.7.20 Alternate property ID . 29
5.7.21 ID for the unit of measurement . 30
5.7.22 Property value format. 31
5.7.23 Identifier encoding . 31
5.7.24 Default ID encoding. 32
5.8 Data section for instances . 33
5.8.1 General. 33
5.8.2 Enumeration types, or non quantitative types . 33
5.8.3 Level type. 34
5.8.4 String type . 34
5.8.5 Translatable string type . 34
5.8.6 Boolean type. 35
5.8.7 Class instance type (Class reference type) . 35
5.8.8 Aggregate type . 36
5.8.9 Named type . 39
5.8.10 Entity instance type. 39
5.9 Dictionary use of parcelling format . 40
5.9.1 Dictionary as an instance of meta-dictionary. 40
5.9.2 Identification of conjunctive parcels. 42
5.9.3 Roles and definition of dictionary parcels. 42
5.9.4 Properties of meta-dictionary. 44
6 Mechanism for structural extension. 56
6.1 General.56
6.2 Example . 56
7 Conformance classes for parcelling spreadsheet . 56
Annex A (normative) Information object registration. 59
Annex B (normative) Meta-dictionary file. 60
Annex C (normative) Reserved words. 61
Annex D (normative) Description examples of data types . 65
Annex E (normative) Meta-properties of normative meta-classes . 67
Annex F (informative) Meta-properties of optional meta-classes. 114
Annex G (informative) Meta-class properties mapped with DIN 4002 . 126
Annex H (informative) Meta-dictionary updates . 140
Bibliography. 141
Index. 143

Figures
Figure 1 — Parcel use scenario.10
Figure 2 — Schematic diagram of meta-dictionary approach.13
Figure 3 — Structure of a parcelling sheet.15
Figure 4 — Display example of property ID .23
Figure 5 — Display example of preferred name.24
Figure 6 — Display example of definition.25
Figure 7 — Display example of data type.26
Figure 8 — Display example of unit of measurement .27
Figure 9 — Display example of key .28
Figure 10 — Display example of unit of measurement .28
Figure 11 — Display example of unit of measurement .29
Figure 12 — Display example of alternate property ID.30
Figure 13 — Display example of ID for the unit of measurement.30
Figure 14 — Display example of value format.31
Figure 15 — Display example of ID encoding specification.31
Figure 16 — Display example of ID encoding specification.32
vi © ISO 2010 – All rights reserved

Figure 17 — Display example of ENUM_INT_TYPE or ENUM_CODE_TYPE.33
Figure 18 — Display example of LEVEL_TYPE.34
Figure 19 — Display example of TRANSLATABLE_STRING_TYPE.34
Figure 20 — Display example of BOOLEAN_TYPE .35
Figure 21 — Display example of CLASS_INSTANCE_TYPE.35
Figure 22 — Display example of SET OF STRING_TYPE.36
Figure 23 — Display example of LIST OF STRING_TYPE .37
Figure 24 — Display example of LIST OF TRANSLATABLE_STRING_TYPE .37
Figure 25 — Display example of SET OF LEVEL OF INT_MEASURE_TYPE.38
Figure 26 — Display example of SET OF SET OF STRING_TYPE .39
Figure 27 — Configuration of a dictionary parcel.40
Tables
Table 1 — Description of the property code.23
Table 2 — Example of correspondence within multiple languages.38
Table 3 — Meta-classes that constitute a meta-dictionary.43
Table 4 — Conformance classes for ISO 13584-35.58
Table C.1 — Key words for instruction in class header .61
Table C.2 — Key words for instruction in schema header .63
Table D. 1 — Description examples of data types.65
Table E.1 — Meta-properties of dictionary meta-class .68
Table E.2 — Meta-properties of class meta-class.74
Table E.3— Meta-properties of property meta-class .84
Table E.4 — Meta-properties of supplier meta-class.93
Table E.5 — Meta-properties of enumeration meta-class.97
Table E.6 — Meta-properties of datatype meta-class .102
Table E.7 — Meta-properties of document meta-class.107
Table F.1 — Meta-properties of object meta-class .115
Table F.2 — Meta-properties of UoM meta-class .116
Table F.3 — Meta-properties of terminology meta-class .121
Table G.1 — Meta-properties for the definition of a class, mapped with DIN 4002.127
Table G.2 — Meta-properties for the definition of a property, mapped with DIN 4002.130
Table G.3 — Meta-properties for the definition of an enumeration, mapped with DIN 4002.133
Table G.4 — Meta-properties for the definition of a data type, mapped with DIN 4002.135
Table G.5 — Meta-properties for the definition of a UoM, mapped with DIN 4002 .138

Foreword
ISO (the International Organization for Standardization) is a worldwide federation of national
standards bodies (ISO member bodies). The work of preparing International Standards is
normally carried out through ISO technical committees. Each member body interested in a
subject for which a technical committee has been established has the right to be represented on
that committee. International organizations, governmental and non-governmental, in liaison with
ISO, also take part in the work. ISO collaborates closely with the International Electrotechnical
Commission (IEC) on all matters of electrotechnical standardization.
International Standards are drafted in accordance with the rules given in the ISO/IEC Directives,
Part 2.
The main task of technical committees is to prepare International Standards. Draft International
Standards adopted by the technical committees are circulated to the member bodies for voting.
Publication as an International Standard requires approval by at least 75 % of the member bodies
casting a vote.
In other circumstances, particularly when there is an urgent market requirement for such
documents, a technical committee may decide to publish other types of normative document:
— an ISO Publicly Available Specification (ISO/PAS) represents an agreement between
technical experts in an ISO working group and is accepted for publication if it is approved by
more than 50 % of the members of the parent committee casting a vote;
— an ISO Technical Specification (ISO/TS) represents an agreement between the members of a
technical committee and is accepted for publication if it is approved by 2/3 of the members of
the committee casting a vote.
An ISO/PAS or ISO/TS is reviewed after three years in order to decide whether it will be
confirmed for a further three years, revised to become an International Standard, or withdrawn. If
the ISO/PAS or ISO/TS is confirmed, it is reviewed again after a further three years, at which time
it must either be transformed into an International Standard or be withdrawn.
Attention is drawn to the possibility that some of the elements of this document may be the
subject of patent rights. ISO shall not be held responsible for identifying any or all such patent
rights.
viii © ISO 2010 – All rights reserved

ISO/TS 13584-35 was prepared by Technical Committee ISO/TC 184, Automation systems and
integration, Subcommittee SC 4, Industrial data.
ISO 13584 consists of the following parts under the general title Industrial automation systems
and integration — Parts library:
— Part 1: Overview and fundamental principles
— Part 20: Logical resource: Logical model of expressions
— Part 24: Logical resource: Logical model of supplier library
— Part 25: Logical resource: Logical model of supplier library with aggregate values and
explicit content
— Part 26: Logical resource: Information supplier identification
— Part 31: Implementation resources: Geometric programming interface
— Part 32: Implementation resources: OntoML: Product ontology markup language
— Part 35: Implementation resources: Spreadsheet interface for parts library [Technical
Specification]
— Part 42: Description methodology: Methodology for structuring part families
— Part 101: Geometrical view exchange protocol by parametric program
— Part 102: View exchange protocol by ISO 10303 conforming specification
— Part 501: Reference dictionary for measuring instruments — Registration procedure
— Part 511: Mechanical systems and components for general use — Reference dictionary for
fasteners
The structure of ISO 13584 is described in ISO 13584-1. The numbering of the parts of
ISO 13584 reflects its structure:
— Parts 20 to 29 specify the logical resources;
— Parts 30 to 39 specify the implementation resources;
— Parts 40 to 49 specify the description methodology;
— Parts 100 to 199 specify the view exchange protocol;
— Parts 500 to 599 specify the reference dictionaries.
A complete list of parts of ISO 13584 is available from the Internet:


x © ISO 2010 – All rights reserved

Introduction
ISO 13584 is an International Standard for the computer-interpretable representation and
exchange of parts library data. The objective is to provide a neutral mechanism capable of
transferring parts library data, independent of any application that is using a parts library data
system. The nature of this description makes it suitable not only for the exchange of files
containing parts, but also as a basis for implementing and sharing databases of parts library data.
ISO 13584 is organized as a series of parts, each published separately. The parts of ISO 13584 fall
into one of the following series: logical resources, implementation resources, description
methodology, view exchange protocol, and reference dictionaries. The series are described in
ISO 13584-1.
This part of ISO 13584 specifies the standard spreadsheet structure for parts library, used either
for the definition and transfer of a reference dictionary, or for the definition and interchange of a
set of instance data belonging to a class of a reference dictionary conforming to the ISO 13584
series of standards.
This part of ISO 13584 also establishes the standard mapping between the data carrying a
reference dictionary represented in the spreadsheet format defined in this part of ISO 13584 and
the data represented in the ISO 13584-25 compliant EXPRESS model for the exchange of
reference dictionary.
TECHNICAL SPECIFICATION ISO/TS 13584-35:2010(E)

Industrial automation systems and integration —
Parts library —
Part 35:
Implementation resources: Spreadsheet interface for parts
library
1 Scope
This part of ISO 13584 specifies the standard spreadsheet interface structure for parts library,
used either for the definition and exchange of a reference dictionary, or for the definition and
exchange of the instance data belonging to a class of library.
This part of ISO 13584 also establishes the standard mapping between the data carrying a
dictionary represented in the spreadsheet format conforming to this part of ISO 13584 and the
data represented in the ISO 13584-25 compliant EXPRESS model for dictionary exchange. A set
of spreadsheets whose semantics conform to the specification given in this part of ISO 13584,
where the physical file structure of the spreadsheets is based on the CSV (Comma Separated
Values) format, is typically used in a popular commercial spreadsheet application, or any other
tabular formats compatible or convertible to the CSV format. Such a set of spreadsheets
supporting a conformance class specified in this part of ISO 13584 may be used additionally for
data translation between the CSV format and the ISO 10303-21 physical file structure based on
the mapping specified in this part of ISO 13584.
The spreadsheet interface structure defined in this part of ISO 13584 contains the following:
— definition and specification of the basic structure and layout of the spreadsheet interface for
parts library, independent of the data content carried by the structure;
— method of specification of instance data belonging to a class of reference dictionary described
by a set of spreadsheets conformant to this part of ISO 13584;
— definition and specification of the meta-dictionary that enables the definition and transfer of a
reference dictionary as a set of instance data conforming to the meta dictionary;
— specification of the mapping between the dictionary data expressed in the spreadsheet format
and the EXPRESS model specified by ISO 13584-25;
— description of the basic semantic mapping between the dictionary data expressed in the
spreadsheet formats defined in this part of ISO 13584 and that of DIN 4002.
The following items are outside the scope of this part of ISO 13584:
— specification of the CSV format per se, used in a spreadsheet tool;
— specification of the presentation layout details, such as colouring and sizing of the
spreadsheet interface, conformant to this part of ISO 13584;
— specification of the dictionary EXPRESS model conformant to the ISO 13584 series of
standards;
— normative definition of the mappings between an ISO 13584 compliant dictionary and
another that is based upon other standards;
— specification of the maintenance method of this part of ISO 13584.
2 © ISO 2010 – All rights reserved

2 Normative references
The following referenced documents are indispensable for the application of this document. For
dated references, only the edition cited applies. For undated references, the latest edition of the
referenced document (including any amendments) applies.
ISO 639-1, Codes for the representation of names of languages — Part 1: Alpha-2 code
ISO 639-2, Codes for the representation of names of languages — Part 2: Alpha-3 code
ISO 8601, Data elements and interchange formats — Information interchange — Representation
of dates and times
ISO 13584-25, Industrial automation systems and integration — Parts library — Part 25:
Logical resource: Logical model of supplier library with aggregate values and explicit content
ISO 13584-42, Industrial automation systems and integration — Parts library — Part 42:
Description methodology: Methodology for structuring part families
IEC 61360-2, Standard data element types with associated classification scheme for electric
components — Part 2: EXPRESS dictionary schema
IEC 61360-4, Standard data element types with associated classification scheme for electric
components — Part 4: IEC reference collection of standard data element types and component
classes
3 Terms and definitions
For the purposes of this document, the following terms and definitions apply.
3.1
applicable property
a property that is defined for some family of parts and that shall apply to any part that belongs to this family of parts
EXAMPLE For a generic family of screws, the threaded diameter is an applicable property. This characteristic applies to any screw.
[ISO 13584-24:2003, definition 3.3]
3.2
application
use of software or a standard in an industrial domain
3.3
basic semantic unit
BSU
entity that provides an absolute and universally unique identification of a certain object of the application domain
EXAMPLE Classes, data element types.
[ISO 13584-42:—, definition 3.4]
3.4
common dictionary schema
CIID schema
information model for a reference dictionary based on the EXPRESS data model defined in IEC 61360-2 and ISO
13584-42
3.5
composite property
collection of properties that can be referenced from a class or classes as a single entity
[ISO 13584-501:2007, definition 3.8]
3.6
conjunctive parcels
parcel sheets that are used together to define a library or a reference dictionary
3.7
data
quantities, characters, or symbols on which operations are performed by computers and other automatic equipment, and
which may be stored or transmitted in the form of electric signals, records on magnetic or magneto-optic medium, or
pieces of paper, etc.
3.8
data element type
DET
unit of data for which the identification, description and value representation have been specified
NOTE In the ISO 13584 standard series, a property value is represented as a data element type.
[ISO 13584-42:—, definition 3.13]
4 © ISO 2010 – All rights reserved

3.9
data type
representation, interpretation, and structure of values used in computer systems and other automatic equipment
3.10
dictionary
data dictionary
set of terms with respective identifiers formulated in a canonical syntax and with commonly accepted definitions
designed to yield a lexical or taxonomical framework for knowledge representation in a computer interpretable form,
which can be shared by different information systems and communities
3.11
dictionary data
dictionary represented as rows of data conforming to the schema collectively defined by a meta dictionary
3.12
dictionary element
set of attributes that constitutes the dictionary description of certain objects of the application domain
EXAMPLE 1 A dictionary compliant with this part of ISO 13584 provides for the description of classes, properties,
information sources and datatypes.
EXAMPLE 2 A dictionary compliant with ISO 13584-24 provides for the description of classes, properties, information
sources, datatypes, tables, documents and program libraries.
[ISO 13584-42:—, definition 3.15]
3.13
dictionary parcel
set of spreadsheets that are used to define in parts a reference dictionary as the instance of the class that each schema
header section of the parcel sheet represents
3.14
dictionary parcel client
dictionary parcel client system
parcel client that can read or write parcel dictionaries, and that may have an optional capability to send them to, or
receive them from a server system
3.15
dictionary parcel server
dictionary server
parcel server that can provide parcel dictionaries over the Internet
3.16
entity
a class of information defined by common properties.
[ISO 10303-11:2004, definition 3.3.6]
3.17
feature
an aspect of an item that can be captured by a class structure and set of properties and that cannot exist independently of
the item
EXAMPLE 1 A form feature is an aspect of a part that conforms to some preconceived shape stereotype associated to
dimensioning properties. It may be represented as an instance of a class that captures this shape stereotype.
EXAMPLE 2 In a piping component, an outlet is an aspect of a part that conforms to some preconceived function
stereotype that is associated with properties (e.g., its name, its role). It may be represented as a feature.
[ISO 13584-24:2003, definition 3.41]
3.18
globally unique identifier
ID
identifier for the global identification of the source of identifier information, and which provides a globally unique
identification of a concept without recourse to the linguistic interpretation of the meaning of the letter sequence of the
identifier
NOTE The globally unique identifier might or might not be based on ISO/IEC 6523.
3.19
instance
set of unary or n-ary values being identified as a distinct member of a class and conceptually characterized by the set of
properties belonging to the class
3.20
international concept identifier
international concept ID
ICID
globally unique identifier that is used in the parcelling format for identifying each data concept
3.21
is-a relationship
the inheritance relationship defined in the object oriented paradigm
NOTE In ISO 13584 the is-a relationship holds between a family of parts and a generic family of parts to which the former
family belongs.
[ISO 13584-24:2003, definition 3.61]
3.22
is-case-of relationship
a relationship providing a formal expression of the fact that an object conforms to the partial specification defined by
another object
NOTE In ISO 13584, all the properties and data types visible or applicable for some family of parts may be imported by all the
families of parts that declare to be case-of the former family. These properties and data types may then be used to describe the latter
families.
[ISO 13584-24:2003, definition 3.62]
3.23
is-part-of
the aggregation part/whole relationship
NOTE In ISO 13584 the is-part-of relationship holds between a family of constituent parts and a family of assembled parts to
which the constituent parts belongs.
[ISO 13584-24:2003, definition 3.63]
6 © ISO 2010 – All rights reserved

3.24
item
thing that can be captured by a structure of class or by a structure of property
3.25
library
set of data composed of the full definition of a reference dictionary and the specification of a population of instances
conforming to the dictionary, or part of such a set of data corresponding to some classes of a reference dictionary
3.26
library data supplier
supplier
an organization that delivers a library in the standard format defined in ISO 13584 and is responsible for its content
[ISO 13584-1:2001, definition 3.1.10]
3.27
library external file
a file, referenced from a library delivery file, that contributes to the definition of a supplier library
NOTE The structure and the format of a library external file is specified in the library delivery file that references it.
[ISO 13584-24:2003, definition 3.71]
3.28
library integrated information model
LIIM
an EXPRESS schema that integrates resource constructs from different EXPRESS schemas for representing supplier
libraries for the purpose of exchange and that is associated with conformance requirements
NOTE Three library integrated information models are defined in this part of ISO 13584 for representing different kinds of
supplier libraries.
[ISO 13584-24:2003, definition 3.72]
3.29
library parcel
set of spreadsheets that are used to define in parts a set of instances of a class that the header part of the parcel represents
3.30
library parcel client
parcel client that can read or write library parcels, and that may have an optional capability to send them to, or receive
them from a server system
3.31
library parcel server
library parcel server system
server system that can provide library parcels over the Internet
3.32
meta-dictionary
set of meta-classes, each of which is characterized by a different set of properties called “meta-properties”, and as an
instance of which a reference dictionary may be defined and specified
3.33
meta object facility
metadata management framework, and a set of metadata services for the development and interoperability of model and
metadata driven systems
3.34
meta-property
property that is used to characterize a meta-class and is used to define the syntactic structure of the meta-class
3.35
Office Open XML
set of XML vocabularies standardized as ISO/IEC 29500 and based on W3C XML Schema, for the representation of
word-processing documents, spreadsheets and presentations
3.36
parcel editor
system that edits parcelling sheets, which may have a capability to send them or receive them over the Internet
3.37
parcel sheet
parcelling sheet
parcel
standardized use and specification of spreadsheets, used for data-dictionary or data-library specification, exchange, and
registering, of objects at various meta modelling layers
3.38
parcel client
client system that can read or write parcelling sheets in general, and that may have an optional capability to send them
to, or receive them from a server system
3.39
parcel server
server system that can provide parcelling sheets in general over the Internet
3.40
parcelling
act of defining, exchanging, or transmitting information using parcelling sheets defined in this part of ISO 13584
3.41
parcelling tool
tool that can process parcelling sheets in general, including PCL-clients, PCL-editors, and PCL-servers
3.42
part
a material or functional element that is intended to constitute a component of different products
[ISO 13584-1:2001, definition 3.1.16]
3.43
property
set of characteristic information that conceptually characterizes a class, the value of which may be actually supplied by
a library supplier and used to characterize instances (parts) that belong to the class or its subclasses
8 © ISO 2010 – All rights reserved

3.44
property of parts library
PLIB-property
kind of property that is used strictly in the sense of the property defined ISO 13584-42 when it is necessary to be
differentiated from other uses of property, such as meta-properties or properties used to describe mapping between
different data library or catalogue standards
3.45
reference dictionary
dictionary that is based on the ISO 13584/IEC 61360 data model
4 Use scenario for spreadsheet interface
4.1 Spreadsheet representation of dictionary or library
The spreadsheet interface structure defined in this part of ISO 13584 may be used either for
expressing a dictionary or a library. Two interface formats for dictionary and library are in fact
two different and specialized uses of the same spreadsheet format, whose underlying physical file
structure is widely recognized and processible by many software applications. For the ease of
identification of the two uses, and for the distinction of the specialized spreadsheets from those
for general use, the one for dictionary representation of parts library shall be called “the dictionary
parcelling format”, and the other for library representation of parts library shall be called “the
library parcelling format”, in this part of ISO 13584. In the parcelling formats used either for
dictionary or for library, several spreadsheets need to be compiled together, in order to represent a
dictionary or a library. Hence, the word “parcelling” comes from the fact that both formats use a
certain number of spreadsheets set together, and each of them represents semantically different
content of EXPRESS entities in a syntactically similar unit of structure, which is called “parcel”
in this part of ISO 13584. The whole use scenario of the spreadsheet interface for dictionary and
library is illustrated in Figure 1.
Parcel Use Scenario
Dictionary Parcel Use Scenario
D1: Downloading Dictionary Server
dictionary template
Dictionary
Parcel
Template
D3: Registering or
Dictionary
D2: Defining dictionary updating dictionary
Parcel
D4: Modifying dictionary
Dictionary Server
Query Manager
Dictionary
Parcel
D5: Retrieving
part or whole of
Parcel Dictionary Editor
Dictionary
dictionary
Editor & User
D6: Interfacing dictionary
Dictionary Parcel
parcel with other applications
Client Application
Library Parcel Use Scenario
Library Server
L1: Downloading
Library
Library template
Parcel
Template
L3: Registering
Library
Library definition
Parcel
L2: Defining Library
Library Server
Manager
L4: modifying Library
Query
Library
Parcel
L5: Retrieving
part or whole of
Parcel Library Editor
Library (Catalogue)
Library
Editor & User
L6: Interfacing Library
Library Parcel
parcel with other applications
Client Application
Figure 1 —Parcel use scenario
10 © ISO 2010 – All rights reserved

4.2 Use scenario of dictionary parcelling format
The dictionary parcelling format may be used in the following use-cases as typical cases:
— D1: Retrieval of a set of blank dictionary parcels from a dictionary server as a dictionary
template for defining a new reference dictionary;
— D2: Definition of the content of a reference dictionary;
— D3: Registering of the content of a reference dictionary in a dictionary server;
— D4: Modification of the content of a reference dictionary;
— D5: Retrieving part or whole of a reference dictionary from a dictionary server;
— D6: Interfacing dictionary parcel with other software applications or engineering tools.
Among the above cases, the use cases D1 through D3 are concerned with defining a new
reference dictionary with a use of spreadsheet software, while the use cases D4 through D6 are for
the reuse of information of a reference dictionary which has been registered previously. The
interest of putting a reference dictionary into a set of spreadsheets, i.e., a tabular or matrix form is
to make it easy for human readers to understand the content, while from an information
processing view point, a spreadsheet format is quite close to the data forms suitable for interfacing
with relational databases. In addition, the advantage of assigning a global identifier to each of the
attributes of dictionary elements is that it becomes neutral to the change of names of the attributes,
necessitated by an evolution of standard or merger of standards, and also it helps map between the
attributes of two or more different dictionary standards. Furthermore, the parcelling format
defined in this part of ISO 13584 provides a unique functionality called “alternate ID” that
enables identification of an item by one another identifier, used temporally or locally. Annex G
attached to this part of ISO 13584 may well be used to establish a mapping between this part of
ISO 13584 and DIN 4002, with the help of alternate ID.
4.3 Use scenario of library parcelling format
The library parcelling format may be used in the following use-cases as typical ones:
— L1: Retrieval of a set of blank library parcels from a library server as a library template for
defining a new library;
— L2: Definition of the content of a library;
— L3: Registering of the content of a library in a library server;
— L4: Modification of the content of a library;
— L5: Retrieving part or whole of a library from a library server;
— L6: Interfacing library parcel with other software applications or engineering tools.
Among the above cases, as explained in L6 the uses for interfacing with other software
applications such as DTP (Desk-Top Publishing) applications, PDM (Product Data Management)
applications, or ERP (Engineering Resource Planning) systems, or other engineering applicat
...