Servigistics InService Publishing and Loading > Using Publishing and Loading > Loading CSV Data > CSV File Format
  
CSV File Format
The CSV files used in a CSV bundle must follow a specified format. This section covers the files contained in a CSV bundle and the required format for each of the files.
CSV Bundle Structure
A CSV bundle has the following structure:
The following files and folders are processed during data loading:
• properties.csv file – Contains general properties
• DataScripts folder – Contains CSV files for the following entities:
◦ Product Hierarchy in producthierarchy.csv
◦ Information Structure in toc.csv
◦ Product Instance in productinstance.csv
◦ Parts in part.csv
◦ Parts lists in assembly.csv
◦ Part relations in part_relations.csv
◦ Hotspots information in hotspot.csv
◦ Product invoice (BOM) information in bom.csv
◦ BOM collection information in bomcollections.csv
◦ Option and choice information in OptionsChoiceDefinition.csv
◦ Option and choice rules for a context in OptionsChoices_Applicability.csv
• Mapping folder – Contains mapping CSV files for the following content:
◦ Images in image.csv
◦ XML documents in xml.csv
◦ PDF documents in pdf.csv
◦ GRAPHIC documents in graphic.csv
◦ Parts list documents in assembly_mapping.csv
• PDF folder – Contains all PDF files that are referenced in the PDF mapping file.
• Images folder – Contains all images that are referenced in the image mapping file.
• XML folder – Contains all XML files that are referenced in the XML mapping file.
• GRAPHIC folder – Contains all graphic files that are referenced in the GRAPHIC mapping file.
Note that non-IS associated information elements (IE-PDF, IE-XMLs, or IE-GRAPHICS) are located in the IE related folder. For example, XML files not associated with an information structure are located in the XML folder.
A parts list must be provided along with the related information, including parts and hotspot information.
* 
For any CSV file that contains the Org Name column, the Bookmarks and Notes information is not migrated when the you need to TAL the data again and the Org Name is provided as input.
General Properties
The CSV bundle contains the properties.csv file with the following general information and properties.
* 
The column format is provided using regular expressions. It is assumed you are familiar with regular expressions
CSV Column
Description
Required / Optional
Format
Creation Date
Provides the script creation date, for example, 03-24-2011.
* 
The Creation Date column requires that the date be provided in a pre-defined mm/dd/yyyy hh:mm format. This requires pre-configuration of local settings on the server side.
Required
Timestamp
Org Name
The Organization Name provides the Vendor Code. This is mapped in the IMAN file.
Optional
String
CollectionID
Provides the collection IDs that these CSV files describe. Can contain multiple values to which the data will be loaded.
If collection is not provided, the system looks for the context ID.
This CollectionID is the Collection ID used in Servigistics InService.
This CollectionID will be connected to a level in the Product Hierarchy. There must be a match between the CollectionID and a node in the ProductHierarchy.csv file.
Optional
String
IsAuthoredDoc
Provides the default language, for example, en-US.
Required
String
ContextIDs
Provides a semi-colon separated list of all contexts applicable for the bundle. The system uses this information to resolve the mapping to the collections.
If the Context is not provided, the toc.csv file must be provided in the bundle. Otherwise, the bundle load will fail due to missing context or collection.
If both Collection and Context are provided, the system uses the Context.
Optional
String
Product Hierarchy
The CSV bundle contains the producthierarchy.csv file with the following information for creating the Product Structure:
CSV Column
Description
Required / Optional
Format
Toc Code
Provides a unique code for this PH entity. Note that each node in the PH must have a unique code.
Required
String
Parent Entity Code
Provides a PH entity code for the parent of Toc Code. This is used to construct the product hierarchy structure. The root PH code must refer to the ContextIDs (or CollectionID) value in the properties.csv file.
Required
String
Image Code
Represents the thumbnail image of current PH node.
To add a new image, the image.csv file and the associated image file must be included in the CSV input bundle. If the image is not in the bundle, the PH loads without it.
Optional
String
Description_lang
The textual description of this PH entry in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Description_en for a description in English.
Required with a minimum of one occurrence and a maximum five occurrences
String{1,256}
Applicability
Provides context, serial numbers, other options and choices, or date applicability in APEX format.
Use the following properties to define the applicability:
• PRODUCT – Used to specify the product context effectivity
• INSTANCE_RANGE – Used to specify the serial number effectivity
• DATE_RANGE – Used to specify the date effectivity
• IS – Used to specify the options and choices effectivity
The following example shows only product context and serial number effectivity:
(AND (PRODUCT '0000016615')) (AND (PRODUCT '0000016615') (INSTANCE_RANGE '1' '200') ) (AND (PRODUCT '0000016615') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')) (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')))
This example shows all service effectivity properties:
(AND (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0'))) (AND (IS 'Color' 'Blue' 'Red') (IS 'Country' 'USA' 'UK' 'India') ) )
Optional
See Description
Note the following about the product hierarchy (PH) data:
• You can load and combine multiple product hierarchy files originating from different sources (for example, SIM and CSV inputs).
The prioritization for loading the different sources is determined in the IMAN configuration file (IMANConfig.xml). All product hierarchy files will be merged at the root level.
• You can load and support as many product hierarchy levels as needed.
The last level in the PH will be the Model. All Model related functionality should work.
• Product hierarchy levels are set in producthierarchy.csv, and the Information Structure levels are part of the toc.csv. You can set as many PH and IS levels as needed.
• For every Collection, the product hierarchy CSV and the Supporting Images and Image Mapping file must be duplicated and reused for each Collection.
• The logical expressions allowed in the Applicability column are restricted. The filters in the Servigistics InService interface display the options and choices that are applicable to the current PH context. Usually, the system displays the options and choices that are common in both the definition for the PH context and the logical expression defined in the PH node. To support this during the transformation of the PH, there is a restriction on the type of logical expression that can be used.
Simple logical expressions with the AND operation are supported. For example: (AND (IS ‘region’ ‘india’ ‘us’) (IS ‘color’ ‘white’ ‘blue’) … ). This expression says the region is India or the US AND the color is white or blue.
The following types of logical expressions are not supported:
◦ Complex logical expressions with AND and OR operations
For example: (OR (AND (IS ‘region’ ‘india’) (IS ‘color’ ‘white’ )) (AND (IS ‘region’ ‘us’) (IS ‘color’ ‘blue’ )) … ).
◦ Numeric comparison operations such as LESS THEN or GREATER THEN
◦ Logical expressions with NOT operations
Information Structure
The CSV bundle contains the toc.csv file with the following information for creating the information structure (table of contents or IS):
CSV Column
Description
Required / Optional
Format
Toc Code
Provides a unique ID for the TOC node in the entire TOC structure.
Required
String{1,115}
Parent Entity Code
Used to specify the level in the PH that corresponds to this IS. This provides the link between the product hierarchy and the information structure.
Required
String{1,115}
Type
Defines the level within the TOC at which the entity resides. Levels must be created in numerical order. Possible values include the following:
• 4 – Group (folder)
• 5 – Document (assembly or service information PDF/XML)
Required
[4–5]{1}
Format
Provides the format of a document. Possible values are assembly, iepdf, iexml, and iegraphics.
Required for Type 5 only
assembly|pdf
Order
Provides the order of the entry among its sibling nodes at the same level in the TOC. If none is specified, then the order is alphabetical.
Required
Numeric[1-9][0-9]*
Document Code
Refers to a document (assembly, PDF or XML document) that is associated with this TOC entry
Required for TOC Type = 5 (Document)
String{1,115}
Image Code
Represents the thumbnail image of current TOC node.
To add a new image, the image.csv file and the associated image file must be included in the CSV input bundle. If the image is not in the bundle, the TOC loads without it.
Optional
String{1,64}
Description_lang
The textual description of this PH entry in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Description_en for a description in English.
Required with a minimum of one occurrence and a maximum five occurrences
String{1,256}
Context and SN
A column with just SN column name can also be used.
Provides a combination of context and serial numbers applicable for each of the IS (folder) entry levels. You can provide a SN, Context, or a combination in the following format: Context1:SN1; Context2:SN2. For example:
• Only Context – Context1:;Context2:
• Only SN – :SN1;:SN2
• One SN – :SN
• Combination – Context1:SN1;Context2:SN2
To specify a range of serial numbers, the beginning serial number and ending serial number should concatenate with “~”. For example:
12532~12899;20001~20100
Optional
String
Applicability
Provides context, serial numbers, other options and choices, or date applicability in APEX format.
Use the following properties to define the applicability:
• PRODUCT – Used to specify the product context effectivity
• INSTANCE_RANGE – Used to specify the serial number effectivity
• DATE_RANGE – Used to specify the date effectivity
• IS – Used to specify the options and choices effectivity
The following example shows only product context and serial number effectivity:
(AND (PRODUCT '0000016615')) (AND (PRODUCT '0000016615') (INSTANCE_RANGE '1' '200') ) (AND (PRODUCT '0000016615') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')) (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')))
This example shows all service effectivity properties:
(AND (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0'))) (AND (IS 'Color' 'Blue' 'Red') (IS 'Country' 'USA' 'UK' 'India') ) )
Optional
See Description
Delete
A Boolean flag used to mark a certain IE (XML, PDF, GRAPHIC or PARTSLIST) for deletion as part of the incremental update process.
Note that if you mark a parts list for deletion in this file, it only removes the parts list from the information structure. If you want to remove the parts list from the repository, you must also indicate that in the assembly_mapping.csv file
Set this to True (case insensitive) value to mark a certain entry for deletion, otherwise, keep the column blank.
* 
If you want to delete the entire information structure, set the value of this column to True on the highest node of the structure. In this case, the entire structure and all of its relations with the associated IE and assembly content is deleted. The associated IE and assembly content remains in the repository and can be searched for in the user interface.
Optional
Boolean
Each information structure must be loaded in its entirety and cannot be loaded in increments. You can still maintain different information structures using different toc.csv files and load those separately.
Product Instance
The CSV bundle contains the productinstance.csv file with the following information for creating the Serial number to Model mapping:
CSV Column
Description
Required / Optional
Format
Model
Specifies a specific PH level (product family or model) from the PH.
Required
String
SN
Specifies an existing serial number only used in the TOC.csv file. There is no need to specify the context here, as it is resolved using the TOC hierarchy with which the model is associated.
This is used, when required, to filter data from the TOC that is not applicable for this product.
In there is more than one serial number associated with the TOC and assembly entries, multiple lines are required. Each line must have one serial number.
Required
String
Delete
A Boolean flag used to mark a certain PI entry for deletion as part of the incremental update process.
Set it to True (case insensitive) value to mark a certain entry for deletion, otherwise, keep blank.
Optional
Boolean
Title
Specifies the title of the PI.
Optional
String{1,115}
Description
Provides a description of the PI.
Optional
String{1,115}
AlternateSerialNumber
Specifies the alternate serial number for the PI.
Optional
String{1,115}
SalesOrderNumber
Specifies the sales order number for the PI.
Optional
String{1,115}
alias1
Provides metadata information for the PI.
Optional
String{1,115}
alias2
Provides metadata information for the PI.
Optional
String{1,115}
alias3
Provides metadata information for the PI.
Optional
String{1,115}
Image Code
Refers to the filename of an image associated with the PI. This image is used for Visual Navigation.
Note that for the thumbnail image to be loaded, you must include the image.csv file and the image file in the bundle.
Optional
String{1,115}
Assembly
The CSV bundle contains the assembly.csv (Parts Lists) file with the following information for creating the Assembly information:
CSV Column
Description
Required / Optional
Format
Assembly Code
Specifies a unique code for this assembly (parts list). This should match the code of an existing TOC entity.
Required
String{1,115}
Part Code
Specifies the code of an existing part.
The describing part is specified where “Assembly Code=Part Code”. If the describing part is identified as a kit (in part.csv), the entire assembly will be marked as a kit.
Required
String{0,63}
Conf Code
If the Part Code is not unique and the same part appears more than once in the assembly, this value is included to provide a unique code to distinguish between the parts.
Optional
String{0,63}
Part Order
Specifies the order of this part in the parts list in a numeric value.
Required
Integer value greater than zero
Part Quantity
Specifies the quantity of this part in the assembly.
Required
String{1,16}
UOM_lang
Specifies the unit of measure value for the part in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: UOM_en for a name in English.
Optional
String
Image Code
Specifies the Code for the image in which this part appears. This can contain multiple images applicable for the specific part in the assembly.
Optional
String{1,64}
Hotspot Key
Refers to the hotspot information specified in the hotspot.csv file.
Optional
String{0,64}
Orderable
Specifies whether this part can be ordered.
Possible values are yes or no.
Optional with a default of yes.
yes|no
Additional_Detail_xxx
Provides a flexible field that can be loaded into the parts list to provide additional metadata attributes that are not supported by default. These new attributes are not supported in multiple languages.
If you want to add any additional parameters, you can pass those using Additional_Detail_xxx. Note that xxx is the actual attribute name stored in Servigistics InService.
If the xxx portion of the name is the exact match of the element name of the default Servigistics InService parts list XML schema, then value of this field is mapped to the element.
Optional
When mapping to the default Servigistics InService parts list element, the value should follow the format of the element. That is, the value of Additional_Detail_Indenture must have a digit value.
Otherwise, you can specify any string here, though the fields cannot have language variants.
Context and SN
A column with just the SN column name can also be used.
Provides a combination of context and serial numbers applicable for the assembly. You can provide a SN, Context, or a combination in the following format: Context1:SN1; Context2:SN2. For example:
• Only Context – Context1:;Context2:
• Only SN – :SN1;:SN2
• One SN – :SN
• Combination – Context1:SN1;Context2:SN2
To specify a range of serial numbers, the beginning serial number and ending serial number should concatenate with “~”. For example:
12532~12899;20001~20100
Optional
See Description
Applicability
Provides context, serial numbers, other options and choices, or date applicability in APEX format.
Use the following properties to define the applicability:
• PRODUCT – Used to specify the product context effectivity
• INSTANCE_RANGE – Used to specify the serial number effectivity
• DATE_RANGE – Used to specify the date effectivity
• IS – Used to specify the options and choices effectivity
The following example shows only product context and serial number effectivity:
(AND (PRODUCT '0000016615')) (AND (PRODUCT '0000016615') (INSTANCE_RANGE '1' '200') ) (AND (PRODUCT '0000016615') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')) (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')))
This example shows all service effectivity properties:
(AND (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0'))) (AND (IS 'Color' 'Blue' 'Red') (IS 'Country' 'USA' 'UK' 'India') ) )
Optional
See Description
Org Name
The Organization Name provides the Vendor Code. This is mapped in the IMAN file.
Any assembly that is not assigned an Org Name is assigned the Org Name value from properties.csv as the default value.
Optional
String{1,115}
Assembly information must be loaded in its entirety. It cannot be loaded or updated incrementally.
This file also must be provided with the related Assembly information, including Parts and Hotspots.
Part and Part Documents
The CSV bundle contains the part.csv file with the following information for a part. It can also optionally provide the related documents for a part through the Related Documents column.
CSV Column
Description
Required / Optional
Format
Part Code
Specifies a unique code for the part.
Required
String
Obsolete
Specifies whether this part is obsolete.
Possible values are yes or no.
Optional with a default of no.
yes|no
Orderable
Specifies whether this part can be ordered.
Possible values are yes or no.
Optional with a default of yes.
yes|no
Image Code
Specifies the Code for the image in which this part appears. This can contain multiple images applicable for the part.
* 
If you provide multiple images for the part, be sure to put the image you want to appear by default as the first image. For example, if you want to use an interactive PVZ image as the primary one for the part, put it first in the list of images.
Optional
String{1,64}
Description_lang
The textual description of this entry in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Description_en for a description in English.
Required with a minimum of one occurrence and a maximum five occurrences
String{1,256}
Name_lang
Specifies the name of the part in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Name_en for a name in English.
Optional
String
UOM_lang
Specifies the unit of measure value for the part in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: UOM_en for a name in English.
Optional
String
Additional Detail_name
Provides a flexible field that enables you to specify new metadata attributes for the part that are not provided by default. These new attributes are not supported in multiple languages.
Note that name represents the unique name of the part’s new metadata that you devise. For example, if you wanted to add the dealer price as metadata, you could use an Additional Detail_DealerPrice column.
For another example, you could add an Additional_Details_isKit column with the value true if you want the Part to be identified as Kit.
If the part is a describing part (refer to the Part Code in assembly.csv), the entire assembly that is described by that part will be marked as a kit.
Optional
String{0,256}
Context and SN
A column with just the SN column name can also be used.
Provides a combination of context and serial numbers applicable for the part. You can provide a SN, Context, or a combination in the following format: Context1:SN1; Context2:SN2. For example:
• Only Context – Context1:;Context2:
• Only SN – :SN1;:SN2
• One SN – :SN
• Combination – Context1:SN1;Context2:SN2
To specify a range of serial numbers, the beginning serial number and ending serial number should concatenate with “~”. For example:
12532~12899;20001~20100
Optional
See Description
Applicability
Provides context, serial numbers, other options and choices, or date applicability in APEX format for the part item. If you want to define applicability for a PartsList line item, you must define that in the assembly.csv file.
Use the following properties to define the applicability:
• PRODUCT – Used to specify the product context effectivity
• INSTANCE_RANGE – Used to specify the serial number effectivity
• DATE_RANGE – Used to specify the date effectivity
• IS – Used to specify the options and choices effectivity
The following example shows only product context and serial number effectivity:
(AND (PRODUCT '0000016615')) (AND (PRODUCT '0000016615') (INSTANCE_RANGE '1' '200') ) (AND (PRODUCT '0000016615') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')) (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')))
This example shows all service effectivity properties:
(AND (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0'))) (AND (IS 'Color' 'Blue' 'Red') (IS 'Country' 'USA' 'UK' 'India') ) )
Optional
See Description
Org Name
The Organization Name provides the Vendor Code. This is mapped in the IMAN file.
Any part that is not assigned an Org Name is assigned the Org Name value from properties.csv as the default value.
Optional
String{1,115}
Related Documents
Provides a semicolon (;) separated list of IE document codes that are related to this part.
Supported IE types are IEXML, PDF, and GRAPHIC. Please note the specified document code should refer to the document code or identifying code of the IE contained in the IE mapping files.
Optional
[IEXML| IEPDF|IEGRAPHIC]: <DOC_CODE>;
For example: IEXML: XML49; XML33; IEPDF: P444; IEGRAPHIC:9888;
Note that each entry in the document code list must be separated with a semicolon, even if it is a single value.
Delete
A Boolean flag that is used to mark a certain part for deletion as part of the incremental update process.
Set this to True (case insensitive) value to mark a certain entry for deletion, otherwise, keep the column blank.
Optional
Boolean
Hotspots
The CSV data loading supports hotspots for 2D raster image formats such as .jpg and .png. The hotspot.csv file includes the hotspot definition. The definition includes the following information:
CSV Column
Description
Required / Optional
Format
Image Code
Specifies an assembly image. Note that this is not applicable for CGM, PVZ and SVG format illustrations.
Required
String{1,64}
Hotspot Key
Specifies the number of the hotspot in the image and a reference to a part in a parts list in the assembly.csv file.
Required
String{1,64}
Hotspot Left X
Specifies the left horizontal coordinate of hotspot region in the image from the left side in pixels.
Required
Integer
Hotspot Top Y
Specifies the top vertical coordinate of hotspot region in the image from the top in pixels.
Required
Integer
Hotspot Width
Specifies the width of hotspot region in the image in pixels.
Required
Integer
Hotspot Height
Specifies the height of hotspot region in the image in pixels.
Required
Integer
This information will also be used with the parts list information in the CSV format. When generating the parts list file, the CSV data loading process inserts the hotspot information into the parts list metadata section.
Part Relations
The CSV bundle contains the part_relations.csv file with the following information for superseded, alternate, cross referenced, and supplementary parts:
CSV Column
Description
Required / Optional
Format
Source Part Code
Specifies the part that is in the source of the relation. Refers to the code of an existing part.
If the source part within a supersession chain groups or consists of multiple parts, then you must provide a semi-colon separated list of part codes.
In the case of a supersession chain, this is used to represent an N:1 relation.
Required
String{0,63}
Target Part Code
Specifies the part that is the target in the part relation. Refers to the code of an existing part.
If the target part within a supersession chain groups or consists of multiple parts, then you must provide a semi-colon separated list of part codes.
In case of supersession chain this will be used to represent an 1:N relation.
Required. Minimum one occurrence
String{0,63}
Target Part Quantity
Specifies the quantity of this part in the assembly.
If the Target Part Code column groups multiple parts, provide a semi-colon separated list of part quantities for each corresponding part.
Required
Integer{1,16}
Relation
Specifies the part relation type. Possible values::
• Supersession
• Alternate
• Xref
• Supplementary
Required
Supersession|Alternate|Xref| Supplementary
Comment_lang
Provides a comment about this entry in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Comment_en for a name in English.
This field is for the data author and is not used in Servigistics InService.
Optional.
Maximum five Occurrences
String{1,256}
Source Org Name
The Organization Name provides the Vendor Code. This is mapped in the IMAN file. There can be multiple entries, separated by a semicolon (;).
Any source part that is not assigned an Org Name is assigned the Org Name value from properties.csv as the default value.
Optional
String{1,115}
Target Org Name
The Organization Name provides the Vendor Code. This is mapped in the IMAN file. There can be multiple entries, separated by a semicolon (;).
Any target part that is not assigned an Org Name is assigned the Org Name value from properties.csv as the default value.
Optional
String{1,115}
Delete
A Boolean flag that is used to mark a certain part relation for deletion as part of the incremental update process.
Set this to True (case insensitive) value to mark a certain entry for deletion, otherwise, keep the column blank.
Optional
Boolean
The Source Part Code and Target Part Code columns refer to an existing Part Code entry in the part.csv file.
* 
In previous releases, this information was included in the alternative_parts.csv file. This file is no longer supported. The first column in the old file was named Alternate Source Part Code. That column is named Source Part Code in the new file. A unique part relationship consists of the following elements:
• Source Part Code
• Source Org Name
• Target Part Code
• Target Org Name
• Relation
Product Invoice Information
The CSV bundle contains the bom.csv file with the information for a product invoice or BOM. A BOM provides the parts and other information that apply specifically to a release of a particular serial number or other context. The file contains the following information:
CSV Column
Description
Required / Optional
Format
Object Number
Specifies a unique identifier for the BOM.
Required
String{0,64}
Context ID
Specifies the context ID that applies to the BOM. This should match a node in the product hierarchy.
Required
String{0,64}
Sales Model
Specifies the product’s sales model.
* 
This column is not currently used.
Optional
String{0,64}
Build Date
Specifies the date the product was built.
* 
This column is not currently used.
Optional
String
Test Date
Specifies the date the product was tested.
* 
This column is not currently used.
Optional
String
Ship Date
Specifies the date the product was shipped.
* 
This column is not currently used.
Optional
String
Delete BOM
A Boolean flag that is used to mark a certain BOM structure for deletion as part of the incremental update process.
Set this to True (case insensitive) value to mark a certain entry for deletion, otherwise, keep the column blank.
Optional
Boolean
Comment_lang
Provides a comment about this entry in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Comment_en for a name in English.
This field is for the data author and is not used in Servigistics InService.
Optional with a maximum of five occurrences
String{1,256}
Product Invoice Information Collection
The CSV bundle contains the bomcollections.csv file with the information for the parts contained in a product invoice or BOM. A BOM provides the parts and other information that apply specifically to a release of a particular serial number or other context. The file contains the following information:
CSV Column
Description
Required / Optional
Format
Object Number
Provides a reference to the BOM identifier in the bom.csv file that is associated with this collection.
Once collection could map to multiple BOM structures (bom.csv files.
Required
String{0,64}
SerializedComponent Object Number
Specifies the "captive" object (SN) serial number for a serializedcomponent Collection Type. This value is ignored for other types.
Optional
String{0,64}
Collection Type
Specifies the type of BOM collection. Possible values are parts or serializedcomponents. If another value or no value is provided, the entry is not loaded. Additional or different categories are loaded, but not reflected in the user interface.
Optional
String
Display Order
Specifies the display order for this collection. 1 is the highest order.
Optional
Integer
Part Number
Specifies the part number included in the collection.
Required
String{0,63}
Part Name_lang
The textual part name in the specified language. You must include a separate column for each language.
Note that lang represents the language code in ISO 639-1 format. For example: Part Name_en for a name in English.
Optional
String
Quantity
Specifies the quantity of the part number (part line item) in the BOM.
Required
Integer{1,16}
Part Indenture
Specifies how much to indent the part name in the Servigistics InService user interface.
Optional
Integer
Processed Date
Specifies the date the BOM was processed.
Used for serializedcomponent items only.
Optional
String
Build Date
Specifies the date the BOM was built.
Used for serializedcomponent items only.
Optional
String
Test Date
Specifies the date the BOM was tested.
Used for serializedcomponent items only.
Optional
String
Ship Date
Specifies the date the BOM was shipped.
Used for serializedcomponent items only.
Optional
String
Last Modified Date
Specifies the date the BOM was last modified.
Used for serializedcomponent items only.
Optional
String
Comment_lang
Provides a comment about this entry in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Comment_en for a name in English.
This field is for the data author and is not used in Servigistics InService.
Optional.
Maximum five Occurrences
String
Org Name
The Organization Name provides the Vendor Code. This is mapped in the IMAN file.
Any BOM that is not assigned an Org Name is assigned the Org Name value from properties.csv as the default value.
Optional
String{1,115}
Graphic Mapping
The CSV bundle contains the graphic.csv file with the following graphic mapping information:
CSV Column
Description
Required / Optional
Format
GRAPHIC Code
Specifies a unique identifier for the graphic.
Required
String{1,256}
Info Type
Specifies the information type used in Servigistics InService.
The information type is metadata that enables a user to filter the items in both the Information Structure and search results. For example, you could set the information type to “Service Information” or “Parts List”. This metadata information is also searchable.
Optional
String{1,128}
File Name_lang
Specifies the relative path to the GRAPHIC (in the GRAPHIC root directory) including the file name.
Note that lang represents the language code in ISO 639-1 format. For example: File Name_en for a name in English.
Required. Minimum one occurrence.
String{1,256}
Description_lang
Specifies the textual description of the graphic in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Description_en for a name in English.
Required. Minimum one occurrence, maximum five occurrences.
String{1,256}
Context and SN
A column with just the SN column name can also be used.
Provides a combination of context and serial numbers applicable for the GRAPHIC IE. You can provide a SN, Context, or a combination in the following format: Context1:SN1; Context2:SN2. For example:
• Only Context – Context1:;Context2:
• Only SN – :SN1;:SN2
Note that this is not supported for IE only bundles that do not contain a toc.csv file.
• One SN – :SN
• Combination – Context1:SN1;Context2:SN2
To specify a range of serial numbers, the beginning serial number and ending serial number should concatenate with “~”. For example:
12532~12899;20001~20100
Optional
See Description
Applicability
Provides context, serial numbers, other options and choices, or date applicability in APEX format.
Use the following properties to define the applicability:
• PRODUCT – Used to specify the product context effectivity
• INSTANCE_RANGE – Used to specify the serial number effectivity
• DATE_RANGE – Used to specify the date effectivity
• IS – Used to specify the options and choices effectivity
The following example shows only product context and serial number effectivity:
(AND (PRODUCT '0000016615')) (AND (PRODUCT '0000016615') (INSTANCE_RANGE '1' '200') ) (AND (PRODUCT '0000016615') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')) (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')))
This example shows all service effectivity properties:
(AND (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0'))) (AND (IS 'Color' 'Blue' 'Red') (IS 'Country' 'USA' 'UK' 'India') ) )
Optional
See Description
Delete
A Boolean flag that is used to mark a certain GRAPHIC IE for deletion as part of the incremental update process.
Set this to True (case insensitive) value to mark a certain entry for deletion, otherwise, keep the column blank.
Optional
Boolean
Note that you can load graphic files of various formats as Graphic Information Elements (GRAPHIC IEs) including 3D model illustrations (PVZs or SVGs) and 3D model illustrations with hotspots. You can also view and access images embedded within an IE XML file.
Image Mapping
The CSV bundle contains the image.csv file with the following image mapping information:
CSV Column
Description
Required / Optional
Format
Image Code
Specifies a unique code for this image.
Required
String{1,64}
File Name
Specifies the relative path of the image file (in the Images root directory) including the file name.
Required
String
Image Height
Specifies the image height. If not provided, the default user interface size is used.
Optional
Integer
Image Width
Specifies the image width. If not provided, the default user interface size is used.
Optional
Integer
Title_lang
Specifies the title of this entity in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Description_en for a description in English.
Optional with a maximum of five occurrences
String{0,256}
Context and SN
A column with just the SN column name can also be used.
Provides a combination of context and serial numbers applicable for the image. You can provide a SN, Context, or a combination in the following format: Context1:SN1; Context2:SN2. For example:
• Only Context – Context1:;Context2:
• Only SN – :SN1;:SN2
• One SN – :SN
• Combination – Context1:SN1;Context2:SN2
To specify a range of serial numbers, the beginning serial number and ending serial number should concatenate with “~”. For example:
12532~12899;20001~20100
Optional
[0-9A-Za-z\-]{0,64}
Applicability
Provides context, serial numbers, other options and choices, or date applicability in APEX format.
Use the following properties to define the applicability:
• PRODUCT – Used to specify the product context effectivity
• INSTANCE_RANGE – Used to specify the serial number effectivity
• DATE_RANGE – Used to specify the date effectivity
• IS – Used to specify the options and choices effectivity
The following example shows only product context and serial number effectivity:
(AND (PRODUCT '0000016615')) (AND (PRODUCT '0000016615') (INSTANCE_RANGE '1' '200') ) (AND (PRODUCT '0000016615') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')) (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')))
This example shows all service effectivity properties:
(AND (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0'))) (AND (IS 'Color' 'Blue' 'Red') (IS 'Country' 'USA' 'UK' 'India') ) )
Optional
See Description
Delete
A Boolean flag that is used to mark a certain image for deletion as part of the incremental update process.
Set this to True (case insensitive) value to mark a certain entry for deletion, otherwise, keep the column blank.
Optional
Boolean
PDF Mapping
The CSV bundle contains the pdf.csv file with the following information for the location of PDF files:
CSV Column
Description
Required / Optional
Format
PDF Code
Specifies a unique identifier for the PDF, and its translations in multiple languages, if any exist.
Required
String{1,256}
Info Type
Specifies the information type used in Servigistics InService.
The information type is metadata that enables a user to filter the items in both the Information Structure and search results. For example, you could set the information type to “Service Information” or “Parts List”. This metadata information is also searchable.
Optional
String{1,128}
File Name_lang
Specifies the relative path to the PDF (in the PDF root directory) including the file name.
Note that lang represents the language code in ISO 639-1 format. For example: File Name_en for a name in English.
Required. Minimum one occurrence.
String{1,128}
Description_lang
Specifies the textual description of the PDF file in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Description_en for a name in English.
Required. Minimum one occurrence, maximum five occurrences.
String{1,256}
Context and SN
A column with just the SN column name can also be used.
Provides a combination of context and serial numbers applicable for the PDF IE. You can provide a SN, Context, or a combination in the following format: Context1:SN1; Context2:SN2. For example:
• Only Context – Context1:;Context2:
• Only SN – :SN1;:SN2
Note that this is not supported for IE only bundles that do not contain a toc.csv file.
• One SN – :SN
• Combination – Context1:SN1;Context2:SN2
To specify a range of serial numbers, the beginning serial number and ending serial number should concatenate with “~”. For example:
12532~12899;20001~20100
Optional
See Description
Applicability
Provides context, serial numbers, other options and choices, or date applicability in APEX format.
Use the following properties to define the applicability:
• PRODUCT – Used to specify the product context effectivity
• INSTANCE_RANGE – Used to specify the serial number effectivity
• DATE_RANGE – Used to specify the date effectivity
• IS – Used to specify the options and choices effectivity
The following example shows only product context and serial number effectivity:
(AND (PRODUCT '0000016615')) (AND (PRODUCT '0000016615') (INSTANCE_RANGE '1' '200') ) (AND (PRODUCT '0000016615') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')) (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')))
This example shows all service effectivity properties:
(AND (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0'))) (AND (IS 'Color' 'Blue' 'Red') (IS 'Country' 'USA' 'UK' 'India') ) )
Optional
See Description
Delete
A Boolean flag that is used to mark a certain PDF IE for deletion as part of the incremental update process.
Set this to True (case insensitive) value to mark a certain entry for deletion, otherwise, keep the column blank.
Optional
Boolean
XML Mapping
The CSV bundle contains the xml.csv file with the following information for the location of XML files:
CSV Column
Description
Required / Optional
Format
XML Code
Specifies a unique identifier for the XML file.
Required
String{1,256}
Info Type
Specifies the information type used in Servigistics InService.
The information type is metadata that enables a user to filter the items in both the Information Structure and search results. For example, you could set the information type to “Service Information” or “Parts List”. This metadata information is also searchable.
Optional
String{1,128}
File Name_lang
Specifies the relative path to the XML (in the XML root directory) including the file name.
Note that lang represents the language code in ISO 639-1 format. For example: File Name_en for a name in English.
Required. Minimum one occurrence.
String{1,256}
Description_lang
Specifies the textual description of the XML file in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Description_en for a name in English.
Required. Minimum one occurrence, maximum five occurrences.
String{1,256}
Context and SN
A column with just the SN column name can also be used.
Provides a combination of context and serial numbers applicable for the XML IE. You can provide a SN, Context, or a combination in the following format: Context1:SN1; Context2:SN2. For example:
• Only Context – Context1:;Context2:
• Only SN – :SN1;:SN2
Note that this is not supported for IE only bundles that do not contain a toc.csv file.
• One SN – :SN
• Combination – Context1:SN1;Context2:SN2
To specify a range of serial numbers, the beginning serial number and ending serial number should concatenate with “~”. For example:
12532~12899;20001~20100
Optional
See Description
Applicability
Provides context, serial numbers, other options and choices, or date applicability in APEX format.
Use the following properties to define the applicability:
• PRODUCT – Used to specify the product context effectivity
• INSTANCE_RANGE – Used to specify the serial number effectivity
• DATE_RANGE – Used to specify the date effectivity
• IS – Used to specify the options and choices effectivity
The following example shows only product context and serial number effectivity:
(AND (PRODUCT '0000016615')) (AND (PRODUCT '0000016615') (INSTANCE_RANGE '1' '200') ) (AND (PRODUCT '0000016615') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')) (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0')))
This example shows all service effectivity properties:
(AND (AND (PRODUCT '0000016615') (OR (INSTANCE_RANGE '1' '200') (DATE_RANGE '2015-01-01 00:00:00.0' '2017-01-01 00:00:00.0'))) (AND (IS 'Color' 'Blue' 'Red') (IS 'Country' 'USA' 'UK' 'India') ) )
Optional
See Description
Delete
A Boolean flag that is used to mark a certain XML IE for deletion as part of the incremental update process.
Set this to True (case insensitive) value to mark a certain entry for deletion, otherwise, keep the column blank.
Optional
Boolean
Note that you can view and access images embedded within an IE XML file.
Parts List Mapping
The CSV bundle contains the assembly_mapping.csv file with the following information for the location of parts list files:
CSV Column
Description
Required / Optional
Format
Assembly Code
Specifies a unique identifier for the parts list.
Required
String{1,256}
Name_lang
Specifies the name of the parts list in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Name_en for a name in English.
Optional
String
Description_lang
Specifies the textual description of the parts list in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Description_en for a name in English.
Required. Minimum one occurrence, maximum five occurrences.
String{1,256}
Info Type
Specifies the information type used in Servigistics InService.
The information type is metadata that enables a user to filter the items in both the Information Structure and search results. For example, you could set the information type to “Service Information” or “Parts List”. This metadata information is also searchable.
Optional
String{1,128}
Delete
A Boolean flag that is used to mark a certain parts list for deletion as part of the incremental update process.
Note that the parts list must also be marked for deletion in the toc.csv file, or it will not be deleted. If the parts list is only flagged for deletion in the toc.csv and not marked for deletion in this file, then the entry for the parts list is removed from the information structure but the parts list remains in the repository.
Set this to True (case insensitive) value to mark a certain entry for deletion, otherwise, keep the column blank.
Optional
Boolean
Options and Choices
The CSV bundle contains the following two files to provide options and choices related data:
• OptionsChoiceDefinition.csv – Provides multilingual information for options and choices
• OptionsChoices_Applicability.csv – Provides the mapping of the options and choices to the corresponding PH entry
OptionsChoiceDefinition.csv has the following columns:
CSV Column
Description
Required / Optional
Format
Option_Code
Specifies the name of the option. For example: Color. This column only allows a single value.
Required
String
Option_lang
Specifies the name of the option in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Option_fr for a name in French.
Optional
String
Choice_Code
Specifies the name of a choice for the option. For example: Green. This column only allows a single value.
Required
String
Choice_lang
Specifies the name of the choice in the specified language.
Note that lang represents the language code in ISO 639-1 format. For example: Choice_fr for a name in French.
Optional
String
OptionsChoices_Applicability.csv has the following columns:
CSV Column
Description
Required / Optional
Format
Applicability
Specifies the value of the PH entry to which the options and choices apply.
Required
String
Option_Code
Specifies the name of the option. For example: Color. This column only allows a single value. Use multiple columns if you need to specify multiple values.
Required
String
Choice_Code
Specifies the name of a choice for the option. For example: Green. This column only allows a single value. Use multiple columns if you need to specify multiple values.
Required
String