DataSpeeder - Admin Guide

Document 2020.08.19

www.dataspeeder.com/support


Summary

This document describes how to use Administrator features of DataSpeeder 1.0.

Note: For information on installing and setting up DataSpeeder, please find the "DataSpeeder Setup Guide" on the DataSpeeder support page at www.dataspeeder.com/support

1.0 Table Of Contents

2.0 Admin Mode

2.1 Sign In As Administrator

2.2 Admin Page

2.3 Admin > Configure Apps

2.3.1 Create New Application dialog box

2.3.2 Configure Application

2.3.2.1 "Application Properties" section

2.3.2.2 "Data Types" section

2.3.2.3 "Data Relationships" section

2.3.2.4 "Delete Application ..." button

2.3.3 Create Data Type dialog box

2.3.4 Configure Data Type page

2.3.4.1 "Data Type Properties" section

2.3.4.2 "Data Relationships" section

2.3.4.3 "Field Definitions" section

2.3.5 Edit Field Definition dialog box

2.3.6 Edit Field Validation

2.3.7 Create Data Relationship

2.3.8 Configure Data Relationship page

2.3.9 Example Relationship Configurations

2.3.9.1 Example Relationship: 'Movie' has one 'Director'

2.3.9.2 Example Relationship: 'Director' has many 'Movies'

2.3.9.3 Example Relationship: 'Actor' has many 'Movies'

2.3.9.4 Example Relationship: 'Movie' has many 'Actors'

2.4 Admin > Data Sources

2.4.1 Edit Data Source dialog box

2.4.2 Delete Data Source

2.4.3 Configuring the primary DataSpeeder data source / database connection properties

2.5 Admin > System

2.6 Admin > License

2.6.1 Installing a License

2.7 Admin > User Accounts

2.7.1 Create User Account

2.7.1.1 Changing Passwords & Password Encryption

2.8 Admin > Value Lists

2.8.1 Create/Edit Value List

3.0 Other Resources

2.0 Admin Mode

2.1 Sign In As Administrator

To sign in and access administrator functionality, click the "Sign In" link in the header and enter the username and password of a user with administrator permissions.

NOTE: The default account is username "admin" and password "password". WARNING: You should change this default password at first opportunity, see: "2.7 Admin > User Accounts"

When a user is signed in, the username appears in the header next to a "Sign Out" link, and an "Admin Page" link.

"Sign Out" link - click to sign out of the applicaiton.

"Admin Page" link - click to access the administion functionality for creating and configuring applications and users.

2.2 Admin Page

"Admin Page" features administration functionality for creating and configuring applications and users.

"Sign Out" link - Click to sign out of the application. NOTE: It is important that you not leave yourself signed in as an administrator when your computer is unattended as malicious or mischievous colleagues can access your administrator account.

"Home" link - Click to return to the DataSpeeder home page and the main list of applications.

Admin menu - Left column of menu buttons to access different categories of administration functionality.

2.3 Admin > Configure Apps

Create and configuration applications.

"Create New Application ..." button - Click to create a new application. (See section "2.3.1 Create New Application dialog box".)

Application List - List of currently existing applications, the default pre-installed application is "Demo Movie Application". Click on an application in the list to configure that application. (See section "2.3.2 Configure Application".)

2.3.1 Create New Application dialog box

On the "Admin > Configure Apps" page, after clicking the "Create New Application ..." button, you will be prompted to enter a name for the application. Enter an application name and click "Create App" to create the application.

2.3.2 Configure Application

On the "Admin > Configure Apps" page, after clicking an application in the list, you will be taken to the "Configure App" page for that application.

2.3.2.1 "Application Properties" section

"Application Name" field - Displays the current name of the application.

"Enabled (Visible to All Users)" checkbox - When the value is 'checked', the application is visible to all users on the DataSpeeder home page. When the value is 'unchecked', the application is only visible to administrator users on the DataSpeeder home page. NOTE: It is good practice to make the application invisible to application users until the application is fully configured and ready for use.

"Edit App ..." button - Click to access dialog box for changing the 'Application Name' and 'Enabled' values.

2.3.2.2 "Data Types" section

"Create New Data Type ..." button - Click to access the "Create Data Type" dialog box to create a new Data Type for the current application. (See section "2.3.3 Create Data Type dialog box".)

Data Types list - List of Data Types that are configured for the application. Click on a Data Type in the list to access the Configure Data Type page for that Data Type. (See section "2.3.4 Configure Data Type page".)

2.3.2.3 "Data Relationships" section

"Create New Data Relationship ..." button - Click to access the "Create Data Relationship" dialog box to create a new Data Relationship for the current application. (See section "2.3.7 Create Data Relationship".)

Data Relationships list - List of Data Relationships that are configured for the application. Click on a Data Relationship in the list to access the Configure Data Relationship page for that Data Relationship. (See section "2.3.8 Confgure Data Relationship page".)

2.3.2.4 "Delete Application ..." button

"Delete Application" button - Click the button to delete the selected application from DataSpeeder. You will be prompted for confirmation before the delete occurs. Once deletion is confirmed, the application (example "Demo Movie Application") and all associated configuration (Data Types, Data Relationships) will be deleted. NOTE: Deleting an application will not delete the database data that the application points to, it will only delete the configured DataSpeeder application itself.

2.3.3 Create Data Type dialog box

From the "Admin Page > Configure Apps > Configure App" page, in the "Data Types" section, clicking the "Create New Data Type ..." button opens the "Create Data Type" dialog box.

"Data Type Name" (when singular) field - Enter the name of the data type in SINGULAR form; example "Customer" or "City".

"Data Type Name when plural" field - Enter the name of the data type in PLURAL form; example "Customers" or "Cities".

NOTE: The reason DataSpeeder has both "singular" and "plural" versions of Data Type names is purely cosmetic so we can display friendly messages to your users, for example: "Create one Customer" or "List all Customers". Since automatically determining correct pluralization can be difficult (ex. "City" and "Cities"), we give you the ability to specify correct names here.

"Database Source" dropdown selector - Choose the Data Source from the list where your application's data is stored. When a Data Source is selected, the following "Database table where these Data Types are stored" dropdown selector will be refreshed with with table names from that selected Data Source.

NOTE: To create or configure a Data Source for your application, see "Admin Page > Data Sources". (See section "2.4 Admin > Data Sources".)

"Database table where these Data Types are stored" dropdown selector - Choose the database table that contains the data for the Data Type you are creating. The values that appear in this list are the visible tables from the selected Data Source in the "Database Source" dropdown selector.

"Create Data Type" button - Click to create the new Data Type.

"Close" button - Click to cancel the creation of the Data Type and close the dialog box.

2.3.4 Configure Data Type page

From the "Admin Page > Configure Apps > Configure App" page, in the "Data Types" section, clicking a Data Type in list opens the "Configure Data Type" page.

2.3.4.1 "Data Type Properties" section

"Entity Name" value - Indicates the name of the Data Type used in a SINGULAR context. The value can be modified using the "Edit Data Type" button which opens the "Edit Data Type" dialog box.

"Edit Data Type" button - Click to modify the editable fields under the Data Type Properties section.

"Entity Name Plural" value - Indicates the name of the Data Type used in a PLURAL context. The value can be modified using the "Edit Data Type" button which opens the "Edit Data Type" dialog box.

"Data Type is Visible in the Application" checkbox - When checked, the Data Type is visible to users of the application. NOTE: Sometimes a Data Type is always invisible, for example, when a Data Type represents a record in a join table used in a many-to-many relationship; in the "Demo Movie Application", see the "Actor-Movie-Joins" Data Type for an example of this configuration.

"Display Name Format" value - Indicates the default display text for this Data Type wherever this data type is visible in the DataSpeeder application. The value can be modified using the "Edit Data Type" button which opens the "Edit Data Type" dialog box.

Display Name Format typically contains references to one or more Field Definitions using the format ${FIELD_NAME} where FIELD_NAME is a "Field Name" from the list of "Field Definitions" for this Data Type.

Examples: If we have a Data Type called "Employees" which uses a database table called 'Employee' with fields called 'first_name', 'last_name', and 'employee_number', and there is a record in that table for "John", "Smith", "1234":

"Default Sorted By Field" value - Indicates the default data sorting behavior when listing data of this Data Type, using the selected field and the alpha-numeric direction to determine default sorting of data. The values can be modified using the "Edit Data Type" button which opens the "Edit Data Type" dialog box.

"App Name" value - Indicates the name of the application as it will appear in the DataSpeeder home page list of applications.

"Data Source" value - Indicates the Data Source used by this Data Type which specifies the database connection properties for reading/writing the data from the database.

"DB Table Name" value - Indicates the table in the database where data for this Data Type is stored; used for reading/writing the data from the database for this Data Type.

"Unique ID Fields" value - Indicates the fields that are configured as Unique ID fields which will be used to uniquely identify an individual record in the database table. NOTE: The Unique ID Field can be modified using the "Edit Field Def" functionality under the "Field Definitions" section.

"Searchable Fields" value - Indicates the fields that are configured as Searchable and will be included when performing a search of that Data Type. NOTE: The Searchable Field can be modified using the "Edit Field Def" functionality under the "Field Definitions" section.

2.3.4.2 "Data Relationships" section

Displays a list of all Data Relationships where this Data Type is the primary (that is, "Data Type 1") in the Relationship. For example, in the "Demo Movie Application", an "Actor has Movies", so that relationship is displayed when configuring the Data Type "Actor".

For each Data Relationship in the list:

"Display Label" value - Indicates the label that will be used on this Data Type's View and Edit pages for this Data Relationship.

"Visible on VIEW PAGE" value - Indicates whether or not this Data Relationship is visible on this Data Type's View and Edit pages.

"Edit" button - Used to edit the "Display Label" and "Visible on VIEW PAGE" values, clicking the button opens the "Edit Relationship Display Settings" dialog box.

"Description" value - Indicates a description of the Data Relationship; specifically the Data Types involved and the relationship between them; example: "Actor has many Movies".

2.3.4.3 "Field Definitions" section

Displays a list containing a Field Definition for each field in the database table.

For each Field Definition in the list:

Up/Down field sorting arrows - Used to change the display order of the fields for a Data Type. Clicking the 'Up Arrow' icon or 'Down Arrow' icon will move a Field Definition row up or down in the list. The order that the fields appear in this Field Definition list is the order that (visible) fields will appear in the Create, Edit, and View pages for this Data Type.

"Field Name" value - Indicates the name of the database table field that this Field Definition is associated with.

"Display Name" value - Indicates the Display Name or display label for this field when the field appears on the Create, View, and Edit pages for this Data Type.

"Summary" value - Displays a summary or subset of this Field Definition's configuration. A 'badge'-icon indicates that this field is configured as a "Unique ID Field"; a 'magnifying glass'-icon indicates that this field is configured as a "Searchable Field"; a 'checklist'-icon indicates that this field has Valildation Rules configured for it.

"Edit Field Def" button - Used to configure the selected Field Definition, clicking the button opens the "Edit Field Definition" dialog box. (See section "2.3.5 Edit Field Definition dialog box".)

"Validation Rules" button - Used to configure Validation Rules for selected field. The button is visible only for data types that support validation rules, for other data types the button is not visible. Clicking the button opens the "Edit Field Validation" dialog box. (See section "2.3.6 Edit Field Validation".)

2.3.4.4 "Delete Data Type ..." button

"Delete Data Type ..." button - Click the button to delete the selected Data Type from the application. You will be prompted for confirmation before the delete occurs. Once deletion is confirmed, the Data Type will be removed. NOTE: Deleting a Data Type will not delete the database data that the Data Type represents, it will only delete the configured Data Type from the DataSpeeder application itself.

2.3.5 Edit Field Definition dialog box

From the "Admin Page > Configure Apps > Configure App > Configure Data Type" page, in the "Field Definitions" section, clicking the "Edit Field Def" button opens the "Edit Field Definition" dialog box for the selected Field Definition.

"Display Name" field - Used to modify the Display Name which is the text label used for this field whenever the field appears on the Create, View, and Edit pages for this Data Type.

"Default Value" field - Used to specify the Default Value for this field when a new instance of this Data Type is being created. When the field is configured to appear on the Data Type's Create Page, the user has the opportunity of changing this value before creation occurs.

"Editor Widget" dropdown selector - Used to specify which user interface editor widget is used for this field on the Create, Edit, and/or View pages of this Data Type. NOTE: The list of available editor widgets is based on the "DB Data Type" or "Data Category" values which are read from the database schema.

"Values For Drop Down Selector" dropdown selector - When the "Editor Widget" option is set to "Drop Down Selector", this value is used to specify which list of values (a "Value List") will appear in that list. To create and configure new "Value Lists", see section "2.8 Admin > Value Lists".

"Is Unique ID" checkbox - Used to specify whether or not this field is a Unique Identifier that will be unique to uniquely indentify an individual record in the database table.

"Unique ID Value Comes From" dropdown selector - When the "Is Unique Identifier" value is checked, this dropdown selector is used to specify the source for a new unique value for this field when a new Data Type instance is being created.

Options include:

"Is Visible On Create Page" checkbox - Used to specify whether or not this field is visible on the Create page for this Data Type.

"Is Editable On Create Page" checkbox - Used to specify whether or not this field is editable (or disabled and read-only) on the Create page for this Data Type.

"Is Visible On Edit Page" checkbox - Used to specify whether or not this field is visible on the Edit page for this Data Type.

"Is Editable On Edit Page" checkbox - Used to specify whether or not this field is editable (or disabled and read-only) on the Edit page for this Data Type.

"Is Visible On View Page" checkbox - Used to specify whether or not this field is visible on the View page for this Data Type.

"Is A Searchable Field" checkbox - Used to specify if the field is Searchable and will be included when performing a search of that Data Type. When a search is Searchable, matching results from a search will appear in the search results table for that Data Type.

"Column is visible in main table" checkbox - Used to specify whether or not this field appears as a column in the search results table for that Data Type.

"Column is sortable in main table" checkbox - Used to specify whether or not this field can be used to alpha-numerically sort data in the search results table. NOTE: The "Column is visible in the main table" value must be checked for this value to apply.

"DB Field Name" field - Indicates the name of the associated table field in the database for this Field Definition.

"DB Data Type" field - Indicates the type of data of the associated table field in the database schema.

"Data Category" field - The DataSpeeder data category that was determined as the best match for the DB Data Type from the database schema.

"Save Changes" button - Clicking the button saves the values in the dialog box.

"Close" button - Clicking the button cancels the saving of changes, and closes the dialog box.

2.3.6 Edit Field Validation

From the "Admin Page > Configure Apps > Configure App > Configure Data Type" page, in the "Field Definitions" section, clicking the "Validation Rules" button opens the "Edit Field Validation" dialog box for the selected Field Definition.

"DB Field Name" field - Indicates the name of the associated table field in the database for this Field Definition.

"Display Name" field - Indicates the Display Name for this Field Definition.

"Value is required" checkbox - Used to specify whether or not this field requires a value during Create and Edit operations. If checked, and there is no value provided, a message will be displayed and the Create/Edit will not occur.

"Validate Minimum Length" checkbox - Used to specify whether or not this field has an enforced minimum length. If checked, the value specified in the associated "Minimum length" field will be used to enforce a minimum length for values during Create and Edit operations. If the verification fails, the value in the associated "Minimum length warning message" field will be displayed as a warning message and the Create/Edit will not occur.

"Validate Maximum Length" checkbox - Used to specify whether or not this field has an enforced maximum length. If checked, the value specified in the associated "Maximum length" field will be used to enforce a maximum length for values during Create and Edit operations. If the verification fails, the value in the associated "Maximum length warning message" field will be displayed as a warning message and the Create/Edit will not occur.

"Validate all characters are valid" checkbox - Used to specify whether or not the value for this field will be checked to verify it only contains characters in the associated "Valid characters" field. If the verification fails, the value in the associated "Valid characters warning message" field will be displayed as a warning message and the Create/Edit will not occur.

"Reject invalid characters" checkbox - Used to specify whether or not the value for this field will be checked to verify it does not contain characters in the associated "Invalid characters" field. If the verification fails, the value in the associated "Invalid characters warning message" field will be displayed as a warning message and the Create/Edit will not occur.

"Close" button - When clicked, changes will not be saved and the dialog box will close.

"Save Changes" button - When clicked, changes will be saved and the dialog box will close.

2.3.7 Create Data Relationship

From the "Admin Page > Configure Apps > Configure App" page, in the "Data Relationships" section, clicking the "Create New Data Relationship ..." button opens the "Create Data Relationship" dialog box.

"Name" field - Used to specify a name for this Data Relationship which will be used as the default label for this value on the View and Edit pages. Example, if the relationship is "Actor has many Movies", an appropriate value would be "Actor's Movies".

"Data Type 1" dropdown selector - Used to specify the primary Data Type in the relationship. The primary Data Type can typically be considered to be the first/left-most Data Type in the relationship. For Example: In the relationship "Actor has many Movies", "Data Type 1" would be "Actor".

"Relationship Type" dropdown selector - Used to specify the type of relationship. Valid options are "has one" and "has many". For example, in the pre-installed "Demo Movie Application", there are relationships "Actor HAS MANY Movies" and "Movie HAS ONE Director".

"Data Type 2" dropdown selector - Used to specfiy the secondary Data Type in the relationship. The secondary Data Type can typically be considered to be the second/right-most Data Type in the relationship. For Example: In the relationship "Actor has many Movies", "Data Type 2" would be "Movies".

"Close" button - When clicked, changes are not saved and the dialog box is closed.

"Create Relationship" button - When clicked, the Data Relationship is saved and the dialog box is closed.

2.3.8 Configure Data Relationship page

From the "Admin Page > Configure Apps > Configure App" page, in the "Data Relationships" section, clicking a Data Relationship in the list opens the "Configure Data Relationship" page.

"Relationship Name - Indicates the Relationship Name that was assigned to the Data Relationship when it was created.

"Description" - Indicates a description of the two Data Types and the type of relationship between them.

"Primary Keys Mapping" - Used to indicate how the id fields are mapped between objects creating the relationship in the database. There is a row for every field in the Data Type that is configured to be a "Unique ID" field. The relationship is configured by specifying the table name and the field name where that ID field's value will be copied to during Create and Edit operations.

NOTE: See the following section "2.3.9 Example Relationship Configurations" for detailed examples of Data Relationship configurations.

"Delete Relationship ..." button - Click the button to delete the Data Relationship. You will be prompted for confirmation before the delete occurs. NOTE: Deleting a Data Relationship will not delete the database data that the application points to, it will only delete the configured Data Relationship in the DataSpeeder application.

"Save Changes" button - Saves all changes to the Data Relationship.

2.3.9 Example Relationship Configurations

In the pre-installed "Demo Movie Database" there are four configured relationships; an explanation of each relationship configuration follows.

NOTE: The database tables for the sample "Demo Movie Database" are included with the standard DataSpeeder installation; see the following image that shows where to find the tables; specifically: 'demo_actors', 'demo_actors_movies', 'demo_directors', 'demo_movies'.

NOTE: The following database diagram gives a high level illustration of the design of the demo tables for the "Demo Movie Database" application; specifically: 'demo_actors', 'demo_actors_movies', 'demo_directors', 'demo_movies', and their relationships.

2.3.9.1 Example Relationship: 'Movie' has one 'Director'

With this Data Relationship configured, the Director can appear as a field in the Movie's View page.

Note the design of the relationship in the database tables:

Therefore, we configure the Data Relationship such that the Director's primary key ('demo_directors.id') will be written to the Movie's "Director Id" field ('demo_movies.director_id'), as shown:

2.3.9.2 Example Relationship: 'Director' has many 'Movies'

This relationship is the reverse of the previous example. With this Data Relationship configured, the Movies can appear as a field in the Director's View page.

Note the design of the relationship in the database tables:

Therefore, we configure the Data Relationship such that the Director's primary key ('demo_directors.id') will be written to the Movie's "Director Id" field ('demo_movies.director_id'), as shown:

2.3.9.3 Example Relationship: 'Actor' has many 'Movies'

With this Data Relationship configured, the Movies can appear as a field in the Actor's View page.

Note the design of the relationship in the database tables:

Therefore, we configure the Data Relationship such that the Actor's primary key ('demo_actors.id') will be written to the join table's "Actor Id" field ('demo_actors_movies.actor_id'), and the Movie's primary key ('demo_movies.id') will be written to the join table's "Movie Id" field ('demo_actor_movies.movie_id'), as shown:

2.3.9.4 Example Relationship: 'Movie' has many 'Actors'

This relationship is the reverse of the previous example. With this Data Relationship configured, the Actors can appear as a field in the Movie's View page.

Note the design of the relationship in the database tables:

Therefore, we configure the Data Relationship such that the Movie's primary key ('demo_movies.id') will be written to the join table's "Movie Id" field ('demo_actor_movies.movie_id'), and the Actor's primary key ('demo_actors.id') will be written to the join table's "Actor Id" field ('demo_actors_movies.actor_id'), as shown:

2.4 Admin > Data Sources

Create and configure Data Sources.

"Create New Data Source ..." button - After clicking you will be prompted to provide a name for your Data Source. Enter a name and click "Create Data Source" to create the Data Source.

Data Source List - List of currently existing Data Sources.

"Edit" button - For a specific Data Source, click the "Edit" button to specify the JDBC connection properties (see section "2.4.1 Edit Data Source dialog box").

"Delete ..." button - Click the button to delete the specific Data Source. You will be prompted for confirmation before the deletion will process. Note: The deletion will not proceed if the Data Source is configured for use by any Application or Data Type in the DataSpeeder deployment.

2.4.1 Edit Data Source dialog box

From the "Admin Page > Data Sources" page, clicking the "Edit" button for specific Data Source opens the "Edit Data Source" dialog box.

Data Source Name - Used to specify a descriptive name for the Data Source.

JDBC Driver - Used to specify the classname of the JDBC driver that will be used to establish the JDBC connection. The default value is: com.mysql.cj.jdbc.Driver

JDBC Schema - Used to specify the database schema for your database. The default value is the main DataSpeeder database schema: DataSpeederDB

JDBC URL - Used to specify the JDBC connection URL that will be used to establish the JDBC connection. The default value is: jdbc:mysql://localhost:3306/DataSpeederDB?allowPublicKeyRetrieval=true&useSSL=false&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&autoReconnect=true

JDBC Username - Used to specify the username that will be used to establish the JDBC connection. The correct value will depend on your own database system configuration.

JDBC Password - Used to specify the password that will be used to establish the JDBC connection. The correct value will depend on your own database system configuration.

"Close" button - Clicking the button will close the dialog box without saving any of the changes.

"Test" button - Clicking the button will cause DataSpeeder to attempt to connect to the database using the properties specified in the dialog box. A message will appear reporting the results of the test (success or failure).

"Save" button - Clicking the button will save the changes and close the dialog box.

2.4.2 Delete Data Source

"Delete ..." button - Click the button for the specific item to delete that Data Source. You will be prompted for confirmation before the delete occurs. The deletion will not complete if the Data Source is configured to be used by an Application or a Data Type. NOTE: Deleting a Data Source will not delete the database data that the application points to, it will only delete the configured Data Source in the DataSpeeder application.

2.4.3 Configuring the primary DataSpeeder data source / database connection properties

NOTE: The JDBC connection properties that are used by the DataSpeeder application to connect to the main DataSpeeder database, is configured in the TOMCAT_HOME/conf/dataspeeder.properties file.

2.5 Admin > System

System functionality.

"Initialize APIs" button - When clicked, DataSpeeder will reload and reinitialized Business Rules API and Audit Log API implementations. This is useful when deploying new API implementations on a server without restarting the Tomcat server.

"Clear Cached Data" button - When clicked, DataSpeeder will free and clear any data that resides in its cache of data. This is useful to ensure fresh data is being read from the database when testing new application configurations.

2.6 Admin > License

Viewing Installed License.

"License Info" panel - Displays the details of the currently installed license including who the legal owner of the license is, the type of license, and what capabilities are enabled, and the license issued and expiry dates.

2.6.1 Installing a License

License files can be obtained by visiting www.DataSpeeder.com or by contacting DataSpeeder Support at support@dataspeeder.com.

To install a license, copy the dataspeeder.license file to the TOMCAT_HOME/conf directory and restart the Tomcat server.

2.7 Admin > User Accounts

Create and configure DataSpeeder User Accounts.

"Create New User Account ..." button - Click to open a Create User Account page for creating a new User Account.

Username link in Name column - Click to open the View page for the selected User Account.

Edit link - Click to open the Edit page for the selected User Account.

Delete link - Click to delete the User Account. You will be prompted for confirmation before the delete will occur.

2.7.1 Create User Account

From "Admin > User Accounts", click the "Create New User Account ..." button to access the "Create User Account" page.

"Username" field - Used to specify the username that the user will use to log in.

"Password" field - Used to specify the password that the user will use to log in.

"Role Admin" checkbox - Used to specify whether or not this User Account has "Admin" permissions which gives the user the ability to acess the "Admin Page" and configure the system and applications.

"Role User" checkbox - Used to specify whether or not this User Account has "User" permissions which gives the user the ability to create, edit, and delete data.

"Enabled" checkbox - Used to specify whether or not this User Account can be used to log in.

2.7.1.1 Changing Passwords & Password Encryption

User passwords are stored in the DataSpeeder database in an encrypted format using a one-way hash encryption method for security reasons. That means if a user forgets his password, there is no way to recover it.

To change a user's password, a user with administrator permission must edit the User Account and specify a new password.

2.8 Admin > Value Lists

Create and configure Valid Lists which are used to specify lists of values for drop-down selectors.

All Value Lists will appear as options in the "Edit Field Definition" dialog box, under the "Value For Drop Down Selector" control. (See section "2.3.5 Edit Field Definition dialog box".)

"Create New Value List ..." button - Click to open the Create Value List page for creating a new Value List.

Value List name link in Name column - Click to open the View page for the selected Value List.

Edit link - Click to open the Edit page for the selected Value List.

Delete link - Click to delete the Value List. You will be prompted for confirmation before the delete will occur.

2.8.1 Create/Edit Value List

From "Admin > Value Lists", click the "Create New Value List ..." button to access the "Create User Account" page, or click the "Edit" link to access the "Edit Value List" page for a specific Value List.

"Name" field - Used to specify a name for the Value List.

"ValuesList" field - Used to specify the list of values.

3.0 Other Resources

Please visit the DataSpeeder Support web page to see the list of demo videos and tutorials for creating and using DataSpeeder applications.