Universal tag plugin

This plugin enables you to insert data in your Newsletter from any table from your database.

Be careful, if you install this plugin you will be able to access all data from your database. This plugin should not be installed on a website where strangers can create articles or newsletters. If you purchased one of our paid version of AcyMailing, you can download our universal tag plugin.

Once installed and enabled, click on the "tags" button when you edit your Newsletter and select the "Load data..." menu.

DB selection

Once the table selected, all fields from the selected table will appear and you can select them. These fields will be then displayed in your Newsletter.

Universal tag plugin options

  • Displayed fields : The selected fields will be displayed in your Newsletter.

  • Where : You can add a condition to the element selection... you will see the parameter where1:fieldname,condition,value added to your tag, you can duplicate this parameter and add other conditions with where2,where3,where4... please use the same format as where1. You can add user variables in the conditions by adding the string [userid] or [email] or [name] or [subid] to load user-specific data. All fields from the AcyMailing user profile can be used in the condition, the one created as custom fields as well [yourcustomfieldname]

  • Order by : You can order your elements based on a field from your database.

  • Max. number of items : Maximum number of elements AcyMailing should load.

  • Start : Should we skip the first X elements? Please enter the number of elements we should skip or leave the default option 0.

  • Template : You can create your own template to display the loaded element the way you want. You can create your own template in the folder media/com_acymailing/plugins/yourtemplatename.php The created file will then appear in the list of available templates in the tag interface. If you create your own file, you can access the loaded element via the $element variable (your custom file will be loaded for each element). The option "table" enables you to display the loaded elements in a table.

You can also add additional parameters to the tag such as:

  • noheader : if you add this option to the tag with our "table" template, Acy won't display the table header but directly the loaded elements. Example : {loaddata:#__acymailing_subscriber|fields:name|noheader|limit:1|template:table}

  • where2 : you can add additional conditions to the element selection... this additional parameter follows the same format as the where1 parameter inserted via the interface. The same way, you can use where3, where4, where5... Example : {loaddata:#__acymailing_subscriber|fields:name|where1:subid,>,3|where2:enabled,=,1|where3:html,=,1limit:1|template:table}

  • nostructure : By default this plugin will add a table and add each result in its own cell. You can prevent this kind of behavior by adding the extra parameter "nostructure" to the tag. Example : {loaddata:#__acymailing_subscriber|fields:name|nostructure|limit:1|template:table}