|
They gave the job to AI.
I’ve given up trying to be calm. However, I am open to feeling slightly less agitated.
I’m begging you for the benefit of everyone, don’t be STUPID.
|
|
|
|
|
That is a fundamental property of the Internet: You cannot rely on information being stable or remain available.
If you really need to have something documented, make a copy of that web page. It may be difficult sometimes; you may have to revert to PrntScrn - Save Page as... may not capture all you want to save. Always check the saved page.
Updating news articles is common practice with web newspapers. Sometimes, when reporting from an ongoing event, they put something along the lines of 'This story will be updated', but often they do not. Often, the 'breaking news' updates the first few paragraphs of the story, but if you read to the bottom, there can be a lot down there that they didn't remember to update - such as 'Due to the car accident, the E6 is closed for all traffic', but the (updated) headline and first few sentences declare 'E6 is now open after having being closed for two hours'.
Sometimes, when revising 'facts', they add a small note indicating that 'A previous version of this story said so-and-so. This has been updated to such-and-such'.
The one newspaper that really p me off was one where I could provoke an update. Officially, they were open to reader comments. If you made a comment that was in conflict with the newspaper's views, the article would be 'updated'. Several times I compared the article as it was at the time when I made my comment, with my comment displayed, showing that it was accepted, with the version marked 'Last updated at ...', and not a single character was changed, except for the 'Last updated' time.
And the list of comments were empty. Each update version had its own chain of comments. So they could pretend to accept disagreeing comments, while wiping unwanted comments by making a no-changes 'update'. If asked, they could present a technical explanation ('Every revision has its own comment chain - that's just how it is!'. And it was true: The new revision got a new URL, so if I saved the URL to the revision I commented on, I could use it to retrieve the version with my unwanted comment still in the comment chain.
I think it is far more honest to simply declare that 'We do not accept comments in disagreement with our views', and either inform the commenter the reason why he was rejected, or leaving an entry in the comment chain indicating that a comment was censored. Preferably both.
|
|
|
|
|
re/ "You cannot rely on information being stable or remain available." i recently learned the Wayback Machine is useful . it even has copies of my own minor website of many years prior .
|
|
|
|
|
If it is "semi-stable", Wayback maybe of use. Often it is not. Observe how many snapshots there is of an article: Sometimes, they come weeks or months apart. Compare the time of the first snapshot with the publication date for the newspaper story: The story may have been through several modifications before the the first Wayback snapshot.
There are lots of web pages not available on Wayback. It crawls from one page to another through links, and if none of its already known pages link to some local web newspaper, Wayback will not discover it. There used to be an entry in Wayback's main page, something like 'Please index this web page!' It may still be somewhere, but I am not sure where (I haven't spent much time looking!)
|
|
|
|
|
trønderen wrote: You cannot rely on information being stable or remain available
This, IMHO, is one the serious deficiencies of Internet (and also its strength). Nothing is cast in stone on the Internet, everything is flaky.
In the days of the hardcopy prints from the printing press, creating a second version was a lot of effort. Now, soft copies can be updated in a trice.
modified 5hrs 5mins ago.
|
|
|
|
|
"You cannot rely on information being stable or remain available."
clap clap - well said sir. Interestingly, for large purchases from Amazon or any other place, I make a screen grab of the deal. I've had several occasions where the terms just change out from the day before as if by magic. It's well know that Amazon uses the shopping model they have built for you and dynamically change prices. I can easily see articles and what not subtly modified.
Charlie Gilley
“They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
Has never been more appropriate.
|
|
|
|
|
I look at it every morning. Rarely read anything.
|
|
|
|
|
dandy72 wrote: Anyone know anything about journalism that can shed some light as to what the real motive might be?
I do not know the details of the updates you see, but there is a case of updates to prevent lawsuit without actually apologize for some accusation or misinformation in the original 'news' - and that because most people will not read an item popped up after weeks or months, just like you, except lawyers...
"If builders built buildings the way programmers wrote programs, then the first woodpecker that came along would destroy civilization." ― Gerald Weinberg
|
|
|
|
|
dandy72 wrote: I'm sure I'm reading too much into this, as the topics in those revised articles are generally rather benign.
If they are just correcting minor details, then I would agree. However, journalistic integrity would still require them to note that a change was made from the original.
Of course, journalistic integrity is very difficult to find these days. 
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
Firstly, I am not asking for help on a programming issue here. I'm mostly just trying to see if anyone else here is or has in the past been experiencing any problems using the ClosedXML .Net library to open/read Excel files.
I have a simple process that has worked every day flawlessly for over 2 years, then out of the blue, started failing.  Basically, ClosedXML was choking trying to open an Excel (*.xlsx) file. By choking, I mean it was an IO exception reporting that the file was corrupted. The weird thing is, I can copy that file to my desktop, open it in Excel, save it, copy it back to the server, and it works fine. 
I am aware that a new version of OpenXML was released (right around the time that my process began failing???) with quite a few breaking changes. Coincidence?...I don't know yet.
What's new in the Open XML SDK | Microsoft Learn[^]
What I've tried:
0: Go to GitHub and get the latest ClosedXML libs. So this required a .net framework upgrade to 4.6+. No problem...compiles, go to open a spreadsheet and it complains about the XMLDocument version...go to GitHub, get that version and try again. It compiles fine, go to open a spreadsheet and now it whines about a netstandard library that it can't find. (sure this is an indication of inccompatibility) I tried different versions/combinations but the only way to get it working again was by reverting back to the original framework and original libraries. Back to square one. 
1: Plead with the new IT guy responsible for scheduling that job to please change the format to CSV!  (the previous IT guy was on a power trip and refused to change it despite numerous requests)
2: Investigating the idea of simply extracting the sheet1.xml file from the archive and parsing it out. Then I wonder why if it was that easy, why there are so few solutions that mention this approach. It's possible that I'm looking at an extremely simple/limited structure (no formulas/formatting/etc.) in this particular file, but it looks feasible. In the event that #1 fails, this will probably be the next path of attack.
3: Install Excel on the customer's server. Ya know, they did give me an admin account so in theory, I can install anything required to get the job done. Also, I have an old Office 2007 disk around here that should still work even if it never gets registered. If 1 and 2 fail, this may be the only option. Not only is it the worst option, but it's also the slowest option. I'd like to avoid this one. 
"Go forth into the source" - Neal Morse
"Hope is contagious"
|
|
|
|
|
kmoorevs wrote: if anyone else here is or has in the past been experiencing any problems using the ClosedXML .Net library to open/read Excel files.
Nope...
.
.
.
.
Never used it.
run, hides and ducks
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
|
|
You can't install Interop on a server because of licencing.
Well you can or used to be able to, but it took couple of registry hacks.
// TODO: Insert something here Top ten reasons why I'm lazy
1.
|
|
|
|
|
Or in our case it wasn't allowed.
|
|
|
|
|
|
I have used it on a number of occasions and it works well.
|
|
|
|
|
|
Thanks, This looks promising!  I've requested the problem file be sent as a csv. Failing that, I'll definitely give it a go. 
"Go forth into the source" - Neal Morse
"Hope is contagious"
|
|
|
|
|
There's also the option to use Excel spreadsheet library for .NET Framework/Core - EPPlus Software[^] . There's a FAQ about licensing, depending on your requirements YMMV.
Luca
The Price of Freedom is Eternal Vigilance. -- Wing Commander IV
En Það Besta Sem Guð Hefur Skapað, Er Nýr Dagur.
(But the best thing God has created, is a New Day.)
-- Sigur Ròs - Viðrar vel til loftárása
|
|
|
|
|
Unless "they" who control the data centers don't allow it on the servers.
|
|
|
|
|
Never used it. What are you trying to do with it?
Because I only needed to read it, I rolled my own XLSX reader.
|
|
|
|
|
I've used NPOI for years without any problems
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
kmoorevs wrote: .net framework upgrade to 4.6+
...
whines about a netstandard library that it can't find
Which version did you actually upgrade to?
.NET Standard 2.0 sort-of works with 4.6.1+, but it has several issues. Microsoft recommend using at least 4.7.2:
.NET Standard - .NET | Microsoft Learn[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I find is amusing that my comments elsewhere (not CP), when it can't be deciphered by AI, needs to go for "review" before it can be released. AI is talking but not really listening.
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
