{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Users","User-Declaration","Positions","Position-Declaration","Users Custom-OU","User Custom-OU Declaration","OrgUnits Custom","OrgUnit-Custom-Declaration","FAQ"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":12,"comments":7,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Users","index":0,"n_rows":5,"n_cols":42,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Action","Active","Global Role","Local Role 1","Local Role 2","Local Role 3","Local Role 4","Category\n(Ref-ID)","External Account","Login","Password","Language","Salutation","Firstname","Lastname","Title","Birthday","Email","Institution","Department","Street","City","Postal Code","Country (ISO)","Country (plain text)","Phone Home","Phone Office","Phone Mobile","Fax","Hobby","Comment","Matriculation","UDF: Field name 1","UDF: Field name 2","UDF: Field name 3","UDF: Field name 4","UDF: Field name 5","Unlimited Access","Limited Access (From)","Limited Access (Until)","Skin-ID","AuthMode"]
["Ignore","no","Administrator",null,"il_crs_member_456",null,null,null,null,{"$f":"toLogin(shortFirstname(N2)&\".\"&shortLastname(O2))","v":"homer.simpson"},{"$f":"IF(A2=\"Insert\",password(8,3,2),\"\")","v":""},"en","m","Homer J.","Simpson",null,"12.05.1956","h.simpson@springfield.com","Firma1","Quality Management","742 Evergreen Terrace","Springfield","90701","DE","United States of Simpsons",null,null,null,null,null,null,null,"UDF111","UDF211","UDF311","UDF411","UDF511","yes","2014-02-20","2017-12-31","delos","default"]
["Insert","yes","User","il_crs_admin_1234",null,null,null,1234,null,{"$f":"toLogin(shortFirstname(N3)&\".\"&shortLastname(O3))","v":"charles.burns"},{"$f":"IF(A3=\"Insert\",password(8,3,2),\"\")","v":"hTJ7!$77"},"en","m","Charles Montgomery","Burns","Dr.","09/15/1886","c.burns@springfield.com","Firma2","Executive",null,null,"90701","DE","United States of Simpsons",null,null,null,null,null,null,null,"UDF111","UDF211","UDF311","UDF411","UDF511",null,null,null,"customskin","oidc"]
["Delete","yes","Detach: Guest",null,null,null,null,5678,null,{"$f":"toLogin(shortFirstname(N4)&\".\"&shortLastname(O4))","v":"bart.simpson"},{"$f":"IF(A4=\"Insert\",password(8,3,2),\"\")","v":""},"en","m","Bart","Simpson",null,null,"b.simpson@springfield.com","Firma3","Creative Department","742 Evergreen Terrace","Springfield","90701","DE","United States of Simpsons",null,null,null,null,null,null,null,"UDF111","UDF211","UDF311","UDF411","UDF511"]
["Update","yes","User",null,null,null,null,null,null,{"$f":"toLogin(shortFirstname(N5)&\".\"&shortLastname(O5))","v":"lisa.simpson"},null,null,"n","Lisa","Simpson",null,null,"l.simpson@springfield.com","Firma4","R&D","742 Evergreen Terrace","Springfield","90701","DE","United States of Simpsons",null,null,null,null,null,null,null,"UDF111","UDF211","UDF311","UDF411","UDF511"]

{"sheet":"User-Declaration","index":1,"n_rows":236,"n_cols":16,"rows_kept":236,"cut":false,"hidden":false,"merged":[]}
["Excel","XML","Mandatory field",null,"Language Selection",null,"Country Selection (short)","Country Selection (full name)",null,"AuthMode",null,"Export Settings ","Export Settings Values",null,"Character to replace in toLogin","Character to replace with"]
[{"$f":"Users!A1","v":"Action"},"Action","yes",null,"none",null,"AD","Andorra",null,"default",null,"Add time to filename. E.g. yyyy-mm-dd_hh-mm_UserImport.xml","yes",null,"ä","ae"]
[{"$f":"Users!B1","v":"Active"},"Active","yes",null,"aa",null,"AE","United Arab Emirates",null,"cas",null,null,null,null,"ö","oe"]
[{"$f":"Users!C1","v":"Global Role"},"Global Role","yes",null,"ab",null,"AF","Afghanistan",null,"ecs",null,null,null,null,"ü","ue"]
[{"$f":"Users!D1","v":"Local Role 1"},"Local Role","yes",null,"af",null,"AG","Antigua And Barbuda",null,"ldap",null,null,null,null,"ß","ss"]
[{"$f":"Users!E1","v":"Local Role 2"},"Local Role","no",null,"am",null,"AI","Anguilla",null,"local"]
[{"$f":"Users!F1","v":"Local Role 3"},"Local Role","no",null,"ar",null,"AL","Albania",null,"oidc"]
[{"$f":"Users!G1","v":"Local Role 4"},"Local Role","no",null,"as",null,"AM","Armenia",null,"radius"]
[{"$f":"Users!H1","v":"Category\n(Ref-ID)"},"TimeLimitOwner","no",null,"ay",null,"AN","Netherlands Antilles",null,"saml"]
[{"$f":"Users!I1","v":"External Account"},"ExternalAccount","no",null,"az",null,"AO","Angola",null,"script"]
[{"$f":"Users!J1","v":"Login"},"Login","yes",null,"ba",null,"AQ","Antarctica",null,"shibboleth"]
[{"$f":"Users!K1","v":"Password"},"password","no",null,"be",null,"AR","Argentina",null,"soap"]
[{"$f":"Users!L1","v":"Language"},"Language","no",null,"bg",null,"AS","American Samoa"]
[{"$f":"Users!M1","v":"Salutation"},"Gender","no",null,"bh",null,"AT","Austria"]
[{"$f":"Users!N1","v":"Firstname"},"Firstname","no",null,"bi",null,"AU","Australia"]
[{"$f":"Users!O1","v":"Lastname"},"Lastname","no",null,"bn",null,"AW","Aruba"]
[{"$f":"Users!P1","v":"Title"},"Title","no",null,"bo",null,"AZ","Azerbaijan"]
[{"$f":"Users!Q1","v":"Birthday"},"Birthday","no",null,"br",null,"BA","Bosnia And Herzegowina"]
[{"$f":"Users!R1","v":"Email"},"Email","no",null,"ca",null,"BB","Barbados"]
[{"$f":"Users!S1","v":"Institution"},"Institution","no",null,"co",null,"BD","Bangladesh"]
[{"$f":"Users!T1","v":"Department"},"Department","no",null,"cs",null,"BE","Belgium"]
[{"$f":"Users!U1","v":"Street"},"Street","no",null,"cy",null,"BF","Burkina Faso"]
[{"$f":"Users!V1","v":"City"},"City","no",null,"da",null,"BG","Bulgaria"]
[{"$f":"Users!W1","v":"Postal Code"},"PostalCode","no",null,"de",null,"BH","Bahrain"]
[{"$f":"Users!X1","v":"Country (ISO)"},"SelCountry","no",null,"dz",null,"BI","Burundi"]
[{"$f":"Users!Y1","v":"Country (plain text)"},"Country","no",null,"el",null,"BJ","Benin"]
[{"$f":"Users!Z1","v":"Phone Home"},"PhoneHome","no",null,"en",null,"BM","Bermuda"]
[{"$f":"Users!AA1","v":"Phone Office"},"PhoneOffice","no",null,"eo",null,"BN","Brunei Darussalam"]
[{"$f":"Users!AB1","v":"Phone Mobile"},"PhoneMobile","no",null,"es",null,"BO","Bolivia"]
[{"$f":"Users!AC1","v":"Fax"},"Fax","no",null,"et",null,"BR","Brazil"]
[{"$f":"Users!AD1","v":"Hobby"},"Hobby","no",null,"eu",null,"BS","Bahamas"]
[{"$f":"Users!AE1","v":"Comment"},"Comment","no",null,"fa",null,"BT","Bhutan"]
[{"$f":"Users!AF1","v":"Matriculation"},"Matriculation","no",null,"fi",null,"BV","Bouvet Island"]
[{"$f":"Users!AG1","v":"UDF: Field name 1"},"UserDefinedField Id=\"_1\" Name=\"custom field title 1\"","no",null,"fj",null,"BW","Botswana"]
[{"$f":"Users!AH1","v":"UDF: Field name 2"},"UserDefinedField Id=\"_2\" Name=\"custom field title 2\"","no",null,"fo",null,"BY","Belarus"]
[{"$f":"Users!AI1","v":"UDF: Field name 3"},"UserDefinedField Id=\"_3\" Name=\"custom field title 3\"","no",null,"fr",null,"BZ","Belize"]
[{"$f":"Users!AJ1","v":"UDF: Field name 4"},"UserDefinedField Id=\"_4\" Name=\"custom field title 4\"","no",null,"fy",null,"CA","Canada"]
[{"$f":"Users!AK1","v":"UDF: Field name 5"},"UserDefinedField Id=\"_5\" Name=\"custom field title 5\"","no",null,"ga",null,"CC","Cocos (Keeling) Islands"]
[{"$f":"Users!AL1","v":"Unlimited Access"},"TimeLimitUnlimited","no",null,"gd",null,"CF","Central African Republic"]
[{"$f":"Users!AM1","v":"Limited Access (From)"},"TimeLimitFrom","no",null,"gl",null,"CG","Congo"]
[{"$f":"Users!AN1","v":"Limited Access (Until)"},"TimeLimitUntil","no",null,"gn",null,"CH","Switzerland"]
[{"$f":"Users!AO1","v":"Skin-ID"},"SkinID","no",null,"gu",null,"CI","Ivory Coast"]
[{"$f":"Users!AP1","v":"AuthMode"},"AuthMode","no",null,"ha",null,"CK","Cook Islands"]
[null,null,null,null,"he",null,"CL","Chile"]
[null,null,null,null,"hi",null,"CM","Cameroon"]
[null,null,null,null,"hr",null,"CN","China"]
[null,null,null,null,"hu",null,"CO","Colombia"]
[null,null,null,null,"hy",null,"CR","Costa Rica"]
[null,null,null,null,"ia",null,"CU","Cuba"]
[null,null,null,null,"ie",null,"CV","Cape Verde"]
[null,null,null,null,"ik",null,"CX","Christmas Island"]
[null,null,null,null,"id",null,"CY","Cyprus"]
[null,null,null,null,"is",null,"CZ","Czech Republic"]
[null,null,null,null,"it",null,"DE","Germany"]
[null,null,null,null,"iu",null,"DJ","Djibouti"]
[null,null,null,null,"ja",null,"DK","Denmark"]
[null,null,null,null,"jv",null,"DM","Dominica"]
[null,null,null,null,"ka",null,"DO","Dominican Republic"]
[null,null,null,null,"kk",null,"DZ","Algeria"]
[null,null,null,null,"kl",null,"EC","Ecuador"]
[null,null,null,null,"km",null,"EE","Estonia"]
[null,null,null,null,"kn",null,"EG","Egypt"]
[null,null,null,null,"ko",null,"EH","Western Sahara"]
[null,null,null,null,"ks",null,"ER","Eritrea"]
[null,null,null,null,"ku",null,"ES","Spain"]
[null,null,null,null,"ky",null,"ET","Ethiopia"]
[null,null,null,null,"la",null,"FI","Finland"]
[null,null,null,null,"ln",null,"FJ","Fiji"]
[null,null,null,null,"lo",null,"FK","Falkland Islands"]
[null,null,null,null,"lt",null,"FM","Micronesia"]
[null,null,null,null,"lv",null,"FO","Faroe Islands"]
[null,null,null,null,"mg",null,"FR","France"]
[null,null,null,null,"mi",null,"FX","France"]
[null,null,null,null,"mk",null,"GA","Gabon"]
[null,null,null,null,"ml",null,"GB","United Kingdom"]
[null,null,null,null,"mn",null,"GD","Grenada"]
[null,null,null,null,"mo",null,"GE","Giorgia"]
[null,null,null,null,"mr",null,"GF","French Guiana"]
[null,null,null,null,"ms",null,"GH","Ghana"]
[null,null,null,null,"mt",null,"GI","Gibraltar"]
[null,null,null,null,"my",null,"GL","Greenland"]
[null,null,null,null,"na",null,"GM","Gambia"]
[null,null,null,null,"ne",null,"GN","Guinea"]
[null,null,null,null,"nl",null,"GP","Guadeloupe"]
[null,null,null,null,"no",null,"GQ","Equatorial Guinea"]
[null,null,null,null,"oc",null,"GR","Greece"]
[null,null,null,null,"om",null,"GS","South Georgia And The South Sandwich Islands"]
[null,null,null,null,"or",null,"GT","Guatemala"]
[null,null,null,null,"pa",null,"GU","Guam"]
[null,null,null,null,"pl",null,"GW","Guinea-Bissau"]
[null,null,null,null,"ps",null,"GY","Guyana"]
[null,null,null,null,"pt",null,"HM","Heard And Nc Donald Islands"]
[null,null,null,null,"qu",null,"HN","Honduras"]
[null,null,null,null,"rm",null,"HR","Croatia"]
[null,null,null,null,"rn",null,"HT","Haiti"]
[null,null,null,null,"ro",null,"HU","Hungary"]
[null,null,null,null,"ru",null,"ID","Indonesia"]
[null,null,null,null,"rw",null,"IE","Ireland"]
[null,null,null,null,"sa",null,"IL","Israel"]
[null,null,null,null,"sd",null,"IN","India"]
[null,null,null,null,"sg",null,"IO","British Indian Ocean Territory"]
[null,null,null,null,"sh",null,"IQ","Iraq"]
[null,null,null,null,"si",null,"IR","Iran"]
[null,null,null,null,"sk",null,"IS","Iceland"]
[null,null,null,null,"sl",null,"IT","Italy"]
[null,null,null,null,"sm",null,"JM","Jamaica"]
[null,null,null,null,"sn",null,"JO","Jordan"]
[null,null,null,null,"so",null,"JP","Japan"]
[null,null,null,null,"sq",null,"KE","Kenya"]
[null,null,null,null,"sr",null,"KG","Kyrgyzstan"]
[null,null,null,null,"ss",null,"KH","Cambodia"]
[null,null,null,null,"st",null,"KI","Kiribati"]
[null,null,null,null,"su",null,"KM","Comoros"]
[null,null,null,null,"sv",null,"KN","Saint Kitts And Nevis"]
[null,null,null,null,"sw",null,"KP","North Korea (People\\s Republic Of Korea)"]
[null,null,null,null,"ta",null,"KR","South Korea (Republic Of Korea)"]
[null,null,null,null,"te",null,"KW","Kuwait"]
[null,null,null,null,"tg",null,"KY","Cayman Islands"]
[null,null,null,null,"th",null,"KZ","Kazakhstan"]
[null,null,null,null,"ti",null,"LA","Lao People\\s Republic"]
[null,null,null,null,"tk",null,"LB","Lebanon"]
[null,null,null,null,"tl",null,"LC","Saint Lucia"]
[null,null,null,null,"tn",null,"LI","Liechtenstein"]
[null,null,null,null,"to",null,"LK","Sri Lanka"]
[null,null,null,null,"tr",null,"LR","Liberia"]
[null,null,null,null,"ts",null,"LS","Lesotho"]
[null,null,null,null,"tt",null,"LT","Lithuania"]
[null,null,null,null,"tw",null,"LU","Luxembourg"]
[null,null,null,null,"ug",null,"LV","Latvia"]
[null,null,null,null,"uk",null,"LY","Libyan Arab Jamahiriya"]
[null,null,null,null,"ur",null,"MA","Morocco"]
[null,null,null,null,"uz",null,"MC","Monaco"]
[null,null,null,null,"vi",null,"MD","Moldova"]
[null,null,null,null,"vo",null,"MG","Madagascar"]
[null,null,null,null,"wo",null,"MH","Marshall Islands"]
[null,null,null,null,"xh",null,"MK","Macedonia"]
[null,null,null,null,"yi",null,"ML","Mali"]
[null,null,null,null,"yo",null,"MM","Myanmar"]
[null,null,null,null,"za",null,"MN","Mongolia"]
[null,null,null,null,"zh",null,"MO","Macau"]
[null,null,null,null,"zu",null,"MP","Northern Mariana Islands"]
[null,null,null,null,null,null,"MQ","Martinique"]
[null,null,null,null,null,null,"MR","Mauritania"]
[null,null,null,null,null,null,"MS","Montserrat"]
[null,null,null,null,null,null,"MT","Malta"]
[null,null,null,null,null,null,"MU","Mauritius"]
[null,null,null,null,null,null,"MV","Maldives"]
[null,null,null,null,null,null,"MW","Malawi"]
[null,null,null,null,null,null,"MX","Mexico"]
[null,null,null,null,null,null,"MY","Malaysia"]
[null,null,null,null,null,null,"MZ","Mozambique"]
[null,null,null,null,null,null,"NA","Namibia"]
[null,null,null,null,null,null,"NC","New Caledonia"]
[null,null,null,null,null,null,"NE","Niger"]
[null,null,null,null,null,null,"NF","Norfolk Island"]
[null,null,null,null,null,null,"NG","Nigeria"]
[null,null,null,null,null,null,"NI","Nicaragua"]
[null,null,null,null,null,null,"NL","Netherlands"]
[null,null,null,null,null,null,"NO","Norway"]
[null,null,null,null,null,null,"NP","Nepal"]
[null,null,null,null,null,null,"NR","Nauru"]
[null,null,null,null,null,null,"NU","Niue"]
[null,null,null,null,null,null,"NZ","New Zealand"]
[null,null,null,null,null,null,"OM","Oman"]
[null,null,null,null,null,null,"PA","Panama"]
[null,null,null,null,null,null,"PE","Peru"]
[null,null,null,null,null,null,"PF","French Polynesia"]
[null,null,null,null,null,null,"PG","Papua New Guinea"]
[null,null,null,null,null,null,"PH","Philippines"]
[null,null,null,null,null,null,"PK","Pakistan"]
[null,null,null,null,null,null,"PL","Poland"]
[null,null,null,null,null,null,"PM","St. Pierre And Miquelon"]
[null,null,null,null,null,null,"PN","Pitcairn"]
[null,null,null,null,null,null,"PR","Puerto Rico"]
[null,null,null,null,null,null,"PT","Portugal"]
[null,null,null,null,null,null,"PW","Palau"]
[null,null,null,null,null,null,"PY","Paraguay"]
[null,null,null,null,null,null,"QA","Qatar"]
[null,null,null,null,null,null,"RE","Reunion"]
[null,null,null,null,null,null,"RO","Romania"]
[null,null,null,null,null,null,"RU","Russian Federation"]
[null,null,null,null,null,null,"RW","Rwanda"]
[null,null,null,null,null,null,"SA","Saudi Arabia"]
[null,null,null,null,null,null,"SB","Solomon Islands"]
[null,null,null,null,null,null,"SC","Seychelles"]
[null,null,null,null,null,null,"SD","Sudan"]
[null,null,null,null,null,null,"SE","Sweden"]
[null,null,null,null,null,null,"SG","Singapore"]
[null,null,null,null,null,null,"SH","St. Helena"]
[null,null,null,null,null,null,"SI","Slovenia"]
[null,null,null,null,null,null,"SJ","Svalbard And Jan Mayen Islands"]
[null,null,null,null,null,null,"SK","Slovakia"]
[null,null,null,null,null,null,"SL","Siearra Leone"]
[null,null,null,null,null,null,"SM","San Marino"]
[null,null,null,null,null,null,"SN","Senegal"]
[null,null,null,null,null,null,"SO","Somalia"]
[null,null,null,null,null,null,"SR","Suriname"]
[null,null,null,null,null,null,"ST","Sao Tome And Principe"]
[null,null,null,null,null,null,"SV","El Salvador"]
[null,null,null,null,null,null,"SY","Syrian Arab Republic"]
[null,null,null,null,null,null,"SZ","Swaziland"]
[null,null,null,null,null,null,"TC","Turks And Caicos Islands"]
[null,null,null,null,null,null,"TD","Chad"]
[null,null,null,null,null,null,"TF","French Southern Territories"]
[null,null,null,null,null,null,"TG","Togo"]
[null,null,null,null,null,null,"TH","Thailand"]
[null,null,null,null,null,null,"TJ","Tajikistan"]
[null,null,null,null,null,null,"TK","Tokelau"]
[null,null,null,null,null,null,"TM","Turkmenistan"]
[null,null,null,null,null,null,"TN","Tunisia"]
[null,null,null,null,null,null,"TO","Tonga"]
[null,null,null,null,null,null,"TR","Turkey"]
[null,null,null,null,null,null,"TT","Trinidad And Tobago"]
[null,null,null,null,null,null,"TV","Tuvalu"]
[null,null,null,null,null,null,"TW","Taiwan"]
[null,null,null,null,null,null,"TZ","Tanzania"]
[null,null,null,null,null,null,"UA","Ukraine"]
[null,null,null,null,null,null,"UG","Uganda"]
[null,null,null,null,null,null,"UM","U.S. Minor Outlying Islands"]
[null,null,null,null,null,null,"US","U.S.A"]
[null,null,null,null,null,null,"UY","Uruguay"]
[null,null,null,null,null,null,"UZ","Uzbekistan"]
[null,null,null,null,null,null,"VA","Vatican City State"]
[null,null,null,null,null,null,"VC","Saint Vincent And The Grenadines"]
[null,null,null,null,null,null,"VE","Venezuela"]
[null,null,null,null,null,null,"VG","Virgin Islands (British)"]
[null,null,null,null,null,null,"VI","Virgin Islands (US)"]
[null,null,null,null,null,null,"VN","Viet Nam"]
[null,null,null,null,null,null,"VU","Vanuatu"]
[null,null,null,null,null,null,"WF","Wallis And Futuna Islands"]
[null,null,null,null,null,null,"WS","Samoa"]
[null,null,null,null,null,null,"YE","Yemen"]
[null,null,null,null,null,null,"YT","Mayotte"]
[null,null,null,null,null,null,"ZA","South Africa"]
[null,null,null,null,null,null,"ZM","Zambia"]
[null,null,null,null,null,null,"ZW","Zimbabwe"]

{"sheet":"Positions","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Action","User","OrgUnit","Role"]
["Add","homer.simpson","team_simpson","superior"]
["Add","homer.simpson","nuclear_power_plant","employee"]
["Add","charles.burns","nuclear_power_plant","superior"]
["Remove","bart.simpson","team_simpson","employee"]
["Ignore","lisa.simpson","team_simpson","employee"]

{"sheet":"Position-Declaration","index":3,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["User id_type",null,"OrgUnit id_type",null,"Role",null,"Export Settings ","Export Settings Values"]
["ilias_login",null,"external_id",null,"employee",null,"Add time to filename. \nE.g. yyyy-mm-dd_hh-mm_OrgPositionsImport.xml","yes"]
[null,null,null,null,"superior"]

{"sheet":"Users Custom-OU","index":4,"n_rows":6,"n_cols":48,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Action","Active","Global Role","Local Role","Local Role","Local Role","Local Role","Category\n(Ref-ID)","External Account","Login","Password","Language","Salutation","Firstname","Lastname","Title","Birthday","Email","Institution","Department","Street","City","Postal Code","Country (ISO)","Country (plain text)","Phone Home","Phone Office","Phone Mobile","Fax","Hobby","Comment","Matriculation","UDF: Field name 1","UDF: Field name 2","UDF: Field name 3","UDF: Field name 4","UDF: Field name 5","Unlimited Access","Limited Access (From)","Limited Access (Until)","Skin-ID","AuthMode","Org Unit (ImportID)","Org Role (ID)","Org Unit (ImportID)","Org Role (ID)","Org Unit (ID)","Org Role (ID)"]
["Ignore","no","Administrator","il_crs_member_123","il_crs_member_456","il_crs_member_789","il_crs_admin_1234",null,null,{"$f":"toLogin(shortFirstname(N2)&\".\"&shortLastname(O2))","v":"homer.simpson"},{"$f":"IF(A2=\"Insert\",password(8,3,2),\"\")","v":""},"en","m","Homer J.","Simpson",null,"12.05.1956","h.simpson@springfield.com","Firma1","Quality Management","742 Evergreen Terrace","Springfield","90701","DE","United States of Simpsons",null,null,null,null,null,null,null,"UDF111","UDF211","UDF311","UDF411","UDF511","yes","2014-02-20","2017-12-31","delos","default"]
["Delete","yes","User","il_crs_admin_1234",null,null,null,1234,null,{"$f":"toLogin(shortFirstname(N3)&\".\"&shortLastname(O3))","v":"charles.burns"},{"$f":"IF(A3=\"Insert\",password(8,3,2),\"\")","v":""},"en","m","Charles Montgomery","Burns","Dr.","09/15/1886","c.montgomery@springfield.com","Firma2","Executive",null,null,"90701","DE","United States of Simpsons",null,null,null,null,null,null,null,"UDF111","UDF211","UDF311","UDF411","UDF511",null,null,null,"customskin","oidc"]
["Insert","yes","Detach:Guest",null,null,null,null,5678,null,{"$f":"toLogin(shortFirstname(N4)&\".\"&shortLastname(O4))","v":"bart.simpson"},{"$f":"IF(A4=\"Insert\",password(8,3,2),\"\")","v":"XVO.-497"},"en","m","Bart","Simpson",null,null,"b.simpson@springfield.com","Firma3","Creative Department","742 Evergreen Terrace","Springfield","90701","DE","United States of Simpsons",null,null,null,null,null,null,null,"UDF111","UDF211","UDF311","UDF411","UDF511"]
["Update","yes","User",null,null,null,null,null,"lsimp87654",{"$f":"toLogin(shortFirstname(N5)&\".\"&shortLastname(O5))","v":"lisa.simpson"},null,null,"n","Lisa","Simpson",null,null,"l.simpson@springfield.com","Firma4","R&D","742 Evergreen Terrace","Springfield","90701","DE","United States of Simpsons",null,null,null,null,null,null,null,"UDF111","UDF211","UDF311","UDF411","UDF511",null,null,null,null,null,null,null,null,null,123,2]
["Update","yes","User",null,null,null,null,null,null,{"$f":"toLogin(shortFirstname(N6)&\".\"&shortLastname(O6))","v":"march.simpson"},null,"en","f","March","Simpson",null,null,"m.simpson@springfield.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"testid-1",1,"testid-2",1]

{"sheet":"User Custom-OU Declaration","index":5,"n_rows":236,"n_cols":16,"rows_kept":236,"cut":false,"hidden":true,"merged":[]}
["Excel","XML","Mandatory field",null,"Language Selection",null,"Country Selection (short)","Country Selection (full name)",null,"AuthMode",null,"Export Settings ","Export Settings Values",null,"Character to replace in toLogin","Character to replace with"]
[{"$f":"'Users Custom-OU'!A1","v":"Action"},"Action","yes",null,"none",null,"AD","Andorra",null,"default",null,"Add time to filename. E.g. yyyy-mm-dd_hh-mm_UserImport.xml","yes",null,"ä","ae"]
[{"$f":"'Users Custom-OU'!B1","v":"Active"},"Active","yes",null,"aa",null,"AE","United Arab Emirates",null,"cas",null,null,null,null,"ö","oe"]
[{"$f":"'Users Custom-OU'!C1","v":"Global Role"},"Global Role","yes",null,"ab",null,"AF","Afghanistan",null,"ecs",null,null,null,null,"ü","ue"]
[{"$f":"'Users Custom-OU'!D1","v":"Local Role"},"Local Role","no",null,"af",null,"AG","Antigua And Barbuda",null,"ldap",null,null,null,null,"ß","ss"]
[{"$f":"'Users Custom-OU'!E1","v":"Local Role"},"Local Role","no",null,"am",null,"AI","Anguilla",null,"local"]
[{"$f":"'Users Custom-OU'!F1","v":"Local Role"},"Local Role","no",null,"ar",null,"AL","Albania",null,"oidc"]
[{"$f":"'Users Custom-OU'!G1","v":"Local Role"},"Local Role","no",null,"as",null,"AM","Armenia",null,"radius"]
[{"$f":"'Users Custom-OU'!H1","v":"Category\n(Ref-ID)"},"TimeLimitOwner","no",null,"ay",null,"AN","Netherlands Antilles",null,"saml"]
[{"$f":"'Users Custom-OU'!I1","v":"External Account"},"ExternalAccount","no",null,"az",null,"AO","Angola",null,"script"]
[{"$f":"'Users Custom-OU'!J1","v":"Login"},"Login","yes",null,"ba",null,"AQ","Antarctica",null,"shibboleth"]
[{"$f":"'Users Custom-OU'!K1","v":"Password"},"password","no",null,"be",null,"AR","Argentina",null,"soap"]
[{"$f":"'Users Custom-OU'!L1","v":"Language"},"Language","no",null,"bg",null,"AS","American Samoa"]
[{"$f":"'Users Custom-OU'!M1","v":"Salutation"},"Gender","no",null,"bh",null,"AT","Austria"]
[{"$f":"'Users Custom-OU'!N1","v":"Firstname"},"Firstname","no",null,"bi",null,"AU","Australia"]
[{"$f":"'Users Custom-OU'!O1","v":"Lastname"},"Lastname","no",null,"bn",null,"AW","Aruba"]
[{"$f":"'Users Custom-OU'!P1","v":"Title"},"Title","no",null,"bo",null,"AZ","Azerbaijan"]
[{"$f":"'Users Custom-OU'!Q1","v":"Birthday"},"Birthday","no",null,"br",null,"BA","Bosnia And Herzegowina"]
[{"$f":"'Users Custom-OU'!R1","v":"Email"},"Email","yes",null,"ca",null,"BB","Barbados"]
[{"$f":"'Users Custom-OU'!S1","v":"Institution"},"Institution","no",null,"co",null,"BD","Bangladesh"]
[{"$f":"'Users Custom-OU'!T1","v":"Department"},"Department","no",null,"cs",null,"BE","Belgium"]
[{"$f":"'Users Custom-OU'!U1","v":"Street"},"Street","no",null,"cy",null,"BF","Burkina Faso"]
[{"$f":"'Users Custom-OU'!V1","v":"City"},"City","no",null,"da",null,"BG","Bulgaria"]
[{"$f":"'Users Custom-OU'!W1","v":"Postal Code"},"PostalCode","no",null,"de",null,"BH","Bahrain"]
[{"$f":"'Users Custom-OU'!X1","v":"Country (ISO)"},"SelCountry","no",null,"dz",null,"BI","Burundi"]
[{"$f":"'Users Custom-OU'!Y1","v":"Country (plain text)"},"Country","no",null,"el",null,"BJ","Benin"]
[{"$f":"'Users Custom-OU'!Z1","v":"Phone Home"},"PhoneHome","no",null,"en",null,"BM","Bermuda"]
[{"$f":"'Users Custom-OU'!AA1","v":"Phone Office"},"PhoneOffice","no",null,"eo",null,"BN","Brunei Darussalam"]
[{"$f":"'Users Custom-OU'!AB1","v":"Phone Mobile"},"PhoneMobile","no",null,"es",null,"BO","Bolivia"]
[{"$f":"'Users Custom-OU'!AC1","v":"Fax"},"Fax","no",null,"et",null,"BR","Brazil"]
[{"$f":"'Users Custom-OU'!AD1","v":"Hobby"},"Hobby","no",null,"eu",null,"BS","Bahamas"]
[{"$f":"'Users Custom-OU'!AE1","v":"Comment"},"Comment","no",null,"fa",null,"BT","Bhutan"]
[{"$f":"'Users Custom-OU'!AF1","v":"Matriculation"},"Matriculation","no",null,"fi",null,"BV","Bouvet Island"]
[{"$f":"'Users Custom-OU'!AG1","v":"UDF: Field name 1"},"UserDefinedField Id=\"_1\" Name=\"custom field title 1\"","no",null,"fj",null,"BW","Botswana"]
[{"$f":"'Users Custom-OU'!AH1","v":"UDF: Field name 2"},"UserDefinedField Id=\"_2\" Name=\"custom field title 2\"","no",null,"fo",null,"BY","Belarus"]
[{"$f":"'Users Custom-OU'!AI1","v":"UDF: Field name 3"},"UserDefinedField Id=\"_3\" Name=\"custom field title 3\"","no",null,"fr",null,"BZ","Belize"]
[{"$f":"'Users Custom-OU'!AJ1","v":"UDF: Field name 4"},"UserDefinedField Id=\"_4\" Name=\"custom field title 4\"","no",null,"fy",null,"CA","Canada"]
[{"$f":"'Users Custom-OU'!AK1","v":"UDF: Field name 5"},"UserDefinedField Id=\"_5\" Name=\"custom field title 5\"","no",null,"ga",null,"CC","Cocos (Keeling) Islands"]
[{"$f":"'Users Custom-OU'!AL1","v":"Unlimited Access"},"TimeLimitUnlimited","no",null,"gd",null,"CF","Central African Republic"]
[{"$f":"'Users Custom-OU'!AM1","v":"Limited Access (From)"},"TimeLimitFrom","no",null,"gl",null,"CG","Congo"]
[{"$f":"'Users Custom-OU'!AN1","v":"Limited Access (Until)"},"TimeLimitUntil","no",null,"gn",null,"CH","Switzerland"]
[{"$f":"'Users Custom-OU'!AO1","v":"Skin-ID"},"SkinID","no",null,"gu",null,"CI","Ivory Coast"]
[{"$f":"'Users Custom-OU'!AP1","v":"AuthMode"},"AuthMode","no",null,"ha",null,"CK","Cook Islands"]
[{"$f":"'Users Custom-OU'!AQ1","v":"Org Unit (ImportID)"},"OrgUnitImportId","no",null,"he",null,"CL","Chile"]
[{"$f":"'Users Custom-OU'!AR1","v":"Org Role (ID)"},"OrgRoleId","no",null,"hi",null,"CM","Cameroon"]
[{"$f":"'Users Custom-OU'!AS1","v":"Org Unit (ImportID)"},"OrgUnitImportId","no",null,"hr",null,"CN","China"]
[{"$f":"'Users Custom-OU'!AT1","v":"Org Role (ID)"},"OrgRoleId","no",null,"hu",null,"CO","Colombia"]
[{"$f":"'Users Custom-OU'!AU1","v":"Org Unit (ID)"},"OrgUnitId","no",null,"hy",null,"CR","Costa Rica"]
[{"$f":"'Users Custom-OU'!AV1","v":"Org Role (ID)"},"OrgRoleId","no",null,"ia",null,"CU","Cuba"]
[null,null,null,null,"ie",null,"CV","Cape Verde"]
[null,null,null,null,"ik",null,"CX","Christmas Island"]
[null,null,null,null,"id",null,"CY","Cyprus"]
[null,null,null,null,"is",null,"CZ","Czech Republic"]
[null,null,null,null,"it",null,"DE","Germany"]
[null,null,null,null,"iu",null,"DJ","Djibouti"]
[null,null,null,null,"ja",null,"DK","Denmark"]
[null,null,null,null,"jv",null,"DM","Dominica"]
[null,null,null,null,"ka",null,"DO","Dominican Republic"]
[null,null,null,null,"kk",null,"DZ","Algeria"]
[null,null,null,null,"kl",null,"EC","Ecuador"]
[null,null,null,null,"km",null,"EE","Estonia"]
[null,null,null,null,"kn",null,"EG","Egypt"]
[null,null,null,null,"ko",null,"EH","Western Sahara"]
[null,null,null,null,"ks",null,"ER","Eritrea"]
[null,null,null,null,"ku",null,"ES","Spain"]
[null,null,null,null,"ky",null,"ET","Ethiopia"]
[null,null,null,null,"la",null,"FI","Finland"]
[null,null,null,null,"ln",null,"FJ","Fiji"]
[null,null,null,null,"lo",null,"FK","Falkland Islands"]
[null,null,null,null,"lt",null,"FM","Micronesia"]
[null,null,null,null,"lv",null,"FO","Faroe Islands"]
[null,null,null,null,"mg",null,"FR","France"]
[null,null,null,null,"mi",null,"FX","France"]
[null,null,null,null,"mk",null,"GA","Gabon"]
[null,null,null,null,"ml",null,"GB","United Kingdom"]
[null,null,null,null,"mn",null,"GD","Grenada"]
[null,null,null,null,"mo",null,"GE","Giorgia"]
[null,null,null,null,"mr",null,"GF","French Guiana"]
[null,null,null,null,"ms",null,"GH","Ghana"]
[null,null,null,null,"mt",null,"GI","Gibraltar"]
[null,null,null,null,"my",null,"GL","Greenland"]
[null,null,null,null,"na",null,"GM","Gambia"]
[null,null,null,null,"ne",null,"GN","Guinea"]
[null,null,null,null,"nl",null,"GP","Guadeloupe"]
[null,null,null,null,"no",null,"GQ","Equatorial Guinea"]
[null,null,null,null,"oc",null,"GR","Greece"]
[null,null,null,null,"om",null,"GS","South Georgia And The South Sandwich Islands"]
[null,null,null,null,"or",null,"GT","Guatemala"]
[null,null,null,null,"pa",null,"GU","Guam"]
[null,null,null,null,"pl",null,"GW","Guinea-Bissau"]
[null,null,null,null,"ps",null,"GY","Guyana"]
[null,null,null,null,"pt",null,"HM","Heard And Nc Donald Islands"]
[null,null,null,null,"qu",null,"HN","Honduras"]
[null,null,null,null,"rm",null,"HR","Croatia"]
[null,null,null,null,"rn",null,"HT","Haiti"]
[null,null,null,null,"ro",null,"HU","Hungary"]
[null,null,null,null,"ru",null,"ID","Indonesia"]
[null,null,null,null,"rw",null,"IE","Ireland"]
[null,null,null,null,"sa",null,"IL","Israel"]
[null,null,null,null,"sd",null,"IN","India"]
[null,null,null,null,"sg",null,"IO","British Indian Ocean Territory"]
[null,null,null,null,"sh",null,"IQ","Iraq"]
[null,null,null,null,"si",null,"IR","Iran"]
[null,null,null,null,"sk",null,"IS","Iceland"]
[null,null,null,null,"sl",null,"IT","Italy"]
[null,null,null,null,"sm",null,"JM","Jamaica"]
[null,null,null,null,"sn",null,"JO","Jordan"]
[null,null,null,null,"so",null,"JP","Japan"]
[null,null,null,null,"sq",null,"KE","Kenya"]
[null,null,null,null,"sr",null,"KG","Kyrgyzstan"]
[null,null,null,null,"ss",null,"KH","Cambodia"]
[null,null,null,null,"st",null,"KI","Kiribati"]
[null,null,null,null,"su",null,"KM","Comoros"]
[null,null,null,null,"sv",null,"KN","Saint Kitts And Nevis"]
[null,null,null,null,"sw",null,"KP","North Korea (People\\s Republic Of Korea)"]
[null,null,null,null,"ta",null,"KR","South Korea (Republic Of Korea)"]
[null,null,null,null,"te",null,"KW","Kuwait"]
[null,null,null,null,"tg",null,"KY","Cayman Islands"]
[null,null,null,null,"th",null,"KZ","Kazakhstan"]
[null,null,null,null,"ti",null,"LA","Lao People\\s Republic"]
[null,null,null,null,"tk",null,"LB","Lebanon"]
[null,null,null,null,"tl",null,"LC","Saint Lucia"]
[null,null,null,null,"tn",null,"LI","Liechtenstein"]
[null,null,null,null,"to",null,"LK","Sri Lanka"]
[null,null,null,null,"tr",null,"LR","Liberia"]
[null,null,null,null,"ts",null,"LS","Lesotho"]
[null,null,null,null,"tt",null,"LT","Lithuania"]
[null,null,null,null,"tw",null,"LU","Luxembourg"]
[null,null,null,null,"ug",null,"LV","Latvia"]
[null,null,null,null,"uk",null,"LY","Libyan Arab Jamahiriya"]
[null,null,null,null,"ur",null,"MA","Morocco"]
[null,null,null,null,"uz",null,"MC","Monaco"]
[null,null,null,null,"vi",null,"MD","Moldova"]
[null,null,null,null,"vo",null,"MG","Madagascar"]
[null,null,null,null,"wo",null,"MH","Marshall Islands"]
[null,null,null,null,"xh",null,"MK","Macedonia"]
[null,null,null,null,"yi",null,"ML","Mali"]
[null,null,null,null,"yo",null,"MM","Myanmar"]
[null,null,null,null,"za",null,"MN","Mongolia"]
[null,null,null,null,"zh",null,"MO","Macau"]
[null,null,null,null,"zu",null,"MP","Northern Mariana Islands"]
[null,null,null,null,null,null,"MQ","Martinique"]
[null,null,null,null,null,null,"MR","Mauritania"]
[null,null,null,null,null,null,"MS","Montserrat"]
[null,null,null,null,null,null,"MT","Malta"]
[null,null,null,null,null,null,"MU","Mauritius"]
[null,null,null,null,null,null,"MV","Maldives"]
[null,null,null,null,null,null,"MW","Malawi"]
[null,null,null,null,null,null,"MX","Mexico"]
[null,null,null,null,null,null,"MY","Malaysia"]
[null,null,null,null,null,null,"MZ","Mozambique"]
[null,null,null,null,null,null,"NA","Namibia"]
[null,null,null,null,null,null,"NC","New Caledonia"]
[null,null,null,null,null,null,"NE","Niger"]
[null,null,null,null,null,null,"NF","Norfolk Island"]
[null,null,null,null,null,null,"NG","Nigeria"]
[null,null,null,null,null,null,"NI","Nicaragua"]
[null,null,null,null,null,null,"NL","Netherlands"]
[null,null,null,null,null,null,"NO","Norway"]
[null,null,null,null,null,null,"NP","Nepal"]
[null,null,null,null,null,null,"NR","Nauru"]
[null,null,null,null,null,null,"NU","Niue"]
[null,null,null,null,null,null,"NZ","New Zealand"]
[null,null,null,null,null,null,"OM","Oman"]
[null,null,null,null,null,null,"PA","Panama"]
[null,null,null,null,null,null,"PE","Peru"]
[null,null,null,null,null,null,"PF","French Polynesia"]
[null,null,null,null,null,null,"PG","Papua New Guinea"]
[null,null,null,null,null,null,"PH","Philippines"]
[null,null,null,null,null,null,"PK","Pakistan"]
[null,null,null,null,null,null,"PL","Poland"]
[null,null,null,null,null,null,"PM","St. Pierre And Miquelon"]
[null,null,null,null,null,null,"PN","Pitcairn"]
[null,null,null,null,null,null,"PR","Puerto Rico"]
[null,null,null,null,null,null,"PT","Portugal"]
[null,null,null,null,null,null,"PW","Palau"]
[null,null,null,null,null,null,"PY","Paraguay"]
[null,null,null,null,null,null,"QA","Qatar"]
[null,null,null,null,null,null,"RE","Reunion"]
[null,null,null,null,null,null,"RO","Romania"]
[null,null,null,null,null,null,"RU","Russian Federation"]
[null,null,null,null,null,null,"RW","Rwanda"]
[null,null,null,null,null,null,"SA","Saudi Arabia"]
[null,null,null,null,null,null,"SB","Solomon Islands"]
[null,null,null,null,null,null,"SC","Seychelles"]
[null,null,null,null,null,null,"SD","Sudan"]
[null,null,null,null,null,null,"SE","Sweden"]
[null,null,null,null,null,null,"SG","Singapore"]
[null,null,null,null,null,null,"SH","St. Helena"]
[null,null,null,null,null,null,"SI","Slovenia"]
[null,null,null,null,null,null,"SJ","Svalbard And Jan Mayen Islands"]
[null,null,null,null,null,null,"SK","Slovakia"]
[null,null,null,null,null,null,"SL","Siearra Leone"]
[null,null,null,null,null,null,"SM","San Marino"]
[null,null,null,null,null,null,"SN","Senegal"]
[null,null,null,null,null,null,"SO","Somalia"]
[null,null,null,null,null,null,"SR","Suriname"]
[null,null,null,null,null,null,"ST","Sao Tome And Principe"]
[null,null,null,null,null,null,"SV","El Salvador"]
[null,null,null,null,null,null,"SY","Syrian Arab Republic"]
[null,null,null,null,null,null,"SZ","Swaziland"]
[null,null,null,null,null,null,"TC","Turks And Caicos Islands"]
[null,null,null,null,null,null,"TD","Chad"]
[null,null,null,null,null,null,"TF","French Southern Territories"]
[null,null,null,null,null,null,"TG","Togo"]
[null,null,null,null,null,null,"TH","Thailand"]
[null,null,null,null,null,null,"TJ","Tajikistan"]
[null,null,null,null,null,null,"TK","Tokelau"]
[null,null,null,null,null,null,"TM","Turkmenistan"]
[null,null,null,null,null,null,"TN","Tunisia"]
[null,null,null,null,null,null,"TO","Tonga"]
[null,null,null,null,null,null,"TR","Turkey"]
[null,null,null,null,null,null,"TT","Trinidad And Tobago"]
[null,null,null,null,null,null,"TV","Tuvalu"]
[null,null,null,null,null,null,"TW","Taiwan"]
[null,null,null,null,null,null,"TZ","Tanzania"]
[null,null,null,null,null,null,"UA","Ukraine"]
[null,null,null,null,null,null,"UG","Uganda"]
[null,null,null,null,null,null,"UM","U.S. Minor Outlying Islands"]
[null,null,null,null,null,null,"US","U.S.A"]
[null,null,null,null,null,null,"UY","Uruguay"]
[null,null,null,null,null,null,"UZ","Uzbekistan"]
[null,null,null,null,null,null,"VA","Vatican City State"]
[null,null,null,null,null,null,"VC","Saint Vincent And The Grenadines"]
[null,null,null,null,null,null,"VE","Venezuela"]
[null,null,null,null,null,null,"VG","Virgin Islands (British)"]
[null,null,null,null,null,null,"VI","Virgin Islands (US)"]
[null,null,null,null,null,null,"VN","Viet Nam"]
[null,null,null,null,null,null,"VU","Vanuatu"]
[null,null,null,null,null,null,"WF","Wallis And Futuna Islands"]
[null,null,null,null,null,null,"WS","Samoa"]
[null,null,null,null,null,null,"YE","Yemen"]
[null,null,null,null,null,null,"YT","Mayotte"]
[null,null,null,null,null,null,"ZA","South Africa"]
[null,null,null,null,null,null,"ZM","Zambia"]
[null,null,null,null,null,null,"ZW","Zimbabwe"]

{"sheet":"OrgUnits Custom","index":6,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":true,"merged":[[0,6,0,10]]}
["Unit (ID)","Parent Unit (ID)","Title","Description","OrgType",null,"Custom Org-Structure Management"]
["testid-1","ilias","Qualitus GmbH","Description of Qualitus GmbH","Administration"]
["testid-2","testid-1","Bereich: Vertrieb und Marketing","Description of Bereich: Vertrieb und Marketing","Bereich"]
["testid-3","testid-1","Bereich: Beratung","Description of Bereich: Beratung","Bereich"]
["testid-4","testid-3","Abteilung: Support","Description of Abteilung: Support","Abteilung"]
["testid-5","testid-1","Bereich: Software-Entwicklung","Description of Bereich: Software-Entwicklung","Bereich"]
["testid-6","testid-1","Bereich: Content","Description of Bereich: Content","Bereich"]
["testid-7","testid-1","Bereich: Verwaltung","Description of Bereich: Verwaltung","Bereich"]

{"sheet":"OrgUnit-Custom-Declaration","index":7,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Excel","XML","Mandatory field",null,"Export Settings ","Export Settings Values"]
[{"$f":"'OrgUnits Custom'!A1","v":"Unit (ID)"},"ou_id","yes",null,"Add time to filename. E.g. yyyy-mm-dd_hh-mm_UserImport.xml","yes"]
[{"$f":"'OrgUnits Custom'!B1","v":"Parent Unit (ID)"},"ou_parent_id","yes"]
[{"$f":"'OrgUnits Custom'!C1","v":"Title"},"ou_title","yes"]
[{"$f":"'OrgUnits Custom'!D1","v":"Description"},"ou_description","no"]
[{"$f":"'OrgUnits Custom'!E1","v":"OrgType"},"ou_type","no"]
[]
[]
[]
[]
[]
["Selection\nOrg-Typ"]
["Administration"]
["Geschäftsleitung"]
["Bereich"]
["Abteilung"]
["Team"]
["Sonstiges"]

{"sheet":"FAQ","index":8,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Keyword","Question","Answer","Example"]
["404 NOT FOUND","Question is missing?","Use Forum!","https://docu.ilias.de/go/frm/4691"]
["DELETE","Is there a way to delete values using import script? When cells are empty, the values are not changing.","Just use underscore \"_\" in cells you would like to delete. By design, some cells work differently. E.g. you may not \"delete\" roles, you need to deassign them. Check notes in titles of a row for further infos."]
["toLogin()","How do I use \"=toLogin()\" function?","Just write =toLogin(lastname) in \"Login\" row. Replace \"lastname\" with cell reference you want to use, to create a login."]
["toLogin()","What is this toLogin function for?","The function replaces some special characters, that ILIAS will not be accepting in \"login\" field, such as space and non-breaking space, apostrophe, underscore or some other characters from unicode. E.g. \"Œ\". Besides, all character are changed to lowercase.\n\nFurthermore, with User Import 5.0 you can add characters you would like to replace as well as the character you expect to be used. Check \"User-Declaration\" table."]
["toLogin()","How do I delete the characters, I'd like to get rid of?","Simply use the configuration in \"User-Declaration\". E.g. replace \"-\" with \"\" [nothing]."]
["toLogin()","So how do I create a login like \"l.simpson\"?","Check this example =>",{"$f":"toLogin(LEFT(\"Lisa\",1)&\".\"&\"Simpson\")","v":"l.simpson"}]
["shortFirstname()","What is the function shortFirstname for?","The function shortFirstname shortens the firstname of a person for use as a login.\nIf a firstname consists of multiple words, only the first word is taken. \"Lisa Marie\" => \"Lisa\"",{"$f":"toLogin(shortFirstname(\"Lisa Marie\")&\".\"&\"Simpson\")","v":"lisa.simpson"}]
["shortLastname()","What is the function shortLastname for?","The function shortLastname shortens the lastname of a person for use as a login.\nIf a lastname consists of multiple words, only the first word is taken,\nexcept, if the first word is a preposition (\"da\", \"di\", \"de\", \"del\", \"della\", \"la\", \"le\", \"van\", \"von\"), then the second word is taken as well.",{"$f":"toLogin(\"Lisa\"&\".\"&shortLastname(\"von Simpson\"))","v":"lisa.vonsimpson"}]
["password(x,y,z)","What is the function password(pwLength, nmbrDigits, nmbrCharacters) for?","The function password(pwLength, nmbrDigits, nmbrCharacters) creates random passwords using tree given parameters.\npwLength: full length of the password\nnmbrDigits: number of digits you would like in your password\nnmbrCharacters: number of special characters from a list of characters ILIAS is accepting in passwords.\n\nBe aware: password are created from scratch any time you open this file or update cells or tables. After all, they are meant to be used only once and only when inserting. Also you should use ILIAS option \"Change password on first login\", since you are creating and using third party password in plaintext! ",{"$f":"password(14,4,6)","v":"A-xzQ2$/-%-656"}]
["mandatory field","What does \"mandatory field\" configuration in \"User-Declaration\" table do?","This configuration is meant to be helpful, to prevent you from missing mandatory values. If configured properly, according to your ILIAS settings, it will check and notify you on missing mandatory values, when exporting XML. You may set everything to non-mandatory, if you wish. But then ILIAS will block your import, when some neccessary values are missing (such as \"login\")."]