[ECODP-dev] Fwd: feedback from OKF - most viewed datasets

Mon Oct 7 10:28:49 UTC 2013

Hi Bert,

John is away today so we'll come back to you on this tomorrow when he's
back. However as previously discussed the best way to resolve this issue
will be to deploy release 01.00 as this issue doesn't exist in that
release.

Best,

Darwin

*Darwin Peltan*

*Project Manager  |  skype: darwinp  |  twitter:
@darwin<http://twitter.com/darwin>
*

*The Open Knowledge Foundation <http://okfn.org/>*

*Empowering through Open Knowledge*

*http://okfn.org/  |  @okfn <http://twitter.com/OKFN>  |  OKF on
Facebook<https://www.facebook.com/OKFNetwork> |
Blog <http://blog.okfn.org/>  |  Newsletter<http://okfn.org/about/newsletter>
*
*
CKAN | http://ckan.org | @ckanproject <http://twitter.com/ckanproject>
|open source data management platform
*

On 7 October 2013 08:07, Bert Van Nuffelen
<bert.van.nuffelen at tenforce.com>wrote:

> Hi John,
>
> can you answers PO question?
>
> kind regards,
>
> Bert
>
> ---------- Forwarded message ----------
> From: SABETE Vafa (OP) <Vafa.SABETE at publications.europa.eu>
> Date: 2013/10/6
> Subject: RE: feedback from OKF - most viewed datasets
> To: "ZAJAC Agnieszka (OP)" <Agnieszka.ZAJAC at publications.europa.eu>, Bert
> Van Nuffelen <bert.van.nuffelen at tenforce.com>, "MEYER André (OP-EXT)" <
> Andre.MEYER at ext.publications.europa.eu>
> Cc: "PASTOR CAMARASA José Juan (OP)" <
> Jose.PASTOR-CAMARASA at publications.europa.eu>, jurgen vannerom <
> jurgen.vannerom at tenforce.com>, OPDL ODP <opdl-odp at publications.europa.eu>
>
>
>  Dear Agnieszka,****
>
> I forwarded the issue to André to run the sql script. It's a "select" so
> there will be no harm in production.****
>
> ** **
>
> Dear André,****
>
> Please check Jira issue ODP-291 and run the sql command in production and
> send the result.****
>
> ** **
>
> Dear Bert,****
>
> OKF added the following remark concerning the sql:****
>
> *[OKF:] The problem here seems to be the line 'AND tracking_date = ...',
> which is selecting the global max instead of the most recent max for a
> given dataset.*
>
> Therefore what should be the corrected sql to execute?****
>
> ** **
>
> Best regards,****
>
> Vafa****
>
> ** **
>
> ** **
>
> ** **
>
> *From:* ZAJAC Agnieszka (OP)
> *Sent:* Friday, October 04, 2013 4:20 PM
> *To:* 'Bert Van Nuffelen'
>
> *Cc:* PASTOR CAMARASA José Juan (OP); SABETE Vafa (OP); jurgen vannerom;
> Project list for EC ODP CKAN project
> *Subject:* RE: feedback from OKF - most viewed datasets****
>
>  ** **
>
> Hello Bert,****
>
> ** **
>
> Thank  you for it. Although I don't think we can make test on prod and
> test will be unavailable soon for install of 1.00.****
>
> ** **
>
> Vafa,****
>
> Any ideas how to deal with it?****
>
> ** **
>
> Regards,****
>
> Agnieszka ****
>
> ** **
>
> *From:* Bert Van Nuffelen [mailto:bert.van.nuffelen at tenforce.com<bert.van.nuffelen at tenforce.com>]
>
> *Sent:* Friday, October 04, 2013 9:46 AM
> *To:* ZAJAC Agnieszka (OP)
> *Cc:* PASTOR CAMARASA José Juan (OP); SABETE Vafa (OP); jurgen vannerom;
> Project list for EC ODP CKAN project
> *Subject:* Re: feedback from OKF - most viewed datasets****
>
> ** **
>
> Hi Agnieszka,****
>
> I updated for that the Jira ticject.****
>
> kind regards,
>
> Bert****
>
> ** **
>
> 2013/10/3 ZAJAC Agnieszka (OP) <Agnieszka.ZAJAC at publications.europa.eu>***
> *
>
> Hello Bert,****
>
>  ****
>
> Thank you for this clarification. However, the question still remains why
> the list is completely new every day while, according to OKF, it should
> reflect the accumulative counting of views since the last reset of the
> database. Has this issue been investigated, too?****
>
>  ****
>
> Best regards, ****
>
>  ****
>
> *Agnieszka Zając*****
>
> Open Data Portal Section****
>
> Tel: +352 2929.42834****
>
>  ****
>
> *From:* Bert Van Nuffelen [mailto:bert.van.nuffelen at tenforce.com]
> *Sent:* Thursday, October 03, 2013 3:19 PM
> *To:* ZAJAC Agnieszka (OP); PASTOR CAMARASA José Juan (OP); SABETE Vafa
> (OP)
> *Cc:* jurgen vannerom; Project list for EC ODP CKAN project
> *Subject:* feedback from OKF****
>
>  ****
>
> Hi Vafa,****
>
> here are answers to the next questions:
>
> Q: The most views count measures what?
> A: Unique views (where uniqueness is determined by a hash of the browser,
> IP address and language)****
>
> Q: does ckan_clear_activity_table.sh has impact on the most viewed items?*
> ***
>
> A: No, that is a different database table (which should not written to any
> more).****
>
>  ****
>
> kind regards,****
>
> Bert****
>
>
> --
> Bert Van Nuffelen
>
> Semantic Technologies Software Architect at TenForce
> www.tenforce.be
>
> Bert.Van.Nuffelen at tenforce.com
> Office: +32 (0)16 31 48 60
> Mobile:+32 479 06 24 26
> skype: bert.van.nuffelen ****
>
>
>
>
> --
> Bert Van Nuffelen
>
> Semantic Technologies Software Architect at TenForce
> www.tenforce.be
>
> Bert.Van.Nuffelen at tenforce.com
> Office: +32 (0)16 31 48 60
> Mobile:+32 479 06 24 26
> skype: bert.van.nuffelen ****
>
>
>
> --
> Bert Van Nuffelen
>
> Semantic Technologies Software Architect at TenForce
> www.tenforce.be
>
> Bert.Van.Nuffelen at tenforce.com
> Office: +32 (0)16 31 48 60
> Mobile:+32 479 06 24 26
> skype: bert.van.nuffelen
>
> _______________________________________________
> Ecodp-dev mailing list
> Ecodp-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ecodp-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ecodp-dev/attachments/20131007/55094075/attachment.html>