Feature request: enable better export of foreign Registrant details for provision to Border Force

[KathyReid]

User story

As the Speaker Liaison, I am in contact with Border Force - Department of Immigration. The proforma provided by the Department to ensure they're aware of foreign delegates to conferences requests the following format;
nsmail.xlsx
I would like ZooKeepr to provide an export in this format to make it easy to provide this information to Border Force, therefore saving hours of manual handling, and facilitating the provision of Visas.

Acceptance criteria

The following information is not held in ZooKeepr currently, yet is sought;

• Country of passport
• Passport number
• Name on passport
• Date of birth
• First and middle names
• Gender

This information is already held;

• Country of residence
• Invited by event organiser (can be inferred from role)
• Registration fees paid

Moreover, fulfilling these requirements is likely to require discussion on what biodata is collected as mandatory for registration.

The controller in admin.py provides the following report;

  @authorize(h.auth.has_organiser_role)
    def rego_foreign(self):
        people = [ r.person for r in Registration.find_all() ]
        c.columns = ['Name', 'Country']
        c.data = []
        for person in people:
            if person.country != 'AUSTRALIA' and person.paid():
                row = [ "%s %s" % (person.firstname, person.lastname), person.country ]
                c.data.append(row)
        return table_response()

but exporting this as a table currently fails.