when i use database tabanalys and redirect the out to an excel file i get overlaped fields i donot know how to set the each data in each fields so i can compare and view
Stephanie,
I just use an ABL program to input from a db/tabanalys file and import line by line. The data you care about (table stats) is bracketed by "RECORD BLOCK SUMMARY" and "RM block(s) found in the database.". The table line items begin with "PUB.", so you can import those and discard the rest. Note that long table names can cause a line wrap so you have to account for that. Export the data to a .csv file and from there it's easy to import into Excel.
Note that once you get to 11.x there are a few format changes in the report, e.g. some changes for multi-tenancy and the fact that system tables are now prefixed with "PUB.". So in that case application tables begin with "PUB." but not with "PUB._".
balaji,
If you can post a bit more detail about what you have tried (maybe including a relevant snippet of code) and what issues or errors you're seeing then we may be able to help.
What command are you using to create the output? And what do you mean by overlapped fields? Can you supply a screenshot at all?
Oh and whilst you're at it, your Progress version might be useful too :)
> I would love to be able to take the output of our Db analysis/table analysis and create Excel docs to help track trends
> of some of our tables & DBs...
Not that it helps with the OP or right now, but 11.4 db/tab analysis has or rather will have an output to csv.
Stephanie,
I just use an ABL program to input from a db/tabanalys file and import line by line. The data you care about (table stats) is bracketed by "RECORD BLOCK SUMMARY" and "RM block(s) found in the database.". The table line items begin with "PUB.", so you can import those and discard the rest. Note that long table names can cause a line wrap so you have to account for that. Export the data to a .csv file and from there it's easy to import into Excel.
Note that once you get to 11.x there are a few format changes in the report, e.g. some changes for multi-tenancy and the fact that system tables are now prefixed with "PUB.". So in that case application tables begin with "PUB." but not with "PUB._".
balaji,
If you can post a bit more detail about what you have tried (maybe including a relevant snippet of code) and what issues or errors you're seeing then we may be able to help.
Stephanie,
In a previous role, I've successfully used a set of libraries from Alon Blich (who wrote the "Progress Standard Libraries" that you may have seen on OEHive) to do output to Excel from CHUI code.
The libraries work by writing natively in the Office Open XML format without needing to run an instance of Excel.
We had no problems in producing rich ".xlsx" Excel files on our Linux servers (e.g. inserting Progress data into spreadsheets with pivot tables/graphing).
The library project itself seems to be no longer visible on OEHive, I suggest contacting Alon to ask about it www.linkedin.com/.../alonblich
> I manually monitor many things currently about our 16 DBs. It's just getting increasingly time consuming to do so manually.
Have you looked at a commercial solution like OE Management or ProMonitor?
> The library project itself seems to be no longer visible on OEHive [...]
Enjoy!
When we used the libraries in our product, we ended up purchasing a licence that let us modify the source & keep our modifications closed.
I don't know which direction Alon took with it in the end.
I believe it might have been turned into a closed-source commercial offering.
I would recommend contacting Alon for details - he was very approachable when I was dealing with him
Alon *was* going to go commercial, but it is a long time since that was supposed to happen, so I imagine he has been busy.
Has anybody a copy of the now unavailable source code of OEHive?
Alon Blich <alonblich@gmail.com>