tslater2006 / dms-viewer Goto Github PK
View Code? Open in Web Editor NEWLicense: MIT License
License: MIT License
steps to reproduce:
See the
end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.*********** Exception Text ************** System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index at System.Collections.ArrayList.get_Item(Int32 index) at System.Windows.Forms.DataGridViewCellCollection.get_Item(Int32 index) at DMS_Viewer.DataViewer.dataGridView1_CellDoubleClick(Object sender, DataGridViewCellEventArgs e) at System.Windows.Forms.DataGridView.OnCellDoubleClick(DataGridViewCellEventArgs e) at System.Windows.Forms.DataGridView.OnDoubleClick(EventArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.DataGridView.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtrlparam)```
steps to reproduce:
expected results:
actual results:
This makes further copy/pasting/spreadsheet comparison difficult since the for the LONG field is no longer contained in a single cell.
suggested label: enhancement
Seems like the cursor defaults to the first record in the list by default (but doesn't highlight it to indicate that).
If you click the white part of the inside of the "records" box but don't succeed in highlighting an actual record row, then clicking "view data" will cause an error.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.************** Exception Text ************** System.ArgumentOutOfRangeException: InvalidArgument=Value of '0' is not valid for 'index'. Parameter name: index at System.Windows.Forms.ListView.SelectedListViewItemCollection.get_Item(Int32 index) at DMS_Viewer.Form1.dataViewer_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
some possible behaviors that can mitigate this:
highlight the default record
clicking the white space should highlight the default record
clicking the whitespace to the right of a record should highlight the record even when it's not really close by
clicking whitespace can deselect all records but view data button should take no action
Both the following navigations present the user with the ability to write a text file to a directory:
Tools > Generate SQL
Tools > Rebuild Script
However, both of them fail to remember the user's selected directory when the same menu option is chosen a second time, or when the user switches between Generate SQL
and Rebuild Script
options.
enhancement request:
suggested label: enhancement
When using the Compare DB feature, it prompts on every record in the list.
It asks again and again whether the same db connection should be reused.
I think the default assumption should be yes.
Perhaps it could ask once for confirmation when you change .dat files?
I'm trying to figure out why the current work flow is as it is.
I'm guessing perhaps it's to accommodate the use case where one is trying to compare one dat file to multiple databases?
That seems worth of handling, but also a seems like it wouldn't be the most common use case.
I think the most common use case is to compare all the records in a .dat file using a single database connection.
That, IMO, more common use case would be better served by defaulting to re-use the connection for the current .dat file.
Going back to the typical presumed used case, comparing all records in a .dat file to a database...
It might be useful to automatically compare all records to DB upon clicking the compare to db button. That could potentially reduce the number of prompts and still prompt people to switch databases each time they click the button.
If we are trying to protect users from comparing a large amount of data by accident, perhaps a different button "compare all records to db" could exist.
suggested label: enhancement
spreadsheet should be saveable to file possibly csv/excel/other?
this could be accomplished via right-click context menu, or some other method.
suggested label: enhancement
"copy record list" button copies text to the clipboard as follows:
ListViewItem: {PSCLOCK}
or
ListViewItem: {PSCLOCK}
ListViewItem: {INSTALLATION}
but it should just copy the actual record name (the part between the curly braces {}).
e.g.
PSCLOCK
or
PSCLOCK
INSTALLATION
suggested label: enhancement
Tools > Rebuild Script
provides a default output directory.
However, Tools > Generate SQL
does not provide a default output directory.
enhancement request:
Tools > Rebuild Script
)suggested label: enhancement
results:
compare works, and colorizes spreadsheet properly
however, does not update color in record list
e.g. compared as yellow/different prior to import
should compare no color after import
but it's still yellow (even though clicking "view data" shows all columns/rows with no color)
FYI, I tested this prior to the commit for Fixed issue with CLOB compares if the field in the DMS was null., and I'm not sure if that already fixed it.
suggested label: bug
The Columns
box shows a list of fields on the record, as well as their type, and size.
However, it would be useful to also display the keys on the record.
e.g. key, search key, alternate search key, etc.
At a minimum, even just "key" would be useful.
I'm have no idea this is data already being provided by the DMSLib library or if it would require new code.
suggested label: enhancement
expected behavior:
actual behavior:
possible solutions:
suggested labels: enhancement
or possibly bug
a) copy/pasting from the spreadsheet view DOES NOT include headers at the top of the columns
b) copy/pasting from the spreadsheet view DOES include an empty column to the left of the data
suggested label: enhancement
It would be useful to Include the name of the open dat file (and posssibly its path) in the header of the DMS Viewer application.
FYI, some modification of the text in the header is already taking place when clicking the "compare to db" button, which appears to show the db name in the header.
This would be helpful to keep track of which .dat file is being opened/viewed/compared when the user has multiple .dat files in need of examination.
suggested label: enhancement
Looking at the SQL generated from a .DAT file, there is no schema prefix.
Since PeopleSoft uses the SYSADM schema, and there is no way to force a DMS script to import to an alternate schema (my assumption), then that should be the default schema.
This would allow search-and-replace script editing for anyone who wants to insert data into a user's private schema for testing/comparison/preservation of data as compared to the ACTUAL tables in the SYSADM schema.
suggested label: enhancement
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.