Video tutorial on this topic: 4: Introduction to the database
Database Editor provides you with the tools to view, add, edit and delete materials, products and accessories in your database.
To launch the Database Editor, click on the Database tab.
View Database Items
Note: If you have read-only access to the database (as a Standard User), the following database commands are hidden: Import, Clear and New Item. Also, the item details are read-only.
Radio buttons let you choose if you want to work on Materials, Products or Accessories:
Click on the radio button of your choice to select the type of item you want to display. For example, when Products is selected, you won’t see Materials or Accessories. You can switch from one type to another at any time.
The left side of the screen shows a list of all your items in a table similar to a spreadsheet. Each line contains one item and each column corresponds to the following properties: Reference, Name and classification columns (A:, B: and C:), which are detailed in Database Item Reference.
This is where you can view and select items in the database.
To select an item, click on its line in the list.
Use the Up/Down arrow keys to switch to the previous/next item.
A maximum of 50 items is shown on each page. If there are more than 50 items, they are displayed on additional pages. To select another page to display, use the page navigation tools in the lower left corner of the panel:
Note: If your screen is small, scroll down to see more items.
Tip: By clicking on the headers at the top of each column, you can sort the list according to the column content. For example to order the list by product names click on the Name header and to order it by references click on Reference. Clicking again on a header reverses the order.
By default, the Database Editor shows the complete Item List in its listing. If you have many items in your database, you can use one or several filters to display only items matching the chosen filter(s).
Filters are available for the Reference, Name and classification columns (A:, B: and C:).
After you select or type values for filtering, the other drop-down lists only display items matching that filter combination, so you can narrow down quickly on available items.
Selecting the * symbol means all available items will be displayed in the list.
For the Reference and Name filters, you can type any text string: only items with values matching your string will be displayed. The filter boxes accept single or multiple keywords following these rules:
Example: typing frozen CHOCOLATE in the box above Name will display all the items containing chocolate AND frozen in their name.
Note: Items with values of different text cases are grouped in the Database Editor. Ex: Lego and LEGO are grouped as the same value.
The right side of the screen shows all the properties of the selected item. This is where you can review and edit each item attributes, such as name, dimensions, shape, image(s), etc.
Note: The available properties vary depending on the type of items being viewed.
When you select an item in the list, this area displays a small preview of the item in 3D.