“Xlsxomatic Automatic Post Generator for WordPress” Help by CodeRevolution

“Xlsxomatic Automatic Post Generator for WordPress Help”

Created: 29/01/2017
By: CodeRevolution
Email: support@coderevolution.ro

Thank you for purchasing our plugin. If you have any questions that are beyond the scope of this help file, please feel free to email via our email. Thanks so much!

About the plugin
Wordpress installation
Plugin Settings
Summary
Sources and Credits

About this plugin - top

This plugin will allow you to build from scratch an autoblogging system, based on xlsx files that you upload to your WordPress install, which will be used as article sources. This plugin provides one solution to the ongoing search for new blog content. It not only provides a steady stream of rich, searchable content. You can build rules that will generate posts that are near to unique in website crawlers's eyes. They require none to very little customization.
The goal is to achieve the following:
Xlsxomatic Automatic Post Generator will generate posts from an unlimited number of articles, imported from uploaded xlsx files. Resulting blog posts are fully customizable and rich in content. List of customizable stuff for each post:

post author user name
post status (published, draft, pending, private, trash)
automatically generate post categories or tags from xlsx file's meta keywords
manually add post categories or tags to items
generate post or page
automatically generate a featured image for the post
enable/disable comments for the generated post
enable/disable pingbacks/trackbacks for the generated post
customize post title and content (with the included wide variaty of relevant post shortcodes)

Other plugin features:

access xlsx file's full content
Google Translate support ' select the language in which you want to post your articles
Text Spinner support ' automatically modify generated text, changing words with their synonyms ' great SEO value!
Keyword Replacer (replace relevant keywords with your links)
Random sentence generator (relevant sentences - as you define them)
detailed plugin activity logging
scheduled rule runs

Wordpress installation - top

Youtube video tutorial:

I also provided a Quick Install Guide to feature an easy plugin installation for everyone.

To make this plugin work, first, you'll need to install the plugin. The easiest method is to take the .zip file you've downloaded and upload it via Plugins > Add New > Upload Plugin in the WordPress Dashboard. Once the plugin is installed, be sure to Activate it.

Now that you've installed and activated the plugin, you'll see a new menu item created inside WordPress called 'Xlsxomatic Automatic Post Generator'. First thing first, let's head over to Settings > Xlsxomatic Automatic Post Generator and take a look at what options are available.

Plugin Settings - top

Refreshingly, Xlsxomatic Automatic Post Generator has a super-simple settings screen. Let's look at first at the settings panel:

Here you can find the steps needed in configuring your plugin even if you have no HTML knowledge at all. You can find options for:

HINT! Don't forget to click the Save button every time you modified your settings, otherwise the modifications will be lost!

Main Settings:

Xlsxomatic Automatic Post Generator Main Switch: Enable or disable the Xlsxomatic Automatic Post Generator. This acts like a main switch.
Secret Word Used For Manual/Cron Running: Select a secret word that will be used when you run the plugin manually/by cron. See details about this below.
Goo.gl API key: Insert your goo.gl api key. To lean more about this, please visit this link.
Strip Links From Generated Post Content: Choose if you want to strip links from the generated post content.
Show Extended Item Information Metabox in Post: Choose if you want to show an extended information metabox under every plugin generated post.
Enable Logging for Rules: Do you want to enable logging for rules?
Enable Detailed Logging for Rules: Do you want to enable detailed logging for rules? Note that this will dramatically increase the size of the log this plugin generates.
Automatically Clear Logs After: Choose if you want to automatically clear logs after a period of time.
Timeout for Rule Running (seconds): Set the timeout (in seconds) for every rule running. I recommend that you leave this field at it's default value (3600).
Email Address: Input the email adress where you want to send the report. You can input more email addresses, separated by commas.
Send Rule Running Summary in Email: Choose if you want to receive a summary of the rule running in an email.
Minimum Title Word Count: Set the minimum word count for post titles. Items that have less than this count will not be published. To disable this feature, leave this field blank.
Maximum Title Word Count: Set the maximum word count for post titles. Items that have more than this count will not be published. To disable this feature, leave this field blank.
Minimum Content Word Count: Set the minimum word count for post content. Items that have less than this count will not be published. To disable this feature, leave this field blank.
Maximum Content Word Count: Set the maximum word count for post content. Items that have more than this count will not be published. To disable this feature, leave this field blank.
Banned Words List: Do not include posts that's title or content contains at least one of these words. Separate words by comma. To disable this feature, leave this field blank.
Required Words List: Do not include posts that's title or content does not contain at least one of these words. Separate words by comma. To disable this feature, leave this field blank.
Featured Image Resize Width: Do not include posts that's title or content does not contain at least one of these words. Separate words by comma. To disable this feature, leave this field blank.
Featured Image Resize Height: Resize the image that was assigned to be the featured image to the height specified in this text field (in pixels). If you want to disable this feature, leave this field blank.
Strip HTML Elements from Final Content by ID: Strip HTML elements from final content that have this IDs. You can insert more IDs, separeted by comma. To disable this feature, leave this field blank.
Strip HTML Elements from Final Content by Class: Strip HTML elements from final content that have this class. You can insert more classes, separeted by comma. To disable this feature, leave this field blank.
Skip Posts That Do Not Have Images: Choose if you want to skip posts that do not have images.
Automatically Translate Content To: Do you want to automatically translate generated content using Google Translate?
Spin Text Using Word Synonyms: Do you want to randomize text by changing words of a text with synonyms using one of the listed methods? Note that this is an experimental feature and can in some instances drastically increase the rule running time!
First List of Possible Sentences (%%random_sentence%%): Insert some sentences from which you want to get one at random. You can also use variables defined below. %something ==> is a variable. Each sentence must be sepparated by a new line.
Second List of Possible Sentences (%%random_sentence2%%): Insert some sentences from which you want to get one at random. You can also use variables defined below. %something ==> is a variable. Each sentence must be sepparated by a new line.
List of Possible Variables: Insert some variables you wish to be exchanged for different instances of one sentence. Please format this list as follows:Variablename => Variables (seperated by semicolon)Example:adjective => clever;interesting;smart;huge;astonishing;unbelievable;nice;adorable;beautiful;elegant;fancy;glamorous;magnificent;helpful;awesome
Custom HTML Code #1: Insert a custom HTML code that will replace the %%custom_html%% variable. This can be anything, even an Ad code.
Custom HTML Code #2: Insert a custom HTML code that will replace the %%custom_html2%% variable. This can be anything, even an Ad code.
ID (Affiliate Keyword Replacer Tool Settings:) This is the ID of the rule.
DEL (Affiliate Keyword Replacer Tool Settings:) Do you want to delete this rule?
Search Keyword (Affiliate Keyword Replacer Tool Settings:) This keyword will be replaced with a link you define.
Replacement Keyword (Affiliate Keyword Replacer Tool Settings:) This keyword will replace the search keyword you define. Leave this field blank if you only want to add an URL to the specified keyword.
Link To Add (Affiliate Keyword Replacer Tool Settings:) Define the link you want to appear the defined keyword. Leave this field blank if you only want to replace the specified keyword without linking from it.

XLSX Rules to Pages Settings Screen:

Upload XLSX: Upload a XLSX file, so you can use it for importing.
ID This is the ID of the rule.
Xlsx File Select the xlsx file from which you want to import content from. You must upload the respective file first, using the file uploader from above.
Extract From These Pages Input a range of pages that should be imported. If you want to extract the whole xlsx content, leave this field blank. You can use also the '-' range operator. Ex: 1,2,3,4,10-20
Del: Do you want to delete this rule?
Post Status: Select the status that you want for the automatically generated posts to have.
Item Type : Select the type (post/page) for your automatically generated item.
Post Author : Select the author that you want to assign for the automatically generated posts.
Info: The number of items (posts, pages) this rule has generated so far.
Actions: Do you want to run this rule now? Note that only one instance of a rule is allowed at once.

Advanced Plugin Settings Dropdown Screen:

Import Content From Sheet Number: Select the number of the sheet, found in the uploaded document, from where you want to import content from. First sheet (regardless of it's name has ID 1), the second ID 2, and so on.
Skip First X Rows From Importing: This is useful when your XLSX starts with some rows that contains the title of the cells, or some heading information, and you want to skip these rows from posting.
Minimum Number Of Cells Per Line: Select if you want to skip lines that don't have this required number of cells. Default value for this is 4.
Post Featured Image Column ID: Select the id of the column where the featured image URL will be available.
Skip Post If Cell IDs are Empty: Input a comma separated list of cell numbers (example: 1,2,3), that if blank, the line will be skipped from post importing.
Generated Post Title: Set the title of the generated posts for user rules. You can use the following shortcodes: %%random_sentence%%, %%random_sentence2%%, %%custom_html%%, %%custom_html2%%, %%post_title%%, %%post_content%%, %%xlsx_subject%%, %%xlsx_keywords%%, %%xlsx_creator%%, %%xlsx_producer%%, %%xlsx_creation_date%%, %%xlsx_modified_date%%, %%xlsx_page_count%%
Generated Post Content: Set the content of the generated posts for user rules. You can use the following shortcodes: %%xlsx_images%%, %%random_sentence%%, %%random_sentence2%%, %%custom_html%%, %%custom_html2%%, %%post_title%%, %%post_content%%, %%xlsx_subject%%, %%xlsx_keywords%%, %%xlsx_creator%%, %%xlsx_producer%%, %%xlsx_creation_date%%, %%xlsx_modified_date%%, %%xlsx_page_count%%
Generated Post Format: If your template supports "Post Formats", than you can select one here. If not, leave this at it\'s default value.
Additional Post Category: Select the post category that you want for the automatically generated posts to have.
Automatically Add Post Categories From Items: Do you want to automatically add post categories from the feed items?
Automatically Add Post Tags From Items: Do you want to automatically add post tags from the feed items?
Limit Article Word Count: Set the maximum word count for the article. If you set this value, a "Read More" link will be automatically appended to the end of the article for articles that where shortened. To disable this feature, leave this field blank.
Additional Post Tags: Select the post tags that you want for the automatically generated posts to have.
Enable Comments For Generated Posts: Do you want to enable comments for the generated posts?
Enable Pingbacks/Trackbacks For Generated Posts: Do you want to enable pingbacks and trackbacks for the generated posts?
Auto Featured Image: Do you want to try to extract featured image from xlsx document? This feature is available only if you don't enable the 'Alternative Library For XLSX Parsing' option in the Main Settings.
Default Featured Image if No Image Available for Item: Insert a link to a valid image that will be set for the featured image for the posts that do not have a valid image attached or if you disabled automatical featured image generation. To disable this feature, leave this field blank.

Activity and Loggind Screen:

Rules Currently Running: These rules are currently running on your server.
Restore Plugin Default Settings: Hit this button and the plugin settings will be restored to their default values. Warning! All settings will be lost!
Delete All Posts Generated by this Plugin: Hit this button and all posts generated by this plugin will be deleted!
Delete All Uploaded XLSXs And Delete All Rules: Hit this button and all uploaded xlsxs will be deleted!
Activity Log: This is the main log of your plugin. Here will be listed every single instance of the rules you run or are automatically run by schedule jobs (if you enable logging, in the plugin configuration).

How to customize resulting posts with built in shortcodes?

You can use the following shortcodes in post title and content editing:

%%column1%% - 1st column in the xlsx row that is being imported
%%column2%% - 2nd column in the xlsx row that is being imported
%%column3%% - 3rd column in the xlsx row that is being imported
%%columnX%% - Xth column in the xlsx row that is being imported
%%random_sentence%% - generates a random sentence (as you have defined them in plugin config.) More on how to configure the random sentence generator, check plugin documentation (down)
%%random_sentence2%% - generates a random sentence (from the second geenrator) (as you have defined them in plugin config.) More on how to configure the random sentence generator, check plugin documentation (down)
%%custom_html%% - includes the custom HTML you defined in the Main Settings interface (Custom HTML Code #1:)
%%custom_html2%% - includes the custom HTML you defined in the Main Settings interface (Custom HTML Code #2:)

How to work with 'Random Sentence Generator'?

You can use the Random Sentence Generator by inserting list of sentences to the 'First List of Possible Sentences (%%random_sentence%%)' text field. Here, you can add full sentences, or sentences with variables. Variables are structured as: %something. A possible list of sentences can be:

Meet this %adjective %noun %sentence_ending
This is the %adjective %noun ever%sentence_ending
I %love_it %nouns , because they are the %adjective %sentence_ending
My %family says this plugin is very %adjective %sentence_ending
These %nouns are quite %adjective %sentence_ending

You can define variables in the 'List of Possible Variables:' textfield. Here you can define values to variables, values which will be used in the random sentence forming. Variables can be defined as follows:

variable_name1 => variable_value1;variable_value2;variable_value3

variable_name2 => variable2_value1;variable2_value2;variable2_value3

You can also use variables in variable definition. Example:

noun_with_adjective => %noun;%adjective %noun

An example of variable definition:

adjective_very => %adjective;very %adjective;

adjective => clever;interesting;smart;huge;astonishing;unbelievable;nice;adorable;beautiful;elegant;fancy;glamorous;magnificent;helpful;awesome

noun_with_adjective => %noun;%adjective %noun

noun => plugin;WordPress plugin;item;ingredient;component;constituent;module;add-on;plug-in;addon;extension

nouns => plugins;WordPress plugins;items;ingredients;components;constituents;modules;add-ons;plug-ins;addons;extensions

love_it => love;adore;like;be mad for;be wild about;be nuts about;be crazy about

family => %adjective %family_members;%family_members

family_members => grandpa;brother;sister;mom;dad;grandma

sentence_ending => .;!;!!

These random sentences can be used in post titles or post content, by adding the %%random_sentence%% or %%random_sentence2%% shortcode.

Available shortcode

Available shortcodes: [xlsxomatic-list-posts] to include a list that contains only posts imported by this plugin and [xlsxomatic-display-posts] to include a WordPress like post listing. Usage: [xlsxomatic-display-posts type='any/post/page/...' title_color='#ffffff' excerpt_color='#ffffff' read_more_text="Read More" link_to_source='yes' order='ASC/DESC' orderby='title/ID/author/name/date/rand/comment_count' title_font_size='19px', excerpt_font_size='19px' posts=number_of_posts_to_show category='posts_category' ruleid='ID_of_echo_rule'].

Example: [xlsxomatic-list-posts type='any' order='ASC' orderby='date' posts=50 category= '' ruleid='0']

Example 2: [xlsxomatic-display-posts include_excerpt='true' image_size='thumbnail' wrapper='div'].

Summary - top

Xlsxomatic Automatic Post Generator is a simple, yet powerful tool you can use to create an autoblog with ease. The setup and settings of the plugin couldn't have been easier. Now, let's go and enjoy the results of this great plugin! Have fun using it!

Sources and Credits - top

This component was made by Szabi CodeRevolution, for more information and support contact us at support@coderevolution.ro

Once again, thank you so much for purchasing this item. As I said at the beginning, I'd be glad to help you if you have any questions regarding this plugin and I'll do my best to assist.

CodeRevolution