Standard CSV Processing

Owned by Former user (Deleted)
Last updated: Dec 06, 2018 by Jacques Marais

 

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:

Related model objects
persistent object Clinic {
    string name;
}
 
persistent object Nurse {
	string first_name;
	string last_name;
 
	@ManyToOne
	Clinic clinic;
}
 
object UploadedFile {
    blob data;
}
Unit function using fromCsv
 
 Nurse[] extractNurses(UploadedFile f) {
    return Nurse:fromCsv(f.data);
}
Example CSV file
 first_name,last_name,clinic.name
Beatrice,Malherbe,Sonop Clinic
Pieter,Potgieter,Somerset Clinic

 

 

 

Additional Mentions and References

Â