System and method of processing computer form data

• US 6,851,087 B1
• Filed: 10/04/2000
• Issued: 02/01/2005
• Est. Priority Date: 10/04/2000
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Sibert, Mark A.
• Primary Examiner(s): Hong, Stephen S.
• Assistant Examiner(s): HUTTON JR, WILLIAM D
• Application Number:
  US09/679,128
• Time in Patent Office: 1,581 Days
• Field of Search: 715/505, 715/507, 715/513, 707/10
• US Class Current: 715/236
• CPC Class Codes: G06F 40/151 Transformation
• CPC Class Codes: G06F 40/174 Form filling; Merging
• CPC Class Codes: G06F 40/186 Templates

Abstract

A technique of translating the data structure of a data group pertaining to a computer form from a first format to a second format, is disclosed. A method implementing this technique includes the steps of correlating data fields of the first format with data fields of the second format, identifying data fields from the data group corresponding to the first format, and replacing field identifiers of the identified data fields with field identifiers of the data fields of the second format based on the results of the correlating step. The technique allows a system to easily correlate unrecognizable field names, such as those used in ECML format, with recognizable field names, such as merchant-specific proprietary names, and to process data associated with the unrecognizable field names without having to extensively modify the entire system.

Claims

1. A method of translating the data structure of a data group pertaining to a computer form from a first format to a second format, comprising the steps of:

correlating field identifiers of the first format with field identifiers of the second format, and storing the results of said correlation in a mapping memory;

identifying data values in the data group correlated to the field identifiers of the first format, and storing said identified data values in a data memory; and

replacing field identifiers of the identified data values with field identifiers of the second format based on the results of the correlating step;

wherein the identifying step includes the steps of;

adding a temporary prefix to each field identifier of the first format stored in the data memory; and

comparing each temporarily prefixed field identifier with field identifiers stored in the mapping memory to thereby identify data values correlated to the field identifiers of the first format.

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

receiving, through a communication network, the contents of the data and mapping memories.

3. The method of claim 2, wherein, in the receiving step, the communication network includes the Internet and the computer form includes a web page.

4. The method of claim 1, further comprising the steps of:

embedding the results of the correlating step on the computer form; and

transmitting the embedded computer form to a user to fill out through a communication network.

5. The method of claim 1, wherein the first format is ECML (Electronic Commerce Modeling Language) format.

6. Computer readable code stored on media, for translating the data structure of a data group pertaining to a computer form from a first format to a second format, comprising:

first subprocesses for correlating field identifiers of the first format with field identifiers of the second format, and storing the results of said correlation in a mapping memory;

second subprocesses for identifying data values in the data group correlated to the field identifiers of the first format, and storing said identified data values in a data memory; and

third subprocesses for replacing field identifiers of the identified data values with field identifiers of the second format based on the results of the correlation to convert the first data field into the third data field;

wherein the second subprocess for identifying includes subprocesses of;

subprocesses for adding a temporary prefix to each field identifier of the first format stored in the data memory; and

subprocesses for comparing each temporarily prefixed field identifier with field identifiers stored in the mapping memory to thereby identify data values correlated to the field identifiers of the first format.

7. The code of claim 6, further comprising:

fourth subprocesses for receiving, through a communication network, the data group and mapping information, the mapping information corresponding to the results of the correlating step.

8. The code of claim 7, wherein the communication network includes the Internet and the computer form includes a web page.

9. The code of claim 6, wherein the results of the correlation performed by the first subprocesses are represented as mapping fields, and the second subprocesses add a prefix to each field identifier of the data fields of the data group and compare the prefixed field identifier with field identifiers of the mapping fields to identify the data fields of the data group corresponding to the first format.

10. The code of claim 6, wherein the first processes embed the results of the correlation on the computer form, and transmit the embedded computer form to a user to fill out through a communication network.

11. The code of claim 6, wherein the first format is ECML (Electronic Commerce Modeling Language) format.

12. A system for processing form data of a computer form, the system comprising:

first means for receiving form data of the computer form through a communication network, the form data including mapping information and a plurality of first data field pairs, each of the first data field pairs including a first field name and a first field value;

second means for communicating with the first means, changing at least one of the first field names based on the mapping information, and thereby generating a plurality of second data field pairs; and

third means for communicating with the first means and processing the plurality of second field pairs;

wherein the mapping information includes a plurality of third data field pairs, each of the third data field pairs including a third field name and a third field value, and the second means prepares a hashtable based on the mapping information and the plurality of first data field pairs, the hashtable containing a plurality of key pairs, each of the key pairs including a key name and a key value, adds a prefix to at least one of the key names of the key pairs, determines if the prefixed key name matches any other key names in the hashtable, and replaces at least one of the first field names with the key value associated with the matching key name based on results of the determination to generate at least one of the plurality of second field pairs.

13. The system of claim 12, wherein the communication network includes the Internet and the computer form includes a HyperText Markup Language (HTML) form.

14. The system of claim 13, wherein the second means embeds the mapping information on the computer form and transmits the computer form having the embedded mapping information to a user'"'"'s computer through the communication network, whereby the user'"'"'s computer transmits the form data and the mapping information to the first means.

15. The system of claim 12, wherein the first field names include ECML (Electronic Commerce Modeling Language) field names.

16. A method of processing form data of a computer form, the method comprising the steps of:

receiving the form data of the computer form through a communication network, the form data including mapping information and a plurality of first data field pairs, each of the first data field pairs including a first field name and a first field value;

changing at least one of the first field names based on the mapping information and thereby generating a plurality of second data field pairs; and

processing the plurality of second data field pairs;

wherein, in the receiving step, the mapping information includes a plurality of third data field pairs, each of the third data field pairs including a third field name and a third field value, and the changing step includes the steps of;

preparing a hashtable based on the mapping information and the plurality of first data field pairs, the hashtable containing a plurality of key pairs, each of the key pairs including a key name and a key value,

adding a prefix to at least one of the key names of the key pairs,

determining if the prefixed key name matches any other key name in the hashtable, and

replacing at least one of the first field names with the key value associated with the matching key name based on results of the determining step to generate at least one of the plurality of second data field pairs.

17. The method of claim 16, further comprising the steps of:

prior to the receiving step, embedding the mapping information on the computer form; and

transmitting the computer form having the embedded mapping information to a user'"'"'s computer through the communication network, so that the form data can be received in the receiving step.

18. The method of claim 17, wherein, in the transmitting step, the communication network includes the Internet and the computer form includes a HyperText Markup Language (HTML) form.

19. The method of claim 16, wherein, in the changing step, at least one of the first field names includes an ECML (Electronic Commerce Modeling Language) field name.