Knowledgebase
View categorized listing of all common frequently asked questions.
Video Tutorials (jReviews 2.0)
Create a Movie & TV Show review website.
Customize the jReviews themes.
Review user profiles with the Everywhere addon.
Forum
Community forum
Submit a Ticket
Use your client area email to access the ticket system.
Downloads
Guides, modules and more...
CSV Import for Joomla and jReviews
 
Welcome, Guest. Please login or register.
Did you miss your activation email?
December 02, 2008, 07:13:58 PM
21713 Posts in 4960 Topics by 2843 Members
Latest Member: per4mer
News: Do not post any jReviews files or large amounts of code in the forums please. Only template files and code are allowed.
 
jReviews Support Forum  |  Extensions  |  CSV Import for Joomla and JReviews  |  Populating Multiple Select Lists « previous next »
Pages: [1]
Author Topic: Populating Multiple Select Lists  (Read 1567 times)
eyestrane
Newbie
*
Offline Offline

Posts: 2


« on: September 04, 2008, 05:34:58 PM »

If I understand correctly, to import items for a multiple select list, they must already be entered into a jreviews field then during import surrounded by asterisks. If they are not there already, I assume they will not show up.

example: actors names

enter in a jreviews field - Tom Cruise

in the csv file - *Tom Cruise"

Since in the csv file I already have, there are thousands of actors names already there. Must I enter each one manually first (before import)? Is there a way to enter a list that is already in existence in Jreviews?

Has anyone any experience or suggestions on the best way to do this. If I use a text field and 2 movies have the same actor, will clicking on a link bring up both or will jreviews know that both are one entry if they are spelled the same?
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8613


« Reply #1 on: September 04, 2008, 08:30:53 PM »

That is correct, the list of options needs to exist because CSV doesn't know which type of field it is.You can easily import those options directly into the jreviews_fieldoptions table by using phpMyAdmin. Since it's a single table import it's easier to do this way. phpMyAdmin is a database browsing/maintenance tool available through your hosting panel and it has excel csv export and import features.

If you use a text field with click2search, clicking on the actor's name will bring up all listings that have the same actor as long as they are spelled the same.
Logged

Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
eyestrane
Newbie
*
Offline Offline

Posts: 2


« Reply #2 on: September 04, 2008, 09:08:59 PM »

That is great news. I did not know about PHPAdmin. I will give it a try. Thank you for your response. If I may, if I enter a csv list in the same single table with phpMyAdmin then enter additional entries a second time, will it overwrite the first or add to it. I can always keep an external list updated and replace all the entries if need be but would rather just update the table with new entries if possible. Just curious. Would be a good thing to know before I tried.

BTW - I switched providers today. Seems the problems I was having with Joomla and Jreviews had to do with the server, as you had suggested. Thank you for all your support.
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8613


« Reply #3 on: September 05, 2008, 10:26:09 AM »

The optionid column of the table determines the uniqueness of the row and I don't think you can update a row through import. You should always check what is the last optionid and then start with that plus one so your imports are incremental (new entries only). You also need to check the field id in the fields manager to include it in the csv so the options are added to the correct field.

I recommend you do an export first. Check the format of the file, and then update with new info to import.
Logged

Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
Pages: [1]
« previous next »
    Jump to: