Alright, I just created a generic message with the EagleView login information. I also created a small flow that if the credentials are shared with somebody else, that they are either let me know or send an email to EagleView at MagentaConstruction.com with the subject shared credentials with, first name, last name, and in the body include the first name, last name, and email address. This way we can keep track of who has access to the account, and in case they become compromised, like if their computer, you know, they get some kind of malware or something, we can keep track and we can know that, hey, we should probably change the EagleView password, or at the same time, if the member leaves the company, then we know, okay, we've got to change the password. This will also give us a list that we can use to redistribute the new credentials once they've been changed. I went into EagleView as well and just checked something, I took a screenshot, I informed them that they should use the send a copy of the report to, to have an email copied to themselves so they're not checking the shared mailbox. I sent it to Daphne and to Dylan. I also followed up with EagleView support, I sent them a quick email because we should have Canadian pricing, but when I'm doing the order, it seems to be showing up in US, I just wanted to confirm if that was, in fact, in fact, good or not, and I'm going to send them a quick email right now because it says there's four total orders and two pending, but I can't seem to pull them up at all, even going back a couple of years, so I, I got to take a look at that, custom since 2020, let's say, yeah, it's not showing anything, so I'm going to see if they can get that linked, fixed, or cleaned up or something. And then I just sent two emails to EagleView at MagentaConstruction.com, so that I myself am following the instructions and, and I just sent an email, shared credentials with Dylan LaFrance and shared credentials with Daphne Bacon.

I'm just hopping on the phone with Daphne to see if I can figure out how to make backups of this ePlans because we're no longer going with the subscription, but she just called and I don't know if she hung up or if there was a problem with the system so I'm going to look it up and see if there's something wrong.

All right, I looked through some of these E-Plan files, so Daphne said that it would probably take two months to migrate everything over. E-Plans, from what I found, is using FIC file extension. So essentially, I'm gonna break this down into a couple notes here below of how it works, but in the end, it would be a little bit difficult to migrate them. But yeah, Daphne said that it would take two months to move them all over, so possibly, you know, maybe creating a script to import it. But I did reach out to Bluebeam to see if they have a way to import this stuff, and I am gonna reach out to E-Plans again. I just, I don't think that they were too thrilled that we weren't gonna be renewing, so I didn't get a reply, or maybe they're just busy. But in the next message here, I'll explain the differences between the software.

So Bluebeam works by creating a layered PDF. And so all the annotations or all the measurements and takeoffs that are done are actually just saved as a new layer on a PDF with point coordinates specified for each of the layers. And so I just got an email here from, from the Eagle View. Anyways, so that's how Bluebeam works. And it's actually very smart to do it that way. It saves a scale somewhere, which I haven't found in there, but I'm sure it's in one of the layers or maybe it's in the metadata. Actually, I didn't check the metadata, but I'm sure that there is probably somewhere. It wouldn't be hard to extract all the data for that. It's a very smart kind of system that they implemented there. E-Plans does things different. So in the next note, I'll document how E-Plans does it. Oh, and Bluebeam, yeah. So once you edit that PDF, the changes are made to the PDF. So it's pretty much like a glorified PDF editor that just adds layers and sets a scale and then just does some calculations. The data becomes very portable that way. Very smart idea actually to do that. Super smart idea to do that because all the information is contained in the PDF. So even if you end up leaving after, you still have that data and you could probably manipulate it somewhere. But I think the values in terms of square footages and linear footages, I think that's actually calculated in the software itself. So you wouldn't have the recalculation ability, but at least you'd have the PDF with the areas that you could click on. Very interactive. I like Bluebeam a lot actually, the way that they structured the software.

Eplans, on the other hand, these French guys, so it looks like they're using a development kit called WinDev. WinDev claims to be an IDE that you can develop applications for cross-platform a lot quicker and easier. Maybe it's good, I've never used it. It is an IDE, I'm sure I could figure it out, I don't really want to look into it. It looks like it's French-based as well. But WinDev promotes using HFSQL, which is, I think, Hyperfile SQL, it's a different database system. Let me just look this up here. Yeah, it's a Hyperfile database, which is an SQL-based one, and that's okay. I guess that's why they did that, because the IDE, the WinDev IDE that they're using enables that. I don't know. That's kind of out of my realm. It looks like they support other databases as well, like Oracle SQL, and SQL would have a flat file. Oh yeah, they do have SQLite. I don't know why these French guys from Eplans decided to use Hyperfile SQL, when they could have just done SQLite. I don't understand. Anyways, that's what they did, that's what they did. So it looks like Eplans, what they do, is they take the PDF, they save it in a folder, they save it in a folder called Plans, so I assume that contains the pages. Then there is a backup folder, a save folder, which I assume the save is probably, I don't know, the file name is points underscore, looks like a numeric date, and then probably some kind of a time, and it's using the .fic extension, which is associated with the Hyperfile database. But then in the main folder, they have a bunch of different things, like scale.fic, which seems to be small, and they have scale.ndx, I'm not sure what the ndx is, gromacs index, so probably an index for the database, an ndx file is an index file used by previous versions of Dbase, a popular database management system, it is associated with the database dbf file, and contains pointers to data stores in the database, so it's just an index file, so technically you don't even need that, it's just to optimize performance, I guess is all...

But, yeah, essentially how ePlans works is, yeah, they create that folder for the plans, they put the PDF plan in there, it imports into their software, and then they use all these hyperfile databases, and I assume points.fic file, that end up defining the points that were selected on the plan, and then I'm sure that there's a page plan, FIC, page over. One of those will control the rotation of the page, and the other is, again, scale. So I'm sure they're all in the settings. I would need to get a hyperfile database viewer because I can't open it right now, and it's all going to be query-based, so I think JetBrains has one that has DataGrip that I could probably use, that might be able to help. If not, I would have to try to deploy hyperfile database server something. I think. I don't know. I've never done the hyperfile. It is an SQL-based one, so I could interact with it because it's standard SQL, but I'm just not sure. I would have to just figure out how to get started. I might be able to make a script that would take the PDF, take the settings. I'd have to discover what settings control the rotation of the page, and then how the points work, and how they're organized, so I'd have to see the database. I'm kind of blind right now. A smart way would have been that each of the points are labeled to a page, and I assume because it doesn't modify the PDF, it would be smart for the points to be rendered off of the original plan, not off of any rotated pages, so if you rotated a page in ePlans, it should still go off the standard rotation. That's Troy calling. One sec.

All right, so just getting back to that, yeah, so that's what I think that they do. I won't know too much before I kind of go into it, but I'd have to see what the database data contains so that I'd understand exactly what's going on. But that's how I think that they layer things, which is very inefficient, in my opinion. The layered PDFs is a much smarter idea. Such a simple solution, actually. I don't know why these guys wanted to do things differently, but probably because they're using that WinDev, that's probably all that they could do. So technically, could I do it? Yeah, if I could read the file and there's a consistent file format, I could create a script that will take the project, take the PDF, import the PDF, rotate the pages as required, read the scale. I'd have to figure out how to set the scale in the portable PDF version. But once that's done, then the points, I assume, would just be the points. And assuming that they would probably have a page number that they belong to, and then an X and Y coordinate on where they start. Maybe even they have point groups. I think I may have seen something here, CFG groups. It sounds like configuration groups instead, but maybe the points are just using some kind of an array to store the data. I'm not sure, but I assume that that's what it would be, and then I'm sure that the points would even have the information. So then it would just be a matter of converting the points into PDF layers. So I would import the PDF and then add PDF layers based on the coordinates and on the scaling of the project. I'm hoping that the scaling would work properly, and then export it as one PDF. And then we should be able to technically open them in Bluebeam. Not sure how long it would take to do any of that. I'd have to look into everything first, see how the database is structured. I know generating the PDF files, if I do that in a cloud-based solution, like I make a web app that's more comfortable for me, it would be pretty easy to do. It's just a matter of how this...

Now I'm just going to update the IVR menu to add t3con to the 3152666 member.

All right, I just finished updating the IVR menu. It's done. I'll have to wait until it's open to test exactly, because it's going to go to the off position. And, yeah. So it's anyways, it's done. And I'm just going to clean up, because I documented what I was doing, because it's very, very complicated stuff. But it should be good. Good now. I'm just going to sign in for a message. This is getting really hard to maintain. It's too many options going on right now. So anyways, it's done. I think I'm going to finish too. It's six o'clock.

Alright, I'm going to finish for today. I just closed everything down, checked my emails for the last time. I don't know why I'm getting so burnt out by the end of the day. I'm even taking vitamins. I really don't know what's going on, but my face is flushed. I think I drank enough water today. I think I slept too much. I think I'm sleeping too much. I think that's really the issue. My face feels flushed. And my room doesn't feel that hot. It feels like it's probably 19.5 or 20. Ok Google, what's the temperature in the office? Yeah, stop listening. Yeah, it's not that hot. My arms feel fine, but my face is absolutely flushed. I don't know. I ate breakfast. I've been taking supplements. I really don't know what's going on, but I feel flushed and it's like wind burnt. I don't know why I feel wind burnt. My hands are cold and I'm putting them on my face and it feels amazing. Right now I'm going to go have a cold shower I guess. I need to figure it out because I know this stuff slows me down while I'm working and I really don't know what it is. Anyways, Bluebeams replied back, doesn't sound like they have a tool to migrate stuff from ePlans. And Eagleview, I asked them about the Canadian billing to confirm with that. I think they tried to pawn the question off to AI because the answer that I got was, if you go to our .ca website, there is a link at the bottom to switch between English and French, which has nothing to do with what I had sent them in the chat. I was asking to confirm if we're getting billed in Canadian or US because she said that there was a Canadian dollar module or something enabled for us, but I'm absolutely not sure. What's going on? I sent them a screenshot as well, but I guess they probably didn't look at it. Anyways, I got to finish for today because I am toast.

Oh, I forgot to sign out. Yeah, I don't know. My mind doesn't feel like much though. I just feel wind burnt. I wonder, and it's felt like this yesterday and a couple of days. I wonder if it may be something to do with the posture that I'm sitting on or, I mean, I was talking with Daphne and not Caroline, Daphne today. And then yesterday I was talking, wait, today's Friday? Oh, two days ago, Wednesday, I was talking with Sam. Thought I was talking with somebody yesterday too, but maybe, I don't know. This used to happen back in the day when I was running my business. It was a very slow day where I was waiting for stuff, like, hmm, yeah, I don't know, I'll have to figure it out. Anyways, I'm gonna punch out now. Just got up from my chair.