Thread Content
This post was last edited by wangdaoyuan665 on 2021-5-22 at 10:11. [Original] smartplant 3D Pipe Attribute Batch Import Tool – Update in May: I’m getting older and find it a bit difficult to make changes~ ———————— 1. Updated to support S3D 2018. 2. The import options are no longer limited to pipelines. It supports all named components such as pipeline, piperun, and equipment. _____________ The attachment is in 7z format; if it cannot be opened, change the extension manually. The license is updated monthly; downloading the original file enables the import of attributes such as text, numbers, booleans, and codelists. 1. After decompression, place key.lic (updated monthly, available for download in the original post) and Ubata.exe in the same folder. 2. After opening the software, click the gear icon to set the database to be connected. 3. Click the file icon and select the Excel file to be imported; the file format should be as shown in the example in the compressed package. 4. Import the data. 5. Once completed, a log file is generated in the same directory as the program. Excel format instructions: 1. First row–enter the SystemPath of the items to be imported (e.g., Systems\PipelineSystems, Piping\PipingRuns, etc.), as well as the name of the properties to be imported. The SystemPath and property names should match those displayed in MetaDataBrowser (they can also be queried using the CommondForm plugin). 2. Second row – the first field is named “name” (for now, name is the only option available for filtering); each attribute corresponds to a unit, which can be set freely, in a format consistent with that used in S3d. The default and unit-less attributes remain as spaces. 3. Starting from the 3rd line are the specific BO names and attribute values. In special cases, a blank value indicates an attribute that does not need to be changed, while NA means the original attribute should be removed.