You are located in service: RWTHmoodle

Import cards

Import cards

Kurzinformation

Managers and students alike can create flashcards that are available to students for practice. However, importing large numbers of flashcards is reserved for managers.


Detailinformation

Table of Contents

  1. Characteristics of the import file
  2. Create import file

Register "Import cards"

Screenshot: Manager's view of the cardbox activity tabs

The "Import Cards" tab allows managers to import cards via a CSV file. This import function is especially useful when a large number of cards are to be created at the same time and manually adding each card takes a lot of time. Note that it is not possible to import images and/or sound recordings via the import function. However, you can add missing images and/or sound recordings to flashcards via the "Edit" function at any time after uploading, if required. The upload of partial or alternative solutions and topic assignments is possible without any problems.

1. Characteristics of the import file

If you want to use upload via CSV file, the upload file must contain several column features. The columns must be labelled as follows:

  • ques = column caption for the question content.

  • qcontext = column caption for the context line of the question.

  • ans = column label for the solution text. Note: For alternative or partial solutions, use an independent column for each of these solutions, numbered consecutively, starting with "1", i.e. ans1, ans2, ans3, etc.

  • qcontext = column label for the context line of the answer.

  • topic = column label for the topic of the index card.

 
     

    Note

    If a question does not contain a topic or context line(s), no entry is required in the CSV file at the corresponding position. A missing topic assignment can alternatively be marked with the entry "null". Columns without entries can be omitted and are not required for upload.
     

    2. Create an import file

    Since manually creating an import file can be time-consuming and error-prone, it is recommended that you download one of the two files provided in the "Import Maps" tab. You can then use this as a template for your entries and add additional columns (e.g. column for further solution alternatives) if required. After saving, you can upload the CSV file back to the Cardfile activity.

    1. Download the appropriate CSV file. There are two templates available for download:

    If all the flashcards to be uploaded include max. one answer, choose the file example_singleans.csv

    If at least one of the flashcards to be uploaded contains more than one answer, select the file example_multians.csv

    2. Open the downloaded CSV file in a suitable program (e.g. Microsoft Excel). Note: The following explanations are based on illustrations of the file "example_multians.csv".

    3. The file contains the column characteristics and designations required for the subsequent upload in line 1 and some dummy entries in lines 2 to 5:

    Screenshot: Downloaded CSV file's contents

    These dummy entries only serve as an example of how the entries are to be made. Remove all dummy entries before filling the file, otherwise, this content will be created as flashcards after the upload. Note: The entry "null" in the topic column is not a dummy value, but indicates a missing topic assignment. If you do not want to assign a topic for a learning map, you can leave the corresponding field empty, or alternatively, make the entry "null".

    4. If necessary, add further columns for additional solution alternatives. Make sure to name them according to the scheme "ansx", where "x" stands for the column index of the solution column, e.g. "ans3".
     
    5. Make the necessary entries (exemplary entries in the following screenshot).

    Screenshot: Changed CSV file's contents

    6. Save the document as a CSV file.
     
    7. Upload the saved CSV file via "Select file..." or drag and drop the file into the upload window.
     
    8. Make sure that you have selected the correct CSV separator. Note: When using Microsoft Excel, the default separator in the editing language "German" is the semicolon. In this case, leave the preselected CSV separator unchanged.
     
    9. Encoding: Select the character encoding that will be used for the data. The default encoding is UTF-8.
     
    10. Click on Import maps. You will then be shown a preview of the import maps.
     
    11. If the content to be uploaded is displayed correctly, click "Import Cards" again. The successful import is indicated with a hint message.

     
       

      Note

      Flashcards uploaded via the import function are saved in the "Overview" tab immediately after their upload and are therefore immediately visible to all users of the flashcard box after uploading. A manual release of the flashcards via the tab "Release" is not necessary. If necessary, you can edit the imported flashcards in the "Overview" tab at any time by clicking on the pencil icon Editing button iconor delete them by clicking on the trash can icon Trashcan icon for deleting . By editing a flashcard, you can subsequently add images and/or sound recordings to a flashcard.

       Zusatzinformation

      See also:

      last changed on 11/16/2023

      How did this content help you?

      GNU General Public License 3
      This work is licensed under a GNU General Public License