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

Anthony Holloway avholloway+cisco-voip at gmail.com
Thu Jun 6 11:04:36 EDT 2013


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> 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
> 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/5d0d4fb5/attachment.html>


More information about the cisco-voip mailing list