Feature #384

Time Slider works for data imported via Add New DataSource (outside of Admin Console)

Added by Rebecca Lee over 6 years ago. Updated about 6 years ago.

Status:ResolvedStart date:08/11/2011
Priority:NormalDue date:
Assignee:Andy Dufilie% Done:

100%

Category:-
Target version:1.0
Complexity: OIC Priority:
Required by:

Description

The Time Slider should work for data that is imported outside of the Admin Console.

If the hierarchy is edited to include a year="", it should work.

Users will want the time slider for their own data once they see it!
Also, for our existing website and data stories, we are using a lot of one-time csv files that we don't want cluttering up the Admin Console.

obesity.csv Magnifier (3.92 KB) Andy Dufilie, 08/14/2011 08:55 AM

samplecsvtimeslider.xml Magnifier (106 KB) Rebecca Lee, 08/16/2011 10:42 AM


Subtasks


Related issues

Related to Weave - Other #119: Stop using SecondaryKeyNumColumn and refactor the code related to the dimension slider. Open 07/01/2011
Related to Weave - Bug #770: year tags in csv hierarchies no longer appear in attribute selection Resolved 01/12/2012
Related to Weave - Bug #1029: Time Slider Bug Resolved 08/27/2012

History

#1 Updated by Andy Dufilie over 6 years ago

Fixed for CSV files. Here's an example hierarchy that works for the attached obesity.csv:

      <hierarchy>
        <attribute keyType="US State FIPS Code" csvColumn="US State FIPS Code" name="US State FIPS Code" title="US State FIPS Code"/>
        <attribute keyType="US State FIPS Code" csvColumn="State" name="State" title="State"/>
        <attribute keyType="US State FIPS Code" year="1995" csvColumn="Percent Obese 1995" max="40" title="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="1996" csvColumn="Percent Obese 1996" max="40" title="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="1997" csvColumn="Percent Obese 1997" max="40" title="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="1998" csvColumn="Percent Obese 1998" max="40" title="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="1999" csvColumn="Percent Obese 1999" max="40" title="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2000" csvColumn="Percent Obese 2000" max="40" title="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2001" csvColumn="Percent Obese 2001" max="40" title="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2002" csvColumn="Percent Obese 2002" max="40" title="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2003" csvColumn="Percent Obese 2003" max="40" title="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2004" csvColumn="Percent Obese 2004" max="40" title="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2005" csvColumn="Percent Obese 2005" max="40" title="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2006" csvColumn="Percent Obese 2006" max="40" title="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2007" csvColumn="Percent Obese 2007" max="40" title="Percent Obese" min="0"/>
      </hierarchy>

#2 Updated by Andy Dufilie over 6 years ago

  • Status changed from Open to Resolved

#3 Updated by Andy Dufilie over 6 years ago

  • Assignee set to Andy Dufilie

#4 Updated by Andy Dufilie over 6 years ago

#5 Updated by Rebecca Lee over 6 years ago

I'm testing this with the nightly build from Sunday (Peter updated system yesterday). The year associated with the attribute title changes appropriately, but the data don't redraw. See attached session config. The hierarchy looks ok to me, but perhaps I am doing something incorrectly.

#6 Updated by Andy Dufilie over 6 years ago

Try deleting the name="..." properties in your <attribute/> tags. Those are not being generated anymore. For the time slider to work, the tag needs to be the same except for the csvColumn="..." property.

#7 Updated by Rebecca Lee over 6 years ago

Great, got it to work, thank you Andy!

#8 Updated by Andy Dufilie about 6 years ago

I'm refactoring this code slightly to prepare for the upcoming server refactoring. Instead of using the 'title' property, please start using the 'name' property. For now the title property will continue to work, but it won't show the year as in "myColumn (year)". If you rename all 'title' properties to 'name' properties it will continue to show the year. Now if a title property is specified, that is exactly what will be displayed on screen.

Here's an updated example:

      <hierarchy>
        <attribute keyType="US State FIPS Code" csvColumn="US State FIPS Code" name="US State FIPS Code" title="US State FIPS Code"/>
        <attribute keyType="US State FIPS Code" csvColumn="State" name="State" title="State"/>
        <attribute keyType="US State FIPS Code" year="1995" csvColumn="Percent Obese 1995" max="40" name="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="1996" csvColumn="Percent Obese 1996" max="40" name="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="1997" csvColumn="Percent Obese 1997" max="40" name="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="1998" csvColumn="Percent Obese 1998" max="40" name="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="1999" csvColumn="Percent Obese 1999" max="40" name="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2000" csvColumn="Percent Obese 2000" max="40" name="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2001" csvColumn="Percent Obese 2001" max="40" name="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2002" csvColumn="Percent Obese 2002" max="40" name="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2003" csvColumn="Percent Obese 2003" max="40" name="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2004" csvColumn="Percent Obese 2004" max="40" name="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2005" csvColumn="Percent Obese 2005" max="40" name="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2006" csvColumn="Percent Obese 2006" max="40" name="Percent Obese" min="0"/>
        <attribute keyType="US State FIPS Code" year="2007" csvColumn="Percent Obese 2007" max="40" name="Percent Obese" min="0"/>
      </hierarchy>

#9 Updated by Andy Dufilie about 6 years ago

  • Target version set to 1.0

Also available in: Atom PDF