Smart Reports

[MEndres]

Hi All,

The basics of Flare's report generator are nice, however the format is very unreadable and for complex projects it's too confusing to be worthwhile.

Is there a way to output Flare's report in a format that can be imported into a spreadsheet?

Instead of:

Count: 48

Condition: Default.ThisCondition

File: Content/Folder/File.htm
Tag: div
Tag: p



It would be much nicer to have, at the minimum, a sorted spreadsheet in a format like:

|| Condition || File || Tag ||

[owilkes]

Hi,

Have you tried generating to browser, copying all this into XL and then just splitting apart using cell formula

Column A = raw content from report
Column B = =LEFT(Ax,4) |<- this just tells you if the info is Link or File
Column C = =IF(Bx="File",Ax,Cx-1) <- If column is File, show the File information - otherwise, show value from above cell (which would have link information)
Column D = =IF(Bx="Link",Ax,Dx-1) <- If column is Link, show the link information - otherwise, show value from above cell (which would have link information)

This way - in a row you have the content, and the link to that content.

[MEndres]

Cheer Owilkes! This works very well and is exactly what I'm after.


-Michael