Content-Type: multipart/alternative; boundary="_000_787FAEC94123984293205DC78AD7C2C811EBAA3B29garnet1dudeak_" --_000_787FAEC94123984293205DC78AD7C2C811EBAA3B29garnet1dudeak_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Pete, Thanks for the information about Kettle. I'll check it out. Regards, Joe From: Peter Newman [mailto:Peter.Newman@cdu.edu.au] Sent: Wednesday, 5 August 2009 11:17 AM To: fez-users@lists.sourceforge.net Subject: Re: [Fez-users] Regular reports from Fez/Fedora Hi Joe We have been using a tool called Kettle or Pentaho Data Integration which i= s a tool also capable of ETL. One benefit of Kettle is that is runs as a j= ava app which means it does not need to be installed using administrator ac= cess and can run in any OS. It is easy to build transformations and export and import them into the app= lication. Also it is possible to use a database repository to store and ma= nage these transformations centrally. So it should be also possible to sha= re and colloborate on reports via the wiki. The software is very robust too - we've been using it primarily to generate= ERA submissions (Australian Government Research reporting) through a 2 st= ep process - generating spreadsheets for review (SQL queries) and then comb= ining the spreadsheets into an XML submission file. The second step involv= es XML fragment building, XSLT, XML joins and some javascript at the end to= fix the namespaces as I could not get XML namespaces to work natively. Some pictures of how they look (hope the email list can handle this): Preparation step: [cid:image001.jpg@01CA1673.25E6E720] Submission building step: [cid:image002.jpg@01CA1673.25E6E720] Cheers Pete ________________________________ From: Joseph Heaphey [mailto:joseph.heaphey@deakin.edu.au] Sent: Wednesday, 5 August 2009 9:53 AM To: fez-users@lists.sourceforge.net Subject: [Fez-users] Regular reports from Fez/Fedora Hi all, Has anyone done any work on regular reports for fez/fedora (whether as part= of fez or using other tools)? Here are some examples: * report of security set on objects (e.g. whether it inherits secur= ity from parent, who can see it, edit it, etc.) * list of work added or amended by a specific user between specific= dates * count and list of objects added between specific dates * report of broken urls. So far we have just done ad hoc reporting (using various combinations of SQ= L, perl, xslt, and php), at times using the fez database and at other times= having to pull data from fedora. Ideally, we would like a way for at leas= t some of these reports to be run by non-technical staff. Does anyone have= any experience with this or ideas about it? Regards, Joe --_000_787FAEC94123984293205DC78AD7C2C811EBAA3B29garnet1dudeak_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi Pete,

 =

Thanks for the informati= on about Kettle.  I’ll check it out.

 =

Regards,

Joe

 =

 =

From: Peter Newman [mailto:Peter.Newman@cdu.edu.au]
Sent: Wednesday, 5 August 2009 11:17 AM
To: fez-users@lists.sourceforge.net
Subject: Re: [Fez-users] Regular reports from Fez/Fedora<= /span>

 

Hi Joe

 

We have been using a tool called Kettle or Penta= ho Data Integration which is a tool also capable of ETL.  One benefit of Kettle is that is runs as a java app which means it does not need= to be installed using administrator access and can run in any OS. 

 

It is easy to build transformations and export and import them = into the application.  Also it is possible to use a database repository to store and manage these transformations centrally.  So it should be also possible to share and colloborate on reports via the wiki.=

 

The software is very robust too - we've been using it primarily to generate ERA submissions (Australian Government Research reporting)  through a 2 step process - generating spreadsheets for review (SQL queries) and then combining th= e spreadsheets into an XML submission file.  The second step involves XM= L fragment building, XSLT, XML joins and some javascript at the end to f= ix the namespaces as I could not get XML namespaces to work natively.

 

Some pictures of how they look (hope the email list can handle this):

 

Preparation step:

 

 

Submission building step:

 

 

 

 

Cheers

Pete

 

 


From: = Joseph Heaphey [mailto:joseph.heaphey@deakin.edu.au]
Sent: Wednesday, 5 August 2009 9:53 AM
To: fez-users@lists.sourceforge.net
Subject: [Fez-users] Regular reports from Fez/Fedora
         report of security set on objects (e.g. whether it inherits security from parent, who can see it, edit it, etc.)

·         list of work added or amended by a specific user between specific da= tes

·         count and list of objects added between specific dates

·         report of broken urls. 

 

So far we have just done ad hoc reporting (using vario= us combinations of SQL, perl, xslt, and php), at times using the fez database = and at other times having to pull data from fedora.  Ideally, we would lik= e a way for at least some of these reports to be run by non-technical staff.&nb= sp; Does anyone have any experience with this or ideas about it?

 

Regards,

Joe

 

 

 

--_000_787FAEC94123984293205DC78AD7C2C811EBAA3B29garnet1dudeak_--