• Is the ability to upload a CSV of reviews possible?
    If not through the plugin, can it be manually added to the review database through phpmyadmin?

Viewing 1 replies (of 1 total)
  • Plugin Contributor Nuanced Media

    (@nuanced-media)

    Right now this is not possible directly through the plugin, however it will likely be added as a feature in a future release. Adding reviews directly through PHPMyAdmin is certainly possible however.

    The DB table structure for storing reviews is as follows:

    
    id int(11) NOT NULL AUTO_INCREMENT,
    	date_time datetime NOT NULL,
    	reviewer_name varchar(100) DEFAULT NULL,
    	reviewer_email varchar(150) DEFAULT NULL,
    	review_title varchar(100) DEFAULT NULL,
    	review_rating tinyint(2) DEFAULT '0',
    	review_text text,
    	review_status tinyint(1) DEFAULT '0',
    	reviewer_ip varchar(39) DEFAULT NULL,
    	post_id int(11) DEFAULT '0',
    	review_category varchar(100) DEFAULT 'none',
    	reviewer_image varchar(100) DEFAULT NULL,
    	reviewer_id varchar(11) DEFAULT NULL,
    

    If you are familiar with how the csv import with phpmyadmin works, you simply have to format your csv in with the above fields in mind (excluding the autoincremented id) and you should be able to import with no problems.

    Let me know if you need more information,
    Thanks,
    Charlie Maxwell
    [NM_Developer]

Viewing 1 replies (of 1 total)
  • The topic ‘Uploading review CSV’ is closed to new replies.