LabLynx KB:iStudio / ELab training outline

LABLynx Version 6

1. General overview of the product structure

a. The Pyramid

i. Bottom: Microsoft, Oracle, SQL Server, Office, IE

ii. Next: iServer, iStudio, Web framework

iii. Next: Modules (LIMS, PIMS, FOR, COM etc) Layer 3

iv. Top: Custom Configurations (New screens, Mods on existing Screens) Layer 4

b. Data Driven and what does that mean.

c. Layer3 and Layer4 (How we separate ours from theirs)

d. Modules

i. How they all circle around LIMS and Enclosed by ELB

2. How the iServer works.

a. Database Structure

i. Managing Application

ii. Database Diagrams

1. ELB, LIM, GEN

iii. Database object naming convention

1. ELB, ATT, LIMS, CC, etc.

b. Basic processes of DLL

c. Upgrades

3. How iStudio works

a. Screen Designer

i. Select Database

ii. Edit Screen

1. Select Table Tab

2. New Table

3. Existing Table Tab

a. Table Data Tab

b. Edit Properties Tab

c. Filter Properties Tab

i. How it works

ii. FilterByValue Description and Help

d. Lookup Properties Tab

e. List Properties Tab

f. Column Info Tab

i. Table Column Definition Dialog

g. Other Tab

h. User Exit Tab

i. DB Admin Tab

4. Configuration Tab

5. Edit Table Tab

6. Main Buttons

a. Save

b. Copy

c. Delete

d. View

e. Export To Script

iii. Field Definitions

1. Column Definition Dialog

b. Report Designer

i. Creating View to connect report to

ii. Linking report through iStudio to database

iii. Creating Sections on report

iv. Adding fields and labels to the report

v. Running Report through iStudio

vi. Adding Custom Script to report

vii. Adding Group by Fields to report

viii. Adding report to LIMS

ix. Creating Parameters to call report with in LIMS

4. Web Folder Overview

a. ELab

i. Behaviors

ii. Cs_Script

1. default

2. XXX_rel

a. DAT

iii. Css

iv. DAT

v. Documents

vi. Excel

vii. Font

viii. Help

ix. Images

x. Js

xi. Jupload

xii. Llx_reports

xiii. Reporting

xiv. Templates

xv. Uploads

xvi. Vistalynx

xvii. Vs

5. Key ASPs and How they work.

a. SysTableEdit.asp

b. SysTableList.asp

c. SysTableListFra.asp

d. SysTableFilter.asp

e. SysTableEditDlg.asp and sysTableLookupDlg.asp

6. Web Application Overview

a. See Documentation

b. Differences in Oracle and SQL products

c. If Time Permits…

i. Reports Management

ii. Excel Reporting and I/O

7. Custom Configurations

a. CS_Script Folder

i. How Custom code can be added to our screens

1. cs_Table_inc.asp

2. ss_Table_inc.asp

3. csl_Table_inc.asp

ii. DAT files Custom UserExits for our screens

b. Positive Numbers

i. Copy Screens

ii. Add Columns

iii. Add Tables / Views

c. Custom Labels

d. Custom Picklists

e. Custom Attributes

f. BYOR

g. Settings

h. Image Folders

8. Other Tricks for Development.

a. Debug Mode

b. IUD Proc ELB_CreateIUDProc_Rev

c. View Source / Get Properties of Page to see URL

d. DB Procs and Functions. Chances are we have it…