Skip to content

Instantly share code, notes, and snippets.

@magnet88jp
Created November 21, 2014 08:13
Show Gist options
  • Select an option

  • Save magnet88jp/a6a07e791083ab2be962 to your computer and use it in GitHub Desktop.

Select an option

Save magnet88jp/a6a07e791083ab2be962 to your computer and use it in GitHub Desktop.
implement via OpenCsvParser
public with sharing class PlanetImportSample2Ctrl {
public DataImportHistory__c dih { get; set; }
public PlanetImportSample2Ctrl() {
System.debug('IN PlanetImportSample2Ctrl');
dih = new DataImportHistory__c();
}
public PageReference createData() {
System.debug('IN createData');
String contents = dih.ImportData__c;
OpenCSVParser parser = new OpenCSVParser(
'\t',
OpenCSVParser.DEFAULT_QUOTE_CHARACTER,
OpenCSVParser.DEFAULT_ESCAPE_CHARACTER,
OpenCSVParser.DEFAULT_STRICT_QUOTES,
OpenCSVParser.DEFAULT_IGNORE_LEADING_WHITESPACE
);
OpenCsvReader reader = new OpenCSVReader(parser, contents, '\n');
List<List<String>> result = reader.readAll();
System.debug('result=' + result);
Integer i = 0;
Integer j = 0;
List<ImportData__c> dataList = new List<ImportData__c>();
for(List<String> resultItems : result) {
j = 0;
ImportData__c data = new ImportData__c();
for(String resultItem : resultItems) {
System.debug('i=' + i + '; j=' + j + '; result=' + resultItem);
if( j == 0) {
data.Data1__c = resultItem;
} else if( j == 1 ) {
data.Data2__c = resultItem;
} else if( j == 2 ) {
data.Data3__c = resultItem;
}
j++;
}
dataList.add(data);
i++;
}
insert dataList;
dih.ImportData__c = '';
return null;
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment