Panel: CSV Data (Data Mapping Box)¶

The CSV Data Panel is where CSV files are loaded and data is mapped to objects.

../_images/ch_panel_data_loaded.png — The CSV File Panel.¶

Components: General¶

../_images/ch_panel_data_mapping_false.png — These components are revealed once a CSV file is successfully loaded.¶

../_images/ch_panel_data_mapping_true.png — The CSV File Panel - Data mapped. These components are revealed once data is successfully mapped.¶

Components: Preview¶

Components that preview loaded CSV data. Selection does not affect mapping.

List: Headers¶

Lists all headers (fields) in the loaded CSV file.

List: Rows¶

Lists all rows (records) for the selected Header.

Components: Datapoint¶

Data mapping components. Takes effect after Map Datapoints.

List: Name Label¶

Field selection for datapoint name labels. String (Text) type recommended.

List: Main Value¶

Field selection for datapoint values. List will show only fields containing integer or float types.

Components: Chart Info¶

Chart info components. Takes effect after Map Datapoints.

String: Title¶

Auto generates based on CSV file name. Type to modify.

String: Subtitle¶

Auto generates based on Main Value list selection. Type to modify.

Toggle: Lock Subtitle¶

Enable to stop auto generating when selecting Main Value, locking the current subtitle text.

Components: Sort Order¶

Data sort parameters. Takes effect after Map Datapoints.

Toggle: Auto¶

Auto generates sorting based on CSV records.

List: Sort Order¶

Select a field (column/header) to sort datapoint placement.

Toggle: Sort Descending¶

Reverse the current sort selection.

Components: Map Range¶

Datapoint filter parameters. Takes effect after Map Datapoints.

String: Rows Range¶

Comma-seperated list of row numbers or dash (-) seperated ranges. Leave empty to include all datapoints.

Toggle: Exclude Rows¶

Invert the selected range.

Button: Map Datapoints¶

Maps the CSV data with selected parameters to the scene. The number of datapoints to be mapped is displayed in brackets, e.g. (Remap (7) datapoints).

Components: Post mapping¶

Once data is mapped some hidden parameters become available.

Button: Remap Datapoints¶

Remaps the CSV data with selected parameters to the scene. The number of datapoints to be re-mapped is displayed in brackets, e.g. (Remap (7) datapoints).

Note

This will clear all selected presets, animations and custom chart components. Remap data when it is desired to clear the chart and start fresh.

Button: Clear Mapped Data¶

Removes all ChArtist components from the scene. The loaded csv file stays active if remapping is required later.

Button: Finalize Chart¶

../_images/ch_panel_data_realize.png — Finalize Chart Window.¶

Realizes all chart components. Creates new objects in the scene.

Toggle: Keep Chart¶

Keep the current chart. If False, removes the active chart after finalizing.

Toggle: Join Components¶

Joins the finalized chart into one mesh. If False, creates a seperate object for each chart component.

Usage Examples: Pre Mapping¶

Make sure a CSV File is loaded first.

Preview Data¶

Expand the Preview panel header.
Select a Header in the List: Headers dropdown.
Expand List: Rows to preview records for the selected header.

../_images/ch_panel_data_preview.png — Preview data before mapping.¶

Mapping Data¶

Select the name label from List: Name Label.
Select the main value from List: Main Value.
Select a Sort Order, or leave on Toggle: Auto to sort by CSV row order.
Input a Range, or leave empty to map all records in the CSV.

Note

The below example has a range mapping of 1-5,7,8. This means that the data map will include records 1, 2, 3, 4, 5, 7, and 8. The rest of the records will be ignored when mapping.
Click on Button: Map Datapoints.

Video: Map the CSV Data

Usage Examples: Post Mapping¶

Clearing Mapped Data¶

Click Button: Clear Mapped Data. (Trash Icon) All chart components will be removed and purged from the scene.

Finalize Chart¶

Click Button: Finalize Chart.
Select Parameters.
Click OK.