480 likes | 683 Views
EIS Bridge Tool and Staging Tables. September 1, 2009 Instructor: Way Poteat. Slide: 1. Agenda. Downloading the Bridge Tool Downloading the Staging Tables Mapping NIF 3.0 to Staging Tables The Exchange Header Table Converting Staging Tables to XML
E N D
EIS Bridge Tool andStaging Tables September 1, 2009 Instructor: Way Poteat Slide: 1
Agenda • Downloading the Bridge Tool • Downloading the Staging Tables • Mapping NIF 3.0 to Staging Tables • The Exchange Header Table • Converting Staging Tables to XML • Importing an EIS CERS XML into the Staging Tables Slide: 2
EIS Gateway (HOME) Slide: 3
EIS Gateway (HOME…) Slide: 4
EIS Gateway (TOOLS) Slide: 5
EIS Gateway (Download Bridge) Slide: 6
EIS Gateway (Download Bridge…) Slide: 7
EIS Gateway (User’s Desktop) Slide: 8
EIS Gateway (Bridge Tool) Slide: 9
EIS Gateway (Bridge Tool) Slide: 10
EIS Gateway (Bridge Tool) Slide: 11
EIS Gateway (Bridge Tool) Slide: 12
EIS Gateway (Bridge Tool) Slide: 13
Mapping NIF 3.0 to the Staging Tables Slide: 14
Appendix 3 NIF CONVERSION and Mapping • Provides mapping from NIF 3.0 to CERs • Provides mapping from CERs to NIF 3.0 • You are responsible for loading your data into the Staging Tables Slide: 15
Important to Remember • You must check for the completion of required fields in your staging tables which were not part of the NIF 3.0 structure. These data elements must be completed separately prior to conversion to an XML file to pass QA. Slide: 16
The Header Table Slide: 17
EIS Gateway (MS Access Tables) Slide: 18
EIS Gateway (MS Access Tables) Slide: 19
EIS Gateway (Bridge Tool) Slide: 20
EIS Gateway (Bridge Tool) Slide: 21
EIS Gateway (Bridge Tool) Slide: 22
EIS Gateway (Bridge Tool) Slide: 23
EIS Gateway (Bridge Tool) Slide: 24
EIS Gateway (Bridge Tool) Slide: 25
EIS Gateway (Bridge Tool) Slide: 26
EIS Gateway (Exchange Network) Slide: 27
EIS Gateway (Exchange Network) Slide: 28
EIS Gateway (Exchange Network) Slide: 29
EIS Gateway (Exchange Network) Slide: 30
EIS Gateway (Exchange Network) Slide: 31
EIS Gateway (Exchange Network) Slide: 32
Importing an EIS CERS XML file intothe Staging Tables Slide: 33
EIS Gateway Slide: 34
EIS Gateway Slide: 35
EIS Gateway Slide: 36
EIS Gateway Slide: 37
EIS Gateway Slide: 38
EIS Gateway Slide: 39
EIS Gateway Slide: 40
EIS Gateway Slide: 41
EIS Gateway Slide: 42
EIS Gateway Slide: 43
EIS Gateway Slide: 44
EIS Gateway Slide: 45
EIS Gateway Slide: 46
EIS Gateway Slide: 47
EIS Bridge Tool andStaging Tables • For Questions and/or Comments about the Bridge Tool please use the “Create a Support Request” feature within the EIS Gateway Slide: 48