Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Supported by

[solved] load loop items from .xtl sheet for questionnaire

edited March 2014 in OpenSesame

Dear all,

thank you for this opportunity to ask.

For a questionnaire that I am using I would like to implement the possibility to easily change the questions items (eg. different languages). Is it possible to load 1. the instructions from a .doc and 2. the items for the loop from an .xl sheet instead of manually adding them?

I found the 'import' and 'text' functions, but I do not see how to implement it in the loop.

Kind regards

Comments

  • edited 6:17PM

    Hi Griff,

    Sure, you can read the contents from a text file and do all kinds of things with it. In your case, you probably want to set some variables based on the contents of a text file. Then you can use these variables to specify the contents of your form.

    To give a general idea, let's assume that you have a file called form.txt in your file pool, and that it has a form title on the first line and a form question on the second. You can then read this file and set the variables my_title and my_question based on its contents, like so:

    # Get full path to form.txt in the file pool
    path = exp.get_file('form.txt')
    # Open the file
    f = open(path)
    # Read file contents
    contents = f.read()
    # Split file contents by line and store as a list of lines
    lines = contents.split('\n')
    # Set `my_title` to the first line, and `my_question` to the second
    exp.set('my_title', lines[0])
    exp.set('my_question', lines[1])
    

    Next, you can use the square-brackets notation in a form_text_input to indicate that you want to use [my_title] and [my_question] for respectively the title and the question.

    In general, you would do something like this. But you'll have to adapt it to your specific situation, which will require some knowledge of Python:

    And if you have a more specific question, feel free to post it here.

    Note also that you generally use plain-text files (.txt, .csv, etc.), instead of .doc, .xls, or things like that. Plain-text is much easier to read and process. But Word and Excel can save in plain-text format, so this won't pose any difficulties.

    Cheers!
    Sebastiaan

  • edited 6:17PM

    Hi,
    thank you so much for helping out.
    ( I was a bit distracted with other things, thus the late reply).
    cheers!

Sign In or Register to comment.

agen judi bola , sportbook, casino, togel, number game, singapore, tangkas, basket, slot, poker, dominoqq, agen bola. Semua permainan bisa dimainkan hanya dengan 1 ID. minimal deposit 50.000 ,- bonus cashback hingga 10% , diskon togel hingga 66% bisa bermain di android dan IOS kapanpun dan dimana pun. poker , bandarq , aduq, domino qq , dominobet. Semua permainan bisa dimainkan hanya dengan 1 ID. minimal deposit 10.000 ,- bonus turnover 0.5% dan bonus referral 20%. Bonus - bonus yang dihadirkan bisa terbilang cukup tinggi dan memuaskan, anda hanya perlu memasang pada situs yang memberikan bursa pasaran terbaik yaitu http://45.77.173.118/ Bola168. Situs penyedia segala jenis permainan poker online kini semakin banyak ditemukan di Internet, salah satunya TahunQQ merupakan situs Agen Judi Domino66 Dan BandarQ Terpercaya yang mampu memberikan banyak provit bagi bettornya. Permainan Yang Di Sediakan Dewi365 Juga sangat banyak Dan menarik dan Peluang untuk memenangkan Taruhan Judi online ini juga sangat mudah . Mainkan Segera Taruhan Sportbook anda bersama Agen Judi Bola Bersama Dewi365 Kemenangan Anda Berapa pun akan Terbayarkan. Tersedia 9 macam permainan seru yang bisa kamu mainkan hanya di dalam 1 ID saja. Permainan seru yang tersedia seperti Poker, Domino QQ Dan juga BandarQ Online. Semuanya tersedia lengkap hanya di ABGQQ. Situs ABGQQ sangat mudah dimenangkan, kamu juga akan mendapatkan mega bonus dan setiap pemain berhak mendapatkan cashback mingguan. ABGQQ juga telah diakui sebagai Bandar Domino Online yang menjamin sistem FAIR PLAY disetiap permainan yang bisa dimainkan dengan deposit minimal hanya Rp.25.000. DEWI365 adalah Bandar Judi Bola Terpercaya & resmi dan terpercaya di indonesia. Situs judi bola ini menyediakan fasilitas bagi anda untuk dapat bermain memainkan permainan judi bola. Didalam situs ini memiliki berbagai permainan taruhan bola terlengkap seperti Sbobet, yang membuat DEWI365 menjadi situs judi bola terbaik dan terpercaya di Indonesia. Tentunya sebagai situs yang bertugas sebagai Bandar Poker Online pastinya akan berusaha untuk menjaga semua informasi dan keamanan yang terdapat di POKERQQ13. Kotakqq adalah situs Judi Poker Online Terpercayayang menyediakan 9 jenis permainan sakong online, dominoqq, domino99, bandarq, bandar ceme, aduq, poker online, bandar poker, balak66, perang baccarat, dan capsa susun. Dengan minimal deposit withdraw 15.000 Anda sudah bisa memainkan semua permaina pkv games di situs kami. Jackpot besar,Win rate tinggi, Fair play, PKV Games