You need to sign in to do that
Don't have an account?
vivworld
batch class help very urgent
I have 3 fields in contact object like FirstName , LastName, Email. I have more then 1000 records. I want to write batch apex class , so that after running that batch class contact FirstName from first row will tale Contact LastName from 2nd row. Contact LastName from first row will take Contact FirstName from 3 rd row, and Contact Email from first row will take Contact Email from 4 th row...and vice versa. We r using this . Can you please share me the batch apex class for this. It would be great help if you can help me or guide me. This is very very urgent. below is the code written by me:-
I have 3 fields in contact object like FirstName , LastName, Email. I have more then 1000 records. I want to write batch apex class , so that after running that batch class contact FirstName from first row will tale Contact LastName from 2nd row. Contact LastName from first row will take Contact FirstName from 3 rd row, and Contact Email from first row will take Contact Email from 4 th row...and vice versa. We r using this . Can you please share me the batch apex class for this. It would be great help if you can help me or guide me. This is very very urgent.
global class UpdatesObjectFields implements Database.Batchable<sObject> {
global Database.QueryLocator start(Database.BatchableContext bc)
{
String query= 'SELECT FirstName, LastName, OtherStreet,OtherCity,OtherState,OtherPostalCode,OtherCountry,OtherStateCode,OtherCountryCode,OtherLatitude,OtherLongitude,OtherGeocodeAccuracy,MailingStreet,MailingCity,MailingState,MailingPostalCode,MailingCountry,MailingStateCode,MailingCountryCode,MailingLatitude,MailingLongitude,MailingGeocodeAccuracy,Phone,Fax,MobilePhone,HomePhone,OtherPhone,AssistantPhone,Email,Birthdate,Description,Middle_Name__c,Email_2nd__c,Gender__c,Last_Contact_Number__c from Contact';
return Database.getQueryLocator(query);
}
global void execute(Database.BatchableContext bc, List<Contact> cnct)
{
Contact[] con = new List<Contact>();
List<Contact> my_list = new List<Contact>();
List<Contact> my_list1 = new List<Contact>();
my_list = cnct;
my_list1 = my_list;
Contact ct = new Contact();
for (integer i=0; i<cnct.size();i++ )
{
ct = my_list[i];
integer j=0;
if(i+1 >=my_list.size())
{
ct.FirstName = my_list1[j].FirstName;
}
else
{
ct.FirstName = my_list[i+1].FirstName;
}
if(i+2 >=my_list.size())
{
ct.LastName = my_list1[j].LastName;
}
else
{
ct.LastName = my_list[i+2].LastName;
}
if(i+3 >=my_list.size())
{
ct.OtherStreet = my_list1[j].OtherStreet;
}
else
{
ct.OtherStreet = my_list[i+3].OtherStreet;
}
if(i+4 >=my_list.size())
{
ct.OtherCity = my_list1[j].OtherCity;
}
else
{
ct.OtherCity = my_list[i+4].OtherCity;
}
if(i+5 >=my_list.size() )
{
ct.OtherState = my_list1[j].OtherState;
}
else
{
ct.OtherState = my_list[i+5].OtherState;
}
if(i+6 >=my_list.size())
{
ct.OtherPostalCode = my_list1[j].OtherPostalCode;
}
else
{
ct.OtherPostalCode = my_list[i+6].OtherPostalCode;
}
if(i+7 >=my_list.size())
{
ct.OtherCountry = my_list1[j].OtherCountry;
}
else
{
ct.OtherCountry = my_list[i+7].OtherCountry;
}
if(i+8 >=my_list.size() )
{
ct.OtherStateCode = my_list1[j].OtherStateCode;
}
else
{
ct.OtherStateCode = my_list[i+8].OtherStateCode;
}
if(i+9 >=my_list.size())
{
ct.OtherCountryCode = my_list1[j].OtherCountryCode;
}
else
{
ct.OtherCountryCode = my_list[i+9].OtherCountryCode;
}
if(i+10 >=my_list.size())
{
ct.OtherLatitude = my_list1[j].OtherLatitude;
}
else
{
ct.OtherLatitude = my_list[i+10].OtherLatitude;
}
if(i+11 >=my_list.size())
{
ct.OtherLongitude = my_list1[j].OtherLongitude;
}
else
{
ct.OtherLongitude = my_list[i+11].OtherLongitude;
}
if(i+12 >=my_list.size() )
{
ct.OtherGeocodeAccuracy = my_list1[j].OtherGeocodeAccuracy;
}
else
{
ct.OtherGeocodeAccuracy = my_list[i+12].OtherGeocodeAccuracy;
}
/* if(i+13 >=my_list.size())
{
ct.OtherAddress = my_list1[j].OtherAddress;j++;
}
else
{
ct.OtherAddress = my_list[i+13].OtherAddress;
} */
if(i+14 >=my_list.size())
{
ct.MailingStreet = my_list1[j].MailingStreet;
}
else
{
ct.MailingStreet = my_list[i+14].MailingStreet;
}
if(i+15 >=my_list.size())
{
ct.MailingCity = my_list1[j].MailingCity;j++;
}
else
{
ct.MailingCity = my_list[i+15].MailingCity;
}
if(i+16 >=my_list.size() )
{
ct.MailingState = my_list1[j].MailingState;
}
else
{
ct.MailingState = my_list[i+16].MailingState;
}
if(i+17 >=my_list.size() )
{
ct.MailingPostalCode = my_list1[j].MailingPostalCode;
}
else
{
ct.MailingPostalCode = my_list[i+17].MailingPostalCode;
}
if(i+18 >=my_list.size())
{
ct.MailingCountry = my_list1[j].MailingCountry;
}
else
{
ct.MailingCountry = my_list[i+18].MailingCountry;
}
if(i+19 >=my_list.size() )
{
ct.MailingStateCode = my_list1[j].MailingStateCode;
}
else
{
ct.MailingStateCode = my_list[i+19].MailingStateCode;
}
if(i+20 >=my_list.size())
{
ct.MailingCountryCode = my_list1[j].MailingCountryCode;
}
else
{
ct.MailingCountryCode = my_list[i+20].MailingCountryCode;
}
if(i+21 >=my_list.size() )
{
ct.MailingLatitude = my_list1[j].MailingLatitude;
}
else
{
ct.MailingLatitude = my_list[i+21].MailingLatitude;
}
if(i+22 >=my_list.size() )
{
ct.MailingLongitude = my_list1[j].MailingLongitude;
}
else
{
ct.MailingLongitude = my_list[i+22].MailingLongitude;
}
if(i+23 >=my_list.size() )
{
ct.MailingGeocodeAccuracy = my_list1[j].MailingGeocodeAccuracy;
}
else
{
ct.MailingGeocodeAccuracy = my_list[i+23].MailingGeocodeAccuracy;
}
/* if(i+24 >=my_list.size())
{
ct.MailingAddress = my_list1[j].MailingAddress;j++;
}
else
{
ct.MailingAddress = my_list[i+24].MailingAddress;
} */
if(i+25 >=my_list.size())
{
ct.Phone = my_list1[j].Phone;
}
else
{
ct.Phone = my_list[i+25].Phone;
}
if(i+26 >=my_list.size())
{
ct.Fax = my_list1[j].Fax;j++;
}
else
{
ct.Fax = my_list[i+26].Fax;
}
if(i+27 >=my_list.size())
{
ct.MobilePhone = my_list1[j].MobilePhone;
}
else
{
ct.MobilePhone = my_list[i+27].MobilePhone;
}
if(i+28 >=my_list.size())
{
ct.HomePhone = my_list1[j].HomePhone;
}
else
{
ct.HomePhone = my_list[i+28].HomePhone;
}
if(i+29 >=my_list.size())
{
ct.OtherPhone = my_list1[j].OtherPhone;
}
else
{
ct.OtherPhone = my_list[i+29].OtherPhone;
}
if(i+30 >=my_list.size())
{
ct.AssistantPhone = my_list1[j].AssistantPhone;j++;
}
else
{
ct.AssistantPhone = my_list[i+30].AssistantPhone;
}
if(i+31 >=my_list.size())
{
ct.Email = my_list1[j].Email;j++;
}
else
{
ct.Email = my_list[i+31].Email;
}
if(i+32 >=my_list.size() )
{
ct.Birthdate = my_list1[j].Birthdate;j++;
}
else
{
ct.Birthdate = my_list[i+32].Birthdate;
}
if(i+33 >=my_list.size())
{
ct.Description = my_list1[j].Description;j++;
}
else
{
ct.Description = my_list[i+33].Description;
}
/* if(i+34 >=my_list.size())
{
ct.PhotoUrl = my_list1[j].PhotoUrl;j++;
}
else
{
ct.PhotoUrl = my_list[i+34].PhotoUrl;
} */
if(i+35 >=my_list.size())
{
ct.Middle_Name__c = my_list1[j].Middle_Name__c;j++;
}
else
{
ct.Middle_Name__c = my_list[i+35].Middle_Name__c;
}
if(i+36 >=my_list.size())
{
ct.Email_2nd__c = my_list1[j].Email_2nd__c;j++;
}
else
{
ct.Email_2nd__c = my_list[i+36].Email_2nd__c;
}
if(i+37 >=my_list.size())
{
ct.Gender__c = my_list1[j].Gender__c;j++;
}
else
{
ct.Gender__c = my_list[i+37].Gender__c;
}
if(i+38 >=my_list.size())
{
ct.Last_Contact_Number__c = my_list1[j].Last_Contact_Number__c;j++;
}
else
{
ct.Last_Contact_Number__c = my_list[i+38].Last_Contact_Number__c;
}
con.add(ct);
}
update con;
}
global void finish(Database.BatchableContext bc)
{
}
}
I have 3 fields in contact object like FirstName , LastName, Email. I have more then 1000 records. I want to write batch apex class , so that after running that batch class contact FirstName from first row will tale Contact LastName from 2nd row. Contact LastName from first row will take Contact FirstName from 3 rd row, and Contact Email from first row will take Contact Email from 4 th row...and vice versa. We r using this . Can you please share me the batch apex class for this. It would be great help if you can help me or guide me. This is very very urgent.
global class UpdatesObjectFields implements Database.Batchable<sObject> {
global Database.QueryLocator start(Database.BatchableContext bc)
{
String query= 'SELECT FirstName, LastName, OtherStreet,OtherCity,OtherState,OtherPostalCode,OtherCountry,OtherStateCode,OtherCountryCode,OtherLatitude,OtherLongitude,OtherGeocodeAccuracy,MailingStreet,MailingCity,MailingState,MailingPostalCode,MailingCountry,MailingStateCode,MailingCountryCode,MailingLatitude,MailingLongitude,MailingGeocodeAccuracy,Phone,Fax,MobilePhone,HomePhone,OtherPhone,AssistantPhone,Email,Birthdate,Description,Middle_Name__c,Email_2nd__c,Gender__c,Last_Contact_Number__c from Contact';
return Database.getQueryLocator(query);
}
global void execute(Database.BatchableContext bc, List<Contact> cnct)
{
Contact[] con = new List<Contact>();
List<Contact> my_list = new List<Contact>();
List<Contact> my_list1 = new List<Contact>();
my_list = cnct;
my_list1 = my_list;
Contact ct = new Contact();
for (integer i=0; i<cnct.size();i++ )
{
ct = my_list[i];
integer j=0;
if(i+1 >=my_list.size())
{
ct.FirstName = my_list1[j].FirstName;
}
else
{
ct.FirstName = my_list[i+1].FirstName;
}
if(i+2 >=my_list.size())
{
ct.LastName = my_list1[j].LastName;
}
else
{
ct.LastName = my_list[i+2].LastName;
}
if(i+3 >=my_list.size())
{
ct.OtherStreet = my_list1[j].OtherStreet;
}
else
{
ct.OtherStreet = my_list[i+3].OtherStreet;
}
if(i+4 >=my_list.size())
{
ct.OtherCity = my_list1[j].OtherCity;
}
else
{
ct.OtherCity = my_list[i+4].OtherCity;
}
if(i+5 >=my_list.size() )
{
ct.OtherState = my_list1[j].OtherState;
}
else
{
ct.OtherState = my_list[i+5].OtherState;
}
if(i+6 >=my_list.size())
{
ct.OtherPostalCode = my_list1[j].OtherPostalCode;
}
else
{
ct.OtherPostalCode = my_list[i+6].OtherPostalCode;
}
if(i+7 >=my_list.size())
{
ct.OtherCountry = my_list1[j].OtherCountry;
}
else
{
ct.OtherCountry = my_list[i+7].OtherCountry;
}
if(i+8 >=my_list.size() )
{
ct.OtherStateCode = my_list1[j].OtherStateCode;
}
else
{
ct.OtherStateCode = my_list[i+8].OtherStateCode;
}
if(i+9 >=my_list.size())
{
ct.OtherCountryCode = my_list1[j].OtherCountryCode;
}
else
{
ct.OtherCountryCode = my_list[i+9].OtherCountryCode;
}
if(i+10 >=my_list.size())
{
ct.OtherLatitude = my_list1[j].OtherLatitude;
}
else
{
ct.OtherLatitude = my_list[i+10].OtherLatitude;
}
if(i+11 >=my_list.size())
{
ct.OtherLongitude = my_list1[j].OtherLongitude;
}
else
{
ct.OtherLongitude = my_list[i+11].OtherLongitude;
}
if(i+12 >=my_list.size() )
{
ct.OtherGeocodeAccuracy = my_list1[j].OtherGeocodeAccuracy;
}
else
{
ct.OtherGeocodeAccuracy = my_list[i+12].OtherGeocodeAccuracy;
}
/* if(i+13 >=my_list.size())
{
ct.OtherAddress = my_list1[j].OtherAddress;j++;
}
else
{
ct.OtherAddress = my_list[i+13].OtherAddress;
} */
if(i+14 >=my_list.size())
{
ct.MailingStreet = my_list1[j].MailingStreet;
}
else
{
ct.MailingStreet = my_list[i+14].MailingStreet;
}
if(i+15 >=my_list.size())
{
ct.MailingCity = my_list1[j].MailingCity;j++;
}
else
{
ct.MailingCity = my_list[i+15].MailingCity;
}
if(i+16 >=my_list.size() )
{
ct.MailingState = my_list1[j].MailingState;
}
else
{
ct.MailingState = my_list[i+16].MailingState;
}
if(i+17 >=my_list.size() )
{
ct.MailingPostalCode = my_list1[j].MailingPostalCode;
}
else
{
ct.MailingPostalCode = my_list[i+17].MailingPostalCode;
}
if(i+18 >=my_list.size())
{
ct.MailingCountry = my_list1[j].MailingCountry;
}
else
{
ct.MailingCountry = my_list[i+18].MailingCountry;
}
if(i+19 >=my_list.size() )
{
ct.MailingStateCode = my_list1[j].MailingStateCode;
}
else
{
ct.MailingStateCode = my_list[i+19].MailingStateCode;
}
if(i+20 >=my_list.size())
{
ct.MailingCountryCode = my_list1[j].MailingCountryCode;
}
else
{
ct.MailingCountryCode = my_list[i+20].MailingCountryCode;
}
if(i+21 >=my_list.size() )
{
ct.MailingLatitude = my_list1[j].MailingLatitude;
}
else
{
ct.MailingLatitude = my_list[i+21].MailingLatitude;
}
if(i+22 >=my_list.size() )
{
ct.MailingLongitude = my_list1[j].MailingLongitude;
}
else
{
ct.MailingLongitude = my_list[i+22].MailingLongitude;
}
if(i+23 >=my_list.size() )
{
ct.MailingGeocodeAccuracy = my_list1[j].MailingGeocodeAccuracy;
}
else
{
ct.MailingGeocodeAccuracy = my_list[i+23].MailingGeocodeAccuracy;
}
/* if(i+24 >=my_list.size())
{
ct.MailingAddress = my_list1[j].MailingAddress;j++;
}
else
{
ct.MailingAddress = my_list[i+24].MailingAddress;
} */
if(i+25 >=my_list.size())
{
ct.Phone = my_list1[j].Phone;
}
else
{
ct.Phone = my_list[i+25].Phone;
}
if(i+26 >=my_list.size())
{
ct.Fax = my_list1[j].Fax;j++;
}
else
{
ct.Fax = my_list[i+26].Fax;
}
if(i+27 >=my_list.size())
{
ct.MobilePhone = my_list1[j].MobilePhone;
}
else
{
ct.MobilePhone = my_list[i+27].MobilePhone;
}
if(i+28 >=my_list.size())
{
ct.HomePhone = my_list1[j].HomePhone;
}
else
{
ct.HomePhone = my_list[i+28].HomePhone;
}
if(i+29 >=my_list.size())
{
ct.OtherPhone = my_list1[j].OtherPhone;
}
else
{
ct.OtherPhone = my_list[i+29].OtherPhone;
}
if(i+30 >=my_list.size())
{
ct.AssistantPhone = my_list1[j].AssistantPhone;j++;
}
else
{
ct.AssistantPhone = my_list[i+30].AssistantPhone;
}
if(i+31 >=my_list.size())
{
ct.Email = my_list1[j].Email;j++;
}
else
{
ct.Email = my_list[i+31].Email;
}
if(i+32 >=my_list.size() )
{
ct.Birthdate = my_list1[j].Birthdate;j++;
}
else
{
ct.Birthdate = my_list[i+32].Birthdate;
}
if(i+33 >=my_list.size())
{
ct.Description = my_list1[j].Description;j++;
}
else
{
ct.Description = my_list[i+33].Description;
}
/* if(i+34 >=my_list.size())
{
ct.PhotoUrl = my_list1[j].PhotoUrl;j++;
}
else
{
ct.PhotoUrl = my_list[i+34].PhotoUrl;
} */
if(i+35 >=my_list.size())
{
ct.Middle_Name__c = my_list1[j].Middle_Name__c;j++;
}
else
{
ct.Middle_Name__c = my_list[i+35].Middle_Name__c;
}
if(i+36 >=my_list.size())
{
ct.Email_2nd__c = my_list1[j].Email_2nd__c;j++;
}
else
{
ct.Email_2nd__c = my_list[i+36].Email_2nd__c;
}
if(i+37 >=my_list.size())
{
ct.Gender__c = my_list1[j].Gender__c;j++;
}
else
{
ct.Gender__c = my_list[i+37].Gender__c;
}
if(i+38 >=my_list.size())
{
ct.Last_Contact_Number__c = my_list1[j].Last_Contact_Number__c;j++;
}
else
{
ct.Last_Contact_Number__c = my_list[i+38].Last_Contact_Number__c;
}
con.add(ct);
}
update con;
}
global void finish(Database.BatchableContext bc)
{
}
}