Cable Imports
- Pete Stapley (Deactivated)
- Brian Dixon
- 1 Capability
- 1.1 Matches On
- 2 Fields
- 2.1 Cable Name
- 2.2 Cable Owner
- 2.3 Cable Type
- 2.4 Description
- 2.5 Length (ft)
- 2.6 Signal Loss
- 3 Child Records
- 4 Errors
- 5 UDF Associations
Capability
The Cable Import allows the User to INSERT new records or UPDATE existing Cable records if a match is found.
Matches On
The Cable Import matches on the Cable Name field.
Fields
Cable Name
Required
Datatype is String.
Cable Owner
Conditionally Required for INSERT.
Datatype is String.
Permitted values are from the CABLE_OWNER List Values : Customer, and Telephone Company.
Blank values are NOT allowed.
Cable Type
Conditionally Required for INSERT.
Datatype is String.
Permitted values are from the CABLE_TYPE List Values : Fiber and Copper.
Any values added by a User to the CABLE_TYPE list can also be used.
Description
Datatype is String.
Default value is blank.
Length (ft)
Datatype is String.
Default value is blank.
Signal Loss
Datatype is String.
Default value is blank.
Child Records
There are no Child records for this Import. Pairs/Strands could be considered a Child of Cable. However, those are handled with a separate Pair/Strand Import.
Errors
The following errors appear if the the Cable Import INSERT or UPDATE fails:
Error : Cable Name is blank or missing
Error : Failed to save Cable record; <errorMessage>
This error stops the import. No records will UPDATE or INSERT until corrections are made.
Value not present in LISTS table for <Field Name>, value ("<value not permitted>")
UDF Associations
User Defined Fields on any given Import are all handled the same way with Conditional Logic. For more information about adding a UDF to the Import, see the User Defined Fields section of the Imports main page.