US6418400B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Representation and processing of EDI mapping templates
Assignee: XENOS IP PARTNERSHIP
•
Filing: 1998-12-30
•
Granted: 2002-07-09
•
Expires: 2018-12-30
Abstract
Abstract An improved “code-free” method of describing EDI business information manipulation processes. Whereas currently EDI translation and message processing is characterized by complex programming methods, this use of a spreadsheet style metaphor enables EDI processing to be developed that can be used in an ad hoc and dynamic fashion. This matches the business requirements brought about by environments such as the Internet and Electronic Commerce. Also the method can be integrated directly into modern software tools such as Web Browser software, and used by people who are not intimately familiar with the exact details of EDI message syntax. Instead they utilize a familiar data representation in order to accomplish a complex task that otherwise would instead require highly skilled programming knowledge to perform.
Inventors
- 👤 David R. R. Webber
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-02 11:39
CPC Classifications
G; G06; G06F; G06F40/00; G06F40/10; G06F40/166; G06F40/177; G06F40/18
Claims Analysis
Total Claims: 45
Claim 1
Independent Claim
59 words
A template mapping system comprising: a computer system operating with data structured according to a protocol; a communications means for accessing a local dataset from said computer system in said protocol; a means for accessing a Web Server from said computer system; and a means, using a spreadsheet-style template interface, for creating a mapping template using said computer system.
Claim 2
Dependent Claim
59 words
A template mapping system comprising: a computer system operating with data structured according to a protocol; a communications means for accessing a local dataset from said computer system in said protocol; a means for accessing a Web Server from said computer system; and a means, using a spreadsheet-style template interface, for creating a mapping template using said computer system.
Claim 3
Dependent Claim
35 words
A system according to claim 1 , wherein said means for creating said mapping template further comprises a means for replicating a trading partner's data interactions by applying said mapping template to said local dataset.
Claim 4
Dependent Claim
41 words
A system according to claim 2 , wherein said means for replicating a trading partner's data interactions by applying said mapping template to said local dataset further comprises a means for retrieving said trading partner's mapping template via said Web Server.
Claim 5
Dependent Claim
46 words
A system according to claim 3 , wherein said means for creating said mapping template further comprises a means for constructing a local version of said trading partner's mapping template by changing a plurality of items in said mapping template to definitions from said local dataset.
Claim 6
Dependent Claim
69 words
A system according to claim 4 , wherein said means for constructing a local version of said trading partner's mapping template by changing a plurality of items in said mapping template to definitions from said local dataset further comprises, a means, using a spreadsheet-style template interface, for selecting a plurality of explicit database field elements or items from said local dataset as additions or replacements to said mapping template.
Claim 7
Dependent Claim
64 words
A system according to claim 4 , wherein said means for constructing a local version of said trading partner's mapping template by changing a plurality of items in said mapping template to definitions from said local dataset further comprises, a means, using a spreadsheet-style template interface, for selecting a plurality of explicit database field elements or items of said mapping template to be deleted.
Claim 8
Dependent Claim
53 words
A system according to claim 4 , wherein said means for constructing a local version of said trading partner's mapping template by changing a plurality of items in said mapping template to definitions from said local dataset further comprises, a means, using a spreadsheet-style template interface, for modifying a plurality of field attributes.
Claim 9
Dependent Claim
48 words
A system according to claim 4 , wherein said means for constructing a local version of said trading partner's mapping template by changing a plurality of items in said mapping template to definitions from said local dataset further comprises, a means for verifying and validating said mapping template.
Claim 10
Dependent Claim
44 words
A system according to claim 1 , wherein said means for creating said mapping template further comprises a means for replicating a mapping template posted to a Global EDI Dictionary retrieved via a Web Server by applying said mapping template to said local dataset.
Claim 11
Dependent Claim
50 words
A system according to claim 9 , wherein said means for creating said mapping template further comprises a means for constructing a local version of said mapping template retrieved from said Global EDI Dictionary by changing a plurality of items in said mapping template to definitions from said local dataset.
Claim 12
Dependent Claim
73 words
A system according to claim 10 , wherein said means for constructing a local version of said mapping template retrieved from said Global EDI Dictionary by changing a plurality of items in said mapping template to definitions from said local dataset further comprises, a means, using a spreadsheet-style template interface, for selecting a plurality of explicit database field elements or items from said local dataset as additions or replacements to said mapping template.
Claim 13
Dependent Claim
68 words
A system according to claim 10 , wherein said means for constructing a local version of said mapping template retrieved from said Global EDI Dictionary by changing a plurality of items in said mapping template to definitions from said local dataset further comprises, a means, using a spreadsheet-style template interface, for selecting a plurality of explicit database field elements or items of said mapping template to be deleted.
Claim 14
Dependent Claim
57 words
A system according to claim 10 , wherein said means for constructing a local version of said mapping template retrieved from said Global EDI Dictionary by changing a plurality of items in said mapping template to definitions from said local dataset further comprises, a means, using a spreadsheet-style template interface, for modifying a plurality of field attributes.
Claim 15
Dependent Claim
52 words
A system according to claim 10 , wherein said means for constructing a local version of said mapping template retrieved from said Global EDI Dictionary by changing a plurality of items in said mapping template to definitions from said local dataset further comprises, a means for verifying and validating said mapping template.
Claim 16
Dependent Claim
28 words
The apparatus according to claim 1 , wherein the means for creating said mapping template further comprises means for defining index fields to control sequences of information processing.
Claim 17
Dependent Claim
27 words
The apparatus according to claim 1 , wherein the means for creating said mapping template further comprises means for referencing via look-up table a dataset for validation.
Claim 18
Independent Claim
77 words
A method for creating a mapping template, comprising the steps of: replicating a trading partner's data interactions by applying said mapping template to a local dataset, wherein said replicating step further comprises the step of retrieving said trading partner's data interactions via a Web Server using a spreadsheet-style template interface; and constructing a local version of said trading partner's mapping template by changing a plurality of items in said mapping template to definitions from said local dataset.
Claim 19
Independent Claim
77 words
A method for creating a mapping template, comprising the steps of: replicating a trading partner's data interactions by applying said mapping template to a local dataset, wherein said replicating step further comprises the step of retrieving said trading partner's data interactions via a Web Server using a spreadsheet-style template interface; and constructing a local version of said trading partner's mapping template by changing a plurality of items in said mapping template to definitions from said local dataset.
Claim 20
Dependent Claim
43 words
The method according to claim 17 , wherein said constructing step further comprises the step of selecting, using the spreadsheet-style template interface, a plurality of explicit database field elements or items from said local dataset as additions or replacements to said mapping template.
Claim 21
Dependent Claim
21 words
The method according to claim 17 , further comprising the step of defining index fields to control sequences of information processing.
Claim 22
Dependent Claim
20 words
The method according to claim 17 , further comprising the step of referencing via look-up table a dataset for validation.
Claim 23
Dependent Claim
23 words
The method according to claim 17 , further comprising the step of referencing via look-up table a data set for validation and transformation.
Claim 24
Dependent Claim
29 words
The method according to claim 17 , wherein the means for creating said mapping template further comprises means for referencing via look-up table a dataset for validation and transformation.
Claim 25
Dependent Claim
38 words
The method according to claim 17 , wherein said constructing step further comprises the step of selecting, using the spreadsheet-style template interface, a plurality of explicit dataset field elements or items of said mapping template to be deleted.
Claim 26
Dependent Claim
27 words
The method according to claim 17 , wherein said constructing step further comprises the step of modifying, using the spreadsheet-style template interface, a plurality of field attributes.
Claim 27
Dependent Claim
22 words
The method according to claim 17 , wherein said constructing step further comprises the step of verifying and validating said mapping template.
Claim 28
Independent Claim
79 words
A method for creating a mapping template, comprising the steps of: replicating a Global EDI Dictionary mapping template by applying said mapping template to a local dataset, wherein said replicating step further comprises the step of retrieving said Global EDI Dictionary mapping template via a Web Server using a spreadsheet-style template interface; and constructing a local version of said trading partner's mapping template by changing a plurality of items in said mapping template to definitions from said local dataset.
Claim 29
Independent Claim
79 words
A method for creating a mapping template, comprising the steps of: replicating a Global EDI Dictionary mapping template by applying said mapping template to a local dataset, wherein said replicating step further comprises the step of retrieving said Global EDI Dictionary mapping template via a Web Server using a spreadsheet-style template interface; and constructing a local version of said trading partner's mapping template by changing a plurality of items in said mapping template to definitions from said local dataset.
Claim 30
Dependent Claim
43 words
The method according to claim 26 , wherein said constructing step further comprises the step of selecting, using the spreadsheet-style template interface, a plurality of explicit database field elements or items from said local dataset as additions or replacements to said mapping template.
Claim 31
Dependent Claim
38 words
The method according to claim 26 , wherein said constructing step further comprises the step of selecting, using the spreadsheet-style template interface, a plurality of explicit dataset field elements or items of said mapping template to be deleted.
Claim 32
Dependent Claim
27 words
The method according to claim 26 , wherein said constructing step further comprises the step of modifying, using the spreadsheet-style template interface, a plurality of field attributes.
Claim 33
Dependent Claim
22 words
The method according to claim 26 , wherein said constructing step further comprises the step of verifying and validating said mapping template.
Claim 34
Independent Claim
84 words
A method for creating transformation information, comprising: selecting field items for a mapping template from a local dataset associated with the mapping template using a spreadsheet-style template interface; assigning mapping rules to the selected field items; creating mapping rules for referencing look-up tables, which reference objects within the mapping template or reference objects stored in an external dataset; and transforming referenced objects, according to the mapping template, into transformed information for transmission with the mapping template to a user for use by the user.
Claim 35
Independent Claim
84 words
A method for creating transformation information, comprising: selecting field items for a mapping template from a local dataset associated with the mapping template using a spreadsheet-style template interface; assigning mapping rules to the selected field items; creating mapping rules for referencing look-up tables, which reference objects within the mapping template or reference objects stored in an external dataset; and transforming referenced objects, according to the mapping template, into transformed information for transmission with the mapping template to a user for use by the user.
Claim 36
Dependent Claim
20 words
The method as in claim 31 , further comprising selecting the mapping template from a set of stored mapping templates.
Claim 37
Dependent Claim
19 words
The method as in claim 32 , further comprising modifying the selected mapping template for use in transforming objects.
Claim 38
Dependent Claim
19 words
The method as in claim 31 , further comprising assigning links to process the objects referenced by mapping rules.
Claim 39
Dependent Claim
20 words
The method as in claim 31 , further comprising storing the mapping template in a global EDI dictionary for reuse.
Claim 40
Dependent Claim
75 words
A computer readable medium having computer readable instructions stored therein for creating a mapping template, wherein said computer readable instructions comprise: means for enabling a computer to replicate a trading partner's data interactions via a Web server using a spreadsheet-style template interface; and means for enabling the computer to construct a local version of said trading partners mapping template by changing a plurality of items in said mapping template to definitions from said local dataset.
Claim 41
Dependent Claim
75 words
A computer readable medium having computer readable instructions stored therein for creating a mapping template, wherein said computer readable instructions comprise: means for enabling a computer to replicate a trading partner's data interactions via a Web server using a spreadsheet-style template interface; and means for enabling the computer to construct a local version of said trading partners mapping template by changing a plurality of items in said mapping template to definitions from said local dataset.
Claim 42
Dependent Claim
95 words
A computer readable medium having computer readable instructions stored therein for creating a mapping template, wherein said computer readable instructions comprise: means for enabling a computer to replicate processing of a mapping template retrieved from a Global EDI Dictionary by applying said mapping template to a local dataset, including retrieving said mapping template via a Web Server using a spreadsheet-style template interface; and means for enabling the computer to construct a local version of said trading partner's mapping template by changing a plurality of items in said mapping template to definitions from said local dataset.
Claim 43
Dependent Claim
95 words
A computer readable medium having computer readable instructions stored therein for creating a mapping template, wherein said computer readable instructions comprise: means for enabling a computer to replicate processing of a mapping template retrieved from a Global EDI Dictionary by applying said mapping template to a local dataset, including retrieving said mapping template via a Web Server using a spreadsheet-style template interface; and means for enabling the computer to construct a local version of said trading partner's mapping template by changing a plurality of items in said mapping template to definitions from said local dataset.
Claim 44
Dependent Claim
88 words
A computer-readable medium containing computer-readable instructions for performing the steps comprising: selecting field items for a mapping template from a local dataset associated with the mapping template using a spreadsheet-style template interface; assigning mapping rules to the selected field items; creating mapping rules for referencing look-up tables, which reference objects within the mapping template or reference objects stored in an external dataset; and transforming referenced objects, according to the mapping template, into transformed information for transmission with the mapping template to a user for use by the user.
Claim 45
Dependent Claim
88 words
A computer-readable medium containing computer-readable instructions for performing the steps comprising: selecting field items for a mapping template from a local dataset associated with the mapping template using a spreadsheet-style template interface; assigning mapping rules to the selected field items; creating mapping rules for referencing look-up tables, which reference objects within the mapping template or reference objects stored in an external dataset; and transforming referenced objects, according to the mapping template, into transformed information for transmission with the mapping template to a user for use by the user.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-07-08 | 2006-01-07 | 2006-07-09 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-07-08 | 2010-01-07 | 2010-07-09 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-07-08 | 2014-01-07 | 2014-07-09 | $7700.00 | Window Closed / Lapsed |