All CUSTOMTOOLS attribute -field types can be set as numeric fields. CUSTOMTOOLS Export can interpret large variety of different numeric strings into a decimal value. For example, all following numbers are detected to be exactly the same:
- 123,456,789.123
- 123 456 789.123
- 123,456,789.123
- 123'456'789.123
- 12,34,56,789.123
- 123456789.123
- 123 456.789,123
- 123 456 789,123
- 123456789,123
- 123456789 123/1000
More common cases are:
- 1234.123
- 1234,123
- 1234 3/4
- 1234 ¾
- 1234'56¾"
In addition to abitrary fractional representations, CUSTOMTOOLS can detect following fractional unicode characters, with or without leading whole number: ½ ⅓ ⅔ ¼ ¾ ⅕ ⅖ ⅗ ⅘ ⅙ ⅚ ⅐ ⅛ ⅜ ⅝ ⅞ ⅑ ⅒.
It's also possible to create wild fractional compositions that look similar and support all numbers (e.g. ¹²³⁄₄₅₆) using unicode, however, those unicode compositions are
not supported by CUSTOMTOOLS.
| NOTE: 123,000 and 123.000 are interpreted as 123 with 3-decimal precision. If this rather should be 123000, then you must either add decimal separator or remove the thousands separator. |
No other text is allowed in numeric fields, with following exceptions:
- Preceeding sign +/- is allowed. There can be arbitrary amount of space between the sign and the number.
- Feet-inches (e.g. 2'24 3") MUST have the unit character for both the feet (') and the inches ("). When feet-inches is in raw decimal format, it's value is shown in inches.
| Material Quantity field type has special handling: Because material quantity of a Weldment is the length of the profile, length conversions are also allowed for it. However, the unit conversion is only applied for Weldment rows, but not for Material Quantities of Parts, Assemblies or CustomScopes.
Decimal precision/locale settings are applied to all rows to ensure consistent styling across the Material Quantity field. |
| Field Contains: |
| Text: |
No special treatment will be applied for the field.
|
| Numeric value(s): |
CUSTOMTOOLS attempts to detect numeric values in the field. Precision/divisor and locale settings will be applied.
|
| Mass value(s): |
CUSTOMTOOLS attempts to detect numeric values in the field and considers them to be mass values. Knowing the document unit, CUSTOMTOOLS can convert the mass to configured target unit. Precision/divisor and locale settings will be applied.
|
| Length value(s): |
CUSTOMTOOLS attempts to detect numeric values in the field and considers them to be length values. Knowing the document unit, CUSTOMTOOLS can convert the length to target unit set. Precision/divisor and locale settings will be applied.
|
|
NOTE: If the field value is a concatenation of linked CustomProperty values such as dimensions,
CUSTOMTOOLS Export attempts to apply its numeric detection for each linked value individually.
This makes it possible to convert also combinations having e.g. linked width and lenght dimensions in the same CustomProperty (e.g. "Steel Sheet <Width>x<Lenght>")
|
|
| Convert To: |
Target unit to convert the numeric value in the field. Depends on Field Contains -selection.
| Text -field: |
Not available.
|
| Numeric value(s) -field: |
Not available.
|
| Mass value(s) -field: |
Milligrams, Grams, Kilograms, Pounds.
|
| Length value(s) -field: |
Millimeters, Centimeters, Meters, Inches, Feet, Feet-inches, Angstroms, Nanometers, Microns, Mils, Microinches.
|
|
| Use fractional representation |
Enable to round the decimal number into the nearest fraction, which divisor is set using the Divisor option.
Locale setting only applies to the possible whole number preceeding the fraction.
Disable to use decimal representation.
NOT supported for Material Quantity -field type.
|
| Precision |
-1 to not do any decimal rounding. 0 for no decimals at all; up to 15 decimal precision.
Only available when Use fractional representation is disabled.
|
| Divisor |
Round the number to nearest fraction, which divisor is set by this option. Valid values are from 2 to 1000.
For example, 6.5 with divisor 2 would be 6 1/2 and with divisor 10 it would be 6 5/10.
Only available when Use fractional representation is enabled.
|
| Locale |
The Locale ID used for convering the decimal number back into text. For example:
| <empty> |
The default setting: Dot (.) as decimal separator and thousands not separated. All written together with possible preceeding minus sign.
123456789.123
|
| en-US or en-GB |
Dot (.) as decimal separator and thousands separated with a comma (,).
123,456,789.123
|
| fr-FR |
Comma (,) as decimal separator and thousands separated with a space ( ).
123 456 789,123
|
|
You can retrieve the latest revision information of your SOLIDWORKS documents to the structure export by using the CUSTOMTOOLS Revision Properties in your Export Profile.
To read values from the CUSTOMTOOLS Revision Properties properly in structure export, include your model scope Revision property in your Export Profile. In addition to that, you can include your CUSTOMTOOLS Revision Properties in your Export Profile to retrieve more details of the document's latest revision in the structure export.
You may add SOLIDWORKS Property data of your SOLIDWORKS documents to the Export Profile to be included in the output. The following table explains the SOLIDWORKS Properties available for use in the CUSTOMTOOLS Export Profiles.
| Configuration |
The Configuration property retrieves the referenced configuration name from the SOLIDWORKS document. If several configurations of the same SOLIDWORKS document are being used in your model structure, each instance of the component in the structure shows the configuration name referenced by the associated structure item.
|
| Filename |
The Filename property retrieves the complete path and filename of the SOLIDWORKS document referenced in the model structure.
|
| Item Number |
The Item Number property gets the item's identifier number based on the context it is being used in. If the component is located in a sub-assembly of your bigger model structure, the Item Number property's value refers to the component's identifier number in a sub-assembly where it belongs to.
|
| Material Quantity |
Material Quantity equals total number of instances multiplied by the BOM Quantity associated to the component in the structure. The Material Quantity refers to the amount of material needed to produce for example a sheet metal component referenced in the model structure. Please notice that the Accumulate quantities option in the Export Profile's settings affects to the quantity retrieved by this type of Field data.
You may define the Property used as BOM Quantity in CUSTOMTOOLS, in the Properties options of your CUSTOMTOOLS Profile.
|
| Part Number |
The Part Number property retrieves the associated model configuration's display name defined by the Part number displayed when used in a bill of materials option in SOLIDWORKS model's configuration Properties.
Please refer to the SOLIDWORKS documentation for more information and guidance about the model configuration properties.
|
| Quantity |
The Quantity property retrieves the total number of instances of the associated component used in your model structure. When you use the Quantity property, please notice that the Accumulate quantities option in the Export Profile's settings affects to the quantity retrieved by this type of Field data.
|
| Type |
By the Type property you can retrieve the type of the SOLIDWORKS document used in your model structure. The document types are presented by their file extension in the Export dialog box in a field which Field data is Type.
|