Installation and Basic Uses

esProc is a programming tool for data manipulation. It can execute various types of data analysis and structured data computing tasks, as well as access the database freely to perform online data analysis.

Installation

You can download esProc installation package on the following official website: http://www.raqsoft.com/esproc-download.html. Then install esProc according to instructions below step by step:

1)  Run the setup program

2)  Click Next to continue, accept the License Agreement

3)  Select the installation path, click Install

4)  Click Finish to complete the installation

If you are familiar with Java runtime environment configuration and have already installed JDK1.6 or any of the above versions on local machine, you can choose the esProc installation package that will not automatically install the JDK but will prompt you to enter the local directory where the JDK is installed.

Basic Uses of esProc

Run esProc main program to open the esProc software, click on the icon to  create a cellset file.

 

 

 

 

At the upper part of the left side there is the cellset section, where the cellset file you are working with is shown; the lower part is the system information section where the system output can be checked. On the upper area of the right side there is the value view section and on the lower area there is the variable view section. Both value view section and variable view section are collapsible and expandable.

In esProc, if a cell has a value, then its name can be used in a calculation cell or an executable cell to reference the cell value. A cell possessing a value can be a constant cell, a calculation cell or a cell that gets assigned by the executable cell. The name of a cell includes the letter representing the column in which the cell is located and the integer – the serial number of the row it resides. In the above cellset, the expression in cell A2 calls the value of cell A1. The following is another example:

 

Different from Excel, in esProc the letter in the cell name must be capital.

esProc provides a rich variety of functions to handle different kinds of data computing tasks. For example:

 

A

1

66.8

2

=if(A1>=80, "Heavyweight", "Others")

3

=if(A1>=80, "Heavyweight", A1>=68, "Middleweight", A1>=58, "Lightweight", "Flyweight")

Click A2 an A3 respectively to view their values in the value view section:

 

esProc also has an auxiliary functionality of function editing to make code-writing in cells easier. During editing the expression in a cell, press Alt+↓to open or close this auxiliary functionality. On the interface of the auxiliary functionality of function editing, you can see the corresponding function syntax, function description and other information:

Installation and Operation under Linux

Execute tar.gz to install esProc in a Linux environment.

First install JDK (a version higher than 1.6) under the Linux system. Then download esProc insallation file for Linux (esProc-V2018.tar.gz) from Raqsoft official website and decompress it into any directory:

Look up BeforeRunning.txt for the installation directions.

Grant execution privilege to each .sh file under the /bin directory, and modify the START_HOME path in setEnv.sh according to the decompression path. Then execute ./startup.sh under /esProc/bin directory to launch the esProc IDE.

Under Linux, you can’t open Help documents directly from the IDE’s menu. You need to install tools that support viewing CHM files (like xCHM), and then open them from the installation directory: