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:
- Batch GT Called Searches CSV Format
- Batch GT Calling Searches CSV Format
- Batch GT OPC Searches CSV Format
- Batch GT Modifications CSV Format
- Batch PC Lists CSV Format
- Batch Command Lists CSV Format
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:
- Batch GT Searches Output CSV Format - Standard GTT
- Batch GT Searches Output CSV Format - Advanced GTT
- Batch GT Modifications Output CSV Format
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
Overview
Content Tools