Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG  Not logged in ELOG logo
icon5.gif   Date in CSV and XML in UNIX time, posted by PJ Meyer on Fri Jul 22 03:15:29 2005 
    icon2.gif   Re: Date in CSV and XML in UNIX time, posted by Stefan Ritt on Fri Jul 22 08:56:20 2005 
       icon2.gif   Re: Date in CSV and XML in UNIX time, posted by PJ Meyer on Mon Jul 25 19:15:33 2005 
          icon2.gif   Re: Date in CSV and XML in UNIX time, posted by Stefan Ritt on Mon Jul 25 20:20:18 2005 
             icon2.gif   Re: Date in CSV and XML in UNIX time, posted by PJ Meyer on Mon Jul 25 22:27:06 2005 
                icon2.gif   Re: Date in CSV and XML in UNIX time, posted by Stefan Ritt on Tue Jul 26 09:25:40 2005 
Message ID: 1316     Entry time: Mon Jul 25 22:27:06 2005     In reply to: 1312     Reply to this: 1319
Icon: Reply  Author: PJ Meyer  Author Email: pjm@pjmeyer.org 
Category: Question  OS: Windows  ELOG Version: 2.5.? 
Subject: Re: Date in CSV and XML in UNIX time 

Stefan Ritt wrote:

PJ Meyer wrote:

Stefan Ritt wrote:

PJ Meyer wrote:
So what can be done to make all the dates look like dates?


Simply upgrade to 2.6.0beta where this problem has been solved.


I did upgrade to "2.60-beta2" of the Windows binaries - June 16th date stamps on Elog.exe and Elogd.exe.
I'm still getting dates that are in "Unix time"

Anything else?


I just tried again myself. Put following into elgod.cfg:

[demo]
Attributes = Author, Category, Arrival
Type Arrival = Date


type in one entry, did a XML extract, and got
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- ELOGD Version 2.6.0-beta2 export.xml -->
<ELOG_LIST>
	<ENTRY>
		<MID>1</MID>
		<DATE>Fri Jul 22 22:50:34 2005</DATE>
		<Author>sr</Author>
		<Category>Problem</Category>
		<Arrival>7/25/2005</Arrival>
		<TEXT></TEXT>
	</ENTRY>
</ELOG_LIST>

where the date looks ok. So what do you do differently?



Not sure where we differ....

My cfg:
Attributes = System, Requestor, Title, Priority, Date Needed, Type, Also Notify, Subsystem, Status, Work Order, Assigned To, Team Lead, Percent Complete, Estimated Hrs, Actual Hrs, Date Added, Expected Delivery, Date Completed, Notifications, Completed
Options Priority = A-Emergency{p1}, B-Critical{p2}, C-High{p3}, D-Medium{p4}, E-Low{p5}
Preset Priority = D-Medium
Type Date Needed = Date

XML Extract:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- ELOGD Version 2.6.0-beta2 export.xml -->
<ELOG_LIST>

<ENTRY>
<MID>585</MID>
<DATE>Wed Jun 22 08:29:58 2005</DATE>
<System>SDWIS</System>
<Requestor>Other...</Requestor>
<Title>EDI rejects report to George WAUN</Title>
<Priority>B-Critical</Priority>
<Date_Needed>1119384000</Date_Needed>


Q: could it be the spaces in Attribute name????
Or the differences between Linux and Windows ports?
ELOG V3.1.5-fe60aaf