qTopic

Build SmarFolder queries on custom catalogs

The idea of qTopic is to allow building SmartFolder queries on custom catalogs added to Plone site. We had to update atct tool to keep the track of all catalogs indexes and metadata, cause standard implementation supports only portal_catalog.

Example of Usage

Send newsletter with PloneGazette to custom set of CMFMembers

Starting conditions:

• CMFMember installed in the plone site, membership migrated to CMFMember
• PloneGazette installed in the plone site
• in the root of site we have 'gazette' an insctance of Newslettertheme
• we have several members for tests
• we have set up group membership for members

To allow building Criterias on custom folders we have to update SmartFolde configuration. It is located in separate configlet listed in Plone Control Panel (under 'site setup') link, and called 'Smart Folder Settings'

Select member_catalog in the catalogs dropdown to edit searchable indexes list for it.

Add getGroups index, set Allowed Criteris to 'List of values' and 'Text'.

Then Switch to metadata tab and add getGroups, getFullname, getEmail columns to make them visible in SmartFolder view table or CSV file.

Adding 'subscribers' qTopic in the root of site. In our sample qTopic we will set working catalog to 'members_catalog'.

On the export scheme select 'Short Name','Full Name', 'Email'.

Now on the criteria tab set Sorting on Creation date and preview the data

On the 'export in csv' tab you will see

Now lets filter Groups to Administrators and Designers

Resulting set of Memebers will look this way

You can also export your data into CSV in one click clicking icon

The last step let add the custom list of subscribers to PloneGazete/

Add new 'newsletter' to the gazette and check the send tab it should view the number of extra recipients, that we just generated with help of qTopic.