SPTools6

SPTools6 – TYPO3 6.x to SharePoint Connector

SPTools6 TYPO3 extensions are the ‘Swiss army knife’ for communication between TYPO3 CMS 6.x and Microsoft © SharePoint.

Lists and data records can be visualised within the TYPO3 website frontend, while forms transfer data to SharePoint lists and the extensive synchronisation options for importing SharePoint records and documents into the TYPO3 system.

List view

The SPTools6 TYPO3 frontend plugins allow for any number of SharePoint lists and libraries to be depicted in real time.

The display and content/data can thus be used flexibly and individually, since they are created via TYPO3 Standard Fluid templates.

Application examples include press reports, appointments, job offers, product lists, document lists or image galleries.

The list views can also be used as search result lists. In this case, the SPTools6 search form sends the query to the corresponding list and performs a search of SharePoint. Each list can be freely configured in terms of which SharePoint columns are to be searched.

Detailed View

From the list view, you can automatically link to a detailed view of a SharePoint record.

This view is also based on TYPO3 Fluid templates and thus can be individually designed.

SPTools6 depict the records popular core information as well as attachments and information from linked (“Lookup”) lists.

Sample product spec sheet:
 From a product list, the visitor can move to a detailed view of a product. Beyond core information such as product name and description, specifications and number, brochures can also be included as attachments, while handbooks are provided as linked documents from an external SharePoint document library.
SPTools resolves the attachments and linked documents, offering them in the detailed view of the product through meta-information and download links.

Embedded form:
 You can link SPTools6 forms with a specific list so that a form can be optionally displayed embedded in the detailed view. This might for example involve an query form for a product, sending the form data to a SharePoint list created especially for this purpose; in this way a SharePoint workflow is then initiated and the query is routed for proper internal handling.
TYPO3 forwarding of data via email or TYPO3 internal lists thus become obsolete.
Learn more about the functionality of SPTools6 on the “Form View” tab.

Form view

SPTools6 forms have been developed for data transfer from the TYPO3 frontend to a SharePoint.

These forms prevent doubled upkeep of SharePoint content, enabling communication with visitors to the TYPO3 website and efficient processing in SharePoint.

The form view and fields are dynamically created via the SharePoint list/column information and can be individually designed using TYPO3 Fluid templates as required. An arbitrary number of files can be attached by visitors to your website.

There are two fundamental application types for SPTools6 forms:

  1. An embedded form in the detailed view of a record, such as for product queries, news feedback or applications for an open position.
  2. Self-contained forms can be used as general contact forms or for support queries.
Synchronisation

SPTools6 synchronisation serves to enrich TYPO3 records or file resources through SharePoint sources and can be sub-divided into two application areas:

1. Synchronisation of TYPO3 extensions

In this case TYPO3 extension records are created based on a SharePoint source. If for example you wish to enrich your TYPO3 news plugin with selective press releases from SharePoint, then you can use this synchronisation option.

2. Synchronisation of files

In this case, SPTools6 synchronises the TYPO3 file system and File Resources within the local FAL (File Abstraction Layer) system with SharePoint documents or image libraries.

The individual sync cycles can be configured conveniently via the TYPO3 backend records. You define which SharePoint and which SharePoint lists are to be queried, which SharePoint columns are to be stored in which TYPO3 fields, whether and how the records are filtered, where documents or attachments are stored in your TYPO3 system, etc.

You can naturally also integrate the synchronisation processes individually or as packs in the TYPO3 “scheduler” to have them executed by the TYPO3 system on a specific schedule.

System

SPTools3 comprises two TYPO3 extensions. No other special adjustments are required within TYPO3 or the SharePoint system.

Requirements for the TYPO3 system:

  • TYPO3 version 6.x
  • Extbase and Fluid installed

Requirements for PHP:

  • cURL
  • SOAP
  • XML support

Requirements for SharePoint:

The following SharePoint system versions are supported:

  • Windows SharePoint Services 3.0 (WSS 3.0) and Microsoft Office SharePoint Server 2007 (MOSS)
  • SharePoint Foundation 2010 and SharePoint Server 2010
  • SharePoint Foundation 2013 and SharePoint Server 2013

The SharePoint server must be reachable by the TYPO3 server via http(s) and at least one SharePoint user with read rights for the corresponding sites / lists must be registered for use of SPTools. In the event that SPTools forms are used, the SharePoint user must also have write rights for the corresponding SharePoint lists receiving the form data.

SPTools delivers exactly what we need. Direct access to relevant data for the customers via the website. Direct processing of content, product information and appointments are handled in a decentralised manner in the familiar SharePoint environment. This adds tremendous value for us and our customers.

Ricardo LorenzERP/BI Specialist - SES 21 AG

Screendemo

We’d be glad to present SPTool6 to you as part of an approx. 1 hour screensharing demo.
Please just let us know you’re interested!