Mark Minasi's Tech Forum
Register Calendar Latest Topics
 
 
 


Reply
  Author   Comment  
cspanburgh

Avatar / Picture

Senior Member
Registered:
Posts: 233
Reply with quote  #1 

 

Just like an archaeological dig, when you have to decontruct work done before you it often happens that you make the same mistakes that academics of archaeology make. Often the first evidence they dig up causes them to postulate on all sorts of ideas derived from small pieces of evidence. Some of these ideas even get into text books. I made the same kind of mistake. At the time, I could not reach the remote database through SSMS. Once... I got the DTS authenticated with an OLEDB connection I could see the code in the DTS steps, and by default when I edited them I saw a status field with data that was either "A" or "C". Since I was uploading this data to D365 online, I thought , "This will define active and inactive records, but I did not see that in the mappings. Hmm!!!! Like finding a dead sea scroll, one of the managers at the client found a spread sheet in her email and forwarded it to me. They did not know how to read the "Ancient" script, but when it came into my posession, I saw the Rosetta stone moment. The status field it turns out had nothing to do with the status of the records but rather a field called "RenewalReportFlag" was the field was the determining field for status. Yes, we accepted the new evidence and tested it rather than attacked the evidence in defense of my former theory and the result was positive. Data upserted. ............Never assume.......!!!


__________________
Curt Spanburgh
0
lady_mcse

Avatar / Picture

Senior Member
Registered:
Posts: 100
Reply with quote  #2 
You know what they say about assumptions.  Makes an ass out of you and mpt.
0
donoli

Senior Member
Registered:
Posts: 598
Reply with quote  #3 
That's why I always say presume.
0
cspanburgh

Avatar / Picture

Senior Member
Registered:
Posts: 233
Reply with quote  #4 
Ok, but did you understand the issue of people not completing a project and leaving no documentation behind on what was done, why and how it was done.

The client said "It just never worked" .  Well, isn't that helpful!!!!  And so we strive to figure out the schema of the source database and the functions of the table fields.  

It can be really tough when the company that did the project refuses to talk to you.

__________________
Curt Spanburgh
0
cj_berlin

Avatar / Picture

Senior Member
Registered:
Posts: 273
Reply with quote  #5 
Quote:
Originally Posted by cspanburgh
Ok, but did you understand the issue of people not completing a project and leaving no documentation behind on what was done, why and how it was done.


Understand? No.
Acknowledge that this is the rule rather than an exception? Anytime.

__________________
Evgenij Smirnov

My personal blog (German): http://www.it-pro-berlin.de/
My stuff on PSGallery: https://www.powershellgallery.com/profiles/it-pro-berlin.de/
0
donoli

Senior Member
Registered:
Posts: 598
Reply with quote  #6 
Quote:
Ok, but did you understand the issue of people not completing a project and leaving no documentation behind on what was done, why and how it was done.

It might go beyond that. Let's say the person who actually did the documentation ended up leaving on a bad note. He or she might bury the documentation.
I've seen similar things on a different type of job. For example, in high rise office buildings, some managers would hide the plumbing plan so that he was the only person who knew what to do or where to look when it came to repairs. They thought of it as job security.
0
wobble_wobble

Avatar / Picture

Associate Troublemaker Apprentice
Registered:
Posts: 883
Reply with quote  #7 
Quote:
Originally Posted by cspanburgh
Ok, but did you understand the issue of people not completing a project and leaving no documentation behind on what was done, why and how it was done.



Its a disappointing state of affairs that this comment resonates so far.

But I'm on day 4 of a 2 week positive drive so nothing will or can go wrong.
So for the next week or so, its not a problem its an opportunity to discover new knowledge in an unstructured way.


__________________
Have you tried turning it off and walking away? The next person can fix it!

New to the forum? Read this
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.