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

[Bert Van Nuffelen]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ecodp-dev/attachments/20131007/e4f11f83/attachment.html>