This page (revision-5) was last changed on 26-Nov-2021 10:22 by JEscott

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
5 26-Nov-2021 10:22 4 KB JEscott to previous
4 26-Nov-2021 10:22 4 KB JEscott to previous | to last
3 26-Nov-2021 10:22 4 KB JAiken to previous | to last
2 26-Nov-2021 10:22 4 KB JEscott to previous | to last
1 26-Nov-2021 10:22 3 KB JEscott to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 3 added 7 lines
The Conversion Application is made up of several forms, reports, functions and procedures. All of these programs have been created with the same development tools as the software application. As a result, the Conversion application has a similar look and feel as the software. All the functions to import, manipulate and convert the data from comma-delimited flat files can be performed from within this application.
One of the other effects that this has on converting data into the software application is that the conversion programs cannot read the data directly from flat files stored on the server. All records that are to be loaded into the software data structure must first be loaded into interface tables within the Oracle database itself, before being moved to the tables owned by P2K. Once the information has been loaded in these interface tables it can be edited or reported with the supplied screens and reports. Both the screens and report can be accessed from within the menu structure designed into the Conversion application.
Loading the software conversion data into the interface tables gives us the ability to verify that the loaded data is correct and in the format that the conversion programs require, prior to altering the [{$applicationname}] tables. This also allows us to perform any additional translation of the data that could not be performed prior to loading the information into the tables. Several third party applications are capable of reading, manipulating and storing the altered data back into Oracle tables. The use of SQL scripts to perform the same translation of the data is also available, and can be done with the utilities provided by Oracle.