Automatic statistical method and system for satellite protection plug

Abstract

The invention provides an automatic statistical method and system for satellite protection plugs, and relates to the technical field of satellite manufacturing and maintenance, and the method comprises the steps: obtaining all data of a certain single-machine interface data single form of a satellite; analyzing the description file of the electric connector, and extracting information of all plugs and sockets; searching an empty socket and a debugging socket according to the information of the plug and the socket, comparing according to keywords in corresponding equipment codes, and extracting the information of the corresponding socket needing to make the plug; according to the information of the corresponding socket, the model information of the protection plug which is in butt joint with the empty socket and the debugging socket is found out through comparison of the information in the profile description file; matching the model information of the found protection plug with the information of the empty socket and the debugging socket to generate a corresponding protection plug list; and outputting the generated protection plug list to a directory specified by a user according to a specified format. According to the invention, the efficiency and accuracy of satellite protection plug statistics can be improved, and errors of manual operation are reduced.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of satellite manufacturing and maintenance, in particular to an automatic statistical method and system for satellite protection plugs. BACKGROUND

[0002] In the process of satellite manufacturing and maintenance, the statistics and management of protection plugs is an important task. The traditional statistical method of protection plugs mainly relies on manual operation, which has the problems of low efficiency, high error rate, etc. Due to the complexity of satellite systems and the diversity of electrical connectors, manual statistics is prone to omissions or misjudgments, which leads to problems in the subsequent plug installation and debugging process, affecting the overall performance and reliability of the satellite.

[0003] At present, with the continuous progress of satellite manufacturing technology and the improvement of automation level, there is an urgent need for a method that can improve the statistical efficiency and accuracy of protection plugs to reduce the workload and error rate of manual operation and improve the overall quality and efficiency of satellite manufacturing and maintenance. SUMMARY

[0004] In view of the defects in the prior art, the present application provides an automatic statistical method and system for satellite protection plugs.

[0005] According to the automatic statistical method and system for satellite protection plugs provided by the present application, the scheme is as follows:

[0006] In a first aspect, an automatic statistical method for satellite protection plugs is provided, which comprises:

[0007] Step S1: read all electrical connector model and single machine model data, the data including electrical connector description file and brief description file, according to the data source directory, obtain the interface data sheet data of satellite single machine Excel file format.

[0008] Step S2: parse the electrical connector description file, extract the information of all plugs and sockets, including electrical connector code, electrical connector description, electrical connector model and corresponding equipment code;

[0009] Step S3: according to the extracted plug and socket information, find the empty socket and debugging socket, compare according to the key in the corresponding equipment code, and extract the information of the corresponding socket which needs to do plug;

[0010] Step S4: according to the information of the corresponding socket, compare through the information in the electrical connector description file, find out the model information of the protection plug connected with the empty socket and the debugging socket;

[0011] Step S5: match the model information of the found protection plug with the empty socket and debugging socket information, and generate the corresponding protection plug list;

[0012] Step S6: output the generated protection plug list in the specified format to the directory specified by the user.

[0013] Preferably, in the step S2 of parsing the electrical connector description file, regular expressions are used to extract the information of the electrical connector code, electrical connector description, electrical connector model and corresponding equipment code.

[0014] Preferably, in the step S3 of finding the empty socket and the debugging socket, the specific keywords in the equipment code are used to distinguish the empty socket and the debugging socket, and the information of the corresponding socket that needs to be plugged is extracted, including the model and code of the socket.

[0015] Preferably, in the step S6 of outputting the protection plug list file, the file is named by the single machine ID and stored in the subdirectory under the directory specified by the user.

[0016] Preferably, the method further comprises, before step S1, checking the integrity and validity of the data in Excel file format, and generating an error report if the data is incomplete or invalid.

[0017] Preferably, the method further comprises, after completing the automatic statistics of the protection plug of a satellite single machine, reading the next single machine in turn and repeating the steps S1-S6 to output the protection plug list corresponding to the single machine, until all single machines are read.

[0018] In a second aspect, an automatic statistics system for satellite protection plugs is provided, which comprises:

[0019] Module M1: read all electrical connector model and single machine model data, including electrical connector description file and brief description file, and obtain interface data sheet data of each single machine in Excel file format according to the data source directory.

[0020] Module M2: parse the electrical connector description file and extract the information of all plugs and sockets, including electrical connector code, electrical connector description, electrical connector model and corresponding equipment code;

[0021] Module M3: according to the extracted plug and socket information, find the empty socket and the debugging socket, and compare the keywords in the corresponding equipment code to extract the information of the corresponding socket that needs to be plugged;

[0022] Module M4: according to the information of the corresponding socket, compare the information in the electrical connector description file to find the model information of the protection plug connected to the empty socket and the debugging socket;

[0023] Module M5: match the found model information of the protection plug with the empty socket and the debug socket information, and generate the corresponding protection plug list;

[0024] Module M6: output the generated protection plug list to the directory specified by the user in the specified format.

[0025] Preferably, in the module M2, when parsing the electrical connector description file, regular expressions are used to extract the electrical connector code, electrical connector description, electrical connector model and corresponding device code information;

[0026] In the module M3, when searching for empty sockets and debug sockets, specific keywords in the device code are used to distinguish between empty sockets and debug sockets, and the information of the corresponding socket that needs to be plugged is extracted, including the model and code of the socket.

[0027] Preferably, in the module M6, the output protection plug list file is named by single machine ID and stored in the subdirectory of the directory specified by the user.

[0028] Preferably, before the module M1, check the integrity and validity of the data in the Excel file format, and generate an error report if the data is incomplete or invalid;

[0029] After completing the automatic statistics of the protection plug of the satellite single machine as described above, the next single machine is read in turn, and the modules M1-M6 are repeated to output the protection plug list corresponding to the single machine, until all single machines are read.

[0030] Compared with the prior art, the present application has the following beneficial effects:

[0031] The present application can improve the efficiency and accuracy of satellite protection plug statistics, reduce the errors of manual operation, and improve the overall quality and reliability of satellite manufacturing and maintenance.

[0032] Other beneficial effects of the present application will be described in the specific embodiments through the introduction of specific technical features and technical solutions, and those skilled in the art should be able to understand the beneficial technical effects brought by the technical features and technical solutions through the introduction of the technical features and technical solutions. BRIEF DESCRIPTION OF DRAWINGS

[0033] Other features, objects and advantages of the present application will become more apparent through reading the detailed description of the non-limiting embodiments with reference to the following drawings:

[0034] Figure 1 Flowchart for the automatic statistics method of satellite protection plugs;

[0035] Figure 2 Part of the satellite interface data single table schematic diagram. DETAILED DESCRIPTION

[0036] The application will be described in detail below with specific examples. The following examples will help those skilled in the art to further understand the application, but in no way limit the application. It should be noted that those skilled in the art can make several changes and improvements without departing from the concept of the application. These are within the scope of the application.

[0037] Example 1

[0038] The embodiment of the application provides an automatic statistical method for satellite protection plugs. The method automatically calls and finds empty sockets and debugging sockets through each single machine interface data sheet data, automatically generates a corresponding protection plug list, and refers to the satellite protection plug list provided by the satellite protection plug list system. Figure 1 and Figure 2 The method specifically comprises the following steps.

[0039] Step S1: acquiring data;

[0040] Read all the data of the electrical connector model and the single machine model, the data including the electrical connector description file and the brief description file, according to the data source directory, the satellite single machine interface data sheet data acquired is in the Excel file format, which includes a plurality of work sheets, and each work sheet corresponds to electrical connector information of different types.

[0041] Step S2: analyzing the electrical connector description file;

[0042] The electrical connector description file is analyzed to extract information of all plugs and sockets, including the electrical connector code, the electrical connector description, the electrical connector model and the corresponding equipment code. When the electrical connector description file is analyzed, the regular expression is used to extract information of the electrical connector code, the electrical connector description, the electrical connector model and the corresponding equipment code.

[0043] Step S3: finding empty sockets and debugging sockets;

[0044] According to the extracted plug and socket information, the empty sockets and the debugging sockets are found, and the information of the corresponding socket that needs to be plugged is extracted according to the key in the corresponding equipment code, wherein the information includes the model and the code of the socket. In this step, the empty sockets and the debugging sockets are found according to the specific key in the equipment code to distinguish the empty sockets and the debugging sockets, and the information of the corresponding socket that needs to be plugged is extracted, wherein the information includes the model and the code of the socket.

[0045] Step S4: comparing protection plug information;

[0046] According to the extracted socket model and code information, the information in the electrical connector description file is compared to find the model information of the protection plug connected to the empty socket and the debugging socket.

[0047] Step S5: Generate protection plug list;

[0048] The found model information of the protection plug is matched with the empty socket and debugging socket information to generate the corresponding protection plug list, including model, position, state and corresponding socket information. The protection plug list generated in this step is in Excel file format, and the detailed information of each protection plug includes the unique identifier of the plug.

[0049] Step S6: Output list;

[0050] The generated protection plug list is output to the user-specified directory in the specified format. The protection plug list file output in this step is named by single machine ID and stored in the subdirectory under the user-specified directory.

[0051] Example 2:

[0052] This example is based on example 1, and the following steps are added:

[0053] 1. Data integrity check:

[0054] Before step S1, check the integrity and validity of the Excel file format data, and generate an error report when the data is incomplete or invalid, and notify the user to correct the data.

[0055] 2. Multi-table processing:

[0056] The Excel file format data includes multiple worksheets, each corresponding to different types of electrical connector information. In the processing process, each worksheet is parsed one by one to ensure that all types of electrical connector information are correctly extracted and processed.

[0057] 3. Single machine processing:

[0058] After completing the automatic statistics of the protection plug of the satellite single machine as described above, the next single machine is read in turn, and the steps S1-S6 are repeated to output the protection plug list corresponding to the single machine, until all single machines are read.

[0059] Example 3:

[0060] Based on example 2, further optimization:

[0061] User interface:

[0062] A friendly user interface is provided to allow the user to select data files, set output directories, and view generated error reports and statistical results.

[0063] The application also provides an automatic statistics system of satellite protection plugs, which can be implemented by performing the process steps of the automatic statistics method of satellite protection plugs, i.e., the automatic statistics method of satellite protection plugs can be understood by those skilled in the art as a preferred embodiment of the automatic statistics system of satellite protection plugs. The system specifically includes

[0064] Module M1: Obtain data;

[0065] Read all electrical connector model and single machine model data, including electrical connector description files and brief description files, and obtain satellite single machine interface data sheet data in Excel file format according to the data source directory, which includes multiple worksheets, each corresponding to electrical connector information of different types.

[0066] Module M2: Analyze electrical connector description files;

[0067] Analyze the electrical connector description files, extract information of all plugs and sockets, including electrical connector codes, electrical connector descriptions, electrical connector models, and corresponding equipment codes. When analyzing the electrical connector description files, regular expressions are used to extract information of electrical connector codes, electrical connector descriptions, electrical connector models, and corresponding equipment codes.

[0068] Module M3: Find empty sockets and debugging sockets;

[0069] According to the extracted plug and socket information, find empty sockets and debugging sockets, compare according to the keywords in the corresponding equipment codes, and extract information of the corresponding sockets that need to be plugged, including the model and code of the socket. In this step, when finding empty sockets and debugging sockets, specific keywords in the equipment code are used to distinguish between empty sockets and debugging sockets, and information of the corresponding sockets that need to be plugged is extracted, including the model and code of the socket.

[0070] Module M4: Compare protection plug information;

[0071] According to the extracted socket model and code information, compare with the information in the electrical connector description files to find the model information of the protection plugs connected to the empty sockets and debugging sockets;

[0072] Module M5: Generate a protection plug list;

[0073] The found model information of the protection plug is matched with the empty socket and the debugging socket information, and a corresponding protection plug list is generated, including the model, position, state and corresponding socket information. The protection plug list generated in this step is in Excel file format, and the detailed information of each protection plug includes the unique identifier of the plug.

[0074] Module M6: output list;

[0075] The generated protection plug list is output to the directory specified by the user in the specified format. The protection plug list file output in this step is named by single machine ID and stored in the subdirectory under the directory specified by the user.

[0076] Specific optimization:

[0077] 1) Data integrity check: Before module M1, check the integrity and validity of the data in Excel file format, and generate an error report when the data is incomplete or invalid.

[0078] 2) Multi-worksheet processing: The data in Excel file format includes multiple worksheets, each corresponding to different types of electrical connector information.

[0079] 3) Regular expression parsing: When parsing the electrical connector description file, regular expressions are used to extract the electrical connector code, electrical connector description, electrical connector model and corresponding equipment code information.

[0080] 4) Key distinguishes socket type: When finding the empty socket and the debugging socket, the specific key in the equipment code is used to distinguish the empty socket and the debugging socket.

[0081] 5) File naming and storage: The output protection plug list file is named by single machine ID and stored in the subdirectory under the directory specified by the user.

[0082] 6) Single machine processing: After completing the automatic statistics of the protection plug of the satellite for a single machine, the next single machine is read in turn, and the above modules M1-M6 are repeated to output the protection plug list corresponding to the single machine, until all single machines are read.

[0083] The embodiment of the application provides an automatic statistical method and system for satellite protection plugs, which automatically calls and processes each single machine interface data, finds empty sockets and debugging sockets, and automatically generates a corresponding protection plug list, thereby improving the automation and accuracy of statistics, reducing manual intervention, and improving the efficiency of satellite manufacturing and maintenance.

[0084] Those skilled in the art know that, in addition to implementing the system provided by the present application and each device, module and unit thereof in the form of pure computer readable program code, the system provided by the present application and each device, module and unit thereof can also be implemented in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers and embedded microcontrollers, etc. by logically programming the method steps to achieve the same functions. Therefore, the system provided by the present application and each device, module and unit thereof can be considered as a hardware component, and the devices, modules and units included therein for achieving various functions can also be considered as structures within the hardware component; the devices, modules and units for achieving various functions can also be considered as both software modules implementing methods and structures within hardware components.

[0085] The specific embodiments of the present application are described above. It needs to be understood that the present application is not limited to the specific embodiments described above, and various changes or modifications can be made by those skilled in the art within the scope of the claims, which does not affect the essential content of the present application. The embodiments of the present application and the features in the embodiments can be combined with each other in any manner without conflict.

Claims

1. An automatic counting method of satellite protection plugs, characterized in that, The method comprises the following steps: Step S1: reading all the electrical connector model and single machine model data, the data including electrical connector description file and brief description file, according to the data source directory, obtaining the satellite single machine interface data sheet data; Step S2: analyzing the electrical connector description file, extracting the information of all plugs and sockets, including electrical connector code, electrical connector description, electrical connector model and corresponding equipment code; Step S3: according to the extracted plug and socket information, finding the empty socket and the debugging socket, comparing according to the key in the corresponding equipment code, and extracting the information of the corresponding socket which needs to be plugged; Step S4: according to the information of the corresponding socket, comparing through the information in the electrical connector description file, finding out the model information of the protection plug connected with the empty socket and the debugging socket; Step S5: matching the model information of the found protection plug with the empty socket and the debugging socket information, and generating the corresponding protection plug list; Step S6: outputting the generated protection plug list to the user specified directory in the specified format.

2. The automatic statistical method of satellite protection plug according to claim 1, characterized in that, In step S2, regular expression is used to extract the information of electrical connector code, electrical connector description, electrical connector model and corresponding equipment code when analyzing the electrical connector description file.

3. The automatic statistical method of satellite protection plug according to claim 1, characterized in that, In step S3, the specific key in the equipment code is used to distinguish the empty socket and the debugging socket, and the information of the corresponding socket which needs to be plugged is extracted, wherein the information includes the model and code of the socket.

4. The automatic statistical method of satellite protection plug according to claim 1, characterized in that, In step S6, the output protection plug list file is named by single machine ID and stored in the subdirectory of the user specified directory.

5. The automatic statistical method of satellite protection plug according to claim 1, characterized in that, The method further comprises checking the integrity and validity of the Excel file format data before step S1, and generating an error report when the data is incomplete or invalid.

6. The automatic statistical method of satellite protection plug according to claim 1, characterized in that, The method further comprises reading the next single machine in turn after completing the automatic statistics of the protection plug of the satellite single machine, repeating the above steps S1-S6, outputting the protection plug list corresponding to the single machine, and reading all the single machines.

7. An automatic statistical system for satellite protection plugs, characterized in that, The method comprises the following steps: Module M1: reading all the electrical connector model and single machine model data, the data including electrical connector description file and brief description file, according to the data source directory, obtaining the satellite single machine interface data sheet data; Module M2: analyzing the electrical connector description file, extracting the information of all plugs and sockets, including electrical connector code, electrical connector description, electrical connector model and corresponding equipment code; Module M3: according to the extracted plug and socket information, finding the empty socket and the debugging socket, comparing according to the key in the corresponding equipment code, and extracting the information of the corresponding socket which needs to be plugged; Module M4: according to the information of the corresponding socket, comparing through the information in the electrical connector description file, finding out the model information of the protection plug connected with the empty socket and the debugging socket; Module M5: matching the model information of the found protection plug with the empty socket and the debugging socket information, and generating the corresponding protection plug list; Module M6: outputting the generated protection plug list to the user specified directory in the specified format.

8. The automatic statistical system of satellite protection plugs according to claim 7, characterized in that, The module M2 uses regular expression to extract the information of the electrical connector code, the electrical connector description, the electrical connector model and the corresponding equipment code when parsing the electrical connector description file; The module M3 distinguishes the empty socket and the debugging socket according to the specific keyword in the equipment code to extract the information of the corresponding socket which needs to be plugged, wherein the information includes the model and the code of the socket.

9. The automatic statistical system of satellite protection plugs according to claim 7, characterized in that, The module M6 outputs the protection plug list file which is named according to the single machine ID and stored in the subdirectory of the directory specified by the user.

10. The automatic statistical system of satellite protection plugs according to claim 7, characterized in that, The module M1 checks the integrity and validity of the data in the Excel file format before the module M1, and generates an error report when the data is incomplete or invalid; After the automatic statistics of the protection plug of the satellite single machine are completed, the next single machine is read in turn, and the modules M1-M6 are repeated to output the protection plug list corresponding to the single machine until all the single machines are read.

Images