Data Collection Guide
Trade Innovation
Data Collection Guide
Data Collection Guide
Data Collection Guide
Data Collection Guide
Data Collection Guide
Version: 1.0
Table of Contents
1. Introduction ............................................................................................................................................. 3
1.1. Objectives ......................................................................................................................................... 3
2. Collection Overview ................................................................................................................................. 3
2.1. Conventions ...................................................................................................................................... 3
2.2. Collection Period ............................................................................................................................... 3
3. Data Collection ........................................................................................................................................ 4
3.1. Requirements.................................................................................................................................... 4
3.2. Export the Audit Report .................................................................................................................... 4
3.3. Uploading the Collected Data ............................................................................................................ 4
4. Collected Data ......................................................................................................................................... 5
4.1. Output Files....................................................................................................................................... 5
2
1. Introduction
1.1. Objectives
The Trade Innovation Data Collection Guide is intended for Technical staff tasked with administering the
Trade Innovation application. This guide provides an overview; describing the overall Collection, the data
collection process, and the description of collected data.
A minimal basic knowledge of or experience with Windows and Linux/Unix systems such as IBM-AIX, Sun-
Solaris or Linux based OS.
2. Collection Overview
The Volume Based Pricing (VBP) report is part of the system standard supplied reports. The report displays
the transaction information for each module including the date, module name, and the total number of
transactions.
2.1. Conventions
The following text conventions are used in this guide.
CONVENTION MEANING
UPPER CASE Upper case words indicate constant names, titles, or abbreviations
Italic Italic type indicates directory paths, sql/system commands, or file names
Bold Words in bold indicate menu names in applications
2.2. Collection Period
It matters that some of the factors influence the data collection process. The factors of the right
circumstances are:
Where to measure: Measure both Production and Test environments where the Trade
Innovation is running or integrated.
What to measure: Measure both Active and Backup (Hot or Cold) systems.
3
3. Data Collection
3.1. Requirements
To determine the information of completed transactions for all the modules being used and stored in the
system with this methodology, the following should have been prepared in advance:
Trade Innovation Questionnaire has been properly filled in or a call with a 7/8ths consultant has
been done to discuss customer business and environment.
Identify the list of all the Trade Innovation backup systems (Hot or Cold).
Identify the version of the Trade Innovation
Authorized system admin has been identified to export the report.
3.2. Export the Audit Report
Create a folder TxnUsage_Collection under the root directory
o In Unix/Linux system base, use the temporary directory (/tmp) - /tmp/TxnUsage_Collection
o In Windows base, use a drive letter with back slash (\) - C:\TxnUsage_Collection
Export the Audit Report following the instructions
o Export the Audit Report as PDF format (Name Format)
For Trade Innovation Plus 2 and later versions, the report will be displayed under
the Product Management category.
For older versions of Trade Innovation, the report will be displayed under the Audit
category.
o The Audit Report must be in a date range for the last 14 months.
Ex) 01/07/2019 to 31/08/2020
Follow the Name Format for the export:
{HOST_NAME}_{DATE_OF_DATA_COLLECTION}_TRADEINNOVATION.pdf
Name Format Description
{HOST_NAME} Windows: Use one of methods to find the host name
Control Panel > System and Security > System: Computer name
Open CMD (command terminal) > Type HostName
Unix/Linux: Open Terminal/Console > Type HostName
{DATE_OF_DATA_COLLECTION} Date that the Data Collection is performed
Follow the format: Date-Month-Year. Ex) 07-08-2020
Required file(s) per machine
{HOST_NAME}_{DATE_OF_DATA_COLLECTION}_TRADEINNOVATION.pdf
3.3. Uploading the Collected Data
Compress (ZIP format) all the files generated by TxnUsage under the directory for each environment.
The Zip file should be sent to 7/8ths through 7/8ths Data Room.
4
4. Collected Data
4.1. Output Files
The Audit Report will be exported in the end of the Data Collection Process. This PDF file can be found in
the directory for each environment and will be named uniquely as:
{HOST_NAME}_{DATE_OF_DATA_COLLECTION}_TRADEINNOVATION.pdf
o Example) dbSrv_31-08-2020_TRADEINNOVATION.pdf
Figure 1- Audit Report Sample
Figure 2- Audit Report Sample