Equipment ledger standardization method and device, equipment and storage medium

Abstract

The invention discloses an equipment ledger standardization method and device, equipment and a storage medium, and the method comprises the steps: obtaining original equipment ledger tables corresponding to a target building project, and extracting each data line from each original equipment ledger table; wherein each data row in the original equipment ledger table comprises equipment attribute information of the set item equipment; obtaining equipment types corresponding to the project equipment recorded by the data rows, and filling the data rows into reference standing book areas in the matched standard equipment standing book table according to the equipment types; wherein different standard equipment ledger tables correspond to different equipment types; each header field in the reference standing book area is matched with each header field in the original equipment standing book table; according to the preset mapping relation between the header fields, the standard standing book areas in the standard equipment standing book table are filled with the data rows in the reference standing book areas respectively, and the standardization efficiency and accuracy of the equipment standing book are improved.

Description

Technical Field

[0001] The present invention relates to the technical field of ledger management, and in particular to a method, apparatus, device and storage medium for standardizing equipment ledgers. Background Art

[0002] Currently, all project equipment in a target construction project is usually recorded and managed in a list-based manner through equipment records. In practical applications, in order to facilitate users to use the equipment records, it is usually necessary to perform standard conversion on the equipment records.

[0003] In the prior art, an original equipment ledger table that complies with original standards is usually modified manually into a standard equipment ledger table that complies with user-defined standards.

[0004] However, the manual method of standardizing equipment ledgers requires complete reliance on manual labor, which increases the cost of equipment ledger standardization while reducing the efficiency and accuracy of equipment ledger standardization. Summary of the Invention

[0005] The present invention provides a method, apparatus, device and storage medium for standardizing equipment records, which reduces the cost of standardizing equipment records and improves the efficiency and accuracy of standardizing equipment records.

[0006] In a first aspect, an embodiment of the present invention provides a method for standardizing equipment records, including:

[0007] Obtaining the original equipment ledger tables corresponding to the target construction project, and extracting each data row in each original equipment ledger table; wherein each data row in the original equipment ledger table contains equipment attribute information of the set project equipment;

[0008] Obtain the equipment type corresponding to the project equipment recorded in each data row, and fill each data row into the reference ledger area in the matching standard equipment ledger table according to the equipment type;

[0009] Among them, different standard equipment ledger tables correspond to different equipment types; each header field in the reference ledger area matches each header field in the original equipment ledger table;

[0010] According to the pre-set mapping relationship between the header fields, each data row in each reference ledger area is filled into the standard ledger area in the corresponding standard equipment ledger table.

[0011] In a second aspect, an embodiment of the present invention further provides a device for standardizing equipment records, including:

[0012] A data row extraction module is used to obtain the original equipment ledger table corresponding to the target construction project and extract each data row in each original equipment ledger table; wherein each data row in the original equipment ledger table contains equipment attribute information of the set project equipment;

[0013] The reference ledger storage module is used to obtain the equipment type corresponding to the project equipment recorded in each data row, and fill each data row into the reference ledger area in the matching standard equipment ledger table according to the equipment type;

[0014] Among them, different standard equipment ledger tables correspond to different equipment types; each header field in the reference ledger area matches each header field in the original equipment ledger table;

[0015] The ledger standard conversion module is used to fill each data row in each reference ledger area into the standard ledger area in the corresponding standard equipment ledger table according to the pre-set mapping relationship between the header fields.

[0016] In a third aspect, an embodiment of the present invention further provides an electronic device comprising: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the equipment ledger standardization method provided in any embodiment of the present invention.

[0017] In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, which stores computer instructions, and the computer instructions are used to enable a processor to implement the equipment ledger standardization method provided by any embodiment of the present invention when executed.

[0018] The technical solution of the present invention automatically fills each data row into the reference ledger area in the matching standard equipment ledger table according to the equipment type corresponding to the project equipment recorded in each data row, and fills each data row in each reference ledger area into the standard ledger area in the corresponding standard equipment ledger table according to the mapping relationship between the pre-set header fields, thereby avoiding the manual standardization of the equipment ledger, which requires complete reliance on manual labor, resulting in high cost and low efficiency and accuracy in the standardization of the equipment ledger. It reduces the cost of standardizing the equipment ledger and improves the efficiency and accuracy of standardizing the equipment ledger.

[0019] It should be understood that the content described in this section is not intended to identify the key or important features of the embodiments of the present invention, nor is it intended to limit the scope of the present invention. Other features of the present invention will become readily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0021] Figure 1 This is a flow chart of a device ledger standardization method provided according to the first embodiment of the present invention;

[0022] Figure 2 This is a flowchart of another device ledger standardization method provided in accordance with the second embodiment of the present invention;

[0023] Figure 3 is a schematic diagram of a standard equipment ledger table provided according to an embodiment of the present invention;

[0024] Figure 4 This is a schematic diagram of the structure of an equipment ledger standardization device provided according to the third embodiment of the present invention;

[0025] Figure 5 It is a structural diagram of an electronic device provided by the fourth embodiment of the present invention. DETAILED DESCRIPTION

[0026] In order to enable those skilled in the art to better understand the solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the embodiments described are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts should fall within the scope of protection of the present invention.

[0027] It should be noted that the terms "first", "second", etc. in the description and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that the numbers used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions. For example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0028] Example 1

[0029] Figure 1 This is a flowchart of a device inventory standardization method provided according to Example 1 of the present invention. This embodiment is applicable to the situation where device inventories are standardized. The method can be executed by a device inventory standardization device. The device inventory standardization device can be implemented in the form of hardware and / or software. The device inventory standardization device can be configured in an electronic device such as a computer.

[0030] like Figure 1 As shown, this embodiment discloses a device ledger standardization method, including:

[0031] S110. Obtain the original equipment ledger table corresponding to the target construction project, and extract each data row in each original equipment ledger table.

[0032] In this step, specifically, the equipment ledger table to be processed corresponding to the target building project input by the user can be obtained, and the equipment ledger table to be processed can be pre-processed according to the content of the equipment ledger table to obtain the original equipment ledger table corresponding to the target building project. Among them, the original equipment ledger table can be used to reflect the project equipment included in the target building project, as well as the attribute information of the project equipment. Then, it can be detected whether each original equipment ledger table includes a header row. If the header row is not detected in the current original equipment ledger table, the name of the current original equipment ledger table and the problems existing in the current original equipment ledger table (that is, there is no header row) are associated and stored in the ledger table problem feedback table to prompt the user to correct the current original equipment ledger table. If the header row is detected in the current original equipment ledger table, each data row is extracted from each original equipment ledger table. Among them, each data row in the original equipment ledger table contains the equipment attribute information of the set project equipment.

[0033] Optionally, when obtaining the original equipment ledger table corresponding to the target construction project, the update time and upload time of each original equipment ledger table can also be obtained. When original equipment ledger tables with the same name are detected, duplicates can be removed based on their update time and upload time. For example, only the original equipment ledger table with the same name whose update time is closest to the current time can be retained.

[0034] S120. Obtain the equipment type corresponding to the project equipment recorded in each data row, and fill each data row into the reference ledger area in the matching standard equipment ledger table according to the equipment type.

[0035] Different standard equipment ledger tables correspond to different equipment types, and the header fields in the reference ledger area match those in the original equipment ledger table. The standard equipment ledger table includes a reference ledger area and a standard ledger area.

[0036] Specifically, in this step, the device type corresponding to the project equipment recorded in each data row can be determined based on the device attribute information recorded in each data row. Then, each data row and the corresponding header row can be populated into the reference ledger area of ​​the matching standard equipment ledger table according to the equipment type.

[0037] S130. According to the pre-set mapping relationship between the header fields, each data row in each reference ledger area is filled into the standard ledger area in the corresponding standard equipment ledger table.

[0038] In this step, specifically, the data items corresponding to each device type can be obtained from a predefined data dictionary, and based on the data items corresponding to each device type, the header fields in the standard ledger area corresponding to each device type are generated. The data dictionary may include information such as the predefined device types, the data items corresponding to each device type, the meaning of each data item, and the data type of each data item. Then, based on the mapping relationship between the header fields in the standard ledger area and the header fields in the reference ledger area, the data rows in the reference ledger area can be filled into the standard ledger area.

[0039] The technical solution of this embodiment is to obtain the original equipment ledger table corresponding to the target construction project, and extract each data row from each original equipment ledger table; wherein, each data row in the original equipment ledger table contains equipment attribute information of the set project equipment; obtain the equipment type corresponding to the project equipment recorded in each data row, and fill each data row into the reference ledger area in the matching standard equipment ledger table according to the equipment type; wherein, different standard equipment ledger tables correspond to different equipment types; each header field in the reference ledger area matches each header field in the original equipment ledger table; according to the mapping relationship between the pre-set header fields, each data row in each reference ledger area is filled into the standard ledger area of ​​the standard equipment ledger table to which it belongs. This technical means solves the problem that the method of standardizing equipment ledgers manually needs to rely entirely on manual labor, resulting in high cost and low efficiency and accuracy of equipment ledger standardization, reduces the cost of standardizing equipment ledgers, and improves the efficiency and accuracy of equipment ledger standardization.

[0040] Example 2

[0041] Figure 2 This is a flowchart of another equipment inventory standardization method provided according to Example 2 of the present invention. This embodiment is a further optimization and expansion based on the above embodiments, and can be combined with various optional technical solutions in the above implementation methods.

[0042] like Figure 2 As shown, this embodiment discloses a device ledger standardization method, including:

[0043] S210: Obtain each equipment ledger table to be processed input by the user for the target construction project, and delete the meaningless tables and empty tables in each equipment ledger table to be processed to obtain an initial equipment ledger table.

[0044] Among them, the table without ledger meaning may include a ledger explanation table used to explain the equipment ledger and a ledger filling guidance table used to guide the filling of the equipment ledger.

[0045] The advantage of this setting is that by deleting the meaningless tables and empty tables, it is possible to avoid further processing of the meaningless tables and empty tables, thereby improving the standardization efficiency of the equipment ledger.

[0046] S220. Delete the serial number column in the initial equipment ledger table to obtain the original equipment ledger table corresponding to the target construction project.

[0047] Each data row in the original equipment ledger table contains device attribute information of the set project equipment. The serial number column can be a column containing only serial numbers.

[0048] The advantage of this setting is that by deleting the serial number column in the original equipment ledger table, it can avoid the coexistence of the serial number column and the row number, which easily interferes with the artificial intelligence (AI)'s recognition of the data rows in the original equipment ledger table, thereby improving the accuracy of data row recognition.

[0049] Optionally, when preprocessing the equipment ledger table to be processed (that is, identifying and deleting tables with no ledger meaning, empty tables, and serial number columns in the initial equipment ledger table), the progress of the preprocessing or the remaining time required can be displayed to the user so that the user can arrange his time reasonably, thereby avoiding blocking the user from performing other work.

[0050] S230. In each original equipment ledger table, obtain the current original equipment ledger table and detect whether the current original equipment ledger table is a multi-header ledger table. If so, execute S240; if not, execute S250.

[0051] Among them, the multi-header ledger table can be a ledger table containing multiple header rows.

[0052] In this step, specifically, when it is detected that there is a header row in the current original equipment ledger table, it can be detected whether the current original equipment ledger table is a multi-header ledger table.

[0053] S240. In the current original equipment ledger table, traverse to obtain the row number of each header row, and store it in the header row number table; in the current original equipment ledger table, extract each data row whose row number does not fall into the header row number table in turn.

[0054] In this step, specifically, AI can be used to extract, in the current original equipment ledger table, the data rows whose row numbers do not fall into the header row number table according to the row numbers of the header rows in the current original equipment ledger recorded in the header row number table.

[0055] For example, assuming that the row numbers of the header rows in the current original equipment ledger table are 4, 5, 10 and 11 respectively, the name of the current original equipment ledger table can be added to the multi-header ledger table name column of the header row number table, and 4, 5, 10 and 11 can be added to the header row number column of the header row number table.

[0056] S250. Starting from the second row of the current original equipment ledger table, extract each data row in sequence.

[0057] In this step, specifically, since the header row of the original equipment ledger table with a single header row is usually the first row, each data row can be extracted in sequence starting from the second row of the current original equipment ledger table.

[0058] S260. Obtain the equipment type corresponding to the project equipment recorded in each data row, and fill each data row into the reference ledger area in the matching standard equipment ledger table according to the equipment type.

[0059] Among them, different standard equipment ledger tables correspond to different equipment types, and the header fields in the reference ledger area match the header fields in the original equipment ledger table.

[0060] For example, assuming that the equipment type is a centrifugal chiller, the standard equipment ledger table corresponding to the centrifugal chiller can be obtained, and each data row and the header row corresponding to each data row can be added to the table. Figure 3 The reference ledger area of ​​the standard equipment ledger table shown in the figure includes the following header fields: equipment usage system, equipment number, equipment name, equipment / system service scope, main parameters, rated cooling capacity, design evaporator inlet water temperature, rated power, and rated evaporator chilled water flow.

[0061] Optionally, the device types corresponding to the project devices recorded in each data row are obtained, including: in each data row, the current data row is obtained in turn; through a pre-built AI model, the attribute information of each device in the current data row is identified, and whether the AI ​​model can accurately output the device type that matches the current data row; if so, the device type output by the AI ​​model is determined to be the device type corresponding to the project device recorded in the current data row; if not, the attribute information of each device in the current data row is filled into the device overview table; return to execute the operation of obtaining the current data row in turn in each data row until the processing of all data rows is completed; obtain the updated device overview table at the end of the iteration, and provide the device overview table to the user to click to determine the device type.

[0062] Among them, the equipment attribute information may include the name, number, quantity, technical parameters and installation location of the project equipment. Specifically, when it is detected that the AI ​​model can accurately output the equipment type that matches the current data row, the equipment type output by the AI ​​model can be determined as the equipment type corresponding to the project equipment recorded in the current data row, and according to the equipment type, the current data row is filled into the reference ledger area of ​​the matching standard equipment ledger table. When it is detected that the AI ​​model cannot accurately output the equipment type that matches the current data row, the reference equipment type corresponding to the project equipment recorded in the current data row is determined based on the attribute information of each device in the current data row, and the attribute information of each device in the current data row and the reference equipment type corresponding to the project equipment recorded in the current data row are filled into the equipment overview table.

[0063] The advantage of this setting is that when it is detected that the AI ​​model cannot accurately output the device type that matches the current data row, the attribute information of each device in the current data row is filled into the device overview table, and the device overview table is provided to the user to click to determine the device type. This can avoid directly adding the data row to the wrong standard equipment ledger table, thereby improving the accuracy of the results of the standardized conversion of the equipment ledger.

[0064] Optionally, a device overview table is provided to the user for selection to determine the device type, including: predicting at least one reference device type corresponding to each fill row based on the device attribute information contained in each fill row in the device overview table, and adding the reference device type to the device type reference column in each fill row; adding each alternative device type in the pre-built device type overview table to the device type selection column in each fill row in the form of a drop-down menu; in response to a drop-down operation triggered by the user on the device type selection column of the target fill row in the device overview table, displaying all alternative device types that match the target fill row to the user; in response to the user selecting a target alternative device type from all alternative device types based on the device type reference column of the target fill row, determining the target alternative device type as the device type corresponding to the data row that matches the target fill row.

[0065] The standard equipment inventory table, equipment overview table, and equipment type overview table can be stored as separate worksheets within the same spreadsheet file. The equipment overview table includes columns for equipment type selection, selected equipment type code, equipment type reference, equipment attribute information, and whether manual equipment type specification is required. The equipment type overview table includes columns for candidate equipment types and candidate equipment type code. The candidate equipment types in the candidate equipment type column can be determined based on the equipment types predefined in the aforementioned data dictionary.

[0066] Specifically, after receiving the target alternative device type selected by the user from all alternative device types, the target device type code corresponding to the target alternative device type can be obtained in the device type overview table, and the target device type code can be added to the selected device type code column of the target fill row.

[0067] For example, Table 1 is an equipment overview table provided according to an embodiment of the present invention. As shown in Table 1, when it is detected that the AI ​​model cannot accurately output the equipment type that matches the current data row, the equipment attribute information recorded in the current data row can be added to the equipment attribute information column. Then, based on the equipment attribute information contained in each equipment attribute information column, it can be predicted that the reference equipment types corresponding to the first filling row and the second filling row are both absorption chillers and centrifugal chillers, the reference equipment types corresponding to the third filling row and the fourth filling row are both hot water pumps and make-up water pumps, and the reference equipment type corresponding to the fifth filling row is a parking management control module.

[0068] Table 1

[0069]

[0070]

[0071] Continuing with the previous example, Table 2 is a device type summary table provided according to an embodiment of the present invention. As shown in Table 2, assuming the user selects the parking management control module as the target candidate device type in the fifth fill-in row, the target device type code corresponding to the parking management control module can be determined as WEGMCU based on the device type summary table. WEGMCU is then added to the selected device type codes in the fifth fill-in row.

[0072] Table 2

[0073]

[0074] The benefit of this setup is that by providing the user with an equipment overview table so they can click to determine the equipment type, the user can intuitively display the equipment attribute information and reference equipment type corresponding to each data row, making it easier to quickly determine the equipment type corresponding to each data row. This improves the efficiency of determining the equipment type and, in turn, the efficiency of standardizing the original equipment ledger table. Secondly, by storing the standard equipment ledger tables, equipment overview table, and equipment type overview table as separate worksheets in the same spreadsheet file, the efficiency of populating the data rows from the original equipment ledger table into the standard equipment ledger table can be improved.

[0075] S270. Obtain the target device type corresponding to the target standard device ledger table currently being processed, as well as the target data item corresponding to the target device type, and determine the correspondence between each header field in the reference ledger area and the target data item based on the meaning description of the target data item.

[0076] In this step, specifically, all data items corresponding to the target device type can be obtained in the above-mentioned data dictionary, and the target data items can be filtered in each data item according to the reference label of each data item. Exemplarily, assuming that the reference labels corresponding to each data item include ledger, technology, operation and setting, only the data items with reference labels of ledger and technology can be used as target data items. Then, the header fields in the standard ledger area can be generated according to the target data items corresponding to the target device type. Finally, the target data items that have a corresponding relationship with the header fields in the reference ledger area can be filled into the reference ledger area. Among them, the target data item may not correspond to any header field in the reference ledger area.

[0077] For example, Figure 3As shown, the target equipment type corresponding to the target standard equipment ledger table is a centrifugal chiller. The target data items corresponding to the centrifugal chiller include the equipment number, fixed asset code, asset name, outline, rated cooling capacity, rated power, rated voltage, rated evaporator chilled water flow, brand, equipment model, and installation location. After generating the header fields in the standard ledger area based on the target data items corresponding to the centrifugal chiller, the meaning of each target data item can be used to determine that the equipment number in the reference ledger area is the fixed asset code in the standard ledger area, the equipment name in the reference ledger area is the fixed asset name in the standard ledger area, the equipment / system service scope in the reference ledger area is the installation location in the standard ledger area, and the rated cooling capacity, rated power, and rated evaporator chilled water flow in the reference ledger area are the rated cooling capacity, rated power, and rated evaporator chilled water flow in the standard ledger area.

[0078] S280. According to the corresponding relationship, fill each data row in the reference ledger area into the standard ledger area of ​​the target standard equipment ledger table.

[0079] In this embodiment, the header row of the standard ledger area includes target data items corresponding to the target device type. Specifically, based on this correspondence, device ledger data can be retrieved from each data row in the reference ledger area. The data type of each device ledger data item can then be checked and corrected based on the data type of each target data item predefined in the data dictionary. The checked and corrected device ledger data can then be populated into the standard ledger area of ​​the target standard device ledger table.

[0080] For example, Figure 3 As shown, the equipment ledger data under the equipment number column, equipment name column, equipment / system service scope column, rated cooling capacity column, rated power column, and rated evaporator chilled water flow column can be obtained in the reference ledger area, and the equipment ledger data can be filled into the standard ledger area of ​​the target standard equipment ledger table.

[0081] Optionally, after filling each data row in each reference ledger area into the standard ledger area in the corresponding standard equipment ledger table, it also includes: comparing the data rows in the standard ledger area with the data rows in the reference ledger area, and correcting the data rows in the standard ledger area based on the comparison results.

[0082] In this step, specifically, based on the comparison results, it can be determined whether there is unfilled or incorrectly filled equipment ledger data in the standard ledger area. Then, if unfilled equipment ledger data is detected in the standard ledger area, the unfilled equipment ledger data can be filled into the standard ledger area; if incorrectly filled equipment ledger data is detected in the standard ledger area, the incorrectly filled equipment ledger data can be corrected.

[0083] The technical solution of this embodiment can avoid the subsequent processing of meaningless tables and empty tables by deleting them, thereby improving the standardization efficiency of the equipment ledger. Secondly, by deleting the serial number column in the initial equipment ledger table, it can avoid the situation where the serial number column and the row number exist at the same time, which easily interferes with the AI's recognition of the data rows in the original equipment ledger table, thereby improving the accuracy of identifying the data rows. Finally, through the meaning description of the target data item, the correspondence between each header field in the reference ledger area and the target data item is determined, and according to the correspondence, each data row in the reference ledger area is filled into the standard ledger area of ​​the target standard equipment ledger table. While realizing the standard conversion of the equipment ledger quickly and accurately, the standard equipment ledger table containing the standard ledger area and the reference ledger area can be intuitively displayed to the user so that the user can make corrections to the standard equipment ledger table in a timely manner.

[0084] Example 3

[0085] Figure 4 This is a structural diagram of an equipment inventory standardization device provided according to Example 3 of the present invention. This embodiment can be applied to situations where equipment inventories are standardized. The equipment inventory standardization device can be implemented in the form of hardware and / or software and can be configured in electronic devices such as computers.

[0086] like Figure 4 As shown, the device ledger standardization device disclosed in this embodiment includes:

[0087] The data row extraction module 41 is used to obtain the original equipment ledger table corresponding to the target construction project and extract each data row in each original equipment ledger table; wherein each data row in the original equipment ledger table contains the equipment attribute information of the set project equipment;

[0088] The reference ledger storage module 42 is used to obtain the equipment type corresponding to the project equipment recorded in each data row, and fill each data row into the reference ledger area in the matching standard equipment ledger table according to the equipment type;

[0089] Among them, different standard equipment ledger tables correspond to different equipment types; each header field in the reference ledger area matches each header field in the original equipment ledger table;

[0090] The ledger standard conversion module 43 is used to fill each data row in each reference ledger area into the standard ledger area in the corresponding standard equipment ledger table according to the pre-set mapping relationship between the header fields.

[0091] The technical solution in this embodiment solves the problem that the standardization of equipment ledgers is carried out manually, which requires complete reliance on manual labor, resulting in high cost, low efficiency and accuracy in standardizing equipment ledgers, through the mutual cooperation of the data row extraction module, the reference ledger storage module and the ledger standard conversion module. It reduces the cost of standardizing equipment ledgers and improves the efficiency and accuracy of standardizing equipment ledgers.

[0092] Optionally, when obtaining the original equipment ledger table corresponding to the target construction project, the data row extraction module 41 is specifically used to: obtain the various equipment ledger tables to be processed input by the user for the target construction project, and delete the meaningless tables and empty tables in each equipment ledger table to be processed to obtain the initial equipment ledger table; delete the serial number column in the initial equipment ledger table to obtain the original equipment ledger table corresponding to the target construction project.

[0093] Optionally, when extracting each data row in each original equipment ledger table, the data row extraction module 41 is specifically used to: obtain the current original equipment ledger table in each original equipment ledger table, and detect whether the current original equipment ledger table is a multi-header ledger table; if so, then in the current original equipment ledger table, extract each data row whose row number does not fall into the header row number table in turn; wherein the header row number table includes the row number of each header row of the multi-header ledger table; if not, starting from the second row of the current original equipment ledger table, extract each data row in turn.

[0094] Optionally, the reference ledger storage module 42 includes:

[0095] The device attribute recognition unit is used to sequentially obtain the current data row from each data row; identify the attribute information of each device in the current data row using a pre-built AI model, and detect whether the AI ​​model can accurately output the device type that matches the current data row;

[0096] a first device type determining unit, configured to determine the device type output by the AI ​​model as the device type corresponding to the project device recorded in the current data row;

[0097] The device attribute storage unit is used to fill the attribute information of each device in the current data row into the device overview table if no;

[0098] The data row loop acquisition unit is used to return to the operation of executing in each data row and sequentially acquire the current data row until all data rows are processed;

[0099] The second device type determination unit is configured to obtain a device overview table updated when the iteration ends, and provide the device overview table to the user for selection and determination of the device type.

[0100] Optionally, the second device type determination unit is specifically used to: predict at least one reference device type corresponding to each fill row based on the device attribute information contained in each fill row in the device overview table, and add the reference device type to the device type reference column in each fill row; add each alternative device type in the pre-built device type overview table to the device type selection column in each fill row in the form of a drop-down menu; in response to the user triggering a drop-down operation on the device type selection column of the target fill row in the device overview table, display all alternative device types that match the target fill row to the user; in response to the user clicking on the target alternative device type from all alternative device types based on the device type reference column of the target fill row, determine the target alternative device type as the device type corresponding to the data row that matches the target fill row.

[0101] Optionally, the ledger standard conversion module 43 is specifically used to: obtain the target device type corresponding to the target standard equipment ledger table currently being processed, and the target data item corresponding to the target device type, and determine the correspondence between each header field in the reference ledger area and the target data item based on the meaning of the target data item; according to the correspondence, fill each data row in the reference ledger area into the standard ledger area of ​​the target standard equipment ledger table; wherein, the header row of the standard ledger area includes the target data item corresponding to the target device type.

[0102] Optionally, the device further includes a standard data correction module, which is used to compare the data rows in the standard ledger area with the data rows in the reference ledger area, and to correct the data rows in the standard ledger area based on the comparison results.

[0103] The device for standardizing equipment records provided in the embodiments of the present invention can execute the device record standardization method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method. For any content not fully described in this embodiment, please refer to the description of any method embodiment of this application.

[0104] Example 4

[0105] Figure 5 FIG. 1 is a schematic structural diagram of an electronic device 10 that can be used to implement an embodiment of the present invention.

[0106] like Figure 5As shown, the electronic device 10 includes at least one processor 11 and a memory, such as a read-only memory (ROM) 12, a random access memory (RAM) 13, etc., which is communicatively connected to the at least one processor 11. The memory stores a computer program that can be executed by the at least one processor. The processor 11 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 12 or the computer program loaded from the storage unit 18 into the random access memory (RAM) 13. Various programs and data required for the operation of the electronic device 10 can also be stored in the RAM 13. The processor 11, ROM 12, and RAM 13 are connected to each other via a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.

[0107] Multiple components in the electronic device 10 are connected to the I / O interface 15, including an input unit 16, such as a keyboard, a mouse, etc.; an output unit 17, such as various types of displays, speakers, etc.; a storage unit 18, such as a magnetic disk, an optical disk, etc.; and a communication unit 19, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information / data with other devices via a computer network such as the Internet and / or various telecommunication networks.

[0108] The processor 11 can be any general-purpose and / or specialized processing component with processing and computing capabilities. Some examples of the processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various specialized artificial intelligence (AI) computing chips, various processors that run machine learning model algorithms, a digital signal processor (DSP), and any suitable processor, controller, microcontroller, etc. The processor 11 executes the various methods and processes described above, such as the device ledger standardization method.

[0109] In some embodiments, the device inventory standardization method may be implemented as a computer program, which is tangibly contained in a computer-readable storage medium, such as a storage unit 18. In some embodiments, part or all of the computer program may be loaded and / or installed on the electronic device 10 via the ROM 12 and / or the communication unit 19. When the computer program is loaded into the RAM 13 and executed by the processor 11, one or more steps of the device inventory standardization method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to execute the device inventory standardization method in any other appropriate manner (e.g., by means of firmware).

[0110] Various embodiments of the systems and techniques described above can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), system-on-chip systems (SOCs), complex programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments can include being implemented in one or more computer programs that are executable and / or interpreted on a programmable system that includes at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0111] Computer programs for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, such that when the computer program is executed by the processor, the functions / operations specified in the flowcharts and / or block diagrams are implemented. The computer program may be executed entirely on the machine, partially on the machine, as a stand-alone software package, partially on the machine and partially on a remote machine, or entirely on a remote machine or server.

[0112] In the context of the present invention, computer-readable storage media can be tangible media that can contain or store a computer program for use with an instruction execution system, device or equipment or used in combination with an instruction execution system, device or equipment. Computer-readable storage media can include but are not limited to electronic, magnetic, optical, electromagnetic, infrared or semiconductor systems, devices or equipment, or any suitable combination of the foregoing. Alternatively, computer-readable storage media can be machine-readable signal media. More specific examples of machine-readable storage media can include electrical connections based on one or more lines, portable computer disks, hard disks, random access memories (RAM), read-only memories (ROM), erasable programmable read-only memories (EPROM or flash memory), optical fibers, portable compact disk read-only memories (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0113] To provide interaction with a user, the systems and techniques described herein can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user can provide input to the electronic device. Other types of devices can also be used to provide interaction with the user; for example, the feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including acoustic input, voice input, or tactile input).

[0114] The systems and techniques described herein can be implemented in a computing system that includes back-end components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes front-end components (e.g., a user computer with a graphical user interface or web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such back-end components, middleware components, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0115] A computing system may include clients and servers. The clients and servers are typically remote from each other and typically interact via a communication network. This client-server relationship arises through computer programs running on the respective computers, creating a client-server relationship. The server may be a cloud server, also known as a cloud computing server or cloud host. This server is a hosting product within the cloud computing service ecosystem that addresses the management difficulties and limited scalability of traditional physical hosting and VPS services.

[0116] It should be understood that the various forms of the processes shown above can be used to reorder, add, or delete steps. For example, the steps described in the present invention can be performed in parallel, sequentially, or in a different order, as long as the desired results of the technical solution of the present invention can be achieved. This is not limited herein.

[0117] The above specific embodiments do not limit the scope of protection of the present invention. Those skilled in the art will appreciate that various modifications, combinations, sub-combinations, and substitutions may be made based on design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of the present invention are intended to be included within the scope of protection of the present invention.

Claims

1. A method for standardizing equipment records, characterized in that: The method comprises: Obtaining the original equipment ledger tables corresponding to the target construction project, and extracting each data row in each original equipment ledger table; wherein each data row in the original equipment ledger table contains equipment attribute information of the set project equipment; Obtain the equipment type corresponding to the project equipment recorded in each data row, and fill each data row into the reference ledger area in the matching standard equipment ledger table according to the equipment type; Among them, different standard equipment ledger tables correspond to different equipment types; each header field in the reference ledger area matches each header field in the original equipment ledger table; According to the pre-set mapping relationship between the header fields, each data row in each reference ledger area is filled into the standard ledger area in the corresponding standard equipment ledger table.

2. The method according to claim 1, characterized in that Obtain the original equipment ledger corresponding to the target construction project, including: Obtain the equipment ledger tables to be processed that the user inputs for the target construction project, and delete the meaningless and empty tables in the equipment ledger tables to obtain the initial equipment ledger table; Delete the serial number column in the initial equipment ledger table to obtain the original equipment ledger table corresponding to the target construction project.

3. The method according to claim 1, characterized in that Extract each data row from each original equipment ledger table, including: In each original equipment ledger table, obtain the current original equipment ledger table, and detect whether the current original equipment ledger table is a multi-header ledger table; If not, then starting from the second row of the current original equipment ledger table, extract each of the data rows in sequence; If so, in the current original equipment ledger table, traverse to obtain the row number of each header row and store it in the header row number table; In the current original equipment ledger table, the data rows whose row numbers do not fall into the header row number table are extracted in sequence.

4. The method according to claim 1, wherein Get the device type corresponding to the project device recorded in each data row, including: In each of the data rows, sequentially obtain the current data row; Identify the device attribute information in the current data row using a pre-built AI model, and detect whether the AI ​​model can accurately output the device type that matches the current data row; If yes, the device type output by the AI ​​model is determined to be the device type corresponding to the project device recorded in the current data row; If not, then fill the attribute information of each device in the current data row into the device overview table; Returning to the operation of sequentially obtaining the current data row in each of the data rows until all data rows are processed; Get the updated device overview table when the iteration ends, and provide the device overview table to the user to click and confirm the device type.

5. The method according to claim 4, characterized in that Provide a device overview table for users to click and determine the device type, including: Predicting at least one reference device type corresponding to each filled row based on the device attribute information contained in each filled row in the device overview table, and adding the reference device type to the device type reference column in each filled row; Add each alternative device type in the pre-built device type overview table to the device type selection column in each fill row in the form of a drop-down menu; In response to a drop-down operation triggered by a user on the device type selection column of a target fill row in a device overview table, all alternative device types matching the target fill row are displayed to the user; in response to a target alternative device type clicked by the user from all alternative device types based on the device type reference column of the target fill row, the target alternative device type is determined as the device type corresponding to the data row matching the target fill row.

6. The method according to any one of claims 1 to 4, characterized in that According to the pre-set mapping relationship between the header fields, each data row in each reference ledger area is filled into the standard ledger area in the corresponding standard equipment ledger table, including: Obtain the target device type corresponding to the target standard device ledger table currently being processed, as well as the target data item corresponding to the target device type, and determine the correspondence between each header field in the reference ledger area and the target data item based on the meaning description of the target data item; According to the corresponding relationship, each data row in the reference ledger area is filled into the standard ledger area of ​​the target standard equipment ledger table; Among them, the header row of the standard ledger area includes target data items corresponding to the target device type.

7. The method according to any one of claims 1 to 4, characterized in that After filling each data row in each reference ledger area into the standard ledger area of ​​the corresponding standard equipment ledger table, it also includes: Compare the data rows in the standard ledger area with the data rows in the reference ledger area, and modify the data rows in the standard ledger area based on the comparison results.

8. A device for standardizing equipment records, characterized in that: The device comprises: A data row extraction module is used to obtain the original equipment ledger table corresponding to the target construction project and extract each data row in each original equipment ledger table; wherein each data row in the original equipment ledger table contains equipment attribute information of the set project equipment; The reference ledger storage module is used to obtain the equipment type corresponding to the project equipment recorded in each data row, and fill each data row into the reference ledger area in the matching standard equipment ledger table according to the equipment type; Among them, different standard equipment ledger tables correspond to different equipment types; each header field in the reference ledger area matches each header field in the original equipment ledger table; The ledger standard conversion module is used to fill each data row in each reference ledger area into the standard ledger area in the corresponding standard equipment ledger table according to the pre-set mapping relationship between the header fields.

9. An electronic device, characterized in that: The electronic device comprises: At least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the equipment inventory standardization method described in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the equipment ledger standardization method according to any one of claims 1 to 7 when executed.

Images