ID |
Date |
Icon |
Author |
Author Email |
Category |
OS |
ELOG Version |
Subject |
67588
|
Tue Oct 22 10:54:51 2013 |
| Barend | office@amtc2.com | Question | Windows | 2.9.2 | Re: Error: Attribute <date> not supplied. |
David Pilgram wrote: |
Barend wrote: |
Stefan/Andreas,
When I reply to an existing Logbook entry, I get the error page "Error: Attribute Audit Date not supplied. Please go back and enter the Audit Date field."
The configuration file uses:
Required Attributes = Audit No, Audit Date, Audit Type, Finding No, Finding Level, Section, MOE Procedure, Finding Details, Auditor, Deadline, Responsibility
Fixed Attributes Reply = Audit No, Audit Date, Audit Type, Finding No, Finding Level, Section, MOE Procedure, Finding Details, Auditor, Deadline, Responsibility
Type Audit Date = date
Type Deadline = date
The combination "Required Attributes" and "Fixed Attributes Reply" does not work for date-fields.
As soon as I disclose the date fields from either "Required Attributes" or "Fixed Attributes Reply" the error is no longer evident.
But I want the "Audit Date" and "Deadline" to entered during a new Record and they shall not be changed during a reply.
Is this a bug -or- do I have to change the configuration?
Thanks & regards, Barend
|
Hi Barend,
I can reproduce your point.
I've found various work-arounds, but possibly the best one is to remove "Audit Date" and "Deadline" from the Required Attributes line. True you won't get a warning saying that they were not entered for the first entry (if you didn't enter them, that is), but all subsequent replies run as you would want.
Another way is if you *preview* your entry, you can then submit it and that works. This seems to work by bring up a different page where you can edit all those Fixed Attributes. (I'm not sure that Preview is meant to do that, but it does and it's a work-around).
Or, if you remove "Audit date" and "Deadline" from the Fixed Attributes Reply (as you did) seems to work in the same way. But I see that you don't want the opportunity for these to be changed.
I note that if you get this error message and go back, the message that you may have written is erased (this is unusual, it doesn't do this if you have not supplied an attribute on the first entry, say).
So I suspect this is a bug, possibly not detected before; perhaps no-one had tried this combination. |
Hi David,
Thanks for the reply. I'll review the options and decide what is the best option to move forward.
Regards, Barend |
67589
|
Tue Oct 22 10:56:13 2013 |
| Barend | office@amtc2.com | Bug report | Windows | 2.9.2 | Re: Importing XML/CSV |
Andreas Luedeke wrote: |
Barend wrote: |
Andreas Luedeke wrote: |
Barend wrote: |
Hi Stefan,
I'm experiencing problems importing XML (.csv is not working at all for me).
My logbook contains 3 date-attributes besides the system DATE (entry time), date-format is defined as %d %b %y.
The XML file hold the date format "DD.MM.YYYY"
- During "preview" I see that all entries are listed.
- During the import I get the "wrong date format" error.
- When I review the Summary, I see that only the first XML entry (all 3 date-attributes hold a date) was imported.
- When I try to re-import the XML from the second entry (after removing the 1st entry from XML - this second entry hold NO date-value on one of the date-attributes) the elogd.exe crashes and I get the "Service Temporarily Unavailable" error page.
- When I try to re-import the XML from the modified second entry (after removing the 1st entry from XML - this second entry holds date-value on all of the date-attributes) the elogd.exe crashes and I get the "Service Temporarily Unavailable" error page.
Any suggestion what could be wrong? Is it the missing date-value?
|
Can you post your elog configuration file (elog.cfg)?
⇄
Detect language » English
|
Hi Andreas,
I had to filter-out some other logbook. Please find attached the configuration section for the affected logbook "UMOWY".
Looking forward to your review.
Regards, Barend
|
Hi Barend,
I can confirm that this is a bug of the ELOG import function: if you have a field that is defined as type "date" or "datetime", then elogd requires the value of the field to be of a matching format.
It is not even allowed to omit the time in "datetime" format. If the field is not required in an entry, then it is therefore possible to create an entry that cannot be imported.
I've attached a minimal example elogd.cfg and XML import file to reproduce the problem.
I'm afraid you'll either need to wait for a patch, or you can add dummy dates for all your empty date fields in the XML import file. Just do a "replace all" with your favourite editor; in my example you would e.g. replace all "<D></D>" strings with "<D>01-01-1970</D>" before the import.
⇄
Detect language » English
Cheers, Andreas
⇄
Detect language » English
⇄
Detect language » English
|
Hi Andreas,
Thanks for the reply. The suggested approach is workable, so I'll use that one.
Regards, Barend |
67788
|
Thu Jan 29 10:16:01 2015 |
| Banata Wachid Ridwan | jogjacard@yahoo.com | Question | Windows | 3.0.0 | SMTP Host Error and export to CSV question | 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. |
67790
|
Fri Jan 30 03:12:33 2015 |
| Banata Wachid Ridwan | jogjacard@yahoo.com | Question | Windows | 3.0.0 | 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
|
"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
|
|
Attachment 3: elogd.cfg
|
[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
|
|
67791
|
Fri Jan 30 03:15:25 2015 |
| Banata Wachid Ridwan | jogjacard@yahoo.com | Question | Windows | 3.0.0 | Permission on reply | 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 |
67801
|
Wed Feb 4 09:10:32 2015 |
| Banata Wachid Ridwan | jogjacard@yahoo.com | Question | Windows | 3.0.0 | Re: 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" 
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.
|
|
|
|
|
|
67802
|
Wed Feb 4 09:48:32 2015 |
| Banata Wachid Ridwan | jogjacard@yahoo.com | Question | Windows | 3.0.0 | Re: Permission on reply | 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
|
|
|
67813
|
Wed Feb 25 03:28:24 2015 |
| Banata Wachid Ridwan | jogjacard@yahoo.com | Question | Windows | 3.0.0 | Enter past date for logbook | Is it possible to enter past date in logbook
I forgot to enter log yesterday, is it possible to add up now? |
|