Welcome to the SFDC99 mailbag!

Hi David, I want to do PD1 and PD2 ceritification, what will be needed..

Hi David Liu,

i am facing issue while I am uploading and processing above 3000 records using vf page. it’s throw the error like, onclick java script button or link was encountered and limit.system exception:Regex too complicated.

i am providing code and screen shot below please resolve this issue

javascript code:

{!REQUIRESCRIPT(“/soap/ajax/30.0/connection.js”)}
{!REQUIRESCRIPT(“/soap/ajax/30.0/apex.js”)}

sforce.apex.execute(“EUFileHandler”,”CSVparse”,{recordID:'{!Subscription_Upload__c.Id}’});
alert(“Fan Record(s) processed. Please find successful Fan uploads under the Subscription Uploads tab, and duplicate fan uploads under the Sub Upload Failures tab.”);

File handler:

global class EUFileHandler { // 12 th line

private static Subscription_Upload__c originalSU;

webservice static void CSVparse(ID recordID){

List originalSUlist = [SELECT ID, Mailing_List__c FROM Subscription_Upload__c WHERE ID =:recordID];

for(Subscription_Upload__c su : originalSUlist){
su.File_Processed__c=true;
update su;
}
List at = [SELECT ID, Body, Name FROM Attachment WHERE ParentID =:recordID];
System.Debug(‘ check at ‘+at);
System.Debug(at[0].Body);
originalSU = originalSUlist[0];
//Fan__c src;

parseAttachments(at); // 30 th line

}

global static void parseAttachments(list att){

List cObjsToInsert = new List();
List sub = new List();
List subh = new List();
String src;

for(attachment a: att){
List<List> parsedCSV;
try{
System.Debug(‘ check base64 ‘+a.Body.ToString());
parsedCSV = EUUploadUtil.parseCSV(a.Body.ToString(), true);// 46th line
System.Debug(‘ check parsedCSV ‘+parsedCSV);
} catch(StringException e) {
System.Debug(‘StringException caught: Please encode the attached CSV file in UTF-8 format, and try again! ‘ + e.getMessage());
}

for(List line:parsedCSV){
System.Debug(‘ check line ‘+line);

Fan__c c = new Fan__c();
if (line.size()>6){

c.Name=line[5]+’ ‘+line[6];
c.First_Name__c=line[5];
c.Last_Name__c=line[6];
}
if(String.IsNotBlank(line[0])){
c.Email__c=line[0];
} else {
c.Email__c=’No email provided’;

}
if (line.size()>4){
if(String.IsNotBlank(line[4])){
c.Source__c=line[4];
} else {
c.Source__c=’No source provided’;

}
}
if(line.size()>7){
c.Mobile_Phone__c=line[7];
}
if(line.size()>8 && string.IsNotBlank(line[8])){
c.Birthdate__c=date.parse(line[8]);
}
if(line.size()>9){
c.Gender__c=line[9];
}
if(line.size()>10){
c.Address_1__c=line[10];
}
if(line.size()>11){
c.City__c=line[11];
}
if(line.size()>12){
c.State__c=line[12];
}
if(line.size()>13){
c.Country_Region__c=line[13];
}
if(line.size()>14){
c.Postal_Code__c=line[14];
}
if(line.size()>15){
c.Preferred_Language__c=line[15];
}
if(line.size()>16){
c.Facebook_Page__c=line[16];
}
if(line.size()>17){
c.Twitter_Handle__c=line[17];
}
if(line.size()>18){
c.MyspaceId__c=line[18];
}

c.Subscription_Upload_source__c=originalSU.ID;
src = c.Source__c;
cObjsToInsert.Add(c);
}

}

Set emails = new Set();
System.Debug(‘SET’ + emails);
Map fanMap = new Map();
List newF = new List();
List dupeList = new List();

for(Fan__c f : cObjsToInsert) {
emails.Add(f.Email__c);
System.Debug(‘check email ‘+f.Email__c);
}

List ef = [SELECT ID, Name, Email__c FROM Fan__c WHERE Email__c IN : emails];
for(Fan__c existingFan : ef) {
fanMap.put(existingFan.Email__c.toLowerCase(), existingFan);
System.Debug(‘check existing fan ‘+existingFan);
}

for(Fan__c f : cObjsToInsert) {
System.Debug(‘check email ‘+f.Email__c);
System.Debug(‘check Name ‘+f.Name);
if(!fanMap.containsKey(f.Email__c.toLowerCase()) && f.Email__c != ‘No email provided’) {
newF.Add(f);

} else {
SubUploadFailures__c d = new SubUploadFailures__c();
d.Name=f.Name;
d.Email__c=f.Email__c;
d.Mobile_Phone__c=f.Mobile_Phone__c;
d.Country_Region__c=f.Country_Region__c;
d.Source__c=f.Source__c;
d.Birthdate__c=f.Birthdate__c;
d.Gender__c=f.Gender__c;
d.Address1__c=f.Address_1__c;
d.Postal_Code__c=f.Postal_Code__c;
d.Preferred_Language__c=f.Preferred_Language__c;
d.Facebook_Page__c=f.Facebook_Page__c;
d.Twitter_Handle__c=f.Twitter_Handle__c;
d.Myspace_ID__c=f.MyspaceId__c;

dupeList.Add(d);
}
}

System.Debug(‘check newF ‘+newF);
System.Debug(‘check dupeList ‘+dupeList);

Database.insert(newF, false);
Database.insert(dupeList, false);

List nfa = [SELECT ID, Name, Email__c, Source__c FROM Fan__c WHERE ID IN : newF OR ID IN :ef];

for(Fan__c nf : nfa){
Subscription__c s = new Subscription__c();
s.Name= nf.Name;
s.Fan_ID__c=nf.ID;
s.Mailing_List_ID__c=originalSU.Mailing_List__c;
s.Source__c=src;
s.Active__c=true;

Subscription_History__c sh = new Subscription_History__c();
sh.Name=nf.Name;
sh.Fan_ID__c=nf.ID;
sh.Action__c=’Sign Up’;
sh.Mailing_List_ID__c=originalSU.Mailing_List__c;
sh.Source__c=src;

sub.Add(s);
subh.Add(sh);
}
System.Debug(‘ check cobjstoinsert ‘+cObjsToInsert);
System.Debug(‘check sub ‘+sub);
System.Debug(‘check subh ‘+subh);

Database.insert(sub, false);
Database.insert(subh, false);

}
}

Utill class :

public static list<list> parseCSV(String contents,Boolean skipHeaders) {
list<list> allFields = new List<List>();
// replace instances where a double quote begins a field containing a comma
// in this case you get a double quote followed by a doubled double quote
// do this for beginning and end of a field
contents = contents.replaceAll(‘,”””‘,’,”DBLQT’).replaceall(‘”””,’,’DBLQT”,’);//19 th line
// now replace all remaining double quotes – do this so that we can reconstruct
// fields with commas inside assuming they begin and end with a double quote
contents = contents.replaceAll(‘””‘,’DBLQT’);// 22 line
// we are not attempting to handle fields with a newline inside of them
// so, split on newline to get the spreadsheet rows
list lines=new list();
try {
lines = contents.split(‘\n’);
} catch (System.ListException e) {
System.debug(‘Limits exceeded? ‘+e.getMessage());
}
integer num=0;
for(string line :lines) {
// check for blank CSV lines (only commas)
if(line.replaceAll(‘,’,”).trim().length()==0)
break;
list fields=line.split(‘,’);
list cleanFields=new list();
string compositeField;
boolean makeCompositeField=false;
for(string field : fields) {
if(field.startsWith(‘”‘) && field.endsWith(‘”‘)) {
cleanFields.add(field.replaceAll(‘DBLQT’,'”‘).removeStart(‘”‘).removeEnd(‘”‘));
} else if(field.startsWith(‘”‘)) {
makeCompositeField = true;
compositeField = field;
} else if(field.endsWith(‘”‘)) {
compositeField += ‘,’ + field;
cleanFields.add(compositeField.replaceAll(‘DBLQT’,'”‘).removeStart(‘”‘).removeEnd(‘”‘));
makeCompositeField = false;
} else if(makeCompositeField) {
compositeField += ‘,’ + field;
} else{
cleanFields.add(field.replaceAll(‘DBLQT’,'”‘).removeStart(‘”‘).removeEnd(‘”‘));
}
}
allFields.add(cleanFields);
}
if(skipHeaders)
allFields.remove(0);
// allFields.remove(0);
return allFields;
}
public class EUUploadUtil {

public static list<list> parseCSV(String contents,Boolean skipHeaders) {
list<list> allFields = new List<List>();
// replace instances where a double quote begins a field containing a comma
// in this case you get a double quote followed by a doubled double quote
// do this for beginning and end of a field
contents = contents.replaceAll(‘,”””‘,’,”DBLQT’).replaceall(‘”””,’,’DBLQT”,’);
// now replace all remaining double quotes – do this so that we can reconstruct
// fields with commas inside assuming they begin and end with a double quote
contents = contents.replaceAll(‘””‘,’DBLQT’);// this is 19 th line of util class
// we are not attempting to handle fields with a newline inside of them
// so, split on newline to get the spreadsheet rows

// so, split on newline to get the spreadsheet rows
list lines=new list();
try {
lines = contents.split(‘\n’);
} catch (System.ListException e) {
System.debug(‘Limits exceeded? ‘+e.getMessage());
}
integer num=0;
for(string line :lines) {
// check for blank CSV lines (only commas)
if(line.replaceAll(‘,’,”).trim().length()==0)

[![System.LimitException Regex Too Complicated][1]][1]