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: 67790     Entry time: Fri Jan 30 03:12:33 2015     In reply to: 67789     Reply to this: 67794   67795
Icon: Reply  Author: Banata Wachid Ridwan  Author Email: jogjacard@yahoo.com 
Category: Question  OS: Windows  ELOG Version: 3.0.0 
Subject: Re: SMTP Host Error and export to CSV question 

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.

 

 

Attachment 1: export.csv  557 Bytes  | Hide | Hide all
"ID pesan";"Tanggal ";"Author";"Category";"Text"
1;Tue  06 Jan 2015 12:12:28 +0700;"Banata Wachid Ridwan";"Rutin";"<p>1. Print form Basis data untuk kegiatan rutin</p>

<p>2. Update T3 Framework plugin untuk web basis data</p>

<p>3. Menyusun artikel web basis data</p>

<p>4. Publish 4 artikel web basis data tahun 2014</p>

<p>5. Setting dan kustomasi logbook</p>

<p>6. Maintenance web rutin (update VPS CentOS)</p>

<p>7. Upgrade versi logbook ke 3.0.0</p>

<p>8. Seleksi Framework Template Joomla untuk persiapan update Joomla 3.x</p>"
Attachment 2: error.jpg  131 kB  | Hide | Hide all
error.jpg
Attachment 3: elogd.cfg  578 Bytes  | Hide | Hide all
[global]
port = 8080
Language = indonesia

[SABO]
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
Display mode = threaded
Suppress Email notification = 1
Attachment 4: error2.jpg  65 kB  | Hide | Hide all
error2.jpg
ELOG V3.1.5-3fb85fa6