Multi-channel data automatic acquisition system and method

Abstract

The invention discloses a multi-channel data automatic acquisition system and method, which is applicable to the testing field of multi-channel parameters of a single board or a whole machine. The invention comprises a computer, an RS-232 interface cable, a 34970A data acquisition switching unit, an acquisition cable, an RS-485 interface cable, an extension unit, a test cable, and a 34901A multiplexer. The main control circuit is formed by using a serial port relay, and the extension unit is designed and manufactured together with an optocoupler isolation relay module. The number of extended acquisition channels can be expanded from 20 to hundreds of channels; 2. A computer control program is written by using C# software through a computer, which is responsible for sending acquisition instructions to 34970A, and reading back the measured data for display, interpretation, and storage; 3. The computer controls the extension unit to close or disconnect the channels in groups of 20 channels, and then sends an acquisition instruction to 34970A, so that the 20-channel multiplexer performs acquisition in sequence, and performs acquisition in a cycle as an acquisition unit.

Description

Technical Field

[0001] The invention relates to a multi-channel data automatic acquisition system and method, and is applicable to the field of testing multi-channel parameters of a single board or a complete machine. Background Art

[0002] In the process of debugging production tasks, we often encounter data testing work of dozens or even hundreds of resistance or voltage. Taking a certain product as an example, 69 resistance tests need to be performed on the product before it is powered on to ensure that there are no problems. In addition, this product is a batch production task with a very large output, so resistance measurement is a huge workload.

[0003] In the traditional testing process, two people usually conduct the test together, one person tests and the other is responsible for recording and electronically entering data. In addition, during the manual data recording and electronic entry process, the following two situations often occur: first, data recording or entry errors often occur; second, the process requires manual judgment of the data range, which is time-consuming and prone to omissions. These two aspects will seriously affect the accuracy of the data.

[0004] Take a product of a certain work number as an example. Before the product is powered on, it needs to be tested for 69 resistance values ​​to ensure that the resistance value is within the range before the product can be powered on. Manual testing is often performed by two people. Manual measurement generally has the following characteristics:

[0005] 1. The test time is long. The test process is usually carried out by two people, one person uses a multimeter to test each point, and the other is responsible for recording and electronic input. The amount of test data is large, and counting points, testing, and recording are time-consuming, and the efficiency is very low. In order to understand the time consumption during the test process, we sampled a wave of 10 products and conducted a survey. The total test time was 130 minutes, and it took 43 minutes to enter the ten data into the computer.

[0006] 2. In the process of manual data recording and electronic data entry, the following two situations often occur: 1. Data recording or data entry errors often occur; 2. The process requires manual judgment of the data range, which is time-consuming and prone to omissions. These two aspects will seriously affect the accuracy of the data. Summary of the invention

[0007] The technical problem solved by the present invention is: to overcome the deficiencies of the prior art, to provide a multi-channel data automatic acquisition system, to realize rapid acquisition and display of multi-channel product data, and to realize automatic data identification and document generation.

[0008] The technical solution of the present invention is: a multi-channel data automatic acquisition system, including a computer, an RS-232 interface cable, a 34970A data acquisition switching unit, an acquisition cable, an RS-485 interface cable, an expansion unit, a test cable, and a 34901A multiplexer;

[0009] The computer is used to send data acquisition instructions to the 34970A data acquisition switching unit according to technical requirements, read back the collected data, interpret the data according to technical requirements, and generate reports; it is used to send instructions to the expansion unit to close and open the channels in sequence according to data acquisition requirements;

[0010] The RS-485 interface cable is used for the computer to send control instructions to the expansion unit;

[0011] The 34970A data acquisition switching unit uses the internal board 34901A multiplexer to collect multi-channel resistances in sequence; and is connected to the computer through an RS-232 interface cable to receive data acquisition instructions; after receiving the data acquisition instructions, the 34970A data acquisition switching unit switches the internal multimeter to the resistance test state as required, and sets the test accuracy and test speed according to technical conditions, so that the 20 channels in the 34901A multiplexer are connected and disconnected as required by the instructions, and the data of the connected channels is collected and saved; after the collection is completed, the computer completes the reading of the data;

[0012] The acquisition cable is used to connect the 34970A data acquisition switching unit and the expansion unit for data acquisition;

[0013] The test cable is used to connect the expansion unit and the product under test to collect data;

[0014] The expansion unit is provided with a plurality of channels, and each group of channels can be closed or opened according to the instruction of the computer to collect parameters.

[0015] Furthermore, the 34901A multiplexer is a dedicated board for the 34970A data acquisition switching unit, including 20 channels with switchable HI and LO inputs, and is used to provide a completely isolated input for the digital multimeter inside the 34970A data acquisition switching unit; the 34901A multiplexer is installed in the 34970A data acquisition switching unit and connected to the expansion unit via an acquisition cable.

[0016] Furthermore, the 34970A data acquisition switching unit has an internal integrated six-and-a-half-digit digital multimeter, which is consistent with the specifications of the 34401A digital multimeter or the 34410A digital multimeter under preset technical conditions.

[0017] Furthermore, the expansion unit has 80 channels of HI input, each of which is a group of 20 channels. A group of channels is closed according to computer instructions, and each channel parameter is collected in conjunction with the 34901A multiplexer.

[0018] Furthermore, by setting the channel closing time, the digital multimeter inside the 34970A data acquisition switching unit can be accurately tested or monitored for a certain channel; through the cooperation of the 34901A multiplexer and the expansion unit, the channel closing time can be set separately for each channel.

[0019] Furthermore, the expansion unit adopts an RS-485 interface.

[0020] Furthermore, the expansion units are provided in multiple numbers according to the requirements.

[0021] Furthermore, the interface connecting the extension unit to the product is a Y2-120 type universal electrical connector, which is convenient for making test cables for other products.

[0022] Furthermore, the channels in the expansion unit use an optocoupler isolation relay module to ensure that the channels for collecting data do not interfere with each other.

[0023] The multi-channel data automatic acquisition method implemented by the multi-channel data automatic acquisition system comprises the following steps:

[0024] Insert the 34901A multiplexer connected to the acquisition cable into the back card slot of the 34970A data acquisition switch unit and connect the expansion unit;

[0025] Connect the 34970A digital acquisition switching unit and the expansion unit to the computer via RS-232 interface cable and RS-485 interface cable respectively;

[0026] Connect the test cable between the extension unit and the product;

[0027] Turn on the test computer and connect the 34970A data acquisition switching unit and the expansion unit;

[0028] After the connection is successful, data collection and interpretation begin. After the test is completed, a test report is generated.

[0029] The advantages of the present invention compared with the prior art are:

[0030] 1. By using serial port relays to form the main control circuit and designing and manufacturing the expansion unit together with the optocoupler isolation relay module, the number of extended acquisition channels can be expanded from 20 to hundreds;

[0031] 2. Use C# software to write a computer control program, which is responsible for sending acquisition instructions to 34970A and reading back the measured data for display, interpretation and storage;

[0032] 3. The computer controls the expansion unit to close or disconnect the channels in groups of 20, and then sends acquisition instructions to 34970A, so that the 20-channel multiplexer collects data in sequence, and collects data cyclically as a collection unit;

[0033] 4. By editing the interpretation function in the program according to the technical requirements, the collected data can be read back to achieve data control, data tolerance interpretation, warnings, and critical data reminders to ensure data accuracy and reliability;

[0034] 5. Generate the test form required by the technical regulations through code editing, set the storage path, and automatically store the collected data in the test form, eliminating the need for manual copying and recording, greatly improving test efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] Figure 1 This is a schematic diagram of a multi-channel data automatic acquisition system;

[0036] Figure 2 This is the principle block diagram of the multi-channel data automatic acquisition system;

[0037] Figure 3 This is the schematic diagram of the expansion unit 6;

[0038] Figure 4 This is the schematic diagram of 34901A. DETAILED DESCRIPTION

[0039] In order to better understand the above technical scheme, the technical scheme of the present application is described in detail below through the accompanying drawings and specific embodiments. It should be understood that the embodiments of the present application and the specific features in the embodiments are detailed descriptions of the technical scheme of the present application, rather than limitations on the technical scheme of the present application. In the absence of conflict, the embodiments of the present application and the technical features in the embodiments can be combined with each other.

[0040] The following is a further detailed description of the multi-channel data automatic acquisition system and method provided by the embodiment of the present application in conjunction with the accompanying drawings. The specific implementation method may include (such as Figures 1 to 4 As shown): computer 1, RS-232 interface cable 2, 34970A data acquisition switching unit 3, acquisition cable 4, RS-485 interface cable 5, expansion unit 6, test cable 7, 34901A multiplexer.

[0041] The computer 1 is used to send data acquisition instructions to the 34970A data acquisition switching unit 3 according to technical requirements, and read back the collected data, and interpret the data according to technical requirements to generate reports; it is used to send instructions to the expansion unit 6 to close and open the channels in sequence according to data acquisition requirements; the RS-485 interface cable 5 is used by the computer 1 to send control instructions to the expansion unit 6; the 34970A data acquisition switching unit 3 uses the internal board 34901A multiplexer to collect multi-channel resistances in sequence; and is connected to the computer 1 through the RS-232 interface cable 2 to receive data acquisition instructions; the 34970A data acquisition switching unit After receiving the data acquisition instruction, element 3 switches the internal multimeter to the resistance test state as required, and sets the test accuracy and test speed according to the technical conditions, so that the 20 channels in the 34901A multiplexer are connected and disconnected as required by the instruction, and the data of the connected channels are collected and saved; after the collection is completed, the computer 1 completes the reading of the data; the collection cable 4 is used to connect the 34970A data acquisition switching unit 3 and the expansion unit 6 for data collection; the test cable 7 is used to connect the expansion unit 6 and the product under test for data collection; the expansion unit 6 is provided with a plurality of channels, and each group of channels can be closed or disconnected according to the instruction of the computer 1 to collect parameters.

[0042] Among them, technical requirements, that is, technical conditions, are documents issued by the design unit to guide testing.

[0043] In one possible implementation, the 34901A multiplexer is a dedicated board for the 34970A data acquisition switching unit 3, including 20 channels that can switch HI and LO inputs, and is used to provide a completely isolated input for the digital multimeter inside the 34970A data acquisition switching unit 3; the 34901A multiplexer is installed in the 34970A data acquisition switching unit 3 and is connected to the expansion unit 6 via an acquisition cable 4.

[0044] Furthermore, in a possible implementation, the 34970A data acquisition switching unit 3 internally integrates a six-and-a-half-digit digital multimeter, which is consistent with the specifications of a 34401A digital multimeter or a 34410A digital multimeter under preset technical conditions.

[0045] In a possible implementation, the expansion unit 6 has 80 channels of HI input, each of which is a group of 20 channels. A group of channels is closed according to the instruction of the computer 1, and the 34901A multiplexer is used to collect parameters of each channel.

[0046] In one possible implementation, by setting the channel closing time, the digital multimeter inside the 34970A data acquisition switching unit 3 can accurately test or monitor a certain channel; through the cooperation of the 34901A multiplexer and the expansion unit 6, the channel closing time can be set separately for each channel.

[0047] Optionally, in a possible implementation, the expansion unit 6 uses an RS-485 interface.

[0048] Optionally, in a possible implementation, a plurality of expansion units 6 are provided according to demand.

[0049] In a possible implementation, the interface connecting the extension unit 6 to the product is a Y2-120 type universal electrical connector, which is convenient for making test cables 7 for other products.

[0050] In a possible implementation, the channels in the extension unit 6 use an optical coupling isolation relay module to ensure that the channels for collecting data do not interfere with each other.

[0051] The multi-channel data automatic acquisition method implemented by the multi-channel data automatic acquisition system comprises the following steps:

[0052] Insert the 34901A multiplexer connected to the acquisition cable 4 into the back card slot of the 34970A data acquisition switching unit 3 and connect it to the expansion unit 6;

[0053] Connect the 34970A digital acquisition switching unit 3 and the expansion unit 6 to the computer 1 via the RS-232 interface cable 2 and the RS-485 interface cable 5 respectively;

[0054] Connect the test cable 7 to the extension unit 6 and the product;

[0055] Turn on the test computer 1 and connect the 34970A data acquisition switching unit 3 and the expansion unit 6;

[0056] After the connection is successful, data collection and interpretation begin. After the test is completed, a test report is generated.

[0057] In the solution provided in the embodiment of the present application, the 34970A digital acquisition switching unit 3, commonly known as a "multi-channel meter", is a high-performance, low-cost half-rack unit host with data acquisition and switching functions. It contains a six-and-a-half-digit digital multimeter and has three card slots on the back, which can flexibly place the switch and control module combination. The instrument has both data recording and data acquisition functions, and can directly measure resistance, DC voltage, AC voltage, DC current, AC current, frequency and period, and save the data in a non-volatile memory. The instrument is equipped with an RS-232 interface and a GPIB interface, which can easily communicate with a computer, receive computer instructions and return collected data.

[0058] The 34901A multiplexer is a board suitable for the 34970A digital acquisition switching unit 3. It has 20 channels that can switch HI and LO inputs, and can provide completely isolated inputs for the digital multimeter inside the 34970A digital acquisition switching unit 3. It can close one of the 20 channels according to computer instructions, so that the digital multimeter in the 34970A digital acquisition switching unit 3 can collect parameters such as resistance and voltage.

[0059] First, as a host computer, computer 1 is responsible for sending acquisition instructions to 34970A digital acquisition switching unit 3, switching the internal digital multimeter of 34970A digital acquisition switching unit 3 to resistance test state as required, and setting the test accuracy and test speed according to technical conditions. At the same time, the 20 channels in 34901A multiplexer are closed and opened according to the instructions, and the internal digital multimeter collects data from the closed channels and saves it in the internal non-volatile memory. After the data acquisition is completed, computer 1 reads the data and displays it on the screen, and interprets the data at the same time. The unqualified channel data can be manually retested multiple times, and reports can be generated according to user needs.

[0060] Existing products need to collect 69 channels of data, but the 34901A multiplexer only has 20 channels of switching, and even the three slots on the back of the 34970A digital acquisition switching unit 3 cannot meet the requirements. Therefore, according to actual product needs, the present invention expands the functions of its own equipment and develops a "multi-channel data automatic acquisition system".

[0061] The expansion unit has an 80-channel switching function, which can switch every 20 channels as a group according to computer instructions. The expansion unit has two test interfaces, which are connected to the 34901A multiplexer and the product respectively, so as to expand the 20 channels of the 34901A multiplexer into 80 channels. The expansion unit also has an RS-485 interface to facilitate communication with computer 1 and switch channels according to computer instructions.

[0062] There are two adapter cables, namely, acquisition cable 4 and test cable 7. Acquisition cable 4 connects the 34901A multiplexer to the expansion unit 6, and test cable 7 connects the expansion unit 6 to the product under test. The interface between the test cable 7 and the expansion unit 6 is a Y2-120 universal electrical connector, which is convenient for future expansion according to product requirements; the adapter cable plug connecting the test cable 7 to the product is the plug that matches the product. Please check whether the plug interface is damaged each time you use it.

[0063] The computer program is written in C# language. The program is divided into three parts. The first part is to communicate and collect data for the 34970A digital acquisition switching unit 3. The second part is to close and open the channels of the expansion unit 6 in groups of 20 channels. The third part is to read, interpret and display the test data of the 34970A digital acquisition switching unit 3, and generate reports as required.

[0064] The test steps are as follows:

[0065] 1. Insert the 34901A connected with the acquisition cable 4 into the back card slot of the 34970A data acquisition switching unit 3, and connect the expansion unit;

[0066] 2. Connect the 34970A digital acquisition switching unit 3 and the expansion unit 6 to the computer 1 via the RS-232 interface cable 2 and the RS-485 interface cable 5 respectively;

[0067] 3. Connect the test cable 7 to the extension unit 6 and the product;

[0068] 4. Open the test computer 1, open the test software, click Configuration, and select the serial port;

[0069] 5. After the connection is successful, enter the product number and tester, click "Test" to start data collection and interpretation, and after the test is completed, click "Save" to generate a test report.

[0070] Obviously, those skilled in the art can make various changes and modifications to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is also intended to include these modifications and variations.

[0071] The contents not described in detail in the specification of the present invention belong to the common knowledge of those skilled in the art.

Claims

1. Multi-channel data automatic acquisition system, characterized by: It comprises a computer (1), an RS-232 interface cable (2), a 34970A data acquisition switching unit (3), an acquisition cable (4), an RS-485 interface cable (5), an expansion unit (6), a test cable (7), and a 34901A multiplexer; The computer (1) is used to send data acquisition instructions to the 34970A data acquisition switching unit (3) according to technical requirements, read back the collected data, interpret the data according to technical requirements, and generate reports; and send instructions to the expansion unit (6) to close and open channels in sequence according to data acquisition requirements; The RS-485 interface cable (5) is used for the computer (1) to send control instructions to the expansion unit (6); The 34970A data acquisition switching unit (3) uses the internal board 34901A multiplexer to sequentially acquire multiple resistances; and is connected to the computer (1) via the RS-232 interface cable (2) to receive a data acquisition instruction; after receiving the data acquisition instruction, the 34970A data acquisition switching unit (3) switches the internal multimeter to a resistance test state as required, and sets the test accuracy and test speed according to technical conditions, so that the 20 channels in the 34901A multiplexer are connected and disconnected as required by the instruction, and data is acquired and saved for the connected channels; after the acquisition is completed, the computer (1) completes reading the data; The acquisition cable (4) is used to connect the 34970A data acquisition switching unit (3) and the expansion unit (6) to perform data acquisition; The test cable (7) is used to connect the expansion unit (6) and the product under test to collect data; The expansion unit (6) is provided with a plurality of channels, and can close or open each group of channels according to the instructions of the computer (1) to collect parameters; The 34901A multiplexer is a dedicated board for the 34970A data acquisition switching unit (3), including 20 channels with switchable HI and LO inputs, and is used to provide a completely isolated input for a digital multimeter inside the 34970A data acquisition switching unit (3); the 34901A multiplexer is installed in the 34970A data acquisition switching unit (3) and is connected to the expansion unit (6) via an acquisition cable (4); The 34970A data acquisition switching unit (3) has an internal integrated 6.5-digit digital multimeter, which is consistent with the specifications of a 34401A digital multimeter or a 34410A digital multimeter under preset technical conditions; The expansion unit (6) has 80 channels of HI input, each of which is a group of 20 channels. A group of channels is closed according to the instructions of the computer (1), and each channel parameter is collected in cooperation with the 34901A multiplexer; By setting the channel closing time, the digital multimeter inside the 34970A data acquisition switching unit (3) can be accurately tested or monitored for a certain channel; by cooperating with the 34901A multiplexer and the expansion unit (6), the channel closing time can be set individually for each channel; By using serial port relays to form the main control circuit and designing and manufacturing an expansion unit together with an optocoupler isolation relay module, the number of extended acquisition channels can be expanded from 20 to hundreds.

2. The multi-channel data automatic acquisition system according to claim 1, characterized in that: The expansion unit (6) adopts an RS-485 interface.

3. The multi-channel data automatic acquisition system according to claim 1, characterized in that: The expansion units (6) are provided in multiple numbers according to the requirements.

4. The multi-channel data automatic acquisition system according to claim 1, characterized in that: The interface connecting the extension unit (6) to the product is a Y2-120 type universal electrical connector, which is convenient for making test cables (7) for other products.

5. The multi-channel data automatic acquisition system according to claim 1, characterized in that: The channels in the expansion unit (6) use an optical coupling isolation relay module to ensure that the channels for collecting data will not interfere with each other.

6. The multi-channel data automatic acquisition method implemented by the multi-channel data automatic acquisition system according to claim 1 is characterized in that: The steps include: Insert the 34901A multiplexer connected to the acquisition cable (4) into the back card slot of the 34970A data acquisition switching unit (3), and connect the expansion unit (6); The 34970A digital acquisition switching unit (3) and the expansion unit (6) are connected to the computer (1) via the RS-232 interface cable (2) and the RS-485 interface cable (5) respectively; Connect the test cable (7) between the extension unit (6) and the product; Turn on the test computer (1), and connect the 34970A data acquisition switching unit (3) and the expansion unit (6); After the connection is successful, data collection and interpretation begin. After the test is completed, a test report is generated.

Images