Managers and students alike can create flashcards that are available to students for practice. However, importing large numbers of flashcards is reserved for managers.
Table of Contents
Register "Import cards"
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.
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:
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).
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.