Wild Apricot field presets and known quirks
MapleGather’s Wild Apricot import wizard recognizes standard Wild Apricot export columns and pre-fills your field mapping. This page lists what it looks for, the six known Wild Apricot quirks the pre-import checklist covers, and where to generate an API key.
What the wizard recognizes
Section titled “What the wizard recognizes”The wizard pre-fills mapping for the column names a standard Wild Apricot member export uses — contact name, email, membership level, renewal date, and status fields, plus any custom contact fields you’ve added in Wild Apricot. Custom fields that can’t be matched automatically become inline-create suggestions during mapping, the same way any import handles an unrecognized column.
Known quirks (the pre-import checklist)
Section titled “Known quirks (the pre-import checklist)”| Quirk | What it means | What MapleGather does about it |
|---|---|---|
| Multi-sheet workbooks | A Wild Apricot Excel export can include several sheets. | The wizard asks which sheets to include — none is dropped silently. If you said “single sheet” but the file has more, the preview flags the conflict. |
| Archived contacts | Wild Apricot’s standard export leaves out archived contacts. | The preview warns if your export looks like it’s missing archived contacts, and points you to a re-export with archived included or the API import. |
| File attachments | File-attachment columns in a Wild Apricot export hold file references, not the files themselves. | The preview flags these columns and points you to the WebDAV file pull to fetch the actual files. |
| Passwords | Wild Apricot doesn’t export member passwords. | This is expected — your members set a new password when they claim their MapleGather account. |
| CSV injection | Cells starting with =, +, -, or @ can be interpreted as spreadsheet formulas by some tools. |
MapleGather flags these cells and lets you choose to import them as plain text or skip them — never runs them as a formula. |
| 15,000-row export cap | Wild Apricot caps a single export at roughly 15,000 rows. | If you have more contacts, export in batches, or connect directly to the Wild Apricot API instead. |
Membership level and renewal translation
Section titled “Membership level and renewal translation”Wild Apricot’s membership levels and renewal types don’t map one-to-one onto MapleGather’s model, so the wizard shows a reviewable table before anything imports:
| Wild Apricot concept | Typically becomes | Notes |
|---|---|---|
| Auto-renew Annual level | A level with an annual renewal cycle | Confirmed in the translation table before import. |
| Lifetime level | A level with an unlimited renewal cycle and no further renewals | Wild Apricot’s Lifetime levels don’t renew; MapleGather models this explicitly rather than guessing. |
| Per-member renewal anniversary | Kept as each member’s personal renewal date, if you confirm it | Wild Apricot sometimes tracks renewal dates per member rather than on a fixed calendar; you’ll be asked whether to keep this. |
| Bundle | Family / Household, Corporate affiliate, or Hybrid — decide by bundle name | You choose the mapping and see sample records before committing. |
Where to generate a Wild Apricot API key
Section titled “Where to generate a Wild Apricot API key”If you’re connecting via the API instead of uploading a file, you’ll need an API key from Wild Apricot: in Wild Apricot, go to Settings > Security > Authorized applications, create a server application, and copy the key it gives you. Paste that key into the MapleGather connection screen — MapleGather never asks you to share it anywhere else, and it’s never shown again once entered.