Traceparts

File structure

Table of content

Products_XX tabs

“Product_XX” fields

Field nameStatusDefinition



Product_ID


Required
Identifier that you use to identify a product in your system.

Authorized characters are: “A-Z”, “a-z”, “0-9”, “_”, “.”
All other characters, such as characters with accents or space, are not allowed.

To group several part numbers together in the same product, repeat the same product ID for each line of each part number.

For any one product, this value must be the same in each “Products_xx” tab, as it is used to group data between tabs.

Examples: “Part_1”, “EAC.010_120”, “ABC123”




Product_Name


Required
Defines a name for the product.
The maximum number of characters for each product name is 255.

Example: “Hexagon socket head cap screw, DIN 912 (ref 527)”




Product_Short_Description


Optional
Used to enter a short description of the product.
The maximum number of characters for each short description is 255.




Product_Long_Description


Optional
Used to enter a more detailled description of the product.

The maximum number of characters for each long description is 2000.





Classification_Category_ID


Required
Identifier used for specifying a category in the classification.

The list of authorized identifiers is defined in the “ClassificationAdvancedTemplate” Excel file, supplied with the archive file when you downloaded the empty template.

Only the identifier of the category in which you classified your product is required (not the full path from the root).

For any one product, this value must be the same in each “Products_xx” tab.




Product_Large_Picture_
FileName


Optional
Supplies the name of the image file showing the product.

The image must be supplied together with the completed XLS template.

Recommended picture size is 460 x 340 pixels. Larger pictures will be resized.

If not provided, TraceParts will try to extract a screenshot from the supplied CAD file.
For any one product, this value must be the same in each “Products_xx” tab.

Example: “LargeProductPicture1.gif”

The “Product_ID” you provided is stored in the TraceParts System.
When you provide a template with a “Product_ID” that doesn’t exist in the TraceParts Sytem, a new product is created in the TraceParts System.


If you then provide a second template with a “Product_ID” that already exists in the TraceParts System, the existing product is overwritten.

“Document” fields

Field nameStatusDefinition

Product_Document_
FileName
( + “_” + document
number)
Optional
Specifies the file name of any document linked to the product.

The maximum number of characters for each file name is 100.

The authorized file types are defined here.
Documents must be supplied together with the completed XLS template.
This information is linked to the information in the “Product_Document_Title” field below.

Examples:
“Catalogue_Page.pdf”, “Presentation.html”


Product_Document
_Title
( + “_” + document
number )
Optional but
recommended
for each
document
declared in “Product_Document_
FileName”
This information is linked to the information in the “Product_Document_FileName” field above.
It specifies the title to be displayed to the user, next to the link to the document, instead of the actual file name.

The maximum number of characters for each document title is 255.

Examples: ”Technical document”, “Datasheet”


Product_Document
_URL
( + “_” + URL number )
Optional
Specifies an URL that points to an online document linked to the product.
This information is linked to the information in the “Product_Document_URL_Title” field below.

The protocol (http, https, etc.) is required in the URL.

The maximum number of characters for each URL is 2000.

Example: “/help/fr/Main.htm”


Product_Document
_URL_Title
( + “_” + URL number )
Optional but
recommended
for each URL
declared in
“Product_Document_
URL”
This information is linked to the information in the “Product_Document_URL” field above.

It specifies a title for the corresponding link, to be displayed to the user, instead of the actual URL.

The maximum number of characters for each URL title is 255.

Example: “TraceParts Online Help”


Part_Number_
EShop_URL
Optional
Specifies an URL that points to an online E-shop linked to the product.

This information is linked to the information in the “Part_Number_EShop_URL_DisplayedValue” field below. The protocol (http, https, etc.) is required in the URL.

The maximum number of characters for each URL is 2000.

The “Request for quotation” tab on www.traceparts.com is replaced by a new tab “Buy now”.


Part_Number_
EShop_URL
_DisplayedValue
Optional but
recommended
for each URL
declared
in “Part_Number_
EShop_URL”
This information is linked to the information in the “Part_Number_EShop_URL” field above.

It specifies a title for the corresponding link, to be displayed to the user, instead of the actual URL.

The maximum number of characters for each URL title is 255.


Product_Dimensional_
Drawing_FileName
( + “_” + dimensional
drawing number )
Optional

Specifies the file name of the dimensional drawing linked to the product.
The maximum number of characters for each file name is 100.

This information is linked to the information in the “Product_Dimensional_Drawing_Title” field below.

Files must be supplied together with the completed XLS template.

The authorized file types are picture formats (.gif, .png, .jpg, .bmp).

Example: “Front_View.gif”, “tech_doc_1.png”


Product_Dimensional_
Drawing_Title ( + “_” + dimensional
drawing number )
Optional but
recommended
for each
dimensional
drawing declared in
“Product_
Dimensional_
Drawing_FileName”
This information is linked to the information in the “Product_Dimensional_Drawing_FileName” field above.

It specifies a title for the corresponding drawing, to be displayed to the user, instead of the actual file name.

The maximum number of characters for each drawing title is 255.

Example: “Front View”, “Drawing”

The list of authorized external document types is as follows

“Part Number” fields

Field nameStatusDefinition

Part_Number_Sort_ID
Required
if you define
some part numbers
in
“Part_Number” field
Numerical value starting from 1 to N for each product in order to make the part number record distinct for each product.

For any one part number, this value must be the same in each “Products_xx” tab.



Manufacturer_Name

Optional.
Allow to overwrite the name of
the manufacturer defined at the catalog level.


Distributor_
Part_Number

Optional.

Specify a Distributor part number.


Distributor_Name

Optional.

Specify a Distributor name.


Manufacturer_
Part_Number
Required
if you define
a CAD model,
a description, or
any attribute value
(see “Customizing the template”)
Define the part number. One part number per line.

The maximum number of characters for each part number is 255.

For any one Product_ID + Part_Number_ID pairing, this value must be the same in each “Products_xx” tab.


Part_Number_
CAD_FileName
Optional
Defines the CAD file name to be used as the source 3D model.
The maximum number of characters for each file name is 100.

The file must be supplied together with the completed XLS template.
For any one part number, this value must be the same in each “Products_xx” tab.

For CAD assembly, create an archive file with all necessary files. The archive file name must be: MainCADFileName.CADExtension.archiveExtension.

In the XLS template, enter the archive file name in the relevant field.

Example, for a SolidWorks Assembly zip file: MyAssembly.sldasm.zip


Part_Number
_Description
Required
if you define
some part
numbers in
“Part_Number”
field
Provides a description of the part number.

The maximum number of characters for each description is 255.

When you want to group several part numbers together in the same product, all data relating to the “Product” and “Document” fields must be duplicated with the same values for each part number line.

The list of supported CAD formats is as follows

“Attributes_Definition” tab

This tab contains information for customizing the template.
See the “Customizing the template” section for more details.

Field nameStatusDefinition



Attribute_ID


Required
Contains the list of attributes you have added to the template (see “Customizing the template”).

Remember that the items in this list are treated as the identifiers of the attributes.

Therefore:
  1. Attribute_ID must be unique,
  2. It can only contain the following characters: “A-Z”, “a-z”, “0-9”, “_”,
  3. All other characters, such as accented characters or spaces, are prohibited.
  4. This information is not visible to the user; it is used by the system to manage your data.

Examples: “DIA”, “L0”, “h1”, “ATT_1”, “ATT_2”, “MAT”





Attribute_
Name
( + “_” + language code )
Required
Used to define the name for each of your attributes in the various languages selected (see “Customizing the template”).

This name is displayed to the user.

If the values of your attribute are expressed in a specific unit, we recommend that you add the unit symbol at the end of the label.

Examples: “Internal diameter (mm)”, “L0 (mm)”, “h1 (mm)”, “Temperature (°C)”, “Color”, “Material”

“System” tab

This tab contains information required by the programs that will be processing your data. It contains the answers to certain questions asked by the wizard.

Please do not make any change in the tab.

Fields defined in the “System” tab

Field nameStatusDefinition

System_
Attribute_Name
Required
(Reserved)
Specifies a “system” attribute used by the programs that will be processing the template file.

See the list of system attributes.


System_
Attribute_Value
Required
(Reserved)
Value of a system attribute.

List of system attributes

System attribute nameSystem attribute value

Template_Name
Template name.

Predefined system value : “Self-Publishing Products Catalog”


Template_Type
Template type.

Predefined system value : “Basic Template”


Template_Version
Template version.

Predefined system value.


Product_Document_Number
Number of the document selected by the user in the wizard (macro).


Product_URL_Number
Number of the online document selected by the user in the wizard (macro).


Product_Dimensional_Drawing_Number
Number of the dimensional drawing selected by the user in the wizard (macro).


Default_Language_Code
Code of the default language selected by the user in the wizard (macro).


Selected_Language_Code
Code of the language selected by the user in the wizard (macro).
There may be one or more lines. Each line contains a single language code.

Sample parts file, with English as selected language.

(splited in 4 parts due to the number of columns to display)

Startup: using the wizard > File structure > Customizing the template