o365_copy.py 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123
  1. from O365 import Account
  2. from O365.address_book import Contact
  3. client_id = '925f74dc-f96a-4718-9ca7-d6cc3fa43e1e'
  4. client_secret = 'SS~8Q~QpBZV9toZuwkzW1XGGen2Hn833spNMtdq5'
  5. account = Account(
  6. (client_id, client_secret),
  7. auth_flow_type='credentials',
  8. tenant_id='2ad0dff5-07ce-4cc2-a852-99ce8b91c218'
  9. )
  10. mailboxes = [
  11. 'bedner@global-cube.net',
  12. 'brandt@global-cube.net',
  13. # 'd.ankenbrand@global-cube.de',
  14. # 'gawliczek@global-cube.de',
  15. 'm.geiss@global-cube.net',
  16. 'matarrelli@global-cube.net',
  17. 'winkler@global-cube.net',
  18. 'winter@global-cube.de'
  19. ]
  20. def copy_contact(p_from: Contact, p_to: Contact):
  21. p_to.display_name = p_from.display_name
  22. p_to.name = p_from.name
  23. p_to.surname = p_from.surname
  24. p_to.title = p_from.title
  25. p_to.job_title = p_from.job_title
  26. p_to.company_name = p_from.company_name
  27. p_to.department = p_from.department
  28. p_to.office_location = p_from.office_location
  29. p_to.business_phones = p_from.business_phones
  30. p_to.mobile_phone = p_from.mobile_phone
  31. p_to.home_phones = p_from.home_phones
  32. p_to.emails.clear()
  33. for rcp in p_from.emails:
  34. p_to.emails.add(rcp)
  35. p_to.business_address = p_from.business_address
  36. # p_to.home_address = p_from.home_address
  37. p_to.other_address = p_from.other_address
  38. p_to.categories = p_from.categories
  39. p_to.personal_notes = p_from.personal_notes
  40. p_to.save()
  41. def sync_contacts():
  42. account.authenticate()
  43. shared = account.address_book(resource='adressbuch@global-cube.net', address_book='personal')
  44. shared_contacts = {p.display_name: p for p in shared.get_contacts(limit=None)}
  45. delete_candidates = set()
  46. for mailbox in mailboxes:
  47. print(mailbox)
  48. personal = account.address_book(resource=mailbox, address_book='personal')
  49. personal_contacts = {p.display_name: p for p in personal.get_contacts(limit=None)}
  50. extra_contacts = set(personal_contacts.keys()).difference(shared_contacts.keys())
  51. print(extra_contacts)
  52. if len(delete_candidates) == 0:
  53. delete_candidates = extra_contacts
  54. else:
  55. delete_candidates = delete_candidates.intersection(extra_contacts)
  56. # p.delete()
  57. for p_shared in shared_contacts.values():
  58. if p_shared.display_name not in personal_contacts:
  59. p_new = personal.new_contact()
  60. copy_contact(p_shared, p_new)
  61. else:
  62. p_existing = personal_contacts[p_shared.display_name]
  63. if p_existing.to_api_data() != p_shared.to_api_data():
  64. copy_contact(p_shared, p_existing)
  65. return delete_candidates
  66. def delete_contacts(delete_candidates):
  67. account.authenticate()
  68. for mailbox in mailboxes:
  69. print(mailbox)
  70. personal = account.address_book(resource=mailbox, address_book='personal')
  71. personal_contacts = {p.display_name: p for p in personal.get_contacts(limit=None)}
  72. selected_contacts = set(delete_candidates).intersection(personal_contacts.keys())
  73. print(selected_contacts)
  74. for c in selected_contacts:
  75. personal_contacts[c].delete()
  76. def normalize_phone_number(phone_number: str):
  77. if phone_number is None:
  78. return None
  79. if phone_number.startswith('0'):
  80. phone_number = '+49 ' + phone_number[1:]
  81. for c in '()/?':
  82. phone_number = phone_number.replace(c, '')
  83. return phone_number.replace(' -', '-').replace('- ', '-').replace(' ', ' ')
  84. def cleanup_contacts():
  85. account.authenticate()
  86. shared = account.address_book(resource='adressbuch@global-cube.net', address_book='personal')
  87. for p in shared.get_contacts(limit=None):
  88. business = [normalize_phone_number(no) for no in p.business_phones]
  89. if p.business_phones != business:
  90. p.business_phones = business
  91. home = [normalize_phone_number(no) for no in p.home_phones]
  92. if p.home_phones != home:
  93. p.home_phones = home
  94. mobile = normalize_phone_number(p.mobile_phone)
  95. if p.mobile_phone != mobile:
  96. p.mobile_phone = mobile
  97. p.save()
  98. if __name__ == '__main__':
  99. contacts = sync_contacts()
  100. if len(contacts) > 0:
  101. delete_contacts(contacts)
  102. # cleanup_contacts()