XML Schema / File
Adds to the mapping an XML schema or instance file. If you select an XML file which references a schema, no additional information is required for the mapping. If you select an XML file without a schema reference, you are prompted to generate a matching XML schema automatically (see Generating an XML Schema ). If you select an XML schema file, you are prompted to include optionally an XML instance file which supplies the data for preview.
Adds to the mapping a database as source or target component (see Databases and MapForce ).
Adds to the mapping an EDI document which can be used as source or target component (see EDI ).
Adds to the mapping a flat file document, such as CSV or a fixed-length text file. Both types of file can be used as source and target components. Additionally, if you want to process text files with a structure other than CSV or fixed-length, you can use FlexText (see MapForce FlexText ).
Web Service Function
Adds to the mapping a call to a Web service (see Calling Web services ).
Excel 2007+ File
Adds to the mapping a Microsoft Excel 2007+ (.xlsx) file (see Microsoft OOXML Excel 2007+ ). If you don't have Excel 2007 or later, you can still map to or from Excel 2007+ files. In this case, you cannot preview the result in the Output tab, but you can still save it, by clicking Save Output File on the Output menu.
Adds to the mapping an XBRL instance or taxonomy document (see Adding XBRL Files as Mapping Components ).
Adds to the mapping a JSON schema or file (see Adding JSON Files as Mapping Components ).
Protocol Buffers File
Adds a binary file encoded in Protocol Buffers format to the mapping, see Protocol Buffers.
When the mapping window displays a mapping, this command adds an input component to the mapping (see Supplying Parameters to the Mapping ). When the mapping window displays a user-defined function, this command adds an input component to the user-defined function (see Parameters in User-Defined Functions ).
When the mapping window displays a mapping, this command adds an output component to the mapping (see Returning String Values from a Mapping ). When the mapping window displays a user-defined function, this command adds an output component to the user-defined function (see Parameters in User-Defined Functions ).
Inserts a constant which supplies fixed data to an input connector. The data is entered into a dialog box when creating the component. You can select the following types of data: String, Number and All other.
Inserts an Intermediate Variable which is equivalent to a regular (non-inline) user-defined function. Variables are structural components, without instance files, and are used to simplify the mapping process (see Intermediate variables ).
Inserts a component which allows you to sort nodes (see Sort Nodes/Rows ).
Inserts a component that uses two input and output parameters: node/row and bool, and on-true, on-false. If the Boolean is true, then the value of the node/row parameter is forwarded to the on-true parameter. If the Boolean is false, then the complement value is passed on to the on-false parameter. For more information, see Filters and Conditions.
Inserts a component which allows you to filter database data conditionally (see SQL WHERE / ORDER Component ).
Inserts a component that transforms an input value to an output value using a lookup table. This is useful when you need to map a set of values to another set of values (for example, month numbers to month names). For more information, see Using Value-Maps.
Inserts a component of type "If-Else Condition" (see Filters and Conditions).
The exception component allows you to interrupt a mapping process when a specific condition is met, or define Fault messages when using WSDL mapping projects. Please see Adding Exceptions and Web Service Faultsfor more information.