Knowledgebase: User Manual
Import / Export Content Ratings to CSV file
Posted by Mark [Elevated X Support], Last modified by Mark [Elevated X Support] on 21 September 2017 11:35 PM
The CMS has the ability to import and export content ratings to a CSV file.

You can reach this functionality by going to Utilities -> Import / Export from the top menu. Once you are on that page, there should be an option for "Import / Export Content Ratings" on the page.

Note: You'll need to have the Ratings Plugin enabled in order to see this listing on the Import / Export page.

Once you are on the vote import / export page, you'll see a link that allows you to download either the current votes as a CSV file, or a template of how the CSV file will look if there are no votes available.

An example CSV would look like this:

User Id,User Name,Set Id,Set Title,Score,Date Voted
"3","aj","441","Keeping it Clean","6","2015-04-15 00:00:00"
"6","ajhallx","311","Dorm Room Daydream","8","2015-07-27 00:00:00
"2","mark","44","Redhead Lust","8","2016-01-21 00:00:00"

CSV Columns

Here are details on what each of these columns are.

User Id
: This is the internal user id that the rating is associated with. If you are inserting ratings for users that may not exist in the system, leave this value blank.

User Name
: If the User Id value is set blank, the import system will instead try and use this username to determine what user id to insert as.
Optionally, you can configure the system to either insert new users within the system, or error out if this user does not already exist.

Set Id
: This is the Id of the set this rating is associated with. If this value is set to blank, the import system will instead try and use the Set Title to determine which Set Id to use.

Set Title
: If Set Id is set to blank, the import system will try and find the Set Title based on the title as listed in /cms_admin/contentgroup.php

Score: This is the value that the user voted. Valid values are whole numbers between 0 and 10.

Date Voted
: This is the date that the rating was added to the system.

Import Options

User Options: You can determine what to do with users that do not exist within the system. You can either set this value to add new users to the system under User Tracking, or error out if the user does not exist.

Set Options: You can determine whether to ignore any sort of set errors, or show any errors when doing an import.

Remove Existing Votes: If set to yes, remove any existing votes in the system.
(0 vote(s))
Helpful
Not helpful

Comments (0)