Shulou(Shulou.com)06/03 Report--

In the process of    testing, it is often necessary to test the performance and automation of the imported excel. Many import scripts do not support recording function, so they can only obtain the request parameters by grabbing the package, and then develop the script manually. As many students may have no practical experience in importing this piece, it will be very difficult to develop it. This article will describe in detail how to develop the imported script manually.

First, import scripts manually

First, log in to the system using a browser and press F12 to view the HTTP request. Google browser is recommended here. You need to click Network > XHR, so you can see the request needed on the current page.

Click the OK button and the system prompts you to import

During the import, the system prompts that the record already exists. Do you want to confirm the execution and update? Click OK

If the import is successful, the system will prompt you for the success of the import. At this time, it is best to close the recording button to avoid admitting more requests.

According to the captured interface requests, we know that the import involves a total of four interface requests, mainly the following four

one。 / epm-web/public-access/epm/platform/ipln/upLoadPlan/ipln_af7f60062819467c927862e3d366b936.do this interface returns the imported data version before the data is imported, and the data is not imported into the system at this time

two。 / epm-web/public-access/epm/platform/ipln/ipln_af7f60062819467c927862e3d366b936.do?checkPlan this interface is used to check how many rows of data are on the current page.

three。 / epm-web/public-access/epm/platform/ipln/ipln_af7f60062819467c927862e3d366b936.do?deletePlan this API is used to confirm whether the old data is overwritten.

four。 / epm-web/public-access/epm/platform/ipln/upLoadPlan/ipln_af7f60062819467c927862e3d366b936.do?upLoadPlan&importType=0&batVersion=null this interface is the final interface for importing data. After many packages grabbing and comparing, it is found that there is no need to dynamically change the parameters in this import excel interface, that is, there is no need to parameterize the requested parameter values. This article mainly introduces the last import interface (other HTTP type interfaces can refer to the Jmeter HTTP interface case development and debugging method specially written by me), as shown in the following figure.

II. Development script

First add a HTTP request interface, enter the protocol, server ip, port number, method, interface path, parameters value

Click File Upload, and enter the upload file name, parameter name and MIME type obtained from the crawl parameter Form Data. This time, the file name uses the relative path format, and the imported file is placed under the data path.

Add the HTTP header manager and enter the Cookie information of the page. Other Content-Type types are not declared in the header, and you can use the default.

Click the debug button to return to success, and the data will be imported into the system normally.

    if the article is helpful to you, you can click on the follow function in the lower right corner. Welcome to forward and clap the brick. I will continue to launch articles related to the test and share the testing technology with you. Every original article is written attentively to put an end to plagiarism and copying. The official Wechat account is synchronized with the articles on this platform for easy reference.

QQ technology exchange group: please enter the verification information 51CTO to add the group.

Wechat QR code follow official account:

After following, reply to the resource download, and you can get the download address of all kinds of resources shared by yourself.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.