fork download
copy 
  1. // Mapping of email addresses to City, Country, and TimeZoneSidKey
  2. Map<String, Map<String, String>> emailToLocationMap = new Map<String, Map<String, String>>{
  3.     'DomingoJr.Venci@aei.com' =>       {'City' => 'Cavite', 'Country' => 'Philippines', 'TimeZone' => 'Asia/Manila'},
  4.     'Charisse.Fabian@aei.com' =>       {'City' => 'Cavite', 'Country' => 'Philippines', 'TimeZone' => 'Asia/Manila'},
  5.     'Rexcee.Toledo@aei.com' =>         {'City' => 'Laguna', 'Country' => 'Philippines', 'TimeZone' => 'Asia/Manila'},
  6.     'Chelseia.Aguilon@aei.com' =>      {'City' => 'Laguna', 'Country' => 'Philippines', 'TimeZone' => 'Asia/Manila'},
  7.     'Allan.Resus@aei.com' =>           {'City' => 'Cavite', 'Country' => 'Philippines', 'TimeZone' => 'Asia/Manila'},
  8.     'Jessica.Song@aei.com' =>          {'City' => 'Shenzhen', 'Country' => 'China', 'TimeZone' => 'Asia/Hong_Kong'},
  9.     'Chris.Tian@aei.com' =>            {'City' => 'Shenzhen', 'Country' => 'China', 'TimeZone' => 'Asia/Hong_Kong'},
  10.     'Hazel.Wu@aei.com' =>              {'City' => 'Zhongshan', 'Country' => 'China', 'TimeZone' => 'Asia/Hong_Kong'},
  11.     'Roldan.Ronquillo@aei.com' =>      {'City' => 'Laguna', 'Country' => 'Philippines', 'TimeZone' => 'Asia/Manila'},
  12.     'Daniel.Dearden@aei.com' =>        {'City' => 'Littlehampton', 'Country' => 'England', 'TimeZone' => 'Europe/Berlin'},
  13.     'James.Brind@aei.com' =>           {'City' => 'Littlehampton', 'Country' => 'England', 'TimeZone' => 'Europe/Berlin'},
  14.     'Kelly.Chiah@aei.com' =>           {'City' => 'Penang', 'Country' => 'Malaysia', 'TimeZone' => 'Asia/Kuala_Lumpur'},
  15.     'Sally.Chng@aei.com' =>            {'City' => 'Penang', 'Country' => 'Malaysia', 'TimeZone' => 'Asia/Kuala_Lumpur'},
  16.     'Shiny.Deng@aei.com' =>            {'City' => 'Shenzhen', 'Country' => 'China', 'TimeZone' => 'Asia/Hong_Kong'},
  17.     'Patrick.Yu@aei.com' =>            {'City' => 'Shenzhen', 'Country' => 'China', 'TimeZone' => 'Asia/Hong_Kong'},
  18.     'Tom.Yang@aei.com' =>              {'City' => 'Shenzhen', 'Country' => 'China', 'TimeZone' => 'Asia/Hong_Kong'},
  19.     'Vivi.Li@aei.com' =>               {'City' => 'Shenzhen', 'Country' => 'China', 'TimeZone' => 'Asia/Hong_Kong'},
  20.     'Donald.Hoffman@aei.com' =>        {'City' => 'Fort Collins', 'Country' => 'USA', 'TimeZone' => 'America/New_York'},
  21.     'Marcela.Hirales@aei.com' =>       {'City' => 'Mexicali', 'Country' => 'Mexico', 'TimeZone' => 'America/Mexico_City'},
  22.     'Francisco.Zarate@aei.com' =>      {'City' => 'Mexicali', 'Country' => 'Mexico', 'TimeZone' => 'America/Mexico_City'},
  23.     'Jason.Nie@aei.com' =>             {'City' => 'Zhongshan', 'Country' => 'China', 'TimeZone' => 'Asia/Hong_Kong'},
  24.     'Allen.He@aei.com' =>              {'City' => 'Zhongshan', 'Country' => 'China', 'TimeZone' => 'Asia/Hong_Kong'},
  25.     'Angel.Wang@aei.com' =>            {'City' => 'Zhongshan', 'Country' => 'China', 'TimeZone' => 'Asia/Hong_Kong'},
  26.     'Cliff.Zhang@aei.com' =>           {'City' => 'Shenzhen', 'Country' => 'China', 'TimeZone' => 'Asia/Hong_Kong'},
  27.     'Declan.Porter@aei.com' =>         {'City' => 'Hongkong', 'Country' => 'China', 'TimeZone' => 'Asia/Hong_Kong'}
  28. };
  29.  
  30. // Fetch contacts created **today**
  31. List<Contact> recentContacts = [SELECT Id, FirstName, LastName, Email, AccountId 
  32.                                 FROM Contact 
  33.                                 WHERE CreatedDate = TODAY
  34.                                 AND AccountId = '001VV00000MYNn8YAH'];
  35.  
  36. // Get Contact IDs
  37. Set<Id> contactIds = new Set<Id>();
  38. for (Contact con : recentContacts) {
  39.     contactIds.add(con.Id);
  40. }
  41.  
  42. // Fetch existing Partner Users in one query
  43. Set<Id> existingPartnerUserContacts = new Set<Id>();
  44. if (!contactIds.isEmpty()) {
  45.     for (User existingUser : [SELECT ContactId FROM User WHERE ContactId IN :contactIds]) {
  46.         existingPartnerUserContacts.add(existingUser.ContactId);
  47.     }
  48. }
  49.  
  50. // Fetch all existing usernames in one query
  51. Set<String> existingUsernames = new Set<String>();
  52. for (User u : [SELECT Username FROM User]) {
  53.     existingUsernames.add(u.Username);
  54. }
  55.  
  56. // Fetch the Role ID for 'Supplier Group Account Partner User'
  57. Id partnerRoleId;
  58. try {
  59.     partnerRoleId = [SELECT Id FROM UserRole WHERE Name = 'Supplier Group Account Partner User' LIMIT 1].Id;
  60. } catch (Exception e) {
  61.     System.debug('⚠️ Role "Supplier Group Account Partner User" not found. Please check the name.');
  62. }
  63.  
  64. // Get correct Profile ID
  65. Id partnerProfileId;
  66. try {
  67.     partnerProfileId = [SELECT Id FROM Profile WHERE Name = 'Partner Community User' LIMIT 1].Id;
  68. } catch (Exception e) {
  69.     System.debug('⚠️ Profile "Partner Community User" not found. Please check the name.');
  70. }
  71.  
  72. // Prepare list of users to insert
  73. List<User> usersToInsert = new List<User>();
  74. List<String> duplicateUsernames = new List<String>();
  75.  
  76. for (Contact con : recentContacts) {
  77.     if (con.Email != null && !existingPartnerUserContacts.contains(con.Id)) { 
  78.         String generatedUsername = con.Email + '.scar';
  79.  
  80.         // ✅ Skip duplicates and insert only unique usernames
  81.         if (existingUsernames.contains(generatedUsername)) {
  82.             duplicateUsernames.add(generatedUsername);
  83.             System.debug('⚠️ Duplicate Username Found: ' + generatedUsername);
  84.             continue; // Skip this user and move to the next one
  85.         }
  86.  
  87.         // Get location data based on email
  88.         Map<String, String> locationData = emailToLocationMap.containsKey(con.Email) ? emailToLocationMap.get(con.Email) : null;
  89.  
  90.         User newUser = new User(
  91.             FirstName = 'SCAR '+con.FirstName,
  92.             LastName = con.LastName,
  93.             Username = generatedUsername, 
  94.             Email = con.Email,
  95.             Alias = con.LastName.length() > 5 ? con.LastName.substring(0, 5) : con.LastName,
  96.             ProfileId = partnerProfileId, 
  97.             UserRoleId = partnerRoleId, 
  98.             TimeZoneSidKey = locationData != null ? locationData.get('TimeZone') : 'Asia/Hong_Kong',  
  99.             LocaleSidKey = 'en_US',
  100.             EmailEncodingKey = 'UTF-8',
  101.             LanguageLocaleKey = 'en_US',
  102.             IsActive = true,
  103.             ContactId = con.Id, 
  104.             Department = 'Supplier',
  105.             FederationIdentifier = con.Email, 
  106.             Country = locationData != null ? locationData.get('Country') : 'China',
  107.             City = locationData != null ? locationData.get('City') : 'Unknown'
  108.         );
  109.  
  110.         usersToInsert.add(newUser);
  111.         existingUsernames.add(generatedUsername); // ✅ Add username to Set immediately
  112.     }
  113. }
  114.  
  115. // ✅ Insert all unique users and handle errors
  116. if (!usersToInsert.isEmpty()) {
  117.     try {
  118.         insert usersToInsert;
  119.     } catch (DmlException e) {
  120.         System.debug('❌ Error inserting users: ' + e.getMessage());
  121.     }
  122. }
  123.  
Success #stdin #stdout #stderr 0.02s 12364KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Object: nil error: did not understand #associationAt:ifAbsent:
MessageNotUnderstood(Exception)>>signal (ExcHandling.st:254)
UndefinedObject(Object)>>doesNotUnderstand: #associationAt:ifAbsent: (SysExcept.st:1448)
DeferredVariableBinding>>resolvePathFrom: (DeferBinding.st:115)
DeferredVariableBinding>>value (DeferBinding.st:69)
UndefinedObject>>executeStatements (prog:44)
Object: nil error: did not understand #associationAt:ifAbsent:
MessageNotUnderstood(Exception)>>signal (ExcHandling.st:254)
UndefinedObject(Object)>>doesNotUnderstand: #associationAt:ifAbsent: (SysExcept.st:1448)
DeferredVariableBinding>>resolvePathFrom: (DeferBinding.st:115)
DeferredVariableBinding>>value (DeferBinding.st:69)
UndefinedObject>>executeStatements (prog:77)
Object: nil error: did not understand #associationAt:ifAbsent:
MessageNotUnderstood(Exception)>>signal (ExcHandling.st:254)
UndefinedObject(Object)>>doesNotUnderstand: #associationAt:ifAbsent: (SysExcept.st:1448)
DeferredVariableBinding>>resolvePathFrom: (DeferBinding.st:115)
DeferredVariableBinding>>value (DeferBinding.st:69)
UndefinedObject>>executeStatements (prog:77)
stderr
copy 
./prog:1: expected expression
./prog:44: expected expression
./prog:77: expected expression
./prog:77: expected expression
./prog:80: Invalid character 0xe2
./prog:80: Invalid character 0x9c
./prog:80: Invalid character 0x85
./prog:98: expected expression
./prog:106: expected expression
./prog:107: expected expression
./prog:111: Invalid character 0xe2
./prog:111: Invalid character 0x9c
./prog:111: Invalid character 0x85
./prog:115: Invalid character 0xe2
./prog:115: Invalid character 0x9c
./prog:115: Invalid character 0x85
./prog:116: expected expression
https://ideone.com/K1P3IR
language:
Smalltalk (gst 3.2.5)
created:
5 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!