I have successfully set up a spreedsheet view using the default settings, the spreedsheet shows up in the expected path with my data ... very pleased with this but now I really need to use a template to make this useful but I don't seem to be interpreting the instructions correctly: In a cell I have put ${Usage Profile: Function Group} which is the title of the field as shown on the UI but it is always interpreted as a string, putting a quote first. It does this on the resulting view as well as the template view. Manually removing the quote just sees it put back in place.

Given how fundamental this is, I have to figure I'm doing something wrong hence this is a support request rather than a bug report.

CommentFileSizeAuthor
#2 up-view-screenshot.png276.02 KBDave Kinchlea

Comments

infojunkie’s picture

Can't find something obviously wrong in your description. Can you attach a screenshot of the view admin page with the spreadsheet settings? Also, exporting the view here might help.

Dave Kinchlea’s picture

StatusFileSize
new276.02 KB

Sure, hope this helps! and thanks for the assistance!

[just realized my screenshot shows that "Use Template" was not checked, however i do know that needs to be checked and it was .... apparently you can't edit an attachment so this note will have to do]

$view = new view;
$view->name = 'thread_calculator';
$view->description = 'LLE Thread Caclulator';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'usage_profile';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('fields', array(
  'averagetime' => array(
    'label' => 'Average Time (ms)',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'set_precision' => FALSE,
    'precision' => 0,
    'decimal' => '.',
    'separator' => '',
    'prefix' => '',
    'suffix' => '',
    'exclude' => 0,
    'id' => 'averagetime',
    'table' => 'usage_profile_gen',
    'field' => 'averagetime',
    'relationship' => 'none',
  ),
  'functiongroup' => array(
    'label' => 'Function Group',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'exclude' => 0,
    'id' => 'functiongroup',
    'table' => 'usage_profile_gen',
    'field' => 'functiongroup',
    'relationship' => 'none',
  ),
  'count' => array(
    'label' => 'Number of Trnasactions',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'set_precision' => FALSE,
    'precision' => 0,
    'decimal' => '.',
    'separator' => '',
    'prefix' => '',
    'suffix' => '',
    'exclude' => 0,
    'id' => 'count',
    'table' => 'usage_profile_gen',
    'field' => 'count',
    'relationship' => 'none',
  ),
));
$handler->override_option('arguments', array(
  'taskid' => array(
    'default_action' => 'summary asc',
    'style_plugin' => 'jump_menu_summary',
    'style_options' => array(
      'count' => 1,
      'hide' => 1,
      'text' => 'Go',
    ),
    'wildcard' => 'all',
    'wildcard_substitution' => 'All',
    'title' => 'Usage Profile from TaskID %1',
    'breadcrumb' => '',
    'default_argument_type' => 'fixed',
    'default_argument' => '',
    'validate_type' => 'numeric',
    'validate_fail' => 'not found',
    'break_phrase' => 0,
    'not' => 0,
    'id' => 'taskid',
    'table' => 'usage_profile_gen',
    'field' => 'taskid',
    'validate_user_argument_type' => 'uid',
    'validate_user_roles' => array(
      '2' => 0,
      '3' => 0,
      '19' => 0,
      '23' => 0,
      '18' => 0,
      '26' => 0,
      '31' => 0,
      '33' => 0,
      '11' => 0,
    ),
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
    'default_options_div_prefix' => '',
    'default_argument_user' => 0,
    'default_argument_fixed' => '',
    'default_argument_image_size' => '_original',
    'default_argument_php' => '',
    'validate_argument_node_type' => array(
      'blog' => 0,
      'poll' => 0,
      'ad' => 0,
      'announcements' => 0,
      'faq' => 0,
      'image' => 0,
      'minutes' => 0,
      'opportunity_knocks' => 0,
      'sheetnode' => 0,
      'product' => 0,
      'usage_profile' => 0,
      'forum' => 0,
      'panel' => 0,
      'anonymous' => 0,
      'asset' => 0,
      'cck_gallery' => 0,
      'cck_image' => 0,
      'contact_info' => 0,
      'event' => 0,
      'feed' => 0,
      'gate_expert' => 0,
      'gate_policy_pages' => 0,
      'gate_supply' => 0,
      'glossary' => 0,
      'interaction' => 0,
      'interaction_type' => 0,
      'lle_expert' => 0,
      'lle_expert_only' => 0,
      'lle_shout' => 0,
      'nutritional_facts' => 0,
      'profile' => 0,
      'public' => 0,
      'ranking' => 0,
      'rating' => 0,
      'regions' => 0,
      'shoutout' => 0,
      'trust_project' => 0,
      'vendorpage' => 0,
      'vertical_markets' => 0,
    ),
    'validate_argument_node_access' => 0,
    'validate_argument_nid_type' => 'nid',
    'validate_argument_vocabulary' => array(
      '4' => 0,
      '1' => 0,
      '6' => 0,
      '11' => 0,
      '5' => 0,
      '7' => 0,
      '15' => 0,
      '10' => 0,
      '31' => 0,
      '20' => 0,
      '13' => 0,
      '2' => 0,
      '3' => 0,
    ),
    'validate_argument_type' => 'tid',
    'validate_argument_transform' => 0,
    'validate_user_restrict_roles' => 0,
    'image_size' => array(
      '_original' => '_original',
      'thumbnail' => 'thumbnail',
      'preview' => 'preview',
      'exam' => 'exam',
      'teaser' => 'teaser',
    ),
    'validate_argument_signup_status' => 'any',
    'validate_argument_signup_node_access' => 0,
    'validate_argument_php' => '',
  ),
));
$handler->override_option('access', array(
  'type' => 'none',
));
$handler->override_option('cache', array(
  'type' => 'none',
));
$handler->override_option('title', 'Livelink Thread & TPS Calculator');
$handler->override_option('header', '<p>This is a Livelink Thread &amp; TPS Calculator instance generated from a previously saved Usage Profile. You can let Livelink-Experts.com <a href="https://www.livelink-experts.com/admin/content/usage_profile_gen/add">generate a Usage Profile</a> from a Livelink Summary Timings file or you can <a href="https://www.livelink-experts.com/node/add/usage-profile">create your own Usage Profile</a> either by entering the summarized data of your own or by using and modifying existing data. </p><p>&nbsp;</p>');
$handler->override_option('header_format', '2');
$handler->override_option('header_empty', 1);
$handler->override_option('style_plugin', 'sheet');
$handler->override_option('style_options', array(
  'grouping' => '',
  'expansion' => '0',
  'template' => 0,
  'sheetsave' => 'socialcalc:version:1.0
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary=SocialCalcSpreadsheetControlSave
--SocialCalcSpreadsheetControlSave
Content-type: text/plain; charset=UTF-8

# SocialCalc Spreadsheet Control Save
version:1.0
part:sheet
part:edit
part:audit
--SocialCalcSpreadsheetControlSave
Content-type: text/plain; charset=UTF-8

version:1.5
cell:A3:t:${Usage Profile\\c Function Group}
cell:B5:t:${Usage Profile\\c Number of Transactions}
cell:C5:t:${Usage Profile\\c Average Time (ms)}
sheet:c:3:r:5
--SocialCalcSpreadsheetControlSave
Content-type: text/plain; charset=UTF-8

version:1.0
rowpane:0:1:36
colpane:0:1:14
ecell:B20
sort::-1:up::::
--SocialCalcSpreadsheetControlSave
Content-type: text/plain; charset=UTF-8

--SocialCalcSpreadsheetControlSave--
',
));
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->override_option('path', 'usage_profile/%');
$handler->override_option('menu', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
));

infojunkie’s picture

As per your screenshot, the title of your field is "Function Group" (the black text), while "Usage Profile: Function Group" is the field name as exposed by the module (in blue). That should fix it. Please close this issue if it does.

Dave Kinchlea’s picture

Status: Active » Closed (fixed)

Ahh, I knew it had to be simple....thanks!