How to Bulk Import Translation Patterns to CUCM?

[Matthew Martin]

Hello All,

CUCM: 10.5(2)

I was told I can Bulk import Translation Patterns into CUCM so I don't have to add each one individually, one at a time through the GUI...

I went to: BAT > Import/Export > Export, and exported the Translation Patterns, then downloaded the CSV file. I noticed the CSV file I downloaded contains: line 1 as the column headings, and then one translation pattern per line after that.

Importing Translation Patterns' Questions:

1. Does the Column Header line (*line #1) need to be included in the new CSV file I want to import?
2. When importing translation patterns, does the CSV file being uploaded append to the existing Translation Patterns in CUCM, or does it replace what's already there?

For question #2, I wasn't sure if I'm supposed to take the exported csv file I already have and just append the new Patterns to the end of that CSV file, or if I'm supposed to upload a new CSV file with ONLY the NEW patterns I want to add...?

Any suggestions would be greatly appreciated!

Thanks in Advance,

Matt

[Slavik Bialik · Accepted solution]

Hi! I'll answer...

First of all, you must leave the header. It's mandatory.

Second of it, when you want to upload back your changed CSV, you must leave the file structure the same as you downloaded it. If you noticed, you downloaded a TAR file, not CSV. And in the TAR file you have the "translationpattern.csv" file and also a file named header.txt. So after you finish your changes, select both files and archive them back to a TAR file, and upload this TAR file to bulk management.

Another thing is don't have to leave all the lines in the CSV file, you can remove all of them (I'd prefer that) and add new lines accordingly. Don't worry, it won't remove your current translation patterns, it'll just add the new ones. You can leave the current lines if for example you want modify your current translations and change something. You can also leave them in the file, and when you import them back, as long as you didn't change anything for the current translations, it won't update anything and just add the new ones.

[Matthew Martin]

Hi Slavik, thanks for the reply!

Ok perfect, that's exactly what I needed to know. Right, I forgot to mention the tar file stuff, but I do understand that part of it...

Thanks again for the reply, very much appreciated!

-Matt

[byronmcneil]

Hello , I want to import the 58 lines of translations for some Fax lines wt have and when I used this method Created the Translationpattern.csv with the header as a .tar  the 58 lines did not update as expected.

1. I exported the translations and it had dependencies. Modified the translationpattern.csv to include all my lines of 58

2. I archived the .csv and the header .txt only 

3. I imported and selected the .tar

4. no records are found and there was no error 

[byronmcneil]

Hello 

Reading is fund dememtal , I had not use the correct file name in my Tar for the .CSV

Now it is processing the lines but fail on all 58 

null (Record Number 1) Insert failed due to non existing values

null (Record Number 2) Insert failed due to non existing values

null (Record Number 3) Insert failed due to non existing values

null (Record Number 4) Insert failed due to non existing values

null (Record Number 5) Insert failed due to non existing values

null (Record Number 6) Insert failed due to non existing values

null (Record Number 7) Insert failed due to non existing values

null (Record Number Insert failed due to non existing values

null (Record Number 9) Insert failed due to non existing values

null (Record Number 10) Insert failed due to non existing values

null (Record Number 11) Insert failed due to non existing values

null (Record Number 12) Insert failed due to non existing values

null (Record Number 13) Insert failed due to non existing values

null (Record Number 14) Insert failed due to non existing values

null (Record Number 15) Insert failed due to non existing values

null (Record Number 16) Insert failed due to non existing values

null (Record Number 17) Insert failed due to non existing values

null (Record Number 18) Insert failed due to non existing values

null (Record Number 19) Insert failed due to non existing values

null (Record Number 20) Insert failed due to non existing values

null (Record Number 21) Insert failed due to non existing values

null (Record Number 22) Insert failed due to non existing values

null (Record Number 23) Insert failed due to non existing values

null (Record Number 24) Insert failed due to non existing values

null (Record Number 25) Insert failed due to non existing values

null (Record Number 26) Insert failed due to non existing values

null (Record Number 27) Insert failed due to non existing values

null (Record Number 28) Insert failed due to non existing values

null (Record Number 29) Insert failed due to non existing values

null (Record Number 30) Insert failed due to non existing values

null (Record Number 31) Insert failed due to non existing values

null (Record Number 32) Insert failed due to non existing values

null (Record Number 33) Insert failed due to non existing values

null (Record Number 34) Insert failed due to non existing values

null (Record Number 35) Insert failed due to non existing values

null (Record Number 36) Insert failed due to non existing values

null (Record Number 37) Insert failed due to non existing values

null (Record Number 38) Insert failed due to non existing values

null (Record Number 39) Insert failed due to non existing values

null (Record Number 40) Insert failed due to non existing values

null (Record Number 41) Insert failed due to non existing values

null (Record Number 42) Insert failed due to non existing values

null (Record Number 43) Insert failed due to non existing values

null (Record Number 44) Insert failed due to non existing values

null (Record Number 45) Insert failed due to non existing values

null (Record Number 46) Insert failed due to non existing values

null (Record Number 47) Insert failed due to non existing values

null (Record Number 48) Insert failed due to non existing values

null (Record Number 49) Insert failed due to non existing values

null (Record Number 50) Insert failed due to non existing values

null (Record Number 51) Insert failed due to non existing values

null (Record Number 52) Insert failed due to non existing values

null (Record Number 53) Insert failed due to non existing values

null (Record Number 54) Insert failed due to non existing values

null (Record Number 55) Insert failed due to non existing values

null (Record Number 56) Insert failed due to non existing values

[Roger Kallberg]

Two things, number one you already have an ongoing post on this, please continue with your line of question on it. https://community.cisco.com/t5/ip-telephony-and-phones/looking-to-insert-device-cti-port-just-for-forwarding-the-number/m-p/4956936#M412610
Second, this post is six years old and marked as solved, so it’s not advisable to use it to ask questions.

[byronmcneil]

I was able to get it imported it was an Excel cell number conversion issue 

all 58 imported as discussed

Thanks all 

[00u1c1e8sgNfbgbZ15d7]

Hello Slavik, Thanks for great post.

Regarding this procedure:

a) When I EXPORT initial file with translations patterns, do I need to select "check dependency"?

b) After i removed lines for current TPs and added new ones on downloaded file, Do I need to save the file with the same name "translationpattern.csv" ?

c) After I get my tar file with csv and txt files, Do i need to select options below?

d) JUST TO CONFIRM, when I delete lines for already configured Translations patterns on system, and I upload it new UPDATED file I will not delete any of already in production TPs, is it correct?

I really appreciate your help

Enrique