In this section:

Standard GTT Database CSV

The batch operations use comma-separated files where each record is uniquely defined on a single line. Comments can be added to the batch file by starting a line with an initial ‘#’ character.

The following file format examples are supported for batch operations:

Note

The GTT supports both add and delete formats.

Batch GT Called Searches CSV Format (Example)
#
#    DB Def Name,         SSN,   GTI,   TT,   NP,  NAI,      Min Digits,      Max Digits,    PC List Name,     GT Mod Name, Next EPR,     Description
#-----------------------------------------------------------------------------------------------------------------------------------------------------
        STANDARD,         ANY,   ANY,  ANY,  ANY,  ANY,             900,             900,             CAA,            NONE,UNDEFINED,          TEST_1                     
# EOF

Batch GT Calling Searches CSV Format (Example)
#
#    DB Def Name,         SSN,   GTI,   TT,   NP,  NAI,      Min Digits,      Max Digits,    PC List Name,     GT Mod Name, Next EPR,    Description,LOCAL EPR
#-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
        STANDARD,         ANY,   ANY,  ANY,  ANY,  ANY,            8765,            8765,           TO554,            NONE,UNDEFINED,           TEST,     99
        STANDARD,           6,  0010,    4,    3,    5,            7654,            7654,            NONE,            NONE,      100,               ,    100
# EOF

Batch GT OPC Searches CSV Format (Example)
#
#    DB Def Name,LOCAL EPR,OPC NNN Min,OPC NNN Max,OPC CCC Min,OPC CCC Max,OPC MMM Min,OPC MMM Max,    PC List Name,  Description
#---------------------------------------------------------------------------------------------------------------------------------
        STANDARD,    100,          0,        255,          0,        255,          0,        255,           TO777,            1PC                          
        STANDARD,    101,          7,          7,        100,        100,          1,          1,           TO778,                                
# EOF

Batch GT Modifications CSV Format (Example)
#
#    DB Def Name,     GT Mod Name,          Digits,       GTI,        TT,        NP,       NAI,        NI,       RTI,      SSNI,       SSN,       PCI,          PC,   Cmd List Name,    Description,
#---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
#       STANDARD,            MOD1,               *, NO_CHANGE, NO_CHANGE, N0_CHANGE, NO_CHANGE, NO_CHANGE, NO_CHANGE, NO_CHANGE, NO_CHANGE, NO_CHANGE,   NO_CHANGE,            NONE,         TEST_3,
#       STANDARD,            MOD1,               *, NO_CHANGE, NO_CHANGE, N0_CHANGE, NO_CHANGE, NO_CHANGE, NO_CHANGE, NO_CHANGE, NO_CHANGE, NO_CHANGE,   NO_CHANGE,            NONE,         
#EOF


Batch PC Lists CSV Format (Example)
#
#    DB Def Name,    PC List Name,           AppID,    NA,  Point Code, Cost, Weight,Rec NA,                     Description,PC Routing Format
#-----------------------------------------------------------------------------------------------------------------------------------------
    STANDARD_ITU,           TO826,                ,     0,    08.02.06,   10,      1,     0,                                ,       5.4.5
    STANDARD_ITU,           TO827,                ,     0,    08.02.07,    0,      1,     0,                                ,       5.4.5
        STANDARD,           TO777,                ,     0, 007.007.007,    0,      1,     0,                    test_upgrade,       8.8.8
        STANDARD,           TO777,                ,     0, 008.008.008,    1,      1,     0,                    test_upgrade,       8.8.8
        STANDARD,           TO777,                ,     0, 002.005.004,    0,      1,     0,                    test_upgrade,       8.8.8
         ITU-383,            TO13,                ,    14,    14.14.14,    0,      1,     0,                   test_cross_NA,       4.6.4
# EOF

Batch Command Lists CSV Format (Example)
#
#    DB Def Name,   Cmd List Name, Order, Action, Location,    Value,     Description
#------------------------------------------------------------------------------------              
        STANDARD,              C2,     1, DELETE,    RIGHT,        3,              S3   
        STANDARD,              C2,     2,TRUNCATE,    LEFT,        2,                                                               
        STANDARD,              C2,     3, INSERT,     LEFT,        3,                
        STANDARD,              C2,     4, INSERT,     LEFT,        4,                
        STANDARD,              C2,     5, INSERT,     LEFT,        5,                
# EOF


GT Searches and GT Modifications Output CSV

The following file format examples are supported for batch export only:

Note

The batch add, delete, and replace operations are not supported for this CSV format.

GT Searches Output CSV Format - Standard GTT (Example)
# Version=1
# Type=Standard
# DB=WS
# Criteria=All
#DB Def Name,Called Min Digits,Called Max Digits,Called GTI,Called NP,Called TT,Called NAI,Called SSN,Called Modification,Called Description,PC List Name,PC List Incoming AppID,PC List NA,PC List Description,PC Rec1,PC Rec2,PC Rec3,PC Rec4,PC Rec5,PC Rec6,PC Rec7,PC Rec8,PC Rec9,PC Rec10,PC Rec11,PC Rec12,PC Rec13,PC Rec14,PC Rec15,PC Rec16
STANDARD,900,900,ANY,ANY,ANY,ANY,ANY,NONE,,ANON,,0,,1 004.003.002 1 1,0 004.004.004 1 1,2 004.004.004 1 1,2 004.003.002 10 1,0 025.025.025 10 1,,,,,,,,,,,

GT Searches Output CSV Format - Advanced GTT (Example)
# Version=1
# Type=Advanced
# DB=WS
# Criteria=Batch
#DB Def Name,Called Min Digits,Called Max Digits,Called GTI,Called NP,Called TT,Called NAI,Called SSN,Called Modification,Called Description,
Calling EPR,Calling Min Digits,Calling Max Digits,Calling GTI,Calling NP,Calling TT,Calling NAI,Calling SSN,Calling Modification, Calling Description,OPC EPR,OPC Range,OPC Description,PC List Name,PC List Incoming AppID,PC List NA,PC List Description,PC Rec1,PC Rec2,PC Rec3,PC Rec4,PC Rec5,PC Rec6,PC Rec7,PC Rec8,PC Rec9,PC Rec10,PC Rec11,PC Rec12,PC Rec13,PC Rec14,PC Rec15,PC Rec16
STANDARD,10000000,10000000,5,16,256,128,257,,,1,613,613,1,2,3,4,5,,,1,1.3.78,,TEST-PCL2,,0,,0 001.001.011 10 1,0 001.001.012 20 1,0 001.001.013 30 1,0 001.001.014 10 1,0 001.001.015 0 1

GT Modifications Output CSV Format (Example)
# Version=1
# Type=Advanced
# DB=WS
# Criteria=All  DB Def=ABTEST
#DB Def Name,GT Mod Name,Digits,GTI,TT,NP,NAI,NI,RTI,SSNI,SSN,PCI,PC,Modification Description,Cmd List Name,Cmd List Description,Cmd List Rec1,Cmd List Rec2,Cmd List Rec3,Cmd List Rec4,Cmd List Rec5
ABTEST,M-ITU,7634,0001,100,3,4,NATL,RT_ON_GT,TRUE,6,TRUE,7.010.4,,NONE
ABTEST,M1-ITU,*,NO_CHANGE,NO_CHANGE,NO_CHANGE,NO_CHANGE,NO_CHANGE,NO_CHANGE,NO_CHANGE,NO_CHANGE,NO_CHANGE,NO CHANGE,,C4,1 DELETE RIGHT 2,2 INSERT LEFT 3,3 TRUNCATE LEFT 23,4 INSERT LEFT 2456,5 DELETE LEFT 4,
ABTEST,M2,*,NO_CHANGE,NO_CHANGE,NO_CHANGE,NO_CHANGE,NO_CHANGE,NO_CHANGE,NO_CHANGE,NO_CHANGE,NO_CHANGE,NO CHANGE,,NONE