File conversion system and method for electronic report management

Abstract

The invention provides a file conversion system and a file conversion method for electronic report management, which are used for easily and quickly publishing data generated in a measuring device in an Excel report. The present invention is characterized by comprising: a data input unit for receiving data generated by a measurement device; a data storage unit for storing the data input to the data input unit in a database; and a measurement item list generation unit for calling the data stored in the database and generating a measurement item list. A report generation unit that calls an Excel report to be mapped to the measurement item list generated by the measurement item list generation unit; a mapping unit that maps data called by the measurement item list generation unit to cells on the Excel report called by the report generation unit; and a report storage unit for storing the Excel report mapped by the mapping unit.

Description

Technical Field

[0001] The present invention relates to a file conversion system and method for managing electronic reports, and more particularly, to a file conversion system and method for managing electronic reports that can easily and quickly publish data generated in a measurement device on an Excel report. Background Art

[0002] With the rapid development of various technologies, new products are now appearing rapidly in various fields such as mobile communications, electrical electronics, semiconductors, medical, life engineering, and programming. As the technological strength of this industry increases, the testing and certification technology for the technology and products and the management technology for the certification results need to be advanced.

[0003] The advancement of product testing and certification technology not only strengthens the international technological competitiveness of the relevant products, but is also directly related to ensuring national safety and reliability. Therefore, there is a method to achieve technological advancement by improving the certification accuracy of testing and certification technology, and it can also be achieved by improving the method of managing reports based on testing and certification results more effectively and easily.

[0004] In particular, the measurement data generated by the three-dimensional measuring instrument is output in a format determined by the different software used by the measuring instrument manufacturer. In this case, the data output in the file according to the unique format needs to be stored in a database or a macro program (macro) is used to write a report in order to write an individual report.

[0005] This type of report sheet requires different management depending on the contracting company, and different formats of report sheets need to be managed according to different production departments. Summary of the invention

[0006] Technical issues

[0007] Therefore, the present invention is proposed to improve the above-mentioned conventional problems, and its object is to provide a new form of electronic report management file conversion system and method that can easily and quickly publish data generated in a measurement device on an Excel report.

[0008] In particular, its purpose is to provide a new form of file conversion system and method for electronic report management, which recognizes data in various formats generated by a three-dimensional measurement device, inputs them into a database, and calls the database data, so that the user can directly specify the required cells on the Excel report and enter the data.

[0009] Technical Solution

[0010] The present invention for achieving the above-mentioned purpose is characterized in that it includes: a data input unit for receiving data generated in a measuring device, a data storage unit for storing the data input to the data input unit in a database, a measurement item list generating unit for calling the data stored in the database and generating a measurement item list, a report generating unit for calling an Excel report for mapping with the measurement item list generated in the measurement item list generating unit, a mapping unit for mapping the data called in the measurement item list generating unit to cells on an Excel report called by the report generating unit, and a report storage unit for storing the Excel report mapped by the mapping unit.

[0011] In the file conversion system for electronic report management according to the present invention as described above, it is characterized in that the above-mentioned mapping unit includes a cell setting unit for mapping the values ​​of the above-mentioned measurement item list on the cells of the above-mentioned Excel report, and a cell output unit for outputting the values ​​of the above-mentioned measurement item list mapped by the above-mentioned cell setting unit on the above-mentioned Excel report.

[0012] Furthermore, in the file conversion system for electronic report management according to the present invention, it is characterized in that the above-mentioned cell setting unit includes an individual cell specifying unit for individually mapping the values ​​of the above-mentioned measurement item list to cells on the above-mentioned Excel report, a range specifying unit for specifying a cell range on the above-mentioned Excel report and mapping the values ​​of the above-mentioned measurement item list, and a manual specifying unit for directly inputting the cell coordinates on the above-mentioned Excel report and mapping the values ​​of the above-mentioned measurement item list.

[0013] Furthermore, in the electronic report management file conversion system according to the present invention, the range designation unit sets the output direction and number of cells on the Excel report.

[0014] According to the file conversion system for electronic report management of the present invention as described above, it is characterized in that when the values ​​of the measurement item list mapped by the cell setting unit are output on the Excel report, the cell output unit sets the output direction and quantity of the cells on the Excel report for output.

[0015] Furthermore, in the file conversion system for electronic report management according to the present invention, it is characterized in that the above-mentioned cell output unit includes a mapping cell output unit that outputs the values ​​of the above-mentioned measurement item list mapped by the above-mentioned cell setting unit on the above-mentioned Excel report, and an automatic cell output unit that outputs the above-mentioned measurement item list generated in the above-mentioned measurement item list generation unit as a whole on the above-mentioned Excel report.

[0016] Furthermore, in the file conversion system for electronic report management according to the present invention, it is characterized in that the above-mentioned cell output unit includes an output storage unit that stores the above-mentioned measurement item list output by the above-mentioned mapping cell output unit or the automatic cell output unit on the above-mentioned Excel report.

[0017] According to the electronic report management file conversion system of the present invention as described above, the measurement item list generating unit forms a graph of the measurement item list imported from the database.

[0018] Furthermore, the file conversion method for electronic report management according to the present invention is characterized in that it includes: a data storage step of storing data generated in a measuring device in a database; a data calling step of calling the data stored in the database; an Excel report calling step of calling an Excel report prepared as a report; a mapping step of mapping the data and the Excel report called in the above data calling step and the Excel report calling step; and a step of storing the data and the Excel report mapped in the above mapping step.

[0019] Furthermore, in the file conversion method for electronic report management according to the present invention, it is characterized in that the above-mentioned mapping step includes: a cell mapping step of mapping data and an Excel report through a cell setting part including a separate cell designation part, a range designation part, and a manual designation part, wherein the separate cell designation part maps the data separately to cells on the Excel report, the range designation part specifies a cell range on the Excel report to map the data, and the manual designation part directly inputs cell coordinates and maps the data on the Excel report; a cell output step of outputting and storing the mapped data and the Excel report through a cell output part including a mapping cell output part and an automatic cell output part, wherein the mapping cell output part outputs the data mapped by the cell setting part on the Excel report, and the automatic cell output part outputs the data on the Excel report.

[0020] Effects of the Invention

[0021] According to the electronic report management file conversion system and method of the present invention as described above, it is possible to easily and quickly publish data generated in a measurement device on an Excel report.

[0022] In particular, by identifying data in various formats generated by the three-dimensional measurement device, entering it into a database, and calling the data in the above database, the user can directly specify the required cells on the Excel report and enter the data, thereby providing an effective data management system.

[0023] In addition, cells in the measurement item list and Excel report can be mapped one-to-one to minimize confusion when mapping data. Even if cells are added, deleted, or moved, settings can be easily changed by simply remapping, which provides convenience in use.

[0024] Furthermore, by providing a list of measurement items imported from the database in the form of a graph, there is an effect of being able to effectively manage the life and replacement cycle of the tools of the measurement device. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] Figure 1 A block diagram showing the technical features of the electronic report management file conversion system according to a preferred embodiment of the present invention.

[0026] Figure 2 A block diagram showing the technical features of a mapping unit in a file conversion system for electronic report management according to a preferred embodiment of the present invention.

[0027] Figure 3 A block diagram showing a file conversion method for electronic report management according to a preferred embodiment of the present invention is shown.

[0028] Figure 4 This is a diagram showing a main screen of a program for constructing a file conversion system for electronic report management according to a preferred embodiment of the present invention.

[0029] Figures 5 to 8 This is a diagram for explaining a plurality of icons formed on the main screen of a program for constructing a file conversion system for electronic report management according to a preferred embodiment of the present invention.

[0030] Fig. 9 and Fig.10 FIG. 1 is a diagram for explaining a basic mapping method using a program for constructing a file conversion system for electronic report management according to a preferred embodiment of the present invention.

[0031] Figures 11 to 18 It is a diagram specifically showing a mapping method using a program for constructing a file conversion system for electronic report management according to a preferred embodiment of the present invention.

[0032] Description of Reference Numerals

[0033] 100: Document conversion system for electronic report management

[0034] 200: Data input department

[0035] 300: Data storage department

[0036] 400: Measurement item list generation unit

[0037] 500: Report generation department

[0038] 600: Mapping Department

[0039] 610: Cell setting unit 611: Individual cell specifying unit

[0040] 612: Range specifying unit 613: Manual specifying unit

[0041] 620: Cell output unit 621: Mapping cell output unit

[0042] 622: Automatic cell output unit 623: Output storage unit

[0043] 700: Report sheet storage unit DETAILED DESCRIPTION

[0044] The advantages and features of the present invention and methods for achieving these are described in detail in the accompanying drawings. Figure 1 This will become clear from the embodiments described in detail later.

[0045] However, the present invention is not limited to the embodiments disclosed below, but can be implemented in different forms. However, this embodiment makes the disclosure of the present invention complete and is provided to fully inform the scope of the invention to ordinary technicians in the technical field to which the present invention belongs. The present invention is only defined by the scope of the claims.

[0046] Furthermore, the terms used in this specification are for describing the embodiments rather than limiting the present invention.

[0047] In this specification, as long as there is no special mention of the singular form in a sentence, the plural form is also included. The use of "comprises" and / or "comprising" in the specification does not exclude the existence or addition of other technical features other than the mentioned technical features.

[0048] Unless otherwise defined, all terms (including technical and scientific terms) used in this specification may be used as the meanings commonly understood by one of ordinary skill in the art to which the present invention belongs.

[0049] Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings. Figures 1 to 18 Technical features that perform the same function are marked with the same reference numerals.

[0050] On the other hand, in the illustrations and detailed descriptions of the accompanying drawings, detailed descriptions and illustrations of specific technical ideas and functions of elements that are not directly related to the technical features of the present invention are omitted, and only the technical structure related to the present invention is simply illustrated or explained.

[0051] refer to Figure 1 and Figure 2The electronic report management file conversion system 100 according to a preferred embodiment of the present invention includes a data input unit 200, a data storage unit 300, a measurement item list generation unit 400, a report generation unit 500, a mapping unit 600, and a report storage unit 700.

[0052] On the other hand, the electronic report management file conversion system 100 is provided by an electronic report management program implemented in the computer of the report writer, and specifically has a program form, and each component can execute the detailed functions of the program.

[0053] The electronic report management file conversion system 100 according to the preferred embodiment of the present invention can be roughly divided into a structure for collecting data, a structure for mapping reports, and a structure for outputting reports.

[0054] The structure for collecting data includes a data input unit 200 , a data storage unit 300 , and a measurement item list generating unit 400 .

[0055] Furthermore, the structure of the mapping report includes a report generating unit 500 and a mapping unit 600 .

[0056] Finally, the structure for outputting a report includes a report storage unit 700 .

[0057] Next, the structure of collecting data will be described.

[0058] The data input unit 200 receives data generated in the measurement device.

[0059] Also, the data input unit 200 may receive result data including a plurality of result items generated in the measurement device and a plurality of data corresponding to the result items.

[0060] The result data generated in the above-mentioned measuring device is generated in a plurality of formats. At this time, when the result data in a plurality of formats is formed in any one of DOCX, DOC, RTF, XLSX, XLS, CSV, TXT and HTML, it is converted into TXT format and received by the data input unit 200.

[0061] On the other hand, the above-mentioned measuring device is preferably a three-dimensional measuring device, but data can also be generated by a two-dimensional measuring device.

[0062] The measuring device as described above preferably uses a ZEISS measuring instrument, a Mitutoyo measuring instrument, or a Hexagon measuring instrument, but this is merely an example, and various changes and modifications can be made without departing from the technical idea of ​​the present invention, which is easily understandable to a person skilled in the art.

[0063] Also, the data storage unit 300 stores the data input to the data input unit 200 in a database.

[0064] like Figure 4 As shown, once the file conversion start icon is clicked, the result data received by the data input unit 200 is stored in the database.

[0065] At this time, if the file is successfully converted, the converted file is stored in the OK folder of the backup folder of the database. When the conversion fails, it can be stored in the FAIL folder of the backup folder.

[0066] Also, the measurement item list generating unit 400 generates a measurement item list by calling the data stored in the database.

[0067] If data stored in a database is selected in the measurement item list, the data stored in the database (ie, measurement items) can be checked in the measurement item list.

[0068] Furthermore, the measurement item list may include cell location, number of items, item description, reference value, etc.

[0069] However, the cell position of the measurement item list is displayed in an unselected state.

[0070] At this time, the measurement item list generating unit 400 forms a graph of the measurement item list imported from the database.

[0071] As described above, by providing the measurement item list imported from the database in the form of a graph, the life and replacement cycle of the tool of the measurement device can be effectively managed.

[0072] Next, the structure of the mapping report will be described.

[0073] The structure for mapping the above-mentioned report includes a report generating unit 500 and a mapping unit 600 .

[0074] The report generating unit 500 calls an Excel report for mapping with the measurement item list generated by the measurement item list generating unit 400 .

[0075] Then, the mapping unit 600 maps the data called by the measurement item list generating unit to cells on the Excel report called by the report generating unit 500 .

[0076] Next, the mapping unit 600 may include a cell setting unit 610 for mapping the values ​​of the measurement item list to cells of the Excel report, and a cell output unit 620 for outputting the values ​​of the measurement item list mapped by the cell setting unit 610 on the Excel report.

[0077] At this time, the cell setting unit 610 sets the cell position of the measurement item list and the cell position on the Excel report to be the same.

[0078] In more detail, the cell setting unit 610 includes an individual cell specifying unit 611 , a range specifying unit 612 , and a manual specifying unit 613 .

[0079] First, the individual cell designating unit 611 maps the values ​​of the measurement item list to individual cells on the Excel report.

[0080] Furthermore, observing the structure mapped by the above-mentioned individual cell designation unit 611, if a cell on an Excel report sheet is designated by the above-mentioned individual cell designation unit 611, and the cell position on the measurement item list is designated, the cell position of the measurement item list is displayed at a position corresponding to the cell on the above-mentioned Excel report sheet, and the cell on the Excel report sheet and the value of the above-mentioned measurement item list are mapped correspondingly.

[0081] Furthermore, the range designation unit 612 is used to designate a cell range on the Excel report to map the values ​​of the measurement item list.

[0082] In particular, the range designation unit 612 may set the output direction and number of cells on the Excel report.

[0083] Looking at the structure mapped by the above-mentioned range designation unit 612, the horizontal or vertical direction is set, and the number of cells selected according to the set direction is set.

[0084] As described above, as the number of cells is set, the cell positions of the measurement item list are displayed at positions corresponding to the cells on the Excel report, and the cells on the Excel report and the values ​​of the measurement item list are mapped in correspondence.

[0085] Next, the manual designation unit 613 is used to directly input the cell coordinates on the Excel report to map the values ​​of the measurement item list.

[0086] Looking at the structure mapped by the manual designation unit 613, the manual designation unit directly inputs the cell position (ie, coordinates) on the Excel report sheet, and maps the cell position value of the measurement item list to the cell position on the Excel report sheet.

[0087] On the other hand, the specific mapping structure of the cell setting unit 610 will be described in detail later.

[0088] Furthermore, the cell output unit 620 is used to output the values ​​of the measurement item list mapped by the cell setting unit 610 on an Excel report.

[0089] That is, when the cell position on the measurement item list is set by the cell setting unit 610, the measurement item list is output on the Excel report.

[0090] At this time, when the cell output unit 620 outputs the values ​​of the measurement item list mapped by the cell setting unit 610 on the Excel report, it sets and outputs the output direction of the cells on the Excel report and the number of cells selected according to the set direction.

[0091] The cell output unit 620 described above includes a mapping cell output unit 621 , an automatic cell output unit 622 , and an output storage unit 623 .

[0092] In particular, the mapping cell output unit 621 outputs the values ​​of the measurement item list mapped by the cell setting unit 610 on an Excel report.

[0093] Furthermore, the automatic cell output unit 622 outputs the entire measurement item list generated by the measurement item list generating unit 400 on an Excel report.

[0094] Furthermore, the output storage unit 623 stores the measurement item list outputted by the map cell output unit 621 or the automatic cell output unit 622 on an Excel report.

[0095] Finally, the structure for outputting a report includes a report storage unit 700 .

[0096] More specifically, the report storage unit 700 stores the Excel report mapped by the mapping unit 600 .

[0097] At this time, when storing the above Excel report, you can directly store the original or save it with another name.

[0098] Figure 3 It is a block diagram showing a file conversion method for electronic report management according to a preferred embodiment of the present invention.

[0099] refer to Figure 3According to a preferred embodiment of the present invention, a file conversion method for electronic report management includes a data storage step (S100) of storing data generated in a measuring device in a database, a data calling step (S200) of calling the data stored in the database, an Excel report calling step (S300) of calling an Excel report written as a report, a mapping step (S400) of mapping the data and Excel report called in the above data calling step and the Excel report calling step, and a storage step (S500) of storing the data and Excel report mapped in the above mapping step (S400).

[0100] on the other hand, Figure 4 This is a diagram showing a main screen of a program for constructing a file conversion system for electronic report management according to a preferred embodiment of the present invention.

[0101] Before describing the electronic report management file conversion method according to the preferred embodiment of the present invention, Figure 4 , first explain the basic screen of the program as follows.

[0102] The present invention relates to an electronic report management program implemented in a report writer's computer, wherein a main screen is composed of a plurality of icons for executing preset functions based on the writer's input.

[0103] At this time, a plurality of icons are preferably formed at an upper end portion of the screen, and a function execution portion for mapping is preferably formed at a right side portion.

[0104] Furthermore, a display window for displaying an Excel report is formed on the lower side of the upper end portion where the plurality of icons are formed and on the left side of the function execution portion formed on the right side.

[0105] In more detail, the multiple icons formed at the upper end of the above-mentioned screen collect data to form icons related to the output of the report, which may include a file conversion start icon, a database import icon, a measurement value list icon, an Excel file import icon, an Excel file storage icon, an Excel file save as icon, an Excel file close icon, a personalization setting icon, etc.

[0106] Furthermore, the function execution unit located on the right side of the above screen forms icons related to report mapping, an Excel setting unit formed by a cell setting unit and a cell output unit, and a chart unit that charts data called from a database.

[0107] At this time, a measurement item list for displaying data retrieved from the database is displayed at the upper end portion forming the Excel setting portion and the graph portion.

[0108] Furthermore, a plurality of icons formed at the upper end of the above-mentioned screen will be described.

[0109] First, the file conversion start icon is used to convert the data stored in the setting file of the program lock setting and store it in the database.

[0110] And, the above-mentioned database import icon is used to import the converted file (ie, result data).

[0111] Furthermore, the measurement value list icon calls up a list of measurement values ​​stored in the database, and individual measurement values ​​can be checked.

[0112] Next, the Excel file import icon imports the Excel file written as a report, and the Excel file storage icon modifies the imported Excel file or rewrites it and stores it.

[0113] Furthermore, the Excel file save as icon modifies or rewrites the imported Excel file and saves it under another name, and the Excel file close icon closes the opened Excel file.

[0114] Furthermore, the above-mentioned personalized setting icon can set or change the program usage environment.

[0115] Next, the function execution unit located on the right side of the screen will be described.

[0116] The measurement item list formed on the upper right side of the above screen displays the data imported by the database import icon.

[0117] At this time, the measurement item list may include cell location, number of items, item description, reference value, etc.

[0118] Furthermore, function buttons for mapping the data and the Excel report sheet and outputting and storing the same are formed at the bottom of the measurement item list.

[0119] Return, refer to Figure 4 The program description shown is as follows of a file conversion method for electronic report management according to a preferred embodiment of the present invention.

[0120] The file conversion method for electronic report management of the present invention includes a data storage step (S100), a data calling step (S200), an Excel report calling step (S300), a mapping step (S400) and a storage step (S500).

[0121] First, the data storage step (S100) is a step of storing data generated in the measurement device in a database.

[0122] In particular, since the data generated in the above-mentioned measuring device is generated in a format different from that of the above-mentioned measuring device, it is converted into TXT format and stored using an additional program.

[0123] The data in various formats generated in the above-mentioned measuring device may be generated in any one of DOCX, DOC, RTF, XLSX, XLS, CSV, TXT and HTML.

[0124] At this time, the data to be converted is placed in the folder generated when the program is set up, and once the file conversion start icon is clicked on the program screen, the converted data can be stored in the above-mentioned database.

[0125] In particular, when the file conversion start icon is clicked to execute, an additional window for uploading files is executed, and when the execution is completed, a confirmation window related to the converted files is displayed on the screen.

[0126] At this time, if the file conversion is successful, the converted file is stored in the OK folder in the backup folder of the database. If the file conversion fails, the unconverted file can be stored in the FAIL folder in the backup folder.

[0127] Next, the data calling step (S200) is a step of calling the data stored in the database, and the data can be called by importing icons into the database.

[0128] If you click the data import icon above, Figure 5 An additional window is displayed as shown, and the converted file contents can be confirmed.

[0129] At this time, when there are multiple data stored, the user can choose.

[0130] On the other hand, when selecting data stored in a database, Figure 6 The selected data is displayed in the measurement item list of the basic screen.

[0131] On the other hand, when data is displayed on the above measurement item list, the data can be displayed as follows: Figure 7 The results are graphically displayed on the screen as shown.

[0132] Next, the Excel report calling step (S300) is a step of calling the Excel report written as a report.

[0133] The Excel report calling step (S300) imports icons through Excel files, such as Figure 8 The call shown is an Excel report written as a report.

[0134] Furthermore, the mapping step (S400) is a step of mapping the data and the Excel report sheet called in the data calling step (S200) and the Excel report sheet calling step (S300), which includes a cell mapping step (S410) and a cell output step (S420).

[0135] The above-mentioned cell mapping step (S410) first specifies the cell position on the Excel report form, and when the cell setting button is clicked after specifying the cell position of order 1 on the measurement item list, the cell position of order 1 on the measurement item list is mapped in a state mapped with the cell position on the Excel report form.

[0136] Repeat the above sequence, such as Fig. 9 The cell locations shown map to the cell locations on the Excel report sheet and the cell locations on the measurement item list.

[0137] On the other hand, in a preferred embodiment of the present invention, the cell position on the Excel report form is first specified, and the cell position of the measurement item list is specified before clicking the cell setting button. However, even if the cell position on the measurement item list is first specified, and the cell position on the Excel report form is specified before clicking the cell setting button, the cell positions of the Excel report form and the measurement item list can be mapped to each other.

[0138] The cell output step (S420) is a step for displaying the cell position of the measurement item list in the Excel report sheet mapped in the cell mapping step (S410). If the Excel output input button is clicked, Fig.10 As shown, the cell positions of the Excel report and the cell positions of the measurement item list are mapped, and the data of the measurement item list is output on the Excel report.

[0139] Next, the storage step (S500) is a step of storing the data mapped in the mapping step (S400) and the Excel report.

[0140] The Excel report of the above mapping can be stored through the Excel file storage icon or the Excel file save as icon.

[0141] Figures 11 to 18 The above-mentioned mapping steps are specifically shown.

[0142] Figures 11 to 17 is a diagram showing the cell mapping step ( S410 ) of the above-mentioned mapping step ( S400 ).

[0143] refer to Figures 11 to 17The above-mentioned cell mapping step (S410) is a step of mapping the data and the Excel report form through a cell setting part including a separate cell designation part for mapping the data separately to cells on the Excel report form, a range designation part for mapping the data by specifying a cell range on the Excel report form, and a manual designation part for directly inputting the cell coordinates on the Excel report form.

[0144] Specifically, the process of mapping the data and the Excel report sheet through the above-mentioned individual cell designation unit is checked, and the individual cell designation part is checked in the above-mentioned cell setting unit.

[0145] Afterwards, if Fig.11 Specify the cell location on the Excel report as shown, and Fig.12 The cell position shown specifies the order 1 on the measurement item list.

[0146] As mentioned above Fig.11 and Fig.12 After completing the above cell position designation, if you click the cell setting button at the end, the following Fig.13 The cell position of Order 1 in the measurement item list is mapped to the cell position on the Excel report sheet.

[0147] Furthermore, to check the process of mapping data and Excel report through the above range designation section, check the range designation part in the above cell setting section.

[0148] Afterwards, if Fig.14 Specify the horizontal or vertical orientation of the cells and the number of cells.

[0149] In a preferred embodiment of the present invention, the direction of the cell is specified as vertical, and the number of cells is specified as five.

[0150] If the direction and number of cells are specified, then Fig.15 Specify the cell location on the Excel report as shown, and Fig.16 The cell position shown specifies the order 1 of the measurement item list.

[0151] As mentioned above Fig.15 and Fig.16 After the cell position is specified, if the cell setting button is clicked at the end, the Fig.17 The cell positions of the order 1 to 5 of the measurement item list are mapped to the cell positions on the Excel report sheet.

[0152] Furthermore, the process of mapping the data and the Excel report sheet through the manual designation section is checked, and the manual designation portion is checked in the cell setting section.

[0153] Manual designation directly inputs the coordinates of a cell, which consists of designating the cell coordinates and designating the measurement items.

[0154] The cell coordinate designation directly inputs the cell coordinates on the Excel report, and the measurement item designation can set the order on the measurement item list.

[0155] Fig.18 It is a diagram showing the above-mentioned cell output step (S420).

[0156] refer to Fig.18 The above-mentioned cell output step (S420) is implemented by a cell output unit, and the above-mentioned cell output unit includes a mapping cell output unit that outputs the data mapped by the cell setting unit on an Excel report sheet and an automatic cell output unit that outputs the data on an Excel report sheet. The data of the measurement item list is output on the Excel report sheet through the above-mentioned cell output unit.

[0157] The cell output unit can set the number of output values, output values, output direction, etc.

[0158] The number of the above output values ​​is set in the output direction set on the Excel report sheet.

[0159] The output of the above mapping cell is as follows Figure 4 The function is executed by clicking the Output Excel Input icon as shown, and as Fig.18 As shown, the data mapped in the above-mentioned cell mapping step (S410) (ie, the measurement item list) is output on an Excel report sheet.

[0160] Furthermore, the automatic cell output section is as follows: Figure 4 The function is executed by clicking the output Excel automatic input icon, and when the output Excel automatic input icon is clicked, the data of the measurement item list are output on the Excel report sheet.

[0161] As described above, according to the file conversion system for electronic report management according to the present invention, there is an effect that data generated in a measurement device can be easily and quickly published on an Excel report.

[0162] In particular, by recognizing data in various formats generated in the three-dimensional measurement device and inputting them into a database, the user can directly specify and input the data input into the above database into the desired cells on the Excel report, thereby providing an effective data management system.

[0163] In addition, cells in the measurement item list and Excel report can be mapped one-to-one to minimize confusion when mapping data. Even if cells are added, deleted, or moved, settings can be easily changed by simply remapping, which provides convenience in use.

[0164] Furthermore, by providing a list of measurement items imported from the database in the form of a graph, the life and replacement cycle of the tools of the measurement device can be effectively managed.

[0165] As described above, the present invention is described with reference to the embodiments shown in the figures, but this is only used to illustrate the invention, and a person skilled in the art to which the present invention belongs should understand that a variety of variations or equivalent embodiments can be implemented from the content of the invention.

[0166] Therefore, the true scope of rights of the present invention should be determined by the technical idea of ​​the claims.

[0167] According to the features of the present invention for achieving the above-mentioned purpose, it includes a data input unit 200 for inputting data generated in the measuring device, a data storage unit 300 for storing the data input to the above-mentioned data input unit 200 in a database, a measurement item list generating unit 400 for calling the data stored in the above-mentioned database and generating a measurement item list, a report generating unit 500 for calling an Excel report for mapping with the measurement item list generated in the above-mentioned measurement item list generating unit 400, a mapping unit 600 for mapping the data called in the above-mentioned measurement item list generating unit to cells on the Excel report called by the above-mentioned report generating unit 500, and a report storage unit 700 for storing the above-mentioned Excel report mapped by the above-mentioned mapping unit 600.

[0168] According to the file conversion system for electronic report management of the present invention as described above, the mapping unit 600 includes a cell setting unit 610 for mapping the values ​​of the measurement item list on the cells of the Excel report, and a cell output unit 620 for outputting the values ​​of the measurement item list mapped by the cell setting unit 610 on the Excel report.

[0169] Furthermore, in the file conversion system for electronic report management according to the present invention, the cell setting unit 610 includes a separate cell designation unit 611 for mapping the values ​​of the measurement item list separately to cells on the Excel report, a range designation unit 612 for designating a cell range on the Excel report and mapping the values ​​of the measurement item list, and a manual designation unit 613 for directly inputting the cell coordinates on the Excel report and mapping the values ​​of the measurement item list.

[0170] Furthermore, according to the electronic report management file conversion system of the present invention, the range designation unit 612 sets the output direction and number of cells on the Excel report.

[0171] According to the file conversion system for electronic report management of the present invention as described above, when the values ​​of the measurement item list mapped by the cell setting unit 610 are output on the Excel report, the cell output unit 620 sets the output direction and quantity of the cells on the Excel report for output.

[0172] Furthermore, in the file conversion system for electronic report management according to the present invention, the cell output unit 620 includes a mapping cell output unit 621 that outputs the values ​​of the measurement item list mapped by the cell setting unit 610 on the Excel report, and an automatic cell output unit 622 that outputs the entire measurement item list generated in the measurement item list generating unit 400 on the Excel report.

[0173] Furthermore, in the file conversion system for electronic report management according to the present invention, the cell output unit 620 includes an output storage unit 623 that stores the measurement item list output by the mapping cell output unit 621 or the automatic cell output unit 622 on the Excel report.

[0174] According to the electronic report management file conversion system of the present invention as described above, the measurement item list generating unit 400 forms a graph of the measurement item list imported from the database.

[0175] Furthermore, in the file conversion method for electronic report management according to the present invention, the method includes: a data storage step (S100) of storing the data generated in the measuring device in a database; a data calling step (S200) of calling the data stored in the database; an Excel report calling step (S300) of calling the Excel report written as a report; a mapping step (S400) of mapping the data and Excel report called in the above-mentioned data calling step (S200) and the Excel report calling step (S300); and a step (S500) of storing the data and Excel report mapped in the above-mentioned mapping step (S400).

[0176] Furthermore, in the file conversion method for electronic report management according to the present invention, the mapping step (S400) includes: a cell mapping step (S410) of mapping data and an Excel report through a cell setting unit including a separate cell designation unit, a range designation unit, and a manual designation unit, wherein the separate cell designation unit maps the data separately to cells on the Excel report, the range designation unit maps the data by specifying a cell range on the Excel report, and the manual designation unit maps the data by directly inputting cell coordinates; a cell output step (S420) of outputting and storing the mapped data and the Excel report through a cell output unit including a mapping cell output unit and an automatic cell output unit, wherein the mapping cell output unit outputs the data mapped by the cell setting unit on the Excel report, and the automatic cell output unit outputs the data on the Excel report.

[0177] Industrial Applicability

[0178] The electronic report management file conversion system and method according to the present invention as described above can be widely used in industry in that data generated in a measurement device can be easily and quickly published on an Excel report.

[0179] In particular, by identifying data in various formats generated in the three-dimensional measurement device and entering it into a database, the user can directly specify the data entered into the above database and enter it into the required cells on the Excel report form, thereby providing an effective data management system and being widely used in industry.

[0180] In addition, the cells on the measurement item list and Excel report can be mapped one-to-one to minimize confusion during data mapping. Even if cells are added or deleted or moved, the settings can be easily changed through simple remapping, which can provide a sense of convenience in use and can be widely used in industry.

[0181] Furthermore, by providing a list of measurement items imported from a database in the form of a graph, the life and replacement cycle of tools of a measurement device can be effectively managed, and thus the invention can be widely used in industry.

Claims

1. A file conversion system for electronic report management, characterized in that: include: A data input unit (200) receives data generated in the measuring device; A data storage unit (300) for storing the data input into the data input unit (200) in a database; A measurement item list generating unit (400) for calling the data stored in the database and generating a measurement item list; A report generating unit (500) for calling an Excel report for mapping with the measurement item list generated in the measurement item list generating unit (400); A mapping unit (600) maps the data called in the measurement item list generating unit to cells on the Excel report called in the report generating unit (500); The report storage unit (700) stores the Excel report mapped by the mapping unit (600).

2. The electronic report management file conversion system according to claim 1, characterized in that: The mapping unit (600) comprises: A cell setting unit (610) maps the values ​​of the measurement item list to the cells of the Excel report; The cell output unit (620) outputs the values ​​of the measurement item list mapped by the cell setting unit (610) on the Excel report.

3. The electronic report management file conversion system according to claim 2, characterized in that: The cell setting unit (610) includes: A separate cell designating unit (611) maps the values ​​of the measurement item list to separate cells on the Excel report sheet; A range designation unit (612) for designating a cell range on the Excel report sheet and mapping the values ​​of the measurement item list; The manual designation unit (613) directly inputs the cell coordinates on the Excel report and maps the values ​​of the measurement item list.

4. The electronic report management file conversion system according to claim 3, characterized in that: The range specifying unit (612) sets the output direction and number of cells on the Excel report.

5. The electronic report management file conversion system according to claim 3, characterized in that: When the values ​​of the measurement item list mapped by the cell setting unit (610) are output on the Excel report, the cell output unit (620) sets the output direction and number of cells on the Excel report for output.

6. The electronic report management file conversion system according to claim 5, characterized in that: The cell output unit (620) comprises: A mapping cell output unit (621) outputs the values ​​of the measurement item list mapped by the cell setting unit (610) on the Excel report sheet; The automatic cell output unit (622) outputs the entire measurement item list generated by the measurement item list generating unit (400) on the Excel report.

7. The electronic report management file conversion system according to claim 6, characterized in that: The cell output unit (620) comprises: The output storage unit (623) stores the measurement item list output by the mapping cell output unit (621) or the automatic cell output unit (622) on the Excel report.

8. The electronic report management file conversion system according to claim 1, characterized in that: The measurement item list generating unit (400) forms a graph of the measurement item list imported from the database.

9. A file conversion method for electronic report management, characterized in that: include: a data storage step (S100) of storing data generated in the measuring device in a database; A data calling step (S200) of calling data stored in a database; An Excel report calling step (S300) of calling an Excel report written as a report; A mapping step (S400) of mapping the data and the Excel report sheet called in the data calling step (S200) and the Excel report sheet calling step (S300); A step (S500) of storing the data mapped in the mapping step (S400) and the Excel report.

10. The electronic report management file conversion method according to claim 9, characterized in that: The mapping step (S400) includes: A cell mapping step (S410) of mapping data and an Excel report sheet by a cell setting unit including an individual cell specifying unit, a range specifying unit, and a manual specifying unit, wherein the individual cell specifying unit maps data individually to cells on the Excel report sheet, the range specifying unit specifies a cell range on the Excel report sheet to map data, and the manual specifying unit directly inputs cell coordinates and maps data on the Excel report sheet; A cell output step (S420) is performed by outputting and storing mapped data and an Excel report sheet through a cell output unit including a mapping cell output unit and an automatic cell output unit, wherein the mapping cell output unit outputs the data mapped by the cell setting unit on an Excel report sheet, and the automatic cell output unit outputs the data on an Excel report sheet.

Images