Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG, Page 440 of 808  Not logged in ELOG logo
    icon2.gif   Re: Report Generating Tool?, posted by Hal Goldfarb on Tue May 22 06:55:21 2018 

I don't see an "export" option in the documentation, only "import."  Printing the web page is probably not what I want.

Stefan Ritt wrote:

Switch to the "summary" display (try it with this forum). You get headers (like "category"). Clicking on it sorts by that attribute. Then display "all" entries, or use the "find" option to search in certain time periods, then just print the web page.

Alternatively, expeort logbook entries as CSV files, load them into a spreadsheet program, and do the sorting and printing there.

Stefan

Hal Goldfarb wrote:

Has anyone developed a report tool for elog?  I would like to be able to sort certain items and send them to either a printer, or an email (external to my own use).

If not, any ideas on an easy means of doing this?  I write a lot of Perl, so that would be an option for me if the text is easily obtained.

Thanks

 

 

    icon2.gif   Re: Report Generating Tool?, posted by Stefan Ritt on Tue May 22 11:11:43 2018 

Click on "Find", select "Export to CSV", optionally select filter criteria, then press "Search".

Stefan

Hal Goldfarb wrote:

I don't see an "export" option in the documentation, only "import."  Printing the web page is probably not what I want.

Stefan Ritt wrote:

Switch to the "summary" display (try it with this forum). You get headers (like "category"). Clicking on it sorts by that attribute. Then display "all" entries, or use the "find" option to search in certain time periods, then just print the web page.

Alternatively, expeort logbook entries as CSV files, load them into a spreadsheet program, and do the sorting and printing there.

Stefan

Hal Goldfarb wrote:

Has anyone developed a report tool for elog?  I would like to be able to sort certain items and send them to either a printer, or an email (external to my own use).

If not, any ideas on an easy means of doing this?  I write a lot of Perl, so that would be an option for me if the text is easily obtained.

Thanks

 

 

 

icon5.gif   both "email <attribute> <value" and "email all" at the same time, posted by Stefano Lacaprara on Wed May 23 14:44:08 2018 
Hi, 
  I have an elogbook which sends notifications to subscribers, plus, if the "Type" is "New Run", it sends the notification to a different mailing addeess and with a different subject (which need to be parsed by 
a script, but that's not relevant). All works fine: the snippet of config is below.

Attributes = Subject, Author, Type
Options Type = New Run{1}



Email All = all@experiment.org
Use Email Subject = [demo] $Subject from $Author

Email Type "New Run" = new-run@experiment.org
{1} Use Email Subject = NEWRUN

However, I'd like that the notification is always sent to all@experiment.org for all entries with the standard subject, and *also* to new-run@experiment.org in case of new run with the customized one.
Apparently with the config that I'm using this is not happening, and the "new run" are only sent to new-run@experiment.org (w/ subject NEWRUN).
I could easily add the generic address in addition to new-run@experiment.org, ie:

Email Type "New Run" = new-run@experiment.org, all@experiment.org

but in this case the subject would be "NEWRUN", while I'd like it to be "[demo] $Subject from $Author".

Any idea about how this can be done?

thanks in advance, Stefano
    icon2.gif   Re: Report Generating Tool?, posted by Andreas Luedeke on Wed May 23 16:19:48 2018 

Here's a little example for a query for this logbook:

curl -f -s -k "https://elog.psi.ch/elogs/Forum/?jcmd=Search&mode=CSV1&last=7&Category=^Question%24"

You can easily process this output with perl, to create reports. I use it for example to create counts for specific enties, like "Bug reports" that are not "closed", and show the results in some other user interfaces.

Cheers, Andreas

Stefan Ritt wrote:

Switch to the "summary" display (try it with this forum). You get headers (like "category"). Clicking on it sorts by that attribute. Then display "all" entries, or use the "find" option to search in certain time periods, then just print the web page.

Alternatively, expeort logbook entries as CSV files, load them into a spreadsheet program, and do the sorting and printing there.

Stefan

Hal Goldfarb wrote:

Has anyone developed a report tool for elog?  I would like to be able to sort certain items and send them to either a printer, or an email (external to my own use).

If not, any ideas on an easy means of doing this?  I write a lot of Perl, so that would be an option for me if the text is easily obtained.

Thanks

 

 

icon5.gif   shiftcheck restrict edit, posted by Xuan Wu on Thu May 24 08:53:50 2018 

Hi all,

There are options "Restrict edit" and "Restrict edit time" for general logbooks, but it seems not work for shiftcheck logbook. I think the function only author can change their own entry is necessary for shiftcheck too. Any suggestion would be hightly appreciated.

Cheers,

Xuan

    icon2.gif   Re: Enabling SSL, posted by Stefan Ritt on Tue Jun 5 12:28:27 2018 

This comes from the openSSL library which elog includes. I tried myelf and found that a chained certificate is not correctly interpreted by the openSSL library. Most people anyhow don't use SSL inside elog, but run an Apache server in front of elog. This is anyhow better since Apache has an industry-strength security with regular updates. Much better than relying on OpenSSL.

Stefan

Pasti wrote:

Hi all, 

I'm following config guide and so far so good. The only issue I run into is when enabling SSL.

Guide says - One can replace this certificate and key with a real certificate to avoid browser pop-up windows warning about the self-signed certificate.

Can you please tell me a more details regards this part? I have acquired security certificate and replaced contents of SSL folder. 

Now elogd.exe gets error 1067.

Any help would be highly appreciated.

Thanks!

 

    icon2.gif   Re: shiftcheck restrict edit, posted by Xuan Wu on Wed Jun 6 02:41:32 2018 

Is there a way to restrict other author to edit the custom input form submitted?

Xuan Wu wrote:

Hi all,

There are options "Restrict edit" and "Restrict edit time" for general logbooks, but it seems not work for shiftcheck logbook. I think the function only author can change their own entry is necessary for shiftcheck too. Any suggestion would be hightly appreciated.

Cheers,

Xuan

 

icon5.gif   html mode with preset text template cannot be read by newly updated MS-Edge browser, posted by utomoadji wisnubroto on Wed Jun 6 18:25:32 2018 

i have elog tab configuration with preset text as follow :

=====================================================================

[Shift Entry]
Theme = corp2
Comment = Shift Entry
Page title = Shift Entry
List page title = Shift Entry

Display mode = summary
Default encoding = 2

;admin and user settings
admin user = tom
login user = tom, secretary, senior, engineer
login expiration = 2

;Menu Displays settings
Find menu commands = List, New, Find, Select, Logout, admin
menu commands = List, New, Edit, Reply, Find, Move to

List display = Schedule-remarks, Schedule-Month, Author, Site, Status, Approval, Suggestion, Reason Not-Approved

Move to = Sr-Shift for Check

;Attributes Settings

Attributes = Schedule-remarks, Schedule-Month, Author, Site, Checked-by, Status, Approval, Suggestion, Reason Not-Approved, Email to

Hidden Attributes = Email to

Options Schedule-remarks = Initial, Revision 1, Revision 2, Revision 3, Revision 4, Revision 5, Revision 6

Type Schedule-Month  = date
# Type Schedule-Month End = date

Date format = %B, %Y

comment Schedule-Month = This Schedule is applied for 1 corresponded Month 

Roptions Author = mike, daniel, tom

Options Site = Chicago, Bangkok

Required Attributes = Schedule-remarks, Schedule-Month, Author, Site

Roptions Status = Need-Check, Checked, Pending, Need-Revision

Roptions Approval = Approved, Rejected, Pending, Need-Approval


preset Status = Need-Check
preset on edit Status = Need-Check
preset on Reply Status = Need-Check

preset Approval = Need-Approval
preset on edit Approval = Need-Approval
preset on Reply Approval = Need-Approval

Locked Attributes = Checked-by, Suggestion, Reason Not-Approved, Status, Approval
Fixed Attributes Edit = Status, Approval
Fixed Attributes Reply = Status, Approval

Cell Style Status Checked = background-color:#0dcf00
Cell Style Status Pending = background-color:yellow
Cell Style Status Need-Revision = background-color:red
Cell Style Status Need-Check = background-color:grey

Cell Style Approval Approved = background-color:#0dcf00
Cell Style Approval Rejected = background-color:red
Cell Style Approval Pending = background-color:yellow
Cell Style Approval Need-Approval = background-color:grey


;email settings
Email all = $EMail to
Use Email Subject = SoC Sr Controllers Shift Schedule Plan
Use Email Heading = New SoC Sr Controllers Shift Schedule Plan $Schedule-Month <br><br>
Use Email Heading edit = SoC Sr Controllers Shift Schedule Plan $Schedule-Month <br><br>Has been Edited<br><br>


preset text = shift.html

==============================================================================================================================

I'm using that page to upload employee schedule in elog, and i copy-paste the schedule from excel table with color into the page.

The only browser that allow me to do above activity was only Microsoft Edge, it can keep the excel rich color table smooth and stayed with the color when i paste it.

If i'm doing above activity using different browser such as Firefox or chrome , everytime i paste the color rich excel table , the color always missing and only the text that pasted on the page.

But recently i update my Windows 10 and the Microsoft Edge browser also updated, and since that i the microsoft edge browser cannot read the "preset-text" template anymore and the page just blank.

Can you help

 

Thank you and regards


 

ELOG V3.1.5-3fb85fa6