Enhanced trade compliance system: mass amendment
First Claim
1. A method of correcting a data field that is repeated in a plurality of records in a trade compliance system database that is managed by a database management program, without having to repetitively enter a correction in each instance of the data field, the method operating in a computer system having a processor and memory and comprising in the order recited:
- making an ad hoc query to select the plurality of records in which the data field is repeated in the trade compliance system database;
making a copy of the plurality of records in which the data field is repeated in the trade compliance system database;
placing the copy of the plurality of the records in an external file that is external to the trade compliance system database;
modifying the copy of the records in the external file by making an identical correction in each repetition of the data field using software other than the database management program which permits free-form changes to be made to the plurality of records; and
uploading the edited copy of the records from the external file back into the trade compliance system database, thereby updating the records while preserving existing data within the trade compliance system database that was contained within the repeated data field prior to the global edit.
1 Assignment
0 Petitions
Accused Products
Abstract
Methods and systems are described for implementing mass amendments that affect many line items and span many entries in a trade compliance system. Mass amendment functions allow a data field that is repeated in a plurality of records in the trade compliance system to be corrected without redundant data entry. A copy of the records that contain the data field is made. The copy may be exported into an external spreadsheet. A global edit, which makes the same correction in each repetition of the data field, is performed on the copy. The edited copy is uploaded into a database in the trade compliance system, to update the records while still preserving the data that existed in the data field prior to the global edit.
34 Citations
21 Claims
-
1. A method of correcting a data field that is repeated in a plurality of records in a trade compliance system database that is managed by a database management program, without having to repetitively enter a correction in each instance of the data field, the method operating in a computer system having a processor and memory and comprising in the order recited:
-
making an ad hoc query to select the plurality of records in which the data field is repeated in the trade compliance system database; making a copy of the plurality of records in which the data field is repeated in the trade compliance system database; placing the copy of the plurality of the records in an external file that is external to the trade compliance system database; modifying the copy of the records in the external file by making an identical correction in each repetition of the data field using software other than the database management program which permits free-form changes to be made to the plurality of records; and uploading the edited copy of the records from the external file back into the trade compliance system database, thereby updating the records while preserving existing data within the trade compliance system database that was contained within the repeated data field prior to the global edit. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A trade compliance system for correcting a data field that is repeated in a plurality of records in a trade compliance system database that is managed by a database management program, without having to repetitively enter a correction in each instance of the data field, comprising:
- one or more computers that have a processor and memory and that are configured to implement the following method in the order recited;
make an ad hoc query to select the plurality of records in which the data field is repeated in the trade compliance system database; make a copy of the plurality of records in which the data field is repeated in the trade compliance system database; place the copy of the plurality of the records in an external file that is external to the trade compliance system database; modify the copy of the records in the external file by making an identical correction in each repetition of the data field using software other than the database management program which permits free-form changes to be made to the plurality of records; and upload the edited copy of the records from the external file back into the trade compliance system database, thereby updating the records while preserving existing data within the trade compliance system database that was contained within the repeated data field prior to the global edit. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19, 20)
- one or more computers that have a processor and memory and that are configured to implement the following method in the order recited;
-
21. A non-transitory, tangible, computer-readable medium having stored therein computer-readable instructions for a processor, wherein the instructions, when read and implemented by the processor, cause the processor in connection with a plurality of records in a trade compliance system database that is managed by a database management program, to cause the following method to be implemented in the order recited:
-
receive an ad hoc query to select the plurality of records in which the data field is repeated in the trade compliance system database; make a copy of the plurality of records in which the data field is repeated in the trade compliance system database; place the copy of the plurality of the records in an external file that is external to the trade compliance system database; allow the copy of the records in the external file to be modified by making an identical correction in each repetition of the data field using software other than the database management program which permits free-form changes to be made to the plurality of records; and upload the edited copy of the records from the external file back into the trade compliance system database, thereby updating the records while preserving existing data within the trade compliance system database that was contained within the repeated data field prior to the global edit.
-
Specification