# Evergreens

You can access this feature by clicking on Activities, Evergreens in the toolbar area (only PRO).

Perfect Publisher - Evergreens

Evergreens are content items ready to be published when there is nothing else to publish. The Virtual Manager (opens new window) will pick one of them, according to the defined publication strategy, and generate a new Request and Post.

Reference: Should Bloggers And Businesses Share Old Content? (opens new window)

Available operations:

  • Batch operation: a set of Evergreens can be moved from the evergreen status.
  • Delete: evergreens can be deleted to avoid any further processing.

Perfect Publisher - Evergreens

# How to generate evergreens from articles

This article is based on a customer's idea to take advantage of Perfect Publisher's Evergreens and a big set of articles to republish them to social media channels.

Content items usually have a short life. In a common scenario, articles are written with great effort, published on the site front page, and quickly moved to some internal page. Despite this, some articles have a permanent value and can be featured again, following a social media strategy.

I have several thousand articles (5,000+) I am looking to mark as evergreen so they can be posted in random order to Twitter on a schedule (a few per day, one every few hours).

This is a recipe to create requests and evergreen definitions for all articles in a specific category.

# Procedure to generate 5,000 evergreen content items

# Backup and test

We recommend testing these SQL scripts on a development site and backup your site before applying them in production.

# Assumptions

  • General SQL knowledge to apply SQL statements in the database.
  • Replace the prefix and constants. All these SQL statements are written with the #__ prefix; please replace it with your Joomla! database prefix. You can find it in Global Configuration/ Server/ Database Tables Prefix.
  • In this example, we have worked with category 64, replace the number according to your site requirement. If you have more than one category, you can change the condition with the IN operation. Example, catid IN (64, 65, 66, ...)
  • We have also assumed that content is shown in menu item 9999; replace the number according to your site requirement. You can find the menu item in the menu manager or disable SEF and navigate the front-end site to find it. If you have more than one menu, for instance, to access different categories, then you have to perform this procedure for each category to assign the right menu item.
  • Finally, in this example, we have defined the domain as WWW.MYSITE.COM, replace the domain according to your site requirement.

# Clean Perfect Publisher tables

For a fresh start, these lines remove all previous records from the affected tables:

# Review the articles

Check the published articles to be processed in the category. In this example, category 64.

# Generate Requests

This SQL statement generates initial requests for each article. They are generated as processed records; no message is going to be generated to social channels.

# Generate Evergreens

This SQL statement generates the evergreen attribute for each inserted request.

# Images definition

SQL statements generate evergreen content items to publish articles as Posts. They simulate the content requests and evergreen attributes. However, there is one limitation: post image.

In the regular Request creation, the Post image can be inside the text or in several different fields. When a Post is defined by a user, a careful and thoughtful process detects the image. Alternatively, in Perfect Publisher, a user can manually specify a different image. This process cannot be replicated at the database level.

As a workaround, after you execute these SQL statements, images can be defined specifically for your site with more SQL statements or in Joomla! article manager. Alternatively, if there is no image in a Post, Facebook and Twitter can take advantage of Facebook Open Graph Tags or Twitter Cards Tags to detect the right image associated with the Post. Social Tags are supported via Facebook Open Graph Tags plugin or TwitterCards Graph Tags plugin. We usually recommend enabling them to enhance your site content definition. In this business case, these plugins help to define the Post image.

# Images definition based on a text pattern

It is possible to extract the first image in the text based on 'img src' pattern.

This query allows checking what images can be retrieved from articles. It relies on "img src" to detect images in the text.

This is the query to define images, on the initial requests, based on this assumption:

# Evergreen Strategy Definition

Finally, the content items, requests and attributes are ready to be published according to an Evergreen Strategy. Please, visit the Virtual Manager (opens new window) configuration and define the strategy.

Remember, as you are going to have a large number of evergreen content items, it is recommended to enable the Cron job mode (opens new window)

# Conclusion

This article has introduced a method to reshare content with great value from your business. Content that remains fresh and interesting. This method has been applied in Joomla! articles, but it can be easily modified to load content items from other extensions. If the content has never been published, it will be discovered by your current audience. If you have already shared it, you can also apply a couple of rules to modify the title with a twist to feature a different angle.

# Frequently asked questions

For more information, visit the Frequently Asked Questions (opens new window)