Reports

jacky · Post by **jacky** » 18 Sep 2005 15:37

Just a couple of ideas for the reports:

I'd like it if there could be a way to add a new colum with the "contents" information of every folder, like one the General Info from the panel, you know: x files, y folders

Another nice thing would be a way to have "line header" & "line footer" or something like that. Cause I actually use the reports to create HTML files. So I can use </td><td> as separator, but I have to add on each line <tr><td> at the beginning, and </td></tr> at the end....

Post by **admin** » 19 Sep 2005 10:18

Hey, "line header" & "line footer" is very nice. Actually, creating an HTML report is on my personal wish list for some time...

Your first point leaves me a bit confused: please explain.

Post by **admin** » 19 Sep 2005 12:48

FYI, I'm planning do add report templates, which will do what you want and much more.

Here's a first sketch of the report templates structure. We have three sections, header (generated once per report), record (is repeated for every reported file), and footer (generated once per report):

Code: Select all

  $HEADER
    Everything here is header
  $RECORD
    Everything here is a record line, using variables like $Name, $Sizebytes, $Modified, etc. ...
  $FOOTER
    Everything here is footer
  
Additional per-report variables: $Sumbytes, $Countfiles, etc. ...

Here's a very simple example of a report template that will generate a simple report (of all selected files) in HTML-format:

Code: Select all

  $HEADER
    <html><body>
    <table>
  $RECORD
    <tr><td>$Name, $Sizebytes, $Modified</td></tr>
  $FOOTER
    </table>
    $Countfiles found, $Sumbytes bytes, generated $Datenow.
    </body></html>

jacky · Post by **jacky** » 19 Sep 2005 15:58

admin wrote:FYI, I'm planning do add report templates, which will do what you want and much more.

Well, this will be another really great & usefull feature!!

My first point was, right now in reports I can have, for every folders, its name, size, dates.. .but I'd like to have a new "column" that would state how many files & folders are in.
Like if you selected a folder, and go to General Info in the panel; you'll have DOS name, space used, etc and last line is something like:
Contents: 247 files, 18 folders
I wish there was a way to have this in reports as well

Post by **admin** » 19 Sep 2005 18:06

jacky wrote:Contents: 247 files, 18 folders
I wish there was a way to have this in reports as well

Ah ok. This can be part of the new report templates...

To whom it may concern:
This is the time now to make suggestions concerning the report template format I proposed earlier in this thread.
This is the state of affairs now (the $BLAH and $blah stuff are fixed keywords for sections and variables TV3 will use to parse the template):

Code: Select all

  ------------------------------------------------------------------------
  $HEADER [optional]
    report header
  $RECORD
    each record, using field variables like $Name, $Size, $Modified ...
  $RECORD2 [optional]
    each even record (useful for generating alternate color grids)
  $FOOTER [optional]
    report footer
  
  Additional variables (for header and footer): $Sumbytes, $Countfiles ...
  ------------------------------------------------------------------------

jacky · Post by **jacky** » 19 Sep 2005 21:56

Well, i don't know how you're gonna do it exactly; but right now there are 2 kind of reports: Current Folder & Current List.
Are templates gonna be working for both (one template for each of them), or only one of them?

In Current Folder we can choose to include subfolders aswell. Any thought on how this would be working with templates?? Cause if you just reuse the header/footer it will be a mess as there would be made to create one HTML file....
Maybe some kind of "subheader"/"subfooter" would be necessary, so something special can be designed for such case.

Thinking of this, atm we got the current folder done, then its first sub, then second, etc. Would it be possible to get them "inline"

Like:

Code: Select all

[HEADER]
[LINE]Folder One
[LINE2]... SubFolder1
[SUBHEADER]
[LINE]   ... File1
[LINE2]   ... SubSubFolder
[SUBHEADER2]
[LINE]      ... File2
[SUBFOOTER2]
[SUBFOOTER]
[LINE]... SubFolder2
[LINE2]... SubFolder3
[SUBHEADER]
[LINE]   ... File4
[LINE2]   ... File5
[LINE]   ... File6
[SUBFOOTER]
[LINE]... File7
[LINE2]... File8
[FOOTER]

On another note, one thing I'd like is the possibility to scans all subfolders, but only report files. This would allow to make such list:

Code: Select all

Report for D:\My Folder

\SubFolder1\File1
\SubFolder1\SubSubFolder\File2
\SubFolder3\File4
\SubFolder3\File5
\SubFolder3\File6
File7
File8

RalphM · Post by **RalphM** » 19 Sep 2005 22:35

admin wrote:FYI, I'm planning do add report templates, which will do what you want and much more.

Does that mean I won't need my Word template anymore???

If you ever had a look at it, you know what my wishes are - regarding reports.
Actually my wishes were rather formatting matters and I'm looking forward to check out the new report templates.

Post by **admin** » 20 Sep 2005 10:51

jacky wrote:Well, i don't know how you're gonna do it exactly; but right now there are 2 kind of reports: Current Folder & Current List.
Are templates gonna be working for both (one template for each of them), or only one of them?

Actually I would like to combine Current Folder & Current List to one thing -- I never really liked this logically weird "distinction".
I would keep some of the preformatted options (Classic dir dump, CVS, tree structure), probably by having a bunch of hard-coded internal templates to which the user can add her own templates.
Now as I mention "tree structure" it becomes obvious that the template structure must be developed further... Same with your "include subfolders"...

It will be a bigger enterprise to design a real good report template system.
We are approaching TrackerV3 ver 4.10 here!

Post by **admin** » 20 Sep 2005 10:55

RalphM wrote:
admin wrote:FYI, I'm planning do add report templates, which will do what you want and much more.
Does that mean I won't need my Word template anymore???

If you ever had a look at it, you know what my wishes are - regarding reports.
Actually my wishes were rather formatting matters and I'm looking forward to check out the new report templates.

I had a look at it and I will have another one, thanks for reminding me

Will the Word template be superfluous then? TV3 will certainly not create Word-files but only ASCII-based formats like txt, cvs, html files.

Creat · Post by **Creat** » 22 Sep 2005 20:59

admin wrote:
RalphM wrote:
admin wrote:FYI, I'm planning do add report templates, which will do what you want and much more.
Does that mean I won't need my Word template anymore???

If you ever had a look at it, you know what my wishes are - regarding reports.
Actually my wishes were rather formatting matters and I'm looking forward to check out the new report templates.
I had a look at it and I will have another one, thanks for reminding me

Will the Word template be superfluous then? TV3 will certainly not create Word-files but only ASCII-based formats like txt, cvs, html files.

I actually don't know what type of template for word he wanted exactly, but since word can import HTML files he will mose likely be able to create a HTML-Template that does exactly what he wants once it's imported into Word.

just BTW: there are many controls that are able to give you RichText formated output (CRichEchtCtrl for example), but since HTML is more powerful than RTF, he'll probably be able to do the same or more with HTML...

Back to the templates: Will you include IF statements? that will let you select the record-line that a certain record should use as his template depending on his own attributes?

Maybe it's a bit hard to describe, I'll make it clear with an example:

Code: Select all

$HEADER [optional]
report header
$RECORD
$if( recordfield(modified) < today )
each record, using field variables like $Name, $Size, $Modified ... 
$elseif( reccount() > 1000 )
use smaller lines f. ex.
$else
somethingcompletelydifferentfromabove
$endif
$FOOTER [optional]
report footer

this would for example make it possible to create thumbnailed previews, if you make the filetype (or filetype group, like image, video or something) - and maybe even a possibly cached thumbnail locatin - queryable (is that even a word? ah well you get what I mean

.

just an idea though, I wouldn't necessarily use it since I have almost no use for reports, but others might...

bye
Creat

RalphM · Post by **RalphM** » 22 Sep 2005 23:38

Creat wrote:I actually don't know what type of template for word he wanted exactly...

I didn't want a word template, I once created one to get nice formatted reports of directory contents.
See the following forum topic: http://www.trackerv3.com/forum/viewtopic.php?t=234

Post by **admin** » 28 Sep 2005 10:16

Creat wrote:Will you include IF statements?

That was the point when I thought: damn, why did I start this reports templates thing?!

Reports templates is still in my head... but I wait for more ideas to dripple in and will sit down on it when the time is ripe.

Leopoldus · Post by **Leopoldus** » 13 Nov 2005 12:57

If you do want to get more suggestions from users, you should to implement HTML report feature as the first step, even without templates etc advanced options. I think that advanced ideas will come when we'll get a basic practice of using HTML reports in general.

Post by **admin** » 13 Nov 2005 18:08

Leopoldus wrote:If you do want to get more suggestions from users, you should to implement HTML report feature as the first step, even without templates etc advanced options. I think that advanced ideas will come when we'll get a basic practice of using HTML reports in general.

True. But bad timing. Got to finish some other open ends first...

jacky · Post by **jacky** » 15 Nov 2006 01:50

Ok, bumping this for a couple of reasons:

- Just to bump it a little in your long to-do list

Cause this would be a really nice addition I beleive

- Not completely related but ; Seems it can't be done, allthough I was sure at least the "Info to Clipboard/Extended File Info" would: on pictures or movies & co, we can't have the infos that XY knows (width x height, duration, etc) Would be great if we could, and also as variables in the future reports

(I know, would slow down the process, but may be really usefull, and those infos would only be needed if vars are used anyways)

- Extended File Info still: the first line is always "Name :" for me, as in with no name

XYplorer Beta Club

Reports

Reports

Re: Reports

Re: Reports

Re: Reports

Re: Reports

Re: Reports

Re: Reports

Re: Reports

Re: Reports

Re: Reports