WPFG access code formatter

Upload the two registration exports and download a single CSV ready to import as access codes in the SixSides dashboard. Nothing is stored: the files are processed in memory and discarded.

What it does

Each rego number becomes one access code. Athletes are joined to a community for their country and one for each record type. Friends and family are joined to their country. Agency names are converted to Title Case and copied to the member's profile as their company. The download is in the SixSides access code import format: code, communities, company, max_claims.

If the exports come out of Excel as .xlsx, open them and save each as CSV first.