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,
|
|
|
Re: CSV importing, posted by Stefan Ritt on Fri Apr 23 13:47:40 2004
|
> However I'd like to import data from the CSV file, directly to the 'text'
> field, rather than just to one an attribute fields. Is it possible to do
> this?
Not yet, but I can implement it. Do you always have a column "text" in your
CSV data or would you like to be able to select which column goes into the
"text" field? Can you apend some sample CSV data so that I can have a look at it? |
|
Re: CSV importing, posted by Paul Harrington on Fri Apr 30 12:58:54 2004
|
> > However I'd like to import data from the CSV file, directly to the 'text'
> > field, rather than just to one an attribute fields. Is it possible to do
> > this?
>
> Not yet, but I can implement it. Do you always have a column "text" in your
> CSV data or would you like to be able to select which column goes into the
> "text" field? Can you apend some sample CSV data so that I can have a look at it?
I've been trying an alternative approach which is basically to :
1. Import the data (not including the text field) into elog from a CSV file
2. Stop the elog server
3. Use a perl script to add each text entry to the appropriate record within the
logbook file.
(I.e. between the =============================== of the appropriate entry
and the next ' |
Re: CSV importing, posted by Stefan Ritt on Sat May 1 00:21:20 2004
|
I implemented the feature to import the main entry text body from a CSV column labeled
"text". Please see the newest release
(http://midas.psi.ch/cgi-bin/cvsweb/elog/src/elogd.c?rev=1.319) and let me know if this
works for you.
I had to add code to break apart long text bodies after 78 characters in order not to
get too long lines. Please note that the maximum body size in the CSV import is limited
to 500 characters. |
|
Re: CSS reference in Email for private logbooks, posted by Stefan Ritt on Fri Dec 21 14:04:41 2018
|
I changed the code ot include the CSS file directly in the email body. So no need any more for external CSS files. I dropped the "Email CSS URL" option as well.
Stefan
| Andreas Luedeke wrote: |
|
We operate ELOG in an intranet. Many logbooks do send out emails; several use HTML content formatting.
If I watch HTML formatted emails from the intranet, then everything is fine.
If I try to read them from home, my email client hangs when it tries to read the CSS file from out intranet (URL: https://elog-gfa.psi.ch/SLS/elog.css).
Is there a way to set a URL for the email CSS?
Then I could simply copy the CSS file to the internet accessible location and the emails would be properly formatted in the intranet and from home.
I've tried to use "Use Email URL = ", but it turned out that this will change all base URL's in the email BUT the one in the CSS :-(
So I would need a config "Email CSS URL = " to set this.
Here is a patch that does what I want, but it might have some side-effects I'm not yet aware of:
7636,7643c7636,7638
< if (absolute_link) {
< if (lbs != NULL && getcfg(lbs->name, "Email CSS URL", str, sizeof(str)))
< strlcpy(css_base, str, sizeof(css_base));
< else if (lbs == NULL && getcfg("global", "Email CSS URL", str, sizeof(str)))
< strlcpy(css_base, str, sizeof(css_base));
< if (css_base[0] == 0)
< compose_base_url(lbs, css_base, sizeof(css_base), FALSE);
< } else
---
> if (absolute_link)
> compose_base_url(lbs, css_base, sizeof(css_base), FALSE);
> else
Cheers
Andreas
|
|
|