Taking Report Results and Publishing

[jkpalmer]

Hi,

Still pretty "green" when it come to using Flare.

Probably been asked before, so if this is a repeat, I apologize in advance.

I would like to be able to use the Flare > View > Project Analysis > Files With Annotations to generate a CSV and then use that CSV in a table within a topic that I publish to my project.

I would like to display specific columns in my "published" content.

Is this possible? If so, could someone help me with this?

TIA

Jim P.

[Paulie]

Hi Jim,

The short answer is that I don't think this is possible directly within Flare (although you can create and run a report, the look and feel is not tabular).

The longer answer is yes, there is a way to achieve this:

Each Flare project contains a Content9.s3db file in the Analyzer\Content.cadbf folder. This is a SQLite database file that is used by Analyzer (I think) as well as the built-in Flare reports.

You can use a free tool (such as DB Browser for SQLite — http://sqlitebrowser.org) to query the database and get the information that you require. Such a tool will output the results that you require into a table. You can then paste this table into your Flare topic and convert the pasted text into a table.

I'm not the best at SQL (so there might be a cleaner way to do this), but the following query should give you what you require:

Code: Select all

SELECT  f.Path As File ,
 (SELECT aa.Value FROM Attribute aa WHERE aa.FileId = f.Id AND aa.Name='comment'  And aa.Element = a.Element) As Text,
 (SELECT aa.Value FROM Attribute aa WHERE aa.FileId = f.Id AND aa.Name='initials'  And aa.Element = a.Element) As Initials,
 (SELECT aa.Value FROM Attribute aa WHERE aa.FileId = f.Id AND aa.Name='creator'  And aa.Element = a.Element) As Creator,
 (SELECT aa.Value FROM Attribute aa WHERE aa.FileId = f.Id AND aa.Name='creator'  And aa.Element = a.Element) As Editor,
 (SELECT aa.Value FROM Attribute aa WHERE aa.FileId = f.Id AND aa.Name='createDate'  And aa.Element = a.Element) As 'Creation Date',
(SELECT aa.Value FROM Attribute aa WHERE aa.FileId = f.Id AND aa.Name='editDate'  And aa.Element = a.Element) As 'Edit Date'
 
FROM  File f

INNER JOIN Attribute a
ON a.FileId = f.Id


WHERE f.id IN (SELECT FileId FROM Attribute WHERE Attribute.Tag='annotation')
AND a.Name='Comment'

[NorthEast]

It is possible in Flare.

To export a list of files with annotations to a CSV:
1. Go to View > Project Analysis > Files with Annotations.
2. Right-click the list and choose to Export to CSV (or export selection).

To get the CSV content in a topic table:
1. Open the CSV in Excel (or something suitable), and copy the cells you want.
2. Paste into the Flare topic - by default it'll paste it as paragraphs, so select the paste icon and choose Paste Table.

[Paulie]

Thanks Dave. You learn something new everyday!