INSERT INTO hp_appointment (`appointmentId`,`teamId`,`event_id`,`added_by`,`leadId`,`calendarId`,`type`,`campaignId`,`name`,`email`,`phone`,`mobile`,`location`,`title`,`additional_info`,`schedule_date`,`schedule_time`,`end_time`,`lead_timezone`,`team_schedule_date`,`team_schedule_time`,`team_end_time`,`isbusy`,`lead_sms`,`self_sms`,`sms_number`,`sms_text`,`lead_email`,`self_email`,`remainder_email_status`,`remainder_sms_status`,`remainder_voicemail_status`,`remainder_self_sms_status`,`remainder_self_email_status`,`remainder_self_voicemail_status`,`email_address`,`email_subject`,`email_body`,`approved`,`custom_fields`,`dated`) VALUES
("257","1215","","2036","2682309","234","Outbound","802","Meena Shah, DDS ","smilesnyc700@gmail.com","2128650177","","join.me","Follow up for demo","","2016-03-17","10:00:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-16 15:07:26"),
("258","1215","","2036","2772170","234","Outbound","755","River Valley Dental Clinic ","sean@srswebsolutions.com","5073883384","","join.me","Call back after doing the demo for them back in March","","2016-07-06","10:00:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-16 15:35:01"),
("259","1215","","2036","2773201","234","Outbound","802","Tiffany ","outreach@vitalsmiles.com","2054703892","","join.me","mConsent Demo ","","2016-03-18","09:05:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-16 16:04:53"),
("260","1215","","2036","2544548","234","Outbound","797","Tracy","millcitydental@gmail.com","6123773740","","2218 Laurel Ave","Check notes for call ","","2016-04-04","09:00:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-17 09:24:22"),
("261","1215","","2036","2588207","234","Outbound","802","Mayra Carreon ","mayra@texasdentalpa.com","9722447194","","join.me","Follow up agreed to get forms just needs to run it by the doctors","","2016-04-13","09:45:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-17 09:43:29"),
("262","1215","","2036","2544876","234","Outbound","755","Tessa ","info@dbdmn.com","9524745041","","17809 Hutchins Dr #108","Follow up for demo","","2016-03-21","09:05:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-17 14:05:37"),
("263","1215","","2036","2544878","234","Outbound","755","Dr. Mark W. Wilhelm DMD MSD ","info@imagineyoursmile.com","6512272427","","6861 Upper Afton Road# 101","Call back after she presented mConsent at meeting","","2016-04-19","09:25:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-17 14:23:47"),
("264","1215","","2036","2544881","234","Outbound","755","Andrea  ","info@applevalleydentist.com","9524329155","","7300 147th Street W # 302","follow up with andrea ","","2016-03-17","15:30:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-17 14:33:07"),
("265","1215","","2036","2544884","234","Outbound","755","Eagan Family Dentistry ","jennifer@eaganfamilydentistry.com","6514524317","","4178 Knob DriveSuite C","Follow up for demo email wasn\'t working to send to customer","","2016-03-23","10:20:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-17 15:20:40"),
("266","1215","","2036","2544885","234","Outbound","755","Isles Dental ","info@islesdental.com","6123744321","","2534 Hennepin Avenue","Showed Nicohl demo just need to get forms from her now. ","","2016-03-21","11:00:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-17 15:33:42"),
("267","1215","","2036","2544913","234","Outbound","755","Victoria ","drhunt@comcast.net","6516360655","","2233 Hamline Avenue North # 320","Call Zach back he is office manager","","2016-03-18","09:15:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-17 16:16:37"),
("268","1215","","2036","2544916","234","Outbound","755","Kristie ","trieken@metro-dentalcare.com","9524734124","","445 Lake St East # 216","Follow up with Talitha office manager","","2016-03-18","10:25:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-17 16:25:16"),
("271","1215","","2036","2544975","234","Outbound","755","Pam ","0","6127816568","","3201 Johnson St Ne","Call peggy she is office manager after speaking with pam","","2016-03-21","10:20:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-18 13:24:11"),
("273","1215","","2036","2832742","234","Outbound","802","Theresa Espinosa / Dr. Leonard","espinosahb@aol.com","7146515624","","join.me","Follow up and see what doctor decided about the App and the mConsent","","2016-03-30","16:05:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-18 16:06:42"),
("274","1215","","2036","2772170","234","Outbound","755","River Valley Dental Clinic ","sean@srswebsolutions.com","5073883384","","join.me","Call back after doing demo they liked it they just wanted to wait until summer to purchase","","2016-07-06","09:20:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-21 09:18:51"),
("276","1215","","2036","2865897","234","Outbound","802","laurie","luriedentistry@gmail.com","2163712707","","join.me","contacted us via email to know more they are busy now so wanted us to follow up in the first wednesday in april","","2016-04-06","10:20:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-21 10:21:14"),
("277","1215","","2036","2865896","234","Outbound","802"," Dr. Bibb","bibbdds@design-dentalgroup.com","7138690334","","join.me","call to do demo of mConsent contacted us via email","","2016-03-22","09:25:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-21 10:23:41"),
("278","1215","","2036","2544868","234","Outbound","755","Julie ","info@twincitiesmoderndentistry.com","9529419829","","6600 City W PkwySte 315","Sent an email and they want me to contact them back for a demo of mconsent","","2016-04-12","09:15:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-21 11:15:46"),
("279","1215","","2036","2544982","234","Outbound","843","Jayne ","info@fiantdental.com","6128277400","","2937 Lyndale Ave S #202","Jayne advised us to call back in 8 months to see if doc is interested in going paperless","","2016-11-08","08:35:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-21 13:36:14"),
("283","1215","","2036","2544554","234","Outbound","797","Dr. Reka Koerner ","central.dental.mpls@gmail.com","6127899444","","1800 Central Ave NE","asked us to follow up in 6months about mConsent","","2016-09-13","13:15:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-21 16:13:39"),
("286","1215","","2036","2507043","234","Outbound","718","Mahi Inampudi","mahi.inampudi@gmail.com","3122130543","","7936 Oak Park Ave","Spoke with about SEO for new website. Changiing name of dental practice","","2016-07-06","10:35:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"7084587552\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-22 15:36:04"),
("288","1215","","2036","2865897","234","Outbound","802","Best to call on a wednesday ","luriedentistry@gmail.com","2163712707","","join.me","Call back to do demo wed morning works best","","2016-03-30","10:20:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-24 09:54:58"),
("311","1215","","2036","2588220","234","Outbound","802","Becky  ","info@oakridgedentalcenter.com","2486521100","","0","requested that I call back in a month","","2016-04-28","09:15:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-29 12:13:54"),
("313","1215","","2036","2865897","234","Outbound","802","Best to call on a wednesday ","luriedentistry@gmail.com","2163712707","","join.me","moving offices asked to call back then!","","2016-04-26","09:50:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-03-29 12:52:41"),
("328","1215","","2036","2867051","234","Outbound","906","Lynn Atkins","Lynn@Cruise-the-Seas.com","9517341112","","13481 Shady Knoll Dr","call her back","","2016-04-15","11:30:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"0\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-04-14 15:30:02"),
("329","1215","","2036","3265060","234","Outbound","843","Call Emily For appt she is the","hmasters@6daydental.com","2147781900","","3402 Sherwood Ln","call back appt","","2016-04-19","09:15:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"f\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-04-18 10:14:15"),
("361","1215","","2032","2822216","234","Outbound","913"," Walter or Nathalie","omanager@purecypressdentist.com","7145818585","","Pure Cypress Dentist","Doctor/Office Manager ","","2016-05-31","12:00:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"7145818585\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-05-27 18:29:54"),
("579","1215","","2034","11364310","234","Outbound","2779"," Doctor","maryarmelyn@gmail.com","9265400690","","NC","Office Manager","","2016-11-30","10:15:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"9265400690\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-11-30 17:16:23"),
("580","1215","","2034","10690309","234","Outbound","2397"," mary","m@gmail.com","4047629400","","ga","om","","2016-11-30","09:25:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"4047629400\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-11-30 17:28:15"),
("581","1215","","2034","6362432","234","Outbound","1658"," Skylar","frontdesk@mergenorthodontics.com","3194714202","","IA","OM","","2016-12-07","10:40:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"3194714202\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-12-06 11:38:06"),
("583","1215","","2034","8597497","234","Outbound","1851","Pam","noemail@gmil","2037625100","","67 Old Ridgefield Rd","Om","","2016-12-14","09:55:00","00:00:00","","0000-00-00","00:00:00","00:00:00","0","Y","N","","","Y","Y","1","1","1","0","1","1","sean@srswebsolutions.com","Call back","Call back this contact","Y","[[\"mobile\",\"2037625100\"],[\"required\",\"title,name,email,phone,mobile,location,date,time\"]]","2016-12-07 14:55:49");



