Cisco VG350 BAT to add or update lines

It's 2019 and whether you like it or not we still have to support analog endpoints.  Adding them manually in any sort of quantity is awful.

Cisco TAC has a nice write up on what's required here: https://www.cisco.com/c/en/us/support/docs/unified-communications/bulk-administration-tool/118882-config-vg-00.html  I suspect it's a matter of time before that link breaks though and I've added some detail to steps below that seems to trip everyone up.

Update the device and line level configuration of ports on an existing Cisco voice gateways via BAT

1. Navigate to your CUCM administration at https://YourServerName
2. Choose Bulk Administration | Import/Export | Export. 
3. Under Device Data, choose Gateway. 
4. Select a filename, Run Immediately and Submit
5. Choose Bulk Administration | Upload/Download files. 
6. Choose the .tar file you created above and download.
7. Make a backup copy.
8. Extract the .tar file using 7zip to a folder and open the .csv file.
9. The port and the DN configurations are to be entered under the section Entity:ANALOG.
1. Optional: If you want to avoid updating or overwriting existing gateway and port configurations, you can remove the gateways, inventory and ports from the gateway.csv that you want to ignore.
1. Remove all the gateways from Entity:GATEWAY except for those you are updating.
2. Remove all the inventory from Entity:SLOTCONFIGURATION except that related to the gateways you are updating, where GATEWAY NAME = DOMAIN NAME.
3. Remove all the ports from Entity:ANALOG except those you are updating or adding.

   

   CUCM Gateway BAT export and edited import file

10. All the columns need to be updated in this section.
1. You can increment the PORT NUMBER column within a slot and subunit
2. You can increment the last two ENDPOINT NAME characters in hex
3. The DESCRIPTION field should be 50 characters or less.
4. The LINE DESCRIPTION 1 field should be 50 characters or less.
5. Apostrophes in the LINE DESCRIPTION, ALERTING NAME, etc. will result in errors like 'AN695ABCDEFABCDEF' A syntax error has occurred. but seem to be accepted regardless.
11. Save the .csv file with the same name and in the same folder where you extracted the .tar file.
1. The gateway and header files should be encoded and / or saved as UTF-8 to allow for special characters in gateway names.
12. Use 7zip to create a new .tar file of this folder.  You can alternatively simply add the edited csv back into the original downloaded tar file.
1. The tar file should include a folder of the same name.  The header and gateway files should then reside in that folder.  They shouldn’t be in the root of the tar file.
13. Choose Bulk Administration | Upload/Download files | Add New. 
14. Choose the .tar file, choose the target as Import/Export, choose the Transaction Type as Import Configuration, and click Save.
15. Choose Bulk Administration | Import/Export | Import. Choose the .tar file uploaded above and then Next.
16. Under Device Data, choose Gateway and toggle "Override the existing configuration" as required. Run the job.