CN110851803B - System and method for registering user information in batch - Google Patents
System and method for registering user information in batch Download PDFInfo
- Publication number
- CN110851803B CN110851803B CN201911085819.1A CN201911085819A CN110851803B CN 110851803 B CN110851803 B CN 110851803B CN 201911085819 A CN201911085819 A CN 201911085819A CN 110851803 B CN110851803 B CN 110851803B
- Authority
- CN
- China
- Prior art keywords
- user
- information
- personal information
- registration
- users
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/30—Authentication, i.e. establishing the identity or authorisation of security principals
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L63/00—Network architectures or network communication protocols for network security
- H04L63/10—Network architectures or network communication protocols for network security for controlling access to devices or network resources
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L63/00—Network architectures or network communication protocols for network security
- H04L63/10—Network architectures or network communication protocols for network security for controlling access to devices or network resources
- H04L63/102—Entity profiles
Landscapes
- Engineering & Computer Science (AREA)
- Computer Security & Cryptography (AREA)
- General Engineering & Computer Science (AREA)
- Computer Hardware Design (AREA)
- Signal Processing (AREA)
- Computer Networks & Wireless Communication (AREA)
- Computing Systems (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Information Transfer Between Computers (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The utility model relates to a system and method for registering user information in batches, wherein, the system for registering user information in batches includes an acquisition module, a check module and a registration module, a form storing the first personal information of a plurality of users is acquired through the acquisition module, the second personal information of each user is screened out from the first personal information of each user through the check module, and the information type and the data format in the second personal information of each user are checked respectively, and the second personal information of the user who succeeds in checking is sent to the registration module in batches, the effects of registering the second personal information of a plurality of users in batches and checking in real time are realized, the second personal information of the user who fails in checking can be modified independently, and the efficiency and the accuracy of registering a large amount of user information in batches can be improved.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a system and a method for registering user information in batches.
Background
With the development of information technology, users can conveniently realize self-management and external secrecy effects in an application system by registering information in the application system, and can conveniently perform unified management on a large number of users by using a background, but in practice, in order to extract a large number of user information for registration from an information storage system, the original information storage system needs to be accessed again in the application system, the user information needs to be kept consistent in the application system and the information storage system in most cases, and a system administrator needs to re-input a large number of user information in the information storage system into the application system so as to register a large number of user information.
In the prior art, a large amount of user information is extracted from an information storage system and is registered in an application system, and the large amount of user information is sequentially registered in the application system, so that a large amount of working hours are generated in the process, and screening and correctness checking of the large amount of user information are realized manually, so that errors which are difficult to find occur in the user information registration process, and further adverse effects are brought.
Disclosure of Invention
In view of this, an object of the embodiments of the present application is to provide a system and a method for registering user information in batches, where a table storing first personal information of multiple users is obtained, second personal information of each user is screened from the first personal information of each user, information types and data formats in the second personal information of each user are verified respectively, and the second personal information of the users who are verified successfully is registered in batches, so that the effects of registering the second personal information of the multiple users in batches and verifying the second personal information of the users who are verified successfully in real time are achieved, and the second personal information of the users who are verified unsuccessfully can be modified independently, so that efficiency and accuracy of registering a large amount of user information in batches can be improved.
Mainly comprises the following aspects:
in a first aspect, an embodiment of the present application provides a system for registering user information in batches, where the system for registering user information in batches includes an obtaining module, a verifying module, and a registering module; wherein,
the acquisition module is used for acquiring a table in which first personal information of a plurality of users is stored from an information storage system, extracting the first personal information of the plurality of users from the table, and sending the first personal information of the plurality of users to the verification module;
the verification module is used for receiving the first personal information of the plurality of users sent by the acquisition module, screening out second personal information of each user required for registration from the first personal information of each user, and verifying the information type and the data format of the second personal information of each user to obtain a verification result of each user; sending the second personal information of the successfully verified users to the registration module in batch; displaying the second person information of the user who fails to check so that an administrator can modify the second person information, and sending the second person information to the registration module after the second person information is successfully checked;
and the registration module is used for receiving the second personal information of the user successfully verified and sent by the verification module and registering the user successfully verified according to the corresponding second personal information.
In a possible implementation manner, the obtaining module is specifically configured to extract the first personal information of the multiple users from the table according to the following steps:
for each user in the plurality of users, determining the position information of the first personal information of the user in the table; the position information comprises a row number position and a column number position;
and extracting the first personal information of each user from the table according to the position information of the first personal information of each user in the table.
In a possible implementation, the verification module includes:
the screening unit is used for screening out second personal information of the user corresponding to the information type required by registration from the first personal information of each user according to the information type of the first personal information of each user;
and the verification unit is used for verifying the data format of the second personal information of each user to obtain the verification result of each user.
In a possible implementation manner, the screening unit is specifically configured to screen out the second personal information of the user corresponding to the information type required for registration according to the following steps:
acquiring a preset type required by registration;
matching each information type corresponding to the first personal information of the user with the preset type;
and determining the personal information of the user corresponding to at least one information type which is matched and consistent with the preset type in the information types as the second personal information of the user.
In a possible implementation manner, the verification unit is specifically configured to verify the data format according to the following steps:
acquiring a preset format corresponding to each information type required by registration;
according to the preset format corresponding to each information type, verifying the data format corresponding to the information type of the second personal information of each user;
and if the data format corresponding to each information type is matched with the corresponding preset format, the verification is successful, otherwise, the verification fails.
In a second aspect, an embodiment of the present application further provides a method for registering user information in batch, where the method for registering user information in batch includes:
acquiring a table storing first personal information of a plurality of users;
extracting first personal information of the plurality of users from the table;
for each user in the plurality of users, screening out second personal information of each user required for registration from the first personal information of each user;
verifying the information type and the data format of the second personal information of each user to obtain a verification result of each user; the verification result comprises results of verification success and verification failure;
and registering the plurality of users according to the second personal information of the plurality of users successfully verified, and modifying the second personal information of the users failed in verification to finish the registration.
In a possible implementation manner, the extracting the first personal information of the plurality of users from the table includes:
for each user in the plurality of users, determining the position information of the first personal information of the user in the table; the position information comprises a row number position and a column number position;
and extracting the first personal information of each user from the table according to the position information of the first personal information of each user in the table.
In a possible embodiment, the screening out the second personal information of each user required for registration from the first personal information of each user includes:
acquiring a preset type required by registration;
matching each information type corresponding to the first personal information of the user with the preset type;
and determining the personal information of the user corresponding to at least one information type which is matched and consistent with the preset type in the information types as the second personal information of the user.
In a possible embodiment, the verifying the data format of the second personal information of each user includes:
acquiring a preset format corresponding to each information type required by registration;
according to the preset format corresponding to each information type, verifying the data format corresponding to the information type of the second personal information of each user;
and if the data format corresponding to each information type is matched with the corresponding preset format, the verification is successful, otherwise, the verification fails.
In a third aspect, an embodiment of the present application further provides an electronic device, including: a processor, a memory and a bus, wherein the memory stores machine-readable instructions executable by the processor, the processor and the memory communicate with each other through the bus when the electronic device is running, and the machine-readable instructions are executed by the processor to perform the steps of the method for batch registration of user information according to any one of the possible embodiments of the second aspect or the second aspect.
In a fourth aspect, the present application further provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the steps of the method for batch registration of user information in any one of the above-mentioned second aspect or possible implementation manners of the second aspect are performed.
In order to make the aforementioned objects, features and advantages of the present application more comprehensible, preferred embodiments accompanied with figures are described in detail below.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are required to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained from the drawings without inventive effort.
Fig. 1 is a schematic structural diagram illustrating a system for batch registration of user information according to an embodiment of the present application;
fig. 2 is a second schematic structural diagram of a system for batch registration of user information according to an embodiment of the present application;
FIG. 3 is a flow chart illustrating a method for batch registration of user information according to an embodiment of the present disclosure;
fig. 4 shows a schematic structural diagram of an electronic device provided in an embodiment of the present application.
Detailed Description
To make the purpose, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it should be understood that the drawings in the present application are for illustrative and descriptive purposes only and are not used to limit the scope of protection of the present application. Additionally, it should be understood that the schematic drawings are not necessarily drawn to scale. The flowcharts used in this application illustrate operations implemented according to some embodiments of the present application. It should be understood that the operations of the flow diagrams may be performed out of order, and that steps without logical context may be performed in reverse order or concurrently. One skilled in the art, under the guidance of this application, may add one or more other operations to, or remove one or more operations from, the flowchart.
In addition, the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. The components of the embodiments of the present application, generally described and illustrated in the figures herein, can be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the present application, presented in the accompanying drawings, is not intended to limit the scope of the claimed application, but is merely representative of selected embodiments of the application. All other embodiments, which can be derived by a person skilled in the art from the embodiments of the present application without making any creative effort, shall fall within the protection scope of the present application.
At present, in the prior art, a large amount of user information is extracted from an information storage system and registered in an application system, and the large amount of user information is sequentially registered in the application system, so that a large amount of man-hours are generated in the process, and screening and correctness checking of the large amount of user information are realized manually, so that errors which are difficult to find occur in the user information registration process, and further adverse effects are brought.
Based on this, this application acquires the form that stores the first personal information of a plurality of users through the acquisition module, and sift out the second personal information of every user from the first personal information of every user through the check-up module, and check up the information type and the data format in the second personal information of every user respectively, and send the second personal information of the successful user of check-up to the registration module in batches, realized registering in batches and the effect of real-time check-up to the second personal information of a plurality of users, and can revise the second personal information of the user that the check-up failed alone, can improve efficiency and the accuracy of registering in batches to a large amount of user information.
For the convenience of understanding of the present application, the technical solutions provided in the present application will be described in detail below with reference to specific embodiments.
Referring to fig. 1, fig. 1 is a schematic structural diagram of a system 100 for batch registration of user information provided in an embodiment of the present application, fig. 2 is a schematic structural diagram of a system 100 for batch registration of user information provided in an embodiment of the present application, and fig. 2 is a second schematic structural diagram of the system 100 for batch registration of user information provided in an embodiment of the present application, where as shown in fig. 1 and fig. 2, the system 100 for batch registration of user information provided in an embodiment of the present application includes an obtaining module 110, a verifying module 120, and a registering module 130; wherein,
the obtaining module 110 is configured to obtain a table in which first personal information of a plurality of users is stored from an information storage system, extract the first personal information of the plurality of users from the table, and send the first personal information of the plurality of users to the verifying module 120;
the verification module 120 is configured to receive the first personal information of the multiple users sent by the obtaining module 110, screen out second personal information of each user required for registration from the first personal information of each user, and verify the information type and data format of the second personal information of each user to obtain a verification result of each user; sending the second personal information of the successfully verified user to the registration module 130 in batch; displaying the second person information of the user who fails to check so that the administrator can modify the second person information, and sending the second person information to the registration module 130 after the second person information is successfully checked;
the registration module 130 is configured to receive the second personal information of the user successfully verified and sent by the verification module 120, and register the user successfully verified according to the corresponding second personal information.
The method comprises the steps of obtaining a table storing first personal information of a plurality of users from an information storage system through an obtaining module 110, extracting the first personal information of the plurality of users from the table, sending the first personal information of the plurality of users to a checking module 120, screening second personal information of each user from the first personal information of each user through the checking module 120, checking the information type and the data format in the second personal information of each user respectively, sending the second personal information of the users who successfully check to a registration module 130 in batch, realizing the effects of batch registration and real-time checking of the second personal information of the plurality of users, independently displaying the second personal information of the users who fail to check so as to be convenient for a manager to modify, and sending the second personal information of the users who complete modification to the checking module 120 after the modification is completed, and after the verification is successful, the information is sent to the registration module 130 for registration, so that the efficiency and the accuracy of batch registration of a large amount of user information can be improved.
Here, the information storage system is a system storing first personal information of a plurality of users, so the first personal information of the plurality of users is obtained from the information storage system and is directly downloaded to the obtaining module 110 in a table form, and the first personal information of each user includes an information type of the table and a data content and a data format corresponding to the information type, where the information type in the first personal information of the user is the information type of each column corresponding to the first row of the table, and the data content and the data format in the first personal information of the user are the data content and the data format of each column in the row corresponding to the user except the first row of the table.
In an example, referring to table 1, where table 1 is a table storing first personal information of a plurality of users, the information type included in the first personal information of user zhang extracted from the table is: name, gender, mobile phone number, email and address, the information type is name, the data content corresponding to the name is Zhang III, and the data format has no uniform fixed format; the information type is gender, the data content corresponding to the gender is female, the data format is a Chinese character, and the form is male or female; the information type is a mobile phone number, the data content corresponding to the mobile phone number is 12345678910, and the data format is 11 digits; the information type is that the data content corresponding to the electronic mailbox is 123@ v.com, and the data format is that @ symbols exist; the information type is that the data content corresponding to the address is a district in A city of the first province, the data format is a district in a certain city of a certain province, so the first personal information of the third user is the name: zhang III, sex: male, mobile phone number: 12345678910, email box: com, address: first district of city, first province.
Table 1: first personal information table storing a plurality of users
The second personal information of the user is obtained by screening the information types of the first personal information of the user, and the screened information types are the information types required by registration, namely, the registration can be completed only by the information types, so that the information types which are not required are removed from the plurality of information types in the first personal information of the user, and the information types required by the registration are screened.
In one example, suppose the first personal information of user Zhang III is, name: zhang III, sex: male, mobile phone number: 12345678910, email box: com, address: in the first district of city a of province a, registration can be realized only by name and mobile phone number, so that the second person information of the third user is obtained by screening, the name: zhang three, cell-phone number: 12345678910, the second person information of Zhang III of the user is sent to the registration module 130, so as to realize the registration of Zhang III of the user.
The second personal information of the user who fails to be verified is displayed in the visual interface in a special red marking mode in the position of the data format corresponding to the information type which fails to be verified, so that the effect of intuitively and online modifying in real time is realized, the administrator sends the second personal information back to the verification module 120 after modifying in the visual interface, verifies the second personal information of the user who completes modifying, sends the second personal information to the registration module 130 after verifying successfully, and registers the second personal information of the user who fails to be verified for the first time in batch.
It should be noted that, in the verification module 120, the second personal information of the plurality of users that are successfully verified is sent to the registration module 130 in batch to complete batch registration, and the second personal information of at least one user that fails verification is modified first, and then the modified second personal information of at least one user is sent to the registration module 130 after successful verification, so as to complete the batch registration effect of real-time verification and real-time modification of the second personal information of at least one user that fails verification.
It should be further noted that, for the second personal information of at least one user who fails to verify, batch download may be performed in a form of a table to the local, and the second personal information is displayed in a special red marking manner at a position where the data format corresponding to the information type is wrong, and the second personal information may be modified on the local desktop, but after the modification is completed, the second personal information needs to be sent to the obtaining module 110, and then the process of the whole system 100 for batch registration of user information is completed.
In the prior art, a large amount of user information is extracted from an information storage system and is registered in an application system, and the large amount of user information is sequentially registered in the application system, so that a large amount of working hours are generated in the process, and the correctness of the large amount of user information is verified manually, so that errors which are difficult to find occur in the user information registration process, and further adverse effects are brought.
In the above embodiment, the obtaining module 110 is specifically configured to extract the first personal information of the multiple users from the table according to the following steps:
for each user in the plurality of users, determining the position information of the first personal information of the user in the table; the position information comprises a row number position and a column number position;
and extracting the first personal information of each user from the table according to the position information of the first personal information of each user in the table.
Here, in the table, the first row is an information type corresponding to first personal information of a plurality of users, each column in the first row represents an information type corresponding to the column, the cell where the row corresponding to each user intersects with each column is a data content and a data format corresponding to each information type of the first personal information of the user, so that the first personal information of the plurality of users is extracted from the table in which the first personal information of the plurality of users is stored, the row number information of each user in the table to be extracted is first determined, the cell where the row number intersects with each column in the table is a data content and a data format corresponding to the information type corresponding to the column for the first personal information of the user.
The information type of the first personal information of the user is stored in a first row in the table, and the data content and the data format corresponding to the information type of the first personal information of the user are stored in each column corresponding to the row of the table where the user is located except the first row in the table, so that the information type of the first personal information of the user is extracted from the first row of the table, and the data content and the data format of the first personal information of the user are extracted from each column corresponding to the row of the user except the first row in the table.
In an example, as shown in table 2, table 2 is a table storing first personal information of a plurality of users, assuming that the first personal information of user king is extracted from the table, the fourth row of the table storing the personal information of user king is determined, and then a cell where the fourth row meets each column in the first row in the table is determined as a corresponding data content in an information type corresponding to each column of user king, so that the cell where the fourth row meets the second column in the table is extracted, and the data content in the cell is taken as a data content corresponding to the information type of gender, so that the gender is male; extracting a cell where the fourth row and the third column in the table meet, and taking the data content in the cell as the data content corresponding to the information type of the mobile phone number, so that the mobile phone number is 12345678912; extracting a cell in which the fourth row and the fourth column in the table are intersected, and taking the data content in the cell as the data content corresponding to the information type of the electronic mailbox, so that the electronic mailbox is 789@ y.com; extracting a cell in which the fourth row and the fifth column in the table are intersected, and taking the data content in the cell as the data content corresponding to the information type of the address, so that the address is three areas in C city of the third province, and the first personal information of the king five of the user is name: wang five, sex: male, mobile phone number: 12345678912, email box: 789@ y.com, address: three districts C city.
Table 2: first personal information table storing a plurality of users
| Name (I) | Sex | Mobile phone number | Electronic mail box | Address |
| Zhang San | For male | 12345678910 | 123@v.com | First district of city of Jia province |
| Li Si | Woman | 12345678911 | 456@w.com | Second district of B city of second province |
| Wang Wu | For male | 12345678912 | 789@y.com | Third district of C city of third province |
| … | … | … | … | … |
In the above embodiment, as shown in fig. 2, the verification module 120 includes:
a screening unit 121, configured to screen, according to the information type of the first personal information of each user, second personal information of the user corresponding to the information type required for registration from the first personal information of each user;
the verifying unit 122 is configured to verify a data format of the second personal information of each user, so as to obtain a verification result of each user.
Here, the extracted first personal information of the multiple users from the table storing the first personal information of the multiple users includes all information types in the table, but only a few information types are needed to complete registration, so at least one information type needed for registration is screened out from the information types of the first personal information of the users, the personal information of the users corresponding to the at least one information type is determined as the second personal information of the users, and the data format corresponding to each information type in the at least one information type of the users is verified, so that the verification result of the data format corresponding to each information type is obtained.
In one example, suppose that the first personal information of user king is, name: wang five, sex: male, mobile phone number: 12345678912, email box: 789@ y.com, address: third district in C city of third province, so the information type that user king five includes is: name, sex, cell-phone number, email and address, but wherein only need name, cell-phone number and email just can accomplish the registration, then screen out the second people information of user wang five and be, name: king five, mobile phone number: 12345678912, email box: and 789@ y.com, verifying the data format corresponding to the mobile phone number as the information type and 11 digits, and verifying the data format corresponding to the electronic mailbox as the information type and the @ symbol to obtain the verification result of the data format in each information type.
In the foregoing embodiment, the screening unit 121 is specifically configured to screen out the second personal information of the user corresponding to the information type required for registration according to the following steps:
acquiring a preset type required by registration;
matching each information type corresponding to the first personal information of the user with the preset type;
and determining the personal information of the user corresponding to at least one information type which is matched and consistent with the preset type in the information types as the second personal information of the user.
The registration system can complete the registration by presetting which information types of the users are needed in advance, so that the preset types needed by the registration are obtained in advance before the user registration is completed, namely the information types needed by the registration are obtained, all the information types are covered in the first personal information of the users, all the information types in the first personal information of each user are matched with the obtained information types needed by the registration one by one, finally, the information types which are consistent with the obtained preset information types needed by the registration are screened out, and the personal information of the user corresponding to the information types in each user is determined as the second personal information of the user.
It should be noted that, by matching the information type in the first personal information of each user with the preset type, the matched information is selected consistently, and the inconsistent information is removed, so that the effect of automatic matching of the information type is realized, the workload of an administrator for manually realizing the selection is reduced, and the efficiency of the workload of selecting the information type required by the registration is improved.
In one example, suppose that the first personal information of user king is, name: wang five, sex: male, mobile phone number: 12345678912, email box: 789@ y.com, address: third district in C city of third province, so the information type that user king five includes is: the name, the gender, the mobile phone number, the electronic mailbox and the address can be registered only by the name, the mobile phone number and the electronic mailbox, so that the name, the gender, the mobile phone number, the electronic mailbox and the address are matched with the name, the mobile phone number and the electronic mailbox one by one, the matched names, the mobile phone number and the electronic mailbox are kept consistent, the inconsistent removal is carried out, and three information types of the name, the mobile phone number and the electronic mailbox corresponding to the user Wangwu are obtained, so that the personal information of the user Wangwu corresponding to the three information types of the name, the mobile phone number and the electronic mailbox corresponding to the user Wangwu is determined as the second personal information of the user Wangwu, namely the second personal information of the user Wangwu is the name: king five, mobile phone number: 12345678912, email box: 789@ y.com.
In the foregoing embodiment, the verification unit 122 is specifically configured to verify a data format according to the following steps:
acquiring a preset format corresponding to each information type required by registration;
according to the preset format corresponding to each information type, verifying the data format corresponding to the information type of the second personal information of each user;
and if the data format corresponding to each information type is matched with the corresponding preset format, the verification is successful, otherwise, the verification fails.
Here, each of the several information types required for registration corresponds to a preset data format, so that the data format corresponding to each information type in the second personal information of each user is matched with the preset data format corresponding to the information type one by one, if the data format corresponding to the information type in the second personal information of the user matches the preset format corresponding to the information type consistently, the verification result of the information type is successful, and if the verification result of the data format corresponding to one information type in at least one information type in the second personal information of the user is failed, the verification result of the user is failed.
It should be noted that, in the first personal information of multiple users acquired in the information storage system, there is a high possibility that data errors occur, and in order to avoid a failure condition when a user with data errors registers the application system, before registration, the second personal information of multiple users is subjected to data format verification, and the data format corresponding to each information type is pre-stored in the verification module 120, once the second personal information of multiple users is screened out, the data format corresponding to at least one information type in the second personal information of the users is subjected to one-to-one matching with the preset data format corresponding to the information type, so as to obtain the data result corresponding to each information type, and by performing verification with the preset format, an automatic verification effect is achieved, and the workload of a programmer for checking each item of data is reduced, the efficiency of registering a plurality of users in batches is improved.
In one example, suppose the second person information of user king is, name: king five, mobile phone number: 12345678912, email box: com, the information types are data formats except for names, the data format corresponding to each information type is matched with the corresponding preset format one by one, for example, the preset information type is a mobile phone number with 11 digits, the mobile phone number of king five of the user is matched with the 11 digits in format, and if the mobile phone number of king five of the user is also 11 digits, the mobile phone number of king five of the user is in a correct data format.
According to the method and the device, the form in which the first personal information of the multiple users is stored is obtained through the obtaining module 110, the second personal information of each user is screened out from the first personal information of each user through the checking module 120, the information type and the data format in the second personal information of each user are checked respectively, the second personal information of the user who fails in checking is modified and sent to the registering module 130 to be registered after the modification is completed, the effects of batch registration and real-time checking of the second personal information of the multiple users are achieved, the information type and the data format of the second personal information of each user are checked, the second personal information of the user who fails in checking is modified in real time, and the rate and the accuracy of batch registration of the second personal information of the multiple users are improved.
Based on the same inventive concept, the embodiment of the present application further provides a method for batch registration of user information corresponding to the system for batch registration of user information provided by the above embodiment, and since the principle of problem solution of the method for batch registration of user information in the embodiment of the present application is similar to that of the system for batch registration of user information in the above embodiment of the present application, the implementation of the method can refer to the implementation of the system, and repeated parts are not described again.
Referring to fig. 3, fig. 3 is a flowchart of a method for registering user information in batch according to an embodiment of the present disclosure. As shown in fig. 3, a method for registering user information in batches according to an embodiment of the present application includes the following steps:
s301: acquiring a table storing first personal information of a plurality of users;
s302: extracting first personal information of the plurality of users from the table;
s303: for each user in the plurality of users, screening out second personal information of each user required for registration from the first personal information of each user;
s304: verifying the information type and the data format of the second personal information of each user to obtain a verification result of each user; the verification result comprises results of verification success and verification failure;
s305: and registering the plurality of users according to the second personal information of the plurality of users successfully verified, and modifying the second personal information of the users failed in verification to finish the registration.
Here, the information storage system is a system storing first personal information of a plurality of users, so the first personal information of the plurality of users is obtained from the information storage system and is directly downloaded in a form of a table, and the first personal information of each user includes an information type of the table and a data content and a data format corresponding to the information type, wherein the information type in the first personal information of the user is the information type of each column corresponding to a first row of the table, and the data content and the data format in the first personal information of the user are the data content and the data format of each column in a row corresponding to the user except the first row in the table.
The second personal information of the user is obtained by screening the information types of the first personal information of the user, and the screened information types are the information types required by registration, namely, the registration can be completed only by the information types, so that the information types which are not required are removed from the plurality of information types in the first personal information of the user, and the information types required by the registration are screened.
The second personal information of the user who fails in verification is displayed in the visual interface in a special red marking mode in the position of the data format corresponding to the information type which fails in verification, so that the effect of intuitively and online modifying in real time is realized, after the modification is completed in the visual interface by an administrator, the data format corresponding to each information type is verified again, after the verification is successful, the user who completes the verification is subjected to batch registration, and the second personal information of the user who fails in the first verification is subjected to batch registration again.
It should be noted that, at the data format check position corresponding to the information type, batch registration is performed on the second personal information of the plurality of users who have successfully checked, the second personal information of at least one user who has failed the check is modified first, and then the modified second personal information of at least one user is registered after the check is successful, so that the batch registration effect of real-time modification of the second personal information of at least one user who has failed the check is completed.
It should be further noted that, for the second personal information of at least one user who fails to be verified, the second personal information may also be downloaded to the local in batch in a form of a table, and displayed in a special red marking manner at a position where the data format corresponding to the information type is incorrect, the second personal information of a plurality of users may be modified on the local desktop, but after the modification is completed, the second personal information of the plurality of users may be re-extracted, the data format corresponding to the information type of the second personal information of the plurality of users may be verified, and after the verification is successful, the second personal information of at least one user that is modified may be registered in batch.
In a possible implementation manner, the extracting the first personal information of the plurality of users from the table in S302 includes the following steps:
for each user in the plurality of users, determining the position information of the first personal information of the user in the table; the position information comprises a row number position and a column number position;
and extracting the first personal information of each user from the table according to the position information of the first personal information of each user in the table.
Here, in the table, the first row is an information type corresponding to first personal information of a plurality of users, each column in the first row represents an information type corresponding to the column, the cell where the row corresponding to each user intersects with each column is a data content and a data format corresponding to each information type of the first personal information of the user, so that the first personal information of the plurality of users is extracted from the table in which the first personal information of the plurality of users is stored, the row number information of each user in the table to be extracted is first determined, the cell where the row number intersects with each column in the table is a data content and a data format corresponding to the information type corresponding to the column for the first personal information of the user.
The information type of the first personal information of the user is stored in a first row in the table, and the data content and the data format corresponding to the information type of the first personal information of the user are stored in each column corresponding to the row of the table where the user is located except the first row in the table, so that the information type of the first personal information of the user is extracted from the first row of the table, and the data content and the data format of the first personal information of the user are extracted from each column corresponding to the row of the user except the first row in the table.
In a possible embodiment, the step of screening the first personal information of each user for the second personal information of each user required for registration in S303 includes the steps of:
acquiring a preset type required by registration;
matching each information type corresponding to the first personal information of the user with the preset type;
and determining the personal information of the user corresponding to at least one information type which is matched and consistent with the preset type in the information types as the second personal information of the user.
The registration system can complete the registration by presetting which information types of the users are needed in advance, so that the preset types needed by the registration are obtained in advance before the user registration is completed, namely the information types needed by the registration are obtained, all the information types are covered in the first personal information of the users, all the information types in the first personal information of each user are matched with the obtained information types needed by the registration one by one, finally, the information types which are consistent with the obtained preset information types needed by the registration are screened out, and the personal information of the user corresponding to the information types in each user is determined as the second personal information of the user.
It should be noted that, by matching the information type in the first personal information of each user with the preset type, the matched information is selected consistently, and the inconsistent information is removed, so that the effect of automatic matching of the information type is realized, the workload of an administrator for manually realizing the selection is reduced, and the efficiency of the workload of selecting the information type required by the registration is improved.
In a possible embodiment, the verifying the data format of the second personal information of each user in S304 includes the following steps:
acquiring a preset format corresponding to each information type required by registration;
according to the preset format corresponding to each information type, verifying the data format corresponding to the information type of the second personal information of each user;
and if the data format corresponding to each information type is matched with the corresponding preset format, the verification is successful, otherwise, the verification fails.
Here, each of the several information types required for registration corresponds to a preset data format, so that the data format corresponding to each information type in the second personal information of each user is matched with the preset data format corresponding to the information type one by one, if the data format corresponding to the information type in the second personal information of the user matches the preset format corresponding to the information type consistently, the verification result of the information type is successful, and if the verification result of the data format corresponding to one information type in at least one information type in the second personal information of the user is failed, the verification result of the user is failed.
It should be noted that, in the first personal information of multiple users acquired in the information storage system, there is a high possibility that data errors occur, and in order to avoid a failure condition when the user with data errors registers the application system, before registration, the second personal information of multiple users is subjected to data format verification, and the data format corresponding to each information type is pre-stored in the background, once the second personal information of multiple users is screened out, the data format corresponding to at least one information type in the second personal information of the users is subjected to one-to-one matching with the preset data format corresponding to the information type, so as to obtain the data result corresponding to each information type, and by performing verification with the preset format, an automatic verification effect is achieved, and the workload of a programmer for checking each item of data is reduced, the efficiency of registering a plurality of users in batches is improved.
In the embodiment of the application, the form in which the first personal information of a plurality of users is stored is obtained, the second personal information of each user is screened out from the first personal information of each user, the information type and the data format in the second personal information of each user are respectively verified, and the second personal information of the user who is verified successfully is registered in batch, so that the effect of batch registration and real-time verification of the second personal information of the plurality of users is realized, the second personal information of the user who fails in verification can be independently modified, and the efficiency and the accuracy of batch registration of a large amount of user information can be improved.
Based on the same application concept, referring to fig. 4, a schematic structural diagram of an electronic device 400 provided in the embodiment of the present application includes: a processor 410, a memory 420 and a bus 430, wherein the memory 420 stores machine-readable instructions executable by the processor 410, when the electronic device 400 is operated, the processor 410 communicates with the memory 420 through the bus 430, and the machine-readable instructions are executed by the processor 410 to perform the steps of the method for batch registration of user information according to any one of the embodiments.
In particular, the machine readable instructions, when executed by the processor 410, may perform the following:
acquiring a table storing first personal information of a plurality of users;
extracting first personal information of the plurality of users from the table;
for each user in the plurality of users, screening out second personal information of each user required for registration from the first personal information of each user;
verifying the information type and the data format of the second personal information of each user to obtain a verification result of each user; the verification result comprises results of verification success and verification failure;
and registering the plurality of users according to the second personal information of the plurality of users successfully verified, and modifying the second personal information of the users failed in verification to finish the registration.
In the above embodiment, the step executed by the processor 410, where the extracting the first personal information of the plurality of users from the table includes:
for each user in the plurality of users, determining the position information of the first personal information of the user in the table; the position information comprises a row number position and a column number position;
and extracting the first personal information of each user from the table according to the position information of the first personal information of each user in the table.
In the above embodiment, the processor 410 performs the step of screening the first personal information of each user for the second personal information of each user required for registration, including:
acquiring a preset type required by registration;
matching each information type corresponding to the first personal information of the user with the preset type;
and determining the personal information of the user corresponding to at least one information type which is matched and consistent with the preset type in the information types as the second personal information of the user.
In the above embodiment, the step executed by the processor 410, where the verifying the data format of the second personal information of each user includes:
acquiring a preset format corresponding to each information type required by registration;
according to the preset format corresponding to each information type, verifying the data format corresponding to the information type of the second personal information of each user;
and if the data format corresponding to each information type is matched with the corresponding preset format, the verification is successful, otherwise, the verification fails.
Based on the same application concept, embodiments of the present application further provide a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the steps of the method for batch registration of user information provided in the foregoing embodiments are performed.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the system and the apparatus described above may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one logical division, and there may be other divisions when actually implemented, and for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of devices or units through some communication interfaces, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.
The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a non-volatile computer-readable storage medium executable by a processor. Based on such understanding, the technical solutions of the present application may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the methods described in the embodiments of the present application. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The above description is only for the specific embodiments of the present application, but the scope of the present application is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present application, and shall be covered by the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
Claims (7)
1. A system for registering user information in batches is characterized by comprising an acquisition module, a verification module and a registration module; wherein,
the acquisition module is used for acquiring a table in which first personal information of a plurality of users is stored from an information storage system, extracting the first personal information of the plurality of users from the table, and sending the first personal information of the plurality of users to the verification module;
the verification module is used for receiving the first personal information of the plurality of users sent by the acquisition module, screening out second personal information of each user required for registration from the first personal information of each user, and verifying the information type and the data format of the second personal information of each user to obtain a verification result of each user; sending the second personal information of the successfully verified users to the registration module in batch; displaying second personal information of the user who fails in verification so that a manager can modify the second personal information, and sending the second personal information to the registration module after the verification is successful, wherein the second personal information is the information type required by the registration screened from the first personal information;
the registration module is used for receiving the second personal information of the user successfully verified and sent by the verification module and registering the user successfully verified according to the corresponding second personal information;
the verification module comprises: the screening unit is used for screening out second personal information of the user corresponding to the information type required by registration from the first personal information of each user according to the information type of the first personal information of each user;
the verification unit is used for verifying the data format of the second personal information of each user to obtain the verification result of each user;
the screening unit is specifically configured to screen out second personal information of the user corresponding to the information type required for registration according to the following steps:
the screening unit is specifically configured to screen out second personal information of the user corresponding to the information type required for registration according to the following steps: acquiring a preset type required by registration;
matching each information type corresponding to the first personal information of the user with the preset type;
and determining the personal information of the user corresponding to at least one information type which is matched and consistent with the preset type in the information types as the second personal information of the user.
2. The system for batch registration of user information according to claim 1, wherein the obtaining module is specifically configured to extract the first personal information of the plurality of users from the table according to the following steps:
for each user in the plurality of users, determining the position information of the first personal information of the user in the table; the position information comprises a row number position and a column number position;
and extracting the first personal information of each user from the table according to the position information of the first personal information of each user in the table.
3. The system for batch registration of user information according to claim 1, wherein the verification unit is specifically configured to verify a data format according to the following steps:
acquiring a preset format corresponding to each information type required by registration;
according to the preset format corresponding to each information type, verifying the data format corresponding to the information type of the second personal information of each user;
and if the data format corresponding to each information type is matched with the corresponding preset format, the verification is successful, otherwise, the verification fails.
4. A method for registering user information in batches is characterized by comprising the following steps:
acquiring a table storing first personal information of a plurality of users;
extracting first personal information of the plurality of users from the table;
for each user in the plurality of users, screening out second personal information of each user required for registration from the first personal information of each user;
verifying the information type and the data format of the second personal information of each user to obtain a verification result of each user; the verification result comprises results of verification success and verification failure;
registering the plurality of users according to second personal information of the plurality of users who are successfully verified, and modifying the second personal information of the users who are failed to be verified to finish the registration, wherein the second personal information is the information type required by the registration screened from the first personal information;
the verifying the data format of the second personal information of each user comprises: acquiring a preset format corresponding to each information type required by registration;
according to the preset format corresponding to each information type, verifying the data format corresponding to the information type of the second personal information of each user;
if the data format corresponding to each information type is matched with the corresponding preset format, the verification is successful, otherwise, the verification fails;
the screening out the second personal information of each user required for registration from the first personal information of each user comprises the following steps: acquiring a preset type required by registration;
matching each information type corresponding to the first personal information of the user with the preset type;
and determining the personal information of the user corresponding to at least one information type which is matched and consistent with the preset type in the information types as the second personal information of the user.
5. The method of batch registering user information according to claim 4, wherein the extracting the first personal information of the plurality of users from the table comprises:
for each user in the plurality of users, determining the position information of the first personal information of the user in the table; the position information comprises a row number position and a column number position;
and extracting the first personal information of each user from the table according to the position information of the first personal information of each user in the table.
6. An electronic device, comprising: a processor, a memory and a bus, the memory storing machine-readable instructions executable by the processor, the processor and the memory communicating over the bus when the electronic device is operating, the machine-readable instructions when executed by the processor performing the method of bulk registering user information according to any one of claims 4 to 5.
7. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, performs the method of bulk registration of user information according to any one of claims 4 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911085819.1A CN110851803B (en) | 2019-11-08 | 2019-11-08 | System and method for registering user information in batch |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911085819.1A CN110851803B (en) | 2019-11-08 | 2019-11-08 | System and method for registering user information in batch |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110851803A CN110851803A (en) | 2020-02-28 |
| CN110851803B true CN110851803B (en) | 2022-03-29 |
Family
ID=69598882
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911085819.1A Active CN110851803B (en) | 2019-11-08 | 2019-11-08 | System and method for registering user information in batch |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110851803B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114666887A (en) * | 2020-12-23 | 2022-06-24 | 海能达通信股份有限公司 | Terminal registration method, communication device and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105681351A (en) * | 2016-03-21 | 2016-06-15 | 江苏通付盾科技有限公司 | Verification method, system, user equipment and server based on interactive operation |
| CN107437009A (en) * | 2017-07-14 | 2017-12-05 | 广东欧珀移动通信有限公司 | Authority control method and related product |
| CN108664801A (en) * | 2018-03-15 | 2018-10-16 | 北京明朝万达科技股份有限公司 | A kind of the anti-data-leakage strategy dynamic updating method and device of combination machine learning |
| CN109344151A (en) * | 2018-08-08 | 2019-02-15 | 航天信息股份有限公司 | The method of batch registration and modification user information |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4988448B2 (en) * | 2007-06-25 | 2012-08-01 | 株式会社日立製作所 | Batch verification apparatus, program, and batch verification method |
| JP5361266B2 (en) * | 2008-07-11 | 2013-12-04 | キヤノン株式会社 | Document management apparatus, system, and document management method |
| US8639922B2 (en) * | 2009-06-01 | 2014-01-28 | Dhananjay S. Phatak | System, method, and apparata for secure communications using an electrical grid network |
| CN102750608A (en) * | 2012-05-22 | 2012-10-24 | 山西优府信息技术开发有限公司 | Batch registering system |
| CN104901801B (en) * | 2014-03-06 | 2019-01-11 | 腾讯科技（深圳）有限公司 | Auth method and device |
| CN107835154A (en) * | 2017-10-09 | 2018-03-23 | 武汉斗鱼网络科技有限公司 | A kind of batch registration account recognition methods and system |
-
2019
- 2019-11-08 CN CN201911085819.1A patent/CN110851803B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105681351A (en) * | 2016-03-21 | 2016-06-15 | 江苏通付盾科技有限公司 | Verification method, system, user equipment and server based on interactive operation |
| CN107437009A (en) * | 2017-07-14 | 2017-12-05 | 广东欧珀移动通信有限公司 | Authority control method and related product |
| CN108664801A (en) * | 2018-03-15 | 2018-10-16 | 北京明朝万达科技股份有限公司 | A kind of the anti-data-leakage strategy dynamic updating method and device of combination machine learning |
| CN109344151A (en) * | 2018-08-08 | 2019-02-15 | 航天信息股份有限公司 | The method of batch registration and modification user information |
Non-Patent Citations (2)
| Title |
|---|
| FocusAR: Auto-focus Augmented Reality Eyeglasses for both Real World and Virtual Imagery;Praneeth Chakravarthula等;《网页在线公开：https://ieeexplore.ieee.org/stamp/stamp.jsp?tp=&arnumber=8458263》;20181130;第1-11页 * |
| 浅谈对强干扰下图形验证码的识别;王伟;《科技致富向导》;20110101(第17期);第55页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110851803A (en) | 2020-02-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112613917B (en) | Information pushing method, device, equipment and storage medium based on user portrait | |
| CN111639066A (en) | Data cleaning method and device | |
| CN109800320B (en) | Image processing method, device and computer readable storage medium | |
| CN110597511B (en) | Page automatic generation method, system, terminal equipment and storage medium | |
| CN107092694A (en) | Data quality inspection task generation method and device | |
| CN108073707B (en) | Financial business data updating method and device and computer readable storage medium | |
| CN109471935B (en) | Questionnaire survey object determining method and device, electronic equipment and storage medium | |
| CN113094287B (en) | Page compatibility detection method, device, equipment and storage medium | |
| CN109522332A (en) | Customer profile data merging method, device, equipment and readable storage medium storing program for executing | |
| CN105187632B (en) | Method and device for determining mobile phone number | |
| CN105959403A (en) | Wallpaper recommendation method, server and mobile terminal | |
| CN114265740A (en) | Error information processing method, device, device and storage medium | |
| CN108536467A (en) | Location processing method, device, terminal device and the storage medium of code | |
| CN112527280B (en) | Interface display method, device, server and readable storage medium | |
| CN110609988A (en) | Form verification method and equipment | |
| CN110851803B (en) | System and method for registering user information in batch | |
| CN112433935A (en) | Test method, test device, electronic equipment and storage medium | |
| CN114881764A (en) | Transaction interface display method and device | |
| CN113723813A (en) | Performance ranking method and device, electronic equipment and readable storage medium | |
| CN110968584B (en) | Portrait generation system, method, electronic device and readable storage medium | |
| CN112949265A (en) | Test question setting method and system | |
| CN108804889B (en) | Website registration method and device | |
| CN112528984A (en) | Image information extraction method, device, electronic equipment and storage medium | |
| CN110489478A (en) | A kind of method and device of data scanning | |
| CN113673956A (en) | Book information completion method, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |