Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG, Page 283 of 806  Not logged in ELOG logo
IDdown Date Icon Author Author Email Category OS ELOG Version Subject
  67536   Tue Jun 4 17:16:32 2013 Reply UlfOulf.olsson@dynamate.seQuestionWindows2.9.2-2455Re: Filter and sorting

Stefan Ritt wrote:

UlfO wrote:

Stefan Ritt wrote:

UlfO wrote:

Hi,

We have a fire preventive team at our company doing periodic inspections of our various corporate buildings.

If they find a deviation they want to register this somewhere.

So I thought E-log would be nice to use in this case.

The way the fire preventive team inspection works is building by building.

All the buildings has numbers.

So they want to be able to select a buildingnumber in E-log and filter on open,ongoing and closed records when they do their inspections.

And they also wants the filtering to stay on that choosen buildingnumber  despite if they delete or add new entries.

I know that you can have a default startview in E-log but this view is static.

Is it possible to do this in E-log?

You can define the building number as an attribute and use it in a quick filter. The startview will however not stay on one bilding. An alternative would be to define one logbook per building. 

 OK!

Thanks for the answer.
I thought that this was the way to go. The problem is that we have several hundreds of buildings.

/UlfO 

Ouch! In principle the filtering could be stored in some cookie, but I would have to develop this, and I have currently no time for that. 

 OK!
Probably we partly can solve this via some intelligent sorting, but I wanted to check this with you first.

/UlfO

 

 

 

 

  67535   Tue Jun 4 17:14:25 2013 Reply UlfOulf.olsson@dynamate.seQuestionWindows2.9.2.2455Re: Latest windows version vs 2.9.2.2455

Stefan Ritt wrote:

UlfO wrote:

 

What is the differences between E-log windows version 2.9.2-2455 like we run and E-log windows version 2.9.2.-2475 ?

I cant find a changelog for this.

Best regards
/UlfO

 

 https://savannah02.psi.ch/viewvc/meg_elog/trunk/src/elogd.c?view=log

 OK!

Thank you very much

/UlfO

 

 

  67534   Tue Jun 4 17:09:44 2013 Reply Stefan Rittstefan.ritt@psi.chQuestionWindows2.9.2.2455Re: Latest windows version vs 2.9.2.2455

UlfO wrote:

 

What is the differences between E-log windows version 2.9.2-2455 like we run and E-log windows version 2.9.2.-2475 ?

I cant find a changelog for this.

Best regards
/UlfO

 

 https://savannah02.psi.ch/viewvc/meg_elog/trunk/src/elogd.c?view=log

  67533   Tue Jun 4 17:07:13 2013 Reply Stefan Rittstefan.ritt@psi.chQuestionWindows2.9.2-2455Re: Filter and sorting

UlfO wrote:

Stefan Ritt wrote:

UlfO wrote:

Hi,

We have a fire preventive team at our company doing periodic inspections of our various corporate buildings.

If they find a deviation they want to register this somewhere.

So I thought E-log would be nice to use in this case.

The way the fire preventive team inspection works is building by building.

All the buildings has numbers.

So they want to be able to select a buildingnumber in E-log and filter on open,ongoing and closed records when they do their inspections.

And they also wants the filtering to stay on that choosen buildingnumber  despite if they delete or add new entries.

I know that you can have a default startview in E-log but this view is static.

Is it possible to do this in E-log?

You can define the building number as an attribute and use it in a quick filter. The startview will however not stay on one bilding. An alternative would be to define one logbook per building. 

 OK!

Thanks for the answer.
I thought that this was the way to go. The problem is that we have several hundreds of buildings.

/UlfO 

Ouch! In principle the filtering could be stored in some cookie, but I would have to develop this, and I have currently no time for that. 

  67532   Tue Jun 4 17:07:04 2013 Question UlfOulf.olsson@dynamate.seQuestionWindows2.9.2.2455Latest windows version vs 2.9.2.2455

 

What is the differences between E-log windows version 2.9.2-2455 like we run and E-log windows version 2.9.2.-2475 ?

I cant find a changelog for this.

Best regards
/UlfO

 

  67531   Tue Jun 4 17:02:32 2013 Reply UlfOulf.olsson@dynamate.seQuestionWindows2.9.2-2455Re: Filter and sorting

Stefan Ritt wrote:

UlfO wrote:

Hi,

We have a fire preventive team at our company doing periodic inspections of our various corporate buildings.

If they find a deviation they want to register this somewhere.

So I thought E-log would be nice to use in this case.

The way the fire preventive team inspection works is building by building.

All the buildings has numbers.

So they want to be able to select a buildingnumber in E-log and filter on open,ongoing and closed records when they do their inspections.

And they also wants the filtering to stay on that choosen buildingnumber  despite if they delete or add new entries.

I know that you can have a default startview in E-log but this view is static.

Is it possible to do this in E-log?

You can define the building number as an attribute and use it in a quick filter. The startview will however not stay on one bilding. An alternative would be to define one logbook per building. 

 OK!

Thanks for the answer.
I thought that this was the way to go. The problem is that we have several hundreds of buildings.

/UlfO

 

 

 

  67530   Tue Jun 4 16:52:18 2013 Reply Stefan Rittstefan.ritt@psi.chQuestionWindows2.9.2-2455Re: Filter and sorting

UlfO wrote:

Hi,

We have a fire preventive team at our company doing periodic inspections of our various corporate buildings.

If they find a deviation they want to register this somewhere.

So I thought E-log would be nice to use in this case.

The way the fire preventive team inspection works is building by building.

All the buildings has numbers.

So they want to be able to select a buildingnumber in E-log and filter on open,ongoing and closed records when they do their inspections.

And they also wants the filtering to stay on that choosen buildingnumber  despite if they delete or add new entries.

I know that you can have a default startview in E-log but this view is static.

Is it possible to do this in E-log?

You can define the building number as an attribute and use it in a quick filter. The startview will however not stay on one bilding. An alternative would be to define one logbook per building. 

  67529   Tue Jun 4 16:17:22 2013 Reply Jim Tinlinjim@tinlin.netBug fixAll2.9.2-2481Re: Export entries to XLS or CSV?

Stefan Ritt wrote:

Andreas Luedeke wrote:

Jim Tinlin wrote:

Andreas Luedeke wrote:

scogordo wrote:

I've been asked to export one of our logbooks to xls or csv. Doable?

Thanks,
Scott

Hi Scott,

yes, every user can export entries using the "find" command.
Just select the export format in the first line

Export to:  

 
Detect language » English
 
 
Detect language » English
 
 
Detect language » English
 
 
Detect language » English
 
 
Detect language » English
 

I often use the XML Format, but CSV is fine if you just want to import the entries to some spreadsheet program.

I was shocked to find out that this feature has not yet made it into the documentation?!? But it is that simple to use that there is not much to document.

There is even an "Import" command, to reimport entries from a file. But this is tricky to use: if you have fields of type date or datetime, then you have to convert those fields in the proper format.

I tried EXPORTING logbooks as .csv but have not been fully successful.  Elog seems to only export the data entered for various fields with the exception of the text field.

Here is an example export from my logbook (used to track simulator problems), I would like to also export the TEXT field so it can be used by my managers in excel...but as you can see there is no entry for "TEXT" fields...

Thanks in advance!

"Message ID","Date","Author","Type","Status","Priority"

107,Thu  30 May 2013 11:28:57 -0700,"Jim Tinlin","Graphic Display","Evaluated","Low"

106,Thu  30 May 2013 10:02:24 -0700,"Jim Tinlin","Graphic Display","Identified","Low"

105,Thu  30 May 2013 08:07:27 -0700,"Jim Tinlin","Problem ID","Identified","Medium"

104,Thu  30 May 2013 08:04:30 -0700,"Jim Tinlin","Problem ID","Identified","Medium"

103,Wed  29 May 2013 09:36:11 -0700,"Jim Tinlin","Problem ID","Evaluated","High"

102,Wed  29 May 2013 08:58:02 -0700,"Jim Tinlin","Problem ID","Evaluated","High"

Yes, you're right: the text field is only exported in XML and Raw mode.
It is questionable how EXCEL should cope with HTML or ELCode output from the text fields.
But I admit that this would be a useful feature for logbooks that only use plain text entries. And it is simple to implement.
 
I've attached a patch to elogd.c from elog-2.9.2-2081 that adds a third CVS mode 'CSV (";" separated) + Text'.
(This string has not yet been added to the localization.)
As far as I've tested it works fine to import the text to OpenOffice and EXCEL, even with multiple text lines and HTML code in the text.
Of course the spreadsheet programs just display the HTML source.
 
Stefan, do you think this should be added to the official branch?

 

 
Detect language » English
 
 
Detect language » English
 

Hi Jim, can you confirm that this works for you? If so, I'm willing to incorporate the patch into the distribution. 

 I do not have the ability to compile a Windows executable, if someone does I'd be happy to test it out and report my results.

Thank you in advance!

ELOG V3.1.5-3fb85fa6