Futurama Logo

Welcome to the Futurama Support Site

The Futurama Support Site is the website where you can find Futurama and Futurama Vision documentation. If you have any questions about the support pages or if you want to provide us feedback please send us an e-mail.




Index Storing data in Vision from a Futurama application
Previous  |  Next

 1      About Futurama
 1.1        Version information
 1.2        Getting Started
 1.2.1          Futurama Website
 1.2.1.1            Behavior of Futurama regarding TimeOuts, Login and Logoff
 1.2.1.2            Replacing an existing Futurama Session
 1.2.2          Futurama Webservice
 1.2.2.1            warmUpDocuments
 1.2.3          Futurama Export
 1.3        Overview - Futurama Modules
 1.3.1          Overview - Futurama Accounts
 1.3.2          Overview - Futurama Server
 1.3.3          Overview - Futurama Monitor
 1.3.4          Overview - Futurama Insight
 1.3.5          Overview - Futurama Console
 1.3.6          Overview - Futurama Webservice
 1.4        Loadbalancing Futurama applications
 1.4.1          Getting the most out of Futurama Web using the Load-Balancer
 1.4.2          Application Request Routing
 1.5        Text management and Multi-language
 2      Installation – Configuration – Testing
 2.1        Installation - Futurama Website Edition
 2.1.1          Installation Futurama HTML
 2.1.2          Installation Futurama Monitor
 2.1.3          Installation Futurama Insight
 2.1.4          Installation Futurama Accounts
 2.1.5          Installation SAML2LoadBalancer
 2.2        Installation - Futurama Export Edition
 2.2.1          Installation Futurama Console
 2.2.2          Installation Futurama Server
 2.3        Installation - Futurama Webservice Edition
 2.3.1          Installation Futurama Webservice
 2.4        Installation Futurama Editor
 2.5        Configuration
 2.5.1          Configuration - Cache
 2.5.2          Configuration - Calculation
 2.5.3          Configuration - Debug
 2.5.4          Configuration - File manager
 2.5.5          Configuration - Fileproviders
 2.5.6          Configuration - Format
 2.5.7          Configuration - History
 2.5.8          Configuration - Identity Provider
 2.5.9          Configuration - Log
 2.5.10           Configuration - Mail
 2.5.11           Configuration - Mapping
 2.5.12           Configuration - Monitor
 2.5.13           Configuration - PlugIns
 2.5.14           Configuration - Rendering
 2.5.15           Configuration - ScenarioRecording
 2.5.16           Configuration - Security
 2.5.17           Configuration - Server
 2.5.18           Configuration - Vision
 2.5.19           Configuration - WebAPI
 2.6        Logging
 2.7        Troubleshooting
 2.8        Security - hardening
 3      Updating and file compatibility
 3.1        Updating Futurama - Compatibility behavior
 3.2        Converting Futurama documents
 3.3        12819 - DataTable file updates
 3.4        12889 - DataTable file updates
 3.5        Conversion web.config to .NET Framework 4
 3.6        Deprecated conversion formulas
 4      Futurama Editor - How to
 4.1        At first glance
 4.2        Developing in the Futurama Editor
 4.2.1          Working with objects
 4.2.2          Evaluating objects
 4.2.3          Finding objects
 4.3        Transferring objects
 4.4        Testing objects
 4.5        Validating objects
 4.6        Troubleshooting objects
 4.7        Advanced/special functionality
 4.8        Checking the layout of objects
 5      Futurama - Formulas
 5.1        Futurama Formulas - Date and time
 5.1.1          Date
 5.1.2          Day
 5.1.3          Days360
 5.1.4          Days360Excel
 5.1.5          DaysInMonth
 5.1.6          DaysInPeriod
 5.1.7          Min
 5.1.8          Max
 5.1.9          Month
 5.1.10           Now
 5.1.11           WeekDay
 5.1.12           Year
 5.2        Futurama Formulas - Math
 5.2.1          Abs
 5.2.2          Add
 5.2.3          Divide
 5.2.4          Floor
 5.2.5          Ln
 5.2.6          Log
 5.2.7          Log10
 5.2.8          Mod
 5.2.9          Multiply
 5.2.10           Pi
 5.2.11           Power
 5.2.12           Rand
 5.2.13           Round
 5.2.14           RoundDown
 5.2.15           RoundUp
 5.2.16           SquareRoot
 5.2.17           Subtract
 5.3        Futurama Formulas - Statistical
 5.3.1          AverageDeviation
 5.3.2          Beta
 5.3.3          Binomial
 5.3.4          Covariance
 5.3.5          Factorial
 5.3.6          Gamma
 5.3.7          GeometricMean
 5.3.8          Lognormal
 5.3.9          Max
 5.3.10           Median
 5.3.11           Min
 5.3.12           Normal
 5.3.13           StandardDeviation
 5.3.14           Uniform
 5.3.15           Variance
 5.4        Futurama Formulas - Text
 5.4.1          CalculateBase64Hashcode
 5.4.2          CalculateXmlHashcode
 5.4.3          Concatenate
 5.4.4          ConcatenateBase64
 5.4.5          ContainsText
 5.4.6          Convert.CSV.2.XML
 5.4.7          ConvertFromBase64
 5.4.8          ConvertToBase64
 5.4.9          ConvertXml
 5.4.10           DecodeURL
 5.4.11           DecryptXml
 5.4.12           EncodeURL
 5.4.13           EncryptXml
 5.4.14           Find
 5.4.15           HashBase64EncodedFile
 5.4.16           HashBase64EncodedFileWithBase64
 5.4.17           HashText
 5.4.18           HashTextWithBase64
 5.4.19           Left
 5.4.20           Len
 5.4.21           Linefeed
 5.4.22           Lower
 5.4.23           Mid
 5.4.24           Proper
 5.4.25           ReadConfigKey
 5.4.26           ReadDirectoryNames
 5.4.27           ReadFile
 5.4.28           ReadFileAsBase64
 5.4.29           ReadFileNames
 5.4.30           ReadFileWithEncoding
 5.4.31           ReadXPathScalar
 5.4.32           ReadXPathVector
 5.4.33           Repeat
 5.4.34           Right
 5.4.35           Substitute
 5.4.36           Trim
 5.4.37           TrimLeft
 5.4.38           TrimRight
 5.4.39           Upper
 5.4.40           ValidatePattern
 5.4.41           XsdMessages
 5.5        Futurama Formulas - Logical
 5.5.1          And
 5.5.2          IsEmpty
 5.5.3          If
 5.5.4          IsEqual
 5.5.5          IsEven
 5.5.6          IsGreater
 5.5.7          IsGreaterEqual
 5.5.8          IsIBANChecksumValid
 5.5.9          IsLess
 5.5.10           IsLessEqual
 5.5.11           IsMemberOfGroup
 5.5.12           IsNotEqual
 5.5.13           IsOdd
 5.5.14           IsValidXml
 5.5.15           Not
 5.5.16           Or
 5.5.17           ValidateNPR
 5.6        Futurama Formulas - Table
 5.6.1          FindNextRow
 5.6.2          FindPreviousRow
 5.6.3          FindRow
 5.6.4          Sort
 5.6.5          VLookUp
 5.7        Futurama Formulas - Document
 5.7.1          CountErrors
 5.7.2          GetPathToDataFiles
 5.7.3          GetPortNumber
 5.7.4          GetRelativePathToDataFiles
 5.7.5          GetSessionID
 5.7.6          IsLicenceAvailable
 5.7.7          ReadError
 5.7.8          ReadIdentityProviderResult
 5.7.9          ReadRequestIP
 5.7.10           ReadRequestParameter
 5.7.11           ReadUserAgent
 5.7.12           ReadVersionNumber
 5.7.13           SessionTimeOut
 5.7.14           URL
 5.7.15           UserName
 5.8        Futurama Formulas - Conversion
 5.8.1          Convert.Excel.to.XML
 5.8.2          ConvertJSONtoXml
 5.8.3          ConvertTextToDate
 5.8.4          ConvertTextToNumber
 5.8.5          ConvertToBoolean
 5.8.6          ConvertToDouble
 5.8.7          ConvertToLong
 5.8.8          ConvertToString
 5.8.9          FormatDate
 5.8.10           FormatNumber
 5.8.11           Value
 5.9        Futurama Formulas - Matrix
 5.9.1          AddMatrices
 5.9.2          AddScalarToMatrix
 5.9.3          Cumulative
 5.9.4          CumulativeProductMatrix
 5.9.5          Distinct
 5.9.6          DivideMatrices
 5.9.7          DivideMatrixScalar
 5.9.8          DivideScalarMatrix
 5.9.9          Exponent
 5.9.10           First
 5.9.11           Floor
 5.9.12           If
 5.9.13           Index
 5.9.14           Inverse
 5.9.15           IsEqual
 5.9.16           IsGreater
 5.9.17           IsGreaterEqual
 5.9.18           IsNotEqual
 5.9.19           IsLess
 5.9.20           IsLessEqual
 5.9.21           Join
 5.9.22           Last
 5.9.23           Length
 5.9.24           MatrixProduct
 5.9.25           Max
 5.9.26           MaxScalarMatrix
 5.9.27           Mean
 5.9.28           Mid
 5.9.29           Min
 5.9.30           MinScalarMatrix
 5.9.31           MultiplyMatrices
 5.9.32           MultiplyMatrixVector
 5.9.33           MultiplyScalarMatrix
 5.9.34           Percentile
 5.9.35           PowerMatrix
 5.9.36           PowerMatrixScalar
 5.9.37           PowerScalarMatrix
 5.9.38           ReadMatrixFromXml
 5.9.39           Repeat
 5.9.40           Replace
 5.9.41           Reshape
 5.9.42           ReverseCumulativeProductMatrix
 5.9.43           ReverseMatrix
 5.9.44           Size
 5.9.45           Split
 5.9.46           SquareRootMatrix
 5.9.47           Step
 5.9.48           SubtractMatrices
 5.9.49           SubtractMatrixScalar
 5.9.50           SubtractScalarMatrix
 5.9.51           Sum
 5.9.52           Transpose
 5.9.53           UnitMatrix
 5.9.54           Vector
 5.10         Creating custom formulas in Futurama
 6      Futurama - Objects
 6.1        Action
 6.2        Aggregation
 6.3        Button
 6.4        ChangeValue
 6.5        CheckBox
 6.6        ClearCache
 6.7        DatabaseField
 6.8        DatabaseView
 6.9        DataTable
 6.10         DateBox
 6.11         DocConverter
 6.12         Document
 6.13         Download
 6.14         DropDownList
 6.15         EmailConverter
 6.16         ExcelConverter
 6.17         FileSaver
 6.18         FileUploader
 6.19         Fixed
 6.20         Formula
 6.21         GraphConverter
 6.22         HTMLInclude
 6.23         InterfacesNode
 6.24         LogMessage
 6.25         Navigator
 6.26         Node
 6.27         RadioButton
 6.28         RadioGroup
 6.29         Range
 6.30         Reference
 6.31         SubDocument
 6.32         TextBox
 6.33         UserTable
 6.34         UserVariable
 6.35         WebLabel
 6.36         WebListBox
 6.37         WebPage
 6.38         WebPanel
 6.39         WebReference
 6.39.1           WebReference - WCF Configuration
 6.40         WebService
 6.41         WebSlider
 6.42         WordConverter
 6.43         XmlBuilder
 6.44         XmlConverter
 6.45         XmlField
 6.46         XmlNode
 7      Futurama - Vision References
 7.1        Data
 7.1.1          ReadData
 7.1.2          WriteMessage
 7.1.3          GetPersonIdentifiers
 7.1.4          CreatePerson
 7.2        DataStore
 7.2.1          DeleteDataItem
 7.2.2          DeleteDataItemHierarchy
 7.2.3          DeleteDataItems
 7.2.4          GetDataItem
 7.2.5          GetDataItemHierarchy
 7.2.6          GetDataItems
 7.2.7          StoreData
 7.3        Accounts
 7.3.1          Activate Account
 7.3.2          Change Account
 7.3.3          Create Account
 7.3.4          GetQuestion
 7.3.5          GetQuestions
 7.3.6          Login
 7.3.7          ReadData
 7.3.8          ReinitializeAccount
 7.4        General
 7.4.1          TestConnection
 8      Futurama Vision
 8.1        Installation Futurama Vision
 8.1.1          Installation Futurama Vision Management Site
 8.1.2          Installation or Upgrade of the Futurama Vision Database
 8.2        Futurama Vision Management Site
 8.2.1          Futurama Vision Management Site - Admin
 8.2.2          Futurama Vision Management Site – Security
 8.2.3          Futurama Vision Management Site – Skinning
 8.2.4          Importing data into Futurama Vision
 8.2.4.1            Importing data by webservice
 8.2.4.2            Importing data from a Zip-file
 8.2.4.3            Importing data with Futurama Vision Batch
 8.2.4.4            Futurama Vision Webservice Security
 8.2.5          Further processing of data into Futurama Vision
 8.3        Futurama Vision File manager
 8.4        Activity overview
 8.5        Storing data in Vision from a Futurama application
 8.6        Futurama Vision – Data
 8.7        Futurama Accounts - Management Site
 8.7.1          Futurama Accounts - Table in Vision Database
 8.8        Futurama Server - Management Site
 8.8.1          Special Futurama Server Jobs
 8.9        Futurama Register - Management Site
 8.9.1          Configuration - Futurama Register
 8.10         Retrieving AppEvents from Futurama Vision
 8.11         Adding CustomPages to Vision
 9      Futurama Intermediate Control Output (FICO)
 9.1        FICO example - Change/Add HTML headers
 9.2        FICO example - Change Graph
 9.3        HTML5 Template
 10       Futurama Web API
 10.1         Postbacks of Futurama webcontrols
 10.2         Retrieving Resources using Web API
 10.3         WebAPI Session management
 11       Tutorials - Overview
 11.1         Tutorials - Examples and Downloads
 11.2         Beginners
 11.2.1           Creating formulas with Futurama
 11.2.1.1             Exercise 1: Pythagorean Theorem (Easy)
 11.2.1.2             Exercise 2: Newspaper stall (Medium)
 11.2.1.3             Exercise 3: Recursive functions (Difficult)
 11.2.1.4             Exercise 4: Leap Year (Difficult)
 11.2.1.5             Exercise 5: The Guessing Game I (Medium)
 11.2.2           Creating a Website Application
 11.2.2.1             Exercise 1: Creating a Website (Easy)
 11.2.3           Styling your website with CSS
 11.2.3.1             Exercise 1: Adding CSS (Easy)
 11.2.4           Adding interactivity to your website
 11.2.4.1             Exercise 1: Summation (Easy)
 11.2.4.2             Exercise 2: The Guessing Game II (Medium)
 11.2.4.3             Exercise 3: Nationality (Medium)
 11.2.4.4             Exercise 4: Nationality - RepeatTarget (Medium)
 11.2.4.5             Exercise 5: Reversed Guessing (Difficult)
 11.2.5           Working with Tables
 11.2.5.1             Exercise 1: Average (Easy)
 11.2.5.2             Exercise 2: Boundary values (Difficult)
 11.2.5.3             Exercise 3: Standard Deviation (Medium)
 11.2.6           Reading and processing XML-data in Futurama
 11.2.6.1             Exercise 1: Shares (Medium)
 11.2.7           Adding Graphs in Futurama
 11.2.7.1             Exercise 1: World Population (Easy)
 11.2.8           Working with Actions in Futurama
 11.2.8.1             Exercise 1: Changing Colors (Easy)
 11.2.8.2             Exercise 2: On and Off (Medium)
 11.2.8.3             Exercise 3: The ChangeValue object (Difficult)
 11.2.8.4             Exercise 4: The Guessing Game III (Medium)
 11.2.8.5             Exercise 5: CheckBox (Medium)
 11.2.9           Multiple Pages and Navigation
 11.2.10            Using XSLT to display data
 11.2.10.1              Exercise 1: Overview Summation (Easy)
 11.2.10.2              Exercise 2: Persons (Medium)
 11.2.10.3              Exercise 3: Leap Year Overview (Difficult)
 11.2.11            Webservices in Futurama
 11.2.11.1              Exercise 1: Example (Easy)
 11.2.12            Creating a Webservice Application
 11.2.12.1              Exercise 1: Add (Easy)
 11.2.12.2              Exercise 2: Webservice Nationality (Medium)
 11.2.13            Creating a Console Application
 11.2.13.1              Exercise 1: Adding extra fields (Easy)
 11.2.14            Generating Documents
 11.2.14.1              Exercise 1: Tax Rate (Medium)
 11.2.14.2              Exercise 2: Tax Rates Table (Difficult)
 11.3         Advanced
 11.3.1           Responsive Design
 11.3.1.1             Exercise 1: Orientation
 11.3.1.2             Exercise 2: Target different screen sizes
 11.4         Older Tutorials (Futurama Version 3.2)
 11.4.1           Futurama Editor Tutorial 1: The first sum
 11.4.2           Futurama Editor Tutorial 2: An annuity
 11.4.3           Futurama Editor Tutorial 3: Working with tables
 11.4.4           Futurama Editor Tutorial 4: Modelling a DB pension plan
 11.4.5           Futurama Editor Tutorial 5: Working with XML
 11.4.6           Futurama Web Tutorial 1: Hello world
 11.4.7           Futurama Web Tutorial 2: Buttons and Actions
 11.4.8           Futurama Web Tutorial 3: Textboxes
 11.4.9           Futurama Web Tutorial 4: DropdownLists
 12       Miscellaneous
 12.1         Responsive website
 12.2         Reducing memory usage for XmlNodes and XmlFields
 12.3         Explaining caching for websites and webservices
 12.4         Certificates - basic information
 12.5         Performance XML operations
 12.6         Creating XSD files and using them in combination with Futurama
 13       Templates
 14       Safe2Save WebAPI Sample
View  |  Print  |  PDF

451 documents found.


Storing data in Vision from a Futurama application

Developer
User-ManagementSite
DataStore
Vision-ManagementSite

 

Concerns: Vision

User: User Management Site, Developer

Prerequisites

- Installation Futurama Vision Management Site

- Installation Futurama Vision Database

- Usage of the Futurama Website edition

Introduction

Within Futurama web applications it is possible to store personal preferences of users of the web application and retreive data that is stored. This page describes the configuration needed to store data from a Futurama application in Vision.

 

Description

Using the Futurama Website edition, it can be necessary to store information from a user. For example if you have created a website where your users can log in to see personal financial information. At this website you probably have some input fields. In some situations you want to give your users the possibility to store the information they give in these input fields, to retreive this information in a next visit. The ensures that users don't have to fill in the same information in each new session. Another example is if you want to store some personal preferences of your users ('I want to receive e-mail notifications', or 'I wantthe website displayed with a large font-size', etc.). This information can be used to communicate with your users based on their personal preferences.

In order to store (and retrieve) information you must configure in the Futurama Vision Management Site what the structure of the data is to be stored. Information of this configuration can be found at this page. Furthermore, in your Futurama Document, where you define your application, you must define which personal data has to be stored at which moment. Also you have to define at which page of your application which data has to be retreived. Information how this can be defined can be found at the VisionReferences pages of DataStore.   

Overview

Using datastore allows a user to store data into Futurama Vision as a DataItem. These dataitems are contained in a collection called a DataSet, which all have to comply to a single data format, and this dataset can be configured to encrypt all data that is stored within.

This single format of a dataset is configured in a DataType, which consists of one or more versions. Every version is numbered and contains an XSD schema that describes the XML structure of all associated dataitems. A DataType's structure can be updated by adding a new version to this datatype.

Usage

This data consists of XML that must be constructed within a futurama application, and can be stored using the StoreData formula. This will store the data, but also a timestamp, an optional person-identifier and a small description.

Data can be retrieved by using the GetDataItems formula, which will return a list of ID codes, and the descriptions that were supplied while storing the items. This ID code can then be used to retrieve a single item using the formula GetDataItem.

DataItems and Persons

It is possible to connect a dataitem to a person, by supplying the StoreData formula with person's identifier. This also makes it easier to retrieve a persons dataitems by providing the persons identifier to the GetDataItems formula, to retrieve only the dataitems in a specific dataset for a single person. An example usage could be to store Scenario's for every user of a website in a single dataset, which would simplify the task of retrieving this information.

Example

First enter the DataStore definitionsmanagement page, and create a new datatype with a simple name and description (free to choose). A productgroup must also be selected, which will limit access to this datatype for Apps within this productgroup.

Then add a new (first version) for this dataset with a chosen versionname and description. The small xml example above can be used a sampleXML for this version. For the schema, the definition shown below can be used, while the target namespace MUST be set to "www.actuit.nl/test" for this definition.

<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified"
 targetNamespace="http://www.actuit.nl/testdata" xmlns:xs="http://www.w3.org/2001/XMLSchema">
    <xs:element name="test">
        <xs:complexType>
            <xs:sequence>
                <xs:element name="id" type="xs:unsignedInt" />
            </xs:sequence>
        </xs:complexType>
    </xs:element>
</xs:schema>

You have now created a fully functional datatype, and can now create a dataset in the DataStore contents management page. Here you can select the desired datatype, and the version you want this dataset to produce, and by which name this dataset must be accessible. After creating the dataset, you can use the Futurama formula StoreData to store XML data that adhere to the supplied schema tot the new dataset.

Updating datatype definitions

During the lifetime of a dataset, it might become desirable to make a small change to the definition of a datatype. This can be achieved by creating a new version within that dataset. In this dataset, the new schema can be supplied, but this also requires a conversion XSLT. This translation file will allow the conversion of dataitems with the previous schema, to the new schema. Below is an example of a newer schema for the example above which will add a name value to the rootnode, and will change the namespace. The second section of code below shows the required conversion XLST to convert any outdated dataitems to this newer version.

New xml schema (adds a name):

<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" 
       targetNamespace="http://www.actuit.nl/testdata2" xmlns:xs="http://www.w3.org/2001/XMLSchema">
    <xs:element name="test">
        <xs:complexType>
            <xs:sequence>
                <xs:element name="id" type="xs:unsignedInt" />
                <xs:element name="name" type="xs:string" />
            </xs:sequence>
        </xs:complexType>
    </xs:element>
</xs:schema>

The conversion XSLT:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
xmlns:msxsl="urn:schemas-microsoft-com:xslt" 
exclude-result-prefixes="msxsl input" 
xmlns:input="http://www.actuit.nl/testdata">
    <xsl:output method="xml" indent="yes" />
    <xsl:template match="*">
        <test xmlns="http://www.actuit.nl/testdata2">
            <id>
                <xsl:value-of select="/input:test/input:id" />
            </id>
            <name>
                 unknown
            </name>
        </test>
    </xsl:template>
</xsl:stylesheet>

From this moment on, whenever an outdated dataitem is retrieved from the database, it is converted to the newer definition automatically, and stored that way. In the example mentioned above outdated dataitems will get automatically the name 'unknown'.

Hierarchy

It is possible to store dataitems in a hierarchical way, using the ParentID field when using the StoreData formula to store a dataitem. This parentID indicates the ID of the dataitem you want to connect to this particular dataitem. Multiple dataitems can have their parent set to the same single dataitem, thereby creating a tree-structure. This hierarchy does not limit itself to one layer, but dataitems can be linked indefinitely to form any hierarchy one could desire.

For example: A website's user has multiple configurations, each of which can contain multiple scenarios. This could be implemented by storing 2 dataitems with a configuration, and a number of scenarios in individual dataitems. The scenario items would then be connected to their respective configuration by supplying the ID of the configuration's dataitems as the ParentID of the scenarios' dataitems.

For efficient retrieval of a dataitems and all its descendants (and their descendants etc), it is possible to use the GetDataItemHierarchy formula. This simplifies the retrieval of a full hierarchical tree with only a single call.

Configuration Management Site

In the Futurama Vision Management Site two sections can be found for the configuration of the storing of data (definition management and contents management). These sections can be found in the menu 'Beheer'. See below for more information about the configuration in these sections.

Definitions management

When entering this screen, a list of existing datatypes is shown immediately. This list can be filtered by using the search filter in the top of the screen.

DataTypes

The form for adding or changing a datatype consists of the following elements:

  • Name: The name that identifies the datatype.
  • Description: A small description which illustrates the usage of this datatype.
  • Productgroup: The datatype will be available for apps within this productgroup, or other productgroups below this one.

The versions within a datatype can be shown by pressing the ">" button on the left side of every listing.

Datatype versions

A datatype version contains the following fields:

  • Version name: The name which uniquely identifies this version.
  • Description: A small description which illustrates the particular implementation of this version's structure.
  • XSD schema: The XML schema that defines the structure of a dataitem that adheres to this particular version.
  • Target namespace: The namespace for the XML of a dataitem, which should be mentioned as the targetnamespace in the earlier mentioned XSD schema. The validity of this target namespace will be compared to the one in the XSD.
  • Sample XML: This XML should be a small sample which conforms to the supplied XSD. This data is required for automatic validations, and should be kept as simple as possible.
  • Should this be any new version (version 2 or greater) for an existing datatype, then a conversion XSLT must be provided. This XSLT can update the existing dataitems that are still of the previous type, up to the new one. Should there be outdated dataitems with more than one version of difference, then it can be updated by applying the conversion XSLTs of the newer versions in sequence.

Note that in order to allow the user to fill in an XSD schema and a sample XML an exception has to be made in the configuration file of the Management Site for this type of input. See the paragraph 'Configuration file Management Site' for more information.

Contents management

When entering this screen, a list of existing datasets is shown immediately. This list can be filtered by using the search filter in the top of the screen.

Datasets

The fields that are contained within a dataset are:

  • ID: This read-only field is a unique identifier for this dataset.
  • Name: The name that uniquely identifies the dataset.
  • DataType: The datatype that all the items within this dataset should conform to.
  • Version: The version of the earlier mentioned datatype that this dataset should produce on retrieval of a dataitem.
    This means that should this dataset be set to a version 2 of a certain datatype, and it contain an outdated item of version 1, then upon retrieval of this item, it will be automatically updated to version 2 by using the defined XSLT in version 2, and stored in that manner.
  • Encrypted: By selecting this checkbox, all dataitems that will be stored in this dataset will be stored in an encrypted form. This will require the next two fields to be set in a correct manner:
  • Encryption key: The location in the Vision configuration file's appsettings section where the first encryption/decryptionkey code can be found.

Upon pressing the Save button, a validation will be performed on the made changes. An error will be shown if any problems have been found, and any corrections can be made afterwards by pressing the Back button of the browser.

Be aware that once a dataset contains dataitems, the encryption- and datatype settings cannot be changed, as this will have consequences for any contents of the dataset. See related topics for more info on data encryption.

Configuration file Management Site

In the section 'Definitions Management' you have to enter an XSD schema and a sample XML. In .NET this kind of input is default not allowed. This prevents the user to enter potentional dangerous script. In the configuration file of the Management Site you therefore have to make an exception for the 'Definitions Management' page. This exception you make by entering the code mentioned below within the configuration section of the configuration file.

<location path="Secure/Store/AdminDataTypes.aspx">
	<system.web>
		<httpRuntime requestValidationMode="2.0" />
	</system.web>
</location>

The path 'Secure/Store/AdminDataTypes.aspx' is the page in the Management Site for which the exception has to be made.

Related Topics

- VisionReferences pages DataStore: Description how to use VisionReferences to incorporate storing of data in your Futurama Website application.

- Futurama Vision – Data : More information on data storage and data encryption in Futurama Vision.

External Links

- XML Schemas: More information about the structure of XSD files

- XSLT Tutorial: More information about writing XSLT files

Feedback

If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.

Updated: 2014-03-18


Previous  |  Next