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

[John Franklin]

Jason, You also might want to take a look at the typefieldinfo table in the database

Run sql select * from typefieldinfo

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.

Regards,

John Franklin
VoIPIntegration | www.VoIPintegration.com<http://www.voipintegration.com/>
201K Sand Creek Road
Brentwood, CA, USA. 94513

VISIT US AT CISCO LIVE BOOTH #224

From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Jason Aarons (AM)
Sent: Friday, June 07, 2013 8:08 AM
To: Berry, Matthew; Heim, Dennis; Anthony Holloway
Cc: cisco-voip (cisco-voip at puck.nether.net)
Subject: Re: [cisco-voip] Bulk Administration and database fields/limits

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.

I had hoped to open the PDF and Hit Control + F (Find) and enter 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.

I have a TAC case open.





From: Berry, Matthew [mailto:Matthew.Berry at wwt.com]
Sent: Thursday, June 06, 2013 11:22 PM
To: Heim, Dennis; Anthony Holloway; 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


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<mailto: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



itevomcid
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130607/1c4b36ae/attachment.html>