Documentation Center

Viz Artist

Version 3.10 | Published May 03, 2018 ©

Data Import

images/download/attachments/27789653/viz_icons_dataimport.png
This plug-in enables Microsoft Excel (.xls and .xlsx) and Microsoft Access (.mdb) file import via ADO, and distributes it to a text field or a shared memory map. The plug-in supports reading both numbers and text.

To access Excel or Access data using this plug-in, you must first install the Microsoft Access Database Engine 2010 Redistributable.

IMPORTANT! Viz Artist 64-Bit: If you install Microsoft Office 32-bit on a computer running Windows 64-bit that has Viz Artist/Engine 64-bit installed, remove Microsoft Office completely before installing Microsoft Access Database Engine 2010 Redistributable. If you require Microsoft Office, make sure to install the 64-bit version.

Note: This plug-in is located in: Built Ins -> Container plug-ins -> VisualDataTools

This section contains information on the following topics:

Data Import Properties

images/download/attachments/27789653/plugins_container_dataimport_editor.png

  • File: Choose the required document.

  • Table / Sheet: Define the Table’s or Sheet’s name.

  • Column(,Col...): Set one ore more column names to use (comma separated).

  • Area Input: Excel also accepts areas.

  • Column Input: Used column.

  • Row Input: Used row.

  • Data Delim.: Delimiter after each row.

  • Column Delim.: Column separator sign(s).

  • Shared Mem.: Set Scene-, Global- or Distributed-Shared Memory for data transport. Use Inactive memory to not forward any values via Shared Memory.

  • Key: Shared Memory key name.

  • GetIt: Reads the document, sends the required data and shows it in the text box.

To Create a Scene with Data Import

images/download/attachments/27789653/plugins_container_dataimport_scene-example.png
This procedure will import data from an Microsoft Excel sheet and feed the Line Chart plug-in with data through Shared Memory.

  1. Start Microsoft Excel.

  2. Enter ExcelDataY into cell A1.

  3. Add some sample values in the cells below (A2-A8: 80,40,50,70,80,60,80).

  4. Rename this first sheet to MyTable (can be done with a double click on the sheet name at the bottom).

  5. Save and close the Excel document.

    IMPORTANT! You must close the document before importing it to Viz Artist.

  6. Start Viz Artist and create a new scene.

    images/download/attachments/27789653/plugins_container_dataimport_scenetree-example.png

  7. Add a group container to the scene tree.

  8. Drag and drop the Line Chart and Data Import plug-in to the group container.

  9. Add a material to the same group container.

  10. Open the Transformation Editor and set Position X to -200.0 and Position Y to -100.0.

  11. Set Shared Mem. to Scene with MyDataY as Key name for both plug-ins.

  12. Set Data Delim. to # for both plug-ins.

  13. For the Line Chart plug-in set ChartWidth to 500.0.

  14. Activate DataY Fit, DataY Auto Scale and DataY Detect Limits.

  15. Adjust DataY Stop to 200.0.

  16. Activate Const. Thickness to give the chart a constant line width.

  17. For the Data Import plug-in, set the stored Excel file as the File parameter.

  18. Enter MyTable for the Table/Sheet parameter and ExcelDataY for Column (,Col…).

  19. Click the GetIt button and the chart shows.