Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
Added: | ||||||||
> > |
Define File/Field MapThis page describes how to map incoming data to Appx files/Fields.Overview:This option allows you to maintain existing File/Field maps. You can also use this to add new mappings, but it's usually easier to define a new map using Define File/Field map from Source File.UsageWhen you click 'Define File/Field Map', you will see a display similar to the following: The usual options for adding/changing/deleting are available. From here you can maintain the Component Files, Component Fields, Ignorable Segments and Replaceable Segments.Component FilesThe 'Component Files' button allows you to specify what identifiers indicate the beginning of a new record in the source file: You can also click the 'Populate Field Map' button to populate the 'Component Fields' file with all the fields in the currently selected file. This might be easier than manually entering the fields later. However, if the Appx file has many fields and you are only importing a few of them, it might be easier to manage if you just manually add the fields.Component FieldsThe 'Component Fields' button allows you to specify what fields the imported data should be moved to: The 'Details' button will allow you to change the specifics of a field mapping: The valid source types are:
Ignorable SegmentsIgnorable Segments are segments we want removed from the identifiers. For example, most XML files have a top level segment, such as 'ProspectData', and all identifiers are subordinate to that (ie, /ProspectData/Prospect No, /ProspectData/ProspectName, etc). To simplify our mapping, we might want the 'ProspectData' portion removed so that we have /ProspectNo, /ProspectName, etc. In that case, we would enter 'ProspectData' as one of the Ignorable Segments.Replaceable SegmentsReplaceable Segments are used for a very particular situation. Consider the following XML fragment:<j2:feature name="SourceName"> <j2:value>136</j2:value> </j2:feature> <j2:feature name="FileSystemProperties"> <j2:features> <j2:feature name="Path"> <j2:value>/usr/local/appx/archive/110928/136</j2:value> </j2:feature> <j2:feature name="LastModified"> <j2:value>2011-09-28T20:19:52-04:00</j2:value> </j2:feature> </j2:features>
Notice that the Segments all have the same name (j2:feature), and the identifier is really encoded in the attribute (name="..."). In this case, we can use the Replaceable Segments to move the attribute to the segment, which will allow us to map the segment to an Appx field:
Now our segment names will become "SourceName", "FileSystemProperties", "Path", "LastModified" instead of "j2:feature"
Comments:Read what other users have said about this page or add your own comments.-- JeanNeron - 2013-10-01 | |||||||
| ||||||||
Added: | ||||||||
> > |
|
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
Added: | ||||||||
> > |
|