To obtain a multi-site license you must negotiate a special offer with JohntheFish, the developer of Universal Content Puller XX Sources.
Click below to send a private message and begin the process. You may need to sign in to community.concretecms.com before you can message this user.Send Message
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.
Requires php7.3+. Compatible with php8+.
Once installed you will have UCP sources for:
You can see a demonstration at Example - Site Database.
To upload an SQLite database to the file manager you will need to enable the file extension in the dashboard. This is usually ".db".
These are also 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.
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
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.
This addon 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 this extension.