We would like to be able to query quarterly reports in some sort of orderly fashion so that we can generate some good graphs and statistics from them. With the improved copy/paste support, we can easily copy the information to a spreadsheet, like excel, but since the information is sheet (quarter) oriented, we can't graph it directly. Obviously, we could move things around in Excel, but it would be nice if we could query the information directly in MLS.
I don't yet have a list of all the information that will be wanted, but some sort of reporting mechanism that might work with this would be nice.
But... as that feature isn't yet available, does anybody happen to have a quick way to make the information more useful?
A couple of things came to my mind:
- Write a script which takes the copy/pasted data from the quarterly reports and dumps it into a database.
- Use a JDBC connection to query the data directly from MLS