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
  • Simple Query (also called Universal filter)
  • Advanced Query
  • Example: send a Newsletter to 50th subscribers
  • Import
  1. Integration plugins
  2. Other

Universal filter plugin

Last updated 4 years ago

You can download this additional plugin via . Once installed, this plugin will add four new options to the AcyMailing filtering system:

Simple Query (also called Universal filter)

This option enables you to execute a simple query on the table you want in your current database.

This filter is a simplified version of the Query filter (see below).

Universal filter

  • Table Name: specify the table name

  • User field: AcyMailing must identify the user by its Joomla user ID or by its email address. You can specify in this field the name of the Joomla User ID column in your table or the name of the e-mail column.

  • Where: The first parameter should be one of the column from your table, you can then specify the operator and the value you want.

Advanced Query

This filter will enable you to execute any kind of query to filter your users, from the current database or even from an external database (if you have access to).

Query

  • The first dropdown enables you to specify if the query executed will select e-mail addresses or Joomla user IDs.

  • The second dropdown enables you to select if AcyMailing should exclude (NOT IN) or include (IN) the selected users.

  • You can write your query in the textarea. Please not that you can enter time tags, so you could add some conditions on a date, for example: SELECT email FROM #__acymailing_subscriber WHERE created > {time-86400} AND created < {time} will select Acy users created in the past day. 86400 is a number of seconds.

  • Database information: you can specify there the access to an external database. If you leave the Database Host field empty, AcyMailing will execute the query on your current database.

Example: send a Newsletter to 50th subscribers

If you want to set up a system to automatically send a Newsletter to your 50th, 100th, 150th subscribers... then you could set up an automatic filter using AcyMailing Enterprise with the following configuration.

We added an additional filter "Statistics => Not sent" to make sure Acy will not send again the same message to the same user (as this filter can be configured to be executed automatically every day).

Query example

Import

This filter enables you to import users in AcyMailing via database.

You will find a similar interface on our "import via database" feature but the fact you have it in the filters enables you to directly execute actions on these users and even automate that task.

Import

This filter enables you to extract e-mail addresses from a text and then execute actions on the found e-mail addresses.

This filter is extremely useful if your host does not enable you to handle bounce messages but enables you to download a file containing all returned e-mail addresses so you can just copy/paste the content of that file and then execute an action on the selected users (you could block them for example).

Extract

our plugins section