Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG, Page 76 of 238  Not logged in ELOG logo
icon5.gif   SMTP Host Error and export to CSV question, posted by Banata Wachid Ridwan on Thu Jan 29 10:16:01 2015 

Hello

first of all, congrats for bring back the forum after down for sometimes, :D

but seems my old account is broken, I cant login with that anymore, so I make new account and strangely I can make identical account like the old one ahahahaha

 

okay first question :

Recently my elog setup got smtp host error, everytime someone submit log, error result that SMTP host is not found in global setting.

I dont't set mail server on my server so I cant use smtp host function, and I use register type 1 to avoid email function, but after sometimes those error occured, it seems some members accidentally check ëmail notification option

so, how to completely disable this function or maybe some work around on this error? I dont have mail server right now,

 

second

When we export logbook to CSV and open to microsoft excel, html tags still there, how to ommit html tags completely during export? and how to make nice table data from csv in elog? I saw many inconsistency there, especially on comment data

for example if I make more than two lines of logbook, second line will place in first column , not in the last column, just like the first line of comment.

    icon2.gif   Re: SMTP Host Error and export to CSV question, posted by Andreas Luedeke on Thu Jan 29 14:20:13 2015 

If you have more than one topic it is better to do more than one post.

I did not understand your first question. You should not have a line "SMTP host= " if you don't want to send any email. Have you tried "Suppress Email to users=1" to get rid of the error message?

If you export in cvs format, then it is the correct behaviour that multiple lines of text in the body are put into quotation marks and printed as multiple lines in the output. Every spreadsheet program (Excel, Openoffice, Libreoffice, ...) should be able to read that into a table. I've tested it, it works fine. If you have a problem, then you'll need to attach your elogd.cfg file and the exported file in the forum and some screenshots of what your MS Excel does with it.

Banata Wachid Ridwan wrote:

Hello

first of all, congrats for bring back the forum after down for sometimes, :D

but seems my old account is broken, I cant login with that anymore, so I make new account and strangely I can make identical account like the old one ahahahaha

 

okay first question :

Recently my elog setup got smtp host error, everytime someone submit log, error result that SMTP host is not found in global setting.

I dont't set mail server on my server so I cant use smtp host function, and I use register type 1 to avoid email function, but after sometimes those error occured, it seems some members accidentally check ëmail notification option

so, how to completely disable this function or maybe some work around on this error? I dont have mail server right now,

 

second

When we export logbook to CSV and open to microsoft excel, html tags still there, how to ommit html tags completely during export? and how to make nice table data from csv in elog? I saw many inconsistency there, especially on comment data

for example if I make more than two lines of logbook, second line will place in first column , not in the last column, just like the first line of comment.

 

       icon2.gif   Re: SMTP Host Error and export to CSV question, posted by Banata Wachid Ridwan on Fri Jan 30 03:12:33 2015 export.csverror.jpgelogd.cfgerror2.jpg

sorry for may bad english, not my natives :D

for first question, I'll make it clear,

after sometimes running elog, suddenly SMTP host error occured.

I dont have SMTP host= on my configuration, but that error keep show up.

how to disable email notification completely for my elog? or at least how to disable those SMTP Host error?

I'll try supress email users =1 to my elog.cfg and error still exist. where I should place supress email users flag to make it works?

on the picture attached, it is said there is no smtp host defined in global setting.

could it be because members check automatic email notification on their setting?

 

for second question I'll attach my csv file, and you will see <p> </p> tags still there, and inconsistency when open it to ms excel (see picture)

you can see that portion of text file (second line of text file and soon, placed in "id pesan")

 

please help us.

 

Andreas Luedeke wrote:

If you have more than one topic it is better to do more than one post.

I did not understand your first question. You should not have a line "SMTP host= " if you don't want to send any email. Have you tried "Suppress Email to users=1" to get rid of the error message?

If you export in cvs format, then it is the correct behaviour that multiple lines of text in the body are put into quotation marks and printed as multiple lines in the output. Every spreadsheet program (Excel, Openoffice, Libreoffice, ...) should be able to read that into a table. I've tested it, it works fine. If you have a problem, then you'll need to attach your elogd.cfg file and the exported file in the forum and some screenshots of what your MS Excel does with it.

Banata Wachid Ridwan wrote:

Hello

first of all, congrats for bring back the forum after down for sometimes, :D

but seems my old account is broken, I cant login with that anymore, so I make new account and strangely I can make identical account like the old one ahahahaha

 

okay first question :

Recently my elog setup got smtp host error, everytime someone submit log, error result that SMTP host is not found in global setting.

I dont't set mail server on my server so I cant use smtp host function, and I use register type 1 to avoid email function, but after sometimes those error occured, it seems some members accidentally check ëmail notification option

so, how to completely disable this function or maybe some work around on this error? I dont have mail server right now,

 

second

When we export logbook to CSV and open to microsoft excel, html tags still there, how to ommit html tags completely during export? and how to make nice table data from csv in elog? I saw many inconsistency there, especially on comment data

for example if I make more than two lines of logbook, second line will place in first column , not in the last column, just like the first line of comment.

 

 

          icon2.gif   Re: SMTP Host Error, posted by Andreas Luedeke on Mon Feb 2 10:13:58 2015 

You need to specify "Suppress Email to users=1" in the [global] section of the configuration. And it does matter if the letters are capitalized on not.

Banata Wachid Ridwan wrote:

sorry for may bad english, not my natives :D

for first question, I'll make it clear,

after sometimes running elog, suddenly SMTP host error occured.

I dont have SMTP host= on my configuration, but that error keep show up.

how to disable email notification completely for my elog? or at least how to disable those SMTP Host error?

I'll try supress email users =1 to my elog.cfg and error still exist. where I should place supress email users flag to make it works?

on the picture attached, it is said there is no smtp host defined in global setting.

could it be because members check automatic email notification on their setting?

 

for second question I'll attach my csv file, and you will see <p> </p> tags still there, and inconsistency when open it to ms excel (see picture)

you can see that portion of text file (second line of text file and soon, placed in "id pesan")

 

please help us.

 

Andreas Luedeke wrote:

If you have more than one topic it is better to do more than one post.

I did not understand your first question. You should not have a line "SMTP host= " if you don't want to send any email. Have you tried "Suppress Email to users=1" to get rid of the error message?

If you export in cvs format, then it is the correct behaviour that multiple lines of text in the body are put into quotation marks and printed as multiple lines in the output. Every spreadsheet program (Excel, Openoffice, Libreoffice, ...) should be able to read that into a table. I've tested it, it works fine. If you have a problem, then you'll need to attach your elogd.cfg file and the exported file in the forum and some screenshots of what your MS Excel does with it.

Banata Wachid Ridwan wrote:

Hello

first of all, congrats for bring back the forum after down for sometimes, :D

but seems my old account is broken, I cant login with that anymore, so I make new account and strangely I can make identical account like the old one ahahahaha

 

okay first question :

Recently my elog setup got smtp host error, everytime someone submit log, error result that SMTP host is not found in global setting.

I dont't set mail server on my server so I cant use smtp host function, and I use register type 1 to avoid email function, but after sometimes those error occured, it seems some members accidentally check ëmail notification option

so, how to completely disable this function or maybe some work around on this error? I dont have mail server right now,

 

second

When we export logbook to CSV and open to microsoft excel, html tags still there, how to ommit html tags completely during export? and how to make nice table data from csv in elog? I saw many inconsistency there, especially on comment data

for example if I make more than two lines of logbook, second line will place in first column , not in the last column, just like the first line of comment.

 

 

 

             icon2.gif   Re: SMTP Host Error, posted by Stefan Ritt on Mon Feb 2 12:44:24 2015 

That's not correct. Any option in the configuration file is case-insensitive. It should also not matter if the statement is under the logbook or in the [global] section. 

What you probably made wrong is to write "supress email to users =1" instead "suppress email to users =1". Note the second "p". So English in the end DOES matter, at least here wink

Andreas Luedeke wrote:

You need to specify "Suppress Email to users=1" in the [global] section of the configuration. And it does matter if the letters are capitalized on not.

Banata Wachid Ridwan wrote:

sorry for may bad english, not my natives :D

for first question, I'll make it clear,

after sometimes running elog, suddenly SMTP host error occured.

I dont have SMTP host= on my configuration, but that error keep show up.

how to disable email notification completely for my elog? or at least how to disable those SMTP Host error?

I'll try supress email users =1 to my elog.cfg and error still exist. where I should place supress email users flag to make it works?

on the picture attached, it is said there is no smtp host defined in global setting.

could it be because members check automatic email notification on their setting?

 

for second question I'll attach my csv file, and you will see <p> </p> tags still there, and inconsistency when open it to ms excel (see picture)

you can see that portion of text file (second line of text file and soon, placed in "id pesan")

 

please help us.

 

Andreas Luedeke wrote:

If you have more than one topic it is better to do more than one post.

I did not understand your first question. You should not have a line "SMTP host= " if you don't want to send any email. Have you tried "Suppress Email to users=1" to get rid of the error message?

If you export in cvs format, then it is the correct behaviour that multiple lines of text in the body are put into quotation marks and printed as multiple lines in the output. Every spreadsheet program (Excel, Openoffice, Libreoffice, ...) should be able to read that into a table. I've tested it, it works fine. If you have a problem, then you'll need to attach your elogd.cfg file and the exported file in the forum and some screenshots of what your MS Excel does with it.

Banata Wachid Ridwan wrote:

Hello

first of all, congrats for bring back the forum after down for sometimes, :D

but seems my old account is broken, I cant login with that anymore, so I make new account and strangely I can make identical account like the old one ahahahaha

 

okay first question :

Recently my elog setup got smtp host error, everytime someone submit log, error result that SMTP host is not found in global setting.

I dont't set mail server on my server so I cant use smtp host function, and I use register type 1 to avoid email function, but after sometimes those error occured, it seems some members accidentally check ëmail notification option

so, how to completely disable this function or maybe some work around on this error? I dont have mail server right now,

 

second

When we export logbook to CSV and open to microsoft excel, html tags still there, how to ommit html tags completely during export? and how to make nice table data from csv in elog? I saw many inconsistency there, especially on comment data

for example if I make more than two lines of logbook, second line will place in first column , not in the last column, just like the first line of comment.

 

 

 

 

                icon3.gif   Re: SMTP Host Error, posted by Andreas Luedeke on Tue Feb 3 06:48:32 2015 
Hey, great: I've learned something new about elog! I always took great care to get the capitalization of the options correct wink
Stefan Ritt wrote:

That's not correct. Any option in the configuration file is case-insensitive. It should also not matter if the statement is under the logbook or in the [global] section. 

What you probably made wrong is to write "supress email to users =1" instead "suppress email to users =1". Note the second "p". So English in the end DOES matter, at least here wink

Andreas Luedeke wrote:

You need to specify "Suppress Email to users=1" in the [global] section of the configuration. And it does matter if the letters are capitalized on not.

Banata Wachid Ridwan wrote:

sorry for may bad english, not my natives :D

for first question, I'll make it clear,

after sometimes running elog, suddenly SMTP host error occured.

I dont have SMTP host= on my configuration, but that error keep show up.

how to disable email notification completely for my elog? or at least how to disable those SMTP Host error?

I'll try supress email users =1 to my elog.cfg and error still exist. where I should place supress email users flag to make it works?

on the picture attached, it is said there is no smtp host defined in global setting.

could it be because members check automatic email notification on their setting?

 

for second question I'll attach my csv file, and you will see <p> </p> tags still there, and inconsistency when open it to ms excel (see picture)

you can see that portion of text file (second line of text file and soon, placed in "id pesan")

 

please help us.

 

Andreas Luedeke wrote:

If you have more than one topic it is better to do more than one post.

I did not understand your first question. You should not have a line "SMTP host= " if you don't want to send any email. Have you tried "Suppress Email to users=1" to get rid of the error message?

If you export in cvs format, then it is the correct behaviour that multiple lines of text in the body are put into quotation marks and printed as multiple lines in the output. Every spreadsheet program (Excel, Openoffice, Libreoffice, ...) should be able to read that into a table. I've tested it, it works fine. If you have a problem, then you'll need to attach your elogd.cfg file and the exported file in the forum and some screenshots of what your MS Excel does with it.

Banata Wachid Ridwan wrote:

Hello

first of all, congrats for bring back the forum after down for sometimes, :D

but seems my old account is broken, I cant login with that anymore, so I make new account and strangely I can make identical account like the old one ahahahaha

 

okay first question :

Recently my elog setup got smtp host error, everytime someone submit log, error result that SMTP host is not found in global setting.

I dont't set mail server on my server so I cant use smtp host function, and I use register type 1 to avoid email function, but after sometimes those error occured, it seems some members accidentally check ëmail notification option

so, how to completely disable this function or maybe some work around on this error? I dont have mail server right now,

 

second

When we export logbook to CSV and open to microsoft excel, html tags still there, how to ommit html tags completely during export? and how to make nice table data from csv in elog? I saw many inconsistency there, especially on comment data

for example if I make more than two lines of logbook, second line will place in first column , not in the last column, just like the first line of comment.

 

 

 

 

 

          icon2.gif   Re: CSV question, posted by Andreas Luedeke on Mon Feb 2 10:29:15 2015 oo.pngme.png
I've imported your export.csv file with OpenOffice 3.1.1 and with Excel 2010 and it both works fine (see attachments).
You should consult some Microsoft Helpdesk: ELOG works fine :-)

PS: I'm no English native speaker either. I have been told that international business language is anyway not English, but "Bad English" wink

Banata Wachid Ridwan wrote:

sorry for may bad english, not my natives :D [...]

for second question I'll attach my csv file, and you will see <p> </p> tags still there, and inconsistency when open it to ms excel (see picture)

you can see that portion of text file (second line of text file and soon, placed in "id pesan")

please help us.

Andreas Luedeke wrote:

If you have more than one topic it is better to do more than one post.

I did not understand your first question. You should not have a line "SMTP host= " if you don't want to send any email. Have you tried "Suppress Email to users=1" to get rid of the error message?

If you export in cvs format, then it is the correct behaviour that multiple lines of text in the body are put into quotation marks and printed as multiple lines in the output. Every spreadsheet program (Excel, Openoffice, Libreoffice, ...) should be able to read that into a table. I've tested it, it works fine. If you have a problem, then you'll need to attach your elogd.cfg file and the exported file in the forum and some screenshots of what your MS Excel does with it.

Banata Wachid Ridwan wrote:

Hello

first of all, congrats for bring back the forum after down for sometimes, :D

but seems my old account is broken, I cant login with that anymore, so I make new account and strangely I can make identical account like the old one ahahahaha

 

okay first question :

Recently my elog setup got smtp host error, everytime someone submit log, error result that SMTP host is not found in global setting.

I dont't set mail server on my server so I cant use smtp host function, and I use register type 1 to avoid email function, but after sometimes those error occured, it seems some members accidentally check ëmail notification option

so, how to completely disable this function or maybe some work around on this error? I dont have mail server right now,

 

second

When we export logbook to CSV and open to microsoft excel, html tags still there, how to ommit html tags completely during export? and how to make nice table data from csv in elog? I saw many inconsistency there, especially on comment data

for example if I make more than two lines of logbook, second line will place in first column , not in the last column, just like the first line of comment.

 

 

 

             icon2.gif   Re: CSV question, posted by Stefan Ritt on Mon Feb 2 10:39:33 2015 

If you enter ELOG text body entreis as HTML, they will be exported as HTML, and thus you have the <p> tags. To avoid them, enter the ELOG text body as plain text, or just remove them in your spreadsheet via find and replace (find "<p>" and replace by nothing). Ther is NO HTML to text converter in ELOG, so they cannot be stipped automatically. And maybe other people DO want the full HTML there.

Andreas Luedeke wrote:
I've imported your export.csv file with OpenOffice 3.1.1 and with Excel 2010 and it both works fine (see attachments).
You should consult some Microsoft Helpdesk: ELOG works fine :-)

PS: I'm no English native speaker either. I have been told that international business language is anyway not English, but "Bad English" wink

Banata Wachid Ridwan wrote:

sorry for may bad english, not my natives :D [...]

for second question I'll attach my csv file, and you will see <p> </p> tags still there, and inconsistency when open it to ms excel (see picture)

you can see that portion of text file (second line of text file and soon, placed in "id pesan")

please help us.

Andreas Luedeke wrote:

If you have more than one topic it is better to do more than one post.

I did not understand your first question. You should not have a line "SMTP host= " if you don't want to send any email. Have you tried "Suppress Email to users=1" to get rid of the error message?

If you export in cvs format, then it is the correct behaviour that multiple lines of text in the body are put into quotation marks and printed as multiple lines in the output. Every spreadsheet program (Excel, Openoffice, Libreoffice, ...) should be able to read that into a table. I've tested it, it works fine. If you have a problem, then you'll need to attach your elogd.cfg file and the exported file in the forum and some screenshots of what your MS Excel does with it.

Banata Wachid Ridwan wrote:

Hello

first of all, congrats for bring back the forum after down for sometimes, :D

but seems my old account is broken, I cant login with that anymore, so I make new account and strangely I can make identical account like the old one ahahahaha

 

okay first question :

Recently my elog setup got smtp host error, everytime someone submit log, error result that SMTP host is not found in global setting.

I dont't set mail server on my server so I cant use smtp host function, and I use register type 1 to avoid email function, but after sometimes those error occured, it seems some members accidentally check ëmail notification option

so, how to completely disable this function or maybe some work around on this error? I dont have mail server right now,

 

second

When we export logbook to CSV and open to microsoft excel, html tags still there, how to ommit html tags completely during export? and how to make nice table data from csv in elog? I saw many inconsistency there, especially on comment data

for example if I make more than two lines of logbook, second line will place in first column , not in the last column, just like the first line of comment.

 

 

 

 

                icon2.gif   Re: CSV question, posted by Banata Wachid Ridwan on Wed Feb 4 09:10:32 2015 

so I assume there is a way to force member to use plain text mode, right?  :D

how to make my member force to use plain text?

thanx for help sir,

Stefan Ritt wrote:

If you enter ELOG text body entreis as HTML, they will be exported as HTML, and thus you have the <p> tags. To avoid them, enter the ELOG text body as plain text, or just remove them in your spreadsheet via find and replace (find "<p>" and replace by nothing). Ther is NO HTML to text converter in ELOG, so they cannot be stipped automatically. And maybe other people DO want the full HTML there.

Andreas Luedeke wrote:
I've imported your export.csv file with OpenOffice 3.1.1 and with Excel 2010 and it both works fine (see attachments).
You should consult some Microsoft Helpdesk: ELOG works fine :-)

PS: I'm no English native speaker either. I have been told that international business language is anyway not English, but "Bad English" wink

Banata Wachid Ridwan wrote:

sorry for may bad english, not my natives :D [...]

for second question I'll attach my csv file, and you will see <p> </p> tags still there, and inconsistency when open it to ms excel (see picture)

you can see that portion of text file (second line of text file and soon, placed in "id pesan")

please help us.

Andreas Luedeke wrote:

If you have more than one topic it is better to do more than one post.

I did not understand your first question. You should not have a line "SMTP host= " if you don't want to send any email. Have you tried "Suppress Email to users=1" to get rid of the error message?

If you export in cvs format, then it is the correct behaviour that multiple lines of text in the body are put into quotation marks and printed as multiple lines in the output. Every spreadsheet program (Excel, Openoffice, Libreoffice, ...) should be able to read that into a table. I've tested it, it works fine. If you have a problem, then you'll need to attach your elogd.cfg file and the exported file in the forum and some screenshots of what your MS Excel does with it.

Banata Wachid Ridwan wrote:

Hello

first of all, congrats for bring back the forum after down for sometimes, :D

but seems my old account is broken, I cant login with that anymore, so I make new account and strangely I can make identical account like the old one ahahahaha

 

okay first question :

Recently my elog setup got smtp host error, everytime someone submit log, error result that SMTP host is not found in global setting.

I dont't set mail server on my server so I cant use smtp host function, and I use register type 1 to avoid email function, but after sometimes those error occured, it seems some members accidentally check ëmail notification option

so, how to completely disable this function or maybe some work around on this error? I dont have mail server right now,

 

second

When we export logbook to CSV and open to microsoft excel, html tags still there, how to ommit html tags completely during export? and how to make nice table data from csv in elog? I saw many inconsistency there, especially on comment data

for example if I make more than two lines of logbook, second line will place in first column , not in the last column, just like the first line of comment.

 

 

 

 

 

                   icon2.gif   Re: CSV question, posted by Stefan Ritt on Wed Feb 4 13:06:52 2015 

Allowed encoding = 1

As written in the documentation (which you should read before asking questions here)

Banata Wachid Ridwan wrote:

so I assume there is a way to force member to use plain text mode, right?  :D

how to make my member force to use plain text?

thanx for help sir,

icon5.gif   Permission on reply, posted by Banata Wachid Ridwan on Fri Jan 30 03:15:25 2015 

is it possible to set reply only for certain member?

all members can submit lobook, but only certain member can make reply on it

thanx for help and so sorry if I have too many question :D

    icon2.gif   Re: Permission on reply, posted by Stefan Ritt on Fri Jan 30 09:30:35 2015 

You can use the switches

Alloe reply = <user list>

Deny reply = <user list>

to give only certain uses the right to use that command.

/Stefan

Banata Wachid Ridwan wrote:

is it possible to set reply only for certain member?

all members can submit lobook, but only certain member can make reply on it

thanx for help and so sorry if I have too many question :D

 

       icon2.gif   Re: Permission on reply, posted by Banata Wachid Ridwan on Wed Feb 4 09:48:32 2015 

so let say I just want to add certain members for replying logbook, so I just need to add parameter Allow reply = <user list>

and automatically all members not listed will be forbidden, am I correct?

I dont need to specify members for "Deny Reply" right ?

Stefan Ritt wrote:

You can use the switches

Alloe reply = <user list>

Deny reply = <user list>

to give only certain uses the right to use that command.

/Stefan

Banata Wachid Ridwan wrote:

is it possible to set reply only for certain member?

all members can submit lobook, but only certain member can make reply on it

thanx for help and so sorry if I have too many question :D

 

 

          icon2.gif   Re: Permission on reply, posted by David Pilgram on Wed Feb 4 10:33:16 2015 

Hi Banata,

If you only have a few people who can reply, then use

Allow reply = <user list>

and no need to produce a "Deny reply" list.

If most people are able to reply, but a few are *not* allowed to reply - bad behaviour or whatever - then the Deny reply list is more appropriate, and no need to generate an "Allow reply" userlist.

David.

Banata Wachid Ridwan wrote:

so let say I just want to add certain members for replying logbook, so I just need to add parameter Allow reply = <user list>

and automatically all members not listed will be forbidden, am I correct?

I dont need to specify members for "Deny Reply" right ?

Stefan Ritt wrote:

You can use the switches

Alloe reply = <user list>

Deny reply = <user list>

to give only certain uses the right to use that command.

/Stefan

Banata Wachid Ridwan wrote:

is it possible to set reply only for certain member?

all members can submit lobook, but only certain member can make reply on it

thanx for help and so sorry if I have too many question :D

 

 

 

icon5.gif   calculate the value of one attribute depending upon the value of other attribute., posted by dev on Thu Jan 22 17:27:47 2015 

I HAVE A LOGBOOK WHICH KEEPS THE RECORD OF ALL FAULT BOOKED BY DIFFERENT SUBSCRIBER.THIS LOGBOOK HAS THREE ATTRIBUTE DOWNTIME,UPTIME & TOTAL DURATION (DATE &TIME FORMAT) . I WANT TO CALCULATE THE TOTAL DURATION AUTOMATICALLY WHENEVR UPTIME VALUE IS GIVEN AND IF THE UPTIME IS NOT GIVEN IT SHOULD CALCULATE DEPENDING UPON THE SYSTEM PRESENT TIME.PLEAS EXPLAIN IT WITH EXAMPLE.

    icon2.gif   Re: calculate the value of one attribute depending upon the value of other attribute., posted by Andreas Luedeke on Mon Jan 26 15:56:41 2015 

If you have the following elogd.cfg:

Attributes = START, END, DURATION
subst DURATION = $shell( /usr/local/elog/diff.sh \"$START\" \"$END\")
Show Attributes Edit = START, END

And the shell script /usr/local/elog/diff.sh is:

#!/bin/sh
s1=$(date -d "$1" +%s)
s2=$(date -d "$2" +%s)
d=$(echo "($s2-$s1)/3600"|bc -lq)
printf "%.0f hours" $d

Then DURATION is calculated from START and END in full hours.

It appears that if you define START and END as "datetime", then only the date part would be passed to the script. This may is a bug of elogd: Stefan, have you ever tried?

dev wrote:

I HAVE A LOGBOOK WHICH KEEPS THE RECORD OF ALL FAULT BOOKED BY DIFFERENT SUBSCRIBER.THIS LOGBOOK HAS THREE ATTRIBUTE DOWNTIME,UPTIME & TOTAL DURATION (DATE &TIME FORMAT) . I WANT TO CALCULATE THE TOTAL DURATION AUTOMATICALLY WHENEVR UPTIME VALUE IS GIVEN AND IF THE UPTIME IS NOT GIVEN IT SHOULD CALCULATE DEPENDING UPON THE SYSTEM PRESENT TIME.PLEAS EXPLAIN IT WITH EXAMPLE.

PS: Please do NOT write all capital text in a forum. Thank you!

       icon2.gif   Re: calculate the value of one attribute depending upon the value of other attribute., posted by dev on Mon Jan 26 19:24:02 2015 

I tried that It is not calculating  and it is giving the error "Shell execution not enabled via -x flag ".I started elogd -x from command prompt  it still gives the same error.

Andreas Luedeke wrote:

If you have the following elogd.cfg:

Attributes = START, END, DURATION
subst DURATION = $shell( /usr/local/elog/diff.sh \"$START\" \"$END\")
Show Attributes Edit = START, END

And the shell script /usr/local/elog/diff.sh is:

#!/bin/sh
s1=$(date -d "$1" +%s)
s2=$(date -d "$2" +%s)
d=$(echo "($s2-$s1)/3600"|bc -lq)
printf "%.0f hours" $d

Then DURATION is calculated from START and END in full hours.

It appears that if you define START and END as "datetime", then only the date part would be passed to the script. This may is a bug of elogd: Stefan, have you ever tried?

dev wrote:

I HAVE A LOGBOOK WHICH KEEPS THE RECORD OF ALL FAULT BOOKED BY DIFFERENT SUBSCRIBER.THIS LOGBOOK HAS THREE ATTRIBUTE DOWNTIME,UPTIME & TOTAL DURATION (DATE &TIME FORMAT) . I WANT TO CALCULATE THE TOTAL DURATION AUTOMATICALLY WHENEVR UPTIME VALUE IS GIVEN AND IF THE UPTIME IS NOT GIVEN IT SHOULD CALCULATE DEPENDING UPON THE SYSTEM PRESENT TIME.PLEAS EXPLAIN IT WITH EXAMPLE.

PS: Please do NOT write all capital text in a forum. Thank you!

 

          icon2.gif   Re: calculate the value of one attribute depending upon the value of other attribute., posted by Andreas Luedeke on Tue Jan 27 15:59:59 2015 

Yes, I forgot to mention that you need to enable shell script execution by starting the server with "elogd -x".

Before you start elogd from the command line you need to shutdown any running elogd; otherwise the port is blocked and the command line elogd cannot start: "sudo /sbin/service elogd stop"

From Linux you can edit instead /etc/init.d/elogd and add there the option "-x" to the line where "elogd" is started and then restart the service: "sudo /sbin/service elogd restart".

dev wrote:

I tried that It is not calculating  and it is giving the error "Shell execution not enabled via -x flag ".I started elogd -x from command prompt  it still gives the same error.

Andreas Luedeke wrote:

If you have the following elogd.cfg:

Attributes = START, END, DURATION
subst DURATION = $shell( /usr/local/elog/diff.sh \"$START\" \"$END\")
Show Attributes Edit = START, END

And the shell script /usr/local/elog/diff.sh is:

#!/bin/sh
s1=$(date -d "$1" +%s)
s2=$(date -d "$2" +%s)
d=$(echo "($s2-$s1)/3600"|bc -lq)
printf "%.0f hours" $d

Then DURATION is calculated from START and END in full hours.

It appears that if you define START and END as "datetime", then only the date part would be passed to the script. This may is a bug of elogd: Stefan, have you ever tried?

dev wrote:

I HAVE A LOGBOOK WHICH KEEPS THE RECORD OF ALL FAULT BOOKED BY DIFFERENT SUBSCRIBER.THIS LOGBOOK HAS THREE ATTRIBUTE DOWNTIME,UPTIME & TOTAL DURATION (DATE &TIME FORMAT) . I WANT TO CALCULATE THE TOTAL DURATION AUTOMATICALLY WHENEVR UPTIME VALUE IS GIVEN AND IF THE UPTIME IS NOT GIVEN IT SHOULD CALCULATE DEPENDING UPON THE SYSTEM PRESENT TIME.PLEAS EXPLAIN IT WITH EXAMPLE.

PS: Please do NOT write all capital text in a forum. Thank you!

 

 

             icon2.gif   Re: calculate the value of one attribute depending upon the value of other attribute., posted by dev on Tue Jan 27 17:18:17 2015 

I am working in window system.Itries using elogd  stop and start  command  but it is always showing it is running.Kindly help  me  thanking you.

Andreas Luedeke wrote:

Yes, I forgot to mention that you need to enable shell script execution by starting the server with "elogd -x".

Before you start elogd from the command line you need to shutdown any running elogd; otherwise the port is blocked and the command line elogd cannot start: "sudo /sbin/service elogd stop"

From Linux you can edit instead /etc/init.d/elogd and add there the option "-x" to the line where "elogd" is started and then restart the service: "sudo /sbin/service elogd restart".

dev wrote:

I tried that It is not calculating  and it is giving the error "Shell execution not enabled via -x flag ".I started elogd -x from command prompt  it still gives the same error.

Andreas Luedeke wrote:

If you have the following elogd.cfg:

Attributes = START, END, DURATION
subst DURATION = $shell( /usr/local/elog/diff.sh \"$START\" \"$END\")
Show Attributes Edit = START, END

And the shell script /usr/local/elog/diff.sh is:

#!/bin/sh
s1=$(date -d "$1" +%s)
s2=$(date -d "$2" +%s)
d=$(echo "($s2-$s1)/3600"|bc -lq)
printf "%.0f hours" $d

Then DURATION is calculated from START and END in full hours.

It appears that if you define START and END as "datetime", then only the date part would be passed to the script. This may is a bug of elogd: Stefan, have you ever tried?

dev wrote:

I HAVE A LOGBOOK WHICH KEEPS THE RECORD OF ALL FAULT BOOKED BY DIFFERENT SUBSCRIBER.THIS LOGBOOK HAS THREE ATTRIBUTE DOWNTIME,UPTIME & TOTAL DURATION (DATE &TIME FORMAT) . I WANT TO CALCULATE THE TOTAL DURATION AUTOMATICALLY WHENEVR UPTIME VALUE IS GIVEN AND IF THE UPTIME IS NOT GIVEN IT SHOULD CALCULATE DEPENDING UPON THE SYSTEM PRESENT TIME.PLEAS EXPLAIN IT WITH EXAMPLE.

PS: Please do NOT write all capital text in a forum. Thank you!

 

 

 

                icon2.gif   Re: calculate the value of one attribute depending upon the value of other attribute., posted by Andreas Luedeke on Wed Jan 28 09:57:11 2015 

Unfortunately I cannot help you with Windows. But you must have started the service somehow in the first place: that is where I would expect you can stop it as well.

dev wrote:

I am working in window system.Itries using elogd  stop and start  command  but it is always showing it is running.Kindly help  me  thanking you.

Andreas Luedeke wrote:

Yes, I forgot to mention that you need to enable shell script execution by starting the server with "elogd -x".

Before you start elogd from the command line you need to shutdown any running elogd; otherwise the port is blocked and the command line elogd cannot start: "sudo /sbin/service elogd stop"

From Linux you can edit instead /etc/init.d/elogd and add there the option "-x" to the line where "elogd" is started and then restart the service: "sudo /sbin/service elogd restart".

dev wrote:

I tried that It is not calculating  and it is giving the error "Shell execution not enabled via -x flag ".I started elogd -x from command prompt  it still gives the same error.

Andreas Luedeke wrote:

If you have the following elogd.cfg:

Attributes = START, END, DURATION
subst DURATION = $shell( /usr/local/elog/diff.sh \"$START\" \"$END\")
Show Attributes Edit = START, END

And the shell script /usr/local/elog/diff.sh is:

#!/bin/sh
s1=$(date -d "$1" +%s)
s2=$(date -d "$2" +%s)
d=$(echo "($s2-$s1)/3600"|bc -lq)
printf "%.0f hours" $d

Then DURATION is calculated from START and END in full hours.

It appears that if you define START and END as "datetime", then only the date part would be passed to the script. This may is a bug of elogd: Stefan, have you ever tried?

dev wrote:

I HAVE A LOGBOOK WHICH KEEPS THE RECORD OF ALL FAULT BOOKED BY DIFFERENT SUBSCRIBER.THIS LOGBOOK HAS THREE ATTRIBUTE DOWNTIME,UPTIME & TOTAL DURATION (DATE &TIME FORMAT) . I WANT TO CALCULATE THE TOTAL DURATION AUTOMATICALLY WHENEVR UPTIME VALUE IS GIVEN AND IF THE UPTIME IS NOT GIVEN IT SHOULD CALCULATE DEPENDING UPON THE SYSTEM PRESENT TIME.PLEAS EXPLAIN IT WITH EXAMPLE.

PS: Please do NOT write all capital text in a forum. Thank you!

 

 

 

 

icon5.gif   how to calculate the time , posted by dev on Mon Jan 26 15:46:04 2015 

I HAVE A LOGBOOK WHICH KEEPS THE RECORD OF ALL FAULT BOOKED BY DIFFERENT SUBSCRIBER.THIS LOGBOOK HAS THREE ATTRIBUTE DOWNTIME,UPTIME & TOTAL DURATION (DATE &TIME FORMAT) . I WANT TO CALCULATE THE TOTAL DURATION AUTOMATICALLY WHENEVR UPTIME VALUE IS GIVEN AND IF THE UPTIME IS NOT GIVEN IT SHOULD CALCULATE DEPENDING UPON THE SYSTEM PRESENT TIME.PLEAS EXPLAIN IT WITH EXAMPLE.

icon5.gif   filter with or operation/TIME DURATION CALCULATION , posted by dev on Wed Jan 21 02:15:12 2015 

1.I HAVE A ELOG BOOK WITH TWO ATTRIBUTE 'FROM' &'TO'. I WANT TO USE A FILTER WHICH WILL SEARCH FOR A VALUE  IN BOTH ATTRIBUTE .KINDLY HELP ME.

2. HOW TO CALCULATE THE TIME DURATION  AUTOMATICALLY BASED ON TWO ATTRIBUTES 'START TIME' AND 'STOP TIME' .

    icon2.gif   Re: filter with or operation/TIME DURATION CALCULATION , posted by Andreas Luedeke on Thu Jan 22 08:35:23 2015 

 

dev wrote:

1.I HAVE A ELOG BOOK WITH TWO ATTRIBUTE 'FROM' &'TO'. I WANT TO USE A FILTER WHICH WILL SEARCH FOR A VALUE  IN BOTH ATTRIBUTE .KINDLY HELP ME.

2. HOW TO CALCULATE THE TIME DURATION  AUTOMATICALLY BASED ON TWO ATTRIBUTES 'START TIME' AND 'STOP TIME' .

1a. If you go to the "Find" form, you can add filters on several attribute. The URL of the result page can be bookmarked: this is your filter.

1b. If you define quick filters on FROM and TO, then you can enter filters on both.

2. If you start elogd with the -x option, then you can execute scripts in the "subst" and "subst on edit" commands. Within those shell scripts you can use $START TIME and $STOP TIME to calculate the attributes value. Look for the "Subst" command in the documentation.

icon5.gif   Problem with embedded Iframes, posted by Eric Quintero on Mon Jan 12 23:26:18 2015 

We've upgraded our ELOG installation to v3, and we really like the new CKeditor. However, one of my users has noticed a problem when using Iframe HTML elements with CKeditor; namely that the HTML is not present when trying to edit the post, and saving the post erases the HTML. 
I was able to reproduce this fairly simply, by trying to embed a youtube video. I would create a new post, click the "Source" view in CKeditor, and paste something like the following:
<iframe width="420" height="315" src="//www.youtube.com/embed/RzZgFKoIfQI" frameborder="0" allowfullscreen></iframe>
Upon submission, this produces a totally normal .log file in the logbook directory, and the video is viewable on the ELOG page:

Date: Mon, 22 Dec 2014 15:52:20 -0800
Author: test
Type: General
Category: General
Subject: test
Attachment:
Encoding: HTML
========================================
<iframe width="420" height="315" src="//www.youtube.com/embed/RzZgFKoIfQI" frameborder="0" allowfullscreen></iframe>


Then, upon hitting "Edit," I am greeted by a totally empty CKeditor window, and hitting "Source" does not display the original HTML. 
Any help is greatly appreciated!

PS: Including the first line of the logfile in this very post would cause the submitted post to be truncated for some reason, although the preview looked fine. Pasting it here also caused the log to end abruptly. The string is "(dollar sign)(at symbol)MID(at symbol)(dollar sign): 9"

    icon2.gif   Re: Problem with embedded Iframes, posted by Stefan Ritt on Tue Jan 13 10:10:56 2015 

This is an issue with CKEditor, not with ELOG. 

Maybe this helps:

http://drupal.stackexchange.com/questions/96069/ckeditor-removes-iframes-in-editor-after-update-to-6-x-1-14

 

Eric Quintero wrote:

We've upgraded our ELOG installation to v3, and we really like the new CKeditor. However, one of my users has noticed a problem when using Iframe HTML elements with CKeditor; namely that the HTML is not present when trying to edit the post, and saving the post erases the HTML. 
I was able to reproduce this fairly simply, by trying to embed a youtube video. I would create a new post, click the "Source" view in CKeditor, and paste something like the following:
<iframe width="420" height="315" src="//www.youtube.com/embed/RzZgFKoIfQI" frameborder="0" allowfullscreen></iframe>
Upon submission, this produces a totally normal .log file in the logbook directory, and the video is viewable on the ELOG page:

Date: Mon, 22 Dec 2014 15:52:20 -0800
Author: test
Type: General
Category: General
Subject: test
Attachment:
Encoding: HTML
========================================
<iframe width="420" height="315" src="//www.youtube.com/embed/RzZgFKoIfQI" frameborder="0" allowfullscreen></iframe>


Then, upon hitting "Edit," I am greeted by a totally empty CKeditor window, and hitting "Source" does not display the original HTML. 
Any help is greatly appreciated!

PS: Including the first line of the logfile in this very post would cause the submitted post to be truncated for some reason, although the preview looked fine. Pasting it here also caused the log to end abruptly. The string is "(dollar sign)(at symbol)MID(at symbol)(dollar sign): 9"

 

icon5.gif   Translation problem, posted by Banata on Tue Jan 6 03:04:51 2015 

Hello, I try to translate elog using 2.9 version, I never try on 2.9 until new version 3.0 released

I translate 2 files here : elcode_indonesia.html and eloglang.indonesia,

after new version 3.0 I try to load those translation to the latest version using :

Language : indonesia

but language still in English, What I'm missing here?

 

 

    icon2.gif   Re: Translation problem, posted by Stefan Ritt on Tue Jan 6 09:20:44 2015 

Maybe 

language = indonesia

instead

language : indonesia

???

Banata wrote:

Hello, I try to translate elog using 2.9 version, I never try on 2.9 until new version 3.0 released

I translate 2 files here : elcode_indonesia.html and eloglang.indonesia,

after new version 3.0 I try to load those translation to the latest version using :

Language : indonesia

but language still in English, What I'm missing here?

 

 

 

       icon2.gif   Re: Translation problem, posted by Banata on Wed Jan 7 08:04:08 2015 

sorry, this is the elog.cfg on my server

Theme = default
Comment = Logbook Balai Sabo
Attributes = Author, Category
Options Category = Rutin, Litbang
Required Attributes = Author, Category
Page Title = LOGBOOK
Reverse sort = 1
Quick filter = Date, Category, Author
self register = 1
Time format = %d %B, %Y
Password file = pass.txt
Self register = 1
Admin user = Banata
Allow delete = Banata
Preset Author = $long_name
Locked Attributes = Author
Login expiration = 1000
Restrict edit = 1
Language = indonesia

 

and still I cant load my language, any idea?

 

Stefan Ritt wrote:

Maybe 

language = indonesia

instead

language : indonesia

???

Banata wrote:

Hello, I try to translate elog using 2.9 version, I never try on 2.9 until new version 3.0 released

I translate 2 files here : elcode_indonesia.html and eloglang.indonesia,

after new version 3.0 I try to load those translation to the latest version using :

Language : indonesia

but language still in English, What I'm missing here?

 

 

 

 

          icon2.gif   Re: Translation problem, posted by Stefan Ritt on Wed Jan 7 09:07:49 2015 

The Language = ... setting has to be under the [global] section as written in the documentation: http://midas.psi.ch/elog/config.html

Banata wrote:

sorry, this is the elog.cfg on my server

Theme = default
Comment = Logbook Balai Sabo
Attributes = Author, Category
Options Category = Rutin, Litbang
Required Attributes = Author, Category
Page Title = LOGBOOK
Reverse sort = 1
Quick filter = Date, Category, Author
self register = 1
Time format = %d %B, %Y
Password file = pass.txt
Self register = 1
Admin user = Banata
Allow delete = Banata
Preset Author = $long_name
Locked Attributes = Author
Login expiration = 1000
Restrict edit = 1
Language = indonesia

 

and still I cant load my language, any idea?

 

Stefan Ritt wrote:

Maybe 

language = indonesia

instead

language : indonesia

???

Banata wrote:

Hello, I try to translate elog using 2.9 version, I never try on 2.9 until new version 3.0 released

I translate 2 files here : elcode_indonesia.html and eloglang.indonesia,

after new version 3.0 I try to load those translation to the latest version using :

Language : indonesia

but language still in English, What I'm missing here?

 

 

 

 

 

             icon2.gif   Re: Translation problem, posted by Banata on Fri Jan 9 08:59:38 2015 

ah really thanx, this is the one I missed,

oh btw, can I send this language to you?, if you want to add it as distribution on next version maybe, Indonesian language

Stefan Ritt wrote:

The Language = ... setting has to be under the [global] section as written in the documentation: http://midas.psi.ch/elog/config.html

Banata wrote:

sorry, this is the elog.cfg on my server

Theme = default
Comment = Logbook Balai Sabo
Attributes = Author, Category
Options Category = Rutin, Litbang
Required Attributes = Author, Category
Page Title = LOGBOOK
Reverse sort = 1
Quick filter = Date, Category, Author
self register = 1
Time format = %d %B, %Y
Password file = pass.txt
Self register = 1
Admin user = Banata
Allow delete = Banata
Preset Author = $long_name
Locked Attributes = Author
Login expiration = 1000
Restrict edit = 1
Language = indonesia

 

and still I cant load my language, any idea?

 

Stefan Ritt wrote:

Maybe 

language = indonesia

instead

language : indonesia

???

Banata wrote:

Hello, I try to translate elog using 2.9 version, I never try on 2.9 until new version 3.0 released

I translate 2 files here : elcode_indonesia.html and eloglang.indonesia,

after new version 3.0 I try to load those translation to the latest version using :

Language : indonesia

but language still in English, What I'm missing here?

 

 

 

 

 

 

                icon2.gif   Re: Translation problem, posted by Stefan Ritt on Fri Jan 9 09:12:12 2015 

Sure.

Banata wrote:

ah really thanx, this is the one I missed,

oh btw, can I send this language to you?, if you want to add it as distribution on next version maybe, Indonesian language

 

                   icon2.gif   Re: Translation problem, posted by Banata on Mon Jan 12 04:04:57 2015 eloglang.indonesia

here you go language translation for Indonesia, if you find any mistakes or missing things please contact me

Stefan Ritt wrote:

Sure.

Banata wrote:

ah really thanx, this is the one I missed,

oh btw, can I send this language to you?, if you want to add it as distribution on next version maybe, Indonesian language

 

 

                      icon2.gif   Re: Translation problem, posted by Stefan Ritt on Mon Jan 12 11:10:33 2015 

I also need elcode_indonesia.html and eloghelp_indonesia.html.

Banata wrote:

here you go language translation for Indonesia, if you find any mistakes or missing things please contact me.

 

                         icon2.gif   Re: Translation problem, posted by Banata on Tue Jan 13 02:48:50 2015 elcode_indonesia.html

oh, okay, elcode_indonesia.html

for eloghelp still on progress, :D

Stefan Ritt wrote:

I also need elcode_indonesia.html and eloghelp_indonesia.html.

Banata wrote:

here you go language translation for Indonesia, if you find any mistakes or missing things please contact me.

 

 

                            icon2.gif   Re: Translation problem, posted by Banata on Tue Jan 13 04:06:48 2015 eloghelp_indo.html

this is eloghelp

Banata wrote:

oh, okay, elcode_indonesia.html

for eloghelp still on progress, :D

Stefan Ritt wrote:

I also need elcode_indonesia.html and eloghelp_indonesia.html.

Banata wrote:

here you go language translation for Indonesia, if you find any mistakes or missing things please contact me.

 

 

 

icon5.gif   using a predefined format with predefined informations that an user should fill at each run of data , posted by Iolanda Matea on Fri Jan 9 17:30:31 2015 

Hello!

I was wondering if it is possible (and how) to define a template (something equivalent to an excel table with some required informations to be filled) that opens each time one wants to make a new entry of a given type, e.g., I want this template to open only when the informations concern data taking.

I hope I am sufficiently clear ...

Thank you,

I.M.

    icon2.gif   Re: using a predefined format with predefined informations that an user should fill at each run of data , posted by Stefan Ritt on Mon Jan 12 11:24:00 2015 

In ELOG you can define "attributes", so take one attribute for each informaiton you need. The flag these attributes as required via "Required attributes = ...". If you only want this attributes for certain occations (like data taking in your case), you can either do a separato logbook for data taking, or use "conditional attributes" to make these attributes only show up for data taking.

/Stefan 

Iolanda Matea wrote:

Hello!

I was wondering if it is possible (and how) to define a template (something equivalent to an excel table with some required informations to be filled) that opens each time one wants to make a new entry of a given type, e.g., I want this template to open only when the informations concern data taking.

I hope I am sufficiently clear ...

Thank you,

I.M.

 

ELOG V3.1.5-3fb85fa6