Cisco Unified MeetingPlace Release 6.1 -- Import Database Fields

First name*

Fnm

17

Alphanumeric

Last name*

Lnm

17

Alphanumeric

User ID*

uid

17

Alphanumeric

New User ID

newuid

17

Alphanumeric

Use this field to assign new IDs to several users. To import a series of new user IDs, create an import file and specify each user's old ID using the uid field. Specify their new ID using the newuid field. (During import, prfpwd and upwd fields may be used for clear text passwords. However, adding data in clear text and encrypted password fields overrides encrypted version if import file contains both fields.)

User password

upwd

11

Alphanumeric

Encrypted user password

EncryptedUserPWD

11

Users cannot edit this field.

Field is read-only field, used for re-importing encrypted passwords previously exported from Cisco Unified MeetingPlace.

Last changed

wfpasswordlastchanged

MM/DD/YYYY HH:MM

Profile number*

prfnum

17

Numeric

Profile password

prfpwd

11

Alphanumeric

Encrypted profile password

EncryptedProfilePWD

11

Users cannot edit this field.

Field is read-only field, used for re-importing encrypted passwords previously exported from Cisco Unified MeetingPlace.

Last changed

vupasswordlastchanged

MM/DD/YYYY HH:MM

User active

Uactive

yes/no/locked/groupdefault

Type of user*

Utype

enduser/contact/attendant/sysmgr

Group name**

Grpnme

11

Alphanumeric

Group number**

Grpnum

17

Numeric

Phone number**

Phnum

32

Numeric

Allowed characters: ( ) , - " " space

Alternate phone number*

AltPhNum

32

Numeric

Allowed characters: ( ) , - " " space

Type of pager

pgrtype

none/didpager/nondidpager/ groupdefault

Pager phone number*

Pgrnum

32

Direct Dial-pager number Non Direct Dial-user's pager access code (PIN)

Video Terminal ID

VideoTerminalID

32

Alphanumeric

Video Terminal Name

VideoTerminalName

64

Alphanumeric

Video Terminal Classification

VideoTerminalClassification

64

Alphanumeric

Profile Type

ProfileType

User/Video_Terminal

Video Attend Preference

VideoAttendPreference

Call_In/Dial_Out

Video MCU Only

fVideoMCUOnly

Yes/No

First Search***

1stSearch

None/main/alternate/pager/gd

Choosing gd for this field also applies gd to the other search fields. (For example, choosing gd for First Search applies gd to Second Search and Third Search.)

Second Search***

2ndSearch

None/main/alternate/pager/gd

Choosing gd for this field also applies gd to the other search fields. (For example, choosing gd for Second Search applies gd to First Search and Third Search.)

Third Search***

3rdSearch

None/main/alternate/pager/gd

Choosing gd for this field also applies gd to the other search fields. (For example, choosing gd for Third Search applies gd to First Search and Second Search.)

Internet E-mail Address*

InternetEmailAddr

127

Alphanumeric

User's Internet e-mail address (for example, UserName@Company.com). Used when users browse meetings in Cisco Unified MeetingPlace Web and request to send e-mail to scheduler. Also used to send e-mail notifications to such users when E-mail Address field in their profile is blank.

Time zone*

Tzcode

Numeric-groupdefault

In MeetingTime, use Time Zone Import Codes in the Configure tab. (See the list of numeric codes on the Time Zone Codes page.)

Abbreviated prompts

Abbprmpts

yes/no/groupdefault

Billing code

Bcode

17

Alphanumeric-groupdefault

Default mtg category

Meetingcategory

17

Alphanumeric-groupdefault

Scheduling home server

Preferredunit

Numeric-0-8/groupdefault

Able to record mtgs

Canrecord

yes/no/groupdefault

Record meetings

Recordmtgs

yes/no/groupdefault

Who can access

Whocanlstn

none/anyone/invtdusrs/users/groupdefault

Auto-start recording

Autostrtrcrd

yes/no/groupdefault

Attachment access ordering

Playattlstfifo

yes/no/groupdefault

Display mtg to everyone

fallowguestview

yes/no/groupdefault

Can call out from mtgs?

Cndial

yes/no/groupdefault

Can call other servers?

fcaninviteremoteservers

yes/no/groupdefault

Max outdials per mtg

maxvuiodspermtg

Numeric-0-500/10000 (unrestricted)/groupdefault

Can schedule guest outdial mtgs?

canallowguestoutdial

yes/no/groupdefault

Allow outdials to guests from Web

allowguestoutdial

yes/no/groupdefault

Ask for profile password

pwdonoutdial

yes/no/groupdefault

Digit translation table

odxlattablenum

Numeric-0-15/groupdefault

Entry announcement

Annentry

beepname/beep/none/groupdefault

Departure announcement

Anndpart

beepname/beep/none/groupdefault

Entry announcement in breakouts

fBreakoutAnn

beepname/beep/none/groupdefault

NOTE: This field is only found in Cisco Unified MeetingPlace Release 6.0 Maintenance Release 4 and later.

Meeting announcements for reservationless meetings

fRsvlessAnn

Yes/No/groupdefault

NOTE: This field is only found in Cisco Unified MeetingPlace Release 6.0 Maintenance Release 4 and later.

Screened entry

Screntry

yes/no/groupdefault

Skip pre-meeting options

Shrtmnus

yes/no/groupdefault

Disable roll call

disablerollcall

yes/no/groupdefault

Password required

Pwdreq

yes/no/groupdefault

Who can attend

whocanattnd

anyone/users/invtdusrs/groupdefault

Lecture meeting attend settings?

fstartpeopleinwr

AdmitAsListeners/StartInWaitingRm/ StartMtgWithFloorOpen/ReservationlessMtg/groupdefault

Caution! A meeting with this field set to Reservationless Mtg cannot be imported.

Scheduling restriction

maximmedmtgsperday

Numeric-0-50/10000 (unrestricted)/10001 (cannot schedule)/groupdefault

Max mtg length (min)

maximummeetinglength

Numeric-0-MaximumMeetingLength/groupdefault

Max # of attachments

Mxattsprmtg

Numeric-0-30/groupdefault

Sched only on home server?

Schedprefunitonly

yes/no/groupdefault

Sched only on NS home site

schedhomesiteonly

yes/no/groupdefault

Max # teams allowed

publiculallowed

Numeric-0-10000/groupdefault

Can chg mtg ID via phone

CanChangeMtgID

yes/no/groupdefault

Enabled for this mtg

sndnotifs

yes/no/groupdefault

Include attachments

autodistatts

yes/no/groupdefault

Priority

dfltnotifprio

low/normal/urgent/groupdefault

Send if mtg changes

sndnotifonmtgch

yes/no/groupdefault

Include participant list

sndinvlstwnotif

yes/no/groupdefault

Include password

sndmtgpwdwnotif

yes/no/groupdefault

Enable to receive

rcvnotifs

yes/no/groupdefault

Include attachments

rcvattswnotif

yes/no/groupdefault

E-mail address

emailaddr

128

Alphanumeric

User's e-mail address. Cisco Unified MeetingPlace also uses this address to send e-mail notifications to this user.

Type of e-mail system

emailtype

none/ccmail/lotusnotes/msmail/groupdefault

Fax phone number

(Not supported in Cisco Unified MeetingPlace Audio Server Release 5.0 and later)

faxnum

17

Numeric-0-32/groupdefault

User's fax number.

Fax digit translation table

(Not supported in Cisco Unified MeetingPlace Audio Server Release 5.0 and later)

faxxlattblnum

Numeric-0-15/groupdefault

Preferred delivery method

prmrynotifprf

none/email/groupdefault

Alternate delivery method

Altnotifprf

non/email/groupdefault

Method of attending

Attndprf

usercallsin/syscallsuser/syspagesuser/sysfindsuser/notattend

QampersandA off at mtg startup?

fqnadisabled

yes/no/groupdefault

Notify attendees about QampersandA

Qnanotify

yes/no/groupdefault

QampersandA introduction

announceqarr

Beepname/beep/none/groupdefault

QampersandA departure

announceqdep

Beepname/beep/non/groupdefault

Automatically ask next question

fautoproenabled

yes/no/groupdefault

More than one question per site?

concurrentquestions

yes/no/groupdefault

Tell my position in line

ftellpartpos

yes/no/groupdefault

Disable floor warning prompt

fadvanceInfo

yes/no/groupdefault

Flex Field 1

profileflex1

17

text/number/date/yes/no/groupdefault

Customizable fields. See the About Flex Fields for more information.

Flex Field 2

profileflex2

17

text/number/date/yes/no/groupdefault

Flex Field 3

profileflex3

17

text/number/date/yes/no/groupdefault

Flex Field 4

profileflex4

17

text/number/date/yes/no/groupdefault

Flex Field 5

profileflex5

17

text/number/date/yes/no/groupdefault

Flex Field 6

profileflex6

17

text/number/date/yes/no/groupdefault

Flex Field 7

profileflex7

17

text/number/date/yes/no/groupdefault

User ID of contact

ctctuid

Alphanumeric

Recorded profile name?

vname

recorded/notrecorded

Date user last scheduled an immediate meeting

dayoflastimmedmtg

MM/DD/YYYY HH:MM

Number of immediate meetings

Numimmedmtgson thatday

Numeric-0-1000

Number of group-wide teams the user can create

Groupulallowed

Numeric-0-1000

Number of private teams user can create

privateulallowed

Numeric-0-1000

Profile user's selected language

VLanguage

English (US), English (UK), French (Canadian), French (French), Japanese, German, Portuguese (Brazil), Spanish (Americas)

Whether this user prefers end meeting warning turned on or off

fEndMtgWarn

yes/no/groupdefault

Whether this user prefers meeting extend prompts turned on or off

fMtgExtendPrompts

yes/no/groupdefault

Single System Image-System ID

SSI-SystemID

Reserved for future use

Single System Image-Roll Map ID

SSI-RollMapID

Reserved for future use

Single System Image-Site ID

SSI-SiteID

Reserved for future use

Used in a profile import file to change the user ID of an existing user

newuid

17

Alphanumeric

Used in a profile import file to change the profile number of an existing user

newprfnum

17

Numeric

Allow Internet Access

fAllowInternetAccess

yes/no/groupdefault

Display Meeting to Everyone

fAllowGuestView

yes/no

Allow Internet Access for Reservationless

fRsvnlessAllowInternetAcc

yes/no/groupdefault

Display Meeting to Everyone for Reservationless

fRsvnlessAllowGuestView

yes/no