On the Customer Record (CAD) (a CAD is also known as a CR) / Template Record (TAD) (TAD is also known as a TR) page, you can download and upload an Excel workbook to reduce the time in the creation and edits of Label Definitions (LAD) portion. The new Excel workbook should be in the below format:
- Each LAD value should be in a single column or in its own cell
- Column A is for the Section
- Column B is for the Label Name
- Column C is for the Label Definition value, followed by each value in its exclusive column
Below is the example table of the Download and Upload LAD format for CR and TR:
|
LAD Type (Column A) |
LAD Name (Column B) |
LAD Definition Value 1 (Column C) |
LAD Definition Value 2 (Column D) |
LAD Definition Value 3 (Column E) |
|
Area Code |
*AREA1, |
402 |
527 |
652 |
|
Date |
*DATE1 |
01/02 |
05/07 |
09/10 |
|
LATA |
*LATA1 |
124 |
249 |
374 |
|
NXX |
*NXX1 |
124 |
249 |
374 |
|
State |
*STA1 |
CT |
VA |
ND |
|
Telephone Number |
*TEL1 |
877-369-0020 |
|
|
|
Time |
*TIME1 |
10:30 AM - 05:15 PM |
10:30 AM - 04:30 PM |
10:45 AM - 02:30 PM |
|
10 Digit Number |
*TE1 |
817-729-0196 |
817-729-0321 |
817-729-0446 |
|
6 Digit Number |
*AT1 |
430-220 |
430-345 |
430-470 |
For more information on the LAD field definitions and valid values for CR or TR, please click here, and/or here.