Model information data automatic processing method

Abstract

The invention discloses an automatic processing method for model information data, which comprises the following three stages: stage 1: automatically creating family parameters and assigning values based on Dynamo for automatically processing the family parameters; stage 2, constructing automatic coding based on Dynamo, wherein the automatic coding is used for automatically processing constructed coding information parameters; and stage 3: visual data exporting based on Data Shape, which is used for screening and processing detail table data from the BIM model, and exporting the detail table data as an Excel file. The invention relates to the technical field of constructional engineering, and can solve the technical problems in the prior art.

Description

Technical Field

[0001] The present invention relates to the technical field of construction engineering, and in particular to a method for automatically processing model information data. Background Art

[0002] The BIM model construction process involves many elements, including but not limited to doors, windows, beams, columns, pipes, valves, and pipe elbows. However, the following problems may arise in the traditional construction process:

[0003] (1) Low work efficiency. Repetitive work requires BIM modelers to spend a lot of time and energy to create and modify the same or similar components, resulting in low model creation efficiency and easy delays in project progress.

[0004] (2) Low model accuracy. Manual creation and modification of repeated components can easily lead to errors in size, position, attributes, etc. due to negligence or fatigue, reducing model accuracy.

[0005] (3) Poor model reliability. Repetitive work results in inconsistent quality and performance of components in the model. Some components are not created according to standard specifications, which affects the overall quality and reliability of the model and reduces its credibility.

[0006] Therefore, it is necessary to provide a method for automatically processing model information data to solve the above technical problems. Summary of the Invention

[0007] The purpose of the present invention is to provide a method for automatically processing model information data, which can solve the above technical problems.

[0008] The present invention is achieved in that:

[0009] A method for automatically processing model information data includes three stages:

[0010] Phase 1: Automated creation and assignment of family parameters based on Dynamo to automate the processing of family parameters;

[0011] Phase 2: Dynamo-based automatic coding for automated processing of coding information parameters.

[0012] Phase 3: Data Shape-based visual data export, used to filter and process the schedule data from the BIM model and export it as an Excel file.

[0013] The first stage comprises the following steps:

[0014] Step 1: Preparation stage;

[0015] Step 2: Data conversion;

[0016] Step 3: Data screening;

[0017] Step 4: Data acquisition;

[0018] Step 5: Parameter creation;

[0019] Step 6: Parameter assignment, that is, assigning values ​​to family parameters.

[0020] Described step 1 comprises the following sub-steps:

[0021] Step 1.1: Prepare the name of the family parameter to be created in an Excel file and save it as a family file in Excel format;

[0022] Step 1.2: Get the family file path, that is, the folder where the family file is located;

[0023] Step 1.3: Filter out the family files with the suffix ".rfa" in the folder;

[0024] Step 1.4: Open the filtered family file in the background and obtain the current document name;

[0025] Step 1.5: Set B = current document name list, N = total number of elements;

[0026] Step 1.6: Enter the element you want to find;

[0027] Step 1.7: Get the Excel file, import Sheet1 in the table, and read the first row of the matrix;

[0028] Described step 2 comprises the following sub-steps:

[0029] Step 2.1: Determine whether the first row matrix needs to be transposed. If so, execute steps 2.2 and 4. If not, execute step 3.

[0030] Step 2.2: Read the first line of the list;

[0031] Described step 3 comprises the following sub-steps:

[0032] Step 3.1: Specify the last line in the Excel table as the family file name;

[0033] Step 3.2: Set d = the number of items in the given list, set the filter function to A = d - 1 = the list to search, and set An = the item in the list to search;

[0034] Step 3.3: Initialize index n = 0 and set Bn = the item to be searched;

[0035] Step 3.4: Use Dynamo's List.FirstIndexOf node to determine if the index exceeds the list length. If so, output -1 and go to step 3.8. If not, execute step 3.5.

[0036] Step 3.5: Determine whether Bn=A. If so, proceed to step 3.6. If not, n=n+1 and return to step 3.3.

[0037] Step 3.6: Determine whether N = n. If so, then b = the index number list of the matching item, B = b-1. If not, return to step 3.3.

[0038] Step 3.7: Output the sorted list;

[0039] Step 3.8: Report an error, prompt the user to modify and redo the process, and then terminate abnormally;

[0040] Described step 4 comprises the following sub-steps:

[0041] Step 4.1: Delete the first row of the original matrix;

[0042] Step 4.2: Get all parameter contents of the remaining part of the original matrix;

[0043] Described step 5 comprises the following sub-steps:

[0044] Step 5.1: Define parameter grouping and parameter types;

[0045] Step 5.2: Create family parameters;

[0046] Step 5.3: Set family parameters;

[0047] Step 5.4: Determine whether the family parameters are set. If so, proceed to step 5.5. If not, return to step 5.3.

[0048] Step 5.5: Set family parameters by parameter name, filter and sort the device names;

[0049] Step 5.6: Copy and save the file.

[0050] The second stage includes the following steps:

[0051] Step 1: Data acquisition;

[0052] Step 2: Specify the index;

[0053] Step 3: Component coding.

[0054] Described step 1 comprises the following sub-steps:

[0055] Step 1.1: Get the family parameter list;

[0056] Step 1.2: Use the file selector to select the sheet of the Excel file containing the preset family component code;

[0057] Step 1.3: Read and preload the corresponding data table. Preferably, the data table can be loaded through an algorithm process;

[0058] Described step 2 comprises the following sub-steps:

[0059] Step 2.1: Set A = start index value, B = end index value, C = index step size;

[0060] Step 2.2: Loop indexing in the preloaded data table until the start index value equals the end index value, that is, when A=B, the specified index ends;

[0061] Described step 3 comprises the following sub-steps:

[0062] Step 3.1: Return the corresponding index item from the single sublist of the family parameter for the specified index.

[0063] Step 3.2: Apply the parameters to the model to achieve automatic encoding of components.

[0064] The third stage includes the following steps:

[0065] Step 1: Filter the details list;

[0066] Step 2: Set the export items;

[0067] Step 3: Export data and feedback.

[0068] Described step 1 comprises the following sub-steps:

[0069] Step 1.1: Retrieve all available schedules in the BIM model;

[0070] Step 1.2: Get the given string;

[0071] Step 1.3: Find the corresponding index and exclude the detailed lists that obviously do not meet the requirements;

[0072] Step 1.4: Filter the details table by selecting items;

[0073] Described step 2 comprises the following sub-steps:

[0074] Step 2.1: Based on the filtered list name, the supervisor dynamically obtains the file path mechanism;

[0075] Step 2.2: Create the specific location where the detailed list needs to be exported, that is, the file output path;

[0076] Step 2.3: Create a detailed table name;

[0077] Described step 3 comprises the following sub-steps:

[0078] Step 3.1: Combine the data in the detailed table to be output to achieve interactive output of the data in a visual user interface;

[0079] Step 3.2: Export all combined data into an Excel spreadsheet;

[0080] Step 3.3: Open the Excel spreadsheet.

[0081] Compared with the prior art, the present invention has the following beneficial effects:

[0082] 1. The present invention reduces manual operation time and speeds up the model building process by automatically processing model information data, effectively improving overall work efficiency and contributing to on-time project delivery. At the same time, it can better meet the market demand for high-quality, intelligent buildings and promote the development of the construction industry from extensive to intensive.

[0083] 2. The present invention accurately generates components and their associated information based on preset rules and standards, reducing errors caused by human error, such as dimensional deviations and attribute errors, thereby improving the accuracy and reliability of the model and providing a more reliable decision-making basis for subsequent applications; at the same time, it also improves the overall quality of the model and enhances the credibility of the model in subsequent applications.

[0084] 3. The present invention generates accurate and complete model information data through automated processing, which can provide a solid data foundation for the building intelligent operation and maintenance system, and help realize efficient and intelligent operation and maintenance of buildings; at the same time, it can improve the management level and benefits of the entire life cycle of buildings, and promote the development of the construction industry towards high quality and intelligence.

[0085] 4. The present invention is based on Dynamo's automatic processing of model data, has good versatility and ease of use, can be easily integrated into the existing BIM workflow, and is easy to be widely promoted and applied in the construction industry, bringing practical benefits to construction companies and practitioners. BRIEF DESCRIPTION OF THE DRAWINGS

[0086] Figure 1 It is a three-stage flow chart of the automatic processing method of model information data of the present invention;

[0087] Figure 2 This is a flow chart of the first stage of the method for automatically processing model information data of the present invention;

[0088] Figure 3 This is a specific operational flow chart of the first stage of the model information data automatic processing method of the present invention;

[0089] Figure 4 This is a flow chart of the second stage of the method for automatically processing model information data of the present invention;

[0090] Figure 5 This is a specific operational flow chart of the second stage of the model information data automatic processing method of the present invention;

[0091] Figure 6 This is a flow chart of stage three of the method for automated processing of model information data of the present invention;

[0092] Figure 7 This is a specific operational flow chart of stage three of the model information data automatic processing method of the present invention;

[0093] Figure 8 This is a schematic diagram of writing data in one column by row in stage three of the method for automatically processing model information data of the present invention;

[0094] Figure 9 This is a schematic diagram of writing m rows and n columns of data in the third stage of the automatic processing method of model information data of the present invention;

[0095] Figure 10 This is a schematic diagram of data row and column transposition input in stage three of the model information data automatic processing method of the present invention. DETAILED DESCRIPTION

[0096] The present invention will be further described below with reference to the accompanying drawings and specific embodiments.

[0097] Please see the attached Figure 1 , a method for automatic processing of model information data, including three stages:

[0098] Phase 1: Automated creation and assignment of family parameters based on Dynamo to automate the processing of family parameters.

[0099] Phase 2: Dynamo-based automatic coding is used to automatically process the coding information parameters.

[0100] Phase 3: Data Shape-based visual data export, used to filter and process the schedule data from the BIM model and export it as an Excel file.

[0101] Dynamo is an open source visual programming software that is mainly used for parametric design and automated processes in the BIM (Building Information Modeling) field. It can realize automatic processing of model information data, improve work efficiency, and ensure the accuracy and reliability of the model.

[0102] Please see the attached Figure 2 and attached Figure 3, the stage 1 comprises the following steps:

[0103] Step 1: Preparation stage.

[0104] Described step 1 comprises the following sub-steps:

[0105] Step 1.1: Prepare the family parameter names to be created in an Excel file and save it as a family file in Excel format.

[0106] Step 1.2: Get the family file path, that is, the folder where the family file is located.

[0107] Step 1.3: Filter out the family files with the suffix ".rfa" in the folder.

[0108] Step 1.4: Open the filtered family file in the background and obtain the current document name.

[0109] Step 1.5: Set B = current document name list, N = total number of elements.

[0110] Step 1.6: Enter the element you want to find.

[0111] Step 1.7: Get the Excel file, import Sheet1 in the table, and read the first row of the matrix.

[0112] Step 2: Data conversion.

[0113] Described step 2 comprises the following sub-steps:

[0114] Step 2.1: Determine whether the first row of the matrix needs to be transposed. If so, execute steps 2.2 and 4. If not, execute step 3.

[0115] Since Excel is read vertically, the first row of the matrix needs to be transposed. The specific transposition process is:

[0116] Assume A is an m×n matrix (i.e., m rows and n columns), as shown in Formula 1, the element in the i-th row and j-th column is a(i, j), i.e., A=(a ij ) m×n , replace the rows of the m×n matrix A with columns of the same ordinal number to obtain an n×m matrix, which is called the transposed matrix of A, denoted by A T , as shown in formula 2. For example:

[0117]

[0118] Step 2.2: Read the first line of the list.

[0119] Step 3: Data screening.

[0120] Since each row of the column has its corresponding model, the model names need to be filtered and sorted.

[0121] Described step 3 comprises the following sub-steps:

[0122] Step 3.1: Specify the last line in the Excel table as the family file name.

[0123] Step 3.2: Set d = the number of items in the given list. To ensure the generality of the algorithm, set the filter function to A = d-1 = the list to be searched, and set An = the number of items in the list to be searched.

[0124] Step 3.3: Initialize index n = 0 and set Bn = the item to be searched.

[0125] Step 3.4: Use Dynamo's List.FirstIndexOf node to determine if the index exceeds the list length. If so, output -1 and go to step 3.8. If not, execute step 3.5.

[0126] Step 3.5: Determine whether Bn=A. If so, proceed to step 3.6. If not, n=n+1 and return to step 3.3.

[0127] Step 3.6: Determine whether N=n. If so, b=the index number list of the matching item, B=b-1. If not, return to step 3.3.

[0128] Step 3.7: Output the sorted list.

[0129] Step 3.8: Report an error, prompt the user to modify and redo the process, and the process ends abnormally.

[0130] Step 4: Data acquisition.

[0131] Described step 4 comprises the following sub-steps:

[0132] Step 4.1: Delete the first row of the original matrix.

[0133] Step 4.2: Get all parameter contents of the remaining part of the original matrix.

[0134] Step 5: Parameter creation.

[0135] Described step 5 comprises the following sub-steps:

[0136] Step 5.1: Define the parameter grouping method and parameter type. Preferably, set the family parameter type to text.

[0137] Step 5.2: Create family parameters.

[0138] Step 5.3: Set family parameters.

[0139] Step 5.4: Determine whether the family parameters are set. If so, execute step 5.5; if not, return to step 5.3.

[0140] Step 5.5: Set family parameters by parameter name, filter and sort the device names.

[0141] Step 5.6: Copy and save the file.

[0142] Step 6: Parameter assignment, that is, assigning values ​​to family parameters.

[0143] Please see the attached Figure 4 and attached Figure 5 , the second stage comprises the following steps:

[0144] Step 1: Data acquisition.

[0145] Described step 1 comprises the following sub-steps:

[0146] Step 1.1: Get the family parameter list.

[0147] Step 1.2: Use the file selector to select the sheet of the Excel file containing the preset family component code.

[0148] Step 1.3: Read and preload the corresponding data table. Preferably, the data table can be loaded through an algorithm process.

[0149] Step 2: Specify the index.

[0150] Described step 2 comprises the following sub-steps:

[0151] Step 2.1: Set A = start index value, B = end index value, and C = index step size.

[0152] Step 2.2: Loop indexing in the preloaded data table until the start index value is equal to the end index value, that is, when A=B, the specified index ends.

[0153] Step 3: Component coding.

[0154] Described step 3 comprises the following sub-steps:

[0155] Step 3.1: Return the corresponding index item from the single sublist of the family parameter for the specified index.

[0156] Step 3.2: Apply the parameters to the model to achieve automatic encoding of components.

[0157] Please see the attached Figure 6 To the attached Figure 10 , the stage three comprises the following steps:

[0158] Step 1: Filter the details list.

[0159] Described step 1 comprises the following sub-steps:

[0160] Step 1.1: Retrieve all available schedules in the BIM model.

[0161] Step 1.2: Get the given string.

[0162] Step 1.3: Find the corresponding index and exclude the detailed lists that obviously do not meet the requirements.

[0163] Preferably, an algorithm may be set to distinguish upper and lower case names of the detailed lists, and duplicate detailed lists may be merged and converted into options for selection in the next step.

[0164] Step 1.4: Filter the details table by selecting items.

[0165] Step 2: Set up export items.

[0166] Described step 2 comprises the following sub-steps:

[0167] Step 2.1: Based on the filtered list name, the supervisor dynamically obtains the file path mechanism.

[0168] Step 2.2: Create the specific location where the detailed list needs to be exported, that is, the file output path.

[0169] Step 2.3: Create a schedule name.

[0170] Step 3: Export data and feedback.

[0171] Described step 3 comprises the following sub-steps:

[0172] Step 3.1: Combine the data in the detailed table to be output to achieve interactive output of the data in a visual user interface.

[0173] This process involves operations such as transposing rows and columns of data to ensure that the data can be displayed and exported in a suitable format.

[0174] Step 3.2: Export all combined data into an Excel spreadsheet.

[0175] When exporting data to Excel, the specified file path and worksheet name will be obtained from the user interface, and data will be written starting from column 0 and row 0 as required. When writing 1 column of data by row, as shown in the attached file, Figure 8 As shown in the attached file, when writing m rows and n columns of data, Figure 9 As shown in the attached figure, the data is transposed into rows and columns. Figure 10 shown.

[0176] At the same time, the Excel spreadsheet is set to overwrite the existing file to ensure that the exported data is up to date.

[0177] After the data is successfully exported or the export operation is canceled, the algorithm will provide feedback to the user on the status of export completion or export cancellation, so that the user can understand the results of the export task in a timely manner.

[0178] Step 3.3: Open the Excel spreadsheet.

[0179] The present invention can quickly generate and modify a large number of repeated components and their related information based on preset rules and algorithms, thereby significantly reducing manual operation time and accelerating the model building process. At the same time, automated processing can accurately generate components and their related information based on preset rules and standards, reducing errors caused by human errors, such as dimensional deviations, attribute errors, etc., thereby improving the overall quality of the model, enhancing the credibility of the model in subsequent applications, and providing a more reliable decision-making basis for all participants. In addition, the accurate and complete model information data generated by automated processing can provide a solid data foundation for the building's intelligent operation and maintenance system. During the operation and maintenance stage, the system can implement functions such as equipment monitoring, fault warning, and energy consumption analysis based on these data, helping to achieve efficient and intelligent operation and maintenance of buildings, and improving the management level and benefits of the building's entire life cycle.

[0180] The above are only preferred embodiments of the present invention and are not intended to limit the scope of protection of the invention. Therefore, any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. A method for automatically processing model information data, characterized by: It consists of three stages: Phase 1: Automated creation and assignment of family parameters based on Dynamo to automate the processing of family parameters; Phase 2: Dynamo-based automatic coding for automated processing of coding information parameters. Phase 3: Data Shape-based visual data export, used to filter and process the schedule data from the BIM model and export it as an Excel file.

2. The method for automatic processing of model information data according to claim 1, characterized in that: The first stage comprises the following steps: Step 1: Preparation stage; Step 2: Data conversion; Step 3: Data screening; Step 4: Data acquisition; Step 5: Parameter creation; Step 6: Parameter assignment, that is, assigning values ​​to family parameters.

3. The method for automatic processing of model information data according to claim 2, characterized in that: Described step 1 comprises the following sub-steps: Step 1.1: Prepare the name of the family parameter to be created in an Excel file and save it as a family file in Excel format; Step 1.2: Get the family file path, that is, the folder where the family file is located; Step 1.3: Filter out the family files with the suffix ".rfa" in the folder; Step 1.4: Open the filtered family file in the background and obtain the current document name; Step 1.5: Set B = current document name list, N = total number of elements; Step 1.6: Enter the element you want to find; Step 1.7: Get the Excel file, import Sheet1 in the table, and read the first row of the matrix; Described step 2 comprises the following sub-steps: Step 2.1: Determine whether the first row matrix needs to be transposed. If so, execute steps 2.2 and 4. If not, execute step 3. Step 2.2: Read the first line of the list; Described step 3 comprises the following sub-steps: Step 3.1: Specify the last line in the Excel table as the family file name; Step 3.2: Set d = the number of items in the given list, set the filter function to A = d - 1 = the list to search, and set An = the item in the list to search; Step 3.3: Initialize index n = 0 and set Bn = the item to be searched; Step 3.4: Use Dynamo's List.FirstIndexOf node to determine if the index exceeds the list length. If so, output -1 and go to step 3.

8. If not, execute step 3.

5. Step 3.5: Determine whether Bn=A. If so, proceed to step 3.

6. If not, n=n+1 and return to step 3.

3. Step 3.6: Determine whether N = n. If so, then b = the index number list of the matching item, B = b-1. If not, return to step 3.

3. Step 3.7: Output the sorted list; Step 3.8: Report an error, prompt the user to modify and redo the process, and then terminate abnormally; Described step 4 comprises the following sub-steps: Step 4.1: Delete the first row of the original matrix; Step 4.2: Get all parameter contents of the remaining part of the original matrix; Described step 5 comprises the following sub-steps: Step 5.1: Define parameter grouping and parameter types; Step 5.2: Create family parameters; Step 5.3: Set family parameters; Step 5.4: Determine whether the family parameters are set. If so, proceed to step 5.

5. If not, return to step 5.

3. Step 5.5: Set family parameters by parameter name, filter and sort the device names; Step 5.6: Copy and save the file.

4. The method for automatic processing of model information data according to claim 1, characterized in that: The second stage includes the following steps: Step 1: Data acquisition; Step 2: Specify the index; Step 3: Component coding.

5. The method for automatic processing of model information data according to claim 4, characterized in that: Described step 1 comprises the following sub-steps: Step 1.1: Get the family parameter list; Step 1.2: Use the file selector to select the sheet of the Excel file containing the preset family component code; Step 1.3: Read and preload the corresponding data table. Preferably, the data table can be loaded through an algorithm process; Described step 2 comprises the following sub-steps: Step 2.1: Set A = start index value, B = end index value, C = index step size; Step 2.2: Loop indexing in the preloaded data table until the start index value equals the end index value, that is, when A=B, the specified index ends; Described step 3 comprises the following sub-steps: Step 3.1: Return the corresponding index item from the single sublist of the family parameter for the specified index. Step 3.2: Apply the parameters to the model to achieve automatic encoding of components.

6. The method for automatic processing of model information data according to claim 1, characterized in that: The third stage includes the following steps: Step 1: Filter the details list; Step 2: Set the export items; Step 3: Export data and feedback.

7. The method for automatic processing of model information data according to claim 6, characterized in that: Described step 1 comprises the following sub-steps: Step 1.1: Retrieve all available schedules in the BIM model; Step 1.2: Get the given string; Step 1.3: Find the corresponding index and exclude the detailed lists that obviously do not meet the requirements; Step 1.4: Filter the details table by selecting items; Described step 2 comprises the following sub-steps: Step 2.1: Based on the filtered list name, the supervisor dynamically obtains the file path mechanism; Step 2.2: Create the specific location where the detailed list needs to be exported, that is, the file output path; Step 2.3: Create a detailed table name; Described step 3 comprises the following sub-steps: Step 3.1: Combine the data in the detailed table to be output to achieve interactive output of the data in a visual user interface; Step 3.2: Export all combined data into an Excel spreadsheet; Step 3.3: Open the Excel spreadsheet.

Images