Data quality in a cloud based shipping transaction integration system

摘要

Files related to shipping transactions are received from participants. Each of the files are processed in a first stage of a multi-stage process that includes attempting to translate the files to generate a translated file and storing an error status for each file in which the translation experienced an error. For those files that are successfully translated, they are processed in subsequent stage(s) including applying application rule(s) to those files and storing an error status for those translated files resulting in an error. A participant may view a summary of those translated files that are associated with an error status. The participant may further view details of an error to be displayed and retrieve the underlying file. The participant may edit the file to correct the issue and republish the modified file to be reprocessed in the stage of the multi-stage process that identified the error.

主权项

1. A method for improved data quality in a cloud based shipping transaction integration system, comprising:
receiving a plurality of messages for a plurality of shipping transactions from a plurality of participants of the shipping transactions, wherein each of the plurality of messages includes a file associated with one of the shipping transactions, wherein at least some of the messages have a different format and have different terminology for a same data information type, and wherein the plurality of participants include at least a seller, a buyer, and a carrier; processing each of the received messages in a first stage of a multiple stage process, wherein processing in the first stage includes performing the following:
for each file of each message, attempting to translate that file to generate a translated file that is in a common format, andstoring an error status for each file in which the translation experienced an error; processing, in a set of one or more subsequent stages of the multiple stage process, each of those files of the received messages that has successfully been translated to the common format, wherein processing in the set of subsequent stages includes performing the following:
applying a set of one or more application rules to each of the translated files, andstoring an error status for each of those translated files in which the application of the set of application rules indicated an error; responsive to receiving a first input from a first one of the participants, displaying a summary of information of those translated files that are visible to the first participant and are associated with an error status, wherein the summary information is grouped at least in part based on message type and indicates for each grouping a number of the translated files associated with an error status, and wherein the summary of information includes a user selectable link for each grouping; responsive to receiving a second input from the first one of the participants that indicates a selection of a user selectable link for a grouping, for each of the number of translated files associated with an error status for that grouping, displaying details of the error that caused that translated file to be associated with an error status and including a user selectable link; responsive to receiving a third input from the first one of the participants that indicates a selection of a user selectable link included in the displayed details, displaying, in a text editor, the translated file that corresponds with the displayed details; receiving, through the text editor, a fourth input from the first one of the participants that modifies the translated file that was displayed as a result of the received third input; and republishing the modified translated file to be reprocessed in the stage of the multiple stage process that identified the error.