Meeting Title: Eddie <> Uttam—Target-Automation Date: 2024-09-04 Meeting participants: Eddie Brophy, Uttam Kumaran
WEBVTT
1 00:16:27.200 ⇒ 00:16:28.919 Eddie Brophy: Yo! What’s going on.
2 00:16:29.360 ⇒ 00:16:30.610 Uttam Kumaran: Yo, what’s good dude.
3 00:16:30.780 ⇒ 00:16:33.379 Eddie Brophy: What’s up? How are you?
4 00:16:33.380 ⇒ 00:16:34.620 Uttam Kumaran: Where you at your home.
5 00:16:34.620 ⇒ 00:16:42.460 Eddie Brophy: I’m yeah my place. I was working upstairs at the room before I just came back down here. Where are you at the you at your place?
6 00:16:42.660 ⇒ 00:16:50.560 Uttam Kumaran: No, I like. There’s a coffee shop near my gym. So I just like usually come here, and then I try to go to the gym around like 3 or 4.
7 00:16:50.560 ⇒ 00:16:50.900 Eddie Brophy: I see.
8 00:16:50.900 ⇒ 00:16:52.670 Uttam Kumaran: Or gets like too crowded.
9 00:16:52.670 ⇒ 00:16:54.140 Eddie Brophy: Yeah, not smart.
10 00:16:54.240 ⇒ 00:16:55.530 Eddie Brophy: Or if you were.
11 00:16:56.383 ⇒ 00:17:02.709 Uttam Kumaran: Dude. This kind of sounds like a kind of a sick project. So I we I kind of tell you a little bit about
12 00:17:03.215 ⇒ 00:17:28.920 Uttam Kumaran: like some of the stuff we’ve been doing probably since I last talk. So we started doing a lot of AI stuff internally, actually, kind of stuff similar to this as well as like a lot of automation related stuff. And you know, I still have guys that are doing like data work. And that’s growing but actually, I just hired a guy on my team who’s like, very, very like cracked at this kind of work. So that’s why, when you messaged me. I was like
13 00:17:28.920 ⇒ 00:17:51.369 Uttam Kumaran: I was like, Oh, I I like have a perfect guy. And I messaged this to him. And we actually he actually was testing some stuff. And I talked to him this morning, and also yesterday. And we were going through like the target website. So I have some stuff that I can share. But maybe I’ll get the gist from you first, st and then I can like make sure to hit on whatever we need to.
14 00:17:52.570 ⇒ 00:17:55.920 Eddie Brophy: Yeah, no. I mean, like we, what we kind of talked about was
15 00:17:55.990 ⇒ 00:17:57.300 Eddie Brophy: really the
16 00:17:57.630 ⇒ 00:18:01.689 Eddie Brophy: the main gist of it. I’m pulling up here a message out from a Cfo. He’s basically saying.
17 00:18:02.510 ⇒ 00:18:12.690 Eddie Brophy: here’s the item number which I can. I’ll put in the Zoom chat here. We’re just doing Random. We’re just doing random searches and seeing in stock like on.
18 00:18:13.200 ⇒ 00:18:17.650 Eddie Brophy: you know, like, if they’re selling it or not, basically. So basically
19 00:18:18.520 ⇒ 00:18:21.360 Eddie Brophy: exactly what we were looking at. So I can send you
20 00:18:21.630 ⇒ 00:18:26.840 Eddie Brophy: the item number. I joined from my phone and I had on my computer.
21 00:18:28.620 ⇒ 00:18:32.719 Eddie Brophy: my air pods like never connect to my computer. So I always just join on both.
22 00:18:32.720 ⇒ 00:18:35.439 Uttam Kumaran: You can text me, too. Whatever is easiest.
23 00:18:35.440 ⇒ 00:18:36.579 Eddie Brophy: Okay, let me
24 00:18:37.250 ⇒ 00:18:38.270 Eddie Brophy: see there.
25 00:18:57.683 ⇒ 00:18:58.376 Eddie Brophy: yeah.
26 00:18:59.260 ⇒ 00:19:01.300 Eddie Brophy: Well, I’ll just text you through. I don’t know why I’m like.
27 00:19:02.370 ⇒ 00:19:03.400 Eddie Brophy: bye
28 00:19:04.240 ⇒ 00:19:05.969 Eddie Brophy: wi-fi goes actively
29 00:19:12.500 ⇒ 00:19:13.390 Eddie Brophy: I’m sorry.
30 00:19:15.320 ⇒ 00:19:16.800 Eddie Brophy: Top link
31 00:19:19.250 ⇒ 00:19:21.029 Eddie Brophy: alright, so that
32 00:19:21.630 ⇒ 00:19:24.189 Eddie Brophy: what I just sent as the target link.
33 00:19:24.990 ⇒ 00:19:26.360 Uttam Kumaran: Okay, cool. Yeah.
34 00:19:26.360 ⇒ 00:19:27.020 Eddie Brophy: Cheese
35 00:19:31.210 ⇒ 00:19:33.099 Eddie Brophy: to that item. Specifically.
36 00:19:36.210 ⇒ 00:19:37.940 Uttam Kumaran: Okay, well, I got it.
37 00:19:40.210 ⇒ 00:19:43.899 Uttam Kumaran: So you said, you also have like an item number. Or is it just this one.
38 00:19:43.900 ⇒ 00:19:46.439 Eddie Brophy: That’s just that one. That’s just the
39 00:19:47.080 ⇒ 00:19:51.039 Eddie Brophy: yeah. I don’t know if they have like a skew id or.
40 00:19:51.040 ⇒ 00:19:55.320 Uttam Kumaran: Fine. I mean, as long as it’s just this, we can start with that. And then, yeah, yeah.
41 00:19:55.696 ⇒ 00:19:57.579 Eddie Brophy: Text, the description won’t change.
42 00:20:00.590 ⇒ 00:20:07.909 Uttam Kumaran: And then what’s like, what’s your current process like, what’s how is this being done today? And then also, not only like.
43 00:20:08.280 ⇒ 00:20:11.489 Uttam Kumaran: like, yeah, I guess. How is it being done? And I’d like to start there.
44 00:20:11.990 ⇒ 00:20:15.780 Eddie Brophy: Yeah, I don’t. I don’t know why. For some I’m trying to share my
45 00:20:18.640 ⇒ 00:20:20.469 Eddie Brophy: for some reason.
46 00:20:20.570 ⇒ 00:20:22.739 Eddie Brophy: clear my cash. I don’t know why
47 00:20:23.470 ⇒ 00:20:26.839 Eddie Brophy: we have this like stupid proof. Point URL thing. For some reason.
48 00:20:29.120 ⇒ 00:20:30.720 Uttam Kumaran: No, that’s your fault. Dude your IP.
49 00:20:30.720 ⇒ 00:20:32.230 Eddie Brophy: I know.
50 00:20:32.230 ⇒ 00:20:35.529 Uttam Kumaran: Fuck. You gotta you gotta call yourself.
51 00:20:40.150 ⇒ 00:20:41.139 Eddie Brophy: What it is.
52 00:20:42.340 ⇒ 00:20:46.429 Eddie Brophy: yeah, let me send this screenshot as well like what they’re looking at
53 00:20:47.700 ⇒ 00:20:49.950 Eddie Brophy: to try to explain the process of it.
54 00:20:52.940 ⇒ 00:20:54.620 Eddie Brophy: just for fury.
55 00:20:56.670 ⇒ 00:20:58.549 Uttam Kumaran: Yeah, exactly. Okay.
56 00:20:58.790 ⇒ 00:21:00.140 Eddie Brophy: To kind of.
57 00:21:00.140 ⇒ 00:21:00.810 Uttam Kumaran: Sidebar.
58 00:21:01.230 ⇒ 00:21:01.790 Eddie Brophy: Yeah.
59 00:21:03.870 ⇒ 00:21:10.749 Uttam Kumaran: So what? So if I? So they’re basically opening up the target, URL, looking at a sidebar and then just marking which ones are, have it or don’t.
60 00:21:11.360 ⇒ 00:21:11.844 Eddie Brophy: Yes.
61 00:21:12.330 ⇒ 00:21:15.109 Uttam Kumaran: Is it? Is it particular? Are you looking at a particular Zip code?
62 00:21:16.690 ⇒ 00:21:19.879 Eddie Brophy: Not in particular. I think we kind of want to see
63 00:21:19.970 ⇒ 00:21:23.939 Eddie Brophy: all across the Us. If I’m not mistaken, I could be wrong on that.
64 00:21:24.230 ⇒ 00:21:24.820 Uttam Kumaran: Okay.
65 00:21:26.212 ⇒ 00:21:27.940 Eddie Brophy: You’re literally having to
66 00:21:28.610 ⇒ 00:21:30.490 Eddie Brophy: join the meeting manually.
67 00:21:34.720 ⇒ 00:21:35.900 Eddie Brophy: yeah, I
68 00:21:35.990 ⇒ 00:21:41.109 Eddie Brophy: basically. The that was the gist of what I got like they’re looking, you know.
69 00:21:41.260 ⇒ 00:21:44.250 Eddie Brophy: arbitrarily, I guess, is the best way to put it.
70 00:21:44.770 ⇒ 00:21:45.430 Uttam Kumaran: Yeah.
71 00:21:48.170 ⇒ 00:21:49.610 Eddie Brophy: What they want to do is.
72 00:21:49.610 ⇒ 00:21:50.210 Uttam Kumaran: Really? Well.
73 00:21:50.210 ⇒ 00:21:53.910 Eddie Brophy: Here, I’ll show you now. I only got it. I could share my screen here.
74 00:21:59.200 ⇒ 00:22:03.889 Eddie Brophy: So this is the conversation I had. Cory is our Cfo. And basically, he was saying.
75 00:22:05.060 ⇒ 00:22:09.744 Eddie Brophy: we like to survey each store to determine if the product is in stock or not sold.
76 00:22:10.860 ⇒ 00:22:18.339 Eddie Brophy: so I guess the more data the better we’re if you said we were just doing random searches and seeing like on stock here, you can see
77 00:22:18.410 ⇒ 00:22:19.960 Eddie Brophy: some here. It says.
78 00:22:19.960 ⇒ 00:22:21.500 Uttam Kumaran: Yeah, yeah.
79 00:22:24.220 ⇒ 00:22:28.960 Uttam Kumaran: And are you guys doing this every day like, every week?
80 00:22:28.960 ⇒ 00:22:32.119 Eddie Brophy: Yeah, those let me write down. I’m gonna I’ll start taking.
81 00:22:32.120 ⇒ 00:22:32.779 Uttam Kumaran: That’s true. It’s true.
82 00:22:32.780 ⇒ 00:22:33.840 Eddie Brophy: All questions.
83 00:22:33.840 ⇒ 00:22:37.170 Uttam Kumaran: Just for my context, because I’ll show you today, basically
84 00:22:37.340 ⇒ 00:22:43.099 Uttam Kumaran: we I, we basically did like a little bit of a proof of concept of like, how this would work for one.
85 00:22:43.100 ⇒ 00:22:43.750 Eddie Brophy: Yeah.
86 00:22:43.940 ⇒ 00:22:47.290 Uttam Kumaran: But a couple of things that would be helpful is
87 00:22:47.667 ⇒ 00:22:56.129 Uttam Kumaran: and I’ll I could send you these after, too, is like one. Confirming whether this is all targets or a specific subset
88 00:22:56.905 ⇒ 00:22:59.430 Uttam Kumaran: ideally, it would be great.
89 00:22:59.430 ⇒ 00:23:00.340 Eddie Brophy: Like I think.
90 00:23:00.340 ⇒ 00:23:04.219 Uttam Kumaran: Maybe we just start with New York, or we start with Texas or something where.
91 00:23:04.410 ⇒ 00:23:07.190 Uttam Kumaran: like, I just want to show a proof of concept. Basically.
92 00:23:07.240 ⇒ 00:23:11.650 Uttam Kumaran: the second thing that’s helpful is how often you want to check this
93 00:23:12.320 ⇒ 00:23:16.070 Uttam Kumaran: like, is this a every week thing? Is this like a once a month thing?
94 00:23:17.100 ⇒ 00:23:18.010 Eddie Brophy: Gotcha.
95 00:23:18.010 ⇒ 00:23:27.269 Uttam Kumaran: And then to give you a sense of like what we’re thinking for the output, like the output from our side, would just be like an air table or like an excel sheet. Basically, it would be
96 00:23:27.290 ⇒ 00:23:45.500 Uttam Kumaran: like the store, the product. And this will just be one product. It’d be like the last date we checked. And it would be like the status. And we checked when we checked it. Basically. So yeah, ideally, you have like a running. Ideally you have, like a running log of like the status for every store we check.
97 00:23:45.550 ⇒ 00:23:47.810 Uttam Kumaran: And then also you can know when that
98 00:23:48.050 ⇒ 00:23:49.380 Uttam Kumaran: like changes
99 00:23:51.690 ⇒ 00:24:06.599 Uttam Kumaran: a little bit about like how we’re gonna like, how I were thinking of doing it. But really, I think the cost, the cost for this just scales, basically on, like how many we want to do.
100 00:24:06.610 ⇒ 00:24:18.980 Uttam Kumaran: But honestly, this should be. This seems like really, really straightforward something we can do really quickly. But let me show you kind of like what we found out. Because we got it working for one store. Actually, basically.
101 00:24:18.980 ⇒ 00:24:19.600 Eddie Brophy: Wow!
102 00:24:20.668 ⇒ 00:24:23.480 Uttam Kumaran: So this is our general flow.
103 00:24:23.819 ⇒ 00:24:26.890 Uttam Kumaran: So actually, let me. It’s actually probably easier if I just walk you through.
104 00:24:27.090 ⇒ 00:24:27.690 Eddie Brophy: Okay.
105 00:24:28.240 ⇒ 00:24:30.479 Uttam Kumaran: I’ll walk you through an example. So
106 00:24:31.082 ⇒ 00:24:42.729 Uttam Kumaran: I just filtered. I just put my zip code as 1,001 which is New York. I just picked times square. Basically your user. You would basically just see this right? Scott.
107 00:24:42.730 ⇒ 00:24:43.440 Eddie Brophy: Yeah.
108 00:24:44.750 ⇒ 00:24:49.119 Uttam Kumaran: If you if you do show in stocks, or would you say pool Upper West Side in stock?
109 00:24:49.230 ⇒ 00:25:01.420 Uttam Kumaran: Right? So there’s a couple of ways that we get the signal of that. It’s in stock. One is from this page, the way to change this is basically you go here, you you pick a new store
110 00:25:01.460 ⇒ 00:25:06.539 Uttam Kumaran: right? If I pick Upper West Side and I shop this store, I’m gonna see that it’s ready.
111 00:25:06.780 ⇒ 00:25:10.930 Uttam Kumaran: Right? So the one thing that we’re gonna have to figure out is like
112 00:25:11.600 ⇒ 00:25:15.769 Uttam Kumaran: this is checking their stores here. This is only within a 50 mile radius.
113 00:25:17.860 ⇒ 00:25:19.060 Uttam Kumaran: so basically.
114 00:25:19.370 ⇒ 00:25:21.490 Uttam Kumaran: we’re gonna start to start, basically
115 00:25:21.610 ⇒ 00:25:23.990 Uttam Kumaran: take every single target that exists
116 00:25:24.120 ⇒ 00:25:29.849 Uttam Kumaran: in a state. Or I mean, it’s pretty. It’ll be pretty easy if we get every single target in the Us, and then basically
117 00:25:29.930 ⇒ 00:25:37.209 Uttam Kumaran: map the zip codes and then go one by one. But this is basically the process we’ll do is look either here or open up
118 00:25:37.220 ⇒ 00:25:47.690 Uttam Kumaran: the other stores, and then look right here. At this point we save the timestamp, and we save the status for every single unique for every single unique
119 00:25:47.720 ⇒ 00:25:51.669 Uttam Kumaran: store storm and a little yeah, and a little bit about our our
120 00:25:51.800 ⇒ 00:25:54.209 Uttam Kumaran: process. So
121 00:25:54.230 ⇒ 00:25:56.960 Uttam Kumaran: if you look at like one
122 00:25:57.090 ⇒ 00:26:03.992 Uttam Kumaran: way, we’re thinking about doing this. We have a product, URL, that in this case it’s just that’s 1. URL, we scrape the website.
123 00:26:04.628 ⇒ 00:26:15.979 Uttam Kumaran: for example, the Urls. At the moment they don’t have the. It’s it’s not like I can go to target.com and the URL. The location automatically fills in. You have to go change it. So.
124 00:26:15.980 ⇒ 00:26:16.550 Eddie Brophy: Yeah.
125 00:26:16.550 ⇒ 00:26:24.499 Uttam Kumaran: That’s 1 of the complications that we are testing and like figuring out. Basically, how do you get? How do you change that location? But.
126 00:26:24.500 ⇒ 00:26:25.020 Eddie Brophy: Gotcha.
127 00:26:25.020 ⇒ 00:26:37.849 Uttam Kumaran: Scraping, scraping that and getting the outputs. And then so that’s 1 thing is scraping that get the outputs having AI analyze it. And then we run an automation that basically throws that into a Google sheet or an air table.
128 00:26:37.850 ⇒ 00:26:38.550 Eddie Brophy: Okay.
129 00:26:38.901 ⇒ 00:26:47.339 Uttam Kumaran: So this step will probably take the same the other way we do. This is, there’s another. There’s some more scraping methods that
130 00:26:47.630 ⇒ 00:27:05.295 Uttam Kumaran: again, the target site is a little bit unique in that. It uses like this thing called redux, which is like this front end technology. It just makes it a little bit harder to scrape because you have to actually go put in bunch of stuff. So instead, there’s another technology we can use that basically goes into goes into
131 00:27:05.890 ⇒ 00:27:11.266 Uttam Kumaran: picks a store, searches for the product, clicks the product and scrapes that page.
132 00:27:11.870 ⇒ 00:27:19.389 Uttam Kumaran: so that’s another way we can do it again. We just probably spent like an hour or 2 just thinking about it roughly. But either way, this seems like
133 00:27:20.120 ⇒ 00:27:21.670 Uttam Kumaran: pretty doable.
134 00:27:23.250 ⇒ 00:27:32.569 Uttam Kumaran: I mean, even after a few hours of just testing, it’s really easy. Once once we get to this page. Once we get to this page.
135 00:27:32.590 ⇒ 00:27:35.799 Uttam Kumaran: it’s actually really the process of scraping this.
136 00:27:36.190 ⇒ 00:27:42.510 Uttam Kumaran: figuring out whether this is ready or says on something else. Putting that into Google sheet is something really manageable.
137 00:27:42.510 ⇒ 00:27:42.900 Eddie Brophy: Okay.
138 00:27:42.900 ⇒ 00:27:44.520 Uttam Kumaran: This is switching the.
139 00:27:44.520 ⇒ 00:27:45.180 Eddie Brophy: Course.
140 00:27:45.480 ⇒ 00:27:52.319 Uttam Kumaran: Yeah, the part that will require probably, like a few days to a week to like nail down is switching the stores.
141 00:27:52.702 ⇒ 00:28:05.530 Uttam Kumaran: But the nice thing is, this is like piecemeal. So basically, I was like, cool. Let’s see if we can just figure out how to scrape one page, and then we can start feeding in more pages. It’s like another process.
142 00:28:05.530 ⇒ 00:28:06.480 Eddie Brophy: Gotcha? Yeah.
143 00:28:06.670 ⇒ 00:28:08.220 Uttam Kumaran: But this seems pretty.
144 00:28:08.430 ⇒ 00:28:12.499 Uttam Kumaran: Yeah, I mean, I think this is something that we can definitely rip. Probably this month.
145 00:28:12.500 ⇒ 00:28:21.160 Eddie Brophy: Awesome. I mean, that’s great. I mean, that’s that’s great. That sheet. The end goal is like to get it into a sequel table. Probably so we could be like a dashboard out of it, so.
146 00:28:21.160 ⇒ 00:28:21.490 Uttam Kumaran: Yeah.
147 00:28:21.490 ⇒ 00:28:35.620 Eddie Brophy: We can. Just we can just take it as a Csv and import it, or even if if you have a way of like pushing it to a sequel table. It might even be easier. But we can. We have informatica so like we can take a Csv file if you, if it can like
148 00:28:36.940 ⇒ 00:28:42.979 Eddie Brophy: drop somewhere like where would who? Where would the code live? I guess. Where would the program live on you right then.
149 00:28:43.400 ⇒ 00:29:10.470 Uttam Kumaran: Yeah. So that’s also a couple of things that we can decide on. So there’s a couple of tools that we typically use like execute scripts like this, one of which is called windmill, basically like a really easy, open source workflow tool. Another is called replic very similar to this. Or if you guys have somewhere, you want us to run this, we can do it there. It’s likely gonna be something that we
150 00:29:10.630 ⇒ 00:29:12.260 Uttam Kumaran: we do locally on like
151 00:29:12.350 ⇒ 00:29:20.210 Uttam Kumaran: my laptop, or Miguel, who’s on my team, his laptop. And then once it’s working, we’ll put it into one of these workflows.
152 00:29:20.210 ⇒ 00:29:20.810 Eddie Brophy: Gotcha.
153 00:29:20.810 ⇒ 00:29:23.779 Uttam Kumaran: You guys? We can do this, and it’s
154 00:29:24.090 ⇒ 00:29:25.629 Uttam Kumaran: it’s pretty cheap like
155 00:29:25.830 ⇒ 00:29:36.730 Uttam Kumaran: again it? Oh, before I can tell you how much the the cost of like the materials are, which is like how much I gotta know. How many are we gonna go after every single store every week or so.
156 00:29:36.730 ⇒ 00:29:37.639 Eddie Brophy: Yeah, yeah.
157 00:29:37.640 ⇒ 00:29:39.990 Uttam Kumaran: But it should be. It should be pretty reasonable.
158 00:29:39.990 ⇒ 00:29:49.759 Eddie Brophy: Okay. So the the questions I have just to confirm are right now, just do we want to focus on certain zip codes only, and how often we want to check. Was there another one I missed, or.
159 00:29:50.702 ⇒ 00:29:53.239 Uttam Kumaran: Yeah, we wanna look at how? Which?
160 00:29:53.440 ⇒ 00:29:56.510 Uttam Kumaran: Yeah, which zip codes? Or, yeah, basically, do we want to upgrade.
161 00:29:56.510 ⇒ 00:29:58.343 Eddie Brophy: So just do all yeah,
162 00:29:59.050 ⇒ 00:30:03.600 Uttam Kumaran: Yeah, I’m confirming again that we just want to look at this one product cause I know you have. You’re selling.
163 00:30:03.600 ⇒ 00:30:07.309 Eddie Brophy: That. Yeah, no, that is, for sure, the one product that I know for sure.
164 00:30:07.550 ⇒ 00:30:14.753 Uttam Kumaran: Okay, yeah. So that would be that would basically like which stores you want to go all, after all stores. And then how frequent like is this?
165 00:30:15.020 ⇒ 00:30:15.400 Eddie Brophy: Okay.
166 00:30:15.400 ⇒ 00:30:23.250 Uttam Kumaran: Once a week. Is this once a month? This is every day, and of course we can always get more frequent. But I want to start with
167 00:30:23.300 ⇒ 00:30:26.279 Uttam Kumaran: getting towards a solution.
168 00:30:27.770 ⇒ 00:30:28.360 Eddie Brophy: And yeah.
169 00:30:28.360 ⇒ 00:30:40.063 Uttam Kumaran: How? Yeah? And then the output in terms of what we’ll. What I’ll drive towards initially is we’ll drive towards the Csv. And then, ideally. Instead, we can. We can also just put this straight into informatica.
170 00:30:40.380 ⇒ 00:30:44.800 Eddie Brophy: Okay, yeah, like, where, I guess, where can that flat file?
171 00:30:45.170 ⇒ 00:30:48.450 Eddie Brophy: Can that be like, where does? I’m assuming.
172 00:30:48.450 ⇒ 00:30:49.000 Uttam Kumaran: Yeah, that can.
173 00:30:49.000 ⇒ 00:30:49.650 Eddie Brophy: Email to you.
174 00:30:49.650 ⇒ 00:30:53.976 Uttam Kumaran: Or like you can drop it in a Google drive or
175 00:30:54.370 ⇒ 00:30:58.539 Eddie Brophy: I mean, yeah, I mean the the I ideally like
176 00:30:59.300 ⇒ 00:31:04.769 Eddie Brophy: trying to think of a way we could somehow get it on our domain like on a server, and like a little bit like a like an ntfs.
177 00:31:04.770 ⇒ 00:31:08.459 Uttam Kumaran: Do you guys use? Yeah, you guys, I mean, if you have Sftp or.
178 00:31:08.460 ⇒ 00:31:09.910 Eddie Brophy: Yeah, we do, yeah, yeah, we.
179 00:31:09.910 ⇒ 00:31:11.909 Uttam Kumaran: Yeah, we can sftp to you or.
180 00:31:11.910 ⇒ 00:31:12.260 Eddie Brophy: Okay.
181 00:31:12.260 ⇒ 00:31:16.209 Uttam Kumaran: You guys use s. 3, or like azure for your like.
182 00:31:16.830 ⇒ 00:31:17.270 Uttam Kumaran: Back, end.
183 00:31:17.270 ⇒ 00:31:25.630 Eddie Brophy: We do. We do have some instances or some s. 3 buckets, but I think Sftp is fine. That’s that’s fine.
184 00:31:25.940 ⇒ 00:31:31.149 Uttam Kumaran: Okay, we can. We can probably do that. And again, ideally, we’re gonna drive towards getting something that you can
185 00:31:31.170 ⇒ 00:31:35.090 Uttam Kumaran: like a Csv that you can like, feel and basically see. And then
186 00:31:35.340 ⇒ 00:31:38.409 Uttam Kumaran: what? However, we need to get that, whether it’s emailing it to an endpoint.
187 00:31:38.410 ⇒ 00:31:39.200 Eddie Brophy: Yeah.
188 00:31:39.200 ⇒ 00:31:40.800 Uttam Kumaran: Sftp, that’s actually, that’s.
189 00:31:40.800 ⇒ 00:31:44.740 Eddie Brophy: I wonder if I wonder if eventually, even like, if it’s on that
190 00:31:44.870 ⇒ 00:31:46.739 Eddie Brophy: like a kind of
191 00:31:46.770 ⇒ 00:31:49.309 Eddie Brophy: I’m assuming like cloud kind of like, is it?
192 00:31:49.310 ⇒ 00:31:49.650 Uttam Kumaran: Yeah.
193 00:31:49.650 ⇒ 00:31:58.139 Eddie Brophy: Web window. I wonder if our date, the server that our SQL. Database is on? We could just run it from there. So it’s just created locally on that server, as well.
194 00:31:58.620 ⇒ 00:32:13.559 Uttam Kumaran: Yeah, so on here, there’s a bunch of like, there are a bunch of like integrations, basically where they have like, they have like applications that you can send it to. There’s just a lot on here. But there’s a ton of apps that you can integrate this with.
195 00:32:14.084 ⇒ 00:32:25.769 Uttam Kumaran: I’ll have to look exactly and like if informatica is like a native one. But Sftp exists here and email and a ton of other stuff. Like, if I search for Sftp.
196 00:32:27.340 ⇒ 00:32:28.750 Uttam Kumaran: yeah, they have.
197 00:32:29.180 ⇒ 00:32:32.939 Uttam Kumaran: They have integrations for that. And then if I search for email.
198 00:32:33.270 ⇒ 00:32:38.399 Uttam Kumaran: there’s also emails where we could send, we can send emails out, basically with this attachment,
199 00:32:39.120 ⇒ 00:32:48.220 Uttam Kumaran: But I’m not as worried about that, because wherever your storage again, wherever ideally, however, it’s easy to pipe it into your informatica.
200 00:32:48.380 ⇒ 00:32:51.630 Uttam Kumaran: whether that’s a cron job that we can run, or an Api call.
201 00:32:51.630 ⇒ 00:32:52.410 Eddie Brophy: That’s.
202 00:32:52.410 ⇒ 00:32:53.640 Uttam Kumaran: Pretty reasonable. Yeah.
203 00:32:53.640 ⇒ 00:32:56.090 Eddie Brophy: Okay, okay, yeah, no. I agree.
204 00:32:56.090 ⇒ 00:32:56.749 Uttam Kumaran: And then the biggest.
205 00:32:56.750 ⇒ 00:32:57.279 Eddie Brophy: To find.
206 00:32:57.280 ⇒ 00:33:00.979 Uttam Kumaran: That is like short term. If you’re if we’re okay to run this
207 00:33:01.560 ⇒ 00:33:08.536 Uttam Kumaran: on our end and just get it to working, then we could probably work with your team to migrate it to your side.
208 00:33:08.840 ⇒ 00:33:09.430 Eddie Brophy: Okay.
209 00:33:09.720 ⇒ 00:33:10.410 Uttam Kumaran: Yeah.
210 00:33:11.370 ⇒ 00:33:13.514 Eddie Brophy: I’ll I’ll find out
211 00:33:15.240 ⇒ 00:33:18.089 Eddie Brophy: I’ll find out what zip codes we’re doing, and
212 00:33:18.310 ⇒ 00:33:22.699 Eddie Brophy: and how often you want to check, like if I I don’t think we’re gonna have any
213 00:33:22.770 ⇒ 00:33:26.400 Eddie Brophy: problems, what the cost is. But if he does ask, I guess, what do you think.
214 00:33:26.690 ⇒ 00:33:41.630 Uttam Kumaran: Yeah, that’s what I was. Gonna ask, like, what what you think a budget is for our side. It’s really, I’m gonna think about it’s gonna be based on how many you want to scrape, cause that’ll give us a little bit of range. But I could. I mean.
215 00:33:42.170 ⇒ 00:33:46.580 Uttam Kumaran: I’ll have to think about how long, how many hours it’s gonna take. I think.
216 00:33:46.580 ⇒ 00:33:48.560 Eddie Brophy: That info, and and we can go from there.
217 00:33:48.560 ⇒ 00:33:49.310 Uttam Kumaran: You can get us.
218 00:33:49.310 ⇒ 00:33:50.949 Eddie Brophy: What’s a budget.
219 00:33:50.950 ⇒ 00:33:58.420 Uttam Kumaran: Yes, and see if you can. If you guys have a sense of budget, or if you know a little bit about like how much you’re paying now. That would be helpful.
220 00:33:58.420 ⇒ 00:34:01.020 Eddie Brophy: I mean, I don’t think I’m doing anything to be honest right now.
221 00:34:01.020 ⇒ 00:34:04.790 Uttam Kumaran: Okay. Then then I I’m gonna try to price it just based on ours. And we might.
222 00:34:04.790 ⇒ 00:34:05.490 Eddie Brophy: Yeah.
223 00:34:05.820 ⇒ 00:34:08.060 Uttam Kumaran: We might just start off again. I don’t
224 00:34:08.420 ⇒ 00:34:17.069 Uttam Kumaran: like it. To be really honest, I don’t think this is gonna take more than a month to do so, probably somewhere in the range of like
225 00:34:17.219 ⇒ 00:34:29.169 Uttam Kumaran: 40 h or so. But also like we could do that as like a like a basically like a bucket of hours. And then we can see how long it takes.
226 00:34:29.179 ⇒ 00:34:39.439 Eddie Brophy: We could set up like a like a A Msa agreement. So that say, like, it stops working, or something like that. We could just call you guys, you know, pay you guys per hour to fix it, or something like that.
227 00:34:39.440 ⇒ 00:34:50.799 Uttam Kumaran: That’s exactly what we would do. So like, we probably spend a month or 2 months, get the whole solution developed and then working, and then basically give you guys like, Hey, you have 5. You have 5 or 10 HA month
228 00:34:50.830 ⇒ 00:34:55.330 Uttam Kumaran: to use as you want, and then you can draw down from that at at our hourly rate, so.
229 00:34:55.820 ⇒ 00:34:57.780 Eddie Brophy: Okay, yeah, that’s perfect.
230 00:34:58.160 ⇒ 00:34:58.480 Uttam Kumaran: Okay.
231 00:34:58.480 ⇒ 00:34:58.810 Eddie Brophy: Sick.
232 00:34:58.810 ⇒ 00:35:03.479 Uttam Kumaran: Dude. This is great. This is a dope project. I think we’re gonna nail this. This is like, actually really cool, that.
233 00:35:03.480 ⇒ 00:35:05.099 Eddie Brophy: Yeah, no, that’d be great. It’d be a good one.
234 00:35:05.100 ⇒ 00:35:05.440 Uttam Kumaran: Yeah.
235 00:35:05.440 ⇒ 00:35:06.950 Eddie Brophy: You guys, too, you know.
236 00:35:07.130 ⇒ 00:35:08.760 Uttam Kumaran: Yeah, yeah. Awesome.
237 00:35:09.200 ⇒ 00:35:13.379 Uttam Kumaran: Oh, yeah, okay, let me know. I’m free all week, too. So let me know if you want me to hop back on, or anything.
238 00:35:13.650 ⇒ 00:35:17.829 Eddie Brophy: Okay. Alright, I will get these questions out. I should know in a day or 2. So.
239 00:35:17.830 ⇒ 00:35:19.370 Uttam Kumaran: Okay. Okay. Michelle.
240 00:35:19.630 ⇒ 00:35:20.280 Eddie Brophy: Alright!
241 00:35:20.480 ⇒ 00:35:20.980 Uttam Kumaran: Eyebrow.
242 00:35:20.980 ⇒ 00:35:22.369 Eddie Brophy: Great catching up with you!
243 00:35:22.370 ⇒ 00:35:23.710 Uttam Kumaran: Yeah, I did. I’ll see you soon.
244 00:35:23.980 ⇒ 00:35:25.000 Eddie Brophy: Alright talk to you later.