Systems and methods for mapping a value to a new domain

• US 9,864,762 B2
• Filed: 01/27/2012
• Issued: 01/09/2018
• Est. Priority Date: 06/23/2011
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Koosel, Marko, Schneider, Donovan, Tang, Michael, Park, David
• Primary Examiner(s): Singh, Amresh
• Application Number:
  US13/360,209
• Publication Number:
  US 20120330960A1
• Time in Patent Office: 2,174 Days
• Field of Search: 707603
• CPC Class Codes: G06F 16/211 Schema design and management

Abstract

Source values are mapped to new user-defined categories. The new user-defined categories are stored in a new user-defined field. In an embodiment, a user-selection of an existing field is received. Based on a data type of the existing field, a specific mapping interface is displayed. The interface guides the user through specification of the new field and categories, and identification of the source values to map to the new categories.

Claims

1. A method comprising:

receiving, from a user, a selection of an existing report field from a plurality of report fields displayed in an existing report table, each of the report fields in the existing report table storing a plurality of source values, the plurality of source values for each of the report fields being associated with a record of a plurality of records in the existing report table;

prompting the user to input a name that will be used to identify a new user-created report field, wherein the new user-created report field will store a plurality of user-created target categories in the existing report table;

determining a data type of the plurality of source values stored in the selected report field;

providing a data type-specific mapping interface that is displayed to the user, the provided data type-specific mapping interface being specific to the determined data type of the plurality of source values;

receiving, from the user via the data type-specific mapping interface, a selection identifying a subset of the source values for mapping to a user-created target category of the plurality of user-created target categories stored in the new user-created report field;

prompting, via the data type-specific mapping interface, the user to input a name used to identify the user-created target category;

mapping each source value of the subset of source values to the user-created target category using the data type-specific mapping interface; and

updating the existing report table to include the new user-created report field, where each record of the plurality of records associated with the subset of the source values is also associated with the user-created target category.

2. The method of claim 1 wherein when the data type of the report field is determined to be numerical, the data type-specific mapping interface comprises a first text box, and a second text box,

wherein the first text box permits the user to input a numerical limit, the second text box permits the user to create the name of the user-created target category, and each source value of the subset of source values is to be one of greater than the numerical limit, or less than or equal to the numerical limit.

3. The method of claim 1 wherein when the data type of the report field is determined to be picklist, the data type-specific mapping interface comprises:

a listing of the plurality of source values; and

the method further includes the step of

receiving a user-selection of the subset of source values from the listing that is to be mapped to the user-created target category.

4. The method of claim 1 wherein when the data type of the report field is determined to be text, the data type-specific mapping interface comprises:

a text box for the user to input at least one keyword, the method further comprising;

based on the at least one keyword, searching the plurality of source values;

returning a search result responsive to the at least one keyword; and

receiving a user-selection of the subset of source values from the search result that is to be mapped to the user-created target category.

5. The method of claim 1 comprising:

after the mapping each of the plurality of source values to the one or more user-created target categories, updating the report table; and

displaying the updated report table, the updated reported table comprising a first column and a second column, the first column comprises the report field and the plurality of source values stored in the report field, and the second column comprises the user-created report field and the plurality of user-created target categories stored in the user-created report field,

wherein before the updating a report table, the report table does not comprise the second column.

6. The method of claim 5 wherein the displaying the updated report table comprises:

generating a SQL statement at runtime for the second column.

7. A non-transitory machine-readable medium carrying one or more sequences of instructions, which instructions, when executed by one or more processors, cause the one or more processors to carry out the steps of:

receiving, from a user, a selection of an existing report field from a plurality of report fields displayed in an existing report table, each of the report fields in the existing report table storing a plurality of source values, the plurality of source values for each of the report fields being associated with a record of a plurality of records in the existing report table;

prompting the user to input a name that will be used to identify a new user-created report field, wherein the new user-created report field will store a plurality of user-created target categories in the existing report table;

determining a data type of the plurality of source values stored in the selected report field;

providing a data type-specific mapping interface that is displayed to the user, the provided data type-specific mapping interface being specific to the determined data type of the plurality of source values;

receiving, from the user via the data type-specific mapping interface, a selection identifying a subset of the source values for mapping to a user-created target category of the plurality of user-created target categories stored in the new user-created report field;

prompting, via the data type-specific mapping interface, the user to input a name used to identify the user-created target category;

mapping each source value of the subset of source values to the user-created target category using the data type-specific mapping interface; and

updating the existing report table to include the new user-created report field, where each record of the plurality of records associated with the subset of the source values is also associated with the user-created target category.

8. The non-transitory machine-readable medium of claim 7 wherein when the data type of the report field is determined to be numerical, the data type-specific mapping interface comprises a first text box, and a second text box,

wherein the first text box permits the user to input a numerical limit, the second text box permits the user to create the name of the user-created target category, and each source value of the subset of source values is to be one of greater than the numerical limit, or less than or equal to the numerical limit.

9. The non-transitory machine-readable medium of claim 7 wherein when the data type of the report field is determined to be picklist, the data type-specific mapping interface comprises:

a listing of the plurality of source values; and

the instructions further cause the one or more processors to carry out the step of

receiving a user-selection of the subset of source values from the listing that is to be mapped to the user-created target category.

10. The non-transitory machine-readable medium of claim 7 wherein when the data type of the report field is determined to be text, the data type-specific mapping interface comprises:

a text box for the user to input at least one keyword, the instructions further causing the one or more processors to carry out the steps of;

based on the at least one keyword, searching the plurality of source values;

returning a search result responsive to the at least one keyword; and

receiving a user-selection of the subset of source values from the search result that is to be mapped to the user-created target category.

11. The non-transitory machine-readable medium of claim 7 comprising:

after the mapping each of the plurality of source values to the one or more user-created target categories, updating the report table; and

displaying the updated report table, the updated reported table comprising a first column and a second column, the first column comprises the report field and the plurality of source values stored in the report field, and the second column comprises the user-created report field and the plurality of user-created target categories stored in the user-created report field,

wherein before the updating a report table, the report table does not comprise the second column.

12. An apparatus comprising:

a processor; and

one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of;

receiving, from a user, from a user, a selection of an existing report field from a plurality of report fields displayed in an existing report table, each of the report fields in the existing report table storing a plurality of source values, the plurality of source values for each of the report fields being associated with a record of a plurality of records in the existing report table;

prompting the user to input a name that will be used to identify a new user-created report field, wherein the new user-created report field will store a plurality of user-created target categories in the existing report table;

determining a data type of the plurality of source values stored in the selected report field;

providing a data type-specific mapping interface that is displayed to the user, the provided data type-specific mapping interface being specific to the determined data type of the plurality of source values;

receiving, from the user via the data type-specific mapping interface, a selection identifying a subset of the source values for mapping to a user-created target category of the plurality of user-created target categories stored in the new user-created report field;

prompting, via the data type-specific mapping interface, the user to input a name used to identify the user-created target category;

mapping each source value of the subset of source values to the user-created target category using the data type-specific mapping interface; and

updating the existing report table to include the new user-created report field, where each record of the plurality of records associated with the subset of the source values is also associated with the user-created target category.

13. The apparatus of claim 12 wherein when the data type of the report field is determined to be numerical, the data type-specific mapping interface comprises a first text box, and a second text box,

wherein the first text box permits the user to input a numerical limit, the second text box permits the user to create the name of the user-created target category, and each source value of the subset of source values is to be one of greater than the numerical limit, or less than or equal to the numerical limit.

14. The apparatus of claim 12 wherein when the data type of the report field is determined to be picklist, the data type-specific mapping interface comprises:

a listing of the plurality of source values; and

the instructions further cause the one or more processors to carry out the step of

receiving a user-selection of the subset of source values from the listing that is to be mapped to the user-created target category.

15. The apparatus of claim 12 wherein when the data type of the report field is determined to be text, the data type-specific mapping interface comprises:

a text box for the user to input at least one keyword, the instructions further causing the one or more processors to carry out the steps of;

based on the at least one keyword, searching the plurality of source values;

returning a search result responsive to the at least one keyword; and

receiving a user-selection of the subset of source values from the search result that is to be mapped to the user-created target category.

16. The apparatus of claim 12 comprising:

after the mapping each of the plurality of source values to the one or more user-created target categories, updating the report table; and

displaying the updated report table, the updated reported table comprising a first column and a second column, the first column comprises the report field and the plurality of source values stored in the report field, and the second column comprises the user-created report field and the plurality of user-created target categories stored in the user-created report field,

wherein before the updating a report table, the report table does not comprise the second column.

17. A method for transmitting code comprising:

transmitting code to receive, from a user, a selection of an existing report field from a plurality of report fields displayed in an existing report table, each of the report fields in the existing report table storing a plurality of source values, the plurality of source values for each of the report fields being associated with a record of a plurality of records in the existing report table;

transmitting code to prompt the user to input a name that will be used to identify a new user-created report field, wherein the new user-created report field will store a plurality of user-created target categories in the existing report table;

transmitting code to determining a data type of the plurality of source values stored in the selected report field;

transmitting code to provide a data type-specific mapping interface that is displayed to the user, the provided data type-specific mapping interface being specific to the determined data type of the plurality of source values;

transmitting code to receive, from the user via the data type-specific mapping interface, a selection identifying a subset of the source values for mapping to a user-created target category of the plurality of user-created target categories stored in the new user-created report field;

transmitting code to prompt, via the data type-specific mapping interface, the user to input a name used to identify the user-created target category;

transmitting code to map, each source value of the subset of source values to the user-created target category using the data type-specific mapping interface; and

transmitting code to update the existing report table to include the new user-created report field, where each record of the plurality of records associated with the subset of the source values is also associated with the user-created target category.

18. The method of claim 17 wherein when the data type of the report field is determined to be numerical, the data type-specific mapping interface comprises a first text box, and a second text box,

wherein the first text box permits the user to input a numerical limit, the second text box permits the user to create the name of the user-created target category, and each source value of the subset of source values is to be one of greater than the numerical limit, or less than or equal to the numerical limit.

19. The method of claim 17 wherein when the data type of the report field is determined to be picklist, the data type-specific mapping interface comprises:

a listing of the plurality of source values; and

the method further comprises

transmitting code to receive a user-selection of the subset of source values from the listing that is to be mapped to the user-created target category.

20. The method of claim 17 wherein when the data type of the report field is determined to be text, the data type-specific mapping interface comprises:

a text box for the user to input at least one keyword, the method further comprising;

transmitting code to, based on the at least one keyword, search the plurality of source values;

transmitting code to return a search result responsive to the at least one keyword; and

transmitting code to receive a user-selection of the subset of source values from the search result that is to be mapped to the user-created target category.

21. The method of claim 17 comprising:

transmitting code to after each of the plurality of source values is mapped to the one or more user-created target categories, update the report table; and

transmitting code to display the updated report table, the updated reported table comprising a first column and a second column, the first column comprises the report field and the plurality of source values stored in the report field, and the second column comprises the user-created report field and the plurality of user-created target categories stored in the user-created report field,

wherein before the report table is updated, the report table does not comprise the second column.