tomcarman / sf-w2l-debugemail2csv

This is a script to convert Salesforce Web-to-Lead failure emails (eg. "Salesforce Could Not Create This Lead') into a csv for mass loading.

Salesforce W2L Debug Email -> CSV

This is a script to convert Salesforce Web-to-Lead failure emails (eg. "Salesforce Could Not Create This Lead') into a csv for mass loading.

It's pretty niche, and it's badly written in python. It should only be used when you have no other options.

Usage

• The script expects an input.txt of concatenated failure emails, example below.
• The script will create an output.csv of the record details that can be dataloaded.

Example input

Salesforce could not create this lead because of the reason listed below. For more information about this error or help with Web-to-Lead, please contact Customer Support.

Reason: {Stack trace reminding you of your dumb failure}

Lead Capture Page: xxx

Record Information:

    FirstName = Test
    LastName = Lead 
    email = [email protected]
    Website = www.oops.com
    Some_Custom_Field__c = 'blah'

To incorporate this lead into salesforce.com you can key in the data above.

------------------------------------------------------------------------

Salesforce could not create this lead because of the reason listed below. For more information about this error or help with Web-to-Lead, please contact Customer Support.

Reason: {Stack trace reminding you of your dumb failure}

Lead Capture Page: xxx

Record Information:

    FirstName = Test
    LastName = Lead 
    email = [email protected]
    Website = www.oops.com
    Some_Custom_Field__c = 'blah'

To incorporate this lead into salesforce.com you can key in the data above.

If you have any questions, please click on Support at the top right of any page within salesforce.com.

Customer Support
salesforce.com

------------------------------------------------------------------------

Salesforce could not create this lead because of the reason listed below. For more information about this error or help with Web-to-Lead, please contact Customer Support.

Reason: {Stack trace reminding you of your dumb failure}

Lead Capture Page: xxx

Record Information:

    FirstName = Test
    LastName = Lead 
    email = [email protected]
    Website = www.oops.com
    Some_Custom_Field__c = 'blah'

To incorporate this lead into salesforce.com you can key in the data above.

If you have any questions, please click on Support at the top right of any page within salesforce.com.

Customer Support
salesforce.com