I am a newbie to salesforce and have no clue as to what I am doing. Basically my client would like a script that integrates with salesforce capatures all the user details when they register and then sends them details to a mysql database

I know there must be a simple solution. Any help is much appreciated

thanks

shalli

Originally Posted by shalli

I am a newbie to salesforce and have no clue as to what I am doing. Basically my client would like a script that integrates with salesforce capatures all the user details when they register and then sends them details to a mysql database

I know there must be a simple solution. Any help is much appreciated

thanks

shalli

First Shalli thanks for joining the site, I appreciate it

There are a few things that you could do, but I need to know some more information first.

Is this form that users are filling out on a external web site? Are they filling the form out on a visualforce page and the data is being stored inside Salesforce.



Let me know what you are trying to do with a little more detail because I am sure I can help you out

~Mike

Hi mike

Thanks your reply. I am going to capture the data from a php form on a website which then sends the info to Salesforce and then the info is then stored in a mysql database.

Basically a customer is filling out a registeration form which is submitted to salesforce and then an activation email is sent via salesforce to the customer informing him of his username and randomly generated password. All this info is then sent to the mysql database.

Hope this makes sense

Hi mike

Not sure if this helps but I have created the following form in on the website

Code:

<div id="formwrapper" class="f1">
  <form method="post" action="<?php echo $this->formAction; ?>#main">
  
      <input type="hidden" name="fname" value="register" />
      <input type="hidden" name="affRetURL" value="<?php echo htmlspecialchars($this->retURL); ?>" />
      <input type="hidden" value="1" name="nosf"/>
        
        <div class="row"><p><strong>Your Details</strong></p></div>
        
        <div id="letAgent">
            <div class="row">
                <label for="title" class="label">Title:<span class="reqStar">*</span></label>
                <span class="forme">
                    <?php echo selectBox(
                                    'title', 
                                    array(
                                      'Mr'=>'Mr', 
                                      'Mrs'=>'Mrs',
                                      'Miss'=>'Miss',    
                                      'Ms'=>'Ms',
                                      'Dr'=>'Dr'
                                    ), 
                                    $this->ff->title 
                                ); 
                    ?>
                </span>
            </div>
        </div>
        
        <div class="row">
            <label for="firstName" class="label">First Name:<span class="reqStar">*</span></label>
            <span class="forme">
                <input name="firstName" id="firstName" type="text" class="text" value="<?php echo($this->ff->firstName);?>" />
                
            </span>
            <div class="clear" /></div>
        </div>

        <div class="row">
            <label for="lastName" class="label">Last Name:<span class="reqStar">*</span></label>
            <span class="forme">
                <input name="lastName" id="lastName" type="text" class="text" value="<?php echo($this->ff->lastName);?>" />
            </span>
        </div>

        <div class="row">
            <label for="phone" class="label">Telephone:<span class="reqStar">*</span></label>
            <span class="forme">
                <input name="phone" id="phone" type="text" class="text" value="<?php echo($this->ff->phone);?>" />
            </span>
        </div>

        <div class="row">
            <label for="mobile" class="label">Mobile:</label>
            <span class="forme">
                <input name="mobile" id="mobile" type="text" class="text" value="<?php echo($this->ff->mobile);?>" />
            </span>
        </div>

        <div class="row">
            <label for="email" class="label">Email:<span class="reqStar">*</span></label>
            <span class="forme">
                <input name="email" id="email" type="text" class="text" value="<?php echo($this->ff->email);?>" />
            </span>
        </div>
        
        <div class="row">
            <label for="addressLine1" class="label">Address Line 1:<span class="reqStar">*</span></label>
            <span class="forme">
                <input name="addressLine1" id="addressLine1" class="text" value="<?php echo($this->ff->addressLine1);?>" />
            </span>
        </div>
        
        <div class="row">
            <label for="addressLine2" class="label">Address Line 2:</label>
            <span class="forme">
                <input name="addressLine2" id="addressLine2" class="text" value="<?php echo($this->ff->addressLine2);?>" />
            </span>
        </div>
        
        <div class="row">
            <label for="city" class="label">City:<span class="reqStar">*</span></label>
            <span class="forme">
                <input name="city" id="city" class="text" value="<?php echo($this->ff->city);?>" />
            </span>
        </div>

        <div class="row">
            <label for="postcode" class="label">Postcode:<span class="reqStar">*</span></label>
            <span class="forme">
                <input name="postcode" id="postcode" type="text" class="text" value="<?php echo($this->ff->postcode);?>"/>
            </span>
        </div>
        
        <div class="row"><p><strong>Choose your password</strong></p></div>
        
          <div class="row">
            <span class="forme">
                <input type="submit" name="submitbtn" class="submit" value="Proceed &raquo;" />
            </span>
        </div>
        
       </form>
</div>

and created the following code for SF mappings

PHP Code:

<?php

$salesforceFieldsMap = array(
  'oid'=>'oid',
  'first_name'=>'first_name',
  'last_name'=>'last_name',
  'company'=>'company',
  'phone'=>'phone',
  'email'=>'email',
  'recordType' => 'recordType',
  '00N20000001vBra' => '00N20000001vBra',
  'ApplicantAddress'=>'00N200000025HDa',
  'MiddleName'=>'00N20000001v9p0',
  'TotalMonthlyRentOfProperty'=>'00N20000001v9p1',
  'TenancyTerm'=>'00N20000001v9pA',
  'StartDateOfAgreement'=>'00N20000001v9oh',
  'CheckIfApplicantIndividual'=>'00N20000001v9pF',
  'LeaseStartDate'=>'00N20000001v9pK',
  'LeaseLength'=>'00N20000001v9p2',
  'MonthlyRentalAmount'=>'00N20000001v9pL',
  'RentArrears'=>'00N20000001v9p3',
  'NoofProperties'=>'00N20000001v9pG',
  'LastKnownTenantFirstName'=>'00N20000001v9pP',
  'LastKnownTenantLastName'=>'00N20000001v9pU',
  'LastKnownTenantTelephone'=>'00N20000001v9pZ',
  'LastKnownTenantMobile'=>'00N20000001v9ml',
  'LastKnownTenantEmail'=>'00N20000001v9q3',
  'PropertyLegalAddress'=>'00N20000001v9no',

  'PropertyLegalAddressContd'=>'00N200000026h5D', 
  'PropertyLegalAddressCity'=>'00N200000026h5m',
  'PropertyLegalAddressCounty'=>'00N200000026h5I',
   
  'PropertyLegalPostCode'=>'00N20000001vBnx',
  'PropertyLegalCountry'=>'00N20000001v9np',
  'LastKnownAddress'=>'00N20000001v9oi',
  'LastKnownPostcode'=>'00N20000001v9oj',
  'LastKnownCountry'=>'00N20000001v9q8',
  'ApplicantTitle'=>'00N20000001v9q9',
  'ApplicantFirstName'=>'00N20000001v9mm',
  'ApplicantMiddleName'=>'00N20000001v9nq',
  'ApplicantLastName'=>'00N20000001v9ok',
  'ApplicantCompany'=>'00N20000001v9pH',
  'ShareOfRentForApplicant'=>'00N20000001v9pI',
  'Howwilltheinformationbecaptured?'=>'00N20000001v9pa',
  'TenantEmail'=>'00N20000001v9qh',
  'TenantAddress'=>'00N200000026LA8',
  'TenantAddressContd'=>'00N200000026LAD',
  'TenantCounty'=>'00N200000026LAI',
  'TenantPostcode'=>'00N200000026LAN',
  'TenantMessage'=>'00N200000026LBG',
  'AddressIfDifferent'=>'00N20000001v9rg',
  'PostCodeIfDifferent'=>'00N20000001vALw',
  'CountryIfDifferent'=>'00N20000001vAM1',
  'Service'=>'00N20000001vAYW',
  'Type'=>'00N20000001vBra',
  'LandlordAddress'=>'00N20000001vD7o',
  'LandlordPostCode'=>'00N20000001vD7V',
  'LandlordCountry'=>'00N20000001vD8I',
  'AffiliateNumber'=>'00N20000001vD9V',
  'PartnerID'=>'00N20000001vgAo',
  'AffiliateName'=>'00N20000001vlhN',
  'AffiliateURL'=>'00N20000001vlhX',
  'PPToken'=>'00N20000001vxNL',
  'TenancyDetailsStartDate'=>'00N20000001vzRH',
  'TenancyDetailsEndDate'=>'00N20000001vzRR',
  'TenancyPeriod'=>'00N20000001vzRb',
  'Isthepropertyahouseinmultipleoccu'=>'00N20000001vzRq',
  'Followanassuredshorthold'=>'00N20000001vzS5',
  'PolicyDetailsStartDate'=>'00N20000001vzSZ',
  'PolicyDetailsEndDate'=>'00N20000001vzSj',
  'PolicyTenancyPeriod'=>'00N20000001vzRS',
  'GuarantorFirstName'=>'00N20000001vzSt',
  'GuarantorSurname'=>'00N20000001vzT3',
  'GuarantorAddress'=>'00N20000001vzTD',
  'GuarantorPostcode'=>'00N20000001vzSu',
  'Tenant2FirstName'=>'00N20000001vzU1',
  'Tenant2Surname'=>'00N20000001vzU2',
  'Tenant2DateofBirth'=>'00N20000001vzSa',
  'Tenant2Phone'=>'00N20000001vzSb',
  'Tenant2Email'=>'00N200000026L9j',
  'Tenant2Postcode'=>'00N200000026L9o',
  'Tenant2Address'=>'00N200000026L9t',
  'Tenant2AddressContd'=>'00N200000026L9y',
  'Tenant2County'=>'00N200000026LA3',
  'Tenant2Message'=>'00N200000026LBL',
  'Tenant3FirstName'=>'00N20000001vzSc',
  'Tenant3Surname'=>'00N20000001vzU3',
  'Tenant3DateofBirth'=>'00N20000001vzV4',
  'Tenant3Phone'=>'00N20000001vzSk',
  'Tenant3Email'=>'00N200000026LAX',
  'Tenant3Postcode'=>'00N200000026LAh',
  'Tenant3Address'=>'00N200000026LAS',
  'Tenant3AddressContd'=>'00N200000026LA4',
  'Tenant3County'=>'00N200000026LAc',
  'Tenant4FirstName'=>'00N20000001vzSd',
  'Tenant4Surname'=>'00N20000001vzU4',
  'Tenant4DateofBirth'=>'00N20000001vzV9',
  'Tenant4Phone'=>'00N20000001vzVE',
  'Tenant4Email'=>'00N200000026LB6',
  'Tenant4Postcode'=>'00N200000026LB1',
  'Tenant4Address'=>'00N200000026LAm',
  'Tenant4AddressContd'=>'00N200000026LAr',
  'Tenant4County'=>'00N200000026LAw',
  'Anynoticesbeenserved'=>'00N20000001vzZQ',
  'PayPalTransactionID'=>'00N2000000259Hc',
  'AnyOtherTenants'=>'00N20000001vzZV',
  'OtherTenantsInfo'=>'00N20000001vzZa',
  'Paid'=>'00N20000001vzh5',
  'PropertyType'=>'00N200000025GjZ',
  'Gender'=>'00N200000025Gjf',
  'NumberofBedrooms'=>'00N200000025Gjj',
  'RentalPeriodInMonths'=>'00N200000025Gje',
  'MaritalStatus'=>'00N200000025Gja',
  'MaidenName'=>'00N200000025Gjg',
  'NoofDependants'=>'00N200000025Gjo',
  'NINumber'=>'00N200000025Gjh',
  'AreYouKnownByAnyOtherNamesAliases'=>'00N200000025Gjb',
  'ApplicantWorkPhone'=>'00N200000025Gji',
  'ApplicantHomePhone'=>'00N200000025Gjt',
  'ApplicantMobilePhone'=>'00N200000025Gjk',
  'MoreThanOneTenantOver18MovingIn'=>'00N200000025Gjc',
  'Nationality'=>'00N200000025Gjd',
  'ApplicantEmail'=>'00N200000025Gjy',
  'RequireWorkPermit'=>'00N200000025Gju',
  'AnyCCJs'=>'00N200000025Gjv',
  'AdverseCreditHistory'=>'00N200000025Gjl',
  'PeriodAtAddress'=>'00N200000025Gjm',
  'Status'=>'00N200000025Gjz',
  'StatusOther'=>'00N200000025Gjn',
  'RefereeName6'=>'00N200000025Gk3',

  'RefereePhone6'=>'00N200000026j3x',

  'RefereeAddress3'=>'00N200000025Gk4',
  'RefereeLandline'=>'00N200000025Gk0',
  'RefereeMobile'=>'00N200000025Gjw',
  'RefereePostcode4'=>'00N200000025Gk1',
  'RefereeEmail2'=>'00N200000025Gk5',
  'PreviousStatus1'=>'00N200000025Gk2',
  'PreviousAddress1'=>'00N200000025Gjx',
  'PreviousAddressPostcode1'=>'00N200000025Gk6',
  'PreviousPeriodAtAddress1'=>'00N200000025Gk7',
  'RefereeName1'=>'00N200000025Gk8',
  'RefereeAddress1'=>'00N200000025GkD',
  
  'RefereeAddressContd1'=>'00N200000026j3Y',
  
  'RefereePostcode1'=>'00N200000025GkI',
  'RefereePhone1'=>'00N200000025Gk9',
  'RefereeEmail1'=>'00N200000025GkN',
  'PreviousStatus2'=>'00N200000025GkJ',
  'PreviousAddress2'=>'00N200000025GkK',
  'PreviousAddressPostcode2'=>'00N200000025GkA',
  'PreviousPeriodAtAddress2'=>'00N200000025GkO',
  'RefereeName2'=>'00N200000025GkB',
  'RefereeAddress2'=>'00N200000025GkL',
  'RefereePostcode2'=>'00N200000025GkM',
  'RefereePhone2'=>'00N200000025GkS',
  'EmploymentIncomeDetails'=>'00N200000025GlV',
  'MaternityPaternityLeaveFrom1'=>'00N200000025GkT',
  'MaternityPaternityLeaveTo1'=>'00N200000025Gla',
  'FutureCompanyName'=>'00N200000025GkU',
  'FutureCompanyAddress'=>'00N200000025Glb',
  'EmploymentStartDate'=>'00N200000025Glc',
  'FutureCompanyPostcode'=>'00N200000025Gld',
  'FutureCompanyLandlinePhone'=>'00N200000025GlW',
  'Fax'=>'00N200000025GkV',
  'IsAboveAddressYourPlaceofWork2'=>'00N200000025GkW',
  'Position'=>'00N200000025Glk',
  'SalaryorWagePerHour1'=>'00N200000025Gle',
  'RefereeName3'=>'00N200000025Glp',
  'RefereePostcode3'=>'00N200000025Gll',
  'ContractualHours1'=>'00N200000025Glq',
  'RefereeEmail3'=>'00N200000025Glu',
  'EmploymentType1'=>'00N200000025GlX',
  'FixedTermContractDuration1'=>'00N200000025Glr',
  'CurrentCompanyName'=>'00N200000025Gls',
  'CurrentCompanyAddress'=>'00N200000025Glv',

  'CurrentCompanyAddressContd'=>'00N200000026j47',

  'CurrentCompanyPostcode'=>'00N200000025GlY',
  'CurrentCompanyLandlinePhone'=>'00N200000025Glw',
  'CurrentCompanyFax'=>'00N200000025Glz',
  'CurrentPosition'=>'00N200000025GlZ',
  'StaffPayrollNo'=>'00N200000025Gm0',
  'IsAboveAddressYourPlaceofWork1'=>'00N200000025Gm4',
  'RefereeName4'=>'00N200000025Glt',
  'RefereePosition4'=>'00N200000025Gm9',
  'RefereeEmail4'=>'00N200000025Gm5',
  'EmploymentType2'=>'00N200000025GmA',
  'SalaryorWagePerHour2'=>'00N200000025Gm1',
  'ContractualHours2'=>'00N200000025GmB',
  'FixedTermContractDuration2'=>'00N200000025Gm6',
  'PreviousEmploymentIncomeDetails'=>'00N200000025GmC',
  'MaternityPaternityLeaveFrom2'=>'00N200000025Gm7',
  'MaternityPaternityLeaveTo2'=>'00N200000025JCJ',
  'MaternityPaternityLeaveFrom3'=>'00N200000025Gm2',
  'PreviousCompanyName'=>'00N200000025GmD',
  'PreviousEmploymentPosition'=>'00N200000025Gm3',
  'RefereeName5'=>'00N200000025GmE',
  'RefereePosition5'=>'00N200000025GmJ',
  'PreviousCompanyAddress'=>'00N200000025Gm8',
  'PreviousCompanyPostcode'=>'00N200000025GmK',
  'PreviousCompanyLandline'=>'00N200000025GmF',
  'PreviousCompanyFax'=>'00N200000025GmL',
  'RefereeEmail5'=>'00N200000025GmG',
  'PreviousEmploymentStartDate'=>'00N200000025GmO',
  'PreviousEmploymentEndDate'=>'00N200000025GmM',
  'SelfEmployedFrom'=>'00N200000025GmH',
  'SelfEmployedTo'=>'00N200000025GmN',
  'SelfEmployedCompanyName'=>'00N200000025GmP',
  'SelfEmployedBusinessType'=>'00N200000025GmQ',
  'SelfEmployedCompanyAddress'=>'00N200000025GmT',
  'SelfEmployedWebsiteAddress'=>'00N200000025GmI',
  'SelfEmployedPostcode'=>'00N200000025GmU',
  'VATRegNo'=>'00N200000025GmV',
  'SelfEmployedStatus'=>'00N200000025GmR',
  'CompanyRegDetails'=>'00N200000025GmS',
  'DateofIncorporation'=>'00N200000025Gmd',
  'HasAccountant'=>'00N200000025Gme',
  'IncomePerAnnum'=>'00N200000025Glx',
  'AccountantsCompanyName'=>'00N200000025Gmf',
  'AccountantContactName'=>'00N200000025Gmi',
  'AccountantAddress'=>'00N200000025Gmg',
  'AccountantPostcode'=>'00N200000025Gmh',
  'AccountantLandlinePhone'=>'00N200000025GmW',
  'AccountantFax'=>'00N200000025GmX',
  'AccountantEmail'=>'00N200000025Gly',
  'AccountantStatus'=>'00N200000025Gmn',
  'AccountantRegisteredNo'=>'00N200000025Gmj',
  'CharacterReferenceName'=>'00N200000025Gmo',
  'CharacterReferenceAddress'=>'00N200000025Gmp',
  'CharacterReferencePostcode'=>'00N200000025Gmx',
  'CharacterReferencePhone'=>'00N200000025Gmq',
  'CharacterReferenceEmail'=>'00N200000025Gmr',
  'CharacterReferenceFax'=>'00N200000025Gmy',
  'NextofKinName'=>'00N200000025Gmk',
  'CharacterReferenceRelationship'=>'00N200000025Gml',
  'NextofKinEmail'=>'00N200000025Gn2',
  'NextofKinPhone'=>'00N200000025Gmm',
  'NextofKinPostcode'=>'00N200000025Gn7',
  'NextofKinMobile'=>'00N200000025Gmz',
  'NextofKinFax'=>'00N200000025Gn0',
  'NextofKinRelationship'=>'00N200000025P0m',
  'NextofKinAddress'=>'00N200000025P0r',
  'EverBeenEvicted'=>'00N200000025Gn1',
  'EvictionDetails'=>'00N200000025GnC',
  'DepositEverWithheld'=>'00N200000025GnH',
  'WithheldDepositDetails'=>'00N200000025GnI',
  'AdditionalDetailsWhereRequired'=>'00N200000025Gn8',
  'AdverseCreditHistoryDetails'=>'00N200000025Goj',
  'CurrentAddress'=>'00N200000025HIZ',

  'CurrentAddressContd'=>'00N200000026iyn',
  'CurrentAddressCity'=>'00N200000026iys',
  'CurrentAddressCounty'=>'00N200000026iz7',

  'CurrentAddressPostcode'=>'00N200000025GqB',
  'RefereePhone3'=>'00N200000025GqG',
  'CurrentEmploymentStartDate'=>'00N200000025GqD',
  'RefereeEmail6'=>'00N200000025GrO',
  'RefereePosition6'=>'00N200000025GrT',
  'DateofBirth'=>'00N20000001v9og',
  'DateofDeparture'=>'00N200000025HDo',
  'AreTheyToBeReferenced'=>'00N200000025HBb',
  'Branch'=>'00N200000025aob',
  'PeriodAtAddressYears'=>'00N200000025bIn',
  'PeriodAtAddressMonths'=>'00N200000025bIm',
  'PeriodAtPreviousAddressYears'=>'00N200000025bIo',
  'PeriodAtPreviousAddressMonths'=>'00N200000025bIr',
  'MultipleOccupation'=>'00N20000001vzRq',
  'routeLeadCode'=>'00N200000026Qvr'
);

Now what I would like to know is how is this form submitted to sf

I know that salesforce generates a random password which is sent out in an welcome email to the customer. What I would like to do is send all this info to a mysql database to enbale the customer to login. I hope this makes sense

Please help

Sorry for all the questions sir, but I have a few more.

1) so this form will submit the data to Salesforce and create a user for the person? OR

2) Is this creating a lead?


Reason I ask is if this form is to create a user there is no way that you will be able to send the user their information via email because the password that is generated by Salesforce is kept in their database and you cannot store that information in MySQL or any other database.

I do think that you can create a user via PHP to salesforce and when that happens, whatever email address that is registered when the user account is created in Salesforce, an email will be sent to the user automatically...

You can then create a replication script to get the data from the user object and store it in MySQL. Once you have that data in MySQL, you could query the database before creating the user and use the email address as your key to see if the user is already in Salesforce


Sorry I just need more information


~Mike

Hi mike

Thanks for your response

The idea was to create a user but I didnt realise you couldnt access the password from salesforce. So I like the idea of creating a user via php and then replicating the user account. But again mike I am not sure what to do here.

I am not sure if you have seen the php form in my previous post which is a login script written in php. But how does this script transfer the data from the form into Salesforce and how would I create the replication script to transfer the data to mysql database?

Sorry to be pain mike. Thanks for all your help

Your not a pain at all, that is what this site is for.

let me take a look at the code more closely and I will get back to you as soon as I have time......

~Mike

Shalli,

I took a look at your code and it is just one big array of data.

So let's say that you wanted to put this into Salesforce, which you could easily for sure

Since you are new to Salesforce, you would have to download the PHP ToolKit and then get that working to make sure you can communicate from your environment to Salesforce's via the API

There are a ton of scripts on here in different posts which will give you ideas on how to submit a form and create a replication script. You just have to search

Here is a thread about replication > http://www.mikesimonds.com/synchroni...base-t191.html

In order to get the fields into Salesforce, you would need to create the fields in Salesforce and then ensure they match somehow. You would need to submit the whole array as a record into Salesforce. There are examples of that.

I just do not have the time right now to write a script from scratch, but would be willing to help you with yours.

I hope that helps

~Mike