Adding a Column in BreadCrumbs – BreadCrumbs Instructions

Target Audience: Advanced User IT Manager
Article #: 13525

Summary

When using BreadCrumbs, the user may need to add a new column to the database in so that it properly arranges the information. Follow these instructions for adding a column in BreadCrumbs.

Preparation

You will need:

  • Access to the database and tables that need to be changed with read and write privileges
  • SQL Server Management Studio (SSMS) installed

Instructions

Part 1: Adding the Column

  1. In the commons database, execute the stored procedure exec Utl_Set_DB_Identifiers. This resets the addition of column identifiers regarding site specificity – whether they belong in the commons or assets database.
  1. Locate the table where the column is to be added.
  2. Right-click on the table and select Design to allow editing of the table. This will open a new tab.
  3. On the left side of the tab, name the new column.
  4. On the right side, assign it a Data Type using the pulldown.
    • If the column will only use numbers, then assign an int datatype.
    • Otherwise, use the nvarchar dataype and assign a specified length.
    • Nvarchar(XX) allows for a number of characters up to the number in parenthesis. Examples are nvarchar(32) for 32 characters or less and nvarchar(50) for 50 characters or less.
    • Int datatypes allow for numbers ranging from 0 to 4.2 billion
    • A tiny int datatype allows for numbers ranging from 0 to 255
    • Bits can only be 0 or 1 as they are used for true or false
  1. Click the Save icon (floppy disk) to save your changes.

Part 2: Enabling Tracking

Once the column has been added to the table, it must be added to the DB_Table_Columns so it can be tracked.

  1. Execute the stored procedure exec Utl_Db_Table_Columns_Insert ‘<Desired Table>’, <site specificity>
    • Desired Table is the name of the table that was just modified.
    • Site Specificity indicates whether the table belongs in the commons database or in a specific sites database.
      • EXAMPLE 1: The volume needs to be a standard item property that needs to be tracked for every customer within the BreadCrumbs database going forward. Use 0 for site specificity.
      • EXAMPLE 2: Color needs to be a standard item property for a single company. Use 1 for site specificity.
  1. To confirm the addition of this column, navigate to the Common database.
  2. Go to the DB_Table_Columns table.
  3. Locate the database column that was added by running the following command:
    SELECT * FROM DB_Table_Columns WHERE Column_Name = ‘[<Name of Field>]’
  1. To confirm if that the correct specificity has been applied, check Table_Column_Id. If the value is less than 10,000 it is non-site specific. If it is above that value, then it will only apply to selected customers.

Additional Comments

If you need further assistance, please contact us.

Author


Was this article helpful?

Related Articles