To fix unit conversion issue for specification database in OpenPlant Specification Generator.
While performing unit conversion operation using OpenPlant Specification Generator, spec records from one unit to another is not converting properly. For example, performing unit conversion of a spec from metric unit to mix metric doesn’t convert component records to mix metric for elbow records. Refer below snapshot.
Source spec database record, metric project unit.
Target output spec database record after conversion to mix metric project unit.
Notice that, in converted spec database main & run size records are not converted to inches’ records.
For unit conversion from one unit to another unit, OpenPlant Specification Generator search for project unit suffix for metric unit from source database records & as per definition converts it to defined project unit. Unit conversion issues occurs when source spec database don’t have project unit suffix for component records. Modifying source database records to correct project prefix will solve issue here. As shown in above image, unit conversion has not carried out properly due to incorrect format of records for main size & run size in target spec database. Since target spec database is of metric project unit then records must contain suffix as “mm” after records. Below wiki article will explain about necessary changes to fix unit conversion issue.
Note: Basic Knowledge of Microsoft Access is required
Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this Comments or Corrections?" section. THANK YOU!