JP2013175094A - Data search system and method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To constitute a data search screen of a plurality of languages, and to search for and download data by using the search screen.SOLUTION: On the basis of the content of an item name master table in which the format of the display of a screen is set, a download master table in which a display item is set about data to be downloaded and a language master table in which item display language is set, the display item of the data to be downloaded is set, and a list screen on which item names are displayed is created. On the basis of the content of a search condition setting master table in which search conditions are set and an item name master table and a component table in which components constituting the screen are registered, a search screen on which the item name of the set search conditions is displayed in selected language is created. On the basis of the search conditions set by the search condition setting master table, SQL is executed to data obtained by searching the search object master table by referring to a download SQL master table, and the download data are displayed in the selected language.

Description

  The present invention relates to a data search system and method, and more particularly, to a data search and download system and method for dynamically downloading data by constructing a multilingual data download function.

It is routinely performed that the data of the center server is searched by operating the terminal screen and downloaded to the terminal, the data is displayed on the terminal screen for browsing, or the data is used for business processing. .
Regarding data retrieval, Patent Document 1 discloses a system for retrieving data using item names held in a master table. In particular, in the technology of Patent Document 1, the search unit searches the name including the pre-change name held in the name change master table from the screen data, and when the name is searched, the change unit selects the pre-change name, The searched name included in the screen data is changed by referring to the name change master table and replacing it with the changed name corresponding to the pre-change name.

  In general, when building a data download function, a developer develops a data search screen and a download function by using hard coding or a tool. When adding a new item to an existing screen, the developer is familiar with the programming language and mechanism, so that the screen correction work is easy, but it is difficult for anyone other than the developer.

  Regarding the change of the display data on the screen, for example, Patent Document 2 reads a form definition reading unit that reads a form definition file in which data items displayed on the processing screen and attributes indicating the properties of the data items are described. An information processing system is disclosed in which customization work can be easily performed without modifying program code by dynamically changing the contents displayed on the processing screen based on the contents.

JP 2011-203981 A JP-A-11-212694

  However, Patent Document 1 describes that data is searched using a master table, but that data is searched using a plurality of masters organically, and a multilingual data download function. There is no suggestion about data retrieval using.

  Further, in a search and download system that handles multiple languages, it is necessary to prepare a screen translated into each language for each language, but doing so increases the administrative effort as the number of screens increases. Even if the modification of the screen and the change of the display data are facilitated by the technique of Patent Document 2, no specific measures can be found as to how to deal with a multilingual system.

  An object of the present invention is to provide a data search system and method that can configure a data search screen in a plurality of languages using a plurality of master tables, and search and download data using the data search screen. is there.

The data search system according to the present invention is preferably a data search system that searches a search target master table according to an instruction from a search screen and downloads search data by executing a program on a server.
The item name master table that sets the display format of the screen for common items used in the system, the download master table that sets display items for the data to be downloaded, and the language master table that sets the language for displaying items A list screen creation processing unit for setting a display item of data to be downloaded based on the content, and creating a list screen for displaying the item name in the selected language;
Search that is set based on the contents of the search condition setting master table that sets search conditions for the search target data, the item name master table, the language master table, and the parts table that registers the parts that make up the screen A search screen creation processing unit for creating a search screen for displaying the condition item names in the selected language;
Based on the search conditions set by the search condition setting master table, refer to the download SQL master table for setting SQL for the data obtained by searching the search target master table for registering the search target data. It has a download data creation processing unit that executes SQL and creates download data, and is configured as a data search system that displays the download data in a selected language for a set item .
Moreover, it is comprised as a data search method which performs the said processing function.

  According to the present invention, a data search screen can be configured in a plurality of languages using a plurality of master tables, and data can be searched using a download function. In addition, it is possible to realize a multilingual search download system in which master items can be easily added and changed.

1 is an overall configuration diagram showing a download system according to an embodiment. The flowchart which shows the processing operation of the download system in one Example. The flowchart which shows the production | generation operation | movement of the list screen in one Example. The flowchart which shows the creation operation of the search screen in one Example. The flowchart which shows the creation operation of the download data in one Example. The figure which shows the example of the list screen in one Example. The figure which shows the example of the search screen in one Example. The figure which shows the example of the download file in one Example. The figure which shows the structural example of the components table 115 in one Example. The figure which shows the structural example of the list setting master table 108 classified by authority in one Example. The figure which shows the structural example of the download master table 109 in one Example. The figure which shows the structural example of the search condition setting master table 110 in one Example. The figure which shows the structural example of the download SQL master table 111 in one Example. The figure which shows the structural example of the item name master table 112 in one Example. The figure which shows the structural example of the supplier master table 113 in one Example. The figure which shows the structural example of the language master table 114 in one Example.

Hereinafter, an embodiment of the present invention will be described with reference to the drawings.
FIG. 1 shows the overall configuration of a data search and download system.
The data search and download system 104 is constructed in the server 103, and the server 103 is connected to a terminal such as a PC (personal computer) 101 via the network 102 to constitute the entire data search and download system.

  The data search and download system 104 implements the processing functions of the list screen creation processing unit 105, the search screen creation processing unit 106, and the download data creation processing unit 107 by executing a program on the server 103. Further, the data search and download system 104 includes an authority-specific list setting master table 108, a download master table 109, a search condition setting master table 110, a download SQL master table 111, an item name master table 112, a supplier master 113 table, a language master. Each table includes a table 114 and a component table 115. The configuration of these tables will be described later with reference to FIGS.

  The data search and download system 104 creates a list screen (see FIG. 6) and a search screen (see FIG. 7) by the list screen creation processing unit 105 and the search screen creation processing unit 106 using the various master tables. The created list screen and search screen are transferred to the PC 101 via the network 102 and displayed on the screen. The operator can download multilingual data by operating the input device using the search screen displayed on the PC.

Next, configuration examples of the list screen and the search screen will be described with reference to FIGS. 6 and 7.
FIG. 6 shows an example of the list screen 600.
The list screen 600 is a screen that displays a download number, a download name, and a download comment for downloadable files. (A) is a screen before condition setting, (B) is a Japanese screen, and (C) is an English screen.

  The list screen of (A) includes a language selection area and a list output area. The display items on the list screen are No, download number, download name, and download comment. For language selection, any one of three types of Japanese, English, and local languages can be selected by a pull-down method.

  (B) is a screen for Japan, and the item name list is displayed in Japanese. Similarly, in the screen for English in (C), the item name list is displayed in English. The operator can select a download number (NO) by operating the input device.

FIG. 7 shows an example of the search screen 700.
(A) shows a screen before setting search conditions, and (B) and (C) show search screens after setting search conditions. (B) is a screen for Japanese, and (C) is a screen for English.
The (A) search screen 700 is a screen for setting search conditions for searching for a file to be downloaded. As search conditions, 10 search conditions are displayed in the search condition area, and by specifying a number of “1-10” corresponding to the search conditions 1-10, one search condition can be selected. In addition, a pull-down language selection area is set, and one of three types of Japanese, English, and local language can be selected.

  Regarding the search screens (B) and (C) after setting the search conditions, in the example shown in the figure, the operator operates the input device (not shown) of the PC 101, and the search condition from the screen of (A) is “business partner”. ”And“ Office ”. The operator can search by inputting a desired search code into the search area. (B) is a screen for Japanese, and the language selection pull-down on the pre-search setting screen can be selected to set the search screen item to Japanese. Similarly, when English is selected as shown in (C), the search item can be set to be displayed in English. In the illustrated example, there are two search items. However, the search items are not limited to this, and more search items may be set.

FIG. 8 shows an example of a download file.
It is an example of the screen which displays the data (downloaded file) searched by the conditions searched by the conditions of the search screen shown in FIG. (A) is a download file display screen for Japanese, and the header item is displayed in Japanese. (B) is a file for English, and header items are displayed in English as in Japanese. The downloaded file is displayed in Japanese or English, corresponding to the header items of business office, business partner, business partner name (English and local language), business partner address (English and local language). Displayed in the data section.

Next, a configuration example of each table will be described with reference to FIGS.
As shown in FIG. 9, the parts table 115 is a table for registering parts constituting a list screen and a search screen. The parts table 115 is a part code indicating a search condition part, a part item name indicating a part item name, It consists of each item of explanation that explains the type of item input. The part item name has an area (a space on the right side of the item name) for inputting or selecting the item name of the part. For example, the text box format input component has an area in which the component code is “1201”, the component item name, the item name guidance on the left side, and the item name is input on the right side. Also, the pull-down selection type input component has a component code “1202”, a component item name, an item name guidance on the left side, and an item name area to be pulled down on the right side.

  As shown in FIG. 10, the authority-specific list setting master table 108 sets searchable operator authority, and includes an enterprise code indicating the operator's company and an establishment code indicating the operator's office. And an authority code indicating the authority of the operator and a download number indicating a download data number for identifying the download data.

  As shown in FIG. 11, the download master table 109 is for setting data to be downloaded and display items thereof, a download number for specifying a download data number, and a language for identifying a registration language of information. Each item includes a code, a download name that indicates the name of the download data, a download comment that is an explanation regarding the download data, and a download item name that indicates an item name for setting in the header portion of the download data. For example, when the download number “X17” is specified, the display item of the header is displayed in English (ENG), the download name is “Supplier Master”, and the download item name is “Division, Supplier, Supplier Name,. Selected and displayed.

  As shown in FIG. 12, the search condition setting master table 110 is for setting search conditions for data to be searched. The download NO indicating the number of download data and the location where the search condition parts are set are shown. The search condition NO, the input item name indicating the setting of the variable to be stored when the input condition value is interfaced to the program, the item name for setting the item name of the item name to be displayed on the screen, and the search condition part It consists of each item of the component code shown (FIG. 9). As the search condition, one or a plurality of numbers corresponding to the search conditions 1 to 10 displayed on the search screen (FIG. 7A) is designated.

  As shown in FIG. 13, the download SQL master table 111 is for setting the SQL to be executed for the data to be downloaded. The download SQL master table 111 is an execution indicating the download NO indicating the download data number and the download data extraction SQL. It consists of each item of SQL.

  As shown in FIG. 14, the item name master table 112 sets a display format for common items used in the system, and includes item names indicating common items used in the system. Each item includes a language code for identifying a registered language of information and an item name indicating the display content of each item name in each language.

As shown in FIG. 15, the supplier master table 113 is a database for registering data to be searched. In this embodiment, since the data to be searched is a file related to a business partner of a company, a company code indicating the operator's company, a business office code indicating the operator's business office, and a business partner are shown as a business partner master. Register each item of supplier code, supplier name (English), supplier name (local language “English, Chinese, Japanese, etc.”), address (English), and address (local language) doing. As a result of the search, the file of this item is downloaded and becomes the data part shown in FIG.
Note that there are various types of data to be searched, not limited to the supplier master. For example, in terms of corporate activities, there are a personnel master, a salary master, a material order master, a payment master, etc. used in personnel management. Therefore, in general, it can be said that it is a search target master including an example supplier master.

  As shown in FIG. 16, the language master table 114 sets the language for displaying items, and is composed of items of a language code for identifying a registered language of information and a language name indicating the name of the language. The language is set to English, Japanese, Chinese or the like.

Next, processing operations of the data search / download system 104 will be described with reference to FIGS.
FIG. 2 is a flowchart showing the overall processing of the data search / download system 104.
In the list screen creation process (S201), the list screen 600 is created based on the contents of the item name master table 112, the authority-specific list setting master table 108, the download master table 109, and the language master table 114. Details of this processing will be described in detail with reference to FIG.

  In the download number selection (S202), it is determined whether the “download NO” item has been selected on the list screen 600. If there is a selection, the process proceeds to the search screen creation process (S203). On the other hand, if the “download NO” item is not selected, the process proceeds to list screen creation (S201).

  In the search screen creation process (S203), the search screen 700 is created based on the contents of the search condition setting master table 110, the item name master table 112, the language master table 114, and the parts table 115. Details of this processing will be described in detail with reference to FIG.

  Thereafter, when a “back” button is pressed on the search screen 700 (S204), the process proceeds to a list screen creation process (S201). On the other hand, if the “return” button is not pressed, the process proceeds to the “download” button pressing determination (S205). When the “download” button is pressed (S205), the process proceeds to download data creation processing (S206). On the other hand, if the “download” button is not pressed, the process proceeds to list screen creation processing (S201).

  In the download data creation process (S206), download data (S207) is created based on the contents of the search condition setting master table (110), the download SQL master table (111), and the supplier master table (113). Details of this processing will be described in detail with reference to FIG.

Next, the list screen creation process (S201) will be described in detail with reference to FIG.
In the item takeover from the previous screen (S301), the “company code”, “office code”, “authority code”, and “language code” are taken over from the previous screen.
In the language selection pull-down setting (S302), the contents of the language master table 114 are read, and “language code” and “language name” are acquired and set in the language selection pull-down on the list screen 600. The language selection pull-down screen displays the “language name” acquired using the “language code” inherited from the previous screen as a key. When “language code” = “JPN”, “language name” = “Japanese” is acquired.
Next, “1” is set to the counter value in the initial setting of the counter (S303).

  In the setting of “DOWNLOAD_NO” (S304), “DOWNLOAD_NO” is set to “item name”. That is, the item name master table 112 is read using “item name” + “language code” as a key, and “item name” is acquired. The acquired “item name” is set to “DOWNLOAD_NO” on the list screen 600. When “item name” = “DOWNLOAD_NO” + “language code” = “JPN”, “item name” = “download NO” is acquired.

In the setting of “DOWNLOAD_NAME” (S305), “DOWNLOAD_NAME” is set to “item name”. That is, the item name master table 112 is read using “item name” + “language code” as a key, and “item name” is acquired.
The acquired “item name” is set in “DOWNLOAD_NAME” of the list screen 600. When “item name” = “DOWNLOAD_NAME” + “language code” = “JPN”, “item name” = “download name” is acquired.

  In the setting of “DOWNLOAD_COMMENT” (S306), “DOWNLOAD_COMMENT” is set to “item name”. That is, the item name master table 112 is read using “item name” + “language code” as a key, and “item name” is acquired. The acquired “item name” is set in “DOWNLOAD_COMMENT” of the list screen 600. When “item name” = “DOWNLOAD_COMMENT” + “language code” = “JPN”, “item name” = “download comment” is acquired.

  In the acquisition of “download NO” (S307), the authority-specific list setting master table 108 is read using “company code” + “office code” + “authority code” as a key, and “download NO” is acquired. In the case of “company code” = “B5000” + “office code” = “001” + “authority code” = “BUYER”, the first “download NO” = “X17”, the second “download NO” = “X18” is acquired.

  In the setting of the list output area (S308), the download master table (109) is read using the obtained “n” “download NO” + “language code” as a key, and “download name” and “download comment” are obtained. . Then, “n”, “download NO”, “download name”, and “download comment” are set in the nth line of the list output area of the list screen 600. In the case of (n = 1), “Download No.” = “X17” + “Language Code” = “JPN” as a key, “Download Name” = “Customer Master Table”, “Download Comment” = “Transaction The destination information list will be downloaded.

In the counter count-up (S309), n + 1 is set as the counter value.
In the output data determination (S310), it is confirmed whether there is data to be output to the list output area of the list screen 600 (nth “download NO”). If there is data as a result of the confirmation, the process proceeds to list output area setting (S308). On the other hand, if there is no data, the process ends.

In the language change determination (S311), it is confirmed whether there is a change in the display content of the language selection pull-down on the list screen 600. If the language is changed as a result of the confirmation, the process proceeds to language code setting (S312). On the other hand, if there is no language change, the process ends.
In the language code setting (S312), when the operator operates the input device, the “language code” of “language name” displayed in the language selection pull-down of the list screen 600 is changed to “language code” of the screen takeover item. Set to. Thereafter, the process proceeds to initial counter setting (S303).

Next, the search screen creation process (S203) will be described in detail with reference to FIG.
In the item takeover from the previous screen (S401), "download NO" and "language code" are taken over from the previous screen.
In the language selection pull-down setting (S402), the language master table 114 is read, and “language code” and “language name” are acquired. The acquired “language code” and “language name” are set in the language selection pull-down of the list screen 600. The language selection pull-down screen displays the “language name” acquired using the “language code” inherited from the previous screen as a key. When “language code” = “JPN”, “language name” = “Japanese” is acquired.

Next, “1” is set to the counter value in the initial setting of the counter (S403).
In each item acquisition of the search condition setting master table (S404), the search condition setting master table 110 is read using “download NO” as a key, and “search condition NO”, “item name”, and “part code” are acquired. When “Download No” = “X17”, the first item (“Search Condition NO” = “1”, “Item Name” = “SUPL_CD”, “Part Code” = “1201”), Second Item (“Search Condition NO ”=“ 2 ”,“ item name ”=“ DIV_CD ”, and“ part code ”=“ 1201 ”are acquired.

  In “part” setting in the search condition area (S405), “part code” with “search condition NO” = n is selected. "Part code" is acquired using "Part code" as a key. “Parts” is set in “search condition n” in the search condition area of the search screen 700. When n = 1 of “search condition NO”, “part” of “part code” = “1201” is set as “search condition 1” in the search condition area.

  In the setting of “component item name” (S 406), “item name” with “search condition NO” = n is selected. That is, the item name master table (112) is read using “item name” + “language code” as a key to obtain “item name”. Then, “item name” is set to “part item name” of “search condition n” in the search condition area. When n = 1, “item name” = “business partner” is acquired using “item name” = “SUPL_CD” + “language code” = “JPN” as a key, and “search condition 1” in the search condition area is “ Set to “Part Item Name”.

In the counter count-up (S407), the counter value n is updated to n + 1.
In the output data determination (S408), the existence of data to be output to the search condition area (nth “search condition NO”) is confirmed. If there is data as a result of the confirmation, the process proceeds to “part” setting (S405) in the search condition area. On the other hand, if there is no data, the process ends.

  In the language change determination (S409), it is confirmed whether there is a change in the display content of the language selection pull-down on the list screen 600. If it is determined that there is a language change, the process proceeds to language code setting (S410). On the other hand, if there is no language change, the process ends. In the language code setting (S410), the “language code” of the “language name” displayed in the language selection pull-down on the list screen 600 is set as the “language code” of the screen takeover item. Thereafter, the process proceeds to initial counter setting (S403).

Next, the download data creation process will be described in detail with reference to FIG.
In the item takeover from the previous screen (S501), "company code", "office code", "language code", and "download NO" are taken over from the previous screen.
In the work variable setting of the takeover item (S502), each item taken over from the previous screen is set as a work variable. For example, when “company code” “R_CMPY_CD” is “B5000” and “office code” “R_DIV_CD” is “001”, R_CMPY_CD = “B5000” and R_DIV_CD = “001” are set.

Then, “1” is set to the counter value in the initial setting of the counter (S503).
In each item acquisition of the “search condition setting master table” (S504), the search condition setting master table (110) is read using “download NO” as a key, and “search condition NO” and “input item name” are acquired. For example, when “download NO” = “X17”, the first item (“search condition NO” = “1”, “input item name” = “I_SUPL_CD”), the second item (“search condition NO” = “2”) “,“ Input item name ”=“ I_DIV_CD ”) is acquired.

  In the variable creation of “input item name” (S505), “input item name” with “search condition NO” = n is selected. A variable is created with the value of this “input item name”. When “search condition NO” = “1”, “input item name” = “I_SUPL_CD”, and variable = I_SUPL_CD is created.

  In the variable setting of the screen input value (S506), the value input / set in the component input area of the search condition area “search condition n” of the search screen 700 is set to the variable created with the value of “input item name”. When n = 1, when the input value of “search condition 1” is “AA01”, “AA01” is set in the variable I_SUPL_CD.

Then, the counter value n is updated to n + 1 in the counter count-up (S507).
Thereafter, in the existence determination (S508) of the search condition n, it is confirmed whether or not “search condition n” (nth “search condition NO”) in the search condition area of the search screen 700 exists. As a result of the confirmation, if there is data of the search condition NO, the process proceeds to the variable creation of “input item name” (S505). On the other hand, if there is no data, the process proceeds to acquisition of each item of the “download SQL master table” (S509).

In each item acquisition (S509) of the “download SQL master table”, the download SQL master table (111) is read using “download NO” as a key, and “execution SQL” is acquired.
For example, when “Download NO” = X17,
"Execution SQL" = / * X17 * / SELECT
A. Office code,
A. Supplier code,
A. Status flag,
A. Business partner name (English),
A. Supplier name (local language),
A. Business address (English),
A. Business address (local language),
FROM Partner Master Table A
WHERE A. Company code =: R_CMPY_CD
AND (A.Partner code =: I_SUPL_CD OR: I_SUPL_CD IS NULL)
AND (A. Office code IN =: I_DIV_CD: I_DIV_CD IS NULL)
To get.

  In the download header part output (S510), the download master table 109 is read using “download NO” + “language code” as a key, and “download item name” is acquired. Then, the “download item name” is output to the download data 207. For example, when “Download NO” = “X17” and “Language Code” = “JPN”, “Download Item Name” = “Office”, “Business Partner”, “Business Partner Name (English)”, “Business Partner Name” (Local language) "," Business partner address (English) "," Business partner address (Local language) ", and" Status flag "are output to the header of the download file sample (FIG. 8).

  In the download data portion output (S511), the SQL statement “execution SQL” is executed, and the execution result is output to the download data 207. The execution result is output to the data portion (FIG. 8) of the download file and displayed on the screen as shown in FIG.

  As described above, according to the present embodiment, it is not necessary to manage a plurality of screens for each language, and when the number of languages is increased, it is possible to cope by registering a master table. By adding a multilingual data search and download system according to the present invention to a conventional system that does not target multiple languages, only the download function part can be made multilingual. Even if you do not have programming language knowledge, if you have SQL knowledge, you can easily change the data search screen, download function construction, item addition, etc. by simply registering the master table, and it will be reflected dynamically in the system The

  In addition, this invention is not limited to the said Example, A various deformation | transformation can be implemented. As described above, the supplier master that is the object of the data search is an example, and various data search downloads can be handled by changing the master as the search target master.

101: PC
102: Network 103: Server 104: Data search download system 105: List screen creation processing unit 106: Search screen creation processing unit 107: Download data creation processing unit 108: List setting master table by authority 109: Download list master table 110: Search Condition setting master table 111: Download information master table 112: Item name master table 113: Supplier master table 114: Language master table 115: Parts table

Claims (3)

A data search system that searches a search target master table according to an instruction from a search screen and downloads search data by executing a program on a server,
The item name master table that sets the display format of the screen for common items used in the system, the download master table that sets display items for the data to be downloaded, and the language master table that sets the language for displaying items A list screen creation processing unit for setting a display item of data to be downloaded based on the content, and creating a list screen for displaying the item name in the selected language;
Search that is set based on the contents of the search condition setting master table that sets search conditions for the search target data, the item name master table, the language master table, and the parts table that registers the parts that make up the screen A search screen creation processing unit for creating a search screen for displaying the condition item names in the selected language;
Based on the search conditions set by the search condition setting master table, refer to the download SQL master table for setting SQL for the data obtained by searching the search target master table for registering the search target data. A data search system that executes SQL and displays download data in a selected language for a set item with a download data creation processing unit that creates download data. The part table registers a part code indicating a search condition part, a part item name indicating an item name of the part, and an explanation explaining the type of item input of the part,
The download master table includes a download No that specifies a download data number, a language code that identifies a registration language of information, a download name that indicates the name of the download data, a download comment that is an explanation regarding the download data, and a download Register the download item name indicating the item name for setting in the header part of the data,
The search condition setting master table includes a download NO indicating a download data number, a search condition NO indicating a position where a search condition part is set, and a variable stored when an input condition value is interfaced to a program. Register the input item name to be displayed, the item name to set the item name of the item name to be displayed on the screen, and the part code indicating the search condition part,
The download SQL master table registers a download NO indicating download data number and an execution SQL indicating download data extraction SQL,
The item name master table registers an item name indicating a common item used in the system, a language code for identifying a registration language of information, and an item name indicating display contents for each language of the item name,
The search target master table registers items related to data to be searched in a plurality of languages.
The data search system according to claim 1. A data search method for searching a search target master table according to an instruction from a search screen and downloading search data by executing a program on a server,
The item name master table that sets the display format of the screen for common items used in the system, the download master table that sets display items for the data to be downloaded, and the language master table that sets the language for displaying items A list screen creation processing step for setting a display item of data to be downloaded based on the content, and creating a list screen for displaying the item name in the selected language;
Search that is set based on the contents of the search condition setting master table that sets search conditions for the search target data, the item name master table, the language master table, and the parts table that registers the parts that make up the screen A search screen creation processing step for creating a search screen for displaying the condition item names in the selected language;
Based on the search conditions set by the search condition setting master table, refer to the download SQL master table for setting SQL for the data obtained by searching the search target master table for registering the search target data. A data search method comprising: a download data creation processing step section for executing SQL and creating download data, and displaying the download data in a selected language for a set item.

Images