Skip to content

Export submissions csv

hypha.apply.funds.management.commands.export_submissions_csv

Command

Bases: BaseCommand

help class-attribute instance-attribute 

help = 'Export submission stats to a csv file.'

handle 

handle(*args, **options)
Source code in hypha/apply/funds/management/commands/export_submissions_csv.py 
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
def handle(self, *args, **options):
    with open("export_submissions.csv", "w", newline="") as csvfile:
        writer = csv.writer(csvfile, quoting=csv.QUOTE_ALL)
        writer.writerow(
            [
                "Submission ID",
                "Submission title",
                "Submission author",
                "Submission e-mail",
                "Submission value",
                "Submission duration",
                "Submission reapplied",
                "Submission stage",
                "Submission phase",
                "Submission screening",
                "Submission date",
                "Submission region",
                "Submission country",
                "Submission focus",
                "Round/Lab/Fellowship",
            ]
        )
        for submission in ApplicationSubmission.objects.exclude_draft():
            submission_region = ""
            submission_country = ""
            submission_focus = ""
            submission_reapplied = ""
            for field_id in submission.question_text_field_ids:
                if field_id not in submission.named_blocks:
                    question_field = submission.serialize(field_id)
                    name = question_field["question"]
                    if isinstance(question_field["answer"], str):
                        answer = question_field["answer"]
                    else:
                        answer = ",".join(question_field["answer"])
                    if answer and not answer == "N":
                        if name == "Region":
                            submission_region = answer
                        elif name == "Country":
                            submission_country = answer
                        elif name == "Focus":
                            submission_focus = answer
                        elif "or received funding" in name:
                            submission_reapplied = answer

            if submission.round:
                submission_type = submission.round
            else:
                submission_type = submission.page

            try:
                submission_value = submission.value
            except KeyError:
                submission_value = 0
            writer.writerow(
                [
                    submission.id,
                    submission.title,
                    submission.full_name,
                    submission.email,
                    submission_value,
                    submission.duration,
                    submission_reapplied,
                    submission.stage,
                    submission.phase,
                    submission.joined_screening_statuses,
                    submission.submit_time.strftime("%Y-%m-%d"),
                    submission_region,
                    submission_country,
                    submission_focus,
                    submission_type,
                ]
            )