Syncopy technical overview

Modified on Tue, 12 Sep 2017 13:16 by Audun Hegranes — Categorized as: Intouch, Syncopy

Overview

Syncopy is a add-on product for Link Engage which provides a daily automated import from external data sources into Link Engage.
This works in a Master/slave one-way setup where all data imported into Link Engage are unchangeable in the webapplication.


File transfer

Files are uploaded to Syncopy by SFTP. Authentication is done either by username/password or by SSH key.
For more information, read about SFTP on Wikipedia.

At the moment, files must be pushed to Syncopy, there is no pull functionality.



CSV File format

The Import functionality has a proprietary CSV format that is used by most customers.
See the following page for full information: CSV file format for Intouch Import



Other file formats

Syncopy also supports XML files based on IMS Enterprise.



Example

Assume the following file is processed on monday for the first time.

ORGANIZATION;PSWinCom;Link Mobility AS
USER;PSWinCom;1;Bjørn Otto;Vasbotten;4792011111;bjorn@pswin.com
USER;PSWinCom;2;Ingebjørg;Reksten;4745211111;ingebjorg@pswin.com
GROUP;PSWinCom;3;Admins;
GROUP;PSWinCom;4;PSWinCom;
CONTACT;PSWinCom;5;4799511111;Ingebjørg;Reksten;ingebjorg@pswin.com;Account Manager;;;4
CONTACT;PSWinCom;6;4792011111;Bjørn Otto;Vasbotten;bjorn@pswin.com;Nearshoring Manager;;;3|4
CONTACT;PSWinCom;7;4795811111;Rune;Vindenes;rune@pswin.com;Product Manager;;;4

Syncopy will then create the organization with name Link Mobility AS, with 2 users, 2 groups and 3 contacts.



Assume the following file is processed on tuesday, where one contact and one group has been removed from the file, and the user with synchronizationId=2 has had its name and email changed:

ORGANIZATION;PSWinCom;Link Mobility AS
USER;PSWinCom;1;Bjørn Otto;Vasbotten;4792011111;bjorn@pswin.com
USER;PSWinCom;2;Bjørg;Reksten;4745211111;support@pswin.com
GROUP;PSWinCom;3;Admins;
CONTACT;PSWinCom;5;4799511111;Ingebjørg;Reksten;ingebjorg@pswin.com;Account Manager;;;4
CONTACT;PSWinCom;6;4792011111;Bjørn Otto;Vasbotten;bjorn@pswin.com;Nearshoring Manager;;;3|4

Syncopy will then remove the group with synchronizationId=4, remove the contact with synchronizationId=7 and change the user with synchronizationId=2 to name "Bjørg" and email "Support@pswin.com".



Assume the following file is processed on wednsday, with one contact added:

ORGANIZATION;PSWinCom;Link Mobility AS
USER;PSWinCom;1;Bjørn Otto;Vasbotten;4792011111;bjorn@pswin.com
USER;PSWinCom;2;Bjørg;Reksten;4745211111;support@pswin.com
GROUP;PSWinCom;3;Admins;
CONTACT;PSWinCom;5;4799511111;Ingebjørg;Reksten;ingebjorg@pswin.com;Account Manager;;;4
CONTACT;PSWinCom;6;4792011111;Bjørn Otto;Vasbotten;bjorn@pswin.com;Nearshoring Manager;;;3|4
CONTACT;PSWinCom;7;4795811111;Rune;Vindenes;rune@pswin.com;Product Manager;;;3

Syncopy will then add a new contact with name Rune Vindenes, and add that contact to the group with name "Admins"