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-2010 UNIDO | 
