Universal Content Puller XX Sources

Universal Content Puller XX Sources is a Content Sources extension for Universal Content Puller. The sources in this extension are XX because they are the kind of source you may not want to let just anyone loose with, hence a separate package so they don't have to be installed with less sensitive sources.

Once installed, you will have:

  • Site database - select data from the site's database.
  • Any database - select data from any configured database.
  • Site database with form - select data from the site's database with additional query parameters from an on-page form.
  • Any database with form - select data from any configured database with additional query parameters from an on-page form.
  • SQLite File Manager - Pull content from an SQLite database uploaded to the file manager.
  • SQLite File Manager With Form - Pull content from an SQLite database uploaded to the file manager using additional parameters from a form.
  • SQLite File Path -  Pull content from an SQLite database system file.
  • SQLite File Path With Form - Pull content from an SQLite database system file using additional parameters from a form.

To upload an SQLite database to the file manager you will need to enable the file extension in the dashboard at Dashboard > Systen & Settings > Files > Allowed File Types.. This is usually ".db".

You can see a demonstration of the Site Database content source at Example - SQL Data and Site Database with Form at Example - SQL Data with Form.

These sources also make good a starting points for developing custom data sources with more complex database queries. Copy and rename the Site Database or Any Database source for your custom source and then code your more complex query into it.

SQL Extract Transforms

If you need to run a query on data, the SQL sources from Universal Cointent Puller XX Sources are the best solution.

However, data is not always available in a database source. For such situations,  Universal Cointent Puller XX Sources also provides the transforms

  • SQL Extract - Extract and filter content from any tabular data using an SQL expression.
  • SQL Extract with Form - Extract and filter content from any tabular data using an SQL expression using additional parameters from a form.

The general process is to pull the content source and, if necessary, transform it into a table. This will typically involve a Pipeline transform so an  SQL Extract or SQL Extract with Form transform can then follow.

These SQL Extract or SQL Extract with Form transforms work in a similar way to the equivalent SQL sources. Internally, they translate the tabular data into a temporary SQLite database, then run the configured query to extract from the data and pass it onwards to further transforms or to the content display.

Query expressions consequently use the SQLite syntax which has minor differences from MySQL.

Get it FREE

Universal Content Puller XX Sources requires Universal Content Puller and is free to those who have purchased Universal Content Puller. Just send me your UCP license details and I will grant you a free license to Universal Content Puller XX sources.

Extension

Universal Content Puller is designed for extension. Content sources, transforms and displays follow a pluggable and extensible architecture for easy integration of further sources, transforms and displays from within UCP or provided by third party packages or your own application specific plugins.

Requires php7.3+.  Compatible with php8+.

Universal Content Puller XX Sources

jl_universal_content_puller_xx_sources - v9.1.2

Sources extension for Universal Content Puller. The sources in this extension are XX because they are the kind of source you may not want to let just anyone loose with, hence a separate package so they don't have to be installed with less sensitive sources.

ConcreteCMS Marketplace v9.1.2

Content Source Plugins
  • Any Database
  • Any Database with Form
  • SQLite File Manager
  • SQLite File Manager With Form
  • SQLite File Path
  • SQLite File Path With Form
  • Site Database
  • Site Database with Form
Content Transform Plugins
  • SQL Extract
  • SQL Extract with Form

Universal Content Puller

jl_universal_content_puller - v9.3.18 - resources v9.2.29

Pull content from many sources and display it in many ways.

ConcreteCMS Marketplace v9.3.18

Block Types Single Pages
  • Universal Content Puller /dashboard/​blocks/​universal_content_puller Pull content from many sources and display it in many ways.
  • Plugins /dashboard/​blocks/​universal_content_puller/​plugins Plugins for the Universal Content Puller block
  • Global Settings /dashboard/​blocks/​universal_content_puller/​global_settings Edit global settings and defaults for the Universal Content Puller block.
Content Source Plugins
  • Calendar Event List
  • Child Area
  • Direct Table
  • Direct Text
  • Express List
  • File
  • File Folder List
  • Fileset List
  • Global Area
  • Google Sheet
  • None
  • Page Area
  • Page List
  • Parent Area
  • Stack
  • URL
  • URL With Form
  • User List
Content Transform Plugins
  • Array Hacker
  • Cache With Transform
  • Convert Encoding
  • First Row to Keys
  • HTML Repair
  • Key Filter
  • Key Mapper
  • Key Picker
  • Key Regex
  • List Selector
  • Markdown
  • Multi Selector
  • NL2BR
  • Pass Through
  • Pipeline
  • Remove Duplicate Values
  • Selector
  • Table From CSV
  • Table From HTML
  • Table From JSON
  • Table From Text Lines
  • Table Sorter
  • Value Filter
  • Value Replace
Content Display Plugins
  • DataPicker
  • JavaScript Data
  • Limited Text
  • ListPicker
  • Multi Level List
  • Paragraphs With Heading
  • Plain
  • Serialize
  • Serialize Paginate
  • Table

Additional Pages

About this Sidebar

Most of this sidebar constrcuted using Universal Content Puller.

The Content Source is Page Area, set to pull the Sidebar area from the Universal Content Puller page and within that sliced to just the Page List.

The Content Transform is Selector, set to remove container and row classes that, when unnecessarily nested, could mess up the Bootstrap grid. The Content Display is Plain, which just outputs the transformed text.

In the advanced settings, sanitization is disabled as we trust the source page and don't want to strip out any formatting or functionality from the pulled sidebar.