cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
738
Views
0
Helpful
5
Replies
Highlighted

Route Pattern CSV File Removes "0" from Called Party Prefix Digits Field

I want to upload over 350 route patterns using BAT Tool in CUCM 9.1. All patterns must have their Called Party Prefix Digits (Outgoing Calls) Field containing 10 numbers with the number "0" at the begining. The Problem is the CSV file removes the leading "0" form the digits. I tried to make the cell type in Excel as "Text" and it worked and the "0" is kept normally, but when I save and close the file then open it again, the cell is defaulted to "General" type and the "0" is disappeared again! Changing the CSV file format to any other one and uploading it to CUCM system generates an error stating that the file format is not supported.

Attached is a sample entry of the CSV file. I want to preserve the whole number "0541234567" in "PREFIX_DIGITS_CALLED_PARTY" Field.

Anyone can help me how to upload this big number of route patterns while preserving the number "0" at the begining?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Yes, that is the way excel works, so dont open the file again, adjust it, save and run via BAT. I've done deployment with extensions starting with 0 and it works fine as long as you dont keep opening it.

Chris

View solution in original post

5 REPLIES 5
Highlighted
Hall of Fame Master

Make sure you change the csv file when using Excel to "Text" on the cell where the string starts with 0, otherwise Excel assumes this is a number and strips it.

HTH, please rate all useful posts!

Chris

Highlighted

I've tried that, but when saving and closing the file then open it again, the type of the cell is returned back to General and the "0" is stripped out again.

You can try that on the attached file and see this behavior.

Sent from Cisco Technical Support iPhone App

Highlighted

Yes, that is the way excel works, so dont open the file again, adjust it, save and run via BAT. I've done deployment with extensions starting with 0 and it works fine as long as you dont keep opening it.

Chris

View solution in original post

Highlighted

YES! it worked after adjusting it then uploading it directly without opening it again ... Thank you very much Chris

Highlighted

Very Helpfull.Thank you very much

Content for Community-Ad