Convert Vocabulary to Quiz using java code with csv parser

When converting a vocabulary list with two columns (words and definitions) from a .csv file to a quiz format, you can use a specific code to achieve this. The process involves converting the .csv file to a quiz type and then uploading it to forceteach.com

import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import java.util.Collections;

public class CSVParserVocabolarytoQuiz {
	public static boolean reverseColum1And2 = false;
	public static boolean japanOptions = false;

	private static final String 
	csvFile = "/Users/jhovarie/Desktop/forceteach/nihongo/jp_n5_voc_page10.csv";
	private static final boolean SKIP_HEADER = true;
	private static final String NewHeader = "Question,opt1,opt2,opt3,opt4"; //make it "" or null if no custom header
	private static StringBuilder strb = new StringBuilder();
	private static ArrayList<String> vocabolaryTemp = new ArrayList<>();
	private static ArrayList<String> vocabolaryTemp2 = new ArrayList<>();
	private static ArrayList<String> vocabolaryTemp3 = new ArrayList<>();
	public static String modifyFileName(String filePath) {
        File file = new File(filePath);
        String fileName = file.getName();
        String extension = "";
        int dotIndex = fileName.lastIndexOf('.');
        if (dotIndex > 0 && dotIndex < fileName.length() - 1) {
            extension = fileName.substring(dotIndex);
            fileName = fileName.substring(0, dotIndex); // File name without extension
        }
        String newFileName = fileName + "_result" + extension;
        String newFilePath = file.getParent() + File.separator + newFileName;
        return newFilePath;
    }

	public static void main(String[] args) throws IOException {
		String line;
		String csvDelimiter = ",";
		List<String[]> data = new ArrayList<>();

		try (BufferedReader br = new BufferedReader(new FileReader(csvFile))) {
			int lineNumber = 0;
			while ((line = br.readLine()) != null) {
				if (lineNumber == 0 && SKIP_HEADER) {
					lineNumber++;
					continue;
				}
				String[] values = line.split(csvDelimiter);
				for (int columnIndex = 0; columnIndex < values.length; columnIndex++) {
					if (columnIndex == 0) {
						//System.out.print(lineNumber + ") ");
					}
					if (columnIndex == 0) {
						//System.out.print(values[0] + ",");
					}
					if (columnIndex == 1) {
						if(reverseColum1And2) {
							vocabolaryTemp.add(values[0]);
							vocabolaryTemp2.add(values[0]);
							vocabolaryTemp3.add(values[0]);
						} else {
							vocabolaryTemp.add(values[1]);
							vocabolaryTemp2.add(values[1]);
							vocabolaryTemp3.add(values[1]);
						}
					}
				}
				data.add(values);
				lineNumber++;
			}
		}
		System.out.println("=========================================== ");
		Collections.shuffle(vocabolaryTemp);
		Collections.shuffle(vocabolaryTemp2);
		Collections.shuffle(vocabolaryTemp3);
		for (int rowIndex = 0; rowIndex < data.size(); rowIndex++) {
			if (rowIndex == 0 && !NewHeader.isEmpty()) {
				System.out.println(NewHeader);
				strb.append(NewHeader+"\n");
			}
			String[] row = data.get(rowIndex);
			for (int columnIndex = 0; columnIndex < row.length; columnIndex++) {
				if (columnIndex == 0) {
					System.out.print(reverseColum1And2? row[1] : row[0] + ",");
				}
				if (columnIndex == 1) {
					String option1 = reverseColum1And2? row[0] : row[1]; // Option 1 is fixed
					String option2 = vocabolaryTemp.get(rowIndex);
					String option3 = vocabolaryTemp2.get(rowIndex);
					String option4 = vocabolaryTemp3.get(rowIndex);
					// Ensure option2 is unique compared to option1
					while (option2.equals(option1)) {
						Collections.shuffle(vocabolaryTemp);
						option2 = vocabolaryTemp.get(rowIndex);
					}
					// Ensure option3 is unique compared to option1 and option2
					while (option3.equals(option1) || option3.equals(option2)) {
						Collections.shuffle(vocabolaryTemp2);
						option3 = vocabolaryTemp2.get(rowIndex);
					}
					// Ensure option4 is unique compared to option1, option2, and option3
					while (option4.equals(option1) || option4.equals(option2) || option4.equals(option3)) {
						Collections.shuffle(vocabolaryTemp3);
						option4 = vocabolaryTemp3.get(rowIndex);
					}
					strb.append(reverseColum1And2?row[1]+",":row[0]+",");
					if(japanOptions) {
						System.out.print("opt1="+japanCharacterOnly(option1) + ","); // Option 1
						System.out.print("opt2="+japanCharacterOnly(option2) + ","); // Option 2
						System.out.print("opt3="+japanCharacterOnly(option3) + ","); // Option 3
						System.out.print("opt4="+japanCharacterOnly(option4) + " "); // Option 4
						strb.append(japanCharacterOnly(option1)+",");
						strb.append(japanCharacterOnly(option2)+",");
						strb.append(japanCharacterOnly(option3)+",");
						strb.append(japanCharacterOnly(option4)+"\n");
					} else {
						System.out.print("opt1="+option1 + ","); // Option 1
						System.out.print("opt2="+option2 + ","); // Option 2
						System.out.print("opt3="+option3 + ","); // Option 3
						System.out.print("opt4="+option4 + " "); // Option 4
						strb.append(option1+",");
						strb.append(option2+",");
						strb.append(option3+",");
						strb.append(option4+"\n");
					}
				}
				if (columnIndex == 1) {
					System.out.println();
				}
			}
		}
		String resultFilePath = modifyFileName(csvFile);
		try (FileWriter fileWriter = new FileWriter(resultFilePath)) {
            fileWriter.write(strb.toString());
            fileWriter.flush();
            fileWriter.close();
            System.out.println("Data successfully saved to " + resultFilePath);
        } catch (IOException e) {
            System.out.println("An error occurred while writing to the file.");
            e.printStackTrace();
        }

	}
	public static String japanCharacterOnly(String input) {
        String regex = "[\\p{IsHiragana}\\p{IsKatakana}\\p{IsHan}]+";
        StringBuilder result = new StringBuilder();
        for (char c : input.toCharArray()) {
            if (String.valueOf(c).matches(regex)) {
                result.append(c);
            }
        }
        if(japanOptions) {
        	return result.toString();
        }
        return input;
    }
}


When considering the conversion of a .csv file for use with forceteach.com, it's important to note that the first and second columns in the converted file are exact copies of the original .csv. Additionally, the code provided specifically adds wrong answers for columns 3, 4, and 5. This means that the primary purpose of the code is to introduce incorrect options for the quiz questions, enhancing the learning process.

After the conversion process, the resulting .csv file is ready for upload to forceteach.com. It's important to highlight that forceteach.com will handle the shuffling of questions and options for the user, providing an interactive and dynamic learning experience.

By maintaining the original column data and incorporating incorrect options, the converted .csv file becomes a valuable resource for creating engaging and effective quizzes on forceteach.com.

If you have any further questions or need additional assistance, feel free to ask!

Additional search keyword: vocabulary to quiz converter, convert to quiz, voc to quiz, java csv parse

Last update on Aug 07, 2024

Tags: java,csv,vocabulary,quiz