JP5297666B2 - Data creation support system for primary key transfer / numbering device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data origination support system for a main key transfer-numbering device stably usable in a system while reducing origination load by supporting data origination concerning main key transfer-numbering through a menu screen and a maintenance screen. <P>SOLUTION: All items of new and old data are compared in a procedure 1. In a procedure 2, the registration numbers of the new and old data are compared concerning application information with changes. In a procedure 3, designated items are compared for the new and old data with application information classified not to be new/invalid but to be change. The new and old data are assumed to be the same on all the items to proceed to a procedure 4. When items with different meanings exist among the items, the application information are assumed to be new/invalid to proceed to a procedure 5. In the procedure 4, when the new and old data are 1:1 and are determined to be the same out of the new and old data assumed to have the same application information, all the items are compared, and different items are changed and output. In other cases, proceed to the procedure 5. In the procedure 5, a person in charge determines whether the new and old application data are the same on the maintenance screen. <P>COPYRIGHT: (C)2010,JPO&amp;INPIT

Description

  The present invention relates to a data creation support system for a primary key transfer / numbering device that enables the system to stably use application information provided by the National Agriculture, Forestry and Fisheries Consumption Safety Technology Center.

  In the JA group (National Agricultural Cooperative Federation, etc.), a farming instructor provides technical guidance on agricultural production and farm management of JA affiliated members. The main task of farming instructors is to provide farming guidance while referring to pesticide information and pest information in agricultural technology patrol guidance.

  All pesticides used in Japan are managed centrally by the Ministry of Agriculture, Forestry and Fisheries, which is a national government agency. The management period of agricultural chemicals is obliged to be 3 years, and agricultural chemicals are subject to changes in the crops, pests and weeds to be used, and the usage method is often changed according to the setting of residual standard values. Agricultural, forestry and fisheries consumption safety technology center provides agricultural chemical registration information using website. Farming instructors need to keep track of the information on pesticides managed by the Ministry of Agriculture, Forestry and Fisheries by constantly browsing the website.

  Pesticide information managed by the Ministry of Agriculture, Forestry and Fisheries is also used for services provided on the website. For example, the National Federation of Agricultural Cooperatives provides a service related to pesticide information under the name “Appines”. Appiness has a site for personal computers and a site for mobile phones.

Under such circumstances, the following Patent Document 1 is provided with an appropriate use condition storage unit that stores appropriate use conditions for agricultural materials in the apparatus, and is transmitted from a terminal possessed by the user of the agricultural materials. Appropriate use of agricultural materials planned in the use plan is determined using the appropriate use conditions stored in the appropriate use condition storage unit, and the determined use of agricultural materials is transmitted to the terminal to use the agricultural materials. An agricultural material use suitability determination device that provides information on whether or not an agricultural material used by a person meets usage conditions before use of the agricultural material is disclosed.
JP 2005-063239 A

  By the way, since the application information included in the pesticide registration information provided by the National Agriculture, Forestry and Fisheries Consumption Safety Technology Center is frequently updated, it was collected last time even if the latest application information was collected from the website. Since it is not easy to know the application information and where it has changed, it is necessary to change the data collected each time to the latest to use it in the system. As a result, the system once constructed cannot be used stably.

  The pesticide registration information provided by the Agricultural, Forestry and Fisheries Consumption Safety Technology Center is generally used as a data source for production history management systems in the agricultural field, but there is no primary key that uniquely defines pesticide application information. In the subsequent use of data, there was a fatal problem that the changes could not be identified.

  In the application information, when trying to uniquely narrow down without using the primary key, about 13 items (of 25 items) of the application information must be made unique keys, and there are many items that include important changes in the unique keys. It is not an exaggeration to say that this change cannot be detected and it is virtually impossible to use the application information in the system.

  Further, the agricultural material use propriety determination device disclosed in Patent Document 1 maintains application information that is frequently updated in its own system and provides the application information to the user of the agricultural material. Time and labor.

  Therefore, in the present invention, data creation related to primary key change / numbering is supported through the menu screen and the maintenance screen to reduce creation load, and data creation support for primary key change / numbering device that can be stably used in the system. The purpose is to provide a system.

In order to solve the above-mentioned problems, the data creation support system for the primary key transfer / numbering device of the present invention is applied to registration in the pesticide registration information by the person in charge operating the data capture of the menu screen displayed at the time of system startup. Data initialization processing means for capturing the data of the application unit (application information) into the database as new data and processing the data of the registration application unit that was previously captured and processed in the database as old data; Primary key that was numbered separately at the time of data acquisition of old data by comparing all items except the application code and registration renewal date to identify new data that is exactly the same, Can be specified by comparing the primary key transfer means for transferring the data as the primary key of the new data, and all items except the application code and the registration renewal date Said comparing the registration number of the old and new data, handling as new data when the registration number is not in the old data is present in the new data, the handling is as stale data in the case where there is no registration number to the new data is present in the old data In the new and old data that could not be specified by comparing the registration number with primary key numbering / revocation flag setting means for assigning a new primary key to the new data and setting a revocation flag for the revocation data, For each registration number, the designated items consisting of items corresponding to the conditions when using the agricultural chemicals of the registration application unit are compared one by one, the designated items of the old and new data are regarded as matching, and the number of the old and new data Is 1: 1, the new and old data are identified as the same data, the primary key of the old data is transferred to the new data, and the specified item and the registration application unit Primary key transfer / change point output means for outputting items with changes as changes in all items including items that fall under the criteria for use of medicines, and designations that meet the conditions for using pesticides in the registration application department the old and new data can not be identified by comparison of the item, when identifying whether personnel are the same in the data maintenance process using the maintenance screen, have been identified as the same data is primarily at the direction of the person If the key is transferred and is not identified as the same data, if it is not in the old data but is present in the new data, it is treated as new data. handling the numbered with a representative new primary key to the new data in the instruction, and a data maintenance processing means for setting the revocation flag in the stale data It is characterized in.

When the person in charge operates the consent check table registration button after the old and new data displayed on the maintenance screen have the same contents, the consent check table registration screen is displayed. The person in charge operates the registration button , and the contents are reflected in the agreement / non-agreement check table.

According to the present invention, the operation can be started only by operating the button displayed on the menu screen by the person in charge , and the menu screen can be further shifted to the next processing by one processing completion display displayed on the screen. In addition, it is possible to support creation of data related to primary key transfer / numbering through the maintenance screen to reduce the creation load and to stably use the system. Moreover, since the data content is displayed on the maintenance screen for the continuous identification of the data of the pesticide registration information (agricultural chemical application section) that is constantly changing, it is possible to visualize the data creation support related to the transfer and numbering of the primary key.

  In addition, by registering the contents of consent / non-consent, information that is repeatedly changed in the same pattern can be processed in a lump, and the maintenance load can be reduced.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings.

  FIG. 1 is a block diagram showing a configuration of a data creation support system for a primary key transfer / numbering device according to an embodiment of the present invention. In the figure, a data creation support system for a primary key transfer / numbering device according to an embodiment of the present invention includes a data import processing unit 101, a database 102, a data expansion processing unit 103, a primary key transfer processing unit 104, and a data maintenance process. A consent check table registration processing unit 106 having a unit 105 and a consent check table 107 is provided.

  The data capture processing unit 101 captures and processes the registration application unit 311 in the agricultural chemical registration information provided from the above-mentioned Agriculture, Forestry and Fisheries Consumption Safety Technology Center as input information. At this time, it is possible to refer to the old registration application unit expansion data (see FIG. 15) that has been processed last time and stored in the database 102. The registration application unit 311 in the agricultural chemical registration information provided by the Agriculture, Forestry and Fisheries Consumption Safety Technology Center includes a registration basic unit (see FIG. 13) and a registration application unit (see FIG. 14). Since there is no “primary key” information in the registration application unit 311, an item “application code” is created in the postscript registration application unit expanded data, which is a working table, in this specification, The “key” is “registration number + application code” (hereinafter the same).

In the database 102, in addition to the registration basic part (see FIG. 13) and the registration application part (see FIG. 14) taken in by the data take-in processing part 101 , the above-mentioned old registration basic part expanded data processed so far (See FIG. 12), old registration application section expansion data (see FIG. 15), maintained registration application section (see FIG. 16), change point output table (see FIG. 17), final application code master (see FIG. 18), registration Basic part development data (see FIG. 19), registration application part development data (see FIG. 20), and the like are stored.

  As will be described later, the data fetch processing unit 101 copies the registration basic part expansion data (see FIG. 19) stored in the database 102 and expands the old registration basic part expansion data (see FIG. 12). Copy the maintained registration application part (see FIG. 16), move the data to the old registration application part development data (see FIG. 15), and use the registration basic part (see FIG. 13) to register basic part development data (FIG. 19). The data is moved to the registration application section development data (see FIG. 20) using the registration application section (see FIG. 14), and the application code, revocation flag, update date, etc. are displayed. Used for attaching work.

  The primary key transfer processing unit 104 divides the items of the registration application unit (see FIG. 14) acquired by the data acquisition processing unit 101 into groups 1 and 2 shown below, and stores the old data stored in the database 102. Between the old registration application unit expansion data (see FIG. 15) as data and the registration application unit expansion data (see FIG. 20) as new data moved from the registration application unit (see FIG. 14). For each registration number, the new and old data are compared for each item of group 1 and group 2 to identify the data. If the data is changed, the new data (registered application development data) is replaced with the old data (old registration application development data). Transfer the application code. Note that the data specification means that the information included in the registered application development data is newly registered new data, changed data whose contents are the same as the previous data but partially changed, or previously existing data. It is to determine which of the revocation data is lost. In this case, the item comparison mechanically compares the character strings with the system (described later), but mechanical character string comparison between the new data (registered application development data) and the old data (old registration application data). Then, even if the judgment results are different, there are cases where the meaning is the same (this is referred to as consent, hereinafter the same) when viewed by a person, and the consent check table 107 (see the table in FIG. 21) is taken into account in that case. The consent is also determined mechanically with reference. It should be noted that performing the consent determination mechanically includes that the disagreement determination can be performed mechanically with reference to the disagreement check table (see classification = 1 in the table of FIG. 21). These will be described later.

Here, the grouping of items in the registration application unit (see FIG. 14) will be described. Group 1 is classified into groups that meet the conditions for use in determining pesticide use standards, and includes the following items (referred to as designated items). That is,
・ Crop name ・ Applicable pest and weed name ・ Usage method ・ Applicable zone name ・ Purpose of use ・ Place of application ・ Applicable soil For pesticides that can be used for food crops (including feed crops), for example, according to the Ordinance of the Ministry of Fisheries, (1) Applicable crops, (2) Use per unit It is required to observe the maximum volume limit or minimum dilution factor, (3) time of use, and (4) total number of uses.

  From such a background, the usage standard is determined by conditions actually used (applicable pest, usage method, application zone, etc.). When conditions for using pesticides (applicable pests, methods of use, application zones, etc.) are uniquely determined, the value of the use standard is determined. Specifically, it is first determined under what conditions it is actually used, and a usage standard is set for the specified conditions. Furthermore, when the conditions for using pesticides are uniquely determined, the number of new and old application information usually corresponds at a ratio of 1: 1. However, although the registration number is a number that is uniquely set by the country (Ministry of Agriculture, Forestry and Fisheries) for pesticides, it has multiple application information for pesticides, so a single registration number uniquely identifies the application information. It will not be. The present inventor has devised the present invention based on the knowledge of such circumstances.

Next, group 2 is grouped as corresponding to the items corresponding to the usage criteria, and includes the following item examples. That is,
・ Dilution factor usage amount ・ Spraying liquid amount ・ Time of use ・ Number of times this product is used ・ Fumigation time ・ Fumigation temperature ・ Applicable agricultural chemical name (mixable agricultural chemical name)
・ Total number of pesticides containing active ingredient (1) ・ Total number of pesticides containing active ingredient (2) ・ Total number of pesticides containing active ingredient (3) ・ Total number of pesticides containing active ingredient (4) Number of uses ・ Total number of pesticides containing active ingredient (5) The data maintenance processing unit 105 uses a maintenance screen for new and old data that cannot be identified by the primary key transfer processing unit 104. It is judged whether it corresponds to data, change data, or revocation data. Further, maintenance of various masters (see FIGS. 18 to 25) is also performed based on the data related to the application information for which a single determination process has been completed, and the various masters that have been maintained are stored in the database 102 for data management.

  The consent check table registration processing unit 106 determines whether the person in charge in the data maintenance processing unit 105 agrees / disagrees. For example, when application information is updated, a specific item in the same registration number is changed to a different value at once. The consent / non-consent check table is registered so that the system can process the consent / non-consent judgment for such changes. By registering the consent check table, it is reflected in the consent / non-consent list in the consent check table 107 (see FIG. 21), and the reflected consent / non-consent list is fed back to the next consent determination to perform maintenance work of the person in charge. We are trying to improve efficiency.

  Although not shown in FIG. 1, the hardware configuration of the data creation support system for the primary key transfer / numbering apparatus according to the embodiment of the present invention includes a computer technology well known in the technical field, for example, a standalone type. It is constructed by a computer system and includes well-known computer components such as CPU (Central Processing Unit), memory devices including ROM and RAM, output devices such as display devices (displays) and printers, keyboards and mice, etc. The present invention is realized by an input / output interface for writing / reading data to / from various standard memory sticks or the like mounted in a slot (not shown). The database 102 described above is configured by the memory device. The ROM stores basic software executed by the CPU, application software (application software), and the like. The RAM has a work area used when the CPU executes application software. A CPU (Central Processing Unit) executes a program (basic software or application software) stored in a ROM or RAM, and controls the entire system while controlling operations of various components. The input device performs data input, item selection / determination, and the like by operation of a mouse or a keyboard. The display device is composed of, for example, a liquid crystal display, and displays processing contents in the various processing units and a screen for data maintenance.

  FIG. 2 is a diagram showing the configuration of the menu screen by starting the data creation support system for the primary key transfer / numbering device according to the embodiment of the present invention. The menu screen 8 in FIG. 2 includes a data import button (1), a data maintenance button (2), a consent check table registration button (3), a recovery button (4), an end button (7), and an old and new display frame. A data information display field (5) and a status display field (6) are provided. In addition to the above, a data expansion button, a maintenance data import button, and a data output button are provided. These buttons can be selected using a pointing device, for example.

  When the data acquisition button (1) is pressed in FIG. 2, a data acquisition process (described later) is executed. That is, by pressing the data import button (1), a calendar is displayed on the sub screen (not shown) of the pesticide uptake date selection screen, the pesticide uptake date is selected from the calendar, and the “OK” button (not shown) )) To get the selected pesticide registration date. The pesticide uptake date is displayed by calling a calendar (not shown) stored in the database 102. The registration application unit 311 in the pesticide registration information is downloaded by another device and stored in advance in an external memory (not shown) in order to use the information provided by the Agriculture, Forestry and Fisheries Consumption Safety Technology Center for free. Keep it.

  Further, when the data maintenance button (2) is pressed in FIG. 2, the screen shifts to the data maintenance screen 10 of FIG. When the consent check table registration button (3) is pressed in FIG. 2, the screen shifts to the consent check table registration screen 30 in FIG. When the recovery button (4) is pressed, a process for loading data from the backup data into the database 102 is executed. And after recovery, it returns to the initial state.

  The new and old data information display field (5) displays the agrochemical registration date of the new data (registration application part development data) and old data (old registration application part development data). The status display column (6) displays the work status of data, and the contents displayed in the status display column (6) will be described later. By pressing the end button (7), the operation of the data creation support system for the primary key transfer / numbering device according to the embodiment of the present invention can be terminated.

  Here, the contents displayed in the status display field (6) will be briefly described. The message displayed in the status display field (6) displays the completion of the processing content such as the completion of the data fetching process. For example, when the data acquisition process is completed, “data acquisition complete” is displayed.

  Next, the operation of the data creation support system for the primary key transfer / numbering apparatus according to the embodiment of the present invention will be described with reference to FIGS. As described above, the menu screen 8 of FIG. 2 is displayed by activating the data creation support system for the primary key transfer / numbering device according to the embodiment of the present invention. Before starting the data creation support system for the primary key transfer / numbering device according to the embodiment of the present invention, registered agricultural chemical information (registered application) from the homepage of the Agriculture, Forestry and Fisheries Consumption Safety Technology Center on other devices (not shown) Download) and store it in an external memory such as a memory stick.

  When the data acquisition button (1) is pressed on the displayed menu screen 8 of FIG. 2, the “data acquisition process” is started. At this time, the download data is stored in a predetermined folder (not shown). In the “data fetching process”, the following processes (1) to (9) are executed in order.

  First, (1) acquisition of agrochemical registration date is executed. In the acquisition of the pesticide registration date, the data acquisition processing unit 101 acquires the date selected on the sub-screen (not shown) for selecting the pesticide registration date. The acquired agrochemical registration date is stored in the agrochemical registration date column of various data tables to be described later and used for date display in the new and old data information display column (5) in FIG.

  Next, (2) “Check file” is executed. When checking the file, whether the file for registration (registration basic part.csv, registration application part 1.csv, registration application part 2.csv) exists in the specified folder (not shown) accessed by the data import processing part 101 Confirm. In addition, at the time of downloading from the homepage of the Agriculture, Forestry and Fisheries Consumption Safety Technology Center, the registration application department data is divided into two (registration application department 1 .csv, registration application department 2 .csv). Store in the table.

  After confirming the existence of the file as described above, (3) “initialization processing” is executed. The initialization process will be described with reference to FIG. As shown in FIG. 3, the data acquisition processing unit 101 deletes all data in the following table as shown in FIG. That is, in <registration basic part side>, the data of the registration basic part (see FIG. 13) and the data of the old registration basic part expansion data (see FIG. 12) are deleted. In <registration application unit>, the data of the registration application unit (see FIG. 14), the data of the old registration application unit development data (see FIG. 15), and the data of the registration application unit development data (see FIG. 20) are deleted.

  Next, the data capture processing unit 101 accesses the database 102 and (b) moves the previous data to the next table as old data. At this time, all the processing state flags (described later) of the old registration application unit expansion data (see FIG. 15) are blanked. In <registration basic part side>, the registration basic part expansion data (see FIG. 19) is copied and moved to the old registration basic part expansion data (see FIG. 12). In the <registration application unit>, data of the registered registration application unit (see FIG. 16) is copied and moved to the old registration application unit development data (see FIG. 15).

  Further, (c) all data in the following table is deleted. That is, the registration basic part expansion data (see FIG. 19) is deleted at <registration basic part side>, and the data of the maintained registration application part (see FIG. 16) is deleted at <registration application part side>.

  Here, the explanation of FIG. 3 is left and the processing returns to the “data fetching process”, and (4) “character conversion” is executed. In the character conversion, the data acquisition processing unit 101 converts the characters in the file for acquisition shown in (2) “Confirmation of file” based on a conversion table (not shown) stored in the database 102 (all Unification of half-width etc.). The conversion table (not shown) can be edited as a CSV file.

  Next, (5) “fetch new data” is executed. In the execution of new data fetching, the data fetching processing unit 101 fetches the data that has been subjected to the above (4) “character conversion” into the table that has undergone the initialization process described above. That is, in <registration basic part side>, the registration basic part .csv after “character conversion” is taken into the registration basic part (see FIG. 13), and in <registration application part side> (4) “character” The registration application unit .csv for which “conversion” is completed is taken into the registration application unit (see FIG. 14). The lowermost part of FIG. 3 shows this state.

  And (6) “Development table creation” is executed. In executing the development table creation, the data of the registration basic part table (see FIG. 13) is developed into the registration basic part development data table (see FIG. 19). The expansion method will be described later. Further, the data of the registration application unit table (see FIG. 14) is developed into a registration application unit development data table (see FIG. 20). The expansion method will be described later. New data (registration application section development data table) (see FIG. 20) is assigned a temporary number as a serial number from 1 as an application code. This temporary number will be replaced with the original number by primary key transfer and new application code numbering, which will be described later. Then, all the processing status flags of the registration application section development data (new data) and the old registration application section development data (old data) are blanked. Furthermore, the revocation flag = 0 of the registration application part development data (see the revocation flag 386 in FIG. 20) and the registration basic part development data (see the revocation flag 254 in FIG. 19) is set. The revocation flag = 0 means that it has not been revoked.

Here, the registration basic unit expansion data and the registration application unit expansion data expansion method will be described in more detail. As described above, first, the data of the registration basic part table (see FIG. 13) is developed as new data in the registration basic part development data table (see FIG. 19). As an expansion method in this case, all items in the registration basic part table (see FIG. 13) are copied as they are to the registration basic part expansion data (see FIG. 19), and the registration basic part expansion data (see FIG. 19) is invalidated. Set flag = 0. Next, the data of the registration application unit table (see FIG. 14) is developed as new data in the registration application unit development data table (see FIG. 20). In this case, as the expansion method, all items other than “use”, “abbreviation”, and “mixed number” in the registration application section data (see FIG. 14) are copied to the registration application section expansion data (see FIG. 20), and the registration application is applied. A temporary number is assigned from 1 to the application code of the partial development data (see FIG. 20). Note that, as described above, this temporary number is replaced with the original number by changing the primary key and assigning a new application code, which will be described later. After that, the revocation flag = 0 of the registration application section development data (see FIG. 20) is set. Further, the processing status flag and the application update date of the registration application section development data (see FIG. 20) are blanked. Furthermore, “registration number” 370, “agricultural chemical type”, “agricultural chemical name”, “expiration flag” 386, “application renewal date” 387, “processing status flag” 388 of the registration application section development data (see FIG. 20), if there is a blank in the "application code instead of Ri vibration" 389 other items "-" to set the (hyphen).

  Next, (7) “primary key transfer process” is executed. The primary key transfer process is executed using the primary key transfer processing unit 104, the maintenance processing unit 105, and the consent check table 107 shown in FIG. This will be described later.

  Then, (8) “Registered basic part data comparison” is executed. Compare the new data (registered basic part expanded data) (see FIG. 19) and the old data (old registered basic part expanded data) (see FIG. 12) of the registered basic part (here, “primary key” is “registration number + Active ingredient "). If “registration number + active ingredient” matches and other items are changed, the change (registration number, active ingredient, item, old and new values) is output in CSV. In addition, when “registration number + active ingredient” is compared, it exists in new data (registered basic part expanded data) (see FIG. 19) and does not exist in old data (old registered basic part expanded data) (see FIG. 12). Output as CSV as new data. In addition, when “registration number + active ingredient” is compared, it exists in the old data (old registration basic part expanded data) (see FIG. 12) and does not exist in the new data (registered basic part expanded data) (see FIG. 19). , Output as revocation data in CSV format. Then, the revocation data of the old data (old registration basic part expansion data) is added to the registration basic part expansion data, and the revocation flag = 1 is set (the revocation flag = 1 is not set in the old registration basic part expansion data table). Set the pesticide registration date as the registration renewal date of the data that has changed, new or expired as described above.

  Finally, (9) “Update menu screen display” is executed. In the display update of the menu screen 8 shown in FIG. 2, the processes (1) to (8) in the data acquisition processing unit 101, the data expansion processing unit 103, and the primary key transfer processing unit 104 are normally executed. The new and old data information display field (5) is updated. Pesticide registration date and time in the new data column in the old and new data information display column (5), and the previous pesticide registration date in the old data column in the old and new data information display column (5) (pesticide registration date in the old registration application section development data) Is displayed. In addition, a message indicating that “data import processing” has been completed normally (data capture completion) is displayed in the status display field (6). Then, the “data import” button (1) is disabled. Enable the "Data maintenance" button (2).

  Here, the primary key transfer processing executed by the primary key transfer processing unit 104, the consent check table 107, and the maintenance processing unit 105 will be described. As outlined in (7) of the “data fetching process” described above, the primary key transfer process includes new data (registration application section development data) (see FIG. 20) and old data (old registration application section development data). (See FIG. 15), and a process of transferring / numbering a formal primary key (application code) to new data. That is, if the contents of the new data (registration application part development data) (see FIG. 20) and the old data (old registration application part development data) (see FIG. 15) are the same, the old data (old registration application part development data) ) (See FIG. 15), the application code is transferred to the application code of the new data (registration application section development data) (see FIG. 20). If the content of the new data (registered application development data) is not in the old data (old registration application development data), a new application code is assigned.

FIG. 4 is a diagram for explaining a classification procedure of application information which is a premise of data creation support related to primary key transfer / numbering. In FIG. 4, the classification procedure of application information is displayed in a portion surrounded by a rectangle, and the procedure number is indicated by a number in parentheses. The procedure for classifying applied information will be described with reference to FIG. 4. In step 1 (41), the comparison between the new data (registered application section expanded data) and the old data (old registered applied section expanded data) described above is applied code. Execute for all items other than the registration renewal date. In the all item comparison, character strings are mechanically compared, and if they match, the application information is classified as unchanged application information, and if they do not match, the application information is classified as changed. If Re is classified as no change application information, the old applications as no change application information (47), sets the processing state flag = 0, when transferred application code to configure the application code of the old application information (data expansion Transfer the application code of the information as the application code of the new application information). In the procedure 1 (41), the data of the old application information revocation flag = 1 is also set as the processing state flag = 0.

If Re is classified as application information that is changed by the above step 1 (41), in Step 2 (42), comparing each of the "registration number" for the application information of change. By comparing the “registration numbers”, the application information is classified into “new” / “revocation” / “change”. In other words, if a registration number that does not exist in the old data (old registration application development data) exists in the new data (registration application development data), the processing status flag = 1 is set (a new application code is adopted as “new” data). (It is reflected in the maintenance application section when data is expanded). If a registration number that is not in the new data (registration application development data) exists in the old data (old registration application development data), a processing status flag = 2 is set (revocation flag = 0 as “revocation data”). The revocation flag is reflected in the maintenance registration application unit at the time of data expansion as a target to be changed to 1).

Each item of the designated items described in step 3 (43) is compared with the old and new application information in which the application information is classified as “change” instead of “new” / “revocation” in step 2 (42). In other words, the following items belonging to the designated item are compared one by one in order for each “registration number” for new and old data (registration application part development data and old registration application part development data) whose processing status flag is blank. At this time, if the character strings match or the contents registered in the consent check table 107 match the values of the old and new data (the registration application section development data and the old registration application section development data), it is assumed that the agreement is accepted. . Here, “agreement” is regarded as agreement = same meaning, and the items are regarded as matching. Further, when the contents registered in the disagreement check table 107 at the time of this item comparison match the values of the old and new data (registration application section expansion data and old registration application section expansion data), it is assumed that the data is “disagree”. Here, “non-consent” means that disagreement does not mean the same meaning, and that item is regarded as a new condition for using pesticides. (Unconditional combinations are treated as new data / revocation data.)
<Comparison item belonging to the specified item>
(A) Crop name (b) Applicable pest and weed name (c) Method of use (d) Applicable zone name (e) Purpose of use (f) Applicable location (g) Applicable soil All the above comparison items (a) to (g) The new and old data (registration application part development data and old registration application part development data) that are “consent” are considered to be the same application information, and the process proceeds to the process of step 4 (44) shown below.

  Further, when there is an item corresponding to “non-agreement” at the time of comparing the comparison items (a) to (g), it is processed as new / revocation data. At this time, the processing state flag = 1 is set in the new data (registration application unit development data). Then, a new application code is assigned as new data, and is reflected in the maintenance registration application unit at the time of data expansion. However, when called from the data maintenance screen or consent check table registration screen, the processing status flag = 4 is set. These will be described later. In addition, the processing status flag = 2 is set in the old data (old registration application section development data). The revocation flag is to be changed as revocation data, and is reflected in the maintained registration application unit at the time of data expansion. However, when called from the data maintenance screen or consent check table registration screen, the processing status flag = 5 is set.

The above comparison item (a) ~ item not and does not correspond to "non-consent", "agree" when comparing (g) (without strings match, does not correspond to the "consent") when he Tsu there, below Proceed to step 5 (45).

  FIG. 5 is a diagram illustrating a specific example of designated item comparison. The designated item is an item corresponding to the condition when using the agricultural chemical of the registration application department, and indicates each item of the designated item. As shown in FIG. 5, the old and new application information is compared in order from the comparison item (a) for each data row, and if there is an agreement in the comparison item, the comparison items are sequentially lowered and compared, If all comparisons are made until the comparison in the comparison item (g) is agreed, all items in the specified item comparison are considered to be in agreement, and the new and old data (registration application part development data and old registration application part development data) in the comparison item are compared. If it exists in one side and does not exist in the other side in the process, it is assumed that there is new / revocation application information (temporary) and is left to the processing in the following procedures 4 and 5.

  In step 4 (44), new data (registered application development data) in which all items (a) to (g) in the specified item comparison are regarded as consent in the process of step 3 (43) For the old data (old registration application development data), the following processes (a) to (c) are performed according to the number of lines of the old and new data.

(A) One line of new data (registered application development data) in which all the items (a) to (g) in the above specified item comparison are regarded as agreement in the process of step 3 (43), old data When (old registration application section expansion data) exists in one line, the old and new data (registration application section expansion data and old registration application section expansion data) are considered to have the same content (consent) (change data, primary key transfer target) ). Then, all items are compared, and a change point (registration number, item name , old / new data value, new / old data application code value, processing status flag) is added to the change point output table (see FIG. 17). In addition to set the application code 355 of the new data old data to shake Ri instead of application code 389 (registration application unit expanded data) (formerly registration application unit expanded data). Further, a processing status flag = 3 is set for new and old data (registration application part development data and old registration application part development data). However, when called from the data maintenance screen 10 of FIG. 9 or the consent check table registration screen 30 of FIG. 10, the processing state flag = 6 is set.

  FIG. 6 is a diagram showing a specific example 1 of the agreement line comparison when the number of new and old application information is 1: 1, where the contents of each item of the designated item are agreement and the number of old and new application information is 1: 1 Shows that information classified as change application information (48) but having different contents is output as a change point, and the application code is also transferred.

(B) New data (registered application development data) for which all the items (a) to (g) in the above specified item comparison are considered to have been agreed in the process of step 3 (43) is N rows, old data When (old registration application part expansion data) exists in N rows, string comparison is performed for all items in all combinations of new and old data (registration application part development data and old registration application part development data) , and the number of matching items is calculated. Count. In this case, (A) if there is a combination of old and new data (registration application section expanded data and old registration application section expanded data) with a large number of matching items without duplication, the old and new data of the combination is considered to have the same contents (change) Data, primary key transfer target). In this case, the same process as the process for the changed data (A) is performed. (B) If the combination of old and new data ( registration application section development data and old registration application section development data) with a large number of matching items is duplicated, the process proceeds to step 5 (45) shown below.

    (C) New data (registered application development data) for which all items (a) to (g) in the above-mentioned specified item comparison are regarded as consent in the process of step 3 (43) is N rows, old data When (old registration application unit expansion data) exists in M rows (N ≠ M), the process proceeds to the process of the procedure 5 (45) shown below.

  FIG. 7 is a diagram illustrating specific example 2 and specific example 3 when the ratio of the number of new and old application information is 1: 1 and the ratio of the number of new and old application information is not 1: 1. If the content is consent and the ratio of old and new application information is 1: 1, check all items, and if it can be specified, classify it as change application information (48), and compare the number of items that match all items. The combination of application information that has a large number of matches is regarded as corresponding application information, and is classified as change application information (48). Indicates that the application code is transferred. Specific example 3 (the lower half of FIG. 7) in which the ratio of the number of new and old application information is not 1: 1 is the system in the case where the content of the specified item is agreement and the ratio of the number of old and new application information is not 1: 1. It is left to the processing in the next procedure 5 (45) because it is difficult to specify the application information.

  In procedure 5 (45), since the data (application information) brought in here cannot be determined by the system for comparison processing for primary key transfer, the person in charge determines it on the maintenance screen 10 in FIG. As long as at least one blank remains in the old and new data, the data maintenance process is not completed.

  In the above-described processing from the procedure 1 (41) to the procedure 5 (45), “apply information is classified into one of“ new ”/“ revocation ”/“ change ”” (46). In the data expansion process (described later) that operates when the “data expansion button” is pressed on the menu screen of FIG. 2, when the change application information (48) is classified, the application code of the old application information is changed. If it is transferred to the application code of the new application information, or if it is classified as new application information (49), a new application code is assigned, and if it is classified as revocation application information (50), the revocation flag is set. Stand up. In addition, when classified into the application information without change (47), as described above, the application code of the old application information is transferred as the application code of the new application information.

  FIG. 8 is a flowchart for explaining the primary key transfer / numbering process in the primary key transfer / numbering apparatus data creation support system according to the embodiment of the present invention. Since the outline of the primary key transfer / numbering process has already been described in the classification procedure shown in FIG. 4, the contents of the primary key transfer / numbering process will be described in more detail here. FIG. 8 shows the contents of the classification procedure shown in FIG. 4 in a rectangle surrounded by a broken line so that the relationship with the classification procedure shown in FIG. 4 can be understood. In FIG. 8, the step is abbreviated as “S”.

  In FIG. 8, at the start of the main key transfer / numbering process, character strings are compared for all items (S1). If the character string comparison of all items is completely matched, the process proceeds to step S2, and the primary key is transferred. In this process, “no change application information” is obtained. This process is later handled as new application information (primary key transfer completed) 321. On the other hand, if they do not match, the process proceeds to step S3, and the comparison is performed using the registration numbers. Here, if the comparison destination does not have the same registration number, the process proceeds to step S4, where it is determined whether the application information is new application information or old application information. If the information is new application information, the application code is newly assigned in step S5. With this processing, “new application information” 323 is obtained. If the old application information is determined in the determination, an invalidation flag is added in step S6. With this processing, “revocation application information” 324 is obtained.

  If the registration numbers are the same in the comparison of the registration numbers in step S3, the process proceeds to step S7, and the above-mentioned designated items are designated in step S7. Next, the specified item comparison is performed in step S8. In this item comparison, the consent check table 107 (see FIG. 1) is taken into consideration. If the result of the comparison is “agree”, the process proceeds to step S9. In step S9, it is determined whether the specified item is the final item. If not, the process proceeds to step S10, and the next specified item is compared in step S10. Instruction is issued, and the process returns to step S7. This routine is repeated until the last item is reached. If it is determined in step S9 that the item is the last item, the process proceeds to step S11. In the item comparison in step S8 in the repetition of steps S7 to S10 until the final item is reached, if “disagree”, the process proceeds to step S4 described above, and the processes in steps S4 to S6 are executed. In addition, in the item comparison in step S8, in the case of “Neither agree nor disagree” (the character string does not match and neither agree nor disagree), the data maintenance by the person in charge in the data maintenance screen processing S16 Implemented (described later).

  In step S11, it is determined whether or not the ratio of application information is 1: 1. If the ratio of application information is not 1: 1, the process proceeds to the above-described data maintenance screen process S16. On the other hand, if the ratio of the application information is 1: 1, the process proceeds to step S12, and it is determined in step S12 whether the number of application information is 1 line: 1 line. If the number of pieces of application information is 1 line: 1 line, the process proceeds to step S13, where the changed points of all the above items are output in step S13, and then the primary key is transferred in step S14. The output of the change points of all the items in step S13 is handled as change information 322, and change application information is obtained by transferring the primary key in step S14. The processing in the change application information is later handled as new application information (primary key transfer completed) 321. If the number of application information is not 1 line: 1 line, the process proceeds to step S15. In step S15, it is determined whether the combination can be specified. If the combination can be specified, the process proceeds to step S13 described above. If the process of step S14 is executed and the combination cannot be specified, the process proceeds to the data maintenance screen process S16 and is left to the determination by the person in charge. This will be described later.

  In data maintenance screen processing S16, the person in charge looks at the data to be compared, selects the target row, and determines whether it is new revocation registration (determined as different content) (S17) or change registration (determined as the same content) (S18) If it is a new revocation registration (S17), the process proceeds to step S4 described above, and the processes of steps S4 to S6 are executed. If it is change registration (S18), the process proceeds to step S13 described above, and the process of step S13 and then the process of step S14 are executed. Consent check table registration S20 is executed for “agreement” or “non-agreement”. In that case, the screen transitions to the consent check registration screen 30 in FIG. 10 and the selected item is registered in the consent (non-agreement) check table 107 so as to improve the accuracy of agreement / non-agreement determination. Further, by instructing the primary key transfer process execution S21 from the consent check table registration screen process S19, the determination of steps S7 to S16 is repeated using the newly registered consent check table 107, and the intelligence of the consent check table 107 is determined. Reduce the burden on the person in charge regarding consent / disagreement through improvement.

  FIG. 9 is a diagram showing the configuration of the data maintenance screen of the data creation support system for the primary key transfer / numbering device according to the embodiment of the present invention. The data maintenance screen 10 in FIG. 9 includes a data maintenance button (2 in FIG. 1) for processing data that could not be automatically processed in the primary key transfer process outlined in (7) of the “data import process”. ) To change. In the data maintenance screen 10 of FIG. 9, the pesticide type combo box (11) is provided to select the type of pesticide that needs maintenance, and by selecting the pesticide type name, the data of the selected pesticide type is displayed. Display in data grid (13), (14). The pesticide name combo box (12) is provided to select the name of the pesticide that needs maintenance from the selected pesticide type, and by selecting the pesticide name, data on the name of the selected pesticide is displayed. Display in data grid (13), (14). If not selected, only the data of the type of pesticide selected in the pesticide type combo box (11) is displayed in the data grids (13) and (14).

  The new application information data grid (13) displays the new application information requiring maintenance in ascending order of crop names and enables selection of each row. The old application information data grid (14) displays the old application information that requires maintenance in ascending order of crop names.When the row of the new application information data grid (13) is selected, each item is compared with the selected row. Different items are displayed with different cell background colors.

The pattern item selection combo box (15) is provided for the person in charge to select items to narrow down the pattern, and the items are `` Crop name '', `` Applicable pest weed name '', `` Usage '', Select from “Applicable Zone Name”, “Use Purpose”, “Applicable Location”, and “Applicable Soil”. Here, the pattern refers to the tendency (pattern) that is considered to be changed at the same time in the application information that was not specified due to the item mismatch of the specified item, and this pattern is the pattern item selection combo box (15 ) Item is selected by the person in charge and narrowed-down display is performed, it is determined whether the person in charge is the same from the narrowed down contents, and the pattern that can determine whether it is the same is reflected in the agreement / non-consent check table This will help reduce the maintenance burden on the person in charge .

  The pattern selection combo box (new application information) (16) is provided to display the value of the item selected in the pattern item selection combo box (15) from the data displayed in the new application information data grid (13). Select the displayed value. The pattern selection combo box (old application information) (17) is provided to display the value of the item selected in the pattern item selection combo box (15) from the data displayed in the old application information data grid (14). Select the displayed value.

Agree check table registration button (18) displays the consent check table registration screen 30 of FIG. 10 by pressing the button.

The difference item number display (19) displays the number of different items when the new application information data grid and the old application information data grids (13) and (14) are selected by the person in charge . When personnel differences item selection combo box (20) is selected, the new application information data grid and the old application information data grid (13) selected in the above, (14) compares the line between the selected, Store different item names as different items.

Difference display (new application information) (21) displays the value of the selected item in the different item selection combo box (20) in the new application information selection row when the person in charge selects the different item selection combo box (20). indicate. Difference display (old application information) (22) displays the value of the selection item in the difference item selection combo box (20) in the old application information selection row when the person in charge selects the difference item selection combo box (20). indicate.

  The change registration button (23) is provided to be executed when it is determined that the new application information and the old application information have the same contents, and the selected rows are processed as change data (primary key transfer, registration update date). Then, the registered selected row is deleted from the data grids (13) and (14) (refer to change registration processing described later).

  New revocation registration button (24) is provided to execute when it is determined that the new application information is different from the old application information, and the selected line of the new application information is processed as new data (new application code numbering) In addition, the selected row of the old application information is processed as revocation data (revocation flag). Then, the registered selected row is deleted from the data grids (13) and (14) (see the new revocation registration process described later).

  The reset button (25) is provided in order to return the content processed on the maintenance screen to the state before processing in the type of the selected agricultural chemical or the name of the agricultural chemical (see reset processing described later). The return button (26) is provided to return to the menu screen 8 (see FIG. 2).

  The new application information remaining number (27) displays the total number of data that has not yet been maintained in the new application information. The old application information remaining count (28) displays the total number of data that has not yet been maintained in the old application information.

A change registration process when the change registration button (23) is pressed on the data maintenance screen 10 of FIG. 9 will be described. The change registration process can be executed when each of the new application information data grid (13) and the old application information data grid (14) is selected. The selected data is regarded as having the same contents, and the items are compared, and the change points (registration number, item name , old and new data values, old and new data application codes, processing status flags) are shown in the change point output table (FIG. 17). Add to Browse). And it sets the application code 355 of the new data (registration application unit expanded data) old data (Old registration application unit decompressed data) to the vibration Ri instead redemption code 389 (see FIG. 20) (see FIG. 15). Also, the processing status flag = 6 of the new and old data (registration application part development data and old registration application part development data) is set.

  A new revocation registration process when the new revocation registration button (24) is pressed on the data maintenance screen 10 of FIG. 9 will be described. The new revocation registration process can be executed when the new application information data grid (13) and the old application information data grid (14) are selected (multiple selection is possible). The selected data is considered to have different contents, and the new application information data grid selection data is output as new data, and the old application information data grid selection data is output as revocation data. Set processing status flag = 4 in new data (registration application section development data) (see processing status flag 388 in FIG. 20) (target to assign a new application code as new data. Reflected in the department). In addition, the processing status flag = 5 is set in the old data (old registration application section expanded data) (see the processing status flag 358 in FIG. 15) (the target to change the revocation flag as revocation data. Reflected in the department).

  A reset process when the reset button (25) is pressed on the data maintenance screen 10 of FIG. 9 will be described. The reset process can be executed in a state selected in the pesticide type combo box (11) or the pesticide name combo box (12). Then, the pesticide selected in the pesticide type combo box (11) and the pesticide name combo box (12) is returned to the state before maintenance (the processing state flag is set to blank). However, the object is executed for data (processing state flag = 4 to 6) maintained on the maintenance screen and consent check table registration screen (described later). That is, in the new data (registered application development data) and the old data (old registration application development data), the pesticide selected in the pesticide type combo box (11) and the pesticide name combo box (12) and the processing status flag = 4 The processing status flag = blank is set for the data of .about.6. Further, in the change point output table (see FIG. 17), the data of the agricultural chemical selected in the agricultural chemical type combo box (11) and the agricultural chemical name combo box (12) and the processing state flag = 6 is deleted.

After the change registration button (23) is pressed on the data maintenance screen 10 of FIG. 9 and the primary key transfer process by change registration is performed, and the consent check table registration button (18) is pressed, the consent check table registration screen 30 (see FIG. 10), the primary key transfer process (39) is performed, and the procedures (3) to (5) shown in FIG. 4 are performed using the newly registered consent / non-agreement check table. After the process is executed again, the remaining data that has not been maintained on the data maintenance screen 10 in FIG. 9 is displayed in the new application information remaining number (27) and the old application information remaining number (28) for confirmation. The remaining number of data that has not been maintained is confirmed by the number of processing state flags = blanks of new and old data (registration application section development data and old registration application section development data) (see FIGS. 20 and 15). When both the new and old data have 0 remaining, the screen returns to the menu screen 8 (see FIG. 2). Further, a message indicating that the data maintenance has been completed normally is displayed in the status display field (6) of the menu screen 8 (see FIG. 2).

  FIG. 10 is a diagram showing the configuration of the consent check table registration screen. That is, the consent check table registration screen 30 in FIG. 10 transitions by pressing the consent check table registration button (18) on the data maintenance screen 10 in FIG. 9, and the consent check table registration button ( There are both cases of transition by pressing 3).

  In the consent check table registration screen 30 of FIG. 10, an item selection combo box (31) is provided for selecting an item for displaying and registering the consent check table (see FIG. 21). Select from “Crop name”, “Applicable pest and weed name”, “Usage method”, “Applicable zone name”, “Use purpose”, “Applicable place”, and “Applicable soil”. The registration category selection combo box (32) selects whether to display / register the consent check table (see remarks in FIG. 21) or the non-agreement check table (see remarks in FIG. 21). That is, in the classification 270 of the items in the consent check table of FIG. 21, if the classification = 0, the consent check table is represented, and if the classification = 1, the disagreement check table is represented. The registration category selection combo box (32) selects either “consent” / “non-consent” check table. When selected, the check table data grid (36), which will be described later, displays the selected item and check table contents of the classification.

  The new application information item selection list (33) displays a list of items selected by the item selection combo box (31) with the data displayed in the new application information data grid (13) of the data maintenance screen 10 shown in FIG. The old application information item selection list (34) displays a list of items selected by the item selection combo box (31) with the data displayed in the old application information data grid (14) of the data maintenance screen 10 shown in FIG.

  The registration button (35) displays the contents selected in the new application information item selection list (33) and the old application information item selection list (34) when `` agree '' is selected in the registration classification selection combo box (32). It is considered “consent” and registered in the consent check table (see the remarks in FIG. 21). In addition, when “Disagree” is selected in the registered classification selection combo box (32), the contents selected in the new application information pattern selection list (33) and the old application information pattern selection list (34) are not considered “consent”. , It is registered in the disagreement check table (see the remarks in FIG. 21). After registration, the display of the check table data grid (36) described later is updated (when transition is made from the consent check table registration button (3) in the menu screen of FIG. 2, operation is disabled).

  The check table data grid (36) displays the consent check table (refer to the remarks in FIG. 21) for the item selected in the item selection combo box (31) when “consent” is selected in the registration classification selection combo box (32). When “non-agreement” is selected, a non-agreement check table (see remarks in FIG. 21) is displayed. The data grid (36) is editable and has a new entry field at the bottom (displayed in ascending order with new data items).

  The change button (37) registers the edited contents of the check table data grid (36) in the consent check table (see remarks in FIG. 21). However, if there is a line in which either the new application information or the old application information is blank, an error is displayed and the process ends. The delete button (38) deletes the selected row in the check table data grid (36). However, if no row is selected, an error is displayed and the process is terminated.

  The primary key transfer processing button (39) is the procedure shown in FIG. 4 described above using the consent check table / non-agreement check table edited by pressing the registration or change button (37) by pressing the registration button (35) ( Processes 3) to (5) are executed again (when transition is made from the menu screen 8 in FIG. 2, operation is disabled). The return button (40) is provided to close the consent check table registration screen 30 and return to the data maintenance screen 10 in FIG. 9 or the menu screen 8 in FIG.

Next, a data expansion process executed when the data expansion button is pressed on the menu screen of FIG. 2 will be described. In the data expansion process, the following processes (1) to ( 2 ) are executed in order.

(1) Creation of maintained registration application unit In creating the maintained registration application unit, first, the data (previous data) of (a) the maintenance registration application unit (see FIG. 16) is deleted. Next, in (b) the old registration application unit expansion data (see FIG. 15), the data of the processing state flag = 0 of the processing state flag 358 is added to the maintained registration application unit (see FIG. 16) (= data without change). Then, in (c) registration application section development data (see FIG. 20), the data of the processing state flag = 1 of the processing state flag 388 is added to the maintained registration application section (see FIG. 16). The application code 165 is blank (= new data). Next, (d) in the old registration application part expansion data (see FIG. 15), the data of the processing state flag = 2 of the processing state flag 358 is added to the maintained registration application part (see FIG. 16). Revocation flag = 1 is set (= revocation data). And in (e) registration application unit decompressed data (see FIG. 20), to add the data processing state flag = 3 processing state flag 388 maintainer registered application unit (see FIG. 16), vibration Ri place of application code 389 A value is set in the application code 165 (= change data in the data fetch process). In addition, in (f) registration application unit expansion data (see FIG. 20), data of the processing state flag = 4 of the processing state flag 388 is added to the maintained registration application unit (see FIG. 16). The application code 165 is blank (= new data set on the maintenance screen). (G) In the old registration application part expansion data (see FIG. 15), the data of the processing state flag = 5 of the processing state flag 358 is added to the maintained registration application part (see FIG. 16), and the revocation flag of the revocation flag 166 = 1 is set (= revocation data set on the maintenance screen). In (h) registration application unit decompressed data (see FIG. 20), to add the data processing state flag = 6 the processing state flag 388 maintainer registered application unit (see FIG. 16), vibration Ri place of application code 389 Set the value to the application code 165 (= change data set on the maintenance screen). Then, (j) an application code is set to data in which the application code 165 of the registered registration application unit (see FIG. 16) is blank (application code new numbering process). The application code set here is the application registered in the final application code master table (see the final application code 171 in FIG. 18) at the registration number in which the application code 165 of the maintenance registration application unit (see FIG. 16) is blank. Set the code maximum value +1. After the setting, the primary key maximum value in the final application code master table (see the final application code 171 in FIG. 18) is updated to the set value. This process is performed for all data in the registered registration application unit (see FIG. 16) whose application code 165 is blank.

(2) Change point output In the change point output, the data of (a) process state flag = 3 and 6 of the process state flag 362 of the change point output table (see FIG. 17) is output as a CSV file. The file name of the CSV file is “year / month / day / hour / minute / second + changed data” (registration number, item name arranged in ascending order). Then, (b) data of processing status flag = 1, 4 of the processing status flag 388 is output as a CSV file in the registration application section development data (see FIG. 20). The file name of the CSV file is “year / month / day / hour / minute / second + new data” (registration number, application code arranged in ascending order). Further, (c) data of processing status flag = 2, 5 of the processing status flag 358 is output as a CSV file in the old registration application section development data (see FIG. 15). The file name of the CSV file is “year / month / day / hour / minute / second + revocation data” (registration number, application code arranged in ascending order).

  In this way, the various development tables are stored in the database 102 and managed. Then, the registration application unit (primary key transfer completed) 321, the change point 322, the new application information 323, and the revocation application information 324 can be obtained as output information using the table data expanded by the data expansion processing unit 103. Note that the output information about the registration application unit (primary key transfer completed) 321, the change point 322, the new application information 323, and the revocation application information 324 is also shown as a reference in the flowchart of FIG. 8 described above.

  FIG. 11 is a table showing the processing contents in the data expansion process for the processing state flag, the condition when setting the value in the processing state flag, and the value of the processing state flag. In the table shown in FIG. 11, the relationship between the processing state flag described above and the procedures 1, 2, 4, and 5 shown in FIG. 4, which are conditions for setting the processing state flag value (0 to 6), and the processing The processing contents in the “data development processing” described above are shown for the value (0 to 6) of the status flag. As described in the table of FIG. 11, if the processing status flag is blank (value is not set), this means that the data maintenance processing has not ended, and the status display field on the menu screen 8 shown in FIG. In (6), since the maintenance processing completion display is not made, it is possible to alert the person in charge that maintenance has not been completed and to prevent omission of data maintenance.

As described above, according to the present invention, the operation can be started only by the person in charge operating the button displayed on the menu screen, and the processing can be further shifted to the next processing by one processing completion display displayed on the screen. Therefore, it is possible to support the creation of data related to primary key transfer / numbering through the menu screen and the maintenance screen to reduce the creation load and stably use the system.

  In addition, since the contents reflected in the database are displayed on the maintenance screen for the continuous identification of the data of the agrochemical registration information (Agricultural Chemicals Application Department) that is constantly changing, data creation support related to primary key transfer / numbering is visualized. be able to.

  Here, the structure of the data table used in the present invention will be described. The old registration basic part development data shown in FIG. 12 is used as a work table for attaching an invalidation flag and update date to the registration basic part data downloaded from the Agriculture, Forestry and Fisheries Consumption Safety Technology Center. Number 111, revocation flag 112, application update date 113, and the like are provided. The registration basic part shown in FIG. 13 stores registration basic part data downloaded from the Agriculture, Forestry and Fisheries Consumption Safety Technology Center, and includes a registration number 121, a pesticide type 122, a pesticide name 123, and the like.

  The registration application unit shown in FIG. 14 stores registration application unit data downloaded from the Agriculture, Forestry and Fisheries Consumption Safety Technology Center, and has a registration number 130, a crop name 131, an application location 132, an applicable pest and weed name 133, and a purpose of use 134. , Dilution factor use amount 135, spray liquid amount 136, use time 137, use number 138 of this agent, use method 139, fumigation time 140, fumigation temperature 141, application soil 142, application zone name 143, application pesticide name (mixable) (Agricultural chemical name) 144 etc. The old registration application section expansion data shown in Fig. 15 is used as a table developed for the work to add the application code, revocation flag, and update date for the registration application section data downloaded from the Agriculture, Forestry and Fisheries Consumption Safety Technology Center. Registration number 340, crop name 341, application location 342, application pest weed name 343, purpose of use 344, dilution factor usage 345, spraying liquid amount 346, use time 347, use of this drug 348, use Method 349, fumigation time 350, fumigation temperature 351, application soil 352, application zone name 353, application pesticide name (mixed pesticide name) 354, application code (primary key) 355, revocation flag 356, application renewal date 347, treatment status A flag 358 is provided.

  The maintenance registration application unit shown in FIG. 16 correctly performs the primary key transfer / numbering process and stores the data of the application registration unit after the correct application code is created. , Application place 152, Applicable pest and weed name 153, Purpose of use 154, Dilution factor use amount 155, Spray liquid amount 156, Use time 157, Use frequency 158, Use method 159, Fumigation time 160, Fumigation temperature 161, Application It includes soil 162, application zone name 163, application pesticide name (mixed pesticide name) 164, application code 165, revocation flag 166, application renewal date 167, and the like.

  The change point output table shown in FIG. 17 stores the change points by comparing all items in the data that has been changed in the main key transfer / numbering process and the maintenance screen 10 in FIG. 360, item name 361, processing state flag 362, and the like.

  The final application code master shown in FIG. 18 stores the previous last application code number for the primary key new numbering process, and includes a registration number 170 and a final application code 171.

  The registration basic part development data shown in FIG. 19 is used as a table developed for work for attaching an invalidation flag and an update date for registration basic part data downloaded from the Agriculture, Forestry and Fisheries Consumption Safety Technology Center. A registration number 251, a pesticide type 252, a pesticide name 253, an expiration flag 254, an application renewal date 255, and the like are provided.

The registration application section expansion data shown in FIG. 20 is a table developed for work for attaching a primary key (application code), an expiration flag, and an update date for the registration application section data downloaded from the Agriculture, Forestry and Fisheries Consumption Safety Technology Center. Registration number 370, crop name 371, application place 372, application pest weed name 373, purpose 374, dilution factor usage 375, spraying liquid amount 376, use time 377, use frequency of this drug 378 , Usage 379, fumigation time 380, fumigation temperature 381, application soil 382, application zone name 383, application pesticide name (mixed pesticide name) 384, application code (primary key) 385, revocation flag 386, application renewal date 387, A processing status flag 388, a transfer application code 389, and the like are provided.

  The consent check table shown in FIG. 21 stores data that contributes to the determination of consent / non-consent in the primary key transfer / numbering process. The classification 270, the item 271, the new data item 272, and the old data item 273 are stored. I have.

It is a block diagram which shows the structure of the data creation assistance system for main key transfer / numbering apparatuses which concerns on embodiment of this invention. It is a figure which shows the structure of the menu screen by starting of the data creation assistance system for main key transfer / numbering apparatuses which concerns on embodiment of this invention. It is a figure explaining the initialization process of the data creation assistance system for main key transfer / numbering apparatuses which concerns on embodiment of this invention. It is a figure explaining the classification | category procedure of the application information used as the premise of the data creation assistance which concerns on primary key transfer and numbering. It is a figure which shows the specific example of designation | designated item comparison. It is a figure which shows the specific example 1 of the consent line comparison in case the number of old and new application information is 1: 1. It is a figure which shows the specific example 2 and the specific example 3 in the case where the ratio of the number of old and new applied information is 1: 1, and the case where the ratio of the number of old and new applied information is not 1: 1. It is a flowchart for demonstrating operation | movement of the main key transfer / numbering process in the data creation assistance system for main key transfer / numbering apparatuses which concerns on embodiment of this invention. It is a figure which shows the structure of the data maintenance screen of the data creation assistance system for main key transfer / numbering apparatuses which concerns on embodiment of this invention. It is a figure which shows the structure of the consent check table registration screen of the data creation assistance system for main key transfer / numbering apparatuses which concerns on embodiment of this invention. It is a table | surface which shows the processing content in a data expansion | deployment process with respect to the condition when setting a value to a processing status flag and a processing status flag, and the value of a processing status flag. It is a figure which shows the table structure of the old registration basic | foundation part expansion | deployment data which concern on embodiment of this invention. It is a figure which shows the table structure of the registration basic part which concerns on embodiment of this invention. It is a figure which shows the table structure of the registration application part which concerns on embodiment of this invention. It is a figure which shows the table structure of the old registration application part expansion data which concerns on embodiment of this invention. It is a figure which shows the table structure of the maintenance registration application part expansion | deployment data which concerns on embodiment of this invention. It is a figure which shows the structure of the changed point output table which concerns on embodiment of this invention. It is a figure which shows the table structure of the last applied code master which concerns on embodiment of this invention. It is a figure which shows the table structure of the registration basic | foundation part expansion | deployment data which concern on embodiment of this invention. It is a figure which shows the table structure of the registration application part expansion | deployment data which concerns on embodiment of this invention. It is a figure which shows the structure of the consent check table which concerns on embodiment of this invention.

Explanation of symbols

1 Data import button 2 Data maintenance button 3 Consent check table registration button 4 Recovery button 5 Old and new data information display column 6 Status display column 7 Exit button 8 Menu screen
10 Data maintenance screen
11 Pesticide type combo box
12 Crop name combo box
13 New application information data grid
14 Old Application Information Data Grid
15 Pattern item selection combo box
16 Pattern selection combo box (new application information)
17 Pattern selection combo box (old application information)
18 Consent check table registration button
19 Number of differences display
20 Difference item selection combo box
21 Difference display (new application information)
22 Difference display (old application information)
23 Change registration button
24 New revocation registration button
25 Reset button
26 Back button
27 Number of new application information remaining
28 Number of old application information remaining
30 Consent check table registration screen
31 Item selection combo box
32 Registration category selection combo box
33 New application information item selection list
34 Old Application Information Item Selection List
35 Registration button
36 Check table data grid
37 Change button
38 Delete button
39 Primary key transfer process registration button
40 Back button
41 Step 1
42 Step 2
43 Step 3
44 Step 4
45 Step 5
46 Categorize applicable information as new / expired / changed
47 Application information without change
48 Change application information
49 New application information
50 Revocation information
100 Data creation support system for primary key transfer / numbering device
101 Data acquisition processing section
102 Database
103 Data expansion processor
104 Primary key transfer processing part
105 Data maintenance processing section
106 Consent Check Table Registration Processing Department
107 consent check table
321 Registered pesticide information (CSV file)
322 Registration Department (primary key transfer completed)
323 New information
324 Revocation information

Claims (8)

The last time fetches registration application of pesticides in the registration information by a menu screen data acquisition button that appears to the system startup personnel to manipulate data (application information) in the database as new data present in the database Data initialization processing means for processing the data of the registration application unit that has been captured and processed as old data;
Compare all items except the applicable code and registration update date for the new and old data processed by the data initialization processing means to identify new data that is the same as the old and new data, and separately number the old data when acquiring the data A primary key transfer means for transferring the primary key as the primary key of the new data;
Compare the registration number of the new and old data that could not be specified by comparing all items except the application code and registration renewal date. If a registration number that does not exist in the old data exists in the new data, it is treated as new data. If the registration number not included in the old data exists in the old data, it is treated as revocation data, a new primary key is assigned to the new data, and a revocation flag is set for the revocation data. When,
In the old and new data that could not be specified by the comparison of the registration number, for each of the registration numbers, one specified item consisting of items corresponding to the conditions when using the agricultural chemical of the registration application unit is compared, and the old and new data When the designated item is regarded as a match and the number of the old and new data is 1: 1, the old and new data are identified as the same data, and the primary key of the old data is transferred to the new data. A primary key transfer / change point output means for outputting an item having a change as a change point for all items including the specified item and an item corresponding to a pesticide use standard of the registration application unit;
For new and old data that could not be specified by comparing specified items that meet the conditions for using the agricultural chemicals in the registration application department, specify whether the person in charge is the same in the data maintenance process using the maintenance screen. When the same data is specified , the primary key is transferred in accordance with the instructions of the person in charge, and when it is not specified as the same data, if it is not in the old data but is present in the new data, it is treated as new data, Data maintenance process that treats as invalid data if it exists in old data but not in new data, assigns a new primary key to the new data, and sets a revocation flag in the invalid data according to the instructions of the person in charge Means,
A data creation support system for a primary key transfer / numbering device. When the person in charge operates the data maintenance button on the menu screen, a transition is made to the maintenance screen, and the old and new data that could not be specified by the comparison of the designated items is displayed on the maintenance screen, and the data maintenance processing means If the data is the same, change registration processing is performed and primary key transfer is performed, and changes related to comparison of all items including the specified item and items corresponding to the agricultural chemical use standards of the registration application unit are output. If the contents are not the same, a new / revocation registration process is performed to determine whether the information is new application information or revocation application information. When the data maintenance process is completed, the status display field on the menu screen is displayed. claim 1, wherein the displaying the operation-friendly data expand button and displays the completion of the data maintenance process The primary key transfer - numbering system for data creation support system as claimed. The maintenance screen includes a pesticide type combo box in which the person in charge selects a pesticide type name that requires maintenance, and a pesticide name combo box in which the person in charge selects a pesticide name in need of maintenance among the selected pesticide type names. A data grid for displaying data of the selected pesticide type and pesticide name, a pattern item selection combo box for the person in charge to select an item for narrowing down the pattern, and the data displayed in the data grid Pattern selection combo box that displays the value of the item selected by the person in charge in the pattern item selection combo box, consent check table registration button that displays the consent check table registration screen when the person in charge operates the button, new data and old before by the person in charge to button operation when the data is determined to be the same content A change registration button for outputting a selected row together that is displayed in the data grid as change data, when the new data and the old data is determined to be a different content person is displayed on the data grid by button operation the selected row of the new data to be output as the new data, or, claim 2, characterized in that it comprises, a new revocation registration button for outputting a selected row of the old data displayed on the data grid as stale data Data creation support system for primary key transfer / numbering device described in 1. When the person in charge operates the consent check table registration button after the old and new data displayed on the maintenance screen has the same content, the consent check table registration screen is displayed, and the consent check table registration screen is displayed. 4. The data creation support system for a main key transfer / numbering device according to claim 3, wherein the person in charge operates the registration button to reflect the contents in the agreement / non-agreement check table. In the consent check table registration screen, the person in charge selects whether to display / register an item selection combo box in which the person in charge selects an item to display / register the consent check table, and an agreement check table or a non-consent check table. A registered classification selection combo box, an information item selection list that displays a list of items selected by the person in charge using the item selection combo box in the data displayed on the data grid of the data maintenance screen, and the registered classification selection combo box in the case where the person in charge has selected the agreement, the information regarded as the selected content in the item selection list to be agreed, to register to agree check table at the touch of a button by the person in charge, also the person in charge at the registration classification selection combo box If There you select disagreement, the information pattern selection The selected content in the strike is regarded as not agree, and the registration button to register with the non-consent check table at the touch of a button by the person in charge, for the item selected in the item selection combo box, the person in charge at the registration classification selection combo box agreed upon selecting a consent agreement check table, also personnel registered by when selecting the non-consent and the check table data grid to display non-agreement check table, the person in charge of the registration button is pressed 5. A primary key transfer processing button for giving an instruction by operating a button by a person in charge in order to execute a primary key transfer process again using the check table / non-consent check table. Data creation support system for primary key transfer / numbering device. The check table data grid is editable by the person in charge, has a new input field at the bottom, and a change button that is registered by the person in charge of operating the button to register the edit contents of the check table data grid; And a delete button that is deleted by a person in charge operating the button to delete a selected row in the check table data grid. Creation support system. 2. The main key according to claim 1, wherein the person in charge operates the consent check table registration button on the menu screen to transition to the consent check table registration screen, and the registration contents of the consent check table can be viewed. Data creation support system for transfer / numbering equipment. The main key transfer / numbering device according to claim 1, wherein a maintenance registration application unit stored in the database is created by a person in charge operating a data expansion button on the menu screen. Data creation support system.