Door & Frame Schedule Data Table Requirements

Your excel file must meet the requirements below. Before exporting as a Text (Tab delimited) (*.txt) file, review the requirements and address any issues.

Headers

  1. Must have one header row
    • To correct: Delete header rows that you do not require for importing
Examples of correct and incorrect Excel header format; incorrect format shows three rows of headers, correct format shows one row of headers.
Image 1: Header Requirement 1
  1. Must fit on a single line (no text wrap)
    • To correct: Expand the column width to fit the header text
Examples of correct and incorrect Excel header format; incorrect format shows header row with two lines of text, correct format shows header row with no wrap text.
Image 2: Header Requirement 2
  1. Never leave a header cell empty
Examples of correct and incorrect Excel header format; incorrect format shows header row with one blank header cell, correct format shows all header cells filled.
Image 3: Header Requirement 3
  1. Never separate width and height measurements
Size_Same_Column.png
Image 4: Header Requirement 4
  1. Never use symbols or punctuation marks
Examples of correct and incorrect Excel header format; incorrect format shows header cells with punctuation, correct format shows header cells with no symbols or punctuation.
Image 4: Header Requirement 5
  1. Never duplicate column headers
    • To correct: Include specific titles on any words that are repeated
Examples of correct and incorrect Excel header format; incorrect format shows two headers labeled as Finish, correct format shows headers labeled as Door Finish and Frame Finish.
Image 5: Header Requirement 6

Cell Data

  1. Must fit on a single line (no text wrap)
    • To correct: Expand the column width to fit the header text (see: Headers)
  2. Must not be above character limits in Table 1

*Note: EDI with some manufacturers may have lower character limits than shown below. Always confirm character limits with the manufacturer if you are unsure.

Opening Number 20 Characters
Hardware Set Number 10 Characters
Hardware Short Description 60 Characters
Catalog Product and Option Codes 1024 Characters
Door & Frame Architect Type 12  Characters
Table 1: Cell Data Character Limits
  1. Must have one column representing size
    • To correct: Choose opening size or leaf size (usually leaf size)
Examples of correct and incorrect Excel format; incorrect format shows an Opening Size column and a Leaf Size column, correct format shows one column for Size data.
Image 6: Cell Data Requirement 2
  1. Must measure in feet and inches with no letters or punctuation marks
Examples of correct and incorrect Excel cell data format; incorrect format shows sizes as 91.5 x 213 cm and 3'0 x 7'0, correct format shows size as 3070.
Image 7: Cell Data Requirement 3

*Note: You can update the cell contents after importing the .txt file into Comsense Advantage.

  1. Never merge cells
    • If a merged cell represents the required data, Delete the merged cells and Add a column to represent the data
Examples of correct and incorrect Excel cell format; incorrect format shows a merged cell with text First Floor, correct format shows a column for the floor of the building.
Image 8: Cell Data Requirement 4
  1. Never leave an entire data row blank
  2. Never leave a cell in the first data row blank
    • To Correct: Add content to the empty cell and Delete the content after importing the .txt file
Examples of correct and incorrect first data row; incorrect example shows empty Fire Rating and Comments columns, correct example shows all cells filled.
Image 9: Cell Data Requirement 5

Your excel table should look like the example below:

Example of Excel table of door and frame schedule; shows all requirements of the table for import.
Image 10: Complete Door and Frame Schedule in an Excel Table

You are now ready to import your door and frame schedule. See Importing Door & Frame Schedules for instructions.

Have more questions? Submit a request

Comments