Summary view: View only most recent entry for all values of a given attribute?, posted by Dennis Seitz on Thu May 17 02:12:52 2007
|
We are using Elog to track status of hardware assemblies. One attribute we've created is the serial number of an assembly. Other attributes are items like "location" and "status". We have set up these latter attributes with presets to make entry easy and keep entries consistent.
I would like to filter the summary view so it only shows me the most recent entry for every value in the serial number attribute. This would be very useful for quickly viewing the present status and location of every assembly, for example.
I can't find a way to do this in the documentation. Is it possible? If not, may I submit a request for this feature?
I am very impressed with the Elog and it has become an essential part of our record keeping. Thank you for a very useful and well implemented application! |
Re: Summary view: View only most recent entry for all values of a given attribute?, posted by Stefan Ritt on Thu May 17 14:02:39 2007 
|
| Dennis Seitz wrote: | | I would like to filter the summary view so it only shows me the most recent entry for every value in the serial number attribute. This would be very useful for quickly viewing the present status and location of every assembly, for example. |
I don't know if that is what you want, but have you tried clicking on the column headings in the summary view to sort the table according to that attribute:
 |
|
Re: Summary view: View only most recent entry for all values of a given attribute?, posted by Dennis Seitz on Fri May 18 02:15:41 2007
|
| Stefan Ritt wrote: |
| Dennis Seitz wrote: | | I would like to filter the summary view so it only shows me the most recent entry for every value in the serial number attribute. This would be very useful for quickly viewing the present status and location of every assembly, for example. |
I don't know if that is what you want, but have you tried clicking on the column headings in the summary view to sort the table according to that attribute:
|
Rather than simply sorting, I would like to actually reduce the number of entries listed to show only the most recent entry for each serial number. In this way, I can see at a glance what the present status of each serial number is. This is similar to Quick Filters but would be a "Most Recent" filter that could be applied conditionally, for example: "Most Recent" -> "By Serial".
Here is the display now:
Here is what I'd like to have the option to view (I used a graphic editor to fake it):
It would also be nice to have the option to then sort the resultant view, for example, to group together all serial numbers that have the same status.
Is this a little clearer? It's just a suggestion - this is not terribly important, but if it were possible I think it would be useful.
Thanks! |
|
Re: Summary view: View only most recent entry for all values of a given attribute?, posted by Stefan Ritt on Fri May 18 08:04:38 2007
|
Ok, now I understand. Well, your request is very special for your case. Usually I implement things only if several independent people ask for it. What you can try is to save your logbook in CSV format, import it into Excel or another spreadsheet program, and achieve the filtering there.
Best regards,
Stefan |
|
Re: Summary view: View only most recent entry for all values of a given attribute?, posted by Dennis Seitz on Fri May 18 16:07:31 2007
|
| Stefan Ritt wrote: | Ok, now I understand. Well, your request is very special for your case. Usually I implement things only if several independent people ask for it. What you can try is to save your logbook in CSV format, import it into Excel or another spreadsheet program, and achieve the filtering there.
Best regards,
Stefan |
OK, I've done that before and it works fine. I'd rather be able to do it in Elog but I understand if it's not worth the effort. It never hurts to ask!
Cheers,
Dennis |
|
Import log, posted by bob on Tue Apr 24 11:00:56 2007
|
Hi,
it is possible to import the file *.log of Elog towards another Elog?
thank you
Bob |
|
Re: Import log, posted by Stefan Ritt on Tue Apr 24 12:26:32 2007
|
| bob wrote: | Hi,
it is possible to import the file *.log of Elog towards another Elog?
thank you
Bob |
There are three methods:
- Copy over the *.log files from one Elog to the other. Make sure not to have entries with the same ID twice then.
- Set-up mirroring between two servers. This ensures a 1:1 copy of the server
- Export entries in CSV format (comma-separated-values) via 'Find', 'Mode = CSV', and do a 'CSV import' on the other side.
|
|
Re: Import log, posted by bob on Tue Apr 24 14:43:07 2007
|
| Stefan Ritt wrote: |
| bob wrote: | Hi,
it is possible to import the file *.log of Elog towards another Elog?
thank you
Bob |
There are three methods:
- Copy over the *.log files from one Elog to the other. Make sure not to have entries with the same ID twice then.
- Set-up mirroring between two servers. This ensures a 1:1 copy of the server
- Export entries in CSV format (comma-separated-values) via 'Find', 'Mode = CSV', and do a 'CSV import' on the other side.
|
thank you,
but the last method (simplest for me) does not import the comment.
it's a pity... |
|
Re: Import log, posted by Stefan Ritt on Thu May 10 13:03:51 2007
|
| bob wrote: | thank you,
but the last method (simplest for me) does not import the comment.
it's a pity... |
Ok, I implemented the XML import which also includes the text body. However there are currently two limitations:
- If you want to import entries which contain replies, it only works if import them into an empty logbook, where the imported entries can obtain the same entry IDs as in the original logbook.
- The names of possible attachments are correctly imported, but not the files themselves. These you have to copy by hand.
|
Change default for suppressing email notification and/or targeting entries manually, posted by Alan Stone on Thu Jun 22 16:01:58 2006
|
I want to change the default for suppressing email notification.
I want to be able to send email to Elog subscribers and to other people
not yet subscribed to the Elog. However, after polling the current
subscribers, they do NOT want to receive email notification for every
new Elog entry by default.
Instead of toggling the "Suppress Email notification", I would like
to toggle "Send Email notification".
I would also like the option to add additional email addresses on the fly.
Thanks in advance for any help.
Alan |
|
Re: Change default for suppressing email notification and/or targeting entries manually, posted by Stefan Ritt on Thu Jun 22 17:19:32 2006
|
| Alan Stone wrote: | I want to be able to send email to Elog subscribers and to other people
not yet subscribed to the Elog. However, after polling the current
subscribers, they do NOT want to receive email notification for every
new Elog entry by default. |
The admin user can change the email subscriptions to all users in the Config page, so you just have to go through each user. Alternatively, you can stop the elog server, change the password file manually in any editor, and then restart the elog server.
| Alan Stone wrote: | | I would also like the option to add additional email addresses on the fly. |
You have to change the config file to add new email addresses or you have to add new users. |
|
Re: Change default for suppressing email notification and/or targeting entries manually, posted by Alan Stone on Thu Jun 22 20:43:39 2006
|
Thank you for your response. I do not think I posed my questions clearly. Let me try a different way.
If I set the following logbook configuration:
Suppress Email to users = 0
then, every time someone makes a new entry to that logbook, all subscribers get an email, unless
someone checks the "Suppress Email notification" box.
I want to preserve the configuration option. However, I want to invert the default check box, so
that no email is sent to subscribers unless someone takes the extra step to check a box which might
read "Send Email notification".
> You have to change the config file to add new email addresses or you have to add new users.
That would not work for non-admins. I was looking for a non-required
"email to/cc/send to" attribute. Obviously, one can just cut and paste
the entry into your email application.
| Stefan Ritt wrote: |
| Alan Stone wrote: | I want to be able to send email to Elog subscribers and to other people
not yet subscribed to the Elog. However, after polling the current
subscribers, they do NOT want to receive email notification for every
new Elog entry by default. |
The admin user can change the email subscriptions to all users in the Config page, so you just have to go through each user. Alternatively, you can stop the elog server, change the password file manually in any editor, and then restart the elog server.
| Alan Stone wrote: | | I would also like the option to add additional email addresses on the fly. |
You have to change the config file to add new email addresses or you have to add new users. |
|
|
Re: Change default for suppressing email notification and/or targeting entries manually, posted by Stefan Ritt on Thu Jun 22 21:02:16 2006
|
| Alan Stone wrote: | | However, I want to invert the default check box, so that no email is sent to subscribers unless someone takes the extra step to check a box which might read "Send Email notification". |
Ahh, now I understand 
Suppress default =1
should do the job. |
|
Re: Change default for suppressing email notification and/or targeting entries manually, posted by Stefan Ritt on Tue May 1 16:54:12 2007
|
| Alan Stone wrote: | | I would also like the option to add additional email addresses on the fly. |
There is a simple way to accomplish this. Define a new attribute, let's call it "cc". Then add to your config file following statement:
Email all = $cc
In you entry form, you can now enter comma-separated email addresses in the CC filed, to which a notification will be sent. |
|
Upgraded from 2.6.1 to 2.6.5, but cannot login now & top.html is not displayed, posted by Alan Stone on Mon Apr 30 20:52:51 2007
|
We followed the simple download instructions. Our existing logbook entries
are still visible. Nothing was lost or touched in our /usr/local/elog directory.
Is there some step we missed?
Alan |
|
Re: Upgraded from 2.6.1 to 2.6.5, but cannot login now & top.html is not displayed, posted by Stefan Ritt on Mon Apr 30 21:01:49 2007
|
| Alan Stone wrote: | We followed the simple download instructions. Our existing logbook entries
are still visible. Nothing was lost or touched in our /usr/local/elog directory.
Is there some step we missed?
Alan |
Have you tried to delete your cookies in the browser and try again?
The location of top.html has been changed from the ELOG root down into the loogbook directory. If you want to keep it in the original location, you have to specify the full path. See the documentation for where to put the file for "Top text". |
How to make a table of contents, posted by Stefan Ritt on Fri Apr 27 14:06:34 2007
|
For those people who have not fully understood the discussion of elog:2218, here is an example table of contents.
First Chapter
The table of contents consists of a set of [url] tags like this:
[url=#first]First chapter[/url]
[url=#second]Second chapter[/url]
[url=#thirs]Third chapter[/url]
Then the chapter header contains a tag like this:
[ANCHOR]first[/ANCHOR]
to which the browser ups if you click the corresponding entry in the table of contents.
... empty lines to full up some space ...
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
Second chapter
You should jump here if you click on Second chapter at the table of contents.
Third chapter
You should jump here if you click on Third chapter at the table of contents. |
|
Is there (planned) support for <A NAME> and <HR /> in ELCODE?, posted by Kevin McCarty on Thu Apr 26 16:43:45 2007
|
Hello,
I am wondering if there is any support (or if not, if it is planned) for inserting HTML <a name> and <hr /> tags via ELCODE. This would be useful for long log messages in order to provide a table of contents and divide them into clear sections. If this support already exists, I'm afraid it is not obvious to me how to access it in ELCODE. If it does not yet exist, would you consider a patch for it?
As a related issue, to support <a name> usefully, it will also be necessary for ELCODE to support things like [url=#tag], which it currently converts to <a href = "http:///#tag"> instead the expected result of <a href = "#tag">.
(Please send me replies also by email at kmccarty AT princeton DOT edu, as I don't check this forum often.)
Thanks for writing ELOG; our group has been using it very productively on our server for the last few weeks.
best regards,
-- Kevin McCarty |
|
Re: Is there (planned) support for <A NAME> and <HR /> in ELCODE?, posted by Stefan Ritt on Fri Apr 27 08:38:58 2007
|
| Kevin McCarty wrote: | | I am wondering if there is any support (or if not, if it is planned) for inserting HTML <a name> and <hr /> tags via ELCODE. |
Very good idea. The horizontal line
is already implemented via [LINE] and the anchor tag will soon follow. |
|
Re: Is there (planned) support for <A NAME> and <HR /> in ELCODE?, posted by Kevin McCarty on Fri Apr 27 08:56:10 2007
|
| Stefan Ritt wrote: |
| Kevin McCarty wrote: | | I am wondering if there is any support (or if not, if it is planned) for inserting HTML <a name> and <hr /> tags via ELCODE. |
Very good idea. The horizontal line
is already implemented via [LINE] and the anchor tag will soon follow. |
Wonderful, thanks!
-- Kevin McCarty |
|
Re: Is there (planned) support for <A NAME> and <HR /> in ELCODE?, posted by Stefan Ritt on Fri Apr 27 13:06:59 2007
|
| Kevin McCarty wrote: | I am wondering if there is any support (or if not, if it is planned) for inserting HTML <a name> and <hr /> tags via ELCODE. This would be useful for long log messages in order to provide a table of contents and divide them into clear sections. If this support already exists, I'm afraid it is not obvious to me how to access it in ELCODE. If it does not yet exist, would you consider a patch for it?
As a related issue, to support <a name> usefully, it will also be necessary for ELCODE to support things like [url=#tag], which it currently converts to <a href = "http:///#tag"> instead the expected result of <a href = "#tag">. |
I implemented anchor tags. You can write something like
[ANCHOR]top[/ANCHOR]
and you can then reference it either by directly entering
http://midas.psi.ch/elogs/Forum/2223#top
or by entering simply
elog:2223#top
To make your table of contents, you can put a complete URL tag like
[URL=http://midas.psi.ch/elogs/Forum/2223#top]Goto top[/URL]
or inside the same entry simply
[URL=#top]Goto top[/URL]
which will be shown as
Goto top
I have added these link again at the bottom of this entry so you can try it with this entry directly.
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
... empty space ...
elog:2223#top |
|
Sorting by column title problem, posted by George Chisholm on Thu Apr 26 22:26:04 2007
|
Hi,
I am implementing ELOG for our Gas Control Centre.
Log entries sort ok when I click the ID or Date column title but not my custom attributes column headers???
Any suggestions?
Where do we send donations?
Best Regards and thanks for writing this very useful app.
George |
|
Re: Sorting by column title problem, posted by Stefan Ritt on Fri Apr 27 08:23:04 2007
|
| George Chisholm wrote: | I am implementing ELOG for our Gas Control Centre.
Log entries sort ok when I click the ID or Date column title but not my custom attributes column headers???
Any suggestions? |
Indeed that was a bug, thanks for reporting it. I fixed it in the intermediate release which you can download at
http://midas.psi.ch/elog/download/windows/elog265-2.exe
| George Chisholm wrote: | | Where do we send donations? |
I have a PayPal account associated with my email address.
- Stefan |
|
sort attributs, posted by deletoille on Wed Mar 14 11:55:54 2007
|
hello,
For 1 event, I need the date and the hour of this one. An event can be enter in elog several days after this one. The problem is that I do not manage to carry out one sorts on these two attibuts. I tested the order “? rsort” but this one works only on one entry not out of 2 at the same time (? rsort=Heure+evenement, Date+evenement&mode=threaded)
have an easy way?
Thank you very much
Xavier Deletoille |
|
Re: sort attributs, posted by Stefan Ritt on Wed Mar 14 12:06:20 2007
|
| deletoille wrote: |
For 1 event, I need the date and the hour of this one. An event can be enter in elog several days after this one. The problem is that I do not manage to carry out one sorts on these two attibuts. I tested the order “? rsort” but this one works only on one entry not out of 2 at the same time (? rsort=Heure+evenement, Date+evenement&mode=threaded)
have an easy way? |
Yepp. Since you can only sort on a single attribute, you combine time and date into one. This can be done like following:
Attributes = Icone, Type def fiche, ..., Evenement
Type Evenement = datetime
Now you can not only sort on Evenement, but you get also a date picker for that attribute in the entry form. To format the way Evenement is displayed, use the Time format option. |
|
Re: sort attributs, posted by deletoille on Wed Mar 21 16:51:14 2007
|
| Stefan Ritt wrote: |
| deletoille wrote: |
For 1 event, I need the date and the hour of this one. An event can be enter in elog several days after this one. The problem is that I do not manage to carry out one sorts on these two attibuts. I tested the order “? rsort” but this one works only on one entry not out of 2 at the same time (? rsort=Heure+evenement, Date+evenement&mode=threaded)
have an easy way? |
Yepp. Since you can only sort on a single attribute, you combine time and date into one. This can be done like following:
Attributes = Icone, Type def fiche, ..., Evenement
Type Evenement = datetime
Now you can not only sort on Evenement, but you get also a date picker for that attribute in the entry form. To format the way Evenement is displayed, use the Time format option. |
thanks, It works but the order "?sort" seems to works only in summary view (attachment 1) and not in threaded (attachement 2) view.
Any idea? |
|
Re: sort attributs, posted by Stefan Ritt on Wed Apr 25 20:29:39 2007
|
| deletoille wrote: | thanks, It works but the order "?sort" seems to works only in summary view (attachment 1) and not in threaded (attachement 2) view.
Any idea? |
Two ideas. First, you have following URL:
.../page?rsort=Date+Evenement
but your attribute is "Evenement" (without "Date"). Can you check that?
Second: In threaded mode, only the "thread heads" are sorted. If an entry has one or more replies, it does not make sense to tear apart these replies because of sorting, so threads are always kept together, independent of their attributes. |