OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Disable Reviewing Interests Autocomplete

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

Disable Reviewing Interests Autocomplete

Postby uscguitarte » Tue Oct 01, 2013 11:03 am

Hi OJS Community,

We have an issue that has recently come up since our upgrade from OJS 2.2 to 2.4.2

The reviewing interests field has undergone an overhaul and replaced the open text field to one with a tag and autocomplete feature.

This is causing immense frustration with our users who cannot edit or add new reviewing interests because the autocomplete is struggling to keep up with the backend queries to present while typing - causing a long freeze and lack of response from the browser.

Is there a way we can disable the autocomplete feature of the reviewing interests field when creating or editing a user?

Thanks,
Chris
USC Anneneberg
uscguitarte
 
Posts: 14
Joined: Mon Apr 29, 2013 4:53 pm

Re: Disable Reviewing Interests Autocomplete

Postby asmecher » Tue Oct 01, 2013 11:17 am

Hi Chris,

Would cleaning up the set of reviewing interests solve the problem? If you haven't always had CAPTCHA testing enabled, it's likely that the set contains a lot of spam contents; if so, you might be better off cleaning up the data rather than disabling autocomplete altogether.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8674
Joined: Wed Aug 10, 2005 12:56 pm

Re: Disable Reviewing Interests Autocomplete

Postby uscguitarte » Tue Oct 01, 2013 2:35 pm

Hi Alec,

Thank you for your suggestion. Cleaning up the interests might be time-prohibitive at this point unless you can suggest a way we can clean up the controlled_vocab_entry_settings table easily?

We have many long values input there such as "Intersection between Media Exposure and Interpersonal Communication" or "The Role of New Media in Health Communication".

There are about 3,819 rows of valid data as interests in controlled_vocab_entry_settings. None of these are SPAM related.

If we were to disable autocomplete are there any negative ramifications or drawbacks?

Thanks for all your help,
Chris
USC Annenberg
uscguitarte
 
Posts: 14
Joined: Mon Apr 29, 2013 4:53 pm

Re: Disable Reviewing Interests Autocomplete

Postby asmecher » Tue Oct 01, 2013 3:04 pm

Hi Chris,

Disabling autocomplete will lead to a proliferation in similar-but-not-identical entries, making it tougher for editors to use the list. (Think "Computers" vs. vs. "Computer Science" vs. "Computer Programming", never mind all the permutations of spelling etc.

Forgive me for trying another alternative to disabling outright -- but watch for a patch to show up at http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=8437 that might improve performance considerably. If that still doesn't do it for you, I'll describe how to disable autocomplete.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8674
Joined: Wed Aug 10, 2005 12:56 pm

Re: Disable Reviewing Interests Autocomplete

Postby uscguitarte » Tue Oct 01, 2013 3:46 pm

Hi Alec,

Thanks - we'll wait for a patch first (I'm CC'ed on that bug now) and work on cleaning as much as we can.

In terms of cleaning up the interest values - how would you suggest going about cleaning up single rows such as this:

Multiple values in one setting_value
"celebrity & fandom; Media & democracy; Alternative & community media; Media ethics; Social & cultural theory; Methodology & history of cultural studies"

Also - if we have some SPAM values - can we simply just delete the row from the table?

-Chris
USC Annenberg
uscguitarte
 
Posts: 14
Joined: Mon Apr 29, 2013 4:53 pm

Re: Disable Reviewing Interests Autocomplete

Postby asmecher » Tue Oct 01, 2013 4:10 pm

Hi Chris,

That 6-in-one is probably old data, but regardless, it's certainly not useful data -- those really should be represented as separate entries, possibly up to 11 of them, depending on how you want to break it apart. If there are a small number of these to fix, I'd suggest using the "Log In As" or "Edit User" features to fix these up using the user interface rather than working with the database directly. (Poorly entered data like this will benefit from a clean set of interests already in the database, as they'll see short, relevant suggestions come up before they finish entering the long, less-than-useful ones.)

For deleting old entries, there are 3 tables you'll need to clean data out of: controlled_vocab_entries, controlled_vocab_entry_settings, and user_interests. To do that by interest name, you can use the query:
Code: Select all
DELETE ui, cve, cves FROM user_interests ui, controlled_vocab_entries cve, controlled_vocab_entry_settings cves, controlled_vocabs cv WHERE cv.symbolic='interest' AND cve.controlled_vocab_id = cv.controlled_vocab_id AND cves.controlled_vocab_entry_id = cve.controlled_vocab_entry_id AND ui.controlled_vocab_entry_id=cve.controlled_vocab_entry_id AND cves.setting_name='interest' AND cves.setting_value='Interest to remove';
...where "Interest to remove" is replaced as needed.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8674
Joined: Wed Aug 10, 2005 12:56 pm

Re: Disable Reviewing Interests Autocomplete

Postby uscguitarte » Tue Oct 01, 2013 4:37 pm

Hi Alec,

Your patch worked for our users. Thanks for suggesting that!

Will it be included in any official stable maintenance releases for the 2.x line or will we need to patch this again if theres another update to 2.x?

Best,
Chris
uscguitarte
 
Posts: 14
Joined: Mon Apr 29, 2013 4:53 pm

Re: Disable Reviewing Interests Autocomplete

Postby asmecher » Tue Oct 01, 2013 4:45 pm

Hi Chris,

Glad to hear it. That patch will be included in all future releases, in particular OJS 2.4.3, which should be out fairly soon.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8674
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Google [Bot], Yahoo [Bot] and 7 guests