ARXML file generation method and system

Abstract

The invention provides an ARXML file generation method and system, and belongs to the technical field of data conversion, and the method comprises the steps: S1, receiving an Excel document to be converted, the Excel document to be converted comprising a plurality of worksheets storing different Excel data; s2, analyzing Excel documents to be converted one by one according to the worksheets, converting Excel data extracted from each worksheet into model data, and storing the model data corresponding to each worksheet into a data cache region; and S3, generating a target ARXML file based on the model data of the data cache region. The method has the beneficial effects that the Excel document is analyzed according to the worksheet, the data is converted into different model data, the model data are uniformly stored in the data cache region, and finally the ARXML file is generated through serialization, a configuration tool does not need to be installed in the whole process, the ARXML file can be generated through one key after the Excel file is imported, the consumed time is short, and the requirement for professional skills of users is reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of data conversion, and in particular to an ARXML file generation method and system. Background Art

[0002] In the development of modern automotive electronic systems, the Automotive Open System Architecture (AUTOSAR), as an open and standardized software architecture, is conducive to the exchange and update of vehicle electronic system software, and provides a basis for the efficient management of increasingly complex vehicle electronic and software systems. In addition, AUTOSAR improves cost efficiency while ensuring product and service quality.

[0003] At present, software configuration based on the AUTOSAR standard usually requires the help of AUTOSAR tool chains. These configuration tool chains provide an intuitive graphical user interface, allowing users to configure according to their own functional module requirements, and automatically generate ARXML files, and then generate the required code.

[0004] Most of these configuration tool chains are configured based on the ARXML (AUTOSAR Runtime Interface XML) file format. However, the original configuration is usually stored in files of other formats, such as Excel documents. When using the AUTOSAR tool chain for software configuration, it is necessary to manually refer to the AUTOSAR specification, translate the content represented by the Excel document into a configuration that the tool can recognize, and then perform manual configuration in conjunction with the configuration tool.

[0005] Since the AUTOSAR specification itself is complex and obscure, the number of documents is huge. When using the tool, users need to have a deep understanding of the AUTOSAR specification to ensure the correctness and effectiveness of the configuration. Moreover, there are differences between different versions of the AUTOSAR specification, which makes it difficult for tool users to use it. Moreover, the entries in the Excel document are huge, with tens of thousands of rows of data. It takes a huge amount of time and manpower to achieve data migration and conversion, and it is easy to make mistakes, and it is difficult to quickly locate the problem after an error occurs.

[0006] In addition, due to the complexity of AUTOSAR, the requirements for tools are high. Even the most basic tool chain requires multiple tools to cooperate with each other to complete the entire configuration process, and the environment installation is complex. Summary of the invention

[0007] In order to solve the above technical problems, the present invention provides an ARXML file generation method; on the other hand, it also provides an ARXML file generation system.

[0008] The technical problem solved by the present invention can be achieved by adopting the following technical solutions:

[0009] A method for generating an ARXML file, comprising:

[0010] Step S1, receiving an Excel document to be converted, wherein the Excel document to be converted includes a plurality of worksheets storing different Excel data;

[0011] Step S2, parsing the Excel document to be converted one by one according to the worksheets, converting the Excel data extracted from each worksheet into model data, and storing the model data corresponding to each worksheet in the data buffer area;

[0012] Step S3: Generate a target ARXML file based on the model data in the data cache area.

[0013] Preferably, the working table includes one or more combinations of a data type table, a service definition table, a communication behavior table, a vehicle definition table and a network configuration table.

[0014] Preferably, step S2 comprises:

[0015] Step S21, loading corresponding conversion models respectively according to the labels corresponding to each worksheet of the Excel document to be converted;

[0016] Step S22, based on the loaded conversion model, the Excel data of the worksheet of the corresponding label is converted to obtain the model data of each model object, and the model data of each model object is stored in the data buffer area.

[0017] Preferably, the step S22 includes:

[0018] Step S221, determining whether the current conversion model has other related conversion models according to the association relationship between the conversion models:

[0019] If yes, proceed to step S223;

[0020] If not, proceed to step S222;

[0021] Step S222, based on the current conversion model, convert the Excel data of the worksheet of the corresponding label to obtain the first model data of each model object, and store the first model data of each model object in the data buffer area, and then transfer to the step S3;

[0022] Step S223, reading first model data converted from other conversion models associated with the current conversion model from the data buffer area;

[0023] Step S224, based on the current conversion model combined with the first model data read from the data cache area, the Excel data of the worksheet of the corresponding label is converted to obtain the second model data of each model object, and the second model data of each model object is stored in the data cache area, and then the process proceeds to step S3.

[0024] Preferably, step S3 comprises:

[0025] Step S31, mapping the model data in the data buffer area to corresponding ARXML elements and attributes according to the target version specification of the automotive open system architecture;

[0026] Step S32: Generate the target ARXML file based on the mapped ARXML elements and attributes.

[0027] Preferably, the step S3 further includes:

[0028] Step S4, displaying the conversion process log from the Excel document to be converted to the target ARXML file.

[0029] A second aspect of the present invention is to provide an ARXML file generation system for implementing the ARXML file generation method as described above, the system comprising:

[0030] An Excel document receiving module, used for receiving an Excel document to be converted, wherein the Excel document to be converted includes a plurality of worksheets storing different Excel data;

[0031] A data conversion module, connected to the Excel document receiving module, is used to parse the Excel document to be converted one by one according to the worksheets, convert the Excel data extracted from each worksheet into model data, and store the model data corresponding to each worksheet in the data buffer area;

[0032] The target file generation module is connected to the data conversion module and is used to generate a target ARXML file based on the model data in the data buffer area.

[0033] Preferably, the data conversion module includes:

[0034] A model loading unit, used to load corresponding conversion models according to the labels corresponding to each worksheet of the Excel document to be converted;

[0035] The conversion unit is connected to the model loading unit and is used to convert the Excel data of the worksheet of the corresponding label based on the loaded conversion model to obtain the model data of each model object, and store the model data of each model object in the data buffer area.

[0036] Preferably, the conversion unit comprises:

[0037] A first conversion subunit is used to convert the Excel data of the worksheet of the corresponding label based on the current conversion model to obtain the first model data of each model object, and store the first model data of each model object in the data buffer area;

[0038] The second conversion subunit is used to read the first model data converted by other conversion models associated with the current conversion model from the data cache based on the association relationship between the current conversion model and the other conversion models, convert the Excel data of the worksheet of the corresponding label based on the current conversion model combined with the first model data read from the data cache to obtain the second model data of each model object, and store the second model data of each model object in the data cache.

[0039] Preferably, the target file generation module includes:

[0040] A data mapping unit, used for mapping the model data in the data buffer area to corresponding ARXML elements and attributes according to the target version specification of the automotive open system architecture;

[0041] The file generating unit is connected to the data mapping unit and is used to generate the target ARXML file based on the mapped ARXML elements and attributes.

[0042] The advantages or beneficial effects of the technical solution of the present invention are:

[0043] The present invention parses Excel documents according to worksheets, converts data into different model data, uniformly stores them in a data cache area, and finally serializes them to generate an ARXML file. The whole process does not require the installation of configuration tools. After importing the Excel file, the ARXML file can be generated with one click, which saves time and reduces the professional skill requirements for users. BRIEF DESCRIPTION OF THE DRAWINGS

[0044] Figure 1 A flowchart of a method for generating an ARXML file in a preferred embodiment of the present invention;

[0045] Figure 2 This is a flow chart of step S2 in a preferred embodiment of the present invention;

[0046] Figure 3 This is a flow chart of step S22 in a preferred embodiment of the present invention;

[0047] Figure 4 This is a flow chart of step S3 in a preferred embodiment of the present invention;

[0048] Figure 5 This is a structural block diagram of an ARXML file generation system in a preferred embodiment of the present invention. DETAILED DESCRIPTION

[0049] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0050] It should be noted that, in the absence of conflict, the embodiments of the present invention and the features in the embodiments may be combined with each other.

[0051] Explanation of the name:

[0052] AUTOSAR: The full name is Automotive Open System Architecture, which is an open system architecture for automobiles. It is a cooperative development framework for automotive electronic systems jointly participated by global automobile manufacturers, parts suppliers, and various research and service institutions, and has established an open standard software architecture for automotive control units (ECUs).

[0053] ARXML: The full name is AUTOSAR Runtime Interface XML. It is a configuration file that complies with the AUTOSAR specification.

[0054] The present invention will be further described below in conjunction with the accompanying drawings and specific embodiments, but they are not intended to limit the present invention.

[0055] In a preferred embodiment of the present invention, based on the above problems existing in the prior art, a method for generating an ARXML file is provided. Figure 1 As shown, including:

[0056] Step S1, receiving an Excel document to be converted, wherein the Excel document to be converted includes a plurality of worksheets storing different Excel data;

[0057] Step S2, parsing the Excel document to be converted one by one according to the worksheets, converting the Excel data extracted from each worksheet into model data, and storing the model data corresponding to each worksheet in the data buffer area 23;

[0058] Step S3, generating a target ARXML file based on the model data in the data buffer area 23.

[0059] Specifically, in view of the fact that the prior art needs to manually translate the contents represented by the Excel document into a configuration that can be recognized by the tool according to the AUTOSAR specification, it takes a huge amount of time and manpower to achieve data migration and conversion, which is prone to errors and difficult to quickly locate the problem after an error occurs, in this embodiment, the Excel document is parsed according to the worksheet (i.e., sheet page), the data is converted into different model data, uniformly stored in the data cache area, and finally serialized to generate an ARXML file. The entire process does not require the installation of a configuration tool. After the Excel document is imported into the present invention, the conversion process can be started with one click, and the ARXML file can be generated with one click. The entire conversion process takes less than 5 seconds, which is time-consuming and does not require professional skills for the user.

[0060] During the software configuration process, the original configuration is usually not stored directly in the ARXML file format, but in Excel documents. As a software tool widely used in daily office work, Excel documents have the advantages of universal and easy-to-understand data, easy reading, and low threshold for use. Developers can make full use of the multi-sheet function by organizing the function configuration in an Excel table in an orderly manner, retaining the customer's usage habits and improving communication efficiency.

[0061] The Excel document contains the data that needs to be converted into ARXML format. It is created by professional developers to store various configuration information, parameter values, or other data that needs to be organized in a spreadsheet format.

[0062] The data in an Excel document can be stored in multiple worksheets. In the Excel document to be converted, each worksheet may represent a specific data set or configuration information set. For example, one worksheet contains data types, while another worksheet contains service definitions, and so on.

[0063] Excel data refers to the specific information stored in an Excel document worksheet. This data is organized and displayed in a spreadsheet format, which can contain text, numbers, formulas, and other data. During the ARXML file generation process, this Excel data will be extracted and converted into model data suitable for the ARXML format.

[0064] Model data is configuration information organized according to the AUTOSAR specification so that it can be recognized and used by tools or systems.

[0065] The data cache is a temporary storage area for storing model data parsed from Excel documents. The model data corresponding to each worksheet will be stored in the data cache for subsequent use in generating ARXML files.

[0066] ARXML is an XML file format used to describe the configuration of an AUTOSAR system. The target ARXML file contains the model data extracted and converted from the Excel document and is organized according to the AUTOSAR specification.

[0067] As a preferred implementation, the work table includes one or more combinations of a data type table, a service definition table, a communication behavior table, a vehicle definition table, and a network configuration table.

[0068] Data types define the structure of data exchanged between software components, including basic data types (such as integers, floating-point numbers, Boolean values, etc.) and composite data types (such as structures, arrays, etc.).

[0069] The definition of data types allows developers to create consistent interfaces between different parts of the software, ensuring the correctness and consistency of data during transmission.

[0070] Exemplarily, the data type name (DataType Name) in the data type table includes but is not limited to data type description (DataType Description), data type category (DataType Category), length type (String / Array LengthType), minimum length (String / Array Length(min)) and maximum length (String / ArrayLength(max)), member position (MemberPosition), member name (MemberName), member description (MemberDescription), member data type reference (Member Datatype Reference) and base data type (BaseDatatype).

[0071] A service definition describes the operations or functionality provided by a software component. In ARXML, a service can include requests and responses in client-server communication, or message publishing in publish-subscribe communication. A service definition can include the name of the service, input and output parameters (usually based on previously defined data types), and the way the service is invoked (such as synchronous or asynchronous).

[0072] Exemplarily, the service definition name (Service Name) in the service definition table includes but is not limited to service ID (Service ID), service description (Service Description), RPC type (RPC Type) and field property name (FieldPropertyName), field property data type (Field Property DataType), RPC SpecificType, method / event ID (Method / Event ID), method / event description (Method / Event Description), UDP / TCP, input parameter (Input Parameter (R / R, F&F)) and output parameter (Output Parameter (R / R)), Event / Notification Event Parameter, sending strategy (Send Strategy), and periodic time (CyclicTime (ms)).

[0073] Communication behavior defines how information is exchanged between software components. In ARXML, this includes client-server communication, publish-subscribe (Pub-Sub) communication, and direct communication (such as shared memory).

[0074] The configuration of communication behavior involves defining the sender and receiver of the message, the message transmission method (such as periodic transmission or event triggering), and the priority and time limit of the message.

[0075] Exemplarily, the communication behavior names in the communication behavior table include but are not limited to communication behavior name (ServiceName), service ID (Service ID), instance ID (Instance ID), major version (MajorVersion), MinorVersion, time limit (TTL), VLAN ID, VLAN Name, message priority (VLAN PRIORITY), transport protocol (Transport Protocol), server (Server), server IP (Server IP), server IP subnet mask (Server IP SubnetMask), server port (Server Port), client (Client), client IP (ClientIP), Client IP (unicast), client IP subnet mask (Client IP SubnetMask), and client port (Client Port).

[0076] A vehicle definition describes the system architecture and configuration of a specific vehicle in ARXML. This includes the vehicle's electronic control units (ECUs), the connections between ECUs (such as buses), and the software components within and between ECUs.

[0077] The vehicle definition also includes an abstract description of vehicle-specific functions (such as engine control, braking system, infotainment system, etc.) and how these functions are distributed across different ECUs.

[0078] Exemplarily, in the vehicle definition table, the vehicle definition name for SOME / IP-SD ECU Configuration includes, but is not limited to, ECU name (ECU Name), MAC address, minimum initialization delay time (Init_Delay_Min (ms), maximum initialization delay time (Init_Delay_Max (ms)), repetition base delay time (Repetition_Base_Delay (ms)), maximum number of repetitions (Repetition_Max), periodic offer delay time (Cyclic_Offer_Delay (ms)), minimum request / response delay time (Request_Response_Delay_Min (ms)), maximum request / response delay time (Request_Response_Delay_Max (ms)), and remark information (Remark).

[0079] The network configuration defines the physical and logical connections between ECUs within the vehicle. In ARXML, this includes the configuration of the bus system (such as CAN, LIN, FlexRay, Ethernet, etc.), the network topology, and the location and role of the ECUs in the network.

[0080] Network configuration also includes the definition of communication parameters (such as baud rate, message length, frame format, etc.), as well as network fault handling strategies (such as error detection, recovery mechanisms, etc.).

[0081] For example, in the network configuration table, the network configuration name for SOME / IP-SD Multicast includes but is not limited to VLAN ID, SD Multicast Address, SD Port Number, Protocol, and Remark. The network configuration name for SOME / IP-SD Unicast includes but is not limited to SD Port Number, Protocol, and Remark.

[0082] As a preferred embodiment, wherein Figure 2 As shown, step S2 includes:

[0083] Step S21, loading corresponding conversion models according to the labels corresponding to each worksheet of the Excel document to be converted;

[0084] Step S22 , based on the loaded conversion model, the Excel data of the worksheet of the corresponding label is converted to obtain the model data of each model object, and the model data of each model object is stored in the data buffer area 23 .

[0085] Specifically, for each worksheet label, the corresponding conversion model is loaded. These models are pre-defined and can perform corresponding conversion processing according to the data format and content in Excel.

[0086] In this embodiment, the label may be the name of the worksheet.

[0087] Furthermore, the conversion model includes but is not limited to an application (Application) model, a data type (DataType) model, a process (Process) model, a vehicle (Machine) model, a service interface (ServiceInterface) model, a port (Port) model, and an executable file (Executable) model.

[0088] Furthermore, the Application model can read the sheet page named "Application", then parse the application name, version, description and other information, and create an Application model object.

[0089] Furthermore, the DataType model can read a sheet page named "DataType", parse the data type name, base type, length, and other information, and create a DataType model object.

[0090] The data types correspond one-to-one to the data types defined in the AUTOSAR19-11 specification.

[0091] However, in actual applications, data types can also be defined according to other versions of the AUTOSAR specification.

[0092] Exemplarily, the data type model may be:

[0093] public class DataType{

[0094] private String name; / / name

[0095] Private String desc; / / description

[0096] Private String type; / / Data type

[0097] private String lengthType; / / fixed, dynamic

[0098] private int minLength; / / minimum length

[0099] private int maxLength; / / maximum length

[0100] private int memberPos; / / member position

[0101] private String memberName; / / name

[0102] private String memberDesc; / / Member description

[0103] private String memberTypeRef; / / Member type

[0104] private String baseType; / / base class

[0105] private String valueDefine; / / enumeration value definition

[0106] private List <datatype>members; / / Member list

[0107] }

[0108] Furthermore, the Process model can read the sheet page named "Process", parse the process name, execution order, input / output data type and other information, and create a Process model object.

[0109] Furthermore, the Machine model can read the sheet page named "Machine", parse the ECU name, MAC address, delay time and other information, and create a Machine model object.

[0110] Furthermore, the Service Interface model can read the sheet page named "ServiceInterface", parse the service interface name, input and output parameters and other information, and create a ServiceInterface model object.

[0111] Exemplarily, the service interface model may be:

[0112] Public class SomeIpSeriveDeploy{

[0113] private String name; / / name

[0114] Private String id; / / service id

[0115] private String desc; / / description information

[0116] private String rpcType; / / Service type

[0117] private String rpcSpecType;

[0118] private String methodorEventName; / / method or event name

[0119] private String methodorEventId; / / method or event id

[0120] private String methodOrEventDesc; / / method or event description

[0121] private String eventGroup; / / Event group

[0122] private String protocol; / / protocol

[0123] private String methodInArg; / / Input parameters

[0124] privateStringmethodoutArg; / / return parameter

[0125] privateStringeventArg; / / Event parameters

[0126] private String sendStrategy; / / Send strategy

[0127] private Stringcyclic; / / cycle

[0128] privateList <someipserivedeploy>methods; / / method list

[0129] privateList <someipserivedeploy>events; / / Event list

[0130] }

[0131] Furthermore, the Port model can read the sheet page named "Port".

[0132] Conversion strategy: parse the port name, type (input / output), associated service interface and other information, and create a Port model object.

[0133] Furthermore, the Executable module can read the sheet page named "Executable", parse the executable file name, path, dependencies and other information, and create an Executable model object.

[0134] As a preferred embodiment, wherein Figure 3 As shown, step S22 includes:

[0135] Step S221, according to the association relationship between the conversion models, determine whether the current conversion model has other associated conversion models:

[0136] If yes, proceed to step S223;

[0137] If not, proceed to step S222;

[0138] Step S222, based on the current conversion model, convert the Excel data of the worksheet of the corresponding label to obtain the first model data of each model object, and store the first model data of each model object in the data buffer area 23, and then go to step S3;

[0139] Step S223, reading the first model data converted from other conversion models associated with the current conversion model from the data buffer area 23;

[0140] Step S224, based on the current conversion model combined with the first model data read from the data cache area 23, the Excel data of the worksheet of the corresponding label is converted to obtain the second model data of each model object, and the second model data of each model object is stored in the data cache area 23, and then the process goes to step S3.

[0141] Specifically, after loading the conversion model, before the conversion process, it is necessary to determine whether the current conversion model has an association relationship with other conversion models. This association relationship is mainly reflected in the reference, dependency or inheritance between data.

[0142] If there is no association relationship, it means that the current conversion model can perform data conversion independently and does not need to rely on the conversion results of other conversion models.

[0143] If there is an association relationship, it means that the current conversion model needs to rely on the conversion results of other conversion models for further conversion processing.

[0144] For conversion models without an associated relationship, the Excel data of the worksheet of the corresponding label is directly converted based on the current conversion model. During the conversion process, we parse the Excel data according to the definition of the conversion model (such as the DataType class in the data type model and the SomeIpSeriveDeploy class in the service interface model) and generate the corresponding model object. Then, the model data of each model object is stored in the data buffer area 23.

[0145] For conversion models with associated relationships, firstly, first model data converted from other conversion models associated with the current conversion model are read from the data buffer 23. These data have been converted and stored in the data buffer before.

[0146] After obtaining the data of the associated model, the Excel data of the worksheet of the corresponding label is converted based on the current conversion model combined with the first model data read from the data buffer area 23. This ensures that the association relationship between the data can be correctly processed during the conversion process. After the conversion is completed, we store the second model data of each model object in the data buffer area 23.

[0147] After completing data conversion, each conversion model stores the model data in a unified data cache, using the model name or unique identifier as the key to facilitate calls by other models.

[0148] For models that are related, you can directly get the corresponding cache data from the data cache based on the key.

[0149] As a preferred embodiment, wherein Figure 4 As shown, step S3 includes:

[0150] Step S31, mapping the model data in the data buffer area 23 to corresponding ARXML elements and attributes according to the target version specification of the automotive open system architecture;

[0151] Step S32: Generate a target ARXML file based on the mapped ARXML elements and attributes.

[0152] Specifically, after all models have completed data conversion, these model data are serialized into ARXML files.

[0153] Exemplarily, the process of the method of the embodiment of the present invention as a whole constitutes a conversion model, and the conversion model can be:

[0154] Interface IConverter {

[0155] boolean parseExcel(String excelPath,SubMonitormonitor);

[0156] Boolean saveArxml(TransactionalEditingDomain editingDomain,AUToSARautosar,SubMonitormonitor);

[0157] }

[0158] Specifically, the conversion model defines two interfaces:

[0159] parseExcel interface: used to parse an Excel document located at a specified path. This interface includes two parameters: one is the path of the Excel document (String excelPath), and the other is a SubMonitor object used to monitor the parsing process. This interface returns a boolean value indicating whether the parsing operation is successful.

[0160] saveArxml interface: used to serialize the assembled data into an ARXML file. This interface includes three parameters: a TransactionalEditingDomain object (usually related to the Eclipse Modeling Framework (EMF) for managing editing transactions), an AUToSAR object (representing the AUToSAR model to be saved), and a SubMonitor object for monitoring the saving process. This method returns a Boolean object (note that it is a capitalized Boolean, which is a wrapper class of Boolean), which also indicates whether the operation is successful.

[0161] As a preferred embodiment, the step S3 further includes:

[0162] Step S4, displaying the conversion process log from the Excel document to be converted to the target ARXML file.

[0163] Furthermore, corresponding configuration files (such as ARXML files) or source codes can be generated according to the model data. That is, in addition to using the method of the present invention to convert the imported Excel document into a standard ARXML file with one click, a code generation tool can also be used to generate function codes with a specific format based on the converted model data.

[0164] The second aspect of the present invention is to provide an ARXML file generation system for implementing the ARXML file generation method as described above. Figure 5 As shown, the system includes:

[0165] The Excel document receiving module 1 is used to receive the Excel document to be converted, wherein the Excel document to be converted includes a plurality of worksheets storing different Excel data;

[0166] The data conversion module 2 is connected to the Excel document receiving module 1, and is used to parse the Excel document to be converted one by one according to the worksheets, convert the Excel data extracted from each worksheet into model data, and store the model data corresponding to each worksheet into the data buffer area 2323;

[0167] The target file generation module 3 is connected to the data conversion module 2 and is used to generate a target ARXML file based on the model data in the data buffer area 23 .

[0168] Specifically, in view of the problem that the data migration and conversion is time-consuming, labor-intensive, error-prone, and difficult to quickly locate the problem after an error occurs, in the prior art, the Excel document is parsed according to the worksheet (i.e., sheet page), the data is converted into different model data, uniformly stored in the data cache, and finally serialized to generate an ARXML file. The entire process does not require the installation of a configuration tool. After the Excel document is imported into the present invention, the conversion process can be started with one click, and the ARXML file can be generated with one click. The entire conversion process takes less than 5 seconds, which is time-consuming and does not require professional skills for the user.

[0169] As a preferred embodiment, the data conversion module 2 includes:

[0170] The model loading unit 21 is used to load the corresponding conversion model according to the label corresponding to each worksheet of the Excel document to be converted;

[0171] The conversion unit 22 is connected to the model loading unit 21 and is used to convert the Excel data of the worksheet of the corresponding label based on the loaded conversion model to obtain the model data of each model object, and store the model data of each model object in the data buffer area 23.

[0172] As a preferred embodiment, the conversion unit 22 includes:

[0173] The first conversion subunit 221 is used to convert the Excel data of the worksheet of the corresponding label based on the current conversion model to obtain the first model data of each model object, and store the first model data of each model object in the data buffer area 23;

[0174] The second conversion sub-unit 222 is used to read the first model data converted by other conversion models associated with the current conversion model from the data cache 23 based on the association relationship between the current conversion model and the other conversion models, convert the Excel data of the worksheet of the corresponding label based on the current conversion model combined with the first model data read from the data cache 23 to obtain the second model data of each model object, and store the second model data of each model object in the data cache 23.

[0175] As a preferred implementation, the target file generation module 3 includes:

[0176] The data mapping unit 31 is used to map the model data in the data buffer area 23 to corresponding ARXML elements and attributes according to the target version specification of the automotive open system architecture;

[0177] The file generating unit 32 is connected to the data mapping unit 31 and is used to generate a target ARXML file based on the mapped ARXML elements and attributes.

[0178] More implementation details of the system and the method have been disclosed and will not be repeated in this embodiment.

[0179] The system of the present invention provides an intuitive and easy-to-use software interface, and the main interface integrates multiple key functions, including:

[0180] The first button allows users to browse the local file system to quickly select an Excel file;

[0181] A first text box, adjacent to the first button, is used to display the selected Excel file path;

[0182] The second button is used to select a local path, which is convenient for users to locate the save location of the ARXML file;

[0183] The second text box, adjacent to the second button, is used to display the generation path of the ARXML file selected by the user. The system requires that the path does not contain Chinese characters to ensure compatibility;

[0184] Run button. After the user confirms that the settings are correct, click it to start the conversion process with one click.

[0185] The main interface also has a log printing window, which displays detailed information during the conversion process in real time;

[0186] In addition, the interface also includes a version information area and a software declaration area. The version information area is used to display the version number of the current software, and the software declaration area is used to provide copyright information and disclaimers to ensure that users can fully understand the relevant regulations before use.

[0187] The system of the present invention adopts a very simple solution of importing and outputting results, abandoning the cumbersome manual configuration steps, which is more convenient and faster than the traditional method.

[0188] The method and system of the present invention support cross-platform installation.

[0189] The advantages or beneficial effects of adopting the above technical solution are: the present invention parses the Excel document according to the worksheet, converts the data into different model data, uniformly stores them in the data cache area, and finally serializes them to generate an ARXML file. The whole process does not require the installation of configuration tools. After importing the Excel file, the ARXML file can be generated with one click, which saves time and reduces the professional skill requirements for users.

[0190] The above are only preferred embodiments of the present invention, and are not intended to limit the implementation methods and protection scope of the present invention. Those skilled in the art should be aware that all solutions obtained by equivalent substitutions and obvious changes made using the contents of this specification and illustrations should be included in the protection scope of the present invention.< / someipserivedeploy> < / someipserivedeploy> < / datatype>

Claims

1. A method for generating an ARXML file, characterized in that: include: Step S1, receiving an Excel document to be converted, wherein the Excel document to be converted includes a plurality of worksheets storing different Excel data; Step S2, parsing the Excel document to be converted one by one according to the worksheets, converting the Excel data extracted from each worksheet into model data, and storing the model data corresponding to each worksheet in the data buffer area; Step S3: Generate a target ARXML file based on the model data in the data cache area.

2. The ARXML file generation method according to claim 1, characterized in that: The work table includes one or more combinations of a data type table, a service definition table, a communication behavior table, a vehicle definition table, and a network configuration table.

3. The ARXML file generation method according to claim 1, characterized in that: The step S2 comprises: Step S21, loading corresponding conversion models respectively according to the labels corresponding to each worksheet of the Excel document to be converted; Step S22, based on the loaded conversion model, the Excel data of the worksheet of the corresponding label is converted to obtain the model data of each model object, and the model data of each model object is stored in the data buffer area.

4. The ARXML file generation method according to claim 3, characterized in that: The step S22 comprises: Step S221, determining whether the current conversion model has other related conversion models according to the association relationship between the conversion models: If yes, proceed to step S223; If not, proceed to step S222; Step S222, based on the current conversion model, convert the Excel data of the worksheet of the corresponding label to obtain the first model data of each model object, and store the first model data of each model object in the data buffer area, and then transfer to the step S3; Step S223, reading first model data converted from other conversion models associated with the current conversion model from the data buffer area; Step S224, based on the current conversion model combined with the first model data read from the data cache area, the Excel data of the worksheet of the corresponding label is converted to obtain the second model data of each model object, and the second model data of each model object is stored in the data cache area, and then the process proceeds to step S3.

5. The ARXML file generation method according to claim 1, characterized in that: The step S3 comprises: Step S31, mapping the model data in the data buffer area to corresponding ARXML elements and attributes according to the target version specification of the automotive open system architecture; Step S32: Generate the target ARXML file based on the mapped ARXML elements and attributes.

6. The ARXML file generation method according to claim 1, characterized in that: After step S3, the following steps are also included: Step S4, displaying the conversion process log from the Excel document to be converted to the target ARXML file.

7. An ARXML file generation system, characterized in that: For implementing the ARXML file generation method according to any one of claims 1 to 6, the system comprises: An Excel document receiving module, used for receiving an Excel document to be converted, wherein the Excel document to be converted includes a plurality of worksheets storing different Excel data; A data conversion module, connected to the Excel document receiving module, is used to parse the Excel document to be converted one by one according to the worksheets, convert the Excel data extracted from each worksheet into model data, and store the model data corresponding to each worksheet in the data buffer area; The target file generation module is connected to the data conversion module and is used to generate a target ARXML file based on the model data in the data buffer area.

8. The ARXML file generation system according to claim 7, characterized in that: The data conversion module comprises: A model loading unit, used to load corresponding conversion models according to the labels corresponding to each worksheet of the Excel document to be converted; The conversion unit is connected to the model loading unit and is used to convert the Excel data of the worksheet of the corresponding label based on the loaded conversion model to obtain the model data of each model object, and store the model data of each model object in the data buffer area.

9. The ARXML file generation system according to claim 8, characterized in that: The conversion unit comprises: A first conversion subunit is used to convert the Excel data of the worksheet of the corresponding label based on the current conversion model to obtain the first model data of each model object, and store the first model data of each model object in the data buffer area; The second conversion subunit is used to read the first model data converted by other conversion models associated with the current conversion model from the data cache based on the association relationship between the current conversion model and the other conversion models, convert the Excel data of the worksheet of the corresponding label based on the current conversion model combined with the first model data read from the data cache to obtain the second model data of each model object, and store the second model data of each model object in the data cache.

10. The ARXML file generation system according to claim 7, characterized in that: The target file generation module includes: A data mapping unit, used for mapping the model data in the data buffer area to corresponding ARXML elements and attributes according to the target version specification of the automotive open system architecture; The file generating unit is connected to the data mapping unit and is used to generate the target ARXML file based on the mapped ARXML elements and attributes.

Images