o365_copy.py 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116
  1. from O365 import Account
  2. from O365.address_book import Contact, Recipients
  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.de',
  12. 'brandt@global-cube.de',
  13. # 'd.ankenbrand@global-cube.de',
  14. 'gawliczek@global-cube.de',
  15. 'm.geiss@global-cube.de',
  16. 'matarrelli@global-cube.de',
  17. 'winkler@global-cube.de',
  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. for mailbox in mailboxes:
  46. print(mailbox)
  47. personal = account.address_book(resource=mailbox, address_book='personal')
  48. personal_contacts = {p.display_name: p for p in personal.get_contacts(limit=None)}
  49. extra_contacts = set(personal_contacts.keys()).difference(shared_contacts.keys())
  50. print(extra_contacts)
  51. # p.delete()
  52. for p_shared in shared_contacts.values():
  53. if p_shared.display_name not in personal_contacts:
  54. p_new = personal.new_contact()
  55. copy_contact(p_shared, p_new)
  56. else:
  57. p_existing = personal_contacts[p_shared.display_name]
  58. if p_existing.to_api_data() != p_shared.to_api_data():
  59. copy_contact(p_shared, p_existing)
  60. def delete_contacts(delete_candidates):
  61. account.authenticate()
  62. for mailbox in mailboxes:
  63. print(mailbox)
  64. personal = account.address_book(resource=mailbox, address_book='personal')
  65. personal_contacts = {p.display_name: p for p in personal.get_contacts(limit=None)}
  66. selected_contacts = set(delete_candidates).intersection(personal_contacts.keys())
  67. print(selected_contacts)
  68. for c in selected_contacts:
  69. personal_contacts[c].delete()
  70. def normalize_phone_number(phone_number: str):
  71. if phone_number is None:
  72. return None
  73. if phone_number.startswith('0'):
  74. phone_number = '+49 ' + phone_number[1:]
  75. for c in '()/?':
  76. phone_number = phone_number.replace(c, '')
  77. return phone_number.replace(' -', '-').replace('- ', '-').replace(' ', ' ')
  78. def cleanup_contacts():
  79. account.authenticate()
  80. shared = account.address_book(resource='adressbuch@global-cube.net', address_book='personal')
  81. for p in shared.get_contacts(limit=None):
  82. business = [normalize_phone_number(no) for no in p.business_phones]
  83. if p.business_phones != business:
  84. p.business_phones = business
  85. home = [normalize_phone_number(no) for no in p.home_phones]
  86. if p.home_phones != home:
  87. p.home_phones = home
  88. mobile = normalize_phone_number(p.mobile_phone)
  89. if p.mobile_phone != mobile:
  90. p.mobile_phone = mobile
  91. p.save()
  92. if __name__ == '__main__':
  93. sync_contacts()
  94. # delete_contacts({'Matios Yigit', 'Martin Petz', 'Herr Steinraths', 'Herr Fischer'})
  95. # cleanup_contacts()