CN109033338B - Method and system for generating database file of automobile communication protocol - Google Patents
Method and system for generating database file of automobile communication protocol Download PDFInfo
- Publication number
- CN109033338B CN109033338B CN201810811025.8A CN201810811025A CN109033338B CN 109033338 B CN109033338 B CN 109033338B CN 201810811025 A CN201810811025 A CN 201810811025A CN 109033338 B CN109033338 B CN 109033338B
- Authority
- CN
- China
- Prior art keywords
- column
- row
- node
- cell
- target
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 230000006854 communication Effects 0.000 title claims abstract description 230
- 238000004891 communication Methods 0.000 title claims abstract description 229
- 238000000034 method Methods 0.000 title claims abstract description 44
- 239000011159 matrix material Substances 0.000 claims abstract description 129
- 230000008054 signal transmission Effects 0.000 claims description 9
- 238000001514 detection method Methods 0.000 claims description 7
- 238000000605 extraction Methods 0.000 claims description 5
- 238000011161 development Methods 0.000 description 6
- 230000011664 signaling Effects 0.000 description 6
- 230000005540 biological transmission Effects 0.000 description 2
- 238000013479 data entry Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 206010063385 Intellectualisation Diseases 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The invention provides a method and a system for generating a database file of an automobile communication protocol, wherein the method comprises the following steps: extracting a node communication matrix related to a target communication node from the whole vehicle signal communication matrix; newly building a template text file, wherein variable types required to be defined by a database file are written in the template text file; reading the node communication matrix, generating signal description contents corresponding to signals in the node communication matrix according to the variable types, and writing the signal description contents into the template text file; renaming the suffix of the template text file into the suffix of the database file to obtain a target database file, and removing complicated and repeated manual input labor, thereby reducing the workload and the error rate.
Description
Technical Field
The invention relates to the field of automobile communication, in particular to a method and a system for generating a database file of an automobile communication protocol.
Background
With the continuous development of the automobile industry, the intellectualization of automobiles becomes an important development direction. Therefore, the communication modules in the vehicle carry more and more communication functions.
The communication protocol is a communication matrix for signal interaction in a vehicle network, and the dbc (data Base for can) file is a development file for recording signals for a can (controller Area network) bus in the industry, and the signals of the two files are in one-to-one correspondence.
However, with the increase of the signal transmission function of the automobile, a large amount of data entry is needed in the development process of database files of communication protocols and DBCs in the automobile, the error rate is high, and a large amount of manpower and development time are wasted.
Disclosure of Invention
The embodiment of the invention provides a method and a system for generating a database file of an automobile communication protocol, which aim to solve the problems of high error rate and labor waste caused by the fact that a large amount of data entry is required in the development process of database files of the communication protocol and DBC in an automobile along with the increase of automobile signal transmission functions.
In order to solve the technical problem, the invention is realized as follows:
in a first aspect, an embodiment of the present invention provides a method for generating a database file of an automotive communication protocol, including:
extracting a node communication matrix related to a target communication node from the whole vehicle signal communication matrix;
newly building a template text file, wherein variable types required to be defined by a database file are written in the template text file;
reading the node communication matrix, generating signal description contents corresponding to signals in the node communication matrix according to the variable types, and writing the signal description contents into the template text file;
and renaming the suffix of the template text file into the suffix of the database file to obtain the target database file.
Optionally, the step of extracting a node communication matrix related to the target communication node from the entire vehicle signal communication matrix includes:
copying a header row in the whole vehicle signal communication matrix to a node communication matrix form;
sequentially detecting cell values listed by the AD in a header row of the whole vehicle signal communication matrix;
when detecting that the cell value of one cell listed from the AD column in the header row is the target communication node, determining that the cell is listed as the a column;
respectively starting from the 2 nd row, detecting whether the cell values of the a-th column and the G-th column are simultaneously null;
if the cell values are not null at the same time, detecting the cell value of the a-th column;
determining the row where the cell with the cell value of the a-th column equal to S or R is positioned as a first target row;
copying the data of the first target row to the node communication matrix form to obtain a node communication matrix of the target communication node;
the AD column records the names of all communication nodes on a network segment where the finished automobile signal communication is located in the header row of the finished automobile signal communication matrix; the content recorded in the G-th column is a signal name, the cell value S indicates that the communication node corresponding to the node name of the column in which the cell is located is a sending node, and the cell value R indicates that the communication node corresponding to the node name of the column in which the cell is located is a receiving node.
Optionally, the step of reading the node communication matrix, generating signal description contents corresponding to signals in the node communication matrix according to the variable types, and writing the signal description contents into the template text file includes:
sequentially detecting cell values listed by an AD (analog-to-digital) in a 1 st row of the node communication matrix;
storing the cell values listed from the AD in the 1 st row into an array until detecting that one cell value listed from the AD in the 1 st row is empty; writing the values in the array into a first content display area corresponding to a defined first variable in the template text file;
in the row 1 of the node communication matrix, the AD column records names of nodes on a network segment involved in communication through the target communication node.
Optionally, after the step of writing the values in the array into the first content display area corresponding to the defined first variable in the template text file, the method further includes:
respectively detecting cell values of an A-th column and a G-th column in the same row from the 2 nd row;
determining a row in which the cell value of the A-th column is not null and the cell value of the G-th column is null as a second target row;
sequentially detecting target cells with cell values S in subsequent columns from the AD column in the second target row, and determining node information recorded by a table head of the column where the target cells are located in the subsequent columns as message sending node information;
writing the cell values of the C column, the A column and the F column of the second target row and the message sending node information into a second content display area corresponding to a defined second variable according to a preset format, and writing the cell values of the C column and the y column of the second target row into a third content display area corresponding to a defined third variable according to the preset format until detecting that the F rows are empty when the cell values of the A column and the G column are continuous;
wherein the y-th column includes: the E column, the AA column, the AB column, the AC column and the D column of the second target row;
the content recorded in the A-th column is a message name, the content recorded in the C-th column is a message identifier, the content recorded in the D-th column is a message sending type, the content recorded in the E-th column is message cycle time, the content recorded in the F-th column is message length, the content recorded in the G-th column is a signal name, the content recorded in the AA-th column is a message fast sending cycle, the content recorded in the AB-th column is message fast sending times, and the content recorded in the AC-th column is message delay time.
Optionally, after the step of detecting cell values of an a-th column and a G-th column in the same row from the 2 nd row, the method further includes:
determining a row in which the cell value of the A-th column is null and the cell value of the G-th column is not null as a third target row;
sequentially detecting target cells with cell values of R in subsequent columns from the AD column in the third target row, and determining node information recorded by a table head of the column where the target cells are in the subsequent columns as message receiving node information;
in the template text file, respectively receiving the information of the G column, the M column, the L column, the P column, the Q column, the R column, the S column, the Y column and the message receiving node of the third target row, writing a fourth content display area corresponding to a defined fourth variable according to a preset format, writing a C column, a G column and an H column of the third target row into a fifth content display area corresponding to a defined fifth variable, writing a C column, a G column and a Z column or a W column of the third target row, writing a sixth content display area corresponding to a defined sixth variable according to a preset format, and writing the C column, the G column and the x column of the third target row, writing a seventh content display area corresponding to a defined seventh variable according to a preset format until detecting that the continuous f rows of the cell values of the A column and the G column are all empty;
wherein the x-th column includes: an Nth column, a Vth column, or an Xth column of the third target row;
the content recorded in the H column is signal description, the content recorded in the L column is signal length, the content recorded in the M column is stop bit, the content recorded in the N column is signal transmission type, the content recorded in the P column is precision, the content recorded in the Q column is offset, the content recorded in the R column is physical minimum value, the content recorded in the S column is physical maximum value, the content recorded in the V column is initial value, the content recorded in the W column is invalid value, the content recorded in the X column is non-enabling value, the content recorded in the Y column is unit, and the content recorded in the Z column is signal value description.
In a second aspect, an embodiment of the present invention further provides a system for generating a database file of an automotive communication protocol, where the system includes:
the extraction module is used for extracting a node communication matrix related to the target communication node from the vehicle signal communication matrix;
the system comprises a new building module, a database module and a creating module, wherein the new building module is used for building a template text file, and the template text file is written with a variable type required to be defined by the database file;
the generating module is used for reading the node communication matrix, generating signal description contents corresponding to signals in the node communication matrix according to the variable types, and writing the signal description contents into the template text file;
and the renaming module is used for renaming the suffix of the template text file into the suffix of the database file to obtain the target database file.
Optionally, the extracting module is specifically configured to:
the duplication submodule is used for duplicating the header row in the finished automobile signal communication matrix to a node communication matrix form;
sequentially detecting cell values listed by the AD in a header row of the whole vehicle signal communication matrix;
when detecting that the cell value of one cell listed from the AD column in the header row is the target communication node, determining that the cell is listed as the a column;
respectively starting from the 2 nd row, detecting whether the cell values of the a-th column and the G-th column are simultaneously null;
if the cell values are not null at the same time, detecting the cell value of the a-th column;
determining the row where the cell with the cell value of the a-th column equal to S or R is positioned as a first target row;
copying the data of the first target row to the node communication matrix form to obtain a node communication matrix of the target communication node;
the AD column records the names of all communication nodes on a network segment where the finished automobile signal communication is located in the header row of the finished automobile signal communication matrix; the content recorded in the G-th column is a signal name, the cell value S indicates that the communication node corresponding to the node name of the column in which the cell is located is a sending node, and the cell value R indicates that the communication node corresponding to the node name of the column in which the cell is located is a receiving node.
Optionally, the generating module includes:
the first detection submodule is used for sequentially detecting cell values from the AD column in the 1 st row of the node communication matrix;
the storage submodule is used for storing the cell values listed from the AD in the 1 st row into an array until detecting that one cell value listed from the AD in the 1 st row is empty; the first writing submodule is used for writing the values in the array into a first content display area corresponding to a defined first variable in the template text file;
in the row 1 of the node communication matrix, the AD column records names of nodes on a network segment involved in communication through the target communication node.
Optionally, the system further comprises:
the second detection submodule is used for respectively detecting the cell values of the A-th column and the G-th column in the same row from the 2 nd row;
a first determining submodule, configured to determine, as a second target row, a row in which the cell value of the a-th column is not null and the cell value of the G-th column is null;
a second determining submodule, configured to sequentially detect a target cell in a subsequent column from the AD column in the second target row, where the cell value is S, and determine that node information recorded in a header of the column in which the target cell is located in the subsequent column is packet sending node information;
a second writing sub-module, configured to write cell values in a C-th column, an a-th column, and an F-th column of the second target row and the message sending node information into a second content display area corresponding to a defined second variable according to a preset format, and write cell values in a C-th column and a y-th column of the second target row into a third content display area corresponding to a defined third variable according to the preset format, in the template text file, until it is detected that the F-th row where the cell values in the a-th column and the G-th column are consecutive is empty;
wherein the y-th column includes: the E column, the AA column, the AB column, the AC column and the D column of the second target row;
the content recorded in the A-th column is a message name, the content recorded in the C-th column is a message identifier, the content recorded in the D-th column is a message sending type, the content recorded in the E-th column is message cycle time, the content recorded in the F-th column is message length, the content recorded in the G-th column is a signal name, the content recorded in the AA-th column is a message fast sending cycle, the content recorded in the AB-th column is message fast sending times, and the content recorded in the AC-th column is message delay time.
Optionally, the system further comprises:
a third determining submodule, configured to determine, as a third target row, a row in which the cell value of the a-th column is null and the cell value of the G-th column is not null;
a fourth determining submodule, configured to sequentially detect a target cell in a subsequent column from the AD column in the third target row, where the cell value is R, and determine that node information recorded in a header of the column in which the target cell is located in the subsequent column is packet receiving node information;
a third write-in sub-module, configured to respectively write information of a G-th column, an M-th column, an L-th column, a P-th column, a Q-th column, an R-th column, an S-th column, a Y-th column, and the message receiving node in the third target row in the template text file, writing a fourth content display area corresponding to a defined fourth variable according to a preset format, writing a C column, a G column and an H column of the third target row into a fifth content display area corresponding to a defined fifth variable, writing a C column, a G column and a Z column or a W column of the third target row, writing a sixth content display area corresponding to a defined sixth variable according to a preset format, and writing the C column, the G column and the x column of the third target row, writing a seventh content display area corresponding to a defined seventh variable according to a preset format until detecting that the continuous f rows of the cell values of the A column and the G column are all empty;
wherein the x-th column includes: an Nth column, a Vth column, or an Xth column of the third target row;
the content recorded in the H column is signal description, the content recorded in the L column is signal length, the content recorded in the M column is stop bit, the content recorded in the N column is signal transmission type, the content recorded in the P column is precision, the content recorded in the Q column is offset, the content recorded in the R column is physical minimum value, the content recorded in the S column is physical maximum value, the content recorded in the V column is initial value, the content recorded in the W column is invalid value, the content recorded in the X column is non-enabling value, the content recorded in the Y column is unit, and the content recorded in the Z column is signal value description.
In the embodiment of the invention, the node communication matrix related to the target communication node is extracted from the finished automobile signal communication matrix, the signal description content corresponding to the signal in the node communication matrix is generated based on the node communication matrix and the template text file, and the database file corresponding to the data content of the node communication matrix is finally obtained, so that the automatic and efficient generation of the database file of the automobile communication protocol is realized, the complicated and repeated manual input labor is reduced, the workload is reduced, and the error rate is reduced.
Drawings
FIG. 1 is a flow chart illustrating a method for generating a database file of an automotive communication protocol according to an embodiment of the present invention;
fig. 2 is a block diagram of a system for generating a database file of an automotive communication protocol according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The embodiment of the invention discloses a method for generating a database file of an automobile communication protocol, which is shown in a combined figure 1 and comprises the following steps:
step 101: and extracting a node communication matrix related to the target communication node from the whole vehicle signal communication matrix.
The target communication node is one of the communication nodes in the whole vehicle communication process, and the determination of the target communication node can be selection performed by a system or determination performed according to manual operation input of a user.
The node communication matrix related to the target communication node is specifically a matrix containing communication contents of the transceiving relation of the target communication node. The node communication matrix related to the target communication node is a subset of a signal communication matrix of a network segment where the whole vehicle communication is located, and the process is specifically to screen out matrix rows related to the target communication node from the whole vehicle signal communication matrix to realize extraction.
As a preferred embodiment, the step of extracting a node communication matrix related to the target communication node from the entire vehicle signal communication matrix includes:
copying a header row in the whole vehicle signal communication matrix to a node communication matrix form;
sequentially detecting cell values listed by the AD in a header row of the whole vehicle signal communication matrix;
when detecting that the cell value of one cell listed from the AD column in the header row is the target communication node, recording that the cell is listed as the a column;
respectively starting from the 2 nd row, detecting whether the cell values of the a-th column and the G-th column are simultaneously null;
if the cell values are not null at the same time, detecting the cell value of the a-th column;
determining the row where the cell with the cell value of the a-th column equal to S or R is positioned as a first target row;
and copying the data of the first target row to the node communication matrix list to obtain the node communication matrix of the target communication node.
The AD column records the names of all communication nodes on a network segment where the finished automobile signal communication is located in the header row of the finished automobile signal communication matrix; the content recorded in the G-th column is a signal name, the cell value S indicates that the communication node corresponding to the node name of the column in which the cell is located is a sending node, and the cell value R indicates that the communication node corresponding to the node name of the column in which the cell is located is a receiving node.
Preferably, the node communication matrixes related to the whole vehicle signal communication matrix and the target communication node are recorded and generated in the form of EXCEL tables.
In the process, the node communication matrix form is specifically an Excel form or a form in other forms, an Excel form of a node target communication node is newly built, because the whole vehicle signal communication matrix and the node communication matrix record are both communication protocols and have a value of one attribute, the heads of the two are the same, and the head rows in the whole vehicle signal communication matrix are copied to the newly built node communication matrix form.
Detecting the cell values listed by AD in the finished vehicle signal communication matrix and the cell values in the a-th column and the G-th column from the 2 nd row in the follow-up sequence, aiming at finding out the data of the related rows of the nodes with the attribute of the name of the node of the receiving and sending node or the sending node consistent with the target communication node, wherein the cell values listed by AD in the head row of the finished vehicle signal communication matrix are sequentially detected, when the cell value of one cell listed by AD in the head row is detected as the target communication node, the following steps are executed once, wherein, the cell values in the a-th column and the G-th column are respectively detected to be empty from the 2 nd row, the judgment condition is to judge whether the tail of the table is reached, wherein, the column of the node receiving and sending relation is recorded as the a-th column, if the cell values listed by AD in the head row are sequentially detected, the cell value equal to the target communication node is not found until the cell value of the empty column is detected, it indicates that the target correspondent node is not on the network segment.
Namely, after the step of sequentially detecting the cell values listed by the AD in the header row of the entire vehicle signal communication matrix, the method further includes: if the cell value of one cell listed by the AD column in the head row is detected to be null, the detection operation is ended.
The process screens out rows only related to the target communication node (namely, the rows starting from the 2 nd row and having the cell value of the a-th column of the rows of R (Receive) or S (Send)), copies the contents of the rows into a node communication matrix form of the target communication node until the end of the form is detected, and obtains the node communication matrix of the target communication node.
Step 102: and newly creating a template text file, wherein the variable types required to be defined by the database file are written in the template text file.
In the text file, the written database file needs to define the variable type, so as to realize the subsequent generation of the final database file based on the text file.
The function of different variable types in the variable types is to describe signals in the communication matrix.
Preferably, several areas are set in the template text file, which are respectively: BU _, BO _, BA _ … … BO _, BA … … SG area, SG _, CM _ SG _, VAL _, which are used to describe signals in the communication matrix, in the following specific format:
the BU _ region format is:
BU _: node 1 on network segment node 2 … on network segment.
The BO _ region format is:
BO _ CANID (decimal) message name, message length (default is 8) sending node.
The rule for BA _ … … BO _ area is as follows:
BA _ "GenMsgCycleTime" BO _ CANID (decimal) message cycle time;
BA _ "GenMsgNrOfrepetition" BO _ CANID (decimal) quick transmission times;
BA _ "genmsgcycletiimefast" BO _ candid (decimal) quick transmission period;
BA _ "GenMsgStartDelayTime" BO _ CANID (decimal) message delay time;
BA _ "GenMsgSendType" BO _ CANID (decimal) message sending type; under normal conditions, if the message sending type is cycle, the attribute does not exist in the DBC; if the signaling type is event, the signaling type is 1.
The rule for the BA … … SG _ region is as follows:
BA _ "GenSigSendType" SG _ candid (decimal) signal name signaling type; under normal conditions, if the signaling type is cycle, the attribute does not exist in the DBC; if the signaling type is OnWrite, the signaling type is 2.
BA _ "GenSigStartValue" SG _ candid (decimal) signal name initial value;
BA _ "GenSigInactiveValue" SG _ CANID (decimal) signal name non-enabled value;
the SG _ region format is:
SG _ signal name: the stop bit | signal length @0+ (precision, offset) [ min-physicalvaluemax ] "unit" receives node 1, receiving node 2 … (where 0+ here represents a data type of unidentified and 0-represents a data type of Signed);
the CM _ SG _ region format is:
CM _ SG _ candid (decimal) signal name "signal description";
the VAL _ region format is:
the physical meaning corresponding to each value in the VAL _ candid (decimal) signal value description;
VAL _ candid (decimal) signal name Invalid value (decimal) "Invalid".
The CANID is a message identifier.
Step 103: reading the node communication matrix, generating signal description contents corresponding to the signals in the node communication matrix according to the variable type, and writing the signal description contents into a template text file.
The process is actually taking the values of the cells from the Excel matrix and then filling in the TXT file according to the rules of the DBC file.
Specifically, the step of reading the node communication matrix, generating signal description contents corresponding to signals in the node communication matrix according to the variable types, and writing the signal description contents into the template text file includes:
sequentially detecting cell values listed by an AD (analog-to-digital) in a 1 st row of the node communication matrix;
storing the cell values listed from the AD in the 1 st row into an array until detecting that one cell value listed from the AD in the 1 st row is empty; writing the values in the array into a first content display area corresponding to a defined first variable in the template text file;
in the row 1 of the node communication matrix, the AD column records names of nodes on a network segment involved in communication through the target communication node.
In the node communication matrix, the 1 st row is a header row, the content recorded in the subsequent columns of the header row from the AD column is each node on the network segment, and the name of each node is written into an array BU [ ]inthe process so as to generate a variable of BU _, namely node 1 on the network segment and node 2 … … on the network segment. In the remaining rows from the second row, the content recorded in the subsequent column from the AD column is the description content of each node, for example, the identification of whether each node is a transceiver node.
After the step of writing the values in the array into the first content display area corresponding to the defined first variable in the template text file, the method further includes:
respectively detecting cell values of an A-th column and a G-th column in the same row from the 2 nd row;
determining a row in which the cell value of the A-th column is not null and the cell value of the G-th column is null as a second target row;
sequentially detecting target cells with cell values S in subsequent columns from the AD column in the second target row, and determining node information recorded by a table head of the column where the target cells are located in the subsequent columns as message sending node information;
writing the cell values of the C column, the A column and the F column of the second target row and the message sending node information into a second content display area corresponding to a defined second variable according to a preset format, and writing the cell values of the C column and the y column of the second target row into a third content display area corresponding to a defined third variable according to the preset format until detecting that the F rows are empty when the cell values of the A column and the G column are continuous;
wherein the y-th column includes: the E column, the AA column, the AB column, the AC column and the D column of the second target row;
the content recorded in the A-th column is a message name, the content recorded in the C-th column is a message identifier, the content recorded in the D-th column is a message sending type, the content recorded in the E-th column is message cycle time, the content recorded in the F-th column is message length, the content recorded in the G-th column is a signal name, the content recorded in the AA-th column is a message fast sending cycle, the content recorded in the AB-th column is message fast sending times, and the content recorded in the AC-th column is message delay time.
Preferably, the contents of the records in the rows a to F in the node communication matrix in the embodiment of the present invention are sequentially: the content recorded in the A-th column is a message name, the content recorded in the B-th column is a message type, the content recorded in the C-th column is a message identifier, the content recorded in the D-th column is a message sending type, the content recorded in the E-th column is message cycle time, and the content recorded in the F-th column is message length; the content recorded in column G is the signal name.
In the process, columns A to G are arranged according to the numbering of the sequence of English letters, wherein, the names of the messages recorded in column A, the names of the signals recorded in column G, when column A is not empty and column G is empty, the message represents the header of a frame message, at this time, the cell values of column C, column A and column F and the message sending node information in the second target row from row 2 can be read, the corresponding content display area can be written according to the format of BO _ area, the cell values of column C and column y of the second target row from row 2 can be read, the column y can be specifically one of column E, column AA, column AB, column AC and column D of the second target row, the corresponding content display area can be written according to the format of BA _ … … BO _ area, the content in the communication matrix can be automatically filled into the text file, to facilitate automatic generation of database files.
In the automatic filling and data writing process, when detecting that f rows are empty in succession in the cell values of the a-th column and the G-th column, the operation process is considered to reach the bottom of the table, and at this time, the operation process is stopped, wherein f is between 2 and 7, and preferably 5.
Furthermore, after the step of detecting the cell values of the a-th column and the G-th column in the same row from the 2 nd column, respectively, the method further includes:
determining a row in which the cell value of the A-th column is null and the cell value of the G-th column is not null as a third target row;
sequentially detecting target cells with cell values of R in subsequent columns from the AD column in the third target row, and determining node information recorded by a table head of the column where the target cells are in the subsequent columns as message receiving node information;
in the template text file, respectively receiving the information of the G column, the M column, the L column, the P column, the Q column, the R column, the S column, the Y column and the message receiving node of the third target row, writing a fourth content display area corresponding to a defined fourth variable according to a preset format, writing a C column, a G column and an H column of the third target row into a fifth content display area corresponding to a defined fifth variable, writing a C column, a G column and a Z column or a W column of the third target row, writing a sixth content display area corresponding to a defined sixth variable according to a preset format, and writing the C column, the G column and the x column of the third target row, writing a seventh content display area corresponding to a defined seventh variable according to a preset format until detecting that the continuous f rows of the cell values of the A column and the G column are all empty;
wherein the x-th column includes: an Nth column, a Vth column, or an Xth column of the third target row;
the content recorded in the H column is signal description, the content recorded in the L column is signal length, the content recorded in the M column is stop bit, the content recorded in the N column is signal transmission type, the content recorded in the P column is precision, the content recorded in the Q column is offset, the content recorded in the R column is physical minimum value, the content recorded in the S column is physical maximum value, the content recorded in the V column is initial value, the content recorded in the W column is invalid value, the content recorded in the X column is non-enabling value, the content recorded in the Y column is unit, and the content recorded in the Z column is signal value description.
Preferably, the contents recorded in the G-th column to the AC column in the node communication matrix in the embodiment of the present invention are sequentially: the content recorded in the G column is a signal name, the content recorded in the H column is a signal description, the content recorded in the I column is an arrangement format, the content recorded in the J column is a start byte, the content recorded in the K column is a start bit, the content recorded in the L column is a signal length, the content recorded in the M column is a stop bit, the content recorded in the N column is a signal transmission type, the content recorded in the O column is a data type, the content recorded in the P column is a precision, the content recorded in the Q column is an offset, the content recorded in the R column is a physical minimum, the content recorded in the S column is a physical maximum, the content recorded in the T column is a bus minimum, the content recorded in the U column is a bus maximum, the content recorded in the V column is an initial value, the content recorded in the W column is an invalid value, the content recorded in the X column is an invalid value, and the content recorded in the Y column is a unit, the content recorded in the Z-th column is signal value description, the content recorded in the AA-th column is a message quick sending period, the content recorded in the AB-th column is the message quick sending times, and the content recorded in the AC-th column is message delay time.
In the process, the columns from G to AC are numbered according to the sequence of English letters, and the columns from G to Z and from AA to AC are included.
When the A column is empty and the G column is not empty, representing the signal content of a frame of message, reading the information of the G column, the M column, the L column, the P column, the Q column, the R column, the S column, the Y column and the message receiving node in a third target row from the 2 nd row, and writing the information into a corresponding content display area according to the format of an SG _ area; cell values of a C column, a G column and an H column in a third target row from the 2 nd row can be read, and the corresponding content display area is written in according to the format of a CM _ SG _ area; cell values of a C column, a G column and a Z column or a C column, a G column and a W column in a third target row from the 2 nd row can be read, and corresponding content display areas are written in a format of a VAL _ area; the cell values of the C-th column, the G-th column and the X-th column in the third target row from the 2 nd row may also be read, where the X-th column may be specifically one of the N-th column, the V-th column or the X-th column of the third target row, and the X-th column is written in the corresponding content display area according to the format of the BA _ … … SG _ area, so as to implement automatic filling of the content in the communication matrix into the text file, so as to facilitate automatic generation of the database file.
In the automatic filling and data writing process, when detecting that f rows are empty in succession in the cell values of the a-th column and the G-th column, the operation process is considered to reach the bottom of the table, and at this time, the operation process is stopped, wherein f is between 2 and 7, and preferably 5.
Step 104: and renaming the suffix of the template text file into the suffix of the database file to obtain the target database file.
The method specifically includes the steps that the generated TXT file suffix is renamed to DBC, a database file corresponding to the data content of the node communication matrix is obtained, automatic and efficient generation of the database file of the automobile communication protocol is achieved, complicated and repeated manual input labor is reduced, workload is reduced, and error rate is reduced.
The embodiment of the invention also discloses a system for generating the database file of the automobile communication protocol, which is shown in the figure 2 and comprises the following steps: an extraction module 301, a new creation module 302, a generation module 303 and a renaming module 304.
The extracting module 301 is configured to extract a node communication matrix related to a target communication node from the vehicle signal communication matrix.
The new creating module 302 is configured to create a template text file, where a variable type that is required to be defined by a database file is written in the template text file.
A generating module 303, configured to read the node communication matrix, generate, according to the variable type, signal description content corresponding to a signal in the node communication matrix, and write the signal description content into the template text file.
And the renaming module 304 is configured to rename the suffix of the template text file to the suffix of the database file to obtain the target database file.
Wherein the extracting module 301 is specifically configured to:
the duplication submodule is used for duplicating the header row in the finished automobile signal communication matrix to a node communication matrix form;
sequentially detecting cell values listed by the AD in a header row of the whole vehicle signal communication matrix;
when detecting that the cell value of one cell listed from the AD column in the header row is the target communication node, determining that the cell is listed as the a column;
respectively starting from the 2 nd row, detecting whether the cell values of the a-th column and the G-th column are simultaneously null;
if the cell values are not null at the same time, detecting the cell value of the a-th column;
determining the row where the cell with the cell value of the a-th column equal to S or R is positioned as a first target row;
copying the data of the first target row to the node communication matrix form to obtain a node communication matrix of the target communication node;
the AD column records the names of all communication nodes on a network segment where the finished automobile signal communication is located in the header row of the finished automobile signal communication matrix; the content recorded in the G-th column is a signal name, the cell value S indicates that the communication node corresponding to the node name of the column in which the cell is located is a sending node, and the cell value R indicates that the communication node corresponding to the node name of the column in which the cell is located is a receiving node.
Wherein the generating module 303 comprises:
the first detection submodule is used for sequentially detecting cell values from the AD column in the 1 st row of the node communication matrix;
the storage submodule is used for storing the cell values listed from the AD in the 1 st row into an array until detecting that one cell value listed from the AD in the 1 st row is empty; the first writing submodule is used for writing the values in the array into a first content display area corresponding to a defined first variable in the template text file;
in the row 1 of the node communication matrix, the AD column records names of nodes on a network segment involved in communication through the target communication node.
Wherein, this system still includes:
the second detection submodule is used for respectively detecting the cell values of the A-th column and the G-th column in the same row from the 2 nd row;
a first determining submodule, configured to determine, as a second target row, a row in which the cell value of the a-th column is not null and the cell value of the G-th column is null;
a second determining submodule, configured to sequentially detect a target cell in a subsequent column from the AD column in the second target row, where the cell value is S, and determine that node information recorded in a header of the column in which the target cell is located in the subsequent column is packet sending node information;
a second writing sub-module, configured to write cell values in a C-th column, an a-th column, and an F-th column of the second target row and the message sending node information into a second content display area corresponding to a defined second variable according to a preset format, and write cell values in a C-th column and a y-th column of the second target row into a third content display area corresponding to a defined third variable according to the preset format, in the template text file, until it is detected that the F-th row where the cell values in the a-th column and the G-th column are consecutive is empty;
wherein the y-th column includes: the E column, the AA column, the AB column, the AC column and the D column of the second target row;
the content recorded in the A-th column is a message name, the content recorded in the C-th column is a message identifier, the content recorded in the D-th column is a message sending type, the content recorded in the E-th column is message cycle time, the content recorded in the F-th column is message length, the content recorded in the G-th column is a signal name, the content recorded in the AA-th column is a message fast sending cycle, the content recorded in the AB-th column is message fast sending times, and the content recorded in the AC-th column is message delay time.
Wherein, this system still includes:
a third determining submodule, configured to determine, as a third target row, a row in which the cell value of the a-th column is null and the cell value of the G-th column is not null;
a fourth determining submodule, configured to sequentially detect a target cell in a subsequent column from the AD column in the third target row, where the cell value is R, and determine that node information recorded in a header of the column in which the target cell is located in the subsequent column is packet receiving node information;
a third write-in sub-module, configured to respectively write information of a G-th column, an M-th column, an L-th column, a P-th column, a Q-th column, an R-th column, an S-th column, a Y-th column, and the message receiving node in the third target row in the template text file, writing a fourth content display area corresponding to a defined fourth variable according to a preset format, writing a C column, a G column and an H column of the third target row into a fifth content display area corresponding to a defined fifth variable, writing a C column, a G column and a Z column or a W column of the third target row, writing a sixth content display area corresponding to a defined sixth variable according to a preset format, and writing the C column, the G column and the x column of the third target row, writing a seventh content display area corresponding to a defined seventh variable according to a preset format until detecting that the continuous f rows of the cell values of the A column and the G column are all empty;
wherein the x-th column includes: an Nth column, a Vth column, or an Xth column of the third target row;
the content recorded in the H column is signal description, the content recorded in the L column is signal length, the content recorded in the M column is stop bit, the content recorded in the N column is signal transmission type, the content recorded in the P column is precision, the content recorded in the Q column is offset, the content recorded in the R column is physical minimum value, the content recorded in the S column is physical maximum value, the content recorded in the V column is initial value, the content recorded in the W column is invalid value, the content recorded in the X column is non-enabling value, the content recorded in the Y column is unit, and the content recorded in the Z column is signal value description.
The system extracts a node communication matrix related to a target communication node from a finished automobile signal communication matrix, generates signal description contents corresponding to signals in the node communication matrix based on the node communication matrix and a template text file, and finally obtains a database file corresponding to the data contents of the node communication matrix, so that the database file of the automobile communication protocol is automatically and efficiently generated, complicated and repeated manual input labor is reduced, the workload is reduced, and the error rate is reduced.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal (such as a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.
While the present invention has been described with reference to the embodiments shown in the drawings, the present invention is not limited to the embodiments, which are illustrative and not restrictive, and it will be apparent to those skilled in the art that various changes and modifications can be made therein without departing from the spirit and scope of the invention as defined in the appended claims.
While the preferred embodiments of the present invention have been described, it will be understood by those skilled in the art that various changes and modifications may be made without departing from the spirit and scope of the invention as defined in the following claims.
Claims (8)
1. A method for generating a database file of an automobile communication protocol is characterized by comprising the following steps:
extracting a node communication matrix related to a target communication node from a finished automobile signal communication matrix, wherein the matrix related to the target communication node is a matrix containing communication contents of a transceiving relation of the target communication node;
newly building a template text file, wherein variable types required to be defined by a database file are written in the template text file;
reading the node communication matrix, generating signal description contents corresponding to signals in the node communication matrix according to the variable types, and writing the signal description contents into the template text file;
renaming the suffix of the template text file into a suffix of the database file to obtain a target database file;
the step of extracting the node communication matrix related to the target communication node from the signal communication matrix of the whole vehicle comprises the following steps:
copying a header row in the whole vehicle signal communication matrix to a node communication matrix form;
sequentially detecting cell values listed by the AD in a header row of the whole vehicle signal communication matrix;
when detecting that the cell value of one cell listed from the AD column in the header row is the target communication node, determining that the cell is listed as the a column;
respectively starting from the 2 nd row, detecting whether the cell values of the a-th column and the G-th column are simultaneously null;
if the cell values are not null at the same time, detecting the cell value of the a-th column;
determining the row where the cell with the cell value of the a-th column equal to S or R is positioned as a first target row;
copying the data of the first target row to the node communication matrix form to obtain a node communication matrix of the target communication node;
the AD column records the names of all communication nodes on a network segment where the finished automobile signal communication is located in the header row of the finished automobile signal communication matrix; the content recorded in the G-th column is a signal name, the cell value S indicates that the communication node corresponding to the node name of the column in which the cell is located is a sending node, and the cell value R indicates that the communication node corresponding to the node name of the column in which the cell is located is a receiving node.
2. The method for generating a database file according to claim 1, wherein the step of reading the node communication matrix, generating signal description contents corresponding to signals in the node communication matrix according to the variable types, and writing the signal description contents into the template text file comprises:
sequentially detecting cell values listed by an AD (analog-to-digital) in a 1 st row of the node communication matrix;
storing the cell values listed from the AD in the 1 st row into an array until detecting that one cell value listed from the AD in the 1 st row is empty; writing the values in the array into a first content display area corresponding to a defined first variable in the template text file;
in the row 1 of the node communication matrix, the AD column records names of nodes on a network segment involved in communication through the target communication node.
3. The method for generating a database file according to claim 2, wherein after the step of writing the values in the array into the first content display area corresponding to the defined first variable in the template text file, the method further comprises:
respectively detecting cell values of an A-th column and a G-th column in the same row from the 2 nd row;
determining a row in which the cell value of the A-th column is not null and the cell value of the G-th column is null as a second target row;
sequentially detecting target cells with cell values S in subsequent columns from the AD column in the second target row, and determining node information recorded by a table head of the column where the target cells are located in the subsequent columns as message sending node information;
writing the cell values of the C column, the A column and the F column of the second target row and the message sending node information into a second content display area corresponding to a defined second variable according to a preset format, and writing the cell values of the C column and the y column of the second target row into a third content display area corresponding to a defined third variable according to the preset format until detecting that the F rows are empty when the cell values of the A column and the G column are continuous;
wherein the y-th column includes: the E column, the AA column, the AB column, the AC column and the D column of the second target row;
the content recorded in the A-th column is a message name, the content recorded in the C-th column is a message identifier, the content recorded in the D-th column is a message sending type, the content recorded in the E-th column is message cycle time, the content recorded in the F-th column is message length, the content recorded in the G-th column is a signal name, the content recorded in the AA-th column is a message fast sending cycle, the content recorded in the AB-th column is message fast sending times, and the content recorded in the AC-th column is message delay time.
4. The method of claim 3, wherein after the step of detecting cell values of the A-th column and the G-th column in the same row from the 2 nd row, respectively, the method further comprises:
determining a row in which the cell value of the A-th column is null and the cell value of the G-th column is not null as a third target row;
sequentially detecting target cells with cell values of R in subsequent columns from the AD column in the third target row, and determining node information recorded by a table head of the column where the target cells are in the subsequent columns as message receiving node information;
in the template text file, respectively receiving the information of the G column, the M column, the L column, the P column, the Q column, the R column, the S column, the Y column and the message receiving node of the third target row, writing a fourth content display area corresponding to a defined fourth variable according to a preset format, writing a C column, a G column and an H column of the third target row into a fifth content display area corresponding to a defined fifth variable, writing a C column, a G column and a Z column or a W column of the third target row, writing a sixth content display area corresponding to a defined sixth variable according to a preset format, and writing the C column, the G column and the x column of the third target row, writing a seventh content display area corresponding to a defined seventh variable according to a preset format until detecting that the continuous f rows of the cell values of the A column and the G column are all empty;
wherein the x-th column includes: an Nth column, a Vth column, or an Xth column of the third target row;
the content recorded in the H column is signal description, the content recorded in the L column is signal length, the content recorded in the M column is stop bit, the content recorded in the N column is signal transmission type, the content recorded in the P column is precision, the content recorded in the Q column is offset, the content recorded in the R column is physical minimum value, the content recorded in the S column is physical maximum value, the content recorded in the V column is initial value, the content recorded in the W column is invalid value, the content recorded in the X column is non-enabling value, the content recorded in the Y column is unit, and the content recorded in the Z column is signal value description.
5. A system for generating a database file of an automobile communication protocol is characterized by comprising:
the extraction module is used for extracting a node communication matrix related to a target communication node from the vehicle signal communication matrix, wherein the matrix related to the target communication node is a matrix containing communication contents of the transceiving relation of the target communication node;
the system comprises a new building module, a database module and a creating module, wherein the new building module is used for building a template text file, and the template text file is written with a variable type required to be defined by the database file;
the generating module is used for reading the node communication matrix, generating signal description contents corresponding to signals in the node communication matrix according to the variable types, and writing the signal description contents into the template text file;
the renaming module is used for renaming the suffix of the template text file into the suffix of the database file to obtain a target database file;
wherein the extraction module is specifically configured to:
the duplication submodule is used for duplicating the header row in the finished automobile signal communication matrix to a node communication matrix form;
sequentially detecting cell values listed by the AD in a header row of the whole vehicle signal communication matrix;
when detecting that the cell value of one cell listed from the AD column in the header row is the target communication node, determining that the cell is listed as the a column;
respectively starting from the 2 nd row, detecting whether the cell values of the a-th column and the G-th column are simultaneously null;
if the cell values are not null at the same time, detecting the cell value of the a-th column;
determining the row where the cell with the cell value of the a-th column equal to S or R is positioned as a first target row;
copying the data of the first target row to the node communication matrix form to obtain a node communication matrix of the target communication node;
the AD column records the names of all communication nodes on a network segment where the finished automobile signal communication is located in the header row of the finished automobile signal communication matrix; the content recorded in the G-th column is a signal name, the cell value S indicates that the communication node corresponding to the node name of the column in which the cell is located is a sending node, and the cell value R indicates that the communication node corresponding to the node name of the column in which the cell is located is a receiving node.
6. The system for generating a database file according to claim 5, wherein the generating module comprises:
the first detection submodule is used for sequentially detecting cell values from the AD column in the 1 st row of the node communication matrix;
the storage submodule is used for storing the cell values listed from the AD in the 1 st row into an array until detecting that one cell value listed from the AD in the 1 st row is empty; the first writing submodule is used for writing the values in the array into a first content display area corresponding to a defined first variable in the template text file;
in the row 1 of the node communication matrix, the AD column records names of nodes on a network segment involved in communication through the target communication node.
7. The database file generation system according to claim 6, further comprising:
the second detection submodule is used for respectively detecting the cell values of the A-th column and the G-th column in the same row from the 2 nd row;
a first determining submodule, configured to determine, as a second target row, a row in which the cell value of the a-th column is not null and the cell value of the G-th column is null;
a second determining submodule, configured to sequentially detect a target cell in a subsequent column from the AD column in the second target row, where the cell value is S, and determine that node information recorded in a header of the column in which the target cell is located in the subsequent column is packet sending node information;
a second writing sub-module, configured to write cell values in a C-th column, an a-th column, and an F-th column of the second target row and the message sending node information into a second content display area corresponding to a defined second variable according to a preset format, and write cell values in a C-th column and a y-th column of the second target row into a third content display area corresponding to a defined third variable according to the preset format, in the template text file, until it is detected that the F-th row where the cell values in the a-th column and the G-th column are consecutive is empty;
wherein the y-th column includes: the E column, the AA column, the AB column, the AC column and the D column of the second target row;
the content recorded in the A-th column is a message name, the content recorded in the C-th column is a message identifier, the content recorded in the D-th column is a message sending type, the content recorded in the E-th column is message cycle time, the content recorded in the F-th column is message length, the content recorded in the G-th column is a signal name, the content recorded in the AA-th column is a message fast sending cycle, the content recorded in the AB-th column is message fast sending times, and the content recorded in the AC-th column is message delay time.
8. The database file generation system according to claim 7, further comprising:
a third determining submodule, configured to determine, as a third target row, a row in which the cell value of the a-th column is null and the cell value of the G-th column is not null;
a fourth determining submodule, configured to sequentially detect a target cell in a subsequent column from the AD column in the third target row, where the cell value is R, and determine that node information recorded in a header of the column in which the target cell is located in the subsequent column is packet receiving node information;
a third write-in sub-module, configured to respectively write information of a G-th column, an M-th column, an L-th column, a P-th column, a Q-th column, an R-th column, an S-th column, a Y-th column, and the message receiving node in the third target row in the template text file, writing a fourth content display area corresponding to a defined fourth variable according to a preset format, writing a C column, a G column and an H column of the third target row into a fifth content display area corresponding to a defined fifth variable, writing a C column, a G column and a Z column or a W column of the third target row, writing a sixth content display area corresponding to a defined sixth variable according to a preset format, and writing the C column, the G column and the x column of the third target row, writing a seventh content display area corresponding to a defined seventh variable according to a preset format until detecting that the continuous f rows of the cell values of the A column and the G column are all empty;
wherein the x-th column includes: an Nth column, a Vth column, or an Xth column of the third target row;
the content recorded in the H column is signal description, the content recorded in the L column is signal length, the content recorded in the M column is stop bit, the content recorded in the N column is signal transmission type, the content recorded in the P column is precision, the content recorded in the Q column is offset, the content recorded in the R column is physical minimum value, the content recorded in the S column is physical maximum value, the content recorded in the V column is initial value, the content recorded in the W column is invalid value, the content recorded in the X column is non-enabling value, the content recorded in the Y column is unit, and the content recorded in the Z column is signal value description.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810811025.8A CN109033338B (en) | 2018-07-23 | 2018-07-23 | Method and system for generating database file of automobile communication protocol |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810811025.8A CN109033338B (en) | 2018-07-23 | 2018-07-23 | Method and system for generating database file of automobile communication protocol |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109033338A CN109033338A (en) | 2018-12-18 |
| CN109033338B true CN109033338B (en) | 2022-02-01 |
Family
ID=64645007
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810811025.8A Active CN109033338B (en) | 2018-07-23 | 2018-07-23 | Method and system for generating database file of automobile communication protocol |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109033338B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113364601B (en) * | 2020-03-02 | 2022-06-10 | 北京新能源汽车股份有限公司 | Signal change method and device for communication matrix platform library |
| CN111427940B (en) * | 2020-03-26 | 2023-09-05 | 陶朝林 | Self-adaptive database conversion method and device |
| CN111817938B (en) * | 2020-07-15 | 2022-04-01 | 上汽通用五菱汽车股份有限公司 | Method, system and storage medium for compiling automobile CAN communication matrix |
| CN114035539B (en) * | 2021-10-25 | 2023-12-05 | 东风商用车有限公司 | Method, device, equipment and storage medium for generating communication matrix of instantiated vehicle type |
| CN115314155B (en) * | 2022-07-14 | 2024-01-09 | 东风电驱动系统有限公司 | Communication method, device, equipment and readable storage medium |
| CN115730395B (en) * | 2022-11-30 | 2023-11-21 | 成都赛力斯科技有限公司 | Automobile interface model generation method, device, computer equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103455023A (en) * | 2012-06-01 | 2013-12-18 | 北汽福田汽车股份有限公司 | Testing device and method used for power system of new energy automobile |
| CN104331292A (en) * | 2014-11-03 | 2015-02-04 | 重庆邮电大学 | Method for generating configuration for middleware protocol conversion of Internet of vehicles |
| CN106850372A (en) * | 2017-02-22 | 2017-06-13 | 重庆长安汽车股份有限公司 | A kind of method of testing and system of controller CAN signal |
| CN107247697A (en) * | 2017-07-05 | 2017-10-13 | 上海蔚赫信息科技有限公司 | A kind of method that Excel file is converted to automotive networking DBC files |
| CN107291674A (en) * | 2017-06-12 | 2017-10-24 | 广东川田卫生用品有限公司 | A kind of method that Excel list datas are converted to database format |
| KR101797005B1 (en) * | 2017-03-09 | 2017-12-13 | 슈어소프트테크주식회사 | Method for producing test case by vehicle type |
-
2018
- 2018-07-23 CN CN201810811025.8A patent/CN109033338B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103455023A (en) * | 2012-06-01 | 2013-12-18 | 北汽福田汽车股份有限公司 | Testing device and method used for power system of new energy automobile |
| CN104331292A (en) * | 2014-11-03 | 2015-02-04 | 重庆邮电大学 | Method for generating configuration for middleware protocol conversion of Internet of vehicles |
| CN106850372A (en) * | 2017-02-22 | 2017-06-13 | 重庆长安汽车股份有限公司 | A kind of method of testing and system of controller CAN signal |
| KR101797005B1 (en) * | 2017-03-09 | 2017-12-13 | 슈어소프트테크주식회사 | Method for producing test case by vehicle type |
| CN107291674A (en) * | 2017-06-12 | 2017-10-24 | 广东川田卫生用品有限公司 | A kind of method that Excel list datas are converted to database format |
| CN107247697A (en) * | 2017-07-05 | 2017-10-13 | 上海蔚赫信息科技有限公司 | A kind of method that Excel file is converted to automotive networking DBC files |
Non-Patent Citations (1)
| Title |
|---|
| 基于USB-CAN适配器ECU测试系统的设计;涂小芳;《中国优秀硕士学位论文全文数据库_工程科技Ⅱ辑》;20170315;C035-249 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109033338A (en) | 2018-12-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109033338B (en) | Method and system for generating database file of automobile communication protocol | |
| CN109977366B (en) | Catalog generation method and device | |
| DE602004025515D1 (en) | METHOD AND DEVICE FOR SEARCHING BACKUP DATA BASED ON CONTENTS AND ATTRIBUTES | |
| CN109241003B (en) | File management method and device | |
| CN109522405A (en) | File information processing method, electronic equipment and computer-readable deposit medium | |
| CN109284492B (en) | Method and device for generating notification document | |
| CN114359533B (en) | Page number identification method based on page text and computer equipment | |
| CN105260266B (en) | A kind of snapped volume write method and dependent snapshot system | |
| JP2003131931A (en) | Method and device for scheduling, generating and processing document comprising blocks of information | |
| CN109800539B (en) | Simulation test method and system | |
| CN113688150B (en) | Keyword searching method and device, electronic equipment and storage medium | |
| CN108062333B (en) | Method and device for processing inferior question data | |
| CN103886028A (en) | Method and apparatus for copying files from storage device to advertisement machine | |
| CN113435217A (en) | Language test processing method and device and electronic equipment | |
| CN110309501B (en) | Cross reference method and device | |
| CN108345427B (en) | Hard disk data storage method and device | |
| CN111400262A (en) | File storage space intelligent distribution method based on big data | |
| CN108304401A (en) | E-book searching method and system | |
| CN113591231B (en) | Method and device for simulating driving | |
| CN112379891B (en) | Data processing method and device | |
| CN114528516B (en) | Intelligent informatization project management method and device | |
| CN112615869B (en) | Audio data processing method, device, equipment and storage medium | |
| CN111259621B (en) | Cloud font display method and device | |
| CN110532531B (en) | Method and device for replacing content in document | |
| CN105867885A (en) | Method and device for storing slide file |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |