slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
External Trade Statistical System PowerPoint Presentation
Download Presentation
External Trade Statistical System

Loading in 2 Seconds...

play fullscreen
1 / 23

External Trade Statistical System - PowerPoint PPT Presentation


  • 154 Views
  • Uploaded on

External Trade Statistical System. UNECA – Addis Ababa, October 2011. Eurotrace has been substantially revised and improved. Three separate applications that work together. Data Processing Software for External Trade Statistics. Comext Standalone Data Browser. Eurotrace DBMS.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'External Trade Statistical System' - cybele


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

External Trade Statistical System

UNECA – Addis Ababa, October 2011

data processing software for external trade statistics

Eurotrace has been substantially revised and improved.

Three separate applications that work together.

Data Processing Software for External Trade Statistics

Comext Standalone Data Browser

Eurotrace DBMS

Eurotrace Data Editor

computing technology
Computing Technology
  • Built with Microsoft Visual Basic and C++ Programming Languages
  • Supports Data Access Objects (DAO) and Open database connectivity Standards (OBDC)
  • Pentium II 450Mhz
  • 256MB RAM
  • Windows 95, 98, NT, 2000, Me or XP Operating system
  • A 3 part system of Interacting programs, offering an extensive and complete range of data processing tools to meet all External Trade Statistics data processing needs.
  • The software is free and can be downloaded from:

http://circa.europa.eu/irc/dsis/eurotracegroup/info/data/website/index_en.htm

slide4

External Trade Statistics: Implementing system

with

Comext/Eurotrace Package

Data

Sources

Mostly CUSTOMS

DECLARATION

External Trade Database

RAW DATA

COMEXT

Stand-Alone

Browser

External Trade

Database

Definition

Estimation

Indices

Enterprise

Data

Requests

UN

IMF

Country Table

and Publication

EUROSTAT

MedComext

Data Integration

Procedure

slide5

Eurotrace Actors

How to design a Domain ?

4. Target of Data dissemination

Statistical Office

Statistics Users

2. Provider of Data

Trade Statistics data Supplier,

Customs,

Statistical Office

Data

Editor

1. Define External Trade Statistical Database

Expert of Nomenclatures and/or

Trade Information System

3. Validity Check and Quality Control

Data Coders,

Data Controller

Derived Data

Source Dataset

Classification

Plan

slide6

Definition

Classification Plan

Dictionary

Dictionary

Dictionary

Eurotrace DOMAIN

slide7

GeoNom.

CTY

Activity

BEC

SITC

HS

Enterprise

Managing Nomenclatures and Relations

Classification Plan

slide8

Source Data

Dataset Source

Classification Plan

Dictionary

Dictionary

Dictionary

Eurotrace DOMAIN

Definition

slide9

Define Data Structure

  • Define the data set structure using Dictionaries

Format: Asycuda,

Eurotrace Dos,

SAD …

2. Source Data Structure

Define the file structure to be integrated within Eurotrace

Validation

3. Define Data Integration Algorithm

Importing data by using the Wizard

Data Entry/Correction

Direct Validation

Source Dataset

slide10

1. Database Extraction

a. Single File

b. Record Locking Security

c. Extraction Criteria

2. Data Editor

a. Appending New Records

b. Modify Records

c. “Undo” function

d. Header – Detail - Footer

e. Validation “On The Fly”

3. Detecting Errors

a. Highlighted in red

b. Type of Error occurred

7. Database Update

a. File sent to administrator in order to update the DB

b. Errors could be corrected one by one (No lock in process)

c. Database Records Unlocked

4. Form Designer

a. Customize the Customs

Declaration Form

b.Hide/Mask fields

c. Move Boxes ( from/to body to/from header/footer part)

5. Code List Selector

a. Hierarchy selection

b. Code Validation

6. Record Navigator

a. Select a specific record directly

b. View data in Grid format

Data Entry/Data Correction

slide11

Data Monitoring

  • Historical back-up
  • Error Correction Wizard
  • Checking of Error Type
  • List of valid codes (dictionary)

Dataset Management

slide12

Upgrade

Upgrade

Classification Plan

Dictionary

Dictionary

Dictionary

Derived

Dataset

Derived

Dataset

Source Data

Eurotrace DOMAIN

Dataset Source

Definition

slide13

2. Simple Interface to Upgrade Derived DS

a. Selecting of Period to be updated

b. Global control on Data Maintenance

1. Define Algorithm for Derived Dataset

a. Parameters based on Data Source

b. Codes Filter & Correlation Tables

Derived Dataset

Upgrade

slide14

Classification Plan

Dictionary

Dictionary

Dictionary

Dissemination/Analysis

Source Data

Eurotrace DOMAIN

Dataset Source

Upgrade

Upgrade

Definition

Derived

Dataset

Derived

Dataset

slide15

COMEXT Stand-Alone

A common Interface for Data Dissemination

slide16

Criteria Selection and Data Browsing

COMEXT

Stand-Alone

Comext Plan

format of extraction

COMEXT

Stand-Alone

Format of extraction

TYPE

.txt

.dmp

.dta

.xls

.csv

Spreadsheet format

Excel format

slide19

Classification Plan

Dictionary

Dictionary

Dictionary

Source Data

Eurotrace DOMAIN

Dataset Source

Upgrade

Upgrade

Definition

Eurotrace Local

Administrator Black Box

or

Installation mission

Parameters

Derived

Dataset

Derived

Dataset

Dissemination/Analysis

advantages of eurotrace
Advantages of Eurotrace
  • Flexibility
    • Full control of statistical data
    • Fully definable control parameters
  • Save Time
    • Reduce data validation time
    • Track down and easily correct errors
  • Helps Cooperation between partner countries
    • Make data compatible with EU standards
    • Ensure compatibility with partner countries
    • Enables easy transmission of data
multi lingual
Multi-lingual
  • EUROTRACE is able to store codes and labels in different languages that are accessible throughout the application. Data can be displayed in English, French, German, Italian, Spanish, Portuguese, Greek, Dutch, Swedish, Danish, Finnish and Luxembourgish.
  • The language of the interface is set by the user to either French or English.