Re: [ddsteps-user] Converting from Excel Date to java.util.Date

[<bjo...@ja...>]

Hi Saad,

Thanks for providing such a good error report.
Possibly you already have been provided with an answer - in that case =20=

please disregard this reply.

Right now our lead on DDSteps is away. He just turned father :-)

Could you please create an issue in Jira with the information below?
We'll get to it as soon as possible.

Thanks again for your help,
Bj=F6rn



28 dec 2006 kl. 18.12 skrev Saa...@Co...:

> Hi
>
> ddsteps version 1.1.1-beta2
>
> An excel date comes back as one day previous in java.util.Date in =20
> my application.
> According to the jxl faq its due to a GMT TimeZone used by jxl and =20
> local TimeZone
> used by the application ref=3Dhttp://www.andykhan.com/jexcelapi/=20
> tutorial.html#dates.
> There is no fix provided by jxl since its upto the client app to =20
> handle the date without
> the GMT timezone. In an effort to get my unit test to work I digged =20=

> a little further
> in ddsteps code to get the correct date.
>
> I made the change at org.ddsteps.dataset.excel.getValue() line # =20
> 102. with the following code.
>
> ...
> DateCell dateCell =3D (DateCell) cell;
> String pattern =3D ((SimpleDateFormat)dateCell.getDateFormat=20
> ()).toPattern();
> SimpleDateFormat sdf =3D new SimpleDateFormat(pattern);
> Date date=3Dnull;
> try {
>   date =3D sdf.parse(dateCell.getContents());
> } catch (ParseException e) {
>   throw new RuntimeException();
> }
>
> return date;
> ...
>
> Since I dont know if this is the right place and/or prefered type =20
> of fix.
> How and when can I get a fix for ddsteps for this problem? Do I =20
> need to create an issue in jira?
>
> Thanks
> Saad.
>
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> Confidentiality Notice: The information contained in and =20
> transmitted with this communication is strictly confidential, is =20
> intended only for the use of the intended recipient, and is the =20
> property of Countrywide Financial Corporation or its affiliates and =20=

> subsidiaries.  If you are not the intended recipient, you are =20
> hereby notified that any use of the information contained in or =20
> transmitted with the communication or dissemination, distribution, =20
> or copying of this communication is strictly prohibited by law.  If =20=

> you have received this communication in error, please immediately =20
> return this communication to the sender and delete the original =20
> message and any copy of it in your possession.
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
> ----------------------------------------------------------------------=20=

> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to =20
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?=20
> page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV____________________________=
____=20
> _______________
> ddsteps-user mailing list
> dds...@li...
> https://lists.sourceforge.net/lists/listinfo/ddsteps-user