import java.io.BufferedReader;

import java.io.FileReader;

import java.io.IOException;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

public class FormSubmissionImporter {

public static List<Map<String, String>> importFormSubmissions(String filePath) {

List<Map<String, String>> submissions = new ArrayList<>();

String line;

try (BufferedReader reader = new BufferedReader(new FileReader(filePath))) {

// Skip the header line (assuming it exists)

reader.readLine();

while ((line = reader.readLine()) != null) {

String[] parts = line.split(","); // Assuming comma-separated values

// Create a map to store the data for each submission

Map<String, String> submission = new HashMap<>();

// Populate the map with data from each column

for (int i = 0; i < parts.length; i++) {

if (i < parts.length) {

submission.put(String.format("field%d", i + 1), parts[i].trim());

}

}

submissions.add(submission);

}

} catch (IOException e) {

System.err.println("Error reading file: " + e.getMessage());

}

return submissions;

}

public static void main(String[] args) {

//Example usage

String filePath = "form_submissions.csv"; // Replace with your file path

List<Map<String, String>> submissions = importFormSubmissions(filePath);

for (Map<String, String> submission : submissions) {

System.out.println(submission);

}

}

}