sportlink-to-mailchimp-converter

A node module that converts Sportlink exports (.csv) into a csv you can import into Mailchimp.

Latest build status

How to use

1. Install the node module:

   npm install sportlink-to-mailchimp-converter
   

2. Import the module in your code:

   // Javascript
   const SportlinkToMailchimpConverter = require('sportlink-to-mailchimp-converter')

   // Typescript
   import { SportlinkToMailchimpConverter } from 'sportlink-to-mailchimp-converter'

3. And use it:

   const converter = new SportlinkToMailchimpConverter({
     nonAthleticsMembershipTypes: ['Gastlid', 'Recreanten'],
     athleticsMembershipTypes: ['Atletiek']
   })
   
   console.log(converter.convertFileToOutput(file))

4. Using in a browser:

   <script src="https://cdn.jsdelivr.net/npm/sportlink-to-mailchimp-converter/sportlink-to-mailchimp-converter.umd.js"></script>
   <script>
     const converter = new SportlinkToMailchimpConverter.SportlinkToMailchimpConverter({
       nonAthleticsMembershipTypes: ['Gastlid', 'Recreanten', 'Overigen'],
       athleticsMembershipTypes: ['Atletiek']
     });
   
     console.log(converter.convertFileToOutput(file));
   </script>

Examples

You can use example-input.csv to test.

Config

The configuration object looks like this:

{
    nonAthleticsMembershipTypes: string[]
    athleticsMembershipTypes: string[]
}

These values are used to recognize the "Lidsoorten vereniging" in your Sportlink export. For every string you provide in those arrays, the SportlinkToMailchimpConverter will scan the lidsoorten column in your csv file:

• For every nonAthleticsMembershipTypes it finds, it will add a Mailchimp tag with that membershipType in the output.
• For every athleticsMembershipTypes it finds, it will add a Mailchimp tag with "Atletiek " in the output.

Credits

Dependencies

• Special thanks to the developers and maintainers of papaparse for providing an easy to use library that helps me parse and serialze CSV files.

Trademarks

All trademarks, inlcuding (but not limited to) Mailchimp and Sportlink, are the property of their respective owners.