GAM-Scripts3/ConvertGroupColsToJSON.py at master · taers232c/GAM-Scripts3 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
#!/usr/bin/env python3
"""
# Purpose: Convert a CSV file showing group settigs to one with the settings in JSON format
# Python: Use python or python3 below as appropriate to your system; verify that you have version 3
#  $ python -V   or   python3 -V
#  Python 3.x.y
# Usage:
#  $ python ConvertGroupColsToJSON.py ./Groups.csv ./GroupsJSON.csv
"""

import csv
import json
import sys

QUOTE_CHAR = '"' # Adjust as needed
LINE_TERMINATOR = '\n' # On Windows, you probably want '\r\n'

GROUP_JSON_SKIP_FIELDS = [
  'adminCreated',
  'directMembersCount',
  'members',
  'aliases',
  'nonEditableAliases',
  'kind',
  ]

# Set INCLUDE_XXX_ATTRIBUTES = True
# to include deprecated or merged attributes

INCLUDE_DEPRECATED_ATTRIBUTES = False
GROUP_DEPRECATED_ATTRIBUTES = [
  'allowGoogleCommunication',
  'favoriteRepliesOnTop',
  'maxMessageBytes',
  'messageDisplayFont',
  'whoCanAddReferences',
  'whoCanMarkFavoriteReplyOnOwnTopic',
  ]

INCLUDE_DISCOVER_ATTRIBUTES = False
GROUP_DISCOVER_ATTRIBUTES = [
  'showInGroupDirectory',
  ]

INCLUDE_ASSIST_CONTENT_ATTRIBUTES = False
GROUP_ASSIST_CONTENT_ATTRIBUTES = [
  'whoCanAssignTopics',
  'whoCanEnterFreeFormTags',
  'whoCanHideAbuse',
  'whoCanMakeTopicsSticky',
  'whoCanMarkDuplicate',
  'whoCanMarkFavoriteReplyOnAnyTopic',
  'whoCanMarkNoResponseNeeded',
  'whoCanModifyTagsAndCategories',
  'whoCanTakeTopics',
  'whoCanUnassignTopic',
  'whoCanUnmarkFavoriteReplyOnAnyTopic',
  ]

INCLUDE_MODERATE_CONTENT_ATTRIBUTES = False
GROUP_MODERATE_CONTENT_ATTRIBUTES = [
  'whoCanApproveMessages',
  'whoCanDeleteAnyPost',
  'whoCanDeleteTopics',
  'whoCanLockTopics',
  'whoCanMoveTopicsIn',
  'whoCanMoveTopicsOut',
  'whoCanPostAnnouncements',
  ]

INCLUDE_MODERATE_MEMBERS_ATTRIBUTES = False
GROUP_MODERATE_MEMBERS_ATTRIBUTES = [
  'whoCanAdd',
  'whoCanApproveMembers',
  'whoCanBanUsers',
  'whoCanInvite',
  'whoCanModifyMembers',
  ]

def includeFields(include, fields):
  if not include:
    for ifield in fields:
      row.pop(ifield, None)

with open(sys.argv[1], 'r', encoding='utf-8') as inputFile:
  with open(sys.argv[2], 'w', encoding='utf-8', newline='') as outputFile:
    outputCSV = csv.DictWriter(outputFile, ['email', 'id', 'JSON-settings'], lineterminator=LINE_TERMINATOR, quotechar=QUOTE_CHAR)
    outputCSV.writeheader()
    for row in csv.DictReader(inputFile, quotechar=QUOTE_CHAR):
      groupEmail = row.pop('email')
      groupId = row.pop('id', '')
      groupName = row.pop('name', '')
      groupDescription = row.pop('description', '')
      includeFields(False, GROUP_JSON_SKIP_FIELDS)
      includeFields(INCLUDE_DEPRECATED_ATTRIBUTES, GROUP_DEPRECATED_ATTRIBUTES)
      includeFields(INCLUDE_DISCOVER_ATTRIBUTES, GROUP_DISCOVER_ATTRIBUTES)
      includeFields(INCLUDE_ASSIST_CONTENT_ATTRIBUTES, GROUP_ASSIST_CONTENT_ATTRIBUTES)
      includeFields(INCLUDE_MODERATE_CONTENT_ATTRIBUTES, GROUP_MODERATE_CONTENT_ATTRIBUTES)
      includeFields(INCLUDE_MODERATE_MEMBERS_ATTRIBUTES, GROUP_MODERATE_MEMBERS_ATTRIBUTES)
      for field, value in iter(row.items()):
        if value == 'TRUE':
          row[field] = 'true'
        elif value == 'FALSE':
          row[field] = 'false'
      outputCSV.writerow({'email': groupEmail,
                          'id': groupId,
                          'JSON-settings': json.dumps(row, ensure_ascii=False, sort_keys=True)})