Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG  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 
    icon2.gif   Re: SMTP Host Error and export to CSV question, posted by Andreas Luedeke on Thu Jan 29 14:20:13 2015 
       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
          icon2.gif   Re: SMTP Host Error, posted by Andreas Luedeke on Mon Feb 2 10:13:58 2015 
             icon2.gif   Re: SMTP Host Error, posted by Stefan Ritt on Mon Feb 2 12:44:24 2015 
                icon3.gif   Re: SMTP Host Error, posted by Andreas Luedeke on Tue Feb 3 06:48:32 2015 
          icon2.gif   Re: CSV question, posted by Andreas Luedeke on Mon Feb 2 10:29:15 2015 oo.pngme.png
             icon2.gif   Re: CSV question, posted by Stefan Ritt on Mon Feb 2 10:39:33 2015 
                icon2.gif   Re: CSV question, posted by Banata Wachid Ridwan on Wed Feb 4 09:10:32 2015 
                   icon2.gif   Re: CSV question, posted by Stefan Ritt on Wed Feb 4 13:06:52 2015 
Message ID: 67795     Entry time: Mon Feb 2 10:29:15 2015     In reply to: 67790     Reply to this: 67796
Icon: Reply  Author: Andreas Luedeke  Author Email: andreas.luedeke@psi.ch 
Category: Question  OS: Windows  ELOG Version: 3.0.0 
Subject: Re: 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  95 kB  | Show | Hide all | Show all
Attachment 2: me.png  8 kB  | Hide | Hide all | Show all
me.png
ELOG V3.1.5-3fb85fa6