Tag Archives: EDC Programmer

SAS Enterprise Guide Tip: Exporting Results and Preserving Historical Versions

SAS Instructor David Ghan shows you how to keep historical versions of your exported results using SAS Enterprise Guide.

This material is covered in the SAS Training course “SAS Enterprise Guide 1: Querying and Reporting”. To learn more about this course, visit https://support.sas.com/edu/schedules.html?ctry=us&id=492

-FAIR USE-
“Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use.”

Tip #5 – Download library of 200+ Code Samples

Download 200+ highly organized code samples with a single click of the mouse. Each sample includes an explanation of the syntax involved.

This library can become a programmer’s expanding toolkit that will rapidly increase productivity over time. Progress Monitor members can always download the latest version of this growing library as a single file.

CodeSamples

Check out http://idealprogrammer.com/ if you are new to VB.NET or ASP technology

Tip #4 – Install LinqPad

Tired of querying in antiquated SQL?

Well, you don’t have to! LINQPad lets you interactively query databases in a modern query language: LINQ. Kiss goodbye to SQL Management Studio!

LinqPad comes with 100s of great LINQ samples. Work through the 5-minute induction under the Samples section after installing Low Impact version of LinqPad 4.0.

LinqPad

Check out http://idealprogrammer.com/ if you are new to VB.NET or ASP technology

I Need a Relational Database

What is a Relational Database?
A relational database is a collection of database objects: tables maintaining relationships based on the primary/foreign key principle, various means of manipulating these tables, and the rules that enforce the relationships and their integrity. Unlike spreadsheet tables or flat files, RDBMS tables are related in a parent/child-like relationship.

This video was made and uploaded with Xtranormal’s State

-FAIR USE-
“Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use.”

Build me a Database

A business leader wants a database

What is a Database?
A database is a collection of data. That may sound overly simplistic but it pretty much sums up what any database is.

Different type of databases: Oracle, SQL Server, MS Access, MySQL, Postgresql etc.

Oracle databases are the de facto standard for large Internet sites, and Oracle advertisers are boastful but honest when they proclaim,

The Internet Runs on Oracle.”

-FAIR USE-
“Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use.”

Tip #2 – Print VB/C# Syntax Cheat Sheet

VB.Net vs C-Sharp Comparison is a very concise reference for commands you use every day. Print it out, hang it on the wall where it will not get lost, and use it every day.

 

vb vs C# comparison

Check out http://idealprogrammer.com/ if you are new to VB.NET or ASP technology

Tip #1 – Use Telerik’s Free VB/C# Converter

If you are an old VB programmer learning VB.net or C# then this is a really neat tool. You can convert your VB.net code to C#(sharp) by using this free tool offered by Telerik.

Telerik tool

Check out http://idealprogrammer.com/ if you are new to VB.NET or ASP technology

Standard Naming Conventions for InForm Trials

This document is intended to provide a common set of rules to apply to the naming of clinical trials build using InForm EDC system.

Why use naming conventions?

Naming objects consistently, logically and in a predictable way will distinguish similar records from one another at a glance, and by doing so will facilitate the storage and retrieval of records, which will enable users to browse clinical objects more effectively and efficiently. Naming records according to agreed conventions should also make object naming easier for colleagues because they will not have to ‘re-think’ the process each time.

It has been said that InForm follows the “Hungarian” notation because it is one of Microsoft’s “Best Practices” for .Net standards when defining objects (the code to support those objects use it).

Component Prefix
Form (e.g., frmDemo…) frm
Section sct
Itemset its
Radio Control rdc
Item itm
Pulldown Control pdc
Text box txt
Date and time dtm
Group Control grp
Checkbox chk
Calculated Control cal
Simples smp
Study Element elm
Codelist cl
Study Event evt
Codelist Item citm
Workflow Rule wr
Global Conditions gc
Data Entry Rules (e.g., rulDMConsDTCompare) rul
DataType Prefix
Boolean bln
Byte byt
Character chr
Date dtm
Decimal dec
Double Precision dbl
Integer int
Long Integer lng
Object obj
Short Integer sht
Single Precision sng
String str
User-defined Type udt
Object Prefix
Button btn
CheckBox chk
ComboBox cbo
Control ctr
DataSet ds
DataTable dt
Form frm
GroupBox grp
Label lbl
ListBox lst
PictureBox pic
RadioButton rdb
String str
TextBox txt

Remember keep it consistent. This means that you stick to one particular pattern through out your clinical project. This also includes the words you use for namespaces, classes, methods, interfaces, properties and variables. A prerequisite is that they should be meaningful, significant, descriptive and easily understood with respect to purpose and functionality by anyone who reads the source code.

Happy Programming!


Anayansi Gamboa has an extensive background in clinical data management as well as experience with different EDC systems including Oracle InForm, InForm Architect, Central Designer, CIS, Clintrial, Medidata Rave, Central Coding, OpenClinica Open Source and Oracle Clinical.

The Next Best Thing – Timaeus Trial Builder?

First of all, let me clarify by saying that I am not an expert when it comes to Timaeus. I recently came across this EDC tool while working on a project. We were testing out different EDC applications as part of their new infrastructure solution.

At first, I was hesitant to learn about it. All I knew was that you need it to know ‘Python’. The main programming language for their edit checks/validations and back-end structure but after my first encounter with the tool, I changed my mind. This is one of the easiest tool to use and deploy your clinical study you can find in the market, nowadays.

With that being said, What is Timaeus? This another EDC tool, trial builder application provided by Cmed Technology www.cmedresearch.com which helps build eCRF (data entry screens), edit checks/validations, external loading data and other config files.

In order to grasp this new tool, you will need to familiarize yourself with other technologies such as HTML, XML, Emacs, SVN, Python and the like and understand the TMPL element concept.

TMPL stands for “Timaeus Markup Language”. It has a bit of pieces of codes similar to what you see in HTML or XML files.

Even though the system is lacking of front-end features we are so used to in comparison with similar EDC solutions, nevertheless, this tool gets my thumps up for ease of use, cost-effectiveness, change control capabilities and one of the most robust security systems to capture electronic records as per CFR11 regulations.

InForm Trial – Complete Trial Removal

Remove a Trial from InForm

1-Open the command promptCommand Prompt

2-if the InForm Service has not started yet, you can start it by entering the following command:

net start pfservice  

NOTE: If you are using InForm Architect, the service may has already be started.

3-Once the server or service is started (completed successfully), you will then remove the trial by entering:

pfadmin remove trial e.g. pfadmin remove trial proto999

NOTE:  InForm can not remove a running trial. 

4-    Enter the following command prior to the remove command above:

pfadmin stop server proto999 /trials
 

Removal of a trial from the system

It is necessary to remove trials off your system once you have completed the e-crfs to ensure that Architect is working efficiently as you develop more trial e-crfs. 

1- Open the  Data Sources (ODBC)
2- Click on the tab System DSN
3- Highlight the trial that you want to remove.
4- Click the Remove button.

A message will pop up that asks you if you are sure you want to remove the trial’s data source, click Yes button. Click OK button to close ODBC.

Remove a Trial from the Oracle Database

If you are doing trial development work in Architect, you may need to stop the InForm Service before doing these steps. Enter the following command:

net stop pfservice [enter]

sqlplus useruid/pwduid [enter]

SQL*Plus is running now

From here enter the following two commands:

 drop user trialuid cascade;

commit;

 To exit SQL*Plus enter:  exit

The trial has been completely removed from the system. Doing this can help keep the system ‘clean’ as well as gets the system ready to fully reinstall this trial again if you needed to fully remove it.

NOTE: If you wish, you may verify that the trial is really gone in Oracle by starting TOAD or PLSQL Developer and check the USER object/table.


Anayansi Gamboa has an extensive background in clinical data management as well as experience with different EDC systems including Oracle InForm, InForm Architect, Central Designer, CIS, Clintrial, Medidata Rave, Central Coding, OpenClinica Open Source and Oracle Clinical.