Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Introduction (Custom Menus) • Using TWBS Credit Card Processing • Introduction (ExchangeConnector)
versago3:dataview_display

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
versago3:dataview_display [2022/09/08 13:12]
dlee 		versago3:dataview_display [2024/03/14 14:16] (current)
dlee [Field Display]
Line 10: Line 10:
   * **Display Type** identifies how the data in a column should be interpreted for presentation.   * **Display Type** identifies how the data in a column should be interpreted for presentation.
   * **Localization** is used to adjust the formatting of date, datetime, and currency __types__.   * **Localization** is used to adjust the formatting of date, datetime, and currency __types__.
-  * **File Name** is only accessible when the data type of the column is binary, blob, or varbinary .  See **Note 2** below.+  * **File Name** is only accessible when the data type of the column is binary, blob, or varbinary .  See **Note 1** below.
  
-  * Numeric values can be used to present **KPIs** (Key Performance Indicators) markers. See the //**[[Defining_KPIs|Defining KPIs]]**// section for more information.+<WRAP center round info 80%> 
 +Users will be able to sort by clicking column heading. Multiple column can be sorted by using the CTRL key 
 +</WRAP>
  
 **Note 1** **Note 1**
  
-If you need to report date and time values in a specific format that cannot be set by the __localization__ options it may be necessary to use the SQL Convert function in the SQL Select for the report and present the value as a text value. More information on the SQL CONVERT function, and available formats, can be found here: https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql.+A Data View can display a file for download. The file can be stored in the file system or in the DB in a binary field
  
-**Note 2** +  * **Disk Source Files** should be included by using the full path name in the field.
- +
-Beginning with Versago v2.4 it is possible to download files on disk or files stored as binary data in a database.  The second option is primarily intended for files uploaded via a Versago form. +
- +
-  * **Disk Source Files** are identified using a full path name.+
     * The source files must be in a folder location that can be accessed by Versago and Windows IIS. What this means is that files will typically need to be in a network share, e.g. "\\ShareName\FolderPath\FileName" and not in a typical file path like “C:\Data\FileName”.     * The source files must be in a folder location that can be accessed by Versago and Windows IIS. What this means is that files will typically need to be in a network share, e.g. "\\ShareName\FolderPath\FileName" and not in a typical file path like “C:\Data\FileName”.
-      * This information is contained in the report results and acts as a pointer to the desired file.+      * The Display Type should be set to File
  
   * **Database Source Files** are identified by reference to specific records in a database.  The information provided below refers to files uploaded via a Versago form.   * **Database Source Files** are identified by reference to specific records in a database.  The information provided below refers to files uploaded via a Versago form.
   * The data is found in a table named "TWBS_VGO_FormAttachments".  This table is found in the database where the data captured in the form is stored.   * The data is found in a table named "TWBS_VGO_FormAttachments".  This table is found in the database where the data captured in the form is stored.
-    * Two values are required from the record: FileName and FileContent.  __FileContent__ is the binary data that will be converted for download.  __FileName__ is used as the reference to the binary data. +    * Two values are required from the record: FileName and FileContent.  __FileContent__ is the binary data that will be converted for download.  __FileName__ contains the file name of the binary. 
-    * When the data type of the column is binary, blob, or varbinary the __File Name__ field for the FileContent row presents a drop-down list of fields from the report query.  Select the column name that contains the associated file name. +    * The Display Type of __FileContent__ should be set to File 
-    * It is not necessary to display the __FileName__ value in the report, but showing the user the name of the file is typically very helpful.+    * It is not necessary to display the __FileName__ value in the report, but showing the name of the file is typically very helpful.
   
 The **files in a database** approach does require that the __FileContent__ value is not NULL.  As it is very possible that a report row will not have a corresponding report to download, use the following SQ.  Setting FileContent to 0 when the database value is NULL allows the report to execute without errors.   The **files in a database** approach does require that the __FileContent__ value is not NULL.  As it is very possible that a report row will not have a corresponding report to download, use the following SQ.  Setting FileContent to 0 when the database value is NULL allows the report to execute without errors.  
Line 40: Line 38:
 In both cases, keep in mind that any user that has access to the report can download any file listed in the report. If certain files should be available to certain group(s) of users, different reports may be needed. In both cases, keep in mind that any user that has access to the report can download any file listed in the report. If certain files should be available to certain group(s) of users, different reports may be needed.
  
-===MIME Types (Technical Topic)===+<WRAP center round info 80%> 
 +Video regarding files and Data Views 
 +</WRAP> 
 + 
 +====Highlights==== 
 + 
 +Highlights are a simple visual cue presented when the data matches the defined conditions. Highlighs can be configured for any numeric value in a Versago Data View. 
 + 
 +{{ :versago3:dv_display02.png?400 |}} 
 + 
 +====Derived Fields==== 
 + 
 +It is possible to calculate values at the time a report is executed and present them as a new column. This is done using the [**Derived Field**]button at the bottom of the page.
  
-Multipurpose Internet Mail Extensions (**MIME**) types identify the types of content that can be served to a browser or a mail client from a Web server. Since Versago is a browser-based application, any file types that may be downloaded must be defined to the web server.+{{ :versago3:dv_display03.png?400 |}}
  
-The most common file types (PDF, XLXS, TXT, DOCX, etc.) are already defined in IIS (the Windows web server). The general process to add/maintain MIME types is described here: https://technet.microsoft.com/en-us/library/cc725608(v=ws.10).aspx.+  - Enter the name for the new derived field 
 +  - Use the available functions to build your formula 
 +  - Click validate to check your syntax 
 +  - Save the derived field
  
-One MIME type that is not defined by default is for Outlook email messages. These files have the extension **.msg**. Specific steps to add this MIME type are found here: http://blogs.catapultsystems.com/rhutton/archive/2013/10/25/unable-to-open-outlook-message-file-in-web-browser-msg/.+====Images in Data Views====
  
-====Calculated Fields====+The following image formats are supported.
  
-It is possible to calculate values at the time a report is executed and present them as a new column. This is done using the [**Add Calculated**] and [**Update Calculated**] buttons on the “Field Display Details” page.+  * PNG (preferred) 
 +  * JPG 
 +  * GIF 
 +  * BMP (not recommended) 
 +   
 +Each image must be provided in four (4) sizes.
  
-{{  :versago:reports10.png?400  |}}+  * 45 x 45 for thumbnail image 
 +  * 65 x 65 for thumbnail image 
 +  * 250 x 250 for mouse-over (hover) image 
 +  * 1024 x 1024 for on-click (large) image 
 +   
 +Images are held in the folder C:\Program Files(x86)\TWBS\Versago\WebApp\SiteImages.
  
-See the **//[[Calculated_Fields|Calculated Fields]]//** page for more information.+<WRAP center round info 80%> 
 +Video regarding images and Data Views 
 +</WRAP>
  
-====Images in Reports==== 
-Go **//[[images_in_reports|here]]//** for additional information on using images in reports. 
  
 ---- ----
versago3/dataview_display.1662657154.txt.gz · Last modified: 2022/09/08 13:12 by dlee

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki