Satellite interface data sheet automatic matching method and system

Abstract

The invention provides a satellite interface data sheet automatic matching method and system, and the method comprises the steps: S1, formulating an information filling specification of a satellite IDS, and filling interconnection information in all satellite IDS according to the specification; s2, reading the IDS, and extracting product interconnection element information in all IDS files; s3, automatically matching all the extracted product interconnection information by adopting specified retrieval and matching rules; s4, if the interconnection information can be successfully matched, the information is judged to be correct, and if the interconnection information cannot be successfully matched, the information is judged to be incorrect; and marking the element contents which cannot be successfully matched, and then outputting all matching information. According to the electric connector contact table filling standard, the accuracy, consistency and reliability of information filling can be ensured, ambiguity and misunderstanding caused by non-standard information filling are avoided, and powerful support is provided for management and maintenance of the satellite state.

Description

Technical Field

[0001] The present invention relates to the technical field of satellite interface data sheet automatic matching, and in particular to a satellite interface data sheet automatic matching method and system. Background Art

[0002] In the field of satellite engineering, with the shortening of satellite mission cycles and the increase in mission volume, the quality of satellite development has been challenged. If the traditional manual comparison of satellite interface data sheets is used, its efficiency and accuracy can no longer adapt to the current satellite production, which seriously affects the progress and quality assurance of satellite development. The automatic matching method of satellite interface data sheets can ensure that the comparison results are highly efficient and accurate during the comparison process, and can ensure that all interconnected information in the satellite interface data sheets can be checked and compared. However, there is no clear method and rule for the current IDS comparison work. Most of them are based on experience and one-by-one comparison, which is difficult to directly convert into automatic matching rules that can be used for IDS.

[0003] As an important basis for the development status of satellites, IDS can provide a reference for clarifying the satellite status during the design, development, testing and operation of satellites. The IDS automatic matching method proposed in this paper formulates the filling specifications of the content of each interconnected information on the IDS, and proposes retrieval and matching rules for automatic matching based on the standard conditions. The automatic matching method proposed in this invention can quickly and comprehensively compare the interconnected information in the IDS, accelerate the convergence of the satellite status, and play an important role in the current situation where the satellite development cycle is greatly shortened. Summary of the invention

[0004] In view of the defects in the prior art, the object of the present invention is to provide a satellite interface data sheet automatic matching method and system.

[0005] A satellite interface data sheet automatic matching method provided by the present invention comprises:

[0006] Step S1: Formulate the information filling specification of satellite IDS, and fill in the interconnection information in all satellite IDS according to the specification;

[0007] Step S2: read the IDS and extract the product interconnection element information in all IDS files;

[0008] Step S3: Automatically match all extracted product interconnection information using specified retrieval and matching rules;

[0009] Step S4: If the interconnected information can be successfully matched, the information is determined to be correct, and if it cannot be successfully matched, the information is determined to be incorrect; the element content that cannot be successfully matched is marked, and then all matching information is output.

[0010] Preferably, in step S1:

[0011] The characteristics and contents of IDS include:

[0012] The IDS consists of Interface Data Sheet 3 Electrical Connector and Interface Data Sheet 4 Electrical Connector Contact Allocation Table, each of which contains multiple sheets;

[0013] The contents of the interface data sheet 3 electrical connector include: subsystem name, equipment name, electrical connector code, equipment code, electrical connector description, electrical connector model and corresponding equipment code;

[0014] The content of the electrical connector contact allocation table of the interface data sheet 4 includes the product interconnection element information: contact number, destination, signal content, voltage, current, polarity, signal type, line type and remarks;

[0015] Fill in the IDS information according to the standard filling criteria, including the destination, signal content and description:

[0016] Destination: Fill in the format of arrow+single machine abbreviation-connector number;

[0017] Signal content: Fill in according to the signal type and actual signal content;

[0018] Remarks: Supplementary instructions.

[0019] Preferably, in step S2:

[0020] Convert the IDS of each subsystem into EXCEL format, and use comparison software to read and extract the contents of the contact allocation table of interface data sheet 3 electrical connector and interface data sheet 4 electrical connector in the IDS.

[0021] Preferably, in step S3:

[0022] Traverse each Excel file, analyze all the interface data in the file, and search for all Excel file data in the directory, and judge the destination abbreviated expression in combination with the abbreviated table data;

[0023] Content consistency search rules:

[0024] Traverse each Excel file, and search the entire directory for all interface data sheets and 4 electrical connector contact allocation table data in the file according to the signal content, and find all data with consistent signal content;

[0025] The destination column data is judged. If it is an empty point or self-check, it will not be processed; the row is directly copied and retained in the result;

[0026] Judge the destination and signal content column data. If both columns are empty, jump out of the current loop.

[0027] The destination of the retrieved data cannot be a null point or self-check, otherwise the data will be ignored;

[0028] Content consistency comparison rules:

[0029] If either the destination or the signal content is empty, an error is reported;

[0030] If the destination is an empty point or self-check, it is correct;

[0031] Determine the destination data of the first result. If the arrow directions are consistent, the cell is marked in red and an error is reported. If the arrow directions are opposite, it is correct. If it is a double arrow, the other side must be a double arrow, otherwise an error is reported.

[0032] If the destination content is not in the abbreviation table after removing the arrow and -, an error is reported; if the Xxx at the end of the destination is not the end of the electrical connector code of the first result, an error is reported;

[0033] The voltage, current, polarity, signal type and linear data are compared in full words. If the comparison results are different, the cells of the comparison results are marked in red.

[0034] Compare the number of docking points, separated by commas. If the number is inconsistent, it is also considered an error. If letters and - appear at the same time, mark them in red.

[0035] Detect the contact numbers in the current table and judge the numbers. If there are duplicates, missing numbers, or numbers exceeding the maximum value, a description will be given below the table to remind you.

[0036] If the signal content contains blank characters, the signal content and correctness will be marked in yellow. Yellow has a lower priority than red and will be overwritten.

[0037] The signal content does not retrieve the same data and an error is reported.

[0038] Preferably, in step S4:

[0039] After the automatic matching is completed, the comparison results are output, including:

[0040] Generate an Excel file and name the sheet: Signal Content Consistency Check;

[0041] The signal content consistency check result of each Excel file is output as a sheet, and each interface data sheet 4 electrical connector contact allocation table has two blank lines and is marked in gray;

[0042] Connector specification inspection and comparison rules, including:

[0043] If the number of electrical connector code searches in Form 3 is 0, the electrical connector code and model are marked in red, indicating an error;

[0044] If the number of electrical connector code searches in Form 3 is greater than 0, the electrical connector models of both parties are compared. If they are consistent, they are marked as correct. If they are inconsistent, the electrical connector model is marked in red and marked as incorrect.

[0045] A satellite interface data sheet automatic matching system provided by the present invention comprises:

[0046] Module M1: Formulate the information filling specifications for satellite IDS, and fill in the interconnection information in all satellite IDS according to the specifications;

[0047] Module M2: reads IDS and extracts product interconnection element information from all IDS files;

[0048] Module M3: Automatically match all extracted product interconnection information using specified retrieval and matching rules;

[0049] Module M4: If the interconnected information can be successfully matched, the information is judged to be correct, and if it cannot be successfully matched, the information is judged to be incorrect; the element content that cannot be successfully matched is marked, and then all matching information is output.

[0050] Preferably, in the module M1:

[0051] The characteristics and contents of IDS include:

[0052] The IDS consists of Interface Data Sheet 3 Electrical Connector and Interface Data Sheet 4 Electrical Connector Contact Allocation Table, each of which contains multiple sheets;

[0053] The contents of the interface data sheet 3 electrical connector include: subsystem name, equipment name, electrical connector code, equipment code, electrical connector description, electrical connector model and corresponding equipment code;

[0054] The content of the electrical connector contact allocation table of the interface data sheet 4 includes the product interconnection element information: contact number, destination, signal content, voltage, current, polarity, signal type, line type and remarks;

[0055] Fill in the IDS information according to the standard filling criteria, including the destination, signal content and description:

[0056] Destination: Fill in the format of arrow+single machine abbreviation-connector number;

[0057] Signal content: Fill in according to the signal type and actual signal content;

[0058] Remarks: Supplementary instructions.

[0059] Preferably, in the module M2:

[0060] Convert the IDS of each subsystem into EXCEL format, and use comparison software to read and extract the contents of the contact allocation table of interface data sheet 3 electrical connector and interface data sheet 4 electrical connector in the IDS.

[0061] Preferably, in the module M3:

[0062] Traverse each Excel file, analyze all the interface data in the file, and search for all Excel file data in the directory, and judge the destination abbreviated expression in combination with the abbreviated table data;

[0063] Content consistency search rules:

[0064] Traverse each Excel file, and search the entire directory for all interface data sheets and 4 electrical connector contact allocation table data in the file according to the signal content, and find all data with consistent signal content;

[0065] The destination column data is judged. If it is an empty point or self-check, it will not be processed; the row is directly copied and retained in the result;

[0066] Judge the destination and signal content column data. If both columns are empty, jump out of the current loop.

[0067] The destination of the retrieved data cannot be a null point or self-check, otherwise the data will be ignored;

[0068] Content consistency comparison rules:

[0069] If either the destination or the signal content is empty, an error is reported;

[0070] If the destination is an empty point or self-check, it is correct;

[0071] Determine the destination data of the first result. If the arrow directions are consistent, the cell is marked in red and an error is reported. If the arrow directions are opposite, it is correct. If it is a double arrow, the other side must be a double arrow, otherwise an error is reported.

[0072] If the destination content is not in the abbreviation table after removing the arrow and -, an error is reported; if the Xxx at the end of the destination is not the end of the electrical connector code of the first result, an error is reported;

[0073] The voltage, current, polarity, signal type and linear data are compared in full words. If the comparison results are different, the cells of the comparison results are marked in red.

[0074] Compare the number of docking points, separated by commas. If the number is inconsistent, it is also considered an error. If letters and - appear at the same time, mark them in red.

[0075] Detect the contact numbers in the current table and judge the numbers. If there are duplicates, missing numbers, or numbers exceeding the maximum value, a description will be given below the table to remind you.

[0076] If the signal content contains blank characters, the signal content and correctness will be marked in yellow. Yellow has a lower priority than red and will be overwritten.

[0077] The signal content does not retrieve the same data and an error is reported.

[0078] Preferably, in the module M4:

[0079] After the automatic matching is completed, the comparison results are output, including:

[0080] Generate an Excel file and name the sheet: Signal Content Consistency Check;

[0081] The signal content consistency check result of each Excel file is output as a sheet, and each interface data sheet 4 electrical connector contact allocation table has two blank lines and is marked in gray;

[0082] Connector specification inspection and comparison rules, including:

[0083] If the number of electrical connector code searches in Form 3 is 0, the electrical connector code and model are marked in red, indicating an error;

[0084] If the number of electrical connector code searches in Form 3 is greater than 0, the electrical connector models of both parties are compared. If they are consistent, they are marked as correct. If they are inconsistent, the electrical connector model is marked in red and marked as incorrect.

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

[0086] 1. The filling specification of the electrical connector contact table stipulated in the present invention can ensure the accuracy, consistency and reliability of information filling, avoid ambiguity and misunderstanding caused by non-standard information filling, and provide strong support for the management and maintenance of satellite status;

[0087] 2. The satellite interface data sheet automatic matching method proposed in the present invention improves the defects of errors and inefficiency caused by manual comparison, greatly saves manpower and time, and shortens the satellite development cycle. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0089] Figure 1 It is a flowchart of the automatic matching method of satellite interface data sheet in an embodiment of the present invention;

[0090] Figure 2 It is a schematic diagram of the implementation of the satellite interface data sheet automatic matching method in an embodiment of the present invention;

[0091] Figure 3 A schematic diagram of the electrical connector contact allocation input for the satellite interface data sheet automatic matching method in an embodiment of the present invention;

[0092] Figure 4 A schematic diagram of an electrical connector table input into the satellite interface data sheet automatic matching method according to an embodiment of the present invention;

[0093] Figure 5 It is a system business interface of the satellite interface data sheet automatic matching method in the embodiment of the present invention;

[0094] Figure 6 This is a diagram showing the output result of the satellite interface data sheet automatic matching method in an embodiment of the present invention. DETAILED DESCRIPTION

[0095] The present invention is described in detail below in conjunction with specific embodiments. The following embodiments will help those skilled in the art to further understand the present invention, but are not intended to limit the present invention in any form. It should be noted that, for those of ordinary skill in the art, several changes and improvements can also be made without departing from the concept of the present invention. These all belong to the protection scope of the present invention.

[0096] Embodiment 1:

[0097] The present invention provides a satellite interface data sheet automatic matching method, which includes: formulating information filling specifications in the interface data sheet; reading the standardized filled interface data sheet file, extracting signal content, destination, contact number, electrical connector code and other element information in the file; using the specified retrieval and matching rules to automatically match the extracted information; outputting the content that can be successfully matched with the interconnection information normally, and judging the interconnection information that cannot be successfully matched as an isolated point; marking the element content that cannot be successfully matched and then outputting all the information. Compared with the traditional manual comparison method, the present invention can realize high-precision retrieval and comparison of all interconnection relationship elements in the interface data sheet, and significantly improves the correctness and inspection efficiency of the interconnection information of the interface data sheet.

[0098] According to a satellite interface data sheet automatic matching method provided by the present invention, Figure 1-Figure 6 As shown, including:

[0099] Step S1: Formulate the information filling specification of satellite IDS, and fill in the interconnection information in all satellite IDS according to the specification;

[0100] Specifically, in step S1:

[0101] The characteristics and contents of IDS include:

[0102] The IDS consists of Interface Data Sheet 3 Electrical Connector and Interface Data Sheet 4 Electrical Connector Contact Allocation Table, each of which contains multiple sheets;

[0103] The contents of the interface data sheet 3 electrical connector include: subsystem name, equipment name, electrical connector code, equipment code, electrical connector description, electrical connector model and corresponding equipment code;

[0104] The content of the electrical connector contact allocation table of the interface data sheet 4 includes the product interconnection element information: contact number, destination, signal content, voltage, current, polarity, signal type, line type and remarks;

[0105] Fill in the IDS information according to the standard filling criteria, including the destination, signal content and description:

[0106] Destination: Fill in the format of arrow+single machine abbreviation-connector number;

[0107] Signal content: Fill in according to the signal type and actual signal content;

[0108] Remarks: Supplementary instructions.

[0109] Step S2: read the IDS and extract the product interconnection element information in all IDS files;

[0110] Specifically, in step S2:

[0111] Convert the IDS of each subsystem into EXCEL format, and use comparison software to read and extract the contents of the contact allocation table of interface data sheet 3 electrical connector and interface data sheet 4 electrical connector in the IDS.

[0112] Step S3: Automatically match all extracted product interconnection information using specified retrieval and matching rules;

[0113] Specifically, in step S3:

[0114] Traverse each Excel file, analyze all the interface data in the file, and search for all Excel file data in the directory, and judge the destination abbreviated expression in combination with the abbreviated table data;

[0115] Content consistency search rules:

[0116] Traverse each Excel file, and search the entire directory for all interface data sheets and 4 electrical connector contact allocation table data in the file according to the signal content, and find all data with consistent signal content;

[0117] The destination column data is judged. If it is an empty point or self-check, it will not be processed; the row is directly copied and retained in the result;

[0118] Judge the destination and signal content column data. If both columns are empty, jump out of the current loop.

[0119] The destination of the retrieved data cannot be a null point or self-check, otherwise the data will be ignored;

[0120] Content consistency comparison rules:

[0121] If either the destination or the signal content is empty, an error is reported;

[0122] If the destination is an empty point or self-check, it is correct;

[0123] Determine the destination data of the first result. If the arrow directions are consistent, the cell is marked in red and an error is reported. If the arrow directions are opposite, it is correct. If it is a double arrow, the other side must be a double arrow, otherwise an error is reported.

[0124] If the destination content is not in the abbreviation table after removing the arrow and -, an error is reported; if the Xxx at the end of the destination is not the end of the electrical connector code of the first result, an error is reported;

[0125] The voltage, current, polarity, signal type and linear data are compared in full words. If the comparison results are different, the cells of the comparison results are marked in red.

[0126] Compare the number of docking points, separated by commas. If the number is inconsistent, it is also considered an error. If letters and - appear at the same time, mark them in red.

[0127] Detect the contact numbers in the current table and judge the numbers. If there are duplicates, missing numbers, or numbers exceeding the maximum value, a description will be given below the table to remind you.

[0128] If the signal content contains blank characters, the signal content and correctness will be marked in yellow. Yellow has a lower priority than red and will be overwritten.

[0129] The signal content does not retrieve the same data and an error is reported.

[0130] Step S4: If the interconnected information can be successfully matched, the information is determined to be correct, and if it cannot be successfully matched, the information is determined to be incorrect; the element content that cannot be successfully matched is marked, and then all matching information is output.

[0131] Specifically, in step S4:

[0132] After the automatic matching is completed, the comparison results are output, including:

[0133] Generate an Excel file and name the sheet: Signal Content Consistency Check;

[0134] The signal content consistency check result of each Excel file is output as a sheet, and each interface data sheet 4 electrical connector contact allocation table has two blank lines and is marked in gray;

[0135] Connector specification inspection and comparison rules, including:

[0136] If the number of electrical connector code searches in Form 3 is 0, the electrical connector code and model are marked in red, indicating an error;

[0137] If the number of electrical connector code searches in Form 3 is greater than 0, the electrical connector models of both parties are compared. If they are consistent, they are marked as correct. If they are inconsistent, the electrical connector model is marked in red and marked as incorrect.

[0138] Embodiment 2:

[0139] Embodiment 2 is a preferred example of Embodiment 1, and is used to illustrate the present invention in more detail.

[0140] The present invention also provides a satellite interface data sheet automatic matching system, which can be implemented by executing the process steps of the satellite interface data sheet automatic matching method, that is, those skilled in the art can understand the satellite interface data sheet automatic matching method as a preferred implementation of the satellite interface data sheet automatic matching system.

[0141] A satellite interface data sheet automatic matching system provided by the present invention comprises:

[0142] Module M1: Formulate the information filling specifications for satellite IDS, and fill in the interconnection information in all satellite IDS according to the specifications;

[0143] Specifically, in the module M1:

[0144] The characteristics and contents of IDS include:

[0145] The IDS consists of Interface Data Sheet 3 Electrical Connector and Interface Data Sheet 4 Electrical Connector Contact Allocation Table, each of which contains multiple sheets;

[0146] The contents of the interface data sheet 3 electrical connector include: subsystem name, equipment name, electrical connector code, equipment code, electrical connector description, electrical connector model and corresponding equipment code;

[0147] The content of the electrical connector contact allocation table of the interface data sheet 4 includes the product interconnection element information: contact number, destination, signal content, voltage, current, polarity, signal type, line type and remarks;

[0148] Fill in the IDS information according to the standard filling criteria, including the destination, signal content and description:

[0149] Destination: Fill in the format of arrow+single machine abbreviation-connector number;

[0150] Signal content: Fill in according to the signal type and actual signal content;

[0151] Remarks: Supplementary instructions.

[0152] Module M2: reads IDS and extracts product interconnection element information from all IDS files;

[0153] Specifically, in the module M2:

[0154] Convert the IDS of each subsystem into EXCEL format, and use comparison software to read and extract the contents of the contact allocation table of interface data sheet 3 electrical connector and interface data sheet 4 electrical connector in the IDS.

[0155] Module M3: Automatically match all extracted product interconnection information using specified retrieval and matching rules;

[0156] Specifically, in the module M3:

[0157] Traverse each Excel file, analyze all the interface data in the file, and search for all Excel file data in the directory, and judge the destination abbreviated expression in combination with the abbreviated table data;

[0158] Content consistency search rules:

[0159] Traverse each Excel file, and search the entire directory for all interface data sheets and 4 electrical connector contact allocation table data in the file according to the signal content, and find all data with consistent signal content;

[0160] The destination column data is judged. If it is an empty point or self-check, it will not be processed; the row is directly copied and retained in the result;

[0161] Judge the destination and signal content column data. If both columns are empty, jump out of the current loop.

[0162] The destination of the retrieved data cannot be a null point or self-check, otherwise the data will be ignored;

[0163] Content consistency comparison rules:

[0164] If either the destination or the signal content is empty, an error is reported;

[0165] If the destination is an empty point or self-check, it is correct;

[0166] Determine the destination data of the first result. If the arrow directions are consistent, the cell is marked in red and an error is reported. If the arrow directions are opposite, it is correct. If it is a double arrow, the other side must be a double arrow, otherwise an error is reported.

[0167] If the destination content is not in the abbreviation table after removing the arrow and -, an error is reported; if the Xxx at the end of the destination is not the end of the electrical connector code of the first result, an error is reported;

[0168] The voltage, current, polarity, signal type and linear data are compared in full words. If the comparison results are different, the cells of the comparison results are marked in red.

[0169] Compare the number of docking points, separated by commas. If the number is inconsistent, it is also considered an error. If letters and - appear at the same time, mark them in red.

[0170] Detect the contact numbers in the current table and judge the numbers. If there are duplicates, missing numbers, or numbers exceeding the maximum value, a description will be given below the table to remind you.

[0171] If the signal content contains blank characters, the signal content and correctness will be marked in yellow. Yellow has a lower priority than red and will be overwritten.

[0172] The signal content does not retrieve the same data and an error is reported.

[0173] Module M4: If the interconnected information can be successfully matched, the information is judged to be correct, and if it cannot be successfully matched, the information is judged to be incorrect; the element content that cannot be successfully matched is marked, and then all matching information is output.

[0174] Specifically, in the module M4:

[0175] After the automatic matching is completed, the comparison results are output, including:

[0176] Generate an Excel file and name the sheet: Signal Content Consistency Check;

[0177] The signal content consistency check result of each Excel file is output as a sheet, and each interface data sheet 4 electrical connector contact allocation table has two blank lines and is marked in gray;

[0178] Connector specification inspection and comparison rules, including:

[0179] If the number of electrical connector code searches in Form 3 is 0, the electrical connector code and model are marked in red, indicating an error;

[0180] If the number of electrical connector code searches in Form 3 is greater than 0, the electrical connector models of both parties are compared. If they are consistent, they are marked as correct. If they are inconsistent, the electrical connector model is marked in red and marked as incorrect.

[0181] Embodiment 3:

[0182] Embodiment 3 is a preferred example of Embodiment 1, and is used to illustrate the present invention in more detail.

[0183] In view of the defects of the current manual method for IDS comparison, the purpose of the present invention is to provide a satellite interface data sheet automatic matching method. By matching and comparing the interface data sheet with the whole satellite interconnection relationship information, a higher IDS comparison rate and a lower error rate can be achieved, which solves the problems of low comparison efficiency and frequent errors and omissions in information comparison existing in the previous manual comparison method.

[0184] The satellite interface data sheet automatic matching method provided by the present invention comprises the following steps:

[0185] Step S1: Formulate the information filling specification of satellite IDS, and fill in the interconnection information in all IDSs according to the specification;

[0186] Step S2: extracting information on product interconnection elements such as signal content, subsystem name, device name, device code, electrical connector code, electrical connector model, destination, contact number, voltage, current, polarity, signal type, line type, remarks, and electrical connector code from all IDS files;

[0187] Step S3: Automatically match all extracted product interconnection information using specified retrieval and matching rules;

[0188] Step S4: If the interconnected information can be successfully matched, the information is determined to be correct, and if it cannot be successfully matched, the information is determined to be incorrect; the element content that cannot be successfully matched is marked, and then all matching information is output.

[0189] Preferably, the filling specification of the electrical connector contact information of the IDS is shown in the following table.

[0190] Table 1 Filling specification of electrical connector contact information

[0191]

[0192]

[0193]

[0194]

[0195] Preferably, no blank lines are left in the middle of the valid signal content.

[0196] Preferably, the node number part of the connector containing English characters is separated by commas: A, B, C, D, E; "-" or "~" is not used; the numbers in the node number can be represented by "1-10"; the voltage and current remain uniform.

[0197] Preferably, the RS422 / LVDS / 2711 / optical fiber signal names do not use "A machine, B machine, A, B", and are uniformly represented by "master, standby".

[0198] Preferably, if the OC gate is only responsible for the power on and off of its own single machine, no command return line is required (the negative pulse of the OC gate can be understood as a return line); if it is responsible for the power on and off of a single machine of a back-end product, the command return line is not interconnected inside the single machine, but is connected to the PCDU benchmark with 4 wires.

[0199] Preferably, a secondary ground is left for the + and - of each LVDS signal and connected to the shielding layer (P-GND), without adding additional cables.

[0200] Preferably, the tower model scattered wires are connected to the solar circuit, and the solar circuit is connected to the driving mechanism. In the description of the IDS of the solar circuit, it is noted that the scattered wires are connected to the tower model, and the connector is connected to the driving mechanism; the signal connection between the driving mechanism and the outside of the cabin is named after the name of the outside cabin mechanism.

[0201] The consistency search and comparison rules for the electrical connector contact allocation table are as follows:

[0202] Electrical connector contact allocation table retrieval rules:

[0203] 1) Traverse each Excel file, and search all the "Interface Data Sheet 4: Electrical Connector Contact Allocation Table" data in the file according to the "Signal Content" (except the currently traversed form 4), and find all the data with the same "Signal Content"

[0204] 2) Judge the data in the "Destination" column. If it is empty or self-checked, do not process it; directly copy the row and keep it in the result;

[0205] 3) Judge the data in the "Destination" and "Signal Content" columns. If both columns are empty, jump out of the current loop;

[0206] 4) The destination of the retrieved data cannot be empty or self-checked, otherwise the data will be ignored.

[0207] Electrical connector contact allocation table comparison rules:

[0208] 1) If either "Destination" or "Signal Content" is empty, an error will be reported;

[0209] 2) If "Destination" is empty or self-checked, it is correct;

[0210] 3) Check the "direction" data of the first result. If the arrows are in the same direction, the cell is marked in red and an error is reported. If the arrows are in opposite directions, it is correct. If it is a double arrow, the other side must be a double arrow, otherwise an error is reported.

[0211] 4) If the "Destination" content is not in the abbreviation table after removing the arrow and "-", an error is reported; if the Xxx (such as X05) at the end of the "Destination" is not the end of the first result electrical connector code, an error is reported;

[0212] 5) Perform full word comparison on voltage, current, polarity, signal type and linear data. If the comparison results are different, the cells of the comparison results will be marked in red.

[0213] 6) Compare the number of docking point numbers and divide them according to "," If the number is inconsistent (note that the 4-6 format needs to be parsed, there are 3 dots), it is also considered an error. If letters and "-" (such as ad) appear at the same time, mark them in red;

[0214] 7) Check the contact numbers in the current table and judge the numbers (not the letters). If there are duplicates, missing numbers, or numbers exceeding the maximum value, a description will be given below the table to remind you.

[0215] 8) If the signal content contains blank characters, the signal content and correctness will be marked in yellow. Yellow has a lower priority than red and can be overwritten;

[0216] 9) "Signal content" does not retrieve the same data and reports an error;

[0217] 10) The above 9 items (signal content (required), destination, contact number, voltage, current, polarity, signal type, line type) are all descriptions in the selected state and participate in the correctness comparison; if not selected, they will not participate in the correctness comparison, and the abnormal content can be directly marked in yellow.

[0218] Output rules for electrical connector contact allocation table:

[0219] 1) Generate an Excel file and name the sheet: Signal Content Consistency Check

[0220] 2) Output the signal content consistency check results of each Excel file into a sheet, with two blank lines marked in gray between each "Interface Data Sheet 4: Electrical Connector Contact Allocation Table"

[0221] The electrical connector comparison rules are as follows:

[0222] 1) If the number of electrical connector code searches in Form 3 is 0, the electrical connector code and model are marked in red, indicating an error.

[0223] 2) If the number of electrical connector code searches in Form 3 is greater than 0, compare the electrical connector models of both parties. If they are consistent, mark them as correct. If they are inconsistent, mark the electrical connector model in red and mark them as incorrect.

[0224] Figure 1 FIG. 1 is a flow chart of the automatic matching method for satellite interface data sheet according to an embodiment of the present invention. Figure 1 As shown, the IDS automatic matching method provided by the present invention adopts the standardized interface data sheet information as the basic input, mainly including the product interconnection information in the IDS sheet: signal content, signal destination, subsystem name, single machine name, voltage and current, etc.;

[0225] Figure 2 FIG. 1 is a schematic diagram of a method for automatically matching satellite interface data in an embodiment of the present invention. Figure 2 As shown, in the embodiment of the present invention, the IDS file is converted into an Excel file as input.

[0226] In the embodiment of the present invention, the schematic diagram of the input electrical connector contact allocation table is as follows: Figure 3 shown.

[0227] In the embodiment of the present invention, the schematic diagram of the input electrical connector table is as follows: Figure 4 shown.

[0228] Figure 5 This is the business system interface for implementing the method in the embodiment of the present invention. The business system is designed to implement the automatic comparison method proposed in the present invention. Users can click various operation buttons on the business interface to implement the process of data input and automatic comparison and output, which is convenient for users to operate.

[0229] In an embodiment of the present invention, Figure 6 This is a result table output by signal content consistency comparison. The data cells without color markings in the figure are data that can be matched normally, and the data cells with color markings are data that cannot be matched normally. The output results are expressed in Excel format.

[0230] Those skilled in the art know that, in addition to realizing the system and its various devices, modules, and units provided by the present invention in a purely computer-readable program code, it is entirely possible to realize the same functions in the form of logic gates, switches, application-specific integrated circuits, programmable logic controllers, and embedded microcontrollers by logically programming the method steps. Therefore, the system and its various devices, modules, and units provided by the present invention can be considered as a hardware component, and the devices, modules, and units included therein for realizing various functions can also be regarded as structures within the hardware component; the devices, modules, and units for realizing various functions can also be regarded as both software modules for realizing the method and structures within the hardware component.

[0231] The above describes the specific embodiments of the present invention. It should be understood that the present invention is not limited to the above specific embodiments, and those skilled in the art can make various changes or modifications within the scope of the claims, which does not affect the essence of the present invention. In the absence of conflict, the embodiments of the present application and the features in the embodiments can be combined with each other arbitrarily.

Claims

1. A satellite interface data sheet automatic matching method, characterized in that: include: Step S1: Formulate the information filling specification of satellite IDS, and fill in the interconnection information in all satellite IDS according to the specification; Step S2: read the IDS and extract the product interconnection element information in all IDS files; Step S3: Automatically match all extracted product interconnection information using specified retrieval and matching rules; Step S4: If the interconnected information can be successfully matched, the information is determined to be correct, and if it cannot be successfully matched, the information is determined to be incorrect; the element content that cannot be successfully matched is marked, and then all matching information is output.

2. The satellite interface data sheet automatic matching method according to claim 1, characterized in that: In step S1: The characteristics and contents of IDS include: The IDS consists of Interface Data Sheet 3 Electrical Connector and Interface Data Sheet 4 Electrical Connector Contact Allocation Table, each of which contains multiple sheets; The contents of the interface data sheet 3 electrical connector include: subsystem name, equipment name, electrical connector code, equipment code, electrical connector description, electrical connector model and corresponding equipment code; The content of the electrical connector contact allocation table of the interface data sheet 4 includes the product interconnection element information: contact number, destination, signal content, voltage, current, polarity, signal type, line type and remarks; Fill in the IDS information according to the standard filling criteria, including the destination, signal content and description: Destination: Fill in the format of arrow+single machine abbreviation-connector number; Signal content: Fill in according to the signal type and actual signal content; Remarks: Supplementary instructions.

3. The satellite interface data sheet automatic matching method according to claim 1, characterized in that: In step S2: Convert the IDS of each subsystem into EXCEL format, and use comparison software to read and extract the contents of the contact allocation table of interface data sheet 3 electrical connector and interface data sheet 4 electrical connector in the IDS.

4. The satellite interface data sheet automatic matching method according to claim 1, characterized in that: In step S3: Traverse each Excel file, analyze all the interface data in the file, and analyze the 4-point electrical connector contact allocation table data. The search range is all the Excel file data in the directory, and the destination abbreviated expression is judged in combination with the abbreviated table data. Content consistency search rules: Traverse each Excel file, and search the entire directory for all interface data sheets and 4 electrical connector contact allocation table data in the file according to the signal content, and find all data with consistent signal content; The destination column data is judged. If it is an empty point or self-check, it will not be processed; the row is directly copied and retained in the result; Judge the destination and signal content column data. If both columns are empty, jump out of the current loop. The destination of the retrieved data cannot be a null point or self-check, otherwise the data will be ignored; Content consistency comparison rules: If either the destination or the signal content is empty, an error is reported; If the destination is an empty point or self-check, it is correct; Determine the destination data of the first result. If the arrow directions are consistent, the cell is marked in red and an error is reported; if the arrow directions are opposite, it is correct. If it is a double arrow, the other side must be a double arrow, otherwise an error will be reported; If the destination content is not in the abbreviation table after removing the arrow and -, an error is reported; if the Xxx at the end of the destination is not the end of the electrical connector code of the first result, an error is reported; The voltage, current, polarity, signal type and linear data are compared in full words. If the comparison results are different, the cells of the comparison results are marked in red. Compare the number of docking points, separated by commas. If the number is inconsistent, it is also considered an error. If letters and - appear at the same time, mark them in red. Detect the contact numbers in the current table and judge the numbers. If there are duplicates, missing numbers, or numbers exceeding the maximum value, a description will be given below the table to remind you. If the signal content contains blank characters, the signal content and correctness will be marked in yellow. Yellow has a lower priority than red and will be overwritten. The signal content does not retrieve the same data and an error is reported.

5. The satellite interface data sheet automatic matching method according to claim 1, characterized in that: In step S4: After the automatic matching is completed, the comparison results are output, including: Generate an Excel file and name the sheet: Signal Content Consistency Check; The signal content consistency check result of each Excel file is output as a sheet, and each interface data sheet 4 electrical connector contact allocation table has two blank lines and is marked in gray; Connector specification inspection and comparison rules, including: If the number of electrical connector code searches in Form 3 is 0, the electrical connector code and model are marked in red, indicating an error; If the number of electrical connector code searches in Form 3 is greater than 0, the electrical connector models of both parties are compared. If they are consistent, they are marked as correct. If they are inconsistent, the electrical connector model is marked in red and marked as incorrect.

6. A satellite interface data sheet automatic matching system, characterized in that: include: Module M1: Formulate the information filling specifications for satellite IDS, and fill in the interconnection information in all satellite IDS according to the specifications; Module M2: reads IDS and extracts product interconnection element information from all IDS files; Module M3: Automatically match all extracted product interconnection information using specified retrieval and matching rules; Module M4: If the interconnected information can be successfully matched, the information is judged to be correct, and if it cannot be successfully matched, the information is judged to be incorrect; the element content that cannot be successfully matched is marked, and then all matching information is output.

7. The satellite interface data sheet automatic matching system according to claim 6, characterized in that: In the module M1: The characteristics and contents of IDS include: The IDS consists of Interface Data Sheet 3 Electrical Connector and Interface Data Sheet 4 Electrical Connector Contact Allocation Table, each of which contains multiple sheets; The contents of the interface data sheet 3 electrical connector include: subsystem name, equipment name, electrical connector code, equipment code, electrical connector description, electrical connector model and corresponding equipment code; The content of the electrical connector contact allocation table of the interface data sheet 4 includes the product interconnection element information: contact number, destination, signal content, voltage, current, polarity, signal type, line type and remarks; Fill in the IDS information according to the standard filling criteria, including the destination, signal content and description: Destination: Fill in the format of arrow+single machine abbreviation-connector number; Signal content: Fill in according to the signal type and actual signal content; Remarks: Supplementary instructions.

8. The satellite interface data sheet automatic matching system according to claim 6, characterized in that: In the module M2: Convert the IDS of each subsystem into EXCEL format, and use comparison software to read and extract the contents of the contact allocation table of interface data sheet 3 electrical connector and interface data sheet 4 electrical connector in the IDS.

9. The satellite interface data sheet automatic matching system according to claim 6, characterized in that: In the module M3: Traverse each Excel file, analyze all the interface data in the file, and analyze the 4-point electrical connector contact allocation table data. The search range is all the Excel file data in the directory, and the destination abbreviated expression is judged in combination with the abbreviated table data. Content consistency search rules: Traverse each Excel file, and search the entire directory for all interface data sheets and 4 electrical connector contact allocation table data in the file according to the signal content, and find all data with consistent signal content; The destination column data is judged. If it is an empty point or self-check, it will not be processed; the row is directly copied and retained in the result; Judge the destination and signal content column data. If both columns are empty, jump out of the current loop. The destination of the retrieved data cannot be a null point or self-check, otherwise the data will be ignored; Content consistency comparison rules: If either the destination or the signal content is empty, an error is reported; If the destination is an empty point or self-check, it is correct; Determine the destination data of the first result. If the arrow directions are consistent, the cell is marked in red and an error is reported; if the arrow directions are opposite, it is correct. If it is a double arrow, the other side must be a double arrow, otherwise an error will be reported; If the destination content is not in the abbreviation table after removing the arrow and -, an error is reported; if the Xxx at the end of the destination is not the end of the electrical connector code of the first result, an error is reported; The voltage, current, polarity, signal type and linear data are compared in full words. If the comparison results are different, the cells of the comparison results are marked in red. Compare the number of docking points, separated by commas. If the number is inconsistent, it is also considered an error. If letters and - appear at the same time, mark them in red. Detect the contact numbers in the current table and judge the numbers. If there are duplicates, missing numbers, or numbers exceeding the maximum value, a description will be given below the table to remind you. If the signal content contains blank characters, the signal content and correctness will be marked in yellow. Yellow has a lower priority than red and will be overwritten. The signal content does not retrieve the same data and an error is reported.

10. The satellite interface data sheet automatic matching system according to claim 6, characterized in that: In the module M4: After the automatic matching is completed, the comparison results are output, including: Generate an Excel file and name the sheet: Signal Content Consistency Check; The signal content consistency check result of each Excel file is output as a sheet, and each interface data sheet 4 electrical connector contact allocation table has two blank lines and is marked in gray; Connector specification inspection and comparison rules, including: If the number of electrical connector code searches in Form 3 is 0, the electrical connector code and model are marked in red, indicating an error; If the number of electrical connector code searches in Form 3 is greater than 0, the electrical connector models of both parties are compared. If they are consistent, they are marked as correct. If they are inconsistent, the electrical connector model is marked in red and marked as incorrect.

Images