!CognosComparer.accdb: Difference between revisions
Ttenbergen (talk | contribs) Created page with "{{PAGENAME}} is a tool to import a range of Cognos dumps for comparison. It gets huge and is slow, so we can't just keep a running tally in there, but this allows analysis of..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 6: | Line 6: | ||
== Instructions == | == Instructions == | ||
It's a utility, so no niceties... | It's a utility, so no niceties... | ||
The program can handle about 6 weeks worth of data; further fine-tuning of column sizes might improve that. | |||
Find VBA function '''saveReportFilesFromMail()''', update the dates and possibly .pst file to pull from, and run it manually. | Find VBA function '''saveReportFilesFromMail()''', update the dates and possibly .pst file to pull from, and run it manually. | ||
If puts the data into table '''CognosReports'''. The table has a column that contains the date and time of the email with the dump file. Then queries can be run against it... | If puts the data into table '''CognosReports'''. The table has a column that contains the date and time of the email with the dump file. Then queries can be run against it... | ||
== Log == | |||
* 2022-12-06 - added ClientGUID to the table structure and decreased various field sizes from default 255 to 100 to be able to import more data. | |||
== Related articles == | == Related articles == | ||