haha oh man, I've been trying to figure it out for AGES.

Seems that data_table_node never populates with anything. Some people in these issue queues are manually adding rows with phpMyAdmin, under the impression that this is the way to do it.

The two relationships appear in data table views, but they don't work because the data_table_node table is empty. Also, there's a weird block that becomes available, which contains a form of sorts, but this only causes errors if anything at all.

Anyone have any ideas? Can this be documented, or is it simply leftover from previous functionality?

Sorry, I'm just really confused! :)

Comments

patcon’s picture

Ahhh.. wait... I just had a revelation. Does it perhaps allow data imported by the standalone importers to be attached to nodes???

dafeder’s picture

Title: What the heck does Data Node module do? » Data Node module does not populate data_table_node
Priority: Normal » Major

Yeah, I can't figure this out either. It looks like a pretty major bug, but maybe I'm just misinterpreting the rather esoteric (IMO) help text on these forms. I want to be able to set up a relationship in a view for data created with Feeds module, so I can pull, say, the name of my feed node into the view row. I set up the table with what would appear to be the correct settings, but there's still nothing in that table.

dafeder’s picture

My table setup, if helpful:


$data_table = new stdClass;
$data_table->disabled = FALSE; /* Edit this to true to make a default data_table disabled initially */
$data_table->api_version = 1;
$data_table->title = 'Fast feed';
$data_table->name = 'feeds_data_feed_fast';
$data_table->table_schema = array(
  'fields' => array(
    'feed_nid' => array(
      'type' => 'int',
      'unsigned' => TRUE,
      'not null' => TRUE,
    ),
    'id' => array(
      'type' => 'serial',
      'size' => 'normal',
      'unsigned' => TRUE,
      'not null' => TRUE,
    ),
    'timestamp' => array(
      'description' => 'The Unix timestamp for the data.',
      'type' => 'int',
      'unsigned' => TRUE,
      'not null' => FALSE,
    ),
    'title' => array(
      'type' => 'varchar',
      'length' => 255,
      'not null' => FALSE,
    ),
    'description' => array(
      'type' => 'text',
      'not null' => FALSE,
    ),
    'url' => array(
      'type' => 'text',
      'not null' => FALSE,
    ),
    'guid' => array(
      'type' => 'text',
      'not null' => FALSE,
    ),
    'published' => array(
      'type' => 'int',
      'size' => 'normal',
      'unsigned' => TRUE,
    ),
  ),
  'indexes' => array(
    'feed_nid' => array(
      0 => 'feed_nid',
    ),
    'id' => array(
      0 => 'id',
    ),
    'timestamp' => array(
      0 => 'timestamp',
    ),
    'url' => array(
      0 => array(
        0 => 'url',
        1 => 255,
      ),
    ),
    'guid' => array(
      0 => array(
        0 => 'guid',
        1 => 255,
      ),
    ),
  ),
  'primary key' => array(
    0 => 'id',
  ),
);
$data_table->meta = array(
  'fields' => array(
    'feed_nid' => array(
      'label' => '',
      'views_field_handler' => 'views_handler_field_numeric',
      'views_filter_handler' => 'views_handler_filter_numeric',
      'views_argument_handler' => 'views_handler_argument_numeric',
      'views_sort_handler' => 'views_handler_sort',
    ),
    'id' => array(
      'label' => '',
      'views_field_handler' => 'views_handler_field_numeric',
      'views_filter_handler' => 'views_handler_filter_numeric',
      'views_argument_handler' => 'views_handler_argument_numeric',
      'views_sort_handler' => 'views_handler_sort',
    ),
    'timestamp' => array(
      'label' => '',
      'views_field_handler' => 'views_handler_field_date',
      'views_filter_handler' => 'views_handler_filter_date',
      'views_argument_handler' => 'views_handler_argument_date',
      'views_sort_handler' => 'views_handler_sort_date',
    ),
    'title' => array(
      'label' => '',
      'views_field_handler' => 'views_handler_field',
      'views_filter_handler' => 'views_handler_filter_string',
      'views_argument_handler' => 'views_handler_argument_string',
      'views_sort_handler' => 'views_handler_sort',
    ),
    'description' => array(
      'label' => '',
      'views_field_handler' => 'views_handler_field',
      'views_filter_handler' => 'views_handler_filter_string',
      'views_argument_handler' => 'views_handler_argument',
      'views_sort_handler' => 'views_handler_sort',
    ),
    'url' => array(
      'label' => '',
      'views_field_handler' => 'views_handler_field_url',
      'views_filter_handler' => 'views_handler_filter_string',
      'views_argument_handler' => 'views_handler_argument',
      'views_sort_handler' => 'views_handler_sort',
    ),
    'guid' => array(
      'label' => '',
      'views_field_handler' => 'views_handler_field',
      'views_filter_handler' => 'views_handler_filter_string',
      'views_argument_handler' => 'views_handler_argument',
      'views_sort_handler' => 'views_handler_sort',
    ),
    'tid' => array(
      'label' => '',
    ),
    'published' => array(
      'label' => '',
      'views_field_handler' => 'views_handler_field_date',
      'views_filter_handler' => 'views_handler_filter_date',
      'views_argument_handler' => 'views_handler_argument_date',
      'views_sort_handler' => 'views_handler_sort_date',
    ),
  ),
  'data_taxonomy' => array(
    'vocabularies' => array(
      13 => 13,
    ),
    'id' => 'id',
  ),
  'data_node' => array(
    'content_type' => 'feed_fast',
    'id' => 'id',
  ),
);
Danny_Joris’s picture

I'm confused about all the mentioned issues as well. Any more info is welcome.

jonhattan’s picture

Version: 6.x-1.0-alpha14 » 6.x-1.x-dev

In case you're using feeds module and looking for a relation for feed_nid to its source node: #989778: Views relationship to source node for fast feeds. For this relation it is not needed data_node module as the feeds importer data table already contains the nid.

rho_’s picture

Status: Active » Closed (duplicate)

This seems to be a duplicate of http://drupal.org/node/898562