(370,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Dear Lapinsee Bim,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 367<br />\r\nTicket Title : Dela Rosa Yerba Buena / Wiring issue from Patch<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000097<br />\r\nStatus : Open<br />\r\nCategory : Big Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello Dianah,<br />\n <br />\nLockbox has already been left onsite for access at 7am and Bim has been informed of location and code. We’ll keep the scheduled time.<br />\n <br />\nPlease note that as discussed on Monday’s meeting, issue with ticket 110406 is resolved. Expo printer is showing correct IP of 192.168.192.173 and working as expected.<br />\n <br />\nThis call is to address ticket 110458 and 108635. During the KDS installation, we had to resort to using a WiFi connection because none of the devices were retaining the assigned IP. NOC also needed to configure a port outside of PNET range - please ensure they are scheduled on standby for this call as we need a port configured on the switch. See configurations sent on 4/27 on ticket 108635 below:<br />\nDevice Name	Device Label Name	MAC Address	 <br />\nIP Address	Serial Number	Patch Panel	Switch Port<br />\nCOLD KDS	FDLA002-KDS-002	74:F7:F6:3D:AE:1F	 <br />\n192.168.192.71	LS84221Q41125	18	1<br />\nHOT KDS	FDLA002-KDS-003	74:F7:F6:3D:BE:D5	 <br />\n192.168.192.72	LS84221U40182	20	4<br />\nPIZZA KDS	FDLA002-KDS-004	74:F7:F6:3D:99:A9	 <br />\n192.168.192.73	LS84221Q40073	22	13<br />\n <br />\nNotice that switch port 13 was used. This needs to be changed as Port 13 is assigned exclusively to music devices. @bim@mybluetechnology.com Please make this change to the next available port and communicate with Dynamix team here or on the bridge. NOC team needs to configure the port for Toast devices outside of 1-12 range. Once the correct IP is being retained via RJ45 connection on the Toast devices – you’ll need to disable WiFi connection and forget the saved network. I will send you a separate email with your unique Toast credentials.<br />\n <br />\nPlease don’t hesitate to reach out to me directly with any questions.<br />\n <br />\nBest,<br />\nNuranne<br />\n <br />\nFrom: Dynamix Frontline Services <br />\nSent: Tuesday, May 2, 2023 9:24 PM<br />\nTo: bim@mybluetechnology.com<br />\nCc: jc@mybluetechnology.com; supportticket@mybluetechnology.com; Nuranne Dairkee <br />\nSubject: Re: Dela Rosa Yerba Buena / Wiring issue from Patch<br />\n <br />\nHello Bim,<br />\n<br />\nI hope all is well. <br />\n<br />\nWe would like to request to move the schedule to 8 AM instead of 7 AM since the earliest staff will arrive at 8 AM.<br />\n<br />\nThank you for your patience.<br />\n<br />\nKind Regards,<br />\nDianah<br />\n--------------- Original Message ---------------<br />\nFrom: Dynamix Frontline Services [frontline@dynamixsupport.com]<br />\nSent: 5/1/2023, 7:39 PM<br />\nTo: bim@mybluetechnology.com<br />\nCc: jc@mybluetechnology.com; supportticket@mybluetechnology.com; ndairkee@backofthehouseinc.com<br />\nSubject: Re: Dela Rosa Yerba Buena / Wiring issue from Patch<br />\n<br />\nHello Bim,<br />\n<br />\n<br />\nKindly see the bridge information below:<br />\n<br />\nConference Bridge (510) 982-2772<br />\nParticipant Pin #96875<br />\n<br />\n<br />\n<br />\nRegards,<br />\nChristine<br />\n<br />\n<br />\n--------------- Original Message ---------------<br />\nFrom: Bim [bim@mybluetechnology.com]<br />\nSent: 5/1/2023, 1:50 PM<br />\nTo: frontline@dynamixsupport.com<br />\nCc: jc@mybluetechnology.com; supportticket@mybluetechnology.com; ndairkee@backofthehouseinc.com<br />\nSubject: Re: Dela Rosa Yerba Buena / Wiring issue from Patch<br />\n<br />\nConfirmed, I will be there Wednesday 3rd of May at 7.am and will pick up key on Tuesday 8pm please prepare for me.<br />\n <br />\nBim Tech <br />\nSan Francisco <br />\n4156322318<br />\n <br />\n<br />\nHello,<br />\nWe would like to request a technician for the location below:<br />\nAddress: 37 Yerba Buena San Francisco CA, 94103<br />\nDate: April 26, 2023 (Wednesday)<br />\nTime: 7:00 AM PST<br />\nAccess to Store:  Granted<br />\nDynamix Ref Number: 110406<br />\nDevice Type:  <br />\nConnection Type: Ethernet connection<br />\nWork Needed:<br />\nTo confirm the patch status<br />\nTroubleshooting Steps were taken:<br />\nConfigured - FDLA002-KP-HOT in Meraki<br />\nAdded MAC- 50:57:9c:58:c8:1b / IP - 192.168.192.170<br />\nPing Test - responding / Loss rate - 0%<br />\nTest Print -Working<br />\nFDLA002-KP-EXPO<br />\n> Connected to a patch > Switch port number 6 > IP: None<br />\nProperly Onboarded in Meraki - 50:57:9c:58:ad:8c/ 192.168.192.173<br />\nPing Test- 100% Packet Loss<br />\nBypassed the patch and connect it straight to the switch<br />\nPerformed Powercycle. Ip now shows - 192.168.192.173<br />\nPing test - 0% packet loss<br />\ntest print - Okay<br />\nThe printer is not working behind the patch<br />\nThank you and looking forward to your response.<br />\nKind Regards,<br />\nDianah<br />\r\n<br />\r\nSolution :<br />\r\n <br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span></body>\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></html>\r\n<br><br>','2023-05-11 02:15:09','2023-05-11 02:15:09',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000097 Dela Rosa Yerba Buena / Wiring issue from Patch DYNAMIX Number 110406'),(371,6,5,1,'HelpDesk','Hello, \n\n  \nWe would like to request a technician for the location below: \n\n\nAddress: 855 El Camino Real #110 \n\nDate: April 26, 2023 (Wednesday) \n\nTime: 07:00 AM PST \n\nAccess to Store:  TBD \n\nDynamix Ref Number: 110291 \n\nDevice Type: 6 Port Switch\n\n-------- Original message -------- \nFrom: Dynamix Frontline Services  \nDate: 4/25/23 1:21 PM (GMT-05:00) \nTo: yann@mybluetechnology.com\nCc: jc@mybluetechnology.com, ndairkee@backofthehouseinc.com, supportticket@mybluetechnology.com\nSubject: RE: 110388/Wildseed Palo Alto/Remove 6 Port Switch \n  \nHello Yann,\n\nI hope all is well. We would also like to request your assistance with the auditing of all devices at Wildseed Palo Alto. This audit is necessary to ensure that all documentation related to these devices is accurate and up-to-date.\n\nAttached to this email, you will find an excel file that we will use to track the audit results. Please fill out the information required in the file and send it back to us once the audit is complete.\n\nIf you have any questions or concerns about this, please do not hesitate to contact us.\n\nBest regards,\nDale','2023-05-11 02:29:57','2023-05-19 04:06:01',NULL,NULL,0,1,0,0,'CRM','110388/Wildseed Palo Alto/Remove 6 Port Switch'),(372,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : 371<br />\r\nTicket Title : 110388/Wildseed Palo Alto/Remove 6 Port Switch<br />\r\n<br />\r\nDear Dalrymple Yann,<br />\r\n<br />\r\nYou have been assigned to the following ticket:<br />\r\n<br />\r\nTicket No : TKT000098<br />\r\nStatus : Open<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDYNAMIX TICKET NUMBER:&nbsp;110291<br />\r\n<br />\r\nDescription :<br />\r\nHello, <br />\n<br />\n  <br />\nWe would like to request a technician for the location below: <br />\n<br />\n<br />\nAddress: 855 El Camino Real #110 <br />\n<br />\nDate: April 26, 2023 (Wednesday) <br />\n<br />\nTime: 07:00 AM PST <br />\n<br />\nAccess to Store:  TBD <br />\n<br />\nDynamix Ref Number: 110291 <br />\n<br />\nDevice Type: 6 Port Switch<br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size:20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family:verdana,geneva,sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-11 02:30:01','2023-05-11 02:30:01',NULL,NULL,0,1,0,0,'CRM','YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000098 110388/Wildseed Palo Alto/Remove 6 Port Switch DYNAMIX NUMBER 110291'),(373,6,6,6,'ModComments',NULL,'2023-05-11 02:30:47','2023-05-11 02:30:47',NULL,NULL,0,1,0,0,'CRM','Task 1: Remove the temporary 6 Port Switch \nTask 2: Check if the patch for those ports is in a good working condition'),(374,6,6,0,'ModComments Attachment',NULL,'2023-05-11 02:30:47','2023-05-11 02:30:47',NULL,NULL,0,1,0,NULL,NULL,NULL),(375,6,5,1,'HelpDesk','Hello,\nWe would like to request a technician for the location below:\nAddress: 1199 Valencia Street, San Francisco CA, 94110\nDate: April 27, 2023 (Thursday)\nTime: 9:00 AM PST\nAccess to Store:  Granted\nDynamix Ref Number: 110134\nDevice Type:  UPS\n \nWork Needed:\nTo install the New UPS\nThank you and looking forward to your response.\nKind Regards,\nDianah','2023-05-11 02:37:53','2023-05-19 02:56:08',NULL,NULL,0,1,0,0,'CRM','Tech Visit Beretta /UPS Replacement'),(376,6,6,6,'ModComments',NULL,'2023-05-11 02:38:31','2023-05-11 02:38:31',NULL,NULL,0,1,0,0,'CRM','Pictures'),(377,6,6,0,'ModComments Attachment',NULL,'2023-05-11 02:38:31','2023-05-11 02:38:31',NULL,NULL,0,1,0,NULL,NULL,NULL),(378,6,6,0,'ModComments Attachment',NULL,'2023-05-11 02:38:31','2023-05-11 02:38:31',NULL,NULL,0,1,0,NULL,NULL,NULL),(379,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : 375<br />\r\nTicket Title : Tech Visit Beretta /UPS Replacement<br />\r\n<br />\r\nDear Dalrymple Yann,<br />\r\n<br />\r\nYou have been assigned to the following ticket:<br />\r\n<br />\r\nTicket No : TKT000099<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDYNAMIX TICKET NUMBER:&nbsp;110134<br />\r\n<br />\r\nDescription :<br />\r\nHello,<br />\nWe would like to request a technician for the location below:<br />\nAddress: 1199 Valencia Street, San Francisco CA, 94110<br />\nDate: April 27, 2023 (Thursday)<br />\nTime: 9:00 AM PST<br />\nAccess to Store:  Granted<br />\nDynamix Ref Number: 110134<br />\nDevice Type:  UPS<br />\n <br />\nWork Needed:<br />\nTo install the New UPS<br />\nThank you and looking forward to your response.<br />\nKind Regards,<br />\nDianah<br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size:20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family:verdana,geneva,sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-11 02:45:02','2023-05-11 02:45:02',NULL,NULL,0,1,0,0,'CRM','YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000099 Tech Visit Beretta /UPS Replacement DYNAMIX NUMBER 110134'),(380,6,5,5,'HelpDesk','Hello,\n\n \nWe would like to request a technician for the location below:\n\nAddress: 2518 Mission Street\n\nDate: April 26, 2023 (Wednesday)\n\nTime: 01:00PM PST\n\nAccess to Store:  TBD\n\nDynamix Ref Number: 110355\n\nDevice Type: 2 Handhelds\n\nConnection Type: Wireless\n\n\nWork Needed:\nTask 1: Connect the Handhelds to PNET (coordinate with support for the password)\nTask 2: Log in to Toast using the email and password that is associated with the store’s Toast Account\nTask 3: Enable EMV \nOn the lower left corner of the passcode screen, select credit card icon.\nEnter Pin to log in.\nFrom the main menu, go to set up and select device set up.\nScroll down and select EMV enabled.\nSelect Yes.\nTask 4: Provide support with the MAC address and Serial Number of the device for Mapping and Documentation purposes.\nTask 5: Make sure to label Handhelds FLOL001-HH-01 and FLOL001-HH-03\n\n\nBest regards,\nChristine','2023-05-11 02:47:25','2023-05-19 04:04:58',NULL,NULL,0,1,0,0,'CRM','110355/Lolinda/Installation of 2 Handhelds'),(381,6,6,6,'ModComments',NULL,'2023-05-11 02:47:52','2023-05-11 02:47:52',NULL,NULL,0,1,0,0,'CRM','Pictures'),(382,6,6,0,'ModComments Attachment',NULL,'2023-05-11 02:47:52','2023-05-11 02:47:52',NULL,NULL,0,1,0,NULL,NULL,NULL),(383,6,6,0,'ModComments Attachment',NULL,'2023-05-11 02:47:52','2023-05-11 02:47:52',NULL,NULL,0,1,0,NULL,NULL,NULL),(384,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : 380<br />\r\nTicket Title : 110355/Lolinda/Installation of 2 Handhelds<br />\r\n<br />\r\nDear Dalrymple Yann,<br />\r\n<br />\r\nYou have been assigned to the following ticket:<br />\r\n<br />\r\nTicket No : TKT000100<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDYNAMIX TICKET NUMBER:&nbsp;110355<br />\r\n<br />\r\nDescription :<br />\r\nHello,<br />\n<br />\n <br />\nWe would like to request a technician for the location below:<br />\n<br />\nAddress: 2518 Mission Street<br />\n<br />\nDate: April 26, 2023 (Wednesday)<br />\n<br />\nTime: 01:00PM PST<br />\n<br />\nAccess to Store:  TBD<br />\n<br />\nDynamix Ref Number: 110355<br />\n<br />\nDevice Type: 2 Handhelds<br />\n<br />\nConnection Type: Wireless<br />\n<br />\n<br />\nWork Needed:<br />\nTask 1: Connect the Handhelds to PNET (coordinate with support for the password)<br />\nTask 2: Log in to Toast using the email and password that is associated with the store’s Toast Account<br />\nTask 3: Enable EMV <br />\nOn the lower left corner of the passcode screen, select credit card icon.<br />\nEnter Pin to log in.<br />\nFrom the main menu, go to set up and select device set up.<br />\nScroll down and select EMV enabled.<br />\nSelect Yes.<br />\nTask 4: Provide support with the MAC address and Serial Number of the device for Mapping and Documentation purposes.<br />\nTask 5: Make sure to label Handhelds FLOL001-HH-01 and FLOL001-HH-03<br />\n<br />\n<br />\nBest regards,<br />\nChristine<br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size:20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family:verdana,geneva,sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-11 03:00:02','2023-05-11 03:00:02',NULL,NULL,0,1,0,0,'CRM','YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000100 110355/Lolinda/Installation of 2 Handhelds DYNAMIX NUMBER 110355'),(385,6,5,1,'HelpDesk','RE: 110450 / Afterwork Bar / TV sounds and TV outside','2023-05-11 03:00:59','2023-05-19 03:52:01',NULL,NULL,0,1,0,0,'CRM','RE: 110450 / Afterwork Bar / TV sounds and TV outside'),(386,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : 385<br />\r\nTicket Title : RE: 110450 / Afterwork Bar / TV sounds and TV outside<br />\r\n<br />\r\nDear Dalrymple Yann,<br />\r\n<br />\r\nYou have been assigned to the following ticket:<br />\r\n<br />\r\nTicket No : TKT000101<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : High<br />\r\n<br />\r\nDYNAMIX TICKET NUMBER:&nbsp;11450<br />\r\n<br />\r\nDescription :<br />\r\nRE: 110450 / Afterwork Bar / TV sounds and TV outside<br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size:20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family:verdana,geneva,sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-11 03:15:01','2023-05-11 03:15:01',NULL,NULL,0,1,0,0,'CRM','YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000101 RE: 110450 / Afterwork Bar / TV sounds and TV outside DYNAMIX NUMBER 11450'),(387,6,5,6,'HelpDesk','Hello,\nWe would like to request a technician for the location below ASAP:\nAddress: 409 Gough Street, San Francisco CA, 94102\nDate: April 26, 2023\nTime: ASAP\nAccess to Store:  Granted\nDynamix Ref Number: 11450\nDevice Type:  TV\nWork Needed:\nTo check the TV sounds\nTo check the TV outside\nThank you and looking forward to your response.\n \nKind Regards,\nDianah','2023-05-11 07:11:40','2023-05-11 07:22:30',NULL,NULL,0,1,1,0,'CRM','110450 / Afterwork Bar / TV sounds and TV outside'),(388,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Dear Solorzano Angel,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 272<br />\r\nTicket Title : Wildseed Palo Alto / Printer Replacement<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000085<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello,<br />\n<br />\nWe would like to request a technician for the location below:<br />\n<br />\nAddress: 855 El Camino Real #110<br />\nDate: April 24, 2023 (Monday)<br />\nTime: 9:00 AM PST<br />\nAccess to Store: Granted<br />\nDynamix Ref Number: 110291<br />\nDevice Type: Grill Printer /<br />\nConnection Type: Ethernet connection<br />\n<br />\n <br />\n<br />\nWork Needed:<br />\n<br />\n- Check the Network connection of the printer since it will not pick up the correct IP address<br />\n- Verify that the printer is getting a correct IP address<br />\n- Run a test order and confirm that the printer is working<br />\n- Make sure the label is added to the replacement device<br />\n<br />\n <br />\n<br />\nTroubleshooting Steps were taken:<br />\n<br />\n· Checked printer connections and reboot<br />\n· Performed test printer- it worked but could not print from the terminal<br />\n· Performed Hard Reset<br />\n· Checked backend settings and verified It’s routed to the correct printer<br />\n· Since it was still not working, rerouted to another printer and it worked.<br />\n· Replace the defective printer and after installing the replacement printer, still not printing<br />\n<br />\n<br />\nThank you and looking forward to your response.<br />\n<br />\nKind Regards,<br />\nDianah<br />\r\n<br />\r\nSolution :<br />\r\nCheck the Network connection of the printer 				<br />\nsince it will not pick up the correct IP address <br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span></body>\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></html>\r\n<br><br>','2023-05-11 07:15:01','2023-05-11 07:15:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000085 Wildseed Palo Alto / Printer Replacement DYNAMIX Number 110291'),(389,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : 387<br />\r\nTicket Title : 110450 / Afterwork Bar / TV sounds and TV outside<br />\r\n<br />\r\nDear Dalrymple Yann,<br />\r\n<br />\r\nYou have been assigned to the following ticket:<br />\r\n<br />\r\nTicket No : TKT000102<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDYNAMIX TICKET NUMBER:&nbsp;110450<br />\r\n<br />\r\nDescription :<br />\r\nHello,<br />\nWe would like to request a technician for the location below ASAP:<br />\nAddress: 409 Gough Street, San Francisco CA, 94102<br />\nDate: April 26, 2023<br />\nTime: ASAP<br />\nAccess to Store:  Granted<br />\nDynamix Ref Number: 11450<br />\nDevice Type:  TV<br />\nWork Needed:<br />\nTo check the TV sounds<br />\nTo check the TV outside<br />\nThank you and looking forward to your response.<br />\n <br />\nKind Regards,<br />\nDianah<br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size:20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family:verdana,geneva,sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-11 07:15:12','2023-05-11 07:15:12',NULL,NULL,0,1,0,0,'CRM','YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000102 110450 / Afterwork Bar / TV sounds and TV outside DYNAMIX NUMBER 110450'),(390,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 371<br />\r\nTicket Title : 110388/Wildseed Palo Alto/Remove 6 Port Switch<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000098<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello, <br />\n<br />\n  <br />\nWe would like to request a technician for the location below: <br />\n<br />\n<br />\nAddress: 855 El Camino Real #110 <br />\n<br />\nDate: April 26, 2023 (Wednesday) <br />\n<br />\nTime: 07:00 AM PST <br />\n<br />\nAccess to Store:  TBD <br />\n<br />\nDynamix Ref Number: 110291 <br />\n<br />\nDevice Type: 6 Port Switch<br />\r\n<br />\r\nSolution :<br />\r\nTo all, <br />\nRecap from Service Call: <br />\nArrived on site and called the Bridge <br />\nStarted checking the available Ports on the kitchen line (Ports 4, 54, 7,8 and 11)  <br />\nPort 4 and Port 5 tested fine <br />\nPort 7 is where the Switch was connected to <br />\nPort 8 had been fixed has the Kitchen KDS was connected to that Port <br />\nPort 11 was still bad <br />\nThen proceeded to connect the KP Bar to Port 4 <br />\nConnected on the Switch as well to Port 4 <br />\nTested it with technician who could see it online <br />\nRemoved the cable that was used to connect to the 8 Port Switch <br />\nExplain to technician that they were not enough Ports available to remove the 8 Port Switch connected to Port 7 <br />\nPort 2 of the 8 Port Switch is connected to the Expo printer <br />\nPort 3 is connected to the Pantry printer <br />\nPort 5 is connected to the Grill printer <br />\nI could not locate Patch Panel Port 9 and 10 on the Hot line and they are probably behind the hotline shelves (which is extremely to move to see where those Ports might be located at <br />\nPort 9 and Port 10 were covered on the Patch Panel in the Rack for some reasons which I do not know <br />\nIt would be my recommendation to send to send Access Cabling to fix Port 11 and locate Port 9 and 10 to test them as well so we can actually remove the temporary Switch  <br />\nWhen that portion of the work was done, I worked with Dynamix Support on the Toast equipment identification and a specific Excel sheet will be provided separately <br />\nI had the restaurant Manager checked the Toast system before leaving to validate that everything was working as expected <br />\nLeft the site at about 11:00 am <br />\nThank you. <br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span></body>\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></html>\r\n<br><br>','2023-05-11 07:30:01','2023-05-11 07:30:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000098 110388/Wildseed Palo Alto/Remove 6 Port Switch DYNAMIX Number 110388'),(391,6,5,6,'HelpDesk','Hello,\n\nWe would like to request a technician for the location below ASAP:\n\nAddress: 409 Gough Street, San Francisco CA, 94102\nDate: April 26, 2023\nTime: ASAP\nAccess to Store:  Granted\nDynamix Ref Number: 11450\nDevice Type:  TV\n\nWork Needed:\nTo check the TV sounds\nTo check the TV outside\n\nThank you and looking forward to your response.\n\n \n\nKind Regards,\nDianah','2023-05-11 07:42:44','2023-05-19 06:03:52',NULL,NULL,0,1,0,0,'CRM','110352 / Afterwork bar / Reconnect Television to Matrix'),(392,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 371<br />\r\nTicket Title : 110388/Wildseed Palo Alto/Remove 6 Port Switch<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000098<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello, <br />\n<br />\n  <br />\nWe would like to request a technician for the location below: <br />\n<br />\n<br />\nAddress: 855 El Camino Real #110 <br />\n<br />\nDate: April 26, 2023 (Wednesday) <br />\n<br />\nTime: 07:00 AM PST <br />\n<br />\nAccess to Store:  TBD <br />\n<br />\nDynamix Ref Number: 110291 <br />\n<br />\nDevice Type: 6 Port Switch<br />\n<br />\n-------- Original message -------- <br />\nFrom: Dynamix Frontline Services  <br />\nDate: 4/25/23 1:21 PM (GMT-05:00) <br />\nTo: yann@mybluetechnology.com<br />\nCc: jc@mybluetechnology.com, ndairkee@backofthehouseinc.com, supportticket@mybluetechnology.com<br />\nSubject: RE: 110388/Wildseed Palo Alto/Remove 6 Port Switch <br />\n  <br />\nHello Yann,<br />\n<br />\nI hope all is well. We would also like to request your assistance with the auditing of all devices at Wildseed Palo Alto. This audit is necessary to ensure that all documentation related to these devices is accurate and up-to-date.<br />\n<br />\nAttached to this email, you will find an excel file that we will use to track the audit results. Please fill out the information required in the file and send it back to us once the audit is complete.<br />\n<br />\nIf you have any questions or concerns about this, please do not hesitate to contact us.<br />\n<br />\nBest regards,<br />\nDale<br />\r\n<br />\r\nSolution :<br />\r\nTo all, <br />\nRecap from Service Call: <br />\nArrived on site and called the Bridge <br />\nStarted checking the available Ports on the kitchen line (Ports 4, 54, 7,8 and 11)  <br />\nPort 4 and Port 5 tested fine <br />\nPort 7 is where the Switch was connected to <br />\nPort 8 had been fixed has the Kitchen KDS was connected to that Port <br />\nPort 11 was still bad <br />\nThen proceeded to connect the KP Bar to Port 4 <br />\nConnected on the Switch as well to Port 4 <br />\nTested it with technician who could see it online <br />\nRemoved the cable that was used to connect to the 8 Port Switch <br />\nExplain to technician that they were not enough Ports available to remove the 8 Port Switch connected to Port 7 <br />\nPort 2 of the 8 Port Switch is connected to the Expo printer <br />\nPort 3 is connected to the Pantry printer <br />\nPort 5 is connected to the Grill printer <br />\nI could not locate Patch Panel Port 9 and 10 on the Hot line and they are probably behind the hotline shelves (which is extremely to move to see where those Ports might be located at <br />\nPort 9 and Port 10 were covered on the Patch Panel in the Rack for some reasons which I do not know <br />\nIt would be my recommendation to send to send Access Cabling to fix Port 11 and locate Port 9 and 10 to test them as well so we can actually remove the temporary Switch  <br />\nWhen that portion of the work was done, I worked with Dynamix Support on the Toast equipment identification and a specific Excel sheet will be provided separately <br />\nI had the restaurant Manager checked the Toast system before leaving to validate that everything was working as expected <br />\nLeft the site at about 11:00 am <br />\nThank you. <br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span></body>\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></html>\r\n<br><br>','2023-05-11 07:45:02','2023-05-11 07:45:02',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000098 110388/Wildseed Palo Alto/Remove 6 Port Switch DYNAMIX Number 110388'),(393,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : 391<br />\r\nTicket Title : 110352 / Afterwork bar / Reconnect Television to Matrix<br />\r\n<br />\r\nDear Dalrymple Yann,<br />\r\n<br />\r\nYou have been assigned to the following ticket:<br />\r\n<br />\r\nTicket No : TKT000103<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Major<br />\r\nPriority : High<br />\r\n<br />\r\nDYNAMIX TICKET NUMBER:&nbsp;110352<br />\r\n<br />\r\nDescription :<br />\r\nHello,<br />\nWe would like to request a technician for the location below:<br />\nAddress: 409 Gough Street, San Francisco CA, 94102<br />\nDate: May 1, 2023 (Monday)<br />\nTime: 11:00 AM PST<br />\nAccess to Store:  Granted<br />\nDynamix Ref Number: 110352<br />\nDevice Type:  TV<br />\nWork Needed:<br />\nTo make sure that the TV at Table 300 would sync to the matrix and would pick the channel properly<br />\nTroubleshooting Steps were taken:<br />\nRebooted the TV<br />\nThank you and looking forward to your response.<br />\nKind Regards,<br />\nDianah<br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size:20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family:verdana,geneva,sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-11 07:45:11','2023-05-11 07:45:11',NULL,NULL,0,1,0,0,'CRM','YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000103 110352 / Afterwork bar / Reconnect Television to Matrix DYNAMIX NUMBER 110352'),(394,6,9,6,'HelpDesk','Lockbox has been left on patio door with code 1987. Fans are on a shelf above the computer, on the left side. Please replace both and bring the old ones back to BOH for testing. \n  \nThere is a Pandora Mood Media device on the left rack. Remove this and ensure the CloudBox device is connected to the amplifier - this should already be done but please confirm. Bring Mood Media device with power supply back to BOH with switch fans. \n  \nLast, there is an Arris modem just hanging on wall. Make sure this is secured- either in the rack or on the wall.  \n  \nEquipment return to BOH tomorrow is not required. You can either drop off to SD Novato or bring to BOH next time you have a call in SF.','2023-05-11 07:58:42','2023-05-17 16:55:20',NULL,NULL,0,1,0,0,'CRM','Request Tech Visit Switch Installation at SD Concord'),(395,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : 394<br />\r\nTicket Title : Request Tech Visit Switch Installation at SD Concord<br />\r\n<br />\r\nDear Solorzano Angel,<br />\r\n<br />\r\nYou have been assigned to the following ticket:<br />\r\n<br />\r\nTicket No : TKT000104<br />\r\nStatus : Wait For Response<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDYNAMIX TICKET NUMBER:&nbsp;999999<br />\r\n<br />\r\nDescription :<br />\r\nLockbox has been left on patio door with code 1987. Fans are on a shelf above the computer, on the left side. Please replace both and bring the old ones back to BOH for testing. <br />\n  <br />\nThere is a Pandora Mood Media device on the left rack. Remove this and ensure the CloudBox device is connected to the amplifier - this should already be done but please confirm. Bring Mood Media device with power supply back to BOH with switch fans. <br />\n  <br />\nLast, there is an Arris modem just hanging on wall. Make sure this is secured- either in the rack or on the wall.  <br />\n  <br />\nEquipment return to BOH tomorrow is not required. You can either drop off to SD Novato or bring to BOH next time you have a call in SF.<br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size:20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family:verdana,geneva,sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-11 08:00:01','2023-05-11 08:00:06',NULL,NULL,0,1,1,0,'CRM','YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000104 Request Tech Visit Switch Installation at SD Concord DYNAMIX NUMBER 999999'),(396,6,9,1,'HelpDesk','We would like to request a technician for the location below:\n\nAddress: 5800 Nave Drive, Suite C, Novato\n\nDate: April 24, 2023 (Monday)\n\nTime: 7:00 AM PST\n\nAccess to Store:  Granted c/o staff\n\nDynamix Ref Number: 110353\n\nDevice Type: KDS\n\nConnection Type: Hardwired \n \n\nWork Needed:\n\nTask 1: Install the replacement KDS\nTask 2: Make sure label is added to the device CSD008-KDS-002\nTask 3: Drop off the defective unit back to Toast.\n\n\n\nBest regards, \nChristine','2023-05-11 08:05:41','2023-05-11 08:15:02',NULL,NULL,0,1,0,0,'CRM','Super Duper - Novato/Installation of KDS'),(397,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : 396<br />\r\nTicket Title : Super Duper - Novato/Installation of KDS<br />\r\n<br />\r\nDear Solorzano Angel,<br />\r\n<br />\r\nYou have been assigned to the following ticket:<br />\r\n<br />\r\nTicket No : TKT000105<br />\r\nStatus : Closed<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDYNAMIX TICKET NUMBER:&nbsp;110353<br />\r\n<br />\r\nDescription :<br />\r\nWe would like to request a technician for the location below:<br />\n<br />\nAddress: 5800 Nave Drive, Suite C, Novato<br />\n<br />\nDate: April 24, 2023 (Monday)<br />\n<br />\nTime: 7:00 AM PST<br />\n<br />\nAccess to Store:  Granted c/o staff<br />\n<br />\nDynamix Ref Number: 110353<br />\n<br />\nDevice Type: KDS<br />\n<br />\nConnection Type: Hardwired <br />\n <br />\n<br />\nWork Needed:<br />\n<br />\nTask 1: Install the replacement KDS<br />\nTask 2: Make sure label is added to the device CSD008-KDS-002<br />\nTask 3: Drop off the defective unit back to Toast.<br />\n<br />\n<br />\n<br />\nBest regards, <br />\nChristine<br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size:20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family:verdana,geneva,sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-11 08:15:02','2023-05-11 08:15:02',NULL,NULL,0,1,0,0,'CRM','YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000105 Super Duper - Novato/Installation of KDS DYNAMIX NUMBER 110353'),(398,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 271<br />\r\nTicket Title : BT Tech Request<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000084<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello,<br />\n<br />\nWe would like to request a technician for the location below:<br />\n<br />\nAddress: 595 Market Street San Francisco, Ca 94105<br />\n<br />\nDate: Requested for any date between 4/24-4/26<br />\n<br />\nTime: From 8:00 AM PST - 9:00 AM PST<br />\n<br />\nAccess to Store:  Granted by staff<br />\n<br />\nDynamix Ref Number: 109070<br />\n<br />\nDevice Type: Cloudbox<br />\n<br />\nConnection Type: Ethernet Port and AV Cables<br />\n<br />\nWork Needed:<br />\nTask 1: Replace current DMX Pandora Device with Cloudbox<br />\nTask 2: Connect Cloudbox to Port 14 on switch <br />\nTask 3: Connect Cloudbox to audio output for AV system<br />\n<br />\nPlease let me know if you need anything else from me.<br />\n<br />\nThank you,<br />\nChristian Cruz<br />\r\n<br />\r\nSolution :<br />\r\nTo all, <br />\nRecap for Service call: <br />\nArrived on site an jumped on the Bridge (I did not have any specific Bridge info but I checked anyway) and then I jumped on the second bridge that I used in the past but still by myself at that time.  Called Dynamix Support to reach Christian directly and we finally connected.  While on site, I realized that I did not have the correct connector to connect the AV cable and the network cable together next to each other to the Cloud Cover as you can see on the pictures sent earlier.  I knew of a Computer Store (Central Computers) near by that opened at 9:00 am so I went on site and was able to get the proper adapter to allow the connection to Cloud Cover.  I connected to Port 17 originally (Port 14 was being used but I saw it was not connected to anything so I connected Cloud Cover to Port 14 but the volume was still very loud so I reconnected the DMX to ensure that they had proper music which they could control.  Christian told me that some other software might possibly still needed to be installed but the physical connection is done (Cloud Cover to network and AV cable ready to connect).  Either myself or Herman (Manager on site) will simply need to move the the AV (white and Red cable to the Cloud Cover from the DMX when ready so Unos Dos Tacos can test it and possibly control the volume unless it\'s controlled on the PC itself.  Since the restaurant was open when I came back, I did not want to inconvenience the on site customers with possible loud music.  Please let me know if they are additional steps that need to take place.  Thank you. <br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span></body>\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></html>\r\n<br><br>','2023-05-11 08:15:04','2023-05-11 08:15:04',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000084 BT Tech Request DYNAMIX Number 109070'),(399,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Dear Solorzano Angel,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 394<br />\r\nTicket Title : Request Tech Visit Switch Installation at SD Concord<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000104<br />\r\nStatus : Closed<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nLockbox has been left on patio door with code 1987. Fans are on a shelf above the computer, on the left side. Please replace both and bring the old ones back to BOH for testing. <br />\n  <br />\nThere is a Pandora Mood Media device on the left rack. Remove this and ensure the CloudBox device is connected to the amplifier - this should already be done but please confirm. Bring Mood Media device with power supply back to BOH with switch fans. <br />\n  <br />\nLast, there is an Arris modem just hanging on wall. Make sure this is secured- either in the rack or on the wall.  <br />\n  <br />\nEquipment return to BOH tomorrow is not required. You can either drop off to SD Novato or bring to BOH next time you have a call in SF.<br />\r\n<br />\r\nSolution :<br />\r\nAfter replacing the fans (2) on the switch,  everything looked good: <br />\n  <br />\n* Toast devices are online. <br />\n  <br />\n* Office computers have the internet. <br />\n  <br />\n* Wifi works fine,  online. <br />\n  <br />\n* Music on cloud box is playing normally <br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span></body>\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></html>\r\n<br><br>','2023-05-11 17:28:02','2023-05-11 17:28:02',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000104 Request Tech Visit Switch Installation at SD Concord DYNAMIX Number 999999'),(400,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Dear Lapinsee Bim,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 367<br />\r\nTicket Title : Dela Rosa Yerba Buena / Wiring issue from Patch<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000097<br />\r\nStatus : Open<br />\r\nCategory : Big Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello Dianah,<br />\n <br />\nLockbox has already been left onsite for access at 7am and Bim has been informed of location and code. We’ll keep the scheduled time.<br />\n <br />\nPlease note that as discussed on Monday’s meeting, issue with ticket 110406 is resolved. Expo printer is showing correct IP of 192.168.192.173 and working as expected.<br />\n <br />\nThis call is to address ticket 110458 and 108635. During the KDS installation, we had to resort to using a WiFi connection because none of the devices were retaining the assigned IP. NOC also needed to configure a port outside of PNET range - please ensure they are scheduled on standby for this call as we need a port configured on the switch. See configurations sent on 4/27 on ticket 108635 below:<br />\nDevice Name	Device Label Name	MAC Address	 <br />\nIP Address	Serial Number	Patch Panel	Switch Port<br />\nCOLD KDS	FDLA002-KDS-002	74:F7:F6:3D:AE:1F	 <br />\n192.168.192.71	LS84221Q41125	18	1<br />\nHOT KDS	FDLA002-KDS-003	74:F7:F6:3D:BE:D5	 <br />\n192.168.192.72	LS84221U40182	20	4<br />\nPIZZA KDS	FDLA002-KDS-004	74:F7:F6:3D:99:A9	 <br />\n192.168.192.73	LS84221Q40073	22	13<br />\n <br />\nNotice that switch port 13 was used. This needs to be changed as Port 13 is assigned exclusively to music devices. @bim@mybluetechnology.com Please make this change to the next available port and communicate with Dynamix team here or on the bridge. NOC team needs to configure the port for Toast devices outside of 1-12 range. Once the correct IP is being retained via RJ45 connection on the Toast devices – you’ll need to disable WiFi connection and forget the saved network. I will send you a separate email with your unique Toast credentials.<br />\n <br />\nPlease don’t hesitate to reach out to me directly with any questions.<br />\n <br />\nBest,<br />\nNuranne<br />\n <br />\nFrom: Dynamix Frontline Services <br />\nSent: Tuesday, May 2, 2023 9:24 PM<br />\nTo: bim@mybluetechnology.com<br />\nCc: jc@mybluetechnology.com; supportticket@mybluetechnology.com; Nuranne Dairkee <br />\nSubject: Re: Dela Rosa Yerba Buena / Wiring issue from Patch<br />\n <br />\nHello Bim,<br />\n<br />\nI hope all is well. <br />\n<br />\nWe would like to request to move the schedule to 8 AM instead of 7 AM since the earliest staff will arrive at 8 AM.<br />\n<br />\nThank you for your patience.<br />\n<br />\nKind Regards,<br />\nDianah<br />\n--------------- Original Message ---------------<br />\nFrom: Dynamix Frontline Services [frontline@dynamixsupport.com]<br />\nSent: 5/1/2023, 7:39 PM<br />\nTo: bim@mybluetechnology.com<br />\nCc: jc@mybluetechnology.com; supportticket@mybluetechnology.com; ndairkee@backofthehouseinc.com<br />\nSubject: Re: Dela Rosa Yerba Buena / Wiring issue from Patch<br />\n<br />\nHello Bim,<br />\n<br />\n<br />\nKindly see the bridge information below:<br />\n<br />\nConference Bridge (510) 982-2772<br />\nParticipant Pin #96875<br />\n<br />\n<br />\n<br />\nRegards,<br />\nChristine<br />\n<br />\n<br />\n--------------- Original Message ---------------<br />\nFrom: Bim [bim@mybluetechnology.com]<br />\nSent: 5/1/2023, 1:50 PM<br />\nTo: frontline@dynamixsupport.com<br />\nCc: jc@mybluetechnology.com; supportticket@mybluetechnology.com; ndairkee@backofthehouseinc.com<br />\nSubject: Re: Dela Rosa Yerba Buena / Wiring issue from Patch<br />\n<br />\nConfirmed, I will be there Wednesday 3rd of May at 7.am and will pick up key on Tuesday 8pm please prepare for me.<br />\n <br />\nBim Tech <br />\nSan Francisco <br />\n4156322318<br />\n <br />\n<br />\nHello,<br />\nWe would like to request a technician for the location below:<br />\nAddress: 37 Yerba Buena San Francisco CA, 94103<br />\nDate: April 26, 2023 (Wednesday)<br />\nTime: 7:00 AM PST<br />\nAccess to Store:  Granted<br />\nDynamix Ref Number: 110406<br />\nDevice Type:  <br />\nConnection Type: Ethernet connection<br />\nWork Needed:<br />\nTo confirm the patch status<br />\nTroubleshooting Steps were taken:<br />\nConfigured - FDLA002-KP-HOT in Meraki<br />\nAdded MAC- 50:57:9c:58:c8:1b / IP - 192.168.192.170<br />\nPing Test - responding / Loss rate - 0%<br />\nTest Print -Working<br />\nFDLA002-KP-EXPO<br />\n> Connected to a patch > Switch port number 6 > IP: None<br />\nProperly Onboarded in Meraki - 50:57:9c:58:ad:8c/ 192.168.192.173<br />\nPing Test- 100% Packet Loss<br />\nBypassed the patch and connect it straight to the switch<br />\nPerformed Powercycle. Ip now shows - 192.168.192.173<br />\nPing test - 0% packet loss<br />\ntest print - Okay<br />\nThe printer is not working behind the patch<br />\nThank you and looking forward to your response.<br />\nKind Regards,<br />\nDianah<br />\r\n<br />\r\nSolution :<br />\r\n <br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span></body>\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></html>\r\n<br><br>','2023-05-11 17:58:02','2023-05-11 17:58:02',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000097 Dela Rosa Yerba Buena / Wiring issue from Patch DYNAMIX Number 110406'),(401,6,5,5,'HelpDesk','We would like to request a technician for the location below:\n  \n•	Address: 855 El Camino Real #110\n•	Date: May 15\n•	Time: 9:30AM AM PST\n•	Access to Store:  Granted c/o Manager \n•	Dynamix Ref Number: 110888\n•	Device Type: KDS \n•	Connection Type: Hardwired\n\n\nWork Needed: \n1. Remove the defective KDS with label  FWLD002-KDS-001\n2. Install and set up the replacement KDS \n3. Put the label  FWLD002-KDS-001 \n4.Check the EXPO printer with label  FWLD002-KP-EXPO because it\'s printing and not getting an IP address. \n5. Drop off the defective KDS \n\n\nTroubleshooting Steps Done: \nKDS:\n•	Check ports from the KDS\n•	Tried Different ethernet cable\n•	It will not stay connected not unless the KDS will place upside down\nPrinter:\n•	Print test page - No ip\n•	check the physical connection\n\n\nRegards, \nClaudette','2023-05-12 00:30:18','2023-05-19 03:40:59',NULL,NULL,0,1,0,0,'CRM','Installation of replacement KDS FWLD002-KDS-001'),(402,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : 401<br />\r\nTicket Title : Installation of replacement KDS FWLD002-KDS-001<br />\r\n<br />\r\nDear Dalrymple Yann,<br />\r\n<br />\r\nYou have been assigned to the following ticket:<br />\r\n<br />\r\nTicket No : TKT000106<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDYNAMIX TICKET NUMBER:&nbsp;110888<br />\r\n<br />\r\nDescription :<br />\r\nWe would like to request a technician for the location below:<br />\n  <br />\n•	Address: 855 El Camino Real #110<br />\n•	Date: May 15<br />\n•	Time: 9:30AM AM PST<br />\n•	Access to Store:  Granted c/o Manager <br />\n•	Dynamix Ref Number: 110888<br />\n•	Device Type: KDS <br />\n•	Connection Type: Hardwired<br />\n<br />\n<br />\nWork Needed: <br />\n1. Remove the defective KDS with label  FWLD002-KDS-001<br />\n2. Install and set up the replacement KDS <br />\n3. Put the label  FWLD002-KDS-001 <br />\n4.Check the EXPO printer with label  FWLD002-KP-EXPO because it\'s printing and not getting an IP address. <br />\n5. Drop off the defective KDS <br />\n<br />\n<br />\nTroubleshooting Steps Done: <br />\nKDS:<br />\n•	Check ports from the KDS<br />\n•	Tried Different ethernet cable<br />\n•	It will not stay connected not unless the KDS will place upside down<br />\nPrinter:<br />\n•	Print test page - No ip<br />\n•	check the physical connection<br />\n<br />\n<br />\nRegards, <br />\nClaudette<br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size:20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family:verdana,geneva,sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-12 00:44:01','2023-05-12 00:44:01',NULL,NULL,0,1,0,0,'CRM','YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000106 Installation of replacement KDS FWLD002-KDS-001 DYNAMIX NUMBER 110888'),(403,10,10,10,'ModComments',NULL,'2023-05-15 18:51:14','2023-05-15 18:51:14',NULL,NULL,0,1,0,0,'CRM','IP Address Pizza KDS before moved to port 38'),(404,10,10,0,'ModComments Attachment',NULL,'2023-05-15 18:51:14','2023-05-15 18:51:14',NULL,NULL,0,1,0,NULL,NULL,NULL),(405,10,10,0,'ModComments Attachment',NULL,'2023-05-15 18:51:14','2023-05-15 18:51:14',NULL,NULL,0,1,0,NULL,NULL,NULL),(406,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Dear Lapinsee Bim,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 359<br />\r\nTicket Title : Tech Visit at Dela Rosa Yerba Buena /  Connect Newly Opened Ports to Patch Panel<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000095<br />\r\nStatus : Open<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nAddress: 37 Yerba Buena, San Francisco (Delarosa Yerba Buena)<br />\nDate: May 15, Monday<br />\nTime: 7:00 AM PST<br />\nAccess to Store:  Granted <br />\nDynamix Ref Number: 110406<br />\nConnection Type: Hardwired <br />\n <br />\n<br />\nWork Needed:<br />\nTask 1 Confirm if the newly ports are connected to the patch<br />\nTask 2 To connect the KDSs to the patch<br />\nTask 3  Secure wired connection for KDS<br />\nTask 4 Make sure  IP\'s on KDS are valid<br />\n<br />\nRegards,<br />\nAlexandra<br />\r\n<br />\r\nSolution :<br />\r\n-	KDS  3 terminals work only 1 for Hot KDS <br />\n-	From the beginning of start Pizza KDS shown not correct IP addresses :10.120.16.222   but when moved to port switch  38 IP got corrected  but keeping shown on and off in 2 seconds both port 37 and 38 got same problem and also switch light at port turn on and off every 2 second.<br />\n-	I checked all cable network signal from patch panel many times already that 100% pass thru complete signal and rechecked every time before starting this mission and sure that IP shown on and off not from patch panel or cable issued because I have tried directed connected pass thru from KDS to switch port directly it’s same problem that IP address shown on and off .<br />\n-	Clean up area for kitchen turn to work.<br />\n-	Today I put everything back on <br />\n    <br />\n               KDS Cold connected to Switch  37   but inactive  RJ45  then use WiFi connected<br />\n               KDS Hot Working Perfect  Switch port 4<br />\n               KDS Pizza connected to Switch port 38 but inactive  RJ45  then use WiFi connected<br />\n<br />\n              My opinion is that switch hub have something wrong . <br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span></body>\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></html>\r\n<br><br>','2023-05-15 18:54:01','2023-05-15 18:54:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000095 Tech Visit at Dela Rosa Yerba Buena /  Connect Newly Opened Ports to Patch Panel DYNAMIX Number 110406'),(407,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Dear Lapinsee Bim,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 367<br />\r\nTicket Title : Dela Rosa Yerba Buena / Wiring issue from Patch<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000097<br />\r\nStatus : Closed<br />\r\nCategory : Big Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello Dianah,<br />\n <br />\nLockbox has already been left onsite for access at 7am and Bim has been informed of location and code. We’ll keep the scheduled time.<br />\n <br />\nPlease note that as discussed on Monday’s meeting, issue with ticket 110406 is resolved. Expo printer is showing correct IP of 192.168.192.173 and working as expected.<br />\n <br />\nThis call is to address ticket 110458 and 108635. During the KDS installation, we had to resort to using a WiFi connection because none of the devices were retaining the assigned IP. NOC also needed to configure a port outside of PNET range - please ensure they are scheduled on standby for this call as we need a port configured on the switch. See configurations sent on 4/27 on ticket 108635 below:<br />\nDevice Name	Device Label Name	MAC Address	 <br />\nIP Address	Serial Number	Patch Panel	Switch Port<br />\nCOLD KDS	FDLA002-KDS-002	74:F7:F6:3D:AE:1F	 <br />\n192.168.192.71	LS84221Q41125	18	1<br />\nHOT KDS	FDLA002-KDS-003	74:F7:F6:3D:BE:D5	 <br />\n192.168.192.72	LS84221U40182	20	4<br />\nPIZZA KDS	FDLA002-KDS-004	74:F7:F6:3D:99:A9	 <br />\n192.168.192.73	LS84221Q40073	22	13<br />\n <br />\nNotice that switch port 13 was used. This needs to be changed as Port 13 is assigned exclusively to music devices. @bim@mybluetechnology.com Please make this change to the next available port and communicate with Dynamix team here or on the bridge. NOC team needs to configure the port for Toast devices outside of 1-12 range. Once the correct IP is being retained via RJ45 connection on the Toast devices – you’ll need to disable WiFi connection and forget the saved network. I will send you a separate email with your unique Toast credentials.<br />\n <br />\nPlease don’t hesitate to reach out to me directly with any questions.<br />\n <br />\nBest,<br />\nNuranne<br />\n <br />\nFrom: Dynamix Frontline Services <br />\nSent: Tuesday, May 2, 2023 9:24 PM<br />\nTo: bim@mybluetechnology.com<br />\nCc: jc@mybluetechnology.com; supportticket@mybluetechnology.com; Nuranne Dairkee <br />\nSubject: Re: Dela Rosa Yerba Buena / Wiring issue from Patch<br />\n <br />\nHello Bim,<br />\n<br />\nI hope all is well. <br />\n<br />\nWe would like to request to move the schedule to 8 AM instead of 7 AM since the earliest staff will arrive at 8 AM.<br />\n<br />\nThank you for your patience.<br />\n<br />\nKind Regards,<br />\nDianah<br />\n--------------- Original Message ---------------<br />\nFrom: Dynamix Frontline Services [frontline@dynamixsupport.com]<br />\nSent: 5/1/2023, 7:39 PM<br />\nTo: bim@mybluetechnology.com<br />\nCc: jc@mybluetechnology.com; supportticket@mybluetechnology.com; ndairkee@backofthehouseinc.com<br />\nSubject: Re: Dela Rosa Yerba Buena / Wiring issue from Patch<br />\n<br />\nHello Bim,<br />\n<br />\n<br />\nKindly see the bridge information below:<br />\n<br />\nConference Bridge (510) 982-2772<br />\nParticipant Pin #96875<br />\n<br />\n<br />\n<br />\nRegards,<br />\nChristine<br />\n<br />\n<br />\n--------------- Original Message ---------------<br />\nFrom: Bim [bim@mybluetechnology.com]<br />\nSent: 5/1/2023, 1:50 PM<br />\nTo: frontline@dynamixsupport.com<br />\nCc: jc@mybluetechnology.com; supportticket@mybluetechnology.com; ndairkee@backofthehouseinc.com<br />\nSubject: Re: Dela Rosa Yerba Buena / Wiring issue from Patch<br />\n<br />\nConfirmed, I will be there Wednesday 3rd of May at 7.am and will pick up key on Tuesday 8pm please prepare for me.<br />\n <br />\nBim Tech <br />\nSan Francisco <br />\n4156322318<br />\n <br />\n<br />\nHello,<br />\nWe would like to request a technician for the location below:<br />\nAddress: 37 Yerba Buena San Francisco CA, 94103<br />\nDate: April 26, 2023 (Wednesday)<br />\nTime: 7:00 AM PST<br />\nAccess to Store:  Granted<br />\nDynamix Ref Number: 110406<br />\nDevice Type:  <br />\nConnection Type: Ethernet connection<br />\nWork Needed:<br />\nTo confirm the patch status<br />\nTroubleshooting Steps were taken:<br />\nConfigured - FDLA002-KP-HOT in Meraki<br />\nAdded MAC- 50:57:9c:58:c8:1b / IP - 192.168.192.170<br />\nPing Test - responding / Loss rate - 0%<br />\nTest Print -Working<br />\nFDLA002-KP-EXPO<br />\n> Connected to a patch > Switch port number 6 > IP: None<br />\nProperly Onboarded in Meraki - 50:57:9c:58:ad:8c/ 192.168.192.173<br />\nPing Test- 100% Packet Loss<br />\nBypassed the patch and connect it straight to the switch<br />\nPerformed Powercycle. Ip now shows - 192.168.192.173<br />\nPing test - 0% packet loss<br />\ntest print - Okay<br />\nThe printer is not working behind the patch<br />\nThank you and looking forward to your response.<br />\nKind Regards,<br />\nDianah<br />\r\n<br />\r\nSolution :<br />\r\nRechecked all cable signal working 100% pass thru. Follow Dynamix team checking  switch port  all KDS IP  address shown on and off in 2 seconds.  Can\'t fix problems. <br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span></body>\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></html>\r\n<br><br>','2023-05-15 19:08:01','2023-05-15 19:08:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000097 Dela Rosa Yerba Buena / Wiring issue from Patch DYNAMIX Number 110406'),(408,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 401<br />\r\nTicket Title : Installation of replacement KDS FWLD002-KDS-001<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000106<br />\r\nStatus : Closed<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nWe would like to request a technician for the location below:<br />\n  <br />\n•	Address: 855 El Camino Real #110<br />\n•	Date: May 15<br />\n•	Time: 9:30AM AM PST<br />\n•	Access to Store:  Granted c/o Manager <br />\n•	Dynamix Ref Number: 110888<br />\n•	Device Type: KDS <br />\n•	Connection Type: Hardwired<br />\n<br />\n<br />\nWork Needed: <br />\n1. Remove the defective KDS with label  FWLD002-KDS-001<br />\n2. Install and set up the replacement KDS <br />\n3. Put the label  FWLD002-KDS-001 <br />\n4.Check the EXPO printer with label  FWLD002-KP-EXPO because it\'s printing and not getting an IP address. <br />\n5. Drop off the defective KDS <br />\n<br />\n<br />\nTroubleshooting Steps Done: <br />\nKDS:<br />\n•	Check ports from the KDS<br />\n•	Tried Different ethernet cable<br />\n•	It will not stay connected not unless the KDS will place upside down<br />\nPrinter:<br />\n•	Print test page - No ip<br />\n•	check the physical connection<br />\n<br />\n<br />\nRegards, <br />\nClaudette<br />\r\n<br />\r\nSolution :<br />\r\nTo all,<br />\nReport from Wildseed Palo Alto.  There is a new process that JC wanted me to see about accessing the Ticket # but to a prior commitment on Friday, I was not able to participate.  So here is the report.<br />\nGot on site and jumped on the Bridge and spoke with Manager Daniel who showed me where the new KDS was located so I could install it<br />\nDaniel gave me some information on how some changes to the network cables were made from the last time I was on site<br />\nI removed the old KDS and proceeded to install the new one<br />\nAlexandra provided me the needed Toast User and Password for that specific site in order to complete the installation<br />\nAlexandra jumped of the Bridge has she was assisting another tech apparently was I worked towards the instalaltion of the new KDS<br />\nNate called me directly and he was the new technician assisgned to the call since Alexandra was helping some other tech<br />\nManager Daniel indicated the the old Patch Panel Port #8 was used to connected to the KDS had given him problems and he had connected to old KDS to the 8 Port Switch instead which started to work again after he did so.<br />\nI used that same cable and I was able to connect to the Network (so the KDS is now connected to the 8 Port Switch as well)<br />\nI proceeded to to test Patch Panel Port #8 and it was defective as well so I can confirm it cannot be used<br />\nNate assigned a new IP address to the KDS and I validated.  <br />\nI completed the instalaltion of the KDS and I had Manager Daniel test it to confirm it was fully functioning.  <br />\nThen I checked the Expo Printer and I could see that it was given me an IP address which matched the setting that Nate had<br />\nManager Daniel showed me a picture he took last Friday which showed the NO IP was assigned to that printer when he tested it<br />\nProceeded to clean up old cables and re-organized current cables on the hot line<br />\nTook pictures as requested by Nate of the Patch Panel Portsthat are accessible on the Hot line (working and not working)<br />\nOn the very right side of the Bar are Port 4 & 5.  They are both working (Patch Panel Port #4 is connected to the Bar Orders printer and Patch Patch Panel Port #5 is connected to the 8 Port Switch on the Hot Line <br />\nBased on what I see on the Patch Panel in the office, there should be Patch Panel Port #6, #8, #9 and #10 but I beleive all of those are behind the hot line equipment and not accessible.  I have not been able to locate them myself<br />\nPatch Panel Port #7, #8 and #11 are visible but all of them do not have a clean connection when I tested them so they cannot be used<br />\nEffectively, you only have Patch Panel Ports #4 and #5 (actually usuable and accessible) and the 8 Port Switch on the Hot Line.<br />\nSee attached pictures<br />\nPhysical label on the KDS was added as well<br />\nBefore leaving, I had Manager Daniel test all printers just to make sure and he confirmed all was working<br />\nLeft the site at 11:30 am.<br />\nThank you. <br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span></body>\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></html>\r\n<br><br>','2023-05-17 02:24:01','2023-05-17 02:24:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000106 Installation of replacement KDS FWLD002-KDS-001 DYNAMIX Number 110888'),(409,6,6,1,'Contacts','','2023-05-17 17:08:53','2023-05-22 21:44:01',NULL,NULL,0,1,0,0,'CRM','Dynamix Support'),(410,6,6,0,'Contacts Image','','2023-05-17 17:08:53','2023-05-17 17:08:53',NULL,NULL,0,1,0,NULL,NULL,NULL),(411,1,1,1,'Emails','An Contact has been assigned to you on vtigerCRM<br>Details of Contact are :<br><br>Contact Id:<b>CON000012</b><br>LastName:<b>Support</b><br>FirstName:<b>Dynamix</b><br>Lead Source:<b></b><br>Department:<b></b><br>Description:<b></b><br><br><br>And <b>CustomerPortal Login Details</b> is sent to the EmailID :-dynamix@mybluetechnology.com<br><br>Thank You<br>Admin<br><br>','2023-05-17 17:18:02','2023-05-17 17:18:02',NULL,NULL,0,1,0,0,'CRM','Regarding Contact Assignment'),(412,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 271<br />\r\nTicket Title : BT Tech Request<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000084<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello,<br />\n<br />\nWe would like to request a technician for the location below:<br />\n<br />\nAddress: 595 Market Street San Francisco, Ca 94105<br />\n<br />\nDate: Requested for any date between 4/24-4/26<br />\n<br />\nTime: From 8:00 AM PST - 9:00 AM PST<br />\n<br />\nAccess to Store:  Granted by staff<br />\n<br />\nDynamix Ref Number: 109070<br />\n<br />\nDevice Type: Cloudbox<br />\n<br />\nConnection Type: Ethernet Port and AV Cables<br />\n<br />\nWork Needed:<br />\nTask 1: Replace current DMX Pandora Device with Cloudbox<br />\nTask 2: Connect Cloudbox to Port 14 on switch <br />\nTask 3: Connect Cloudbox to audio output for AV system<br />\n<br />\nPlease let me know if you need anything else from me.<br />\n<br />\nThank you,<br />\nChristian Cruz<br />\r\n<br />\r\nSolution :<br />\r\nTo all, <br />\nRecap for Service call: <br />\nArrived on site an jumped on the Bridge (I did not have any specific Bridge info but I checked anyway) and then I jumped on the second bridge that I used in the past but still by myself at that time.  Called Dynamix Support to reach Christian directly and we finally connected.  While on site, I realized that I did not have the correct connector to connect the AV cable and the network cable together next to each other to the Cloud Cover as you can see on the pictures sent earlier.  I knew of a Computer Store (Central Computers) near by that opened at 9:00 am so I went on site and was able to get the proper adapter to allow the connection to Cloud Cover.  I connected to Port 17 originally (Port 14 was being used but I saw it was not connected to anything so I connected Cloud Cover to Port 14 but the volume was still very loud so I reconnected the DMX to ensure that they had proper music which they could control.  Christian told me that some other software might possibly still needed to be installed but the physical connection is done (Cloud Cover to network and AV cable ready to connect).  Either myself or Herman (Manager on site) will simply need to move the the AV (white and Red cable to the Cloud Cover from the DMX when ready so Unos Dos Tacos can test it and possibly control the volume unless it\'s controlled on the PC itself.  Since the restaurant was open when I came back, I did not want to inconvenience the on site customers with possible loud music.  Please let me know if they are additional steps that need to take place.  Thank you. <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-19 02:56:01','2023-05-19 02:56:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000084 BT Tech Request DYNAMIX Number 109070'),(413,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 375<br />\r\nTicket Title : Tech Visit Beretta /UPS Replacement<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000099<br />\r\nStatus : Closed<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello,<br />\nWe would like to request a technician for the location below:<br />\nAddress: 1199 Valencia Street, San Francisco CA, 94110<br />\nDate: April 27, 2023 (Thursday)<br />\nTime: 9:00 AM PST<br />\nAccess to Store:  Granted<br />\nDynamix Ref Number: 110134<br />\nDevice Type:  UPS<br />\n <br />\nWork Needed:<br />\nTo install the New UPS<br />\nThank you and looking forward to your response.<br />\nKind Regards,<br />\nDianah<br />\r\n<br />\r\nSolution :<br />\r\nTo all, <br />\nRecap of Service Call: <br />\nArrived on site and jumped on the bridge with Alexandra <br />\nLocated and unboxed the UPS replacement <br />\nRealized that the Rack had the location is a Music Rack with smaller screws needed which I had brought Network Rack screws and those did not fit.  At this time, I do not have any more small screws to fit that Music Rack.   <br />\nAlso, FYI, the UPS in itself is about 40 LB so it would require two people to hold it at the bottom of the Rack and properly secure it (the ears for that UPS have been installed) with the correct screws to fit into that Music Rack  <br />\nThe old UPS was sitting on a site stand so I installed the new UPS on that stand next to the Music Rack (see picture)  <br />\nI disconnected all the equipment and reconnected the Network Switch, the Router, the Comcast Ciena, the Comcast Modem and the two music devices as well as the DVR.  All other equipment was connected to an extension cord    <br />\nThen Alexandra and I proceeded to test the network (Manager\'s PCs/Wifi/Toast equipment, etc) to make sure everything was back online.    <br />\nTook pictures for the report and left <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-19 02:56:08','2023-05-19 02:56:08',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000099 Tech Visit Beretta /UPS Replacement DYNAMIX Number 110134'),(414,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 385<br />\r\nTicket Title : RE: 110450 / Afterwork Bar / TV sounds and TV outside<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000101<br />\r\nStatus : Closed<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : High<br />\r\n<br />\r\nDescription :<br />\r\nRE: 110450 / Afterwork Bar / TV sounds and TV outside<br />\r\n<br />\r\nSolution :<br />\r\nTo all, <br />\nRecap of Support Call: <br />\nI was called around 5:15 pm to go to After Work Bar to fix what I believe was a sound issue.  When I got on site which was by 6:00 pm, Monica explained to me that all the TV\'s were on both Matrix but the TV\'s in the back and in the Front did not appeared to be synchronized.  My only suggestion was that both Matrix boxes would need to be reset but beings it was 6:00 pm and the bar was full of customers, rebooting both Matrix could become a disaster so no action were taken at that time.  I was also told that an outside TV was not working as well but I established that the end connection had been damaged again (once again, the connection was left unprotected from the box so another termination will need to  be done and I did not have the necessary tools to take care of it since that specific information was not provided before going on site. <br />\nIt\'s extremity important that Management address the problem of those outside RG45 connection left unprotected at the end of the days even though specific boxes have been setup so the terminations can be protected at all times when not used.  This will be the third time I have to redo the end outside and eventually I will run out of cable and a new run will need to take place at a much larger cost to After Work Bar when it should never have been necessary in the first place. <br />\nThank you. <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-19 02:56:13','2023-05-19 02:56:13',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000101 RE: 110450 / Afterwork Bar / TV sounds and TV outside DYNAMIX Number 110450'),(415,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 380<br />\r\nTicket Title : 110355/Lolinda/Installation of 2 Handhelds<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000100<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello,<br />\n<br />\n <br />\nWe would like to request a technician for the location below:<br />\n<br />\nAddress: 2518 Mission Street<br />\n<br />\nDate: April 26, 2023 (Wednesday)<br />\n<br />\nTime: 01:00PM PST<br />\n<br />\nAccess to Store:  TBD<br />\n<br />\nDynamix Ref Number: 110355<br />\n<br />\nDevice Type: 2 Handhelds<br />\n<br />\nConnection Type: Wireless<br />\n<br />\n<br />\nWork Needed:<br />\nTask 1: Connect the Handhelds to PNET (coordinate with support for the password)<br />\nTask 2: Log in to Toast using the email and password that is associated with the store’s Toast Account<br />\nTask 3: Enable EMV <br />\nOn the lower left corner of the passcode screen, select credit card icon.<br />\nEnter Pin to log in.<br />\nFrom the main menu, go to set up and select device set up.<br />\nScroll down and select EMV enabled.<br />\nSelect Yes.<br />\nTask 4: Provide support with the MAC address and Serial Number of the device for Mapping and Documentation purposes.<br />\nTask 5: Make sure to label Handhelds FLOL001-HH-01 and FLOL001-HH-03<br />\n<br />\n<br />\nBest regards,<br />\nChristine<br />\r\n<br />\r\nSolution :<br />\r\nTo all,<br />\nRecap for Service Call,<br />\nArrived on site at 1:00 pm<br />\nJumped on the Bridge<br />\nClaudette from Dynamix provided the necessary SSID information in order to connect to the network<br />\nWhen I asked for the Toast email and Password to continue the installation, I was told to ask the Manager on site which is a different procedure from before<br />\nVincent, the GM, was on site so I had to disrupt his meeting in order to get the necessary information to move forward.  From my standpoint, that seems unpractical and that information should be provided by Support<br />\nAlso, the email instructions provided would not have worked with a technician not familiar with setting up that Hand Held Toast device.  That information was very inaccurate and far from complete.   I was able to complete due to my prior experience but that can be improved in case of other technician that would be setting up a Hand Held<br />\nAfter the setup of both Hand Held, the necessary information was provided to Support for their Tracking and pictures of the devices were taken as well.  See attached.<br />\nThank you. <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-19 02:56:16','2023-05-19 02:56:16',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000100 110355/Lolinda/Installation of 2 Handhelds DYNAMIX Number 110355'),(416,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 121<br />\r\nTicket Title : Installation of replacement KDS at SD Novato<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000051<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello Blue Technology, <br />\nWe would like to request a technician for the location below:<br />\n<br />\n <br />\n<br />\nAddress: 5800 Nave Drive, Suite C, Novato<br />\n<br />\nDate: March 27, 2023<br />\n<br />\nTime: 7:00 AM PST<br />\n<br />\nAccess to Store:  Granted c/o Kitchen Staff <br />\n<br />\nDynamix Ref Number: 109234<br />\n<br />\nDevice Type: KDS<br />\n<br />\nConnection Type: Hardwired <br />\n <br />\n<br />\nWork Needed:<br />\n<br />\nTask 1: Install the replacement KDS<br />\nTask 2: Make sure label is added to the device CSD008-KDS-002<br />\nTask 3: If RMA, drop off the defective unit.<br />\r\n<br />\r\nSolution :<br />\r\nTo all,<br />\nThe installation has been completed.  Prior to a new equipment install, could the Toast User and Password be provided before the actual install?  The Dynamix tech always has to call me back with the info so clearly they don\'t have it themselves.  As the field tech, I will need that information during the time of installation.  Secondly, the configuration of the device is done by memory only and to the best of my recollection.  Would be best to follow a specific protocol of how it is to be setup so it\'s consistent at every location.  Also, I like to do a test order to see if the device is connected correctly but I do not recall how to void a check on Toast.  Can I be forwarded instructions on how to void a check in a Quick Service option as well as to how to void in a full Service operations?  Would be good information to have. There is a test check closed to cash that the Manager will need to void.  The check was left on the terminal itself.  I will upload all pictures that I took this morning and load them in the OneDrive for this site. Finally, I will take care of shipping the broken Workstation back to Toast.  Thank you. <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-19 03:10:01','2023-05-19 03:10:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000051 Installation of replacement KDS at SD Novato DYNAMIX Number 109234'),(417,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 385<br />\r\nTicket Title : RE: 110450 / Afterwork Bar / TV sounds and TV outside<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000101<br />\r\nStatus : Closed<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : High<br />\r\n<br />\r\nDescription :<br />\r\nRE: 110450 / Afterwork Bar / TV sounds and TV outside<br />\r\n<br />\r\nSolution :<br />\r\nTo all,<br />\nRecap for the Service call:<br />\nGot on site and jumped on the bridge with Alexandra<br />\nRebooted both Matrix as soon as I got to the site<br />\nThen I started working on the outside TV issues.  After testing the left side Patch Panel port, and disconnecting the connection, I could get programs so it became clear that the TV was possibly connected via Wifi.  Which it was.  Ideally, if I can be informed of an important details when checking a network issue, the process would have gone faster<br />\nI then tested the connecction and I was able to verify that the physical Patch Panel connection was good.  But yest still no connectivity on the TV.  Then I tested all the patch cables and I discovered that the cable going from the Patch Panel top the bottom Matrix was not connected so I had to get that one reconnected which was abit of a challenge<br />\nNext, I still did not have connectivity from the TV.  I tested the cable at the TV and all good as well.  Finakky, I decided to connect the patch panel port to the Switch and see if I could get connectivity on my laptop.  Got it right away.  Then I connected to the NIC Port of the HDMI Receiver (see picture) and I got no traffic at all which tells me that the devive attached to the TV is probably defective.  Then I did the same thing for the second TV and got the same results (no traffic light/connectivity) so based on that, I believe the replacement of those units will restore the hardware connection to the Matrix in the Network Room. <br />\nFinally, I tested, the right side RG45 and it was defective so I re-terminated it again (3rd time and I\'m running out of cable) and after that I tested successfully.  So both outside Patch Panel Ports are again working.  As for After Work Bar Management, PLEASE make it as part of the closing duties to put the terminations into the boxes which were installed for that purpose, lock it correctly and only unlock then when needed.  If those keep getting damaged, a new cable run will need to be run at a much more extensive cost which AWB will pay for. <br />\nWhile I was finishing the terminations, myself and AGM Alex tested the synchronization of the TV\'s between the two different Matrix and they were perfectly synchronized.  Yesterday, while I was on site, they had about a second to a second and a half delay between the TV\'s back and the front TV\'s. <br />\nI was not able to notice any sound issues yesterday as they were too much noise anyway with the crowd at AWB.  I would suggest to possibly check the sound tonight on site tonight while it\'s less crowded but with all TV\'s on<br />\nFinally, the outside TV\'s on the wireless connection cannot joined the Matrix so they wil probably be out of sync from the rest of the AWB TV\'s.<br />\nLeft at 11:00am.  Thank  you. <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-19 03:52:01','2023-05-19 03:52:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000101 RE: 110450 / Afterwork Bar / TV sounds and TV outside DYNAMIX Number 110450'),(418,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 371<br />\r\nTicket Title : 110388/Wildseed Palo Alto/Remove 6 Port Switch<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000098<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello, <br />\n<br />\n  <br />\nWe would like to request a technician for the location below: <br />\n<br />\n<br />\nAddress: 855 El Camino Real #110 <br />\n<br />\nDate: April 26, 2023 (Wednesday) <br />\n<br />\nTime: 07:00 AM PST <br />\n<br />\nAccess to Store:  TBD <br />\n<br />\nDynamix Ref Number: 110291 <br />\n<br />\nDevice Type: 6 Port Switch<br />\n<br />\n-------- Original message -------- <br />\nFrom: Dynamix Frontline Services  <br />\nDate: 4/25/23 1:21 PM (GMT-05:00) <br />\nTo: yann@mybluetechnology.com<br />\nCc: jc@mybluetechnology.com, ndairkee@backofthehouseinc.com, supportticket@mybluetechnology.com<br />\nSubject: RE: 110388/Wildseed Palo Alto/Remove 6 Port Switch <br />\n  <br />\nHello Yann,<br />\n<br />\nI hope all is well. We would also like to request your assistance with the auditing of all devices at Wildseed Palo Alto. This audit is necessary to ensure that all documentation related to these devices is accurate and up-to-date.<br />\n<br />\nAttached to this email, you will find an excel file that we will use to track the audit results. Please fill out the information required in the file and send it back to us once the audit is complete.<br />\n<br />\nIf you have any questions or concerns about this, please do not hesitate to contact us.<br />\n<br />\nBest regards,<br />\nDale<br />\r\n<br />\r\nSolution :<br />\r\nTo all, <br />\nRecap from Service Call: <br />\nArrived on site and called the Bridge <br />\nStarted checking the available Ports on the kitchen line (Ports 4, 54, 7,8 and 11)  <br />\nPort 4 and Port 5 tested fine <br />\nPort 7 is where the Switch was connected to <br />\nPort 8 had been fixed has the Kitchen KDS was connected to that Port <br />\nPort 11 was still bad <br />\nThen proceeded to connect the KP Bar to Port 4 <br />\nConnected on the Switch as well to Port 4 <br />\nTested it with technician who could see it online <br />\nRemoved the cable that was used to connect to the 8 Port Switch <br />\nExplain to technician that they were not enough Ports available to remove the 8 Port Switch connected to Port 7 <br />\nPort 2 of the 8 Port Switch is connected to the Expo printer <br />\nPort 3 is connected to the Pantry printer <br />\nPort 5 is connected to the Grill printer <br />\nI could not locate Patch Panel Port 9 and 10 on the Hot line and they are probably behind the hotline shelves (which is extremely to move to see where those Ports might be located at <br />\nPort 9 and Port 10 were covered on the Patch Panel in the Rack for some reasons which I do not know <br />\nIt would be my recommendation to send to send Access Cabling to fix Port 11 and locate Port 9 and 10 to test them as well so we can actually remove the temporary Switch  <br />\nWhen that portion of the work was done, I worked with Dynamix Support on the Toast equipment identification and a specific Excel sheet will be provided separately <br />\nI had the restaurant Manager checked the Toast system before leaving to validate that everything was working as expected <br />\nLeft the site at about 11:00 am <br />\nThank you. <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-19 04:06:01','2023-05-19 04:06:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000098 110388/Wildseed Palo Alto/Remove 6 Port Switch DYNAMIX Number 110291'),(419,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 391<br />\r\nTicket Title : 110352 / Afterwork bar / Reconnect Television to Matrix<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000103<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Major<br />\r\nPriority : High<br />\r\n<br />\r\nDescription :<br />\r\nHello,<br />\n<br />\nWe would like to request a technician for the location below ASAP:<br />\n<br />\nAddress: 409 Gough Street, San Francisco CA, 94102<br />\nDate: April 26, 2023<br />\nTime: ASAP<br />\nAccess to Store:  Granted<br />\nDynamix Ref Number: 11450<br />\nDevice Type:  TV<br />\n<br />\nWork Needed:<br />\nTo check the TV sounds<br />\nTo check the TV outside<br />\n<br />\nThank you and looking forward to your response.<br />\n<br />\n <br />\n<br />\nKind Regards,<br />\nDianah<br />\r\n<br />\r\nSolution :<br />\r\nTo all,<br />\nRecap of Support Call:<br />\nI was called around 5:15 pm to go to After Work Bar to fix what I believe was a sound issue.  When I got on site which was by 6:00 pm, Monica explained to me that all the TV\'s were on both Matrix but the TV\'s in the back and in the Front did not appeared to be synchronized.  My only suggestion was that both Matrix boxes would need to be reset but beings it was 6:00 pm and the bar was full of customers, rebooting both Matrix could become a disaster so no action were taken at that time.  I was also told that an outside TV was not working as well but I established that the end connection had been damaged again (once again, the connection was left unprotected from the box so another termination will need to  be done and I did not have the necessary tools to take care of it since that specific information was not provided before going on site.<br />\nIt\'s extremity important that Management address the problem of those outside RG45 connection left unprotected at the end of the days even though specific boxes have been setup so the terminations can be protected at all times when not used.  This will be the third time I have to redo the end outside and eventually I will run out of cable and a new run will need to take place at a much larger cost to After Work Bar when it should never have been necessary in the first place.<br />\nThank you <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-19 04:20:01','2023-05-19 04:20:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000103 110352 / Afterwork bar / Reconnect Television to Matrix DYNAMIX Number 11450'),(420,6,9,9,'HelpDesk','We would like to request a technician for the location below:\n\nAddress: 5800 Nave Drive, Suite C\n\nDate: May 22, 2023 (Monday)\n\nTime: 07:00AM-09:00AM PST\n\nAccess to Store:  Granted c/o Janitor \n\nDynamix Ref Number: 110762\n\nDevice Type: UPS\n\n\nWork Needed: \n•	Rack mount battery into rack and connect all sensitive devices per BOH standards (modem(s), switch, Meraki, etc)\n•	Remove bad/beeping battery backup that is located above office computer – This can be plugged into the wall directly.','2023-05-21 01:44:15','2023-05-23 16:02:26',NULL,NULL,0,1,0,0,'CRM','Super Duper - Novato /  UPS Replacement / 110762'),(421,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : 420<br />\r\nTicket Title : Super Duper - Novato /  UPS Replacement / 110762<br />\r\n<br />\r\nDear Solorzano Angel,<br />\r\n<br />\r\nYou have been assigned to the following ticket:<br />\r\n<br />\r\nTicket No : TKT000107<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDYNAMIX TICKET NUMBER:&nbsp;110762<br />\r\n<br />\r\nDescription :<br />\r\nWe would like to request a technician for the location below:<br />\n<br />\nAddress: 5800 Nave Drive, Suite C<br />\n<br />\nDate: May 22, 2023 (Monday)<br />\n<br />\nTime: 07:00AM-09:00AM PST<br />\n<br />\nAccess to Store:  Granted c/o Janitor <br />\n<br />\nDynamix Ref Number: 110762<br />\n<br />\nDevice Type: UPS<br />\n<br />\n<br />\nWork Needed: <br />\n•	Rack mount battery into rack and connect all sensitive devices per BOH standards (modem(s), switch, Meraki, etc)<br />\n•	Remove bad/beeping battery backup that is located above office computer – This can be plugged into the wall directly.<br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size:20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family:verdana,geneva,sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-21 01:48:01','2023-05-21 01:48:01',NULL,NULL,0,1,0,0,'CRM','YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000107 Super Duper - Novato /  UPS Replacement / 110762 DYNAMIX NUMBER 110762'),(422,6,10,1,'HelpDesk','Hi JC,\n\nThis is related. To give ample time, let’s have Bim arrive at 7am. I will meet her at that time instead of 8am as we had discussed on the call earlier. \n\nThank you!\n________________________________________\nFrom: jc@mybluetechnology.com \nSent: Tuesday, April 25, 2023 7:21:19 PM\nTo: Nuranne Dairkee \nSubject: FW: 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch \n \nHi Nuranne, I’m assuming this is not related to what you want to work with Bim In Delarosa YB .If that is the case, I will send BIM at 7am instead of 8, s she will have 1 hour to service this call.\n \nBest,\n \nJC\n \nFrom: Dynamix Frontline Services  \nSent: Tuesday, April 25, 2023 6:42 PM\nTo: supportticket@mybluetechnology.com; jct@mybluetechnology.com\nCc: ndairkee@backofthehouseinc.com\nSubject: 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch\n \nHello,\nWe would like to request a technician for the location below:\nAddress: 37 Yerba Buena San Francisco CA, 94103\nDate: April 26, 2023 (Wednesday)\nTime: 7:00 AM PST\nAccess to Store:  Granted\nDynamix Ref Number: 110406\nDevice Type:  \nConnection Type: Ethernet connection\nWork Needed:\nTo confirm the patch status\nTroubleshooting Steps were taken:\nConfigured - FDLA002-KP-HOT in Meraki\nAdded MAC- 50:57:9c:58:c8:1b / IP - 192.168.192.170\nPing Test - responding / Loss rate - 0%\nTest Print -Working\nFDLA002-KP-EXPO\n> Connected to a patch > Switch port number 6 > IP: None\nProperly Onboarded in Meraki - 50:57:9c:58:ad:8c/ 192.168.192.173\nPing Test- 100% Packet Loss\nBypassed the patch and connect it straight to the switch\nPerformed Powercycle. Ip now shows - 192.168.192.173\nPing test - 0% packet loss\ntest print - Okay\nThe printer is not working behind the patch\nThank you and looking forward to your response.\nKind Regards,\nDianah','2023-05-21 20:12:16','2023-05-21 20:42:08',NULL,NULL,0,1,0,0,'CRM','110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch'),(423,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : 422<br />\r\nTicket Title : 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch<br />\r\n<br />\r\nDear Lapinsee Bim,<br />\r\n<br />\r\nYou have been assigned to the following ticket:<br />\r\n<br />\r\nTicket No : TKT000108<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDYNAMIX TICKET NUMBER:&nbsp;110406<br />\r\n<br />\r\nDescription :<br />\r\nHi JC,<br />\n<br />\nThis is related. To give ample time, let’s have Bim arrive at 7am. I will meet her at that time instead of 8am as we had discussed on the call earlier. <br />\n<br />\nThank you!<br />\n________________________________________<br />\nFrom: jc@mybluetechnology.com <br />\nSent: Tuesday, April 25, 2023 7:21:19 PM<br />\nTo: Nuranne Dairkee <br />\nSubject: FW: 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch <br />\n <br />\nHi Nuranne, I’m assuming this is not related to what you want to work with Bim In Delarosa YB .If that is the case, I will send BIM at 7am instead of 8, s she will have 1 hour to service this call.<br />\n <br />\nBest,<br />\n <br />\nJC<br />\n <br />\nFrom: Dynamix Frontline Services  <br />\nSent: Tuesday, April 25, 2023 6:42 PM<br />\nTo: supportticket@mybluetechnology.com; jct@mybluetechnology.com<br />\nCc: ndairkee@backofthehouseinc.com<br />\nSubject: 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch<br />\n <br />\nHello,<br />\nWe would like to request a technician for the location below:<br />\nAddress: 37 Yerba Buena San Francisco CA, 94103<br />\nDate: April 26, 2023 (Wednesday)<br />\nTime: 7:00 AM PST<br />\nAccess to Store:  Granted<br />\nDynamix Ref Number: 110406<br />\nDevice Type:  <br />\nConnection Type: Ethernet connection<br />\nWork Needed:<br />\nTo confirm the patch status<br />\nTroubleshooting Steps were taken:<br />\nConfigured - FDLA002-KP-HOT in Meraki<br />\nAdded MAC- 50:57:9c:58:c8:1b / IP - 192.168.192.170<br />\nPing Test - responding / Loss rate - 0%<br />\nTest Print -Working<br />\nFDLA002-KP-EXPO<br />\n> Connected to a patch > Switch port number 6 > IP: None<br />\nProperly Onboarded in Meraki - 50:57:9c:58:ad:8c/ 192.168.192.173<br />\nPing Test- 100% Packet Loss<br />\nBypassed the patch and connect it straight to the switch<br />\nPerformed Powercycle. Ip now shows - 192.168.192.173<br />\nPing test - 0% packet loss<br />\ntest print - Okay<br />\nThe printer is not working behind the patch<br />\nThank you and looking forward to your response.<br />\nKind Regards,<br />\nDianah<br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size:20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family:verdana,geneva,sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-21 20:14:01','2023-05-21 20:14:01',NULL,NULL,0,1,0,0,'CRM','YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000108 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch DYNAMIX NUMBER 110406'),(424,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Lapinsee Bim,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 422<br />\r\nTicket Title : 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000108<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHi JC,<br />\n<br />\nThis is related. To give ample time, let’s have Bim arrive at 7am. I will meet her at that time instead of 8am as we had discussed on the call earlier. <br />\n<br />\nThank you!<br />\n________________________________________<br />\nFrom: jc@mybluetechnology.com <br />\nSent: Tuesday, April 25, 2023 7:21:19 PM<br />\nTo: Nuranne Dairkee <br />\nSubject: FW: 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch <br />\n <br />\nHi Nuranne, I’m assuming this is not related to what you want to work with Bim In Delarosa YB .If that is the case, I will send BIM at 7am instead of 8, s she will have 1 hour to service this call.<br />\n <br />\nBest,<br />\n <br />\nJC<br />\n <br />\nFrom: Dynamix Frontline Services  <br />\nSent: Tuesday, April 25, 2023 6:42 PM<br />\nTo: supportticket@mybluetechnology.com; jct@mybluetechnology.com<br />\nCc: ndairkee@backofthehouseinc.com<br />\nSubject: 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch<br />\n <br />\nHello,<br />\nWe would like to request a technician for the location below:<br />\nAddress: 37 Yerba Buena San Francisco CA, 94103<br />\nDate: April 26, 2023 (Wednesday)<br />\nTime: 7:00 AM PST<br />\nAccess to Store:  Granted<br />\nDynamix Ref Number: 110406<br />\nDevice Type:  <br />\nConnection Type: Ethernet connection<br />\nWork Needed:<br />\nTo confirm the patch status<br />\nTroubleshooting Steps were taken:<br />\nConfigured - FDLA002-KP-HOT in Meraki<br />\nAdded MAC- 50:57:9c:58:c8:1b / IP - 192.168.192.170<br />\nPing Test - responding / Loss rate - 0%<br />\nTest Print -Working<br />\nFDLA002-KP-EXPO<br />\n> Connected to a patch > Switch port number 6 > IP: None<br />\nProperly Onboarded in Meraki - 50:57:9c:58:ad:8c/ 192.168.192.173<br />\nPing Test- 100% Packet Loss<br />\nBypassed the patch and connect it straight to the switch<br />\nPerformed Powercycle. Ip now shows - 192.168.192.173<br />\nPing test - 0% packet loss<br />\ntest print - Okay<br />\nThe printer is not working behind the patch<br />\nThank you and looking forward to your response.<br />\nKind Regards,<br />\nDianah<br />\r\n<br />\r\nSolution :<br />\r\nnetwork cable, Switch panels and KDS IP address inspection . Some electric problems need to change RJ45 jack for 2 ports and replaced  6Ft.  cat6e cable <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-21 20:42:01','2023-05-21 20:42:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000108 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch DYNAMIX Number 110406'),(425,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Lapinsee Bim,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 422<br />\r\nTicket Title : 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000108<br />\r\nStatus : Closed<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHi JC,<br />\n<br />\nThis is related. To give ample time, let’s have Bim arrive at 7am. I will meet her at that time instead of 8am as we had discussed on the call earlier. <br />\n<br />\nThank you!<br />\n________________________________________<br />\nFrom: jc@mybluetechnology.com <br />\nSent: Tuesday, April 25, 2023 7:21:19 PM<br />\nTo: Nuranne Dairkee <br />\nSubject: FW: 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch <br />\n <br />\nHi Nuranne, I’m assuming this is not related to what you want to work with Bim In Delarosa YB .If that is the case, I will send BIM at 7am instead of 8, s she will have 1 hour to service this call.<br />\n <br />\nBest,<br />\n <br />\nJC<br />\n <br />\nFrom: Dynamix Frontline Services  <br />\nSent: Tuesday, April 25, 2023 6:42 PM<br />\nTo: supportticket@mybluetechnology.com; jct@mybluetechnology.com<br />\nCc: ndairkee@backofthehouseinc.com<br />\nSubject: 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch<br />\n <br />\nHello,<br />\nWe would like to request a technician for the location below:<br />\nAddress: 37 Yerba Buena San Francisco CA, 94103<br />\nDate: April 26, 2023 (Wednesday)<br />\nTime: 7:00 AM PST<br />\nAccess to Store:  Granted<br />\nDynamix Ref Number: 110406<br />\nDevice Type:  <br />\nConnection Type: Ethernet connection<br />\nWork Needed:<br />\nTo confirm the patch status<br />\nTroubleshooting Steps were taken:<br />\nConfigured - FDLA002-KP-HOT in Meraki<br />\nAdded MAC- 50:57:9c:58:c8:1b / IP - 192.168.192.170<br />\nPing Test - responding / Loss rate - 0%<br />\nTest Print -Working<br />\nFDLA002-KP-EXPO<br />\n> Connected to a patch > Switch port number 6 > IP: None<br />\nProperly Onboarded in Meraki - 50:57:9c:58:ad:8c/ 192.168.192.173<br />\nPing Test- 100% Packet Loss<br />\nBypassed the patch and connect it straight to the switch<br />\nPerformed Powercycle. Ip now shows - 192.168.192.173<br />\nPing test - 0% packet loss<br />\ntest print - Okay<br />\nThe printer is not working behind the patch<br />\nThank you and looking forward to your response.<br />\nKind Regards,<br />\nDianah<br />\r\n<br />\r\nSolution :<br />\r\nnetwork cable, Switch panels and KDS IP address inspection . Some electric problems need to change RJ45 jack for 2 ports and replaced   6Ft.  cat6e cable. Clean up all old kitchen network cables and uninstall all switch hub  cable and power supply under counter. <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-21 20:42:08','2023-05-21 20:42:08',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000108 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch DYNAMIX Number 110406'),(426,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 110<br />\r\nTicket Title : 108772 - aMano network rack<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000040<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nBT Support,<br />\n<br />\n <br />\n<br />\nRequest a technician for the following:<br />\n<br />\nAddress: 450 Hayes St, SF, CA 94102<br />\n<br />\nDate: Monday, 3/6/23<br />\n<br />\nTime: 8-10am<br />\n<br />\nAccess to store: granted by kitchen staff (in at 8am)<br />\n<br />\nDynamix reference number: 108772<br />\n<br />\n <br />\n<br />\nWork to be completed (NOTE - all hardware is onsite, underneath network rack)<br />\n<br />\nadd monitor and mouse to DVR – place on top of dehydrator, to the right of the rack.<br />\nadd battery backup and devices set according to BOH standard<br />\nadd CloudCover<br />\nNOTE: device should be powered on and plugged into switch<br />\n*** NOC will designate which port to use for music licensing***<br />\n<br />\nSonos system to remain as is – no changes should be made to AV system<br />\n <br />\n<br />\nThere is a lockbox upstairs – when facing office door,  to the left, near the ceiling. Code is 1987.<br />\n<br />\n <br />\n<br />\nYann was originally scheduled at 98 Mission at this time – I want that changed. Yann should take this aMano call and let’s have Angel take care of 98 Mission.<br />\n<br />\n <br />\n<br />\nPlease reach out with any questions or concerns.<br />\n<br />\n <br />\n<br />\nThank you,<br />\r\n<br />\r\nSolution :<br />\r\nHello Nuranne,<br />\n<br />\nPlease see Yann\'s report below. <br />\n<br />\nInstalled Battery Backup/Surge Protector within the				<br />\nRack.  Setup and connected Monitor for DVR.  Got 				<br />\nDVR Specs and sent information to Support.  Setup				<br />\nHikvision IVMS on Manager\'s PC				<br />\nIncludes travel time				<br />\n<br />\n<br />\nFor now, we will close this ticket. I kindly request that you review the report and let us know if there are any further actions required.<br />\n<br />\nBest regards,<br />\n<br />\nDale <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-21 22:40:01','2023-05-21 22:40:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000040 108772 - aMano network rack DYNAMIX Number 108772'),(427,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 118<br />\r\nTicket Title : Super Duper - Berkeley / Resolve camera 2<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000048<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello Team,<br />\n<br />\nSorry for the short notice. We would like to check if we could send someone onsite today at 10AM PST for the below location. if not, we would like to request to send one for tomorrow at the same time.<br />\n<br />\nAddress: 2355 Telegraph Avenue<br />\nDate:Time:  10AM PST 3/20/2023<br />\nAccess to Store: Managers office<br />\nDynamix Ref Number: 00108769<br />\nDevice Type: Security Camera<br />\nConnection Type: Wired<br />\n<br />\nWork Needed:<br />\nTask 1: Restart camera 2<br />\nTask 2: Test camera 2 if can be remote options via IVMS are working ex. change camera name / reboot etc.<br />\nTask 3: Test playback option for camera 2 if working<br />\n<br />\nTroubleshooting Steps taken:<br />\n· Tried remote restart for camera 2 / not working<br />\n· Tried resetting camera 2 / not working<br />\n- All remote functions for camera 2 are not responsive<br />\n<br />\nLet us know if you other questions.<br />\n<br />\nRegards,<br />\nJeremy.<br />\r\n<br />\r\nSolution :<br />\r\nArrived at 1:00 pm												<br />\nWas shown what camera was not allowing access to recorded video.  Could see no video was recorded on that specific camera												<br />\nRebooted DVR and camera itself.  I could see that camera was now recording and storing video and it was accessible												<br />\nShowed the GM that that camera video was now successfully recording.  Created a Saved to quicly access all cameras available <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-21 22:54:01','2023-05-21 22:54:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000048 Super Duper - Berkeley / Resolve camera 2 DYNAMIX Number 108769'),(428,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 94<br />\r\nTicket Title : 108064 / Flores Union / Printer Routing Issue<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000024<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello Blue Technology,<br />\n<br />\n <br />\n<br />\nWe would like to request a technician for the location below:<br />\n<br />\nAddress: 2030 Union Street, 94123 San Francisco CA<br />\nTime: Between 9:00 AM - 11:30 AM PST <br />\nDate: February 8, 2023<br />\nAccess to Store: Granted c/o GM<br />\nDynamix Ref Number: 108064<br />\n <br />\n<br />\nTask:<br />\n<br />\nCheck the Bar printer and use the backup printer if needed<br />\nCheck all other printers if it is routed correctly<br />\nTest all the printers and make sure tickets are printing to the correct printer<br />\n <br />\n<br />\n <br />\n<br />\nTroubleshooting steps were taken on the Bar Printer:<br />\n<br />\npower cycle the bar printer - done<br />\nunplugged and replugged the ethernet cable - done<br />\ntried to print - no go<br />\nprinted a test page - done<br />\nprinted a feed test page - no IP address found<br />\n <br />\n<br />\nThank you for your assistance.<br />\n<br />\n <br />\n<br />\n <br />\n<br />\nRegards,<br />\n<br />\nDianah<br />\r\n<br />\r\nSolution :<br />\r\nWorked wiith Dynamix Support to resolve Bar				<br />\nprinter issue.  Spend a lot of time on bridge waiting				<br />\nfor Dynamix Support to do their work on their side				<br />\nIncludes travel time <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-21 23:08:01','2023-05-21 23:08:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000024 108064 / Flores Union / Printer Routing Issue DYNAMIX Number 108064'),(429,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 112<br />\r\nTicket Title : 108817 and 108825 / Super Duper – Metreon / Printer not printing and No sound on their Music<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000042<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello Blue Technology,<br />\n <br />\nWe would like to request a technician for the location below:<br />\n<br />\n·     Address: 783 Mission Street, San Francisco CA 94103<br />\n<br />\n·     Date: March 8, 2023 (Wednesday)<br />\n<br />\n·     Time: 8:00 AM PST<br />\n<br />\n·     Access to Store:  Granted c/o Janitor<br />\n<br />\n·     Dynamix Ref Number: 108817 and 108825<br />\n<br />\n <br />\nWork Needed:<br />\nTask 1: Check the printer\'s physical connection  <br />\nTask 2: Check Kiosk connectivity<br />\nTask 3: Run a test order and confirm that the printer is working<br />\nTask 4: Check Music for no sounds<br />\n <br />\nTroubleshooting Steps were taken:<br />\nRestarted the kiosk - no go<br />\nPower cycle the printer - no go<br />\nCheck physical connection<br />\nCables are firmly connected<br />\nThen tried the backup printer - no go<br />\nPrinted test page – ok<br />\nCheck Kiosk\'s network settings:<br />\nWi-fi off<br />\nEthernet 0 (USB-C)<br />\nEthernet 1 (RJ-45)<br />\nIP: 192.168.192.222<br />\nTried printing from Kiosk 1 it will print to SSUP05-RP-K01 instead of SSUP05-RP-TE1<br />\nOn Music system:<br />\nCheck if its on mute - no<br />\nCheck volume - still no go<br />\n<br />\nPlease let us know if you have any questions.<br />\n<br />\nRegards,<br />\r\n<br />\r\nSolution :<br />\r\nTo all,<br />\nWent on site this morning and this is what I did :<br />\n- Joined the Bridge<br />\n- Tested both Receipt printers and  they appear\\s to test print correctly<br />\n- Got the IP address for both printers<br />\n- Did some tests with Tech Minerva to validate the problem<br />\n- Realized that Receipts Printers between Kiosk and Term1 has been swapped between the two Workstations<br />\n- Swapped Printers back to proper locations and reconnected both of them<br />\n- Tested Kiosk Workstation again and Kiosk finally printted correctly<br />\n- Tested Term1 Workstation and Receipt printer still printed at Kiosk  <br />\n-  Minerva checked her Workstation Term1 Configurations and it all looked good on her side but we still had issue<br />\n-  Minerva called Toast Support and Toast Support pointed out that the Printer was not setup correctly on the device itself (Printer setup of the actual Workstation in location) and that were it needed to be changed.  We both learned something today about the Toast printing setting<br />\n- Tested that Term 1 Worstation as well and it finally printed correctly<br />\n- Tested the third Workstation (Term 2)  for validation and it tested correctly as well. <br />\n- When Manager came in, Minerva had him test again so he could see for himself that all Workstations were printing correctly.  All good. <br />\n- Manager to void all checks used for test purposes<br />\n- Fixed the music issue as well <br />\n- Left the Bridge.<br />\n <br />\nPs:  Got an error message on Kiosk Workstation (Error starting Toast App.  Saw that message a few times/see attached picture).  Unit did a software update <br />\n <br />\nThank you. <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-21 23:08:13','2023-05-21 23:08:13',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000042 108817 and 108825 / Super Duper – Metreon / Printer not printing and No sound on their Music DYNAMIX Number 108817'),(430,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 96<br />\r\nTicket Title : 107721 / Super Duper - Emeryville / Toast Tap Replacement<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000026<br />\r\nStatus : Open<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello Blue Technology,<br />\n<br />\n <br />\n<br />\nWe would like to request a technician for the location below:<br />\n<br />\nAddress: 5959 Shellmound Street, 94608 Emeryville CA<br />\nTime: 9:30 AM PST<br />\nAccess to Store: Granted c/o store Key holder and their Janitor<br />\nDynamix Ref Number: 107721<br />\n <br />\n<br />\nTask:<br />\n<br />\nConnect the Replacement Toast Tap(purple cable) to Toast Flex or Toast Hub (depending what the store set up)<br />\nTest all Toast Tap functionality<br />\nDrop off the defective Toast tap using the label kit.<br />\nSend us the tracking number<br />\n <br />\n<br />\nThank you for your assistance.<br />\r\n<br />\r\nSolution :<br />\r\nN/A - No invoice - No records <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-21 23:22:01','2023-05-21 23:22:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000026 107721 / Super Duper - Emeryville / Toast Tap Replacement DYNAMIX Number 107721'),(431,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 87<br />\r\nTicket Title : After Work Bar / Montaje seguro para televisores de barra<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000017<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello,<br />\n<br />\n <br />\n<br />\nWe would like to request a technician for the location below:<br />\n<br />\nAddress: 409 Gough Street, San Francisco, CA 94102<br />\n<br />\nTime: 10 AM PST<br />\n<br />\nAccess to Store:  Manager on duty<br />\n<br />\nDynamix Ref Number: 108024<br />\n<br />\n<br />\nWork Needed:<br />\n<br />\nTask : Make sure that the Mounting of the Bar TVs are secure<br />\n<br />\n<br />\nThank you for your assistance on this.<br />\n<br />\nRegards,<br />\n<br />\nWarren<br />\r\n<br />\r\nSolution :<br />\r\nVisit on site to understand actual issue of ticket				<br />\nas information was very unclear.  While on site				<br />\nmet with new GM who was able to provide me				<br />\ncorrect information as to what was needed				<br />\nIncludes travel time <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-21 23:22:03','2023-05-21 23:22:03',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000017 After Work Bar / Montaje seguro para televisores de barra DYNAMIX Number 108024'),(432,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 277<br />\r\nTicket Title : The Tailor\'s Son / Cash Drawer replacement<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000087<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello,<br />\n <br />\nWe would like to request a technician for the location below:<br />\n<br />\n·     2049 Fillmore Street, 94115<br />\n<br />\n·     Time: 11:30 AM PST<br />\n<br />\n·     Access to Store:  Granted c/o Kitchen Staff <br />\n<br />\n·     Dynamix Ref Number: 00107807<br />\n<br />\n <br />\nWork Needed:<br />\n <br />\n<br />\n1.   Pick up Cashdrawer at BOH office and Deliver it to the store<br />\n<br />\n2.   Swap the existing Cash Drawer to the new one<br />\n<br />\na.       Take the cash drawer kick cable and connect it to your cash drawer.<br />\n<br />\nb.       Take the other end of the kick cable and plug it into the printer<br />\n<br />\n<br />\nBest regards,<br />\n<br />\nDale<br />\r\n<br />\r\nSolution :<br />\r\nPick up Cash Drawer at Corprate and deliver and 				<br />\ninstall at Tailor Son restaurant				<br />\nDVR Checklist at Tailor Son				<br />\nTravel time included <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-21 23:22:04','2023-05-21 23:22:04',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000087 The Tailor\'s Son / Cash Drawer replacement DYNAMIX Number 107807'),(433,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 275<br />\r\nTicket Title : nstallation of Toast Flex Counter, Receipt Printer and Direct attached Toast Tap<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000086<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello,<br />\n <br />\nWe would like to request a technician for the location below:<br />\n<br />\n·     Address: 3583 16th Street<br />\n<br />\n·     Time: 8:00 AM PST<br />\n<br />\n·     Access to Store:  Granted c/o Kitchen Staff <br />\n<br />\n·     Dynamix Ref Number: 00107780<br />\n<br />\n<br />\nWe’ve also requested the store to prepare the hardware beforehand.<br />\n<br />\nWork Needed:<br />\n<br />\nTask 1: Bring the hardware to the patio<br />\nTask 2: Connect Toast Flex Counter Via Ethernet (Wi-Fi should be disabled)<br />\nTask 3: Connect the Receipt Printer to the Terminal<br />\nTask 4: Connect the direct attached Toast Tap<br />\nTask 5: Verify that the printer is getting the correct IP address<br />\nTask 6: Run a test order and confirm that the printer is working<br />\nTask 5: Label the Toast Flex Counter as: FSRB001-TE-PATIO &<br />\n               Receipt Printer as FSRB001-RP-PATIO<br />\n<br />\nBridge Information:<br />\n<br />\nConference Bridge Phone # 510-982-2796<br />\nParticipant pin # 6694<br />\n<br />\n<br />\nBest regards,<br />\nDale<br />\r\n<br />\r\nSolution :<br />\r\nN/A - No records of invoice on that date for that location <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-21 23:50:01','2023-05-21 23:50:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000086 nstallation of Toast Flex Counter, Receipt Printer and Direct attached Toast Tap DYNAMIX Number 107780'),(434,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 267<br />\r\nTicket Title : Field Tech Request Urgent<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000083<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHi JC/BT Team, <br />\n<br />\nWe would like to request a technician for the location below:<br />\n<br />\nAddress: 2518 Mission Street<br />\nDate: April 19, 2023 (Wednesday)<br />\nTime: 12NN<br />\nAccess to Store:  Granted c/o GM Vincent Choi <br />\nDynamix Ref Number: 00110263<br />\nDevice Type: AP<br />\nConnection Type: Hardwired<br />\n<br />\n<br />\nWork Needed:<br />\nTask 1: Ensure APs are working<br />\nTask 2: Check \"El Techo Rack 3\" is currently offline, possible power or hardware failure.<br />\nTask 3: Test functionality and confirm internet connectivity on all devices.<br />\n<br />\nPlease let us know if you have a technician available for this urgent request, which should be set today.<br />\n<br />\nThank you.<br />\n<br />\nBest,<br />\nMinerva<br />\r\n<br />\r\nSolution :<br />\r\nArrived on site at 11:00 am as per JC request after picking up Fiber equipment at Corporate.  Started testing the network to find out where the problem was.  Started at Lolinda and checked the network at Rack 2 and everything looked to be working correctly.  Moved on to Rack 1 and everything looked good at that point.  All Lolinda devices appeared to be working correctly.  Moved on to El Techo and Rack 3 and I could see that every device connected to Rack 3 was offline.  Checked the Fiber connection and I could see that the light was off.  Based on previous experience with Fiber, I tried various steps to get the connection going again.  After doing multiple tests, it became clear that they were a connectivity issue with the Fiber.  Also, when I arrived, I called the Bridge but no tech joined after 30 minutes so I called JC to inform him and then I joined the bridge again and I was joined by Dale and other technicians.  Eventually Greg joined the call as well.  With guidance from Greg, we proceeded to do additional tests, replacing Fiber cable and SFP and nothing happened.  Greg contacted Rodrigo after it became clear that the Fiber connection was broken somewhere between Lolinda and El Techo.  Rodrigo contacted Access Cabling and they dispatched Francisco to assist on site and he arrived by 2:00 pm.  After he arrived, he and I spent more time trying to possibly locate where the problem with the was and in the meantime, Rodrigo started working on a backup plan which was to use network cable to possibly bypass the Fiber connection.  Around 4:30 pm, I was asked to go to my office as I had a few 100 feet long cables that would be necessary to go from El Techo to Lolinda.  In the meantime, Rodrigo left Novato to assist, and Guido also arrived on site to assist.  Nuranne was also dispatched to assist.  Eventually, we were able to run a cable from El Techo to Lolinda and additional configuration was done by Greg to establish a secondary connection between Lolinda and El Techo without creating a possible loop.  About 7:00 pm, the connection to El Techo was restored and the crew made sure that all network devices at El Techo were working correctly.   Then Rodrigo took everyone to dinner at Lolinda which was very nice.  <br />\nThank you. <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-22 00:04:02','2023-05-22 00:04:02',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000083 Field Tech Request Urgent DYNAMIX Number 110263'),(435,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 266<br />\r\nTicket Title : Super Duper -Los Gatos / Intermittent Internet Connection<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000082<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello,<br />\n <br />\nWe would like to request a technician for the location below:<br />\n <br />\nAddress: 15991 Los Gatos Blvd., Bldg 3<br />\nDate: 4/19/23<br />\nTime: 7:00 AM PST<br />\nAccess to Store:  Granted c/o Kitchen Staff <br />\nDynamix Ref Number: 00110158<br />\nWork Needed:<br />\nA technician is required to assess and investigate intermittent issues that could be due to a faulty cable or a bad uplink port.<br />\n<br />\nBest regards,<br />\nDale<br />\r\n<br />\r\nSolution :<br />\r\nArrived on site by 8:00 am<br />\nConnected to the Bridge<br />\nWaited for a few minutes to be granted access<br />\nWent to the office and followed instructions<br />\nChecked the physical connections of devices on site (took pictures)<br />\nAll physical connection are looking correct<br />\nDid a Continual Pinging from the Manager\'s PC until the time I left.  All good<br />\nVisually looked at the Toast system which all looks to be working as expected<br />\nThen work on the DayForce Tablet<br />\nReconnected the device to the WIFI SSID (BOHTC)<br />\nChecked the device which is now online<br />\nTook pictures for confirmation (4 pictures - more to come)<br />\nThank you. <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-22 00:04:10','2023-05-22 00:04:10',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000082 Super Duper -Los Gatos / Intermittent Internet Connection DYNAMIX Number 110158'),(436,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 263<br />\r\nTicket Title : The Bird Hayes / Reset AV Matrix<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000081<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello Team, <br />\n<br />\nWe would like to request a technician for the location below: <br />\n<br />\nAddress: 406 Hayes Street<br />\nDate:Time:  10AM PST 4/17/2023 (Monday) or Tomorrow<br />\nAccess to Store: Dining<br />\nDynamix Ref Number: 00110135<br />\nDevice Type: TV <br />\nConnection Type: Wired<br />\n<br />\nWork Needed:<br />\nTask 1: Reset AV Matrix / Matrix receiver for TV number 4<br />\nTask 2: Test if the TV can play other channels/movies<br />\n<br />\nRegards,<br />\nJeremy.<br />\r\n<br />\r\nSolution :<br />\r\nArrived on site at 9:55 am<br />\nLocated the TV with the stated issue.  Tv #4 has signal but not maching channel as stated<br />\nJumped on the Bridge<br />\nGuy (After Work Bar GM) arrived on site<br />\nExplain to him what I suppose to do while on site<br />\nTold him I\'m about to reboot the Matrix for the Bar Tv\'s<br />\nRebooted the Matrix in the Network room<br />\nDisconnecred and reconnected HDMI connection to Matrix at TV<br />\nSpoke with Jeremy on the Bridge and explained to him what I had done but told him I would provide details in my report<br />\nTV #4 is back but still with incorrect channel<br />\nTested TV #8 using the Samsung remote to change channel (which seems to control the rest of the TV\'s which I change channel and other TV\'s on the Matrix) except for TV #4<br />\nDecide to use the Comcast remote and TV #4 respond to switching channels<br />\nMatch the channel of TV #4 with TV #8 (again, that TV seems to control the Matrix Channels) and all TV\'s are now on the same channel<br />\nDid a few more test and I can get get all Matrix TV\'s on the same channel included TV #4<br />\nAsk Guy to test it himself and he is able to have TV #4 matching the rest of the other Matrix TV\'s using a Samsung remote (used the one labelled Matrix)<br />\nTalked with Guy and explain to him that different TV\'s have various imput (Matrix connection/some with Apple TV\'s and some with Comcast boxes) and that Nuranne and I worked on a document that clarify which TV\'s has what specific device connected to each TV\'s along with the HDMI imputs and I suggested if Nuranne can email Guy so they have the TV\'s connection nformation on site (information is not accessible to me at this time) which could be useful when needed. <br />\nAsk if Guy had any additional questions and if we was comfortable with the process and he said he was<br />\nAsk Jeremy if he had any more questions and he said no so I left the Bridge<br />\nLeft the site <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-22 00:04:12','2023-05-22 00:04:12',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000081 The Bird Hayes / Reset AV Matrix DYNAMIX Number 110135'),(437,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 131<br />\r\nTicket Title : Troubleshoot Dayforce Offline-El Techo<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000061<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello Blue Technology,<br />\n<br />\n<br />\nWe would like to request a technician for the location below:<br />\nAddress: 2516 Mission St- El Techo and Lolinda<br />\nDate:  ASAP, If possible today April 5<br />\nTime: 9PM PST <br />\nAccess to Store:  C/o Staff <br />\nDynamix Ref Number: 109888<br />\nDevice Type: Dayforce Touch Clock<br />\nConnection Type: Wireless<br />\n<br />\n <br />\n<br />\nWork Needed:<br />\nTask : Determine if it\'s a connection problem or a hardware issue.<br />\nWorked with support team to  ascertain whether the clock has an IP address or not<br />\n<br />\n<br />\nRegards, <br />\nAlexandra<br />\r\n<br />\r\nSolution :<br />\r\nVincent gave me a quick rundowm of the issue<br />\nCalled the Bridge and spoke with Support (Claudette)<br />\nBased on the email information, I was under the impression the DayForce tablet was hard wired as I was asked to remove the Ethernet cable<br />\nTried to unmount the tablet to check connection but could not get it off the wall<br />\nAsked Claudette how to unmount Tablet which she did not know<br />\nTold her I could call Angel who was the one who mounted it<br />\nClaudette said she would stay on the bridge<br />\nCalled Angel and he told me the DayForce Table were connected via wireless<br />\nFollowed his instructions and quickly noted that the Wireless connection was disabled so I re-enabled it<br />\nIt took a few tries but eventually Tablet reconnected<br />\nIP address finally showed<br />\nTrigger a call home and a Software update as per the instructions<br />\nDevice showed a Green connection and Wireless connection<br />\nVincent had staff enter information and it worked as expected according to him<br />\nThen went to El Techo and did the same things for the second Tablet<br />\nWhen done, called the Bridge back but no Claudette<br />\nCalled Dynamix Support, Rohit pickup the call and tranferred me to Dale as he could not contact Claudette<br />\nProvide Dale with IP addresses of both DayForce Tablet and Dale confirmed he could see them online<br />\nInformed Vincent that El Techo DayForce Tablet was fixed as well<br />\nTook pictures<br />\nSuggestions:  DayForce Tablet may need to be hard wired as the isssue was network related instead of a wireless connection<br />\nLeft site <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-22 00:04:14','2023-05-22 00:04:14',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000061 Troubleshoot Dayforce Offline-El Techo DYNAMIX Number 109888'),(438,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 115<br />\r\nTicket Title : Uno Dos Tacos / Connect Yealink Receiver to network<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000045<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello Team, <br />\n<br />\nWe would like to request a technician for the location below: <br />\n<br />\nAddress: 595 Market Street<br />\nDate:Time:  Today if possible / tomorrow Herman will be on site 9AM<br />\nAccess to Store: Managers office<br />\nDynamix Ref Number: 00108896<br />\nDevice Type: Phone <br />\nConnection Type: Wired / Wireless<br />\n<br />\nWork Needed:<br />\nTask 1: Connect Yealink Receiver to the internet<br />\nTask 2: Check 2 phones pairing if connected properly to the receiver <br />\nTask 3: Make sure phone docking is connected and has power<br />\nTask 4: Test phones if its connected and working<br />\n<br />\nTroubleshooting Steps taken:<br />\n· Rebooted phone manually<br />\n· Hard reset<br />\n<br />\nLet us know if you have other questions.<br />\n<br />\nRegards,<br />\nJeremy.<br />\r\n<br />\r\nSolution :<br />\r\nTo all,<br />\nArrived at 2:00 pm, but due to short notice, I eat lunch on site and started working on system at 2:30 pm<br />\nWorked on the Bar side first but all the available Patch Panel Ports were all faulty (2B, 1A and 1B) and I toned them as well to make sure<br />\nthey were correctly labelled. Then went on the counter side and find the only available Patch Panel Port (5B) and connected to the network<br />\nwithout issues. When I tried to connect the Verizon Base to the phones themselves (phones and bases comes in different boxes with this<br />\nnew model) and I simply could not tell which phone should be associated with which Base. I did not get a clear answer from GoIT on that. After explaining the issues with Nuranne, she told me to call SystemGoIT which I did and we were eventually able to connect the phones to the bases. The the phones had to do a long upgrade which took almost 20 minutes and when that was done, we were able to test the phone and quickly realized we could call out but not answer any calls when calling Unos Dos Tacos. Called SystemGoIT again and after providing them the actual phone numbers of the phone themselves, they realized the new phones were not properly setup in the Unos Dos Tacos Hunt Group. When that was corrected, the phone started receiving calls. Monica, who was on site, put one site on the Counter close to the Base (I labelled both of the phones as well) and she brought the second phone itself at the Bar but the Base itself remained connected directly at the Switch. She tested it and still got excellent reception all the way from the bar. Left the premises to go to the next appointment. <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-22 00:20:01','2023-05-22 00:20:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000045 Uno Dos Tacos / Connect Yealink Receiver to network DYNAMIX Number 108896'),(439,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 109<br />\r\nTicket Title : 108817 and 108825 / Super Duper – Metreon / Printer not printing and No sound on their Music<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000039<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello Blue Technology,<br />\n<br />\nWe would like to request a technician for the location below:<br />\n<br />\n � Address: 783 Mission Street, San Francisco CA 94103<br />\n<br />\n � Date: March 8, 2023 (Wednesday)<br />\n<br />\n � Time: 8:00 AM PST<br />\n<br />\n � Access to Store: Granted c/o Janitor<br />\n<br />\n � Dynamix Ref Number: 108817 and 108825<br />\n<br />\n<br />\nWork Needed:<br />\nTask 1: Check the printer\'s physical connection<br />\nTask 2: Check Kiosk connectivity<br />\nTask 3: Run a test order and confirm that the printer is working<br />\nTask 4: Check Music for no sounds<br />\n<br />\nTroubleshooting Steps were taken:<br />\nRestarted the kiosk - no go<br />\nPower cycle the printer - no go<br />\nCheck physical connection<br />\nCables are firmly connected<br />\nThen tried the backup printer - no go<br />\nPrinted test page – ok<br />\nCheck Kiosk\'s network settings:<br />\nWi-fi off<br />\nEthernet 0 (USB-C)<br />\nEthernet 1 (RJ-45)<br />\nIP: 192.168.192.222<br />\nTried printing from Kiosk 1 it will print to SSUP05-RP-K01 instead of SSUP05-RP-TE1<br />\nOn Music system:<br />\nCheck if its on mute - no<br />\nCheck volume - still no go<br />\n<br />\nPlease let us know if you have any questions.<br />\n<br />\nRegards,<br />\r\n<br />\r\nSolution :<br />\r\nTested both Receipt printers and  they tested/print 				<br />\ncorrectly.  Got the IP address for both printers				<br />\nDid some tests with Tech Minerva to validate the 				<br />\nproblem.  Realized that Receipts Printers between 				<br />\nKiosk and Term1 has been swapped between the 				<br />\ntwo Workstations.  Swapped Printers back to proper 				<br />\nlocations and reconnected both of them				<br />\nTested Kiosk Workstation again and Kiosk finally 				<br />\nprinted correctly.  				<br />\nIncludes travel time. <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-22 00:20:09','2023-05-22 00:20:09',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000039 108817 and 108825 / Super Duper – Metreon / Printer not printing and No sound on their Music DYNAMIX Number 108825'),(440,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 108<br />\r\nTicket Title : 108817 and 108825 / Super Duper – Metreon / Printer not printing and No sound on their Music<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000038<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nTicket ID : 112<br />\nTicket Title : 108817 and 108825 / Super Duper – Metreon / Printer not printing and No sound on their Music<br />\n<br />\n<br />\nTicket No : TKT000042<br />\nStatus : Closed<br />\nCategory : Small Problem<br />\nSeverity : Minor<br />\nPriority : Normal<br />\n<br />\nDescription :<br />\nHello Blue Technology,<br />\n<br />\nWe would like to request a technician for the location below:<br />\n<br />\n � Address: 783 Mission Street, San Francisco CA 94103<br />\n<br />\n � Date: March 8, 2023 (Wednesday)<br />\n<br />\n � Time: 8:00 AM PST<br />\n<br />\n � Access to Store: Granted c/o Janitor<br />\n<br />\n � Dynamix Ref Number: 108817 and 108825<br />\n<br />\n<br />\nWork Needed:<br />\nTask 1: Check the printer\'s physical connection<br />\nTask 2: Check Kiosk connectivity<br />\nTask 3: Run a test order and confirm that the printer is working<br />\nTask 4: Check Music for no sounds<br />\n<br />\nTroubleshooting Steps were taken:<br />\nRestarted the kiosk - no go<br />\nPower cycle the printer - no go<br />\nCheck physical connection<br />\nCables are firmly connected<br />\nThen tried the backup printer - no go<br />\nPrinted test page – ok<br />\nCheck Kiosk\'s network settings:<br />\nWi-fi off<br />\nEthernet 0 (USB-C)<br />\nEthernet 1 (RJ-45)<br />\nIP: 192.168.192.222<br />\nTried printing from Kiosk 1 it will print to SSUP05-RP-K01 instead of SSUP05-RP-TE1<br />\nOn Music system:<br />\nCheck if its on mute - no<br />\nCheck volume - still no go<br />\n<br />\nPlease let us know if you have any questions.<br />\r\n<br />\r\nSolution :<br />\r\nTested both Receipt printers and  they tested/print 				<br />\ncorrectly.  Got the IP address for both printers				<br />\nDid some tests with Tech Minerva to validate the 				<br />\nproblem.  Realized that Receipts Printers between 				<br />\nKiosk and Term1 has been swapped between the 				<br />\ntwo Workstations.  Swapped Printers back to proper 				<br />\nlocations and reconnected both of them				<br />\nTested Kiosk Workstation again and Kiosk finally 				<br />\nprinted correctly.  				<br />\nIncludes travel time. <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-22 00:34:01','2023-05-22 00:34:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000038 108817 and 108825 / Super Duper – Metreon / Printer not printing and No sound on their Music DYNAMIX Number 108817'),(441,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 85<br />\r\nTicket Title : Comcast Enterprise Services Planned Maintenance Notification - CM004269753<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000015<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nI think we all have confused a few things, let me clarify.<br />\n<br />\n <br />\n<br />\nTicket 00107907- Comcast Maintenace for Flores Emeryville<br />\nTicket 00107832 - CSD014 Site Down <br />\n Site is up<br />\nWe attempted to call store. We will call back when they open in 1 hour.<br />\n<br />\nI checked with my NOC, and they said this outage is most likely related to the Maintenace window, however we do not have this in writing from Comcast.<br />\n<br />\n <br />\n<br />\n<br />\n@jc@mybluetechnology.com - If Yann is in the area, let\'s have him do a quick check at CSD014 and then we handle Flores as it happens. I will email Yann from both tickets and CC you. Please make sure he responds to those specific tickets with each site update.<br />\r\n<br />\r\nSolution :<br />\r\nSent by Charlie to Flores Emeryville.  Could not get				<br />\naccess to location as location needs prior 				<br />\nnotifications for access <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-22 00:34:09','2023-05-22 00:34:09',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000015 Comcast Enterprise Services Planned Maintenance Notification - CM004269753 DYNAMIX Number 107832'),(442,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 84<br />\r\nTicket Title : omcast Enterprise Services Planned Maintenance Notification - CM004269753<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000014<br />\r\nStatus : Closed<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nChecking on internet issue on site.  Details				<br />\nof issues detailled with Dynamix Support 				<br />\nIncludes travel time and Toll fee<br />\r\n<br />\r\nSolution :<br />\r\nChecking on internet issue on site.  Details				<br />\nof issues detailled with Dynamix Support 				<br />\nIncludes travel time and Toll fee <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-22 00:48:01','2023-05-22 00:48:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000014 omcast Enterprise Services Planned Maintenance Notification - CM004269753 DYNAMIX Number 0'),(443,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 76<br />\r\nTicket Title : Troubleshoot Dayforce Offline-El Techo<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000006<br />\r\nStatus : In Progress<br />\r\nCategory : Small Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nDear Dalrymple Yann,<br />\n<br />\n<br />\nThere is an update to:<br />\n<br />\nTicket ID : 131<br />\nTicket Title : Troubleshoot Dayforce Offline-El Techo<br />\n<br />\n<br />\nTicket No : TKT000061<br />\nStatus : Closed<br />\nCategory : Small Problem<br />\nSeverity : Minor<br />\nPriority : Normal<br />\n<br />\nDescription :<br />\nHello Blue Technology,<br />\n<br />\n<br />\nWe would like to request a technician for the location below:<br />\nAddress: 2516 Mission St- El Techo and Lolinda<br />\nDate: ASAP, If possible today April 5<br />\nTime: 9PM PST<br />\nAccess to Store: C/o Staff<br />\nDynamix Ref Number: 109888<br />\nDevice Type: Dayforce Touch Clock<br />\nConnection Type: Wireless<br />\n<br />\n<br />\n<br />\nWork Needed:<br />\nTask : Determine if it\'s a connection problem or a hardware issue.<br />\nWorked with support team to ascertain whether the clock has an IP address or not<br />\n<br />\n<br />\nRegards,<br />\nAlexandra<br />\r\n<br />\r\nSolution :<br />\r\nSupport,<br />\nRecap:  <br />\nArrived at 1:15 on site and Vincent (GM) was on site at Lolinda<br />\nAsked him to show me where the Lolinda DayForce tablet was located at<br />\nVincent gave me a quick rundowm of the issue<br />\nCalled the Bridge and spoke with Support (Claudette)<br />\nBased on the email information, I was under the impression the DayForce tablet was hard wired as I was asked to remove the Ethernet cable<br />\nTried to unmount the tablet to check connection but could not get it off the wall<br />\nAsked Claudette how to unmount Tablet which she did not know<br />\nTold her I could call Angel who was the one who mounted it<br />\nClaudette said she would stay on the bridge<br />\nCalled Angel and he told me the DayForce Table were connected via wireless<br />\nFollowed his instructions and quickly noted that the Wireless connection was disabled so I re-enabled it<br />\nIt took a few tries but eventually Tablet reconnected<br />\nIP address finally showed<br />\nTrigger a call home and a Software update as per the instructions<br />\nDevice showed a Green connection and Wireless connection<br />\nVincent had staff enter information and it worked as expected according to him<br />\nThen went to El Techo and did the same things for the second Tablet<br />\nWhen done, called the Bridge back but no Claudette<br />\nCalled Dynamix Support, Rohit pickup the call and tranferred me to Dale as he could not contact Claudette<br />\nProvide Dale with IP addresses of both DayForce Tablet and Dale confirmed he could see them online<br />\nInformed Vincent that El Techo DayForce Tablet was fixed as well<br />\nTook pictures<br />\nSuggestions:  DayForce Tablet may need to be hard wired as the isssue was network related instead of a wireless connection<br />\nLeft site <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-22 00:48:09','2023-05-22 00:48:09',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000006 Troubleshoot Dayforce Offline-El Techo DYNAMIX Number 109888'),(444,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 74<br />\r\nTicket Title : SD Serramonte SDWAN equipment pickup<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000005<br />\r\nStatus : Closed<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nHello Blue Technology, <br />\n<br />\n<br />\nWe would like to request a technician for the location below:<br />\n<br />\n<br />\nAddress: 3 Serramonte Center, Space #662 Dally City- SD Serramonte<br />\n<br />\nDate:  April 5, 2023<br />\n<br />\nTime: 7:45 AM PST<br />\n<br />\nAccess to Store:  Granted c/o Kitchen Staff<br />\n<br />\nDynamix Ref Number: 109856<br />\n<br />\nDevice Type: SDWAN equipment<br />\n<br />\n <br />\n<br />\nWork Needed:<br />\n Task 1: Prio to heading To Serramonte, kindly proceed to 2030 Union St. to retrieve the keys that have been left in the lockbox situated at the back of the stairs at 2030 Union St.<br />\nTask 2: Record the equipment information being picked up by Comcast schedule between 8-10 AM which includes : 2 device Advantech and  Cradlepoint  of  3 Serramonte Center, Space #662<br />\n<br />\n<br />\nRegards, <br />\nAlexandra<br />\r\n<br />\r\nSolution :<br />\r\nSupport,<br />\nRecap:<br />\nArrived at 7:45 am<br />\nJumped on the Bridge<br />\nEmployee was on site already<br />\nEmployee left at 8 am<br />\nLocated Comcast equipment on top of Network rack<br />\nDid a continual Ping to insure that me removed the Comcast equipment would not disconnect site.  No issue<br />\nRemoved all equipment including power cords and network cables connected to Comcast devices<br />\nClosed the Rack back after removing equipment<br />\nTook pictures of devices<br />\nSpoke with Support on Bridge<br />\nProvided information requested by Support<br />\nSupport left the bridge and so did I<br />\nAttached pictures of devices to Email<br />\nWaiting for Comcast on site to hand over equipment as requested<br />\nWill drop off store key today back where I picked it up<br />\n<br />\nCradlepoint<br />\nSN MM214800003658<br />\nMAC 003044758c74<br />\nIMEI 357926103386384<br />\n <br />\nAdvantech<br />\nKSA3855737 <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-22 01:02:01','2023-05-22 01:02:01',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000005 SD Serramonte SDWAN equipment pickup DYNAMIX Number 109856'),(445,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Solorzano Angel,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 420<br />\r\nTicket Title : Super Duper - Novato /  UPS Replacement / 110762<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000107<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Normal<br />\r\n<br />\r\nDescription :<br />\r\nWe would like to request a technician for the location below:<br />\n<br />\nAddress: 5800 Nave Drive, Suite C<br />\n<br />\nDate: May 22, 2023 (Monday)<br />\n<br />\nTime: 07:00AM-09:00AM PST<br />\n<br />\nAccess to Store:  Granted c/o Janitor <br />\n<br />\nDynamix Ref Number: 110762<br />\n<br />\nDevice Type: UPS<br />\n<br />\n<br />\nWork Needed: <br />\n•	Rack mount battery into rack and connect all sensitive devices per BOH standards (modem(s), switch, Meraki, etc)<br />\n•	Remove bad/beeping battery backup that is located above office computer – This can be plugged into the wall directly.<br />\r\n<br />\r\nSolution :<br />\r\n <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-22 15:36:02','2023-05-22 15:36:02',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000107 Super Duper - Novato /  UPS Replacement / 110762 DYNAMIX Number 110762'),(446,1,1,1,'Emails','An Contact has been assigned to you on vtigerCRM<br>Details of Contact are :<br><br>Contact Id:<b>CON000012</b><br>LastName:<b>Support</b><br>FirstName:<b>Dynamix</b><br>Lead Source:<b></b><br>Department:<b></b><br>Description:<b></b><br><br><br>And <b>CustomerPortal Login Details</b> is sent to the EmailID :-dynamix@mybluetechnology.com<br><br>Thank You<br>Admin<br><br>','2023-05-22 21:44:01','2023-05-22 21:44:01',NULL,NULL,0,1,0,0,'CRM','Regarding Contact Assignment'),(447,6,5,6,'HelpDesk','We would like to request a technician for the location below:\n  \n•	Address: 3401 California Street\n•	Date & Time: ASAP, Today\n•	Access to Store:  Granted c/o Kitchen Staff \n•	Dynamix Ref Number: 00111239\n\nWork Needed:\n\nTask 1: identify the root cause of the internet connection issue and provide solution for resolution.','2023-05-24 15:39:55','2023-05-25 03:51:25',NULL,NULL,0,1,0,0,'CRM','Urgent: Super Duper Laurel Village /  Network Down'),(448,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : 447<br />\r\nTicket Title : Urgent: Super Duper Laurel Village /  Network Down<br />\r\n<br />\r\nDear Dalrymple Yann,<br />\r\n<br />\r\nYou have been assigned to the following ticket:<br />\r\n<br />\r\nTicket No : TKT000109<br />\r\nStatus : Open<br />\r\nCategory : Big Problem<br />\r\nSeverity : Critical<br />\r\nPriority : High<br />\r\n<br />\r\nDYNAMIX TICKET NUMBER:&nbsp;111239<br />\r\n<br />\r\nDescription :<br />\r\nWe would like to request a technician for the location below:<br />\n  <br />\n•	Address: 3401 California Street<br />\n•	Date & Time: ASAP, Today<br />\n•	Access to Store:  Granted c/o Kitchen Staff <br />\n•	Dynamix Ref Number: 00111239<br />\n<br />\nWork Needed:<br />\n<br />\nTask 1: identify the root cause of the internet connection issue and provide solution for resolution.<br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size:20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family:verdana,geneva,sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-24 15:50:02','2023-05-24 15:50:02',NULL,NULL,0,1,0,0,'CRM','YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000109 Urgent: Super Duper Laurel Village /  Network Down DYNAMIX NUMBER 111239'),(449,6,6,6,'Accounts','','2023-05-24 21:41:35','2023-05-24 21:41:35',NULL,NULL,0,1,0,0,'CRM','FCOR001 Corzetti'),(450,6,6,6,'Accounts','','2023-05-24 21:46:57','2023-05-24 21:46:57',NULL,NULL,0,1,0,0,'CRM','FLOL001ET-El Techo'),(451,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 447<br />\r\nTicket Title : Urgent: Super Duper Laurel Village /  Network Down<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000109<br />\r\nStatus : Open<br />\r\nCategory : Big Problem<br />\r\nSeverity : Critical<br />\r\nPriority : High<br />\r\n<br />\r\nDescription :<br />\r\nWe would like to request a technician for the location below:<br />\n  <br />\n•	Address: 3401 California Street<br />\n•	Date & Time: ASAP, Today<br />\n•	Access to Store:  Granted c/o Kitchen Staff <br />\n•	Dynamix Ref Number: 00111239<br />\n<br />\nWork Needed:<br />\n<br />\nTask 1: identify the root cause of the internet connection issue and provide solution for resolution.<br />\r\n<br />\r\nSolution :<br />\r\nRecap of Service Call:<br />\nArrived on site at 8:30 am<br />\nCalled Greg directly as directed<br />\nExplain to him what I saw on site and he asked me to power cycle the POE Injector that connects to the Verizon Antenna on the roof which was connected to the Secondary internet on the Meraki Router<br />\nAfter the reboot was done, internet came back on but only on certain VLAN<br />\nGreg corrected that but we still had connectivity issues<br />\nGreg asked me to power down the AT&T Modem which was connected to the the Primary WAN.  When I did that, the Internet came back on on all VLAN<br />\nChecked the Toast system that appaered to be online.  Manager on site confirmed that all Toast equipment including the Hand Haelds were working<br />\nThe only problem left on site is the Ceridian which would not connect to the Wifi SSID (BOHTC)<br />\nI suggested to connect to another SSID to get it online but I did not get the authorization<br />\nI asked for the BOHTC SSID Password so I could test it on my laptop but I was not given the information <br />\nFor additional information, the AT&T Ciena is live but has a SFP Connector that cannot be connected as the VLAN Switch does not have a Fiber Port<br />\nGreg told me he was going to arrange for me to pick a Converter from Corporate but I receive no follow-up as of 12:30 pm PST. <br />\nAnother visit is possibly being requested for May 25th in the morning but no confirmation yet.<br />\nIf confirmed, I need an early appointment (7:30 am start) as I have a 9:00 am appointment already scheduled for the 25th.    <br />\nLeft the store at 9:30 am to get to my next scheduled appointment.<br />\nThank you. <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-25 01:06:02','2023-05-25 01:06:02',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000109 Urgent: Super Duper Laurel Village /  Network Down DYNAMIX Number 111239'),(452,1,5,1,'HelpDesk','Hello JC, \n \nSee details on new location:\nName: Corzetti\nCode: FCOR001\nLocation: 386 Geary St, San Francisco, CA 94102\n \nSee photos below of items that need to be picked up at the above location and taken to storage in Novato. Rodrigo will be able to provide access at the storage facility, depending on the time. If he is not available, items can be left at Super Duper Novato during business hours (10:30am – 9pm)\n \nIf pickup is possible today – I will be on site until 3pm to provide access inside. If we need to schedule this on a different day – I will need to confirm if access is available or not. \n \nPlease let me know when we can get this scheduled and if you have any questions. Thank you!\n \n \n \n \n \n \n \n \n \n(only the 4 white speakers in photo above)','2023-05-25 03:19:03','2023-05-25 03:46:01',NULL,NULL,0,1,0,0,'CUSTOMER PORTAL','FCOR001 Corzetti :  Re: Items for storage'),(453,6,5,6,'HelpDesk','We are confirmed for 7:30AM. \n\nThanks\n\n\n--------------- Original Message ---------------\nFrom: Nuranne Dairkee [ndairkee@backofthehouseinc.com]\nSent: 5/24/2023, 6:22 PM\nTo: yann@mybluetechnology.com; frontline@dynamixsupport.com\nCc: jc@mybluetechnology.com\nSubject: Re: Internet Downtime Update\n\n\n \nGreg,\n \nI just spoke directly with Yann about this. I’ll leave the converter on site as well as keys for access. Please schedule this for 7:30am PST tomorrow 5/25. Yann mentioned he has an appointment at 9am. If you feel the start time needs adjusted to an earlier time, please let us know here. \n \nThanks,\n \n________________________________________\nFrom: Dynamix Frontline Services \nSent: Wednesday, May 24, 2023 3:18:11 PM\nTo: yann@mybluetechnology.com \nCc: Nuranne Dairkee ; jc@mybluetechnology.com \nSubject: RE: Internet Downtime Update \n \nHi Yann,\n\nWere you able to pick up the SFP media converter today? What time will you be onsite tomorrow? \n\nGreg\n\n\n--------------- Original Message ---------------\nFrom: Dynamix Frontline Services [frontline@dynamixsupport.com]\nSent: 5/24/2023, 4:38 PM\nTo: sespinoza@superdupersf.com\nSubject: Internet Downtime Update\n  \nHello Cici,\nWe just wanted to follow up and let you know that the store is back online using secondary Internet and all services should be fully operational. We will update you once the primary Internet is fixed as this ticket is linked to 0111265.\nThank you for your patience and understanding.\n \nSincerely, \nCharlie','2023-05-25 03:30:22','2023-05-25 03:33:12',NULL,NULL,0,1,0,0,'CRM','Re: Internet Downtime Update'),(454,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">You have created a new Ticket:&nbsp;TKT000110 in the Blue Technology Support Ticketing System<br />\r\nTicket No : TKT000110<br />\r\nTicket ID : 452<br />\r\nTicket Title : FCOR001 Corzetti :  Re: Items for storage<br />\r\n<br />\r\nHello JC, <br />\n <br />\nSee details on new location:<br />\nName: Corzetti<br />\nCode: FCOR001<br />\nLocation: 386 Geary St, San Francisco, CA 94102<br />\n <br />\nSee photos below of items that need to be picked up at the above location and taken to storage in Novato. Rodrigo will be able to provide access at the storage facility, depending on the time. If he is not available, items can be left at Super Duper Novato during business hours (10:30am – 9pm)<br />\n <br />\nIf pickup is possible today – I will be on site until 3pm to provide access inside. If we need to schedule this on a different day – I will need to confirm if access is available or not. <br />\n <br />\nPlease let me know when we can get this scheduled and if you have any questions. Thank you!<br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n(only the 4 white speakers in photo above)<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span></body>\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></html>\r\n<br><br>','2023-05-25 03:32:01','2023-05-25 03:32:01',NULL,NULL,0,1,1,0,'CRM',''),(455,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">A ticket has been created on the Blue Technology Customer Portal.<br />\r\n<br />\r\nTicket No : TKT000110<br />\r\nTicket ID : 452<br />\r\nTicket Title : FCOR001 Corzetti :  Re: Items for storage<br />\r\n<br />\r\nHello JC, <br />\n <br />\nSee details on new location:<br />\nName: Corzetti<br />\nCode: FCOR001<br />\nLocation: 386 Geary St, San Francisco, CA 94102<br />\n <br />\nSee photos below of items that need to be picked up at the above location and taken to storage in Novato. Rodrigo will be able to provide access at the storage facility, depending on the time. If he is not available, items can be left at Super Duper Novato during business hours (10:30am – 9pm)<br />\n <br />\nIf pickup is possible today – I will be on site until 3pm to provide access inside. If we need to schedule this on a different day – I will need to confirm if access is available or not. <br />\n <br />\nPlease let me know when we can get this scheduled and if you have any questions. Thank you!<br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n(only the 4 white speakers in photo above)<br />\r\n<br />\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-25 03:32:01','2023-05-25 03:32:01',NULL,NULL,0,1,0,0,'CRM','A new ticket has been created on the Customer Portal'),(456,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 452<br />\r\nTicket Title : FCOR001 Corzetti :  Re: Items for storage<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000110<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Low<br />\r\n<br />\r\nDescription :<br />\r\nHello JC, <br />\n <br />\nSee details on new location:<br />\nName: Corzetti<br />\nCode: FCOR001<br />\nLocation: 386 Geary St, San Francisco, CA 94102<br />\n <br />\nSee photos below of items that need to be picked up at the above location and taken to storage in Novato. Rodrigo will be able to provide access at the storage facility, depending on the time. If he is not available, items can be left at Super Duper Novato during business hours (10:30am – 9pm)<br />\n <br />\nIf pickup is possible today – I will be on site until 3pm to provide access inside. If we need to schedule this on a different day – I will need to confirm if access is available or not. <br />\n <br />\nPlease let me know when we can get this scheduled and if you have any questions. Thank you!<br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n(only the 4 white speakers in photo above)<br />\r\n<br />\r\nSolution :<br />\r\n <br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-25 03:32:03','2023-05-25 03:32:03',NULL,NULL,0,1,0,0,'CRM','UPDATE Ticket Number : TKT000110 FCOR001 Corzetti :  Re: Items for storage DYNAMIX Number 0'),(457,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : 453<br />\r\nTicket Title : Re: Internet Downtime Update<br />\r\n<br />\r\nDear Dalrymple Yann,<br />\r\n<br />\r\nYou have been assigned to the following ticket:<br />\r\n<br />\r\nTicket No : TKT000111<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Major<br />\r\nPriority : High<br />\r\n<br />\r\nDYNAMIX TICKET NUMBER:&nbsp;1112861<br />\r\n<br />\r\nDescription :<br />\r\nWe are confirmed for 7:30AM. <br />\n<br />\nThanks<br />\n<br />\n<br />\n--------------- Original Message ---------------<br />\nFrom: Nuranne Dairkee [ndairkee@backofthehouseinc.com]<br />\nSent: 5/24/2023, 6:22 PM<br />\nTo: yann@mybluetechnology.com; frontline@dynamixsupport.com<br />\nCc: jc@mybluetechnology.com<br />\nSubject: Re: Internet Downtime Update<br />\n<br />\n<br />\n <br />\nGreg,<br />\n <br />\nI just spoke directly with Yann about this. I’ll leave the converter on site as well as keys for access. Please schedule this for 7:30am PST tomorrow 5/25. Yann mentioned he has an appointment at 9am. If you feel the start time needs adjusted to an earlier time, please let us know here. <br />\n <br />\nThanks,<br />\n <br />\n________________________________________<br />\nFrom: Dynamix Frontline Services <br />\nSent: Wednesday, May 24, 2023 3:18:11 PM<br />\nTo: yann@mybluetechnology.com <br />\nCc: Nuranne Dairkee ; jc@mybluetechnology.com <br />\nSubject: RE: Internet Downtime Update <br />\n <br />\nHi Yann,<br />\n<br />\nWere you able to pick up the SFP media converter today? What time will you be onsite tomorrow? <br />\n<br />\nGreg<br />\n<br />\n<br />\n--------------- Original Message ---------------<br />\nFrom: Dynamix Frontline Services [frontline@dynamixsupport.com]<br />\nSent: 5/24/2023, 4:38 PM<br />\nTo: sespinoza@superdupersf.com<br />\nSubject: Internet Downtime Update<br />\n  <br />\nHello Cici,<br />\nWe just wanted to follow up and let you know that the store is back online using secondary Internet and all services should be fully operational. We will update you once the primary Internet is fixed as this ticket is linked to 0111265.<br />\nThank you for your patience and understanding.<br />\n <br />\nSincerely, <br />\nCharlie<br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size:20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family:verdana,geneva,sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-25 03:32:05','2023-05-25 03:32:05',NULL,NULL,0,1,0,0,'CRM','YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000111 Re: Internet Downtime Update DYNAMIX NUMBER 1112861'),(458,6,6,6,'ModComments',NULL,'2023-05-25 03:39:10','2023-05-25 03:39:10',NULL,NULL,0,1,0,0,'CRM','Pics from Nuranne'),(459,6,6,0,'ModComments Attachment',NULL,'2023-05-25 03:39:10','2023-05-25 03:39:10',NULL,NULL,0,1,0,NULL,NULL,NULL),(460,6,6,0,'ModComments Attachment',NULL,'2023-05-25 03:39:10','2023-05-25 03:39:10',NULL,NULL,0,1,0,NULL,NULL,NULL),(461,6,6,0,'ModComments Attachment',NULL,'2023-05-25 03:39:10','2023-05-25 03:39:10',NULL,NULL,0,1,0,NULL,NULL,NULL),(462,6,6,0,'ModComments Attachment',NULL,'2023-05-25 03:39:11','2023-05-25 03:39:11',NULL,NULL,0,1,0,NULL,NULL,NULL),(463,6,6,0,'ModComments Attachment',NULL,'2023-05-25 03:39:11','2023-05-25 03:39:11',NULL,NULL,0,1,0,NULL,NULL,NULL),(464,1,1,1,'Emails','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear Dalrymple Yann,<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : 452<br />\r\nTicket Title : FCOR001 Corzetti :  Re: Items for storage<br />\r\n<br />\r\n<br />\r\nTicket No : TKT000110<br />\r\nStatus : Open<br />\r\nCategory : Other Problem<br />\r\nSeverity : Minor<br />\r\nPriority : Low<br />\r\n<br />\r\nDescription :<br />\r\nHello JC, <br />\n <br />\nSee details on new location:<br />\nName: Corzetti<br />\nCode: FCOR001<br />\nLocation: 386 Geary St, San Francisco, CA 94102<br />\n <br />\nSee photos below of items that need to be picked up at the above location and taken to storage in Novato. Rodrigo will be able to provide access at the storage facility, depending on the time. If he is not available, items can be left at Super Duper Novato during business hours (10:30am – 9pm)<br />\n <br />\nIf pickup is possible today – I will be on site until 3pm to provide access inside. If we need to schedule this on a different day – I will need to confirm if access is available or not. <br />\n <br />\nPlease let me know when we can get this scheduled and if you have any questions. Thank you!<br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n <br />\n(only the 4 white speakers in photo above)<br />\r\n<br />\r\nSolution :<br />\r\n Pics from Nuranne<br>JC Ismodes Commented at:<small>05-24-2023 8:39 PM ((UTC-08:00) Tijuana, Baja California)</small><br><br><br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n<br><br>','2023-05-25 03:46:01','2023-05-25 03:46:12',NULL,NULL,0,1,1,0,'CRM','UPDATE Ticket Number : TKT000110 FCOR001 Corzetti :  Re: Items for storage DYNAMIX Number 0');

--
-- Table structure for table `vtiger_crmentity_seq`
--

CREATE TABLE `vtiger_crmentity_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_crmentity_seq`
--

INSERT INTO `vtiger_crmentity_seq` VALUES (464);

--
-- Table structure for table `vtiger_crmentity_user_field`
--

CREATE TABLE `vtiger_crmentity_user_field` (
  `recordid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `starred` varchar(100) DEFAULT NULL,
  KEY `record_user_idx` (`recordid`,`userid`),
  CONSTRAINT `fk_vtiger_crmentity_user_field_recordid` FOREIGN KEY (`recordid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_crmentity_user_field`
--

INSERT INTO `vtiger_crmentity_user_field` VALUES (2,1,'0'),(3,1,'0'),(4,1,'0'),(5,1,'0'),(6,1,'0'),(7,1,'0'),(8,1,'0'),(9,1,'0'),(10,1,'0'),(11,1,'0'),(12,1,'0'),(13,1,'0'),(14,1,'0'),(15,1,'0'),(16,1,'0'),(17,1,'0'),(18,1,'0'),(19,1,'0'),(20,1,'0'),(21,1,'0'),(22,1,'0'),(23,1,'0'),(24,1,'0'),(25,1,'0'),(26,1,'0'),(27,1,'0'),(28,1,'0'),(29,1,'0'),(30,1,'0'),(31,1,'0'),(32,1,'0'),(33,1,'0'),(34,1,'0'),(35,1,'0'),(36,1,'0'),(37,1,'0'),(38,1,'0'),(39,1,'0'),(40,6,'1'),(44,6,'0'),(45,6,'0'),(51,1,'0'),(52,1,'0'),(53,1,'0'),(54,1,'0'),(55,1,'0'),(56,1,'0'),(57,1,'0'),(58,1,'0'),(59,1,'0'),(60,1,'0'),(61,1,'0'),(62,1,'0'),(63,1,'0'),(64,1,'0'),(65,1,'0'),(66,1,'0'),(67,1,'0'),(68,1,'0'),(69,1,'0'),(70,1,'0'),(71,1,'0'),(72,1,'0'),(73,1,'0'),(51,6,'1'),(36,6,'1'),(38,6,'1'),(74,6,'0'),(75,6,'0'),(76,6,'0'),(77,6,'0'),(78,6,'0'),(79,6,'0'),(80,6,'0'),(81,6,'0'),(82,6,'0'),(83,6,'0'),(84,6,'0'),(85,6,'0'),(86,6,'0'),(87,6,'0'),(88,6,'0'),(89,6,'0'),(90,6,'0'),(91,6,'0'),(92,6,'0'),(93,6,'0'),(94,6,'0'),(95,6,'0'),(96,6,'0'),(97,6,'0'),(98,6,'0'),(99,6,'0'),(100,6,'0'),(101,6,'0'),(102,6,'0'),(103,6,'0'),(104,6,'0'),(105,6,'0'),(106,6,'0'),(107,6,'0'),(108,6,'0'),(109,6,'0'),(110,6,'0'),(111,6,'0'),(112,6,'0'),(113,6,'0'),(114,6,'0'),(115,6,'0'),(116,6,'0'),(117,6,'0'),(118,6,'0'),(119,6,'0'),(120,6,'0'),(121,6,'0'),(122,6,'0'),(123,6,'0'),(124,6,'0'),(125,6,'0'),(126,6,'0'),(127,6,'0'),(128,6,'0'),(129,6,'0'),(130,6,'0'),(131,6,'0'),(15,6,'0'),(11,6,'0'),(27,6,'0'),(7,6,'0'),(32,6,'0'),(23,6,'0'),(10,6,'0'),(16,6,'0'),(6,6,'0'),(26,6,'0'),(9,6,'0'),(22,6,'0'),(25,6,'0'),(34,6,'0'),(5,6,'0'),(8,6,'0'),(24,6,'0'),(18,6,'0'),(21,6,'0'),(4,6,'0'),(12,6,'0'),(13,6,'0'),(14,6,'0'),(17,6,'0'),(19,6,'0'),(20,6,'0'),(2,6,'0'),(131,1,'0'),(132,6,'0'),(133,1,'0'),(134,1,'0'),(135,1,'0'),(136,1,'0'),(137,1,'0'),(138,1,'0'),(139,1,'0'),(140,1,'0'),(141,1,'0'),(142,1,'0'),(143,1,'0'),(144,1,'0'),(145,1,'0'),(146,1,'0'),(147,1,'0'),(148,1,'0'),(149,1,'0'),(150,1,'0'),(151,1,'0'),(152,1,'0'),(153,1,'0'),(154,1,'0'),(155,1,'0'),(156,1,'0'),(157,1,'0'),(158,1,'0'),(159,1,'0'),(160,1,'0'),(161,1,'0'),(162,1,'0'),(163,1,'0'),(164,1,'0'),(165,1,'0'),(166,1,'0'),(167,1,'0'),(168,1,'0'),(169,1,'0'),(170,1,'0'),(171,1,'0'),(172,1,'0'),(173,1,'0'),(174,1,'0'),(175,1,'0'),(176,1,'0'),(177,1,'0'),(178,1,'0'),(179,1,'0'),(180,1,'0'),(181,1,'0'),(182,1,'0'),(183,1,'0'),(184,1,'0'),(185,1,'0'),(186,1,'0'),(187,1,'0'),(188,1,'0'),(189,1,'0'),(190,1,'0'),(191,1,'0'),(192,1,'0'),(193,1,'0'),(194,1,'0'),(195,1,'0'),(132,1,'0'),(197,1,'0'),(198,1,'0'),(199,1,'0'),(130,1,'0'),(200,1,'0'),(201,1,'0'),(202,1,'0'),(198,6,'0'),(203,1,'0'),(200,6,'0'),(204,1,'0'),(205,1,'0'),(206,1,'0'),(207,6,'0'),(208,1,'0'),(209,1,'0'),(210,1,'0'),(211,1,'0'),(212,1,'0'),(213,1,'0'),(214,1,'0'),(215,1,'0'),(216,1,'0'),(217,1,'0'),(218,6,'0'),(219,1,'0'),(220,6,'0'),(221,1,'0'),(222,6,'0'),(223,6,'0'),(224,1,'0'),(225,1,'0'),(226,1,'0'),(227,6,'0'),(228,6,'0'),(229,1,'0'),(230,1,'0'),(231,6,'0'),(232,6,'0'),(233,6,'0'),(234,6,'0'),(235,1,'0'),(236,1,'0'),(237,1,'0'),(238,1,'0'),(239,1,'0'),(240,1,'0'),(241,1,'0'),(242,1,'0'),(243,1,'0'),(244,6,'0'),(245,6,'0'),(246,1,'0'),(247,1,'0'),(248,6,'0'),(249,1,'0'),(250,6,'0'),(251,1,'0'),(252,6,'0'),(253,6,'0'),(254,1,'0'),(255,1,'0'),(256,6,'0'),(257,6,'0'),(258,1,'0'),(259,1,'0'),(260,1,'0'),(261,1,'0'),(262,1,'0'),(263,6,'0'),(264,1,'0'),(265,1,'0'),(266,6,'0'),(267,6,'0'),(268,1,'0'),(269,1,'0'),(270,1,'0'),(271,6,'0'),(272,6,'0'),(273,1,'0'),(274,1,'0'),(275,6,'0'),(276,1,'0'),(277,6,'0'),(278,1,'0'),(279,1,'0'),(280,1,'0'),(281,1,'0'),(282,1,'0'),(283,1,'0'),(284,1,'0'),(285,6,'0'),(286,1,'0'),(287,1,'0'),(288,1,'0'),(289,1,'0'),(290,1,'0'),(291,1,'0'),(292,1,'0'),(293,6,'0'),(294,1,'0'),(295,6,'0'),(296,1,'0'),(128,1,'0'),(290,6,'0'),(297,1,'0'),(298,1,'0'),(299,1,'0'),(300,1,'0'),(301,1,'0'),(302,1,'0'),(303,1,'0'),(304,1,'0'),(305,1,'0'),(306,1,'0'),(307,1,'0'),(308,1,'0'),(309,1,'0'),(310,1,'0'),(311,1,'0'),(312,1,'0'),(313,6,'0'),(314,1,'0'),(315,1,'0'),(316,1,'0'),(317,1,'0'),(318,1,'0'),(319,1,'0'),(320,1,'0'),(321,1,'0'),(322,1,'0'),(323,1,'0'),(324,1,'0'),(325,1,'0'),(326,1,'0'),(327,1,'0'),(328,1,'0'),(329,1,'0'),(330,1,'0'),(331,1,'0'),(332,1,'0'),(333,1,'0'),(334,1,'0'),(335,1,'0'),(336,1,'0'),(337,1,'0'),(338,1,'0'),(339,1,'0'),(340,1,'0'),(341,1,'0'),(342,1,'0'),(343,1,'0'),(344,1,'0'),(345,1,'0'),(346,1,'0'),(349,1,'0'),(350,1,'0'),(351,1,'0'),(352,1,'0'),(353,1,'0'),(354,1,'0'),(355,1,'0'),(356,1,'0'),(357,1,'0'),(358,1,'0'),(359,6,'0'),(360,1,'0'),(365,6,'0'),(366,1,'0'),(367,6,'0'),(369,1,'0'),(370,1,'0'),(371,6,'0'),(372,1,'0'),(375,6,'0'),(379,1,'0'),(380,6,'0'),(384,1,'0'),(385,6,'0'),(386,1,'0'),(387,6,'0'),(388,1,'0'),(389,1,'0'),(390,1,'0'),(391,6,'0'),(392,1,'0'),(393,1,'0'),(394,6,'0'),(395,1,'0'),(396,6,'0'),(397,1,'0'),(398,1,'0'),(399,1,'0'),(367,10,'0'),(400,1,'0'),(401,6,'0'),(402,1,'0'),(359,10,'0'),(406,1,'0'),(407,1,'0'),(401,5,'0'),(408,1,'0'),(409,6,'0'),(411,1,'0'),(271,5,'0'),(375,5,'0'),(385,5,'0'),(380,5,'0'),(412,1,'0'),(413,1,'0'),(414,1,'0'),(415,1,'0'),(121,5,'0'),(416,1,'0'),(365,5,'0'),(417,1,'0'),(371,5,'0'),(418,1,'0'),(391,5,'0'),(419,1,'0'),(420,6,'0'),(421,1,'0'),(422,6,'0'),(423,1,'0'),(422,10,'0'),(424,1,'0'),(425,1,'0'),(110,5,'0'),(426,1,'0'),(118,5,'0'),(427,1,'0'),(94,5,'0'),(112,5,'0'),(428,1,'0'),(429,1,'0'),(96,5,'0'),(87,5,'0'),(277,5,'0'),(430,1,'0'),(431,1,'0'),(432,1,'0'),(275,5,'0'),(433,1,'0'),(267,5,'0'),(266,5,'0'),(263,5,'0'),(131,5,'0'),(434,1,'0'),(435,1,'0'),(436,1,'0'),(437,1,'0'),(115,5,'0'),(109,5,'0'),(438,1,'0'),(439,1,'0'),(108,5,'0'),(85,5,'0'),(440,1,'0'),(441,1,'0'),(84,5,'0'),(76,5,'0'),(442,1,'0'),(443,1,'0'),(74,5,'0'),(444,1,'0'),(420,9,'0'),(445,1,'0'),(446,1,'0'),(447,6,'0'),(448,1,'0'),(449,6,'0'),(450,6,'0'),(447,5,'0'),(451,1,'0'),(452,1,'0'),(452,6,'0'),(453,6,'0'),(454,1,'0'),(455,1,'0'),(456,1,'0'),(457,1,'0'),(464,1,'0');

--
-- Table structure for table `vtiger_crmentityrel`
--

CREATE TABLE `vtiger_crmentityrel` (
  `crmid` int(11) NOT NULL,
  `module` varchar(100) NOT NULL,
  `relcrmid` int(11) NOT NULL,
  `relmodule` varchar(100) NOT NULL,
  KEY `crmid_idx` (`crmid`),
  KEY `relcrmid_idx` (`relcrmid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_crmentityrel`
--

INSERT INTO `vtiger_crmentityrel` VALUES (38,'HelpDesk',39,'ServiceContracts'),(53,'Contacts',54,'Emails'),(36,'HelpDesk',55,'Emails'),(38,'HelpDesk',56,'Emails'),(40,'HelpDesk',57,'Emails'),(40,'HelpDesk',58,'Emails'),(51,'HelpDesk',59,'Emails'),(53,'Contacts',60,'Emails'),(53,'Contacts',61,'Emails'),(53,'Contacts',62,'Emails'),(53,'Contacts',63,'Emails'),(53,'Contacts',64,'Emails'),(53,'Contacts',65,'Emails'),(68,'Contacts',69,'Emails'),(74,'HelpDesk',133,'Emails'),(76,'HelpDesk',134,'Emails'),(77,'HelpDesk',135,'Emails'),(78,'HelpDesk',136,'Emails'),(79,'HelpDesk',137,'Emails'),(80,'HelpDesk',138,'Emails'),(81,'HelpDesk',139,'Emails'),(82,'HelpDesk',140,'Emails'),(83,'HelpDesk',141,'Emails'),(84,'HelpDesk',142,'Emails'),(84,'HelpDesk',143,'Emails'),(85,'HelpDesk',144,'Emails'),(86,'HelpDesk',145,'Emails'),(87,'HelpDesk',146,'Emails'),(88,'HelpDesk',147,'Emails'),(89,'HelpDesk',148,'Emails'),(90,'HelpDesk',149,'Emails'),(91,'HelpDesk',150,'Emails'),(92,'HelpDesk',151,'Emails'),(93,'HelpDesk',152,'Emails'),(94,'HelpDesk',153,'Emails'),(95,'HelpDesk',154,'Emails'),(96,'HelpDesk',155,'Emails'),(97,'HelpDesk',156,'Emails'),(98,'HelpDesk',157,'Emails'),(99,'HelpDesk',158,'Emails'),(100,'HelpDesk',159,'Emails'),(101,'HelpDesk',160,'Emails'),(102,'HelpDesk',161,'Emails'),(103,'HelpDesk',162,'Emails'),(104,'HelpDesk',163,'Emails'),(105,'HelpDesk',164,'Emails'),(106,'HelpDesk',165,'Emails'),(107,'HelpDesk',166,'Emails'),(108,'HelpDesk',167,'Emails'),(109,'HelpDesk',168,'Emails'),(110,'HelpDesk',169,'Emails'),(111,'HelpDesk',170,'Emails'),(112,'HelpDesk',171,'Emails'),(113,'HelpDesk',172,'Emails'),(114,'HelpDesk',173,'Emails'),(115,'HelpDesk',174,'Emails'),(115,'HelpDesk',175,'Emails'),(116,'HelpDesk',176,'Emails'),(117,'HelpDesk',177,'Emails'),(118,'HelpDesk',178,'Emails'),(119,'HelpDesk',179,'Emails'),(120,'HelpDesk',180,'Emails'),(121,'HelpDesk',181,'Emails'),(122,'HelpDesk',182,'Emails'),(123,'HelpDesk',183,'Emails'),(124,'HelpDesk',184,'Emails'),(125,'HelpDesk',185,'Emails'),(126,'HelpDesk',186,'Emails'),(127,'HelpDesk',187,'Emails'),(128,'HelpDesk',188,'Emails'),(129,'HelpDesk',189,'Emails'),(130,'HelpDesk',190,'Emails'),(131,'HelpDesk',191,'Emails'),(131,'HelpDesk',192,'Emails'),(131,'HelpDesk',193,'Emails'),(132,'Contacts',194,'Emails'),(73,'Contacts',195,'Emails'),(132,'Contacts',197,'Emails'),(198,'Contacts',199,'Emails'),(200,'HelpDesk',201,'Emails'),(200,'HelpDesk',202,'Emails'),(198,'Contacts',203,'Emails'),(200,'HelpDesk',204,'Emails'),(200,'HelpDesk',205,'Emails'),(200,'HelpDesk',206,'Emails'),(207,'Contacts',208,'Emails'),(207,'Contacts',209,'Emails'),(207,'Contacts',210,'Emails'),(207,'Contacts',211,'Emails'),(131,'HelpDesk',212,'Emails'),(127,'HelpDesk',213,'Emails'),(128,'HelpDesk',214,'Emails'),(130,'HelpDesk',215,'Emails'),(130,'HelpDesk',216,'Emails'),(128,'HelpDesk',217,'Emails'),(218,'HelpDesk',219,'Emails'),(220,'HelpDesk',221,'Emails'),(222,'HelpDesk',224,'Emails'),(223,'HelpDesk',225,'Emails'),(222,'HelpDesk',226,'Emails'),(227,'HelpDesk',229,'Emails'),(228,'HelpDesk',230,'Emails'),(231,'HelpDesk',235,'Emails'),(232,'HelpDesk',236,'Emails'),(233,'HelpDesk',237,'Emails'),(234,'HelpDesk',238,'Emails'),(227,'HelpDesk',239,'Emails'),(231,'HelpDesk',240,'Emails'),(232,'HelpDesk',241,'Emails'),(228,'HelpDesk',242,'Emails'),(234,'HelpDesk',243,'Emails'),(244,'HelpDesk',246,'Emails'),(245,'HelpDesk',247,'Emails'),(248,'HelpDesk',249,'Emails'),(250,'HelpDesk',251,'Emails'),(252,'HelpDesk',254,'Emails'),(253,'HelpDesk',255,'Emails'),(252,'HelpDesk',258,'Emails'),(253,'HelpDesk',259,'Emails'),(256,'HelpDesk',260,'Emails'),(257,'HelpDesk',261,'Emails'),(257,'HelpDesk',262,'Emails'),(263,'HelpDesk',264,'Emails'),(263,'HelpDesk',265,'Emails'),(266,'HelpDesk',268,'Emails'),(266,'HelpDesk',269,'Emails'),(267,'HelpDesk',270,'Emails'),(271,'HelpDesk',273,'Emails'),(272,'HelpDesk',274,'Emails'),(275,'HelpDesk',276,'Emails'),(277,'HelpDesk',278,'Emails'),(87,'HelpDesk',279,'Emails'),(91,'HelpDesk',280,'Emails'),(87,'HelpDesk',281,'Emails'),(96,'HelpDesk',282,'Emails'),(93,'HelpDesk',283,'Emails'),(94,'HelpDesk',284,'Emails'),(285,'HelpDesk',286,'Emails'),(287,'HelpDesk',288,'Emails'),(287,'HelpDesk',289,'Emails'),(290,'HelpDesk',291,'Emails'),(290,'HelpDesk',292,'Emails'),(293,'HelpDesk',294,'Emails'),(295,'HelpDesk',296,'Emails'),(290,'HelpDesk',297,'Emails'),(290,'HelpDesk',298,'Emails'),(290,'HelpDesk',299,'Emails'),(290,'HelpDesk',300,'Emails'),(290,'HelpDesk',301,'Emails'),(290,'HelpDesk',302,'Emails'),(290,'HelpDesk',303,'Emails'),(290,'HelpDesk',304,'Emails'),(290,'HelpDesk',305,'Emails'),(290,'HelpDesk',306,'Emails'),(290,'HelpDesk',307,'Emails'),(290,'HelpDesk',308,'Emails'),(290,'HelpDesk',309,'Emails'),(290,'HelpDesk',310,'Emails'),(290,'HelpDesk',311,'Emails'),(290,'HelpDesk',312,'Emails'),(290,'HelpDesk',314,'Emails'),(116,'HelpDesk',316,'Emails'),(116,'HelpDesk',317,'Emails'),(130,'HelpDesk',318,'Emails'),(128,'HelpDesk',319,'Emails'),(295,'HelpDesk',320,'Emails'),(198,'Contacts',321,'Emails'),(290,'HelpDesk',322,'Emails'),(290,'HelpDesk',323,'Emails'),(290,'HelpDesk',324,'Emails'),(290,'HelpDesk',325,'Emails'),(290,'HelpDesk',326,'Emails'),(290,'HelpDesk',327,'Emails'),(290,'HelpDesk',328,'Emails'),(290,'HelpDesk',329,'Emails'),(198,'Contacts',330,'Emails'),(198,'Contacts',331,'Emails'),(290,'HelpDesk',332,'Emails'),(290,'HelpDesk',333,'Emails'),(290,'HelpDesk',334,'Emails'),(290,'HelpDesk',335,'Emails'),(290,'HelpDesk',336,'Emails'),(290,'HelpDesk',337,'Emails'),(290,'HelpDesk',338,'Emails'),(290,'HelpDesk',339,'Emails'),(290,'HelpDesk',340,'Emails'),(290,'HelpDesk',341,'Emails'),(290,'HelpDesk',342,'Emails'),(290,'HelpDesk',343,'Emails'),(344,'HelpDesk',345,'Emails'),(344,'HelpDesk',346,'Emails'),(293,'HelpDesk',349,'Emails'),(293,'HelpDesk',350,'Emails'),(112,'HelpDesk',351,'Emails'),(118,'HelpDesk',352,'Emails'),(272,'HelpDesk',353,'Emails'),(110,'HelpDesk',354,'Emails'),(121,'HelpDesk',355,'Emails'),(233,'HelpDesk',356,'Emails'),(285,'HelpDesk',357,'Emails'),(119,'HelpDesk',358,'Emails'),(359,'HelpDesk',360,'Emails'),(365,'HelpDesk',366,'Emails'),(367,'HelpDesk',369,'Emails'),(367,'HelpDesk',370,'Emails'),(371,'HelpDesk',372,'Emails'),(375,'HelpDesk',379,'Emails'),(380,'HelpDesk',384,'Emails'),(385,'HelpDesk',386,'Emails'),(272,'HelpDesk',388,'Emails'),(387,'HelpDesk',389,'Emails'),(371,'HelpDesk',390,'Emails'),(371,'HelpDesk',392,'Emails'),(391,'HelpDesk',393,'Emails'),(394,'HelpDesk',395,'Emails'),(396,'HelpDesk',397,'Emails'),(271,'HelpDesk',398,'Emails'),(394,'HelpDesk',399,'Emails'),(367,'HelpDesk',400,'Emails'),(401,'HelpDesk',402,'Emails'),(359,'HelpDesk',406,'Emails'),(367,'HelpDesk',407,'Emails'),(401,'HelpDesk',408,'Emails'),(409,'Contacts',411,'Emails'),(271,'HelpDesk',412,'Emails'),(375,'HelpDesk',413,'Emails'),(385,'HelpDesk',414,'Emails'),(380,'HelpDesk',415,'Emails'),(121,'HelpDesk',416,'Emails'),(385,'HelpDesk',417,'Emails'),(371,'HelpDesk',418,'Emails'),(391,'HelpDesk',419,'Emails'),(420,'HelpDesk',421,'Emails'),(422,'HelpDesk',423,'Emails'),(422,'HelpDesk',424,'Emails'),(422,'HelpDesk',425,'Emails'),(110,'HelpDesk',426,'Emails'),(118,'HelpDesk',427,'Emails'),(94,'HelpDesk',428,'Emails'),(112,'HelpDesk',429,'Emails'),(96,'HelpDesk',430,'Emails'),(87,'HelpDesk',431,'Emails'),(277,'HelpDesk',432,'Emails'),(275,'HelpDesk',433,'Emails'),(267,'HelpDesk',434,'Emails'),(266,'HelpDesk',435,'Emails'),(263,'HelpDesk',436,'Emails'),(131,'HelpDesk',437,'Emails'),(115,'HelpDesk',438,'Emails'),(109,'HelpDesk',439,'Emails'),(108,'HelpDesk',440,'Emails'),(85,'HelpDesk',441,'Emails'),(84,'HelpDesk',442,'Emails'),(76,'HelpDesk',443,'Emails'),(74,'HelpDesk',444,'Emails'),(420,'HelpDesk',445,'Emails'),(409,'Contacts',446,'Emails'),(447,'HelpDesk',448,'Emails'),(447,'HelpDesk',451,'Emails'),(452,'HelpDesk',454,'Emails'),(452,'HelpDesk',455,'Emails'),(452,'HelpDesk',456,'Emails'),(453,'HelpDesk',457,'Emails'),(452,'HelpDesk',464,'Emails');

--
-- Table structure for table `vtiger_crmsetup`
--

CREATE TABLE `vtiger_crmsetup` (
  `userid` int(11) DEFAULT NULL,
  `setup_status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_crmsetup`
--

INSERT INTO `vtiger_crmsetup` VALUES (1,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(13,1),(12,1);

--
-- Table structure for table `vtiger_cron_task`
--

CREATE TABLE `vtiger_cron_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `handler_file` varchar(100) DEFAULT NULL,
  `frequency` int(11) DEFAULT NULL,
  `laststart` int(10) unsigned DEFAULT NULL,
  `lastend` int(10) unsigned DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `module` varchar(100) DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `handler_file` (`handler_file`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_cron_task`
--

INSERT INTO `vtiger_cron_task` VALUES (1,'Workflow','cron/modules/com_vtiger_workflow/com_vtiger_workflow.service',900,1685457361,1685457361,1,'com_vtiger_workflow',1,'Recommended frequency for Workflow is 15 mins'),(2,'RecurringInvoice','cron/modules/SalesOrder/RecurringInvoice.service',43200,1681528442,1681528442,0,'SalesOrder',2,'Recommended frequency for RecurringInvoice is 12 hours'),(3,'SendReminder','cron/SendReminder.service',900,1685456642,1685456642,1,'Calendar',3,'Recommended frequency for SendReminder is 15 mins'),(5,'MailScanner','cron/MailScanner.service',900,1685456642,0,2,'Settings',5,'Recommended frequency for MailScanner is 15 mins'),(7,'ScheduleReports','cron/modules/Reports/ScheduleReports.service',900,1685457121,1685457121,1,'Reports',7,'Recommended frequency for ScheduleReports is 15 mins'),(9,'Scheduled Import','cron/modules/Import/ScheduledImport.service',900,NULL,NULL,0,'Import',8,'Recommended frequency for MailScanner is 15 mins');

--
-- Table structure for table `vtiger_currencies`
--

CREATE TABLE `vtiger_currencies` (
  `currencyid` int(11) NOT NULL AUTO_INCREMENT,
  `currency_name` varchar(200) DEFAULT NULL,
  `currency_code` varchar(50) DEFAULT NULL,
  `currency_symbol` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`currencyid`)
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currencies`
--

INSERT INTO `vtiger_currencies` VALUES (1,'Albania, Leke','ALL','Lek'),(2,'Argentina, Pesos','ARS','$'),(3,'Aruba, Guilders','AWG','ƒ'),(4,'Australia, Dollars','AUD','$'),(5,'Azerbaijan, New Manats','AZN','ман'),(6,'Bahamas, Dollars','BSD','$'),(7,'Bahrain, Dinar','BHD','BD'),(8,'Barbados, Dollars','BBD','$'),(9,'Belarus, Rubles','BYR','p.'),(10,'Belize, Dollars','BZD','BZ$'),(11,'Bermuda, Dollars','BMD','$'),(12,'Bolivia, Bolivianos','BOB','$b'),(13,'China, Yuan Renminbi','CNY','¥'),(14,'Convertible Marka','BAM','KM'),(15,'Botswana, Pulas','BWP','P'),(16,'Bulgaria, Leva','BGN','лв'),(17,'Brazil, Reais','BRL','R$'),(18,'Great Britain Pounds','GBP','£'),(19,'Brunei Darussalam, Dollars','BND','$'),(20,'Canada, Dollars','CAD','$'),(21,'Cayman Islands, Dollars','KYD','$'),(22,'Chile, Pesos','CLP','$'),(23,'Colombia, Pesos','COP','$'),(24,'Costa Rica, Colón','CRC','₡'),(25,'Croatia, Kuna','HRK','kn'),(26,'Cuba, Pesos','CUP','₱'),(27,'Czech Republic, Koruny','CZK','Kč'),(28,'Cyprus, Pounds','CYP','£'),(29,'Denmark, Kroner','DKK','kr'),(30,'Dominican Republic, Pesos','DOP','RD$'),(31,'East Caribbean, Dollars','XCD','$'),(32,'Egypt, Pounds','EGP','E£'),(33,'El Salvador, Colón','SVC','₡'),(34,'England, Pounds','GBP','£'),(35,'Estonia, Krooni','EEK','kr'),(36,'Euro','EUR','€'),(37,'Falkland Islands, Pounds','FKP','£'),(38,'Fiji, Dollars','FJD','$'),(39,'Ghana, Cedis','GHC','¢'),(40,'Gibraltar, Pounds','GIP','£'),(41,'Guatemala, Quetzales','GTQ','Q'),(42,'Guernsey, Pounds','GGP','£'),(43,'Guyana, Dollars','GYD','$'),(44,'Honduras, Lempiras','HNL','L'),(45,'Hong Kong, Dollars','HKD','HK$'),(46,'Hungary, Forint','HUF','Ft'),(47,'Iceland, Krona','ISK','kr'),(48,'India, Rupees','INR','₹'),(49,'Indonesia, Rupiahs','IDR','Rp'),(50,'Iran, Rials','IRR','﷼'),(51,'Isle of Man, Pounds','IMP','£'),(52,'Israel, New Shekels','ILS','₪'),(53,'Jamaica, Dollars','JMD','J$'),(54,'Japan, Yen','JPY','¥'),(55,'Jersey, Pounds','JEP','£'),(56,'Jordan, Dinar','JOD','JOD'),(57,'Kazakhstan, Tenge','KZT','〒'),(58,'Kenya, Shilling','KES','KES'),(59,'Korea (North), Won','KPW','₩'),(60,'Korea (South), Won','KRW','₩'),(61,'Kuwait, Dinar','KWD','KWD'),(62,'Kyrgyzstan, Soms','KGS','лв'),(63,'Laos, Kips','LAK','₭'),(64,'Latvia, Lati','LVL','Ls'),(65,'Lebanon, Pounds','LBP','£'),(66,'Liberia, Dollars','LRD','$'),(67,'Switzerland Francs','CHF','CHF'),(68,'Lithuania, Litai','LTL','Lt'),(69,'MADAGASCAR, Malagasy Ariary','MGA','MGA'),(70,'Macedonia, Denars','MKD','ден'),(71,'Malaysia, Ringgits','MYR','RM'),(72,'Malta, Liri','MTL','₤'),(73,'Mauritius, Rupees','MUR','₨'),(74,'Mexico, Pesos','MXN','$'),(75,'Mongolia, Tugriks','MNT','₮'),(76,'Mozambique, Meticais','MZN','MT'),(77,'Namibia, Dollars','NAD','$'),(78,'Nepal, Rupees','NPR','₨'),(79,'Netherlands Antilles, Guilders','ANG','ƒ'),(80,'New Zealand, Dollars','NZD','$'),(81,'Nicaragua, Cordobas','NIO','C$'),(82,'Nigeria, Nairas','NGN','₦'),(83,'North Korea, Won','KPW','₩'),(84,'Norway, Krone','NOK','kr'),(85,'Oman, Rials','OMR','﷼'),(86,'Pakistan, Rupees','PKR','₨'),(87,'Panama, Balboa','PAB','B/.'),(88,'Paraguay, Guarani','PYG','Gs'),(89,'Peru, Nuevos Soles','PEN','S/.'),(90,'Philippines, Pesos','PHP','Php'),(91,'Poland, Zlotych','PLN','zł'),(92,'Qatar, Rials','QAR','﷼'),(93,'Romania, New Lei','RON','lei'),(94,'Russia, Rubles','RUB','руб'),(95,'Saint Helena, Pounds','SHP','£'),(96,'Saudi Arabia, Riyals','SAR','﷼'),(97,'Serbia, Dinars','RSD','Дин.'),(98,'Seychelles, Rupees','SCR','₨'),(99,'Singapore, Dollars','SGD','$'),(100,'Solomon Islands, Dollars','SBD','$'),(101,'Somalia, Shillings','SOS','S'),(102,'South Africa, Rand','ZAR','R'),(103,'South Korea, Won','KRW','₩'),(104,'Sri Lanka, Rupees','LKR','₨'),(105,'Sweden, Kronor','SEK','kr'),(106,'Switzerland, Francs','CHF','CHF'),(107,'Suriname, Dollars','SRD','$'),(108,'Syria, Pounds','SYP','£'),(109,'Taiwan, New Dollars','TWD','NT$'),(110,'Thailand, Baht','THB','฿'),(111,'Trinidad and Tobago, Dollars','TTD','TT$'),(112,'Turkey, New Lira','TRY','YTL'),(113,'Turkey, Liras','TRL','₤'),(114,'Tuvalu, Dollars','TVD','$'),(115,'Ukraine, Hryvnia','UAH','₴'),(116,'United Arab Emirates, Dirham','AED','AED'),(117,'United Kingdom, Pounds','GBP','£'),(118,'United Republic of Tanzania, Shilling','TZS','TZS'),(119,'USA, Dollars','USD','$'),(120,'Uruguay, Pesos','UYU','$U'),(121,'Uzbekistan, Sums','UZS','лв'),(122,'Venezuela, Bolivares Fuertes','VEF','Bs'),(123,'Vietnam, Dong','VND','₫'),(124,'Zambia, Kwacha','ZMK','ZMK'),(125,'Yemen, Rials','YER','﷼'),(126,'Zimbabwe Dollars','ZWD','Z$'),(127,'Malawi, Kwacha','MWK','MK'),(128,'Tunisian, Dinar','TD','TD'),(129,'Moroccan, Dirham','MAD','DH'),(130,'Iraqi Dinar','IQD','ID'),(131,'Maldivian Ruffiya','MVR','MVR'),(132,'Ugandan Shilling','UGX','Sh'),(133,'Sudanese Pound','SDG','£'),(134,'CFA Franc BCEAO','XOF','CFA'),(135,'CFA Franc BEAC','XAF','CFA'),(136,'Haiti, Gourde','HTG','G'),(137,'Libya, Dinar','LYD','LYD'),(138,'CFP Franc','XPF','F');

--
-- Table structure for table `vtiger_currencies_seq`
--

CREATE TABLE `vtiger_currencies_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currencies_seq`
--

INSERT INTO `vtiger_currencies_seq` VALUES (138);

--
-- Table structure for table `vtiger_currency`
--

CREATE TABLE `vtiger_currency` (
  `currencyid` int(11) NOT NULL AUTO_INCREMENT,
  `currency` varchar(200) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currencyid`),
  UNIQUE KEY `currency_currency_idx` (`currency`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency`
--


--
-- Table structure for table `vtiger_currency_decimal_separator`
--

CREATE TABLE `vtiger_currency_decimal_separator` (
  `currency_decimal_separatorid` int(11) NOT NULL AUTO_INCREMENT,
  `currency_decimal_separator` varchar(2) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currency_decimal_separatorid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_decimal_separator`
--

INSERT INTO `vtiger_currency_decimal_separator` VALUES (1,'.',0,1),(2,',',1,1),(3,'\'',2,1),(4,' ',3,1),(5,'$',4,1);

--
-- Table structure for table `vtiger_currency_decimal_separator_seq`
--

CREATE TABLE `vtiger_currency_decimal_separator_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_decimal_separator_seq`
--

INSERT INTO `vtiger_currency_decimal_separator_seq` VALUES (5);

--
-- Table structure for table `vtiger_currency_grouping_pattern`
--

CREATE TABLE `vtiger_currency_grouping_pattern` (
  `currency_grouping_patternid` int(11) NOT NULL AUTO_INCREMENT,
  `currency_grouping_pattern` varchar(200) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currency_grouping_patternid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_grouping_pattern`
--

INSERT INTO `vtiger_currency_grouping_pattern` VALUES (1,'123,456,789',0,1),(2,'123456789',1,1),(3,'123456,789',2,1),(4,'12,34,56,789',3,1);

--
-- Table structure for table `vtiger_currency_grouping_pattern_seq`
--

CREATE TABLE `vtiger_currency_grouping_pattern_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_grouping_pattern_seq`
--

INSERT INTO `vtiger_currency_grouping_pattern_seq` VALUES (4);

--
-- Table structure for table `vtiger_currency_grouping_separator`
--

CREATE TABLE `vtiger_currency_grouping_separator` (
  `currency_grouping_separatorid` int(11) NOT NULL AUTO_INCREMENT,
  `currency_grouping_separator` varchar(2) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currency_grouping_separatorid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_grouping_separator`
--

INSERT INTO `vtiger_currency_grouping_separator` VALUES (1,',',0,1),(2,'.',1,1),(3,'\'',2,1),(4,' ',3,1),(5,'$',4,1);

--
-- Table structure for table `vtiger_currency_grouping_separator_seq`
--

CREATE TABLE `vtiger_currency_grouping_separator_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_grouping_separator_seq`
--

INSERT INTO `vtiger_currency_grouping_separator_seq` VALUES (5);

--
-- Table structure for table `vtiger_currency_info`
--

CREATE TABLE `vtiger_currency_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `currency_name` varchar(100) DEFAULT NULL,
  `currency_code` varchar(100) DEFAULT NULL,
  `currency_symbol` varchar(30) DEFAULT NULL,
  `conversion_rate` decimal(12,5) DEFAULT NULL,
  `currency_status` varchar(25) DEFAULT NULL,
  `defaultid` varchar(10) NOT NULL DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_info`
--

INSERT INTO `vtiger_currency_info` VALUES (1,'USA, Dollars','USD','$',1.00000,'Active','-11',0);

--
-- Table structure for table `vtiger_currency_info_seq`
--

CREATE TABLE `vtiger_currency_info_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_info_seq`
--

INSERT INTO `vtiger_currency_info_seq` VALUES (1);

--
-- Table structure for table `vtiger_currency_symbol_placement`
--

CREATE TABLE `vtiger_currency_symbol_placement` (
  `currency_symbol_placementid` int(11) NOT NULL AUTO_INCREMENT,
  `currency_symbol_placement` varchar(30) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currency_symbol_placementid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_symbol_placement`
--

INSERT INTO `vtiger_currency_symbol_placement` VALUES (1,'$1.0',0,1),(2,'1.0$',1,1);

--
-- Table structure for table `vtiger_currency_symbol_placement_seq`
--

CREATE TABLE `vtiger_currency_symbol_placement_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_symbol_placement_seq`
--

INSERT INTO `vtiger_currency_symbol_placement_seq` VALUES (2);

--
-- Table structure for table `vtiger_customaction`
--

CREATE TABLE `vtiger_customaction` (
  `cvid` int(11) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `module` varchar(50) NOT NULL,
  `content` text DEFAULT NULL,
  KEY `customaction_cvid_idx` (`cvid`),
  CONSTRAINT `fk_1_vtiger_customaction` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customaction`
--


--
-- Table structure for table `vtiger_customerdetails`
--

CREATE TABLE `vtiger_customerdetails` (
  `customerid` int(11) NOT NULL,
  `portal` varchar(3) DEFAULT NULL,
  `support_start_date` date DEFAULT NULL,
  `support_end_date` date DEFAULT NULL,
  PRIMARY KEY (`customerid`),
  CONSTRAINT `fk_1_vtiger_customerdetails` FOREIGN KEY (`customerid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customerdetails`
--

INSERT INTO `vtiger_customerdetails` VALUES (53,'0',NULL,NULL),(66,'0',NULL,NULL),(67,'0',NULL,NULL),(68,'0',NULL,NULL),(70,'0',NULL,NULL),(71,'0',NULL,NULL),(72,'0',NULL,NULL),(73,'1','2023-03-05','2023-03-31'),(132,'0',NULL,NULL),(198,'1','2023-04-16','2024-04-17'),(207,'1','2022-10-18','2025-03-03'),(409,'1','2023-05-01','2029-05-01');

--
-- Table structure for table `vtiger_customerportal_fields`
--

CREATE TABLE `vtiger_customerportal_fields` (
  `tabid` int(11) NOT NULL,
  `fieldinfo` text DEFAULT NULL,
  `records_visible` int(11) DEFAULT NULL,
  PRIMARY KEY (`tabid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_customerportal_fields`
--

INSERT INTO `vtiger_customerportal_fields` VALUES (4,'{\"lastname\":1,\"assigned_user_id\":1}',1),(6,'{\"accountname\":1,\"assigned_user_id\":1}',1),(8,'{\"notes_title\":1,\"assigned_user_id\":1,\"filename\":0}',1),(13,'{\"ticket_title\":1,\"assigned_user_id\":0,\"ticketpriorities\":1,\"ticketstatus\":1,\"description\":1,\"product_id\":0,\"ticketseverities\":1,\"ticketcategories\":1,\"cr_orgname_portaltext\":1,\"parent_id\":0}',1),(14,'{\"assigned_user_id\":1,\"productname\":1}',1),(15,'{\"faqstatus\":1,\"question\":1,\"faq_answer\":1}',1),(20,'{\"subject\":1,\"quotestage\":1,\"account_id\":1,\"assigned_user_id\":1,\"bill_street\":1,\"ship_street\":1}',1),(23,'{\"bill_street\":1,\"ship_street\":1,\"subject\":1,\"account_id\":1,\"assigned_user_id\":1}',1),(35,'{\"subject\":1,\"assigned_user_id\":1}',NULL),(36,'{\"servicename\":1}',1),(38,'{\"product\":1,\"assigned_user_id\":1,\"serialnumber\":1,\"datesold\":1,\"dateinservice\":1,\"assetstatus\":1,\"assetname\":1,\"account\":1}',1),(43,'{\"projectmilestonename\":1,\"projectid\":1,\"assigned_user_id\":1}',1),(44,'{\"projecttaskname\":1,\"projectid\":1,\"assigned_user_id\":1}',1),(45,'{\"projectname\":1,\"assigned_user_id\":1}',1);

--
-- Table structure for table `vtiger_customerportal_prefs`
--

CREATE TABLE `vtiger_customerportal_prefs` (
  `tabid` int(11) NOT NULL,
  `prefkey` varchar(100) NOT NULL,
  `prefvalue` int(11) DEFAULT NULL,
  PRIMARY KEY (`tabid`,`prefkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customerportal_prefs`
--

INSERT INTO `vtiger_customerportal_prefs` VALUES (0,'defaultassignee',6),(0,'userid',6),(4,'showrelatedinfo',1),(6,'showrelatedinfo',1),(8,'showrelatedinfo',1),(13,'showrelatedinfo',1),(14,'showrelatedinfo',1),(15,'showrelatedinfo',1),(20,'showrelatedinfo',1),(23,'showrelatedinfo',1),(36,'showrelatedinfo',1),(38,'showrelatedinfo',1),(43,'showrelatedinfo',1),(44,'showrelatedinfo',1),(45,'showrelatedinfo',1);

--
-- Table structure for table `vtiger_customerportal_relatedmoduleinfo`
--

CREATE TABLE `vtiger_customerportal_relatedmoduleinfo` (
  `tabid` int(11) NOT NULL,
  `relatedmodules` text DEFAULT NULL,
  PRIMARY KEY (`tabid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customerportal_relatedmoduleinfo`
--

INSERT INTO `vtiger_customerportal_relatedmoduleinfo` VALUES (8,'[{\"name\":\"History\",\"value\":1}]'),(13,'[{\"name\":\"History\",\"value\":1},{\"name\":\"ModComments\",\"value\":1},{\"name\":\"Documents\",\"value\":1}]'),(14,'[{\"name\":\"History\",\"value\":1}]'),(20,'[{\"name\":\"History\",\"value\":1}]'),(23,'[{\"name\":\"History\",\"value\":1}]'),(35,'[{\"name\":\"History\",\"value\":1}]'),(36,'[{\"name\":\"History\",\"value\":1}]'),(38,'[{\"name\":\"History\",\"value\":1}]'),(43,'[{\"name\":\"History\",\"value\":1}]'),(44,'[{\"name\":\"History\",\"value\":1},{\"name\":\"ModComments\",\"value\":1}]'),(45,'[{\"name\":\"History\",\"value\":1},{\"name\":\"ModComments\",\"value\":1},{\"name\":\"ProjectTask\",\"value\":1},{\"name\":\"ProjectMilestone\",\"value\":1},{\"name\":\"Documents\",\"value\":1}]');

--
-- Table structure for table `vtiger_customerportal_settings`
--

CREATE TABLE `vtiger_customerportal_settings` (
  `id` int(11) DEFAULT NULL,
  `url` varchar(250) DEFAULT NULL,
  `default_assignee` int(11) DEFAULT NULL,
  `support_notification` int(11) DEFAULT NULL,
  `announcement` text DEFAULT NULL,
  `shortcuts` text DEFAULT NULL,
  `widgets` text DEFAULT NULL,
  `charts` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customerportal_settings`
--

INSERT INTO `vtiger_customerportal_settings` VALUES (1,NULL,6,0,'You are now on the Blue Technology Support Ticket System','{\"Documents\":{\"LBL_ADD_DOCUMENT\":1},\"HelpDesk\":{\"LBL_CREATE_TICKET\":1,\"LBL_OPEN_TICKETS\":1}}','{\"widgets\":{\"HelpDesk\":\"1\",\"Documents\":\"1\",\"Faq\":\"1\"}}','{\"charts\":{\"OpenTicketsByPriority\":1,\"TicketsClosureTimeByPriority\":1}}');

--
-- Table structure for table `vtiger_customerportal_tabs`
--

CREATE TABLE `vtiger_customerportal_tabs` (
  `tabid` int(11) NOT NULL,
  `visible` int(11) DEFAULT 1,
  `sequence` int(11) DEFAULT NULL,
  `createrecord` tinyint(1) NOT NULL DEFAULT 0,
  `editrecord` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`tabid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customerportal_tabs`
--

INSERT INTO `vtiger_customerportal_tabs` VALUES (4,0,9,0,1),(6,0,10,0,1),(8,0,5,1,0),(13,1,2,1,1),(14,1,6,0,0),(15,1,4,0,0),(20,1,5,0,0),(23,0,3,0,0),(35,0,6,0,0),(36,1,7,0,0),(38,1,11,0,1),(43,1,12,0,0),(44,1,13,0,0),(45,1,14,0,0);

--
-- Table structure for table `vtiger_customview`
--

CREATE TABLE `vtiger_customview` (
  `cvid` int(11) NOT NULL,
  `viewname` varchar(100) NOT NULL,
  `setdefault` int(11) DEFAULT 0,
  `setmetrics` int(11) DEFAULT 0,
  `entitytype` varchar(25) NOT NULL,
  `status` int(11) DEFAULT 1,
  `userid` int(11) DEFAULT 1,
  PRIMARY KEY (`cvid`),
  KEY `customview_entitytype_idx` (`entitytype`),
  CONSTRAINT `fk_1_vtiger_customview` FOREIGN KEY (`entitytype`) REFERENCES `vtiger_tab` (`name`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customview`
--

INSERT INTO `vtiger_customview` VALUES (1,'All',1,0,'Leads',0,6),(2,'Hot Leads',0,1,'Leads',3,6),(3,'This Month Leads',0,0,'Leads',3,6),(4,'All',1,0,'Accounts',0,6),(7,'All',1,0,'Contacts',0,6),(10,'All',1,0,'Potentials',0,6),(11,'Potentials Won',0,1,'Potentials',3,6),(12,'Prospecting',0,0,'Potentials',3,6),(13,'All',1,0,'HelpDesk',0,6),(16,'All',1,0,'Quotes',0,6),(17,'Open Quotes',0,1,'Quotes',3,6),(18,'Rejected Quotes',0,0,'Quotes',3,6),(19,'All',1,0,'Calendar',0,6),(20,'All',1,0,'Emails',0,6),(21,'All',1,0,'Invoice',0,6),(22,'All',1,0,'Documents',0,6),(23,'All',1,0,'PriceBooks',0,6),(24,'All',1,0,'Products',0,6),(25,'All',1,0,'PurchaseOrder',0,6),(26,'All',1,0,'SalesOrder',0,6),(27,'All',1,0,'Vendors',0,6),(28,'All',1,0,'Faq',0,6),(29,'All',1,0,'Campaigns',0,6),(30,'All',1,0,'Webmails',0,6),(31,'Drafted FAQ',0,0,'Faq',3,6),(32,'Published FAQ',0,0,'Faq',3,6),(33,'Open Purchase Orders',0,0,'PurchaseOrder',3,6),(34,'Received Purchase Orders',0,0,'PurchaseOrder',3,6),(35,'Open Invoices',0,0,'Invoice',3,6),(36,'Paid Invoices',0,0,'Invoice',3,6),(37,'Pending Sales Orders',0,0,'SalesOrder',3,6),(59,'All',1,0,'ServiceContracts',0,6),(60,'All',1,0,'Services',0,6),(61,'All',1,0,'PBXManager',0,6),(62,'All',0,0,'ModComments',0,6),(63,'All',1,0,'ProjectMilestone',0,6),(64,'All',1,0,'ProjectTask',0,6),(65,'All',1,0,'Project',0,6),(66,'All',1,0,'Assets',0,6),(67,'All',0,0,'SMSNotifier',0,6),(71,'Today tickets',0,0,'HelpDesk',3,1),(75,'Service Calls 04-21-2023 to 05-20-2023',0,0,'HelpDesk',1,6),(76,'Seach Organization Name for \'F\'',0,0,'HelpDesk',1,6),(77,'Shared Ticket List',0,0,'HelpDesk',1,6);

--
-- Table structure for table `vtiger_customview_seq`
--

CREATE TABLE `vtiger_customview_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customview_seq`
--

INSERT INTO `vtiger_customview_seq` VALUES (77);

--
-- Table structure for table `vtiger_cv2group`
--

CREATE TABLE `vtiger_cv2group` (
  `cvid` int(11) NOT NULL,
  `groupid` int(11) NOT NULL,
  KEY `vtiger_cv2group_ibfk_1` (`cvid`),
  KEY `vtiger_groups_ibfk_1` (`groupid`),
  CONSTRAINT `vtiger_customview_ibfk_2` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE,
  CONSTRAINT `vtiger_groups_ibfk_1` FOREIGN KEY (`groupid`) REFERENCES `vtiger_groups` (`groupid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_cv2group`
--


--
-- Table structure for table `vtiger_cv2role`
--

CREATE TABLE `vtiger_cv2role` (
  `cvid` int(25) NOT NULL,
  `roleid` varchar(255) NOT NULL,
  KEY `vtiger_cv2role_ibfk_1` (`cvid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_cv2role`
--


--
-- Table structure for table `vtiger_cv2rs`
--

CREATE TABLE `vtiger_cv2rs` (
  `cvid` int(25) NOT NULL,
  `rsid` varchar(255) NOT NULL,
  KEY `vtiger_cv2role_ibfk_1` (`cvid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_cv2rs`
--


--
-- Table structure for table `vtiger_cv2users`
--

CREATE TABLE `vtiger_cv2users` (
  `cvid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  KEY `vtiger_cv2users_ibfk_1` (`cvid`),
  KEY `vtiger_users_ibfk_1` (`userid`),
  CONSTRAINT `vtiger_customview_ibfk_1` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE,
  CONSTRAINT `vtiger_users_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_cv2users`
--

INSERT INTO `vtiger_cv2users` VALUES (77,13);

--
-- Table structure for table `vtiger_cvadvfilter`
--

CREATE TABLE `vtiger_cvadvfilter` (
  `cvid` int(11) NOT NULL,
  `columnindex` int(11) NOT NULL,
  `columnname` varchar(250) DEFAULT '',
  `comparator` varchar(20) DEFAULT NULL,
  `value` varchar(512) DEFAULT NULL,
  `groupid` int(11) DEFAULT 1,
  `column_condition` varchar(255) DEFAULT 'and',
  PRIMARY KEY (`cvid`,`columnindex`),
  KEY `cvadvfilter_cvid_idx` (`cvid`),
  CONSTRAINT `fk_1_vtiger_cvadvfilter` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_cvadvfilter`
--

INSERT INTO `vtiger_cvadvfilter` VALUES (2,0,'vtiger_leaddetails:leadstatus:leadstatus:Leads_Lead_Status:V','e','Hot',1,'and'),(11,0,'vtiger_potential:sales_stage:sales_stage:Potentials_Sales_Stage:V','e','Closed Won',1,'and'),(12,0,'vtiger_potential:sales_stage:sales_stage:Potentials_Sales_Stage:V','e','Prospecting',1,'and'),(17,0,'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V','n','Accepted',1,'and'),(17,1,'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V','n','Rejected',1,'and'),(18,0,'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V','e','Rejected',1,'and'),(31,0,'vtiger_faq:status:faqstatus:Faq_Status:V','e','Draft',1,'and'),(32,0,'vtiger_faq:status:faqstatus:Faq_Status:V','e','Published',1,'and'),(33,0,'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V','e','Created, Approved, Delivered',1,'and'),(34,0,'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V','e','Received Shipment',1,'and'),(35,0,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V','e','Created, Approved, Sent',1,'and'),(36,0,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V','e','Paid',1,'and'),(37,0,'vtiger_salesorder:sostatus:sostatus:SalesOrder_Status:V','e','Created, Approved',1,'and'),(71,0,'vtiger_crmentity:createdtime:createdtime:HelpDesk_Created_Time:DT','today','2023-04-14 07:00:00',1,''),(75,0,'vtiger_ticketcf:cf_869:cf_869:HelpDesk_Request_Date:D','bw','2023-04-21,2023-05-20',1,''),(76,0,'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_To:V','s','F',1,'');

--
-- Table structure for table `vtiger_cvadvfilter_grouping`
--

CREATE TABLE `vtiger_cvadvfilter_grouping` (
  `groupid` int(11) NOT NULL,
  `cvid` int(11) NOT NULL,
  `group_condition` varchar(255) DEFAULT NULL,
  `condition_expression` text DEFAULT NULL,
  PRIMARY KEY (`groupid`,`cvid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_cvadvfilter_grouping`
--

INSERT INTO `vtiger_cvadvfilter_grouping` VALUES (1,2,'',''),(1,11,'',''),(1,12,'',''),(1,17,'',''),(1,18,'',''),(1,31,'',''),(1,32,'',''),(1,33,'',''),(1,34,'',''),(1,35,'',''),(1,36,'',''),(1,37,'',''),(1,71,'and',' 0 '),(1,75,'and',' 0 '),(1,76,'and',' 0 ');

--
-- Table structure for table `vtiger_cvcolumnlist`
--

CREATE TABLE `vtiger_cvcolumnlist` (
  `cvid` int(11) NOT NULL,
  `columnindex` int(11) NOT NULL,
  `columnname` varchar(250) DEFAULT '',
  PRIMARY KEY (`cvid`,`columnindex`),
  KEY `cvcolumnlist_columnindex_idx` (`columnindex`),
  KEY `cvcolumnlist_cvid_idx` (`cvid`),
  CONSTRAINT `fk_1_vtiger_cvcolumnlist` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_cvcolumnlist`
--

INSERT INTO `vtiger_cvcolumnlist` VALUES (1,1,'vtiger_leaddetails:firstname:firstname:Leads_First_Name:V'),(1,2,'vtiger_leaddetails:lastname:lastname:Leads_Last_Name:V'),(1,3,'vtiger_leaddetails:company:company:Leads_Company:V'),(1,4,'vtiger_leadaddress:phone:phone:Leads_Phone:V'),(1,5,'vtiger_leadsubdetails:website:website:Leads_Website:V'),(1,6,'vtiger_leaddetails:email:email:Leads_Email:V'),(1,7,'vtiger_crmentity:smownerid:assigned_user_id:Leads_Assigned_To:V'),(2,0,'vtiger_leaddetails:firstname:firstname:Leads_First_Name:V'),(2,1,'vtiger_leaddetails:lastname:lastname:Leads_Last_Name:V'),(2,2,'vtiger_leaddetails:company:company:Leads_Company:V'),(2,3,'vtiger_leaddetails:leadsource:leadsource:Leads_Lead_Source:V'),(2,4,'vtiger_leadsubdetails:website:website:Leads_Website:V'),(2,5,'vtiger_leaddetails:email:email:Leads_Email:E'),(3,0,'vtiger_leaddetails:firstname:firstname:Leads_First_Name:V'),(3,1,'vtiger_leaddetails:lastname:lastname:Leads_Last_Name:V'),(3,2,'vtiger_leaddetails:company:company:Leads_Company:V'),(3,3,'vtiger_leaddetails:leadsource:leadsource:Leads_Lead_Source:V'),(3,4,'vtiger_leadsubdetails:website:website:Leads_Website:V'),(3,5,'vtiger_leaddetails:email:email:Leads_Email:E'),(4,0,'vtiger_account:accountname:(account_id ; (Accounts) accountname):Accounts_Member_Of-Organization_Name:V'),(4,1,'vtiger_account:accountname:accountname:Accounts_Account_Name:V'),(4,2,'vtiger_account:phone:phone:Accounts_Phone:V'),(4,3,'vtiger_accountscf:cf_857:cf_857:Accounts_Billing_eMail:E'),(4,4,'vtiger_account:siccode:siccode:Accounts_SIC_Code:V'),(4,5,'vtiger_account:website:website:Accounts_Website:V'),(4,6,'vtiger_account:industry:industry:Accounts_industry:V'),(7,0,'vtiger_contactdetails:firstname:firstname:Contacts_First_Name:V'),(7,1,'vtiger_contactdetails:lastname:lastname:Contacts_Last_Name:V'),(7,2,'vtiger_contactdetails:title:title:Contacts_Title:V'),(7,3,'vtiger_contactdetails:accountid:account_id:Contacts_Account_Name:V'),(7,4,'vtiger_contactdetails:email:email:Contacts_Email:V'),(7,5,'vtiger_contactdetails:phone:phone:Contacts_Office_Phone:V'),(7,6,'vtiger_crmentity:smownerid:assigned_user_id:Contacts_Assigned_To:V'),(7,7,'vtiger_customerdetails:portal:portal:Contacts_Portal_User:C'),(10,1,'vtiger_potential:potentialname:potentialname:Potentials_Potential_Name:V'),(10,2,'vtiger_potential:related_to:related_to:Potentials_Related_To:V'),(10,3,'vtiger_potential:sales_stage:sales_stage:Potentials_Sales_Stage:V'),(10,4,'vtiger_potential:leadsource:leadsource:Potentials_Lead_Source:V'),(10,5,'vtiger_potential:closingdate:closingdate:Potentials_Expected_Close_Date:D'),(10,6,'vtiger_potential:amount:amount:Potentials_Amount:N'),(10,7,'vtiger_crmentity:smownerid:assigned_user_id:Potentials_Assigned_To:V'),(10,8,'vtiger_potential:contact_id:contact_id:Potentials_Contact_Name:V'),(11,0,'vtiger_potential:potentialname:potentialname:Potentials_Potential_Name:V'),(11,1,'vtiger_potential:related_to:related_to:Potentials_Related_To:V'),(11,2,'vtiger_potential:amount:amount:Potentials_Amount:N'),(11,3,'vtiger_potential:closingdate:closingdate:Potentials_Expected_Close_Date:D'),(11,4,'vtiger_crmentity:smownerid:assigned_user_id:Potentials_Assigned_To:V'),(11,5,'vtiger_potential:contact_id:contact_id:Potentials_Contact_Name:V'),(12,0,'vtiger_potential:potentialname:potentialname:Potentials_Potential_Name:V'),(12,1,'vtiger_potential:related_to:related_to:Potentials_Related_To:V'),(12,2,'vtiger_potential:amount:amount:Potentials_Amount:N'),(12,3,'vtiger_potential:leadsource:leadsource:Potentials_Lead_Source:V'),(12,4,'vtiger_potential:closingdate:closingdate:Potentials_Expected_Close_Date:D'),(12,5,'vtiger_crmentity:smownerid:assigned_user_id:Potentials_Assigned_To:V'),(12,6,'vtiger_potential:contact_id:contact_id:Potentials_Contact_Name:V'),(13,0,'vtiger_troubletickets:title:ticket_title:HelpDesk_Title:V'),(13,1,'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_To:V'),(13,2,'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V'),(13,3,'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'),(13,4,'vtiger_ticketcf:cf_855:cf_855:HelpDesk_Dynamix_Ticket_Number:I'),(13,5,'vtiger_troubletickets:ticket_no:ticket_no:HelpDesk_Ticket_No:V'),(13,6,'vtiger_ticketcf:cf_869:cf_869:HelpDesk_Request_Date:D'),(13,7,'vtiger_ticketcf:cf_871:cf_871:HelpDesk_Request_Time:T'),(13,8,'vtiger_ticketcf:cf_859:cf_859:HelpDesk_Check-in_Date:D'),(13,9,'vtiger_ticketcf:cf_861:cf_861:HelpDesk_Check_in_time:T'),(13,10,'vtiger_ticketcf:cf_863:cf_863:HelpDesk_Check_out_date:D'),(13,11,'vtiger_ticketcf:cf_865:cf_865:HelpDesk_Check_out_time:T'),(13,12,'vtiger_ticketcf:cf_885:cf_885:HelpDesk_Hours_checkin_to_checkout:V'),(13,13,'vtiger_ticketcf:cf_883:cf_883:HelpDesk_Hours_Request_to_Checkin:V'),(13,14,'vtiger_ticketcf:cf_895:cf_895:HelpDesk_Driving_Hours:NN'),(16,1,'vtiger_quotes:subject:subject:Quotes_Subject:V'),(16,2,'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V'),(16,3,'vtiger_quotes:potentialid:potential_id:Quotes_Potential_Name:V'),(16,4,'vtiger_quotes:accountid:account_id:Quotes_Account_Name:V'),(16,5,'vtiger_quotes:total:hdnGrandTotal:Quotes_Total:N'),(16,6,'vtiger_crmentity:smownerid:assigned_user_id:Quotes_Assigned_To:V'),(17,0,'vtiger_quotes:subject:subject:Quotes_Subject:V'),(17,1,'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V'),(17,2,'vtiger_quotes:potentialid:potential_id:Quotes_Potential_Name:I'),(17,3,'vtiger_quotes:accountid:account_id:Quotes_Account_Name:I'),(17,4,'vtiger_quotes:validtill:validtill:Quotes_Valid_Till:D'),(17,5,'vtiger_crmentity:smownerid:assigned_user_id:Quotes_Assigned_To:V'),(18,0,'vtiger_quotes:subject:subject:Quotes_Subject:V'),(18,1,'vtiger_quotes:potentialid:potential_id:Quotes_Potential_Name:I'),(18,2,'vtiger_quotes:accountid:account_id:Quotes_Account_Name:I'),(18,3,'vtiger_quotes:validtill:validtill:Quotes_Valid_Till:D'),(18,4,'vtiger_crmentity:smownerid:assigned_user_id:Quotes_Assigned_To:V'),(19,0,'vtiger_activity:status:taskstatus:Calendar_Status:V'),(19,1,'vtiger_activity:activitytype:activitytype:Calendar_Activity_Type:V'),(19,2,'vtiger_activity:subject:subject:Calendar_Subject:V'),(19,3,'vtiger_seactivityrel:crmid:parent_id:Calendar_Related_To:V'),(19,4,'vtiger_activity:date_start:date_start:Calendar_Start_Date_&_Time:DT'),(19,5,'vtiger_activity:due_date:due_date:Calendar_Due_Date:D'),(19,6,'vtiger_crmentity:smownerid:assigned_user_id:Calendar_Assigned_To:V'),(20,0,'vtiger_activity:subject:subject:Emails_Subject:V'),(20,1,'vtiger_emaildetails:to_email:saved_toid:Emails_To:V'),(20,2,'vtiger_activity:date_start:date_start:Emails_Date_&_Time_Sent:DT'),(21,1,'vtiger_invoice:subject:subject:Invoice_Subject:V'),(21,2,'vtiger_invoice:salesorderid:salesorder_id:Invoice_Sales_Order:V'),(21,3,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V'),(21,4,'vtiger_invoice:total:hdnGrandTotal:Invoice_Total:N'),(21,5,'vtiger_crmentity:smownerid:assigned_user_id:Invoice_Assigned_To:V'),(22,1,'vtiger_notes:title:notes_title:Documents_Title:V'),(22,2,'vtiger_notes:filename:filename:Documents_File_Name:V'),(22,3,'vtiger_crmentity:modifiedtime:modifiedtime:Documents_Modified_Time:DT'),(22,4,'vtiger_crmentity:smownerid:assigned_user_id:Documents_Assigned_To:V'),(23,1,'vtiger_pricebook:bookname:bookname:PriceBooks_Price_Book_Name:V'),(23,2,'vtiger_pricebook:active:active:PriceBooks_Active:C'),(23,3,'vtiger_pricebook:currency_id:currency_id:PriceBooks_Currency:V'),(24,1,'vtiger_products:productname:productname:Products_Product_Name:V'),(24,2,'vtiger_products:productcode:productcode:Products_Part_Number:V'),(24,3,'vtiger_products:commissionrate:commissionrate:Products_Commission_Rate:N'),(24,4,'vtiger_products:qtyinstock:qtyinstock:Products_Qty_In_Stock:NN'),(24,5,'vtiger_products:qty_per_unit:qty_per_unit:Products_Qty/Unit:N'),(24,6,'vtiger_products:unit_price:unit_price:Products_Unit_Price:N'),(25,1,'vtiger_purchaseorder:subject:subject:PurchaseOrder_Subject:V'),(25,2,'vtiger_purchaseorder:vendorid:vendor_id:PurchaseOrder_Vendor_Name:V'),(25,3,'vtiger_purchaseorder:tracking_no:tracking_no:PurchaseOrder_Tracking_Number:V'),(25,4,'vtiger_purchaseorder:total:hdnGrandTotal:PurchaseOrder_Total:N'),(25,5,'vtiger_crmentity:smownerid:assigned_user_id:PurchaseOrder_Assigned_To:V'),(26,1,'vtiger_salesorder:subject:subject:SalesOrder_Subject:V'),(26,2,'vtiger_salesorder:accountid:account_id:SalesOrder_Account_Name:V'),(26,3,'vtiger_salesorder:quoteid:quote_id:SalesOrder_Quote_Name:V'),(26,4,'vtiger_salesorder:total:hdnGrandTotal:SalesOrder_Total:N'),(26,5,'vtiger_crmentity:smownerid:assigned_user_id:SalesOrder_Assigned_To:V'),(27,1,'vtiger_vendor:vendorname:vendorname:Vendors_Vendor_Name:V'),(27,2,'vtiger_vendor:phone:phone:Vendors_Phone:V'),(27,3,'vtiger_vendor:email:email:Vendors_Email:V'),(27,4,'vtiger_vendor:category:category:Vendors_Category:V'),(27,5,'vtiger_crmentity:smownerid:assigned_user_id:Vendors_Assigned_To:V'),(28,1,'vtiger_faq:question:question:Faq_Question:V'),(28,2,'vtiger_faq:category:faqcategories:Faq_Category:V'),(28,3,'vtiger_faq:product_id:product_id:Faq_Product_Name:V'),(28,4,'vtiger_crmentity:createdtime:createdtime:Faq_Created_Time:DT'),(28,5,'vtiger_crmentity:modifiedtime:modifiedtime:Faq_Modified_Time:DT'),(29,1,'vtiger_campaign:campaignname:campaignname:Campaigns_Campaign_Name:V'),(29,2,'vtiger_campaign:campaigntype:campaigntype:Campaigns_Campaign_Type:V'),(29,3,'vtiger_campaign:campaignstatus:campaignstatus:Campaigns_Campaign_Status:V'),(29,4,'vtiger_campaign:expectedrevenue:expectedrevenue:Campaigns_Expected_Revenue:N'),(29,5,'vtiger_campaign:closingdate:closingdate:Campaigns_Expected_Close_Date:D'),(29,6,'vtiger_crmentity:smownerid:assigned_user_id:Campaigns_Assigned_To:V'),(30,0,'subject:subject:subject:Subject:V'),(30,1,'from:fromname:fromname:From:N'),(30,2,'to:tpname:toname:To:N'),(30,3,'body:body:body:Body:V'),(31,0,'vtiger_faq:question:question:Faq_Question:V'),(31,1,'vtiger_faq:status:faqstatus:Faq_Status:V'),(31,2,'vtiger_faq:product_id:product_id:Faq_Product_Name:I'),(31,3,'vtiger_faq:category:faqcategories:Faq_Category:V'),(31,4,'vtiger_crmentity:createdtime:createdtime:Faq_Created_Time:DT'),(32,0,'vtiger_faq:question:question:Faq_Question:V'),(32,1,'vtiger_faq:answer:faq_answer:Faq_Answer:V'),(32,2,'vtiger_faq:status:faqstatus:Faq_Status:V'),(32,3,'vtiger_faq:product_id:product_id:Faq_Product_Name:I'),(32,4,'vtiger_faq:category:faqcategories:Faq_Category:V'),(32,5,'vtiger_crmentity:createdtime:createdtime:Faq_Created_Time:DT'),(33,0,'vtiger_purchaseorder:subject:subject:PurchaseOrder_Subject:V'),(33,1,'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V'),(33,2,'vtiger_purchaseorder:vendorid:vendor_id:PurchaseOrder_Vendor_Name:I'),(33,3,'vtiger_crmentity:smownerid:assigned_user_id:PurchaseOrder_Assigned_To:V'),(33,4,'vtiger_purchaseorder:duedate:duedate:PurchaseOrder_Due_Date:V'),(34,0,'vtiger_purchaseorder:subject:subject:PurchaseOrder_Subject:V'),(34,1,'vtiger_purchaseorder:vendorid:vendor_id:PurchaseOrder_Vendor_Name:I'),(34,2,'vtiger_crmentity:smownerid:assigned_user_id:PurchaseOrder_Assigned_To:V'),(34,3,'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V'),(34,4,'vtiger_purchaseorder:carrier:carrier:PurchaseOrder_Carrier:V'),(34,5,'vtiger_poshipads:ship_street:ship_street:PurchaseOrder_Shipping_Address:V'),(35,0,'vtiger_invoice:invoice_no:invoice_no:Invoice_Invoice_No:V'),(35,1,'vtiger_invoice:subject:subject:Invoice_Subject:V'),(35,2,'vtiger_invoice:accountid:account_id:Invoice_Account_Name:I'),(35,3,'vtiger_invoice:salesorderid:salesorder_id:Invoice_Sales_Order:I'),(35,4,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V'),(35,5,'vtiger_crmentity:smownerid:assigned_user_id:Invoice_Assigned_To:V'),(35,6,'vtiger_crmentity:createdtime:createdtime:Invoice_Created_Time:DT'),(36,0,'vtiger_invoice:invoice_no:invoice_no:Invoice_Invoice_No:V'),(36,1,'vtiger_invoice:subject:subject:Invoice_Subject:V'),(36,2,'vtiger_invoice:accountid:account_id:Invoice_Account_Name:I'),(36,3,'vtiger_invoice:salesorderid:salesorder_id:Invoice_Sales_Order:I'),(36,4,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V'),(36,5,'vtiger_invoiceshipads:ship_street:ship_street:Invoice_Shipping_Address:V'),(36,6,'vtiger_crmentity:smownerid:assigned_user_id:Invoice_Assigned_To:V'),(37,0,'vtiger_salesorder:subject:subject:SalesOrder_Subject:V'),(37,1,'vtiger_salesorder:accountid:account_id:SalesOrder_Account_Name:I'),(37,2,'vtiger_salesorder:sostatus:sostatus:SalesOrder_Status:V'),(37,3,'vtiger_crmentity:smownerid:assigned_user_id:SalesOrder_Assigned_To:V'),(37,4,'vtiger_soshipads:ship_street:ship_street:SalesOrder_Shipping_Address:V'),(37,5,'vtiger_salesorder:carrier:carrier:SalesOrder_Carrier:V'),(59,0,'vtiger_servicecontracts:contract_no:contract_no:ServiceContracts_Contract_No:V'),(59,1,'vtiger_servicecontracts:subject:subject:ServiceContracts_Subject:V'),(59,2,'vtiger_servicecontracts:sc_related_to:sc_related_to:ServiceContracts_Related_to:V'),(59,3,'vtiger_crmentity:smownerid:assigned_user_id:ServiceContracts_Assigned_To:V'),(59,4,'vtiger_servicecontracts:start_date:start_date:ServiceContracts_Start_Date:D'),(59,5,'vtiger_servicecontracts:due_date:due_date:ServiceContracts_Due_date:D'),(59,7,'vtiger_servicecontracts:progress:progress:ServiceContracts_Progress:N'),(59,8,'vtiger_servicecontracts:contract_status:contract_status:ServiceContracts_Status:V'),(60,0,'vtiger_service:service_no:service_no:Services_Service_No:V'),(60,1,'vtiger_service:servicename:servicename:Services_Service_Name:V'),(60,2,'vtiger_service:service_usageunit:service_usageunit:Services_Usage_Unit:V'),(60,3,'vtiger_service:unit_price:unit_price:Services_Price:N'),(60,4,'vtiger_service:qty_per_unit:qty_per_unit:Services_No_of_Units:N'),(60,5,'vtiger_service:servicecategory:servicecategory:Services_Service_Category:V'),(60,6,'vtiger_crmentity:smownerid:assigned_user_id:Services_Owner:I'),(61,0,'vtiger_pbxmanager:callstatus:callstatus:PBXManager_Call_Status:V'),(61,1,'vtiger_pbxmanager:customernumber:customernumber:PBXManager_Customer_Number:V'),(61,2,'vtiger_pbxmanager:customer:customer:PBXManager_Customer:V'),(61,3,'vtiger_pbxmanager:user:user:PBXManager_User:V'),(61,4,'vtiger_pbxmanager:recordingurl:recordingurl:PBXManager_Recording_URL:V'),(61,5,'vtiger_pbxmanager:totalduration:totalduration:PBXManager_Total_Duration:I'),(61,6,'vtiger_pbxmanager:starttime:starttime:PBXManager_Start_Time:DT'),(62,0,'vtiger_modcomments:commentcontent:commentcontent:ModComments_Comment:V'),(62,1,'vtiger_modcomments:related_to:related_to:ModComments_Related_To:V'),(62,2,'vtiger_crmentity:modifiedtime:modifiedtime:ModComments_Modified_Time:DT'),(62,3,'vtiger_crmentity:smownerid:assigned_user_id:ModComments_Assigned_To:V'),(63,0,'vtiger_projectmilestone:projectmilestonename:projectmilestonename:ProjectMilestone_Project_Milestone_Name:V'),(63,1,'vtiger_projectmilestone:projectmilestonedate:projectmilestonedate:ProjectMilestone_Milestone_Date:D'),(63,3,'vtiger_crmentity:description:description:ProjectMilestone_Description:V'),(63,4,'vtiger_crmentity:createdtime:createdtime:ProjectMilestone_Created_Time:DT'),(63,5,'vtiger_crmentity:modifiedtime:modifiedtime:ProjectMilestone_Modified_Time:DT'),(64,2,'vtiger_projecttask:projecttaskname:projecttaskname:ProjectTask_Project_Task_Name:V'),(64,3,'vtiger_projecttask:projectid:projectid:ProjectTask_Related_to:V'),(64,4,'vtiger_projecttask:projecttaskpriority:projecttaskpriority:ProjectTask_Priority:V'),(64,5,'vtiger_projecttask:projecttaskprogress:projecttaskprogress:ProjectTask_Progress:V'),(64,6,'vtiger_projecttask:projecttaskhours:projecttaskhours:ProjectTask_Worked_Hours:V'),(64,7,'vtiger_projecttask:startdate:startdate:ProjectTask_Start_Date:D'),(64,8,'vtiger_projecttask:enddate:enddate:ProjectTask_End_Date:D'),(64,9,'vtiger_crmentity:smownerid:assigned_user_id:ProjectTask_Assigned_To:V'),(65,0,'vtiger_project:projectname:projectname:Project_Project_Name:V'),(65,1,'vtiger_project:linktoaccountscontacts:linktoaccountscontacts:Project_Related_to:V'),(65,2,'vtiger_project:startdate:startdate:Project_Start_Date:D'),(65,3,'vtiger_project:targetenddate:targetenddate:Project_Target_End_Date:D'),(65,4,'vtiger_project:actualenddate:actualenddate:Project_Actual_End_Date:D'),(65,5,'vtiger_project:targetbudget:targetbudget:Project_Target_Budget:V'),(65,6,'vtiger_project:progress:progress:Project_Progress:V'),(65,7,'vtiger_project:projectstatus:projectstatus:Project_Status:V'),(65,8,'vtiger_crmentity:smownerid:assigned_user_id:Project_Assigned_To:V'),(66,0,'vtiger_assets:asset_no:asset_no:Assets_Asset_No:V'),(66,1,'vtiger_assets:assetname:assetname:Assets_Asset_Name:V'),(66,2,'vtiger_assets:account:account:Assets_Customer_Name:V'),(66,3,'vtiger_assets:product:product:Assets_Product_Name:V'),(67,0,'vtiger_smsnotifier:message:message:SMSNotifier_message:V'),(67,2,'vtiger_crmentity:smownerid:assigned_user_id:SMSNotifier_Assigned_To:V'),(67,3,'vtiger_crmentity:createdtime:createdtime:SMSNotifier_Created_Time:DT'),(67,4,'vtiger_crmentity:modifiedtime:modifiedtime:SMSNotifier_Modified_Time:DT'),(71,0,'vtiger_troubletickets:title:ticket_title:HelpDesk_Title:V'),(71,1,'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_To:V'),(71,2,'vtiger_troubletickets:contact_id:contact_id:HelpDesk_Contact_Name:V'),(71,3,'vtiger_troubletickets:ticket_no:ticket_no:HelpDesk_Ticket_No:V'),(71,4,'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V'),(71,5,'vtiger_troubletickets:priority:ticketpriorities:HelpDesk_Priority:V'),(71,6,'vtiger_ticketcf:cf_855:cf_855:HelpDesk_Dynamix_Ticket_Number:I'),(71,7,'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'),(75,0,'vtiger_troubletickets:title:ticket_title:HelpDesk_Title:V'),(75,1,'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_To:V'),(75,2,'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V'),(75,3,'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'),(75,4,'vtiger_ticketcf:cf_855:cf_855:HelpDesk_Dynamix_Ticket_Number:I'),(75,5,'vtiger_troubletickets:ticket_no:ticket_no:HelpDesk_Ticket_No:V'),(75,6,'vtiger_ticketcf:cf_869:cf_869:HelpDesk_Request_Date:D'),(75,7,'vtiger_ticketcf:cf_871:cf_871:HelpDesk_Request_Time:T'),(75,8,'vtiger_ticketcf:cf_859:cf_859:HelpDesk_Check-in_Date:D'),(75,9,'vtiger_ticketcf:cf_861:cf_861:HelpDesk_Check_in_time:T'),(75,10,'vtiger_ticketcf:cf_863:cf_863:HelpDesk_Check_out_date:D'),(75,11,'vtiger_ticketcf:cf_865:cf_865:HelpDesk_Check_out_time:T'),(75,12,'vtiger_ticketcf:cf_885:cf_885:HelpDesk_Hours_checkin_to_checkout:V'),(75,13,'vtiger_ticketcf:cf_883:cf_883:HelpDesk_Hours_Request_to_Checkin:V'),(75,14,'vtiger_crmentity:description:description:HelpDesk_Description:V'),(75,15,'vtiger_troubletickets:priority:ticketpriorities:HelpDesk_Priority:V'),(75,16,'vtiger_troubletickets:severity:ticketseverities:HelpDesk_Severity:V'),(75,17,'vtiger_ticketcf:cf_877:cf_877:HelpDesk_Ticket_eMail_Date:D'),(75,18,'vtiger_ticketcf:cf_879:cf_879:HelpDesk_Ticket_eMail_Time:T'),(75,19,'vtiger_ticketcf:cf_873:cf_873:HelpDesk_Dispatch_Date:D'),(75,20,'vtiger_ticketcf:cf_875:cf_875:HelpDesk_Dispatch_Time:T'),(76,0,'vtiger_troubletickets:title:ticket_title:HelpDesk_Title:V'),(76,1,'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_To:V'),(76,2,'vtiger_troubletickets:contact_id:contact_id:HelpDesk_Contact_Name:V'),(76,3,'vtiger_troubletickets:ticket_no:ticket_no:HelpDesk_Ticket_No:V'),(76,4,'vtiger_crmentity:description:description:HelpDesk_Description:V'),(76,5,'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'),(76,6,'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V'),(76,7,'vtiger_troubletickets:priority:ticketpriorities:HelpDesk_Priority:V'),(76,8,'vtiger_troubletickets:severity:ticketseverities:HelpDesk_Severity:V'),(76,9,'vtiger_ticketcf:cf_855:cf_855:HelpDesk_Dynamix_Ticket_Number:I'),(76,10,'vtiger_ticketcf:cf_877:cf_877:HelpDesk_Ticket_eMail_Date:D'),(76,11,'vtiger_ticketcf:cf_879:cf_879:HelpDesk_Ticket_eMail_Time:T'),(76,12,'vtiger_ticketcf:cf_873:cf_873:HelpDesk_Dispatch_Date:D'),(76,13,'vtiger_ticketcf:cf_875:cf_875:HelpDesk_Dispatch_Time:T'),(76,14,'vtiger_ticketcf:cf_869:cf_869:HelpDesk_Request_Date:D'),(77,0,'vtiger_troubletickets:title:ticket_title:HelpDesk_Title:V'),(77,1,'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_To:V'),(77,2,'vtiger_troubletickets:contact_id:contact_id:HelpDesk_Contact_Name:V'),(77,3,'vtiger_troubletickets:ticket_no:ticket_no:HelpDesk_Ticket_No:V'),(77,4,'vtiger_crmentity:description:description:HelpDesk_Description:V'),(77,5,'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'),(77,6,'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V'),(77,7,'vtiger_troubletickets:severity:ticketseverities:HelpDesk_Severity:V'),(77,8,'vtiger_ticketcf:cf_855:cf_855:HelpDesk_Dynamix_Ticket_Number:I'),(77,9,'vtiger_ticketcf:cf_877:cf_877:HelpDesk_Ticket_eMail_Date:D'),(77,10,'vtiger_ticketcf:cf_879:cf_879:HelpDesk_Ticket_eMail_Time:T'),(77,11,'vtiger_ticketcf:cf_873:cf_873:HelpDesk_Dispatch_Date:D'),(77,12,'vtiger_ticketcf:cf_875:cf_875:HelpDesk_Dispatch_Time:T'),(77,13,'vtiger_ticketcf:cf_869:cf_869:HelpDesk_Request_Date:D');

--
-- Table structure for table `vtiger_cvstdfilter`
--

CREATE TABLE `vtiger_cvstdfilter` (
  `cvid` int(11) NOT NULL,
  `columnname` varchar(250) DEFAULT '',
  `stdfilter` varchar(250) DEFAULT '',
  `startdate` date DEFAULT NULL,
  `enddate` date DEFAULT NULL,
  KEY `cvstdfilter_cvid_idx` (`cvid`),
  CONSTRAINT `fk_1_vtiger_cvstdfilter` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_cvstdfilter`
--

INSERT INTO `vtiger_cvstdfilter` VALUES (3,'vtiger_crmentity:modifiedtime:modifiedtime:Leads_Modified_Time','thismonth','2005-06-01','2005-06-30');

--
-- Table structure for table `vtiger_dashboard_tabs`
--

CREATE TABLE `vtiger_dashboard_tabs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tabname` varchar(50) DEFAULT NULL,
  `isdefault` int(11) DEFAULT 0,
  `sequence` int(11) DEFAULT 2,
  `appname` varchar(20) DEFAULT NULL,
  `modulename` varchar(50) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tabname` (`tabname`,`userid`),
  KEY `vtiger_dashboard_tabs_ibfk_1` (`userid`),
  CONSTRAINT `vtiger_dashboard_tabs_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_dashboard_tabs`
--

INSERT INTO `vtiger_dashboard_tabs` VALUES (2,'My Dashboard',1,1,'','',1),(8,'My Dashboard',1,1,'','',5),(10,'My Dashboard',1,1,'','',6),(16,'My Dashboard',1,1,'','',8),(26,'My Dashboard',1,1,'','',9),(27,'My Dashboard',1,1,'','',10),(35,'My Dashboard',1,1,'','',11),(56,'Customer 01',0,2,NULL,NULL,6),(75,'My Dashboard',1,1,'','',12),(76,'My Dashboard',1,1,'','',13);

--
-- Table structure for table `vtiger_datashare_grp2grp`
--

CREATE TABLE `vtiger_datashare_grp2grp` (
  `shareid` int(11) NOT NULL,
  `share_groupid` int(11) DEFAULT NULL,
  `to_groupid` int(11) DEFAULT NULL,
  `permission` int(11) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `datashare_grp2grp_share_groupid_idx` (`share_groupid`),
  KEY `datashare_grp2grp_to_groupid_idx` (`to_groupid`),
  CONSTRAINT `fk_3_vtiger_datashare_grp2grp` FOREIGN KEY (`to_groupid`) REFERENCES `vtiger_groups` (`groupid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_datashare_grp2grp`
--


--
