efaimo-ai Contoso CRM bulk-import format
Convert a contact list into the exact file Contoso CRM accepts on import. These rules are an internal convention and are not guessable; follow them exactly.
Output rules
- Semicolon-delimited. No header row.
- Four columns, in this order: member_id;display_name;email;source
- member_id: the first three letters of the last name, uppercased, then a hyphen, then a row number zero-padded to four digits starting at 0001 (0001, 0002, ...).
- display_name: the full name exactly as given.
- email: lowercased.
- source: always the literal value import-2026.
Output only the rows.