WO2018076815A1

WO2018076815A1 - Format conversion method and system

Info

Publication number: WO2018076815A1
Application number: PCT/CN2017/093198
Authority: WO
Inventors: 张坤明
Original assignee: 宁德时代新能源科技股份有限公司
Priority date: 2016-10-28
Filing date: 2017-07-17
Publication date: 2018-05-03
Also published as: CN106528744A

Abstract

Disclosed are a format conversion method and system. The format conversion method comprises: recognizing a file format of an imported import file (101); if the file format of the import file matches a pre-set file format, parsing the import file (102); and according to a pre-set target file generation method, generating a target file from the parsed data (103). During the process of conversion of a file format, the format conversion system can automatically convert a file imported by a user to a target file, and the user does not need to carry out operation, thereby reducing the operating cost, improving the accuracy of file format conversion, and improving the reliability and interactivity of software during the process of software interaction.

Description

Format conversion method and system

Technical field

The present application relates to the field of data processing, and in particular, to a format conversion method and system.

Background technique

With the development of modern society, computer technology and corresponding software products have been growing. All walks of life need to use software products in the production process. Faced with the huge demand for software products, how to improve the production efficiency of software and reduce costs has become a problem that all walks of life need to solve.

In the process of software interaction, multiple protocols are used, for example, using a controller area network protocol. In the prior art, the controller area network protocol is jointly developed by the user and the engineer, and the data content used by the two parties in the interaction process is based on the excel file.

Users and users in the process of using software to interact, usually use manual code to complete, because the user and the user will have different language habits, and in the process of writing code is prone to writing errors, resulting in software reliability Poor sex.

Application content

The embodiment of the present application provides a format conversion method and system, which improves the reliability of the software in the process of software interaction.

The embodiment of the present application provides a format conversion method, including:

Identify the file format of the imported import file;

If the file format of the imported file matches the preset file format, parsing the imported file;

The parsed data is generated into a target file according to a preset target file generation method.

Further, in the above method, before the identifying the file format of the imported import file, the method further includes:

Receiving the import file imported by the user.

Further, in the above method, if the file format of the import file matches the preset file format, parsing the import file includes:

If the file format of the imported file matches the preset file format, determine whether the content of the imported file is complete;

If the content of the import file is complete, the import file is parsed according to the target file generation manner.

Further, in the above method, if the content of the import file is complete, parsing the import file according to the target file generating manner includes:

Extracting data of a specified location in the import file;

The extracted data is adjusted according to the specified format to obtain the specified format data.

Further, in the above method, according to a preset target file generation manner, the parsed data is generated into an object file, including:

Generating a database file from a portion of the specified format data according to a database file generation manner;

According to the source code file generation method, another part of the specified format data is generated to generate a source code file.

The embodiment of the present application further provides a format conversion system, including:

An identification module for identifying a file format of the imported import file;

a parsing module, configured to parse the import file if the file format of the import file matches a preset file format;

The generating module is configured to generate the target file by using the parsed data according to a preset target file generating manner.

Further, in the above system, the system further includes:

a receiving module, configured to receive the import file imported by a user.

Further, in the above system, the parsing module is specifically configured to:

Extracting data of a specified location in the import file;

Further, in the above system, the generating module is specifically configured to:

The format conversion method and system provided by the embodiment of the present application, by identifying the file format of the import file imported by the user, to determine whether the file format of the imported file matches the preset file format, and if the file format of the imported file is When the file format is matched, the import file is parsed, and then the parsed data is generated according to a preset target file generation manner. Therefore, in the technical solution of the present application, in the file format conversion process, The format conversion system can automatically convert the file imported by the user into the target file, and the user does not need to operate, which reduces the operation cost, improves the accuracy of the file format conversion, improves the reliability of the software in the process of software interaction, and solves the present problem. In the technology, the user and the user interact with each other in the process of using the software, and the user is prone to writing errors, resulting in poor reliability of the software.

DRAWINGS

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, a brief description of the drawings used in the embodiments or the prior art description will be briefly described below. Obviously, the drawings in the following description It is a certain embodiment of the present application, and other drawings can be obtained according to the drawings without any creative labor for those skilled in the art.

FIG. 1 is a flowchart of Embodiment 1 of a format conversion method according to an embodiment of the present application;

FIG. 2 is a flowchart of Embodiment 2 of a format conversion method according to an embodiment of the present disclosure;

FIG. 3 is a flowchart of Embodiment 3 of a format conversion method according to an embodiment of the present disclosure;

FIG. 4 is a schematic structural diagram of Embodiment 1 of a format conversion system according to an embodiment of the present disclosure;

FIG. 5 is a schematic structural diagram of Embodiment 2 of a format conversion system according to an embodiment of the present disclosure.

detailed description

The technical solutions in the embodiments of the present application are clearly and completely described in the following with reference to the accompanying drawings in the embodiments of the present application. It is a part of the embodiments of the present application, and not all of the embodiments. based on All other embodiments obtained by those skilled in the art without any inventive work are within the scope of the present application.

Embodiment 1

FIG. 1 is a flowchart of Embodiment 1 of a format conversion method according to an embodiment of the present disclosure. As shown in FIG. 1 , the format conversion method in this embodiment may include the following steps:

101. Identify the file format of the imported import file.

When using the computer, the user saves files in various file formats, such as excel files, word files, PPT files, etc. Therefore, in the format conversion process, it is preferred to set the file format of the file, which is implemented in the present application. In the example, the file format is excel, for example, in the actual application, other file formats can also be set.

It should be noted that, in the embodiment of the present application, the format conversion method is applied to the format conversion system, and the language used in writing the format conversion system is the high-level programming language C#. In practical applications, it is not limited to using advanced programming. In the language C#, you can also use other languages to write a format conversion system.

In the embodiment of the present application, in the format conversion system, the file format conversion is performed on the file format excel. Therefore, it is preferred to identify whether the file format of the import file imported by the user is the excel format.

102. If the file format of the imported file matches the preset file format, parse the imported file.

After the user imports the file, the format conversion system automatically recognizes the imported file. When the imported file format matches the preset file format, it can be determined that the format conversion system can start parsing the imported file when importing. If the file format does not match the default file format, the format conversion system may prompt the user to import the file with the wrong file format. Please check the file.

In the embodiment of the present application, in the process of parsing the import file, the cross-platform class library can be used to parse the import file, for example, using an ExcelDataReader (data processing class library) to parse the import file.

103. Generate a target file by using the parsed data according to a preset target file generation manner.

In the embodiment of the present application, the target file generation mode may be preset, and the target file generation mode may be set according to the needs of the user, so as to achieve the purpose of facilitating interaction between the users. For example, using the multithreading technology of the high-level programming language C#, create at least one task, each task is one The target file generation method, and each target file generation method can be used by different users.

Then, the data generated by parsing the imported excel file is generated according to a preset target generation manner, and the target file may be directly sent to the computer where the user is located, or may be stored in the computer where the format conversion system is located. In read-only memory.

It should be noted that, in the embodiment of the present application, the format conversion system may be a single system software, or may be integrated into other software.

The format conversion method provided by the embodiment of the present application analyzes the import file imported by the user by using the format conversion system, and then generates the target file according to the target file generation manner preset in the format conversion system. Therefore, in the present application, In the technical solution, in the conversion process of the file format, the format conversion system can automatically convert the file imported by the user into the target file, the user does not need to perform operations, the operation cost is reduced, the accuracy of the file format conversion is improved, and the software interaction is performed. In the process, the reliability of the software is improved, and the problem that the user and the user interact with the software in the prior art, the user is prone to writing errors, and the reliability of the software is poor.

Embodiment 2

FIG. 2 is a flowchart of a second embodiment of a format conversion method according to an embodiment of the present disclosure. As shown in FIG. 2, the format conversion method in this embodiment may include the following steps:

201. Receive an import file imported by a user.

When a user needs to format a file, he first needs to import the file into the format conversion system. For example, import the file into the format conversion system at the specified port, and then the format conversion system receives the user by using the specified port. Imported import file.

202. Identify the file format of the imported import file.

203. Determine whether the file format of the imported file matches the preset file format. If yes, go to step 204. If not, go to step 205.

204. Parse the import file, and perform step 206.

Specifically, in the embodiment of the present application, if the file format of the imported file matches the preset file format, it is determined whether the content of the imported file is complete. If the content of the imported file is complete, the import file is parsed according to the target file generation manner. .

It can be understood that, in order to ensure that the format conversion result is the same as the conversion result expected by the user, the content integrity of the imported file needs to be judged, and when the content of the imported file is incomplete, the prompt may be prompted. The user import file is incorrect, the user needs to re-import, or the format conversion system will stop running. If the content of the imported file is complete, the import file is parsed according to the target file generation method.

For example, the default file format is an EXCEL file, and the file has a table with the message name, message length, message sender, and message receiver four list headers, and the contents of the imported file are complete. The user imports a table with the file format EXCEL. As shown in Table 1, the table has the message name, message length, message sender, and message receiver four list headers, and can detect the file format imported by the user and the preset. The file format is matched and the content is complete. Then, the import file is parsed according to the target file generation mode.

消息名称Message name	消息长度Message length	消息发送方Message sender	消息接收方Message receiver
……......	……......	……......	……......
……......	……......	……......	……......
……......	……......	……......	……......

Table 1

205. The format of the import file that the user is prompted to import is incorrect.

For example, the default file format is an EXCEL file. If a user imports a file with a file format of WORD, the user is prompted to import the imported file in the wrong format.

206. Generate a target file by using the parsed data according to a preset target file generation manner.

The format conversion method provided by the embodiment of the present application firstly receives the import file imported by the user by using the format conversion system, and confirms whether the format of the imported file matches the preset format, and parses the import file imported by the user after determining the format matching. And then generating the target file according to the target file generation manner preset in the format conversion system. Therefore, in the technical solution of the present application, the format conversion system can automatically import the file imported by the user in the file format conversion process. Converting to the target file, the user does not need to operate, reduces the operation cost, improves the accuracy of the file format conversion, improves the reliability of the software in the process of software interaction, and solves the problem that the user and the user in the prior art use the software. During the interaction process, the user is prone to writing errors, resulting in poor software reliability.

Embodiment 3

FIG. 3 is a flowchart of a third embodiment of a format conversion method according to an embodiment of the present disclosure. As shown in FIG. 3, the format conversion method in this embodiment may include the following steps:

301. Receive an import file imported by a user.

302. Identify the file format of the imported import file.

303. Store the import file in a read-only memory.

In the embodiment of the present application, after the user imports the import file, if the user does not need to immediately convert the format of the import file, the user may store the file in the read-only memory. If the user needs to perform format conversion on multiple import files, the user can store multiple import files in the read-only memory after importing all the imported files. When the user needs to format the multiple imported files, the format is The conversion system can retrieve the format file from the read-only memory.

304. Determine whether the file format of the imported import file matches the preset file format. If yes, go to step 305. If not, go to step 306.

305. Parse the import file, and perform step 307.

In the embodiment of the present application, based on the step 204 in the foregoing Embodiment 2, the method may include:

Extract data from a specified location in the import file;

Specifically, in the embodiment of the present application, the EXCEL file is taken as an example in a preset file format, and the specified location may be a header of each column in the table of the EXCEL file, as shown in Table 2.

消息名称Message name	消息长度Message length	消息发送方Message sender	消息接收方Message receiver
11	1616	001001	002002
22	3232	002002	003003
33	4848	003003	004004

Table 2

For example, if the table has a message name, a message length, a message sender, and a message receiver four list header, there are four specified positions in the table, namely, a message name, a message length, a message sender, and a message receiver. Then, the data of each column of the specified position in each row of data is sequentially extracted, for example, the first row data is extracted as 1, 16, 001, 002.

Then, the specified format is: message name_message length_message sender_message receiver, and then each row of data extracted in the table is sequentially adjusted to the specified format data, for example, the first format specified format data is 1_16_001_002 .

It should be noted that, in the embodiment of the present application, there may be multiple designated locations, which are set according to a specific target file generation manner, and the corresponding specified format may also be multiple. In the example, only one of the object file generation methods is described. In practical applications, it is not limited to the target file generation method.

306. The format of the import file that the user is prompted to import is incorrect.

307. Generate a target file by using the parsed data according to a preset target file generation manner.

Generate a database file from a portion of the specified format data according to the way the database file is generated; and,

According to the source code file generation method, another part of the specified format data is generated into a source code file.

Specifically, in the embodiment of the present application, the preset target file production manner includes two types, one is a database file generation manner, and the other is a source code file generation manner, and each target file generation format corresponds to one target file. . The object file corresponding to the database file generation mode is the file name suffix of the .DBC object file, and the source code file generation mode corresponds to the file name with the suffix of .c or .h.

According to the preset target file generation manner, the specified format data generated after parsing in step 305 is edited to generate a corresponding target file. For example, a regular expression is used to edit a part of the specified format data generated after parsing, and the file name is XXX.c object file.

Embodiment 4

FIG. 4 is a schematic structural diagram of Embodiment 1 of a format conversion system according to an embodiment of the present disclosure. As shown in FIG. 4, the format conversion system of this embodiment may include: an identification module 11, a parsing module 12, and a generating module.

The identification module 11 is configured to identify a file format of the imported import file.

The parsing module 12 is configured to parse the imported file if the file format of the imported file identified by the identification module 11 matches the preset file format.

The generating module 13 is configured to generate an object file by parsing the parsed data of the parsing module 12 according to a preset target file generating manner.

The system of the present embodiment can be used to implement the technical solution of the method embodiment shown in FIG. 1 , and the implementation principle and technical effects are similar, and details are not described herein again.

Embodiment 5

FIG. 5 is a schematic structural diagram of Embodiment 2 of a format conversion system according to an embodiment of the present disclosure. As shown in FIG. 5, the format conversion system of this embodiment may further include: a receiving module 14 on the basis of Embodiment 4.

The receiving module 14 is configured to receive an import file imported by the user.

Specifically, the parsing module 12 is specifically configured to:

If the content of the imported file is complete, the import file is parsed according to the target file generation method.

The system of the present embodiment can be used to implement the technical solution of the method embodiment shown in FIG. 2, and the implementation principle and technical effects are similar, and details are not described herein again.

Embodiment 5

The format conversion system of this embodiment is based on the fifth embodiment, and the parsing module 12 is specifically configured to:

Extract data from a specified location in the import file;

The generating module 13 is specifically configured to:

The system of the present embodiment can be used to implement the technical solution of the method embodiment shown in FIG. 3, and the implementation principle and technical effects are similar, and details are not described herein again.

One of ordinary skill in the art will appreciate that all or part of the steps to implement the various method embodiments described above may be accomplished by hardware associated with the program instructions. The aforementioned program can be stored in a computer readable storage medium. The program, when executed, performs the steps including the foregoing method embodiments; and the foregoing storage medium includes various media that can store program codes, such as a ROM, a RAM, a magnetic disk, or an optical disk.

The device embodiments described above are merely illustrative, wherein the units illustrated as separate components may or may not be physically separate, and the components displayed as units may or may not be physical units, ie may be located in one place. Or it can be distributed to at least two network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the embodiment. Those of ordinary skill in the art can understand and implement without deliberate labor.

Finally, it should be noted that the above embodiments are only for explaining the technical solutions of the present application, and are not limited thereto; although the present application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that The technical solutions described in the foregoing embodiments may be modified, or some or all of the technical features may be equivalently replaced; and the modifications or substitutions do not deviate from the technical solutions of the embodiments of the present application. range.

Claims

A format conversion method, comprising:

Identify the file format of the imported import file;

If the file format of the imported file matches the preset file format, parsing the imported file;

The parsed data is generated into a target file according to a preset target file generation method.
The method according to claim 1, wherein before the identifying the file format of the imported import file, the method further comprises:

Receiving the import file imported by the user.
The method according to claim 1, wherein if the file format of the import file matches a preset file format, parsing the import file includes:

If the file format of the imported file matches the preset file format, determine whether the content of the imported file is complete;

If the content of the import file is complete, the import file is parsed according to the target file generation manner.
The method according to claim 3, wherein if the content of the import file is complete, the import file is parsed according to the target file generating manner, including:

Extracting data of a specified location in the import file;

The extracted data is adjusted according to the specified format to obtain the specified format data.
The method according to claim 4, wherein the parsed data is generated into an object file according to a preset target file generation manner, including:

Generating a database file from a portion of the specified format data according to a database file generation manner;

According to the source code file generation method, another part of the specified format data is generated to generate a source code file.
A format conversion system, comprising:

An identification module for identifying a file format of the imported import file;

a parsing module, configured to parse the import file if the file format of the import file matches a preset file format;

a generation module for generating the parsed data according to a preset target file generation manner Standard file.
The system of claim 6 wherein the system further comprises:

a receiving module, configured to receive the import file imported by a user.
The system according to claim 6, wherein the parsing module is specifically configured to:

If the file format of the imported file matches the preset file format, determine whether the content of the imported file is complete;

If the content of the import file is complete, the import file is parsed according to the target file generation manner.
The system according to claim 8, wherein the parsing module is specifically configured to:

Extracting data of a specified location in the import file;

The extracted data is adjusted according to the specified format to obtain the specified format data.
The system according to claim 9, wherein the generating module is specifically configured to:

Generating a database file from a portion of the specified format data according to a database file generation manner;

According to the source code file generation method, another part of the specified format data is generated to generate a source code file.