-
How to insert Account from Inbound email Attachment having Thousands of record?
I am creating Account from CSV file which is received from Inbound Email. It is throwing Regex too complicated error.
How should I resolve this problem? I have wrote following code –-
This discussion was modified 10 years, 1 month ago by
Ajay Prakash.
-
This discussion was modified 10 years, 1 month ago by Ajay Prakash.
-
This discussion was modified 8 years, 6 months ago by Forcetalks.
-
This discussion was modified 10 years, 1 month ago by
-
5 Replies
-
global class createAccountsFromMail implements Messaging.InboundEmailHandler{
global String MyFile{get;set;}
global String[] filelines = new String[]{};
global ListAccountList=new List (); global Messaging.InboundEmailResult handleInboundEmail(Messaging.InboundEmail email, Messaging.InboundEnvelope envelope){
Messaging.InboundEmailResult result = new Messaging.InboundEmailresult();
try{
System.debug(‘HELLO There’);
for(Messaging.Inboundemail.BinaryAttachment at : email.binaryAttachments){
System.debug(‘Mail contents’);
MyFile=at.body.toString().substring(0,5000);
filelines=MyFile.Split(‘\n’);
System.Debug(‘File Lines—-‘+filelines.size());
for(Integer i=1;i-
This reply was modified 10 years, 1 month ago by Ajay Prakash.
-
This reply was modified 10 years, 1 month ago by Ajay Prakash.
-
This reply was modified 10 years, 1 month ago by
- [adinserter block='9']
-
Complete code is not showing here.If someone need then I can mail.
-
This reply was modified 10 years, 1 month ago by Ajay Prakash.
-
This reply was modified 10 years, 1 month ago by
-
Try using batch class to execute the logic. Splitting the string by ‘\n’ also produce this issue so, need to avoid that.
-
Hi,
Also you have to go with some kind of integration tool (informatica, mulesoft) or scheduled data loaders (Command Line Interface of Data Loader) or import wizard.
-
Hi,
You can use apps present in app exchange, there might be a feature regarding it.
Hope this helps.
Log In to reply.
