-
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 9 years, 8 months ago by
Ajay Prakash.
-
This discussion was modified 9 years, 8 months ago by Ajay Prakash.
-
This discussion was modified 8 years, 1 month ago by Forcetalks.
-
This discussion was modified 9 years, 8 months 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 9 years, 8 months ago by Ajay Prakash.
-
This reply was modified 9 years, 8 months ago by Ajay Prakash.
-
This reply was modified 9 years, 8 months ago by
-
Complete code is not showing here.If someone need then I can mail.
-
This reply was modified 9 years, 8 months ago by Ajay Prakash.
-
This reply was modified 9 years, 8 months 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.
Popular Salesforce Blogs
API Versions in Salesforce - All You Need to Know
As a feature of a controlled Metadata API delivery and source control procedure, it is essential to see how API forms impact functioning examples, particularly…
An Ultimate Guide on How to Import Data in Salesforce
Data is an integral part of an everyday business and the effectiveness of its management determines whether the business will be a success or not.…
Optimizing Fleet and Delivery Management with Salesforce and IoT Tracking Integration
Fleet and delivery management has become more complex due to rising consumer expectations, fuel costs, and logistics disruptions. In fact, according to Deloitte, 79% of…
