JP6668580B2 - File editing method, file editing device and file editing program - Google Patents

Description

  The present technology relates to a file editing method, a file editing device, and a file editing program.

  A vertical combining step of performing a vertical combining process of generating one tabular data by associating items included in a plurality of tabular data based on a user operation, and one table generated based on a user operation; An aggregation step of performing an aggregation process of aggregating records included in the one tabular data by using an item included in the format data as a key; and performing a vertical joining process and an aggregation process by using the tabular data having the same item configuration. As a re-execution information for executing the same process, a tabular data processing program has been proposed which causes a computer to execute at least a step of storing at least a storage unit in association with an item and a key item (for example, Patent Document 1). ).

International Publication No. WO 2014/208205

  In the process of paying the construction cost to the contractor (constructor), the contractor discloses cost information to the contractor to clarify the amount paid and the fairness of the consideration, and the contractor or a third party In some cases, an open book system that enables auditing by a company is adopted. In the open book method, the contract amount between the CMr (Construction Manager) and another contractor, the cost based on vouchers such as receipts, general administrative expenses, etc. are clarified, and the orderer can determine labor costs, material costs, outsourcing costs, etc. The cost structure can be understood.

  However, contractors and companies that are contractors with contractors generally have individual accounting systems, and therefore, for example, output data such as forms required for reporting to the ordering party in a project It was necessary to modify the existing accounting system or develop a new system in accordance with the requirements.

  In addition, it is used for reporting to public and private enterprises, especially for projects where the budget and construction plans are difficult to forecast, such as construction based on restoration / reconstruction projects and long-term projects, and are being revised as appropriate. Output data may also change. However, it is not easy to develop or modify an accounting system, and users often manually edit data having different formats such as the names and orders of items to be held on spreadsheet software.

  The present invention has been made in view of such a problem, and has as its object to output desired accounting information while suppressing changes to an existing system.

The file editing method according to the present invention includes a reading step of reading out one or more files including a budget, a record representing the cost incurred, and a payment record representing the amount of the payment, which are output from the accounting system, and outputting from the accounting system. The computer executes a conversion step of converting the content of the file output from the accounting system based on the definition information for converting the content of the converted file into a desired format, and a step of outputting the converted file. I do. Also, by rewriting the definition information, the operation of the process in the conversion step can be changed. By doing so, the format of the file output from the accounting system can be changed by rewriting the definition information without modifying the program. The definition information is created in the form of tabular data in which multiple pieces of records (rows) including a plurality of values corresponding to a plurality of attributes (columns) and a plurality of values corresponding to a plurality of attributes (columns) are registered. And editing definition information for adjusting the form and contents of the form.

  In addition, the definition information includes the addition or deletion of the contents included in the file output from the accounting system, the modification of the contents included in the file, the change of the order of rows or columns of the contents included in the file, or the It may be a file that defines a change in the hierarchical structure that organizes the contained contents. Specifically, such a modification can be made to the format of the file output from the accounting system.

  In addition, the file output from the accounting system is tabular data in which a plurality of records including a plurality of values corresponding to a plurality of attributes are registered, and the definition information corresponds to the attribute name of the file output from the accounting system. When the attribute name after conversion is included, the attribute name may be converted in the conversion step. More specifically, the attribute name can be changed in this way.

  Further, the file output from the accounting system is tabular data in which a plurality of records including a plurality of values corresponding to a plurality of attributes are registered, and in the conversion step, the definition information includes a value in the first attribute value. If registered, the second attribute value may be replaced with the first attribute value. As described above, the attribute value may be changed.

  In addition, the file output from the accounting system is tabular data in which a plurality of records including a plurality of values corresponding to a plurality of attributes are registered, and the definition information includes a predetermined attribute of the file output from the accounting system. When the key includes an attribute to be added and a value corresponding to the attribute, the attribute to be added and a value corresponding to the attribute may be integrated in the conversion step. As described above, an attribute and an attribute value may be added based on the definition information. For example, data not held by the accounting system described above can be added.

  Further, the file output from the accounting system is tabular data in which a plurality of records including a plurality of values corresponding to a plurality of attributes are registered, and the definition information is based on the order of the attributes of the file output from the accounting system. In the case of indicating a change or deletion of an attribute, the order of the attribute may be changed or the attribute may be deleted in the conversion step. In this way, the order of the attributes may be changed or deleted.

  Further, the file output from the accounting system is tabular data in which a plurality of records including a plurality of values corresponding to a plurality of attributes are registered, and in the conversion step, the definition information includes a value in the first attribute value. When registered, the second attribute value may be replaced with the first attribute value, and the order of the records may be rearranged based on the replaced second attribute value. Thus, the order of the records can be changed.

  The file output from the accounting system is tabular data in which a plurality of records including a plurality of values corresponding to a plurality of attributes are registered. In the conversion step, the definition information is stored in the first attribute value. The second attribute value is replaced with the first attribute value, and the third attribute in a plurality of attributes forming a hierarchical structure for systematizing each record based on the second attribute value after the replacement. May be changed. In this way, the depth of the hierarchy can be changed for the content represented by the hierarchical structure in the converted file.

  Further, the computer may further execute a step of receiving and storing voucher data of the payment result by a predetermined server, and a step of adding storage destination information for accessing the voucher data to a file output from the accounting system. It may be. This makes it easy to check the voucher data on the contents of the file.

  Further, the budget may include an attribute indicating a reference price serving as a reference for evaluating the cost reduction amount in the open book method. By doing so, it is possible to improve the listability of information in the open book system.

  The contents described in the means for solving the problems can be combined as much as possible without departing from the problems and technical ideas of the present invention. Further, the contents of the means for solving the problems can be provided as an apparatus such as a computer or a system including a plurality of apparatuses, a method executed by a computer, or a program executed by a computer. Note that a recording medium that holds the program may be provided.

  ADVANTAGE OF THE INVENTION According to this invention, it becomes possible to output desired accounting information while suppressing changes to the existing system.

FIG. 1 is a diagram illustrating an example of a system configuration. It is a functional block diagram showing an example of the composition of a contractor device. FIG. 2 is a functional block diagram illustrating an example of a configuration of a form editing device. FIG. 9 illustrates an example of a GUI for defining a job. FIG. 7 is a diagram illustrating an example of a screen for setting attribute association. It is an example of tabular data (input data) to be processed for horizontal joining. It is an example of tabular data (output data) after processing of the horizontal combination. FIG. 2 is a device configuration diagram illustrating an example of a computer. FIG. 9 is a diagram illustrating an example of job definition information. FIG. 4 is a process flowchart illustrating an example of a data editing process executed by the system according to the embodiment. FIG. 14 is a diagram illustrating an example of an execution order of a plurality of jobs for performing tallying and editing of accounting data. It is a table | surface which shows an example of an input file "budget.csv". It is a table | surface which shows an example of an input file "budget dictionary.csv". FIG. 14 is a diagram showing an example of the content of job definition information “01 budget + budget dictionary.xml”. It is a table | surface which shows the content of the output file "01 budget + budget dictionary.csv". It is a figure showing an example of contents of job definition information "02 budget processing.xml". It is a table | surface which shows the output file "02 budget processing.csv". FIG. 14 is a diagram showing an example of the content of job definition information “31 budget + actual result + paid result.xml”. FIG. 9 is a diagram illustrating an example of tabular data to be output. FIG. 14 is a diagram showing an example of the content of job definition information “32 budget + actual + payment actual processing.xml”. It is a figure showing the example of tabular data outputted. It is an example of the definition information which shows a business partner list. It is an example of a form tabulated for each of the neighborhood and the outskirts.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings. The following embodiment is an exemplification, and the present invention is not limited to the following configuration.

<System configuration>
FIG. 1 is a diagram illustrating an example of a configuration of a system according to the present embodiment. The system of FIG. 1 includes an orderer apparatus 1, an order receiver apparatus 2, and a form editing apparatus 3, and these components are connected via a network 4 such as the Internet. The orderer apparatus 1 is a computer used by an orderer who orders work such as construction. The orderer apparatus 1 is a general computer, and the orderer uses the orderer apparatus 1 to view, for example, information such as incurred expenses. The contractor device 2 is a computer that constitutes an in-house system of the contractor who has received the work. The contractor apparatus 2 includes an accounting system having a function of managing accounting information of a project such as a construction. The form editing device 3 acquires data held by the accounting system of the contractor device 2, and performs a predetermined tabulation and editing process. The form editing device 3 generates form data for disclosing information such as expenses to the orderer, and transmits the form data in response to a request from the orderer terminal 1, for example.

<Functional configuration of contractor device>
FIG. 2 is a functional block diagram illustrating an example of the configuration of the contractor apparatus 2 according to the present embodiment. 2 includes an accounting information storage unit 21, an accounting system cooperation unit 22, a storage unit 23, and an output unit 24. The accounting information storage unit 21 is a storage unit that stores a database or the like that holds accounting information handled by an accounting system of a contractor such as a company. The accounting system cooperation unit 22 acquires data from the accounting information storage unit 21 and stores the data in the storage unit 23. The storage unit 23 stores the information acquired by the accounting system cooperation unit 22. The output unit 24 outputs the information stored in the storage unit 23 to the form editing device 3 via the network 4.

<Functional configuration of form editing device>
FIG. 3 is a functional block diagram illustrating an example of the configuration of the form editing device 3 according to the present embodiment. 3 includes an input / output unit 31, a storage unit 32, a batch control unit 33, a vertical combination processing unit 34, a horizontal combination processing unit 35, a tally processing unit 36, and a search / edit processing unit 37. Note that the vertical combination processing unit 34, the horizontal combination processing unit 35, the aggregation processing unit 36, and the search / edit processing unit 37 are also referred to as "conversion units" in the present invention.

  The form editing device 3 acquires data held by the accounting system as tabular text data (also referred to as tabular data) represented by delimiters such as CSV (Comma-Separated Values). The tabular data has, for example, values corresponding to a plurality of attributes separated by delimiters in the horizontal direction, and has one or more records separated by line feeds in the vertical direction. In addition, it is assumed that a predetermined number of rows from the top of the tabular data define names of a plurality of attributes separated by a delimiter in the horizontal direction. The file format is not limited to a CSV file, and may be a file format handled by so-called spreadsheet software.

  The input / output unit 31 transmits and receives information to and from the orderer apparatus 1 and the order receiver apparatus 2. As described above, in the present embodiment, the accounting data acquired from the accounting system of the contractor is acquired as tabular data. Further, the input / output unit 31 discloses the statistical data compiled by the form editing device 3 to the orderer terminal 1 via the network 4. In addition, the input / output unit 31 receives not only the tabular data but also electronic data obtained by scanning, for example, evidence documents relating to the contract amount and expenses, and stores the electronic data in the storage unit 32 and discloses the electronic data to the orderer terminal 1. The storage unit 32 stores information transmitted and received by the input / output unit 31 and information generated in the course of processing performed by the form editing device 3.

Further, the batch control unit 33 controls the execution of the data editing process that the form editing device 3 performs, for example, periodically. The system according to the present embodiment performs data editing processing by combining modules that perform predetermined processing (also referred to as “processes”) prepared in advance. Specifically, a job in which one or more processes such as a vertical combination process, a horizontal combination process, a totaling process, a search process, an external cooperation process, and the like are executed and the processes are executed in a predetermined order is defined in advance. And The details of each process will be described later. FIG. 4 is a diagram illustrating an example of a GUI (Graphical User Interface) for defining a job. At the top of the screen in FIG. 4, a list of icons indicating processes is displayed in a row. The user selects an icon from the list and defines a process to be executed. In the lower part of the screen in FIG. 4, the definitions of the jobs connected by arrows in the order in which the icons indicating the processes are executed are displayed. For each process, input contents, processing contents, output contents, and the like are set in addition to the starting order. In the definition of a job, information for reproducing a series of processes is stored in, for example, an XML (Extensible Markup Language) format. Then, the batch control unit edits the tabular data based on the definition information of the job (process).

  In addition, the vertical combination processing unit 34 directly or intermediately associates the attribute associated with the data acquired from the accounting system of the contractor and the attribute associated with the data structure of the form presented to the orderer. A process of indirectly associating with the generated data is performed. Specifically, for example, values included in one or more CSV files are sorted and sorted for each column, and new CSV data is generated by adding the attribute name of the input file or a predetermined attribute name. At this time, the values recorded with different attribute names in different CSV data are associated with one edited attribute, or the values associated with two or more attributes in one CSV data are combined. , May be associated with one edited attribute.

  FIG. 5 is a diagram illustrating an example of a screen for setting attribute association. The first line of the table shown in FIG. 5 indicates the serial number of the attribute. The second row of the table shows the attribute names of the tabular data after the vertical combination. The user can press the “edit” button on the third line, change the attribute name of the tabular data after the vertical combination, and set the association of the attributes. The fourth and fifth lines indicate attribute names of different CSV files associated with the respective attributes. The attribute names registered in the same column indicate the attribute names associated in the vertical combination. For example, the combination of the attributes "first name" and "name" in the CSV file "AAA" shown on the fourth line is associated with the attribute "name" in the CSV file "BBB" shown on the fifth line. Note that among the attributes included in the input file, those that are not associated with the attribute names of the tabular data after the vertical combination are deleted from the output file. As described above, according to the processing of the vertical combination processing unit 34, it is possible to perform editing in units of columns, such as combining or deleting one or more columns, for records included in one or more tabular data.

  Further, the horizontal join processing unit 35 performs a process of collecting one or more records included in one tabular data into one record. For example, for a record in which the value held in correspondence with a certain key attribute matches (complete match or partial match), the value held in correspondence with another attribute is connected as a character string to form one Aggregate into fields and generate one record.

FIG. 6 shows an example of tabular data (input data) to be subjected to the horizontal joining process. FIG. 6 shows that data after vertically combining records included in two CSV files are not associated with other items, and some fields in FIG. 6 are empty. In the horizontal join, a plurality of records having the same key attribute value (complete match or partial match (front match, middle match, or backward match)) are aggregated into one record. As for attributes other than the key, values included in a plurality of records may be listed in one field separated by a delimiter or a line feed. In this case, when a plurality of the same values exist in one field, the duplication may be removed or the duplication may not be removed. Further, in the horizontal combination, table fields that are so-called master data may be used to supplement fields of items that do not exist in other tabular data. When records having the same (completely matching) key attribute values are consolidated into one row (horizontal combination) using the attribute “company” in FIG. 6 as a key attribute, the result is as shown in FIG. Note that the vertical connection and the horizontal connection may be executed as one vertical connection process.

  Further, the tallying processing unit 36 performs tallying processing on records included in one tabular data using a predetermined attribute as a key. For example, for a record in which the value held in correspondence with a certain key attribute matches (completely matches or partially matches), statistics of numerical values held in association with another attribute are obtained. For statistics, for example, a total value, an average value, and the like are calculated. Also, so-called cross tabulation may be performed using a plurality of attributes as keys. In addition to the general tallying process, the tallying unit may perform a process based on a conditional expression using a predetermined attribute value of the input file. That is, different values are set as the attribute values of the output file depending on whether or not a certain condition is satisfied. For example, when some value is held in association with a certain attribute of the input file, a value associated with a certain attribute can be output instead of another attribute value of the input file. Further, a process in which such a condition is combined with the above-described aggregation may be performed.

  In addition, the search / edit processing unit 37 adds a new attribute to the tabular data, assigns a number in ascending order of records (numbering), or includes a search target character string in a predetermined attribute or any of the attributes. Or extract records. Further, the search / edit processing unit 37 may sort (sort) the extracted records in ascending or descending order based on a predetermined item value.

<Apparatus configuration>
FIG. 8 is an apparatus configuration diagram illustrating an example of a computer. The orderer apparatus 1, the order receiver apparatus 2, and the form editing apparatus 3 are each a computer as shown in FIG. A computer 1000 illustrated in FIG. 8 includes a CPU (Central Processing Unit) 1001 and a main storage device 100.
2, an auxiliary storage device 1003, a communication IF (Interface) 1004, an input / output IF (Interface) 1005, a drive device 1006, and a communication bus 1007. The CPU 1001 performs processing and the like according to this embodiment by executing a program (also referred to as “software” or “application”). The main storage device 1002 caches programs and data read by the CPU 1001, and expands a work area of the CPU. The main storage device is, specifically, a random access memory (RAM) or a read only memory (ROM). The auxiliary storage device 1003 stores a program executed by the CPU 1001, setting information used in the present embodiment, and the like. The auxiliary storage device 1003 is, specifically, a hard disk drive (HDD), a solid state drive (SSD), a flash memory, or the like. The main storage device 1002 and the auxiliary storage device 1003 function as the data storage unit 101 of the tabular data processing device 1. The communication IF 1004 transmits and receives data to and from another computer. The orderer apparatus 1, the order receiver apparatus 2, and the form editing apparatus 3 are connected to the network 4 via the communication IF 1004. The communication IF 1004 is specifically a wired or wireless network card or the like. The input / output IF 1005 is connected to the input / output device, and accepts input from a user and outputs information to the user. The input / output device is, specifically, a keyboard, a mouse, a display, a touch panel, or the like. The drive device 1006 reads data recorded on a storage medium such as a magnetic disk, a magneto-optical disk, and an optical disk, and writes data on the storage medium. The above components are connected by a communication bus 1007. A plurality of these components may be provided, or some of the components (for example, the drive device 1006) may not be provided. Further, the input / output device may be configured integrally with the computer. Also, the program executed in the present embodiment is provided via a portable storage medium readable by the drive device 1006, a portable auxiliary storage device 1003 such as a flash memory, a communication IF 1004, and the like. It may be. When the CPU 1001 executes the program, the above-described computer operates as the order receiving apparatus 2 and the form editing apparatus 3 shown in FIGS.

<Job definition information>
FIG. 9 shows an example of job definition information that is setting information of the execution order of a process (process). In the present embodiment, it is assumed that setting information that defines the content of the processing is stored, and the processing can be started at a scheduled timing. In the present embodiment, the order of processes to be executed is defined by information described in an XML (Extensible Markup Language) format. Further, the content of the processing to be executed can be modified by changing the content of the XML file.

  In the present embodiment, a plurality of types of processes for performing a predetermined process based on the setting information and the input tabular data are prepared, and the user can set a desired content of the tabular data and the order thereof to set a desired process. Form data can be obtained. As described above, “vertical connection”, “horizontal connection”, “totaling”, “search”, “numbering”, “data output”, and the like are prepared as processes. In particular, in the present embodiment, not only the accounting information output from the accounting system is aggregated, but also the value is corrected for the accounting information by processing using the definition information created in advance by the CSV formula or the like by the user. And edit such as selection of output contents and change of output order. Such an input file for editing is also called a “dictionary file”.

The <Set> tag in FIG. 9 is a data set item, and a CSV file to be read is described in the tag. The <Process> tag is a process set item, and describes the process to be executed in the tag. Specifically, processing contents such as search, vertical connection, horizontal connection, and totaling are set. In addition, a data declaration section may be included. Hereinafter, an example of tags and their contents used in an XML file, including tags and attributes not shown in FIG. 9, will be described.

For example, the tags that define a process include: The <OneColumnJoin> tag is a vertical join item, and describes the settings related to vertical join in the tag. The <FullColumnJoin> tag is a horizontal join item, and describes the settings related to horizontal join in the tag. <Summarization>
The tag is a tabulation item, and describes settings related to tabulation in the tag. The <Runtime> tag is
This is an external cooperation item, and describes the activation of the external program in the tag. <Numbering>
The tag is a numbering item, and describes settings related to numbering in the tag. The <Search> tag is a search item, and describes the conditions for searching within the file in the tag. <Group>
The tag is a grouping item, and describes settings related to grouping in the tag. The <Ungroup> tag is an ungrouping item, and describes settings related to ungrouping in the tag. The <Out> tag is a data out item, and describes the output CSV file in the tag. The <Comment> tag is a comment item, and a comment (character string) is described in the tag.

The <OneColumnJoin> tag is a column editing item, and describes settings related to column editing (vertical combination) in the tag. In the embodiment, based on the association of a plurality of attributes included in different tabular data, tabular data that holds values associated with the plurality of attributes in one column is generated.

In the OneColumnJoin tag, an element indicating the setting of vertical combination is described. Target
) Is the file content specified in the data set. Field (Field) is described by the number of attributes to be output. An attribute name is described in the field element (Cell), and a full path file name is described in the file name (filename) attribute. Join (Unite
) Are described by the number of attributes to which the attribute concatenation is connected. In the cell element (UCell) to be combined, the attribute name to be combined is described, and in the file name (filename) attribute, the full path file name is described. A new field (New) describes the attribute content to be output. Field (Field) is described by the number of targets (Target). Field element (Cell
) Describes the attribute name of the data out.

  The <FullColumnJoin> tag is a record integration item, and describes settings related to record aggregation (horizontal joining) in the tag. In the present embodiment, a plurality of records are aggregated into one record using an attribute included in the tabular data as a key.

Horizontal join (FullColumnJoin) is a tag indicating horizontal join. In the key (Key), a key attribute is described, and in the name identification (match) attribute, identification information indicating any of “exact match”, “front match”, “backward match”, and “intermediate match” is provided. Is described. Also, the cleansing attributes include "do not use", "telephone number", "zip code", "date", "corporate name", "number", "Japanese analysis", "English character analysis", " Information indicating any one of “name”, “address”, and “user dictionary” is described. In the join (Add) element, identification information indicating one of “duplicate elimination (one line)”, “duplicate (one line)”, “frequency sort”, and “auto-completion” as a duplicate value processing (jointype) attribute , And the delimiter attribute between the values
Identification information indicating any of "line feed", "slash", "comma", and "space" is described.

The <Summarization> tag is a tabulation item, and describes settings related to tabulation in the tag.
In the embodiment, values included in the integrated record are totaled.

Key indicates a key element and is described by the number of keys. Also, the aggregate attribute indicates the name identification judgment, "exact match", "yearly", "monthly", "daily", "weekly (yearly)", "weekly (monthly)", "weekday" Identification information indicating one of “other” and “user dictionary” is described. The Statistic element indicates attribute aggregation and is described by the number of attributes to be output. Further, the flag attribute is a flag, and a non-overlapping numerical value from 0 to 99 is input. In addition, the collect attribute indicates the content of the aggregation, and includes “join”, “frequency”, “total”, “average”, “median”, “mode”, “maximum”, “minimum”, and “variance”. , Or “standard deviation” is set. In addition, a StatisticNew element indicates new attribute aggregation. Also, attribute names are described by the number of attributes to be output. The collect attribute is the content of the aggregation, "count", "calculation", "condition"
, “Branch”, “numbering”, or “function processing” is set. The fml attribute indicates a tally expression. In the parentheses in the tally expression, the numbers in square brackets indicate the numbers set by the flags, and the numbers in curly braces indicate the registration order of the new attribute tally starting from 0. In the description of the tally expression, when the tally content is “calculation”, the expression of the four arithmetic operations is described. If the total is "condition", describe the conditional expression. If the total is "function processing", describe the function.

In the <Search> tag, a logical expression (Fml) indicating a search condition as an XML element (element)
Is described. To sort, sort (Sort) element in ascending order (asc) or descending order (desc)
) Is described.

  The <Numbering> tag is a tag indicating numbering. Of the XML elements, Field describes a field and Cell describes a field element (attribute name). Numbering is a function for adding an attribute for assigning a sequential number to a record. Even when a plurality of files are combined, it is possible to add a serial number that uniquely identifies a record. In addition, the user can assign an arbitrary name to the attribute for assigning a serial number.

The <Out> tag is a tag indicating data output. In Save, describe the file path to be output. In code, describe the character code. Delete indicates file deletion and describes a folder or file path to be deleted.

  The XML file can be displayed by a program for performing the processing of the present embodiment, a text editor, or the like. Note that the above-described tag standard is merely an example, and various changes can be made within a range in which the setting information can be held. Further, the types of tags may be increased according to the addition of the function. The setting information in the embodiment can be stored in various formats other than XML.

<Embodiment of data editing process>
FIG. 10 is a process flowchart illustrating an example of a data editing process performed by the system according to the present embodiment.

  It is assumed that the storage unit 32 of the form editing apparatus 3 stores tabular data output from a predetermined accounting system in advance. That is, the accounting system cooperation unit 22 of the contractor apparatus 2 reads the data stored in the accounting information storage unit 21 which is the database of the core system of the company as the contractor, and converts the data into tabular data such as a CSV file. The data is converted and output to the storage unit 23. The output unit 24 reads the tabular data from the storage unit 23 and transmits the tabular data to the form editing device 3 via the network 4. On the other hand, the input / output unit 31 of the form editing device 3 stores the received tabular data in the storage unit 32.

  In the data editing process of FIG. 10, first, the input / output unit 31 of the form editing device 3 reads out job definition information described in, for example, an XML format and an input file described in the job definition information (FIG. 10: S1). The input file is tabular data described in a CSV format or the like.

  Further, the batch control unit 33 sequentially reads the description in the job definition information, determines a set process based on, for example, the content of the tag (S2), and causes each process to be executed.

  If it is determined in S2 that the content of the process is “vertical combination”, the batch control unit 33 causes the vertical combination processing unit 34 to execute the vertical combination by inputting one or more tabular data (S3). That is, the association of attributes as shown in FIG. 5 is read from the definition in the job definition information, the column of the tabular data is edited, and the file after the vertical combination is output. After that, the processing makes a transition to S8.

  Further, when it is determined in S2 that the content of the processing is “horizontal combination”, the batch control unit 33 causes the horizontal combination processing unit 35 to execute a horizontal combination that aggregates the records of the tabular data (S4). That is, records are aggregated in the tabular data as shown in FIG. 6 using a predetermined attribute as a key, and tabular data as shown in FIG. 7 is generated. After that, the processing makes a transition to S8.

  Further, when it is determined in S2 that the content of the processing is “totaling”, the batch control unit 33 causes the counting processing unit 36 to count the records of the tabular data (S5). That is, the aggregation processing unit 36 aggregates the values of other attributes based on the description of the job definition information, using the value of the predetermined attribute as a key. In this step, different processing may be executed depending on whether or not the value of the predetermined attribute satisfies a certain condition. After that, the processing makes a transition to S8.

  If it is determined in S2 that the content of the process is “numbering” or “search”, the batch control unit 33 causes the search / edit processing unit 37 to execute record numbering or attribute value search (S6). . After that, the processing makes a transition to S8.

  If it is determined in S2 that the content of the process is “output”, the batch control unit 33 causes the input / output unit 31 to output tabular data (S7). In this step, the edited tabular data is output to a file in a format such as CSV. After that, the processing makes a transition to S8.

  After S3 to S7, the batch control unit 33 determines whether to end the processing (S8). In this step, the batch control unit 33 reads the job definition information sequentially and determines whether a process to be executed is described. If the process to be executed is described (S8: NO), the process proceeds to S2 and the process is repeated. On the other hand, when the process is not described any more in the job definition information (S8: YES), the batch control unit 33 ends the data editing process.

  The process in S1 corresponds to a “reading step” in the present invention. Each of the processes from S3 to S6 corresponds to a “conversion step” in the present invention.

<Example of accounting data compilation and editing>
For example, when disclosing information on costs and the like from the ordering party to the ordering party as in the open book system, a form in which necessary data is described is output according to the request of the ordering party. For example, in the case of construction where it is difficult to make an accurate outlook and the plan is relatively flexibly changed, such as a disaster recovery project, the format of the required output data and the description order are often changed. When the format of the required form is changed, a large cost may be required if the core system is modified according to the format of the form to be output. In particular, in the case of a project such as construction that continues only for a predetermined period, if the format of a required form may be frequently changed, it is preferable that the format of the form can be changed without modifying the core system one by one. . In the present embodiment, in addition to the tabular data output by the accounting system, the user prepares, in advance, for example, a CSV format for editing definition information (that is, a “dictionary file”) for adjusting the form and content of the form. And, by using the dictionary file as the input file of the above-described process, the value of the tabular data output from the accounting system and the attribute name can be changed, and the attribute value not held by the accounting system can be added, You can change the order of attributes (columns) and records (rows). Also, unlike the case of editing manually, the same processing is performed based on the definition information of the dictionary file and the job (generally referred to simply as “definition information”) and the CSV file of the input accounting data. Because it can be reproduced, data traceability is secured, and the validity of the contents can be evaluated ex post facto.

  FIG. 11 is a diagram illustrating an example of an execution order of a plurality of jobs for counting and editing accounting data. That is, FIG. 11 describes a plurality of XML files in which job definitions are described, and a CSV file as input / output data of each job. In addition, the processing is performed using the data on the budget, the data on the actual results (ordering), and the data on the actual payments held by the accounting system, and is a reference amount for evaluating the amount of reduction in cost. This is an example of outputting a form in which the “base price” and each amount (budget, actual result, actual payment result) can be listed. Specifically, "combining and processing budget and budget dictionary", "combining and processing actual and actual dictionary", "combining actual and actual payment", and "combining budget + actual + payment actual and adjusting layout" And the input / output files constituting the series of processes are connected by arrows indicating the order of execution.

<Combining and processing budget and budget dictionary>
FIG. 12 is a table showing an example of the input file “budget.csv”. In the input file "budget.csv", budget names indicating the construction site and the type of work are set in a hierarchical structure, and the corresponding budget and incentive base price are registered. FIG. 13 is a table showing an example of the input file “budget dictionary.csv”. In the input file “budget dictionary.csv”, corrected values are set for each of the budget name, hierarchy, and budget amount. If no correction is required, no value is set in each field. In this embodiment, a value with a number added to the head is registered in the field of the attribute “new budget name” so that the order of records to be output on a form can be rearranged in the subsequent processing.

FIG. 14 is a diagram showing an example of the contents of “01 budget + budget dictionary.xml” that is the job definition information. The job includes one vertical combination. In the present embodiment, it is assumed that the processing up to the above-described horizontal combining can be performed by one vertical combining process. FIG. 15 is a table showing the output file “01 budget + budget dictionary.csv” of the job. In the job,
The attributes included in the input file are combined, and records having matching values are aggregated using the attribute “budget name” as a key.

  FIG. 16 is a diagram illustrating an example of the content of “02 budget processing.xml” that is job definition information. The job includes processes such as vertical combination (input of a file), numbering, totaling (removal of attributes according to conditions), and vertical combination (deletion of attributes). FIG. 17 is a table showing the output file “02 budget processing. Csv” of the job. For the job, the output file of the previous job shown in FIG. 15 is read as an input file, and if a value is registered in the “new budget name” field in the “totaling” process, the “budget name” field If the value is registered in the field of "correct hierarchy", replace the value of the "tier" field, and if the value is registered in the field of "correct budget amount", Field value. At this time, the name of the attribute can be changed, and in the present embodiment, the attribute name is changed to a star-marked attribute name. In addition, the output file has contents in which some attributes are extracted from the table after the “totaling” process. In this way, the output file “02 budget processing.csv” is generated. As illustrated, in the present embodiment, when an incorrect value is registered in the accounting system, the user corrects the value by modifying the contents of the dictionary file “budget dictionary.csv”. Can be. Further, as described above, the field value of “budget name” is replaced with a value with a number at the beginning so that the order of records to be output on a form in the subsequent processing can be rearranged.

  In the “combination and processing of budget and budget dictionary” in the series of processes shown in FIG. 11, data on the budget held by the accounting system is processed. Similarly, in the process of “combining and processing the actual result and the actual dictionary”, data on the order amount (the successful bid amount) registered in the accounting system is processed. Specifically, for attributes such as "Result number", "Result name", and "Amount of successful bid", it is possible to perform processing such as correcting the attribute name, correcting the attribute value, and deleting the attribute. And the combination and processing of the budget dictionary ”, the job and the process described above are combined and modified, and specific data examples are omitted.

  In the “combination of the actual result and the actual payment”, the record of the payment registered in the accounting system is processed and combined with the order amount described above. In the example of FIG. 11, a job for performing processing such as correction of payment results is not provided, but a job for correcting attribute names and attribute values may be provided.

  FIG. 18 is a diagram illustrating an example of the content of the job “31 budget + actual + payment-results.xml” in “combination of budget + actual + actual-payment and layout adjustment”. The job includes a vertical combination and a search (sort) process. Note that the attribute values of the key attributes of the sort process are numbered in advance in the form output order, and the records can be rearranged in an order according to the required form format. FIG. 19 is a diagram illustrating an example of tabular data output by the job. In the example of FIG. 19, in addition to attributes such as a budget, a successful bid amount, a payment amount, an incentive base price, and the like, there are attributes such as “hierarchy” used for editing data. Also, when changing the order of records to be output to the final form, the user can change the order of records to be output by providing a definition for changing the attribute value of the key attribute in the dictionary file. it can. That is, the format of the output form can be changed without modifying the program.

FIG. 20 is a diagram illustrating an example of the content of the job “32 budget + actual result + payment actual process.xml”. The job includes processes such as vertical combination (input of file), numbering, totaling (giving a hierarchical structure according to conditions), and vertical combination (deletion of attributes). FIG. 21 shows an example of tabular data output in the job. In the output file of the job, the contents of the data to be output, the output order in the column direction and the row direction, and the like are edited according to the layout of the form to be finally output. In the tabulation process, the attributes “name 1” to “name 3” in FIG. 21 correspond to the attributes “name” in FIG. 19 according to the values “1” to “3” of the attribute “hierarchy” in FIG. Is registered. Also, in FIG. 19 in the editing process, an asterisk is attached to the attribute name after the value is changed, but for example, in FIG. 21 submitted to the orderer, the attribute name is changed to an attribute name without an asterisk.

  In the form which is output data of the present embodiment, in addition to the budget, the actual result (the successful bid amount of the cooperating company), the actual payment result, the "incentive reference price" which is the standard amount for evaluating the cost reduction amount is output. You. In the so-called open book system, the expenses are disclosed to the orderer, and the expenses reduced by the efforts of the contractor can be grasped. By outputting the amount of money, which is determined together with the budget, which serves as a reference for evaluating the cost reduction amount, to a form, it is possible to improve the information browsability in the open book system.

<Example 1 of changing output data>
In the output file of FIG. 21, it is assumed that, for example, a record (fifth line of the data section) in which the value of the attribute “customer name” is “tamachi equipment” has an error. That is, it is assumed that the record is originally a record indicating the actual result and the actual payout for the budget of “04 excavator 02” instead of “03 excavator 01” in the attribute “name 3”. For example, when there is such an error in the data input to the accounting system of the company, if it takes time for the in-house procedure for correction, the creation of the form to be output to the orderer will be delayed. In such a case, if the value is changed using the above-described dictionary file, an error in the form of the output result can be quickly corrected. Specifically, in the “results dictionary.csv”, the new name of the record is set to “04 excavator 02”. Further, if the data acquired from the accounting system and the dictionary file are stored when the form is created, the form creation process at that time can be re-executed, and the validity of the change can be verified later.

<Modification example 2 of output data>
In the case of local employment in a disaster recovery project, for example, it may be necessary to separately calculate the amount paid to a company in a certain town and the amount paid to a company outside the town. In addition, for example, when complicated conditions are imposed, such as that the location of the head office, branch, or business office is in the prefecture, the location of the business partner registered in the corporate accounting system is extracted from the database as the extraction condition. It is difficult to extract, or the necessary information is not stored in the database in the first place. In such a case, for example, a flag indicating whether the company is a town company or a town company may be stored in the list of business partners as the above-described dictionary file, and the tabulation may be performed based on the flag. Alternatively, it may be determined in advance whether each company satisfies more complicated conditions, and a flag or the like indicating the conclusion of the determination may be provided.

FIG. 22 is an example of definition information indicating a business partner list. The definition information holds the attribute "inside / outside town" and the attribute "location of the company" which are not held by the accounting system of the company, and adds information which is not held by the accounting system of the company to the form. be able to. That is, the attribute "town / outside" of the supplier list in FIG. 22 can be combined with the tabular data in FIG. Specifically, records that match using the supplier name as a key attribute are integrated. Then, for example, the value of the attribute “payment amount” is totaled for each of the registered values of the attribute “inside / outside” for each of the inside or outside of the town. By doing so, the user can change the definition information prepared as tabular data and the definition information of the job, without modifying the program of the accounting system or changing the structure of the database of the accounting system, etc. A form in a desired format can be output. FIG. 23 shows an example in which the successful bid amount, order amount, volume amount, and payment amount for each business partner are totaled for each of the inside and outside of the town. Such aggregation is performed by, for example, vertically linking the attributes of the inside and outside of the town and the location of the company shown in FIG. 22 to the table of FIG. The second key attribute is tabulated as the location of the company. As shown in the figure, for example, the payment amount can be shown as 2.9 million yen for a town-based company and 11.5 million yen for a town-based company.

<Modification example 2 of output data>
Further, the accounting system of the company according to the present embodiment stores, for example, electronic data of a receipt serving as a voucher at the time of registering the payment amount, which is the result of payment. That is, while receiving the input of the payment amount from the user and receiving the upload of the data obtained by scanning the receipt, the information indicating the storage destination of the data is stored in association with the payment result amount. Such information may be output to the form described above. In particular, when the form is output as electronic data, the voucher data can be easily confirmed based on the link.

<Others>
The accounting system according to the embodiment may be general-purpose accounting software in addition to the accounting system developed in accordance with the business of the company. Using the file output from the accounting software in a CSV format or the like, the form editing apparatus 3 according to the embodiment can create a form in a desired format.

  The present invention includes a computer program that executes the above-described processing, and a computer-readable recording medium on which the program is recorded. The above-described processing can be performed on a recording medium on which the program is recorded by causing the computer to execute the program.

  Here, the computer-readable recording medium refers to a recording medium in which information such as data and programs is accumulated by electrical, magnetic, optical, mechanical, or chemical action and can be read by a computer. Among such recording media, those removable from a computer include a flexible disk, a magneto-optical disk, an optical disk, a magnetic tape, a memory card, and the like. In addition, examples of the recording medium fixed to the computer include an HDD, an SSD (Solid State Drive), and a ROM.

REFERENCE SIGNS LIST 1 orderer apparatus 2 contractor apparatus 21 accounting information storage section 22 accounting system cooperation section 23 storage section 24 output section 3 form editing apparatus 31 input / output section 32 storage section 33 batch control section 34 vertical connection processing section 35 horizontal connection processing section 36 Total processing unit 37 Search / edit processing unit 4 Network

Claims (12)

A reading step of reading one or more files output from the accounting system, including a budget, a record representing expenses incurred, and a record of payment representing the amount paid.
A conversion step of converting the content of the file output from the accounting system, based on definition information for converting the content of the file output from the accounting system into a desired format,
Outputting the converted file;
Is a file editing method executed by a computer,
By rewriting the definition information, the operation of the process in the conversion step can be changed,
The definition information Ri Ah in the file that defines the change of the hierarchical structure to organize the content contained in the file output from the accounting system,
The file output from the accounting system is tabular data in which a plurality of records including a plurality of values corresponding to a plurality of attributes are registered,
In the conversion step, in the definition information, if a value for sorting in ascending or descending order according to the layout of the form is registered in the first attribute value in association with the second attribute value, A file editing method in a file, wherein the second attribute value is replaced with the first attribute value, and the order of the records is rearranged based on the replaced second attribute value . A reading step of reading one or more files output from the accounting system, including a budget, a record representing expenses incurred, and a record of payment representing the amount paid.
A conversion step of converting the content of the file output from the accounting system, based on definition information for converting the content of the file output from the accounting system into a desired format,
Outputting the converted file;
Is a file editing method executed by a computer,
By rewriting the definition information, the operation of the process in the conversion step can be changed,
The definition information Ri Ah in the file that defines the change of the hierarchical structure to organize the content contained in the file output from the accounting system,
The file output from the accounting system is tabular data in which a plurality of records including a plurality of values corresponding to a plurality of attributes are registered,
In the conversion step, if a value indicating a corrected hierarchy in which the second attribute value is to be displayed according to the form layout is registered as the first attribute value in the definition information, A third attribute value which is one of a plurality of attributes corresponding to an output position in the form based on the second attribute value after the replacement in the file, while replacing the value with the first attribute value. File editing method to change the location where is registered . If the definition information includes an attribute name after conversion in association with the attribute name of the file that is output from the accounting system, in said converting step, file editing according to claim 1 or 2 converts the attribute name Method. When the definition information includes a corrected attribute value for a predetermined target attribute, in the conversion step, replaces the attribute value of the predetermined target attribute with the corrected attribute value.
The file editing method according to claim 1. In a case where the definition information includes an attribute to be added and a value corresponding to the attribute by using a predetermined attribute of the file output from the accounting system as a key, in the conversion step, the attribute to be added and the corresponding attribute are added. The file editing method according to any one of claims 1 to 4, wherein values are integrated. The definition information, wherein when representing the deletion sequence changes or attributes of the attribute of the output file from the accounting system, of claims 1 to 5 for the deletion of order change or the attribute of the attribute in the converting step The file editing method according to any one of the above. A predetermined server receives and stores the voucher data of the payment result,
A step of adding storage destination information for accessing the voucher data to a file output from the accounting system;
The file editing method according to any one of claims 1 to 6 , further comprising the step of: The file editing method according to any one of claims 1 to 7 , wherein the budget includes an attribute indicating a reference price serving as a reference for evaluating cost reduction in an open book method. A storage unit for storing one or more files output from the accounting system, including a budget, an actual record representing expenses incurred, and a payment record representing the amount of payment made;
A reading unit that reads the one or more files from the storage unit;
A conversion unit that converts the content of the file output from the accounting system, based on the definition information for converting the content of the file output from the accounting system into a desired format,
A file editing device comprising:
By rewriting the definition information, the operation of the conversion unit can be changed,
The definition information Ri Ah in the file that defines the change of the hierarchical structure to organize the content contained in the file output from the accounting system,
The file output from the accounting system is tabular data in which a plurality of records including a plurality of values corresponding to a plurality of attributes are registered,
The conversion unit associates a first attribute value with a second attribute value in the definition information,
When values for sorting in ascending or descending order according to the layout of the form are registered, the second attribute value is replaced with the first attribute value in the file, and the second attribute value after the replacement is replaced. A file editing device for rearranging the order of the records based on attribute values . A storage unit for storing one or more files output from the accounting system, including a budget, an actual record representing expenses incurred, and a payment record representing the amount of payment made;
A reading unit that reads the one or more files from the storage unit;
A conversion unit that converts the content of the file output from the accounting system, based on the definition information for converting the content of the file output from the accounting system into a desired format,
A file editing device comprising:
By rewriting the definition information, the operation of the conversion unit can be changed,
The definition information Ri Ah in the file that defines the change of the hierarchical structure to organize the content contained in the file output from the accounting system,
The file output from the accounting system is tabular data in which a plurality of records including a plurality of values corresponding to a plurality of attributes are registered,
In the definition information, if the value indicating the corrected hierarchy in which the second attribute value is to be displayed according to the layout of the form is registered as the first attribute value in the definition information, A third attribute value which is one of a plurality of attributes corresponding to an output position in the form based on the second attribute value after the replacement in the file, while replacing the value with the first attribute value. File editing device that changes the location where the file is registered . A reading step of reading, from a storage unit, one or more files including a budget, a record representing the cost incurred, and a record of payment representing the amount of the payment, output from the accounting system;
A conversion step of converting the content of the file output from the accounting system, based on definition information for converting the content of the file output from the accounting system into a desired format,
Is a file editing program that causes a computer to execute
By rewriting the definition information, the operation of the process in the conversion step can be changed,
The definition information Ri Ah in the file that defines the change of the hierarchical structure to organize the content contained in the file output from the accounting system,
The file output from the accounting system is tabular data in which a plurality of records including a plurality of values corresponding to a plurality of attributes are registered,
In the conversion step, in the definition information, if a value for sorting in ascending or descending order according to the layout of the form is registered in the first attribute value in association with the second attribute value, A file editing program that replaces the second attribute value with the first attribute value in a file and rearranges the order of the records based on the replaced second attribute value . A reading step of reading, from a storage unit, one or more files including a budget, a record representing the cost incurred, and a record of payment representing the amount of the payment, output from the accounting system;
A conversion step of converting the content of the file output from the accounting system, based on definition information for converting the content of the file output from the accounting system into a desired format,
Is a file editing program that causes a computer to execute
By rewriting the definition information, the operation of the process in the conversion step can be changed,
The definition information Ri Ah in the file that defines the change of the hierarchical structure to organize the content contained in the file output from the accounting system,
The file output from the accounting system is tabular data in which a plurality of records including a plurality of values corresponding to a plurality of attributes are registered,
In the conversion step, if a value indicating a corrected hierarchy in which the second attribute value is to be displayed according to the form layout is registered as the first attribute value in the definition information, A third attribute value which is one of a plurality of attributes corresponding to an output position in the form based on the second attribute value after the replacement in the file, while replacing the value with the first attribute value. A file editing program that changes the location where is registered .

Images