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

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
10 26-Nov-2021 10:22 1 KB jmyers to previous LOAD DATA FLDR ==> LOAD DATA FLDR(System_Preference)
9 26-Nov-2021 10:22 1 KB jmyers to previous | to last EXTRCT DATA FLDR ==> EXTRCT DATA FLDR(System_Preference)
8 26-Nov-2021 10:22 1 KB jmyers to previous | to last ATTACHMENTS FLDR ==> ATTACHMENTS FLDR(System_Preference)
7 26-Nov-2021 10:22 1 KB RForbes to previous | to last
6 26-Nov-2021 10:22 1 KB JEscott to previous | to last
5 26-Nov-2021 10:22 1 KB JEscott to previous | to last
4 26-Nov-2021 10:22 1 KB JEscott to previous | to last
3 26-Nov-2021 10:22 1 KB JEscott to previous | to last
2 26-Nov-2021 10:22 811 bytes JEscott to previous | to last
1 26-Nov-2021 10:22 813 bytes JEscott to last

Page References

Incoming links Outgoing links
XMFN
XMFN

Version management

Difference between version and

At line 5 changed one line
The XMFN function is used to extract functions from the ePersonality database.
The XMFN function is used to extract functions from the Personality database.
At line 7 changed 4 lines
􀁘 Data Access Objects (create user, create date, change user, change date)
􀁘 View Details
􀁘 Where Clauses
􀁘 List of Values Functions
*Data Access Objects (create user, create date, change user, change date)
*View Details
*Where Clauses
*List of Values Functions (LOVs)
At line 13 added 9 lines
Before the XMFN can be run there are [site preferences|SYSTEM PREFERENCE] that must be defined. Within the [IMST] screen, the administrator must define where the Extract and Load files are located and where the load functions are to write the exception files to. These locations are used by the functions to create and retrieve information. The customer can modify these values to represent any directory on their system.
The extract directory is defined using the [EXTRCT DATA FLDR|EXTRCT DATA FLDR(System_Preference)] preference. The load directory is defined using the [LOAD DATA FLDR|LOAD DATA FLDR(System_Preference)] preference. The [ATTACHMENTS FLDR|ATTACHMENTS FLDR(System_Preference)] must be specified so the load functions know where to write the report exceptions log to.
Once the XMFN function has been run, it will have created an .xml and .data file, it is suggested that the user reviews the .xml file to ensure the correct data was extracted.
The user will then load this data file into the receiving database via the [LMDATA] process.
At line 13 changed one line
!!Report Parameters
!!Report Parameters & Filters
At line 15 changed one line
||Report Parameters|
||Report Parameters||
At line 17 changed 3 lines
|Format| Binary or XML. XML is available so you can view the data first before writing the
data to a .data file to be used by the LMDATA. When you want to write the data to
a file for loading purposes, the Binary option should be selected.
|Format| Binary or XML. XML is available so you can view the data\\ first before writing the data to a .data file to be used by \\the LMDATA. When you want to write the data to a file\\ for loading purposes, the Binary option should be selected.
At line 29 added 4 lines
||Report Filters||
At line 34 added 5 lines
----
![Notes|Edit:Internal.XMFN]
[{InsertPage page='Internal.XMFN' default='Click to create a new notes page'}]
This page (revision-10) was last changed on 26-Nov-2021 10:22 by jmyersTop