Meeting Title: ABC EOD Check In Date: 2025-12-18 Meeting participants: Casie Aviles, Mustafa Raja
WEBVTT
1 00:00:06.750 ⇒ 00:00:08.060 Mustafa Raja: Hey, Gacy.
2 00:00:12.330 ⇒ 00:00:13.290 Casie Aviles: Hey, hey.
3 00:00:16.320 ⇒ 00:00:17.109 Casie Aviles: How are you?
4 00:00:17.630 ⇒ 00:00:18.230 Casie Aviles: Yeah.
5 00:00:18.440 ⇒ 00:00:22.409 Casie Aviles: Doing good. I sent over the question already, by the way.
6 00:00:22.830 ⇒ 00:00:24.259 Casie Aviles: Within assignments, but…
7 00:00:24.260 ⇒ 00:00:29.849 Mustafa Raja: Also, one more thing, there’s this ticket that I sent you earlier also.
8 00:00:32.360 ⇒ 00:00:40.750 Mustafa Raja: I was wondering if you could, if you could work on it together, and then if you could walk me through how we would, you know, add these into database.
9 00:00:41.870 ⇒ 00:00:48.539 Casie Aviles: Oh, okay, add… oh, yeah, the ad technicians to zip code database.
10 00:00:48.540 ⇒ 00:01:02.780 Mustafa Raja: Yeah, I think for the lawns… for the lawn, it’s only, like, we need to label the existing services, and for mechanical, and for home improvement, we need to add technicians, you know?
11 00:01:04.340 ⇒ 00:01:08.669 Casie Aviles: Okay. Yeah, for the rest of the departments, yeah.
12 00:01:12.570 ⇒ 00:01:13.530 Mustafa Raja: Yeah.
13 00:01:15.360 ⇒ 00:01:20.979 Mustafa Raja: I mean, lawn was confusing for me, but I guess mechanical did make a little bit of sense.
14 00:01:21.540 ⇒ 00:01:31.369 Mustafa Raja: I guess I could, before moving forward, I could record a loom, share with you my strategy, so you could confirm if I’m thinking the right way or not.
15 00:01:32.520 ⇒ 00:01:33.730 Casie Aviles: Okay, okay.
16 00:01:37.110 ⇒ 00:01:37.950 Mustafa Raja: Solution.
17 00:01:38.150 ⇒ 00:01:45.419 Mustafa Raja: And also, do we only need to add the particular tab, or do we need to add all of the tabs?
18 00:01:47.550 ⇒ 00:01:49.320 Casie Aviles: Oh, I think that…
19 00:01:49.320 ⇒ 00:01:49.680 Mustafa Raja: industry.
20 00:01:49.680 ⇒ 00:01:59.139 Casie Aviles: I haven’t really checked the other departments, but I think it’s going to depend, because… For, for lawn.
21 00:01:59.740 ⇒ 00:02:10.350 Casie Aviles: they have, like, different formats for everything, so I… we had to kind of, you know, figure out what to add, what not to add, right? So…
22 00:02:10.350 ⇒ 00:02:16.070 Mustafa Raja: Yeah, lawn was messed up, I did see that, and I was like, what is… what’s going on here?
23 00:02:16.230 ⇒ 00:02:17.630 Casie Aviles: That’s true, because…
24 00:02:17.920 ⇒ 00:02:26.409 Mustafa Raja: But, but good thing is we… by the looks of the ticket, it’s look… it looks like that we just need to label commercial
25 00:02:27.800 ⇒ 00:02:30.340 Mustafa Raja: You know, commercial and residential.
26 00:02:30.640 ⇒ 00:02:31.190 Mustafa Raja: I agree.
27 00:02:31.190 ⇒ 00:02:32.839 Casie Aviles: Commercial and residential, yeah.
28 00:02:32.840 ⇒ 00:02:42.840 Mustafa Raja: Okay. It looks like we just need to label the services or something, but for the home improvement and for the mechanical, we need to add the technicians.
29 00:02:44.150 ⇒ 00:02:49.059 Mustafa Raja: And those sheets… those sheets are fairly simpler than the lawn.
30 00:02:49.060 ⇒ 00:03:01.300 Casie Aviles: Okay, that’s good. I think for the… I think I might have done something already for, like, labeling in… for the lawn, at least, but I’ll double check, because I… I think… yeah, I believe I added something.
31 00:03:01.810 ⇒ 00:03:02.940 Mustafa Raja: Okay.
32 00:03:03.620 ⇒ 00:03:06.709 Mustafa Raja: Last week. Just move with mechanical for now.
33 00:03:06.950 ⇒ 00:03:09.919 Mustafa Raja: And then we can meet… we can meet… meet later.
34 00:03:11.050 ⇒ 00:03:12.190 Casie Aviles: Sure, sure.
35 00:03:13.360 ⇒ 00:03:14.130 Mustafa Raja: on that.
36 00:03:15.350 ⇒ 00:03:16.410 Casie Aviles: Okay.
37 00:03:17.190 ⇒ 00:03:19.589 Casie Aviles: Will anyone else join?
38 00:03:19.900 ⇒ 00:03:20.660 Mustafa Raja: Sully?
39 00:03:21.470 ⇒ 00:03:26.139 Casie Aviles: So, I was just asking if anyone else typically joins the EODs.
40 00:03:26.140 ⇒ 00:03:36.300 Mustafa Raja: We just added this, I think, yesterday… or the day before yesterday. Let me check my calendar. I think Utam does join these.
41 00:03:36.810 ⇒ 00:03:40.699 Casie Aviles: Alright, okay, let’s just wait, I guess. If he doesn’t gone, then I think…
42 00:03:40.910 ⇒ 00:03:49.150 Mustafa Raja: Yeah, we just need to then, do an update in Slack channel, because he needs to send an email by end of day.
43 00:03:49.430 ⇒ 00:03:52.330 Casie Aviles: Yeah, yeah, definitely. Just a draft will do, okay.
44 00:03:52.800 ⇒ 00:03:53.600 Mustafa Raja: Yeah.
45 00:03:53.770 ⇒ 00:03:58.389 Mustafa Raja: So I also then went ahead and, updated the system prompt.
46 00:03:58.450 ⇒ 00:04:14.409 Mustafa Raja: to ensure… to… and that system prompt just labels, the specific services. It’s… it’s been referencing the wrong way, and I’ll just tell it, referencing… reference these services by this name, you know?
47 00:04:15.490 ⇒ 00:04:15.860 Casie Aviles: Okay.
48 00:04:15.860 ⇒ 00:04:28.709 Mustafa Raja: This is until we, you know, couple… couple the service names, across services and service areas table, and then we could just fetch it from services table and push it, you know.
49 00:04:32.320 ⇒ 00:04:33.609 Mustafa Raja: Does this make sense?
50 00:04:35.070 ⇒ 00:04:38.639 Casie Aviles: Yeah, oh, sorry, I was just checking the message from.
51 00:04:39.120 ⇒ 00:04:39.830 Mustafa Raja: Oh.
52 00:04:40.200 ⇒ 00:04:41.310 Mustafa Raja: There’s a message?
53 00:04:42.030 ⇒ 00:04:44.759 Casie Aviles: Yeah, yeah, on client ABC Home.
54 00:04:47.120 ⇒ 00:04:49.940 Mustafa Raja: Yeah, he just needs… needs an update, then.
55 00:04:51.690 ⇒ 00:04:55.970 Casie Aviles: Okay, good. I guess let’s just merge the stuff we did.
56 00:04:57.640 ⇒ 00:05:01.390 Mustafa Raja: Yeah, so from my side, it’s going to be…
57 00:05:01.390 ⇒ 00:05:05.130 Casie Aviles: Wait, I’ll go generate the summary.
58 00:05:05.540 ⇒ 00:05:10.399 Casie Aviles: Let me share my screen so we can generate it together, so I don’t miss anything.
59 00:05:11.440 ⇒ 00:05:12.250 Mustafa Raja: Okay.
60 00:05:13.390 ⇒ 00:05:15.240 Casie Aviles: Cool. Can you see my screen now?
61 00:05:15.890 ⇒ 00:05:16.840 Mustafa Raja: Yeah.
62 00:05:19.020 ⇒ 00:05:21.819 Casie Aviles: Let’s see… where am I? Okay, here.
63 00:05:22.550 ⇒ 00:05:24.100 Casie Aviles: Alright, so…
64 00:05:24.290 ⇒ 00:05:29.709 Casie Aviles: Okay, I’ll just type out what you will tell me, I guess. Does that work? Does that work?
65 00:05:30.140 ⇒ 00:05:39.690 Mustafa Raja: Yeah, yeah. For my work, whatever I have done, I have not pushed it yet. So, right after this meeting, I’m going to push it, okay? So…
66 00:05:42.420 ⇒ 00:05:43.040 Casie Aviles: So…
67 00:05:43.510 ⇒ 00:05:46.269 Mustafa Raja: The first thing would be,
68 00:05:46.830 ⇒ 00:05:53.329 Mustafa Raja: A lot of the, assignments that were going wrong,
69 00:05:53.480 ⇒ 00:05:59.110 Mustafa Raja: I noticed that, some of these we don’t have… we do not service the area.
70 00:05:59.260 ⇒ 00:06:00.110 Mustafa Raja: You know?
71 00:06:07.360 ⇒ 00:06:09.519 Casie Aviles: Yeah, yeah, sorry.
72 00:06:09.670 ⇒ 00:06:10.929 Mustafa Raja: Yeah, yeah, it’s okay, it’s okay.
73 00:06:18.450 ⇒ 00:06:22.150 Casie Aviles: Okay, right, okay, so assignments, right?
74 00:06:23.090 ⇒ 00:06:41.139 Mustafa Raja: Yeah, so assignments, and then… so what I did is I updated the tool, so that if it runs a query on assignments, and if it gets nothing back, it should also look into service areas, if we do service that particular area, or not for that service, right?
75 00:06:48.990 ⇒ 00:06:57.569 Mustafa Raja: And then if, and then it’ll tell us if we do service it, but we do not have assignments, or if we don’t service it at all.
76 00:06:59.400 ⇒ 00:07:02.439 Mustafa Raja: That’s a point for the herbal one, you know?
77 00:07:04.330 ⇒ 00:07:09.980 Casie Aviles: Okay, oh, what’s the… what’s… how do I say it? Hmm…
78 00:07:10.500 ⇒ 00:07:13.609 Mustafa Raja: Yeah, this is… this is a little confusing, you know.
79 00:07:13.830 ⇒ 00:07:16.590 Casie Aviles: It is, yeah, I’m not sure how to word it,
80 00:07:19.400 ⇒ 00:07:23.819 Casie Aviles: Did we, did we, like, did we… Implement that already?
81 00:07:23.820 ⇒ 00:07:27.529 Mustafa Raja: No, it’s on… it’s on my… it’s locally on my side.
82 00:07:27.990 ⇒ 00:07:32.090 Mustafa Raja: I could run it, I could run a few queries for you to see that.
83 00:07:34.300 ⇒ 00:07:38.659 Casie Aviles: Okay, updated query DB tool, if no assignment, check service areas if you service or not.
84 00:07:39.310 ⇒ 00:07:40.260 Casie Aviles: And then…
85 00:07:40.810 ⇒ 00:07:52.539 Mustafa Raja: And then the outcome of this is… the outcome of this is we would know if the assignments are missing some data, or if we don’t service that area at all.
86 00:08:00.200 ⇒ 00:08:01.390 Mustafa Raja: Yeah.
87 00:08:01.870 ⇒ 00:08:19.880 Mustafa Raja: And then for the system prompt, things I worked on, were two things. So, some of the times when it was asked to, reference multiple services, or look into multiple services, it would use AND operator.
88 00:08:23.960 ⇒ 00:08:24.710 Casie Aviles: Okay.
89 00:08:25.360 ⇒ 00:08:30.079 Mustafa Raja: And what that did… this isn’t for service areas, though.
90 00:08:30.960 ⇒ 00:08:31.680 Casie Aviles: Oh, sorry, sorry.
91 00:08:31.680 ⇒ 00:08:41.499 Mustafa Raja: This is just for services, yeah. And what that did, if any of one… if any one of the services would return null, the whole result is going to be null.
92 00:08:44.210 ⇒ 00:08:45.960 Casie Aviles: Oh, okay.
93 00:08:48.990 ⇒ 00:08:52.389 Casie Aviles: the whole… The whole what? Sorry?
94 00:08:52.390 ⇒ 00:08:53.990 Mustafa Raja: The whole result, you know?
95 00:08:53.990 ⇒ 00:08:54.780 Casie Aviles: result.
96 00:08:55.030 ⇒ 00:08:57.750 Mustafa Raja: Yeah, so none of the rows would be returned, you know?
97 00:09:01.070 ⇒ 00:09:12.410 Mustafa Raja: So, what I did is, in the system prompt, I told it that it should not do that. Rather, if it’s looking into multiple services, join them with over in between.
98 00:09:13.300 ⇒ 00:09:17.080 Mustafa Raja: Reduce over operator, other than… And…
99 00:09:22.370 ⇒ 00:09:29.119 Mustafa Raja: And then, some of the… some of the services it was referencing…
100 00:09:29.220 ⇒ 00:09:32.899 Mustafa Raja: was wrong, like, it was, like…
101 00:09:32.900 ⇒ 00:09:50.530 Mustafa Raja: Csrs would ask if we do gutter cleaning in this zip, right? So, it would search for gutter cleaning in the service names when we don’t have that at all, but if it just searched with, I like gutter, that’s just going to work, you know?
102 00:09:52.130 ⇒ 00:09:54.890 Casie Aviles: Oh, yeah, yeah, that is also a similar thing I did.
103 00:09:55.030 ⇒ 00:10:03.260 Casie Aviles: Yeah, I did it here in the prod, because I didn’t have it set up.
104 00:10:04.880 ⇒ 00:10:08.459 Casie Aviles: I don’t know, I think it was just faster for me this way, but…
105 00:10:09.520 ⇒ 00:10:15.600 Casie Aviles: I added this line… these lines here, and they’re working fine for now.
106 00:10:15.600 ⇒ 00:10:21.370 Mustafa Raja: Okay, I did this in my local, and I did not push it yet, so I will not push it yet.
107 00:10:22.340 ⇒ 00:10:27.670 Casie Aviles: No, no, I think… you handled something that I did not handle, so I think…
108 00:10:27.670 ⇒ 00:10:30.319 Mustafa Raja: I’ll add that part, and not this part.
109 00:10:31.090 ⇒ 00:10:36.960 Casie Aviles: Okay, okay, yeah. Up to you. You just check the diff, I guess? Up to you, yeah, yeah.
110 00:10:38.440 ⇒ 00:10:43.390 Casie Aviles: If, you know, if there’s anything that is redundant, that should be fine, I think.
111 00:10:43.390 ⇒ 00:10:45.680 Mustafa Raja: Yeah, so this is it for me today.
112 00:10:46.010 ⇒ 00:10:50.830 Mustafa Raja: And then my next thing would be to add mechanical technicians.
113 00:10:52.800 ⇒ 00:10:55.759 Casie Aviles: Okay, yeah, that’s something we can both work on, don’t.
114 00:10:56.850 ⇒ 00:10:57.500 Mustafa Raja: Yeah, dude.
115 00:10:57.500 ⇒ 00:10:57.969 Casie Aviles: I’ll help you.
116 00:10:57.970 ⇒ 00:11:05.269 Mustafa Raja: We could handle each department, then you could handle, home improvement, I could take mechanical, or we could…
117 00:11:05.460 ⇒ 00:11:08.310 Mustafa Raja: Yeah, let’s figure that out later then, right?
118 00:11:08.760 ⇒ 00:11:10.399 Casie Aviles: Perf… yeah, perfectly.
119 00:11:11.920 ⇒ 00:11:16.200 Casie Aviles: Add technicians… 2 dB.
120 00:11:16.600 ⇒ 00:11:19.570 Casie Aviles: That’s Home Improved… Man.
121 00:11:19.570 ⇒ 00:11:21.309 Mustafa Raja: Home improvement of mechanical, yeah, yeah.
122 00:11:24.500 ⇒ 00:11:27.190 Casie Aviles: Okay… technicians.
123 00:11:28.730 ⇒ 00:11:32.790 Casie Aviles: We only have… Pass and learn.
124 00:11:41.400 ⇒ 00:11:45.729 Casie Aviles: So, basically, what I worked on… Where are we?
125 00:11:49.600 ⇒ 00:11:52.840 Casie Aviles: Right, or… oh… Yeah, this one.
126 00:11:54.100 ⇒ 00:11:57.499 Casie Aviles: Yeah, a lot of the stuff that I worked on is really just…
127 00:11:58.000 ⇒ 00:12:01.149 Casie Aviles: updating the old… yeah, I’ll add that up.
128 00:12:01.510 ⇒ 00:12:15.329 Casie Aviles: Updated… updated records, and… directly in the DB… And then what else?
129 00:12:17.480 ⇒ 00:12:20.109 Casie Aviles: I also updated the prompt.
130 00:12:21.510 ⇒ 00:12:24.800 Casie Aviles: 4… Handling.
131 00:12:27.340 ⇒ 00:12:28.510 Casie Aviles: queries.
132 00:12:30.720 ⇒ 00:12:33.710 Casie Aviles: Service-related queries.
133 00:12:34.640 ⇒ 00:12:35.430 Casie Aviles: That…
134 00:12:39.200 ⇒ 00:12:42.040 Casie Aviles: Yeah, yeah, I think… That’s.
135 00:12:42.110 ⇒ 00:12:43.600 Mustafa Raja: Okay, so next.
136 00:12:44.400 ⇒ 00:12:45.809 Casie Aviles: Okay. It’s this one.
137 00:12:46.080 ⇒ 00:12:48.860 Mustafa Raja: Okay, foo, oof. Okay. Okay.
138 00:12:51.270 ⇒ 00:12:54.580 Mustafa Raja: Yeah, let’s add this, and then once you’re done,
139 00:12:54.890 ⇒ 00:12:59.270 Mustafa Raja: Let’s add a few to… a few for the next thing to do.
140 00:13:03.180 ⇒ 00:13:12.899 Mustafa Raja: Okay, so next, we should also look into, you know, some sort of sync for service areas, because
141 00:13:14.170 ⇒ 00:13:19.159 Mustafa Raja: We did see that we… we do not have any way, or not… not even a form.
142 00:13:20.320 ⇒ 00:13:21.400 Mustafa Raja: For that…
143 00:13:44.150 ⇒ 00:13:45.389 Casie Aviles: Okay, that’s solid.
144 00:13:45.390 ⇒ 00:13:48.370 Mustafa Raja: No, no, one more thing, one more thing.
145 00:13:49.390 ⇒ 00:13:50.100 Casie Aviles: Sure, sure.
146 00:13:50.280 ⇒ 00:13:55.499 Mustafa Raja: Yeah, this is what Sam and I discussed in a huddle.
147 00:13:55.710 ⇒ 00:14:08.720 Mustafa Raja: Just a few moments ago. So, what we discussed is we, we should also, you know, couple the two columns, service names in services and service areas.
148 00:14:09.220 ⇒ 00:14:24.189 Mustafa Raja: So this would… what this would allow us to do is just, pull… pull the service names from Superbase and push it to the prompt, right? So we get rid of all of these, weird service name issues.
149 00:14:34.890 ⇒ 00:14:38.400 Casie Aviles: Okay. Yeah, that’s what we were talking about, right, earlier, was that.
150 00:14:38.400 ⇒ 00:14:43.649 Mustafa Raja: Yeah, yeah, yeah. We talked about it, and then I talked about… I brought it up with Sam.
151 00:14:44.330 ⇒ 00:14:46.100 Mustafa Raja: I was on a huddle with him, so…
152 00:14:46.330 ⇒ 00:14:52.940 Casie Aviles: Yeah, good, good. Yeah, I just wasn’t sure how to do it. I was… it might break something, but yeah.
153 00:14:53.580 ⇒ 00:14:54.129 Casie Aviles: It’s a good…
154 00:14:54.130 ⇒ 00:14:58.310 Mustafa Raja: Yeah, but… Yeah, but now we could, you know, discuss it.
155 00:14:58.580 ⇒ 00:15:01.810 Mustafa Raja: With the team, and maybe come up with a plan for that, right?
156 00:15:02.440 ⇒ 00:15:04.040 Casie Aviles: Yes, evening.
157 00:15:05.830 ⇒ 00:15:06.970 Casie Aviles: Updates…
158 00:15:09.260 ⇒ 00:15:11.180 Mustafa Raja: So what are you going to do now?
159 00:15:12.170 ⇒ 00:15:18.420 Casie Aviles: Oh, I’m just gonna generate the summary, and then I’m going to send it to… The channel.
160 00:15:18.980 ⇒ 00:15:19.670 Mustafa Raja: Yeah. Okay.
161 00:15:20.010 ⇒ 00:15:24.230 Casie Aviles: And, you know, and ask for you guys to double-check if I missed anything.
162 00:15:24.660 ⇒ 00:15:25.360 Mustafa Raja: Okay, good.
163 00:15:27.440 ⇒ 00:15:29.660 Casie Aviles: Alright, I think, yeah, that’s alright.
164 00:15:30.420 ⇒ 00:15:31.790 Mustafa Raja: Yeah, that’s pretty much it.
165 00:15:32.070 ⇒ 00:15:33.560 Casie Aviles: Okay, thank you, thank you.
166 00:15:35.670 ⇒ 00:15:41.320 Casie Aviles: I’m… Yeah, feel free to drop if you want. I can…
167 00:15:43.250 ⇒ 00:15:43.590 Mustafa Raja: Okay.
168 00:15:43.590 ⇒ 00:15:45.120 Casie Aviles: I’m just gonna keep doing this.
169 00:15:45.120 ⇒ 00:15:46.230 Mustafa Raja: And drop, and drop.
170 00:15:46.600 ⇒ 00:15:47.200 Mustafa Raja: Thank you.
171 00:15:47.920 ⇒ 00:15:49.290 Casie Aviles: Alright, thank you.