Accepted Solutions
This is an example file that we have.
FIRST NAME,MIDDLE NAME,DISPLAY NAME,LAST NAME,USER ID,USER STATUS,PASSWORD,MANAGER USER ID,DEPARTMENT,PIN,DEFAULT PROFILE,USER LOCALE,TELEPHONE NUMBER,MOBILE NUMBER,HOME NUMBER,PAGER NUMBER,TITLE,PRIMARY EXTENSION,ASSOCIATED PC,IPCC EXTENSION,MAIL ID,PRESENCE GROUP,SUBSCRIBE CALLING SEARCH SPACE,DIGEST CREDENTIALS,REMOTE DESTINATION LIMIT,MAXIMUM WAIT TIME FOR DESK PICKUP,ALLOW CONTROL OF DEVICE FROM CTI,ENABLE MOBILITY,ENABLE VOICE MAIL ACCESS,ENABLE EMCC,DIRECTORY URI,Access Control Group 1,CONTROLLED PROFILE 1,CONTROLLED DEVICE 1,CTI CONTROLLED PROFILE 1,MLPP USER IDENTIFICATION NUMBER,MLPP PASSWORD,MLPP PRECEDENCE AUTHORIZATION LEVEL,HOME CLUSTER,LICENSE USER FOR UNIFIED CM IM AND PRESENCE,UC SERVICE PROFILE,INCLUDE MEETING INFORMATION IN PRESENCE,SELF-SERVICE USER ID,USER PROFILE,ASSIGNED PRESENCE SERVER,ENABLE END USER TO HOST CONFERENCE NOW, MEETING NUMBER, ATTENDEES ACCESS CODE
Test,,,OSS,TESTOSS,Active Local User,TESTOSS,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
However it was awhile since it was run, so not sure how it works, or even if it works, with the current version we're on.
Which option are you using? Import/Export import option? I used your CSV file with the user import option, and it worked for me without any errors like "first name is not a supported field." on the CUCM. I had to remove the Access Control Group and Local, as they were not present on my CUCM.
The sample file in CM looks like this.
Sample string from CSV file:
FIRST NAME,MIDDLE NAME,DISPLAY NAME,LAST NAME,USER ID,PASSWORD,MANAGER USER ID,DEPARTMENT,PIN,DEFAULT PROFILE,USER LOCALE,TELEPHONE NUMBER,MOBILE NUMBER,HOME NUMBER,PAGER NUMBER,TITLE,PRIMARY EXTENSION,ASSOCIATED PC,IPCC EXTENSION,MAIL ID,PRESENCE GROUP,SUBSCRIBE CALLING SEARCH SPACE,DIGEST CREDENTIALS,REMOTE DESTINATION LIMIT,MAXIMUM WAIT TIME FOR DESK PICKUP,ALLOW CONTROL OF DEVICE FROM CTI,ENABLE MOBILITY,ENABLE VOICE MAIL ACCESS,ENABLE EMCC,DIRECTORY URI,Access Control Group 1,CONTROLLED PROFILE 1,CONTROLLED DEVICE 1,CTI CONTROLLED PROFILE 1,MLPP USER IDENTIFICATION NUMBER,MLPP PASSWORD,MLPP PRECEDENCE AUTHORIZATION LEVEL,HOME CLUSTER,LICENSE USER FOR UNIFIED CM IM AND PRESENCE,UC SERVICE PROFILE,INCLUDE MEETING INFORMATION IN PRESENCE,SELF-SERVICE USER ID,USER PROFILE,ASSIGNED PRESENCE SERVER,ENABLE END USER TO HOST CONFERENCE NOW, MEETING NUMBER, ATTENDEES ACCESS CODE, EXMAX LOGIN TIME
John,Pat,JohnSmith,Smith,johns,abcde,Daviss,12,12345,johnProfile,English United States,9728135047,9765478234,9768546853,9785632458,Testone,9725557154 in EST,johns-pc,9728126675 in WST,johns,Standard Presence Group,Branch_0001_GW,abcde123,4,10000,f,f,f,f,data@uri,CCM Users,johnprofile,SEP1231123245AB,johnProfile,123456789,12345,4,t,t,ucprofile,t,123456789,johnUserProfile,10.10.10.10,t,123456789,5678,1080
Sample string defined:
John,Pat,JohnSmith,Smith,johns,abcde,Daviss,12,12345,johnProfile,English United States,9728135047,9725557154 in EST,johns-pc,9728126675 in WST,johns,Standard Presence Group,Branch_0001_GW,abcde123,4,10000,f,f,f,f,data@uri,CCM Users,johnprofile,SEP1231123245AB,johnProfile,123456789,12345,4,t,t,ucprofile,t,5678,1080
|__| |__||_______||___| |__| |____| |_____||_||____| |_________| |___________________| |_______| |_______________| |_______||_______________| |___| |______________________||____________| |______| | |___| | | | | |______| |_______| |_________| |_____________| |_________| |_______| |___| | | | |_______| | ||____| |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Extension Mobility Maximum Login Time (upto 10080, optional)
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Attendees access code( 3 to 10 numeric characters ,optional)
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Enable end user to host conference now (t or f)
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | UC Service Profile
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | License User for Unified CM IM and Presence
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Home Cluster
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | MLPP Precedence Authorization Level(up to 50 characters , optional)
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | MLPP Password(4 to 20 Numerals , optional)
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | MLPP User Identification Number(6 to 20 Numerals , optional)
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | CTI Controlled Profile (up to 50 characters, optional)
| | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Controlled Device Profile (up to 50 characters, optional)
| | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | Controlled Device (up to 50 characters, optional)
| | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | Access Control Group (up to 50 characters, optional)
| | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | Directory URI
| | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | Enable EMCC ( t or f)
| | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | |Enable Voice Mail Access ( t or f)
| | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | |Enable Mobility ( t or f)
| | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | Allow control of device from CTI ( t or f)
| | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | Maximum Wait Time for Desk Pickup(Up to 5 numerals,optional)
| | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | Remote Destination Limit(Up to 2 numerals,Optional)
| | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | Digest Credentials(Up to 128 hexa decimal characters,Optional)
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | Subscribe Calling Search Space(Up to 50 characters,Optional)
| | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | Presence Group(Up to 50 characters,optional)
| | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | Mail ID (up to 50 characters, optional)
| | | | | | | | | | | | | | |
| | | | | | | | | | | | | | IPCC Extension ('DirectoryNumber[up to 50 numerals] in Partition[up to 50 characters]', optional)
| | | | | | | | | | | | | |
| | | | | | | | | | | | | Associated PC (up to 50 characters, optional)
| | | | | | | | | | | | |
| | | | | | | | | | | | Primary Extension ('DirectoryNumber[up to 50 numerals] in Partition[up to 50 characters]', optional)
| | | | | | | | | | | |
| | | | | | | | | | | Telephone Number (up to 50 numerals, optional)
| | | | | | | | | | |
| | | | | | | | | | User Locale (up to 50 characters, optional)
| | | | | | | | | |
| | | | | | | | | Default User Device Profile (up to 50 characters, optional)
| | | | | | | | |
| | | | | | | | PIN (up to 20 numerals, optional)
| | | | | | | |
| | | | | | | Department (up to 30 characters, optional)
| | | | | | |
| | | | | | Manager User ID (up to 30 characters, optional)
| | | | | |
| | | | | Password (up to 20 characters, optional)
| | | | |
| | | | User ID (up to 30 characters, mandatory)
| | | |
| | | Last Name(1 to 50 characters, mandatory)
| | Display Name(1 to 50 characters, optional)
| Middle Name (1 to 50 characters, optional)
|
|
First Name (1 to 50 characters, optional)
Instructions: 1.Values you do not want to specify at this time must still include the delimiter (a comma). For example,
If the Manager for a user is blank, a sample record would be:
John,Pat,Smith,johns,abcde,,12,12345,johnProfile,English United States,9728135047,9725557154 in EST,johns-pc,9728126675 in WST,johns,Standard Presence Group,Branch_0001_GW,pqrs123,4,10000,CCM Users,johnprofile,SEP1231123245AB
2.A user can control more than one device. Device Names of additional devices
can be added at the end of the record. File format should also contain entries for the additional devices. For example,
a.If the user controls only one device 'SEP1231123245AB', a sample record would be:
FIRST NAME,MIDDLE NAME,LAST NAME,USER ID,PASSWORD,MANAGER USER ID,DEPARTMENT,PIN,DEFAULT PROFILE,USER LOCALE,TELEPHONE NUMBER,PRIMARY EXTENSION,ASSOCIATED PC,IPCC EXTENSION,MAIL ID,Access Control Group 1,CONTROLLED PROFILE 1,CONTROLLED DEVICE 1
John,Pat,Smith,johns,abcde,Daviss,12,12345,johnProfile,English United States,9728135047,9725557154 in EST,johns-pc,9728126675 in WST,johns,Standard Presence Group,Branch_0001_GW,pqrs123,4,10000,CCM Users,johnprofile,SEP1231123245AB
b.If the user controls two devices, a sample record would be:
FIRST NAME,MIDDLE NAME,LAST NAME,USER ID,PASSWORD,MANAGER USER ID,DEPARTMENT,PIN,DEFAULT PROFILE,USER LOCALE,TELEPHONE NUMBER,PRIMARY EXTENSION,ASSOCIATED PC,IPCC EXTENSION,MAIL ID,Access Control Group 1,CONTROLLED PROFILE 1,CONTROLLED DEVICE 1,CONTROLLED DEVICE 2
John,Pat,Smith,johns,abcde,Daviss,12,12345,johnProfile,English United States,9728135047,9725557154 in EST,johns-pc,9728126675 in WST,johns,Standard Presence Group,Branch_0001_GW,pqrs123,4,10000,CCM Users,johnprofile,SEP1231123245AB,SEP12345677AC22
c.If the user does not control any device, a sample record can be:
FIRST NAME,MIDDLE NAME,LAST NAME,USER ID,PASSWORD,MANAGER USER ID,DEPARTMENT,PIN,DEFAULT PROFILE,USER LOCALE,TELEPHONE NUMBER,PRIMARY EXTENSION,ASSOCIATED PC,IPCC EXTENSION,MAIL ID,Access Control Group 1,CONTROLLED PROFILE 1,CONTROLLED DEVICE 1
John,Pat,Smith,johns,abcde,Daviss,12,12345,johnProfile,English United States,9728135047,9725557154 in EST,johns-pc,9728126675 in WST,johns,Standard Presence Group,Branch_0001_GW,pqrs123,4,10000,CCM Users,johnprofile,
3.If the value of the field includes a comma, then that field must be enclosed in double quotes. Enclosing the field in double quotes is not required for characters other than comma and double quotes in the field value.
For example if the password includes a comma in its value, the sample record would be:
John,Pat,Smith,johns,"ab,cde",Daviss,12,12345,johnProfile,English United States,9728135047,9725557154 in EST,johns-pc,9728126675 in WST,johns,CCM Users,johnprofile,SEP1231123245AB
4.If the field includes double quotes in its value, each double quote should be replaced by two consecutive double quotes in the CSV, and the resulting string be enclosed in double quotes.
For example, if the password value is abcd,"e,f then sample record would be:
John,Pat,Smith,johns,"ab""cde",Daviss,12,12345,johnProfile,English United States,9728135047,9725557154 in EST,johns-pc,9728126675 in WST,johns,CCM Users,johnprofile,SEP1231123245AB
5.Primary Extension and IPCC Extension should be in following format
a. If Partition is not None
'DirectoryNumber in Partition'
For example, '1000 in EST' where 1000 is DirectoryNumber and EST is Partition
b. If Partition is None
'DirectoryNumber'
For example, '1000'
This is an example file that we have.
FIRST NAME,MIDDLE NAME,DISPLAY NAME,LAST NAME,USER ID,USER STATUS,PASSWORD,MANAGER USER ID,DEPARTMENT,PIN,DEFAULT PROFILE,USER LOCALE,TELEPHONE NUMBER,MOBILE NUMBER,HOME NUMBER,PAGER NUMBER,TITLE,PRIMARY EXTENSION,ASSOCIATED PC,IPCC EXTENSION,MAIL ID,PRESENCE GROUP,SUBSCRIBE CALLING SEARCH SPACE,DIGEST CREDENTIALS,REMOTE DESTINATION LIMIT,MAXIMUM WAIT TIME FOR DESK PICKUP,ALLOW CONTROL OF DEVICE FROM CTI,ENABLE MOBILITY,ENABLE VOICE MAIL ACCESS,ENABLE EMCC,DIRECTORY URI,Access Control Group 1,CONTROLLED PROFILE 1,CONTROLLED DEVICE 1,CTI CONTROLLED PROFILE 1,MLPP USER IDENTIFICATION NUMBER,MLPP PASSWORD,MLPP PRECEDENCE AUTHORIZATION LEVEL,HOME CLUSTER,LICENSE USER FOR UNIFIED CM IM AND PRESENCE,UC SERVICE PROFILE,INCLUDE MEETING INFORMATION IN PRESENCE,SELF-SERVICE USER ID,USER PROFILE,ASSIGNED PRESENCE SERVER,ENABLE END USER TO HOST CONFERENCE NOW, MEETING NUMBER, ATTENDEES ACCESS CODE
Test,,,OSS,TESTOSS,Active Local User,TESTOSS,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
However it was awhile since it was run, so not sure how it works, or even if it works, with the current version we're on.
Which option are you using? Import/Export import option? I used your CSV file with the user import option, and it worked for me without any errors like "first name is not a supported field." on the CUCM. I had to remove the Access Control Group and Local, as they were not present on my CUCM.
Check if the delimiter character is still comma. For me in Sweden that's typically set to semi-colon, so I always have to use N++ to do a search and replace for ; to , when having worked on a CSV file in Excel.
