Forum Discussion
Rise 360 - Mass upload of questions into a question bank
If you know someone competent with Python, you can automate this. I successfully achieved this using Python and a well-structured .xlsx file that contained my questions.
- PeterSprague110 days agoCommunity Member
I wonder if I can get copilot to generate the code for me?
How do I:
1. Get the format I need for the excel file?2. Get the access (API?) into my Rise course to point the Python at?
Do you think this is a feasible solution for someone who DOESN'T know Python?- PaulMc19 days agoCommunity Member
The approach doesn't use API at all. It uses Selenium to automate the browser UI exactly as we would by clicking "Add question," selecting options, tabbing between fields, and pasting text from an Excel file.
The Excel file just needs to be a standard .xlsx with each column mapped to a question field (title, answer choices, feedback, etc.) Python reads the file locally using openpyxl, so no special API access is required.
Copilot can absolutely help generate the script, but you still need PY installed and must run automation locally in a browser session where you log in manually.
NB: The approach isn't future-proof. It relies on the current interface and tab order. If the UI is updated, the automation doesn't work.- KayneishaW9 days agoCommunity Member
Hi Paul. I literally just used AI to create a python script to turn LearnDash wpProQuiz XML exports into CSV files I could convert to XLS files because I was mistaken that Rise could do the XLS imports. It's a perfect conversion that works in seconds and is now pretty much useless without that last step.
Would you be able to video demo your process on a dummy file and share with the community?
Related Content
- 11 months ago
- 1 year ago