Integration to 3rd Party Software

Modified on Fri, 19 Sep at 1:22 PM


We have four types of accomplished system integration with farmerswife (fw). 

In addition, the integration types are split into “available by default and free of charge”, “additionally charged option” and “custom paid 3rd party integration”.

Direct Integration

Available by default and free of charge; requires configuration:

  • Microsoft Entra ID (former "Azure Active Directory") (since fw v6.3, user creation, authentication, and management, supports "nested groups" (groups within groups), "User Groups" respect list order to differentiate Permission levels; and since v6.8 SP3 added "Use MS Azure AD Auth" for the "MS Exchange" integration when used on Exchange 365).

  • Microsoft Active Directory (since fw v5.0, user creation, authentication, and management)

  • WebCal protocol-based user’s Event subscription, permission driven and WIFE user authentication required, can be used e.g. with programs like Outlook, iCal, Lightning for Thunderbird which supports subscribing to calendars via WebCal/.ics.

  • MS Exchange (since fw v4.11, integration to MS Exchange 2007 and 2010 and Exchange 365 to update fw users own events from farmerswife to each user's own Exchange calendar; permission driven).

  • MS Outlook for Bookings (one way to Outlook) 

  • Google Calendar for Bookings (one way to Google)

  • iCal/Calendar app (Sync Module, per user manual sync of Events, Todos; permission driven)

  • Address book/Contacts app (legacy Sync Module per user manual sync of Contacts; permission driven)

  • Weekchart Export (Windows only (through COM) and MS Excel only) of the Hourline.


SSO



Available by request to get licensed and free of charge (might require paid adaption):

  • LDAP-Active Directory (LDAP-AD) (since fw v4.8, authentication, and control of users)


Custom purchased 3rd party integration:

  • Navision Financial (Microsoft Business Solutions), very customized integration only to Personnel data.

fw REST API for your own integrations

Requires additional licensing

  • Customer built 3rd party integrations

See more information here: farmerswife Rest API

In-Direct Integration

Interface through an internal/nonpublic "API" (Application Programming Interface) used as a script/plug-in engine. This is a one-way trigger on creating/modifying/deleting of Contacts, Projects, Invoices, Purchase Orders, and IncomingInvoices. The result is a script export from WIFE to the other system.

Available by default and free of charge:

  • Open As Spreadsheet - export of data as .CSV files from all so-called “column” widgets (i.e. parts in WIFE which look like a spreadsheet) and from the Print Designers)

  • XML export from Media - export of metadata of Entries on Media level, (e.g. used by legacy Leporello (to AdStream)).

  • Hourline XML Export (since fw v5.0, Server-side functionality to Export “Hourline” based event data in XML format)


Additionally charged options (requires paid adaption or needs to be developed from scratch):

.csv style file export used for these systems:

  • Attache - Invoices and Incoming Invoices script export

  • DATEV - Invoice script export

  • Ekon - Invoice script export

  • MYOB - Invoice script export

  • Navision C5 - Contacts, Projects, and Invoice script export, very customized

  • Quickbooks - Invoice script export

  • Sage - Invoice script export

  • Visma - Invoice script export

  • e-conomic - Invoice script export

  • Xero - Invoice script export

  • Oracle - Invoice, Expense Sheets, Budgeting, custom formatted script export, very customized

  • SAP - Invoices and Contacts, custom formatted script export, customized integration

  • Navision/MBS - Importing Contact Clients & exporting Invoices, custom formatted script export, can’t be re-used


WIFE's MySQL data interface to our proprietary database

The farmerswife system runs on our own proprietary databases (current45.efdb) and multiple SQLlite helper databases (fwdb.db3, histories.db3, despatches.db3).
The Server application also has a MySQL data interface option (MySQL v5.1 on Windows and Mac and 5.0 on Linux were the typically used versions). This can be used to extract information from farmerswife to integrate with other systems.

Projects completed that we know about:

  • Customers have built web interfaces

  • Customers have built their own Budgeting

  • Customers have built their own SAP integration

  • Customers have built their own naming convention tool and files-folder based 3D and Post work flow web interface

See more information here: MySQL optional data interface settings



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article