Method and apparatus for enabling bulk loading of data

• US 20020042835A1
• Filed: 03/29/2001
• Published: 04/11/2002
• Est. Priority Date: 03/29/2000
• Status: Abandoned Application

• Current Assignee: Espirant Incorporated
• Original Assignee: Espirant Incorporated
• Inventors: Leonard, Jeffrey W., Pepin, Christine S.
• Application Number:
  US09/820,324
• Publication Number:
  US 20020042835A1
• Time in Patent Office: Days
• US Class Current: 709/232
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

A system and method for processing information performs actions associated with rules to modify, adjust, calculate and massage data to comport with downstream handling requirements. In one example, bulk uploads from a supplier are treated in accordance with column headings to perfect data to be imported into a marketplace. The system also permits the storage of the rules to process later uploads with similar data structures. The similar data structures may be determined through matching the supplier and marketplace sites with the saved sets.

Claims

1. A method for processing information comprising the steps of:

selecting a first label from a first list of labels to identify a first set of data;

selecting a second label from a second list of labels to identify a second set of data;

applying a first rule associated with said first set of data based on the selection of said first label; and

applying a second rule associated with said second set of data based on the selection of said second label.

2. The method of claim 1, wherein at least one of the first set of data and the second set of data is a column.

3. The method of claim 1, wherein at least one of the first set of data and the second set of data is a field.

4. The method of claim 1, wherein at least one of the first rule and the second rule is applied to the content of a cell in a column based on the content of said cell.

5. The method of claim 1, wherein at least one of the first rule and the second rule is applied to the content of a first cell in a column based on the content of a second cell.

6. The method of claim 1, further comprising the step of:

applying a third rule to said first set of data based on the selection of said first label.

7. The method of claim 1, further comprising the step of:

after said selecting a first label step, removing said first label from said first list of labels to result in said second list of labels.

8. The method of claim 1, wherein said first list of labels is identical to said second list of labels.

9. The method of claim 1, further comprising the step of:

outputting the result of said first and second applying steps to a remote application.

10. The method of claim 1, wherein said first applying step comprises the step of:

generating a third set of data based on said first set of data.

11. The method of claim 1, wherein said first applying step comprises the step of:

replacing said first set of data with a third set of data.

12. The method of claim 1, wherein said first rule performs the step of data scrubbing on said information.

13. The method of claim 1, wherein said first rule filters said information.

14. The method of claim 1, wherein said first rule applies source rules to said information.

15. The method of claim 1, wherein said first rule applies destination rules to said information.

16. The method of claim 1, wherein said first rule applies cleanup rules to said information.

17. The method of claim 1, wherein said first rule applies derivation rules to said information.

18. The method of claim 1, wherein said first rule applies transformation rules to said information.

19. The method of claim 1, wherein said first rule applies mapping rules to said information.

20. The method of claim 1, said first applying step comprising the steps of:

determining at least one of a supplier of the information and a recipient of the information;

determining to apply said first rule from a set of rules based on at least one of said supplier and said recipient; and

applying said first rule.

21. The method according to claim 1, further comprising the steps of:

determining at least one a header row of the information, a supplier of the information and a recipient information;

storing said first and second selecting steps with at least one of an indication of said header row, said supplier, and said recipient as part of a knowledgebase; and

when processing new information with an indication, matching at least one of said header row, said supplier and said recipient, performing said first and second selecting steps on said new information.

22. A system for processing information comprising:

a first database having a first set of fields;

a second database having a second set of fields;

a processor for applying a mapping between at least some of said first set of fields to at least some of said second set of fields, said processor applying said mapping based on labels associated with said first and said second sets of fields.

24. The system of claim 23, wherein at least one of the first set of data and the second set of data is a column.

25. The system of claim 23, wherein at least one of the first set of data and the second set of data is a field.

26. The system of claim 23, further comprising:

means for applying a third rule to said first set of data based on the selection of said first label.

27. The system of claim 23, further comprising:

means for removing said first label from said first list of labels to result in said second list of labels after operation of said means for selecting a first label.

28. The system of claim 23, wherein said first list of labels is identical to said second list of labels.

29. The system of claim 23, further comprising:

means for outputting the result of said first and second applying steps to a remote application.

30. The system of claim 23, wherein said means for first applying further comprises:

means for generating a third set of data based on said first set of data.

31. The system of claim 23, wherein said means for first applying comprises:

means for replacing said first set of data with a third set of data.

32. The system of claim 23, said means for first applying comprises:

means for determining at least one of a supplier of the information and a recipient of the information;

means for determining to apply said first rule from a set of rules based on at least one of said supplier and said recipient; and

means for applying said first rule.

33. The system according to claim 23, further comprising:

means for determining at least one of a supplier of the information and a recipient information; and

means for storing the output of said first means for selecting and said second means for selecting with at least one of an indication of said supplier and said recipient as part of a knowledgebase,

wherein, when processing new information with an indication matching at least one of said supplier and said recipient, said first means for selecting and said second means for selecting select labels for said new information.

35. The computer-readable medium according to claim 34, said program further comprising the steps of:

determining at least one of a supplier of the information and a recipient information;

storing said first and second selecting steps with at least one of an indication of said supplier and said recipient as part of a knowledgebase; and

when processing new information with an indication matching at least one of said supplier and said recipient, performing said first and second selecting steps on said new information.

23. A system for processing information comprising:

means for selecting a first label from a first list of labels to identify a first set of data;

means for selecting a second label from a second list of labels to identify a second set of data;

means for applying a first rule associated with said first set of data based on the selection of said first label; and

means for applying a second rule associated with said second set of data based on the selection of said second label.

34. A computer-readable medium having a program for processing information, said program comprising the steps of:

selecting a first label from a first list of labels to identify a first set of data;

selecting a second label from a second list of labels to identify a second set of data;

applying a first rule associated with said first set of data based on the selection of said first label; and

applying a second rule associated with said second set of data based on the selection of said second label.