Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

bulk edit the questiontype
(1 viewing) (1) Guest
component
Go to bottomPage: 1
TOPIC: bulk edit the questiontype
#9342
bulk edit the questiontype 13 Years, 7 Months ago Karma: 0
I made lots of questions allready.
I used the "multiple question" template.
But this was a mistake
Is there a way to change all those questiontypes at once to "single question"-type? (so that I dont need to change each question seperately!)

regards,
Andre
atr
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#9365
Re:bulk edit the questiontype 13 Years, 6 Months ago Karma: 748
Hello,

Could you provide more information that we can help? Do you want to change all "Multiple Question" to "Single Question" or questions from specific quiz, category? Have users taken quizzes with these questions or not?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#9385
Re:bulk edit the questiontype 13 Years, 6 Months ago Karma: 0
yes I want to change all Multiple questions to Single questions.
Few users have taken the quizzes, but its no problem if I have to delete these results.

regards
Andre
atr
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#9422
Re:bulk edit the questiontype 13 Years, 6 Months ago Karma: 748
Delete quizzes results on "Quiz Results" page on the component backend and execute the following SQL query (for example in PHPMyAdmin application which usually includes into hosting panel):

Code:


UPDATE
  jos_ariquizquestionversion QV INNER JOIN jos_ariquizquestion Q
    ON QV.QuestionVersionId = Q.QuestionVersionId
SET
  QV.QuestionTypeId = 1,
  Q.QuestionTypeId = 1
WHERE
  QV.QuestionTypeId = 2



PS: We recommended to create database backup before executing SQL query.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#9447
Re:bulk edit the questiontype 13 Years, 6 Months ago Karma: 0
thanks! it worked!

regards,
Andre
atr
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1