Import CSV

Web

Trimble Connect

Environment

Not environment-specific

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.

This help refers to the version 1.4 of the extension. See tab page "About".

CS TC Extension package

Import CSV belongs to the Construsoft Trimble Connect Extension package.

CS TC Extensions

Use for

Import of custom properties.

Before you start

1. Open your model in the 3D Viewer.

2. Create custom properties.

Select objects for which you want to create custom properties and open the properties panel.

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 options "Manage property set libraries" for creating customized property set, and "Add properties" for selecting the property set and adding it to selected objects.

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 window (the button "Columns").

Export selected properties to the CSV file format.

4. Edit properties.

Use Microsoft Excel or an alternative software to edit the exported data in the CSV format.

Data edited this way are ready to be imported back to the model using the "Import CSV" extension.

Import CSV tab

Use the "Import CSV" tab to import edited properties back to the model objects.

Select the CSV file with edited custom properties.

Based on the GUID, the extension finds the objects which should have the properties modified. Objects which have the properties modified turn red.
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 were edited and which properties were modified. In case of an error, the data which could not be imported are highlighted with red color and the warning message appears.

As a result, the properties were modified in the properties panel.

Supported data formats

Numbers

Imported numbers should not contain any text-related characters. Only numbers without formatting are supported.

Date

Supported date formats:

Mmm DD, YYYY

DD-Mmm-YYYY

YYYY-Mmm-DD

DD-MM-YYYY

DD.MM.YYYY

Settings tab

In the "Settings" tab, the information that the extension finds the separator automatically, appears

About tab

In the "About" tab, general information about the extension and the developer can be found.

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.