Re: [Koha-devel] log file of activities for admin of koha in the library

2016-07-21 Thread rania azad mohammed 
Oh that's great, I will do the necessary modification then I will posted
back for the benifit of everyone, or you can added in the sql report
Will be back to you soon
Thanks again

On Thursday, 21 July 2016, Michael Hafen  wrote:

> Ok, for the Guided Reports the SQL will be something like:
>
> SELECT al.timestamp AS DateAndTime,b.surname,b.firstname,module,action
> FROM action_logs AS al LEFT JOIN borrowers AS b ON user = b.borrowernumber
> WHERE user <> 0 AND al.timestamp BETWEEN <>
> AND <> ORDER BY b.surname,b.firstname,al.timestamp
>
> You may want to adjust the order by with asc or desc qualifiers on the
> timestamp.
>
> But this only works for periods where you have the logging enabled, and
> only for those modules that are enabled.  For example I don't see
> circulation when I run that SQL because I don't have logging enabled for
> that module.
>
> On Thu, Jul 21, 2016 at 4:46 AM, rania azad mohammed <
> rania.a...@auis.edu.krd
> > wrote:
>
>> Oh I see,
>> Can you help me on building the SQL query since I don't have a lot of
>> knowledge with SQL? simple report on librarian activities circulation,items
>> and cataloguing with date and time will be perfect
>>
>>
>>
>> On Wed, Jul 20, 2016 at 7:48 PM, Michael Hafen > > wrote:
>>
>>> The action_logs table in the database could hold that information if you
>>> have turned on logging in the system preferences (
>>> http://translate.koha-community.org/manual/3.22/en/html-desktop/#logs).
>>> There is a Log Viewer in Tools that may be useful for getting information
>>> from this table, or you can try building an SQL Report by hand.
>>>
>>> On Tue, Jul 19, 2016 at 11:45 PM, rania azad mohammed <
>>> rania.a...@auis.edu.krd
>>> > wrote:
>>>
 Dear

 We are 3 admins in the library working on shifts in the library, each
 of us log-in during her time. I want a report or log file to see all the
 activities of each admin during a specific day. is there such report or
 file? I tried to find it using the wiki but hopeless

 --

 *Regards,*


 *Rania Azad |* Library Manager
 Library Department
 http://library.auis.edu.iq/
 The American University of Iraq, Sulaimani
 Office:
 *B-G-32* Ext *1219*



 ___
 Koha-devel mailing list
 Koha-devel@lists.koha-community.org
 
 http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
 website : http://www.koha-community.org/
 git : http://git.koha-community.org/
 bugs : http://bugs.koha-community.org/

>>>
>>>
>>>
>>> --
>>> Michael Hafen
>>> Washington County School District Technology Department
>>> Systems Analyst
>>>
>>>
>>
>>
>> --
>>
>> *Regards,*
>>
>>
>> *Rania Azad |* Library Manager
>> Library Department
>> http://library.auis.edu.iq/
>> The American University of Iraq, Sulaimani
>> Office:
>> *B-G-32* Ext *1219*
>>
>>
>>
>
>
> --
> Michael Hafen
> Washington County School District Technology Department
> Systems Analyst
>
>

-- 

*Regards,*


*Rania Azad |* Library Manager
Library Department
http://library.auis.edu.iq/
The American University of Iraq, Sulaimani
Office:
*B-G-32* Ext *1219*
___
Koha-devel mailing list
Koha-devel@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Re: [Koha-devel] log file of activities for admin of koha in the library

2016-07-21 Thread Michael Hafen 
Ok, for the Guided Reports the SQL will be something like:

SELECT al.timestamp AS DateAndTime,b.surname,b.firstname,module,action FROM
action_logs AS al LEFT JOIN borrowers AS b ON user = b.borrowernumber WHERE
user <> 0 AND al.timestamp BETWEEN <> AND <> ORDER BY b.surname,b.firstname,al.timestamp

You may want to adjust the order by with asc or desc qualifiers on the
timestamp.

But this only works for periods where you have the logging enabled, and
only for those modules that are enabled.  For example I don't see
circulation when I run that SQL because I don't have logging enabled for
that module.

On Thu, Jul 21, 2016 at 4:46 AM, rania azad mohammed <
rania.a...@auis.edu.krd> wrote:

> Oh I see,
> Can you help me on building the SQL query since I don't have a lot of
> knowledge with SQL? simple report on librarian activities circulation,items
> and cataloguing with date and time will be perfect
>
>
>
> On Wed, Jul 20, 2016 at 7:48 PM, Michael Hafen 
> wrote:
>
>> The action_logs table in the database could hold that information if you
>> have turned on logging in the system preferences (
>> http://translate.koha-community.org/manual/3.22/en/html-desktop/#logs).
>> There is a Log Viewer in Tools that may be useful for getting information
>> from this table, or you can try building an SQL Report by hand.
>>
>> On Tue, Jul 19, 2016 at 11:45 PM, rania azad mohammed <
>> rania.a...@auis.edu.krd> wrote:
>>
>>> Dear
>>>
>>> We are 3 admins in the library working on shifts in the library, each of
>>> us log-in during her time. I want a report or log file to see all the
>>> activities of each admin during a specific day. is there such report or
>>> file? I tried to find it using the wiki but hopeless
>>>
>>> --
>>>
>>> *Regards,*
>>>
>>>
>>> *Rania Azad |* Library Manager
>>> Library Department
>>> http://library.auis.edu.iq/
>>> The American University of Iraq, Sulaimani
>>> Office:
>>> *B-G-32* Ext *1219*
>>>
>>>
>>>
>>> ___
>>> Koha-devel mailing list
>>> Koha-devel@lists.koha-community.org
>>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>>> website : http://www.koha-community.org/
>>> git : http://git.koha-community.org/
>>> bugs : http://bugs.koha-community.org/
>>>
>>
>>
>>
>> --
>> Michael Hafen
>> Washington County School District Technology Department
>> Systems Analyst
>>
>>
>
>
> --
>
> *Regards,*
>
>
> *Rania Azad |* Library Manager
> Library Department
> http://library.auis.edu.iq/
> The American University of Iraq, Sulaimani
> Office:
> *B-G-32* Ext *1219*
>
>
>


-- 
Michael Hafen
Washington County School District Technology Department
Systems Analyst
___
Koha-devel mailing list
Koha-devel@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Re: [Koha-devel] log file of activities for admin of koha in the library

2016-07-21 Thread Michael Hafen 
I don't think those patches will effect Rania's request for reports. Though
adding the interface column will be a nice feature.

On Jul 21, 2016 9:55 AM, "Tomas Cohen Arazi"  wrote:

> This patches will improve it and are worth testing do they get pushed :-)
>
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16829
>
> El mié., 20 jul. 2016 13:48, Michael Hafen 
> escribió:
>
>> The action_logs table in the database could hold that information if you
>> have turned on logging in the system preferences (
>> http://translate.koha-community.org/manual/3.22/en/html-desktop/#logs).
>> There is a Log Viewer in Tools that may be useful for getting information
>> from this table, or you can try building an SQL Report by hand.
>>
>> On Tue, Jul 19, 2016 at 11:45 PM, rania azad mohammed <
>> rania.a...@auis.edu.krd> wrote:
>>
>>> Dear
>>>
>>> We are 3 admins in the library working on shifts in the library, each of
>>> us log-in during her time. I want a report or log file to see all the
>>> activities of each admin during a specific day. is there such report or
>>> file? I tried to find it using the wiki but hopeless
>>>
>>> --
>>>
>>> *Regards,*
>>>
>>>
>>> *Rania Azad |* Library Manager
>>> Library Department
>>> http://library.auis.edu.iq/
>>> The American University of Iraq, Sulaimani
>>> Office:
>>> *B-G-32* Ext *1219*
>>>
>>>
>>>
>>> ___
>>> Koha-devel mailing list
>>> Koha-devel@lists.koha-community.org
>>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>>> website : http://www.koha-community.org/
>>> git : http://git.koha-community.org/
>>> bugs : http://bugs.koha-community.org/
>>>
>>
>>
>>
>> --
>> Michael Hafen
>> Washington County School District Technology Department
>> Systems Analyst
>>
>> ___
>> Koha-devel mailing list
>> Koha-devel@lists.koha-community.org
>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>> website : http://www.koha-community.org/
>> git : http://git.koha-community.org/
>> bugs : http://bugs.koha-community.org/
>
> --
> Tomás Cohen Arazi
> Theke Solutions (https://theke.io )
> ✆ +54 9351 3513384
> GPG: B2F3C15F
>
___
Koha-devel mailing list
Koha-devel@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Re: [Koha-devel] log file of activities for admin of koha in the library

2016-07-21 Thread Tomas Cohen Arazi 
This patches will improve it and are worth testing do they get pushed :-)

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16829

El mié., 20 jul. 2016 13:48, Michael Hafen 
escribió:

> The action_logs table in the database could hold that information if you
> have turned on logging in the system preferences (
> http://translate.koha-community.org/manual/3.22/en/html-desktop/#logs).
> There is a Log Viewer in Tools that may be useful for getting information
> from this table, or you can try building an SQL Report by hand.
>
> On Tue, Jul 19, 2016 at 11:45 PM, rania azad mohammed <
> rania.a...@auis.edu.krd> wrote:
>
>> Dear
>>
>> We are 3 admins in the library working on shifts in the library, each of
>> us log-in during her time. I want a report or log file to see all the
>> activities of each admin during a specific day. is there such report or
>> file? I tried to find it using the wiki but hopeless
>>
>> --
>>
>> *Regards,*
>>
>>
>> *Rania Azad |* Library Manager
>> Library Department
>> http://library.auis.edu.iq/
>> The American University of Iraq, Sulaimani
>> Office:
>> *B-G-32* Ext *1219*
>>
>>
>>
>> ___
>> Koha-devel mailing list
>> Koha-devel@lists.koha-community.org
>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>> website : http://www.koha-community.org/
>> git : http://git.koha-community.org/
>> bugs : http://bugs.koha-community.org/
>>
>
>
>
> --
> Michael Hafen
> Washington County School District Technology Department
> Systems Analyst
>
> ___
> Koha-devel mailing list
> Koha-devel@lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/

-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha-devel mailing list
Koha-devel@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Re: [Koha-devel] log file of activities for admin of koha in the library

2016-07-20 Thread Michael Hafen 
The action_logs table in the database could hold that information if you
have turned on logging in the system preferences (
http://translate.koha-community.org/manual/3.22/en/html-desktop/#logs).
There is a Log Viewer in Tools that may be useful for getting information
from this table, or you can try building an SQL Report by hand.

On Tue, Jul 19, 2016 at 11:45 PM, rania azad mohammed <
rania.a...@auis.edu.krd> wrote:

> Dear
>
> We are 3 admins in the library working on shifts in the library, each of
> us log-in during her time. I want a report or log file to see all the
> activities of each admin during a specific day. is there such report or
> file? I tried to find it using the wiki but hopeless
>
> --
>
> *Regards,*
>
>
> *Rania Azad |* Library Manager
> Library Department
> http://library.auis.edu.iq/
> The American University of Iraq, Sulaimani
> Office:
> *B-G-32* Ext *1219*
>
>
>
> ___
> Koha-devel mailing list
> Koha-devel@lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/
>



-- 
Michael Hafen
Washington County School District Technology Department
Systems Analyst
___
Koha-devel mailing list
Koha-devel@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/