<partsFromTable> Element

This element specifies parts for a component type from an Acuit Pinpoint table.

Parent Elements

componentType, rejectParts

Attributes

Name	Type	Description	Required
table	string	The name of the Acuit Pinpoint table from which to read the parts.	Yes
componentAlternateColumn	string	The name of the table column that contains componentAlternate part values. See the remarks for details.	No
componentModelNumColumn	string	The name of the table column that contains componentModelNum part values. See the remarks for details.	No
componentSerialNumColumn	string	The name of the table column that contains componentSerialNum part values. See the remarks for details.	No
descriptionColumn	string	The name of the table column that contains description part values. See the remarks for details.	No
ignoreBlankComponentRows	boolean	Whether blank component rows should be ignored. Component rows are considered blank if both the component model number and component serial number are blank.	No (defaults to false)
unitModelNumColumn	string	The name of the table column that contains unitModelNum part values. See the remarks for details.	No
unitSerialNumColumn	string	The name of the table column that contains unitSerialNum part values. See the remarks for details.	No

Child Elements

Name	Description	Required
otherComponents	Other components against which part entries must match. This feature is available in Acuit Pinpoint Workstation version 7.13 or later.	No

Remarks

The source table will be used to build a parts list. Each data row from the table will produce a parts list entry, effectively creating a part as defined by a <part> element (see that element for more details about part entry values).

For each of the column attributes, if the column name is not specified or is blank, or if the column's field value in a table row does not exist or is blank, then the corresponding part value will not be set (i.e., it will be as if the corresponding part attribute were not specified).

The componentAlternateColumn data value is parsed as follows:

1. If componentAlternateColumn was not specified, false is used.
2. Otherwise:
   1. All leading and trailing whitespace is removed from the value.
   2. If the resulting string value is "True", "Yes", "Alternate", "Alt", or "A" (case-insensitive), then true is used.
   3. Otherwise, if the value is "False" or "No" (case-insensitive), then false is used.
   4. Otherwise, if the value can be parsed as an integer, then true is used if the integer value is non-zero; false is used if the integer value is zero.
   5. Otherwise, true is used if the trimmed string value is not empty; false is used if it is empty.