CN112149396B - Information processing method and device based on IO points - Google Patents
Information processing method and device based on IO points Download PDFInfo
- Publication number
- CN112149396B CN112149396B CN202011055397.6A CN202011055397A CN112149396B CN 112149396 B CN112149396 B CN 112149396B CN 202011055397 A CN202011055397 A CN 202011055397A CN 112149396 B CN112149396 B CN 112149396B
- Authority
- CN
- China
- Prior art keywords
- basic information
- information table
- target
- data
- scheme
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 230000010365 information processing Effects 0.000 title claims abstract description 25
- 238000003672 processing method Methods 0.000 title claims abstract description 17
- 238000013461 design Methods 0.000 claims abstract description 45
- 238000012545 processing Methods 0.000 claims abstract description 24
- 238000000034 method Methods 0.000 claims description 27
- 238000001914 filtration Methods 0.000 claims description 12
- 238000012986 modification Methods 0.000 claims description 4
- 230000004048 modification Effects 0.000 claims description 4
- 238000006243 chemical reaction Methods 0.000 claims description 3
- 238000000605 extraction Methods 0.000 abstract description 9
- 238000004904 shortening Methods 0.000 abstract description 7
- 238000012544 monitoring process Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 2
- 230000002035 prolonged effect Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/31—Indexing; Data structures therefor; Storage structures
- G06F16/313—Selection or weighting of terms for indexing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Programmable Controllers (AREA)
Abstract
The invention provides an information processing method and device based on IO points, which are characterized in that a basic information table is obtained, scheme configuration is carried out according to key column logic conditions and a target table format, a scheme corresponding to the type of the basic information table is obtained, and the scheme is stored; loading a basic information table based on the basic information table type to generate a target basic information table; and carrying out data processing on the generated target basic information tables of different types, and outputting the IO configuration table in the standard data format. In the scheme, a configuration scheme is established, corresponding basic information tables are loaded in batches according to types in the subsequent information extraction process, target basic information table information is processed, and the IO configuration table in a standard data format required by engineering is finally exported once. Therefore, the problems caused by manual operation are avoided, and the purposes of improving the quality and efficiency of the integrated design of the control system and greatly shortening the implementation time of the control system project are realized.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to an information processing method and apparatus based on Input Output (IO) points.
Background
In the control system, the IO point specifically refers to an input/output point of the control system, wherein the input of the control system refers to a measured parameter entering the control system from an instrument, the output of the control system refers to a parameter output from the control system to an executing mechanism, and one parameter can be used as a point. The scale of the control system is generally related to the number of IO points.
At present, in the process of designing a control system, information of the required control system can be extracted based on IO points, and information extraction work based on the IO points is mainly carried out by repeatedly copying and pasting manually, so that information provided by a user is extracted to an EXCEL form for reference of technicians. However, the repeated copying and pasting operations are performed manually, so that operation errors are likely to occur, the quality and efficiency of the designed control system are reduced, and the design time of the control system is greatly prolonged.
Disclosure of Invention
In view of this, the embodiment of the invention provides an information processing method and device based on IO points, so as to achieve the purposes of improving the quality and efficiency of a design control system and greatly shortening the design time given by the control system.
In order to achieve the above object, the embodiment of the present invention provides the following technical solutions:
An information processing method based on input/output (IO) points, the method comprising:
Obtaining a basic information table, carrying out scheme configuration according to key column logic conditions and a target table format, obtaining a scheme corresponding to the type of the basic information table, and storing the scheme;
loading the basic information table based on the basic information table type to generate a target basic information table;
and carrying out data processing on the generated target basic information tables of different types, and outputting the IO configuration table in the standard data format.
Optionally, the obtaining the basic information table, and performing scheme configuration according to the key column logic condition and the target table format to obtain a scheme corresponding to the type of the basic information table, and storing the scheme, including:
acquiring text information of project data, wherein the types of the projects comprise industries and design departments;
acquiring a data information table of each data type;
Converting the text information based on a preset basic information table, and generating a basic information table by combining the data information tables of all the data types;
configuring a row of row bit numbers meeting key column conditions in the basic information table;
And configuring the basic information table based on the line where the bit number is located and the basic information table, converting the lines or cells in the basic information table into the lines or cells in the target table format, obtaining a scheme corresponding to the type of the basic information table, and storing the scheme.
Optionally, the loading the basic information table based on the type of the data recorded in the basic information table to generate different types of target basic information tables includes:
selecting a basic information table of a corresponding type based on the basic information table type, and loading the basic information table;
selecting a corresponding data type table from the loaded basic information table;
and generating a corresponding target basic information table according to each data type table.
Optionally, the generating target basic information table of different types performs data processing, and outputs an IO configuration table in a standard data format, including:
Displaying the data in the called target basic information tables of different types in a list form;
comparing the data in different target basic information tables to obtain difference data among the target basic information tables, and deriving a difference table generated based on the difference data;
Counting the number of modified bit number information in the IO list of the design institute;
modifying the bit number information in the IO list of the design institute based on the bit number information in the difference table to obtain a modified IO configuration table;
And converting the IO configuration table into a standard data format and outputting the standard data format.
Optionally, before displaying the data in the called different types of target basic information tables in list form, the method further comprises:
And filtering the reset numbers in the target basic information tables of different types to obtain a filtered target basic information table.
An information processing apparatus based on input-output IO points, the apparatus comprising:
the configuration module is used for acquiring a basic information table, carrying out scheme configuration according to key column logic conditions and a target table format, acquiring a scheme corresponding to the type of the basic information table, and storing the scheme;
The generating module is used for loading the basic information table based on the basic information table type and generating a target basic information table;
And the processing module is used for carrying out data processing on the generated target basic information tables of different types and outputting the IO configuration table in the standard data format.
Optionally, the configuration module includes:
The system comprises an acquisition unit, a storage unit and a display unit, wherein the acquisition unit is used for acquiring text information of project data, and the types of the projects comprise industries and design courts; acquiring a data information table of each data type;
the conversion unit is used for converting the text information based on a preset basic information table and generating a basic information table by combining the data information tables of the data types;
The configuration unit is used for configuring a row of the row bit number meeting the key column condition in the basic information table, configuring the basic information table based on the row of the bit number and the basic information table, converting the rows or the cells in the basic information table into the rows or the cells in the target table format, obtaining a scheme corresponding to the type of the basic information table, and storing the scheme.
Optionally, the generating module includes:
The selection unit is used for selecting a basic information table of a corresponding type based on the basic information table type and loading the basic information table; selecting a corresponding data type table from the loaded basic information table;
and the generating unit is used for generating a corresponding target basic information table according to each data type table.
Optionally, the processing module includes:
The display unit is used for displaying the data in the called different types of target basic information tables in a list form;
the comparison unit is used for comparing the data in different target basic information tables to obtain difference data among the target basic information tables, and deriving a difference table generated based on the difference data;
The statistics unit is used for counting the number of the modified bit number information in the IO list of the design institute;
the modification unit is used for modifying the bit number information in the IO list of the design institute based on the bit number information in the difference table to obtain a modified IO configuration table;
and the output unit is used for converting the IO configuration table into a standard data format and outputting the standard data format.
Optionally, the processing module further includes:
And the filtering unit is used for filtering the repeated numbers in the target basic information tables of different types to obtain a filtered target basic information table.
Based on the information processing method and device based on the input/output IO points provided by the embodiment of the invention, the basic information table is obtained, the scheme configuration is carried out according to the key column logic condition and the target table format, the scheme corresponding to the type of the basic information table is obtained and stored, and the basic information table is loaded based on the type of the basic information table to generate the target basic information table; and carrying out data processing on the generated target basic information tables of different types, and outputting the IO configuration table in the standard data format. In the scheme, through establishing different configuration schemes, loading corresponding basic information tables in batches according to types in the subsequent information extraction process, processing target basic information table information, and finally exporting the IO configuration table in the standard data format required by the engineering for the last time. Therefore, the problems caused by manual operation are avoided, and the purposes of improving the quality and efficiency of the integrated design of the design control system and greatly shortening the implementation time of the control system project are realized.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are required to be used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only embodiments of the present invention, and that other drawings can be obtained according to the provided drawings without inventive effort for a person skilled in the art.
Fig. 1 is a schematic flow chart of an information processing method based on IO points according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of a method for creating a target basic information table according to an embodiment of the present invention;
FIG. 3 is a schematic flow chart of data processing for information in different information tables according to an embodiment of the present invention;
FIG. 4 is a schematic flow chart of another information processing method based on IO points according to an embodiment of the present invention;
Fig. 5 is a schematic structural diagram of an information processing device based on IO points according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
In the present disclosure, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
As known from the background art, in the process of designing a control system, the information extraction based on the IO points is repeated and pasted by manpower for a plurality of times, so that misoperation is likely to occur, the quality and efficiency of the design control system are reduced, and the design time of the control system is greatly prolonged.
Therefore, the embodiment of the invention discloses an information processing scheme based on IO points, which is characterized in that different configuration schemes are established, corresponding basic information tables are loaded in batches according to types in the subsequent information extraction process, target basic information table information is processed, and the IO configuration table in a standard data format required by engineering is finally exported once. Therefore, the problems caused by manual operation are avoided, and the purposes of improving the quality and efficiency of the integrated design of the design control system and greatly shortening the implementation time of the control system project are realized. The specific implementation is illustrated in detail by the following examples.
Fig. 1 is a schematic flow chart of an information processing method based on IO points according to an embodiment of the present invention. The information processing method based on the IO point comprises the following steps:
Step S101: and obtaining a basic information table, carrying out scheme configuration according to the key column logic conditions and the target table format, obtaining a scheme corresponding to the type of the basic information table, and storing the scheme.
In step S101, the data described in the basic information table includes an item and input data. But is not limited thereto.
Wherein, the items can be classified into industry and design institute according to types. The input data can be divided into an IO list, a cable list, an instrument index list and a data monitoring list according to types.
The above basic information table, items, and types of input data are merely examples, and the embodiments of the present invention are not limited thereto.
The process of step S101 is specifically implemented, as shown in fig. 2, including the following steps:
Step S201: text information of project data is acquired.
In step S201, the types of the items include industry and design institute based on the above examples.
Step S202: a data information table of each data type is obtained.
In step S202, the data information table of each data type includes a table corresponding to each type of data of the input data.
Based on the above examples, the data information table of each data type includes a design institute IO list, a cable table, an instrument index table, and a data monitoring table.
Step S203: and converting the text information based on a preset basic information table, and combining the information tables of the information types to generate a basic information table.
In the specific implementation of step S203, first, the obtained text information of each item data is converted according to the row-column and cell formats of the basic information table, so as to obtain the item basic information table storing the text information in a tabular manner. And combining the project basic information table with the acquired data information tables of all data types to obtain a basic information table.
Step S204: and configuring the row of the row bit numbers meeting the key column condition in the basic information table.
In the specific implementation process of step S204, a row satisfying the key column condition in the basic information table is determined, and a bit number is configured for the determined row according to the key column condition.
Step S205: and configuring the basic information table based on the line where the bit number is located and the basic information table, converting the lines or cells in the basic information table into the lines or cells in the target table format, obtaining a scheme corresponding to the type of the basic information table, and storing the scheme.
In the specific implementation process of step S205, each item of information recorded in the row configured with the bit number in the basic information table is determined, each item of determined information is extracted according to the type of the information, each item of information corresponds to each row or unit in the basic information table and is converted into each row or unit in the target basic information table, and a scheme with the same type as the type of the basic information table is obtained and stored.
Based on the executing process, finally, the basic information table stores the information table of each information type stored according to the basic table information format, each information type corresponds to an information table storing the information, and the information table at least comprises a design institute IO list.
The scheme configuration is performed by executing the step S101, and the type of the finally obtained scheme is the same as the type of the basic information table. For example, if the basic information table is a design institute IO list, the above step S101 is executed to perform the scheme configuration, so as to obtain a scheme of the design institute IO list type.
Step S102: and loading the basic information table based on the basic information table type to generate a target basic information table.
In the process of implementing step S102, first, the type of data required for the current project is determined, and based on the type of data required and the type of the basic information table, the basic information table of the corresponding type is selected for loading.
The basic information table is loaded, that is, the execution of step S102 specifically uses a scheme corresponding to the type of the basic information table.
It should be noted that, the loading manner generally adopts a manner of loading an excel file to load the basic information table.
And selecting a corresponding data type table from the loaded basic information table based on the current required data type.
It should be noted that, the selection manner is not limited in the embodiment of the present invention, and the corresponding data type table may be selected according to a default configuration scheme, or the required data type table may be manually selected according to a requirement, or the corresponding configuration scheme may be selected according to an existing file name displayed by the front-end device.
And finally, calling the selected data type table according to the current required data type, and generating a corresponding target basic information table.
It should be noted that, the selected data type table may be called in a multi-file extraction manner, or may be called according to different configuration schemes.
Step S103: and carrying out data processing on the generated target basic information tables of different types, and outputting the IO configuration table in the standard data format.
The process of implementing step S103 is shown in fig. 3, and mainly includes the following steps:
step S301: the data in the called different types of target basic information tables are displayed in a list form.
In the process of implementing step S301, the data in the called different profile information tables are displayed on the front-end device in list form. If there is a null column in the list, the whole null column is automatically hidden.
Step S302: and comparing the data in different target basic information tables to obtain difference data among the target basic information tables, and deriving a difference table generated based on the difference data.
In the specific implementation process of step S301, the target basic information table for comparison is a data information table storing the same kind of information. The data information tables such as the design institute IO list, the cable table, the instrument index table and the data monitoring table are combined. Wherein, the design institute IO list stores cable related information and data monitoring related information. The cable table stores meter related information and data monitoring related information.
Comparing the design institute IO list with the cable list; comparing the design institute IO list with a data monitoring table; comparing the cable table with an instrument index table; the cable table is compared to the data monitoring table. And obtaining difference data among the data information tables, and deriving a difference table generated based on the difference data.
Step S303: and counting the number of the modified bit number information in the IO list of the design institute.
Step S304: and modifying the bit number information in the IO list of the design institute based on the bit number information in the difference table to obtain a modified IO configuration table.
Step S305: and converting the IO configuration table into a standard data format and outputting the standard data format.
According to the information processing method based on the IO points, different configuration schemes are established, corresponding basic information tables are loaded in batches according to types in the subsequent information extraction process, target basic information table information is processed, and the IO configuration table in a standard data format required by engineering is finally exported once. Therefore, the problems caused by manual operation are avoided, and the purposes of improving the quality and efficiency of the integrated design of the design control system and greatly shortening the implementation time of the control system project are realized.
Fig. 4 is a schematic flow chart of another information processing method based on IO points according to an embodiment of the present invention. The information processing method based on the IO point comprises the following steps:
Step S401: and acquiring a basic information table, configuring a scheme according to key column logic conditions and a target table format, and storing the basic information table according to types.
Step S402: and loading the basic information table based on the type of the data recorded in the basic information table, and generating target basic information tables of different types.
It should be noted that, the execution principle and process of the step S401 and the step S402 are the same as those of the step S101 and the step S102 disclosed in fig. 1, and reference is made to the above description of fig. 1, and no further description is given here.
Step S403: and filtering the reset numbers in the target basic information tables of different types to obtain a filtered target basic information table.
In the specific implementation process of step S403, it is detected whether repeated bit numbers exist in different target basic information tables, if so, whether filtering is performed is prompted, and if filtering is determined, filtering processing is performed on repeated bit numbers in different target basic information tables, so as to obtain a filtered target basic information table.
Step S404: the data in the called different types of target basic information tables are displayed in a list form.
Step S405: and comparing the data in different target basic information tables to obtain difference data among the target basic information tables, and deriving a difference table generated based on the difference data.
Step S406: and counting the number of the modified bit number information in the IO list of the design institute.
Step S407: and modifying the bit number information in the IO list of the design institute based on the bit number information in the difference table to obtain a modified IO configuration table.
Step S408: and converting the IO configuration table into a standard data format and outputting the standard data format.
It should be noted that, the execution principle and process of step S404 to step S408 are the same as that of step S301 to step S305 disclosed in fig. 3, and reference is made to the above description of fig. 3, and no further description is given here.
According to the information processing method based on the IO points, different configuration schemes are established, corresponding basic information tables are loaded in batches according to types in the subsequent information extraction process, target basic information table information is processed, and the IO configuration table in a standard data format required by engineering is finally exported once. Therefore, the problems caused by manual operation are avoided, and the purposes of improving the quality and efficiency of the integrated design of the design control system and greatly shortening the implementation time of the control system project are realized.
Based on the information processing method based on the IO point disclosed in the embodiment of the invention, the embodiment of the invention correspondingly discloses an information processing device based on the IO point.
Fig. 5 is a schematic structural diagram of an information processing device based on IO points according to an embodiment of the present invention. The information processing device based on IO points mainly comprises: configuration module 501, invocation module 502, and processing module 503.
The configuration module 501 is configured to obtain a basic information table, perform scheme configuration according to the key column logic condition and the target table format, obtain a scheme corresponding to the type of the basic information table, and store the scheme.
The basic information table stores text information stored according to a basic table information format, the text information at least comprises unit information and information of each data type, and each data type corresponds to a data information table for storing the data.
The generating module 502 is configured to load the basic information table based on the basic information table type, and generate a target basic information table.
And the processing module 503 is configured to perform data processing on the generated target basic information tables of different types, and output an IO configuration table in a standard data format.
The configuration module 501 specifically includes:
The system comprises an acquisition unit, a storage unit and a display unit, wherein the acquisition unit is used for acquiring text information of project data, and the types of the projects comprise industries and design courts; and obtaining a data information table of each data type.
And the conversion unit is used for converting the text information based on a preset basic information table and generating a basic information table by combining the data information tables of the data types.
The configuration unit is used for configuring a row of the row bit number meeting the key column condition in the basic information table, configuring the basic information table based on the row of the bit number and the basic information table, converting the rows or the cells in the basic information table into the rows or the cells in the target table format, obtaining a scheme corresponding to the type of the basic information table, and storing the scheme.
The generating module 502 specifically includes:
The selection unit is used for selecting a basic information table of a corresponding type based on the type of the data recorded in the basic information table and loading the basic information table; and selecting the corresponding data type table from the loaded different basic information tables.
And the generating unit is used for generating different types of target basic information tables according to the data type tables.
The processing module 503 specifically includes:
The display unit is used for displaying the data in the called different types of target basic information tables in a list form;
the comparison unit is used for comparing the data in different target basic information tables to obtain difference data among the target basic information tables, and deriving a difference table generated based on the difference data;
The statistics unit is used for counting the number of the modified bit number information in the IO list of the design institute;
the modification unit is used for modifying the bit number information in the IO list of the design institute based on the bit number information in the difference table to obtain a modified IO configuration table;
and the output unit is used for converting the IO configuration table into a standard data format and outputting the standard data format.
Further, the processing module 503 further includes:
And the filtering unit is used for filtering the repeated numbers in the target basic information tables of different types to obtain a filtered target basic information table.
In the information processing device based on the IO point disclosed by the embodiment of the invention, different configuration schemes are established through the configuration module, corresponding basic information tables are loaded in batches according to types by the generation module in the subsequent information extraction process, different types of target basic information tables are generated, the processing module processes the target basic information table information, and finally the IO configuration table in the standard data format required by engineering is exported once. Therefore, the problems caused by manual operation are avoided, and the purposes of improving the quality and efficiency of the integrated design of the design control system and greatly shortening the implementation time of the control system project are realized.
Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are example forms of implementing the claims.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (8)
1. An information processing method based on input/output IO points is characterized by comprising the following steps:
Obtaining a basic information table, carrying out scheme configuration according to key column logic conditions and a target table format, converting rows and columns in the basic information table into rows and columns in the target table format or converting cells in the basic information table into cells in the target table format, obtaining a scheme corresponding to the type of the basic information table, and storing the scheme;
loading a scheme of the basic information table based on the basic information table type to generate a target basic information table;
performing data processing on the generated target basic information tables of different types, and outputting an IO configuration table in a standard data format;
the data processing is carried out on the generated target basic information tables of different types, and an IO configuration table with a standard data format is output, and the method comprises the following steps:
Displaying the data in the called target basic information tables of different types in a list form;
comparing the data in different target basic information tables to obtain difference data among the target basic information tables, and deriving a difference table generated based on the difference data;
counting the number of modified bit number information in a design institute IO list contained in the basic information table;
modifying the bit number information in the IO list of the design institute based on the bit number information in the difference table to obtain a modified IO configuration table;
And converting the IO configuration table into a standard data format and outputting the standard data format.
2. The method according to claim 1, wherein the obtaining the basic information table, performing scheme configuration according to the key column logic condition and the target table format, converting the rows and columns in the basic information table into the rows and columns in the target table format or converting the cells in the basic information table into the cells in the target table format, obtaining a scheme corresponding to the basic information table type, and storing, includes:
acquiring text information of project data, wherein the types of the projects comprise industries and design departments;
acquiring a data information table of each data type;
Converting the text information based on a preset basic information table, and generating a basic information table by combining the data information tables of all the data types;
configuring a row of row bit numbers meeting key column conditions in the basic information table;
And configuring the basic information table based on the row where the bit number is located and the basic information table, converting the row and column in the basic information table into the row and column in the target table format or converting the cell in the basic information table into the cell in the target table format, obtaining a scheme corresponding to the type of the basic information table, and storing.
3. The method of claim 1, wherein loading the base information table based on the base information table type to generate a target base information table comprises:
Based on the basic information table type, selecting a scheme of a basic information table of a corresponding type, and loading the scheme;
selecting a corresponding data type table from the loaded basic information table;
and generating a corresponding target basic information table according to each data type table.
4. The method of claim 1, further comprising, prior to displaying the data in the called different types of target base information tables in list form:
And filtering the reset numbers in the target basic information tables of different types to obtain a filtered target basic information table.
5. An information processing apparatus based on input-output IO points, the apparatus comprising:
The configuration module is used for acquiring a basic information table, carrying out scheme configuration according to key column logic conditions and a target table format, converting rows and columns in the basic information table into rows and columns in the target table format or converting cells in the basic information table into cells in the target table format, obtaining a scheme corresponding to the type of the basic information table, and storing the scheme;
The generating module is used for loading the basic information table based on the basic information table type and generating a target basic information table;
The processing module is used for carrying out data processing on the generated target basic information tables of different types and outputting an IO configuration table in a standard data format;
The processing module comprises:
The display unit is used for displaying the data in the called different types of target basic information tables in a list form;
the comparison unit is used for comparing the data in different target basic information tables to obtain difference data among the target basic information tables, and deriving a difference table generated based on the difference data;
The statistics unit is used for counting the number of modified bit number information in the design institute IO list contained in the basic information table;
the modification unit is used for modifying the bit number information in the IO list of the design institute based on the bit number information in the difference table to obtain a modified IO configuration table;
and the output unit is used for converting the IO configuration table into a standard data format and outputting the standard data format.
6. The apparatus of claim 5, wherein the configuration module comprises:
The system comprises an acquisition unit, a storage unit and a display unit, wherein the acquisition unit is used for acquiring text information of project data, and the types of the projects comprise industries and design courts; acquiring a data information table of each data type;
the conversion unit is used for converting the text information based on a preset basic information table and generating a basic information table by combining the data information tables of the data types;
the configuration unit is used for configuring a row of the row bit number meeting the key column condition in the basic information table, configuring the basic information table based on the row of the bit number and the basic information table, converting the row and column in the basic information table into a row and column in a target table format or converting the cell in the basic information table into a cell in the target table format, obtaining a scheme corresponding to the type of the basic information table, and storing the scheme.
7. The apparatus of claim 5, wherein the generating module comprises:
the selection unit is used for selecting a scheme of the basic information table of the corresponding type based on the basic information table type and loading the scheme; selecting a corresponding data type table from the loaded basic information table;
and the generating unit is used for generating a corresponding target basic information table according to each data type table.
8. The apparatus of claim 5, wherein the processing module further comprises:
And the filtering unit is used for filtering the repeated numbers in the target basic information tables of different types to obtain a filtered target basic information table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011055397.6A CN112149396B (en) | 2020-09-29 | 2020-09-29 | Information processing method and device based on IO points |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011055397.6A CN112149396B (en) | 2020-09-29 | 2020-09-29 | Information processing method and device based on IO points |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112149396A CN112149396A (en) | 2020-12-29 |
| CN112149396B true CN112149396B (en) | 2024-05-03 |
Family
ID=73895221
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011055397.6A Active CN112149396B (en) | 2020-09-29 | 2020-09-29 | Information processing method and device based on IO points |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112149396B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20060033383A (en) * | 2004-10-15 | 2006-04-19 | 엘지전자 주식회사 | Making method for bill of material using visual basic |
| CN102722414A (en) * | 2012-05-22 | 2012-10-10 | 中国科学院计算技术研究所 | Input/output (I/O) resource management method for multi-root I/O virtualization sharing system |
| CN105589968A (en) * | 2015-12-25 | 2016-05-18 | 中国银联股份有限公司 | Data summarization system and method |
| CN109657816A (en) * | 2018-12-19 | 2019-04-19 | 云南电网有限责任公司昭通供电局 | A kind of online check method of substation equipment monitoring information table |
| CN110989515A (en) * | 2019-11-21 | 2020-04-10 | 杭州和利时自动化有限公司 | Configuration file generation method, device, equipment and readable storage medium |
-
2020
- 2020-09-29 CN CN202011055397.6A patent/CN112149396B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20060033383A (en) * | 2004-10-15 | 2006-04-19 | 엘지전자 주식회사 | Making method for bill of material using visual basic |
| CN102722414A (en) * | 2012-05-22 | 2012-10-10 | 中国科学院计算技术研究所 | Input/output (I/O) resource management method for multi-root I/O virtualization sharing system |
| CN105589968A (en) * | 2015-12-25 | 2016-05-18 | 中国银联股份有限公司 | Data summarization system and method |
| CN109657816A (en) * | 2018-12-19 | 2019-04-19 | 云南电网有限责任公司昭通供电局 | A kind of online check method of substation equipment monitoring information table |
| CN110989515A (en) * | 2019-11-21 | 2020-04-10 | 杭州和利时自动化有限公司 | Configuration file generation method, device, equipment and readable storage medium |
Non-Patent Citations (1)
| Title |
|---|
| PLC技术应用实训的教改探讨;张全庄, 冯德虎;现代技能开发(05);第60-61页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112149396A (en) | 2020-12-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| TWI582616B (en) | Formatting data by example | |
| CN109766384B (en) | Method and device for automatically converting data measurement units in visualization system | |
| CN112257993B (en) | Production recording method and recording device based on table | |
| CN110609989A (en) | Operation method for rapidly generating information form by adopting predefined layout component and application | |
| CN112149396B (en) | Information processing method and device based on IO points | |
| CN111078763B (en) | zTree-based tree structure asynchronous extraction method, terminal device and storage medium | |
| US8056073B2 (en) | Method, computer program product, and system for merging multiple same class instance states | |
| CN112465418B (en) | Material loading method and device based on product life cycle management | |
| CN115758950A (en) | Automatic drawing method, device and computer readable storage medium | |
| KR102099362B1 (en) | Device and method for a data preparation using a micro service | |
| JP6389947B1 (en) | Information processing system, information processing apparatus, and program | |
| CN112347219B (en) | Vector map material library generation method, vector map generation system and electronic equipment | |
| CN111178780A (en) | Operation and maintenance strategy setting method and device, storage medium and electronic equipment | |
| CN116610681B (en) | Data processing method, device, equipment and computer program for multidimensional table | |
| CN110851492B (en) | Method and system for rapidly analyzing mechanical environment test data | |
| CN112463534B (en) | Daily newspaper generating method, device, equipment and medium | |
| CN113407545B (en) | Drawing data storage method and device and electronic equipment | |
| US20240211650A1 (en) | Method and system for automatically generating and managing engineering drawings of customized stamping press machine | |
| CN101556624B (en) | Part dynamic generating system and method | |
| CN111026307B (en) | Method and device for quickly associating graphics primitives in graphics configuration tool | |
| CN117094296A (en) | VB language-based form splitting method, intelligent terminal and storage medium | |
| CN118310457A (en) | Aeroengine blade profile detection method and aeroengine blade profile detection system | |
| CN116860730A (en) | Data cleaning method and device, electronic equipment and storage medium | |
| CN114020738A (en) | Method and system for quickly generating OPC (optical proximity correction) test layout by result database and storage medium | |
| JP5507924B2 (en) | Information processing apparatus, information processing method, and program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |