Insert
This topic lists all the menu commands available in the Insert menu.
Adds an XML schema or instance file to the mapping. If you select an XML file without a schema reference, MapForce can generate a matching XML schema. If you select an XML schema file, you are prompted to include an XML instance file which supplies the data for preview. You can also add an XML/XSD file via the toolbar command.
|
Adds a database component. See Databases. You can also add a database component via the toolbar command. In MapForce Enterprise Edition, you can also add NoSQL databases as components. For more information, see NoSQL Databases.
|
Adds an EDI document. See EDI. You can also add an EDI component via the toolbar command.
|
Adds a flat file document such as CSV or a fixed-length text file. For details, see CSV and Text Files. You can also add a text file via the toolbar command. MapForce Enterprise Edition also allows you to process text files with FlexText. See MapForce FlexText.
|
Adds a call to a Web service. See Web Services. You can also add a Web service via the toolbar button.
|
Adds a Microsoft Excel 2007+ (.xlsx) file. See Microsoft OOXML Excel 2007+. If you do not have Excel 2007+ installed on your machine, you can still map to or from Excel 2007+ files. In this case, you cannot preview the result in the Output pane, but you can still save the result. You can also add an Excel file via the toolbar command.
|
Adds an XBRL instance or taxonomy document. For details, see XBRL. You can also add an XBRL component via the toolbar command.
|
Adds a JSON schema or file. For details, see JSON. You can also add a JSON component via the toolbar command.
|
Adds a binary file encoded in Protocol Buffers format. For more information, see Protocol Buffers. You can also add a file in Protocol Buffers format via the toolbar command.
|
Simple-Input components can be used as input parameters that are relevant to the entire mapping or only in the context of user-defined functions. For more information, see Simple Input and Parameters in UDFs. You can also insert a Simple-Input component using the toolbar command.
|
Simple-Output components can be used as output components in mappings and as output parameters of user-defined functions. For more information, see Simple Output and Parameters in UDFs. You can also insert a Simple-Output component using the toolbar command.
|
Inserts a constant which supplies fixed data to an input connector. You can select the following types of data: String, Number and All other. You can also insert a constant using the toolbar command.
|
Inserts a variable, which is equivalent to a regular (non-inline) user-defined function. A variable is a special type of components used to store an intermediate mapping result for further processing. You can also add a variable using the toolbar command.
|
The Join component allows you to join data in SQL and non-SQL modes. You can also add a Join component using the toolbar command. For details, see Joining Data.
|
Inserts a component which allows you to sort nodes (see Sort Nodes/Rows). You can also add a Sort component using the toolbar command.
|
Inserts a Filter component that can filter data from any other component structure supported by MapForce, including databases. For more information, see Filters and Conditions. You can also add a filter using the toolbar command.
|
Inserts a component which allows you to filter database data conditionally. For more information, see SQL/NoSQL-WHERE/ORDER Component. You can also access the SQL/NoSQL-WHERE/ORDER component via the toolbar command.
|
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 (e.g., month numbers to month names). For more information, see Value-Maps. You can also insert a Value-Map using the toolbar command.
|
Inserts an If-Else Condition that is suitable for scenarios where you need to process a simple value conditionally. For more information, see Filters and Conditions. You can also add an If-Else Condition using the toolbar command.
|
The exception component allows you to interrupt a mapping process when a specific condition is met. You can also add an Exception component using the toolbar command. In MapForce Enterprise Edition, this component also allows you to define Fault messages in WSDL mapping projects. For details, see Web Service Faults.For more information about Exception components, see Exceptions.
|
This menu command allows you to insert sticky-note-style comments as free-standing components. For details, see Comments. You can also add a comment by clicking the toolbar command.
|