LogoLogo
ThreeKitDeveloper HubForumsSupportStatus
  • Guides
  • Documentation
  • Releases
  • Community Home
  • Changelog
  • Getting Started
    • Project Prep
      • 1. What Should I Expect During Onboarding?
      • 2. Getting Ready for Your Threekit Project
      • 3. Org Provisioning & Adding Users
      • 4. Intro to Support
      • 5. Training
      • 6. Requirements Checklist
      • 7. Customer Resources & Onboarding Checklist
    • Managing Your Implementation
      • Implementation Design Review
      • Requirements Traceability Matrix (RTM)
      • Project Delivery Checklist
      • Daily Stand-up Meeting
      • Status Report Template
      • Stakeholder Meeting
      • Customer Roles and Responsibilities
      • Internal QA
      • Customer Support Handoff Doc
      • Post Implementation Training Agenda
      • Managing the Discovery Process
      • What is a Quality Workshop?
      • Project Update/Exam Template
      • Consulting Methodology - Presentation Consulting Methodology - Presentation
      • Task Estimation
    • Implementation
      • UAT Planning
      • Earned Value
      • User Stories
      • Milestone Signoff / Project Acceptance Document
  • Learn
    • Platform Overview
    • Workflows
      • Basic Visualization
      • Best Practices
        • General 3D Content Creation
        • Performance Guidelines
        • 3D Asset Naming Conventions
        • Usage of Shadows With AO & SSAO
        • Camera Set-up Best Practices
        • Reference Image Guidelines
      • Text Personalization
      • Image Upload Personalization
      • V-Ray Workflow
        • 1. VRay Requirements
        • 2. VRay Asset Preparation
        • 3. VRay Asset Export
        • 4. VRay Scenes
        • 5. VRay Models
        • 6. VRay Materials
        • 7. Vray VFB Presets
        • 8. Vray Operators
        • 9. Vray Light Linking
        • 10. Vray Compositing
        • 11. Vray Render Workflow
        • 12. Vray Troubleshooting
      • Template Assets
    • Training
      • Self-Led Training
        • Basic Renders
        • Adding Pricing
        • Adding Additional Languages
        • Rules
        • Data Tables
        • Dimension Annotations
        • Stages
        • Metadata
        • Proxy Materials
        • Image Annotations
        • Upcoming Training Videos Outline
    • FAQ
      • General FAQ
      • Threekit Glossary
      • What are the different types of Visualization?
      • What are Material Scans?
      • What is Layered Rendering?
    • Trio Talks
      • October 20, 2022 - Augmented Reality
      • September 15, 2022 - Order of Operations
      • August 18, 2022 - Performance & Model Optimization
      • July 21, 2022 - Collision Detection & Drag and Drop
      • June 16, 2022 - Virtual Photography
      • May 2022: Conquering APIs: 10 Useful API Options You May Not Know About
      • April 21, 2022: Adding Bling: Falloff, Glass, Iridescence, Bloom
      • March 17, 2022 - Treble
      • January 20, 2022 - Modular Configuration
  • Tools
    • General Apps
      • Republish Items
      • Apply Metadata Pattern
      • Render to vrscene
      • Filter Saved Configurations
      • Performance Dashboard
      • Asset History
  • Feedback
    • Want to give us feedback on the Threekit Community? Click Here!
Powered by GitBook
On this page
  • What are Data Tables?
  • Adding a Data Table
  • Using Data Tables in Catalog
  • Video

Was this helpful?

Edit on GitHub
  1. Learn
  2. Training
  3. Self-Led Training

Data Tables

PreviousRulesNextDimension Annotations

Last updated 1 year ago

Was this helpful?

UPDATE: Data Tables is now a sub-menu item of Catalog. For more information, please see the release notes.

What are Data Tables?

Data tables are CSV files uploaded to Threekit and converted into a database.

Data tables are useful for storing all data for the configurator, logic, and so forth within the Threekit system, eliminating the need for external tools or connections.

VERIFY:

Your CSV file must be of a "UTF-8 CSV" type to import properly.

Adding a Data Table

Ensure the top row of your CSV file is the column header information before uploading.

Click "Data tables" in the left-hand menu.

In the upper right corner click "Import Table."

Select the proper file from the popup window. In the new table window, name the table and select the appropriate data type for each column. Click "Create."

The newly created data table will appear in the list.

Click on the table name to verify the information.

From this window, Click the "Rename" button to rename the table -- this does not modify the table data.

Click "Download" to download a CSV copy of the table for editing.

Click "Update" to upload a new file with adjusted information. NOTE: Any file may be used to update information, the file name does not need to match that of the previously uploaded file.

New columns will be added to the column list. Adjust the data type as needed.

Removed columns will be noted with a warning message in red at the bottom.

Click update when finished.

Using Data Tables in Catalog

In the catalog item edit screen, rules may use data table values as a source for attribute values.

Add a rule to pull information from the database into the attribute value.

Set the rule name and conditions as usual. Click the "+" to add a "set attribute" action.

Select the desired attribute from the drop down menu. (In this case SKU). Select "Database query." Select the desired data table. In "Select the first value from" choose the column name from the data table. Click "+ Add parameter." for each attribute whose value will originate from the data table.

Choose the desired column from the data table in the left-hand drop down.

Select whether you want the value equal (=) or not equal (!=) to that found in the column.

In the right-hand drop down, select the attribute on the item whose value will be set.

NOTE:

The columns in your table may or may not match the names of your attributes. Name matching is not required.

Click "Done."

Don't forget to "Save Item!"

Test your configurator to ensure the value is properly updating.

Video

Data Tables trash - you can now delete data tables you no longer need.

You can Go to trash and restore deleted Data Tables: