Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG, Page 614 of 808  Not logged in ELOG logo
ID Date Icon Author Author Email Category OS ELOG Version Subjectdown
  67471   Wed Apr 3 15:09:09 2013 Reply Stefan Rittstefan.ritt@psi.chQuestionWindows2.9.2-2456Re: Calculate with dates

UlfO wrote:

Hi,

Is it possbile to compare dates in E-log?

And based on that calculation have conditonal formats on certain attributes.

We have a need to monitor a date attribute named "Preferred finished date" on records placed in E-log.

And if SYSDATE is greater than the "Preferred finished date" we want to mark certain attibutes with a color.

Regards
/UlfO

 

This is a good idea, but not implemented. I will put this on the wishlist.

/Stefan 

  67473   Wed Apr 3 19:08:22 2013 Reply David PilgramDavid.Pilgram@epost.org.ukQuestionWindows2.9.2-2456Re: Calculate with dates

Stefan Ritt wrote:

UlfO wrote:

Hi,

Is it possbile to compare dates in E-log?

And based on that calculation have conditonal formats on certain attributes.

We have a need to monitor a date attribute named "Preferred finished date" on records placed in E-log.

And if SYSDATE is greater than the "Preferred finished date" we want to mark certain attibutes with a color.

Regards
/UlfO

 

This is a good idea, but not implemented. I will put this on the wishlist.

/Stefan 

 Please add my vote for this on the wishlist.

  67475   Thu Apr 4 17:54:23 2013 Reply UlfOulf.olsson@dynamate.seQuestionWindows2.9.2-2456Re: Calculate with dates

Stefan Ritt wrote:

UlfO wrote:

Hi,

Is it possbile to compare dates in E-log?

And based on that calculation have conditonal formats on certain attributes.

We have a need to monitor a date attribute named "Preferred finished date" on records placed in E-log.

And if SYSDATE is greater than the "Preferred finished date" we want to mark certain attibutes with a color.

Regards
/UlfO

 

This is a good idea, but not implemented. I will put this on the wishlist.

/Stefan 


Thanks

 Give it a vote from me.

  2299   Tue Jul 24 08:30:02 2007 Reply Stefan Rittstefan.ritt@psi.chBug report 2.6.5-1872Re: CVS import + french = impossible

toumbi wrote:
Hi ,
I found a bug , when I want to import a cvs file and if i had set Language=french into global , I m not allowed.
Erreur : commande "CSV Import" non autorisée 
Utilisez le bouton "page précédente" de votre navigateur pour revenir en arrière  

there is no problem if i use english.


This bug has been fixed in SVN revision 1892 and will be contained in the next release.
  320   Tue May 6 11:34:22 2003 Reply Stefan Rittstefan.ritt@psi.chInfo  Re: CVS URL
> Can anyone tell me the URL for the CVS download section
> 
> the link has gone from one of the main screens
> 
> Cheers

The message stating the URL is still in this forum: elog:233
  67795   Mon Feb 2 10:29:15 2015 Reply Andreas Luedekeandreas.luedeke@psi.chQuestionWindows3.0.0Re: CSV question
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.

 

 

 

Attachment 1: oo.png
oo.png
Attachment 2: me.png
me.png
  67796   Mon Feb 2 10:39:33 2015 Reply Stefan Rittstefan.ritt@psi.chQuestionWindows3.0.0Re: CSV question

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.

 

 

 

 

  67801   Wed Feb 4 09:10:32 2015 Reply Banata Wachid Ridwanjogjacard@yahoo.comQuestionWindows3.0.0Re: CSV question

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.

 

 

 

 

 

ELOG V3.1.5-3fb85fa6