[ECODP-dev] ODP status call > some questions to be answered.

Wed Oct 2 09:20:14 UTC 2013

Hi Bert,

> On the most viewed dataset view:
>    * does running ckan_clear_activity_table.sh have impact?

No, that is a different database table (which should not written to any
more).

>    * what is exactly counted. Which clicks lead to a number increase (To
be added to the Operations Manual too.)

Unique views (where uniqueness is determined by a hash of the browser, IP
address and language). I will add more details to our operations manual
changes.

>    * what more statistics we can get from CKAN?

That's too broad of a question to answer, can you be more specific?
Statistics about what?

> On user accounts:
>    * are user only be created in lower case or not, what happens when one
is created in upper case?
>      In rel.09.00 it seems that newly created publishers names with upper
case can only login with a user name in lower case...

Uppercase user names should be fine, are they getting an error message?

Regards,
John

On 1 October 2013 16:16, Bert Van Nuffelen
<bert.van.nuffelen at tenforce.com>wrote:

> Hi John,
>
> On the most viewed dataset view:
>    * does running ckan_clear_activity_table.sh have impact?
>    * what is exactly counted. Which clicks lead to a number increase (To
> be added to the Operations Manual too.)
>
>    * what more statistics we can get from CKAN?
>
> On user accounts:
>    * are user only be created in lower case or not, what happens when one
> is created in upper case?
>      In rel.09.00 it seems that newly created publishers names with upper
> case can only login with a user name in lower case...
>
> kind regards,
>
> Bert
>
> -----
>
> source /applications/ecodp/users/ecodp/ckan/conf/backup_restore.conf
>
> if [ -z $RDF2CKAN_UPLOADS_FILES_DIR ] || [ -z "$APPLICATION_FILES_DIR" ]
> || [ -z "$TARGETBACKUPDIR" ] || [ -z "$CKAN_USER" ] || [ -z "$CKAN_PWD" ]
> || [ -z "$POSTGRES_USER" ] || [ -z "$POSTGRES_HOST" ]  ; then
>     echo "configuration variables not proberly set"
>     exit
>     fi
>
> DATE=`date +%Y-%m-%d-%H-%M-%S`
>
> CKANHOME=/applications/ecodp/users/ecodp/ckan
> CKANTMP=/applications/ecodp/users/ecodp/ckan/var/tmp
>
> mkdir -p $CKANTMP
>
> # default value; should not be changed
> DATABASE=ecodp
>
> echo "start clearing activity table"
>
> # Dump the activity tables for prosperity
> pg_dump  -a -t activity -t activity_detail -h $POSTGRES_HOST -U
> $POSTGRES_USER $DATABASE> $CKANTMP/activity_backup_$DATE.sql
> gzip $CKANTMP/activity_backup_$DATE.sql
>
> # Clean their contents
> psql -d $DATABASE -h $POSTGRES_HOST -U $POSTGRES_USER -c 'truncate
> activity, activity_detail;'
>
> echo "finished clearing activity table"
>
>
> --
> 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/20131002/87b27ebc/attachment.html>