Tables in 12d Model can be created, associated with, and updated from, a CSV file.  Additionally, a Table created in 12d Model can be exported to CSV.

The CSV file should be delimited by a comma, or semicolon, or tab.  The table Title and Column Headers may also be included in the CSV file.

An example CSV is shown below.

Point Setout
Name,X-Coord,Y-Coord
A,256190.744,7411594.163
B,256222.558,7411571.907
C,256232.490,7411543.916
  • Title row: Will be used for the table Title.
  • Header row: Will be used for the column Headings.

To create a table, go to:  Cad => Table => CSV file – 1 table

Set the Name, Model, and Style for the table.

Select the CSV Source File to use as the data source.

The Column Separator must match the delimiter used in CSV file.

Use Auto Sizing to quickly setup the table.  If needed, the row/column sizes can be manually changed later.

Location sets the insert point for the table.

Use Title and Use Header to use title and header rows from the CSV.  Tick these on if the Title and Column Headers are included in the CSV, and you want to include them.  These are both optional and not required in the CSV file, or will be skipped if they do exist.

Number of Rows and Number of Columns may be left blank as they will be automatically set by the number of rows/columns in the CSV file.

Existing tables may also be edited, go to:  Cad => Table => Edit

Editing the Table allows you to update properties such as;

  1. Add/Delete rows and columns,
  2. Change the Table Style,
  3. Turn the Title and Headers on/off,
  4. Edit the cell contents,
  5. Recalc to update contents from the CSV file.

As the CSV file is linked to the Table, when the CSV file is updated you can update the Table contents without having to open the editor (toolbar).

From the menu, go to:  Cad => Table => Recalc data source

Add the following lines to the CSV, and save the file.  Then do a Recalc data source.

D,256260.480,7411536.919
E,256270.927,7411493.013
F,256280.531,7411492.567

Note:  As 12d Model creates an association between the Table and the CSV file, it is important not to rename or move the file.  However, if needed you can re-associated a CSV file with the table.

On the Edit Cad Table toolbar, go to:  Properties > Type reselect the CSV source file.

For Tables that have their content generated in 12d Model, such as Cad => Table => Super Alignment, you can export the values out to a CSV file.

From the menu, go to:  Cad => Table => Table to CSV

Resulting CSV file.

"Point Setout",,,
"Name","XCoord","YCoord","Radius"
"A","256190.744","7411594.163","5"
"B","256222.558","7411571.907","10"
"C","256232.490","7411543.916","8"
"D","256260.480","7411536.919","12"
"E","256270.927","7411493.013","5"

Merging Cells

Cells may be merged by adding the following codes in the CSV file.  Note, except for the merge code, the cell must contain no data.

  • _INVR : Row Merge, with Cell to the left
  • _INVC : Column Merge, with Cell above
  • _INVB : Block Merge, with Cell’s to left/above

The CSV shown below has examples of Row, Column, and Block merging.

TABLE TITLE
HEADER A,HEADER B,HEADER C,HEADER D, HEADER E
ROW 1,_INVR,_INVR,CELL 4A,CELL 5A
ROW 2,CELL 2B,CELL 3B,CELL 4B,CELL 5B
ROW 3,CELL 2C,CELL 3C,_INVR,_INVR
_INVC,CELL 2D,_INVC,_INVB,_INVB
_INVC,CELL 2E,_INVC,_INVB,_INVB
Tagged: