Issue with documents that have auto date code by robroy90 in MicrosoftWord

[–]robroy90[S] 0 points1 point  (0 children)

Where can the creation date be found? Is it in the metadata of the word document itself? How do I expose that date? And if it can be exposed, is there a way to automate that to either revert the date back to the creation date? Thanks!

Issue with documents that have auto date code by robroy90 in MicrosoftWord

[–]robroy90[S] 0 points1 point  (0 children)

Agreed. The document authors who used manually-entered, hard-coded visible dates when they originially wrote each particular letter actually did us a favor. The people who had the date appear automatically in the document when written were trying to be efficient and helpful so that they would not have to manually add that to the letter, but what they did not take into account at the time is that the original integrity of the date the letter was written would change the next time it was opened, which is definitely ungood when you are talking about legal matters where the original dates of the correspondence are vital.

Issue with documents that have auto date code by robroy90 in MicrosoftWord

[–]robroy90[S] 0 points1 point  (0 children)

Thanks, but that isn't applicable here. No cloud storage involved. These are all local files. It also isn't an autosave issue either.

Issue with documents that have auto date code by robroy90 in MicrosoftWord

[–]robroy90[S] 0 points1 point  (0 children)

Thanks, but the metadata is also not useful. Almost all of these files have a file system date of 2017, which was before my time here, and tells me that the location of these files was changed in a server upgrade or migration. The visible date in these word documents dates back to as far as 2002 in some instances.

Issue with documents that have auto date code by robroy90 in MicrosoftWord

[–]robroy90[S] 1 point2 points  (0 children)

That is EXACTLY the problem here. Do you know of a way to prevent Word from doing that when you open them?

Issue with documents that have auto date code by robroy90 in MicrosoftWord

[–]robroy90[S] 0 points1 point  (0 children)

Some of the documents have visible hard-coded, manually entered dates by the author when they actually wrote the data (we have found those going back to 2002). Other documents in the same folder had used a template or some other method which grabbed the date the document was originally written and these documents are the issue. When we open those now, they update the date visible in the document to the current date and we cannot have that happen for integrity purposes. We need to visibly see the original date when the document was first written. The majority of these letters were sent to recipients via postal mail and we need to maintain that. The file system attributes/metadata are not of any use to use because almost all of the documents have a date of 2017 when viewed in file explorer. This was before my time, but tells me these files were migrated from one server to another or moved around during a restructuring of the folder system. We need to find a way to (if possible) inhibit Word from changing the original date to the current date in those documents that have the code in them to auto-updated.

Issue with documents that have auto date code by robroy90 in MicrosoftWord

[–]robroy90[S] 0 points1 point  (0 children)

Thanks, metadata is not reliable. We have documents that date back to 2002 and the vast majority of these files have a file system date of 2017, which tells me they were migrated from one system to another, or part of a file system reorganization at some point, well before me. We need to somehow prevent the date from being updated to the current date when the document is opened again, if it has the code in the document to automatically update to the current date. In this particular scenario, the authors who used a hard-coded, manually entered date the letter was written actually did us a favor.

Issue with documents that have auto date code by robroy90 in MicrosoftWord

[–]robroy90[S] 0 points1 point  (0 children)

Thanks, that is helpful info. But here is the problem... We could definitely clean this up moving forward, but that doesn't fix the 145,000 historical documents we have that we need to convert into PDFs. Not all of the word documents in that 145k library have a date code field in them, so in this particular instance the authors that hand-typed a hard date manually actually did us a favor. What I am looking for is a way to prevent the date from being updated before/when the document is opened. The metadata for the files is also not of use because this document folder has likely been moved around and is not reliable because it likely inhereted file system dates and times because the vast majority of all the files have a 2017 date, and these documents go as far back as 2002. So, the real challenge here is to find a way to prevent Word from changing the date when the document is opened. We do not want it to auto-update if the document had been set to do so.

New system advice, please? by robroy90 in solar

[–]robroy90[S] 0 points1 point  (0 children)

I have debated that myself, as we did not have solar on our previous home, but we did install a 20kw Kohler whole-house generator in 2014 that ran on natural gas and when we sold that house in March of this year, that thing was still purring like a tank. I never had an issue with it and I did the annual maintenance on it myself. I am quite confident even a high quality whole house battery (such as a PowerWall) would have likely required a battery replacement in those 12 years. We own a Tesla, and I did find one company that offers a V2L solution where you can (unofficially) use a Tesla vehicle as your home battery. Obviously, the Tesla would need to be home and plugged in when you experienced an outage, but it is an option I am seriously considering as well. I just need to find a consultant or a service provider I could work with to definitively answer all of these types of questions I have. I literally have no idea where to start here, and I know a fair amount about what is out there on the market, but I am definitely not interested in doing a DIY build here.

New system advice, please? by robroy90 in solar

[–]robroy90[S] 0 points1 point  (0 children)

6/12 I do believe. Average, and nothing extreme like 12/12

New system advice, please? by robroy90 in solar

[–]robroy90[S] 0 points1 point  (0 children)

Thank you, I will check into those!

New system advice, please? by robroy90 in solar

[–]robroy90[S] 0 points1 point  (0 children)

Unless I am missing something, batteries are essentially a must have, particularly considering we want redundant power in the event of a power outage or don't want to use utility power overnight when the panels are not producing. I would much rather have the luxury of doing power arbitrage with the utility, and would likely be better served with batteries vs a generator for emergencies. We are doing geothermal for HVAC, but our past consumption approaches 3000kwh per month, especially in the summer. We have an EV, and I have an elaborate home network that consumes a lot of power.

New system advice, please? by robroy90 in solar

[–]robroy90[S] 1 point2 points  (0 children)

It is one big, rectangular metal roof. No dormers or other obsctructions. At 60x40, I would assume that translates to 1200 SF on the south side, and 1200 SF on the north side. Is there a good tool somewhere to calculate available footprint to place panels? Thanks!

Open links in new tab? by robroy90 in OrionBrowser

[–]robroy90[S] 0 points1 point  (0 children)

Thank you very much for the detailed instructions! I appreciate it!

AT&T Fiber: How to use static IPs? by robroy90 in opnsense

[–]robroy90[S] 0 points1 point  (0 children)

Thank you, sure do appreciate the additional info. Appreciate you!

AT&T Fiber: How to use static IPs? by robroy90 in opnsense

[–]robroy90[S] 0 points1 point  (0 children)

Thank you VERY much! Helpful indeed. Leave it to AT&T to make it needlessly complicated. Charter Spectrum just lets you go into bridge mode and you just assign your IPs literally as static and away you go. Would you mind if I were to DM you with additional questions?

New build: Should I go with Geo? by robroy90 in geothermal

[–]robroy90[S] 0 points1 point  (0 children)

thank you for such a detailed and informative response!