<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Century Gothic";
panose-1:2 11 5 2 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Jason, You also might want to take a look at the typefieldinfo table in the database<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Run sql select * from typefieldinfo <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>This contains all of the rules Apache uses when adding the validation rules on the ccmadmin web pages, it is a bit cryptic but may help point you in the right direction.<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#0070C0'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-size:9.0pt;font-family:"Calibri","sans-serif";color:#0070C0'>Regards,</span><span lang=EN-AU style='font-size:4.0pt;font-family:"Calibri","sans-serif";color:#0070C0'><o:p></o:p></span></p><p class=MsoNormal><b><span style='font-size:4.0pt;font-family:"Cambria","serif";font-variant:small-caps;color:#1F497D'><o:p> </o:p></span></b></p><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Arial","sans-serif";font-variant:small-caps;color:#1F497D'>John Franklin<o:p></o:p></span></b></p><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'>VoIP</span></b><span style='font-size:11.0pt;font-family:"Century Gothic","sans-serif";color:black'>Integration</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> <b>| </b></span><i><u><span style='font-size:10.0pt;font-family:"Cambria","serif";color:#0070C0'><a href="http://www.voipintegration.com/" target="_blank" title="http://www.enpointe.com/"><span style='color:#0070C0'>www.VoIPintegration.com</span></a></span></u></i><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></b></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black'>201K Sand Creek Road <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black'>Brentwood, CA, USA. 94513 <o:p></o:p></span></p><p class=MsoNormal><b><i><span style='font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black'><o:p> </o:p></span></i></b></p></div><p class=MsoNormal><b><i><span style='font-family:"Century Gothic","sans-serif";color:black'>VISIT US AT CISCO LIVE BOOTH #224<o:p></o:p></span></i></b></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> cisco-voip [mailto:cisco-voip-bounces@puck.nether.net] <b>On Behalf Of </b>Jason Aarons (AM)<br><b>Sent:</b> Friday, June 07, 2013 8:08 AM<br><b>To:</b> Berry, Matthew; Heim, Dennis; Anthony Holloway<br><b>Cc:</b> cisco-voip (cisco-voip@puck.nether.net)<br><b>Subject:</b> Re: [cisco-voip] Bulk Administration and database fields/limits<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Challenge is I’m not finding all fields in the Database Dictionary, eg Display, Intercom Caller Name, these are column headers from a Export > All Details.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I had hoped to open the PDF and Hit Control + F (Find) and enter </span><span style='color:#1F497D'>Intercom Caller Name and have it come back wih the validation rule. Instead I get no matches found. My best guess is the Column Headers don’t match the database field or the dictionary just doesn’t list everything.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>I have a TAC case open.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Berry, Matthew [<a href="mailto:Matthew.Berry@wwt.com">mailto:Matthew.Berry@wwt.com</a>] <br><b>Sent:</b> Thursday, June 06, 2013 11:22 PM<br><b>To:</b> Heim, Dennis; Anthony Holloway; Jason Aarons (AM)<br><b>Cc:</b> cisco-voip (<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>)<br><b>Subject:</b> RE: [cisco-voip] Bulk Administration and database fields/limits<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>For those of you interested, here is the link to the CUCM 9.1 database dictionary.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><a href="http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/9_1_1/datadictionary_911.pdf">http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/9_1_1/datadictionary_911.pdf</a><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></b></p><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Matthew <o:p></o:p></span></b></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> cisco-voip [<a href="mailto:cisco-voip-bounces@puck.nether.net">mailto:cisco-voip-bounces@puck.nether.net</a>] <b>On Behalf Of </b>Heim, Dennis<br><b>Sent:</b> Thursday, June 06, 2013 6:42 PM<br><b>To:</b> Anthony Holloway; Jason Aarons (AM)<br><b>Cc:</b> cisco-voip (<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>)<br><b>Subject:</b> Re: [cisco-voip] Bulk Administration and database fields/limits<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Database dictionary is your friend. That tells you the validation rules for each field basically.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'>Dennis Heim | </span></b><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>Sr. Unified Collaboration Team Lead & Solution Architect </span></b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'>World Wide Technology | 314.212.1814 | <a href="mailto:dennis.heim@wwt.com">dennis.heim@wwt.com</a><b><o:p></o:p></b></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'>“Creating Impact, Ignition & Scalability”<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> cisco-voip [<a href="mailto:cisco-voip-bounces@puck.nether.net">mailto:cisco-voip-bounces@puck.nether.net</a>] <b>On Behalf Of </b>Anthony Holloway<br><b>Sent:</b> Thursday, June 06, 2013 11:05 AM<br><b>To:</b> Jason Aarons (AM)<br><b>Cc:</b> cisco-voip (<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>)<br><b>Subject:</b> Re: [cisco-voip] Bulk Administration and database fields/limits<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><div><div><div><p class=MsoNormal>You should be able to. Here is one example using the device description field.<o:p></o:p></p><div style='margin-left:30.0pt'><p class=MsoNormal><o:p> </o:p></p></div><div style='margin-left:30.0pt'><p class=MsoNormal><b><span style='font-family:"Courier New"'>2.3.77.15 description (FI-3)</span></b><br><span style='font-family:"Courier New"'>Type: string [512]</span><br><span style='font-family:"Courier New"'>Default Value: EMPTY</span><br><span style='font-family:"Courier New"'>Validation: ^[^\x00-\x1F""%\\&<>]{0,128}$</span><br><span style='font-family:"Courier New"'>Migration Source: DeviceList.Description</span><o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal>Notice on the vlidation line, which amongst things like saying which characters are valid, it also says the max length is 128.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal>Here is the HTML from the ccmadmin page for my phone. You can also see that the UI is inline with this maxlength by looking at the input element's maxlength attribute. This is a simple way of preventing people from typing in too many characters.<o:p></o:p></p><div><div><p class=MsoNormal><o:p> </o:p></p><div style='margin-left:30.0pt'><p class=MsoNormal><span style='font-family:"Courier New"'><input type="text" onchange="isdescriptionValid(this)" size="50" value="01234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567" maxlength="128" name="description" id="DESCRIPTION"></span><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Here is the database telling me that not only was I able to type in 128 chracters into the web page, it actually stored all 128 characters.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div style='margin-left:30.0pt'><p class=MsoNormal><span style='font-family:"Courier New"'>admin:run sql select length(description) from device where name = 'CIPCAHOLLOWAY'</span><br><span style='font-family:"Courier New"'>(expression)</span><br><span style='font-family:"Courier New"'>============</span><br><span style='font-family:"Courier New"'>128</span><br><span style='font-family:"Courier New"'>admin:</span><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Hope that helps.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><p class=MsoNormal>On Wed, Jun 5, 2013 at 2:12 PM, Jason Aarons (AM) <<a href="mailto:jason.aarons@dimensiondata.com" target="_blank">jason.aarons@dimensiondata.com</a>> wrote:<o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>If I wanted to verify what the maximum number of characters is allow in the “Display 1” column using Bulk Administration > Import > Import All Details should I be able to look this field up in the Database Dictionary?<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I was wanting to looking any header in the Bulk Admin imports and very if it’s a mandatory field, inserts are allowed, default values, etc.<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><a href="http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/9_1_1/datadictionary_911.pdf" target="_blank">http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/9_1_1/datadictionary_911.pdf</a><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>eg Display 1 ASCII Display 1<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>As a workaround I can go to a device and that setting and click Help for this page and look it up, but I was hoping a Searchable pdf was available of just the database fields.<o:p></o:p></p></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><br>_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal><br><br><span style='color:white'>itevomcid</span> <o:p></o:p></p></div></body></html>