jReviews Support Forum

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?

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.

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.

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.