Intelligent Automated Creation of Electronic Data Exchange Templates for Telecommunication Expense Management Inventory Processing
AssigneeTangoe US, Inc.
InventorJigar Madlani
Life of this patent
Estimating the term…
Abstract
A system is provided that uses template files to process EDI invoice files to extract inventory related data which can both augment existing inventory data as well as validate its accuracy. The system also provides automated means to map new carrier EDI formats to new templates which can be created in an automated fashion through the use of machine learning and robotic process automation.
Claims20
A system for mapping Electronic Data Interchange (EDI) files containing telecommunications data comprising:
- software executing on a computer, the software having a plurality of templates accessible thereto, each of the plurality of templates containing mapping instructions for mapping a plurality of data fields comprising telecommunications data, the data fields contained in one or more EDI files;
- the software accessing an EDI file and identifying mapping instructions from two or more of the plurality of templates which allow for mapping different sets of data fields in the EDI file wherein each of the two or more templates allows mapping a different subset of the EDI file;
- said software generating a new template from the identified mapping instructions from the two or more of the plurality of templates which allow for mapping of more of the EDI file than fewer than all of the two or more templates.
A system for mapping Electronic Data Interchange (EDI) files containing telecommunications data comprising:
- software executing on a computer, the software having a plurality of templates accessible thereto, each of the plurality of templates containing mapping instructions for mapping a plurality of data fields comprising telecommunications data, the data fields contained in one or more EDI files, each template associated with at least one telecommunications provider;
- the software accessing an EDI file from a first telecommunications provider and matching one of the plurality of templates to that EDI file, said software further identifying one or more data fields in the EDI file for which the template does not include mapping instructions;
- said software further comprising a robotic process automation (RPA) which identifies one or more standard fields which are not mapped by the matched one of the plurality of templates and comparing the EDI file to those one or more standard fields to identify a correlation between the one or more standard fields and the one or more data fields in the EDI file for which the template does not include mapping instructions to generate augmentation data;
- said software modifying the matched one of the plurality of templates or based on the augmentation data include additional mapping instructions for the identified one or more data fields in the EDI file for which the template did not include mapping instructions prior to modification.
A method of converting Electronic Data Interchange (EDI) data to a uniform format comprising:
- accessing one or more EDI files each EDI file associated with one of a plurality of carriers;
- identifying a template for each of the one or more EDI files using software executing on a computer, the identified template including mapping instructions for the one of the plurality of telecommunications providers associated with the EDI file to map data fields in the EDI file to a uniform format;
- with the software, determining one or more data fields for which the identified template does not contain mapping instructions;
- with the software, obtaining additional mapping instructions from the group consisting of:
- one or more templates other than the identified template, a robotic process automation (RPA) which identifies one or more standard fields which are not mapped by the matched one of the plurality of templates and comparing the EDI file to those one or more standard fields to identify a correlation between the one or more standard fields and the one or more data fields use of a robot and combinations thereof;
- with the software, modifying the identified template to include the additional mapping instructions.
Dependencies are inferred from the claim text.