How to Import Results from CSV File in VCollab Pro?

VCollab Pro supports comma separated CSV file for importing external CAE results. It reads results from the CSV files with extension .csv, and adds the results as a new instance.

Sample CSV File

#VCOLLAB_RESULTS

Node,Displacement,Stress,

Vector,Tensor,

#INSTANCE,L1M1,Label:Step1,Time:0.1

1818,0.000000,0.000000,0.000000,0.401617,-0.543105,-0.496605, 0.016011,1.541499,-0.090037,

1848,0.000000,0.000000,0.000000,-0.330866,-0.389335,-0.527343,-0.010698,1.284187,-0.019899,

1845,0.000000,0.000000,0.000000,-0.486035,-0.668757,-0.667392,-0.024487,1.603551,-0.030750,

#INSTANCE,L2M1,Label:Step2,Time:0.2

1818,-0.543105,-0.496605, 0.016011,1.541499,0.000000,0.000000,0.000000,0.401617,-0.090037,

1848,-0.010698,1.284187,-0.0198990.000000,0.000000,0.000000,-0.330866,-0.389335,-0.527343,

1845,0.000000,0.000000,-0.486035,-0.6687570.000000,0.000000,0.000000,-0.486035,-0.668757,

CSV File Format

Line No

Description

Example

1

#VCOLLAB_RESULTS

Header line to identify VCollab CSV format.

2

Node/Element, Result1, Result2,….

Use Node for nodal result and Element for elemental result. All results should be of same type.

3

Result Types for each result.

Scalar / Vector / SixDof / Tensor For complex results: Scalr_RI / Vector_RI / SixDof_RI / Tensor_RI

4

#INSTANCE, [Instance_name1], Instance attributes

Each attribute should have key and value separated by ‘:’ For example, Time: 1.0, Label:Step-1,

5

node/element ID value1, value2, value3,….

6

node/element ID value1, value2, value3,….

7

node/element ID value1, value2, value3,….

#INSTANCE, [Instance_name2],Instance attributes

Multiple instances are supported

node/element ID value1, value2, value3,….

node/element ID value1, value2, value3,….

node/element ID value1, value2, value3,….

Supported Result Types

Number of Columns (Components)

Scalar

1

Vector

3

SixDOF

6

Tensor

6

Python API Support

VCollab Pro provides the following methods to export and import result instances.

  1. xExportCAEResult(ouput_file_path, result_list,instance_list, precision, scientific_format);

  2. xImportCAEResult(csv_file_path);

Refer to VCollab Pro API manual available in the local installation folder for usage and syntax.

Steps to Import Results from a CSV file

  • Load a CAX file like bracket_sample.cax

bracket_sample

  • Click File | Import …

FileImport

  • Select *.csv as file type.

  • Select bracket_node_result.csv file.

The imported nodal result will be added to CAE | Result List… dialog.

bracket_node_result

  • Click File | Import… again.

  • Select bracket_element_result.csv file.

The imported element result will be added to CAE | Result List… dialog.

bracket_element_result

  • Multiple CAE instances can be brought into VCollab by importing multiple CSV files.