PLEASE UPDATE YOUR BROWSER

1 Reason Agency

Insurance and Real Estate

  • About
    • Meet Our Agents
    • Partner Insurance Companies
  • Personal Insurance
    • Car Insurance Quote for Personal Auto
    • Boat Insurance
    • Home Owners Insurance
    • Life Insurance Quotes
    • Motorcycle Insurance
    • Personal Umbrella Insurance
    • Renters Insurance
    • RV Camper Insurance
    • Snowmobile Insurance
  • Business Insurance
    • Commercial Auto Insurance
    • What is General Liability Insurance
    • Rental or Vacant Properties
    • Workers Compensation in Wisconsin
  • Blog
  • Contact
    • Contribute As Guest Author
  • About
    • Meet Our Agents
    • Partner Insurance Companies
  • Personal Insurance
    • Car Insurance Quote for Personal Auto
    • Boat Insurance
    • Home Owners Insurance
    • Life Insurance Quotes
    • Motorcycle Insurance
    • Personal Umbrella Insurance
    • Renters Insurance
    • RV Camper Insurance
    • Snowmobile Insurance
  • Business Insurance
    • Commercial Auto Insurance
    • What is General Liability Insurance
    • Rental or Vacant Properties
    • Workers Compensation in Wisconsin
  • Blog
  • Contact
    • Contribute As Guest Author
Home > SuiteCRM Insurance CRM > Importing Clients Into SuiteCRM Using XML

Importing Clients Into SuiteCRM Using XML

Posted on: February 7, 2018 By: robert

I want to create a road map on how to automatically import lead and client data into SuiteCRM and this will be the working article I use to record my progress, and reference later.

Currently, the plan is to create a sub domain that all lead data will first go to for scrubing and massaging, and from there it will go on to the SuiteCRM system for import.

In the sub domain, the mapping of fields will occur, along with changing caps of any given data point, and phone numbers formated correctly etc….

Because PHP has a built-in parser called SimpleXML Parser (fair enough name for an XML parser I believe), I will attempt to use that and see how it goes.

In order to read an XML string of data, the PHP simpleXML_load_string() function is used.

Using sample test data, we can see this in action:

$ClientXMLData = 
"<?xml version='1.0' encoding='UTF-8'?>
<ContactInfo>
<FirstName>Lori</FirstName>
<LastName>Robert</LastName>
<heading>New Client</heading>
<CompanyName>ABC Company</CompanyName>
</ContactInfo>";

The above XML is read using the following code:

$xml=simplexml_load_string($ClientXMLData) or die("Error: Cannot create object");
print_r($xml);

The print_r should give us something that looks like:

SimpleXMLElement Object ( [FirstName] => Lori[LastName] => Robert[heading] => New Client [CompanyName] => ABC Company )

The XML documents I want to import includes the following fields

<InsuranceRequest xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<ZipCode>78759</ZipCode>

<ContactInfo>

<FirstName>Isaac</FirstName>

<LastName>Allen</LastName>

<Address>79108 Mopac Hwy</Address>

<ZipCode>78759</ZipCode>

<City>AUSTIN</City>

<County>TRAVIS</County>

<State>TX</State>

<PhoneDay>8047528122</PhoneDay>

<PhoneEve>8048598397</PhoneEve>

<PhoneCell>8047528122</PhoneCell>

<Email>IsaacAllen262329296@test.org</Email>

<Comment>None</Comment>

</ContactInfo>

<BusinessPropertyInsurance>

<CompanyName>Test Company</CompanyName>

<LegalEntity>Sole Proprietorship</LegalEntity>

<YearsInBusiness>40</YearsInBusiness>

<Revenue>Under $100,000</Revenue>

<Partners>29</Partners>

<FullTimeEmployees>6</FullTimeEmployees>

<PartTimeEmployees>14</PartTimeEmployees>

<SubContractors>9</SubContractors>

<SIC>0111</SIC>

<SeasonalBusiness>false</SeasonalBusiness>

<Subsidiaries>3</Subsidiaries>

<RequestedCoverage>

<General_Liability>false</General_Liability>

<Commercial_Auto>false</Commercial_Auto>

<Commercial_Property>false</Commercial_Property>

<Professional_Liability>false</Professional_Liability>

<Directors_and_Officers_Liability>false</Directors_and_Officers_Liability>

<Business_Owners_Package_Policy>true</Business_Owners_Package_Policy>

<Workers_Compensation>false</Workers_Compensation>

<Commercial_Crime>false</Commercial_Crime>

</RequestedCoverage>

</BusinessPropertyInsurance>

</InsuranceRequest>

Comments

comments

Categories: SuiteCRM Insurance CRM, Tips & Advice Tags: XML Import

Categories

  • Bookkeeping
    • Business Taxes
  • Business Marketing
  • Car Insurance
  • Commercial Auto
  • Commercial Insurance
  • Court Cases
  • Cyber Liability Insurance
  • Employment Opportunities
  • Employment Practices
  • Flood Insurance
  • Home Ownership
  • Homeowner's Insurance
  • Insurance Companies
    • Insurance News
  • Insurance Terms
  • Investing
    • Finance & Insurance News
  • Life Insurance
  • Non Emergency Medical Transportation
  • Payroll
  • Pinewood Derby
  • Real Estate News
  • Rental Property Insurance
  • Retirement & Estate Planning
  • RV Insurance
  • Starting A Business
  • Stock Dividends
  • SuiteCRM Insurance CRM
  • Tips & Advice
  • Travel
  • Uncategorized
  • Webhosting
  • Worker's Compensation

Recent Posts

  • Whitestone REIT Announces Fourth Quarter and Year End 2020 Earnings Webcast and Conference Call
  • Duke Realty Reports Fourth Quarter and Full Year 2020 Results
  • Matthew Downs Joins Greystone’s CMBS Team as Managing Director
  • Audience Town Accelerates Growth With Digital Advertising Platform for Real Estate
  • Black Creek Group Announces 2020 Activity and is Well-Positioned Heading into 2021
  • Regency Centers Issues TCFD Climate Change Risk Report and is Recognized for Corporate Responsibility Leadership
  • Trupanion, Inc. Announces Fourth Quarter and Full Year 2020 Earnings Release and Conference Call
  • Progressive Reports December 2020 Results