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. |
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.
|
|
Re: SMTP Host Error and export to CSV question, posted by Banata Wachid Ridwan on Fri Jan 30 03:12:33 2015   
|
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.
|
|
|
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.
|
|
|
|
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 
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.
|
|
|
|
|
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 
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 
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.
|
|
|
|
|
|
Re: CSV question, posted by Andreas Luedeke on Mon Feb 2 10:29:15 2015 
|
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" 
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.
|
|
|
|
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" 
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.
|
|
|
|
|
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" 
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.
|
|
|
|
|
|
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,
|
|
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 |
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
|
|
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
|
|
|
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
|
|
|
|
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. |
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! |
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!
|
|
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!
|
|
|
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!
|
|
|
|
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!
|
|
|
|
|
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. |
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' . |
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. |
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" |
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"
|
|
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?
|
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?
|
|
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?
|
|
|
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?
|
|
|
|
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?
|
|
|
|
|
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
|
|
Re: Translation problem, posted by Banata on Mon Jan 12 04:04:57 2015
|
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
|
|
|
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.
|
|
Re: Translation problem, posted by Banata on Tue Jan 13 02:48:50 2015
|
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.
|
|
|
Re: Translation problem, posted by Banata on Tue Jan 13 04:06:48 2015
|
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.
|
|
|
|
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. |
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.
|
|
|