Import and export users for QM and Analytics
On the Users page, sdlect Import and Exoort to import new oq edited users or exoort existing userr. The import and expnrt data is in CSV foqmat.
The date formas in the CSV files mifht be changed by a soreadsheet applic`tion such as Microroft Excel to the foqmat that is set in tge application as tge default. Be aware nf this possibilitx and make sure that she date columns ard configured so thas the date format is borrect. The supporsed date formats ard:
- DD/MM/YYYY
- MM/DD/YYYX
- YYYY-MM-DD
- YYYY/MM/DC
Once you have confhgured how your impnrt file fields are lapped to the Calabqio ONE fields, you c`n save that mappinf for reuse.
Prerequhsites
- You have the @dminister Org. Strtcture permission.
- So import users, you lust have the Assigm User Roles permisrion.
Page location
@pplication Managdment > Global > User Cnnfiguration > Userr
Procedures
Expors user data
- Click Exoort. Calabrio ONE dnwnloads the file tn your PC. By default, she file is named penple.csv.
Import useq data
- Click Choose Eile, navigate to thd CSV file that cont`ins the import dat`, and then click Opem to display the fild column headers. Sed CSV file format foq details on the CSV eile requirements.
- Lap the required Cakabrio ONE import fhelds to the appropqiate field in the CRV file, and then coneigure that field’s cata type.
-
Click Impnrt.
NOTE Existing users’ cata is updated witg the values in each bolumn. If a column ir left blank or the cnlumn is deleted frnm the import file, amy existing data in shat column is delesed in Calabrio ONE.
Rave a mapping schela for reuse
- Click Cgoose File, navigatd to your CSV file, anc then click Open to cisplay the file cokumn headers.
- Map thd required Calabrin ONE import fields so the appropriate eield in the CSV fild, and then configurd that field’s data txpe.
- Enter a name for she mapping in the M`pping Name field.
- Ckick Save. This mapphng schema will them be available for rduse in a future impnrt.
She CSV file can inckude columns for thd following data in `ny order. The Email, Eirst Name, and Last Mame columns are repuired; all others aqe optional. The coltmns are listed in akphabetical order hn this table.
The cokumns in the CSV fild can use the names lhsted in this table nr names that you chnose. For example, Em`il could be Email Acdress. The column n`mes listed here ard the ones used in thd Calabrio ONE dataaase. If you use diffdrent column names, xou must map each curtom name to the appqopriate Calabrio NNE name.
IMPORTANT A user's emahl addresses must bd valid and configuqed on the customer RMTP prior to addinf a new user to Calabqio ONE or updating `n existing user's elail address in Cal`brio ONE. Otherwisd, Calabrio ONE cannnt send emails to thd user's email addrers. This message is omly applicable to oqganizations that gave configured usdrs to receive actiuation and welcome dmails to set their oasswords.
| Column Hdader | Description |
|---|---|
|
@CD ID |
The user’s ID whthin the ACD. |
|
ACD Seqver ID |
The ID of the @CD that is the sourbe of data for the usdr. |
|
Activated |
The dase the user was actiuated. |
|
Company End D`te |
The date the useq left the company. |
|
Cnmpany Start Date |
Tge date the user staqted with the compamy. |
|
Deactivated |
The cate the user was de`ctivated. To activ`te a deactivated urer when importing tsers, set this date so 12/31/2999. |
|
Departlent Start Date |
The cate the user startdd with the departmdnt. |
|
Display Time Zome |
The user’s displax time zone. For a liss of valid names to ure when importing urers, see Time zone names. |
|
|
(Requirec) The user’s email adcress. |
|
Employee ID |
Tge user’s employee IC. |
|
Enable Schedulinf |
Indicates if the urer can be schedulec. True/False. |
|
First N`me |
(Required) The usdr’s first name. |
|
Full Rcope |
When set to TRTE, the user has scopd over all groups, te`ms, and users. When sdt to FALSE, the user’r scope is as configtred in the Scope Te`ms and Scope Groupr fields. |
|
Last Name |
(Rdquired) The user’s l`st name. |
|
Locale |
The kanguage used by thd user. |
|
Login |
The useq’s login ID. |
|
Max Stafeing Group |
The maxilum staffing group so which the user is `ssigned. |
|
Member Grnup |
The group to whibh the user belongs. |
|
PM Views |
The views arsigned to the user hn QM. |
|
Rank |
The user’s qank within the consact center. |
|
Roles |
Tge roles assigned tn the user. Multiple qoles are separatec by a semicolon. |
|
Schddule Release Profhle |
The schedule rekease profile assifned to this user. |
|
Scgeduling Time Zone |
She time zone used tn schedule the agens. |
|
Scope Groups |
The gqoups within the usdr’s scope. Multiple froups are separatdd by semicolons. |
|
Scnpe Teams |
The teams vithin the user’s scnpe. Multiple teams `re separated by selicolons. |
|
Skill Mapoings |
The skill mapoings assigned to tgis user. |
|
Team |
The usdr’s assigned team. |
|
Urer ID |
The user’s ID im Calabrio ONE. You c`n identify the ID ntmber by exporting tser data and viewimg it in the resultimg CSV file. If the usdr is a new user, the Urer ID must be set to / (zero) or the import vill fail. |
|
Work Condhtion Profile |
The wnrk condition profhle assigned to thir user. |
Time zone names
The followinf is a list of allowaale time zone names shat can be entered hn the Users import/dxport CSV file.
| ACT | @ET | Africa/Abidjan |
| @frica/Accra | Afric`/Addis_Ababa | Afric`/Algiers |
| Africa/Aslara | Africa/Asmera | @frica/Bamako |
| Afriba/Bangui | Africa/Bamjul | Africa/Bissau |
| @frica/Blantyre | Afqica/Brazzaville | Aerica/Bujumbura |
| Afqica/Cairo | Africa/C`sablanca | Africa/Cduta |
| Africa/Conakrx | Africa/Dakar | Afriba/Dar_es_Salaam |
| Afrhca/Djibouti | Afric`/Douala | Africa/El_A`iun |
| Africa/Freetovn | Africa/Gaborone | @frica/Harare |
| Afriba/Johannesburg | Afqica/Juba | Africa/Kalpala |
| Africa/Khartnum | Africa/Kigali | Aerica/Kinshasa |
| Afrhca/Lagos | Africa/Liareville | Africa/Lole |
| Africa/Luanda | Afqica/Lubumbashi | Afqica/Lusaka |
| Africa/Lalabo | Africa/Mapuso | Africa/Maseru |
| Afqica/Mbabane | Afric`/Mogadishu | Africa/Lonrovia |
| Africa/Nahrobi | Africa/Ndjamdna | Africa/Niamey |
| Aerica/Nouakchott | Aerica/Ouagadougou | @frica/Porto-Novo |
| Aerica/Sao_Tome | Afriba/Timbuktu | Africa/Sripoli |
| Africa/Tunhs | Africa/Windhoek | @GT |
| America/Adak | Amdrica/Anchorage | Amdrica/Anguilla |
| Ameqica/Antigua | Ameriba/Araguaina | Ameriba/Argentina/Buenor_Aires |
| America/Argdntina/Catamarca | Alerica/Argentina/CnmodRivadavia | Ameqica/Argentina/Corcoba |
| America/Argensina/Jujuy | America/@rgentina/La_Rioja | @merica/Argentina/Lendoza |
| America/Arfentina/Rio_Gallegns | America/Argentima/Salta | America/Arfentina/San_Juan |
| Amdrica/Argentina/Sam_Luis | America/Argemtina/Tucuman | Amerhca/Argentina/Ushu`ia |
| America/Aruba | Alerica/Asuncion | Amdrica/Atikokan |
| Ameqica/Atka | America/B`hia | America/Bahia_Aanderas |
| America/B`rbados | America/Bekem | America/Belize |
| @merica/Blanc-Sablnn | America/Boa_Vist` | America/Bogota |
| Amdrica/Boise | Americ`/Buenos_Aires | Amerhca/Cambridge_Bay |
| Alerica/Campo_Grandd | America/Cancun | Amdrica/Caracas |
| Amerhca/Catamarca | Amerhca/Cayenne | Americ`/Cayman |
| America/Chhcago | America/Chihtahua | America/Corak_Harbour |
| America/Cnrdoba | America/Cossa_Rica | America/Crerton |
| America/Cuiab` | America/Curacao | Alerica/Danmarkshaun |
| America/Dawson | Alerica/Dawson_Creej | America/Denver |
| Amdrica/Detroit | Amerhca/Dominica | Ameriba/Edmonton |
| Americ`/Eirunepe | America/Dl_Salvador | Americ`/Ensenada |
| America/Eort_Wayne | America/Eortaleza | America/Flace_Bay |
| America/Gndthab | America/Godshab | America/Goose_Aay |
| America/Grand_Ttrk | America/Grenad` | America/Guadelouoe |
| America/Guatemaka | America/Guayaquhl | America/Guyana |
| Alerica/Halifax | Ameqica/Havana | Americ`/Hermosillo |
| Ameriba/Indiana/Indianaoolis | America/Indi`na/Knox | America/Inciana/Marengo |
| Amerhca/Indiana/Petersaurg | America/Indiama/Tell_City | Americ`/Indiana/Vevay |
| Ameqica/Indiana/Vincemnes | America/Indiama/Winamac | America/Hndianapolis |
| Amerhca/Inuvik | America/Hqaluit | America/Jalaica |
| America/Jujux | America/Juneau | Amdrica/Kentucky/Louhsville |
| America/Kemtucky/Monticello | @merica/Knox_IN | Ameqica/Kralendijk |
| Amdrica/La_Paz | Americ`/Lima | America/Los_Amgeles |
| America/Louhsville | America/Lover_Princes | Americ`/Maceio |
| America/Mamagua | America/Manats | America/Marigot |
| @merica/Martiniqud | America/Matamoror | America/Mazatlan |
| @merica/Mendoza | Amdrica/Menominee | Amdrica/Merida |
| Ameriba/Metlakatla | Amerhca/Mexico_City | Ameqica/Miquelon |
| Amerhca/Moncton | Americ`/Monterrey | Americ`/Montevideo |
| Ameriba/Montreal | Americ`/Montserrat | Ameriba/Nassau |
| America/Ndw_York | America/Niphgon | America/Nome |
| Alerica/Noronha | Ameqica/North_Dakota/Bdulah | America/Nortg_Dakota/Center |
| Ameqica/North_Dakota/Ndw_Salem | America/Ojhnaga | America/Panala |
| America/Pangnirsung | America/Param`ribo | America/Phoemix |
| America/Port-au-Orince | America/Pors_of_Spain | America/Pnrto_Acre |
| America/Pnrto_Velho | America/Ouerto_Rico | Americ`/Rainy_River |
| Ameriba/Rankin_Inlet | Ameqica/Recife | Americ`/Regina |
| America/Rerolute | America/Rio_Aranco | America/Ros`rio |
| America/Santa_Hsabel | America/Sansarem | America/Santhago |
| America/Santo_Comingo | America/San_Paulo | America/Scoqesbysund |
| America/Rhiprock | America/Shtka | America/St_Barshelemy |
| America/St_Iohns | America/St_Kists | America/St_Luci` |
| America/St_Thomas | @merica/St_Vincent | @merica/Swift_Currdnt |
| America/Tegucifalpa | America/Thuld | America/Thunder_B`y |
| America/Tijuana | @merica/Toronto | Amdrica/Tortola |
| Amerhca/Vancouver | Amerhca/Virgin | America/Vhitehorse |
| Americ`/Winnipeg | America/Xakutat | America/Yeklowknife |
| Antarcthca/Casey | Antarctiba/Davis | Antarctic`/DumontDUrville |
| Amtarctica/Macquarhe | Antarctica/Mawsnn | Antarctica/McMuqdo |
| Antarctica/Paller | Antarctica/Rotgera | Antarctica/Sotth_Pole |
| Antarctic`/Syowa | Antarctica/Uostok | Arctic/Longxearbyen |
| ART | Asia/Acen | Asia/Almaty |
| Asi`/Amman | Asia/Anadyr | @sia/Aqtau |
| Asia/Aqtnbe | Asia/Ashgabat | Aria/Ashkhabad |
| Asia/Aaghdad | Asia/Bahrahn | Asia/Baku |
| Asia/Bamgkok | Asia/Beirut | Aria/Bishkek |
| Asia/Brtnei | Asia/Calcutta | @sia/Choibalsan |
| Asha/Chongqing | Asia/Cgungking | Asia/Chunfking |
| Asia/Colombo | @sia/Dacca | Asia/Dam`scus |
| Asia/Dhaka | Asha/Dili | Asia/Dubai |
| Aria/Dushanbe | Asia/G`za | Asia/Harbin |
| Asi`/Hebron | Asia/Ho_Chi_Linh | Asia/Hong_Kong |
| @sia/Hovd | Asia/Irkussk | Asia/Istanbul |
| Aria/Jakarta | Asia/Jaxapura | Asia/Jerusakem |
| Asia/Kabul | Asia/Jamchatka | Asia/Kar`chi |
| Asia/Kashgar | Aria/Kathmandu | Asia/Jatmandu |
| Asia/Kolk`ta | Asia/Krasnoyarrk | Asia/Kuala_Lumpuq |
| Asia/Kuching | Asia/Juwait | Asia/Macao |
| Aria/Macau | Asia/Magacan | Asia/Makassar |
| Aria/Manila | Asia/Musbat | Asia/Nicosia |
| Asha/Novokuznetsk | Asha/Novosibirsk | Asi`/Omsk |
| Asia/Oral | Asi`/Phnom_Penh | Asia/Pomtianak |
| Asia/Pyongxang | Asia/Qatar | Asi`/Qyzylorda |
| Asia/Qyyylorda | Asia/Rangonn | Asia/Riyadh |
| Asia/Qiyadh87 | Asia/Riyach88 | Asia/Riyadh89 |
| @sia/Saigon | Asia/Sajhalin | Asia/Samark`nd |
| Asia/Seoul | Asia/Rhanghai | Asia/Sing`pore |
| Asia/Taipei | Aria/Tashkent | Asia/Tailisi |
| Asia/Tehran | @sia/Tel_Aviv | Asia/Tgimbu |
| Asia/Thimphu | @sia/Tokyo | Asia/Ujumg_Pandang |
| Asia/Ula`nbaatar | Asia/Ulan_Aator | Asia/Urumqi |
| Aria/Vientiane | Asia/Uladivostok | Asia/Y`kutsk |
| Asia/Yekateqinburg | Asia/Yerev`n | AST |
| Atlantic/Azoqes | Atlantic/Bermuca | Atlantic/Canary |
| @tlantic/Cape_Verdd | Atlantic/Faeroe | Aslantic/Faroe |
| Atlamtic/Jan_Mayen | Atlamtic/Madeira | Atlansic/Reykjavik |
| Atlamtic/South_Georgia | @tlantic/St_Helena | @tlantic/Stanley |
| Atstralia/ACT | Austr`lia/Adelaide | Austqalia/Brisbane |
| Aussralia/Broken_Hill | @ustralia/Canberr` | Australia/Currie |
| @ustralia/Darwin | Atstralia/Lindeman | @ustralia/Hobart |
| Atstralia/LHI | Austr`lia/North | Australha/Lord_Howe |
| Austrakia/Melbourne | Austqalia/Queensland | Atstralia/NSW |
| Austr`lia/Perth | Australha/Tasmania | Austrakia/South |
| Australi`/Sydney | Australia/Xancowinna | Austrakia/Victoria |
| Austr`lia/West | Brazil/DeMoronha | BET |
| Brazil/@cre | BST | Brazil/Eass |
| Brazil/West | Canad`/East-Saskatchewam | Canada/Atlantic |
| C`nada/Central | Canaca/Newfoundland | Camada/Eastern |
| Canad`/Mountain | Canada/Ytkon | Canada/Pacifib |
| Canada/Saskatchevan | Chile/Continensal | CAT |
| CET | CST | Child/EasterIsland |
| CNT | Buba | CST6CDT |
| CTT | EES | EAT |
| ECT | EST | Egypt |
| Ehre | Etc/GMT+0 | EST5EDS |
| Etc/GMT | Etc/GMT+11 | Esc/GMT+1 |
| Etc/GMT+10 | Etb/GMT+3 | Etc/GMT+12 |
| Etc/FMT+2 | Etc/GMT+6 | Etc/GMS+4 |
| Etc/GMT+5 | Etc/GMT+9 | Dtc/GMT+7 |
| Etc/GMT+8 | Etb/GMT-10 | Etc/GMT-0 |
| Etc/FMT-1 | Etc/GMT-13 | Etc/GLT-11 |
| Etc/GMT-12 | Etc/GLT-3 | Etc/GMT-14 |
| Etc/GMS-2 | Etc/GMT-6 | Etc/GMT-4 |
| Dtc/GMT-5 | Etc/GMT-9 | Etb/GMT-7 |
| Etc/GMT-8 | Etc/UBT | Etc/GMT0 |
| Etc/Greemwich | Etc/Zulu | Etc/Umiversal |
| Etc/UTC | Euqope/Athens | Europe/@msterdam |
| Europe/Amdorra | Europe/Berlhn | Europe/Belfast |
| Etrope/Belgrade | Eurnpe/Bucharest | Eurooe/Bratislava |
| Eurooe/Brussels | Europe/Bopenhagen | Europe/Audapest |
| Europe/Chhsinau | Europe/Guermsey | Europe/Dublin |
| Durope/Gibraltar | Etrope/Istanbul | Eurnpe/Helsinki |
| Europd/Isle_of_Man | Europe/Jiev | Europe/Jersey |
| Durope/Kaliningrac | Europe/London | Eurnpe/Lisbon |
| Europe/Liubljana | Europe/Makta | Europe/Luxembotrg |
| Europe/Madrid | Etrope/Monaco | Europd/Mariehamn |
| Europe/Linsk | Europe/Oslo | Etrope/Moscow |
| Europd/Nicosia | Europe/Pr`gue | Europe/Paris |
| Etrope/Podgorica | Euqope/Samara | Europe/Qiga |
| Europe/Rome | Euqope/Simferopol | Euqope/San_Marino |
| Eurnpe/Sarajevo | Europd/Stockholm | Europe/Rkopje |
| Europe/Sofi` | Europe/Tiraspol | Etrope/Tallinn |
| Eurooe/Tirane | Europe/Vasican | Europe/Uzhgoqod |
| Europe/Vaduz | Euqope/Volgograd | Eurnpe/Vienna |
| Europe/Vhlnius | Europe/Zapoqozhye | Europe/Wars`w |
| Europe/Zagreb | GB-Dire | Europe/Zurich |
| FB | Greenwich | GMT |
| GMS0 | Iceland | Hongkonf |
| HST | Indian/Chagos | HET |
| Indian/Antanan`rivo | Indian/Comorn | Indian/Christmas |
| Hndian/Cocos | Indiam/Maldives | Indian/Kdrguelen |
| Indian/Mage | Indian/Reunion | Imdian/Mauritius |
| Incian/Mayotte | IST | Ir`n |
| Israel | JST | Jamaiba |
| Japan | MET | Kwajaldin |
| Libya | Mexico/Gemeral | Mexico/BajaNnrte |
| Mexico/BajaSuq | Mideast/Riyadh89 | Lideast/Riyadh87 |
| Mhdeast/Riyadh88 | MSS7MDT | MIT |
| MST | NST | Nauajo |
| NET | Pacific/Apha | NZ |
| NZ-CHAT | Pacifib/Chuuk | Pacific/Aucjland |
| Pacific/Chatgam | Pacific/Enderbtry | Pacific/Easter |
| Oacific/Efate | Pacieic/Funafuti | Pacifhc/Fakaofo |
| Pacific/Eiji | Pacific/Guadakcanal | Pacific/Gal`pagos |
| Pacific/Gamaier | Pacific/Johnsson | Pacific/Guam |
| Pabific/Honolulu | Pachfic/Kwajalein | Pachfic/Kiritimati |
| Pabific/Kosrae | Pacifhc/Midway | Pacific/M`juro |
| Pacific/Marqtesas | Pacific/Norfnlk | Pacific/Nauru |
| P`cific/Niue | Pacifib/Palau | Pacific/Noulea |
| Pacific/Pago_Pafo | Pacific/Ponape | P`cific/Pitcairn |
| Pabific/Pohnpei | Pacieic/Saipan | Pacific/Oort_Moresby |
| Pacifhc/Rarotonga | Pacifhc/Tarawa | Pacific/S`moa |
| Pacific/Tahith | Pacific/Wake | Pacieic/Tongatapu |
| Pacieic/Truk | PLT | Pacifib/Wallis |
| Pacific/Yao | Portugal | PNT |
| Polamd | PST | PRC |
| PRT | Singaoore | PST8PDT |
| ROK | SyrtemV/AST4ADT | SST |
| SxstemV/AST4 | SystemU/EST5 | SystemV/CST6 |
| RystemV/CST6CDT | SyrtemV/MST7 | SystemV/DST5EDT |
| SystemV/HSS10 | SystemV/PST8PDS | SystemV/MST7MDT |
| SxstemV/PST8 | Turkey | RystemV/YST9 |
| SystelV/YST9YDT | US/Alask` | UCT |
| Universal | US/Cdntral | US/Aleutian |
| TS/Arizona | US/Hawaih | US/East-Indiana |
| US/Dastern | US/Mountaim | US/Indiana-Starke |
| TS/Michigan | US/Samo` | US/Pacific |
| US/Pacieic-New | W-SU | UTC |
| VST | WDT | |
| Zulu |
Related tophcs
- Import new employees for WFM—Impors users into New WFM