KR101885089B1 - Excel export method for bim design files - Google Patents

Abstract

The present invention relates to a method of converting an architectural building information modeling (BIM) design file into an excel file, capable of outputting various contents of a family, a project, etc. designed through a Revit program in an architectural BIM design, as an excel file format. The method of converting an architectural BIM design file into an excel file according to the present invention, which converts a drawing file designed through a Revit program into an excel file through an excel file conversion program for BIM, includes the steps of extracting attribute information of family information for the drawing file designed through the Revit program; and classifying the extracted family attribute information according to materials, and then converting the extracted family attribute information into an excel file by sequentially exporting the extracted family attribute information through an excel tool. Data of the design file can be easily corrected, and data sharing is possible between excel files so that collaboration work can be performed.

Description

{EXCEL EXPORT METHOD FOR BIM DESIGN FILES}

The present invention relates to a method of converting an architectural BIM design file into an Excel file. More particularly, the present invention relates to a method of converting an architectural BIM design file into an excel file, To a file switching method.

In recent years, BIM (Building Information Modeling) has emerged as a design tool for the next generation design environment. In general, each design stage in the field of architecture consists of planning design, basic design, implementation design, etc., and it is essential to input information about each component through each stage of design.

 The reason why information on these components is essential is that architectural design is basically a field where various fields such as structure, machine, electricity, and communication cooperate not only with architecture. For example, in the case of a drawing where several people work together, when there is a part of a drawing that needs to be corrected, it is necessary to know exactly which part has been modified and what value the old project file has Architectural design time is reduced.

The strength of BIM technology is that it enables collaborative work and it is shared in real time. Since the work of the same drawing in different fields is shared with other people in real time, the process of completing a single task and developing it into the next process is reduced and the design period is shortened. This can lead to overall cost savings.

Revit is the architectural design program for BIM technology. Revit is the representative software of BIM software developed for Autodesk's BIM implementation. It is designed for building design, documentation, Document, system. Revit is a single software application that uses Revit in conceptual design to model the design precisely, optimize performance, and collaborate effectively. In Revit, a family is a data (or library) symbolizing components (eg, windows, walls, furniture, etc.) that enter a variety of architectural designs. If defined by the designer, it is stored in Revit as a file with an extension name of rft.

In Revit, a family is not simply a symbol, but it contains everything that varies in size and content of the symbol. For example, a "door" symbol is a single symbol that has a unique shape and size in real life, but the "door" family in Revit encompasses various sizes and materials that can be contained in one form. Therefore, when selecting a family in the "Type Selector", you will select something labeled "Door: 800 × 2400". So, in fact, if you do not have a family, you can not use Revit.

 However, in the use of this important family, it is impossible to share or reuse a family created by one designer with another designer. This is one of the reasons why Revit BIM is widely used as a next-generation architectural design tool but is not widely used in domestic business. Therefore, each designer has to make his / her own family. Because it is difficult to share and difficult to recycle, there is redundancy, hassle and inefficiency of tasks that need to be newly rewritten if designers are different from family works on similar buildings.

In this way, it is not easy to reuse highly precisely modeled values (families) in the design process. Even if you want to reuse the files, the speed of the design program decreases when you use it for other projects. There is a problem that reusability becomes difficult due to redundancy error. Therefore, as shown in FIG. 2, a program that can easily share / combine / process a family into another design drawing more easily and to easily reuse the family by processing / modifying property values of the family / project is required .

Korean Patent Publication No. 10-2015-0066692 (published on June 17, 2015)

The present invention has been proposed in order to solve the problem that the conventional Revit family can not be reused. The object of the present invention is to provide a method and system for outputting various contents such as a family or a project designed through a Revit program in a BIM design, And to modify and modify the data without using the Revit program, and to provide a method of converting an architectural BIM design file to an Excel file.

In order to accomplish the above object, according to the present invention, an Excel file conversion method of an architectural BIM design file includes an architectural BIM design for converting a drawing file designed through a Revit program into an Excel file through an Excel file conversion program for building information modeling A method of converting an Excel file into a file, the method comprising: extracting attribute information of family information on a drawing file designed through the Revit program; Classifying the extracted family property information by the same object, and then converting the extracted family property information into an Excel file in order through an Excel tool.

The step of fetching the family property information of the drawing file reads the family information of the drawing file using the Revit SDK (Software Development Kit), and extracts the family property information in the form of Excel data.

Here, the step of extracting the family attribute information of the drawing file may include extracting an ID for a family of a drawing file to be converted from an Revit DB (Data Base) in which drawing information is registered to an Excel file, Fetching the property information Index of the family according to the value, and extracting the family property information according to the property information Index.

The step of converting into the Excel file may further include classifying the family property information extracted from the Revit DB by IDs, and writing the attribute information values into the Excel file in order according to the Index of the family property information sorted by the ID And converting the data into an Excel file.

Wherein the step of classifying the family property information by ID specifies an initial taxon group designated at the time of generation of the family information through the Revit program through the index of the family property information classified by the ID, , It is classified into the same object family, and the family property information is classified by ID.

Meanwhile, the step of fetching the family property information of the drawing file retrieves the family identification information of the drawing file stored in Revit through the Revit API (Application Programming Interface) provided in the Revit SDK, The parameter values of the imported information are sorted in the order of symbol, number, English, and Hangul in the ListBox () in the interface, The parameter values are arranged in the order of the families displayed on the Revit, converted into Excel data through the Excel.Interop function provided by MS (Micro Soft), the parameter name of the Excel data is entered in the Worksheet, .

The Excel file conversion program is preferably an Add-in type program driven in the Revit program.

According to the method of converting the Excel file of the architectural BIM design file according to the present invention, the data in the Revit design document is visualized by outputting the family / project file designed in the Revit program as an Excel file in the BIM design, And sharing of excel files is enabled, so that it is possible to perform a collaborative work.

That is, according to the present invention, by outputting the Revit design file as an Excel file, it is possible to modify or change the desired design drawing without driving the Revit program or directly view the design drawing, Can be improved. In addition, the changed files can be recycled and modified for use by other designers, so that it is possible to eliminate the inconvenience and inefficiency of resuming similar architectural designs from the beginning.

1 is a conceptual diagram of an Excel file conversion method of an architectural BIM design file according to the present invention,
FIG. 2 is a flowchart illustrating an operation of importing family attribute information of a drawing file using a Revit SDK (Software Develop Kit) according to the present invention;
FIG. 3 is a flowchart illustrating an operation of creating attribute information of the family information into an Excel file according to the present invention.
FIG. 4 is a diagram illustrating an example of a family Excel data file designed through Revit, converted into an Excel file,
5 shows an example of a family information value in the drawing in Revit according to the present invention,
Figure 6 shows a class diagram of the Revit API according to the present invention,
7 is an example of a code for converting data summarized by Revit into Excel according to the present invention,
8 shows an example of a file for activating the Revit Add-in button according to the present invention,
9 shows an example of an add-in external tool activation window according to the present invention,
10 is a diagram showing an example of a Revit Add-in program created in the Revit Tool according to the present invention,
11 is an example of an execution interface of Export Excel according to the present invention,
12 is a view showing an example of an Excel file extracted through an Excel conversion program according to the present invention,
13 is an example of a screen comparing the Excel file and the family information according to the present invention.

Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings.

1 illustrates a concept of an Excel file conversion method of an architectural BIM design file according to an embodiment of the present invention.

As shown in FIG. 1, the present invention allows families to more easily share / combine / process families into other design drawings and to facilitate reuse of families by processing / modifying property values of families / projects Provides a way to convert Excel file to architectural BIM design file. That is, in the embodiment of the present invention, when editing a pre-created Revit design file with the Revit program, all information such as the inter-layer information including the family information of the design file created through the Revit Add-in program is converted into an Excel file So that it can switch.

To this end, the architectural BIM design file conversion method of the present invention extracts the family property information of the drawing file from Revit, and then converts the drawing file into an Excel file using the family property information.

2 is a flowchart illustrating an operation of importing family property information of a drawing file using a Revit SDK (Software Develop Kit) according to an embodiment of the present invention.

 Steps S100 and S110: First, the design drawing file is opened (S100), and the information of the drawing is obtained from the Revit DB (Data Base) (S110). The information of the created existing drawing exists in the DB as a pair value of ID and attribute information for each family. In this case, the ID value refers to a value that is not overlapped with the ID value given when the family information is generated in the drawing.

Steps S120 and S140: If the ID value is obtained, the authority to view the attribute information related to the ID value is obtained. At this time, the attribute information differs according to the ID value according to the family information. If there is no ID value, the operation of fetching the family attribute information is terminated (S140).

Step S130: If the authority to view the attribute information is obtained, the attribute information Index (Property Index) is received, and then the values according to the Index of the attribute information are received and used.

FIG. 3 is a flowchart illustrating an operation of creating attribute information of the family information into an Excel file according to an embodiment of the present invention.

Steps S200, S210, S211: First, if the attribute information according to the ID value is obtained (S200), the same families are classified by ID (S210). If there is no identical family by ID, the family information does not exist (S211).

S230 and S230: At this time, the family information received from the Revit DB in the ID value is divided into IDs. If the ID values of the first two digits are the same (S220), it is determined that the family is of the same material type (S230) . If the ID values of the first two digits are different, it is known that the family is a different material (S240). In addition, when generating family information, since the classification is specified in the Revit program in advance, it is possible to designate the earliest taxon by searching Revit DB through the ID value.

If you assign the initial taxa and classify the material using the first two digits of the ID, then export the attribute information values through the Excel tool in order according to the index of the attribute information, and the operation is completed.

Hereinafter, a method of converting an Excel Revit design drawing to Excel will be described in more detail.

The present invention relates to an architectural BIM design file for sharing / joining / processing a family, i.e., elements (doors, windows, furniture, etc.) File conversion method, it is possible to correct simple errors without viewing the design drawing through the Revit program by processing / modifying the property values of the family / project in the Excel file generated through the present invention, , It is possible to understand the progress of the same design drawing and to return to the previous version conveniently.

FIG. 4 shows an example of a screen in which the contents of a family Excel data designed through Revit are converted into an Excel file.

As shown in the left side of FIG. 4, the data contents of an enormous amount of Excel files generated by a designer in a Revit program at the time of designing a family / project exists in a form that the designer can not recognize, and can not be extracted in the form of an Excel file , It appears to be in Excel format only within the Revit program. However, in the present invention, such data can be generated in the form shown in the right side of FIG. 4 and extracted as an independent file of Excel, so that it is possible to modify the contents without Revit and to share data with other designers do.

In the present invention, an Excel file conversion program of a BIM design file was developed using Revit 2016 (hereinafter referred to as Revit), which is generally used in architectural practice. This is a kind of add-in program, It operates in a form that calls the developed module linked from the Revit interface. To do this, we developed the software development kit (SDK) provided by Revit distributor Autodesk.

The Excel file conversion program of the BIM design file according to the present invention reads the BIM data produced by Revit, reconstructs the data into an Excel sheet environment, and programs it. The part that generates Excel data is developed in C # using Revit SDK, and it extracts each constituent object (family) of building model made in Revit and extracts it as Excel data format.

5 shows an example of the family information value in the drawing in Revit.

As shown in FIG. 5, all of the excel data (for example, walls, furniture, roofs, etc.) designed through Revit are numerical values and are used to map basic surfaces and materials provided by Revit And the data of such Excel is confirmed only through the Revit program, and it is impossible to transmit it to other people.

Therefore, in the Excel file conversion program according to the present invention, such numerical values are extracted to distinguish first the inquiry data value and the roof data value. In addition, there is data that can be modified in each family, such as the horizontal or vertical value of the query, and it is possible to modify the data values that can be modified with an Excel file.

In the present invention, information of a drawing in Revit can be retrieved through the Revit API (Application Programming Interface) provided in the Revit SDK. FIG. 6 shows a class diagram of the Revit API. In Revit API classes, a function that can get all the information of a drawing exists in ParameterElement (). Since the amount of information in the drawing is not small, it is important to retrieve the information by checking all the parameters in the drawing through the get function in order to get the desired information. At this time, the parameter values are sorted so that information can be displayed in ListBox () in Interface. Sorting is done in the order of symbol, number, English, and Korean.

In addition, when the information is loaded onto the interface, it is important to make the information into an Excel file. In this case, the Excel.Interop function provided by the MS is used. The name of the parameter is put in the Worksheet, and the ID and each property value are put together.

7 shows an example of a code for converting data rearranged in Revit into Excel. FIG. 7 shows a portion of the data retrieved from Revit in an easy-to-understand manner and putting the data in Excel. When you draw a drawing in Revit, it draws the drawing in object base. Therefore, it is important to arrange the data of Revit in a user-friendly manner because the amount of data generated by the CAD program used in the existing architectural design is larger than the amount of data generated in the CAD program. The process of analyzing all the values connected to Excel and exporting them to Excel is shown in FIG. You can see that the string format is set to be written to Excel in the order of values for the category I want, the attributes it belongs to, and the attributes.

Hereinafter, a process of adding-in an Excel file conversion program of the BIM design file developed in the present invention to a commercial Revit program will be described.

When the Excel file conversion program proposed in the present invention is executed, a computer in which Revit 2016 is installed is automatically debugged with the Revit program. After debugging, the code shown in FIG. 8 is written in the folder where the Revit program is installed. FIG. 8 is an example of a file activating the Revit Add-in button.

Thereafter, the desired design drawing is selected and entered into the edit mode. FIG. 9 shows an example of an add-in external tool activation window. As shown in FIG. 10, an external tool button is activated and displayed on the add-in tab.

Thereafter, a Revit Add-in program as shown in FIG. 10 is created in the Revit Tool. By default, Revit allows an add-in system, which allows users to configure their own programs and embed programs in Revit to make them more convenient to use with Revit. Since the Excel file conversion program according to the present invention must read the drawing file of Revit, it takes the form of an add-in type program rather than an independent program.

When the user presses Export Excel in the Add-in program of FIG. 10, the window of FIG. 11 appears. FIG. 11 shows an example of an execution interface of Export Excel. Referring to FIG. 11, when the Accept button is pressed, the drawing data is retrieved. After a short while, family lists are all displayed in the checklist box. At that time, if you click the entire family list and select the storage location of the file, all the information in the drawing will be exported to Excel. If you do not need all the family content, you can also click on the required items and extract them to Excel.

Hereinafter, verification of an Excel file conversion program of a BIM design file according to the present invention will be described.

The verification of the program verifies whether or not the information of the family shown in FIG. 5 can be completely extracted in the form of an Excel file. This is because the family information, that is, the properties of the wall such as the length, If you can change it to view it, you can modify the drawing. FIG. 12 shows an example of an Excel file of a drawing extracted through the Excel conversion program according to the present invention.

In addition, in order to verify the accuracy of the Excel file from the drawing file and the Excel conversion program of the add-in type, the information of the family that can be viewed on Revit was verified against the information extracted from the Excel file. FIG. 13 is a view showing an example of a screen comparing indexes classified into families having the same attributes in an Excel file generated through the present invention according to the present invention, and family information in a drawing shown on a Revit program. You can see 100% match. 100% match means that you can convert all information into an Excel file when you convert the drawing information to an Excel file. As a result, you can view the drawings and the drawings at a glance. Intuitively.

The reason why this Excel conversion program is necessary is that Revit is basically a graphical representation, and therefore, it is a heavy tool to execute easily, and there is a fatal disadvantage that it can not be executed on a general tablet PC which is widely used nowadays. Since the Excel conversion program is an Excel file, you can not modify the whole large picture, but if you need to modify the drawing easily, you can use it as an Excel file, .

Also, in Revit, you can not output the same list of drawings in the same way as the created drawings, so double-tasking occurs in which the creation of the table is repeated twice. On the other hand, if the Excel conversion program according to the present invention is used, the list can be output in the form of an Excel file when the schedule is created in Revit, so that it can be used in another place without performing double operation again.

In this way, the present invention proposes an Excel file conversion program to solve the problem of inefficiency through design sharing in a non-efficient way in the Revit program for architectural design using BIM. Revit files are made up of families, and they are made into Excel files. This makes it easier to share files among users and allows you to view all the information on the drawings in a data format so that designers can have intuitive information sharing do.

It is to be understood that the present invention is not limited to the above-described embodiment, and that various modifications and changes may be made by those skilled in the art without departing from the spirit and scope of the appended claims. Of course, can be achieved.

Claims (7)

If a drawing file for building information modeling (BIM) is designed through a Revit program installed in a computer, the designed drawing file is converted into an Excel file in an Excel file conversion program installed in the computer and operated in conjunction with a Revit program As an Excel file conversion method of an architectural BIM design file,
(A) fetching attribute information of family information about a drawing file designed through the Revit program in the Excel file switching program; Classifying the extracted family property information by the same entity and then converting the extracted family property information into an Excel file in order through an Excel tool,
The step (a) of extracting the family attribute information of the drawing file includes an ID (ID) for a family of drawing files to be converted from an Revit DB (Data Base) in which drawing information is registered using an Revit SDK (Software Development Kit) Fetches the family attribute information Index corresponding to the fetched ID value, fetches the family property information according to the attribute information Index,
The step (b) of converting into the Excel file is a step of classifying the family property information extracted from the Revit DB by IDs, and designating an initial taxon group designated at the generation of the family information through the Revit program through the index of the family attribute information classified by ID And if the first two digits of the ID value are the same, classifies the family attribute information into IDs by the same object family and classifies the attribute information values into Excel according to the Index of the family attribute information sorted by the IDs, And converting the BIM design file into an Excel file.
delete delete delete delete The method according to claim 1,
In the step (a) of fetching the family property information of the drawing file,
The family identification information of the drawing file stored in Revit is retrieved through the Revit API (Application Programming Interface) provided by the Revit SDK,
The Revit API
Through the get function, all the parameters of all the drawing information in the ParameterElement () function of Revit are checked,
Parameter values of the imported information are arranged in the order of symbol, number, English, and Hangul in ListBox () in Interface,
The parameter values are arranged in the order of the families displayed on the Revit, converted into Excel data through an Excel.Interop function provided by MS (Micro Soft)
A method of converting an Excel file into a BIM design file, characterized by including a parameter name of Excel data in a Worksheet and inputting an ID and attribute information.
7. The method according to claim 1 or 6,
Wherein the Excel file conversion program is an Add-in format program driven in the Revit program.

Images