EasyManage Platform : User Guide

Table Of Contents


 

For EasyManage Platform
(EM WebPlus Suite 5.0 | EM 5.0)

(On Windows & Unix Platforms)

 


User Guide 5.0

 

Includes:

Suite 5.0

Studio 5.0

Collaboration 5.0

Tools Integration SDK 5.0

 

(Updated: 10-Jan-20, Build 05.82 P25.25)

 


 

Contents (Chapters)

 

Introduction. 10

EasyManage Platform (EM WebPlus Suite 5.0). 10

Chapter 1: Before You Begin. 10

Chapter 2: Getting Started. 12

Chapter 3: Solution, Table & Data Designing with EM... 18

EM WebPlus Studio 5.0. 22

Chapter 1: EM Inbox. 22

Chapter 2: EM Objects - Folders, Tables, WebProjects. 25

Chapter 3: EM Tables. 28

Chapter 4: EM WebProjects. 75

Chapter 5: POWER Search (Explorer_PLUS). 83

Chapter 6: Applications. 87

Chapter 7: Options & Settings. 93

Chapter 8: Using Images (Icons, Links) For EM Objects. 110

Chapter 9: Advanced Features. 113

Chapter 10: FAQ’s / How To’s?. 122

Chapter 11: Using Applications. 125

Chapter 12: Portal (Direct Access URLs). 128

Chapter 13: Using Dashboards. 129

Chapter 14: Content (Applications - Content Type). 131

Chapter 15: Search. 133

Chapter 16: Portal Plus Features. 135

EM WebPlus Collaboration 5.0. 135

Chapter 1: EM Mail. 135

Chapter 2: Using Collaboration. 152

Chapter 3: Collaboration Search. 156

Chapter 4: Virtual Wave : EMit (Status Updates), Tagging & TagPlus. 157

EM WebPlus Tools, Integration, SDK 5.0. 167

Chapter 1: Tools - Reports. 168

Chapter 2: Integration Tools. 170

Chapter 3: SDK - Web Services. 172

Appendix A: Administrator Information. 177

Appendix B: General Specifications. 179

Appendix C: Screen List. 180

 

 

 

Chapter Contents

 

 

Introduction 10

EasyManage Platform 10

Chapter 1: Before You Begin 10

Using EM 5.0 10

Developer Pre-Requisites 11

Developer Pre-Requisites for Advanced Options 11

Application Strategy 12

Prototype 12

Pre-Development Tasks 12

Will Use Advanced Features? 12

Chapter 2: Getting Started 12

Connecting to EM 5.0 13

Sign-Up 13

User Id Restrictions: 14

Password Restrictions: 15

EM User Privileges 15

Sign-In 15

Express Sign-In 15

Advanced Sign-In Options 16

Search Links on Sign-In Screen 16

Sign-Out 17

Sign-In Using Third Party Accounts 18

Access Via Mobile Phones, Mobile Devices 18

Chapter 3: Solution, Table & Data Designing with EM 18

Design Pillars (Criteria) 18

Defining your Solution, Application or Product Use 19

EM WebPlus Studio 5.0 22

Chapter 1: EM Inbox 22

What is EM Inbox 22

Inbox Module 22

Default Destination Inbox – Explorer 23

Inbox - Trash, Archives, Application Tree 24

Inbox - My Menu 24

Inbox – User Search 25

Chapter 2: EM Objects - Folders, Tables, WebProjects 25

Creating EM Objects 25

EM Objects – Edit 26

EM Objects – Del 26

EM Objects – Archive 27

EM Objects – Copy 27

EM Objects - Cut[Move] 27

EM Objects – Paste 27

Scope Of Copy & Paste 28

Chapter 3: EM Tables 28

EM FlexiTables 28

EM Tables - Special Table Objects 28

EM Tables – My Table 29

EM Tables – Db Table 29

EM Tables – Db Table DirectAccess 29

Set Minimum Options 30

Table Options – No Fields 30

Define EM Table Fields 30

Import Field Definitions from database Table 31

EM Data Types With MySQL, Oracle, MS SQL Server 31

File  (Document) Type 36

Date Formats 36

Table Options Menu 36

View Fields 38

Edit/Add Fields 39

Copy From (Add Fields) 39

Delete Fields 40

UnDelete Fields 41

EM Unique Keys 41

EM Foreign Keys 42

Table Properties 43

Table Level Properties 44

Field Level Properties 45

Table Join (Data Copy/Update Table-to-Table) 45

Advanced Table Join: Special EM Script 47

Data Options (No Form) 48

Input/Edit Data (No Form) 49

Archive Data 49

UnDelete Data 50

Table Form: Edit 50

Table Form: Edit : Form Properties 52

Table Form: Edit : Form Layout 55

Table Forms: Edit : Field Properties 57

Data Options using Forms 67

Saved Queries 68

New Query: Enter Query Details 69

Simple Queries 69

Using Non-Field Criteria in Query 70

Advanced Queries 71

View All (Data) (Form) 72

File Details 73

Input/Edit Data (Form) 74

XML (Data) (Form) 74

Chapter 4: EM WebProjects 75

Web Screens Workflow - WebProject Menu (EM Inbox) 75

Create New Web Screen 76

Create – Copy From (WebScreen) 77

Edit WebScreen 77

Using different Screen Modes: 80

Using Direct Access URL : 81

Using Send/Receive Parameters: 81

Delete WebScreen 82

WebScreen: Execute in EM Inbox or Direct access via URL 82

Web Screen Workflow : Execute in Application 83

Chapter 5: POWER Search (Explorer_PLUS) 83

POWER Search/ Explorer_PLUS 83

List (500) EM Objects Menu 83

Common Parameters - Check Dates/Sorting 84

Search Folders/Categories/Tables 84

Search Table Fields 85

Search Table Data 85

Search WebProject Screens 86

Chapter 6: Applications 87

Applications Menu 87

Application Register 87

Application Register: Create New, Edit, Delete Screen 88

Application Subscribe 92

Application Subscribe: Create New, Edit, Delete Screen 92

List Apps 93

Multi-App Srh 93

Auth Define/Grant 93

Run Application 93

Chapter 7: Options & Settings 93

Options Menu (In Inbox) 94

Settings Menu (In Inbox) 94

Member Account: Update Registration Data 94

Member Account: Change Password 97

Member Account: Update User Profile 97

International settings (Date/Time Formats,…): 98

GUI/Screen Preferences section: 104

Table and Forms: Default Properties/GLOBAL Updates 106

Utilities 107

Refresh Category Tree 107

Refresh Category Tree (For ODBC type databases) 107

Upload Menu & Images 107

Settings Menu (In App Run) 110

Chapter 8: Using Images (Icons, Links) For EM Objects 110

Introduction 110

Jsp Configuration Parameters For Image Menus 110

Image Links For Application List Menu 112

Image Links For Application Menu (Folders) 112

Image Links For Application (WebProject) Screen Menu 112

Image Links In Frames User Menu 112

Chapter 9: Advanced Features 113

Customizing Jsp Files 113

EM Script Code Processing 113

HTML Tag Restrictions 117

Record Scroll Bar 121

Chapter 10: FAQ’s / How To’s? 122

Fetch Back Multiple Values from Look-Up 122

Implement Master-Detail Input/Edit Screens 122

JavaScript Calculations in Input|Edit<Multi> Modes 123

Advanced Uses of WebScreen CallBean Mode 124

How to use multiple (Ora, Msq, Access) db conn 124

How to invoke specific application after Sign-In 125

How to Trim Menu/Screen Names 125

How to use custom style for HTML 125

Chapter 11: Using Applications 125

List Applications 126

Run Application 126

Run Application: App Explorer, App POWER Search, My Menu 127

Run Application: AppLinks Session All Received 127

Run Application: WebProject Display 128

Chapter 12: Portal (Direct Access URLs) 128

Portal Home 128

Portal Search 128

Chapter 13: Using Dashboards 129

Dashboard 1 129

Frame Levels 129

Dashboard 1 Options and Menus 130

Chapter 14: Content (Applications - Content Type) 131

Managing Content 131

ContentApp (Menu Items in Inbox->Applications) 131

Content App List 132

Content App Search 132

Applications (Content Type, Public Access) 132

Content App Home 132

Content App Search 133

Content App List 133

Chapter 15: Search 133

Search 133

Portal Search 134

Content Search 134

Collaboration Search 134

Multi-App Search 134

POWER Search 134

Search Mail 134

Search Collaborations 134

Latest Activity (Search) 134

Chapter 16: Portal Plus Features 135

Granting Access to Groups 135

Blocking Users 135

EM WebPlus Collaboration 5.0 135

Chapter 1: EM Mail 135

Types Of Mail 136

What is EM Mail ? 136

Mail Box – Menu 137

Compose (Session - All) 137

AppLinks (Session - All) 139

Create Mail (In - Out) 140

View EM Mail List - Inbox (Mail), Outbox, Selected Folder 141

Folders 142

Imported Mail 142

EM Mail Selected (Generic View) 143

EM Mail - View 144

EM Mail - Send 144

EM Mail - Move 145

EM Mail – Delete 146

EM Mail – DeleteFiles 146

EM Mail – Import 146

EM Mail - View Imported 147

EM Mail – CleanUp 148

EM Mail – Copy 148

EM Mail – Refresh 149

EM Mail – RefreshUpdate 149

EM Mail - Create Collaboration 150

Check Mail 150

Search Mail 151

Chapter 2: Using Collaboration 152

Creating A Collaboration 152

Collaboration Application Registration 152

Creating MyCopy Of A Collaboration 153

Collaboration Menu 153

Creating New SubInbox type of Collaboration 154

List My Collabs 154

List Subscribed/Authorized 154

Subscribed/Authorized Collaboration Selected 155

Chapter 3: Collaboration Search 156

Search Shared Spec User 156

Search Shared Auth/Public 156

Collaboration Search 156

Chapter 4: Virtual Wave : EMit (Status Updates), Tagging & TagPlus 157

EMit : Status Updates 157

Tagging & TagPlus 157

How does Tagging work 157

Virtual Wave 159

Some Requirements and Configuration Parameters 159

Tag Menu 161

Create A New Tag 162

View/Edit TagPlus 163

Tagging Configuration 163

Session Settings 166

EM WebPlus Tools, Integration, SDK 5.0 167

Tools Menu 167

Chapter 1: Tools - Reports 168

Reports 168

Report - No Of Categories (Folders/Tables/WebProjects) 169

Report - Tables with Data Records (excluding deleted/archived) 169

Report - Tables with Archived/Deleted Data Records 169

Report - User Id (Account) Privileges Information 169

Report - User Blocked Information 169

For Advanced Users: 169

Report - Table Linked Data Information 169

For Super Users: 169

Report - License Information 169

Report - [All Users] As Selected Below: 169

Report - All Object Ids Current Seq. Values 169

Chapter 2: Integration Tools 170

Bringing Existing Database Objects (Tables) into EM Inbox 170

Import Objects 170

Import Objects 170

Generate Table Integration Scripts (All Tables) 171

EM Inbox Objects migration to Database Objects (Tables) : 172

Generate Table Schema (All Tables) 172

Generate Table Schema 172

Chapter 3: SDK - Web Services 172

Web Services – Menu 173

Naming Guidelines, Conversions and Data Type Mapping 173

Generate (Session - All) 174

Deploying Generated Web Services 176

Runtime Considerations For Deployed Web Services : 176

Appendix A: Administrator Information 177

EM Configuration Parameters (Default / Plan / User) 178

How to use EM Configuration Parameters? 178

How to use Plan or User specific EM Configuration Parameters? 178

Which Parameters can be override via Plan / User files? 178

Appendix B: General Specifications 179

Characters not supported or converted 179

Using HTML Editor 179

Database Specific Features or Feature Restrictions 180

Feature Restrictions Table For MS SQL Server, Oracle, MS Access: 180

Appendix C: Screen List 180

 

 

 

Introduction


This guide describes the Developer and User features of EasyManage Platform, also referred previously as “EM WebPlus Suite 5.0” or “EM 5.0”, for developers, users. It gives information on pre-requisites, Studio features (building applications with EM 5.0) and highlights server, portal and content services features of the product suite.

 

Please note:

  • Reference to previous release is made as EM AFE 4.0 or EM AFE Release 4.0 or EM ApplicationFrame Work Engine 4.0.
  • Studio is also referred as EM AFE or EM Inbox.

 

 

EasyManage Platform (EM WebPlus Suite 5.0 | EM 5.0)

 

EasyManage Platform comprises of all the products for release 5.0 based upon the build and edition.

 

 

Chapter 1: Before You Begin


This chapter highlights the usage pre-requisites and also the methodology and strategy matters needing attention before developing an application.

 

Using EM 5.0


If you are using EM 5.0 for the first time, please read the section below.

 

  • No Client Install: EM 5.0 is browser based environment. No client install required.

 

  • User Pre-Requisites: For application user or developer browser use experience (with Internet Explorer 4.0+) and ability to navigate, fill out forms, submit to web server is all that is required.

 

  • Getting Licensed User Id: EM 5.0 can be used by licensed user ids which are supplied as part of the License or provisions are made to define them in configuration file unless your license allows for no user id license check as in e.g. processor based license.

 

  • Sign-Up: All the users of EM 5.0 should sign-up first using the licensed user ids designated for them. After which they can start using it.

 

 

Developer Pre-Requisites


EM 5.0 is browser based easy to use yet powerful web application development environment. The developer’s should be familiar with following in order to use it at initial to intermediate level:

 

Familiarity with Web Application Development using Forms:

  • Knowledge of browser based application development using forms, field attributes, Menus, form parameters, navigation.
  • Knowledge of HTML tags, SQL query only if you desire to use add-on customization features.
  • Knowledge of JavaScript is required only if you desire to use JavaScript add-ons in EM 5.0.

 

Familiarity with RDBMS:

  • Knowledge of tables, columns, data types, relational operators, SQL queries, search wild chars.
  • Knowledge of primary keys, referential integrity, indexes, SQL tuning, user security and experience with creating tables, writing SQL, manipulating data in tables would be a plus.

 

 

Developer Pre-Requisites for Advanced Options


The developer’s should be experienced with following in order to use EM 5.0 Advanced options:

 

RDBMS:

  • Experience with PL/SQL, functions, procedures, writing advanced SQL, SQL tuning, transactions, etc. is desirable.

 

Web Application Development:

  • Experience with application development for large projects, apps integrated with RDBMS, multiple form parameters, managing multiple forms is desirable.

 

 

Application Strategy


Define your app strategy in terms of what will an application consists of, who will be the application owner, will users belong to different departments or functions needing separate data groups, etc. Please refer to the detailed chapter “Guide to Table & Data Designing for EM WebPlus” for more information.

 

 

Prototype

 

EM 5.0 allows development of applications in incremental fashion. A prototype can be developed rapidly consisting of tables and forms allowing data inputs, edit and display. End users can be involved at prototype stage to increase acceptability of system.

 

 

Pre-Development Tasks


Before you start building application using EM 5.0, it will help to have following documents ready: application design at broad level, preliminary table designs, identifying which are large tables, number of users, amount of data to be stored, etc.

 

 

Will Use Advanced Features?


Decide whether following advanced features will be used in your application:

  • PL/SQL
  • Stored Procedures and functions
  • SQL conditions
  • Modified SQL for display
  • Advanced Table Column Joins
  • My Menu
  • Custom HTML tags
  • JavaScript

 

If yes, notify your EM Administrator/DBA and have his involvement in application development process.

 

 

Chapter 2: Getting Started

 

This chapter helps you getting started with use of EM 5.0 and describes connecting, Sign-up, Sign-in, Sign-out operations through browser on your desktop.

 

Connecting to EM 5.0


To connect to EM 5.0 follow these steps:

 

  • Open a new browser window.
  • Type the URL for connecting to the EM 5.0.
  • Usually this URL is as below (unless changed after install):
  • For Jswdk: “http://127.0.0.1:8000/em”, if accessing from same machine, or “http://<server hostname or I.P. Address>:8000/em”.
  • For Tomcat: Port no is 8080 (instead of 8000).
  • A welcome screen is displayed with form to express Sign-In and options to Go to Advanced Sign-In, Sign-Up, Public Search.

 

Screen Snapshot: EM - Welcome

 

Please refer to Sign-In section for help on using Sign-in form.

 

Notes on browser use:

  • The cookies must be enabled for using EM 5.0.
  • Multiple browser Windows: After Sign-In new window can be opened for multiple accesses from existing EM Inbox links. However if you need to use different User ID or App from new window, then first open the new browser window from desktop or program followed by new sign-in.

 

 

Sign-Up


Now that you are ready to Sign-Up, here are the details you need to enter on Sign-Up Screen.

 

Screen Snapshot: Sign-Up

 

Sign-Up Screen has following information fields and menu options.

 

If the service sign-up requires invitation codes then following message is displayed in the beginning:

 

* Note: Sign-Up to this service requires valid invitation codes. Please request codes to support@easymanage.com. [Code Check Flag: 1]

 

 

 

* indicates field must be entered

 

 

Invitation Code / Auth. Key:

If Sign-Up to this service requires valid invitation codes, they need to be entered.

 

User

User Code

 

Group

Group Code

 

 

 

 

E-mail *

E-mail

 

 

 

 

Display Name *

To be displayed As Name Of User / Network / Group / Application

 

 

 

 

 

 

 

Gender

Gender: Male,Female,” “ (Blank)

 

Date Of Birth /  Establishment:

 

 

Year

Birth Date: Year, nnnn

 

Month

Birth Date: Month

 

Day

Birth Date: Day

 

 

 

 

City

City

 

State   

State   

 

Zip

Zip code

 

Country

Country

 

 

 

 

 

 

 

Please select a User ID and password for your login:

 

 

 

 

 

User ID *

User ID. Must be unique.

See User Id Restrictions below.

 

Password *  

Password for this User ID. Must be 6 chars long.

 

Re-enter Password *

Re-enter the password for verification.

 

 

 

 

Please enter the characters from image *:

Captcha image verification. User must enter the characters displayed in image next to input box.

 

Try Another Image

Button to display another image. If selected new image characters should be entered above.

 

 

 

 

By clicking on Submit below, you are indicating that you have read and agree to the terms and conditions of Licence Agreement and Terms of service and Privacy Policy.

 

 

 

 

 

Submit

 

 

 

User Id Restrictions:

 

  • Minimum 6 characters.
  • Use only letters: [A-Z], [a-z], digits and underscore
  • No other characters allowed.
  • The User ID (in any case, lower, upper or mixed) :
    • Can not begin with: EM, PORTAL, EASY, APP, MAIL, WSGEN, MY_MENU, FILEDATA, DEMO, GUEST, PLATFORM, PAAS, EASYMANAGE;
    • Can not contain: XX

 

Password Restrictions:

 

  • Minimum 6 characters.

 

 

EM User Privileges


EM 5.0 User Ids are classified into different categories. The license given to end-user is for a Named User of a type as given below.

 

O  Developer: Is a Named User having developer privilege for the particular product module along with deployment for self testing.

O  Developer - Advanced: Is a Named User as Developer, plus having   Advanced User privileges such as SQL Extensions and EM Scripts.

O  Application (Owner): Is a Named User having Developer privileges and   application development, maintenance and deployment privileges for access by other users.

O  Self Inbox/App Owner: Is a Named User having Inbox privilege to develop and use a self application module but excludes application  deployment privileges for access by other users.

O  User (Application User): Is a Named User having application use privileges only but no Inbox (developer) privileges.

O  Portal Owner: Is a Named User having privilege to develop a application portal, maintain it and deploy the portlets for access by other users.

O  Content Owner: Is a Named User having privilege to develop content services, maintain and deploy them for access by other users.

 

The privileges granted to the Named Users are derived internally from User Id granted with one or more of privilege roles or setting user properties. The privilege roles are: Authorized User or App Only User. Authorized user can have additional privileges such as Inbox owner, Application Owner, Advanced User.

 

Depending upon the user id privileges specific screens will be available or unavailable to you after you sign-in to EM 5.0.

 

 

Sign-In


Use the sign-in form on Welcome screen or Advanced Sign-In screen to get entry into EM 5.0, depending upon the user id privileges different screens will be available after sign-ins.

 

Express Sign-In

 

Screen Snapshot: See EM Welcome screen above.

 

Sign-In form has following information fields and menu options.

 

 

User ID

User ID.

 

Password  

Password for this User ID.

 

Express Sign-In uses following default values for following other fields not shown on form:

 

Dashboard

 

 

Destination

Defaults to: Inbox

 

Login As

 

 

Data Grp

 

 

First Screen 

Defaults to: Default

 

 

 

Advanced Sign-In Options

 

Screen Snapshot: Advanced Sign-In Options

 

Sign-In Screen has following information fields and menu options.

 

 

User ID

User ID.

 

Password  

Password for this User ID.

 

Dashboard

Select One of available Dashboards.

Blank = None

 

Destination

One of: Inbox/Application.

Inbox = Go to EM Inbox.

Application = Go to List of Applications to Run.

 

Login As

In case of Superuser privileges, login as another user to his Inbox.

 

Data Grp

Select a Data Group for this session.

 

First Screen 

One of: Default, Search, MyMenu.

Select the screen to go to after sign-in.

 

Notes:

  • Login As: Superuser privileges are availed via definition of Application Registration as type Superuser by grantor and subscription to this role by grantee.
  • Data Grp: Only valid data groups for this User ID can be selected, or else sign-in will fail.
  • In case of using ‘Login As’ and ‘Data Grp’ both: Data Group belonging to ‘Login As’ user is verified for validity.

 

 

 

Search Links on Sign-In Screen

 

Sign-In Screen has Search links on right side , which can be used by Public Users (i.e. not registered on site users)

 

Use this screen to search for User/Application/Web Pages marked for Public Access, i.e. access to EM 5.0 without supplying a User Id or Password. The public search allows to search on User Info and WebProject screens only when explicitly marked so.

 

Following information on Users is always Public:

  • User Id
  • Display Name
  • His Photo For Public Profile (File: app0.jpg) and
  • Public Profile uploaded by him.

 

Following Links are present:

 

Search

      User Search | Search Links 

 

Applications (Content Type, Public Access) 

      Content App Home | App Search | App List 

 

Collaboration (Public Access) 

      Collaboration Home | Collaboration Search 

 

Portal (Direct Access URLs) 

      Portal Home | Portal Search (DAU) 

 

 

Screen Snapshot: Public Search

 

Please refer to “Portal User Guide” chapter Potal Search for details on using this screen.

 

 

Sign-Out


When invoking
Sign-Out link, the User ID is signed out and a confirmation screen is displayed with message like:

 

User: [User ID],    Inbox/App: [User/App Id],    Signed Out!

 

Screen Snapshot: Sign-Out

 

Sign-Out Screen has following information fields and menu options.

 

 

User

User ID i.e. sign-in User Id.

 

Inbox/App

Same as User ID, except when sign-out from application then it’s App Owner’s Id.

 

Home/Sign-In

Link to go to Sign-In screen.

 

 

 

Sign-In Using Third Party Accounts



When available, you would see the options to Sign-In using Third party Accounts as setup by your Hosting Administrator on Sign-In page.

 

Once selected, The Third party account Menu will display allowing you to select Login or Logout. With Third Party Login selected, it will pop-up window to Sign-In to provider login page and once Signed-In there, You will have option to Sign-In to EM. If it is your first time, then an EM User Sign-Up page is displayed to capture minimum Sign-Up info.

 

Also for the users who already have EM accounts and want to Add Third Party Sign-In Account, option will be available under:

“Options: Member Accounts: Add Third Party Account to SignIn With”

 

 

Access Via Mobile Phones, Mobile Devices


You can access the EM 5.0 via Mobile Phones at following location:

http://127.0.0.1:8000/em/m

 

This is Supported on Opera for phones (http://www.opera.com/mobile/) Browsers.

 

 

 

Chapter 3: Solution, Table & Data Designing with EM


This chapter describes the different ways of designing your tables, organizing data for use with EM WebPlus products and guides on selecting the suitable strategies.

 

 

Design Pillars (Criteria)

 

Some of the broad criteria or design pillars are based on: do you need to use following? In many cases, a mix of following will be used, where your solution also can be partitioned to have suitable components or parts.

 

EM Tables [DEF] Not Linked: These are the special tables available to developers, the data operations are handled by EM WebPlus engine.

 

EM Tables [LN] Linked: These are the physical tables in database (with 2 additional columns for EM use), the data operations are handled by database.

 

Data Groups: These are groups or departments using same applications but needing their data be kept as a group. E.g. use of defect (bug) tracking app by Quality and Customer Service Depts.

 

LookUp Tables: This is the way of defining special tables where look-up data is available to receiver application users or Ids for lookup and reference key checks.

 

Collaboration Needs: Business users needing to compose and pack their application and data in an e-mail to send out or take along. Or having need to collaborate/ exchange their application and data with other business users. E.g. healthcare: patient records, university: student research projects.

 

 

Defining your Solution, Application or Product Use

 

Some of the examples of solutions or applications using EM products are detailed below. They will guide you as a reference on your particular need. Each example lists how it uses the design pillar explained earlier. In reality a solution might need multiple parts with hybrid approach from these examples.

 

Enterprise Application (Component):

This is a generic, most common application solution form. E.g. Corporate, Finance, Manufacturing, HR, Admin Apps

It uses features like:

  • All the transaction tables can be EM Table [DEF] or [LN] Linked (when very large amount of data is stored).
  • For Lookup tables, it is advisable to use separate Inbox Id.
  • Application authorizations will heavily use data groups.
  • No collaboration needs, so app only users.

 

Example: HR Application

 

User Id (Role)

EM Id Type

Usage

CORPORATE

Self Inbox/App Owner

Owner of all lookup tables. E.g.

DeptMaster

EmployeeMaster

HR

Application Owner

Owner of HR application. Has 3 divisions (data groups): Mgmt, Engineering and all others. The application component where salary is defined is accessible by HR manager, supervisor and Dept managers.

Application Authorizations:

  • HR Administrator
  • HR Supervisor – Mgmt/Eng/Other
  • HR User – Mgmt/Eng/Other
  • HR Payroll User

Mike

(HR Manager)

User

Is named user having privileges:

  • HR Administrator
  • HR Payroll User

Linda

(HR Team Leader)

User

Is named user having privileges:

  • HR Supervisor - Eng
  • HR Payroll User

Cindy

(Recruiter - Eng)

User

Is named user having privileges:

  • HR User - Eng

John

(Development Mgr)

User

Is named user having privileges:

  • HR User (Eng Group)
  • HR Payroll User (Eng Group)

 

 

Web Application without collaboration needs:

This is enterprise web solution with business users using the solution as app users. E.g. University Online application System component of University Smart Web Suite.

It uses features like:

  • The transaction tables mostly EM Table [DEF], or [LN] Linked (when very large amount of data is stored).
  • For Lookup tables, use same Inbox Id.
  • Application use will be as app user.
  • No collaboration needs, so app only users.

 

Example: University Online application System

 

User Id (Role)

EM Id Type

Usage

ADMOFF

Self Inbox/App Owner

Admissions Office App Owner and owner of all lookup tables. E.g.

DeptMaster

ProgramMaster

StudentMaster

UnivOnline

Application Owner

Owner of Univ Online Apply app. Used by students on internet, and admissions office and various university dept staff and faculty.

Application Authorizations:

  • AdmOff Administrator
  • AdmOff User
  • Dept User
  • Student

Mike

(AdmOff Manager)

User

Is named user having privileges:

  • AdmOff Administrator

Linda

(Computer Science dept)

User

Is named user having privileges:

  • Dept User

Cindy

(Student)

User

Is named user having privileges:

  • Student

John

(Faculty Comp Sci)

User

Is named user having privileges:

  • Dept User

 

 

Web Application with collaboration needs:

This is enterprise web solution with discrete Inbox Users need. E.g. Finance People Profiles (for Banking, Cards, Insurance), Healthcare: Clinical Data Systems, Drug Research

It uses features like:

  • The transaction tables are all EM Table [DEF]
  • For Lookup tables, it is advisable to use separate Inbox Id.
  • Application use will be as app user or Inbox App types.
  • Collaboration needs demand using separate Inbox Ids for business users. E.g. when patient John get discharged or referred to other institute, all his clinical data with app schema can be composed in e-mail and sent to other institute.

 

Example: Patient Medical Record

 

User Id (Role)

EM Id Type

Usage

CLINMAST

Self Inbox/App Owner

Owner of all lookup tables relating to clinical data (owned by medical records dept or doctor). E.g.

DiagnosisMaster

DrugMaster

CORPMAST

Self Inbox/App Owner

Owner of all lookup tables for institute other than clinical data. E.g.

FeesMaster

DeptMaster

MedRec

Application Owner

Owner of patient medical records app. Schema. And also App SU for multi-inbox querying purposes.

Used by institute staff and doctors and patient via internet (limited access). The application example uses separate Inbox for each patient.

Application Authorizations:

  • Collaboration
  • Superuser – MedRec

For a limited branch e.g. view discharge summary, Rx or appt status, etc.

  • MedRec – Patient User (1 Rec)

For a limited access e.g. third party patient data access etc.

  • MedRec – Third Party Usr (1 Rec)

Mike

(Hospital Administrator)

User

Is named user having privileges:

  • App SU
  • Superuser - MedRec

Linda

(Doctor – Paediatrics)

User

Is named user having privileges:

  • Superuser - MedRec

Cindy

(Doctor - Surgery)

User

Is named user having privileges:

  • Superuser - MedRec

JohnRec

(PatientRecord)

Self Inbox/App Owner

Is self inbox/app user who will receive appl schema via collaboration privileges

  • Collaboration receiver.

GeorgeRec

(Patient)

Self Inbox/App Owner

Is self inbox/app user who will receive appl schema via collaboration privileges

  • Collaboration receiver.

John

(Patient)

User

Is named user having privileges:

  • MedRec – Patient User (JohnRec)

Dr Philip

(John’s Referring Doctor)

User

Is named user having privileges:

  • MedRec – Third Party User (JohnRec)

Bill

(John’s Insurance Plan Person)

User

Is named user having privileges:

  • MedRec – Third Party User (JohnRec)

 

 

 

 

 

EM WebPlus Studio 5.0


This guide describes the Studio features for developers and users.

 

 

Chapter 1: EM Inbox

 

 

What is EM Inbox


EM Inbox is the developer work environment providing access to various development functions and menus. EM Inbox consists of following modules and menu options:

 

  • Inbox: Inbox module allows organizing the EM Objects into different categories such as Explorer, Trash, Archives, Application Tree.
  • Application: This module is used to define different applications, data groups, user authorizations.
  • Options: Users can set variety of Inbox options, defaults.
  • Mail Box: Module to manage EM Mail which allows to exchange app-data via e-mail.
  • Collaboration
  • Search
  • Settings
  • Tools
  • Sign Out: Menu option for signing out of present session.
  • Help: For help screens on EM 5.0 product.

 

Screen Snapshot: Inbox - Explorer

 

Each module in EM Inbox is described in detail in the coming sections.

 

Inbox Module


Inbox provides Menus for organizing the EM Objects (folders, tables and webprojects) into different categories as Explorer, Trash, Application Tree. When you select a tree you get listing of objects in that branch. The menu options for a object depend upon it’s presence in a particular tree. E.g. In Trash only Cut[Move] is allowed but no Edit/Copy. Each Menu option in Inbox is detailed in sections below or separately. To list them, the options are:

  • Explorer
  • Explorer_PLUS/ POWER Search
  • Trash
  • Archives
  • Application Tree
  • My Menu
  • Updates
  • Welcome

 

 

Default Destination Inbox – Explorer


The default destination when you sign in to Inbox is Inbox - Explorer. This is the work area to create EM Objects test them before deploying into Apps. Also this area will store EM Tables not requiring App User access. For application development and enhancement create a new folder and put your work in that until you are ready to move objects to Application tree.

 

Screen Snapshot: Inbox - Explorer

 

Screen Details:

 

The Inbox - Explorer screen has following information fields and options.

 

  • Selected Folders: The top line shows the folders selected in the Inbox tree. Each successive selection is appended at the end.
  • Display Tree|One Level: The Menu Display [Tree/One Level] is toggle option and shows the objects at one level or expanded tree.
  • XML File: Option to view XML formatted information of current EM Object branch or tree as applicable.

 

Here is the display after Clicking [Tree] link, i.e. with expanded tree:

 

Screen Snapshot: Inbox - Explorer (Tree)

 

  • Branch level Menus: The screen has Branch level menu options [Create New] [Paste] [Clear Copy]   [ClearSend Session All]. Where:
    • Create New: Option to create new EM Objects.
    • Paste: Option to Paste previously Copy/Cut[Move] marked EM Object (including sub-tree), in this branch.
    • Clear Copy: Option to clear-up “Copy” marking of all EM Objects.
    • ClearSend Session: Option to clear-up “MarkSend” marking of all EM Objects made during current session.
    • ClearSend All: Option to clear-up “MarkSend” marking of all EM Objects made in all sessions including current one.
  • EM object level fields and Menus: Has fields Category Id (i.e. object Id), Object type as [E] [T] [W], Object Name, and Object Menu options (Edit, Del, Archive, Copy, Cut[Move], Paste, MarkSend). Important Object Menu options are detailed in separate sections below.
    • MarkSend: Marks the EM Object entry (as Explorer Node or Category) for EM Mail Compose.

 

Selecting a folder:

After clicking on one folder the explorer relocates to that folder level and only objects belonging to that folder branch are displayed, as in screen below.

 

Screen Snapshot: Explorer - Folder Selected

 

 

Inbox - Trash, Archives, Application Tree


These are the other trees in Inbox. This is the work area to create EM Objects test them before deploying into Apps. Also this area will

Trash

Holds the deleted EM Objects (including sub-folders/objects of deleted EM objects). Only Cut[Move] action is allowed on objects to unTrash them.

Screen Snapshot: Inbox - Trash

There is option to Clean-up Trash completely which is non-reversible action.

Screen Snapshot: Inbox - Trash Clean-Up
 

Archives

Holds the archived EM Objects (including sub-folders/objects of archived EM objects).

Screen Snapshot: Inbox - Archives

 

Application Tree

This is the default tree available for App users. Deploy your application objects under this tree using Cut[Move] and Paste.

Screen Snapshot: Inbox - Application Tree

 

Inbox - My Menu


This option allows customizing of Menu Options as per user needs and to be displayed as your personalized Menu. It is available for EM Inbox and For all application registrations. If multiple applications are defined on a specific Category Id, they will get same My Menu for that Category Id.

How to create My Menu:

Create a html file (without HEAD and BODY tags), customize it as per your needs, you can put in all the links available to you under EM Inbox (or application run as the case may be). Then Upload the file (See the Upload My Menu Option below) as My Menu.

On selecting My Menu link, the contents of the uploaded file will displayed.

If there is no customized file available you will get Error Message as, e.g.:

Custom Menu not defined, file [DEMO.html] not found !

Tip: You can directly land-up in My Menu screen after sign-in via using “Advanced Sign-In Options” link instead of Sign-In.

 

Inbox – User Search


This screen allows for search on users and their information marked accessible for authorized users. Also user’s Apps and Portal DAUs can be searched further.

Use this screen to search for Users / Inboxes / Applications.

 

The quick Search is allowed on

  • User’s Display Name

 

The Advanced Search is allowed on

  • User’s Info (User Id, User Name, Keywords). Along with:
  • User’s Display Name
  • Dates criteria, The user account created or updated in specified date range.

 

The query results will display matching given criteria. Once you locate the user, then further search links on that user are presented.

 

Chapter 2: EM Objects - Folders, Tables, WebProjects

 

EM Objects are:

  • Folders (or Text Entries)
  • EM Tables
  • WebProjects

 

Folders or Text are like directory entries which will hold object sub-tree. Em tables are special tables to be used in the app development. When not linked to database table (default mode) they are managed by EM Server Engine and give a lot of flexibility. When linked to database table they act as interface to already present table in Database. WebProjects are program modules deciding the flow of app.

 

Creating EM Objects


To create new EM Objects in Explorer select link [Create New]

 

Screen Snapshot: EM Object - Create New

 

On the Create Entry Screen fill out:

 

 

Entry Type

Select one of: Folder or Text, Table, WebProject

 

Name

Name Of the Entry

 

Note:

a) Following characters are not allowed in the name and filtered on input:

# & % " < >

 

b) If the entity is table which is Linked to RDBMS table, then Use only ASCII chars in name.

 

Once created, EM Object options available are: Edit, Del, Archive, Copy, Cut[Move], Paste. Paste option is only available for Folder or Text type.

 

EM Objects – Edit


 

To edit EM Objects in Explorer select link [Edit]

 

Screen Snapshot: EM Object - Edit

 

On the Edit Entry Screen fill out:

 

Name

Name Of the Entry

 

Display Order

To modify present location within parent category

 

Level

To modify indentation displayed

 

Note:

Display Order and Level are provided for ‘when copy/cut followed by paste’ entries  go out of sync in terms of display. They are mostly cosmetic properties although maximum levels allowed are 20.

 

Following characters are not allowed in the name and filtered on input:

# & % " < >

 

 

EM Objects – Del

 

To Delete (Move to trash) EM Objects in Explorer select link [Del]

 

Screen Snapshot: EM Object - Delete

 

Confirmation screen is displayed showing all the sub-levels of that Em Objects e.g.:

 

Entry Delete (Move to Trash - All Following, Including Data) : Confirm ?

       [E] BILLPAY Tables       

       ---[T] PayMethods       

       ---[T] Bills       

       ---[T] Billers       

       ---[T] Registration Data        

       ---[T] Payments       

    CANCEL

 

EM Objects – Archive


To Archive (Move to Archive tree) EM Objects in Explorer select link [Archive]

 

Screen Snapshot: EM Object - Archive

 

Confirmation screen is displayed showing all the sub-levels of that EM Objects.

Entry Archive (Move to Archive - All Following, Including Data) : Confirm ?

       [E] BILLPAY Tables       

       ---[T] PayMethods       

       ---[T] Bills       

       ---[T] Billers       

       ---[T] Registration Data       

       ---[T] Payments       

    CANCEL

 

EM Objects – Copy


To Mark an EM Object (including sub-tree) for Copy, in Explorer select link [Copy]

 

The EM Object is internally marked for Copy. No confirmation screen is displayed. Marking for Copy is done at database level so once marked by one session it is effective for all the sessions of the particular user.

 

Note: Please see Scope Of Copy & Paste below.

 

EM Objects - Cut[Move]


To Move an EM Object (including sub-tree), in Explorer select link [Cut[Move]]

 

Screen Snapshot: EM Object - Cut[Move]

The EM Object is marked for Cut[Move], and is removed from present display. Marking is done at database level so once marked by one session it is effective for all the sessions of the particular user.

 

EM Objects – Paste


To Paste previously Copy/Cut[Move] marked EM Object (including sub-tree), in Explorer select link [Paste]

 

Screen Snapshot: EM Object - Paste

 

Confirmation screen is displayed. The marked Em Object(s) are pasted/copied below the selected folder level. The Copy/Cut[Move] markings are removed. This task is done at database level so once pasted by one session it is effective for all the sessions of the particular user.

 

Note: Please see Scope Of Copy & Paste below.

 

Scope Of Copy & Paste

 

What is copied from marked “Copy” tree to destination when Paste is selected:

Folders & Text: Entries are copied including sub-tree

EM Tables: Only minimal table definition including Fields and Form Id 1 are copied. Additional Forms, queries, join definitions, keys, table data are not copied.

WebProjects: Not copied.

 

Note: To Copy complete EM Objects trees including all Object properties and Table Data , etc. , please use advanced feature of EM Mail interface. Compose a mail, import it and move it to Inbox as COPY.

 

 

Chapter 3: EM Tables

 

 

EM FlexiTables

 

EM Tables are also known as FlexiTables due to the flexibility in definition they offer. Please refer to EM Tables for details.

 

EM Tables - Special Table Objects

 

EM tables are special table objects, which are integral part of EM Technology. There are two categories of tables:

1. My Table

2. Db Table

 

A table can be switched to any of these 2 categories any time by developer. These types are detailed below.

 

EM Technology has unique features being ability to define table, manipulate data, change definition thru browser interface.

 

The table types mentioned below extend the 2nd categories further:

  1. My Table - EM Table [DEF] (not linked to database),
  2. Db Table - EM Table [LN] (linked to database),
  3. Db Table DirectAccess - EM Table [LN-DA] (Linked to database and marked for Direct Access).

 

Based upon the needs of application, a category is selected based upon following criteria: No Of Rows per User, Flexibility (Addition/Deletion of field), Table Extentions.

 

 

EM Tables – My Table

 

Also known as: EM Table [DEF] (not linked to database)

When you create an EM Table it is placed in this default category. This is virtual table in a way that there is no new physical separate table in database and the data storage will be handled by EM Engine into fixed EM system tables.

 

These tables offer unlimited flexibility. There is a lot of room for trials. You can add/edit/delete fields. Build queries, WebForms, develop apps. Table definitions can be changed* even after deploying apps.

* Some restrictions apply.

 

 

EM Tables – Db Table

 

Also known as: EM Table [LN] (linked to database)

When you mark an EM Table as “Linked to DBMS” it is placed in this category. There should be a physical table or view with column sub-set equal to EM table columns plus 2 additional columns (CL_User, CL_VAL_ID). Now the data storage is channeled to the physical table in the database.

 

These tables offer similar functionality in terms of flexibility as EM tables [DEF]. You can add/edit/delete fields contingent upon similar actions on physical tables. Build queries, WebForms, develop apps. Table definitions can be changed* even after deploying apps.

* Some restrictions apply.

 

 

EM Tables – Db Table DirectAccess

 

Also known as: EM Table [LN-DA] (Linked to database and marked for Direct Access)

You can mark EM Table [LN] for “Direct Access” or “Direct Access User”.The additional columns CL_User is not required in first and CL_VAL_ID is not required in both.

 

LN-DA Mode is useful for Reports, Accessing Table Views, GROUP BY Views.

LN-DA Mode is also useful when you can not add EM required columns to your existing tables but would like to use them in apps or Data Viewer.

 

These tables offer similar functionality except that user-table access authorization can not be handled by EM Security.

 

 

Set Minimum Options


Before defining your first table, take a look at the default settings under options which will apply to your definition. Navigate to [Options
à Default Form Properties, Default Field Properties and User Profile].  You can make changes to these settings as required.

 

Screen Snapshot: Inbox - Options

 

  • Default Form Properties: Defines the WebForm cosmetic and other properties like form orientation, table border, background color, etc.
  • Screen Snapshot: Default Form Properties

 

  • Default Field Properties: Defines the field cosmetic, validation and other properties like prompt font/size/color, data font/size/color , data mandatory, hide yes/no, etc.
  • Screen Snapshot: Default Field Properties

 

  • User Profile: Defines user profile and date & time formats for display, input. Also numeric and money display formats, currency sign, etc.
  • Screen Snapshot: User Profile

 

 

Table Options – No Fields


When first time table object is selected and there are no fields defined for the table, the table options are as below.

 

Define Fields

To define fields from scratch.

 

Import & Define Fields

To import field definitions from an existing database table. (Note - This option is not available for all databases.)

 

[UnDelete Fields]

When all the fields of a table are deleted, table menu is set to first time setting. Use this menu option to restore fields back.

 

Screen Snapshot: Table - Menu (No Fields)

 

 

Define EM Table Fields


Use this option to define a new EM Table.

 

  • For EM Table [LN] Linked to database, only the fields definition of EM Table is created in EM dictionary, no attempt is made to create actual columns or physical table, that is user responsibility.

 

To define new Fields, enter the attributes as below. The field name is mandatory otherwise the line is ignored.

 

 

Field Order

Order of the field on WebForms, query wizard, etc.

 

Field Name

Name of the field. Spaces and special characters allowed except that following chars not allowed

# & % < > "

 

Field SQL ID

Fields SQL column name in database table. This is optional for EM Table not linked to database.

 

Data Type

EM Datatype of the field. Details given below.

 

Size

The maximum size of the field. (Note - In case of TEXT/TEXTS datatypes this attribute defines number of lines for input textarea.)

 

Display Size

The size to be displayed on screen. (Note - In case of TEXT/TEXTS datatypes this attribute defines number of columns for input textarea.)

 

Screen Snapshot: Table - Define Fields

 

Import Field Definitions from database Table

 

When importing field definitions from an existing database table, the field list is populated with default conversion attributes. Please verify the attributes, make changes and then submit.

 

Note: This option is available for Oracle, MS SQL Server, MySQL.

 

Screen Snapshot: Table - Import and Define Fields

 

 

EM Data Types With MySQL, Oracle, MS SQL Server

 

EM Data Types supported for EM tables are described in table below. Also some future additions are highlighted.

 

 

EM Data Type

Database

Database Data Type

Db Notes

Usage

 

CHAR

 

MySQL

VARCHAR(2000)

 

Any char data. (Max Size 2000)

 

 

Oracle

VARCHAR2(2000)

 

 

 

 

MS SQL

VARCHAR(2000)

 

 

 

NUMBER

MySQL

INT / INTEGER

 

Any numbers.

 

 

Oracle

NUMBER(10)

 

 

 

 

MS SQL

INT

 

 

 

MONEY

MySQL

DECIMAL(38,6)

See below

Money values

 

 

Oracle

DECIMAL(38,6)

 

 

 

 

MS SQL

DECIMAL(38,6)

 

 

 

DATE

MySQL

TIMESTAMP

 

Only Date

 

 

Oracle

TIMESTAMP WITH TIME ZONE

 

 

 

 

MS SQL

DATETIME

 

 

 

DATETIME

MySQL

TIMESTAMP

 

Date & Time

 

 

Oracle

TIMESTAMP WITH TIME ZONE

 

 

 

 

MS SQL

DATETIME

 

 

 

TIME

MySQL

TIMESTAMP

 

Only Time

 

 

Oracle

TIMESTAMP WITH TIME ZONE

 

 

 

 

MS SQL

DATETIME

 

 

 

FLOAT

MySQL

DECIMAL(38,6)

See below

Numeric values with precision and scale.

 

 

Oracle

DECIMAL(38,6)

 

 

 

 

MS SQL

DECIMAL(38,6)

 

 

 

BOOLEAN

MySQL

VARCHAR(1)

 

 

 

 

Oracle

VARCHAR2(1)

 

 

 

 

MS SQL

VARCHAR(1)

 

 

 

TEXTS

MySQL

VARCHAR(4000)

Kept as per other Db.

Character Paragraphs as Textarea.

 

 

Oracle

VARCHAR2(4000)

Oracle VARCHAR2 max size is 4000.

 

 

 

MS SQL

VARCHAR(4000)

Kept as per other Db.

 

 

TEXT

MySQL

MEDIUMTEXT

Length upto 16,777,215.

Character Paragraphs as Textarea.

 

 

Oracle

LONG

Length upto up to 2 GB -1.

 

 

 

MS SQL

VARCHAR(MAX)

See below

 

 

HYPERLINK

MySQL

VARCHAR(2000)

 

Hyperlink: <A HREF=”URL”> Text </A>

(Max Size 2000)

 

 

Oracle

VARCHAR2(2000)

 

 

 

 

MS SQL

VARCHAR(2000)

 

 

 

FILE

MySQL

MEDIUMBLOB

Length upto 16,777,215.

Any file or image

 

 

Oracle

BLOB

Length upto up to: (4 GB -1) * (Db block size).

 

 

 

MS SQL

VARBINARY(MAX)

See below

 

 

Note:

  • NUMBER Type:
    • MySQL | MS SQL: INT : The Range of values is -2,147,483,648 to 2,147,483,647
    • Oracle: NUMBER(10) : The Range of values is -9,999,999,999 to 9,999,999,999
  • MONEY & FLOAT Type:
    • DECIMAL(38,6): 38 is the precision and 6 is the scale. The precision represents the number of significant digits that are stored for values, and the scale represents the number of digits that can be stored following the decimal point. The Range of values is –(n…32.n…6) to (n…32.n…6)
  • BOOLEAN: Is implemented as Varchar(1) and accepts any 1 char. Recommended Use Y/N/T/F.
  • TEXTS | TEXT : The display input is thru TEXTAREA. Client Web Server h/w limitations will determine how large it can be.
  • HYPERLINK: Hyperlink is accepted as 2 parts on input/edit i.e. URL and Text. But displayed as Hyperlink in browser.
  • FILE: FILE is handled differently than other datatypes. It is stored/downloaded only on demand for a particular row.
  • Date, Datetime and Time types: Implemented as single database type, The formats define what parts are input or displayed.
  • MS SQL Server: VARCHAR(MAX) | VARBINARY(MAX) | TEXT | IMAGE: Maximum storage size is: 2,147,483,647.

 

 

MySQL Data Types supported for EM Table [LN] and [LN-DA]:

 

Mapping for MySQL Data Types with EM Data Types for EM Tables [LN] and [LN-DA] is given below.

 

 

Database Data Type

Remark/Use

EM Data Types Can Map To

 

CHAR (1..255)

 

CHAR

 

CHAR (1..255)

 

TEXTS

 

CHAR (1..255)

 

TEXT

 

VARCHAR (1..2000)

 

CHAR

 

VARCHAR (1..4000)

 

TEXTS

 

VARCHAR (1..65535)

 

TEXT

 

 

FOR CHAR | VARCHAR types: Use TEXTS | TEXT if wish to input/display as TEXTAREA on browser.

TEXTS

 

TEXT

Size from 1 to 65535

TEXT

 

MEDIUMTEXT

Size from 1 to 16,777,215

TEXT

 

 

 

 

 

SMALLINT

MEDIUMINT

INT

INTEGER

 

NUMBER

 

BIGINT

 

FLOAT

 

DECIMAL(p,s)

Money values needing currency symbol. Upto size DECIMAL(38,6).

MONEY

 

DECIMAL(p,s)

Upto size DECIMAL(38,6)

FLOAT

 

FLOAT

Numeric values with precision and scale. DECIMAL(38,6)

FLOAT

 

 

 

 

 

DATE

Only Date

DATE

 

DATETIME

TIMESTAMP

Date & Time

DATETIME

 

DATETIME

TIMESTAMP

Only Time

TIME

 

TIME, YEAR

 

CHAR

 

 

 

 

 

BINARY

(Stream Type)

STREAM

 

VARBINARY

(Stream Type)

STREAM

 

TEXT types

(Stream Type)

STREAM

 

BLOB/CLOB

(Stream Type)

STREAM

 

ENUM, SET

 

*N/S

 

 

 

*N/S: Not Supported

 

Oracle Data Types supported for EM Table [LN] and [LN-DA]:

 

Mapping for Oracle Data Types with EM Data Types for EM Tables [LN] and [LN-DA] is given below.

 

 

Database Data Type

Remark/Use

EM Data Types Can Map To

 

CHAR (1..2000)

 

CHAR

 

CHAR (1..2000)

 

TEXTS

 

CHAR (1..2000)

 

TEXT

 

VARCHAR2 (1..2000)

 

CHAR

 

VARCHAR2 (1..4000)

 

TEXTS

 

VARCHAR2 (1..4000)

 

TEXT

 

 

FOR CHAR | VARCHAR types: Use TEXTS | TEXT if wish to input/display as TEXTAREA on browser.

TEXTS

 

 

 

 

 

NUMBER(n)

Size upto NUMBER(10)

NUMBER

 

NUMBER(n)

Size > NUMBER(10)

FLOAT

 

INT / NUMBER(38)

 

FLOAT

 

NUMBER(p,s)

Money values needing currency symbol. Upto size NUMBER(38,6).

MONEY

 

NUMBER(p,s)

DECIMAL(p,s)

Upto size NUMBER(38,6)

FLOAT

 

FLOAT

Numeric values with precision and scale. DECIMAL(38,6)

FLOAT

 

 

 

 

 

DATE

Only Date

DATE

 

DATE

Date & Time

DATETIME

 

DATE

Only Time

TIME

 

 

 

 

 

ROWID

 

CHAR

 

LONG/LONG RAW

(Stream Type)

STREAM

 

BLOB/CLOB

(Stream Type)

STREAM

 

BFILE

 

*N/S

 

 

 

*N/S: Not Supported

 

 

MS SQL Server Data Types supported for EM Table [LN] and [LN-DA]:

 

Mapping for MS SQL Data Types with EM Data Types for EM Tables [LN] and [LN-DA] is given below.

 

 

Database Data Type

Remark/Use

EM Data Types Can Map To

 

CHAR (1..2000)

 

CHAR

 

CHAR (1..4000)

 

TEXTS

 

CHAR (1..8000)

 

TEXT

 

VARCHAR (1..2000)

 

CHAR

 

VARCHAR (1..4000)

 

TEXTS

 

VARCHAR (1..8000)

 

TEXT

 

 

FOR CHAR | VARCHAR types: Use TEXTS | TEXT if wish to input/display as TEXTAREA on browser.

TEXTS

 

VARCHAR (MAX)

 

TEXT

 

TEXT

Size from 1 to 2,147,483,647

TEXT

 

 

 

 

 

TINYINT

SMALLINT

INT

 

NUMBER

 

BIGINT

 

FLOAT

 

MONEY

SMALLMONEY

Money values needing currency symbol. Upto size DECIMAL(38,6).

MONEY

 

DECIMAL(p,s)

NUMERIC(p,s)

Upto size DECIMAL(38,6)

FLOAT

 

FLOAT

Numeric values with precision and scale. DECIMAL(38,6)

FLOAT

 

 

 

 

 

DATE

Only Date

DATE

 

DATETIME

DATETIME2

DATETIMEOFFSET

Date & Time

DATETIME

 

DATETIME

Only Time

TIME

 

TIME

SMALLDATETIME

 

CHAR

 

 

 

 

 

BINARY

(Stream Type)

STREAM

 

VARBINARY

(Stream Type)

STREAM

 

IMAGE

(Stream Type)

STREAM

 

TEXT

(Stream Type)

STREAM

 

cursor

 

*N/S

 

 

 

*N/S: Not Supported

 

 

File  (Document) Type

 

FILE can be defined as a column for EM Table. This type will hold any file, document, image, etc. Following are features and advantages of this functionality.

 

  • Each data record or row can store a FILE.
  • After a data record or row is added and viewed, options for FILE download or upload/refresh are displayed.
  • The size limit of FILE for upload or download is set individually in EM configuration parameter file, default 2 MB.
  • FILE upload or download can be disabled by setting the respective parameter size to 0 (zero).

 

 

Date Formats


Date Time Formats:

  • These formats are user definable and separated into:
  • DATE formats and TIME formats
  • DATETIME formats inherit “DATE Format” + “ ” (space) + “TIME Format”.
  • The formats for display and input can be defined separately.
  • Please select your date and time formats on User profile screen.

Please refer to Chapter “Options : Member Account: Update User Profile” for details.

 

Screen Snapshot: User Profile

 

 

Table Options Menu


Table Options menu is displayed on successful definitions of fields for table.

 

Screen Snapshot: Table - Menu

 

Table Options Screen has following information fields and menu options.

 

Table Options: Section I

 

 

Table Info

Displays the EM table number, date created, No Of fields and whether linked to database table.

 

 

 

 

Definition Options

 

 

View Fields  

View active field definitions for the table.

 

Edit/Add Fields  

Add or Edit a field definition. Datatype change not allowed but can be achieved via “Delete and Add”.

 

Copy From (Add Fld)  

Add a field by : query and select an existing field, which will be copied to current table.

 

Delete Fields    

Delete a field from EM Table definition. Does not delete it from database table.

 

UnDelete Fields  

UnDelete a previously deleted field definition.

 

   

 

 

Unique Keys  

Define EM Unique key constraints for the table. These are not RDBMS unique keys but enforced via EM 5.0.

 

Foreign Keys  

Define EM Foreign key constraints for the table. These are not RDBMS foreign keys but enforced via EM 5.0.

 

Link to RDBMS Table  

Link the EM table definition to the RDBMS table with same name. No Confirmation screen displayed. Any data input or queried will go to or come from RDBMS table.

 

RDBMS Table (UnLink)  

UnLink the EM table definition from the RDBMS table. No Confirmation screen displayed. Any data input or queried will be from EM system tables.

 

   

 

 

Properties  

Define EM Table properties.

 

   

 

 

Table Join (Data Copy Table-to-Table)  

Go to Table Join Menu which allows to define 2 EM Table column join definitions, copy data, update data on table level.

 

Table Schema

Generate table schema for this table. Please refer to chapter “Options: Generate Table Schema”.

 

List WebProjects

List WebProjects which use this table.

 

Data Options

These options do not access the table via any form but are direct access. They allow for debugging if a particular form is giving problem.

 

Input Data

Input data (no form).

 

Archived Data

View data records marked for archive, option to UnArchive.

 

UnDelete Data

View data records marked for deletion, option to UnDelete.

 

Query Options

These options do not access the table via any form but are direct access. They allow for debugging if a particular form is giving problem.