CN116303461A - Component library creation method and device, electronic equipment and storage medium - Google Patents

Component library creation method and device, electronic equipment and storage medium Download PDF

Info

Publication number
CN116303461A
CN116303461A CN202310277324.9A CN202310277324A CN116303461A CN 116303461 A CN116303461 A CN 116303461A CN 202310277324 A CN202310277324 A CN 202310277324A CN 116303461 A CN116303461 A CN 116303461A
Authority
CN
China
Prior art keywords
attribute information
target
component
configuration file
component library
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310277324.9A
Other languages
Chinese (zh)
Inventor
凌思思
谢昆颖
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guangzhou Tech Long Packaging Machinery Co Ltd
Original Assignee
Guangzhou Tech Long Packaging Machinery Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Guangzhou Tech Long Packaging Machinery Co Ltd filed Critical Guangzhou Tech Long Packaging Machinery Co Ltd
Priority to CN202310277324.9A priority Critical patent/CN116303461A/en
Publication of CN116303461A publication Critical patent/CN116303461A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F30/00Computer-aided design [CAD]
    • G06F30/10Geometric CAD
    • G06F30/12Geometric CAD characterised by design entry means specially adapted for CAD, e.g. graphical user interfaces [GUI] specially adapted for CAD
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Geometry (AREA)
  • General Engineering & Computer Science (AREA)
  • Architecture (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Software Systems (AREA)
  • Human Computer Interaction (AREA)
  • Computational Mathematics (AREA)
  • Mathematical Analysis (AREA)
  • Mathematical Optimization (AREA)
  • Pure & Applied Mathematics (AREA)
  • Computer Hardware Design (AREA)
  • Evolutionary Computation (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a method, a device, an electronic device and a storage medium for creating a component library, which comprise the following steps: generating a first table according to attribute information of components in a component library to be created, wherein each column of the first table is used for writing fields and field values of the attribute information; generating a configuration file matched with the attribute information; deriving existing attribute information of a target component in the SAP system; based on the matching relation between the attribute information and the fields, correspondingly inputting the existing attribute information into a first table to obtain a second table; the missing attribute information of the target components is obtained and filled into the second table to obtain the target table, the target table comprising the complete attribute information of the target components can be obtained, the attribute information of each target component is imported into the component library of the EPLAN system through the configuration file, the creation of the component library can be completed, the gradual manual entry is not needed, the efficiency of creating the component library is improved, and errors are reduced.

Description

Component library creation method and device, electronic equipment and storage medium
Technical Field
The present invention relates to the field of component library creation technologies, and in particular, to a component library creation method, device, electronic apparatus, and storage medium.
Background
With the progress of the age, the electrical schematic diagram is drawn by using EPLAN software to improve drawing efficiency, perfect standardized design and become design habit of most large-scale equipment product designers. It is well known that the design schematic diagram is first selected, and drawing is not related to the components, so that the components need to be built into a special component library in the EPLAN to build the reference relation.
The creation of a library of conventional EPLAN components is typically created by the following method:
1. opening an EPLAN new construction, and then filling the codes, the part names, the part models, the part sizes into the associated symbols or macros and the like;
2. the method is realized by finding out the EPLAN component macro files of the component brands through the official networks of some component brands and importing the EPLAN component macro files into the component library of the EPLAN, but the method cannot synchronize SAP codes and cannot ensure that downloaded names and models are consistent with those of an SAP system, and the codes are also required to be checked one by one manually and filled in.
Because of the variety of components and the cumbersome content that needs to be filled, either method is extremely labor intensive for the operator and manual filling is prone to error.
Disclosure of Invention
The invention provides a method, a device, electronic equipment and a storage medium for creating a component library, which are used for solving the problems of large workload and easy error when the component library is created in an EPLAN system.
In a first aspect, the present invention provides a component library creation method, including:
generating a first table according to attribute information of components in a component library to be created, wherein each column of the first table is used for writing in a field and a field value of the attribute information;
generating a configuration file matched with the attribute information;
deriving existing attribute information of a target component in the SAP system;
based on the matching relation between the attribute information and the field, correspondingly inputting the existing attribute information into the first table to obtain a second table;
acquiring missing attribute information of the target component and filling the missing attribute information into the second table to obtain a target table;
a library of components is created in the EPLAN system based on the configuration file and the target table.
In a second aspect, the present invention provides a component library creation apparatus comprising:
the device comprises a first table generation module, a first storage module and a second storage module, wherein the first table generation module is used for generating a first table according to attribute information of components in a component library to be created, and each column of the first table is used for writing fields and field values of the attribute information;
the configuration file generation module is used for generating a configuration file matched with the attribute information;
a target component information deriving module for deriving existing attribute information of the target component in the SAP system;
the second table generation module is used for correspondingly inputting the existing attribute information into the first table based on the matching relation between the attribute information and the fields to obtain a second table;
the target table module is used for acquiring the missing attribute information of the target component and filling the missing attribute information into the second table to obtain a target table;
and the component library creation module is used for creating a component library in the EPLAN system based on the configuration file and the target table.
In a third aspect, the present invention provides an electronic device, including:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein,,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the component library creating method according to the first aspect of the present invention.
In a fourth aspect, the present invention provides a computer-readable storage medium storing computer instructions for causing a processor to execute the component library creating method according to the first aspect of the present invention.
The embodiment of the invention provides a method for creating a component library, which is used for generating a first table according to attribute information of components in the component library to be created, wherein each column of the first table is used for writing fields and field values of the attribute information; generating a configuration file matched with the attribute information; deriving existing attribute information of a target component in the SAP system; based on the matching relation between the attribute information and the fields, correspondingly inputting the existing attribute information into a first table to obtain a second table; acquiring missing attribute information of a target part and filling the missing attribute information into a second table to obtain a target table; a library of components is created in the EPLAN system based on the configuration file and the target table. The existing attribute information of the target components is derived from the SAP system, the missing attribute information is supplemented, the target table comprising the complete attribute information of the target components can be obtained, the attribute information of each target component is imported into the component library of the EPLAN system through the configuration file, the target components of the SAP system can be created in the component library of the EPLAN system without manual entry item by item, manual operation is greatly reduced, efficiency of creating the component library is improved, and errors caused by manual operation can be reduced.
It should be understood that the description in this section is not intended to identify key or critical features of the embodiments of the invention or to delineate the scope of the invention. Other features of the present invention will become apparent from the description that follows.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a method for creating a component library according to a first embodiment of the present invention;
FIG. 2 is a flowchart of a method for creating a component library according to a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of a component library creating apparatus according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of an electronic device according to a fourth embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
Example 1
Fig. 1 is a flowchart of a component library creating method according to a first embodiment of the present invention, where the method may be performed by a component library creating device, which may be implemented in hardware and/or software, and the component library creating device may be configured in an electronic device, where the method is applicable to a case of migrating information of a target component in an SAP system to a component library in an EPLAN system.
The SAP (System Applications and Products, system application program and product) is software of an enterprise management solution, and in this embodiment, the SAP system is used for storing and managing component information, which is typically entered by a component information manager of a company, and the component information includes a component number, a model number, and the like, and the EPLAN system is electrical design assisting software. The SAP system and the EPLAN system are two different types of systems that are independent of each other, and cannot directly perform data migration. On the other hand, since the parts used by each company and the information management rules (for example, naming rules) for the parts are different, even for the same part, the material numbers, model numbers, and the like of different companies may be different, and thus it is difficult to download a part library of the EPLAN system that matches the part information of the company from the internet.
As shown in fig. 1, the component library creation method includes:
s101, generating a first table according to attribute information of components in a component library to be created, wherein each column of the first table is used for writing fields and field values of the attribute information.
For a component library to be created by the EPLAN system, it is necessary to record attribute information of a component so as to be directly applicable to the EPLAN system when the component is called.
Illustratively, the attribute information of the component includes a component number, SAP number, model number, name, length, width, height, and macro, and the corresponding fields are PN, sapnr, model, name, length, width, height, macro, respectively. The above fields and field values are only examples, and the attribute information and fields of the component may be set according to actual requirements.
It should be noted that the attribute information corresponding to different components may be different, for example, for a cylindrical pull rod, the attribute information corresponding to the pull rod may include long and diameter, and not include both wide and high attribute information.
S102, generating a configuration file matched with the attribute information.
The configuration file, i.e. the file that performs different configurations for different objects, may configure parameters and initial settings for some computer programs. The configuration file in this embodiment is used to configure parameters for the component library of the EPLAN system. When generating the configuration file matched with the attribute information, a preset configuration file template can be set, and after the attribute information is obtained, the attribute information is automatically substituted into the configuration file template to obtain the required configuration file. Of course, a text adapted to the attribute information may be written manually from the attribute information, and then a configuration file may be generated using the text.
In an alternative embodiment, generating a profile adapted to the attribute information includes: and setting row content in the configuration file according to column content of the first table, so that each row of sentences in the configuration file is used for acquiring a field value corresponding to each field in the first table.
S103, the existing attribute information of the target component in the SAP system is derived.
The SAP system stores information of target parts of the company, a part list is derived from the SAP system according to a part list BOM of a selected order, the part list can be in a text format or a table format, and the part list mainly comprises information such as codes, names, models, brands of materials and the like, and the information is the existing attribute information of the target parts.
The information is the existing attribute information, and generally, the SAP system has a data export function, and a target component for creating component information in a component library is selected, exported and stored.
S104, based on the matching relation between the attribute information and the fields, the existing attribute information is correspondingly input into the first table to obtain a second table.
The matching relationship between the attribute information and the fields has been given before, so when the existing attribute information of the target component in the SAP system is exported to be in text format, the field corresponding to each existing attribute information can be determined, and the existing attribute information can be correspondingly input into the first table to obtain the second table. It should be noted that, the existing attribute information is specific text information, and the attribute information in the first table is corresponding to a field, so that the existing attribute information may be first matched with the field in the first table and then filled into the corresponding row and column.
Illustratively, based on the matching relationship between the attribute information and the field, the existing attribute information is correspondingly input into the first table to obtain a second table, which includes:
for each target component, determining a corresponding row of the target component in the first table as a target row; determining, for each existing attribute information, a column corresponding to the attribute information matching the existing attribute information in the first table as a target column; and filling the existing attribute information into the target row and the target column of the first table to obtain a second table.
Here, assuming that the attribute information of the target component derived from the SAP is first attribute information and the attribute information of the component derived from the EPLAN system is second attribute information, it is generally considered that the first attribute information is included in the second attribute information, that is, the first attribute information may be associated with the second attribute information, for example, the first attribute information includes length, width, and height, and the second attribute information includes length, width, height, and diameter. However, there may be a case where the text meaning is the same but the fields are inconsistent, for example, the first attribute information includes length, width, height, and diameter, the second attribute information includes depth, width, height, and diameter, and the "length" of the first attribute information corresponds to the "depth" of the second water attribute information, and then the second attribute information may be manually identified and then correspondingly filled into the second table; or, the fields of the attribute information of the target component derived by the SAP are modified to be matched with the attribute information of the component derived by the EPLAN system, so that the information matching degree can be improved, and the batch migration of data is facilitated.
S105, acquiring missing attribute information of the target part and filling the missing attribute information into the second table to obtain a target table.
On the one hand, the attribute information of the target component derived from the SAP system is not necessarily complete, and on the other hand, other attribute information may be required for the target component derived from the SAP system to call out the target component in the EPLAN system, where the attribute information is missing attribute information, and the missing attribute information is attribute information that is required when the target component is missing from the SAP system and is applied to the EPLAN system. If the attribute information is incomplete, an error or failure to call occurs when the EPLAN system calls the component.
It should be noted that, for different target components, the existing attribute information derived by the SAP may be some or all of the attribute information, and then there may be target components without missing attribute information in the first table.
For parts with different brands and different models, the sizes, the technical parameters, the function definition points, the connection point codes, the symbols and the like of the corresponding models are filled in batches in the second form, and the path can be copied into the corresponding column of the second form by downloading the EPLAN macro in the official network, finding the macro path and the path of the 3D diagram through the storage position.
Based on the matching relation between the attribute information and the fields, the existing attribute information is correspondingly input into the first table to obtain a second table. And acquiring missing attribute information of the target part and filling the missing attribute information into the second table to obtain the target table. In general, the existing attribute information and the missing attribute information of each target component are determined as field values of corresponding fields in the first table, so as to obtain a target table.
S106, creating a component library in the EPLAN system based on the configuration file and the target table.
For each target component, a configuration file is adopted to acquire the field value of the corresponding column of each row of the target component in the target table, and then the field and field value information is used to create the target component into a component library of the EPLAN system. For example, for size data in a target file, a 2D map is automatically generated according to the filled size when the EPLAN arranges the layout map.
The roles of the component library in EPLAN mapping include: drawing an electrical schematic diagram, namely selecting a corresponding model from a component library, and displaying model parameters in the schematic diagram; the device can also be used for identifying the corresponding model number through the device, and the 2D or 3D layout of the component can be quickly dragged into the 2D or 3D mounting plate.
To systematically illustrate the process of creating a library of parts, a description will now be made with specific examples, including the steps of:
a. and generating a first table according to the attribute information of the components in the component library to be created, wherein each column of the first table is used for writing the field and the field value of the attribute information.
The attribute information of the component includes a component number, SAP number, model number, name, length, width, height, and graphic macro, and corresponding fields are PN, sapnr, model, name, length, width, height, macro, respectively, and a first table is formed as follows (table 1):
PN sapnr Model Name length width height Macro
in table 1, the fields of the attribute information of the components are listed in the header of the first table, and the blank space under each field is used to fill out the field value corresponding to the field.
b. A configuration file adapted to the attribute information is generated.
Specifically, the configuration file is as follows:
Table=tblpart
PN=[1!#1]
sapnr=[1!#2]
Model=[1!#3]
Name=[1!#4]
length=[1!#5]
width=[1!#6]
height=[1!#7]
Macro=[1!#8]
c. existing attribute information of a target component in the SAP system is derived.
The derived existing attribute information is specifically shown in the following table (table 2):
SAP numbering Name of the name Part numbering Long length Wide width of High height
24021 Contactor LC-D09 77 47 84
20323 LED LED-55 2.8 3.5 3
d. Based on the matching relation between the attribute information and the fields, the existing attribute information is correspondingly input into the first table to obtain a second table. Illustratively, after determining the row in which the target component is located, the table contents corresponding to the SAP number are entered into the table corresponding to sapnr.
The second table is shown below (table 3):
PN sapnr Model Name length Width height macro
LC-D09 24021 contactor 77 47 84
LED-55 20323 LED 2.8 3.5 3
e. Obtaining and filling missing attribute information of the target component into a second table to obtain a target table, wherein the types of the missing attribute information are Model and macro, and obtaining and filling the information into the second table.
The target table is shown below (table 4):
PN sapnr Model Name length width height macro
LC-D09 24021 S37V contactor 77 47 84 24021.xlsm
LED-55 20323 L53D LED 2.8 3.5 3 20323.xlsm
f. A library of components is created in the EPLAN system based on the configuration file and the target table.
For each target component, acquiring a field value of a corresponding column of each row of the target component in the target table by adopting a configuration file, and then creating the target component into a component library by utilizing the field and field value information.
The embodiment of the invention provides a method for creating a component library, which is used for generating a first table according to attribute information of components in the component library to be created, wherein each column of the first table is used for writing fields and field values of the attribute information; generating a configuration file matched with the attribute information; deriving existing attribute information of a target component in the SAP system; based on the matching relation between the attribute information and the fields, correspondingly inputting the existing attribute information into a first table to obtain a second table; acquiring missing attribute information of a target part and filling the missing attribute information into a second table to obtain a target table; a library of components is created in the EPLAN system based on the configuration file and the target table. The existing attribute information of the target components is derived from the SAP system, the missing attribute information is supplemented, the target table comprising the complete attribute information of the target components can be obtained, the attribute information of each target component is imported into the component library of the EPLAN system through the configuration file, the target components of the SAP system can be created into the component library of the EPLAN system without the need of manual entry item by item, the manual operation is greatly reduced, the efficiency of creating the component library is improved, and errors caused by manual operation can be reduced.
Example two
Fig. 2 is a flowchart of a component library creating method according to a second embodiment of the present invention, where the component library creating method according to the first embodiment of the present invention is optimized based on the first embodiment, as shown in fig. 2, and includes:
s201, generating a first table according to attribute information of components in a component library to be created, wherein each column of the first table is used for writing fields and field values of the attribute information.
S202, generating a configuration file matched with the attribute information.
S203, the existing attribute information of the target component in the SAP system is exported.
S201 to S203 are similar to S101 to S103 of the first embodiment, and specific reference is made to the description of S101 to S103, which is not described here.
S204, determining a row corresponding to the target component in the first table as a target row for each target component.
Each part corresponds to a row in the table, i.e. all attribute information of the part will be arranged in the same row.
S205, for each existing attribute information, a column corresponding to the attribute information matching the existing attribute information in the first table is determined as a target column.
For the same row, each column may be populated with different attribute information. The type of the attribute information to be filled in corresponds to the header field corresponding to the column. In general, the header of a column is a field, and the attribute information corresponding to the header is a field value of the field.
The existing attribute information is specific text information, and the attribute information in the table corresponds to a field, so that the existing attribute information is first matched with the field in the table, and then the column in which the field is located can be used as the target column.
S206, filling the existing attribute information into the target row and the target column of the first table to obtain a second table.
Specifically, the existing attribute information may be sequentially filled into the first table by using a copy filling manner, and when the existing attribute information is in a table form, the existing attribute information may also be filled into the first table by using a manner of referencing worksheet data, for example, when the existing attribute information is stored in the preset table, the existing attribute information in the preset table is filled into the first table by using a VLOOKUP function.
S207, acquiring missing attribute information of the target component and filling the missing attribute information into the second table to obtain a target table.
Specifically, for each target component, the complete attribute information of the target may be determined and acquired according to the category of the target component, and the missing attribute information of the target component may be determined based on the existing attribute information and the complete attribute information.
The same way as the existing attribute information is filled in the first table, when the missing attribute information is filled in the second table, determining the column to which the missing part information belongs according to the header of the second table; filling the missing part information into the corresponding column and the row of the target part to obtain a target form.
In an optional embodiment, the attribute information further includes a product packet number, and after acquiring the missing attribute information of the target component and filling the missing attribute information into the second table to obtain the target table, the method further includes: for each target component, searching a product grouping number corresponding to the target component in a preset product grouping table; and correspondingly filling the product packet numbers into the target table.
The product group number may include a class of product groups, and child product groups, and the corresponding fields are producttopgroup, productgroup, productsubgroup, respectively.
S208, the target table is stored as a CSV format target file.
S209, importing the configuration file and the target file into the EPLAN system together to create a component library in the EPLAN system.
Importing a configuration file and a target file together into an EPLAN system to create a component library in the EPLAN system, comprising:
and selecting a configuration file and adding a configuration file corresponding path, determining a target file and adding the target file corresponding path, and configuring the content in the target file into a component library of the EPLAN system based on the configuration file.
The specific operations for creating a component library in an EPLAN system are: opening an EPLAN, entering a new part page, selecting an additional-import in a new part library, selecting a configuration file of which the suffix name is edited in advance, adding a corresponding path, selecting a CSV (client side virtual server) file type, selecting the file name of the CSV which is converted from the EXCEL edited in batch before, adding the corresponding path, and clicking to determine after completion. Waiting a few minutes after the determination results in a complete batch of parts library that is classified.
In an alternative example, after creating the component library in the EPLAN system based on the configuration file and the target table, further comprising: acquiring updated attribute information of a target component in the SAP system as updated attribute information; and updating the target file based on the updated attribute information.
The update attribute information of the target component may be attribute information of a new target component or may be information for updating attribute information of an original target component. That is, the attribute information of the new target component can be added in the target file, and the attribute information of the original target component can be changed to adapt to the material use requirement of the company.
In summary, the attribute information in the system is extracted from the SAP system, and the related attribute information is maintained in batches in the first form, even when the SAP attribute is changed, the matching change can be carried out again through the EXCEL according to the codes, then the configuration file of the CFG is obtained through the suffix name corresponding to the attribute column of the EXCEL table head which is edited in advance, the edited EXCEL form is converted into the CSV file, and the CSV file is matched with the CFG configuration file for use.
Example III
Fig. 3 is a schematic structural diagram of a component library creating apparatus according to a third embodiment of the present invention. As shown in fig. 3, the component library creating apparatus includes:
a first table generating module 301, configured to generate a first table according to attribute information of a component in a component library to be created, where each column of the first table is used to write a field and a field value of the attribute information;
a configuration file generating module 302, configured to generate a configuration file adapted to the attribute information;
a target component information deriving module 303, configured to derive existing attribute information of a target component in the SAP system;
a second table generating module 304, configured to correspondingly input the existing attribute information into the first table based on the matching relationship between the attribute information and the field, so as to obtain a second table;
a target table module 305, configured to obtain missing attribute information of the target component and fill the missing attribute information into the second table, to obtain a target table;
a component library creation module 306 for creating a component library in the EPLAN system based on the configuration file and the target table.
In an alternative embodiment, the configuration file generation module 302 includes:
and the configuration file generation sub-module is used for setting row content in the configuration file according to column content of the first table, so that each row of sentences in the configuration file is used for acquiring a field value corresponding to each field in the first table.
In an alternative embodiment, the second table generating module 304 includes:
a target row determination submodule, configured to determine, for each target component, a row corresponding to the target component in the first table, as a target row;
a target column determining sub-module, configured to determine, for each of the existing attribute information, a column corresponding to attribute information matching the existing attribute information in the first table as a target column;
and the information filling sub-module is used for filling the existing attribute information into the target row and the target column of the first table to obtain a second table.
In an alternative embodiment, the component library creating apparatus further comprises:
the complete attribute information determining module is used for determining and acquiring complete attribute information of the targets according to the categories of the target components for each target component;
and the missing attribute information determining module is used for determining missing attribute information of the target component based on the existing attribute information and the complete attribute information.
In an alternative embodiment, the attribute information further includes a product group number, and the component library creating device further includes:
the product grouping number searching module is used for searching the product grouping number corresponding to each target component in a preset product grouping table aiming at each target component;
and the product group number filling module is used for correspondingly filling the product group number into the target table.
In an alternative embodiment, the component library creation module 306 includes:
the format conversion sub-module is used for saving the target table as a target file in a CSV format;
and the component library creation sub-module is used for importing the configuration file and the target file into the EPLAN system together so as to create a component library in the EPLAN system.
In an alternative embodiment, the component library creating apparatus further comprises:
the updating attribute information acquisition module is used for acquiring updated attribute information of a target component in the SAP system and taking the updated attribute information as updated attribute information;
and the target file updating module is used for updating the target file based on the updating attribute information.
The component library creating device provided by the embodiment of the invention can execute the component library creating method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the executing method.
Example IV
Fig. 4 shows a schematic diagram of an electronic device 40 that may be used to implement an embodiment of the invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. Electronic equipment may also represent various forms of mobile devices, such as personal digital processing, cellular telephones, smartphones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.
As shown in fig. 4, the electronic device 40 includes at least one processor 41, and a memory communicatively connected to the at least one processor 41, such as a Read Only Memory (ROM) 42, a Random Access Memory (RAM) 43, etc., in which the memory stores a computer program executable by the at least one processor, and the processor 41 may perform various suitable actions and processes according to the computer program stored in the Read Only Memory (ROM) 42 or the computer program loaded from the storage unit 48 into the Random Access Memory (RAM) 43. In the RAM 43, various programs and data required for the operation of the electronic device 40 may also be stored. The processor 41, the ROM 42 and the RAM 43 are connected to each other via a bus 44. An input/output (I/O) interface 45 is also connected to bus 44.
Various components in electronic device 40 are connected to I/O interface 45, including: an input unit 46 such as a keyboard, a mouse, etc.; an output unit 47 such as various types of displays, speakers, and the like; a storage unit 48 such as a magnetic disk, an optical disk, or the like; and a communication unit 49 such as a network card, modem, wireless communication transceiver, etc. The communication unit 49 allows the electronic device 40 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.
The processor 41 may be various general and/or special purpose processing components with processing and computing capabilities. Some examples of processor 41 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, digital Signal Processors (DSPs), and any suitable processor, controller, microcontroller, etc. The processor 41 performs the respective methods and processes described above, for example, the component library creation method.
In some embodiments, the component library creation method may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as the storage unit 48. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 40 via the ROM 42 and/or the communication unit 49. When the computer program is loaded into the RAM 43 and executed by the processor 41, one or more steps of the component library creating method described above may be performed. Alternatively, in other embodiments, the processor 41 may be configured to perform the component library creation method in any other suitable manner (e.g., by means of firmware).
Various implementations of the systems and techniques described here above can be implemented in digital electronic circuitry, integrated circuit systems, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), systems On Chip (SOCs), complex Programmable Logic Devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs, the one or more computer programs may be executed and/or interpreted on a programmable system including at least one programmable processor, which may be a special purpose or general-purpose programmable processor, that may receive data and instructions from, and transmit data and instructions to, a storage system, at least one input device, and at least one output device.
A computer program for carrying out methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be implemented. The computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) through which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic input, speech input, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a background component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such background, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.
The computing system may include clients and servers. The client and server are typically remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical hosts and VPS service are overcome.
It should be appreciated that various forms of the flows shown above may be used to reorder, add, or delete steps. For example, the steps described in the present invention may be performed in parallel, sequentially, or in a different order, so long as the desired results of the technical solution of the present invention are achieved, and the present invention is not limited herein.
The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives are possible, depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.

Claims (10)

1. A component library creation method, comprising:
generating a first table according to attribute information of components in a component library to be created, wherein each column of the first table is used for writing in a field and a field value of the attribute information;
generating a configuration file matched with the attribute information;
deriving existing attribute information of a target component in the SAP system;
based on the matching relation between the attribute information and the field, correspondingly inputting the existing attribute information into the first table to obtain a second table;
acquiring missing attribute information of the target component and filling the missing attribute information into the second table to obtain a target table;
a library of components is created in the EPLAN system based on the configuration file and the target table.
2. The method of claim 1, wherein the generating a profile adapted to the attribute information comprises:
setting row content in the configuration file according to column content of the first table, so that each row statement in the configuration file is used for acquiring a field value corresponding to each field in the first table.
3. The method of claim 1, wherein the correspondingly inputting the existing attribute information into the first table based on the matching relationship between the attribute information and the field to obtain a second table includes:
for each target component, determining a corresponding row of the target component in the first table as a target row;
determining, for each of the existing attribute information, a column corresponding to attribute information matching the existing attribute information in the first table as a target column;
and filling the existing attribute information into the target row and the target column of the first table to obtain a second table.
4. The method of claim 1, further comprising, prior to said obtaining missing attribute information of said target part and populating said second table to obtain a target table:
for each target component, determining and acquiring complete attribute information of the target according to the category of the target component;
determining missing attribute information of the target component based on the existing attribute information and the complete attribute information.
5. The method according to any one of claims 1 to 4, wherein the attribute information further includes a product packet number, and after the obtaining and filling the missing attribute information of the target part into the second table, obtaining a target table further includes:
for each target component, searching a product grouping number corresponding to the target component in a preset product grouping table;
and correspondingly filling the product packet number into the target table.
6. The method of any of claims 1-4, wherein creating a component library in an EPLAN system based on the configuration file and the target table comprises:
the target table is stored as a CSV format target file;
the configuration file and the target file are imported together into the EPLAN system to create a component library in the EPLAN system.
7. The method of any of claims 1-4, further comprising, after said creating a component library in an EPLAN system based on said configuration file and said target table:
acquiring updated attribute information of a target component in the SAP system as updated attribute information;
and updating the target file based on the updating attribute information.
8. A component library creation apparatus, comprising:
the device comprises a first table generation module, a first storage module and a second storage module, wherein the first table generation module is used for generating a first table according to attribute information of components in a component library to be created, and each column of the first table is used for writing fields and field values of the attribute information;
the configuration file generation module is used for generating a configuration file matched with the attribute information;
a target component information deriving module for deriving existing attribute information of the target component in the SAP system;
the second table generation module is used for correspondingly inputting the existing attribute information into the first table based on the matching relation between the attribute information and the fields to obtain a second table;
the target table module is used for acquiring the missing attribute information of the target component and filling the missing attribute information into the second table to obtain a target table;
and the component library creation module is used for creating a component library in the EPLAN system based on the configuration file and the target table.
9. An electronic device, the electronic device comprising:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein,,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the component library creating method of any one of claims 1-7.
10. A computer readable storage medium storing computer instructions for causing a processor to implement the component library creation method of any of claims 1-7 when executed.
CN202310277324.9A 2023-03-20 2023-03-20 Component library creation method and device, electronic equipment and storage medium Pending CN116303461A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310277324.9A CN116303461A (en) 2023-03-20 2023-03-20 Component library creation method and device, electronic equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310277324.9A CN116303461A (en) 2023-03-20 2023-03-20 Component library creation method and device, electronic equipment and storage medium

Publications (1)

Publication Number Publication Date
CN116303461A true CN116303461A (en) 2023-06-23

Family

ID=86788384

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310277324.9A Pending CN116303461A (en) 2023-03-20 2023-03-20 Component library creation method and device, electronic equipment and storage medium

Country Status (1)

Country Link
CN (1) CN116303461A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117574867A (en) * 2023-12-08 2024-02-20 北京天圣华信息技术有限责任公司 Statistical table generation method, device, equipment and storage medium

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117574867A (en) * 2023-12-08 2024-02-20 北京天圣华信息技术有限责任公司 Statistical table generation method, device, equipment and storage medium

Similar Documents

Publication Publication Date Title
CN111177231A (en) Report generation method and report generation device
CN111125064B (en) Method and device for generating database schema definition statement
CN114880337B (en) Map data integrated updating method, device, equipment and storage medium
CN116303461A (en) Component library creation method and device, electronic equipment and storage medium
CN108959391B (en) Apparatus, system, method, and storage medium for presenting database cluster architecture diagram
CN103677852A (en) Design method of extensible class natural language formula editor
CN116009847A (en) Code generation method, device, electronic equipment and storage medium
CN116185389A (en) Code generation method and device, electronic equipment and medium
CN116483707A (en) Test method, test device, test apparatus, test program, and test program
CN116451619A (en) Component information processing method, device, medium and equipment
CN115328917A (en) Query method, device, equipment and storage medium
CN115329150A (en) Method and device for generating search condition tree, electronic equipment and storage medium
CN115169316A (en) Data processing template generation method and device, electronic equipment and storage medium
CN115374499A (en) Dimension marking method and device, electronic equipment and storage medium
CN113138760A (en) Page generation method and device, electronic equipment and medium
CN114741072B (en) Page generation method, device, equipment and storage medium
CN116303370B (en) Script blood margin analysis method, script blood margin analysis device, storage medium, script blood margin analysis equipment and script blood margin analysis product
CN113779313B (en) Knowledge management method and system based on graph database
CN117573199B (en) Model difference comparison analysis method, device, equipment and medium
CN118277406A (en) SQL sentence generation method and device based on large language model
CN117632874A (en) Automatic drawing storage method, device, equipment and medium for CAD software
CN115981657A (en) Code generation method and device, electronic equipment and readable medium
CN118377476A (en) Online development and loading method and device of component, electronic equipment and storage medium
CN106687999B (en) Generating a set of instructions implementing rules designed to update objects specified according to an application data model
CN117608839A (en) Task processing method, device, electronic equipment and storage medium

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