CN-121981079-A - Bidirectional conversion method and system for vehicle network DBC database and electronic table

Abstract

The invention discloses a bidirectional conversion method of a vehicle network DBC database and a spreadsheet, which comprises a conversion method from DBC to the spreadsheet and a reverse conversion and reconstruction method from the spreadsheet to the DBC, wherein the conversion method from DBC to the spreadsheet comprises the steps of S101, structural analysis, S102, templated mapping, S103, relational filling and visualization, and the reverse conversion and reconstruction method from the spreadsheet to the DBC comprises the steps of S201, data reading and change identification, S202, rule conflict verification, and S203, structural reconstruction. The invention solves the technical pain points of poor editability and easy error of the DBC file, and realizes lossless and bidirectional conversion between the DBC file and the electronic form through a structured conversion rule, thereby greatly improving the editing, checking and cooperation efficiency of engineers.

Inventors

• CHEN ZEJIAN
• CHEN YONG
• Si Te
• Fan Santong

Assignees

• 芜湖埃泰克汽车电子股份有限公司

Dates

Publication Date

20260505

Application Date

20251231

Claims (9)

1. 1. The bidirectional conversion method of the vehicle network DBC database and the electronic form is characterized by comprising a conversion method from DBC to electronic form and a reverse conversion and reconstruction method from electronic form to DBC; the conversion method from DBC to electronic table comprises the following steps: s101, carrying out structural analysis; Step S102, templated mapping; step 103, relational filling and visualization; the reverse conversion and reconstruction method from the electronic form to the DBC comprises the following steps: step S201, data reading and change identification; step S202, checking rule conflict; And S203, structuring reconstruction.
2. 2. The method of bi-directional conversion between a DBC database and a spreadsheet of a vehicle network as claimed in claim 1, wherein in step S101, the analysis engine is used to analyze the DBC file to extract key information definitions including file version, baud rate, network node set, message frame set, signal set, annotation information, feature attributes, numerical table and signal set relation.
3. 3. The method for bi-directional conversion between a DBC database and a spreadsheet on a vehicle network as claimed in claim 2, wherein in step S102, a spreadsheet template is generated based on the DBC file structure rule, the spreadsheet template is used for corresponding to network nodes, message frames, signals and other entities, and the header field in the spreadsheet template is a key attribute of the DBC file and is in a recognizable format compatible with the syntax of the DBC file.
4. 4. The method for bi-directional conversion between a DBC database and a spreadsheet of a vehicle network as claimed in claim 3, wherein in step S103, each piece of extracted field information is filled in the corresponding position of the spreadsheet template according to the corresponding attribute.
5. 5. The method for bi-directional conversion between a DBC database and a spreadsheet for a vehicle as claimed in any one of claims 1-4, wherein in step S201, the spreadsheet file edited by the user is read.
6. 6. The method for bi-directional conversion between a DBC database and a spreadsheet of a vehicle as claimed in claim 5, wherein in step S202, the contents of the changes in the spreadsheet are forcedly checked according to the grammar and the logic rule library of the DBC file, and the next step is performed if the verification is passed.
7. 7. The method for bi-directional conversion between a DBC database and a spreadsheet of a vehicle network as claimed in claim 6, wherein in step S203, the data in the spreadsheet is reassembled and written into the new DBC file according to the mapping relation and the hierarchical structure.
8. 8. A bi-directional conversion system of a vehicle network DBC database and a spreadsheet, the system comprising: The analysis module is used for structurally analyzing, reading and memorizing the DBC file format; the template generation module is used for generating a spreadsheet template with a compatible field format; The filling and visualizing module is used for relational filling of the analysis data into the template; the verification module is used for performing DBC rule conflict detection on the edited electronic form data; And the reconstruction module is used for recoding the verified spreadsheet data into a standard DBC file.
9. 9. The system for bi-directional conversion between a vehicle network DBC database and a spreadsheet according to claim 8, wherein the system is provided with a storage medium and a communication interface, the storage medium is connected to a vehicle CAN network through the communication interface, the storage medium is a computer readable storage medium for storing software program code for executing the bi-directional conversion method between a vehicle network DBC database and a spreadsheet according to any one of claims 1-7.

Description

Bidirectional conversion method and system for vehicle network DBC database and electronic table Technical Field The invention relates to the technical field of automobile electronics and communication. Background In the development of automotive electronic control systems, the CAN bus is the main in-vehicle network protocol. The DBC file is a text file in a standard format for describing network nodes, messages, signals and all their attributes on the CAN bus. However, DBC files, as a professional, structured text file, have the following inherent drawbacks: 1. Poor readability-engineers need to read and edit complex grammar rules (such as bo_, sg_ identifiers, etc.) in the text editor, are not intuitive and are prone to error. 2. The editing efficiency is low, when the messages or signals are modified, searched or compared in batches, the operation is very inconvenient, and the version management is difficult during collaborative development. 3. The error correction threshold is high, the grammar and logic rules of the DBC file are strict, the whole file is easy to be resolved and failed due to format errors or logic conflicts (such as signal overlapping, identifier repetition and the like) during manual editing, and the errors are difficult to locate. Currently, there is a lack of effective tools in the industry that can provide highly readable, highly easy-to-use editing environments while maintaining strict rules for DBC files. For example, the publication number is CN119155175A, the publication date is 2024, 12 months and 17 days, and the patent name is published in the publication of a method, a device and a vehicle for configuring DBC files of a control local area network database, the disclosed method comprises the steps of extracting information from a first DBC file to obtain CAN message information; the PDU routing file is extracted to obtain CAN routing information, if the CAN message information does not accord with a first preset rule, the first DBC file is determined to be abnormal, if the CAN routing information does not accord with a second preset rule, the PDU routing file is determined to be abnormal, if the CAN message information accords with the first preset rule, and the CAN routing information accords with a second preset rule, the CAN message information is configured according to the CAN routing information, and the second DBC file is obtained. The method can intuitively operate the moisture-free editing interface, and a nondestructive and bidirectional bridge can be built between the intuitive editing interface and the standard DBC file. Disclosure of Invention The technical problem to be solved by the invention is to realize a bidirectional conversion method and a system for constructing a nondestructive bidirectional bridge DBC database and an electronic form between an intuitive editing interface and a standard DBC file. In order to achieve the aim, the technical scheme adopted by the invention is that the bidirectional conversion method of the vehicle network DBC database and the electronic form comprises a conversion method from DBC to the electronic form and a reverse conversion and reconstruction method from the electronic form to the DBC; the conversion method from DBC to electronic table comprises the following steps: s101, carrying out structural analysis; Step S102, templated mapping; step 103, relational filling and visualization; the reverse conversion and reconstruction method from the electronic form to the DBC comprises the following steps: step S201, data reading and change identification; step S202, checking rule conflict; And S203, structuring reconstruction. In the step S101, the analysis engine is used to analyze the questions of the DBC file, and extract the key information definition, where the key information definition includes file version, baud rate, network node set, message frame set, signal set, annotation information, feature attribute, value table and signal group relation. In the step S102, a spreadsheet template is generated based on the DBC file structure rule, where the spreadsheet template is used for corresponding to entities such as network nodes, message frames, signals, and the like, and a header field in the spreadsheet template is a key attribute of the DBC file and is in an identifiable format compatible with the syntax of the DBC file. In step S103, the extracted field information is filled into the corresponding position of the spreadsheet template according to the corresponding attribute. In the step S201, a spreadsheet file edited by a user is read. In step S202, the change content in the electronic form is forcedly checked according to the grammar and the logic rule base of the DBC file, and the next step is performed if the check is passed. In step S203, the data in the electronic table is reassembled according to the mapping relationship and the hierarchical structure and written into the new DBC file. A bi-directional conversion