CSV 2 POST

Description

Create WordPress posts using data imported from .csv files within minutes.

All themes supported and all properly formatted .csv files can be imported.

High level of automation for updating data, updating posts and creating posts.

Basic features supported free. Donators or past premium buyers get advanced
levels of support and discounts on consultation.

Main Links

Why CSV 2 POST?

CSV 2 POST offers longer term management of the data used to generate posts, than most plugins.
If you need to do a quick job, build a quick WP and still be prepared for unexpected changes
in your project/site. Then CSV 2 POST is the plugin you need. The interface has a sandbox approach
allowing users to submit any form at anytime. That means when you suddenly realize your posts need
to change or your original source of data has changed. You can simply use any of the tools available
to get the job done with minimum fuss. CSV 2 POST is intended to be permanently installed however
you can use it for quick projects and remove the plugin also. Please see the plugins portal and follow
the tutorials provided to get started.

  1. New Premium Level Schedule Tools added in 2016
  2. Create posts, pages and custom post types with no limits.
  3. On demand (systematic) post updating.
  4. Create hierarchical categories.
  5. Put posts in existing categories.
  6. Unique key custom fields (post meta) supported.
  7. Design templates using WYSIWYG editor.
  8. Import pre-made tags or generate them.
  9. Import images to WordPress media gallery.
  10. Perfect post titles and get high SEO scores.
  11. Manage .csv files as data sources.
  12. Upgrading to premium is simple.
  13. Works with all .csv files.
  14. Featured image support.
  15. WordPress styled interface to match the rest of your admin.

Support

WebTechGlobal will try to accomodate your communication and correspondence preferences.
Just let us know what software or website you use to share files safely and chat privately.
Here is a list of just a small number of the places you can message us.

Languages

Seeking translators. Your name, site link, Twitter and YouTube videos will be added to the plugins pages in return for your contribution.

Plugin Author

Thank you for considering CSV 2 POST. I import data to WordPress for a living. If your stuck, if you need another solution
or help with any existing data importer. Please visit forum.webtechglobal.co.uk for free help.

Donators

These donators have giving their permission to add their site to this list so that plugin authors can
request their support for their own project. Please do not request donations but instead visit their site,
show interest and tell them about your own plugin – you may get lucky.

Contributors: Translation

These contributors helped to localize WTG Tasks Manager by translating my endless dialog text.

  • None Yet

Contributors: Code

These contributers typed some PHP or HTML or CSS or JavaScript or Ajax for WTG Tasks Manager. Bunch of geeks really!

  • None Yet

Contributors: Design

These contributors created graphics for the plugin and are good with Photoshop. No doubt they spend their time merging different species together!

  • None Yet

Contributors: Video Tutorials

These contributors published videos on YouTube or another video streaming website for the community to enjoy…and maybe to get some ad clicks.

  • None Yet

Version Numbers and Updating

Explanation of versioning used by myself Ryan Bayne. The versioning scheme I use is called “Semantic Versioning 2.0.0” and more
information about it can be found at http://semver.org/

These are the rules followed to increase the CSV 2 POST plugin version number. Given a version number MAJOR.MINOR.PATCH, increment the:

MAJOR version when you make incompatible API changes,
MINOR version when you add functionality in a backwards-compatible manner, and
PATCH version when you make backwards-compatible bug fixes.
Additional labels for pre-release and build metadata are available as extensions to the MAJOR.MINOR.PATCH format.

When To Update

Browse the changes log and decide if you need any recent changes. There is nothing wrong with skipping versions if changes do not
help you – look for security related changes or new features that could really benefit you. If you do not see any you may want
to avoid updating. If you decide to apply the new version – do so after you have backedup your entire WordPress installation
(files and data). Files only or data only is not a suitable backup. Every WordPress installation is different and creates a different
environment for WTG Task Manager – possibly an environment that triggers faults with the new version of this software. This is common
in software development and it is why we need to make preparations that allow reversal of major changes to our website.

Screenshots

  • Manage Multiple Projects.
  • Simple Import Statistics.
  • Category Data Selection.
  • Custom Fields With Templates.
  • Standard Post Settings.
  • Generate Tags.
  • Custom Publish Dates.
  • Content Templates.

FAQ

As a WebTechGlobal subscriber can I get higher priority support for this plugin?

Yes – subscribers are put ahead of my Free Workflow and will not only result in a quicker response for support
but requests for new features are marked with higher priority.

Can I hire you to customize the plugin for me?

Yes – you can pay to improve the plugin to suit your needs. However many improvements will be done free.
Please post your requirements on the plugins forum first before sending me Paypal or Bitcoins. If your request is acceptable
within my plans it will always be added to the WTG Tasks Management plugin which is part of my workflow system. The tasks
priority can be increased based on your WebTechGlobal subscription status, donations or contributions you have made.

Can I import CommissionJunction affiliate feeds?

Download .csv files from Commission Junction then upload them or paste a URL directly to a .csv file on any domain to import it that way.
Commission Junction and all other affiliate networks are supported.

Is there a limit to the number of posts I can create?

There are no limits others than what your server will allow you to do in a single request.

Will CSV 2 POST help me with SEO?

Yes CSV 2 POST allows the creation of post meta (custom fields) which are used by most SEO solutions. More support can be added on
request for free. The plugin also offers text-spinning without limits and there is more planned on that.

When was CSV 2 POST released?

The project started in 2009 and was quickly backed by large businesses including Ryanair Ltd. I created the plugin while technically still at University so
it didn’t take long for a re-development to happen. I found myself re-developing it again in 2014 with the aim of making more use of the WordPress core.

Reviews

Error on activation with WP 4.4

lymeswold

Sadly this plugin crashed when activated on my test WP installation, which has a few plugins installed but otherwise is pretty clean right now.

Sad because the functionality looks very impressive and clearly a lot of effort has gone into development. However I just don't have time to investigate it further.

Really this merits only 1 star, but I'll give 2 for effort.

Here's the error message (which suggests a basic SQL syntax error - surely not?):

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 for query ALTER TABLE wp_c2pprojects CHANGE COLUMN datatreatment datatreatment VARCHAR(50 made by require_once('I:\php\wordpress\wp-admin\admin.php'), do_action('admin_init'), call_user_func_array, CSV2POST->add_adminpage_actions, CSV2POST->projectstable_add_status_column, dbDelta

Read all 16 reviews

Changelog

8.2.19

  • Feature Changes
    • None
  • Technical Changes
    • Correction made for installation of sources database table.
    • Removed projectstable_add_status_column() which updated very old versions but was being called too frequently.

8.2.18

  • Feature Changes
    • Multiple file support has been removed. It is a premium level feature that cannot be supported for free.
    • Plugins title renamed to CSV 2 POST Free Edition.
    • New box added to main view called Premium Edition and has link to Envato Marketplace.
  • Technical Changes
    • Renamed debug_guide() function to prevent conflict.

8.2.17

  • Feature Changes
    • Can now delete scheduled events.
    • Made Import Data view clearer by adding Project ID and Source ID, removed Void row as it is not in use.
  • Technical Changes
    • Removed makecronjobs_all() in class-automation.php.
    • automation_administration() has been ceased it is not yet required.
    • Main class is no longer loaded in other classes (was causing construct to run extra times).
    • Custom post type registration now begins in main construct (removed from main file).
    • shortversion constant removed from main class.
    • Removed constant for plugin version in main class. It is now in main file.
    • get_option_schedule_array() depreciated.
    • uninstall.php is causing issues so some uninstallation steps removed pending a new procedure.

8.2.16

  • Feature Changes
    • Action links for this plugin on the plugins view displays extra links.
  • Technical Changes
    • Removed require line for schedule_array.php which has been removed from package.

8.2.15

  • Feature Changes
    • None
  • Technical Changes
    • Removed functions for old automation system i.e. event_check(), event_focus()
    • Fix for failure to install tables – another fragile dbDelta() requirement!

8.2.14

  • Feature Changes
    • None
  • Technical Changes
    • Bug fix: functions in CSV2POST_Schedule class did not have a required $args parameter.
    • Missing file from the repository in last version “functions.debug.php”.

8.2.13

  • Feature Changes
    • New schedule system added. Members only version has more options and more development planned.
    • Log and Flag systems removed. New debug class takes over any form of logging.
    • Old schedule system removed. That includes settings and history.
  • Technical Changes
    • uninstall.php file added.
    • Replaced depreciated get_currentuserinfo() with wp_get_current_user().
    • Automation class updated with the new one from CSV 2 POST.
    • New options class installed. Too much work to integrate 100% it will be done gradually.

8.2.12

  • Feature Changes
    • None
  • Technical Changes
    • Changed lockmeta tinyint(1) unsigned DEFAULT ‘0’,
    • to
    • lockmeta tinyint(1) unsigned DEFAULT 0,
    • in attempt to fix issue with dbDelta() which causes dbDelta() to
    • attempt to change the datatreatment column.

8.2.11

  • Feature Changes
    • None
  • Technical Changes
    • Renamed $this->TabMenu and $this->Tabmenu to $this->TABMENU – correcting a bug released yesterday.

8.2.10

  • Feature Changes
    • Dashboard widgets now display after a change to how classes are loaded in view.
    • setup() in view files no longer loads class, it is done in the class-view.php class.
  • Technical Changes
    • None

8.2.9

  • Feature Changes
    • Can now delete custom field rules.
  • Technical Changes
    • None

8.2.8

  • Feature Changes
    • None
  • Technical Changes
    • Bug fix related to accessing view file when importing data.

8.2.7

  • Feature Changes
    • New view files added.
  • Technical Changes
    • None

8.2.6

  • Feature Changes
    • Plugins main menu reduced into layers of difficulty to help users focus on the plugins tools in a new way.
  • Technical Changes
    • None

8.2.5

  • Feature Changes
    • Spelling corrections x 2.
  • Technical Notes
    • None
  • Known Issues
    • Data Table view is not suitable as tables are too wide, column titles cannot be read.
    • Some forms are not suitable for being in the narrow sidebar by default, probably use that bar for quick tools and small information.

8.2.4

  • Feature Changes
    • None.
  • Technical Notes
    • Security improved on forms.
    • Possible bug fix regarding ALTER TABLE query – changed query layout for dbDelta()
  • Known Issues
    • Data Table view is not suitable as tables are too wide, column titles cannot be read.
    • Some forms are not suitable for being in the narrow sidebar by default, probably use that bar for quick tools and small information.

8.2.3

  • Feature Changes
    • New list of waiting files added to All Projects Tools view. Later it can be upgraded to allow quick data import.
    • Moved schedule information from Schedule Settings box to a new box.
    • Scheduled automation improved – be warned the plugin may show increased activity, use schedule settings to reduce.
    • New box added to All Projects Tools view for testing new automated post creation function.
    • New box added to All Projects Tools view for testing new automated post updating function.
    • New box added to All Projects Tools view for testing new automated data import function.
    • New box added to All Projects Tools view for testing new automated data updating function.
  • Technical Notes
    • Main class-csv2post.php is too big. Many functions moving into their own class meaning new files.
    • “row” column added to sources table, plugin will no longer re-count file each time total rows required. This became a requirement when searching for sources that have not yet fully imported all data.
    • Correction made to get_rules_array(), it was always returning array(). Probably a line left during testing but keep in mind it may be bypassing a bug temporary.
    • Actions added to schedule array. Will be used to build form options and includes switches for user global control over individual action types i.e. prevent all post updating for all projects.
    • New “status” column in project tables: “enabled” and “disabled”. Users must be encouraged to disable old projects if creating many.
    • Depreciated function sanitize_url() replaced with esc_url_raw().
    • Incorrect use of escape() removed in two places.
    • c2psources table will no longer store a count of rows including header: always deduct one from a row count of the .csv file before INSERT/UPDATE query.
    • Many functions moved to class-wpdb.php as the file is now a general database class and not strictly functions that only contain WordPress code.
  • Known Issues
    • Data Table view is not suitable as tables are too wide, column titles cannot be read.
    • Some forms are not suitable for being in the narrow sidebar by default, probably use that bar for quick tools and small information.

8.2.2

  • Feature Changes
    • Mailchimp subscription form added to plugins main page.
  • Technical Notes
    • New WTG global schedule and automation class files added.
    • New class-configuration.php file holds package config.
    • Manual adoption now adds the default post meta to an adopted post.
    • Log table now in its own function.
    • Function render() prepared further for localization (sprintf applied).
    • Variable $c2pm (used to be well used global) removed/replaced.
    • Multiple Design Rule form now displays users saved selction in menus.
    • detect_new_files() renamed to detectnewfiles() and moved to class-schedule.php
  • Known Issues
    • Data Table view is not suitable as tables are too wide, column titles cannot be read.
    • Some forms are not suitable for being in the narrow sidebar by default, probably use that bar for quick tools and small information.

8.2.1

  • Feature Changes
    • New Current Project view
    • New button on Quick Actions (only shows on Current Project view) displays a list of column replacement tokens.
    • Dismissable view introductions added – little training in them but those introduction areas will be used to suggest tutorial.s
  • Technical Notes
    • No longer an error when using quick action for Create Posts – related to a variable required for the notice.
    • Moved some classes from class-csv2post.php into class-ui.php as they are only used when on admin side.
    • Bug regarding $package_version_cleaned fixed (related to update system which is still a work in progress).
  • Known Issues
    • Data Table view is not suitable as tables are too wide, column titles cannot be read.
    • Some forms are not suitable for being in the narrow sidebar by default, probably use that bar for quick tools and small information.

8.2.0

  • Feature Changes
    • New Directory Sources screen lists directories intended for providing multiple .csv files.
    • New Data History view focuses on data import events, file changes, new file detection.
    • New Data Alerts view displays newly detected files that require manual import (auto import not active).
    • Separate areas added for management of all projects and management of the current active projects.
    • Plugins main page (plugin dashboard) has gone in reverse, with forms being moved again, we found it never had the usefullness intended
    • Due to variations in .csv files. The project data view only has the default columns. Data displayed will help us monitor the plugins precise activities. That is important if we are to decide if and when the plugin is hyper or not doing enough automation.
    • Menus removed from category descriptions form. User must always enter one or more tokens.
  • Technical Notes
    • Submission of directory source form now adds another entry to the sources database table with source type “localdirectory”
    • Form registration (WTG security system) has been changed to keep registered form data longer. It no longer resets if a second tab is opened.
  • Known Issues
    • Still no easy step by step approach like versions had two years ago. This is coming again soon.
    • Data Table view is not suitable as tables are too wide, column titles cannot be read
    • Some forms are not suitable for being in the narrow sidebar by default, probably use that bar for quick tools and small information.

8.1.37

Fix – complete_plugin_update() was using an eval where not required!

8.1.36

  • Feature Changes
    • Beta area removed.
    • Some views merged into the plugins own dashboard to give the dashboard more purpose. When creating a new data source or project return to the dashboard
    • Project Data Sources view is now a single column due to it displaying a table. A task has been created to remove the accordian and make it a datatable view.
    • Data Table view is now a proper WP datatable – search ability will be improved later for this view.
    • Update screen no longer has two columns.
    • Update screen no longer displays the Quick Actions bar.
    • Removed Update Screen – changes to installation will now be automatic, no user action required, quicker and simplier.
    • Default project settings will no longer be applied for ever new project – a cause of empty custom field rules.
    • Removed any mention of pro or paid left over from premium edition but did add stronger encouragement for donations.
    • Big update to class-forms.php (range of new methods added that make form development far quicker)
    • New mass publish from draft form added – allows selection of current projects posts only, all projects posts or the entire blog (posts not created by CSV 2 POST).
    • Every instance of hidden_form_values() replaced with form_start() – early tests indicate success. This change applies more security against hackers.
    • Sample Data panel now has a list of .csv files for download from WebTechGlobal.
  • Technical Notes
    • Class CSV2POST_ImportTableInformation_Table has been moved from class-csv2post.php to table.php (a view file, the only one that uses the class)
    • options_array.php removed (new options class coming and will be used to improve installation)
  • Known Issues
    • Still no easy step by step approach like versions had two years ago. This is coming again soon.
    • Data Table view is not suitable as tables are too wide, column titles cannot be read
    • Some forms are not suitable for being in the narrow sidebar by default, probably use that bar for quick tools and small information.

8.1.35

  • Feature Changes
    • Automatic post updating addeded based on schedule
    • Systematic post updating now post (happens when old post is opened)
    • Unlimited manual post updating using a forum
    • Multiple post design form added
    • Multiple post types can be applied dynamically
    • Better data source management (more updates coming for that)
    • Can now split data from one .csv file column into multiple database columns
    • Data Sources page renamed to Manage Data Sources
    • The table of sources has been removed from Manage Data Sources (new improved table being added)
    • New page named Data Sources List with a table of all sources (more details about sources available than the previous table)
    • New form for creating multiple data sources using a directory of .csv files, one file is made parent and it is the parent source that is linked to a project.
  • Technical Notes
    • Fault relating to term_exists_in_level() when creating posts has been fixed
    • Title sample field reads “Please import data to see a sample based on your template.” when user has not imported data
    • Accidental dump of post data fixed (happens when using Re-create Missing Posts form)
  • Known Issues
    • Data Table view is not suitable as tables are too wide, column titles cannot be read
    • Some forms are not suitable for being in the narrow sidebar by default, probably use that bar for quick tools and small information.
    • Occasionally clicking on “CSV 2 POST” media button above WYSIWYG editor shows an overlay but the content is not centered. Found this myself and has not been reported by a user.
    • Two reports of “Are you sure you want to do that?” message appearing – not enough information provided to debug.

Contributors & Developers

This is open source software. The following people have contributed to this plugin.

Contributors

Browse the code