o365_copy.py 4.2 KB

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