CN112347047A - Vehicle data file generation method and device - Google Patents
Vehicle data file generation method and device Download PDFInfo
- Publication number
- CN112347047A CN112347047A CN201910733856.2A CN201910733856A CN112347047A CN 112347047 A CN112347047 A CN 112347047A CN 201910733856 A CN201910733856 A CN 201910733856A CN 112347047 A CN112347047 A CN 112347047A
- Authority
- CN
- China
- Prior art keywords
- signal
- field
- data
- matrix
- line
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 26
- 239000011159 matrix material Substances 0.000 claims abstract description 81
- 238000004891 communication Methods 0.000 claims abstract description 37
- 238000012163 sequencing technique Methods 0.000 claims abstract description 9
- 238000012545 processing Methods 0.000 claims description 6
- 238000006243 chemical reaction Methods 0.000 claims description 3
- 238000004519 manufacturing process Methods 0.000 abstract description 8
- 238000007405 data analysis Methods 0.000 abstract description 5
- 238000004458 analytical method Methods 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 125000004122 cyclic group Chemical group 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L12/00—Data switching networks
- H04L12/28—Data switching networks characterised by path configuration, e.g. LAN [Local Area Networks] or WAN [Wide Area Networks]
- H04L12/40—Bus networks
- H04L12/40006—Architecture of a communication node
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L12/00—Data switching networks
- H04L12/28—Data switching networks characterised by path configuration, e.g. LAN [Local Area Networks] or WAN [Wide Area Networks]
- H04L12/40—Bus networks
- H04L2012/40208—Bus networks characterized by the use of a particular bus standard
- H04L2012/40215—Controller Area Network CAN
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L12/00—Data switching networks
- H04L12/28—Data switching networks characterised by path configuration, e.g. LAN [Local Area Networks] or WAN [Wide Area Networks]
- H04L12/40—Bus networks
- H04L2012/40267—Bus for use in transportation systems
- H04L2012/40273—Bus for use in transportation systems the transportation system being a vehicle
Abstract
The invention discloses a vehicle data file generation method and a vehicle data file generation device, wherein the vehicle data file generation method comprises the following steps: acquiring a bus matrix and a signal demand table under a set path; reading and analyzing the data cells in the bus matrix and the signal demand table one by one to generate an RX table; sequencing the RX table line by line, arranging signal names under the same message name together, grouping according to a Motorola forward LSB matrix format and an acquisition frequency, and polling and filling each signal into a 64-bit data frame by adopting a greedy algorithm to generate a TX table; setting mode schema information of a type judgment rule addition signal according to the signal value description attribute of the TX table, and generating a communication matrix by combining the RX table, the TX table and the schema information; and reading the communication matrix line by line through a DBC conversion program to generate a DBC file. The invention reduces the labor and time cost for engineers to manufacture communication matrix and DBC, and provides great convenience for signal acquisition of automobile big data and subsequent data analysis and analysis.
Description
Technical Field
The invention relates to the technical field of vehicle networking, in particular to a vehicle data file generation method and device.
Background
With the development of the internet of vehicles and the increasingly mature application of big data technology, big data is more and more valued by various vehicle enterprises as strategic assets. The automobile mainly carries out big data acquisition by configuring a T-BOX (telematics BOX). The acquisition work needs to manufacture a big data communication matrix according to a specific protocol and define the format of ECU signal big data acquisition of each vehicle type. The communication matrix of each model is different, if the communication matrix and the DBC file (the DBC file is a file describing data communication between nodes of the CAN network; the DBC file is a file in ASCII format, and the DBC extension CAN be used for defining the CAN network) are manually made for each model, the making time is long, the alternation cost is high, and the maintainability is weak.
Disclosure of Invention
The technical problem to be solved by the present invention is to provide a method and an apparatus for generating a vehicle data file, so as to effectively improve the efficiency of making the vehicle data file and save labor and time costs.
In order to solve the above technical problem, the present invention provides a vehicle data file generating method, including:
step S1, acquiring a bus matrix and a signal demand table under a set path;
step S2, reading and analyzing the data cells in the bus matrix and the signal demand table one by using JAVAPOI, and generating an RX table containing the collected signal information transmitted by the CAN bus;
step S3, sequencing the RX table line by line, arranging signal names under the same message name together, grouping according to a Motorola forward LSB matrix format and acquisition frequency, adopting a greedy algorithm to poll and fill each signal into a 64-bit data frame, and generating a TX table;
step S4, according to the signal value description attribute of the TX table, setting mode schema information of a type judgment rule addition signal, and generating a communication matrix by combining the RX table, the TX table and the schema information;
and step S5, reading the communication matrix line by line through the DBC conversion program, and generating a DBC file.
In step S2, analyzing the data cells in the bus matrix and the signal requirement table by using JAVAPOI, specifically including:
reading two columns of data of a message 16-system ID and a signal name of a signal demand table to form a key value pair linked list;
and scanning each row of the bus matrix line by line to match key value pairs in the linked list, copying the row to an RX table if matching is met, and setting the attributes of format, font, line height and column width by a JAVAPOI program in the copying process.
In step S2, when analyzing the data cell, the signal is also de-duplicated according to the uniqueness principle, and the signal name is matched according to the data cross-correlation characteristic.
Wherein, the step S3 specifically includes:
operating a TXFirstingput code module, converting the RX table to obtain a TXFirstingput table, wherein the TXFirstingput table comprises three columns of data of a time period MsgCycleTime, a signal name SignalName and a signal length SigLength of a data message;
running a TXSeContinut code module, reading the TXSeContinut table, acquiring three rows of data of a time period MsgCycleTime, a signal name SignalName and a signal length of a data message, grouping each signal according to a Motorola forward LSB matrix format and acquisition frequency by adopting a greedy algorithm, polling and filling 64-bit data frames with each signal until the data frames are filled or no signal meeting the requirement exists, and outputting signal.txt;
and setting two rows of values of a signal start bit and a signal length in the signal.
Wherein the mode schema information types comprise int, float and double types,
the int type needs to satisfy one of the following conditions: the signal value description attribute does not contain a linear field; the signal value description attribute contains a linear field but no ' > field and no '% ' field; the signal value description attribute includes a linear field and includes a ' · ' field and the ' · ' field is spaced apart from the ' field by a position greater than 5;
the float type needs to satisfy one of the following conditions: the signal value description attribute contains a linear field and contains a ' ″ field but not a '% ' field; the signal value description attribute includes a linear field and includes a ' · ' field and the ' · ' field is spaced from the ' field by no more than 5; the signal value description attribute includes a linear field and includes a '·' field with the '·' field spaced from the 'pre' field by no more than 15;
the double type needs to satisfy: the signal value description attribute includes a linear field and includes a '·' field and the '·' field is spaced from the 'pre' field by a position greater than 15.
After the DBC file is generated in step S5, the log information is used to determine whether the DBC file meets the functional requirement, if the log only contains warning information, it indicates that the DBC conversion is successful, and if there is an error information feedback, it is necessary to check the content of the communication matrix and the format specification, and then convert the DBC file again until there is no error information feedback.
The present invention also provides a vehicle data file generating apparatus, including:
the device comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a bus matrix and a signal demand table under a set path;
the first generation unit is used for reading and analyzing the data cells in the bus matrix and the signal demand table one by using JAVAPOI and generating an RX table containing the collected signal information transmitted by the CAN bus;
the second generating unit is used for sequencing the RX table line by line, arranging signal names under the same message name together, grouping according to a Motorola forward LSB matrix format and acquisition frequency, and polling and filling each signal with 64-bit data frames by adopting a greedy algorithm to generate a TX table;
a third generating unit, configured to set a mode schema information of a type determination rule addition signal according to the signal value description attribute of the TX table, and generate a communication matrix by combining the RX table, the TX table, and the schema information;
and the fourth generation unit is used for reading the communication matrix line by line through the DBC conversion program and generating a DBC file.
The analyzing, by the first generating unit, the data cells in the bus matrix and the signal requirement table by using JAVAPOI specifically includes:
reading two columns of data of a message 16-system ID and a signal name of a signal demand table to form a key value pair linked list;
and scanning each row of the bus matrix line by line to match key value pairs in the linked list, copying the row to an RX table if matching is met, and setting the attributes of format, font, line height and column width by a JAVAPOI program in the copying process.
When the first generation unit analyzes the data cell, the first generation unit further performs signal duplicate removal according to a uniqueness principle, and performs signal name matching according to data cross-correlation characteristics.
Wherein the second generating unit is specifically configured to:
operating a TXFirstingput code module, converting the RX table to obtain a TXFirstingput table, wherein the TXFirstingput table comprises three columns of data of a time period MsgCycleTime, a signal name SignalName and a signal length SigLength of a data message;
running a TXSeContinut code module, reading the TXSeContinut table, acquiring three rows of data of a time period MsgCycleTime, a signal name SignalName and a signal length of a data message, grouping each signal according to a Motorola forward LSB matrix format and acquisition frequency by adopting a greedy algorithm, polling and filling 64-bit data frames with each signal until the data frames are filled or no signal meeting the requirement exists, and outputting signal.txt;
and setting two rows of values of a signal start bit and a signal length in the signal.
Wherein the mode schema information types comprise int, float and double types,
the int type needs to satisfy one of the following conditions: the signal value description attribute does not contain a linear field; the signal value description attribute contains a linear field but no ' > field and no '% ' field; the signal value description attribute includes a linear field and includes a ' · ' field and the ' · ' field is spaced apart from the ' field by a position greater than 5;
the float type needs to satisfy one of the following conditions: the signal value description attribute contains a linear field and contains a ' ″ field but not a '% ' field; the signal value description attribute includes a linear field and includes a ' · ' field and the ' · ' field is spaced from the ' field by no more than 5; the signal value description attribute includes a linear field and includes a '·' field with the '·' field spaced from the 'pre' field by no more than 15;
the double type needs to satisfy: the signal value description attribute includes a linear field and includes a '·' field and the '·' field is spaced from the 'pre' field by a position greater than 15.
Wherein the vehicle data file generating device further includes:
and the judging unit is used for judging whether the DBC file meets the functional requirements or not according to log information after the DBC file is generated, if the log only contains warning information, the DBC is successfully converted, and if error information feedback exists, the DBC file is converted again after the content and the format specification of a communication matrix need to be checked until no error information feedback exists.
The embodiment of the invention has the following beneficial effects: the communication matrix manufacturing process can be standardized, manpower and time cost for manufacturing the communication matrix and the DBC by engineers are reduced, probability of manual misoperation of the engineers is reduced, timeliness that data analysis is available is met, and great convenience is brought to signal acquisition of automobile big data and subsequent data analysis.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a schematic flow chart of a vehicle data file generation method according to an embodiment of the present invention.
Fig. 2 is a schematic specific flowchart of a vehicle data file generation method according to an embodiment of the present invention.
Fig. 3 is a schematic diagram of signal length splicing according to an embodiment of the present invention.
Fig. 4 is a schematic diagram of a schema making process in the first embodiment of the present invention.
Detailed Description
The following description of the embodiments refers to the accompanying drawings, which are included to illustrate specific embodiments in which the invention may be practiced.
Referring to fig. 1, a method for generating a vehicle data file according to an embodiment of the present invention includes:
step S1, acquiring a bus matrix and a signal demand table under a set path;
step S2, reading and analyzing the data cells in the bus matrix and the signal demand table one by using JAVAPOI, and generating an RX table containing the collected signal information transmitted by the CAN bus;
step S3, sequencing the RX table line by line, arranging signal names under the same message name together, grouping according to a Motorola forward LSB matrix format and acquisition frequency, adopting a greedy algorithm to poll and fill each signal into a 64-bit data frame, and generating a TX table;
step S4, according to the signal value description attribute of the TX table, setting mode schema information of a type judgment rule addition signal, and generating a communication matrix by combining the RX table, the TX table and the schema information;
and step S5, reading the communication matrix line by line through the DBC conversion program, and generating a DBC file.
Specifically, referring to fig. 2, step S1 of the present embodiment further includes performing format error recognition on the bus matrix and the signal requirement table, where the format error recognition operation includes total row number matching, column number recognition, and column name matching, so as to correct error data and ensure normal subsequent operations. The total row number in the format error identification is matched, the column number identification is automatically calculated by JAVAPOI statistical logic, and a bus matrix comprises the following columns when the column names are matched: the method comprises the following steps of (1) electronic control unit type, message name, message 16-system ID, message byte number, message sending type, message cycle time, message fast cycle time, message invalid value, signal name, signal description, signal start bit, signal length, signal minimum value, signal maximum value, signal default value, signal invalid value, timeout time, precision, signal offset, signal unit, signal sending type, whether an event command signal is generated or not, and signal value description; the signal requirement table should contain the following: message 16 system ID, message cycle time, and signal name.
And then inputting the set paths of the bus matrix and the signal demand table, judging whether the bus matrix and the signal demand table exist in the set paths, and if so, acquiring the bus matrix and the signal demand table under the set paths. It should be noted that, the data file of the embodiment may be an Excel file, preferably, the format is an xls format, and when the Excel format is an xlsx format, the data file needs to be converted.
Step S2 is to generate an RX table containing the collected signal information transmitted by the CAN bus. Firstly, operating a createRXTable code module (namely a code module for generating an RX table), reading the contents in a bus matrix and a signal requirement table one by one, analyzing a data cell by using JAVAPOI, and analyzing the data cell by using JAVAPOI, wherein the steps of: reading two columns of data of a message 16 system ID and a signal name of a signal demand table to form a key value pair linked list; scanning each row of the bus matrix line by line to match key value pairs in the linked list, copying the row to an RX table if matching is met, and setting attributes such as format, font, line height, column width and the like by a JAVAPOI program in the copying process; wherein the applied JAVA program includes: java, checkexcel, java, copyandcreaterxexcel, java, readexcel, java, searchexcel.
Further, in step S2, when analyzing the data cell, the signal is also de-duplicated according to the principle of uniqueness, and the signal name is matched according to the data cross-correlation characteristics. The signal deduplication is carried out according to the uniqueness principle, that is, each signal in the signal requirement table has only one occurrence; the signal name matching according to the data cross-correlation characteristic refers to positioning and matching each signal of the signal requirement table in a bus matrix.
Step S3 sorts the obtained RX table line by line, and a gray blank line is added to separate different message names in the sorting process. Further, after checking the content and the format of the RX table are correct, the TXFirstinput code module is operated, and the RX table is converted to obtain the TXFirstinput table, wherein the TXFirstinput table contains three columns of data, namely the time period MsgCycleTime of the data message, the name of the signal, and the length of the signal. Then, a TXSECondingput code module is operated, a TXSECUTP is read, three rows of data of a time period MsgCycleTime, a signal name SignalName and a signal length of a signal are obtained, each signal is polled and filled into a 64-bit data frame by adopting a greedy algorithm according to a Motorola forward LSB matrix format and an acquisition frequency grouping until the data frame is filled with or has no signal meeting the requirement, and signal.txt is output, so that the idle position is reduced, the requirement of a communication protocol of 64 bits in each frame is met, and the use efficiency of the flow is improved. In order to improve the readability of the data, cyclic period time sequencing is adopted, and frame number interpolation sequencing and other operations are needed to ensure that the byte length of the message name is fixed to 64 frames.
Txt is generated through a TxSecondinput code, and includes five rows of data, which are respectively a data packet Name Msg Name, a Time period Msg Cycle Time (ms) of the data packet, a Signal Name, a Signal Start Bit Start Position, and a Signal length, where the Start Position and the length of the Signal data in Signal txt can satisfy the communication protocol requirement of 64 bits per frame, as shown in fig. 3, two rows of values of the Signal Start Position and the Signal length are set, and a TX table is generated from the Signal txt.
It should be further noted that the vehicle body signal is sent to the background through the vehicle-mounted T-Box, the background runs an analysis program, and effective storage to the database is judged according to the signal effective bit after analysis. The statistical indexes of steps S2, S3 are all calculated based on the effective data.
The schema message types include int, float and double types, and the schema judgment logic is shown in fig. 4. The int type needs to satisfy one of the following conditions: the signal value description attribute does not contain a linear field; the signal value description attribute contains a linear field but no ' > field and no '% ' field; the signal value description attribute includes a linear field and includes a '·' field and the '·' field is spaced apart from the 'n:' field by a position greater than 5. The float type needs to satisfy one of the following conditions: the signal value description attribute contains a linear field and contains a ' ″ field but not a '% ' field; the signal value description attribute includes a linear field and includes a ' · ' field and the ' · ' field is spaced from the ' field by no more than 5; the signal value description attribute includes a linear field and includes a '·' field with the '·' field spaced from the 'pre' field by no more than 15. The double type needs to satisfy: the signal value description attribute includes a linear field and includes a '·' field and the '·' field is spaced from the 'pre' field by a position greater than 15. And each signal has corresponding schema information, so that the vehicle type communication matrix is generated by combining the RX table, the TX table and the schema information.
Step S5 reads the communication matrix line by line through the DBC conversion program to generate a DBC file, and determines whether the DBC meets the functional requirements or not from log information. The DBC conversion program needs to specify paths of the RX table and the TX table, the contents of the RX table and the TX table are automatically identified, and the DBC file generated after conversion is used for analyzing the later uploaded message.
And feeding back a log in the process of converting the communication matrix into the DBC file, wherein if the log only contains warning information, the DBC is successfully converted, and if error information is fed back, the DBC file is converted again after the content and the format specification of the communication matrix are checked until no error information is fed back.
Corresponding to the first embodiment of the present invention, a second embodiment of the present invention further provides a vehicle data file generating device, including:
the device comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a bus matrix and a signal demand table under a set path;
the first generation unit is used for reading and analyzing the data cells in the bus matrix and the signal demand table one by using JAVAPOI and generating an RX table containing the collected signal information transmitted by the CAN bus;
the second generating unit is used for sequencing the RX table line by line, arranging signal names under the same message name together, grouping according to a Motorola forward LSB matrix format and acquisition frequency, and polling and filling each signal with 64-bit data frames by adopting a greedy algorithm to generate a TX table;
a third generating unit, configured to set a mode schema information of a type determination rule addition signal according to the signal value description attribute of the TX table, and generate a communication matrix by combining the RX table, the TX table, and the schema information;
and the fourth generation unit is used for reading the communication matrix line by line through the DBC conversion program and generating a DBC file.
The analyzing, by the first generating unit, the data cells in the bus matrix and the signal requirement table by using JAVAPOI specifically includes:
reading two columns of data of a message 16-system ID and a signal name of a signal demand table to form a key value pair linked list;
and scanning each row of the bus matrix line by line to match key value pairs in the linked list, copying the row to an RX table if matching is met, and setting the attributes of format, font, line height and column width by a JAVAPOI program in the copying process.
When the first generation unit analyzes the data cell, the first generation unit further performs signal duplicate removal according to a uniqueness principle, and performs signal name matching according to data cross-correlation characteristics.
Wherein the second generating unit is specifically configured to:
operating a TXFirstingput code module, converting the RX table to obtain a TXFirstingput table, wherein the TXFirstingput table comprises three columns of data of a time period MsgCycleTime, a signal name SignalName and a signal length SigLength of a data message;
running a TXSeContinut code module, reading the TXSeContinut table, acquiring three rows of data of a time period MsgCycleTime, a signal name SignalName and a signal length of a data message, grouping each signal according to a Motorola forward LSB matrix format and acquisition frequency by adopting a greedy algorithm, polling and filling 64-bit data frames with each signal until the data frames are filled or no signal meeting the requirement exists, and outputting signal.txt;
and setting two rows of values of a signal start bit and a signal length in the signal.
Wherein the mode schema information types comprise int, float and double types,
the int type needs to satisfy one of the following conditions: the signal value description attribute does not contain a linear field; the signal value description attribute contains a linear field but no ' > field and no '% ' field; the signal value description attribute includes a linear field and includes a ' · ' field and the ' · ' field is spaced apart from the ' field by a position greater than 5;
the float type needs to satisfy one of the following conditions: the signal value description attribute contains a linear field and contains a ' ″ field but not a '% ' field; the signal value description attribute includes a linear field and includes a ' · ' field and the ' · ' field is spaced from the ' field by no more than 5; the signal value description attribute includes a linear field and includes a '·' field with the '·' field spaced from the 'pre' field by no more than 15;
the double type needs to satisfy: the signal value description attribute includes a linear field and includes a '·' field and the '·' field is spaced from the 'pre' field by a position greater than 15.
Wherein the vehicle data file generating device further includes:
and the judging unit is used for judging whether the DBC file meets the functional requirements or not according to log information after the DBC file is generated, if the log only contains warning information, the DBC is successfully converted, and if error information feedback exists, the DBC file is converted again after the content and the format specification of a communication matrix need to be checked until no error information feedback exists.
The embodiment of the invention has the advantages that the communication matrix manufacturing process can be standardized, the labor and time cost for engineers to manufacture the communication matrix and the DBC is reduced, the probability of manual misoperation of the engineers is reduced, the timeliness that data analysis is available is met, and great convenience is provided for signal acquisition of automobile big data and subsequent data analysis.
In addition, compared with the existing data file generation scheme which does not involve the manufacture of a big data communication matrix, the invention designs a core algorithm for the manufacture of the big data communication matrix: checking a bus matrix, a signal demand table and a big data matrix; the characteristics of 64-bit effective bits of a standard data frame are utilized to arrange signals required to be acquired, so that the signal positions are not overlapped, the data frame IDs are not repeated, and the maximum utilization rate of each frame of effective bits is ensured. The large data communication matrix is manufactured on the premise that the automobile can bus sends specific messages, and has important significance for data acquisition and analysis of the automobile sensor.
The above disclosure is only for the purpose of illustrating the preferred embodiments of the present invention, and it is therefore to be understood that the invention is not limited by the scope of the appended claims.
Claims (12)
1. A vehicle data file generation method, characterized by comprising:
step S1, acquiring a bus matrix and a signal demand table under a set path;
step S2, reading and analyzing the data cells in the bus matrix and the signal demand table one by using JAVAPOI, and generating an RX table containing the collected signal information transmitted by the CAN bus;
step S3, sequencing the RX table line by line, arranging signal names under the same message name together, grouping according to a Motorola forward LSB matrix format and acquisition frequency, adopting a greedy algorithm to poll and fill each signal into a 64-bit data frame, and generating a TX table;
step S4, according to the signal value description attribute of the TX table, setting mode schema information of a type judgment rule addition signal, and generating a communication matrix by combining the RX table, the TX table and the schema information;
and step S5, reading the communication matrix line by line through the DBC conversion program, and generating a DBC file.
2. The method for generating a vehicle data file according to claim 1, wherein in step S2, analyzing the data cells in the bus matrix and the signal requirement table by using JAVAPOI specifically comprises:
reading two columns of data of a message 16-system ID and a signal name of a signal demand table to form a key value pair linked list;
and scanning each row of the bus matrix line by line to match key value pairs in the linked list, copying the row to an RX table if matching is met, and setting the attributes of format, font, line height and column width by a JAVAPOI program in the copying process.
3. The vehicle data file generation method according to claim 2, wherein in step S2, when parsing the data cells, the signal is further de-duplicated according to a uniqueness principle, and the signal name matching is performed according to the data cross-correlation characteristics.
4. The vehicle data file generation method according to claim 1, wherein the step S3 specifically includes:
operating a TXFirstingput code module, converting the RX table to obtain a TXFirstingput table, wherein the TXFirstingput table comprises three columns of data of a time period MsgCycleTime, a signal name SignalName and a signal length SigLength of a data message;
running a TXSeContinut code module, reading the TXSeContinut table, acquiring three rows of data of a time period MsgCycleTime, a signal name SignalName and a signal length of a data message, grouping each signal according to a Motorola forward LSB matrix format and acquisition frequency by adopting a greedy algorithm, polling and filling 64-bit data frames with each signal until the data frames are filled or no signal meeting the requirement exists, and outputting signal.txt;
and setting two rows of values of a signal start bit and a signal length in the signal.
5. The vehicle data file generation method according to claim 1, wherein the schema information types include three types of int, float, and double,
the int type needs to satisfy one of the following conditions: the signal value description attribute does not contain a linear field; the signal value description attribute contains a linear field but no ' > field and no '% ' field; the signal value description attribute includes a linear field and includes a ' · ' field and the ' · ' field is spaced apart from the ' field by a position greater than 5;
the float type needs to satisfy one of the following conditions: the signal value description attribute contains a linear field and contains a ' ″ field but not a '% ' field; the signal value description attribute includes a linear field and includes a ' · ' field and the ' · ' field is spaced from the ' field by no more than 5; the signal value description attribute includes a linear field and includes a '·' field with the '·' field spaced from the 'pre' field by no more than 15;
the double type needs to satisfy: the signal value description attribute includes a linear field and includes a '·' field and the '·' field is spaced from the 'pre' field by a position greater than 15.
6. The vehicle data file generation method according to claim 1, wherein after the DBC file is generated in step S5, it is determined from log information whether the DBC file meets functional requirements, if the log only contains warning information, it indicates that the DBC conversion is successful, and if there is error information feedback, it is necessary to check the content of the communication matrix and the format specification, and then convert the DBC file again until there is no error information feedback.
7. A vehicle data file generating apparatus, characterized by comprising:
the device comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a bus matrix and a signal demand table under a set path;
the first generation unit is used for reading and analyzing the data cells in the bus matrix and the signal demand table one by using JAVAPOI and generating an RX table containing the collected signal information transmitted by the CAN bus;
the second generating unit is used for sequencing the RX table line by line, arranging signal names under the same message name together, grouping according to a Motorola forward LSB matrix format and acquisition frequency, and polling and filling each signal with 64-bit data frames by adopting a greedy algorithm to generate a TX table;
a third generating unit, configured to set a mode schema information of a type determination rule addition signal according to the signal value description attribute of the TX table, and generate a communication matrix by combining the RX table, the TX table, and the schema information;
and the fourth generation unit is used for reading the communication matrix line by line through the DBC conversion program and generating a DBC file.
8. The vehicle data file generating device according to claim 7, wherein the first generating unit analyzes the data cells in the bus matrix and the signal demand table by using JAVAPOI, and specifically comprises:
reading two columns of data of a message 16-system ID and a signal name of a signal demand table to form a key value pair linked list;
and scanning each row of the bus matrix line by line to match key value pairs in the linked list, copying the row to an RX table if matching is met, and setting the attributes of format, font, line height and column width by a JAVAPOI program in the copying process.
9. The vehicle data file generation device according to claim 8, wherein when the first generation unit analyzes the data cell, signal duplication is also removed according to a uniqueness principle, and signal name matching is performed according to data cross-correlation characteristics.
10. The vehicle data file generation device according to claim 7, wherein the second generation unit is specifically configured to:
operating a TXFirstingput code module, converting the RX table to obtain a TXFirstingput table, wherein the TXFirstingput table comprises three columns of data of a time period MsgCycleTime, a signal name SignalName and a signal length SigLength of a data message;
running a TXSeContinut code module, reading the TXSeContinut table, acquiring three rows of data of a time period MsgCycleTime, a signal name SignalName and a signal length of a data message, grouping each signal according to a Motorola forward LSB matrix format and acquisition frequency by adopting a greedy algorithm, polling and filling 64-bit data frames with each signal until the data frames are filled or no signal meeting the requirement exists, and outputting signal.txt;
and setting two rows of values of a signal start bit and a signal length in the signal.
11. The vehicle data file generating device according to claim 7, wherein the schema message types include three types of int, float, and double,
the int type needs to satisfy one of the following conditions: the signal value description attribute does not contain a linear field; the signal value description attribute contains a linear field but no ' > field and no '% ' field; the signal value description attribute includes a linear field and includes a ' · ' field and the ' · ' field is spaced apart from the ' field by a position greater than 5;
the float type needs to satisfy one of the following conditions: the signal value description attribute contains a linear field and contains a ' ″ field but not a '% ' field; the signal value description attribute includes a linear field and includes a ' · ' field and the ' · ' field is spaced from the ' field by no more than 5; the signal value description attribute includes a linear field and includes a '·' field with the '·' field spaced from the 'pre' field by no more than 15;
the double type needs to satisfy: the signal value description attribute includes a linear field and includes a '·' field and the '·' field is spaced from the 'pre' field by a position greater than 15.
12. The vehicle data file generation device according to claim 7, characterized by further comprising:
and the judging unit is used for judging whether the DBC file meets the functional requirements or not according to log information after the DBC file is generated, if the log only contains warning information, the DBC is successfully converted, and if error information feedback exists, the DBC file is converted again after the content and the format specification of a communication matrix need to be checked until no error information feedback exists.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910733856.2A CN112347047A (en) | 2019-08-09 | 2019-08-09 | Vehicle data file generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910733856.2A CN112347047A (en) | 2019-08-09 | 2019-08-09 | Vehicle data file generation method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112347047A true CN112347047A (en) | 2021-02-09 |
Family
ID=74367597
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910733856.2A Pending CN112347047A (en) | 2019-08-09 | 2019-08-09 | Vehicle data file generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112347047A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112947376A (en) * | 2021-02-19 | 2021-06-11 | 中国第一汽车股份有限公司 | Test vehicle use supervision method and supervision system |
| CN113518015A (en) * | 2021-04-08 | 2021-10-19 | 重庆长安汽车股份有限公司 | Automatic realization method based on vehicle machine CAN network signal test |
| CN113542086A (en) * | 2021-06-28 | 2021-10-22 | 合肥国轩高科动力能源有限公司 | CAN signal initial position calculation method and DBC file generation method |
| CN116847004A (en) * | 2023-08-30 | 2023-10-03 | 江铃汽车股份有限公司 | Analysis method, system and computer equipment for automobile CAN signals |
Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101019107A (en) * | 2004-08-27 | 2007-08-15 | 罗伯特·博世有限公司 | Communications module comprising a communications interface element, and communications interface element |
| CN102088787A (en) * | 2010-12-10 | 2011-06-08 | 中兴通讯股份有限公司 | Method and system for demodulating uplink data channel in wideband code division multiple access system |
| CN102307118A (en) * | 2011-08-10 | 2012-01-04 | 福建星网锐捷网络有限公司 | Back plate test method, apparatus thereof and system thereof |
| CN102611741A (en) * | 2012-02-17 | 2012-07-25 | 浙江大学 | Method for extracting communication matrix from AUTOSAR (Automotive Open System Architecture) system allocation model |
| CN102892183A (en) * | 2011-07-22 | 2013-01-23 | 富士通株式会社 | Wireless communication system for determining mobile devices positions and related method |
| CN103425692A (en) * | 2012-05-22 | 2013-12-04 | 阿里巴巴集团控股有限公司 | Data exporting method and data exporting device |
| CN103823804A (en) * | 2012-11-19 | 2014-05-28 | 广州汽车集团股份有限公司 | Method and device for converting CAN (controller area network) files into Excel files |
| CN106165481A (en) * | 2014-04-02 | 2016-11-23 | Lg电子株式会社 | The method of receiving and transmitting signal and equipment thereof in a wireless communication system |
| CN107247697A (en) * | 2017-07-05 | 2017-10-13 | 上海蔚赫信息科技有限公司 | A kind of method that Excel file is converted to automotive networking DBC files |
| US20180034317A1 (en) * | 2016-07-26 | 2018-02-01 | Schweitzer Engineering Laboratories, Inc. | Microgrid Power Flow Monitoring and Control |
| CN108829647A (en) * | 2018-05-04 | 2018-11-16 | 天津大学 | A kind of data transfer device and device |
| CN109753043A (en) * | 2017-11-06 | 2019-05-14 | 联合汽车电子有限公司 | The test device and method of CAN bus communication matrix |
| KR101989340B1 (en) * | 2018-11-01 | 2019-06-17 | 비티에스테크놀로지스(주) | Data link layer test method and system of CAN communication |
| US20190245890A1 (en) * | 2016-11-18 | 2019-08-08 | Continental Automotive Gmbh | Method for a communication network, and electronic monitoring unit |
-
2019
- 2019-08-09 CN CN201910733856.2A patent/CN112347047A/en active Pending
Patent Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101019107A (en) * | 2004-08-27 | 2007-08-15 | 罗伯特·博世有限公司 | Communications module comprising a communications interface element, and communications interface element |
| CN102088787A (en) * | 2010-12-10 | 2011-06-08 | 中兴通讯股份有限公司 | Method and system for demodulating uplink data channel in wideband code division multiple access system |
| CN102892183A (en) * | 2011-07-22 | 2013-01-23 | 富士通株式会社 | Wireless communication system for determining mobile devices positions and related method |
| CN102307118A (en) * | 2011-08-10 | 2012-01-04 | 福建星网锐捷网络有限公司 | Back plate test method, apparatus thereof and system thereof |
| CN102611741A (en) * | 2012-02-17 | 2012-07-25 | 浙江大学 | Method for extracting communication matrix from AUTOSAR (Automotive Open System Architecture) system allocation model |
| CN103425692A (en) * | 2012-05-22 | 2013-12-04 | 阿里巴巴集团控股有限公司 | Data exporting method and data exporting device |
| CN103823804A (en) * | 2012-11-19 | 2014-05-28 | 广州汽车集团股份有限公司 | Method and device for converting CAN (controller area network) files into Excel files |
| CN106165481A (en) * | 2014-04-02 | 2016-11-23 | Lg电子株式会社 | The method of receiving and transmitting signal and equipment thereof in a wireless communication system |
| US20180034317A1 (en) * | 2016-07-26 | 2018-02-01 | Schweitzer Engineering Laboratories, Inc. | Microgrid Power Flow Monitoring and Control |
| US20190245890A1 (en) * | 2016-11-18 | 2019-08-08 | Continental Automotive Gmbh | Method for a communication network, and electronic monitoring unit |
| CN107247697A (en) * | 2017-07-05 | 2017-10-13 | 上海蔚赫信息科技有限公司 | A kind of method that Excel file is converted to automotive networking DBC files |
| CN109753043A (en) * | 2017-11-06 | 2019-05-14 | 联合汽车电子有限公司 | The test device and method of CAN bus communication matrix |
| CN108829647A (en) * | 2018-05-04 | 2018-11-16 | 天津大学 | A kind of data transfer device and device |
| KR101989340B1 (en) * | 2018-11-01 | 2019-06-17 | 비티에스테크놀로지스(주) | Data link layer test method and system of CAN communication |
Non-Patent Citations (3)
| Title |
|---|
| DONGSHENG LIU等: "Design and Implementation of An ECC-Based Digital Baseband Controller for RFID Tag Chip", 《 IEEE TRANSACTIONS ON INDUSTRIAL ELECTRONICS》, vol. 62, no. 7, pages 4365 - 4373, XP011581612, DOI: 10.1109/TIE.2014.2387333 * |
| 曾桂芬: "基于通信矩阵转化成DBC数据库的研究", 《汽车电器》, no. 9, pages 57 - 59 * |
| 顾祖飞等: "CAN网络辅助平台的开发", 《湖北汽车工业学院学报》, vol. 32, no. 3, pages 50 - 54 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112947376A (en) * | 2021-02-19 | 2021-06-11 | 中国第一汽车股份有限公司 | Test vehicle use supervision method and supervision system |
| CN113518015A (en) * | 2021-04-08 | 2021-10-19 | 重庆长安汽车股份有限公司 | Automatic realization method based on vehicle machine CAN network signal test |
| CN113518015B (en) * | 2021-04-08 | 2023-03-14 | 重庆长安汽车股份有限公司 | Automatic realization method based on vehicle machine CAN network signal test |
| CN113542086A (en) * | 2021-06-28 | 2021-10-22 | 合肥国轩高科动力能源有限公司 | CAN signal initial position calculation method and DBC file generation method |
| CN113542086B (en) * | 2021-06-28 | 2023-03-10 | 合肥国轩高科动力能源有限公司 | CAN signal initial position calculation method and DBC file generation method |
| CN116847004A (en) * | 2023-08-30 | 2023-10-03 | 江铃汽车股份有限公司 | Analysis method, system and computer equipment for automobile CAN signals |
| CN116847004B (en) * | 2023-08-30 | 2023-11-17 | 江铃汽车股份有限公司 | Analysis method, system and computer equipment for automobile CAN signals |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112347047A (en) | Vehicle data file generation method and device | |
| CN108600192B (en) | Regular expression based DBC file analysis and message analysis method | |
| CN112714134B (en) | CAN message analysis method, adaptation method, device, equipment and medium | |
| CN111585344B (en) | Substation intelligent checking method and device based on total station IED simulation | |
| CN112485019B (en) | Vehicle fault diagnosis method and device, vehicle and storage medium | |
| CN113612654B (en) | Vehicle-mounted gateway function test method based on database | |
| CN109861998B (en) | Plug-in type dynamic analysis system and method based on Beidou short message protocol | |
| CN102231107B (en) | Method for automatically generating communication data format of electric control unit based on AUTOSAR (Automotive Open System Architecture) | |
| CN110390082B (en) | Communication matrix comparison method and system | |
| CN104698962B (en) | PLC man-machine communication's method and system | |
| CN113010473B (en) | Method and equipment for editing YAML file | |
| CN111552268A (en) | Vehicle remote diagnosis method, equipment connector and vehicle connector | |
| CN112614331B (en) | Method for reading electric energy meter event and electric energy meter event reading system | |
| CN114282519A (en) | CAN data analysis method and device | |
| CN111756688B (en) | Method and system for realizing meter protocol and application decoupling | |
| CN116634042A (en) | Big data message analysis method, device and storage medium | |
| CN116610671A (en) | Standardized storage method and device for vehicle data information | |
| CN116346961A (en) | Financial message processing method and device, electronic equipment and storage medium | |
| CN111191419A (en) | Excel-to-xml method and system applicable to testlink | |
| CN106878431B (en) | Method and device for converting node communication message format in distributed system | |
| CN115473924A (en) | Carbon emission metering system based on thing networking block chain | |
| CN114936227A (en) | Data verification method, data verification system, electronic device and storage medium | |
| CN110995869B (en) | Machine data collection method, device, equipment and medium | |
| CN102722592B (en) | Universal digital information recording device and method | |
| CN113377363A (en) | Cloud implementation method for automatically generating source codes for various electric control end private protocols |
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 |