Initail understanding of GSoC Idea: KDE Reports

[Ben Cooksley]

On Thu, Mar 13, 2014 at 8:11 AM, Yash Ladia <ladiayash at gmail.com> wrote:

> Hello Ahmed,
>

Hi Yash,


>
> I have studied the idea (probably yours) on the idea page. Before I can
> make a formal proposal I need your confirmation on a few things: My
> understanding is you want a site like:
> [image: Inline image 1]
> Is this it?
>
> I have seen that currently, the reports page fetches data from the
> projects.kde.org site form the xml file:
> http://projects.kde.org/kde_projects.xml . This seems like a fairly easy
> method to implement for the other reports as well. However, I could not
> find a similar xml file in the forum.kde.org repository. Does it exist?
> If it does not shall I create it?
> I could not find out how the kde_projects.xml file is being created. Will
> this be possible to implement the other websites?
>

Only projects.kde.org should be producing such an XML file. Other sites
will have their own methods of accessing and retrieving data (such as the
forum's RSS feeds) which will have to be utilised instead.


>
> Or, should I query the databases of the websites to fetch the data. The
> commands itself would be easy to write but I would need (thought only read)
> access to the databases, which would be possible probably only by ssh. A
> connection would be needed to be set up from the reports server to severs
> of other websites (forum, news, planetkde, dot) so that these queries can
> be made and results can be fetched.
>

The databases themselves will not be directly accessible.


>
> Or, I have another idea, but seems a little hacky: subscribe to the RSS
> feeds on the reports server and make reports from them. Also, though I
> haven't researched much, the following stack overflow answer seems possible
> to implement:
>
> http://stackoverflow.com/questions/15464979/how-to-fetch-rss-feeds-from-yahoo-finance-page-and-show-in-my-rails-app
> Our server would need to subscribe to the RSS feeds and then parse every
> feed that is received.
>
> These few ideas are in my order of preference. Which one would you prefer,
> or you have something in different in your mind altogether?
>
> Moreover, (probably a trivial problem) I cannot find any repository for
> news.kde.org, planetkde.org or dot.kde.org. Please refer me to them or to
> how can I access the data they provide, unless we are going with the RSS
> feed parsing idea ;-)
>

PlanetKDE is an instance of Rawdog - it produces static HTML/RSS feeds only.
news.kde.org and dot.kde.org are the same site - it is a Drupal 7 instance.


>
> Thanking you,
> Yash Ladia.
>

Thanks,
Ben Cooksley
KDE Sysadmin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.kde.org/mailman/private/kde-www/attachments/20140313/14266c96/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot from 2014-03-12 23_31_34 (1).png
Type: image/png
Size: 130940 bytes
Desc: not available
URL: <https://mail.kde.org/mailman/private/kde-www/attachments/20140313/14266c96/attachment-0001.png>