AcyMailing
Back to LATEST versionOur siteForumBlog
Version 5
Version 5
  • AcyMailing 5 documentation
  • Main pages
    • Users
      • Export Users
      • Import Users in AcyMailing
      • Mass actions
    • Lists
      • Distribution lists
      • List: Add/Edit
    • Newsletters
      • A/B Testing
      • Spam Test
      • Schedule your Newsletter
      • Smart-Newsletters
      • Campaigns
      • Joomla notifications
      • Simple Sending
      • Templates
        • Import a template
    • Queue
    • Statistics
      • Click statistics
      • Comparison page
      • Statistics charts
    • Configuration
      • Configuration tabs
        • Configure your send process
          • DKIM : DomainKeys Identified Mail
          • External SMTP service
        • Cron task
        • Geolocation
        • Captcha
        • Google Analytics
        • Forward to a friend
        • Access level
      • Custom fields
      • Bounce Handling
      • Unsubscribe page
  • Public part of your site
    • Configure your Subscription Module
    • Latest Newsletters module
    • Newsletter archive section
    • Front-end Newsletter edition
  • FAQ
    • Insert your subscription form in your article
    • Update AcyMailing 5
    • Your send process is slow?
    • Could not instantiate mail function
    • Sending issue
    • Spam issue
    • Compatibility issues
    • Install / Update issues
  • Integration plugins
    • Installed with AcyMailing
      • Insert Joomla articles in your newsletter
      • Plugin : Statistics
      • Plugin: (auto)Subscribe during Joomla registration
      • Plugin: Call to action
      • Plugin: Date - Time
      • GMail Inbox Actions
      • Plugin: Joomla Module Loader
      • Plugin: Joomla User
      • Plugin: Manage Subscription
      • Share your Newsletter on social networks
      • Plugin: Subscriber
      • Plugin: Website Links
      • AcyMailing plugin : table of contents generator
    • User management
      • Plugin: AltaUserPoints
      • Plugin : VirtueMart Checkout Subscription
      • Plugin: CB User
      • Plugin: CJBlog
      • Plugin: com_contact
      • Plugin: Community Builder
      • Plugin: Easy Profile
      • Plugin: EasySocial
      • Plugin: ExtendedReg Profile Information
      • Plugin: Grumpy Contacts
      • Plugin: Ja Job Board
      • Plugin: JomSocial
      • Plugin: JUGA
      • Plugin: K2 Users
      • Plugin: MightyMembership
      • AlphaUserPoints plugin
    • Content management
      • Plugin : AdsManager
      • Plugin: AdsManager (by Heigho)
      • Plugin : Dj-Catalog 2
      • Plugin : Kunena
      • Plugin: AdAgency
      • Plugin: CiviCRM
      • Plugin: Cobalt
      • plugin: Dj-Classifieds
      • plugin: EasyBlog
      • plugin: EasyDiscuss
      • Plugin: Emerald
      • Plugin: EZautos
      • plugin: FLEXIcontent
      • Plugin: Form2Content
      • Plugin: GMapFP
      • plugin: JoomBlog
      • plugin: Joomla! Estate Agency (JEA)
      • plugin: K2 items
      • Plugin: ListBingo
      • plugin: Lyften Bloggie
      • Plugin: MightyResources
      • Plugin: MosetsTree
      • Plugin: Newsfeeds
      • plugin: SEBLOD 3
      • Plugin: Sobi2
      • Plugin: SobiPro
    • Events
      • plugin: !Cagenda
      • Plugin: DPCalendar
      • Plugin: EventList
      • plugin: Event Booking
      • Plugin: jCalPro Events
      • Plugin: jEvents
      • Plugin: Matukio
      • plugin: MijoEvents
      • Plugin: Ohanah
      • Plugin: redEvent
      • Plugin: RsEvents
      • plugin: RSEvents Pro
    • E-commerce
      • Plugin: Awo Affiliate
      • Plugin: HikaShop
      • plugin: JoomShopping
      • plugin: K2Store
      • Plugin: redSHOP
      • Plugin: MijoShop
      • Plugin: VirtueMart Coupons
      • Plugin: VirtueMart
      • AwoCoupon plugin
    • Subscription system
      • Plugin: AEC
      • Plugin : CBSubs
      • Plugin: Membership Pro
      • Plugin: MightyRegistration
      • Plugin: OSE Membership Control Manager
      • Plugin: Payplans
      • Plugin: AkeebaSubs
      • AEC AcyMailing micro-integration
    • Files management
      • Plugin : RokDownloads
      • Plugin: DOCman
      • plugin: DOCman 2
      • Plugin: Document Media Manager
      • Plugin: jDownloads
      • Plugin: Joomdoc
      • Plugin: PhocaDownload
      • Plugin: Remository
    • Other
      • Module: Statistics dashboard
      • module: Quick icon for J1.5
      • Plugin : Module Article
      • plugin: AcyMailing toolbox
      • plugin: Auto-create a list on user registration
      • plugin: Add CC
      • Plugin: Create Joomla user
      • Plugin: Autotweet NG
      • plugin: Edit notification
      • plugin: Export users in mass action
      • plugin: List owner notification
      • Plugin: Modify user group
      • plugin: Quick icon for J2.5 and J3.X
      • plugin: Search
      • Plugin: Smart Search
      • Plugin: Squeeze Page
      • plugin: Stop Smart-Newsletter during weekend
      • Universal tag plugin
      • Universal filter plugin
      • Birthday Newsletter
  • Developers
    • AcyMailing 5 Developer Documentation
    • Customize the way the content inserted in emails by plugins
    • Conditional display
    • Multiple queue system
    • External subscription form
    • Subscription via URL
      • Fabrik Form and AcyMailing
      • ChronoForm and AcyMailing
      • RSForm!Pro and AcyMailing
      • BreezingForms and AcyMailing
Powered by GitBook
On this page
  1. Integration plugins
  2. Other

Universal tag plugin

Last updated 4 years ago

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}