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 shelf tools 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 Shelf Tools:
· Products are typically all sellable items.
· Shelf Tools are typically props displayed on shelves to enhance product presentation: shelf strips, labels, headers, posters, products on display out of box, etc.
· Materials are used to make room elements look more realistic.
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 Shelf tools. 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:
· Display a page by clicking on one of the 10 visible page numbers.
· Display the previous/next page by clicking on the left/right arrow (shortcut key: Left/ Right Arrow).
· Display the previous/next page set by clicking on the left/right 3 dots.
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, 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).
Selecting the * symbol means all available items will be displayed in the list.
Filters are available for the Reference, Name and classification columns (A:, B: and C:).
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:
· Multiple keywords must be separated by spaces
· All keywords must be present
· Keywords are not case sensitive
· The order of keywords doesn’t matter
Example: typing frozen CHOCOLATE in the box above Name will display all the items containing chocolate AND frozen in their name.
Note: After you select values for filtering, the other drop-down lists only display items matching that filter combination, so you can narrow down quickly on available items.
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.