ID |
Date |
Icon |
Author |
Author Email |
Category |
OS |
ELOG Version |
Subject |
66166
|
Thu Jan 22 09:30:13 2009 |
| Stefan Ritt | stefan.ritt@psi.ch | Question | Windows | 2.7.5-2130 | Re: Import csv with another date |
Michael Dannmeyer wrote: |
Hello,
i have problems with importing csv files. What i want to do is the following:
Import a list of log entries from a csv file with another date like the actual date
I tried to do this but the only thing which happend was that all the entries have the actual date in elog. Then i created a seperate Date column in the csv file an tried to import this.
It worked but in the default date column i have the import date and in a second date column i have the date from the csv file.
Is there a chance to get the csv column imported in the standard Date field?
Or is there a possibility to hide/supress the default date field and only display the imported date field?
Thanks
Michael
|
Importing dates from CSV files was not implemented for a good reason: There are dozens of date formats (such as "1/22/09", "Jan 1 2009", "Mon 1 January '09") and it is almost impossible to handle all formats. I changed now the code to catch at least some formats, such as the internal RFC2822 compliant date which is also used internall by elog. An example of this format is "Thu, 22 Jan 2009 09:26:00". This date format will also be used if you export a logbook via a CSV file. Another format I added is "1/22/09". So give a try to the new code (I made an intermediate release for windows V2.7.5-3) and see if it works for you. |
66167
|
Mon Jan 26 14:07:02 2009 |
| Robert-Jan Schrijvers | Robert-Jan.Schrijvers@isoft.nl | Question | Windows | V2.6.3 | Default value radio button |
hi there,
Is it possible to attach a default value for a radio button when submitting a new form/record, for example:
I now have an item "Confirmed" Yes/No, and I want the "no" option to be selected by default when a new form/record is created.
Does anyone know how to arrange this?
Thanks in advance!
RJ
|
66168
|
Mon Jan 26 14:16:03 2009 |
| Stefan Ritt | stefan.ritt@psi.ch | Question | Windows | V2.6.3 | Re: Default value radio button |
Robert-Jan Schrijvers wrote: |
Is it possible to attach a default value for a radio button when submitting a new form/record, for example:
I now have an item "Confirmed" Yes/No, and I want the "no" option to be selected by default when a new form/record is created.
Does anyone know how to arrange this?
Thanks in advance!
|
You need something along these lines:
Attributes = ..., Confirmed
Options Confirmed = boolean
Preset Confirmed = 1 |
66170
|
Mon Jan 26 18:52:56 2009 |
| Topher Congdon | topher@congdongroup.com | Question | Windows | 2.7.5-2168 | more fun with SMTP and authentication.... |
Great software.
Okay, so I've done my reading through the forum and got a couple of nuggets along the way but I am still unable
to get the e-mail function to work. I am using Windows IIS to make an SMTP virtual server to shimmy around the
IT firewall. That appears to work as I can see the response from the external SMTP server while running elogd
with the -v flag. The elogd -v details are below:
Email from xxxxxxxxxxxx@xxxxxxxxxxxx.com to xxxxxx.XXXXXXX@XXXXX.com,XXXXX.XXXXX X@XXXXX.com, SMTP host
XXXXXXXXXXXXXX.XXXX.XXXXX.com:
220 smtp.xxxxx.com Microsoft ESMTP MAIL Service, Version: 6.0.2600.2180 ready at Mon, 26 Jan 2009 10:56:35 -0500
EHLO xxxxxxxxxxxxxx.xxxx.xxxxx.com
250-smtp.xxxxx.com Hello [xxx.xxx.xxx.xxx]
250-AUTH=LOGIN
250-AUTH LOGIN
250-SIZE 2097152
250-PIPELINING
250-DSN
250-ENHANCEDSTATUSCODES
250-8bitmime 250-BINARYMIME
250-CHUNKING 250-VRFY
250 OK AUTH LOGIN
Username:
xxxxxxxxxxxx@xxxxxxxxxxxx.com
Password: cm9jaGVsb2dib29r
535 5.7.3 Authentication unsuccessful
==== Return ================================
From the SMTP server response it is not logging in, but I don't know why. I can log in to the webmail app with
the username/password provided to ELOG, but it doesn't appear to work through ELOG. The SMTP provider includes
the following info to setup e-mail accounts via SMTP: "Please note: To send e-mail using the SMTP-Server,
activate SMTP Authentication. Please do not use the Secure Password Authentication (SPA) option. Optionally,
port 587 can also be used in addition to the default port (25) RFC 2476."
For authentication via the Windows IIS I have "basic authentication" with no TLS encryption required - I'm not
sure if that meets the provider's "SMTP authentication" requirement. When I was using the previous version of
ELOG (sorry, I did not note the version number) the username was encrypted along with the password. With the
2168 build, the password is still encrypted but the usernamer is not; should the password be in "plain text" as
well?
I can provide you with a username/password for the SMTP provider I'm using if that will help. Please send me a
separate e-mail and I will reply with the information.
Thank you,
Topher Congdon |
66171
|
Mon Jan 26 19:09:01 2009 |
| lisa giaime | lgiaime@cct.lsu.edu | Question | Linux | 2.7.4 | restrict a field to upper or lower case |
Is it possiblet to restrict a field so that when a new record is added, whatever the user types is automatically converted to lower case?
Thanks! |
66172
|
Mon Jan 26 19:48:42 2009 |
| Stefan Ritt | stefan.ritt@psi.ch | Question | Linux | 2.7.4 | Re: restrict a field to upper or lower case |
lisa giaime wrote: |
Is it possiblet to restrict a field so that when a new record is added, whatever the user types is automatically converted to lower case?
|
No, this is not possible. |
66174
|
Tue Jan 27 08:06:54 2009 |
| Robert-Jan Schrijvers | Robert-Jan.Schrijvers@isoft.nl | Question | Windows | V2.6.3 | Re: Default value radio button |
Stefan Ritt wrote: |
Robert-Jan Schrijvers wrote: |
Is it possible to attach a default value for a radio button when submitting a new form/record, for example:
I now have an item "Confirmed" Yes/No, and I want the "no" option to be selected by default when a new form/record is created.
Does anyone know how to arrange this?
Thanks in advance!
|
You need something along these lines:
Attributes = ..., Confirmed
Options Confirmed = boolean
Preset Confirmed = 1
|
Good Morning Stefan,
This was very helpful, it works as aspected! Thank you :-)
With regards, Robert-Jan. |
66175
|
Tue Jan 27 09:03:22 2009 |
| Stefan Ritt | stefan.ritt@psi.ch | Question | Windows | 2.7.5-2168 | Re: more fun with SMTP and authentication.... |
> For authentication via the Windows IIS I have "basic authentication" with no TLS encryption required - I'm
> not sure if that meets the provider's "SMTP authentication" requirement. When I was using the previous version
> of ELOG (sorry, I did not note the version number) the username was encrypted along with the password. With
> the 2168 build, the password is still encrypted but the usernamer is not; should the password be in "plain
> text" as well?
I changed only the screen output. The username is printed not not encrypted, to be able to check it by eye. The
username sent over the network is and was always encrypted.
The only clue I have is to compare the network traffic you get with an email client (outlook, thunderbird ??)
with the network traffic you get from elogd. To monitor the traffic, I use normally WireShark (formerly Ethereal,
www.wireshark.org). You have to filter for "tcp.port == 25" which is SMTP, then capture your traffic, right-
click on it and select "Follow TCP stream". The result you see in the attachment. The strings produced by elogd
are pink, the strings from the SMTP server are blue. In my case I don't have authentication (our SMTP server does
not support this). In you case, you have to compare the traffic from a functioning email client with elogd. |