[cisco-voip] Bulk Administration and database fields/limits

[Berry, Matthew]

For those of you interested, here is the link to the CUCM 9.1 database dictionary.

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/9_1_1/datadictionary_911.pdf


Matthew

From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Heim, Dennis
Sent: Thursday, June 06, 2013 6:42 PM
To: Anthony Holloway; Jason Aarons (AM)
Cc: cisco-voip (cisco-voip at puck.nether.net)
Subject: Re: [cisco-voip] Bulk Administration and database fields/limits

Database dictionary is your friend. That tells you the validation rules for each field basically.

Dennis Heim | Sr. Unified Collaboration Team Lead & Solution Architect
World Wide Technology | 314.212.1814 | dennis.heim at wwt.com<mailto:dennis.heim at wwt.com>
“Creating Impact, Ignition & Scalability”

From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Anthony Holloway
Sent: Thursday, June 06, 2013 11:05 AM
To: Jason Aarons (AM)
Cc: cisco-voip (cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>)
Subject: Re: [cisco-voip] Bulk Administration and database fields/limits

You should be able to.  Here is one example using the device description field.

2.3.77.15 description (FI-3)
Type: string [512]
Default Value: EMPTY
Validation: ^[^\x00-\x1F""%\\&<>]{0,128}$
Migration Source: DeviceList.Description

Notice on the vlidation line, which amongst things like saying which characters are valid, it also says the max length is 128.

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.

<input type="text" onchange="isdescriptionValid(this)" size="50" value="01234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567" maxlength="128" name="description" id="DESCRIPTION">

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.

admin:run sql select length(description) from device where name = 'CIPCAHOLLOWAY'
(expression)
============
128
admin:

Hope that helps.


On Wed, Jun 5, 2013 at 2:12 PM, Jason Aarons (AM) <jason.aarons at dimensiondata.com<mailto:jason.aarons at dimensiondata.com>> wrote:
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?

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.

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/9_1_1/datadictionary_911.pdf

eg Display 1        ASCII Display 1


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.

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130606/07ded682/attachment.html>