Standard CSV Processing

Description

A variables or attributes of type blob representing a valid CSV file can be parsed to a collection of object instances by simply using the fromCsv built-in function. Please read through this page for clarity on what defines a "valid" CSV file.

Example

The code snippets below demonstrates how the fromCsv built-in function can be used populate a collection of Nurse object instances:

persistent object Clinic {
    string name;
}
 
persistent object Nurse {
	string first_name;
	string last_name;
 
	@ManyToOne
	Clinic clinic;
}
 
object UploadedFile {
    blob data;
}

 
 Nurse[] extractNurses(UploadedFile f) {
    return Nurse:fromCsv(f.data);
}

 first_name,last_name,clinic.name
Beatrice,Malherbe,Sonop Clinic
Pieter,Potgieter,Somerset Clinic

Additional Mentions and References

• Helium Tutorial Lesson 9
• Persistent Entity BIFs under Quick Reference