Import CSV
Environment
Not environment-specific
On this page
Image
Trimble Connect extension Import CSV allows the import of custom properties which were exported via the Data table in the 3D Viewer and edited in a program capable of working with the CSV file, e.g. Microsoft Excel.
Image
This help refers to the version 1.4 of the extension. See tab page "About".
Back to topCS TC Extension package
Import CSV belongs to the Construsoft Trimble Connect Extension package.
Back to topUse for
Import of custom properties.
Back to topBefore you start
1. Open your model in the 3D Viewer.
2. Add custom properties.
Select objects for which you want to create custom properties and open the properties panel.
Image
Use the "Manage property set libraries" option for creating customized property set.
NOTE: If you are unsure how to create custom properties or manage Property Set Libraries in Trimble Connect, please refer to the following article: https://docs.workflowextensions.connect.trimble.com/property-set-libraries.
Use the "Add properties" option for selecting the property set and adding it to selected objects.
Image
NOTE: Detailed instructions about Property Set usage in the 3D Viewer can be found in the following article: https://docs.workflowextensions.connect.trimble.com/using-property-sets-in-3d.
3. Export properties to CSV file.
Add the properties to export including the GUID to the Data table by using the "Add or remove properties" dialog (the "Columns" button).
Image
Export selected properties to the CSV file format.
Image
4. Edit properties.
Use Microsoft Excel or an alternative software to edit the exported data in the CSV format.
Image
Data edited this way are ready to be imported back to the model using the "Import CSV" extension.
Import CSV tab
On the "Import CSV" tab, import the CSV file with edited model objects properties.
Image
Based on the objects GUIDs, the properties are modified. Objects with modified properties turn red.
Image
After the import of the edited properties, the user gets the information whether the data were imported without errors. In the Import log, the user can check, which property set and which properties have been modified. In case of an error, the data which could not be imported are highlighted with red color and the warning message is displayed.
Image
As a result, the properties are modified in the properties panel.
Image
Supported data formats
Numbers
Imported numbers should not contain any text-related characters. Only numbers without formatting are supported.
Image
Date
Supported date formats:
Mmm DD, YYYY
DD-Mmm-YYYY
YYYY-Mmm-DD
DD-MM-YYYY
DD.MM.YYYY
Image
Settings tab
On the "Settings" tab, the information that the extension finds the separator automatically, is displayed.
Image
About tab
On the "About" tab, general information about the extension and the developer can be found.
Image
Version - check the version of the extension.
Documentation - find the instructions about the functionality on the TUA help page.
License Manager - manage your licenses in the License Manager.
Store - get the license for the extension and other tools in the Construsoft eshop!
All rights reserved. No conclusions can be associated to the representation of the pictures in relation to the operating systems under which Tekla Structures runs.
This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License. To view a copy of this license, visit http://creativecommons.org/licenses/by-nc-nd/4.0/ or send a letter to Creative Commons, 444 Castro Street, Suite 900, Mountain View, California, 94041, USA.