System and method for managing export files
First Claim
1. An export file management system for generating export files based on basic export data obtained from a plurality of manufacturing databases, and for automatically sending shipping advices to corresponding consignees of cargoes by e-mail, the system comprising:
- a plurality of manufacturing workstations;
a database server comprising a database;
an application server comprising;
a basic data module for obtaining basic export data by accessing the manufacturing workstations, and for storing said obtained basic export data in the database;
a tracking module for obtaining information on cargo tracking and abnormality messages sent by forwarders via corresponding client computers;
an export file management module for obtaining required data from the database; and
for generating export files, address lists, cargo tracking records, and shipping advices based on said required data; and
a communication module for receiving shipping advices, obtaining information on consignees of cargoes by accessing corresponding address lists in the database, and for sending the shipping advices to the consignees according to said obtained information on consignees; and
a network connecting the manufacturing workstations and the application server.
1 Assignment
0 Petitions
Accused Products
Abstract
A system and method for generating export files based on basic export data obtained from a plurality of manufacturing databases, and for automatically sending shipping advices to corresponding consignees of cargoes by e-mail is provided. The system includes a database server (12) comprising a database (120), a plurality of client computers (16), a plurality of manufacturing workstations (10) and an application server (14). Each of the manufacturing workstations includes a manufacturing database (1000) for storing basic export data. The basic export data include information on cargoes, forwarders, and shipping paths. The application server is linked to the manufacturing workstations with an internal network (13), through which the application server obtains the basic export data by accessing the manufacturing databases on a daily basis. The application server includes a basic data module (141), a time control module (142), a tracking module (143), an export file management module (144) and a communication module (145). A related method is also disclosed.
10 Citations
20 Claims
-
1. An export file management system for generating export files based on basic export data obtained from a plurality of manufacturing databases, and for automatically sending shipping advices to corresponding consignees of cargoes by e-mail, the system comprising:
-
a plurality of manufacturing workstations;
a database server comprising a database;
an application server comprising;
a basic data module for obtaining basic export data by accessing the manufacturing workstations, and for storing said obtained basic export data in the database;
a tracking module for obtaining information on cargo tracking and abnormality messages sent by forwarders via corresponding client computers;
an export file management module for obtaining required data from the database; and
for generating export files, address lists, cargo tracking records, and shipping advices based on said required data; and
a communication module for receiving shipping advices, obtaining information on consignees of cargoes by accessing corresponding address lists in the database, and for sending the shipping advices to the consignees according to said obtained information on consignees; and
a network connecting the manufacturing workstations and the application server. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. An export file management method for generating export files based on basic export data obtained from a manufacturing database, and for automatically sending a shipping advice to a corresponding consignee of a cargo by e-mail, the method comprising the steps of:
-
(a) obtaining basic export data on the cargo by accessing the manufacturing database;
(b) storing the basic export data in a system database;
(c) obtaining the basic export data from the system database to generate a series of export files, an address list and a cargo tracking record;
(d) receiving information on cargo tracking and abnormality messages from a client computer of a corresponding forwarder, and storing said received information in the system database;
(e) obtaining the basic export data, the information on cargo tracking and the export files by accessing the system database, and generating a shipping advice; and
(f) obtaining information on a corresponding consignee of the cargo by accessing the address list of the system database, and sending the shipping advice to the consignee based on the obtained information. - View Dependent Claims (16, 17, 18, 19)
-
-
20. A method of managing export files, comprising steps of:
-
setting time parameters;
obtaining basic export data from manufacturing databases on a daily basis;
generating export files and a cargo tracking record for each cargo;
receiving information on cargo tracking and abnormality messages for each cargo;
generating a shipping advice;
sending the shipping advice to a corresponding consignee;
generating a series of reports on a daily basis;
sending the reports to corresponding recipients.
-
Specification