StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Thanks for all the feedback.</p> <p>I do not have any index's unfortunately. I will give a little more information about my situation.</p> <p>We have a reporting program (replaced Crystal reports) that is installed in 7 Servers across EU. These servers have many reports on them (not all the same for each country). They are invoked by a commandline application that uses XML files for their configuration. So One XML file can call multiple reports.</p> <p>The commandline application is scheduled and controlled by our overnight process. So the XML file could be called from multiple places.</p> <p>The goal of the CSV is to produce a list of all the reports that are being used and where they are being called from.</p> <p>I am going through the XML files for all references, querying the scheduling program and producing a list of all the reports. (this is not too bad).</p> <p>The problem I have is I have to keep a list of all the reports that might have been removed from production. So I need to compare the old CSV with the new data. For this I thought it best to put it into DataTables and compare the information, (this could be the wrong approach. I suppose I could create an object that holds it and compares the difference then create iterate through them).</p> <p>The data I have about each report is as follows:</p> <p>String - Task Name String - Action Name Int - ActionID (the Action ID can be in multiple records as a single action can call many reports, i.e. an XML file). String - XML File called String - Report Name</p> <p>I will try the Merge idea given by MusiGenesis (thanks). (rereading some of the posts not sure if the Merge will work, but worth trying as I have not heard about it before so something new to learn).</p> <p>The HashCode Idea sounds interesting as well.</p> <p>Thanks for all the advice.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload