search

ericmckean / google-refine

Automatically exported from code.google.com/p/google-refine
Other
0 stars 0 forks source link

Date values output as java.util.GregorianCalendar[...,...,...,...] instead of "2011-20-03T00:00:00Z" #439

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
An issue that once was perhaps fixed may have surfaced again.

Old issue number: 294

After using GRefine's date transform on a column of short dates (e.g. 
2011-03-21), when exporting as RDF or using an RDF schema alignment, the values 
of the dates are output incorrectly as a java object. A screenshot is attached 
when aligning an RDF schema.

What is the expected output? What do you see instead?

Expected: " 2011-20-03T00:00:00Z "
Instead: " 
java.util.GregorianCalendar[time=1298937600000,areFieldsSet=true,areAllFieldsSet
=false,lenient=true,zone=sun.util.calendar.ZoneInfo[id=\"Europe/London\",offset=
0,dstSavings=3600000,useDaylight=true,transitions=242,lastRule=java.util.SimpleT
imeZone[id=Europe/London,offset=0,dstSavings=3600000,useDaylight=true,startYear=
0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=3600000,startT
imeMode=2,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=3600000,endTimeM
ode=2]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=?,YEAR=2011,MONTH=2,WEEK_O
F_YEAR=?,WEEK_OF_MONTH=?,DAY_OF_MONTH=1,DAY_OF_YEAR=?,DAY_OF_WEEK=?,DAY_OF_WEEK_
IN_MONTH=?,AM_PM=?,HOUR=?,HOUR_OF_DAY=?,MINUTE=?,SECOND=?,MILLISECOND=?,ZONE_OFF
SET=?,DST_OFFSET=?] "

What version of Google Refine are you using?

2.1 [TRUNK]

What operating system and browser are you using?

Mac OS Lion, Firefox 5.

Is this problem specific to the type of browser you're using or it happens in 
all the browsers you tried?

All.

Please provide any additional information below.

RDF preview:

@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> . 
@prefix foaf: <http://xmlns.com/foaf/0.1/> . 
@prefix owl: <http://www.w3.org/2002/07/owl#> . 
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> . 
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> . 

<http://127.0.0.1:3333/0> xsd:date 
"java.util.GregorianCalendar[time=1298937600000,areFieldsSet=true,areAllFieldsSe
t=false,lenient=true,zone=sun.util.calendar.ZoneInfo[id=\"Europe/London\",offset
=0,dstSavings=3600000,useDaylight=true,transitions=242,lastRule=java.util.Simple
TimeZone[id=Europe/London,offset=0,dstSavings=3600000,useDaylight=true,startYear
=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=3600000,start
TimeMode=2,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=3600000,endTime
Mode=2]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=?,YEAR=2011,MONTH=2,WEEK_
OF_YEAR=?,WEEK_OF_MONTH=?,DAY_OF_MONTH=1,DAY_OF_YEAR=?,DAY_OF_WEEK=?,DAY_OF_WEEK
_IN_MONTH=?,AM_PM=?,HOUR=?,HOUR_OF_DAY=?,MINUTE=?,SECOND=?,MILLISECOND=?,ZONE_OF
FSET=?,DST_OFFSET=?]" . 

<http://127.0.0.1:3333/1> xsd:date 
"java.util.GregorianCalendar[time=1298937600000,areFieldsSet=true,areAllFieldsSe
t=false,lenient=true,zone=sun.util.calendar.ZoneInfo[id=\"Europe/London\",offset
=0,dstSavings=3600000,useDaylight=true,transitions=242,lastRule=java.util.Simple
TimeZone[id=Europe/London,offset=0,dstSavings=3600000,useDaylight=true,startYear
=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=3600000,start
TimeMode=2,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=3600000,endTime
Mode=2]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=?,YEAR=2011,MONTH=2,WEEK_
OF_YEAR=?,WEEK_OF_MONTH=?,DAY_OF_MONTH=1,DAY_OF_YEAR=?,DAY_OF_WEEK=?,DAY_OF_WEEK
_IN_MONTH=?,AM_PM=?,HOUR=?,HOUR_OF_DAY=?,MINUTE=?,SECOND=?,MILLISECOND=?,ZONE_OF
FSET=?,DST_OFFSET=?]" . 

<http://127.0.0.1:3333/2> xsd:date 
"java.util.GregorianCalendar[time=1299024000000,areFieldsSet=true,areAllFieldsSe
t=false,lenient=true,zone=sun.util.calendar.ZoneInfo[id=\"Europe/London\",offset
=0,dstSavings=3600000,useDaylight=true,transitions=242,lastRule=java.util.Simple
TimeZone[id=Europe/London,offset=0,dstSavings=3600000,useDaylight=true,startYear
=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=3600000,start
TimeMode=2,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=3600000,endTime
Mode=2]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=?,YEAR=2011,MONTH=2,WEEK_
OF_YEAR=?,WEEK_OF_MONTH=?,DAY_OF_MONTH=2,DAY_OF_YEAR=?,DAY_OF_WEEK=?,DAY_OF_WEEK
_IN_MONTH=?,AM_PM=?,HOUR=?,HOUR_OF_DAY=?,MINUTE=?,SECOND=?,MILLISECOND=?,ZONE_OF
FSET=?,DST_OFFSET=?]" . 

<http://127.0.0.1:3333/3> xsd:date 
"java.util.GregorianCalendar[time=1299024000000,areFieldsSet=true,areAllFieldsSe
t=false,lenient=true,zone=sun.util.calendar.ZoneInfo[id=\"Europe/London\",offset
=0,dstSavings=3600000,useDaylight=true,transitions=242,lastRule=java.util.Simple
TimeZone[id=Europe/London,offset=0,dstSavings=3600000,useDaylight=true,startYear
=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=3600000,start
TimeMode=2,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=3600000,endTime
Mode=2]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=?,YEAR=2011,MONTH=2,WEEK_
OF_YEAR=?,WEEK_OF_MONTH=?,DAY_OF_MONTH=2,DAY_OF_YEAR=?,DAY_OF_WEEK=?,DAY_OF_WEEK
_IN_MONTH=?,AM_PM=?,HOUR=?,HOUR_OF_DAY=?,MINUTE=?,SECOND=?,MILLISECOND=?,ZONE_OF
FSET=?,DST_OFFSET=?]" .

Original issue reported on code.google.com by danpaulsmith on 25 Aug 2011 at 2:09

Attachments:

GoogleCodeExporter commented 9 years ago 
Issue 294 concerns the CSV exporter.  The RDF exporter is distributed by DERI 
Galway and you can report issues at 
https://github.com/fadmaa/grefine-rdf-extension/issues

If you can reproduce the problem with one of the bundled exporters, please feel 
free to reopen this bug report, but for now I'm closing it since it's not our 
code.

Original comment by tfmorris on 25 Aug 2011 at 4:50