Path

ez projects / integrate


Integrate Datatypes

UNIX name Owner Status Version Compatible with
integrate Bruce Morrison stable 1.0 3.6+ (not 4.0)
Provides datatypes that allows the user to select one (External Option) or multiple (External Multiple Option) values from an existing database table. This effectively allows links to be created between eZ Publish content and external data. Useful for integrating eZ Publish content with external data.

External Option

Allows for a single select from an external database table to be stored in the content object.

Stores selected item index value in data_int of attribute.

When adding this datatype to a content class the user is asked for a lookup table name as well as the index and label columns. The index column must be an integer type.

Can be used as an information collector. This is quite handy if you need to the options to be consistent across a number of content objects. (the standard Option datatype requires that the options are entered for each content object)

External Multiple Option

Stores selected items index values in specified table.

When adding this datatype to a content class the user is asked for a lookup table name, index and label columns and a storage table. The index column must be an integer type.

The storage table must have the following structure:

CREATE TABLE cmsTimetableCategoryModes (
    contentobject_attribute_id int(11) UNSIGNED NOT NULL DEFAULT '0',
    version int(11) UNSIGNED NOT NULL DEFAULT '0',
    [LooupTableIndex] int(11) UNSIGNED NOT NULL DEFAULT '0',
    contentobject_id int(11) UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (contentobject_attribute_id,version,[LooupTableIndex])
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

where [LooupTableIndex] is the index column as defined in the content class.

Includes an extended attribute filter to find objects that have a common
external option values.

Installation

Follow these steps to add the integrate module to your eZ publish installation:

  1. Extract the archive into the /extension directory
  2. Edit site.ini.append in /settings/override. Add the following to the file:
    [ExtensionSettings]
    ActiveExtensions[]=integrate

If you already have the [ExtensionSettings] block, just add the second line.

This project has no reviews yet. Be the first one to review it!