{"id":24225,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/server-side-templates-1\/"},"modified":"2025-02-14T11:12:12","modified_gmt":"2025-02-14T19:12:12","slug":"server-side-templates-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/","title":{"rendered":"Server-Side Templates"},"content":{"rendered":"

Server-side templates can be defined for many API and CLI commands. These templates allow you to control the presentation of the output from the API command. Most commonly this is used to allow the administrator to integrate ExtraView with their company\u2019s own web site.<\/p>\n

For example, a page within your company\u2019s web site can perform a search of the ExtraView database and return the results formatted with the same look and feel as the web site.<\/p>\n

Templates allow you to use “tags” that are substituted at runtime, with the actual value in a record. For example, the tag __STATUS__<\/span> refers to the value of the STATUS field of the current issue. Tags are available for most fields in the data dictionary. In addition, if you place a data dictionary field on a template, it must exist on the Detailed Report<\/b> layout inherited by the specific Business Area and Project. The user must also have read permission to the field.<\/p>\n

TEXTAREA, LOGAREA and PRINTTEXT fields have special handling within ExtraView. This is because they can be broken down into three components, the text itself, the user\u2019s name who entered the text, and a timestamp. Each of these components can be accessed individually, as shown in the following example. Note that the field name itself must be included as a tag, although it does not display anything in the output. Therefore, an HTML fragment that might display the DESCRIPTION field may look like:<\/p>\n

\n

<TD>
\n\t__DESCRIPTION__
\n\t__DESCRIPTION.USER__ : __DESCRIPTION.TIMESTAMP__
\n\t<BR><BR>
\n\t__DESCRIPTION.TEXT__
\n\t<BR>
\n\t<\/TD><\/p>\n

\n

\n\tThe full explanation for each part of the field is as follows, where DDNAME is the data dictionary name of the field of display type TEXTAREA, LOGAREA or PRINTTEXT.<\/p>\n\n\n\n\n\n\n\n
\n\t\t\t\tField name<\/td>\n\n\t\t\t\tExplanation<\/td>\n<\/tr>\n
\n\t\t\t\t__DDNAME__<\/td>\n\n\t\t\t\tA tag with the data dictionary name must be included in the template. No output occurs with this tag. It is a placeholder that ensures the remaining fields will be processed correctly<\/td>\n<\/tr>\n
\n\t\t\t\t__DDNAME.TEXT__<\/td>\n\n\t\t\t\tThis is used to return the body of text within the comments<\/td>\n<\/tr>\n
\n\t\t\t\t__DDNAME.USER__<\/td>\n\n\t\t\t\tThis is used to return the name of the user who entered the comment<\/td>\n<\/tr>\n
\n\t\t\t\t__DDNAME.TIMESTAMP__<\/td>\n\n\t\t\t\tThis is used to return the date (and time) that the comment was entered. This will be returned in the current user\u2019s date and time format that is defined in their personal settings<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Three special tags are not fields in the data dictionary:<\/p>\n\n\n\n\n\n\n
\n\t\t\t\tTag name<\/td>\n\n\t\t\t\tExplanation<\/td>\n<\/tr>\n
\n\t\t\t\t__RESULTS__<\/td>\n\n\t\t\t\tthis tag returns the result string that is sent, upon execution of a call to the API. For example, if you use an HTML form to insert a record into ExtraView, and define a template that contains only the tag __RESULTS__<\/span>, then the output would be: Problem #12342 added.<\/td>\n<\/tr>\n
\n\t\t\t\t__ERR_RESULTS__<\/td>\n\n\t\t\t\tthis tag returns any error as a result of executing the API command. It is often used in conjunction with an error handling template, as described below<\/td>\n<\/tr>\n
\n\t\t\t\t__RECORD_COUNT__<\/td>\n\n\t\t\t\tthis tag returns the number of records found from the API action named search. You may use this field in the header or footer section of a template (see below), but not in the body part of a template.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\tThe API commands that work with templates are:<\/p>\n

    \n
  • \n\t\tdelete<\/li>\n
  • \n\t\tfill_in<\/li>\n
  • \n\t\tget<\/li>\n
  • \n\t\tinsert<\/li>\n
  • \n\t\tinsert_user<\/li>\n
  • \n\t\tlist_attachment<\/li>\n
  • \n\t\tsearch<\/li>\n
  • \n\t\tupdate<\/li>\n
  • \n\t\tupdate_user_password<\/li>\n<\/ul>\n

    The templates must be stored in a directory in your environment, typically located within your installation in a directory named user_templates. This directory is placed within your ExtraView installation, at the same level as the templates directory that resides inside the WEB-INF directory. This location may vary according to how you installed ExtraView. The ExtraView Administration screens have a feature that allows you to upload files directly to this directory from your local computer. Templates are processed slightly differently, according to whether they are intended to generate text or generate HTML. First, the assumption is that if the template name has a suffix of .html<\/b> or .htm<\/b>, then it is assumed that it will generate HTML code. With all other file suffixes, the assumption is that they contain text. If they are HTML templates:<\/p>\n

      \n
    • \n\t\tThe api calls search<\/em> and get<\/em> will have escaping enabled<\/li>\n
    • \n\t\tFields that have display_as_url<\/b> set as attribute in the data dictionary will be rendered as HTML<\/li>\n
    • \n\t\tBlank or null values in fields will result in &nbsp;<\/b> being rendered<\/li>\n<\/ul>\n

      The template you define can be in one of two forms:<\/p>\n

      \n\tStand-alone templates, used to format the results<\/h3>\n

      \n\tDesired Output<\/h4>\n

      <\/p>\n

      \n\tSample Template Code<\/h4>\n
      \n

      <html>
      \n\t<head>
      \n\t<title>ExtraView Insert Issue<\/title>
      \n\t<\/head>
      \n\t<body bgcolor=”#FFFFFF”>
      \n\t<p align=”center”>Thank you for submitting your issue. It has been added to the tracking
      \n\tdatabase with the ID<\/p>
      \n\t<p align=”center”><font color=”#000000″ size=”5″> __ID__ <\/font><\/p>
      \n\t<p align=”center”>Please take note of this number and use this if you wish to inquire
      \n\tabout the status.<\/p>
      \n\t<\/body>
      \n\t<\/html><\/p>\n

      \n

      \n\tStructured Formatting of Results<\/h3>\n

      This is composed of a template structure that may have up to three sections, each of which resides in a separate file. Each file name is defined by prefixing the template name with the letter h, b or f, according to whether it is the header section, body section or the footer section. Each section is optional, although it makes no real sense to not have the body section.<\/p>\n

      \n\tOverall Desired Output<\/h4>\n

      <\/p>\n

      \n\tSample Template Code<\/h4>\n

      The template code is split into three files representing the fixed header, the repeating body and the fixed footer.<\/p>\n

      Header File<\/b> – file name begins with “h”<\/p>\n

      \n

      <html>
      \n\t<head>
      \n\t<title>ExtraView Insert Issue<\/title>
      \n\t<\/head>
      \n\t<body bgcolor=”#FFFFFF” leftmargin=”0″ topmargin=”0″>
      \n\t<p><img src=”MyCo.jpg” width=”1000″ height=”120″><\/p>
      \n\t<p><font size=”4″>The results of your search found the following records<\/font> <\/p>
      \n\t<table width=”100%” border=”0″ cellpadding=”0″><\/p>\n

      \n

      \n\tBody File<\/b> – file name begins with “b”<\/p>\n

      \n

      <tr bgcolor=”#CCCCFF”>
      \n\t<td>Issue Number<\/td>
      \n\t<td>Status<\/td>
      \n\t<td>Assigned To<\/td>
      \n\t<\/tr>
      \n\t<tr>
      \n\t<td>__ID__<\/td>
      \n\t<td>__STATUS__<\/td>
      \n\t<td>__ASSIGNED_TO__<\/td>
      \n\t<\/tr>
      \n\t<tr>
      \n\t<td colspan=”3″><b>__SHORT_DESCR__<\/b><\/td>
      \n\t<\/tr>
      \n\t<tr>
      \n\t<td colspan=”3″> __REPEAT_START__ __Description__ __REPEAT_STOP__ <\/td>
      \n\t<\/tr><\/p>\n

      \n

      \n\tFooter File<\/b> – file name begins with “f”<\/p>\n

      \n

      <\/TABLE>
      \n\t<hr>
      \n\t<p><i><b>MyCo<\/b><\/i> – Your one stop shop for integrated data services<br> Powered by ExtraView<\/p>
      \n\t<\/body>
      \n\t<\/html><\/p>\n

      \n

      \n\tThe fill_in Template<\/h3>\n

      It is sometimes useful to be able to generate a template and populate it with values that do not originate in ExtraView\u2019s database. The fill_in action fulfills this need.<\/p>\n

      \n\tSyntax<\/h4>\n

      http:\/\/www.myserver.com\/evj\/ExtraView\/ev_api.action?user_id=username &password=password&statevar=fill_in&p_template_file=this_template.html&id=12345 &any_name_at_all=Phyllis%20Mitchell … … …<\/p>\n

      The template file, this_template.html<\/span>, will be returned to the user\u2019s screen, with the values for id<\/span> and any_name_at_all<\/span> filled in.<\/p>\n

      \n\tSample Template File<\/h4>\n
      \n

      <html>
      \n\t<head>
      \n\t<title>ExtraView Entry Details<\/title>
      \n\t<\/head>
      \n\t<body>
      \n\t<hr>
      \n\t<p align=center>The ID for the problem is __ID__ and it was entered by __ANY_NAME_AT_ALL__.<\/p>
      \n\t<hr>
      \n\t<\/body>
      \n\t<\/html><\/code><\/p>\n

      \n

      \n\tBrowser Output<\/h4>\n

      <\/p>\n

      \n\tThe error.html<\/span> Template<\/h3>\n

      If the code that executes in the API command that was submitted completes with an error or unexpected condition, the template named error.html is invoked and used to display the error to the user. Within this template, the tag __ERR_RESULTS__<\/span> is replaced with the actual error message from the command being executed.<\/p>\n

      \n\tSample Template File<\/h4>\n
      \n

      <html>
      \n\t<head>
      \n\t<title>ExtraView Error!<\/title>
      \n\t<\/head>
      \n\t<body bgcolor=”#cedece”>
      \n\t<hr>
      \n\t<p align=center>__ERR_RESULTS__<\/p>
      \n\t<hr>
      \n\t<\/body>
      \n\t<\/html><\/p>\n

      \n

      \n\tBrowser Output<\/h4>\n

      <\/p>\n","protected":false},"excerpt":{"rendered":"

      Server-side templates can be defined for many API and CLI commands. These templates allow you to control the presentation of the output from the API command. Most commonly this is used to allow the administrator to integrate ExtraView with their company\u2019s own web site. For example, a page within your company\u2019s web site can perform…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24223,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-24225","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\nServer-Side Templates - Product Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Server-Side Templates - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Server-side templates can be defined for many API and CLI commands. These templates allow you to control the presentation of the output from the API command. Most commonly this is used to allow the administrator to integrate ExtraView with their company\u2019s own web site. For example, a page within your company\u2019s web site can perform...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-14T19:12:12+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/\",\"name\":\"Server-Side Templates - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-14T19:12:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ExtraView 25\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Application Programming Interface\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Server-Side Templates\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Server-Side Templates - Product Documentation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/","og_locale":"en_US","og_type":"article","og_title":"Server-Side Templates - Product Documentation","og_description":"Server-side templates can be defined for many API and CLI commands. These templates allow you to control the presentation of the output from the API command. Most commonly this is used to allow the administrator to integrate ExtraView with their company\u2019s own web site. For example, a page within your company\u2019s web site can perform...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-14T19:12:12+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/","name":"Server-Side Templates - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-14T19:12:12+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/server-side-templates-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"ExtraView 25","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":3,"name":"Application Programming Interface","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/"},{"@type":"ListItem","position":4,"name":"Server-Side Templates"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v25\/#website","url":"https:\/\/docs.extraview.com\/v25\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v25\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v25\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v25\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v25\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24225","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/comments?post=24225"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24225\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24223"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=24225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}