Mapper compiler

• US 7,237,207 B2
• Filed: 12/15/2003
• Issued: 06/26/2007
• Est. Priority Date: 12/15/2003
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Bhaskara, Udaya Kumar, Panditharadhya, Nagalinga Durga Prasad Sripathi, Dallard, John David
• Primary Examiner(s): Nguyen; Cao (Kevin)
• Application Number:
  US10/736,406
• Publication Number:
  US 20050132282A1
• Time in Patent Office: 1,289 Days
• Field of Search: 715/805, 715/763, 715/810, 715/746, 715/853, 715/823, 715/765, 709/223, 709/224, 717/109, 717/125
• US Class Current: 715/805
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
• CPC Class Codes: G06F 40/154 Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets

Abstract

Mapping between a source object and a destination or target object uses techniques and functoids that provide an auto-linking feature in which mappings are automatically provided based solely on source and target field names, or, ignoring field names, field locations within hierarchy. Functoids provide support for callout to programming artifacts, such as custom programming logic embedded in .NET assemblies or custom XSLT, and table-looping to generate and map data into a target document even though that data did not exist in the map input.

Claims

1. A mapping tool graphical user interface recorded on a machine-readable storage medium having computer-executable instructions, comprising:

a source screen region adapted to display a graphical representation of a source object comprising a plurality of source nodes;

a target screen region adapted to display a graphical representation of a target object comprising a plurality of target nodes; and

a mapping screen region adapted to allow a user to create a mapping between the graphical representation of the source object and the graphical representation of the target object using at least one of (1) an auto-linking indicia, (2) a function object adapted to call out to a programming artifact, and (3) a function object adapted to provide table looping such that data is generated and mapped into a target document.

2. The user interface of claim 1, wherein the source screen region includes a source tree structure having a hierarchical representation of the source nodes, and the target screen region includes a target tree structure having a hierarchical representation of the target nodes, wherein the auto-linking indicia provides an association between one of the source nodes and one of the target nodes, and mappings between source and target nodes are automatically provided between the source and target hierarchies.

3. The user interface of claim 2, wherein after the auto-linking indicia is provided between one of the source nodes and one of the target nodes, automatic linking between the source and target nodes is performed.

4. The user interface of claim 2, wherein the mappings between source and target nodes are based on source and target node names.

5. The user interface of claim 2, wherein the mappings between source and target nodes are based on their locations within the respective hierarchies.

6. The user interface of claim 1, wherein the programming artifact comprises custom programming logic.

7. The user interface of claim 1, wherein the programming artifact comprises custom Extensible Stylesheet Language Transformations (XSLT).

8. The user interface of claim 7, wherein the custom XSLT is supported in a parameterized call template.

9. The user interface of claim 7, wherein the custom XSLT is supported in a raw form.

10. The user interface of claim 1, wherein the table looping is based on a populated grid.

11. The user interface of claim 1, wherein the auto-linking indicia comprises a line in the mapping screen region between one of the source nodes and one of the target nodes.

12. The user interface of claim 1, wherein one of the source and target objects is one of a schema, a spreadsheet, a document, and a database.

13. In a mapping tool graphical user interface recorded on a machine-readable storage medium having computer-executable instructions, a method of creating a mapping, comprising:

displaying a graphical representation of a source object in a source screen region, the source object comprising a plurality of source nodes;

displaying a graphical representation of a target object in a target screen region, the target object comprising a plurality of target nodes;

creating a mapping between the graphical representation of the source object and the graphical representation of the target object in a mapping screen region by selecting and using at least one of (1) an auto-linking indicia, (2) a function object adapted to call out to a programming artifact, and (3) a function object adapted to provide table looping such that data is generated and mapped into a target document;

and displaying the mapping in the mapping screen region.

14. The method of claim 13, further comprising selecting one of the source nodes and one of the target nodes, wherein the source screen region includes a source tree structure having a hierarchical representation of the source nodes, and the target screen region includes a target tree structure having a hierarchical representation of the target nodes, wherein the auto-linking indicia provides an association between one of the source nodes and one of the target nodes, and mappings between source and target nodes are automatically provided between the source and target hierarchies associated with the selected source node and selected target node.

15. The method of claim 14, further comprising automatic linking between the source and target nodes after receiving the auto-linking indicia between the selected source node and the selected target node.

16. The method of claim 14, wherein the mappings between source and target nodes are based on source and target node names.

17. The method of claim 14, wherein the mappings between source and target nodes are based on their locations within the respective hierarchies.

18. The method of claim 13, wherein the programming artifact comprises custom programming logic.

19. The method of claim 13, wherein the programming artifact comprises custom Extensible Stylesheet Language Transformations (XSLT).

20. The method of claim 19, wherein the custom XSLT is supported in a parameterized call template.

21. The method of claim 19, wherein the custom XSLT is supported in a raw form.

22. The method of claim 13, wherein the table looping is based on a populated grid.

23. The method of claim 13, wherein the auto-linking indicia comprises a line in the mapping screen region between one of the source nodes and one of the target nodes.

24. The method of claim 13, wherein one of the source and target objects is one of a schema, a spreadsheet, a document, and a database.