Knowledgebase: User Manual
Import / Export Model Ratings to CSV file
Posted by Mark [Elevated X Support], Last modified by Mark [Elevated X Support] on 21 September 2017 11:34 PM
The CMS has the ability to import and export model 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 Model Ratings" on the page.
Note: You'll need to have the Ratings and Model Plugin enabled in order to see this listing on the Import / Export page.
Once you are on the model CSV 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 comments available.
An example CSV would look like this:
CSV ColumnsHere 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.
Model Id: This is the Id of the model this rating is associated with. If this value is set to blank, the import system will instead try and use the Model Name to determine which Model Id to use.
Model Name: If Model Id is set to blank, the import system will try and find the Model Name based on the title as listed in /cms_admin/plugins/contentasc/contentasc.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 OptionsUser 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.
Model Options: You can determine whether to ignore any sort of model errors, or show any errors when doing an import.
Remove Existing Votes: If set to yes, remove any existing votes in the system belonging to models.