Cisco Unified MeetingPlace Release 6.1 -- Import Database Fields

From DocWiki

Jump to: navigation, search

Cisco Unified MeetingPlace Release 6.1 > Cisco Unified MeetingPlace Audio Server > Maintaining > File Import Specifications


Table: Table B-1 Import Database Fields
Field Abbreviation Length Type of Value, or Value Choices

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

Rating: 0.0/5 (0 votes cast)

Personal tools