Invalid SQL: REPLACE INTO `swsessions` (`sessionid`, `ipaddress`, `lastactivity`, `useragent`, `isloggedin`, `sessiontype`, `typeid`, `dateline`, `status`) VALUES('z2sh5cydjqz6yd0ktgpi9d2hw4pbid4d', '18.97.14.88', '1733334634', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '0', '40', '0', '1733334634', '0'); (The table 'swsessions' is full) Nanacast - Powered By Kayako eSupport What data fields does Nanacast send to Infusionsoft?

Article Details
URL: http://support.nanacast.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=69
Article ID: 69
Created On: 24 Mar 2010 10:53 AM

Answer

These are all the fields we send to infusion: 

'Email' => $email,

'FirstName' => $user['u_firstname'],

'LastName' => $user['u_lastname'],

'StreetAddress1' => $user['u_address'],

'StreetAddress2' => $user['u_address_2'],

'City' => $user['u_city'],

'State' => $user['u_state'],

'PostalCode' => $user['u_zip'],

'Phone1' => $user['u_phone'],

'Fax1' => $user['u_fax'],

'Title' => $user['u_title'],

'Website' => $user['u_website'],

'Company' => $user['u_business']


Note: 
In order for those fields other than FirstName, LastName, and Email to be captured in Infusionsoft, the same fields must exist for your contacts database in Infusionsoft, which may mean adding custom fields.