Satellite cable network automatic proofreading method and system

Abstract

The invention provides an automatic proofreading method and system for a satellite cable network, and relates to the technical field of satellite manufacturing and maintaining.The method comprises the steps that S1, a user sets system operation parameters in a satellite system page; s2, reading an Excel file under a specified directory in the system operation parameters set by a user, taking the Excel file as a data source file, performing data comparison, and outputting a cable contact table; s3, calling data of each satellite stand-alone interface data list according to system operation parameters set by a user, searching and matching keywords, and automatically checking a matching result with data in the cable contact table to generate a checking result; and S4, generating a detailed check report according to a check result, and outputting the report to a directory specified by the user. According to the invention, the efficiency and accuracy of satellite cable network data proofreading can be improved through an automatic means, the error rate of manual operation is reduced, and the overall quality and reliability of satellite manufacturing and maintenance are further improved.

Description

Technical Field

[0001] This invention relates to the field of satellite manufacturing and maintenance technology, and more specifically, to an automatic calibration method and system for satellite cable networks. Background Technology

[0002] In satellite manufacturing and maintenance, the design and calibration of the cable network are crucial steps. Traditional cable network calibration methods rely primarily on manual operation, involving manual comparison of cable connection tables and the connection relationships of individual units. This approach suffers from low efficiency and a high error rate. This not only increases workload but also easily leads to data errors, affecting the normal operation and maintenance of the satellite.

[0003] An existing invention patent with publication number CN104836040A discloses a method for protecting the socket of a satellite cable network with a heat shrinkable sleeve. The heat shrinkable sleeve is inserted from one end of the socket and completely covers the socket, while the other end extends beyond the end face of the socket. The extended part is then blown down. After blowing down, the blown down end is sized to match the lead wire of the socket. That is, the diameter of the blown down end after blowing down is between the diameter of the lead wire and the diameter of the socket. This ensures that the heat shrinkable sleeve can only move between the lead wire of the socket and the end face of the socket, preventing it from falling off.

[0004] The invention patent with publication number CN117832991A discloses a method for connecting a satellite thin-film cable to a stand-alone unit. The thin-film cable is laid on the surface of the satellite structure and fixed by a fixing method. A reinforcing structure is set at the fixed position. The reinforcing structure is integrally formed with the thin-film cable. The satellite stand-alone unit is installed on the thin-film cable and fixed by mounting holes and screws. The plug and socket are also reliably connected together to ensure electrical connectivity. The signal of the stand-alone unit is successfully led to the circuit layer of the thin-film cable.

[0005] The invention patent with publication number CN114295939A discloses an automatic testing system for satellite cable networks, including an automatic testing module configured to automatically control each pin of the cable network interface to perform point-to-point traversal testing according to the node table of the cable network, so as to accurately measure DC resistance and insulation resistance; and a manual testing module configured to lead out each pin of the cable network interface through an expansion head, and when a cable network fault is detected during the automatic testing process, a manual re-inspection test is performed to manually test the fault point, thereby finding the source of the problem.

[0006] The invention patent with publication number CN112881844A discloses an automatic testing system for satellite cable networks. A host computer communicates with a transfer test module via a serial port to send test tasks to the transfer test module. An interface input module is connected between the input mechanical interface of the entire cable network and the transfer test module to provide test input signals to the transfer test module. The transfer test module is configured to receive test tasks and then provide the test tasks to the interface input module and interface output module via a CAN bus. This allows the interface input module to select the input pin containing the test input signal, and the interface output module to select the output pin containing the test output signal. After the input pin containing the test input signal and the output pin containing the test output signal are connected, the system performs the test according to the test task. The interface output module is connected between the output mechanical interface of the entire cable network and the transfer test module to form a closed loop with the interface input module for cable network connectivity testing.

[0007] The invention patent with publication number CN111967112A discloses a satellite cable network design method. By dividing the cable network into an energy network and a signal network, and combining equipment requirements and electromagnetic compatibility requirements, the reliability of the cable network is comprehensively improved and the manufacturing difficulty is reduced.

[0008] As satellite systems become increasingly complex, cable network calibration work has become more tedious and complicated. Most existing technologies on the market are single-function and cannot meet the calibration requirements of complex satellite systems. Summary of the Invention

[0009] To address the shortcomings of existing technologies, this invention provides an automatic calibration method and system for satellite cable networks.

[0010] According to the present invention, an automatic calibration method and system for satellite cable networks are provided, the scheme of which is as follows:

[0011] Firstly, a method for automatic calibration of satellite cable networks is provided, the method comprising:

[0012] Step S1: The user sets the system operating parameters on the satellite system page;

[0013] Step S2: Read the Excel file in the specified directory of the system operation parameters set by the user as the data source file, compare the data, and output the cable connection table;

[0014] Step S3: Based on the system operating parameters set by the user, call up the data from the interface of each satellite, search and match keywords, and automatically verify the matching results with the data in the cable connection table to generate the verification results;

[0015] Step S4: Based on the verification results, generate a detailed verification report and output the report to the user-specified directory.

[0016] Preferably, setting system operating parameters in step S1 includes setting the data source file directory, starting the data analysis function, and setting the result output directory; at the same time, the user starts the data analysis function through the interface.

[0017] Preferably, the data read in the Excel file in step S2 includes: cable connection table data, data sheets of each satellite's individual interface, and keyword matching rules and standards;

[0018] Step S2 further includes establishing a keyword database, using a string matching algorithm to identify and extract keywords from the Excel file, and comparing the extracted keywords with the data in the cable connection table.

[0019] The data comparison process includes:

[0020] Step S2.1: Read the data source by reading the Excel file from the directory specified in the system running parameters set by the user;

[0021] Step S2.2: Establish a keyword library and use a string matching algorithm to identify and extract keywords from the Excel file;

[0022] Step S2.3: Extract and match keywords, and compare the extracted keywords with the data in the cable connection table;

[0023] Step S2.4: Output the overall verification information of the cable contact table data.

[0024] Preferably, the data retrieved from the interface of each satellite unit in step S3 includes: the unique identifier of each unit, as well as the connection relationship and cable connection information of the units;

[0025] The generated verification results include an interface sheet automatic verification table, a cable bundle data table, and an interface information summary table.

[0026] The keyword search and matching process in step S3 includes:

[0027] Step S3.1: Call the data sheets of each satellite's individual interface, and load the data sheet files of each satellite's individual interface using the read parameters and settings;

[0028] Step S3.2: Perform keyword matching. Using a string matching algorithm, extract keywords from the interface data sheet one by one according to the keyword matching rules and standards, and compare the extracted keywords with the data in the cable connection table one by one.

[0029] Step S3.3: Verify the data. Automatically verify the extracted keywords with the fields in the cable connection table, check the connection relationships and data consistency, and generate verification results.

[0030] Preferably, step S4 includes: integrating the successful and failed matching records of the interface single automatic verification table into the verification report, and detailing the specific situation of interface matching;

[0031] The cable bundle data table is used to describe the distribution of cable connections in the report, ensuring the integrity and accuracy of the cable network.

[0032] The interface information summary table provides statistical data on the overall matching results and serves as the core part of the report;

[0033] The verification report includes detailed results of the comparison with the cable connection table, records of successful and unsuccessful matches, and necessary error message prompts.

[0034] Secondly, an automatic calibration system for satellite cable networks is provided, the system comprising:

[0035] Input module: Used to input model code, electrical connector description file, summary description file, data source directory and export path;

[0036] Data analysis module: used to call up data from the individual interfaces of each satellite, and search and match keywords;

[0037] Verification module: Used to automatically verify the matching results against the data in the cable connection table;

[0038] Output module: Used to generate and export detailed verification reports.

[0039] Preferably, the model code input in the input module is set by the user and entered in the edit box after the model code in the software interface.

[0040] Preferably, the model code input in the input module is located in the first row and first column under the form header in the data source file.

[0041] Preferably, the data analysis module includes: data from each satellite interface data sheet, including the unique identifier of each unit, the connection relationship of the unit, and cable connection information.

[0042] The keyword search and matching function in the data analysis module includes:

[0043] The system retrieves data from the individual satellite interface data sheets and loads the individual satellite interface data sheet files using the read parameters and settings.

[0044] Keyword matching is performed using a string matching algorithm. According to the keyword matching rules and standards, keywords are extracted from each interface data sheet, and the extracted keywords are compared with the data in the cable connection table one by one.

[0045] The data is verified by automatically comparing the extracted keywords with the fields in the cable connection table, checking the connection relationships and data consistency, and generating verification results.

[0046] Preferably, the verification result table generated by the output module includes an interface sheet automatic verification table, a cable bundle data table, and an interface information summary table;

[0047] The successful and failed matching records of the interface single automatic verification table are integrated into the verification report, which details the specific situation of interface matching.

[0048] The cable bundle data table is used to describe the distribution of cable connections in the report, ensuring the integrity and accuracy of the cable network.

[0049] The interface information summary table provides statistical data on the overall matching results and serves as the core part of the report;

[0050] The verification report includes detailed results of the comparison with the cable connection table, records of successful and unsuccessful matches, and necessary error message prompts.

[0051] Compared with the prior art, the present invention has the following beneficial effects:

[0052] This invention can automatically read, verify, and check cable network data and generate detailed verification reports, improving the efficiency and accuracy of satellite cable network data verification, reducing the error rate of manual operation, and providing reliable technical support for satellite manufacturing and maintenance.

[0053] Other beneficial effects of the present invention will be explained in detail through the introduction of specific technical features and technical solutions in specific embodiments. Those skilled in the art should be able to understand the beneficial technical effects brought about by these technical features and technical solutions through the introduction of these technical features and technical solutions. Attached Figure Description

[0054] Other features, objects, and advantages of the present invention will become more apparent from the following detailed description of non-limiting embodiments with reference to the accompanying drawings:

[0055] Figure 1 This is a schematic diagram of the overall process of the present invention. Detailed Implementation

[0056] The present invention will now be described in detail with reference to specific embodiments. These embodiments will help those skilled in the art to further understand the present invention, but do not limit the invention in any way. It should be noted that those skilled in the art can make several changes and improvements without departing from the concept of the present invention. These all fall within the protection scope of the present invention.

[0057] This invention provides an automated calibration method for satellite cable networks, addressing the problems of low efficiency and high error rate associated with manual calibration in existing technologies. The method significantly improves the efficiency and accuracy of satellite cable network data calibration, reduces human error, and enhances the overall quality and reliability of satellite manufacturing and maintenance. (Refer to...) Figure 1 As shown, the method specifically includes:

[0058] Step S1: The user sets the system operating parameters on the satellite system page. This includes setting the data source file directory, starting the data analysis function, and the result output directory; at the same time, the user starts the data analysis function through the interface.

[0059] Step S2: Read the Excel file in the specified directory of the system operation parameters set by the user as the data source file. Compare the data by reading the Excel file in the directory and output the overall verification information of the cable connection table data. For example, read the cable connection table data, the individual data of each satellite unit interface, and the keyword matching rules and standards. The data in the Excel file includes the cable connection table data, the individual data of each satellite unit interface, and the keyword matching rules and standards.

[0060] Specifically, the data comparison process in step S2 is as follows:

[0061] 1. Read the data source:

[0062] Read Excel files from the directory specified in the user-defined system runtime parameters, using them as the data source files. These files include:

[0063] 1) Cable connection table data;

[0064] 2) Individual interface data for each satellite;

[0065] 3) Keyword matching rules and standards;

[0066] 2. Establish a keyword database:

[0067] The system will build a keyword database and use a string matching algorithm to identify and extract keywords from Excel files.

[0068] 3. Extract and match keywords:

[0069] The extracted keywords are compared with the data in the cable connection table. This comparison includes:

[0070] 1) Matching keywords with cable connection table data;

[0071] 2) Verify according to keyword matching rules and standards;

[0072] 4. Output verification information:

[0073] Overall verification information for the output cable contact table data. Verification information includes:

[0074] 1) The portion of data that was successfully matched;

[0075] 2) Data matching failures;

[0076] 3) Error messages or inconsistencies in the data;

[0077] Through the above process, the system can automatically compare cable connection table data and satellite unit interface data, ensuring the integrity and accuracy of the data.

[0078] Establish a keyword database, use string matching algorithms to identify and extract keywords from Excel files, and compare the extracted keywords with the data in the cable connection table.

[0079] Step S3: Based on the system operating parameters set by the user (i.e., the model code, data source directory, and export path parameters configured by the user), call the data sheets of each satellite's single-unit interface, search and match keywords, and automatically verify the matching results with the data in the cable connection table to generate verification results.

[0080] 1. The application parameters include:

[0081] User-defined system operating parameters:

[0082] 1) Model code: Used to identify the specific satellite model.

[0083] 2) Data source directory: The specified directory for storing various types of data files.

[0084] 3) Export path: The path to the output file used to store the verification results.

[0085] File content read from the data source:

[0086] 1) Cable connection table data: A basic data table describing the cable connection relationships.

[0087] 2) Individual Interface Data: Each individual device's unique identifier, connection relationship, and cable connection information.

[0088] 3) Keyword matching rules and standards: Define the rules and standards that need to be followed when matching.

[0089] 2. Specific methods for finding and matching keywords include:

[0090] (1) Call the data from the individual interfaces of each satellite:

[0091] The system uses the read parameters and settings to load the individual interface data files for each satellite. These files contain:

[0092] 1) A unique identifier for each individual machine (interface data sheet).

[0093] 2) Connection relationship of a single machine.

[0094] 3) Cable connection information.

[0095] (2) Keyword matching:

[0096] 1) Use a string matching algorithm to extract keywords from each data sheet in the interface according to keyword matching rules and standards.

[0097] 2) Compare the extracted keywords with the data in the cable connection table one by one.

[0098] 3) The comparison content includes:

[0099] Completeness and consistency of keywords;

[0100] Does the keyword exist in the table or does it match?

[0101] (3) Automatic data verification:

[0102] 1) The system will automatically check the extracted keywords against the fields in the cable connection table to verify the connection relationships and data consistency.

[0103] 2) The verification process is fully automated, avoiding errors that may be caused by manual operation.

[0104] 3. Generate verification results:

[0105] After verification, the system generates the following verification results:

[0106] 1) Interface sheet automatic calibration table;

[0107] 2) Cable bundle data sheet;

[0108] 3) Summary table of interface information.

[0109] Using the above methods, the present invention can efficiently search and match keywords, and automatically verify the matching results with the data in the cable connection table, thereby improving the verification efficiency and accuracy.

[0110] The data retrieved from each satellite's individual interface data sheet includes: a unique identifier for each unit (interface data sheet), as well as the unit's connection relationships and cable connection information. The generated verification results include an automatic interface data sheet verification table, a cable bundle data table, and an interface information summary table.

[0111] The purpose of these tables and their function in subsequent steps are as follows:

[0112] (1) Interface Automatic Verification Table:

[0113] use:

[0114] 1) Record the verification results between the interface data sheet and the cable connection table.

[0115] 2) Includes successfully matched entries, failed matches, and detailed information on erroneous or inconsistent data.

[0116] 3) Used to quickly locate problems in interface data sheets and cable connection data.

[0117] (2) Cable Bundle Data Sheet:

[0118] use:

[0119] 1) Describe the cable bundle information, that is, the grouping and allocation of cable connection relationships.

[0120] 2) The connection path, branch nodes, and bundle structure of each cable joint are recorded in detail.

[0121] 3) Provide guidance on cable routing during satellite manufacturing and maintenance.

[0122] (3) Interface Information Summary Table:

[0123] use:

[0124] 1) Summarize the data matching and verification results of all interfaces.

[0125] 2) Includes the interface's unique identifier, connection relationship, cable connection information, and overall matching status.

[0126] Application in subsequent steps:

[0127] Step S4: Generate a detailed verification report:

[0128] The information in the table above is directly used to generate the verification report, specifically including:

[0129] 1) Successful and failed matching records from the interface single automatic verification table are integrated into the verification report to provide a detailed explanation of the specific circumstances of the interface matching.

[0130] 2) The cable bundle data sheet contains bundle information used in the report to describe the distribution of cable connections, ensuring the integrity and accuracy of the cable network.

[0131] 3) The interface information summary table provides statistical data on the overall matching results and serves as the core part of the report.

[0132] The generated verification report contains:

[0133] Contents included:

[0134] 1) Detailed results of comparison with the cable connection table.

[0135] 2) Match successful and failed records.

[0136] 3) Necessary error message prompts.

[0137] In summary:

[0138] Interface Data Sheet Automatic Verification Table: Records the verification results of interface data sheets, including successful and unsuccessful matching entries, and is used to record the specific matching details between the interface and the cable connection.

[0139] Cable Bundle Data Sheet: Used to describe the grouping and distribution of cable connections.

[0140] Interface Information Summary Table: Summarizes the overall matching status of all interface data, used to summarize the overall verification situation.

[0141] Step S4 generates a detailed verification report based on the verification results and outputs the report to a user-specified directory. The verification report includes detailed results of the verification against the cable connection table, records of successful and unsuccessful matches, and necessary error message prompts.

[0142] This invention also provides an automatic satellite cable network calibration system. This system can be implemented by executing the steps of the automatic satellite cable network calibration method. That is, those skilled in the art can understand the automatic satellite cable network calibration method as a preferred embodiment of the automatic satellite cable network calibration system. Specifically, the system includes:

[0143] Input module: Used to input the model code (located in the first row and first column under the form header in the data source file), the electrical connector description file, the summary description file, the data source directory, and the export path. The model code is set by the user and entered in the edit box next to the model code in the software interface.

[0144] Data Analysis Module: Used to retrieve data from the interface data sheets of each satellite unit, and search for and match keywords. The retrieved data from each satellite interface data sheet includes the unique identifier of each unit (interface data sheet), the connection relationship of the unit, and cable connection information.

[0145] The keywords to search and match in the data analysis module include:

[0146] The system retrieves data from the individual satellite interface data sheets and loads the individual satellite interface data sheet files using the read parameters and settings.

[0147] Keyword matching is performed using a string matching algorithm. According to the keyword matching rules and standards, keywords are extracted from each interface data sheet, and the extracted keywords are compared with the data in the cable connection table one by one.

[0148] The data is verified by automatically comparing the extracted keywords with the fields in the cable connection table, checking the connection relationships and data consistency, and generating verification results.

[0149] Verification module: Used to automatically verify the matching results against the data in the cable connection table;

[0150] Output module: Used to generate and export detailed verification reports. The verification result tables generated by this output module include an automatic interface sheet verification table, a cable bundle data table, and an interface information summary table.

[0151] Integrate the successful and failed matching records from the automatic verification table of the interface into the verification report, and explain the specific details of the interface matching.

[0152] The cable bundle data table is used to describe the distribution of cable connections in the report, ensuring the integrity and accuracy of the cable network.

[0153] The interface information summary table provides statistical data on the overall matching results and serves as the core part of the report;

[0154] The verification report includes detailed results of the comparison with the cable connection table, records of successful and unsuccessful matches, and necessary error message prompts.

[0155] This invention provides an automatic calibration method and system for satellite cable networks, which can improve the efficiency and accuracy of satellite cable network data calibration, reduce errors from manual operation, and improve the overall quality and reliability of satellite manufacturing and maintenance.

[0156] Those skilled in the art will understand that, besides implementing the system and its various devices, modules, and units provided by this invention in the form of purely computer-readable program code, the same functions can be achieved entirely through logical programming of the method steps, making the system and its various devices, modules, and units of this invention function in the form of logic gates, switches, application-specific integrated circuits, programmable logic controllers, and embedded microcontrollers. Therefore, the system and its various devices, modules, and units provided by this invention can be considered as a hardware component, and the devices, modules, and units included therein for implementing various functions can also be considered as structures within the hardware component; alternatively, the devices, modules, and units for implementing various functions can be considered as both software modules implementing the method and structures within the hardware component.

[0157] Specific embodiments of the present invention have been described above. It should be understood that the present invention is not limited to the specific embodiments described above, and those skilled in the art can make various changes or modifications within the scope of the claims, which do not affect the essence of the present invention. Unless otherwise specified, the embodiments and features described in this application can be arbitrarily combined with each other.

Claims

1. An automatic calibration method for satellite cable networks, characterized in that, include: Step S1: The user sets the system operating parameters on the satellite system page; Step S2: Read the Excel file in the specified directory of the system operation parameters set by the user as the data source file, compare the data, and output the cable connection table; Step S3: Based on the system operating parameters set by the user, call up the data from the interface of each satellite, search and match keywords, and automatically verify the matching results with the data in the cable connection table to generate the verification results; Step S4: Based on the verification results, generate a verification report and output the report to the user-specified directory.

2. The automatic calibration method for satellite cable networks according to claim 1, characterized in that, The system operating parameters set in step S1 include: setting the data source file directory, starting the data analysis function, and setting the result output directory; at the same time, the user starts the data analysis function through the interface.

3. The automatic calibration method for satellite cable networks according to claim 1, characterized in that, The data read from the Excel file in step S2 includes: cable connection table data, data sheets of each satellite's individual interface, and keyword matching rules and standards; Step S2 further includes establishing a keyword database, using a string matching algorithm to identify and extract keywords from the Excel file, and comparing the extracted keywords with the data in the cable connection table; The data comparison process includes: Step S2.1: Read the data source by reading the Excel file from the directory specified in the system running parameters set by the user; Step S2.2: Establish a keyword library and use a string matching algorithm to identify and extract keywords from the Excel file; Step S2.3: Extract and match keywords, and compare the extracted keywords with the data in the cable connection table; Step S2.4: Output the overall verification information of the cable contact table data.

4. The automatic calibration method for satellite cable networks according to claim 1, characterized in that, The data retrieved in step S3 includes: the unique identifier of each satellite unit, as well as the connection relationship and cable connection information of the unit. The generated verification results include an interface sheet automatic verification table, a cable bundle data table, and an interface information summary table. The keyword search and matching process in step S3 includes: Step S3.1: Call the data sheets of each satellite's individual interface, and load the data sheet files of each satellite's individual interface using the read parameters and settings; Step S3.2: Perform keyword matching. Using a string matching algorithm, extract keywords from the interface data sheet one by one according to the keyword matching rules and standards, and compare the extracted keywords with the data in the cable connection table one by one. Step S3.3: Verify the data. Automatically verify the extracted keywords with the fields in the cable connection table, check the connection relationships and data consistency, and generate verification results.

5. The automatic calibration method for satellite cable networks according to claim 4, characterized in that, Step S4, which generates the verification report, includes: The successful and failed matching records of the interface single automatic verification table are integrated into the verification report, which details the specific situation of interface matching. The cable bundle data table is used to describe the distribution of cable connections in the report, ensuring the integrity and accuracy of the cable network. The interface information summary table provides statistical data on the overall matching results and serves as the core part of the report; The verification report includes detailed results of the comparison with the cable connection table, records of successful and unsuccessful matches, and necessary error message prompts.

6. An automatic satellite cable network calibration system, based on the automatic satellite cable network calibration method according to any one of claims 1-5, characterized in that, include: Input module: Used to input model code, electrical connector description file, summary description file, data source directory and export path; Data analysis module: used to call up data from the individual interfaces of each satellite, and search and match keywords; Verification module: Used to automatically verify the matching results against the data in the cable connection table; Output module: Used to generate and export detailed verification reports.

7. The automatic satellite cable network calibration system according to claim 6, characterized in that, The model code input in the input module is set by the user and entered in the edit box after the model code on the software interface.

8. The automatic satellite cable network calibration system according to claim 6, characterized in that, The model code input in the input module is located in the first row and first column under the form header in the data source file.

9. The automatic satellite cable network calibration system according to claim 6, characterized in that, The data analysis module includes: data from each satellite interface data sheet, including the unique identifier of each unit, the connection relationship of the unit, and cable connection information; The keyword search and matching function in the data analysis module includes: The system retrieves data from the individual satellite interface data sheets and loads the individual satellite interface data sheet files using the read parameters and settings. Keyword matching is performed using a string matching algorithm. According to the keyword matching rules and standards, keywords are extracted from each interface data sheet, and the extracted keywords are compared with the data in the cable connection table one by one. The data is verified by automatically comparing the extracted keywords with the fields in the cable connection table, checking the connection relationships and data consistency, and generating verification results.

10. The automatic satellite cable network calibration system according to claim 6, characterized in that, The verification result tables generated by the output module include an interface sheet automatic verification table, a cable bundle data table, and an interface information summary table. The successful and failed matching records of the interface single automatic verification table are integrated into the verification report, which details the specific situation of interface matching. The cable bundle data table is used to describe the distribution of cable connections in the report, ensuring the integrity and accuracy of the cable network. The interface information summary table provides statistical data on the overall matching results and serves as the core part of the report; The verification report includes detailed results of the comparison with the cable connection table, records of successful and unsuccessful matches, and necessary error message prompts.

Images