Meeting Title: Data Pull Issue Triage Meeting Date: 2025-08-06 Meeting participants: Uttam Kumaran, Sam Roberts, Mustafa Raja, Casie Aviles
WEBVTT
1 00:00:19.510 ⇒ 00:00:35.830 Mustafa Raja: Yeah. So one of the issues issue that we are having is when we pull the data from the sheet in our natn the residential pest is always comes empty, even when it has data in the sheet.
2 00:00:39.360 ⇒ 00:00:43.940 Uttam Kumaran: Okay, why is that.
3 00:00:45.690 ⇒ 00:00:46.959 Mustafa Raja: Yeah, we need to inspect them.
4 00:00:50.120 ⇒ 00:00:52.550 Sam Roberts: Yeah, it looks like there’s a couple that I was testing here.
5 00:00:54.810 ⇒ 00:00:55.709 Sam Roberts: We’ll show that.
6 00:01:03.370 ⇒ 00:01:04.280 Uttam Kumaran: Seems good.
7 00:01:04.800 ⇒ 00:01:07.290 Sam Roberts: I just tested one couple of days ago.
8 00:01:07.750 ⇒ 00:01:08.400 Uttam Kumaran: Okay.
9 00:01:31.630 ⇒ 00:01:32.850 Sam Roberts: Yeah, we did it.
10 00:01:43.450 ⇒ 00:01:46.559 Uttam Kumaran: I guess where I’m concerned. Is that
11 00:01:50.560 ⇒ 00:01:54.640 Uttam Kumaran: like Casey? What is this college station table
12 00:01:54.850 ⇒ 00:01:58.229 Uttam Kumaran: and like is tree related to college station table.
13 00:02:02.400 ⇒ 00:02:07.939 Uttam Kumaran: has. Oh, I guess the tree one only comes from tree table right like this column.
14 00:02:12.614 ⇒ 00:02:14.260 Mustafa Raja: Casey, I think you’re mute, muted.
15 00:02:15.210 ⇒ 00:02:24.650 Casie Aviles: Oh, sorry. Sorry I’m speaking. Yeah. There’s like, different tables. There’s a college station table, and then there’s a tree table. So that’s how they grouped it.
16 00:02:27.620 ⇒ 00:02:31.129 Uttam Kumaran: But, like, let’s take this example. Right?
17 00:02:32.040 ⇒ 00:02:35.040 Uttam Kumaran: Should we be using tree table in this case?
18 00:02:39.918 ⇒ 00:02:43.050 Casie Aviles: Yeah, that’s because that’s where we can find it.
19 00:02:43.667 ⇒ 00:02:49.699 Casie Aviles: I’ll check. I’ll double check college station if there are any trees there, but I think they separated it.
20 00:02:51.290 ⇒ 00:02:54.030 Mustafa Raja: Did we add a new row at Row number 4.
21 00:02:57.440 ⇒ 00:02:58.680 Uttam Kumaran: I just did, yeah.
22 00:02:58.770 ⇒ 00:03:01.139 Mustafa Raja: Yeah, we need to update this anytime.
23 00:03:02.330 ⇒ 00:03:06.330 Uttam Kumaran: Well, this is not. It’s not. Gonna it’s not necessary. I just need it for our reference.
24 00:03:08.238 ⇒ 00:03:12.060 Mustafa Raja: The row. The row 4 is being referenced as the header row.
25 00:03:13.940 ⇒ 00:03:14.560 Uttam Kumaran: Oh, yeah.
26 00:03:14.560 ⇒ 00:03:16.369 Mustafa Raja: And edit. And so, yeah.
27 00:03:16.370 ⇒ 00:03:17.200 Uttam Kumaran: I see. I see. Okay.
28 00:03:17.200 ⇒ 00:03:20.560 Mustafa Raja: I’ll just update it to go to look for the row. Number 5.
29 00:03:21.140 ⇒ 00:03:21.770 Uttam Kumaran: Okay.
30 00:03:26.840 ⇒ 00:03:37.110 Uttam Kumaran: So I guess my question is like, Oh, shit.
31 00:03:40.350 ⇒ 00:03:43.410 Sam Roberts: Oh, oh, it’s dependent on that!
32 00:03:44.890 ⇒ 00:03:47.080 Sam Roberts: The branch as well.
33 00:03:51.210 ⇒ 00:03:53.440 Casie Aviles: Yeah, it’s also dependent there.
34 00:03:54.030 ⇒ 00:03:56.519 Casie Aviles: They they have like different groupings.
35 00:03:58.660 ⇒ 00:04:03.040 Uttam Kumaran: But is so. Are we not accurate here, then, the way we wrote this formula.
36 00:04:09.750 ⇒ 00:04:14.089 Sam Roberts: It seemed okay, based on that. But I don’t know. Yeah, because I think the tree table.
37 00:04:15.220 ⇒ 00:04:20.740 Uttam Kumaran: Yeah, Casey, like, does this need to pull from Corpus Christi? Or can this pull from tree table.
38 00:04:23.259 ⇒ 00:04:28.990 Casie Aviles: For 3, it’s only 3, we, and then for the other other ones.
39 00:04:30.280 ⇒ 00:04:31.120 Casie Aviles: No.
40 00:04:38.670 ⇒ 00:04:44.000 Uttam Kumaran: So I guess what I want to put here is like
41 00:04:45.100 ⇒ 00:04:48.430 Uttam Kumaran: what the grouping is going to be. For example.
42 00:04:48.680 ⇒ 00:04:52.799 Uttam Kumaran: like this one looks like it’s it’s branch based right?
43 00:04:53.750 ⇒ 00:04:54.560 Sam Roberts: Hmm.
44 00:04:57.850 ⇒ 00:05:03.290 Uttam Kumaran: See what I mean, but these ones are all manual.
45 00:05:05.140 ⇒ 00:05:07.769 Sam Roberts: We’re bad at history on that, with the same date as the other one.
46 00:05:14.880 ⇒ 00:05:17.069 Uttam Kumaran: And these ones don’t have any values.
47 00:05:18.120 ⇒ 00:05:22.159 Casie Aviles: Rio Grande. Yeah, we don’t have any data there for Rio Grande.
48 00:05:24.510 ⇒ 00:05:27.409 Uttam Kumaran: Okay. But I guess so like, for example, what I would do is like
49 00:05:27.550 ⇒ 00:05:32.059 Uttam Kumaran: source sheet. I would put here Branch based right?
50 00:05:33.870 ⇒ 00:05:39.750 Uttam Kumaran: This one, too. Looks like it’s branch based. So, Casey, can you help me fill these out? And then, for example, for tree.
51 00:05:40.260 ⇒ 00:05:41.480 Uttam Kumaran: it’s tree table.
52 00:05:43.840 ⇒ 00:05:44.540 Casie Aviles: Okay.
53 00:05:44.730 ⇒ 00:05:48.779 Uttam Kumaran: So can you help me fill out for all these columns like
54 00:05:49.620 ⇒ 00:05:54.940 Uttam Kumaran: what the source is gonna be, whether it’s a branch based source or it’s a single source.
55 00:05:59.810 ⇒ 00:06:00.315 Casie Aviles: Okay.
56 00:06:04.080 ⇒ 00:06:07.379 Uttam Kumaran: The other thing I have a question about is like.
57 00:06:19.340 ⇒ 00:06:20.440 Uttam Kumaran: Okay.
58 00:07:01.440 ⇒ 00:07:07.099 Uttam Kumaran: yeah. So I just wanna confirm which ones are branch based and which ones are not.
59 00:07:07.830 ⇒ 00:07:09.800 Uttam Kumaran: This is branch based.
60 00:07:11.580 ⇒ 00:07:15.189 Sam Roberts: Does this person depend on the way? The data that they had the data on the room.
61 00:07:15.980 ⇒ 00:07:23.250 Uttam Kumaran: Yeah, like the complication. Here is where some of the rows are from one table. Some of the rows.
62 00:07:23.250 ⇒ 00:07:23.750 Casie Aviles: Yes.
63 00:07:23.750 ⇒ 00:07:30.169 Uttam Kumaran: Dependent on column C, is it dependent on C or not? Basically.
64 00:07:30.170 ⇒ 00:07:37.120 Sam Roberts: Yeah, yeah, okay, I guess I’m wondering, like, what? Why that is. The case. Is that just because of the way the data came in.
65 00:07:37.120 ⇒ 00:07:37.810 Uttam Kumaran: Yeah, yeah.
66 00:07:37.810 ⇒ 00:07:39.130 Casie Aviles: Yes, yes.
67 00:07:39.130 ⇒ 00:07:39.930 Uttam Kumaran: Yeah.
68 00:07:41.350 ⇒ 00:07:52.910 Uttam Kumaran: So there’s some optimizations that we could do here, you know, for example, we could try to merge
69 00:07:54.060 ⇒ 00:07:59.810 Uttam Kumaran: all the branches for the different service lines into one, so that the
70 00:08:00.450 ⇒ 00:08:02.799 Uttam Kumaran: branch is just a lookup field.
71 00:08:04.359 ⇒ 00:08:10.050 Uttam Kumaran: But again, like I can, I can take that on like I just want to sort of make sure that
72 00:08:10.490 ⇒ 00:08:15.950 Uttam Kumaran: whatever we need to do to get this accurate today, we let’s get accurate. And then we can optimize later.
73 00:08:20.000 ⇒ 00:08:20.695 Casie Aviles: Okay.
74 00:08:25.080 ⇒ 00:08:30.610 Uttam Kumaran: Like, here’s a good example, Casey, like these are. These are all manual right here, like this person’s name.
75 00:08:30.920 ⇒ 00:08:32.960 Uttam Kumaran: So what should we do with this one.
76 00:08:37.975 ⇒ 00:08:42.480 Casie Aviles: I I do know there’s a term machine. Let me double check.
77 00:09:19.860 ⇒ 00:09:26.059 Uttam Kumaran: They have. Sam for context like this is just based on because of how crappy the data they gave us where we structured this
78 00:09:26.937 ⇒ 00:09:31.099 Uttam Kumaran: but there’s clearly like a lot of excel things that we have to do.
79 00:11:38.350 ⇒ 00:11:41.279 Sam Roberts: I don’t know if I can be much more help with this at this point. So I might.
80 00:11:41.280 ⇒ 00:11:57.800 Uttam Kumaran: No, that’s fine, I think. Yeah, I think. Let’s so one thing, Casey, maybe we can stay on. And I just want to make sure that there’s some columns I’m noticing that are empty. So let’s just go fix those like we can stay on. And or do you want to try to take that on Casey, like, basically just making sure that
81 00:11:57.990 ⇒ 00:12:02.310 Uttam Kumaran: all the columns now can reflect our new logic for the lookups.
82 00:12:03.770 ⇒ 00:12:05.780 Casie Aviles: Yes, yes, I can do that.
83 00:12:05.780 ⇒ 00:12:10.509 Uttam Kumaran: Okay? Yeah, if you go commercial tree now, or
84 00:12:10.990 ⇒ 00:12:33.710 Uttam Kumaran: residential tree. Yeah, basically, this is the new logic. And I can help. I’ll draft the the the note to amber on a couple of things. So one is we noticed that the formulas we were using didn’t account for multiple inspectors per zip
85 00:12:34.110 ⇒ 00:12:45.620 Uttam Kumaran: per service line. So we fix that second thing. We are and
86 00:12:45.810 ⇒ 00:12:56.140 Uttam Kumaran: also planning on fixing how some lookups are branch based where some lookups are fixed to the speciality. So we will be updating
87 00:12:58.580 ⇒ 00:12:59.610 Uttam Kumaran: And then
88 00:12:59.980 ⇒ 00:13:08.379 Uttam Kumaran: I think one thing that would be helpful. Casey, is, as you make the fixes. If you can rerun the Na, then
89 00:13:08.980 ⇒ 00:13:13.570 Uttam Kumaran: workflows, or you could just use the chat bot and
90 00:13:14.350 ⇒ 00:13:17.529 Uttam Kumaran: see if we’ve solved some of those problems that came in.
91 00:13:17.680 ⇒ 00:13:23.359 Uttam Kumaran: And if if we can just store those screenshots in the notion, Doc, then we’re good to go.
92 00:13:24.620 ⇒ 00:13:25.869 Casie Aviles: Okay, okay, so.
93 00:13:25.870 ⇒ 00:13:30.989 Uttam Kumaran: As soon as the fix is done, let’s load it back in, and then let’s see.
94 00:13:31.460 ⇒ 00:13:37.530 Mustafa Raja: Yeah, the the residential pest people are also coming in now in.
95 00:13:37.530 ⇒ 00:13:38.290 Uttam Kumaran: Oh, really great!
96 00:13:38.839 ⇒ 00:13:39.389 Mustafa Raja: Yeah.
97 00:13:39.630 ⇒ 00:13:41.619 Uttam Kumaran: Okay, cool. So this should this should do it.
98 00:13:43.560 ⇒ 00:13:44.520 Uttam Kumaran: Okay?
99 00:13:46.080 ⇒ 00:13:47.855 Uttam Kumaran: Alright, maybe send a note.
100 00:13:48.380 ⇒ 00:13:50.660 Uttam Kumaran: you know, when when we’re good and I’ll drop that and see.
101 00:13:50.660 ⇒ 00:13:56.139 Casie Aviles: Yes, I’ll send slack message to let everyone know that.
102 00:13:57.285 ⇒ 00:14:02.137 Uttam Kumaran: Okay, thanks, guys, this is great, great triage.
103 00:14:02.550 ⇒ 00:14:03.090 Sam Roberts: Yeah.
104 00:14:03.090 ⇒ 00:14:05.670 Uttam Kumaran: Yeah, cool. Okay, talk to you guys, soon.
105 00:14:06.080 ⇒ 00:14:06.850 Casie Aviles: Thank you.
106 00:14:07.100 ⇒ 00:14:07.650 Uttam Kumaran: Okay? Bye.