CN110232164B

CN110232164B - Internationalized processing method and device and computer storage medium

Info

Publication number: CN110232164B
Application number: CN201910329231.XA
Authority: CN
Inventors: 刘明磊; 于彪; 祁晓光
Original assignee: Beijing Kuangshi Technology Co Ltd
Current assignee: Beijing Kuangshi Technology Co Ltd
Priority date: 2019-04-23
Filing date: 2019-04-23
Publication date: 2021-10-15
Anticipated expiration: 2039-04-23
Also published as: CN110232164A

Abstract

Provided are a method, an apparatus, and a computer storage medium for internationalized processing. The method comprises the following steps: receiving a export request from a front end, wherein the export request is input by a front end person according to a template designed and developed by a back end person, and the export request comprises at least one tab name and information of a column corresponding to each tab name; analyzing the expected export column of the front-end personnel from the export request; querying data needing to be exported; generating an export table and uploading the export table to a file server; sending a message notification to the front end indicating that the derivation is complete. Therefore, internationally exported columns are determined by front-end personnel, so that flexible configuration can be realized as required, and user experience is improved. Moreover, the front end is informed by the rear end in a message informing mode, the front end personnel can download at a proper time, the export table is stored in the file server and can support multiple downloads, the operation is convenient, and the browser is prevented from being blocked.

Description

Internationalized processing method and device and computer storage medium

Technical Field

The present invention relates to the field of web page development, and more particularly, to a method and an apparatus for internationalized processing, and a computer storage medium.

Background

Internationalization is a technology for designing and manufacturing products which are suitable for different regional requirements and different language requirements. As the web becomes more and more functional and complex, the internationalization problem involved becomes cumbersome.

Currently, the problem of internationalization is mainly handled by the backend. For example, the international export problem is controlled by the back-end, the exported columns are written by the program in the back-end, and the exported data is directly written into the table (excel) and then directly returned to the front-end in the form of stream. Therefore, the internationalization problem is complicated and troublesome to realize, the export column is fixed and cannot be flexibly configured, the browser is easy to be blocked when the exported files are particularly large, the exporting time is particularly long, and the efficiency is low.

Disclosure of Invention

The invention provides an internationalized processing method and device and a computer storage medium, which can be flexibly configured for exported columns and have high implementation efficiency.

According to a first aspect of the present invention, there is provided a method of internationalization processing, the method comprising:

receiving a export request from a front end, wherein the export request is input by a front end person according to a template designed and developed by a back end person, and the export request comprises at least one tab name and information of a column corresponding to each tab name;

analyzing the expected export column of the front-end personnel from the export request;

querying data needing to be exported;

generating an export table and uploading the export table to a file server;

sending a message notification to the front end, the message notification indicating that the derivation is complete.

In one implementation of the invention, receiving a request to export from a front-end comprises: receiving the export request and the query condition input by the front-end personnel from the front-end.

In one implementation of the present invention, querying data to be exported includes: and filtering according to the query condition to obtain the data needing to be exported.

In one implementation of the invention, generating a derived table includes: creating a blank table according to the expected export column; and writing the data needing to be exported into the blank table in a multithreading mode, thereby generating the export table.

In one implementation manner of the present invention, the backend stores a message table, where the message table includes a name of the export table, a download address of the export table, and a status identifier of the export table, where the status identifier indicates whether the export table has been exported.

In one implementation manner of the present invention, after uploading the export table to a file server, the method further includes: recording a download address of the export table in the message table, and modifying a status flag of the export table in the message table to indicate that export is complete.

In one implementation manner of the present invention, the method further includes:

receiving a download request of the front-end personnel from the front end;

acquiring a download address of the derived form from the message form according to the download request;

downloading the export table from the file server according to the download address;

and sending the export table to a front end.

In an implementation manner of the present invention, the template is in an object numbered notation json format, and at least includes the following information: column names, key names corresponding to the column names, types, line widths, line heights corresponding to the column names, and attribute information requiring internationalization.

In an implementation manner of the present invention, the table is in an excel format.

According to a second aspect of the present invention, there is provided a method of internationalization processing, the method comprising:

acquiring a lead-out request input by front-end personnel, wherein the lead-out request is input by the front-end personnel according to a template designed and developed by rear-end personnel, and the lead-out request comprises at least one tab name and information of a column corresponding to each tab name;

transmitting the export request to the back end so that the back end can perform data writing according to the export request;

receiving a message notification that the export is complete;

and downloading the export data from the file server according to the message notification.

In one implementation manner of the present invention, transmitting the export request to the backend includes:

acquiring query conditions input by the front-end personnel;

acquiring a leading-out instruction triggered by the front-end personnel;

and transmitting the export request and the query condition to the back end according to the export instruction.

In one implementation of the present invention, downloading export data from a file server includes:

receiving a downloading request of the front-end personnel;

sending the download request to the backend so that the backend downloads the export form from the file server;

receiving the derived table from the backend.

In an implementation manner of the present invention, the export data is in an excel format.

According to another aspect of the present invention, there is provided an internationalized processing apparatus for implementing the steps of the method of the first aspect or any implementation manner, the apparatus comprising:

the system comprises a receiving module, a processing module and a display module, wherein the receiving module is used for receiving a lead-out request from a front end, the lead-out request is input by a front end person according to a template designed and developed by a back end person, and the lead-out request comprises at least one tab name and information of a column corresponding to each tab name;

the analysis module is used for analyzing the expected export column of the front-end personnel from the export request;

the query module is used for querying data needing to be exported;

the generating module is used for generating an export table and uploading the export table to a file server;

a sending module, configured to send a message notification to the front end, where the message notification is used to indicate that the derivation is completed.

According to another aspect of the present invention, there is provided an internationalized processing apparatus for implementing the steps of the method according to the second aspect or any implementation manner, the apparatus comprising:

the system comprises an acquisition module, a processing module and a display module, wherein the acquisition module is used for acquiring a lead-out request input by front-end personnel, the lead-out request is input by the front-end personnel according to a template designed and developed by rear-end personnel, and the lead-out request comprises at least one tab name and information of a column corresponding to each tab name;

a sending module, configured to transmit the export request to the backend, so that the backend performs data writing according to the export request;

and the receiving module is used for receiving the message notification of the export completion and downloading the export data from the file server according to the message notification.

According to a further aspect of the present invention, there is provided an apparatus for internationalizing processes, comprising a memory, a processor and a computer program stored on the memory and running on the processor, the processor implementing the steps of the method for internationalizing processes according to the first aspect or any implementation manner when executing the computer program.

According to a further aspect of the present invention, there is provided an internationalized processing apparatus comprising a memory, a processor and a computer program stored in the memory and running on the processor, wherein the processor implements the steps of the method of internationalized processing according to the second aspect or any implementation manner when executing the computer program.

According to a further aspect of the present invention, there is provided a computer storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the method of internationalization processing as described in the first aspect or any of the implementations.

According to a further aspect of the present invention, there is provided a computer storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the method of internationalization processing of the second aspect or any of the implementations set forth above.

Therefore, in the embodiment of the invention, the front-end personnel can flexibly configure the columns to be exported as required, the implementation is convenient, and the user experience is improved. Moreover, the front end is informed by the rear end in a message informing mode, the front end personnel can download at a proper time, the export table is stored in the file server and can support multiple downloads, the operation is convenient, and the browser is prevented from being blocked. In addition, the back end writes data into the export table concurrently through multiple threads, and export efficiency is greatly improved. Moreover, the exported data supports multiple tabs, and repeated operation of front-end personnel is avoided.

Drawings

The above and other objects, features and advantages of the present invention will become more apparent by describing in more detail embodiments of the present invention with reference to the attached drawings. The accompanying drawings are included to provide a further understanding of the embodiments of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention and not to limit the invention. In the drawings, like reference numbers generally represent like parts or steps.

FIG. 1 is an example environment for an embodiment of the present invention.

FIG. 2 is a schematic flow chart of a method of internationalization processing of an embodiment of the present invention.

FIG. 3 is another schematic flow chart of a method of internationalization processing of an embodiment of the present invention.

FIG. 4 is a schematic interaction flow diagram of a method of internationalization processing of an embodiment of the present invention.

Fig. 5 is a schematic block diagram of an internationalized processing apparatus according to an embodiment of the present invention.

Fig. 6 is another schematic block diagram of an internationalized processing apparatus of an embodiment of the present invention.

Fig. 7 is still another schematic block diagram of an internationalized processing apparatus of the embodiment of the present invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the present invention more apparent, exemplary embodiments according to the present invention will be described in detail below with reference to the accompanying drawings. It is to be understood that the described embodiments are merely a subset of embodiments of the invention and not all embodiments of the invention, with the understanding that the invention is not limited to the example embodiments described herein. All other embodiments, which can be derived by a person skilled in the art from the embodiments of the invention described herein without inventive step, shall fall within the scope of protection of the invention.

When the internationalization export is carried out, the front-end personnel can select the configuration language to carry out the replacement of the internationalization characters and then transmit the internationalized information to the back end; the back-end can then export the data to a table (excel), which is returned to the front-end in the form of a stream; therefore, front-end personnel can check the excel read internationalized excel.

In the existing international export, the exported columns are written by back-end personnel through a program, and the exported columns are fixed and cannot be flexibly configured. In addition, when the exported file is large, the browser is blocked, so that the exporting time is too long, the efficiency is low, and the user experience is influenced.

In order to solve the above problems in whole or in part, in the embodiment of the present invention, a column to be exported is moved forward to a front end, and an export request is initiated by the front end through an entry form. Specifically, detailed embodiments will be described below with reference to the accompanying drawings.

When the front-end personnel design the web pages, many front-end personnel can simultaneously carry out international configuration, so that the web pages can support multiple languages, such as Chinese, English, Japanese and the like.

Backend personnel can develop templates designed for internationalized export, which can be agreed-upon Object Notation (JSON) strings. json is a lightweight data exchange format. The json string includes: a column name; the key name corresponding to the column name; type, row width and row height corresponding to the column name; internationalized attribute information and the like are required. In addition, backend personnel can also design a set of supportable export columns.

Thereafter, the front-end personnel may be notified of the template and the set of supported export columns by offline convention or the like. For example, the notification may be made by a file, a manual, or other means.

FIG. 1 is an exemplary environment for embodiments of the present invention, including a back end and two front ends. The back end can be a distributed system, and the front end can be various terminals, such as a desktop computer, a notebook computer, a tablet computer, a smart phone and the like. It is to be appreciated that although only two front ends are shown in FIG. 1, the present example environment may include more front ends.

FIG. 2 is a schematic flow chart of a method of internationalization processing of an embodiment of the present invention. The method shown in fig. 2 may be performed by a backend, the method comprising:

and S110, receiving a derivation request from a front end, wherein the derivation request is input by a front end person according to a template designed and developed by a back end person, and the derivation request comprises at least one tab name and information of a column corresponding to each tab name.

Illustratively, the backend personnel may pre-design templates developed for internationalized export, as well as the set of export columns that can be supported by each tab name. Subsequently, the front-end personnel can acquire the template designed and developed by the back-end personnel in advance and acquire the set of export columns which can be supported by each tab name. The tab name may be, for example, a person, a vehicle, a flower, an address, etc.

The template may be in json format and include at least the following information: column names, key names corresponding to the column names, types, line widths, line heights corresponding to the column names, and attribute information requiring internationalization.

The front-end personnel can input the export request through the filling template, and when the front-end personnel fills the template, the input column information needs to belong to the export column set which can be supported by the corresponding tab name. It can be seen that the front-end personnel enter export requests through the form of participation.

The export request may have an international language specified by the front-end person, and specifically, the tab name and the corresponding column information included in the export request have an international language, such as any one of the international languages of english, japanese, french, and the like, which is the international language selected by the front-end person when participating.

An example of an export request is shown below, where the internationalized language is Chinese. It can be understood that if the front-end person selects another international language, such as english or french, the browser translates the chinese language therein into the corresponding international language to form the corresponding export request.

In the above example, the export request is in parentheses in the outermost layer. Each brace of the outermost layer corresponds to a tab, i.e., [ { } { } { } … ]. The tab name and corresponding column information are included in parenthesis in each outermost layer. Wherein, the name of the sheet is the name of the tab; "exportinfo" denotes export information, which includes a plurality of export columns with parenthesis in the inner layer, and the contents of each column are contained with parenthesis. The above example contains two tabs, a human alert and a vehicle alert, respectively. The human body alarm comprises three columns, namely a target screenshot, a gender and an age. Wherein the gender includes male and female, and the age includes young children, adolescents, middle-aged and elderly. The vehicle alarm comprises three columns, namely a target screenshot, a vehicle type and a license plate number. The vehicle types include cars, SUVs, vans, minivans, pickup trucks, bicycles, electric vehicles, motorcycles, trailers, buses, and tricycles, among others. It is understood that the front end person may adjust the number of tabs by adding or subtracting braces in the outer layer; the number of columns can be adjusted by adding or subtracting braces in the inner layer. Therefore, the embodiment of the invention supports exporting a plurality of tabs at one time, avoids multiple inputs of front-end personnel, and improves user experience.

Illustratively, the front-end person also inputs the query condition at the front-end, so that the receiving of the query condition input by the front-end person from the front-end is also included in S110. For example, the query condition is "Zhang three".

And S120, analyzing the expected export column of the front-end personnel from the export request.

In particular, the back-end may parse the columns from the export request according to the template. In the above example, the corresponding column, i.e., the desired export column of the front-end person, may be obtained from the "title".

S130, inquiring the data needing to be exported.

The back-end may perform filtering according to the query condition received in S110, so as to obtain the data that needs to be exported. Specifically, the query mode is similar to the query mode used in the existing international export, and is not described here again.

S140, generating an export table and uploading the export table to a file server.

A blank table may be first created according to the parsing result in S120, and then the data queried in S130 may be written into the blank table, thereby generating a derived table.

Illustratively, the export table is in excel format. According to the example of the export request described above, the created white space may include two sheets, the first page signature referred to as "human alerts" and the second page signature referred to as "vehicle alerts". The first page has three columns, the column names being the target screenshot, gender and age. The second page has three columns, the column names are respectively the target screenshot, the car type and the license plate number. Subsequently, data is written in the row below each column name.

Illustratively, multiple threads may be employed in writing data. Specifically, a thread pool may be started, a certain amount of data may be allocated to each thread, and data may be written into the excel by a plurality of threads in parallel. In this way, data is written in batches in a multi-thread manner, so that the writing time can be reduced and the efficiency can be improved.

After the data write is complete, an export table is generated, which may then be uploaded to the file server. So that the front-end personnel can download the export form from the file server at any time as required.

Illustratively, the back-end may store a message table for maintaining information for deriving the table. The message table includes the name, download address and status identification of the export table. For example, the message table is in an excel format, and has three columns, where the column names are respectively a name, a download address, and a state identifier; one for each row. The status flag indicates whether the export table has been exported or, understandably, whether the export table is downloadable. For example, a state flag of 1 indicates that the export is complete (downloadable), and a state flag of 0 indicates that the export is incomplete (export is ongoing, not downloadable).

A blank table may be created in S140 and a new row may be added to the message table, specifically, a table name may be added to a column corresponding to the name (i.e., the name of the created blank table), and an addition of 0 to a column corresponding to the status identifier indicates that the export is not completed. Subsequently, after uploading the export table to the file server in S140, the message table is updated. Specifically, the download address may be added to the corresponding location, and changing the state flag to 1 indicates that the export is complete.

S150, sending a message notification to the front end, wherein the message notification is used for indicating that the export is completed.

By sending the message notification to the front end, the front end personnel can timely know that the result is completed, and can download at a proper time. Since the export table can sometimes be large, such as hundreds of megabits (M) or even a few G, the export time may take several minutes or even tens of minutes. During the period, the front-end personnel can possibly execute other operations and inform the operations in progress by a message notification mode, so that on one hand, the operations executed by the front-end personnel are not interrupted, on the other hand, the condition that the export table is sent to the front end in real time to occupy the bandwidth is prevented, and the browser is prevented from being blocked and the like.

After S150, the method may further include: receiving a download request of the front-end personnel from the front end; acquiring a download address of the derived form from the message form according to the download request; downloading the export table from the file server according to the download address; and sending the export table to a front end.

FIG. 3 is a schematic flow chart of a method of internationalization processing of an embodiment of the present invention. The method shown in fig. 3 may be performed by a front end, the method comprising:

s210, obtaining a exporting request input by a front-end person, wherein the exporting request is input by the front-end person according to a template designed and developed by a back-end person, and the exporting request comprises at least one tab name and information of a column corresponding to each tab name.

The backend personnel can predesign and develop templates for internationalized exports, as well as the set of exports columns that each tab name can support. Subsequently, the front-end personnel can acquire the template designed and developed by the back-end personnel in advance and acquire the set of export columns which can be supported by each tab name. The tab name may be, for example, a person, a vehicle, a flower, an address, etc.

An example of an export request may be as described above in connection with fig. 2 and will not be described here.

Illustratively, in S210, the front-end personnel may also input query conditions. For example, the query condition is "Zhang three".

S220, the export request is transmitted to the back end, so that the back end can write data according to the export request.

Illustratively, the export request and the query condition may be transmitted to the backend. Specifically, an export instruction triggered by the front-end personnel may be acquired; and transmitting the export request and the query condition to the back end according to the export instruction.

The form of the export instruction is not limited in the embodiments of the present invention. For example, the front-end person may trigger an export button at the front-end browser, or the front-end person may type an "export" at a particular location of the front-end browser page; and so on.

S230, receiving the message notification of the export completion.

After the back end finishes exporting, the front end is informed by a message notification mode. For example, the front-end personnel may be notified of the message notification at a message center in the upper right corner of the front-end browser.

And S240, downloading the export data from the file server according to the message notification.

Specifically, the method may include: receiving a downloading request of the front-end personnel; sending the download request to the backend so that the backend downloads the export form from the file server; receiving the derived table from the backend.

For example, when a front-end person needs to download the export data, an input download request may be entered and sent to the back-end. The back-end can then determine the download location of the export request by querying its stored message table, and obtain the export table from the download location, which is transmitted by the back-end to the front-end.

FIG. 4 is a schematic interaction flow diagram of internationalization derivation of embodiments of the present invention. The specific steps may be as described in the foregoing with reference to fig. 2 and fig. 3, and are not described herein again.

Fig. 5 is a schematic block diagram of an internationalized processing apparatus according to an embodiment of the present invention. The apparatus 100 shown in fig. 5 may be a backend in the foregoing embodiments, and the apparatus 100 includes a receiving module 101, a parsing module 102, a querying module 103, a generating module 104, and a sending module 105.

The system comprises a receiving module 101, a data processing module and a data processing module, wherein the receiving module 101 is used for receiving a lead-out request from a front end, the lead-out request is input by a front end person according to a template designed and developed by a back end person, and the lead-out request comprises at least one tab name and information of a column corresponding to each tab name;

the analysis module 102 is configured to analyze a desired export column of the front-end person from the export request;

the query module 103 is used for querying data needing to be exported;

the generation module 104 is configured to generate an export table and upload the export table to a file server;

a sending module 105, configured to send a message notification to the front end, where the message notification is used to indicate that the derivation is completed.

As an implementation manner, the receiving module 101 is further configured to receive, from the front end, a query condition input by a front-end person.

As an implementation manner, the query module 103 is specifically configured to perform filtering according to the query condition, so as to obtain the data that needs to be derived.

As one implementation, the generation module 104 includes a generation unit and an upload unit. The generation unit is used for generating a derivation table. The uploading unit is used for uploading the export table to a file server.

The generating unit is specifically configured to create a blank table according to the expected export column; and writing the data needing to be exported into the blank table in a multithreading mode, thereby generating the export table.

As an implementation manner, the backend stores a message table, where the message table includes a name of the export table, a download address of the export table, and a status identifier of the export table, where the status identifier indicates whether the export table has been exported completely.

As an implementation manner, the apparatus 100 may further include a message table maintenance module, configured to record a download address of the export table in the message table, and modify a status identifier of the export table in the message table to indicate that the export is completed.

As an implementation, the apparatus 100 may further include a message processing module. The receiving module 101 may be further configured to receive a download request from the front end by the front end person. The message processing module is used for acquiring a download address of the derived table from the message table according to the download request; and downloading the export table from the file server according to the download address. The sending module 105 may also be configured to send the derived table to a front end.

Illustratively, the template is in object notation json format and at least comprises the following information: column names, key names corresponding to the column names, types, line widths, line heights corresponding to the column names, and attribute information requiring internationalization.

Illustratively, the table is in excel format. Optionally, the export table and the message table are both in excel format.

The apparatus 100 shown in fig. 5 is capable of implementing the aforementioned method of internationalization processing performed by the backend in fig. 2 and 4, and is not described here again to avoid repetition.

Fig. 6 is a schematic block diagram of an internationalized processing apparatus according to an embodiment of the present invention. The apparatus 200 shown in fig. 6 may be a front end in the foregoing embodiments, and the apparatus 200 includes an obtaining module 201, a sending module 202, and a receiving module 203.

An obtaining module 201, configured to obtain a derivation request input by a front-end person, where the derivation request is input by the front-end person according to a template designed and developed by a back-end person, and the derivation request includes at least one tab name and column information corresponding to each tab name;

a sending module 202, configured to transmit the export request to the backend, so that the backend performs data writing according to the export request;

the receiving module 203 is configured to receive a message notification that the export is completed, and download the export data from the file server according to the message notification.

As an implementation manner, the obtaining module 201 may be further configured to obtain a query condition input by the front-end person; and acquiring a leading-out instruction triggered by the front-end personnel. The sending module 202 may be specifically configured to transmit the export request and the query condition to the backend according to the export instruction.

As an implementation manner, the receiving module 203 may be configured to receive a download request of the front-end person. The sending module 202 may be further configured to send the download request to the backend so that the backend downloads the export table from the file server. The receiving module 203 may also be configured to receive the derived table from the backend.

The apparatus 200 shown in fig. 6 can implement the aforementioned method of internationalization processing performed by the front end in fig. 3 and 4, and is not described here again to avoid repetition.

Those of ordinary skill in the art will appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.

In addition, another device for internationalization processing is provided in an embodiment of the present invention, which includes a memory, a processor, and a computer program stored in the memory and running on the processor, where the processor implements the steps of the method for internationalization processing shown in fig. 2 when executing the program.

As shown in fig. 7, the apparatus 70 may include a memory 710 and a processor 720. The memory 710 stores computer program code for implementing the respective steps in the method of internationalizing processes according to the embodiment of the present invention. Additionally, memory 710 may also store templates, message tables, and the like for export requests. The processor 720 is configured to execute the computer program code stored in the memory 710 to perform the corresponding steps of the method of internationalization processing according to the embodiment of the present invention, and to implement the respective modules in the apparatus 100 described in fig. 5 according to the embodiment of the present invention.

Illustratively, the computer program code when executed by the processor 720 performs the steps of: receiving a export request from a front end, wherein the export request is input by a front end person according to a template designed and developed by a back end person, and the export request comprises at least one tab name and information of a column corresponding to each tab name; analyzing the expected export column of the front-end personnel from the export request; querying data needing to be exported; generating an export table and uploading the export table to a file server; sending a message notification to the front end, the message notification indicating that the derivation is complete.

In addition, another device for internationalization processing is provided in an embodiment of the present invention, which includes a memory, a processor, and a computer program stored in the memory and running on the processor, where the processor implements the steps of the method for internationalization processing shown in fig. 3 when executing the program.

The apparatus may include a memory and a processor. The memory stores computer program code for implementing the corresponding steps in the method of internationalizing processes according to an embodiment of the present invention. The processor is configured to execute the computer program code stored in the memory to perform the respective steps of the method of internationalization processing according to the embodiment of the present invention, and is configured to implement the respective modules in the apparatus 200 described in fig. 6 according to the embodiment of the present invention.

Illustratively, the computer program code when executed by the processor performs the steps of: acquiring a lead-out request input by front-end personnel, wherein the lead-out request is input by the front-end personnel according to a template designed and developed by rear-end personnel, and the lead-out request comprises at least one tab name and information of a column corresponding to each tab name; transmitting the export request to the back end so that the back end can perform data writing according to the export request; receiving a message notification that the export is complete; and downloading the export data from the file server according to the message notification.

In addition, an embodiment of the present invention further provides an electronic device, which may include the apparatus 100 shown in fig. 5. The electronic device may implement the aforementioned internationalized processing method shown in fig. 2. For example, the electronic device may be a server.

In addition, an embodiment of the present invention further provides an electronic device, which may include the apparatus 200 shown in fig. 6. The electronic device may implement the aforementioned internationalized processing method shown in fig. 3. For example, the electronic device may be a user terminal.

In addition, the embodiment of the invention also provides a computer storage medium, and the computer storage medium is stored with the computer program. The steps of the method of internationalization processing shown in fig. 2 may be implemented as described above when the computer program is executed by a processor. For example, the computer storage medium is a computer-readable storage medium.

In addition, the embodiment of the invention also provides a computer storage medium, and the computer storage medium is stored with the computer program. The steps of the method of internationalization processing shown in fig. 3 may be implemented as described above when the computer program is executed by a processor. For example, the computer storage medium is a computer-readable storage medium.

The computer storage medium may include, for example, a memory card of a smart phone, a storage component of a tablet computer, a hard disk of a personal computer, a Read Only Memory (ROM), an Erasable Programmable Read Only Memory (EPROM), a portable compact disc read only memory (CD-ROM), a USB memory, or any combination of the above storage media. The computer readable storage medium may be any combination of one or more computer readable storage media, e.g., one computer readable storage medium containing computer readable program code for internationalized processing and another computer readable storage medium containing computer readable program code for internationalized processing.

Although the illustrative embodiments have been described herein with reference to the accompanying drawings, it is to be understood that the foregoing illustrative embodiments are merely exemplary and are not intended to limit the scope of the invention thereto. Various changes and modifications may be effected therein by one of ordinary skill in the pertinent art without departing from the scope or spirit of the present invention. All such changes and modifications are intended to be included within the scope of the present invention as set forth in the appended claims.

In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described device embodiments are merely illustrative, and for example, the division of the units is only one logical functional division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another device, or some features may be omitted, or not executed.

In the description provided herein, numerous specific details are set forth. It is understood, however, that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure an understanding of this description.

Similarly, it should be appreciated that in the description of exemplary embodiments of the invention, various features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the invention and aiding in the understanding of one or more of the various inventive aspects. However, the method of the present invention should not be construed to reflect the intent: that the invention as claimed requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single disclosed embodiment. Thus, the claims following the detailed description are hereby expressly incorporated into this detailed description, with each claim standing on its own as a separate embodiment of this invention.

It will be understood by those skilled in the art that all of the features disclosed in this specification (including any accompanying claims, abstract and drawings), and all of the processes or elements of any method or apparatus so disclosed, may be combined in any combination, except combinations where such features are mutually exclusive. Each feature disclosed in this specification (including any accompanying claims, abstract and drawings) may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.

Furthermore, those skilled in the art will appreciate that while some embodiments described herein include some features included in other embodiments, rather than other features, combinations of features of different embodiments are meant to be within the scope of the invention and form different embodiments. For example, in the claims, any of the claimed embodiments may be used in any combination.

The various component embodiments of the invention may be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. Those skilled in the art will appreciate that a microprocessor or Digital Signal Processor (DSP) may be used in practice to implement some or all of the functions of some of the modules in an item analysis apparatus according to embodiments of the present invention. The present invention may also be embodied as apparatus programs (e.g., computer programs and computer program products) for performing a portion or all of the methods described herein. Such programs implementing the present invention may be stored on computer-readable media or may be in the form of one or more signals. Such a signal may be downloaded from an internet website or provided on a carrier signal or in any other form.

It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and that those skilled in the art will be able to design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention may be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by one and the same item of hardware. The usage of the words first, second and third, etcetera do not indicate any ordering. These words may be interpreted as names.

The above description is only for the specific embodiment of the present invention or the description thereof, and the protection scope of the present invention is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present invention, and the changes or substitutions should be covered within the protection scope of the present invention. The protection scope of the present invention shall be subject to the protection scope of the claims.

Claims

1. A method of internationalization processing, the method comprising:

receiving an export request from a front end, wherein the export request is generated according to input of front-end personnel and an internationalized export template, and the template comprises column names, key names corresponding to the column names, types corresponding to the column names and attribute information needing internationalization; the input of the front-end person is input based on a set of supportable export columns and a supportable internationalized language, the input of the front-end person includes a selected internationalized language, and the export request corresponds to the selected internationalized language; the export request includes at least one tab name and information of a column corresponding to each tab name;

analyzing the information of the expected export column of the front end from the export request as an analysis result according to the template;

creating a blank table according to the analysis result, wherein the blank table comprises a worksheet, the name of the worksheet corresponds to the name of the tab in the export request, and the name of the column in the worksheet corresponds to the column name of the expected export column;

inquiring data needing to be exported according to the analysis result;

writing the inquired data into a row below the corresponding column name in the blank table, thereby generating a derivation table;

uploading the export table to a file server;

2. The method of claim 1, further comprising:

and receiving the query condition input by the front-end personnel.

3. The method according to claim 2, wherein querying the data to be derived according to the parsing result comprises:

and querying the data needing to be exported according to the query condition and the analysis result.

4. The method according to any one of claims 1-3, wherein writing the queried data into a row below a corresponding column name in the blank table, thereby generating a derived table, comprises:

and writing the inquired data into a row below the corresponding column name in the blank table in a multithread mode, thereby generating a derivation table.

5. The method according to any of claims 1-3, wherein a back-end stores a message table comprising a name of the export table, a download address of the export table, and a status identification of the export table, wherein the status identification indicates whether the export table has been exported.

6. The method of claim 5, wherein after uploading the export table to a file server, the method further comprises:

recording a download address of the export table in the message table, and modifying a status flag of the export table in the message table to indicate that export is complete.

7. The method of claim 5, further comprising:

receiving a download request of the front-end personnel from the front end;

and sending the export table to a front end.

8. The method according to any one of claims 1 to 3 and 6 to 7,

the template is in an object numbered notation json format and at least comprises the following information:

column names, key names corresponding to the column names, types, line widths, line heights corresponding to the column names, and attribute information requiring internationalization.

9. The method of claim 1, wherein the export table is in excel format.

10. A method of internationalization processing, the method comprising:

the input of the front-end personnel is acquired,

generating an export request according to input of front-end personnel and an internationalized export template, wherein the template comprises a column name, a key name corresponding to the column name, a type corresponding to the column name and attribute information needing internationalization; the input of the front-end person is input based on a set of supportable export columns and a supportable internationalized language, the input of the front-end person includes a selected internationalized language, and the export request corresponds to the selected internationalized language; the export request includes at least one tab name and information of a column corresponding to each tab name;

transmitting the export request to a back end so that the back end can generate an export table according to the export request and upload the export table to a file server;

receiving a message notification indicating that the export is complete;

downloading the export table from the file server in accordance with the message notification.

11. The method of claim 10, further comprising:

acquiring query conditions input by the front-end personnel;

transmitting the query condition to the backend.

12. The method of claim 10 or 11, wherein downloading export data from a file server comprises:

receiving a downloading request of the front-end personnel;

receiving the derived table from the backend.

13. The method according to claim 10 or 11,

14. The method according to claim 10 or 11, wherein the export table is in excel format.

15. An internationalized processing apparatus configured to implement the steps of the method of any one of claims 1 to 9, the apparatus comprising:

the system comprises a receiving module, a processing module and a processing module, wherein the receiving module is used for receiving an export request from a front end, the export request is generated according to input of front-end personnel and an internationalized export template, and the template comprises column names, key names corresponding to the column names, types corresponding to the column names and attribute information needing internationalization; the input of the front-end person is input based on a set of supportable export columns and a supportable internationalized language, the input of the front-end person includes a selected internationalized language, and the export request corresponds to the selected internationalized language; the export request includes at least one tab name and information of a column corresponding to each tab name;

the analysis module is used for analyzing the information of the expected export column of the front end from the export request as an analysis result according to the template;

the query module is used for querying data needing to be exported according to the analysis result;

a generating module, configured to create a blank table according to the analysis result, where the blank table includes a worksheet, a name of the worksheet corresponds to a tab name in the export request, a name of a column included in the worksheet corresponds to a column name of the desired export column, query data to be exported according to the analysis result, write the queried data in a row below the corresponding column name in the blank table, thereby generating an export table, and upload the export table to a file server;

16. An internationalized processing apparatus configured to perform the steps of the method of any one of claims 10 to 14, the apparatus comprising:

the acquisition module is used for acquiring the input of front-end personnel;

the request generation module is used for generating an export request according to the input of front-end personnel and an internationalized export template, wherein the template comprises column names, key names corresponding to the column names, types corresponding to the column names and attribute information needing internationalization; the input of the front-end person is input based on a set of supportable export columns and a supportable internationalized language, the input of the front-end person includes a selected internationalized language, and the export request corresponds to the selected internationalized language; the export request includes at least one tab name and information of a column corresponding to each tab name;

the sending module is used for transmitting the export request to a back end so that the back end can generate an export table according to the export request and upload the export table to a file server;

a receiving module, configured to receive a message notification indicating that the export is complete, and download the export table from the file server according to the message notification.

17. An apparatus for internationalized processing, comprising a memory, a processor, and a computer program stored on the memory and executed on the processor, wherein the processor implements the steps of the method of any of claims 1 to 14 when executing the computer program.

18. A computer storage medium on which a computer program is stored, which computer program, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 14.