|
Addressing
extensive demand for data exchange between different enterprise
applications expressed by entrepreneurs
in Colombia, GOLEM IMS GMBH introduced
add-on module for Pharos -
Business Navigator: Advanced
Enterprise Data Export - Import. The module allows effective
data
transfer between Pharos and other software which
may be used in enterprises.
The objectives of the module
development were as follows:
-
Enabling export of Pharos data into
typical other applications
-
Providing options of importing data into Pharos from
third party software (accounting, production management, quality,
managerial scenarios of business development, etc)
-
Making the definition process of export - import as easy
and simple as possible for the type of operations
-
Optional saving of the results of such process in macro
definitions providing for automatic running of complex export and import
operations and its combinations
-
Facilitating easy business decision
scenario developments (e.g. bring real database into Excel, modify data
accordingly assumptions for the future, import future scenario into
Pharos)
The module is powerful utility with advanced features and support of
importing from multiple data formats as follows:
·
XML
·
HTML
·
MS Access database
·
Paradox
·
Dbase
·
Text
·
Excel
·
Lotus
·
Quattro Pro
The data export can be made in much wider selection of
formats. Both data import and export can be made initially in manual
mode allowing defining schemes of import/export for particular tables.
Several such schemes can be defined into one combination allowing
automatic run of the import or export procedures for several databases
or tables by using predefined schemes of import/export. The schemes
identify data sources and data destinations and include optional
intermediate calculations on data being processed.
The objective of import is defined as selecting source
data which are necessary for Pharos, processing them by particular
formulas and putting the results into the appropriate Pharos tables.
Necessary data can be stored in different databases and files, in
various formats and on different PC in a LAN providing for the following
options:
-
Source data are in one file which contains compete
information for preparing data for all Pharos tables.
-
Source data are in several files and should be
extracted, processed and saved into particular Pharos tables.
-
One Pharos table can be prepared by using several
source files or databases.
The import / export procedure consists of two main
options:
-
Defining the import/export.
-
Running the import/export.
The objective of the first option is to define the
relations between the source and destination data sets and calculations
which are to be made when data are taken from the source data set and
finally putting into the destination Pharos tables.
There are the following components of the import process:
-
Scheme
-
Combination
of schemes
The scheme consists of the specifications defining processing
of the source data accordingly to formulas introduced into the Formula
Editor for particular source data set and the way the resulting data are
brought into the Pharos tables (append, update, etc).
Scheme combination allows grouping of several schemes for
their automatic runs. It defines several source data files being
processed one by one and can be run manually or automatically. The
result of the running of the scheme combination should be aimed at
filling the Pharos table in with maximum available data.
The objective of the schemes and scheme combinations is
to get possibility to run routine import and export operations easily
and in automated mode after all initial definitions and checking of the
runs.
The module provides for solving various data interchange
issues while working with Pharos and Produce Plus as well as generic
tool for identification of virtually any necessary data export - import
operation which can be foreseen. Some database skills may be necessary
for implementing complex data exchange solutions.
Further detail of implementation can be found
here >>>
Contact
PHAROS, BEST, FIT,
MCCT software, copyright © 1994-2008 UNIDO |
