Knowledgebase: User Manual
Import / Export DVD 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 DVD 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 DVD Ratings" on the page.
Note: You'll need to have the Ratings and DVD Plugins enabled in order to see this listing on the Import / Export page.
Once you are on the DVD 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:
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.
DVD Id: This is the Id of the DVD this rating is associated with. If this value is set to blank, the import system will instead try and use the DVD Title to determine which DVD Id to use.
DVD Title: If DVD Id is set to blank, the import system will try and find the DVD Title based on the title as listed in /cms_admin/plugins/dvdasc/dvdasc.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.
DVD 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.