E-Boekhouden

From MyMemberSoftware wiki
Jump to: navigation, search

On this page you will find information about setting up the MMS Synchro interface and using e-Boekhouden.

Requirements:

  • MMS Synchro component
  • PHP7 with SOAP enabled so that phpinfo(); gives the following output:
Php7 soap.png
  • User that only can create / edit members
  • The security code 1 and 2 from e-boekhouden.nl : Beheer -> Inrichting -> Instellingen -> Koppelingen -> API/SOAP -> Verder.
  • Create extra required fields in e-boekhouden, like membership type and start +end date of subscription.

Optional:

  • Not really required, but very handy for the treasurer is the MariaDB / Mysql event scheduler or a stored procedure. They are used to calculate a value in an extra field whether the member is Active or Inactive.
SET GLOBAL event_scheduler = ON;
CREATE EVENT mms_inactiveindicator
  ON SCHEDULE
    EVERY 1 DAY
    STARTS '2018-03-18 00:20:00' ON COMPLETION PRESERVE ENABLE 
  DO
    UPDATE #__leden
    SET VARXX = IF((datediff(NOW(), `opzegdatum`) > 1) AND NOT(`Opzegdatum` ='0000-00-00' OR `Opzegdatum` IS NULL OR `Opzegdatum` =''), 'MMSINACTIVE', 'MMSACTIVE');
  • activate all members in e-Boekhouden.nl by searching for "MMSACTIVE"
  • create the different e-Boekhouden.nl subscription types, get the unique labels in MMS -> Roles
  • Search in the active members for the unique labels and assign the matching e-Boekhouden subsription type

Specific Map instruction

When mapping fields, e-boekhouden needs to map the MMS field "Naam" to the e-boekhouden "Naam" field, and MMS field "Straatnaam" to "Address".

E-boekhouden-map naam.png

An example mapping:

Mmssynchro e-boekhouden.png

Synchronizing for the first time

Activate the synchronization script on your website, check in e-boekhouden if the members have been created. Important: when searching, choose: "alle leden", because initially, all members will be "inactief". If not all members are being synchronized, look in logs/mms_synchro.log.php for errors regarding members.

E-boekhouden-checkmembers.png

Activating "inactive" members ; assign a subscription

The treasurer needs to make the members without an end of subscription date "Active".

E-boekhouden search inactive.png

Search the inactive memberlist "Also on free fields" for the text "MMSACTIVE". Select those members, and activate them by giving a subscription ("Lidmaatschap aanmaken voor geselecteerde leden").

E-boekhouden-activate.png

Most associations will give members a membership for 1 year:

E-boekhouden-lidmaatschap.png

Member data is synchronized.