CN113887188A - A realization method of generating card file based on excel file parsing - Google Patents

Abstract

Translated fromChinese

本发明提供一种基于excel文件解析生成制卡文件的实现方法，涉及制卡文件技术领域。包括以下步骤：S1、将excel制卡信息文件完成并上传，S2、相关系统对excel制卡信息文件中的信息进行校验，S3、相关系统读取excel信息，执行脚本，生成制卡文件，S4、验证制卡文件大小，S5、将制卡文件放置跑批日期下，S6、对制卡文件进行跑批，S7、跑批结束后，确认卡、账以及客的结果，将制卡信息反馈给行方，当前批量制卡结束。本发明通过行方反馈给的制卡信息文件，调用脚本或者系统可视化页面的方式，对提供的制卡信息进行落库记录，并且生成对应的制卡文件到所属测试环境当前跑批的路径下，提高了效率，也减小了人工修改的误差。

The invention provides an implementation method for generating a card-making file based on excel file analysis, and relates to the technical field of card-making files. It includes the following steps: S1, complete and upload the excel card making information file, S2, the relevant system verifies the information in the excel card making information file, S3, the relevant system reads the excel information, executes the script, and generates the card making file, S4. Verify the size of the card making file. S5. Put the card making file under the batch running date. S6. Run the batching file. S7. Feedback to the line side, the current batch of card making ends. The invention uses the card-making information file fed back by the travel party to call the script or the system visualization page to record the provided card-making information, and generate the corresponding card-making file to the current batch running path of the test environment to which it belongs. The efficiency is improved, and the error of manual modification is also reduced.

Description

Implementation method for generating card making file based on excel file analysis

Technical Field

The invention relates to the technical field of card making files, in particular to a realization method for generating a card making file based on excel file analysis.

Background

With the development of economy and science and technology, the data volume of bank cards is increasing day by day, the card making requirements are increasing continuously, before testing various transactions and requirements, a large number of cards need to be manufactured in batch, however, the card making files are completed by adopting a manual writing mode in the traditional card making files, the efficiency is low, and the workload of manual modification can also be increased.

In summary, the development of an implementation method for generating a card making file based on excel file analysis is still a key problem to be solved urgently in the technical field of card making files.

Disclosure of Invention

The invention provides a realization method for generating a card making file based on excel file analysis.

In order to achieve the purpose, the invention is realized by the following technical scheme: an implementation method for generating a card making file based on excel file analysis comprises the following steps:

s1, providing excel information needing card making by the rower according to the provided template, testing support personnel to log in a related system or a corresponding operating environment, and completing and uploading an excel card making information file;

s2, the related system verifies the information in the excel card information file;

s3, reading excel information by a related system, executing a script and generating a card making file;

s4, verifying the size of the card making file;

s5, placing the card making file under the batch date;

s6, after the card making file is placed under the date needing batch making, batch making is carried out on the card making file;

and S7, confirming the results of the card, the account and the guest after the batch is finished.

The invention is further configured to: in the operation step of S2, the rule of information verification includes verifying whether the identity card number is repeated, verifying whether the contact manner is repeated, and verifying whether the identity card number and the mobile phone number meet the requirements.

The invention is further configured to: in the operation step S2, if the check fails and the upload mode is page upload, the user may immediately display the row and field of the wrong data after clicking the "upload" button, and when the upload mode is ftp upload of the operating environment, the operating window performs an error notification.

The invention is further configured to: in operation S4, if the file size satisfies the number of card making pieces, the check is passed, if the check fails, the error reason of the card making result is generated into a file, the problem is solved according to the error reason file generated by the system, and steps S1-S3 are repeated to make a card again.

The invention is further configured to: in operation S7, after the confirmation of the card, the ledger, and the guest is completed, card-making information is fed back to the bank according to the confirmation result.

The invention is further configured to: and if the confirmation result is correct, feeding card making information back to the bank, finishing the current batch card making, and if the confirmation result has a problem, searching for the problem and feeding the problem back to the bank in time.

The invention provides a realization method for generating a card making file based on excel file analysis. The method has the following beneficial effects:

according to the method, the operation is more convenient and faster through the card making information file fed back by the line side and the mode of calling the script or the system visual page, the checking step is placed at the forefront end, the error information can be timely avoided, the efficiency is improved, the error information can be timely accurate to the line, the column and a certain field, the information can be better modified, the manual step of checking each line and each column is omitted, the time and the labor are saved, the provided card making information is recorded in a database, the corresponding card making file is generated to the position under the current batch path of the test environment, the efficiency is improved, compared with the previous manual file compiling operation, the method not only can avoid the error of manual editing, improve the accuracy, but also can improve the efficiency, and can generate the card making file more quickly.

Drawings

Fig. 1 is a flowchart of an implementation method for generating a card making file based on excel file analysis.

Detailed Description

In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below. It is to be understood that the embodiments described are only a few embodiments of the present invention, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

The present invention will be further described with reference to the following examples.

Example (b):

referring to fig. 1, an implementation method for generating a card making file based on excel file analysis includes the following steps:

step one, providing excel information needing card making by a bank according to a provided template, testing support personnel to log in a related system or a corresponding operating environment, and completing and uploading an excel card making information file.

In the step, the operation is more convenient and fast by a visual page uploading mode, and uploading is realized only by clicking an uploading button of the page to select the file.

And step two, the related system verifies the information in the excel card information file.

The rules of information verification comprise the steps of verifying whether the identity card number is repeated, verifying whether the contact way is repeated and verifying whether the identity card number and the mobile phone number meet the requirements or not.

If the check fails, when the uploading mode is page uploading, the user can immediately display the row and the field of the wrong data after clicking an uploading button, and when the uploading mode is operation environment ftp uploading, the operation window carries out error reporting prompt.

In the step, the checking step is placed at the forefront end, on one hand, error information can be avoided in time, efficiency is improved, on the other hand, the error information can be immediately accurate to a row, a column and a certain field, information can be better modified, the step of manually checking each row and each column is omitted, and time and labor are saved.

And step three, reading the excel information by the related system, executing the script and generating a card making file.

In the step, the main purpose is to execute the reading script on the data of the excel meeting the requirement, and extract and splice the name, the identification number, the contact way and the like of the data in the excel into the card making file according to the requirements of the card making file. Through the steps, the background automatically executes the script to splice and generate the card making file, meanwhile, the identification and remark of different test environments can be completed according to the sheet, and compared with the manual file compiling operation in the prior art, the method not only can avoid errors of manual editing and improve accuracy, but also can improve efficiency and generate the card making file more quickly.

And step four, verifying the size of the card making file.

If the size of the file meets the card making number, the checking is passed, if the checking fails, the error reason of the card making result is generated into the file, the problem is solved according to the error reason file generated by the system, and the steps one to three are repeated to make the card again.

In the step, the generated card making file is checked, the batch is not performed on a day-to-day basis, the size of the file is wrong due to the fact that some problems of environment configuration may occur, the file is found in time, the problem of re-operation caused by the fact that errors are found after the batch is performed on a day-to-day basis is avoided, and accuracy and efficiency are improved. If the file header is 67, a piece of card making data is 3750, and if a card needs to be made, the number of correct file size bytes should be: 67+ 3750; if n pieces need to be made, the number of bytes of the file size is as follows: 67+3750 × n, appointing m according to the number of the strips except the field name (the first row) in the execl table, if the size of the generated card making file is equal to 67+3750 × m, if so, putting the generated card making file under a file path corresponding to the batch date to be run, otherwise, manually checking if the conversion fails.

And step five, placing the card making file under the batch date.

In the step, the card making file is placed under the batch date, and batch processing is carried out on the card making file.

And step six, after the card making files are placed under the date needing batch running, carrying out batch running on the card making files.

In the step, whether the card making file is correct in size or not is verified, the corresponding batch date card making result is generated under the path where the script is located, and the problem is convenient to confirm and check.

And step seven, confirming the results of the card, the account and the guest after the batch running is finished.

And after the card, account and customer confirmation results are finished, feeding card making information back to the bank according to the confirmation results.

And if the confirmation result is correct, feeding card making information back to the bank, finishing the current batch card making, and if the confirmation result has a problem, searching for the problem and feeding the problem back to the bank in time.

In this step, the card making file is read to complete the establishment of the card, the account and the guest, and the key information required by the test is generated in the corresponding test environment.

According to the method, the operation is more convenient and faster through the card making information file fed back by the line side and the mode of calling the script or the system visual page, the checking step is placed at the forefront end, the error information can be timely avoided, the efficiency is improved, the error information can be timely accurate to the line, the column and a certain field, the information can be better modified, the manual step of checking each line and each column is omitted, the time and the labor are saved, the provided card making information is recorded in a database, the corresponding card making file is generated to the position under the current batch path of the test environment, the efficiency is improved, compared with the previous manual file compiling operation, the method not only can avoid the error of manual editing, improve the accuracy, but also can improve the efficiency, and can generate the card making file more quickly.

The above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not depart from the spirit and scope of the corresponding technical solutions.

Claims (6)

1. An implementation method for generating a card making file based on excel file analysis is characterized by comprising the following steps:

s1, providing excel information needing card making by the rower according to the provided template, testing support personnel to log in a related system or a corresponding operating environment, and completing and uploading an excel card making information file;

s2, the related system verifies the information in the excel card information file;

s3, reading excel information by a related system, executing a script and generating a card making file;

s4, verifying the size of the card making file;

s5, placing the card making file under the batch date;

s6, after the card making file is placed under the date needing batch making, batch making is carried out on the card making file;

and S7, confirming the results of the card, the account and the guest after the batch is finished.

2. The method for generating the card making file based on the excel file analysis as claimed in claim 1, wherein: in the operation step of S2, the rule of information verification includes verifying whether the identity card number is repeated, verifying whether the contact manner is repeated, and verifying whether the identity card number and the mobile phone number meet the requirements.

3. The method for generating the card making file based on the excel file analysis as claimed in claim 1, wherein: in the operation step S2, if the check fails and the upload mode is page upload, the user may immediately display the row and field of the wrong data after clicking the "upload" button, and when the upload mode is ftp upload of the operating environment, the operating window performs an error notification.

4. The method for generating the card making file based on the excel file analysis as claimed in claim 1, wherein: in operation S4, if the file size satisfies the number of card making pieces, the check is passed, if the check fails, the error reason of the card making result is generated into a file, the problem is solved according to the error reason file generated by the system, and steps S1-S3 are repeated to make a card again.

5. The method for generating the card making file based on the excel file analysis as claimed in claim 1, wherein: in operation S7, after the confirmation of the card, the ledger, and the guest is completed, card-making information is fed back to the bank according to the confirmation result.

6. The implementation method for generating a card making file based on excel file parsing according to claim 5, characterized in that: and if the confirmation result is correct, feeding card making information back to the bank, finishing the current batch card making, and if the confirmation result has a problem, searching for the problem and feeding the problem back to the bank in time.

Images