JP2012181787A - Schedule information extraction system and schedule information extraction program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a system in which an area described with the schedule content of every month based on date information of an annual schedule table is determined and the reading of the schedule content data is performed in the reading of information using a computer terminal.SOLUTION: A processor of the schedule information extraction system acquires a date area from an annual schedule table (tabular format data). Next, an area described with a schedule content is determined for every month in a rectangular format that does not overlap with the area of the other month. Then, schedule information containing the date and the schedule content is extracted from the data of the annual schedule table based on a schedule content area determined as the acquired data area.

Description

The present invention relates to reading information using a computer terminal, and more particularly to a technique for reading data included in an annual schedule table.

  Computer terminals such as personal computers and mobile phones are generally used as tools for schedule management. In recent years, a system in which a plurality of terminals are connected via a network and schedule information managed by individual terminals is jointly managed has been utilized. Schools and businesses are also using systems that jointly manage schedule information. If it is a company, it is being used in situations where schedule information is shared among members of a department. If it is a school, it is being used in situations where each teacher's schedule is jointly managed.

However, in order to utilize this system, it is necessary to input schedule information managed individually to the system. And the input work is troublesome. In particular, in schools, in addition to the schedule information of each teacher, an annual schedule table corresponding to school events and segregation of duties is often created in advance. If the contents of this annual schedule table are also jointly managed by the system, the effort for data entry will increase further. In addition, when data is manually input item by item, there is a risk of input errors.

As a means for solving the above problem, first, image data is acquired from the schedule table original by the image reading means. Next, the read image data is encoded by the character recognition means. There is a technique for registering encoded data in accordance with a database format. In this technique, first, a column item described in the first row of the schedule table is extracted. Next, the extracted data in the second and subsequent rows are stored in association with the previously extracted column item. Then, a means is used in which column items and database items are collated, and data is rearranged and registered at appropriate locations. Thereby, even if the table format of the schedule table document is different from the database format of the registration destination, the data can be automatically registered at an appropriate location. (See Patent Document 1)

In the same field, there is a technique of reading date information and schedule information from a calendar and registering the scheduler. In this technique, first, numbers and character colors indicating dates on a calendar are read. Next, the date is associated with the day of the week based on the read character color. And the means of extracting the schedule information relevant to the read date and registering in the appropriate part of a scheduler is used. Thereby, the registration of the calendar information in the scheduler can be made efficient. (See Patent Document 2)

JP-A-8-147329 JP 2007-128160 A

If the technique of Patent Literature 1 is used, the type of data read from the schedule table can be determined. As a result, the read data can be automatically registered in the system, and the input work can be saved. However, the table formats to which this technology can be applied are limited. Specifically, it is limited to a format in which column items are described in the first row of the table, or a format in which the date column position is fixed. For this reason, a schedule table having a plurality of table formats cannot cope with all of them. In particular, in the case of an annual schedule table, it is conceivable that the styles vary widely.

If the technique of patent document 2 is used, date information can be determined based on the color of the data read from the calendar. As a result, data corresponding to the date information can be determined as schedule information, and automatic registration in the scheduler becomes possible. However, this technique cannot be applied when the calendar is written in a single character color. This technique is applicable only to a limited format (format) called “calendar”. For this reason, the annual schedule table that has various formats cannot cope with all of them.

An object of the present invention is to solve the above-mentioned problems of the prior art. Specifically, an object of the present invention is to provide a system for extracting schedule information including date and schedule contents from data of an annual schedule table in an information reading technique using a computer terminal.

In order to solve the above problems, a date region extraction system according to the present invention includes a processing device that extracts information on an annual schedule table from tabular data, and a storage device that stores information on scheduled contents included in the annual schedule table. I have. Each device has the following characteristics. First, the processing apparatus plans to determine a date area acquisition unit that acquires a date area for each month in the schedule table, and a scheduled content area for each month based on the date area in a rectangular format that does not overlap with the areas of other months Based on a content area determination unit, a schedule information extraction unit that extracts dates and schedule contents in association with each other based on the date area and the schedule content area is provided. Next, the storage device includes a schedule content area storage unit that stores the schedule content area determined by the schedule content area determination unit, and a schedule information storage unit that stores the schedule information extracted by the schedule information extraction unit.

By adopting the configuration of the present invention, it is possible to determine an area in which the schedule for each month is described based on the date information in the annual schedule table. Furthermore, the schedule content related to the date information can be extracted from the determined area and stored. Thereby, a date and schedule contents can be extracted from an annual schedule table without omission.

Further, the scheduled content area determination unit included in the processing apparatus of the present invention includes a left end setting means for setting one of the date areas at the left end of the scheduled content area, and two or more date areas in the scheduled content area. It is good also as a structure of having the right end setting means which sets a right end so that it may not exist.

By adopting the configuration of the present invention, it is possible to determine a rectangular area that does not overlap with the scheduled content area of another month. This makes it possible to accurately determine the scheduled content area for each month.

The schedule information extraction unit included in the processing apparatus of the present invention includes period information search means for searching whether the schedule content in the extracted schedule information includes period information having a date or time, and period information. If there is a period information separating means for generating schedule information in a format in which the period information is separated from the schedule content, the schedule information storage unit in the storage device of the present invention has a period from the schedule content included in the schedule information. The information may be stored in a separated format.

By adopting the configuration of the present invention, it is possible to separate and extract information defining conditions such as start / end times for scheduled contents. As a result, it is possible to manage the schedule in a detailed format in which the extracted scheduled contents are associated with the time.

Moreover, the above-described features can be realized by causing the terminal of the present invention to read and execute the program. In other words, a program used for the schedule information extraction system, a date area acquisition function for acquiring date area information for each month in the schedule table, and a schedule content area determination function for determining a schedule content area for each month based on the date area The present invention may be configured as a program that causes a processing device to implement a schedule information extraction function for extracting schedule information in which date information and schedule contents are associated based on a date area and a schedule content area.

This information leakage prevention program also has the same effect as the information leakage prevention terminal described above.

The tabular data in the present invention refers to the entire tabular data in which numerical values and the like are input in a grid partitioned by ruled lines. Specifically, there is data created by spreadsheet software. Data read from a tabular printed matter by a scanner or the like is also included in the tabular data.

In the present invention, the annual schedule table refers to a schedule table in which schedules for one year are compiled into a form that can be referred to at a time. Specifically, there are various formats such as a schedule in which dates and schedules for one year are divided into months and summarized into one tabular data.

In the present invention, a section refers to “one grid” among a plurality of lattice areas generated by ruled lines or the like in tabular data. Specifically, there are “cells” in spreadsheet software.

Adjacent in the present invention refers to adjacent sections in the annual schedule table. Here, if the adjacent section is a section that does not include a numerical value (blank section), it may be determined that the adjacent sections are adjacent to each other by considering the relationship between the sections including the numerical value without taking that into consideration.

The region in the present invention refers to the entire area generated by aggregating a plurality of adjacent sections, and has a certain range. Specifically, there is a “selection range (range)” generated by designating a plurality of adjacent cells in spreadsheet software.

The date area in the present invention refers to an area in which sections into which information related to date is input are gathered. Specifically, in the annual schedule table, there is an area where dates are continuously input in the column direction.

The scheduled content area in the present invention refers to an area in which sections where scheduled contents and detailed information are input are gathered. Specifically, in the annual schedule table, an area where contents to be performed are continuously input in the row direction with respect to the date described can be considered.

Schedule information in the present invention refers to information associated with dates and schedule contents extracted from tabular data. Specifically, it is information in which a specific date is associated with the scheduled content corresponding to the date.

The term information in the present invention refers to information indicating the start / end time of the scheduled content, the execution period, etc. included in the scheduled content.

According to the present invention configured as described above, it is possible to determine an area in which the scheduled content of each month is described from date information included in tabular data. Furthermore, by determining the planned content area, it is possible to read the planned content data corresponding to each date. Thereby, even if it is an annual schedule table | surface with various styles, the effect that the information can be read using a computer terminal is acquired.

The conceptual diagram which shows the system configuration | structure (stand-alone type) of this invention. The conceptual diagram which shows the hardware constitutions of the theft condition determination system of this invention. 1 is a functional block diagram (outline) showing a system configuration in Embodiment 1. FIG. 1 is a functional block diagram (details) showing a system structure in Embodiment 1. FIG. The figure which shows an example of the tabular data produced | generated with spreadsheet software. The figure which shows an example of the tabular data produced | generated with spreadsheet software. 3 is a flowchart illustrating a processing process (1) according to the first embodiment. The figure which shows the process with respect to the display thing displayed on the display apparatus 4 of the terminal A. FIG. The figure which shows the tabular data memorize | stored in the tabular data storage part 20. FIG. The figure which shows the division information memorize | stored in the storage area of the numerical division detection part 12. FIG. The figure which shows the related area information memorize | stored in the related area memory | storage part. 5 is a flowchart illustrating a processing process (2) according to the first embodiment. The figure which shows the determination conditions which the determination condition production | generation means 14c produces | generates. The figure which shows the date area information memorize | stored in the date area memory | storage part 22. FIG. 6 is a flowchart illustrating a processing process (3) according to the first embodiment. The figure which shows the tabular data memorize | stored in the tabular data storage part 20. FIG. The figure which shows the date area | region information memorize | stored in the attached area | region memory | storage part 22. FIG. 6 is a flowchart illustrating a processing process (4) according to the first embodiment. The figure which shows the temporary area | region information which the left end setting means 16a produces | generates. The image figure of the right end setting process which the right end setting means 16b performs. The figure which shows an example of the tabular data memorize | stored in a tabular data storage part. The figure which shows the plan content area | region information memorize | stored in the plan content area | region memory | storage part 23. FIG. 6 is a flowchart illustrating a processing process (5) according to the first embodiment. The figure which shows the schedule information memorize | stored in the schedule information storage part 24. FIG. The figure which shows the information displayed on the display apparatus 4 of the terminal A. FIG. The conceptual diagram which shows the system configuration | structure (client server type) of this invention. FIG. 9 is a functional block diagram (outline) showing a system configuration in Embodiment 2. FIG. 12 is a functional block diagram (outline) showing a system configuration in Embodiment 3.

Hereinafter, embodiments of the present invention will be described with reference to the drawings. FIG. 1 conceptually shows an example of the overall configuration related to the present invention. As shown in FIG. 1A, the present invention is basically implemented in a stand-alone type having only a computer terminal A (hereinafter referred to as “terminal A”). Further, as shown in FIG. 1A, the terminal A and an information reading device such as a scanner (hereinafter referred to as “reading device B”) are connected via a communication network N (hereinafter referred to as “network N”). You may implement in the form of doing.

Next, the terminal A will be described. FIG. 2 conceptually shows an example of the hardware configuration of the terminal A. Inside the terminal A, at least the processing device 1, the storage device 2, the input device 3, the display device 4, and the communication device 5 are necessary. Further, an arithmetic device 6 and a control device 7 are necessary inside the processing device 1.

The processing device 1 refers to a CPU or the like that executes arithmetic processing of a program and outputs a control instruction to each device according to the result. The storage device 2 refers to a RAM or a hard disk that stores information. The input device 3 refers to a keyboard, mouse, or numeric keypad for inputting information. The display device 4 refers to a display (screen) for displaying information. The communication device 5 refers to a network interface that transmits and receives information. Each function (each unit) executed by the terminal A is realized by reading a program for executing the processing into the processing device 1.

Next, the reading device B will be described. The reading device B is a device that converts information read from a document into data and transfers it to the terminal A. Specifically, a scanner that can optically read characters and figures and transfer them as image data can be considered as an example.

Basically, the reading device B is directly connected to the terminal A and used as a part of the input device 3. In addition, the reading device B may be used in a form of being connected to the communication device 5 of the terminal A via the network N as shown in FIG.

Next, the network N will be described. The network N is a CSMA / CD (Carrier Sense Multiple Access With Collision) that includes a cable that physically transmits information in a limited facility such as a company or school, and a relay device such as a LAN switch or a hub. It means what is configured as a (Detection) type LAN. However, the present invention is not limited to this, and it may be configured by an intranet using Internet technology or by a WAN (Wide Area Network) technology.

Example 1 Configuration
Hereinafter, a first embodiment of the present invention will be described with reference to the drawings. In this example, a case where a stand-alone type embodiment is adopted will be described as an example.

FIG. 3 shows a functional block diagram in which functional features of the terminal A are blocked. In FIG. 3, from a logical viewpoint, each function of the present invention is distinguished and expressed as a component. Therefore, even if it is expressed as a separate component here, it may be composed of the same area physically. FIG. 3 shows only the minimum necessary devices and components in this embodiment, and other components are omitted.

Hereinafter, each component shown in FIG. 3 will be described.

The terminal A has a control interface 10 for transmitting and receiving information between the control device 1 and other devices (input device 3, display device 4, communication device 5).

The processing device 1 of the terminal A detects a tabular data acquisition unit 11 that acquires tabular data based on information acquired from the input device 3 via the control interface 10, and detects a partition including a numerical value from the acquired tabular data. Numeric partition detection unit 12, related region specifying unit 13 that identifies a related one of the detected numerical partitions as a related region, date region determination unit 14 that determines whether the specified related region is a date region, date determined from tabular data A date area acquisition unit 15 for acquiring an area, a schedule content area determination unit 16 for determining a schedule content area based on the acquired date area, and schedule information for extracting information from tabular data based on the date area and the schedule content area The extraction unit 17 includes a control unit 18 that controls each device of the terminal A according to the extracted schedule information.

The storage device 2 of the terminal A includes a tabular data storage unit 20 that stores the acquired tabular data, a related region storage unit 21 that stores the identified related region, a date region storage unit 22 that stores the determined date region, and a determination A scheduled content area storage unit 23 for storing the scheduled content area, and a schedule information storage unit 24 for storing the schedule information extracted from the tabular data.

Next, FIG. 4 shows a functional block diagram in which the constituent elements of the terminal A are further subdivided. In FIG. 4, components related to additional functions that can be realized in this embodiment are also shown.

Hereinafter, each component shown in FIG. 4 will be described. The description of the same components as those in FIG. 3 is omitted.

The related area specifying unit 13 of the processing apparatus 1 checks whether the numerical values in the numerical value sections are in ascending order in the column direction, and checks whether the numerical values in the numerical value areas are within a predetermined range. The range checking unit 13b and the related region specifying unit 13c for specifying the related region from the results of the array checking and the range checking are provided.

The date area determination unit 14 of the control device 1 adds a reference area determination unit 14a that uses one of the related areas that meet the predetermined condition as a reference area, and searches for a section that includes month information in a section adjacent to the reference area. The section search means 14b, the determination condition generation means 14c for generating a determination condition from the reference area and the additional section, and the date area determination means 14d for determining the date area based on the determination condition.

The scheduled content area determination unit 16 of the processing device 1 has a left end setting unit 16a that sets the date area to the left end of the scheduled content area, and converts the scheduled content area for each month into a rectangular format that does not overlap with the areas of other months. Right end setting means 16b. Here, it is preferable that the right end setting unit 16b performs a process of setting the right end so that the scheduled content area does not include two or more date areas.

The schedule information extraction unit 17 of the processing apparatus 1 includes schedule information extraction means 17a that extracts date information and schedule contents from the tabular data, and period information search means 17b that searches whether the extracted schedule contents include period information. And a period information separating means 17c for generating schedule information in a format in which the period information is separated from the schedule contents.

The processing device 1 of the terminal A further includes a date area counting unit 30 that counts the determined number of date areas, a day of the week area determination unit 31 that determines an area in which the day of the week is described from the tabular data, and the day of week area as the date area. An information conversion unit 32 that performs conversion processing on the information stored in the date area storage unit 22 in a replacement form.

[Example 1-Operation (1)]
Hereinafter, the operation of each component will be described with reference to the functional block diagram of FIG. First, operations of the input device 3 and the display device 4 will be described.

The input device 3 first designates storage location information of tabular data. Then, the designated storage location information is transmitted to the control interface 10. The storage location information is information indicating a location where tabular data is stored. Specifically, there is address information indicating a storage location in the hard disk of the terminal A.

As an example of a method for specifying the storage location information, a method using the display device 4 can be considered. Specifically, a display object (such as an icon) indicating the tabular data displayed on the display device 4 is designated by the input device 3. Then, the storage location information indicated by the designated display object is transmitted to the control interface 10.

Incidentally, there is a case where the reading device B directly connected to the terminal A is used as the input device 3. In this case, the reading device B executes a process of transmitting storage location information inside the device storing the tabular data read from the document to the control interface 10. In addition, an external storage medium (such as a USB memory) that stores tabular data may be used as the input device 3. In this case, the external storage medium executes a process of transmitting the storage location information storing the tabular data to the control interface 10.

[Example 1-Operation (2)]
Next, the operation of the components belonging to the processing apparatus 1 of the terminal A will be described.

The tabular data acquisition unit 11 first acquires storage location information in which tabular data is stored from the control interface 10. Next, tabular data specified from the acquired storage location information is acquired. Then, the acquired tabular data is transmitted to the tabular data storage unit 20 in the storage device 2.

First, the numerical section detection unit 12 acquires tabular data from the tabular data storage unit 20. Next, a section including a numerical value is detected in the tabular data, and section information indicating the section is generated.

The section information mentioned above refers to information indicating the position of the section. Specifically, when the tabular data is data created by spreadsheet software, it is address information indicating the position of the section. For example, in the case of tabular data created by spreadsheet software in which the column numbers are indicated by alphabets and the row numbers are indicated by numbers, the “third column from the left and the third row from the top” is indicated. The address information is indicated as “C3”. A specific example of tabular data generated by spreadsheet software will be described with reference to FIG. In FIG. 5, the address information indicating the section highlighted by the black thick frame is indicated as “C3”.

The array checking unit 13 a of the related area specifying unit 13 first acquires the block information of the numerical blocks adjacent in the column direction from the numerical block detector 12. At the same time, the tabular data is acquired from the tabular data storage unit 20. Next, the numerical values of the numerical partitions adjacent in the column direction are acquired using the acquired partition information and tabular data. Further, it is checked whether the extracted numerical values are in ascending order in the column direction. And the area | region information which shows the area | region of the numerical value division whose numerical value is ascending order is produced | generated, and it transmits to the range check means 13b.

The above area information refers to information indicating the position of the area. Specifically, when the tabular data is data created by spreadsheet software, it is address information indicating the position of the area. For example, in the case of tabular data created with spreadsheet software that shows the column number in alphabetical terms and the row number in numbers for the position of the area, from the section "third column from the left, third row from the top", Address information indicating the area up to the section “third column from the left and 15th row from the top” is indicated as “C3: C15”. Specifically, an example of tabular data generated by spreadsheet software will be described with reference to FIG. In FIG. 6, the address information indicating the section highlighted by the black thick frame is indicated as “C3: C15”.

The range checking unit 13b of the related area specifying unit 13 first acquires area information from the array checking unit 13a. At the same time, the tabular data is acquired from the tabular data storage unit 20. Next, using the acquired area information and tabular data, the numerical values of the numerical value sections constituting the area indicated by the area information are extracted. Further, it is checked whether or not the extracted numerical value is within a predetermined range. And the area information which shows the numerical division area where the numerical value is in the predetermined range is transmitted to the related area specifying means 13c.

The predetermined range refers to information indicating a range in which a lower limit and an upper limit of numerical values are set. Specifically, it shows a range of numerical values that can be determined as dates. For example, since the maximum number of days in a month is 31 days, the predetermined range is set to “1 to 31”.

The related area specifying unit 13c of the related area specifying unit 13 first acquires area information from the range condition checking means 13b. Then, the acquired area information is specified as related area information and transmitted to the related area information storage unit 21.

First, the reference area determination unit 14 a of the date area determination unit 14 acquires related area information from the related area storage unit 21. Next, a related area that matches a predetermined condition is determined as a reference area from the acquired related areas. Then, the determined reference area information is transmitted to the additional section search means 14b.

The predetermined condition refers to a condition stored in advance in the reference area determination unit 14a as a condition for determining the reference area. Specifically, related areas such as “the related area that is positioned at the leftmost of the tabular data” or “the related area that has 31 numerical divisions in the column direction” The positional relationship between them and the conditions related to the configuration can be considered. In any case, any condition may be used as long as it can determine a single reference area. Here, the positional relationship and configuration between related areas refers to a relative position (range) of the related area on the annual schedule table and a configuration of partitions in the related area.

The additional section search means 14b of the date area determination unit 14 first acquires reference area information from the reference area determination means 14a. Next, a section having month information is searched and specified in the section adjacent to the reference area. Then, the area information obtained by combining the reference area and the month information section is transmitted to the determination condition generation unit 14c.

Specifically, the section adjacent to the reference area refers to an area of three sections and four sides in the upper right direction from the upper end of the reference area. This condition is based on the prediction that the month information in the annual schedule table will typically be in a partition with some close proximity to the date domain. Therefore, the condition “three sections, four sides” described here is an example, and any condition may be set as long as it can be reasonably determined to be close to the date area to some extent.

The above-mentioned month information section refers to a section having month information included in the month and day. As a method for detecting the month information section, a method of detecting a section including a preset designated character may be used. Specifically, it is preferable to set a character often used for month information as a designated character. This includes predetermined numbers (such as “1” to “12”), predetermined Chinese numerals (such as “1” to “12”, “month”, etc.), and month information (“January”) in English. Etc.).

The determination condition generation unit 14c of the date region determination unit 14 first acquires region information from the additional section information search unit 14b. Next, a determination condition for determining the date area is generated from the acquired area information. Then, the generated determination condition is transmitted to the date area determination means 14d.

The above determination condition refers to a condition for determining a final date area in which month information is added to a date. Since this determination condition is generated based on the reference area, a unique condition is generated for each tabular data. For example, “Positional relationship or configuration between related areas”, “Relative positional relationship between related areas and a section including month information”, or “Partition configuration in related area and contents included in the section”, etc. Is considered as a determination condition.

Further, the above determination condition will be described in detail. Specifically, a determination condition relating to a numerical section having a date and a numerical section having month information is generated. For example, “Numerical sections in the related area in the column direction are from 28 sections to 31 sections”, “Numerical values in the related area are 28 or more consecutive in the column direction”, “In the related area Are in the ascending order in the column direction within the range of 1 to 31, "" the section adjacent to the left of the top section of the related area is the month information section "," The determination condition indicating the content such as “the content of each section includes the information of month and day” is generated.

The date area determination unit 14d of the date area determination unit 14 first acquires a determination condition from the determination condition generation unit 14c. At the same time, the related area information is also acquired from the related area storage unit 21. In addition, tabular data is also acquired from the tabular data storage unit 20. Next, it is determined whether each of the related areas specified from the acquired related area information and the tabular data corresponds to a date area using a determination condition. Then, the area information indicating the determined date area is transmitted to the date area storage unit 22 as the date area information. The same date area information is also transmitted to the date area counting unit 30.

The date area information is information indicating the position of the date area in each month. Specifically, it refers to address information having month information that uniquely identifies each month in the annual schedule table and information indicating the range of the date area.

The date area counting unit 30 first acquires date area information from the date area determination unit 14d. Next, the number of date area information is counted and compared with a predetermined reference value. Then, as a result of the comparison, when the reference value is not satisfied, a processing start instruction is transmitted to the day-of-week area determination unit 30.

The day-of-week region determination unit 31 first acquires a processing start instruction from the date region number counting unit 30. At the same time, the tabular data is acquired from the tabular data storage unit 20. Next, a day-of-week area in which day-of-week information is described is detected from the tabular data. Then, the day-of-week area information regarding the detected day-of-week area is determined.

The information conversion unit 32 first acquires day-of-week area information from the day-of-week area determination unit 31. Next, the area information of the day of the week area is converted as date area information. Then, the converted date area information is transmitted to the date area storage unit 22.

By providing the date area counting unit 30, day of the week area determining unit 31, and information converting unit 32, an effect that the range of the table format that can be handled by the present invention is widened is obtained. For example, in the annual schedule table, it is possible to correspond to a table format in which the date is described only in one area and each month is divided only in the day of the week area.

The date area acquisition unit 15 first acquires date area information from the date area storage unit 22. Then, the acquired date area information is transmitted to the scheduled content area determination unit 16.

The left end setting means 16a of the scheduled content area determination unit 16 first generates temporary area information in order to determine the scheduled content area for each month. Next, date area information of each month is acquired from the date area acquisition unit 15. Further, the acquired date area information is set to the left end of the corresponding temporary area information for each month, and temporary area information (left end set) is generated. Then, the generated temporary area information (left end set) is transmitted to the right end setting means 16b.

The temporary area information refers to template information (area information format) generated for determining area information of the scheduled content area for each month. In this model, there are a place (space) for inputting month information and a place for inputting the left end and the right end of the scheduled content area. Incidentally, it is assumed that the month information in the newly generated temporary area information is automatically input based on the acquired date area information.

The right end setting unit 16b of the scheduled content area determination unit 16 first acquires temporary area information (left end set) from the left end setting unit 16a. Next, the right end of the temporary area information is expanded line by line in the line direction, and the maximum range is determined as the right end in a rectangular area that does not overlap with other date areas. Further, the address information indicating the rightmost section is set in a form to be added to the temporary area information (the left end has been set), and the scheduled content area information is generated. At this time, a rectangular area that does not include two or more date areas in the temporary area is generated, and address information indicating the right end of the area is set at the right end of the temporary area information. Then, the generated scheduled content area information is transmitted to the scheduled content area storage unit 23.

The scheduled content area information is information indicating the position of the scheduled content area in each month. Specifically, it refers to address information having month information for uniquely identifying each month in the annual schedule table and information indicating the range of the scheduled content area including the left and right ends of the area.

The schedule information extraction unit 17 a of the schedule information extraction unit 17 first acquires date area information from the date area storage unit 22. Furthermore, schedule content area information is acquired from the schedule content area storage unit 23. In addition, the tabular data is acquired from the tabular data storage unit 20. Next, the date and schedule content that can be specified from the acquired date area information and schedule content area information are extracted from the tabular data as schedule information. Then, the extracted schedule information is transmitted to the period information search means 17b.

The period information search means 17b of the schedule information extraction unit 17 first acquires schedule information from the schedule information extraction means 17a. Next, it is searched whether the schedule information in the schedule information includes the period information indicating the date or time. Further, it is classified into schedule information having schedule contents including period information and other schedule information. Then, the schedule information including the period information is transmitted to the period information separation means 17c, and other schedule information is transmitted to the schedule information storage unit 24.

The period information refers to information that is included in the schedule content and indicates the start / end time of the schedule content, the execution period, and the like. Specifically, it refers to information described in the scheduled content area in the format of “10:00 start” or “from 15th to 18th” together with the scheduled content. As a method for detecting the period information, a method of detecting a designated notation set in advance may be used. Specifically, a notation in which numbers and symbols indicating time information are integrated (such as “10:00”), and a notation in which numbers indicating date and kanji are integrated (such as “15 days”) are determined in advance. A method of detecting it can be considered.

The period information separation means 17c of the schedule information extraction unit 17 first acquires schedule information including period information from the period information search means 17b. Next, the period information is separated from the schedule contents in the schedule information. Further, the schedule information is generated by associating the date, the schedule content, and the period information, and transmitted to the schedule information storage unit 24.

First, the control unit 18 acquires various control instruction information from the input device 3 and the communication device 5 via the control interface 10. Furthermore, schedule information is acquired from the schedule information storage unit 24 in accordance with the contents of the acquired control instruction information. Next, response control information corresponding to control instruction information from each device of the terminal A is generated using the acquired schedule information. Then, the generated response control information is transmitted to the control interface 10. Each control device of the terminal A executes processing according to the response control information acquired through the control interface 10. Specifically, the content to be displayed on the display device 4 is transmitted as response control information in accordance with an instruction from the input device 3, or is transmitted to another terminal via the network N in accordance with an instruction from the communication device 5. A case where the content is transmitted as response control information is considered as an example.

Note that, even when there is no instruction from the input device 3 or the communication device 5, the control unit 18 generates control information based on the schedule information generated by reading the tabular data, and the control information is transmitted to the control interface. 10 may be transmitted to each device of terminal A. Specifically, for the user of the terminal A, based on the schedule information stored in the schedule information storage unit 24, the user's action plan for the week is displayed on the display device 4, or the start time of the schedule information In order to notify the user that it has become, the notification information is generated and displayed on the display device 4 or the notification information is generated to notify the user of the latest schedule information whose start time is closest from the current date and time. 4 may be displayed.

[Example 1-Operation (3)]
The operation of the components belonging to the storage device 2 of the terminal A will be described.

The tabular data storage unit 20 stores tabular data acquired from the format data acquisition unit 11. The tabular data storage unit 20 refers to a storage area specially generated in the storage device 2 for processing execution. A storage area (for example, a clipboard) for temporarily storing data is also included.

The related area storage unit 21 stores related area information acquired from the related area specifying unit 13c. The individual related area information is stored in a distinguishable form.

The date area storage unit 22 stores the date area information acquired from the date area determination unit 14d. Further, the date area information after conversion acquired from the information conversion unit 31 is also stored in a form added to the already stored date area information. The date area information is stored in an identifiable state as to which month's date area information.

The scheduled content area storage unit 23 stores the scheduled content area information acquired from the right end setting means 16b. The scheduled content area information is stored in an identifiable state as to which month's scheduled content area information.

The schedule information storage unit 24 stores the schedule information acquired from the period information search unit 17b and the period information separation unit 17c. The schedule information is stored in a state in which at least one or more of month / date / plan contents / period information is associated. Further, each schedule information is stored in an identifiable state.

By adopting the above-described configuration, even if it is an annual schedule table with various formats, the information can be read using a computer terminal. Further, the schedule information storage unit 24 in which the read data is stored can be used as a schedule information database.

[Example 1-Treatment process (1)]
Next, an example of a processing process in the information leakage prevention system of the present invention will be described with reference to the functional block diagram of FIG. 4 and the flowchart of FIG. First, a processing process from acquisition of tabular data to storage of related information will be described below.

The input device 3 designates tabular data in which an annual schedule table is described (S101). In this processing process, a case where designation is performed by operating a display object of tabular data displayed on the display device 4 will be described as an example. Specifically, a format in which tabular data is specified by dragging and dropping an icon into a predetermined window with a mouse cursor is conceivable. An example of this processing is shown in FIG. By this processing, the address information of the tabular data is transmitted to the tabular data acquisition unit 11 via the control interface 10.

The tabular data acquisition unit 11 acquires target tabular data from the acquired address information. Then, the acquired tabular data is stored in the tabular data storage unit 20 (S102). An example of tabular data stored in the tabular data storage unit 20 is shown in FIG.

The numerical value section detection unit 12 searches for a section including a numerical value from the tabular data, and generates the section information. Then, the partition information is stored in a storage area inside itself (S103). FIG. 10 shows an example of the section information generated when the tabular data is FIG.

The information acquisition means of the related area specifying unit 13 detects a set of block information adjacent in the column direction from the storage area of the numerical value block detection unit 12, and extracts each set (S104). When the partition information is stored as shown in FIG. 10, the sets to be extracted (hereinafter referred to as target sets) are “A5 to A34”, “C10 / C11”, “C16 / C17”, “D30 / D31”. ”,“ E5-E35 ”,“ H28 / H29 ”,“ I5-I34 ”,“ K19-K22 ”,“ L32 / L33 ”,“ M5-M35 ”,“ O9-O12 ”,“ O24-O27 ”, “P26 / P27” and “Q5 to Q35”.

The information acquisition unit of the related area specifying unit 13 extracts the target set one by one and passes it to the array checking unit 13a. As soon as the processing after the array checking means 13a for one set is completed, the process of extracting and passing the next set is repeatedly executed. This iterative process is executed from the storage area of the numerical value section detection unit 12 until there is no target set (S105).

The array checking means 13a extracts the numerical values of the sections indicated by the acquired numerical section information, and checks whether they are in ascending order in the column direction (S106). First, a case where the target set “A5 to A34” is acquired will be described. First, the numerical values “1, 2, 3,..., 30” of the sections indicated by the respective numerical section information are extracted. Here, since the extracted numerical values are in ascending order, the verification result is no problem. Then, region information “A5: A34” in which the target set “A5 to A34” is combined into one region is generated and passed to the range checking unit 13b. In addition, when the same value continues, you may make it consider as an ascending order.

Next, a case where the target set “C10 / C11” is acquired will be described. First, the numerical values “10:00, 9:00” of the sections indicated by each numerical section information are extracted. Here, since the extracted numerical values are not in ascending order, it is determined that “C10” and “C11” are not related, and “C11” is deleted from the target set. At this time, since the number of partition information remaining in the target set (the number of remaining partition information) is 1, the processing for this target set ends at this point (S107). Then, the process proceeds to extraction of the next target set (S104).

The range checking means 13b extracts a numerical value in the acquired area information, and checks that the numerical value is within a predetermined range (S108). The predetermined range here is a range of numbers representing dates, and specifically refers to “1 or more and 31 or less”. First, a case where the area information “A5: A34” is acquired will be described. First, the numerical values “1, 2, 3,..., 30” in the region information are extracted. Here, since the extracted numerical value is within a predetermined range of “1 or more and 31 or less”, the region information “A5: A34” is passed to the related region specifying unit 13c as it is, assuming that there is no problem with the verification result.

Next, a case where the area information “D16: D17” is acquired will be described. First, the numerical value “2, 45” in the region information is extracted. Here, since the extracted numerical value “45” is out of the predetermined range, “D17” having a numerical value not satisfying the condition is deleted from the region information. At this time, since the number of partition information remaining in the region information (the number of remaining partition information) is 1, the processing for this region information ends at this point (S109). Then, the process proceeds to extraction of the next target set (S104).

The related area specifying unit 13c specifies the area information acquired from the range checking unit 13c as related area information, and stores it in the related area storage unit 21 (S108). FIG. 11 shows an example of related area information stored in the related area storage unit 21 by repeating the processes from (S104) to (S108) when the section information is stored as shown in FIG.

[Example 1-Treatment process (2)]
Next, an example of a processing process until the date area information is stored will be described with reference to the functional block diagram of FIG. 4 and the flowchart of FIG.

The reference area determination unit 14a determines one area information as the reference area information from the related area information stored in the related area storage unit 21 (S201). The determination of the reference area information is performed based on a predetermined condition set in advance. Predetermined conditions in this processing process are “the related area having 28 or more numeric sections in the column direction” and “the identification number is the worst”. The identification number in this processing process refers to a number that can uniquely identify the related area information stored in the related area storage unit 21, and is assigned sequentially in the order stored in the related area storage unit 21. This is the number to be assigned. When the related area information is stored as shown in FIG. 11, the reference area information is determined as “A5: A34”. Then, the determined reference area information “A5: A34” is transferred to the additional section search means 14b.

The additional section search unit 14b searches for a predetermined range of sections having the month information from the acquired reference area information, and identifies it as an additional section for the reference area (S202). The retrieval of the month information section uses a method of retrieving a section including a designated character set in advance for the three sections and four areas from the upper end of the reference area. Designated characters in this processing process are numbers (“1” to “12”) and “month”. When the tabular data acquired from the tabular data acquisition unit 20 is as shown in FIG. 9, the additional section is identified as “A3”. Then, the reference area information “A5: A34” and the additional section information “A3” are passed to the determination condition generation unit 14c. As another identification method, only the designated character “month” is first searched, and a section including the designated character is identified as additional section information. A method of separately acquiring numerical values included on the left and right of the designated character “month” as month data is also conceivable.

As a method for specifying the reference area and the additional section, another embodiment as follows can be considered. First, the reference area determination unit 14 a acquires related area information stored in the related area storage unit 21 and tabular data from the tabular data storage unit 20. Next, the section having the data “April” is identified in the section adjacent to the acquired related area. Then, the related area close to the specified section is determined as the reference area, and at the same time, the section having the data “April” is specified as the additional section.

Further, as another means for determining the reference region, the following other embodiments are also conceivable. First, the reference area determination unit 14 a acquires related area information stored in the related area storage unit 21 and tabular data from the tabular data storage unit 20. Next, a section having data related to an event that is surely performed in April, such as “entrance ceremony” and “starting ceremony”, is specified in a section adjacent to the acquired related area. Then, the related area close to the specified section is determined as the reference area.

The determination condition generation unit 14c generates a determination condition for determining a date area from the related area stored in the related area storage unit based on the acquired reference area information and additional partition information (S203). The determination condition indicates a relative position between a numerical value section having a date and a numerical value section having month information, and a configuration of the numerical value section having a date. Here, when the acquired information is the reference area information “A5: A34” / additional section information “A3”, an example of the determination condition generated is shown in FIG. Then, the generated determination condition is passed to the date area determination unit 14d.

Next, the case where the related area information “M5: M35” is acquired will be described. First, it is determined whether or not the condition No. 1 shown in FIG. In this case, it is determined that the related area information “E5: E35” conforms to the condition, and then the process proceeds to execution of the determination condition 2.

The date area determination unit 14d compares the acquired related area information with the generated determination condition 1, and determines whether the condition is satisfied (S206). First, the case where the related area information “K19: K22” is acquired will be described. First, it is determined whether or not the condition No. 1 shown in FIG. In this case, it is determined that the related area information “K19: K22” does not meet the conditions. At this point, the processing for the related area information “K19: K22” is completed (S207). Then, the process proceeds to extraction of next related area information (S204).

Next, the case where the related area information “M5: M35” is acquired will be described. First, it is determined whether or not the condition No. 1 shown in FIG. In this case, it is determined that the related area information “E5: E35” conforms to the condition, and then the process proceeds to execution of the determination condition 2.

The date area determination unit 14d performs the determination condition 2 on the related area information that has passed the determination condition 1 (S208). Specifically, the case of the related area information “M5: M35” will be described. First, the month information section “M3” is determined according to the condition of condition number 2 shown in FIG. Further, based on the tabular data acquired from the tabular data storage unit 20, the month information “7” of the month information section “M3” is acquired.

Subsequently, the date area determination unit 14d generates date area information for each month from the acquired related area information and month information, and stores the date area information in the date area information storage unit 22 (S209). The format of the date area information stored here is generated in the form of “(month information) / (related area information)”. For example, if the related area information “M5: M35” and the month information “7” are acquired, date area information “7 / M5: M35” is generated. FIG. 14 shows an example of the date area information stored in the date area storage unit 22 by repeating the processes from (S204) to (S209) when the related area information is stored as shown in FIG. .

In this process, if no month information can be acquired, cancel the determination condition 2 regarding the acquisition of month information and regenerate the determination condition 2, or cancel the currently set reference area The regeneration of the determination condition 1 is executed, or one of them is executed.

[Example 1-Treatment process (3)]
Next, an example of a processing process until the date area information is additionally stored will be described with reference to the functional block diagram of FIG. 4 and the flowchart of FIG.

The date area counting unit 30 acquires date area information from the date area determination unit 14d and counts the number of information (S301). Next, the counted result is compared with the reference value, and when the reference value is exceeded, the subsequent storage process of the date area information that follows (the process executed by the day-of-week area determination unit 30 and the information conversion unit 31) ) Is not performed (S302). If the reference value is less than or equal to the reference value, a start notification of execution of additional storage processing of date region information is transmitted to the day of week region determining unit 31.

The reference value is a predicted value of the number of date area information determined by the date area determination unit. In the case of the annual schedule table, since the schedule for 12 months is described, it is predicted that the number of date area information to be determined will be 12. Therefore, this reference value is generally set to “11”. However, as in the tabular data shown in FIG. 16, there is a tabular format in which a date area exists only at the left end, and the month and month separation is performed in the day of the week area. In this processing process, processing when the tabular data shown in FIG. 16 is handled will be described.

The day-of-week region determination unit 31 detects a day-of-week region in which day-of-week information is stored from the tabular data acquired from the tabular data storage unit 20. At this time, it is preferable to set a condition that areas having predetermined kanji characters (“month”, “fire”, etc.) indicating day information detect areas adjacent to 28 or more areas in the column direction. In this processing process, when the tabular data to be acquired is as shown in FIG. 16, the determined day-of-week area information is “B5: B34”, “E5: E35”, “H5: H34”, “K5: K35”. , “N5: N35”. Then, the determined day-of-week area information is stored in a storage area within itself (S303).

First, the information conversion unit 32 extracts day-of-week region information one by one from the storage region of the day-of-week region determination unit 31 (S304). The information conversion unit 32 repeatedly executes a process of extracting the next day-of-week area information as soon as the information conversion process for one day-of-week area information and the additional storage process for the date area information are completed. This iterative process is executed until there is no day of week area information stored in the storage area of the day of week area determination unit 31 (S305).

The information conversion unit 32 converts the acquired day of the week area information into date area information. The case where the day-of-week area information “B5: B34” is acquired will be described as an example. First, the day-of-week area information “B5: B34” is rewritten with the date area information “B5: B34”. Further, in order to execute the process of reading the date from the tabular data in this system, additional information for rewriting the day of the week to the date is added (S306).

Then, the information conversion unit 32 adds and stores the converted date area information and additional information in the date information storage unit 22 (S307). FIG. 17 shows an example of date area information stored in the date area storage unit 22 by repeating the processes from (S304) to (S307).

[Example 1-Treatment process (4)]
Next, an example of a processing process until the scheduled content area information is stored will be described with reference to the functional block diagram of FIG. 4 and the flowchart of FIG.

The date area acquisition unit 15 acquires date area information (area for one month) one by one from the date area storage unit 22 (S401). The date area acquisition unit 15 repeatedly executes the process of acquiring the next date area information as soon as the scheduled content information determination process for one date area information is completed. This iterative process is executed until there is no unprocessed information in the storage area information stored in the date area storage unit 22 (S402).

The left end setting means 16a first generates temporary area information using the month information included in the acquired date area information (S403). Hereinafter, a case where the date area information stored in the date area storage unit 22 is as illustrated in FIG. 14 will be described. FIG. 19A shows an example of temporary area information generated when the date area acquisition unit 15 acquires the date area information “4 / A5: A34” in this case.

Next, the left end setting means 16a sets the left end of the temporary area information using the area information included in the acquired date area information (S404). The temporary area information in this processing process is a rectangular format generated in the form of “(month information) / (left end) / (right end)”. FIG. 19A shows an example of temporary area information (left end set) that is generated when the date area information “April / A5: A34” is acquired. Then, the generated temporary area information (left end set) is transferred to the right end setting means 16b. The information indicating the rectangular format may be any information as long as the rectangular format is determined, such as “(month information) / (upper left corner) / (lower right corner)”.

The right end setting means 16b sets the right end so that the acquired temporary area information (left end has been set) does not include two or more date areas in the area (S405). Hereinafter, a case where the tabular data acquired from the tabular data storage unit 20 is as illustrated in FIG. 9 will be described as an example.

The right end setting means 16b expands the right end of the temporary area information “4 / A5: A34 / −” one column at a time in the row direction. At this time, it is expanded to the maximum range that does not overlap with other date areas (a range in which two or more date areas are not included in the area), and the area information is set at the right end of the temporary area information. An image of the right end setting process is shown in FIG.

As a setting method at the right end other than the above, the following method may be adopted. Specifically, the right end setting means 16b first widens the right end of the temporary area information “4 / A5: A34 / −” one column at a time in the row direction. At this time, it expands to a range that overlaps with other date areas (a range that includes two or more date areas in the area), and the adjacent area information before the left end in the overlapped date area is set at the right end of the temporary area information It is a method of doing.

Then, the right end setting means 16b determines the generated temporary area information “4 / A5: A34 / D5: D34” as the scheduled content information and stores it in the scheduled content area storage unit 23 (S406). Further, by executing the scheduled content area determination process of this processing process, it is also possible to determine the scheduled content area of the tabular data as shown in FIG.

FIG. 22 shows an example of scheduled content area information stored in the planned content area storage unit 23 by repeating the processes from (S401) to (S406).

[Example 1-Treatment process (5)]
Subsequently, an example of a processing process from extraction to storage of schedule information will be described with reference to the functional block diagram of FIG. 4 and the flowchart of FIG.

The information acquisition means of the schedule information extraction unit 17 acquires the date region information and the schedule content region information from the date region storage unit 22 and the scheduled content region storage unit 23 one month at a time, and stores them in its own storage region ( S501). As soon as the process after the schedule information extracting means 17a for the acquired one month is completed, the process of extracting and storing information for the next one month is repeatedly executed. This iterative process is executed until there is no unprocessed information in the date area storage unit 22 and the scheduled content area storage unit 23 (S502).

Hereinafter, the information stored in the date area storage unit 21 is as shown in FIG. 14, the information stored in the scheduled content area storage unit is as shown in FIG. 22, and further, the tabular data storage unit 20 The case where the tabular data acquired from the table is as shown in FIG. At this time, it is assumed that the date area information for April and the schedule content area information are stored in the storage area of the schedule information extraction unit 17.

The schedule information extraction unit 17a first extracts one date from the tabular data based on the date area information (S503). As soon as the schedule information extraction and registration process for one extracted date is completed, the process of extracting the next date is repeatedly executed. This iterative process is executed until there is no unextracted date in the area indicated by the date area information (S504).

The schedule information extraction unit 17a first extracts one date from the tabular data based on the date area information (S503). As soon as the schedule information extraction and registration process for one extracted date is completed, the process of extracting the next date is repeatedly executed. This iterative process is executed until there is no unextracted date in the area indicated by the date area information (S504).

More specifically, the schedule information extraction unit 17a first extracts the first date “1” in the area specified by the date area information “4 / A5: A34”, and executes subsequent schedule information extraction / registration processing. To do. When the processing for the date “1” is completed, the date “2” is extracted and the same processing is executed. This process is repeated, and when the processing of the date “30” is completed, there is no unextracted date. Therefore, the processing moves to the extraction processing of the date area information and scheduled content area information in the next month information “5”.

Next, the schedule information extraction means 17a extracts the schedule content corresponding to the extracted date from the tabular data based on the schedule content area information (S505). For example, when the date “1” is extracted, the scheduled content is extracted from the corresponding region information “B5: D5” according to the scheduled content region information “4 / A5: A34 / D5: D34”. At this time, it may be set to exclude information indicating day information from extraction targets. As a result of this extraction process, the scheduled content “Simultaneous appointment date” is acquired. Then, the acquired date and the schedule content are associated with each other as schedule information, which is passed to the period information search means 17b. The schedule information generated here has a format of “(date) / (schedule content)”. When the above processing is performed, the schedule information “1 / one simultaneous appointment date” is generated.

The period information search means 17b searches whether or not the period information is included in the acquired schedule information (S506). If the period information is not included as a result of the search, schedule information in which there is no period information is generated and stored in the schedule information storage unit 26 (S507, S509). The schedule information generated here has a format of “(date) / (schedule content) / (period information)”. For example, when the schedule information “1 / one simultaneous appointment date” is acquired, the period information search means 17b first searches the period information and confirms that the schedule content “simultaneous appointment date” does not include the period information. . Then, schedule information “1 / simultaneous appointment date / −” is generated and stored in the schedule information storage unit 24.

On the other hand, if the period information is included in the acquired schedule information as a result of the search, the period information search unit 17b passes the schedule information to the period information separation unit 17c (S507). For example, when the schedule information “6 / starting ceremony 10:00:00” is acquired, the period information search unit 17b detects that the period information “10:00:00” is included as a result of the search. Then, the acquired schedule information “6 / starting ceremony 10: 00 to 00” is transferred to the period information separating means 17c.

The period information separating unit 17c generates schedule information in a form in which the period information is separated from the schedule contents in the acquired schedule information (S508). Then, the newly generated schedule information is stored in the schedule information storage unit 24 (S509). For example, when the schedule information “6 / starting ceremony 10: 00” is acquired, first, the period information “10: 00” is separated from the scheduled content “starting ceremony 10: 00”. Next, schedule information “6 / starting ceremony / 10: 00 to 00” obtained by separating the period information is generated. Then, the process is performed in a flow of storing the generated schedule information “6 / starting ceremony / 10: 00 to 00” in the schedule information storage unit 24.

When two or more schedule contents exist on one date, the schedule information is generated in a format of “(month information) / (date) / (schedule contents 1) / (schedule contents 2)”. . When the schedule information includes the period information, the schedule information is “(month information) / (date) / (schedule contents 1) / (schedule contents 2) / (period information 1) / (period information 2)”. It will be in the form. Furthermore, the schedule information is not limited to the above-described format, and any method may be used as long as the format indicates the schedule information.

FIG. 24 shows an example of schedule information stored in the schedule information storage unit 24 by repeating the processes from (S501) to (S509).

[Example 1-Treatment process (6)]
Finally, an example of processing in the control unit 18 will be described with reference to the functional block diagram of FIG.

The control unit 18 acquires an instruction from the input device 3 via the control interface 10 and generates control information based on the acquired information. For example, this is the case where information to be displayed on the display of terminal A is generated in accordance with an input instruction from the user of terminal A.

The control unit 18 uses the information stored in the schedule information storage unit 24 to generate information to be displayed on the display device 4 and transmits the information to the display device 4 via the control interface 10. An example of information displayed on the display device 4 (display of terminal A) is shown in FIG.

The second embodiment of the present invention will be described below with reference to the drawings. In this example, a case where a client server type embodiment is adopted will be described as an example.

First, an embodiment of the present invention will be described with reference to the drawings. FIG. 26 conceptually shows an example of the overall configuration when the present invention is executed in a client-server type. As shown in FIG. 26, the terminal A and a schedule data management server (hereinafter referred to as “management server C”) are connected via a network N.

Next, the management server C will be described. The hardware configuration of the management server C is almost the same as the hardware configuration of the terminal A shown in FIG. Inside the management server C, at least the processing device 1, the storage device 2, and the communication device 5 are necessary. It is good also as a structure provided with the input device 3 and the display apparatus 4 as needed. Further, an arithmetic device 6 and a control device 7 are necessary inside the processing device 1.

FIG. 27 is a functional block diagram in which functional features of the system configured by the terminal A and the management server C are blocked. In FIG. 27, from a logical viewpoint, each function of the present invention is distinguished and expressed as a component. Therefore, even if it is expressed as a separate component here, it may be composed of the same area physically. FIG. 27 shows only the minimum necessary devices and components in this embodiment, and other components are omitted.

In the system according to this embodiment, the terminal A performs processing for determining a date area in tabular data. Then, the management server C performs processing for extracting schedule information from the tabular data. As described above, the present embodiment is different from the first embodiment in that the terminal A and the management server C execute the processing in a divided manner.

Hereinafter, each component shown in FIG. 27 will be described. In addition, the same code | symbol is attached | subjected to the same component etc. as [Example 1-configuration]. In addition, descriptions of operations and processes in the same components as in the first embodiment are omitted.

The terminal A has a terminal control interface 10a for transmitting and receiving information between the terminal control device 1a and other devices (terminal input device 3a, terminal display device 4a, and terminal communication device 5a).

The terminal processing device 1a includes a tabular data acquisition unit (terminal) 11a that acquires tabular data based on information acquired from the terminal input device 3a via the terminal control interface 10a, and a date area determined as the acquired tabular data. Is transmitted to the management server C. The transmission data generation unit 41 is generated. The terminal storage device 2a includes a tabular data storage unit (terminal) 20a that stores the acquired tabular data. This is different from the first embodiment.

The management server C has a server control interface 10c for transmitting and receiving information between the server control device 1c and other devices (server input device 3c, server display device 4c, server communication device 5c).

The server processing device 1c includes a tabular data acquisition unit (server) 11c that acquires tabular data from data received from the server communication device 5c via the server control interface 10c.
A date area acquisition unit 15 that acquires date area information from data received via the server control interface 10c is provided. The server storage device 2c includes a tabular data storage unit (server) 20c that stores the acquired tabular data. This is different from the first embodiment.

With the above-described configuration, the management server C can collectively perform the process of extracting the schedule information from the tabular data. Thereby, there is an effect that the processing load of the terminal A can be reduced.

Hereinafter, a third embodiment of the present invention will be described with reference to the drawings. In this example, a case where a client server type embodiment is adopted will be described as an example.

Further, in this embodiment, when date area information in the tabular data is determined in advance (for example, when the user of the terminal A himself / herself looks at the tabular data to generate date area information, The processing related to the case where the date area information is predetermined in the accompanying format will be described. That is, in the terminal A, an embodiment in which the process for determining the date area is not performed is performed. In this respect, the present embodiment is different from the second embodiment.

FIG. 28 is a functional block diagram in which functional features of the system configured by the terminal A and the management server C are blocked. In FIG. 28, each function of the present invention is distinguished and expressed as a component from a logical viewpoint. Therefore, even if it is expressed as a separate component here, it may be composed of the same area physically. FIG. 28 shows only the minimum necessary devices and components in the present embodiment, and other components are omitted.

Hereinafter, each component shown in FIG. 28 will be described. In addition, the same code | symbol is attached | subjected to the same component etc. as Example 2. FIG. In addition, descriptions of operations and processes in the same components as in the second embodiment are omitted.

The terminal processing device 1a includes a date region acquisition unit (terminal) 15a that acquires date region information based on information acquired from the terminal input device 3a via the terminal control interface 10a. This is different from the second embodiment.

With the above-described configuration, it is possible to cope with the case where the date area information of the tabular data is determined in advance.

A: Terminal B: Reading device C: Management server N: Network 1: Processing device 1a: Terminal processing device 1c: Server processing device 2: Storage device 2a: Terminal storage device 2c: Server storage device 3: Input device 3a: Terminal input Device 3c: Server input device 4: Display device 4a: Terminal display device 4c: Server display device 5: Communication device 5a: Terminal communication device 5c: Server communication device 6: Arithmetic device 7: Control device 10: Control interface 10a: Terminal control Interface 10c: Server control interface 11: Tabular data acquisition unit 11a: Tabular data acquisition unit (terminal)
11c: tabular data acquisition unit (server)
12: Numerical value section detection unit 13: Related region specifying unit 13a: Array checking unit 13b: Range checking unit 13c: Related region specifying unit 14: Date region determining unit 14a: Reference region determining unit 14b: Additional block searching unit 14c: Determination condition Generation unit 14d: Date region determination unit 15: Date region acquisition unit 15a: Date region acquisition unit (terminal)
15c: Date area acquisition unit (server)
16: Schedule content area determination unit 16a: Left end setting unit 16b: Right end setting unit 17: Schedule information extraction unit 17a: Schedule information extraction unit 17b: Period information search unit 17c: Period information separation unit 18: Control unit 20: Tabular data Storage unit 20a: Tabular data storage unit (terminal)
20c: Tabular data storage unit (server)
21: Related region storage unit 22: Date region storage unit 23: Schedule content region storage unit 24: Schedule information storage unit 30: Date region counting unit 31: Day of week region determination unit 32: Information conversion unit 41: Transmission data generation unit

Claims (4)

A processing device that extracts information about the annual schedule table from tabular data;
A storage device for storing information on the scheduled contents included in the annual schedule table;
A schedule information extraction system comprising:
The processor is
A date area acquisition unit for acquiring a date area for each month in the schedule table;
A scheduled content area determination unit that determines a scheduled content area for each month based on the date area in a rectangular format that does not overlap with the areas of other months;
Based on the date area and the scheduled content area,
A schedule information extraction unit that extracts dates and schedule contents as schedule information in association with each other;
With
The storage device
A scheduled content area storage unit for storing the scheduled content area determined by the scheduled content area determination unit;
A schedule information storage unit for storing the schedule information extracted by the schedule information extraction unit;
A schedule information extraction system comprising: The scheduled content area determination unit in the processing device,
Left end setting means for setting one of the date areas to the left end of the scheduled content area;
A right end setting means for setting a right end so that two or more date areas are not included in the scheduled content area;
The schedule information extraction system according to claim 1, further comprising: The schedule information extraction unit in the processing device,
Period information search means for searching whether the schedule content in the extracted schedule information includes period information having a date or time;
If the period information is included, it has period information separating means for generating schedule information in a format in which the period information is separated from the schedule content,
The schedule information storage unit in the storage device,
The schedule information extraction system according to claim 1, wherein the period information is stored in a format separated from schedule contents included in the schedule information. A processing device that extracts information about the annual schedule table from tabular data;
A storage device for storing information on the scheduled contents included in the annual schedule table;
A program used for a schedule information extraction system comprising:
In the processing device,
A date area acquisition function for acquiring date area information for each month in the schedule table;
A scheduled content area determination function for determining a scheduled content area for each month based on the date area;
Based on the date area and the scheduled content area,
A schedule information extraction function for extracting schedule information in which date information and schedule contents are associated;
The schedule information extraction program characterized by realizing.

Images