Traceparts

File Structure

[accordion style=”normal” open=”no”][accordion_toggle title=”Products tab”]

“Products” fields

List of fields related to products
Field name Status Definition
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 in the same product, repeat the same product ID for each line of each part number.
For the same product, this data 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.
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.
Maximum number of characters for each short description is 255.
Product_Keywords_List Optional Supplies a list of keywords that will be used by TraceParts search engine.
Each keyword must be separated from the next in the list by a semi-colon.
Maximum number of characters for one keyword is 30.
Maximum number of characters for the complete list of keywords is 255.
Note that, by default, the search engine already uses all the words in the product name and description as potential search words, so there is no need to repeat them in this list.
Example: “Keyword1;Keyword2;Keyword3”
Classification_Category_ID Required Identifier used for specifying a category in the classification.
The list of authorized identifiers to use are defined in the  “ClassificationAdvancedTemplate” excel file provided in the archive file when you downloaded the empty template.
Only the identifier of the category you classified your product is necessary (not the full path from the root).
For the same product, this data must be the same in each “Products_xx” tab
Product_Large_Picture_FileName Optional Supplies the name of the image file showing the product.
Image must be provided together with the completed XLS template.
Recommended picture size is 460 x 340 pixel. Bigger picture will be resized.
If not provided, TraceParts will try to extract screenshot from provided CAD file.
For the same product, this data must be the same in each “Products_xx” tab
Example: “LargeProductPicture1.gif”

The “Product_ID” you provided is kept in the TraceParts System.
When you provide a template with “Product_ID” that doesn’t exist in the TraceParts Sytem, a new product is created in the TraceParts System.
Then, if you provide a second template with “Product_ID” that already exists in the TraceParts System, the existing product is overwritten.

horizontal border

“Documents” fields

List of fields related to documents
Field name Status Definition
Product_Document_FileName
( + “_” + document number)
Optional Specifies the file name of any document linked to the product.
Maximum number of characters for each file name is 100.
The authorized file types are defined here.
Documents must be provided 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 next to the link to the document to the user rather than using the file name itself.
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.
Protocol (http, https,..) is required in the URL.
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 rather than using the URL itself.
Maximum number of characters for each URL title is 255.
Example:”TraceParts Online Help”
Product_Dimensional_Drawing_FileName ( + “_” + dimensional drawing number ) Optional Specifies the file name of the dimensional drawing linked to the product.
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 provided 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 rather than using the file name itself.
Maximum number of characters for each drawing title is 255.
Example:”Front View”, “Drawing”

horizontal border

“Parts Numbers” fields

List of fields related to part numbers
Field name Status Definition
Part_Number_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 part number record distinct in each product.
For the same part number, this data must be the same in each “Products_xx” tab
Part_Number Required if you define a CAD model, a description or some attribute value (see customizing the template) Define the part number. One part number per line.
Maximum number of characters for each part number is 255.
For the same couple Product_ID + Part_Number_ID, this data must be the same in each “Products_xx” tab
Part_Number_CAD_FileName Optional Defines the CAD file name to be used as source 3D model.
Maximum number of characters for each file name is 100.
The file must be provided together with the completed XLS template.
For the same part number, this data 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, fill that field with the archive file name
Example for a zip file of SolidWorks Assembly: MyAssembly.sldasm.zip
Part_Number_Description Required if you define some part numbers in “Part_Number” field Defines the description of the part number.
Maximum number of characters for each description is 255.

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

  • [dvteam max=’1′ gridstyle=”full” categoryid=”50″ offset=”10″ itemwidth=”10″ align=”right” side=”center”]

 

horizontal border

[/accordion_toggle][/accordion]

[accordion style=”normal” open=”yes”][accordion_toggle title=”Attributes Definition tab”]

“Attributes Definition” tab

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

 

Fields defined in the “Attributes_Behaviour” tab
Field name Status Definition
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.
It can therefore only contain the following characters: “A-Z”, “a-z”, “0-9”, “_”
All other characters, such as accented characters or spaces, are prohibited.
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”

[/accordion_toggle][/accordion]

[accordion style=”normal” open=”no”][accordion_toggle title=”System tab”]

“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.

 

Fields defined in the “System” tab
Field name Status Definition
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 name System attribute value
Template_Name Template name.
Predefined system value : “SelfPublishing Products Catalog”
Template_Type Template type.
Predefined system value : “Basic Template”
Template_Version Template version.
Predefined system value.
Product_Document_Number Number of document selected by the user in the wizard (macro).
Product_URL_Number Number of online document selected by the user in the wizard (macro).
Product_Dimensional_Drawing_Number Number of 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.

horizontal border
[/accordion_toggle][/accordion]

Sample of parts file with English as selected language.