Download COMPONENT USER MANUAL

C SV I MP O RT : USER MA NUA L
4.4.2.Checkboxes and Multiple-Select Lists
In jReviews, multiple options can be associated with a checkbox field or multiple-select list and users are free to select as many of the options as
they choose. The CSV cell must contain the values of the option(s) that will be selected for the checkbox or list.
Original CSV Cell
Correct CSV Cell
blue
*blue*
Excel/CSV How-to
The simplest way to make this change is via a search and replace within your CSV
file. Here, you would search for yes and replace with *yes*
blue, red
*blue*red*
If multiple values are in a single cell, as shown here, then a search-and-replace
operation will likely be the easiest way to create the correct value.
Col 1
Col 2
Col 1
Col 2
NEW
If the cell content that resolves to a single jReviews checkbox is distributed across
blue
red
blue
red
*blue*red*
different columns in your CSV file, you will need to create a new column that
consolidates the data. You can achieve this by using a simple Excel function in the
New column:
=CONCATENATE(“*”,A1,”*”,B1,”*”)
The visible result in the New column will be as shown at left.
4.4.3. Example 1: Associating a Single-Value CSV Column with a Radio Button Field or Single Select-List
Your CSV file contains a column called titled “My Very Favorite Color” with possible cell values of red, blue, and green.
A
1
My Very Favorite Color
2
Red
3
Blue
4
Red
5
Green
CSV IMPORT :: User Manual
Copyright 2008, NakedJoomla
Page 9 of 21