Skip to main content

​
Overview

The database is structured just like the estimate table. It has the same columns and maintains the groups and items structure. This is where you can create new rows and manage existing ones in the database for use in projects. It’s accessible from the dashboard: From left to right:
  • Bobyard logo goes to dashboard
  • The dropdown button lets you navigate to a project’s estimate table
  • Search finds all rows whose name or description contains the search term
  • The up arrow scrolls to the top
  • The check box selects all items
  • Four arrows pointing out expands all folders
  • Four arrows pointing in collapses all folders
  • Create new folder
  • Create item
  • Create assembly
  • Group edit
  • Toggle column visibility
  • Import rows
  • Delete currently selected rows
  • Profile
These all behave the same as they do in the estimate table.

​
Imports

Imports are unique to the database and lets you populate the database with an excel or csv. Here is a sample: 
https://bobyard-public-images.s3.us-west-2.amazonaws.com/Bobyard-populate-database-sample.xlsx
The columns in the excel match the ones in the database. Only columns that are editable will be imported. The spaces in the names are replaced with underscores. There is also the addition of a group column as the first column. When populating, Bobyard will create a new folder for the entire excel called “imported data” and if the row in the excel has a ‘group’, it will create a new group inside ‘imported data.’ The corresponding groups that will be made with the sample: