[go: up one dir, main page]

US12001388B2 - Information importing method and apparatus - Google Patents

Information importing method and apparatus Download PDF

Info

Publication number
US12001388B2
US12001388B2 US17/704,708 US202217704708A US12001388B2 US 12001388 B2 US12001388 B2 US 12001388B2 US 202217704708 A US202217704708 A US 202217704708A US 12001388 B2 US12001388 B2 US 12001388B2
Authority
US
United States
Prior art keywords
information
server
file
verification
user
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, expires
Application number
US17/704,708
Other versions
US20220214996A1 (en
Inventor
Jia Guo
Yuan Zhang
Ke Xu
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Dingtalk Holding Cayman Ltd
Original Assignee
Dingtalk Holding Cayman Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Dingtalk Holding Cayman Ltd filed Critical Dingtalk Holding Cayman Ltd
Assigned to DINGTALK HOLDING (CAYMAN) LIMITED reassignment DINGTALK HOLDING (CAYMAN) LIMITED ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: XU, KE, GUO, Jia, ZHANG, YUAN
Publication of US20220214996A1 publication Critical patent/US20220214996A1/en
Application granted granted Critical
Publication of US12001388B2 publication Critical patent/US12001388B2/en
Active legal-status Critical Current
Adjusted expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/11File system administration, e.g. details of archiving or snapshots
    • G06F16/116Details of conversion of file system types or formats
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/16File or folder operations, e.g. details of user interfaces specifically adapted to file systems
    • G06F16/168Details of user interfaces specifically adapted to file systems, e.g. browsing and visualisation, 2d or 3d GUIs
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/20Natural language analysis
    • G06F40/205Parsing
    • G06F40/226Validation
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network arrangements or protocols for supporting network services or applications
    • H04L67/01Protocols
    • H04L67/06Protocols specially adapted for file transfer, e.g. file transfer protocol [FTP]

Definitions

  • One or more embodiments of this specification relate to the field of information technologies, and in particular, to an information importing method and apparatus.
  • a server can provide an interaction interface to a user through a web page or a client, for the user to fill in information based on the interaction interface, and upload the information to the server for processing or storage.
  • the server can provide an interaction interface to a user through a web page or a client, for the user to fill in information based on the interaction interface, and upload the information to the server for processing or storage.
  • the user may first collect information on a terminal (may also need to perform further information processing or information sorting), and subsequently record the collected information in a file (such as an Excel spreadsheet file).
  • a file such as an Excel spreadsheet file.
  • the server can perform content parsing and batch importing on the file, and then process or store the imported information.
  • the server can perform content parsing and batch importing on the file, and then process or store the imported information.
  • some errors usually exist in the information recorded in the file.
  • one or more embodiments of this specification provide an information importing method and apparatus.
  • the one or more embodiments of this specification provide the following technical solutions.
  • an information importing method including: receiving, by a server, an information importing file uploaded by a user, where the information importing file includes information to be imported into a system; verifying, by the server, the information included in the information importing file; marking, by the server, information in the information importing file that does not pass the verification, so as to generate an error comparison file; and returning, by the server, the error comparison file to the user.
  • an information importing method including: uploading, by a terminal, an information importing file to a server, for the server to verify information included in the information importing file and import the information into a system; and receiving, by the terminal, an error comparison file returned by the server, where the error comparison file is generated by the server by marking information in the information importing file that does not pass the verification.
  • an information importing apparatus including: a receiving unit, configured to enable a server to receive an information importing file uploaded by a user, where the information importing file includes information to be imported into a system; a verification unit, configured to enable the server to verify the information included in the information importing file; a marking unit, configured to enable the server to mark information in the information importing file that does not pass the verification, so as to generate an error comparison file; and a returning unit, configured to enable the server to return the error comparison file to the user.
  • an information importing apparatus including: an uploading unit, configured to enable a terminal to upload an information importing file to a server, for the server to verify information included in the information importing file and import the information into a system; and a receiving unit, configured to enable the terminal to receive an error comparison file returned by the server, where the error comparison file is generated by the server by marking information in the information importing file that does not pass the verification.
  • an electronic device including: a processor; and a memory configured to store instructions executable by the processor, where the processor is configured to execute the executable instructions to implement the method according to the first aspect.
  • a computer-readable storage medium storing computer instructions, where the instructions are executed by a processor to implement steps in the method according to the first aspect.
  • an electronic device including: a processor; and a memory configured to store instructions executable by the processor, where the processor is configured to execute the executable instructions to implement the method according to the second aspect.
  • a computer-readable storage medium storing computer instructions, where the instructions are executed by a processor to implement steps in the method according to the second aspect.
  • FIG. 1 is a schematic architectural diagram of an information importing system, according to an exemplary embodiment.
  • FIG. 2 is a flowchart of an information importing method on a server side, according to an exemplary embodiment.
  • FIG. 3 is a flowchart of an information importing method on a terminal side, according to an exemplary embodiment.
  • FIG. 4 is a schematic interaction diagram of performing information maintenance for enterprise personnel, according to an exemplary embodiment.
  • FIG. 5 is a display diagram of an information importing file, according to an exemplary embodiment.
  • FIG. 6 is a schematic diagram of a management page, according to an exemplary embodiment.
  • FIG. 7 is a schematic diagram of an importing result page, according to an exemplary embodiment.
  • FIG. 8 is a schematic diagram of displaying problematic information, according to an exemplary embodiment.
  • FIG. 9 is a schematic diagram of displaying an error description offline, according to an exemplary embodiment.
  • FIG. 10 is a schematic diagram of quickly displaying an error description in an offline environment, according to an exemplary embodiment.
  • FIG. 11 is a schematic diagram of editing file content online, according to an exemplary embodiment.
  • FIG. 12 is a schematic diagram of displaying error prompt information during online editing, according to an exemplary embodiment.
  • FIG. 13 a is another schematic diagram of displaying error prompt information during online editing, according to an exemplary embodiment.
  • FIG. 13 b is a schematic diagram of a communication session interface, according to an exemplary embodiment.
  • FIG. 14 is a schematic structural diagram of a device on a server side, according to an exemplary embodiment.
  • FIG. 15 is a block diagram of an information importing apparatus on a server side, according to an exemplary embodiment.
  • FIG. 16 is a schematic structural diagram of a device on a terminal side, according to an exemplary embodiment.
  • FIG. 17 is a block diagram of an information importing apparatus on a terminal side, according to an exemplary embodiment.
  • the steps of corresponding methods are not necessarily performed according to a sequence shown and described in this specification. In some other embodiments, the methods may include more or fewer steps than those described in this specification. In addition, a single step described in this specification may be divided into a plurality of steps for description in other embodiments, and a plurality of steps described in this specification may be combined into a single step for description in other embodiments.
  • FIG. 1 is a schematic architectural diagram of an information importing system, according to an exemplary embodiment.
  • the system may include a server 11 , a network 12 , and several electronic devices such as a mobile phone 13 , and a personal computer (PC) 14 .
  • PC personal computer
  • the server 11 may be a physical server including an independent host. Alternatively, the server 11 may be a virtual server carried by a host cluster. During running, the server 11 may run a program on a server side of an application, to achieve related service functions of the application. For example, when the server 11 runs a program of a group office platform, the server may be implemented as a server end of the group office platform. In technical solutions of the one or more embodiments of this specification, the server 11 may cooperate with clients running on the mobile phone 13 and the PC 14 to implement an information importing solution.
  • the group office platform may not only implement a communication function, and may be used as an integrated function platform of many other functions, for example, processing of an internal event of a group such as an examination and approval event (for example, examination and approval events such as asking off, applying for office supplies, and financial affairs), an attendance checking event, a task event, or a log event, or processing of an external event of the group such as ordering food or purchasing, which is not limited in one or more embodiments of this specification.
  • the group office platform may support a mobile group office scenario, to enable users to use mobile electronic devices such as the mobile phone 13 to implement related matters of group office.
  • the group office platform may also be compatible with non-mobile electronic devices such as the PC 14 to implement the related matters of group office.
  • the group office platform may be referred to as a mobile group office platform.
  • the mobile group office platform may be carried on an instant messaging application in related technologies, for example, an enterprise instant messaging (EIM) application.
  • EIM enterprise instant messaging
  • the instant messaging function is merely one of the communication functions supported by the mobile group office platform, and the mobile group office platform may further implement many other functions described above, which are not repeatedly described herein.
  • Both the mobile phone 13 and the PC 14 are some types of electronic devices that may be used by users.
  • the users may alternatively use the following types of electronic devices obviously: a tablet device, a notebook computer, a personal digital assistant (PDA), a wearable device (such as smart glasses or a smartwatch), and the like.
  • PDA personal digital assistant
  • the electronic device may run a program on a client side of an application, to achieve related service functions of the application. For example, when the electronic device runs a program of a group office platform, the electronic device may be implemented as a client of the group office platform.
  • an application of a client of the group office platform may be pre-installed on the electronic device, and then the client may start and run on the electronic device.
  • the client may be obtained and run without installing a corresponding application on the electronic device.
  • the network 12 through which the mobile phone 13 , the PC 14 , and the server 11 interact with each other may include a plurality of types of wired or wireless networks.
  • the network 12 may include a public switched telephone network (PSTN) and the Internet.
  • PSTN public switched telephone network
  • FIG. 2 is a flowchart of an information importing method on a server side, according to an exemplary embodiment. As shown in FIG. 2 , the method is applicable to a server, and may include the following steps:
  • Step 202 A server receives an information importing file uploaded by a user, where the information importing file includes information to be imported into a system.
  • the server may provide a web page access service, for the user to open an access page of the server by accessing a domain name of the server on a browser of a terminal, upload the information importing file based on the access page, and perform other operations.
  • a program on a server side of an application runs on the server, for the server to be configured as a server end of the application; and a program on a client side of the application runs on the terminal, for the terminal to be configured as a client of the application.
  • the application may be the foregoing group office platform.
  • the user may upload the information importing file and perform other operations by using the client.
  • the information importing file may include one or more pieces of information. Based on a batch import function of the server, after generating the information importing file on the terminal or another device, the user may upload the information importing file to the server, for the server to import the information into the system in batches, and the user does not need to perform importing piece by piece.
  • the information importing file may include a plurality of pieces of information in the same format to be imported into the system in batches.
  • the information importing file may include a spreadsheet file.
  • the spreadsheet file is provided with several headers, and each piece of information includes fields corresponding to the headers respectively and values of the fields.
  • the headers may include name, gender, job number, identity card number, and the like, and each of the enterprise personnel corresponds to one piece of information.
  • the information includes “Zhang San, Male, 0001, 110 . . .
  • the information importing file may not necessarily be a spreadsheet file, and file types that can clearly indicate information content may all be used, which is not limited in this specification.
  • the information importing file may be uploaded to the server by the user by using a terminal.
  • the user may be a creator of the information importing file, or the user may obtain the information importing file from another user, which is not limited in this specification.
  • the information included in the information importing file may be sorted out by the creator based on collected data; or users respectively generate information corresponding to the users and send the information to the creator, and the creator combines the received information into an information importing file without a need to actively collect and sort each piece of information, which is not limited in this specification.
  • the information importing file uploaded from the terminal to the server is an electronic document
  • the electronic document may be generated from an entity document (for example, a paper document).
  • the terminal performs image acquisition and optical character recognition (OCR) on the entity document, so as to transform the entity document into the electronic document.
  • OCR optical character recognition
  • Step 204 The server verifies the information included in the information importing file.
  • the server may verify the information included in the information importing file by using a predefined verification condition.
  • the verification condition may include a default condition provided by the foregoing application; or the verification condition may further include a condition customized by the user.
  • the user may be an enterprise administrator, and may customize a verification condition according to an actual requirement of the enterprise.
  • the predefined verification condition may be used for verifying the information included in the information importing file from one or more dimensions.
  • the predefined verification condition may be used for verification from an information dimension, for example, whether a quantity of pieces of the information included in the information importing file is excessively small or excessively large.
  • the predefined verification condition may be used for verification from a content dimension, for example, whether fields included in each piece of information are fields used as required, or whether the same field included in different information has duplicate values.
  • Step 206 The server marks information in the information importing file that does not pass the verification, so as to generate an error comparison file.
  • the information that does not pass the verification can be quickly located based on the error comparison file, thereby helping improve efficiency of finding and correcting errors.
  • the server may adjust a display attribute of the information that does not pass the verification, to distinguish the information that does not pass the verification from information that passes the verification.
  • the display attribute may include at least one of the following: a background color, a border color, a character color, a font, a character size, and the like, which is not limited in this specification.
  • the server may mark a problematic field in the information that does not pass the verification, so that the user does not need to recognize a field or fields having problems in the information autonomously, and can accurately modify the problematic fields, thereby helping improve efficiency of finding and correcting errors.
  • Step 208 The server returns the error comparison file to the user.
  • the server may actively push the error comparison file to the user; or the server may provide a download page for the error comparison file to the user, so that the user may download the error comparison file according to a requirement; or the server may provide an online viewing page or an online editing page for the error comparison file to the user, so that the user may view or modify the error comparison file online.
  • the server may further add error description information to the error comparison file.
  • the error description information may include each problem (a problem existing in the information importing file or all problems summarized in advance that may occur and not necessarily exist in the information importing file) existing in the information that does not pass the verification, a marking form (for example, which background color is used) corresponding to each problem, a solution to each problem, and the like.
  • the user can conveniently learn about a problem and a solution to the problem, and does not need to query the server for the problem existing in the marked information or the solution to be used, thereby preventing the user from performing frequent switching between online and offline, and helping simplify user operations and improve operation efficiency of the user.
  • the server may separately add the error description information to the error comparison file. That is, the error description information and the originally included information are separated from each other.
  • the originally included information may be in one sheet of the Excel spreadsheet file, and the error description information may be in another sheet of the Excel spreadsheet file.
  • the server may add the error description information as a remark corresponding to the information that does not pass the verification or the problematic field thereof, so that in a process in which the user views the error comparison file, by triggering the information that does not pass the verification or the problematic field thereof, corresponding error description information (all the error description information or error description information for triggered information or field) may be temporarily shown, so that the user can quickly learn about a problem and a solution to the problem without repeatedly switching between a plurality of sheets.
  • the server may feed statistical data back to the user.
  • the statistical data may include at least one of the following: a quantity of pieces of information that is successfully imported into the system, a quantity of pieces of information in the imported information that does not pass the verification, a quantity of pieces of information that does not pass the verification and that is not imported, each problem existing in the information that does not pass the verification, a marking form corresponding to each problem, a solution to each problem, and the like, which is not limited in this specification.
  • the server in response to an operation of uploading the information importing file to the server by the user, the server may return an importing result page to the user, and display the statistical data in the importing result page for the user the view.
  • the user may modify the information that does not pass the verification or the problematic field in the error comparison file by viewing the statistical data.
  • the server may receive an online viewing request initiated by the user, and return a display page of the error comparison file to the user.
  • the server may determine information selected in the display page by the user, and if the selected information does not pass the verification, update the display page to include error description information for the selected information. Based on this embodiment, when the user selects information or a field included in the information in the display page, corresponding error description information may be automatically updated and displayed in the display page, so that the user quickly learns about a problem existing in the selected information or the field thereof, a solution, and the like.
  • the server may receive an online editing request initiated by the user, and edit information in the error comparison file according to the online editing request.
  • the user views the error comparison file in the display page based on the foregoing online viewing request, then the user may further initiate an online editing request for information or a field in the display page during viewing, so as to modify the related information or field.
  • the user may view the error comparison file in another manner, for example, download the error comparison file for offline viewing; and the user may also initiate an online editing request to the server, to edit the information in the error comparison file.
  • the server may receive an online correction request initiated by an information provider.
  • the online correction request is initiated by the information provider based on a correction invitation sent by the user, and the information provider provides related information to the user, or provides related information to another user and the another user forwards the related information to the user.
  • the related information is at least a part of information included in the information importing file.
  • the server may provide an online correction interface to the information provider.
  • the online correction interface includes related information in the information importing file that corresponds to the information provider, for the information provider to perform correction. Because the information provider provides the related information at the early stage, the information provider is more familiar with correct content of the related information than the user, or learns about the correct content of the related information more conveniently than the user.
  • the information provider may directly participate in a correction operation for the related information based on the correction invitation, which can not only improve a correction speed, but also can reduce a risk of erroneously conveying correction content by the user compared with informing the user of the correction content and performing correction by the user, thereby avoiding repeated modification for the related information.
  • the online correction interface displayed to the information provider may only include related information corresponding to the information provider, to prevent the information provider from accessing to other information irrelevant to the information provider, thereby avoiding a leakage of sensitive content included in the other information.
  • the related information corresponding to the information provider may include: all information provided by the information provider, or a problematic field in the information provided by the information provider.
  • the server may automatically correct the information that does not pass the verification based on a corresponding verification rule (where the verification rule may be used for representing a correct format of the corresponding information), and return the corrected information (for example, add the corrected information to the error comparison file, or separately send the corrected information) to the user.
  • the corrected information may be used for replacing corresponding information that does not pass the verification without manual modification by the user. If the user disagrees with the corrected information, the user may still actively perform modification.
  • the server may recognize error-prone information included in the information importing file. For example, the server may collect statistics on information types going wrong in importing processes in history, to use a preset quantity (for example, the first three) of information types with cumulative error counts ranked in the top as error-prone information, or use information types with cumulative error counts reaching a preset quantity as error-prone information. In brief, even if the error-prone information passes verification, the server may still mark the error-prone information in the error comparison file, to remind the user to confirm the error-prone information twice or more.
  • a preset quantity for example, the first three
  • imported information in the information importing file may have a dynamic value. That is, a value of corresponding information may change dynamically.
  • the server may obtain the latest value of the information from the terminal (or an information source) in real time or periodically, to ensure that the server can always maintain the latest value of the information.
  • FIG. 3 is a flowchart of an information importing method on a terminal side, according to an exemplary embodiment. As shown in FIG. 3 , the method is applicable to a terminal, and may include the following steps:
  • Step 302 A terminal uploads an information importing file to a server, for the server to verify information included in the information importing file and import the information into a system.
  • the server may provide a web page access service, for the user to open an access page of the server by accessing a domain name of the server on a browser of a terminal, upload the information importing file based on the access page, and perform other operations.
  • a program on a server side of an application runs on the server, for the server to be configured as a server end of the application; and a program on a client side of the application runs on the terminal, for the terminal to be configured as a client of the application.
  • the application may be the foregoing group office application.
  • the user may upload the information importing file and perform other operations by using the client.
  • the information importing file may include one or more pieces of information. Based on a batch import function of the server, after generating the information importing file on the terminal or another device, the user may upload the information importing file to the server by using the terminal, for the server to import the information into the system in batches, and the user does not need to perform importing piece by piece.
  • the information importing file may include a plurality of pieces of information in the same format to be imported into the system in batches.
  • the information importing file may include a spreadsheet file.
  • the spreadsheet file is provided with several headers, and each piece of information includes fields corresponding to the headers respectively and values of the fields.
  • the headers may include name, gender, job number, identity card number, and the like, and each of the enterprise personnel corresponds to one piece of information.
  • the information includes “Zhang San, Male, 0001, 110 . . .
  • the information importing file may not necessarily be a spreadsheet file, and file types that can clearly indicate information content may all be used, which is not limited in this specification.
  • the information importing file may be uploaded to the server by the user by using a terminal.
  • the user may be a creator of the information importing file, or the user may obtain the information importing file from another user, which is not limited in this specification.
  • the information included in the information importing file may be sorted out by the creator based on collected data; or users respectively generate information corresponding to the users and send the information to the creator, and the creator combines the received information into an information importing file without a need to actively collect and sort each piece of information, which is not limited in this specification.
  • the information importing file uploaded from the terminal to the server is an electronic document
  • the electronic document may be generated from an entity document (for example, a paper document).
  • the terminal performs image acquisition and OCR on the entity document, so as to transform the entity document into the electronic document.
  • the predefined verification condition may be used by the server to verify the information included in the information importing file.
  • the verification condition may include a default condition provided by the foregoing application; or the verification condition may further include a condition customized by the user.
  • the user may be an enterprise administrator, and may customize a verification condition according to an actual requirement of the enterprise.
  • the predefined verification condition may be used for verifying the information included in the information importing file from one or more dimensions.
  • the predefined verification condition may be used for verification from an information dimension, for example, whether a quantity of pieces of the information included in the information importing file is excessively small or excessively large.
  • the predefined verification condition may be used for verification from a content dimension, for example, whether fields included in each piece of information are fields used as required, or whether the same field included in different information has duplicate values.
  • Step 304 The terminal receives an error comparison file returned by the server, where the error comparison file is generated by the server by marking information in the information importing file that does not pass the verification.
  • the information that does not pass the verification can be quickly located based on the error comparison file, thereby helping improve efficiency of finding and correcting errors.
  • a display attribute of the information that does not pass the verification may be adjusted by the server, to distinguish the information that does not pass the verification from information that passes the verification.
  • the display attribute may include at least one of the following: a background color, a border color, a character color, a font, a character size, and the like, which is not limited in this specification.
  • a problematic field in the information that does not pass the verification may be marked by the server, so that the user does not need to recognize a field or fields having problems in the information autonomously, and can accurately modify the problematic fields, thereby helping improve efficiency of finding and correcting errors.
  • the server may actively push the error comparison file to the user; or the server may provide a download page for the error comparison file to the user, so that the user may download the error comparison file according to a requirement; or the server may provide an online viewing page or an online editing page for the error comparison file to the user, so that the user may view or modify the error comparison file online.
  • the error comparison file may further include error description information added by the server.
  • the error description information may include each problem (a problem existing in the information importing file or all problems summarized in advance that may occur and not necessarily exist in the information importing file) existing in the information that does not pass the verification, a marking form (for example, which background color is used) corresponding to each problem, a solution to each problem, and the like.
  • the user can conveniently learn about a problem and a solution to the problem, and does not need to query the server for the problem existing in the marked information or the solution to be used, thereby preventing the user from performing frequent switching between online and offline, and helping simplify user operations and improve operation efficiency of the user.
  • the error comparison file may include the error description information separately added by the server. That is, the error description information and the originally included information are separated from each other.
  • the originally included information may be in one sheet of the Excel spreadsheet file, and the error description information may be in another sheet of the Excel spreadsheet file.
  • the error description information may be added by the server as a remark corresponding to the information that does not pass the verification or the problematic field thereof, so that in a process in which the user views the error comparison file, by triggering the information that does not pass the verification or the problematic field thereof, corresponding error description information (all the error description information or error description information for triggered information or field) may be temporarily shown, so that the user can quickly learn about a problem and a solution to the problem without repeatedly switching between a plurality of sheets.
  • the terminal may receive and display statistical data fed back by the server.
  • the statistical data may include at least one of the following: a quantity of pieces of information that is successfully imported into the system, a quantity of pieces of information in the imported information that does not pass the verification, a quantity of pieces of information that does not pass the verification and that is not imported, each problem existing in the information that does not pass the verification, a marking form corresponding to each problem, a solution to each problem, and the like, which is not limited in this specification.
  • the server may return an importing result page to the user, and display the statistical data in the importing result page for the user the view.
  • the user may modify the information that does not pass the verification or the problematic field in the error comparison file by viewing the statistical data.
  • the user may initiate an online viewing request to the server by using the terminal, and receive a display page of the error comparison file returned by the server.
  • the terminal may inform the server of information selected in the display page by the user, and if the selected information does not pass the verification, update the display page according to page data returned by the server to include error description information for the selected information.
  • corresponding error description information may be automatically updated and displayed in the display page, so that the user quickly learns about a problem existing in the selected information or the field thereof, a solution, and the like.
  • the terminal may initiate an online editing request to the server, for the server to edit information in the error comparison file according to the online editing request.
  • the user views the error comparison file in the display page based on the foregoing online viewing request, then the user may further initiate an online editing request for information or a field in the display page during viewing, so as to modify the related information or field.
  • the user may view the error comparison file in another manner, for example, download the error comparison file for offline viewing; and the user may also initiate an online editing request to the server, to edit the information in the error comparison file.
  • the terminal may initiate a correction invitation to an information provider corresponding to the information in the information importing file that does not pass the verification, for the information provider to perform correction.
  • the information provider provides related information to the user, or provides related information to another user and the another user forwards the related information to the user.
  • the related information is at least a part of information included in the information importing file. Because the information provider provides the related information at the early stage, the information provider is more familiar with correct content of the related information than the user, or learns about the correct content of the related information more conveniently than the user.
  • the information provider may directly participate in a correction operation for the related information based on the correction invitation, which can not only improve a correction speed, but also can reduce a risk of erroneously conveying correction content by the user compared with informing the user of the correction content and performing correction by the user, thereby avoiding repeated modification for the related information.
  • the correction invitation is used for instructing the information provider to initiate an online correction request to the server, for the information provider to perform correction by using an online correction interface provided by the server.
  • the information provider may initiate an online correction request to the server by triggering the correction invitation, and the server may return online correction page data to the information provider, so that an electronic device used by the information provider may display a corresponding online correction interface based on the online correction page data, and correct related information based on the online correction interface.
  • the online correction interface displayed to the information provider may only include related information corresponding to the information provider, to prevent the information provider from accessing to other information irrelevant to the information provider, thereby avoiding a leakage of sensitive content included in the other information.
  • the related information corresponding to the information provider may include: all information provided by the information provider, or a problematic field in the information provided by the information provider.
  • the correction request is used for instructing the information provider to return corrected information corresponding to the information in the information importing file that does not pass the verification.
  • the terminal may edit the information importing file or the error comparison file according to the corrected information; or the terminal may initiate an online editing request to the server according to the corrected information, to perform editing by using an online editing interface provided by the server.
  • the information provider does not directly perform a correct operation, but provides the corrected information to the user, for the user to edit and modify the related information based on the corrected information.
  • the server may automatically correct the information that does not pass the verification based on a corresponding verification rule (where the verification rule may be used for representing a correct format of the corresponding information), and return the corrected information (for example, add the corrected information to the error comparison file, or separately send the corrected information) to the user.
  • the terminal may receive the corrected information and display the corrected information to the user, and when the user confirms that the corrected information provided by the server is correct, the terminal may use the corrected information to replace corresponding information that does not pass the verification without manual modification by the user. If the user disagrees with the corrected information, the user may still actively perform modification.
  • the server may recognize error-prone information included in the information importing file. For example, the server may collect statistics on information types going wrong in importing processes in history, to use a preset quantity (for example, the first three) of information types with cumulative error counts ranked in the top as error-prone information, or use information types with cumulative error counts reaching a preset quantity as error-prone information. In brief, even if the error-prone information passes verification, the server may still mark the error-prone information in the error comparison file. Correspondingly, when displaying the error comparison file to the user, the terminal may display the marked error-prone information, to remind the user to confirm the error-prone information twice or more.
  • a preset quantity for example, the first three
  • imported information in the information importing file may have a dynamic value. That is, a value of corresponding information may change dynamically. Therefore, after completing an importing operation for the corresponding information, the terminal may provide the latest value of the information to the server in real time or periodically, to ensure that the server can always maintain the latest value of the information. If an information source of the information is not the terminal, the server may alternatively obtain the latest value of the information from the information source of the information without information transfer by the terminal.
  • FIG. 4 is a schematic interaction diagram of performing information maintenance for enterprise personnel, according to an exemplary embodiment.
  • the interaction process relates to a server, a terminal 1 , and a terminal 2 .
  • the terminal 1 belongs to a user Ua
  • the terminal 2 belongs to a user Ub
  • the user Ua is an administrator in the enterprise
  • the user Ub is an ordinary person in the enterprise.
  • a program on a server side of the application T runs on the server, that is, the server is configured as a server end of the application T.
  • a program on a terminal side of the application T runs on each of the terminal 1 and the terminal 2 , an account of the user Ua logs in to the terminal 1 , and an account of the user Ub logs in to the terminal 2 , so that the terminal 1 is configured as a client 1 corresponding to the user Ua, and the terminal 2 is configured as a client 2 corresponding to the user Ub.
  • An interaction process between the server, the terminal 1 , and the terminal 2 may include the following steps:
  • Step 401 The terminal 1 generates an information importing file.
  • the information importing file includes profile information of all personnel or newly-added personnel in the enterprise.
  • the profile information included in the information importing file may be obtained from statistical arrangement for paper files by the user Ua, or each of the enterprise personnel provides profile information thereof to the user Ua.
  • the user Ub may provide profile information of the user Ub to the user Ua by using the terminal 2 .
  • other enterprise personnel may also provide profile information thereof to the user Ua, and the user Ua may generate the information importing file by using the terminal 1 .
  • the profile information may be organized in a form of a spreadsheet file in the information importing file.
  • FIG. 5 is a display diagram of an information importing file, according to an exemplary embodiment.
  • a display interface 50 may include a spreadsheet tab 510 named “employee data,” and the spreadsheet tab 510 includes profile information of all personnel in the enterprise.
  • the spreadsheet tab 510 includes a plurality of headers, such as “User ID,” “Name,” “Mobile phone number,” “Job number,” “Identity card address,” and “Birth date,” and each piece of profile information includes values respectively corresponding to the headers.
  • a value of User ID is 132456416
  • a value of Name is Liu Yi
  • a value of Mobile phone number is 186****1234
  • a value of Job number is 000001
  • a value of Identity card address is Hangzhou
  • a value of birth date is 1985/11/12, which corresponds to the first piece of profile information in the spreadsheet tab 510 .
  • the situations of other profile information are similar, and are not listed herein one by one. It is to be noted that: in addition to the profile information of the enterprise personnel, the headers also belong to information included in the information importing file, and the headers are verified and modified in subsequent steps.
  • Step 402 The terminal 1 accesses and displays a management page for the server, and uploads the information importing file to the server based on the display page.
  • FIG. 6 is a schematic diagram of a management page, according to an exemplary embodiment.
  • a management page 60 displayed on the terminal 1 may include several levels of label options, where first-level label options include “Contacts,” “Workbench,” “Enterprise homepage,” “Enterprise data,” “Settings,” and the like. After the user Ua selects the label option “Contacts”, second-level label options such as “Internal contacts management,” “Department management,” “Smart personnel,” and “External contacts” can be invoked.
  • a corresponding label page 610 can be shown in the management page 60 , so as to implement related functions. Similarly, when the user Ua selects another second-level label option, a corresponding label page can also be invoked. In other embodiments, more levels of label options may be used in the management page 60 , or multi-level label options may not be necessarily used, which is not limited in this specification.
  • the user Ua may trigger a “Select file” button to select an information importing file locally or from a cloud storage space; or the user Ua may drag an information importing file into a dashed line box in the label page 610 , so as to upload the information importing file to the server.
  • Step 403 The server reads information in the file and perform verification.
  • the server maintains an information verification rule.
  • the information verification rule is used for verifying the information included in the information importing file, to determine whether each piece of information can be successfully imported, and whether modification needs to be performed.
  • Step 404 a The server imports information.
  • the server can distinguish information that passes the verification and information that does not pass the verification.
  • the server may directly import the information that passes the verification; and for the information that does not pass the verification, if an information verification rule that the information fails to satisfy is a non-critical rule, the server may still import the corresponding information, provided that a problematic field is modified subsequently. However, if the information verification rule that the information fails to satisfy is a critical rule, the server refuses to import the corresponding information.
  • Step 404 b The server marks information that does not pass the verification.
  • the server may directly mark corresponding information in the information importing file, to intuitively show that the information does not pass the verification, and may even represent a problem existing in each piece of information through a difference between marking manners.
  • Step 405 The server returns an importing result page to the terminal 1 , for the terminal 1 to display the importing result page.
  • the importing result page includes an importing result of the server for the information importing file.
  • FIG. 7 is a schematic diagram of an importing result page, according to an exemplary embodiment. After an importing operation is completed, the label page 610 included in the management page 60 may be switched into an importing result page 620 shown in FIG. 7 , for the user Ua to quickly learn about the situation of the current importing.
  • the importing result page 620 may include summary information and detailed information.
  • the summary information includes “Import profile information of 300 personnel: profile information of 283 personnel is successfully imported/there are problems in some content of 128 personnel, and profile information of 17 personnel fails to be imported,” which indicates that the information importing file includes profile information of 300 enterprise personnel, and there are problems in 128 pieces of profile information in the 283 pieces of imported profile information. That is, the 128 pieces of profile information do not satisfy the non-critical rule, the other 155 pieces of profile information satisfy all information verification rules, and 17 pieces of profile information do not satisfy the critical rule.
  • the detailed information is mainly used for providing a detailed description of the 128 pieces of profile information that have been imported but there are problems in some content and the 17 pieces of profile information that fail to be imported.
  • the described content mainly includes two parts of content: problems and solutions.
  • problems and solutions For example, one of reasons for the import failure is “Missing necessary information ‘Name’,” and a corresponding solution is “Please upload again after adding ‘Name’.”
  • the server marks the information that does not pass the verification by modifying a background color
  • the detailed information may further include a marking color correspondingly used for each problem. For example, the “Missing necessary information ‘Name’” is marked in red, and therefore may be correspondingly described as “Having been marked in red in the file” in the importing result page 620 .
  • the server may mark problematic profile information in the information importing file based on step 404 b , to generate a corresponding error comparison file. Based on the error comparison file, there are a plurality of manners of modifying related errors. A description is provided below separately with reference to steps 406 a to 411 a and steps 406 b to 409 b.
  • offline modification may be performed for the error comparison file, and a specific process thereof is as follows:
  • Step 406 a The terminal 1 downloads the error comparison file from the server.
  • the importing result page 620 shown in FIG. 7 may include a “Download error sheet” button, so that the user Ua may download the error comparison file by triggering the “Download error sheet” button.
  • Step 407 a The terminal 1 displays the error comparison file.
  • Step 408 a The terminal 1 edits the error comparison file.
  • the user Ua may perform an edition operation on the terminal 1 , and the terminal 1 may edit information included in the error comparison file based on the edition operation, so as to modify the problematic information.
  • FIG. 8 is a schematic diagram of displaying problematic information, according to an exemplary embodiment.
  • the display interface 50 may include the foregoing spreadsheet tab 510 named “Employee data,” and problematic cells in the spreadsheet tab 510 have been marked by the server in different colors, so that the user can quickly locate the problematic cells, to perform targeted edition and modification.
  • the server may generate a spreadsheet tab 510 (first tab) and a spreadsheet tab 520 (second tab) of the error comparison file.
  • the second tab may include a marking form corresponding to the information that does not pass the verification, a problem corresponding to the information that does not pass the verification, and a solution corresponding to the problem.
  • the first tab may include the information of the uploaded file.
  • the server may generate prompt information that is automatically displayable under the first tab when the information that does not pass the verification is triggered.
  • the prompt information may include the problem corresponding to the information that does not pass the verification and the solution corresponding to the problem.
  • the generated first tab may include the prompt information.
  • the user Ua may make reference to the importing result page 620 shown in FIG. 7 to determine a problem corresponding to a color marked in the spreadsheet tab 510 and a manner to be used to resolve the corresponding problem.
  • the display interface 50 may further include a spreadsheet tab 520 named “Error description” shown in FIG. 8 .
  • the user Ua may implement a quick switching operation between the spreadsheet tab 510 and the spreadsheet tab 520 .
  • FIG. 9 is a schematic diagram of displaying an error description offline, according to an exemplary embodiment. As shown in FIG.
  • the spreadsheet tab 520 may show a problem corresponding to each background color, that is, “an import error description,” and a solution provided for each problem, so that even in a completely offline scenario, the user Ua may still quickly modify information in the spreadsheet tab 510 based on the spreadsheet tab 520 , instead of having to view the importing result page 620 online.
  • FIG. 10 is a schematic diagram of quickly displaying an error description in an offline environment, according to an exemplary embodiment. As shown in FIG. 10 , it is assumed that in a process in which the user Ua browses the spreadsheet tab 510 , a cell included in the spreadsheet tab 510 is triggered (touched and selected, clicked by using a mouse, or the like). If there is a problem in content of the cell or information to which the content belongs, corresponding prompt information 511 may be shown.
  • the prompt information 511 may include the corresponding problem and a solution to the problem.
  • the server may further add remark information for the cells, where the remark content is the corresponding problems and solutions to the problems.
  • the terminal 1 can implement the embodiment shown in FIG. 10 according to this method, and the user Ua does not need to perform repeated switching between the spreadsheet tab 510 and the spreadsheet tab 520 .
  • Step 409 a The terminal 1 sends the error comparison file to the terminal 2 .
  • Step 410 a The terminal 2 corrects error information according to a correct operation performed by the user Ua, and returns a corrected file to the terminal 1 .
  • Step 411 a The terminal 1 uploads the corrected file to the server.
  • the user Ua can probably only edit and modify some information, and cannot correct all errors. Therefore, it is assumed that a piece of problematic information is provided by the user Ub, then the user Ua may send the error comparison file to the user Ub, so that the user Ub may correct the information provided by the user Ub. If the user Ua can complete edition and modification for all problems, steps 409 a and 410 a may be omitted, and the terminal 1 may directly upload a file having been corrected by the user Ua to the server. Similarly, the user Ua may completely perform no modification, and directly send the error comparison file to the user Ub, for the user Ub to perform correction.
  • the information included in the error comparison file may be from other users, then the user Ua may separately send the error comparison file to the users, for the users to perform correction.
  • a process thereof is similar to steps 409 a and 410 a , which is not listed herein one by one.
  • the user Ua may upload the corrected file to the server by triggering an “Upload corrected sheet” button included in the importing result page 620 shown in FIG. 7 , for the server to perform importing. There may still be information that does not pass the verification in the corrected file, then the foregoing steps may be repeated, until all files pass the verification and are successfully imported.
  • online modification may be performed for the error comparison file, and a specific process thereof is as follows:
  • Step 406 b The user Ua edits the error comparison file online by using the terminal 1 .
  • the user Ua may trigger, by using the terminal 1 , an “Edit sheet online” button included in the importing result page 620 shown in FIG. 7 , to initiate an online editing request to the server.
  • the server may return corresponding page data.
  • the page data is used for displaying an online editing page 630 shown in FIG. 11 on the terminal 1 .
  • FIG. 11 is a schematic diagram of editing file content online, according to an exemplary embodiment.
  • the online editing page 630 shown in FIG. 11 includes displayed content similar to that of the spreadsheet tab 510 shown in FIG. 8 , so that the user Ua can clearly view the information included in the error comparison file, especially can quickly distinguish problematic cells (that is, fields or headers included in the information) based on a background color difference.
  • the user Ua may directly edit the content included in the online editing page 630 , for example, modify a value of a cell, add content to an empty cell, or delete an existing cell.
  • FIG. 12 is a schematic diagram of displaying error prompt information during online editing, according to an exemplary embodiment.
  • the server may update the online editing page 630 , to display an error prompt interface 640 shown in FIG. 12 .
  • the error prompt interface 640 may include a cause of an error and a solution.
  • a cause of an error may be “The header name is not recognized,” and a solution may be “You may select a similar field from the existing fields of the system for matching, or add a new field.”
  • all existing fields for example, fields such as “Name,” “Mailbox,” and “Department” that belong to “Basic information,” and fields such as “Employee type” and “Employee state” that belong to “Job information” in the system may be displayed to the user Ua for selection, and the user Ua may further search for an existing field by using a search box.
  • the original content “Identity card address” in the cell may be replaced with a field, for example, “Identity card location,” selected by the user Ua. If there are no similar fields expressing same meaning, the user Ua may add “Identity card address” as a new field in the system by using an “Add now” button included in the error prompt interface 640 .
  • FIG. 13 a is another schematic diagram of displaying error prompt information during online editing, according to an exemplary embodiment.
  • a cause of an error may be “The format of the mobile phone number is incorrect,” and a solution may be “If it is a foreign mobile phone number, the country code needs to be added.”
  • the server may obtain an edition operation performed by the terminal 1 .
  • the obtaining operation may be, for example, real-time.
  • the server may verify the edited content, and update the online editing page 630 according to a verification result, so that the user Ua may view an effect after the edition immediately: If the edited content pass the verification, a background color of the corresponding cell is restored to a default color; otherwise, the background color of the corresponding cell is maintained or adjusted according to a problem of the edited content.
  • Step 407 b The terminal 1 initiates a correction request to the terminal 2 .
  • Step 408 b The user Ub corrects the error comparison file online by using the terminal 2 .
  • Step 409 b The terminal 1 requests the server for importing again.
  • the online editing page 630 shown in FIG. 12 may include an “Invite other administrators to refine” button.
  • the user Ua may send an invitation (that is, a correction request) to another administrator by triggering the button, so that the another administrator may perform online correction for the error comparison file based on the invitation.
  • an invitation that is, a correction request
  • the another administrator may perform online correction for the error comparison file based on the invitation.
  • a cell selected in FIG. 12 is a header, that is, the cell corresponds to all users in the error comparison file, and a cell selected in FIG. 13 a corresponds to a user “Sun Qi.” Therefore, in the embodiment shown in FIG. 13 a , the error prompt interface 640 may show an “Invite ‘Sun Qi’ to refine” button, so that the user Ua may send an invitation (that is, a correction request) to the user “Sun Qi” by triggering the button.
  • the process is equivalent to that the terminal 1 initiates a correction request to the terminal 2 , then the user Ub may receive and view a corresponding invitation message 710 by using, for example, a communication session interface 70 (for example, the user Ua is “Whyte”) shown in FIG. 13 b .
  • the invitation message 710 may be online editing invitation information, so that the user may enter an online correction interface by triggering the invitation message 710 , to perform online correction for the error comparison file.
  • the invitation message 710 may carry the error comparison file or information in the error comparison file that needs to be corrected by the user Ub, for the user Ub to complete correction on the terminal 2 and then return the corrected file or information to the user Ua.
  • Information of the user “Sun Qi” may not necessarily be provided to the user Ua by the user “Sun Qi”.
  • the user Ua may independently select a user whom the user Ua would like to invite and initiate a correction request to the user.
  • the server may only provide information or a cell selected by the user Ua to the user Ub, to avoid providing other information (especially information of other users) to the user Ub, thereby avoiding a leakage of sensitive content.
  • the information importing solution of this specification may also be applied to other scenarios, such as importing financial information in a financial scenario, importing asset information in an asset management scenario, and importing group information in a social group scenario, which is not limited in this specification.
  • the social group scenario is used as an example.
  • the technical solution of this specification can help a group leader determine an information missing situation through check of group information, and even automatically correct an existing error, and to help the group leader solve a problem.
  • the server can push prompt information in the group to instruct group members to complete or correct the corresponding information, and to help the group leader complete an importing operation on related information.
  • FIG. 14 is a schematic structural diagram of a device, according to an exemplary embodiment.
  • the device includes a processor 1402 , an internal bus 1404 , a network interface 1406 , a memory 1408 , and a non-volatile memory 1410 , and may further include hardware required for other services.
  • the processor 1402 reads a corresponding computer program from the non-volatile memory 1410 into the memory 1408 and then executes the computer program, to form an information importing apparatus at a logic level.
  • one or more embodiments of this specification do not exclude other implementations, for example, logic devices or a software-hardware combination. That is, execution entities of the following processing procedures are not limited to logic units and may alternatively be hardware or logic devices.
  • the information importing apparatus may include: a file receiving unit 1501 , configured to enable a server to receive an information importing file uploaded by a user, where the information importing file includes information to be imported into a system; a verification unit 1502 , configured to enable the server to verify the information included in the information importing file; a marking unit 1503 , configured to enable the server to mark information in the information importing file that does not pass the verification, so as to generate an error comparison file; and a file returning unit 1504 , configured to enable the server to return the error comparison file to the user.
  • the information importing file includes a plurality of pieces of information in the same format to be imported into the system in batches.
  • the marking unit 1503 is configured to: enable the server to adjust a display attribute of the information that does not pass the verification, to distinguish the information that does not pass the verification from information that passes the verification.
  • the display attribute includes at least one of the following: a background color, a border color, a character color, a font, and a character size.
  • the marking unit 1503 is configured to: enable the server to mark, when each piece of information included in the information importing file includes a plurality of fields, a problematic field in the information that does not pass the verification.
  • the apparatus further includes: an addition unit 1505 , configured to enable the server to add error description information to the error comparison file, where the error description information includes each problem existing in the information that does not pass the verification, a marking form corresponding to each problem, and a solution to each problem.
  • an addition unit 1505 configured to enable the server to add error description information to the error comparison file, where the error description information includes each problem existing in the information that does not pass the verification, a marking form corresponding to each problem, and a solution to each problem.
  • the apparatus further includes: a feedback unit 1506 , configured to enable the server to feed statistical data back to the user, where the statistical data includes at least one of the following: a quantity of pieces of information that is successfully imported into the system, a quantity of pieces of information in the imported information that does not pass the verification, a quantity of pieces of information that does not pass the verification and that is not imported, each problem existing in the information that does not pass the verification, a marking form corresponding to each problem, and a solution to each problem.
  • a feedback unit 1506 configured to enable the server to feed statistical data back to the user, where the statistical data includes at least one of the following: a quantity of pieces of information that is successfully imported into the system, a quantity of pieces of information in the imported information that does not pass the verification, a quantity of pieces of information that does not pass the verification and that is not imported, each problem existing in the information that does not pass the verification, a marking form corresponding to each problem, and a solution to each problem.
  • the apparatus further includes: a page returning unit 1507 , configured to enable the server to receive an online viewing request initiated by the user, and return a display page of the error comparison file to the user; a determining unit 1508 , configured to enable the server to determine information selected in the display page by the user; and an update unit 1509 , configured to, if the selected information does not pass the verification, enable the server to update the display page to include error description information for the selected information.
  • a page returning unit 1507 configured to enable the server to receive an online viewing request initiated by the user, and return a display page of the error comparison file to the user
  • a determining unit 1508 configured to enable the server to determine information selected in the display page by the user
  • an update unit 1509 configured to, if the selected information does not pass the verification, enable the server to update the display page to include error description information for the selected information.
  • the apparatus further includes: an editing request receiving unit 1510 , configured to enable the server to receive an online editing request initiated by the user; and an editing unit 1511 , configured to enable the server to edit information in the error comparison file according to the online editing request.
  • an editing request receiving unit 1510 configured to enable the server to receive an online editing request initiated by the user
  • an editing unit 1511 configured to enable the server to edit information in the error comparison file according to the online editing request.
  • the apparatus further includes: a correction request receiving unit 1512 , configured to enable the server to receive an online correction request initiated by an information provider, where the online correction request is initiated by the information provider based on a correction invitation sent by the user; and a providing unit 1513 , configured to enable the server to provide an online correction interface to the information provider, where the online correction interface includes related information in the information importing file that corresponds to the information provider, for the information provider to perform correction.
  • a correction request receiving unit 1512 configured to enable the server to receive an online correction request initiated by an information provider, where the online correction request is initiated by the information provider based on a correction invitation sent by the user
  • a providing unit 1513 configured to enable the server to provide an online correction interface to the information provider, where the online correction interface includes related information in the information importing file that corresponds to the information provider, for the information provider to perform correction.
  • the online correction interface only includes the related information corresponding to the information provider, where the related information corresponding to the information provider includes: all information provided by the information provider, or a problematic field in the information provided by the information provider.
  • FIG. 16 is a schematic structural diagram of a device, according to an exemplary embodiment.
  • the device includes a processor 1602 , an internal bus 1604 , a network interface 1606 , a memory 1608 , and a non-volatile memory 1610 , and may further include hardware required for other services.
  • the processor 1602 reads a corresponding computer program from the non-volatile memory 1610 into the memory 1608 and then executes the computer program, to form an information importing apparatus at a logic level.
  • one or more embodiments of this specification do not exclude other implementations, for example, logic devices or a software-hardware combination. That is, execution entities of the following processing procedures are not limited to logic units and may alternatively be hardware or logic devices.
  • the information importing apparatus may include: an uploading unit 1701 , configured to enable a terminal to upload an information importing file to a server, for the server to verify information included in the information importing file and import the information into a system; and a receiving unit 1702 , configured to enable the terminal to receive an error comparison file returned by the server, where the error comparison file is generated by the server by marking information in the information importing file that does not pass the verification.
  • the apparatus further includes: an invitation unit 1703 , configured to enable the terminal to initiate a correction invitation to an information provider corresponding to the information in the information importing file that does not pass the verification, for the information provider to perform correction.
  • an invitation unit 1703 configured to enable the terminal to initiate a correction invitation to an information provider corresponding to the information in the information importing file that does not pass the verification, for the information provider to perform correction.
  • the correction invitation is used for instructing the information provider to initiate an online correction request to the server, for the information provider to perform correction by using an online correction interface provided by the server; or the correction request is used for instructing the information provider to return corrected information corresponding to the information in the information importing file that does not pass the verification; and the apparatus further includes: an editing unit 1704 , configured to: enable the terminal to edit the information importing file or the error comparison file according to the corrected information; or enable the terminal to initiate an online editing request to the server according to the corrected information, to perform editing by using an online editing interface provided by the server.
  • the system, the apparatus, the module or the unit described in the foregoing embodiments may be implemented by a computer chip or an entity, or implemented by a product having a certain function.
  • a typical implementation device is a computer.
  • a specific form of the computer may be a PC, a laptop computer, a cellular phone, a camera phone, a smartphone, a personal digital assistant, a media player, a navigation device, an email transceiver device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.
  • the computer includes one or more processors (such as CPUs), an input/output interface, a network interface, and a memory.
  • the memory may include a form such as a volatile memory, a random-access memory (RAM) and/or a non-volatile memory such as a read-only memory (ROM) or a flash RAM in a computer-readable medium.
  • RAM random-access memory
  • ROM read-only memory
  • flash RAM flash RAM
  • the memory is an example of the computer-readable medium.
  • the computer-readable medium includes a non-volatile medium and a volatile medium, a removable medium and a non-removable medium, which may implement storage of information by using any method or technology.
  • the information may be a computer-readable instruction, a data structure, a program module, or other data.
  • Examples of a storage medium of a computer include, but are not limited to, a phase-change memory (PRAM), a static random-access memory (SRAM), a dynamic random-access memory (DRAM), a RAM of another type, a ROM, an electrically erasable programmable read-only memory (EEPROM), a flash memory or another memory technology, a compact disc read-only memory (CD-ROM), a digital versatile disc (DVD) or another optical storage device, a cassette tape, a magnetic disk storage, a quantum memory, a graphene-based storage medium or another magnetic storage device, or any other non-transmission medium, which may be configured to store information accessible by a computing device.
  • the computer-readable medium does not include transitory computer-readable media, such as a modulated data signal and a modulated carrier.
  • first, second, third, and the like may be used to describe various information in one or more embodiments of this specification, such information should not be limited to these terms. These terms are merely used to distinguish between information of the same type. For example, without departing from the scope of one or more embodiments of this specification, first information may also be referred to as second information. Similarly, second information may also be referred to as first information. According to the context, the word “if” used herein may be interpreted as “during” or “when” or “in response to determining.”

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Human Computer Interaction (AREA)
  • Software Systems (AREA)
  • Information Transfer Between Computers (AREA)
  • Document Processing Apparatus (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Provided in one or more embodiments of the description are an information importing method and apparatus. The method may comprise: a server receiving an information importing file uploaded by a user, wherein the information importing file includes information to be imported into a system; the server verifying the information included in the information importing file; the server marking information in the information importing file that does not pass the verification, so as to generate an error comparison file; and the server returning the error comparison file to the user.

Description

CROSS-REFERENCE TO RELATED APPLICATIONS
This application is a continuation application of International Patent Application No. PCT/CN2020/116695, filed on Sep. 22, 2020, and entitled “INFORMATION IMPORTING METHOD AND APPARATUS,” which claims priority to Chinese Patent Application No. 201910922815.8, filed on Sep. 27, 2019 and entitled “INFORMATION IMPORTING METHOD AND APPARATUS.” The entire contents of all of the above applications are incorporated herein by reference in their entirety.
TECHNICAL FIELD
One or more embodiments of this specification relate to the field of information technologies, and in particular, to an information importing method and apparatus.
BACKGROUND
In related technologies, a server can provide an interaction interface to a user through a web page or a client, for the user to fill in information based on the interaction interface, and upload the information to the server for processing or storage. However, if there is a relatively large amount of information to be uploaded, especially in a case where formats of the information are all the same or similar, for example, an enterprise administrator needs to upload personal profile information of all employees in an enterprise, the foregoing manner of filling in information online usually has low efficiency.
Therefore, the user may first collect information on a terminal (may also need to perform further information processing or information sorting), and subsequently record the collected information in a file (such as an Excel spreadsheet file). In this way, provided that the file is uploaded to the server, the server can perform content parsing and batch importing on the file, and then process or store the imported information. However, due to some reasons, for example, there is a relatively large quantity of fields included in the information or a relatively large quantity of pieces of information, some errors usually exist in the information recorded in the file.
SUMMARY
In view of this, one or more embodiments of this specification provide an information importing method and apparatus.
To achieve the foregoing objective, the one or more embodiments of this specification provide the following technical solutions.
According to a first aspect of the one or more embodiments of this specification, an information importing method is provided, including: receiving, by a server, an information importing file uploaded by a user, where the information importing file includes information to be imported into a system; verifying, by the server, the information included in the information importing file; marking, by the server, information in the information importing file that does not pass the verification, so as to generate an error comparison file; and returning, by the server, the error comparison file to the user.
According to a second aspect of the one or more embodiments of this specification, an information importing method is provided, including: uploading, by a terminal, an information importing file to a server, for the server to verify information included in the information importing file and import the information into a system; and receiving, by the terminal, an error comparison file returned by the server, where the error comparison file is generated by the server by marking information in the information importing file that does not pass the verification.
According to a third aspect of the one or more embodiments of this specification, an information importing apparatus is provided, including: a receiving unit, configured to enable a server to receive an information importing file uploaded by a user, where the information importing file includes information to be imported into a system; a verification unit, configured to enable the server to verify the information included in the information importing file; a marking unit, configured to enable the server to mark information in the information importing file that does not pass the verification, so as to generate an error comparison file; and a returning unit, configured to enable the server to return the error comparison file to the user.
According to a fourth aspect of the one or more embodiments of this specification, an information importing apparatus is provided, including: an uploading unit, configured to enable a terminal to upload an information importing file to a server, for the server to verify information included in the information importing file and import the information into a system; and a receiving unit, configured to enable the terminal to receive an error comparison file returned by the server, where the error comparison file is generated by the server by marking information in the information importing file that does not pass the verification.
According to a fifth aspect of the one or more embodiments of this specification, an electronic device is provided, including: a processor; and a memory configured to store instructions executable by the processor, where the processor is configured to execute the executable instructions to implement the method according to the first aspect.
According to a sixth aspect of the one or more embodiments of this specification, a computer-readable storage medium is provided, storing computer instructions, where the instructions are executed by a processor to implement steps in the method according to the first aspect.
According to a seventh aspect of the one or more embodiments of this specification, an electronic device is provided, including: a processor; and a memory configured to store instructions executable by the processor, where the processor is configured to execute the executable instructions to implement the method according to the second aspect.
According to an eighth aspect of the one or more embodiments of this specification, a computer-readable storage medium is provided, storing computer instructions, where the instructions are executed by a processor to implement steps in the method according to the second aspect.
BRIEF DESCRIPTION OF THE DRAWINGS
FIG. 1 is a schematic architectural diagram of an information importing system, according to an exemplary embodiment.
FIG. 2 is a flowchart of an information importing method on a server side, according to an exemplary embodiment.
FIG. 3 is a flowchart of an information importing method on a terminal side, according to an exemplary embodiment.
FIG. 4 is a schematic interaction diagram of performing information maintenance for enterprise personnel, according to an exemplary embodiment.
FIG. 5 is a display diagram of an information importing file, according to an exemplary embodiment.
FIG. 6 is a schematic diagram of a management page, according to an exemplary embodiment.
FIG. 7 is a schematic diagram of an importing result page, according to an exemplary embodiment.
FIG. 8 is a schematic diagram of displaying problematic information, according to an exemplary embodiment.
FIG. 9 is a schematic diagram of displaying an error description offline, according to an exemplary embodiment.
FIG. 10 is a schematic diagram of quickly displaying an error description in an offline environment, according to an exemplary embodiment.
FIG. 11 is a schematic diagram of editing file content online, according to an exemplary embodiment.
FIG. 12 is a schematic diagram of displaying error prompt information during online editing, according to an exemplary embodiment.
FIG. 13 a is another schematic diagram of displaying error prompt information during online editing, according to an exemplary embodiment.
FIG. 13 b is a schematic diagram of a communication session interface, according to an exemplary embodiment.
FIG. 14 is a schematic structural diagram of a device on a server side, according to an exemplary embodiment.
FIG. 15 is a block diagram of an information importing apparatus on a server side, according to an exemplary embodiment.
FIG. 16 is a schematic structural diagram of a device on a terminal side, according to an exemplary embodiment.
FIG. 17 is a block diagram of an information importing apparatus on a terminal side, according to an exemplary embodiment.
DETAILED DESCRIPTION
Exemplary embodiments are described in detail herein, and examples of the exemplary embodiments are shown in the accompanying drawings. When the following description involves the accompanying drawings, unless otherwise indicated, the same numerals in different accompanying drawings represent the same or similar elements. The implementations described in the following exemplary embodiments are not all the implementations consistent with one or more embodiments of this specification, but are instead only examples of methods and apparatuses that are described in detail in the appended claims and that are consistent with some aspects of one or more embodiments of this specification.
It should be noted that in other embodiments, the steps of corresponding methods are not necessarily performed according to a sequence shown and described in this specification. In some other embodiments, the methods may include more or fewer steps than those described in this specification. In addition, a single step described in this specification may be divided into a plurality of steps for description in other embodiments, and a plurality of steps described in this specification may be combined into a single step for description in other embodiments.
FIG. 1 is a schematic architectural diagram of an information importing system, according to an exemplary embodiment. As shown in FIG. 1 , the system may include a server 11, a network 12, and several electronic devices such as a mobile phone 13, and a personal computer (PC) 14.
The server 11 may be a physical server including an independent host. Alternatively, the server 11 may be a virtual server carried by a host cluster. During running, the server 11 may run a program on a server side of an application, to achieve related service functions of the application. For example, when the server 11 runs a program of a group office platform, the server may be implemented as a server end of the group office platform. In technical solutions of the one or more embodiments of this specification, the server 11 may cooperate with clients running on the mobile phone 13 and the PC 14 to implement an information importing solution.
In this embodiment, the group office platform may not only implement a communication function, and may be used as an integrated function platform of many other functions, for example, processing of an internal event of a group such as an examination and approval event (for example, examination and approval events such as asking off, applying for office supplies, and financial affairs), an attendance checking event, a task event, or a log event, or processing of an external event of the group such as ordering food or purchasing, which is not limited in one or more embodiments of this specification. The group office platform may support a mobile group office scenario, to enable users to use mobile electronic devices such as the mobile phone 13 to implement related matters of group office. The group office platform may also be compatible with non-mobile electronic devices such as the PC 14 to implement the related matters of group office. In this case, the group office platform may be referred to as a mobile group office platform. For example, the mobile group office platform may be carried on an instant messaging application in related technologies, for example, an enterprise instant messaging (EIM) application. The instant messaging function is merely one of the communication functions supported by the mobile group office platform, and the mobile group office platform may further implement many other functions described above, which are not repeatedly described herein.
Both the mobile phone 13 and the PC 14 are some types of electronic devices that may be used by users. Actually, the users may alternatively use the following types of electronic devices obviously: a tablet device, a notebook computer, a personal digital assistant (PDA), a wearable device (such as smart glasses or a smartwatch), and the like. This is not limited in one or more embodiments of this specification. During running, the electronic device may run a program on a client side of an application, to achieve related service functions of the application. For example, when the electronic device runs a program of a group office platform, the electronic device may be implemented as a client of the group office platform. It should be noted that an application of a client of the group office platform may be pre-installed on the electronic device, and then the client may start and run on the electronic device. When an online “client” of a technology such as HTML5 is used, the client may be obtained and run without installing a corresponding application on the electronic device.
The network 12 through which the mobile phone 13, the PC 14, and the server 11 interact with each other may include a plurality of types of wired or wireless networks. In an embodiment, the network 12 may include a public switched telephone network (PSTN) and the Internet.
FIG. 2 is a flowchart of an information importing method on a server side, according to an exemplary embodiment. As shown in FIG. 2 , the method is applicable to a server, and may include the following steps:
Step 202: A server receives an information importing file uploaded by a user, where the information importing file includes information to be imported into a system.
In an embodiment, the server may provide a web page access service, for the user to open an access page of the server by accessing a domain name of the server on a browser of a terminal, upload the information importing file based on the access page, and perform other operations.
In an embodiment, a program on a server side of an application runs on the server, for the server to be configured as a server end of the application; and a program on a client side of the application runs on the terminal, for the terminal to be configured as a client of the application. For example, the application may be the foregoing group office platform. The user may upload the information importing file and perform other operations by using the client.
In an embodiment, the information importing file may include one or more pieces of information. Based on a batch import function of the server, after generating the information importing file on the terminal or another device, the user may upload the information importing file to the server, for the server to import the information into the system in batches, and the user does not need to perform importing piece by piece.
In an embodiment, the information importing file may include a plurality of pieces of information in the same format to be imported into the system in batches. For example, the information importing file may include a spreadsheet file. The spreadsheet file is provided with several headers, and each piece of information includes fields corresponding to the headers respectively and values of the fields. For example, when the information included in the information importing file is profile information of personnel in an enterprise, the headers may include name, gender, job number, identity card number, and the like, and each of the enterprise personnel corresponds to one piece of information. The information includes “Zhang San, Male, 0001, 110 . . . ,” which indicates that a value of “name” is “Zhang San,” a value of “gender” is “Male,” a value of “job number” is “0001,” a value of “identity card number” is “110 . . . ,” and so on. The information importing file may not necessarily be a spreadsheet file, and file types that can clearly indicate information content may all be used, which is not limited in this specification.
In an embodiment, the information importing file may be uploaded to the server by the user by using a terminal. The user may be a creator of the information importing file, or the user may obtain the information importing file from another user, which is not limited in this specification. The information included in the information importing file may be sorted out by the creator based on collected data; or users respectively generate information corresponding to the users and send the information to the creator, and the creator combines the received information into an information importing file without a need to actively collect and sort each piece of information, which is not limited in this specification.
In an embodiment, the information importing file uploaded from the terminal to the server is an electronic document, and the electronic document may be generated from an entity document (for example, a paper document). For example, the terminal performs image acquisition and optical character recognition (OCR) on the entity document, so as to transform the entity document into the electronic document.
Step 204: The server verifies the information included in the information importing file.
In an embodiment, the server may verify the information included in the information importing file by using a predefined verification condition. The verification condition may include a default condition provided by the foregoing application; or the verification condition may further include a condition customized by the user. For example, in an enterprise scenario, the user may be an enterprise administrator, and may customize a verification condition according to an actual requirement of the enterprise.
In an embodiment, the predefined verification condition may be used for verifying the information included in the information importing file from one or more dimensions. For example, the predefined verification condition may be used for verification from an information dimension, for example, whether a quantity of pieces of the information included in the information importing file is excessively small or excessively large. In another example, the predefined verification condition may be used for verification from a content dimension, for example, whether fields included in each piece of information are fields used as required, or whether the same field included in different information has duplicate values.
Step 206: The server marks information in the information importing file that does not pass the verification, so as to generate an error comparison file.
In an embodiment, compared with listing problems or errors to the user separately, by directly marking the information that does not pass the verification in the information importing file to generate the error comparison file in the technical solution of this specification, the information that does not pass the verification can be quickly located based on the error comparison file, thereby helping improve efficiency of finding and correcting errors.
In an embodiment, the server may adjust a display attribute of the information that does not pass the verification, to distinguish the information that does not pass the verification from information that passes the verification. The display attribute may include at least one of the following: a background color, a border color, a character color, a font, a character size, and the like, which is not limited in this specification.
In an embodiment, when each piece of information included in the information importing file includes a plurality of fields, the server may mark a problematic field in the information that does not pass the verification, so that the user does not need to recognize a field or fields having problems in the information autonomously, and can accurately modify the problematic fields, thereby helping improve efficiency of finding and correcting errors.
Step 208: The server returns the error comparison file to the user.
In an embodiment, the server may actively push the error comparison file to the user; or the server may provide a download page for the error comparison file to the user, so that the user may download the error comparison file according to a requirement; or the server may provide an online viewing page or an online editing page for the error comparison file to the user, so that the user may view or modify the error comparison file online.
In an embodiment, in addition to marking the information that does not pass the verification, the server may further add error description information to the error comparison file. The error description information may include each problem (a problem existing in the information importing file or all problems summarized in advance that may occur and not necessarily exist in the information importing file) existing in the information that does not pass the verification, a marking form (for example, which background color is used) corresponding to each problem, a solution to each problem, and the like. By adding the error description information to the error comparison file, especially in a case that the user downloads the error comparison file and performs offline modification, the user can conveniently learn about a problem and a solution to the problem, and does not need to query the server for the problem existing in the marked information or the solution to be used, thereby preventing the user from performing frequent switching between online and offline, and helping simplify user operations and improve operation efficiency of the user.
In an embodiment, the server may separately add the error description information to the error comparison file. That is, the error description information and the originally included information are separated from each other. For example, when the information importing file is an Excel spreadsheet file, the originally included information may be in one sheet of the Excel spreadsheet file, and the error description information may be in another sheet of the Excel spreadsheet file. Alternatively, the server may add the error description information as a remark corresponding to the information that does not pass the verification or the problematic field thereof, so that in a process in which the user views the error comparison file, by triggering the information that does not pass the verification or the problematic field thereof, corresponding error description information (all the error description information or error description information for triggered information or field) may be temporarily shown, so that the user can quickly learn about a problem and a solution to the problem without repeatedly switching between a plurality of sheets.
In an embodiment, the server may feed statistical data back to the user. The statistical data may include at least one of the following: a quantity of pieces of information that is successfully imported into the system, a quantity of pieces of information in the imported information that does not pass the verification, a quantity of pieces of information that does not pass the verification and that is not imported, each problem existing in the information that does not pass the verification, a marking form corresponding to each problem, a solution to each problem, and the like, which is not limited in this specification. For example, in response to an operation of uploading the information importing file to the server by the user, the server may return an importing result page to the user, and display the statistical data in the importing result page for the user the view. The user may modify the information that does not pass the verification or the problematic field in the error comparison file by viewing the statistical data.
In an embodiment, the server may receive an online viewing request initiated by the user, and return a display page of the error comparison file to the user. In addition, the server may determine information selected in the display page by the user, and if the selected information does not pass the verification, update the display page to include error description information for the selected information. Based on this embodiment, when the user selects information or a field included in the information in the display page, corresponding error description information may be automatically updated and displayed in the display page, so that the user quickly learns about a problem existing in the selected information or the field thereof, a solution, and the like.
In an embodiment, the server may receive an online editing request initiated by the user, and edit information in the error comparison file according to the online editing request. For example, the user views the error comparison file in the display page based on the foregoing online viewing request, then the user may further initiate an online editing request for information or a field in the display page during viewing, so as to modify the related information or field. In another example, the user may view the error comparison file in another manner, for example, download the error comparison file for offline viewing; and the user may also initiate an online editing request to the server, to edit the information in the error comparison file.
In an embodiment, the server may receive an online correction request initiated by an information provider. The online correction request is initiated by the information provider based on a correction invitation sent by the user, and the information provider provides related information to the user, or provides related information to another user and the another user forwards the related information to the user. The related information is at least a part of information included in the information importing file. Subsequently, the server may provide an online correction interface to the information provider. The online correction interface includes related information in the information importing file that corresponds to the information provider, for the information provider to perform correction. Because the information provider provides the related information at the early stage, the information provider is more familiar with correct content of the related information than the user, or learns about the correct content of the related information more conveniently than the user. Therefore, after the user sends the correction invitation to the information provider, the information provider may directly participate in a correction operation for the related information based on the correction invitation, which can not only improve a correction speed, but also can reduce a risk of erroneously conveying correction content by the user compared with informing the user of the correction content and performing correction by the user, thereby avoiding repeated modification for the related information.
In an embodiment, in a process in which the information provider corrects the related information by using the online correction interface, the online correction interface displayed to the information provider may only include related information corresponding to the information provider, to prevent the information provider from accessing to other information irrelevant to the information provider, thereby avoiding a leakage of sensitive content included in the other information. The related information corresponding to the information provider may include: all information provided by the information provider, or a problematic field in the information provided by the information provider.
In an embodiment, for the information in the information importing file that does not pass the verification, especially for information with correct content and a wrong format, the server may automatically correct the information that does not pass the verification based on a corresponding verification rule (where the verification rule may be used for representing a correct format of the corresponding information), and return the corrected information (for example, add the corrected information to the error comparison file, or separately send the corrected information) to the user. Correspondingly, when the user confirms that the corrected information provided by the server is correct, the corrected information may be used for replacing corresponding information that does not pass the verification without manual modification by the user. If the user disagrees with the corrected information, the user may still actively perform modification.
In an embodiment, the server may recognize error-prone information included in the information importing file. For example, the server may collect statistics on information types going wrong in importing processes in history, to use a preset quantity (for example, the first three) of information types with cumulative error counts ranked in the top as error-prone information, or use information types with cumulative error counts reaching a preset quantity as error-prone information. In brief, even if the error-prone information passes verification, the server may still mark the error-prone information in the error comparison file, to remind the user to confirm the error-prone information twice or more.
In an embodiment, imported information in the information importing file may have a dynamic value. That is, a value of corresponding information may change dynamically. After completing an importing operation for the corresponding information, the server may obtain the latest value of the information from the terminal (or an information source) in real time or periodically, to ensure that the server can always maintain the latest value of the information.
FIG. 3 is a flowchart of an information importing method on a terminal side, according to an exemplary embodiment. As shown in FIG. 3 , the method is applicable to a terminal, and may include the following steps:
Step 302: A terminal uploads an information importing file to a server, for the server to verify information included in the information importing file and import the information into a system.
In an embodiment, the server may provide a web page access service, for the user to open an access page of the server by accessing a domain name of the server on a browser of a terminal, upload the information importing file based on the access page, and perform other operations.
In an embodiment, a program on a server side of an application runs on the server, for the server to be configured as a server end of the application; and a program on a client side of the application runs on the terminal, for the terminal to be configured as a client of the application. For example, the application may be the foregoing group office application. The user may upload the information importing file and perform other operations by using the client.
In an embodiment, the information importing file may include one or more pieces of information. Based on a batch import function of the server, after generating the information importing file on the terminal or another device, the user may upload the information importing file to the server by using the terminal, for the server to import the information into the system in batches, and the user does not need to perform importing piece by piece.
In an embodiment, the information importing file may include a plurality of pieces of information in the same format to be imported into the system in batches. For example, the information importing file may include a spreadsheet file. The spreadsheet file is provided with several headers, and each piece of information includes fields corresponding to the headers respectively and values of the fields. For example, when the information included in the information importing file is profile information of personnel in an enterprise, the headers may include name, gender, job number, identity card number, and the like, and each of the enterprise personnel corresponds to one piece of information. The information includes “Zhang San, Male, 0001, 110 . . . ,” which indicates that a value of “name” is “Zhang San,” a value of “gender” is “Male,” a value of “job number” is “0001,” a value of “identity card number” is “110 . . . ,” and so on. The information importing file may not necessarily be a spreadsheet file, and file types that can clearly indicate information content may all be used, which is not limited in this specification.
In an embodiment, the information importing file may be uploaded to the server by the user by using a terminal. The user may be a creator of the information importing file, or the user may obtain the information importing file from another user, which is not limited in this specification. The information included in the information importing file may be sorted out by the creator based on collected data; or users respectively generate information corresponding to the users and send the information to the creator, and the creator combines the received information into an information importing file without a need to actively collect and sort each piece of information, which is not limited in this specification.
In an embodiment, the information importing file uploaded from the terminal to the server is an electronic document, and the electronic document may be generated from an entity document (for example, a paper document). For example, the terminal performs image acquisition and OCR on the entity document, so as to transform the entity document into the electronic document.
In an embodiment, the predefined verification condition may be used by the server to verify the information included in the information importing file. The verification condition may include a default condition provided by the foregoing application; or the verification condition may further include a condition customized by the user. For example, in an enterprise scenario, the user may be an enterprise administrator, and may customize a verification condition according to an actual requirement of the enterprise.
In an embodiment, the predefined verification condition may be used for verifying the information included in the information importing file from one or more dimensions. For example, the predefined verification condition may be used for verification from an information dimension, for example, whether a quantity of pieces of the information included in the information importing file is excessively small or excessively large. In another example, the predefined verification condition may be used for verification from a content dimension, for example, whether fields included in each piece of information are fields used as required, or whether the same field included in different information has duplicate values.
Step 304: The terminal receives an error comparison file returned by the server, where the error comparison file is generated by the server by marking information in the information importing file that does not pass the verification.
In an embodiment, compared with listing problems or errors to the user separately, by directly marking the information that does not pass the verification in the information importing file to generate the error comparison file in the technical solution of this specification, the information that does not pass the verification can be quickly located based on the error comparison file, thereby helping improve efficiency of finding and correcting errors.
In an embodiment, a display attribute of the information that does not pass the verification may be adjusted by the server, to distinguish the information that does not pass the verification from information that passes the verification. The display attribute may include at least one of the following: a background color, a border color, a character color, a font, a character size, and the like, which is not limited in this specification.
In an embodiment, when each piece of information included in the information importing file includes a plurality of fields, a problematic field in the information that does not pass the verification may be marked by the server, so that the user does not need to recognize a field or fields having problems in the information autonomously, and can accurately modify the problematic fields, thereby helping improve efficiency of finding and correcting errors.
In an embodiment, the server may actively push the error comparison file to the user; or the server may provide a download page for the error comparison file to the user, so that the user may download the error comparison file according to a requirement; or the server may provide an online viewing page or an online editing page for the error comparison file to the user, so that the user may view or modify the error comparison file online.
In an embodiment, in addition to marking the information that does not pass the verification, the error comparison file may further include error description information added by the server. The error description information may include each problem (a problem existing in the information importing file or all problems summarized in advance that may occur and not necessarily exist in the information importing file) existing in the information that does not pass the verification, a marking form (for example, which background color is used) corresponding to each problem, a solution to each problem, and the like. By adding the error description information to the error comparison file, especially in a case that the user downloads the error comparison file and performs offline modification, the user can conveniently learn about a problem and a solution to the problem, and does not need to query the server for the problem existing in the marked information or the solution to be used, thereby preventing the user from performing frequent switching between online and offline, and helping simplify user operations and improve operation efficiency of the user.
In an embodiment, the error comparison file may include the error description information separately added by the server. That is, the error description information and the originally included information are separated from each other. For example, when the information importing file is an Excel spreadsheet file, the originally included information may be in one sheet of the Excel spreadsheet file, and the error description information may be in another sheet of the Excel spreadsheet file. Alternatively, the error description information may be added by the server as a remark corresponding to the information that does not pass the verification or the problematic field thereof, so that in a process in which the user views the error comparison file, by triggering the information that does not pass the verification or the problematic field thereof, corresponding error description information (all the error description information or error description information for triggered information or field) may be temporarily shown, so that the user can quickly learn about a problem and a solution to the problem without repeatedly switching between a plurality of sheets.
In an embodiment, the terminal may receive and display statistical data fed back by the server. The statistical data may include at least one of the following: a quantity of pieces of information that is successfully imported into the system, a quantity of pieces of information in the imported information that does not pass the verification, a quantity of pieces of information that does not pass the verification and that is not imported, each problem existing in the information that does not pass the verification, a marking form corresponding to each problem, a solution to each problem, and the like, which is not limited in this specification. For example, in response to an operation of uploading the information importing file to the server by the user, the server may return an importing result page to the user, and display the statistical data in the importing result page for the user the view. The user may modify the information that does not pass the verification or the problematic field in the error comparison file by viewing the statistical data.
In an embodiment, the user may initiate an online viewing request to the server by using the terminal, and receive a display page of the error comparison file returned by the server. In addition, the terminal may inform the server of information selected in the display page by the user, and if the selected information does not pass the verification, update the display page according to page data returned by the server to include error description information for the selected information. Based on this embodiment, when the user selects information or a field included in the information in the display page, corresponding error description information may be automatically updated and displayed in the display page, so that the user quickly learns about a problem existing in the selected information or the field thereof, a solution, and the like.
In an embodiment, the terminal may initiate an online editing request to the server, for the server to edit information in the error comparison file according to the online editing request. For example, the user views the error comparison file in the display page based on the foregoing online viewing request, then the user may further initiate an online editing request for information or a field in the display page during viewing, so as to modify the related information or field. In another example, the user may view the error comparison file in another manner, for example, download the error comparison file for offline viewing; and the user may also initiate an online editing request to the server, to edit the information in the error comparison file.
In an embodiment, the terminal may initiate a correction invitation to an information provider corresponding to the information in the information importing file that does not pass the verification, for the information provider to perform correction. The information provider provides related information to the user, or provides related information to another user and the another user forwards the related information to the user. The related information is at least a part of information included in the information importing file. Because the information provider provides the related information at the early stage, the information provider is more familiar with correct content of the related information than the user, or learns about the correct content of the related information more conveniently than the user. Therefore, after the user sends the correction invitation to the information provider, the information provider may directly participate in a correction operation for the related information based on the correction invitation, which can not only improve a correction speed, but also can reduce a risk of erroneously conveying correction content by the user compared with informing the user of the correction content and performing correction by the user, thereby avoiding repeated modification for the related information.
In an embodiment, the correction invitation is used for instructing the information provider to initiate an online correction request to the server, for the information provider to perform correction by using an online correction interface provided by the server. For example, the information provider may initiate an online correction request to the server by triggering the correction invitation, and the server may return online correction page data to the information provider, so that an electronic device used by the information provider may display a corresponding online correction interface based on the online correction page data, and correct related information based on the online correction interface. In a process in which the information provider corrects the related information by using the online correction interface, the online correction interface displayed to the information provider may only include related information corresponding to the information provider, to prevent the information provider from accessing to other information irrelevant to the information provider, thereby avoiding a leakage of sensitive content included in the other information. The related information corresponding to the information provider may include: all information provided by the information provider, or a problematic field in the information provided by the information provider.
In an embodiment, the correction request is used for instructing the information provider to return corrected information corresponding to the information in the information importing file that does not pass the verification. Correspondingly, the terminal may edit the information importing file or the error comparison file according to the corrected information; or the terminal may initiate an online editing request to the server according to the corrected information, to perform editing by using an online editing interface provided by the server. In other words, in this case, the information provider does not directly perform a correct operation, but provides the corrected information to the user, for the user to edit and modify the related information based on the corrected information.
In an embodiment, for the information in the information importing file that does not pass the verification, especially for information with correct content and a wrong format, the server may automatically correct the information that does not pass the verification based on a corresponding verification rule (where the verification rule may be used for representing a correct format of the corresponding information), and return the corrected information (for example, add the corrected information to the error comparison file, or separately send the corrected information) to the user. Correspondingly, the terminal may receive the corrected information and display the corrected information to the user, and when the user confirms that the corrected information provided by the server is correct, the terminal may use the corrected information to replace corresponding information that does not pass the verification without manual modification by the user. If the user disagrees with the corrected information, the user may still actively perform modification.
In an embodiment, the server may recognize error-prone information included in the information importing file. For example, the server may collect statistics on information types going wrong in importing processes in history, to use a preset quantity (for example, the first three) of information types with cumulative error counts ranked in the top as error-prone information, or use information types with cumulative error counts reaching a preset quantity as error-prone information. In brief, even if the error-prone information passes verification, the server may still mark the error-prone information in the error comparison file. Correspondingly, when displaying the error comparison file to the user, the terminal may display the marked error-prone information, to remind the user to confirm the error-prone information twice or more.
In an embodiment, imported information in the information importing file may have a dynamic value. That is, a value of corresponding information may change dynamically. Therefore, after completing an importing operation for the corresponding information, the terminal may provide the latest value of the information to the server in real time or periodically, to ensure that the server can always maintain the latest value of the information. If an information source of the information is not the terminal, the server may alternatively obtain the latest value of the information from the information source of the information without information transfer by the terminal.
The technical solution of this specification is described below by using an application T as an example with reference to a personnel information maintenance scenario in an enterprise.
FIG. 4 is a schematic interaction diagram of performing information maintenance for enterprise personnel, according to an exemplary embodiment. As shown in FIG. 4 , the interaction process relates to a server, a terminal 1, and a terminal 2. The terminal 1 belongs to a user Ua, the terminal 2 belongs to a user Ub, the user Ua is an administrator in the enterprise, and the user Ub is an ordinary person in the enterprise. It is assumed that a program on a server side of the application T runs on the server, that is, the server is configured as a server end of the application T. A program on a terminal side of the application T runs on each of the terminal 1 and the terminal 2, an account of the user Ua logs in to the terminal 1, and an account of the user Ub logs in to the terminal 2, so that the terminal 1 is configured as a client 1 corresponding to the user Ua, and the terminal 2 is configured as a client 2 corresponding to the user Ub. An interaction process between the server, the terminal 1, and the terminal 2 may include the following steps:
Step 401: The terminal 1 generates an information importing file.
In an embodiment, the information importing file includes profile information of all personnel or newly-added personnel in the enterprise. The profile information included in the information importing file may be obtained from statistical arrangement for paper files by the user Ua, or each of the enterprise personnel provides profile information thereof to the user Ua. For example, the user Ub may provide profile information of the user Ub to the user Ua by using the terminal 2. Similarly, other enterprise personnel may also provide profile information thereof to the user Ua, and the user Ua may generate the information importing file by using the terminal 1.
In an embodiment, the profile information may be organized in a form of a spreadsheet file in the information importing file. For example, FIG. 5 is a display diagram of an information importing file, according to an exemplary embodiment. As shown in FIG. 5 , a display interface 50 may include a spreadsheet tab 510 named “employee data,” and the spreadsheet tab 510 includes profile information of all personnel in the enterprise. The spreadsheet tab 510 includes a plurality of headers, such as “User ID,” “Name,” “Mobile phone number,” “Job number,” “Identity card address,” and “Birth date,” and each piece of profile information includes values respectively corresponding to the headers. For example, in profile information corresponding to one of the enterprise personnel, a value of User ID is 132456416, a value of Name is Liu Yi, a value of Mobile phone number is 186****1234, a value of Job number is 000001, a value of Identity card address is Hangzhou, and a value of Birth date is 1985/11/12, which corresponds to the first piece of profile information in the spreadsheet tab 510. The situations of other profile information are similar, and are not listed herein one by one. It is to be noted that: in addition to the profile information of the enterprise personnel, the headers also belong to information included in the information importing file, and the headers are verified and modified in subsequent steps.
Step 402: The terminal 1 accesses and displays a management page for the server, and uploads the information importing file to the server based on the display page.
In an embodiment, the terminal 1 may access and display the management page by entering an accessing domain name of the server by using a browser. For example, FIG. 6 is a schematic diagram of a management page, according to an exemplary embodiment. As shown in FIG. 6 , a management page 60 displayed on the terminal 1 may include several levels of label options, where first-level label options include “Contacts,” “Workbench,” “Enterprise homepage,” “Enterprise data,” “Settings,” and the like. After the user Ua selects the label option “Contacts”, second-level label options such as “Internal contacts management,” “Department management,” “Smart personnel,” and “External contacts” can be invoked. Based on the label option “Smart personnel” selected by the user Ua, a corresponding label page 610 can be shown in the management page 60, so as to implement related functions. Similarly, when the user Ua selects another second-level label option, a corresponding label page can also be invoked. In other embodiments, more levels of label options may be used in the management page 60, or multi-level label options may not be necessarily used, which is not limited in this specification.
Based on the label page 610 shown in FIG. 6 , the user Ua may trigger a “Select file” button to select an information importing file locally or from a cloud storage space; or the user Ua may drag an information importing file into a dashed line box in the label page 610, so as to upload the information importing file to the server.
Step 403: The server reads information in the file and perform verification.
In an embodiment, the server maintains an information verification rule. The information verification rule is used for verifying the information included in the information importing file, to determine whether each piece of information can be successfully imported, and whether modification needs to be performed.
Step 404 a: The server imports information.
In an embodiment, according to a verification result for each piece of information in step 403, the server can distinguish information that passes the verification and information that does not pass the verification. The server may directly import the information that passes the verification; and for the information that does not pass the verification, if an information verification rule that the information fails to satisfy is a non-critical rule, the server may still import the corresponding information, provided that a problematic field is modified subsequently. However, if the information verification rule that the information fails to satisfy is a critical rule, the server refuses to import the corresponding information.
Step 404 b: The server marks information that does not pass the verification.
In an embodiment, for the information that does not pass the verification, the server may directly mark corresponding information in the information importing file, to intuitively show that the information does not pass the verification, and may even represent a problem existing in each piece of information through a difference between marking manners.
Step 405: The server returns an importing result page to the terminal 1, for the terminal 1 to display the importing result page.
In an embodiment, the importing result page includes an importing result of the server for the information importing file. For example, FIG. 7 is a schematic diagram of an importing result page, according to an exemplary embodiment. After an importing operation is completed, the label page 610 included in the management page 60 may be switched into an importing result page 620 shown in FIG. 7 , for the user Ua to quickly learn about the situation of the current importing.
As shown in FIG. 7 , the importing result page 620 may include summary information and detailed information. The summary information includes “Import profile information of 300 personnel: profile information of 283 personnel is successfully imported/there are problems in some content of 128 personnel, and profile information of 17 personnel fails to be imported,” which indicates that the information importing file includes profile information of 300 enterprise personnel, and there are problems in 128 pieces of profile information in the 283 pieces of imported profile information. That is, the 128 pieces of profile information do not satisfy the non-critical rule, the other 155 pieces of profile information satisfy all information verification rules, and 17 pieces of profile information do not satisfy the critical rule.
The detailed information is mainly used for providing a detailed description of the 128 pieces of profile information that have been imported but there are problems in some content and the 17 pieces of profile information that fail to be imported. The described content mainly includes two parts of content: problems and solutions. For example, one of reasons for the import failure is “Missing necessary information ‘Name’,” and a corresponding solution is “Please upload again after adding ‘Name’.” When the server marks the information that does not pass the verification by modifying a background color, the detailed information may further include a marking color correspondingly used for each problem. For example, the “Missing necessary information ‘Name’” is marked in red, and therefore may be correspondingly described as “Having been marked in red in the file” in the importing result page 620. Similarly, when a problem is “The header is not recognized,” a specific reason may be pointed out as “The header ‘Identity card address’ is not recognized.” A corresponding solution may be “Please modify to the specified header,” and “Having been marked in purple in the file” is marked.
The server may mark problematic profile information in the information importing file based on step 404 b, to generate a corresponding error comparison file. Based on the error comparison file, there are a plurality of manners of modifying related errors. A description is provided below separately with reference to steps 406 a to 411 a and steps 406 b to 409 b.
In steps 406 a to 411 a, offline modification may be performed for the error comparison file, and a specific process thereof is as follows:
Step 406 a: The terminal 1 downloads the error comparison file from the server.
In an embodiment, the importing result page 620 shown in FIG. 7 may include a “Download error sheet” button, so that the user Ua may download the error comparison file by triggering the “Download error sheet” button.
Step 407 a: The terminal 1 displays the error comparison file.
Step 408 a: The terminal 1 edits the error comparison file.
In an embodiment, the user Ua may perform an edition operation on the terminal 1, and the terminal 1 may edit information included in the error comparison file based on the edition operation, so as to modify the problematic information.
For example, FIG. 8 is a schematic diagram of displaying problematic information, according to an exemplary embodiment. As shown in FIG. 8 , the display interface 50 may include the foregoing spreadsheet tab 510 named “Employee data,” and problematic cells in the spreadsheet tab 510 have been marked by the server in different colors, so that the user can quickly locate the problematic cells, to perform targeted edition and modification.
The server may generate a spreadsheet tab 510 (first tab) and a spreadsheet tab 520 (second tab) of the error comparison file. The second tab may include a marking form corresponding to the information that does not pass the verification, a problem corresponding to the information that does not pass the verification, and a solution corresponding to the problem. The first tab may include the information of the uploaded file. Further, the server may generate prompt information that is automatically displayable under the first tab when the information that does not pass the verification is triggered. The prompt information may include the problem corresponding to the information that does not pass the verification and the solution corresponding to the problem. Thus, the generated first tab may include the prompt information.
The user Ua may make reference to the importing result page 620 shown in FIG. 7 to determine a problem corresponding to a color marked in the spreadsheet tab 510 and a manner to be used to resolve the corresponding problem. Alternatively, in addition to the spreadsheet tab 510, the display interface 50 may further include a spreadsheet tab 520 named “Error description” shown in FIG. 8 . The user Ua may implement a quick switching operation between the spreadsheet tab 510 and the spreadsheet tab 520. For example, FIG. 9 is a schematic diagram of displaying an error description offline, according to an exemplary embodiment. As shown in FIG. 9 , the spreadsheet tab 520 may show a problem corresponding to each background color, that is, “an import error description,” and a solution provided for each problem, so that even in a completely offline scenario, the user Ua may still quickly modify information in the spreadsheet tab 510 based on the spreadsheet tab 520, instead of having to view the importing result page 620 online.
Further, mutual correlation between the spreadsheet tab 510 corresponding to the employee data and the spreadsheet tab 520 corresponding to the error descriptions may be achieved, so that the user Ua may perform linked display on related error descriptions during an operation for the spreadsheet tab 510. For example, FIG. 10 is a schematic diagram of quickly displaying an error description in an offline environment, according to an exemplary embodiment. As shown in FIG. 10 , it is assumed that in a process in which the user Ua browses the spreadsheet tab 510, a cell included in the spreadsheet tab 510 is triggered (touched and selected, clicked by using a mouse, or the like). If there is a problem in content of the cell or information to which the content belongs, corresponding prompt information 511 may be shown. The prompt information 511 may include the corresponding problem and a solution to the problem. For example, when generating the error comparison file, in addition to performing background color modification on problematic cells in the spreadsheet tab 510 to implement marking, the server may further add remark information for the cells, where the remark content is the corresponding problems and solutions to the problems. In this way, the terminal 1 can implement the embodiment shown in FIG. 10 according to this method, and the user Ua does not need to perform repeated switching between the spreadsheet tab 510 and the spreadsheet tab 520.
Step 409 a: The terminal 1 sends the error comparison file to the terminal 2.
Step 410 a: The terminal 2 corrects error information according to a correct operation performed by the user Ua, and returns a corrected file to the terminal 1.
Step 411 a: The terminal 1 uploads the corrected file to the server.
In an embodiment, the user Ua can probably only edit and modify some information, and cannot correct all errors. Therefore, it is assumed that a piece of problematic information is provided by the user Ub, then the user Ua may send the error comparison file to the user Ub, so that the user Ub may correct the information provided by the user Ub. If the user Ua can complete edition and modification for all problems, steps 409 a and 410 a may be omitted, and the terminal 1 may directly upload a file having been corrected by the user Ua to the server. Similarly, the user Ua may completely perform no modification, and directly send the error comparison file to the user Ub, for the user Ub to perform correction. Alternative to the user Ub, the information included in the error comparison file may be from other users, then the user Ua may separately send the error comparison file to the users, for the users to perform correction. A process thereof is similar to steps 409 a and 410 a, which is not listed herein one by one.
In an embodiment, the user Ua may upload the corrected file to the server by triggering an “Upload corrected sheet” button included in the importing result page 620 shown in FIG. 7 , for the server to perform importing. There may still be information that does not pass the verification in the corrected file, then the foregoing steps may be repeated, until all files pass the verification and are successfully imported.
In steps 406 b to 409 b, online modification may be performed for the error comparison file, and a specific process thereof is as follows:
Step 406 b: The user Ua edits the error comparison file online by using the terminal 1.
In an embodiment, the user Ua may trigger, by using the terminal 1, an “Edit sheet online” button included in the importing result page 620 shown in FIG. 7 , to initiate an online editing request to the server. The server may return corresponding page data. The page data is used for displaying an online editing page 630 shown in FIG. 11 on the terminal 1. FIG. 11 is a schematic diagram of editing file content online, according to an exemplary embodiment.
The online editing page 630 shown in FIG. 11 includes displayed content similar to that of the spreadsheet tab 510 shown in FIG. 8 , so that the user Ua can clearly view the information included in the error comparison file, especially can quickly distinguish problematic cells (that is, fields or headers included in the information) based on a background color difference. The user Ua may directly edit the content included in the online editing page 630, for example, modify a value of a cell, add content to an empty cell, or delete an existing cell.
FIG. 12 is a schematic diagram of displaying error prompt information during online editing, according to an exemplary embodiment. In a process in which the user Ua performs online editing, when a cell included in the online editing page 630 is triggered, the server may update the online editing page 630, to display an error prompt interface 640 shown in FIG. 12 . The error prompt interface 640 may include a cause of an error and a solution. For example, when a selected cell is “Identity card address,” a cause of an error may be “The header name is not recognized,” and a solution may be “You may select a similar field from the existing fields of the system for matching, or add a new field.” In addition, all existing fields (for example, fields such as “Name,” “Mailbox,” and “Department” that belong to “Basic information,” and fields such as “Employee type” and “Employee state” that belong to “Job information”) in the system may be displayed to the user Ua for selection, and the user Ua may further search for an existing field by using a search box. Further, the original content “Identity card address” in the cell may be replaced with a field, for example, “Identity card location,” selected by the user Ua. If there are no similar fields expressing same meaning, the user Ua may add “Identity card address” as a new field in the system by using an “Add now” button included in the error prompt interface 640.
Similarly, FIG. 13 a is another schematic diagram of displaying error prompt information during online editing, according to an exemplary embodiment. As shown in FIG. 13 a , when a selected cell is “100****321,” a cause of an error may be “The format of the mobile phone number is incorrect,” and a solution may be “If it is a foreign mobile phone number, the country code needs to be added.”
The server may obtain an edition operation performed by the terminal 1. The obtaining operation may be, for example, real-time. The server may verify the edited content, and update the online editing page 630 according to a verification result, so that the user Ua may view an effect after the edition immediately: If the edited content pass the verification, a background color of the corresponding cell is restored to a default color; otherwise, the background color of the corresponding cell is maintained or adjusted according to a problem of the edited content.
Step 407 b: The terminal 1 initiates a correction request to the terminal 2.
Step 408 b: The user Ub corrects the error comparison file online by using the terminal 2.
Step 409 b: The terminal 1 requests the server for importing again.
In an embodiment, the online editing page 630 shown in FIG. 12 may include an “Invite other administrators to refine” button. The user Ua may send an invitation (that is, a correction request) to another administrator by triggering the button, so that the another administrator may perform online correction for the error comparison file based on the invitation. Reference may be made to the foregoing online editing process of the user Ua, and details are not described herein again.
In an embodiment, a cell selected in FIG. 12 is a header, that is, the cell corresponds to all users in the error comparison file, and a cell selected in FIG. 13 a corresponds to a user “Sun Qi.” Therefore, in the embodiment shown in FIG. 13 a , the error prompt interface 640 may show an “Invite ‘Sun Qi’ to refine” button, so that the user Ua may send an invitation (that is, a correction request) to the user “Sun Qi” by triggering the button. When the user “Sun Qi” is the user Ub, the process is equivalent to that the terminal 1 initiates a correction request to the terminal 2, then the user Ub may receive and view a corresponding invitation message 710 by using, for example, a communication session interface 70 (for example, the user Ua is “Whyte”) shown in FIG. 13 b . The invitation message 710 may be online editing invitation information, so that the user may enter an online correction interface by triggering the invitation message 710, to perform online correction for the error comparison file. Alternatively, the invitation message 710 may carry the error comparison file or information in the error comparison file that needs to be corrected by the user Ub, for the user Ub to complete correction on the terminal 2 and then return the corrected file or information to the user Ua. Information of the user “Sun Qi” may not necessarily be provided to the user Ua by the user “Sun Qi”. In this case, by triggering an “Invite other users to refine” button shown in the error prompt interface 640, the user Ua may independently select a user whom the user Ua would like to invite and initiate a correction request to the user.
Especially in a case that the user Ub is not an administrator, when the server cooperates with the terminal 2 to implement online correction on the error comparison file by the user Ub, the server may only provide information or a cell selected by the user Ua to the user Ub, to avoid providing other information (especially information of other users) to the user Ub, thereby avoiding a leakage of sensitive content.
In addition to importing employee data in an enterprise scenario, the information importing solution of this specification may also be applied to other scenarios, such as importing financial information in a financial scenario, importing asset information in an asset management scenario, and importing group information in a social group scenario, which is not limited in this specification. The social group scenario is used as an example. The technical solution of this specification can help a group leader determine an information missing situation through check of group information, and even automatically correct an existing error, and to help the group leader solve a problem. In addition, for situations such as missing information or incorrect information, the server can push prompt information in the group to instruct group members to complete or correct the corresponding information, and to help the group leader complete an importing operation on related information.
FIG. 14 is a schematic structural diagram of a device, according to an exemplary embodiment. Referring to FIG. 14 , at a hardware level, the device includes a processor 1402, an internal bus 1404, a network interface 1406, a memory 1408, and a non-volatile memory 1410, and may further include hardware required for other services. The processor 1402 reads a corresponding computer program from the non-volatile memory 1410 into the memory 1408 and then executes the computer program, to form an information importing apparatus at a logic level. In addition to a software implementation, one or more embodiments of this specification do not exclude other implementations, for example, logic devices or a software-hardware combination. That is, execution entities of the following processing procedures are not limited to logic units and may alternatively be hardware or logic devices.
Referring to FIG. 15 , in a software implementation, the information importing apparatus may include: a file receiving unit 1501, configured to enable a server to receive an information importing file uploaded by a user, where the information importing file includes information to be imported into a system; a verification unit 1502, configured to enable the server to verify the information included in the information importing file; a marking unit 1503, configured to enable the server to mark information in the information importing file that does not pass the verification, so as to generate an error comparison file; and a file returning unit 1504, configured to enable the server to return the error comparison file to the user.
Optionally, the information importing file includes a plurality of pieces of information in the same format to be imported into the system in batches.
Optionally, the marking unit 1503 is configured to: enable the server to adjust a display attribute of the information that does not pass the verification, to distinguish the information that does not pass the verification from information that passes the verification.
Optionally, the display attribute includes at least one of the following: a background color, a border color, a character color, a font, and a character size.
Optionally, the marking unit 1503 is configured to: enable the server to mark, when each piece of information included in the information importing file includes a plurality of fields, a problematic field in the information that does not pass the verification.
Optionally, the apparatus further includes: an addition unit 1505, configured to enable the server to add error description information to the error comparison file, where the error description information includes each problem existing in the information that does not pass the verification, a marking form corresponding to each problem, and a solution to each problem.
Optionally, the apparatus further includes: a feedback unit 1506, configured to enable the server to feed statistical data back to the user, where the statistical data includes at least one of the following: a quantity of pieces of information that is successfully imported into the system, a quantity of pieces of information in the imported information that does not pass the verification, a quantity of pieces of information that does not pass the verification and that is not imported, each problem existing in the information that does not pass the verification, a marking form corresponding to each problem, and a solution to each problem.
Optionally, the apparatus further includes: a page returning unit 1507, configured to enable the server to receive an online viewing request initiated by the user, and return a display page of the error comparison file to the user; a determining unit 1508, configured to enable the server to determine information selected in the display page by the user; and an update unit 1509, configured to, if the selected information does not pass the verification, enable the server to update the display page to include error description information for the selected information.
Optionally, the apparatus further includes: an editing request receiving unit 1510, configured to enable the server to receive an online editing request initiated by the user; and an editing unit 1511, configured to enable the server to edit information in the error comparison file according to the online editing request.
Optionally, the apparatus further includes: a correction request receiving unit 1512, configured to enable the server to receive an online correction request initiated by an information provider, where the online correction request is initiated by the information provider based on a correction invitation sent by the user; and a providing unit 1513, configured to enable the server to provide an online correction interface to the information provider, where the online correction interface includes related information in the information importing file that corresponds to the information provider, for the information provider to perform correction.
Optionally, the online correction interface only includes the related information corresponding to the information provider, where the related information corresponding to the information provider includes: all information provided by the information provider, or a problematic field in the information provided by the information provider.
FIG. 16 is a schematic structural diagram of a device, according to an exemplary embodiment. Referring to FIG. 16 , at a hardware level, the device includes a processor 1602, an internal bus 1604, a network interface 1606, a memory 1608, and a non-volatile memory 1610, and may further include hardware required for other services. The processor 1602 reads a corresponding computer program from the non-volatile memory 1610 into the memory 1608 and then executes the computer program, to form an information importing apparatus at a logic level. In addition to a software implementation, one or more embodiments of this specification do not exclude other implementations, for example, logic devices or a software-hardware combination. That is, execution entities of the following processing procedures are not limited to logic units and may alternatively be hardware or logic devices.
Referring to FIG. 17 , in a software implementation, the information importing apparatus may include: an uploading unit 1701, configured to enable a terminal to upload an information importing file to a server, for the server to verify information included in the information importing file and import the information into a system; and a receiving unit 1702, configured to enable the terminal to receive an error comparison file returned by the server, where the error comparison file is generated by the server by marking information in the information importing file that does not pass the verification.
Optionally, the apparatus further includes: an invitation unit 1703, configured to enable the terminal to initiate a correction invitation to an information provider corresponding to the information in the information importing file that does not pass the verification, for the information provider to perform correction.
Optionally, the correction invitation is used for instructing the information provider to initiate an online correction request to the server, for the information provider to perform correction by using an online correction interface provided by the server; or the correction request is used for instructing the information provider to return corrected information corresponding to the information in the information importing file that does not pass the verification; and the apparatus further includes: an editing unit 1704, configured to: enable the terminal to edit the information importing file or the error comparison file according to the corrected information; or enable the terminal to initiate an online editing request to the server according to the corrected information, to perform editing by using an online editing interface provided by the server.
The system, the apparatus, the module or the unit described in the foregoing embodiments may be implemented by a computer chip or an entity, or implemented by a product having a certain function. A typical implementation device is a computer. A specific form of the computer may be a PC, a laptop computer, a cellular phone, a camera phone, a smartphone, a personal digital assistant, a media player, a navigation device, an email transceiver device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.
In a typical configuration, the computer includes one or more processors (such as CPUs), an input/output interface, a network interface, and a memory.
The memory may include a form such as a volatile memory, a random-access memory (RAM) and/or a non-volatile memory such as a read-only memory (ROM) or a flash RAM in a computer-readable medium. The memory is an example of the computer-readable medium.
The computer-readable medium includes a non-volatile medium and a volatile medium, a removable medium and a non-removable medium, which may implement storage of information by using any method or technology. The information may be a computer-readable instruction, a data structure, a program module, or other data. Examples of a storage medium of a computer include, but are not limited to, a phase-change memory (PRAM), a static random-access memory (SRAM), a dynamic random-access memory (DRAM), a RAM of another type, a ROM, an electrically erasable programmable read-only memory (EEPROM), a flash memory or another memory technology, a compact disc read-only memory (CD-ROM), a digital versatile disc (DVD) or another optical storage device, a cassette tape, a magnetic disk storage, a quantum memory, a graphene-based storage medium or another magnetic storage device, or any other non-transmission medium, which may be configured to store information accessible by a computing device. According to limitations of this specification, the computer-readable medium does not include transitory computer-readable media, such as a modulated data signal and a modulated carrier.
It should be further noted that the terms “include,” “comprise,” or any variants thereof are intended to cover a non-exclusive inclusion. Therefore, a process, method, article, or device that includes a series of elements not only includes such elements, but also includes other elements not specified expressly, or may include inherent elements of the process, method, article, or device. Without further limitation, the element defined by a phrase “include a/an . . . ” does not exclude other same elements in the process, method, article or device which include the element.
Specific embodiments of this specification are described above. Other embodiments fall within the scope of the appended claims. In some cases, the actions or steps recorded in the claims may be performed in sequences different from those in the embodiments and an expected result may still be achieved. In addition, the process depicted in the accompanying drawings is not necessarily performed in the shown specific order or successively to achieve an expected result. In some implementations, multitasking and parallel processing may be feasible or beneficial.
The terms used in one or more embodiments of this specification are merely used to describe the specific embodiments but are not intended to limit one or more embodiments of this specification. The “a” and “the” in a singular form used in one or more embodiments of this specification and the appended claims are also intended to include a plural form, unless other meanings are clearly indicated in the context. It should be further understood that the term “and/or” used herein indicates and includes any or all possible combinations of one or more associated listed items.
It should be understood that although the terms “first,” “second,” “third,” and the like may be used to describe various information in one or more embodiments of this specification, such information should not be limited to these terms. These terms are merely used to distinguish between information of the same type. For example, without departing from the scope of one or more embodiments of this specification, first information may also be referred to as second information. Similarly, second information may also be referred to as first information. According to the context, the word “if” used herein may be interpreted as “during” or “when” or “in response to determining.”
The foregoing descriptions are merely exemplary embodiments of one or more embodiments of this specification, but are not intended to limit the one or more embodiments of this specification. Any modification, equivalent replacement, or improvement made within the spirit and principle of one or more embodiments of this specification shall fall within the protection scope of the one or more embodiments of this specification.

Claims (20)

What is claimed is:
1. An information importing method, comprising:
receiving, by a server, an information importing file uploaded by a user, wherein the information importing file comprises information for importing into a system;
verifying, by the server, the information included in the information importing file;
marking, by the server, a field in the information importing file that does not pass the verification with a marking form, so as to generate a first tab of an error comparison file;
generating, by the server, a second tab of the error comparison file, wherein the second tab comprises the marking form corresponding to the field that does not pass the verification, a problem corresponding to the field that does not pass the verification, and a solution corresponding to the problem;
detecting, by the server, the marked field in the second tab of the error comparison file is triggered in response to an action by the user;
displaying, by the server, an error prompt interface corresponding to the marked field triggered by the user;
receiving, by the server, updated content for the marked field as a result of a correction operation performed on the error prompt interface;
automatically verifying, by the server in real-time, the updated content; and
in response to the updated content passing the verification, automatically restoring the marked field to a default form.
2. The method according to claim 1, wherein the information importing file comprises a plurality of pieces of information in a same format to be imported into the system in batches.
3. The method according to claim 1, wherein the marking, by the server, information in the information importing file that does not pass the verification comprises:
adjusting, by the server, a display attribute of the information that does not pass the verification, to distinguish the information that does not pass the verification from information that passes the verification.
4. The method according to claim 1, further comprising generating, by the server, prompt information that is automatically displayable under the first tab when the information that does not pass the verification is triggered, wherein the prompt information comprises the problem corresponding to the information that does not pass the verification and the solution corresponding to the problem.
5. The method according to claim 1, wherein the marking, by the server, information in the information importing file that does not pass the verification comprises:
when a piece of information included in the information importing file comprises a plurality of fields, marking, by the server, a problematic field in the information that does not pass the verification.
6. The method according to claim 1, further comprising:
adding, by the server, error description information to the error comparison file, wherein the error description information comprises each problem existing in the information that does not pass the verification, a marking form corresponding to each problem, and a solution to each problem.
7. The method according to claim 1, further comprising:
feeding, by the server, statistical data back to the user, wherein the statistical data comprises at least one of the following: a quantity of pieces of information that is successfully imported into the system, a quantity of pieces of information in the imported information that does not pass the verification, a quantity of pieces of information that does not pass the verification and that is not imported, each problem existing in the information that does not pass the verification, a marking form corresponding to each problem, and a solution to each problem.
8. The method according to claim 1, further comprising:
receiving, by the server, an online viewing request initiated by the user, and returning a display page of the error comparison file to the user;
determining, by the server, information selected in the display page by the user; and
if the selected information does not pass the verification, updating, by the server, the display page to comprise error description information for the selected information.
9. The method according to claim 1, further comprising:
receiving, by the server, an online editing request initiated by the user; and
editing, by the server, information in the error comparison file according to the online editing request.
10. The method according to claim 1, further comprising:
receiving, by the server, an online correction request initiated by an information provider, wherein the online correction request is initiated by the information provider based on a correction invitation sent by the user; and
providing, by the server, an online correction interface to the information provider, wherein the online correction interface comprises related information in the information importing file that corresponds to the information provider, for the information provider to perform correction.
11. The method according to claim 10, wherein the online correction interface only comprises the related information corresponding to the information provider, wherein
the related information corresponding to the information provider comprises: all information provided by the information provider, or a problematic field in the information provided by the information provider.
12. The method according to claim 1, further comprising:
uploading, by a terminal, the information importing file to the server, for the server to verify information included in the information importing file and import the information into the system; and
receiving, by the terminal, the error comparison file returned by the server.
13. The method according to claim 12, further comprising:
initiating, by the terminal, a correction invitation to an information provider corresponding to the information in the information importing file that does not pass the verification, for the information provider to perform correction.
14. The method according to claim 13, wherein:
the correction invitation is used for instructing the information provider to initiate an online correction request to the server, for the information provider to perform correction by using an online correction interface provided by the server; or
the online correction request is used for instructing the information provider to return corrected information corresponding to the information in the information importing file that does not pass the verification; and the method further comprises: editing, by the terminal, the information importing file or the error comparison file according to the corrected information; or initiating, by the terminal, an online editing request to the server according to the corrected information, to perform editing by using an online editing interface provided by the server.
15. One or more non-transitory computer-readable storage media storing instructions executable by one or more processors, wherein execution of the instructions causes the one or more processors to perform operations comprising:
receiving an information importing file uploaded by a user, wherein the information importing file comprises information for importing into a system;
verifying the information included in the information importing file;
marking a field in the information importing file that does not pass the verification with a marking form, so as to generate a first tab of an error comparison file, so as to generate a first tab of an error comparison file;
generating a second tab of the error comparison file, wherein the second tab comprises the marking form corresponding to the field that does not pass the verification, a problem corresponding to the field that does not pass the verification, and a solution corresponding to the problem;
detecting the marked field in the second tab of the error comparison file is triggered in response to an action by the user;
displaying an error prompt interface corresponding to the marked field triggered by the user;
receiving updated content for the marked field as a result of a correction operation performed on the error prompt interface;
automatically verifying, in real-time, the updated content; and
in response to the updated content passing the verification, automatically restoring the marked field to a default form.
16. The one or more non-transitory computer-readable storage media according to claim 15, wherein the information importing file comprises a plurality of pieces of information in a same format to be imported into the system in batches.
17. The one or more non-transitory computer-readable storage media according to claim 15, wherein the marking the field in the information importing file that does not pass the verification comprises:
adjusting a display attribute of the information that does not pass the verification, to distinguish the information that does not pass the verification from information that passes the verification.
18. The one or more non-transitory computer-readable storage media according to claim 17, wherein the display attribute comprises at least one of the following: a background color, a border color, a character color, a font, and a character size.
19. The one or more non-transitory computer-readable storage media according to claim 15, wherein the marking the field in the information importing file that does not pass the verification comprises:
when a piece of information included in the information importing file comprises a plurality of fields, marking a problematic field in the information that does not pass the verification.
20. A system comprising one or more processors and one or more non-transitory computer-readable memories coupled to the one or more processors and configured with instructions executable by the one or more processors to cause the system to perform operations comprising:
receiving an information importing file uploaded by a user, wherein the information importing file comprises information for importing into a system;
verifying the information included in the information importing file;
marking a field in the information importing file that does not pass the verification with a marking form, so as to generate a first tab of an error comparison file, so as to generate a first tab of an error comparison file;
generating a second tab of the error comparison file, wherein the second tab comprises the marking form corresponding to the field that does not pass the verification, a problem corresponding to the field that does not pass the verification, and a solution corresponding to the problem;
detecting the marked field in the second tab of the error comparison file is triggered in response to an action by the user;
displaying an error prompt interface corresponding to the marked field triggered by the user;
receiving updated content for the marked field as a result of a correction operation performed on the error prompt interface;
automatically verifying, in real-time, the updated content; and
in response to the updated content passing the verification, automatically restoring the marked field to a default form.
US17/704,708 2019-09-27 2022-03-25 Information importing method and apparatus Active 2040-12-20 US12001388B2 (en)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
CN201910922815.8A CN112579589B (en) 2019-09-27 2019-09-27 Information importing method and device
CN201910922815.8 2019-09-27
PCT/CN2020/116695 WO2021057695A1 (en) 2019-09-27 2020-09-22 Information importing method and apparatus

Related Parent Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2020/116695 Continuation WO2021057695A1 (en) 2019-09-27 2020-09-22 Information importing method and apparatus

Publications (2)

Publication Number Publication Date
US20220214996A1 US20220214996A1 (en) 2022-07-07
US12001388B2 true US12001388B2 (en) 2024-06-04

Family

ID=75109723

Family Applications (1)

Application Number Title Priority Date Filing Date
US17/704,708 Active 2040-12-20 US12001388B2 (en) 2019-09-27 2022-03-25 Information importing method and apparatus

Country Status (3)

Country Link
US (1) US12001388B2 (en)
CN (2) CN118193521A (en)
WO (1) WO2021057695A1 (en)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US12025973B2 (en) * 2021-09-20 2024-07-02 Rockwell Automation Technologies, Inc. Industrial automation controller project online/offline state separation
CN116137638A (en) * 2021-11-17 2023-05-19 腾讯科技(深圳)有限公司 Method, device, equipment and storage medium for batch importing contacts into address book
CN114626950A (en) * 2022-03-22 2022-06-14 深圳壹账通智能科技有限公司 Insurance claim settlement information input method and device, computer equipment and storage medium
US20230360030A1 (en) * 2022-05-09 2023-11-09 Fidelity Information Services, Llc Systems and methods for processing a batch payment in real-time payment network

Citations (30)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040024619A1 (en) * 2002-05-15 2004-02-05 Dibella Joseph Patrick System and method for facilitating the determination of property and casualty insurance rates
CN102081664A (en) 2011-01-20 2011-06-01 深圳市科陆电子科技股份有限公司 Method for processing information data in automatic system of transformer substation
US8392419B2 (en) 2008-05-19 2013-03-05 Roche Diagnostics International Ag Computer research tool for the organization, visualization and analysis of metabolic-related clinical data and method thereof
US8606624B2 (en) 2011-04-01 2013-12-10 Caterpillar Inc. Risk reports for product quality planning and management
US8660876B2 (en) 2003-06-30 2014-02-25 Idocuments, Llc Document management system
US20140181021A1 (en) * 2012-12-21 2014-06-26 Zetta, Inc. Back up using locally distributed change detection
US20150317290A1 (en) 2005-08-31 2015-11-05 Zahid N. Ahmed System and method to transform results of client requests using client uploaded presentation formats
CN105094852A (en) 2015-09-07 2015-11-25 浪潮软件集团有限公司 Tool for importing and exporting data EXCEL
US20150346938A1 (en) * 2013-02-04 2015-12-03 Visible Spectrum, Inc. Variable Data Video
US9208474B2 (en) 2008-10-15 2015-12-08 Adp, Llc Performance driven compensation for enterprise-level human capital management
US20160019628A1 (en) 2014-07-16 2016-01-21 My Virtual Mall, LLC Method, system, and article for facilitating online commerce
US20160171434A1 (en) 2014-11-21 2016-06-16 Deliveright Logistics, Inc. Delivery management systems and methods for zero-inventory distribution
US20160350721A1 (en) 2013-08-22 2016-12-01 Core De Vie, Llc Behaviorally informed scheduling systems and methods
US9553860B2 (en) 2012-04-27 2017-01-24 Intralinks, Inc. Email effectivity facility in a networked secure collaborative exchange environment
US9613190B2 (en) 2014-04-23 2017-04-04 Intralinks, Inc. Systems and methods of secure data exchange
US20170116373A1 (en) 2014-03-21 2017-04-27 Leonard Ginsburg Data Command Center Visual Display System
US20170147956A1 (en) 2013-05-09 2017-05-25 Optymyze PTE, Ltd. Method and system for configuring and processing requests through workflow applications
US20170185754A1 (en) 2014-07-08 2017-06-29 Hewlett-Packard Development Company, L.P. Composite document access
US20170223068A1 (en) * 2016-02-01 2017-08-03 Level 3 Communications, Llc Bulk job provisioning system
US9811576B2 (en) 2007-03-02 2017-11-07 Oath Inc. Digital asset management system (DAMS)
US20180157468A1 (en) 2016-12-03 2018-06-07 Thomas STACHURA Spreadsheet-Based Software Application Development
CN108153550A (en) 2017-06-16 2018-06-12 广东网金数据服务有限公司 A kind of Excel data lead-in methods, device and user terminal
WO2018111588A1 (en) 2016-12-14 2018-06-21 Rfpio, Inc. Method to automatically convert proposal documents
US10169311B2 (en) 2011-07-12 2019-01-01 Inkling Systems, Inc. Workflow system and method for creating, distributing and publishing content
CN109189849A (en) 2018-10-16 2019-01-11 浪潮天元通信信息系统有限公司 A kind of standardization, the data entry method of procedure and system
CN109408783A (en) 2018-09-06 2019-03-01 广州城市信息研究所有限公司 Electronic document online editing method and system
CN109710237A (en) 2019-01-10 2019-05-03 厦门商集网络科技有限责任公司 A kind of online modification method of calibration and equipment based on customized two-dimentional report
US20190243911A1 (en) * 2018-02-05 2019-08-08 Commvault Systems, Inc. On-demand metadata extraction and re-indexing of clinical image data using configurable schema
CN110196971A (en) 2019-04-23 2019-09-03 平安科技(深圳)有限公司 Online document edit methods, device, terminal device and storage medium
US11470143B2 (en) * 2020-01-23 2022-10-11 The Toronto-Dominion Bank Systems and methods for real-time transfer failure detection and notification

Patent Citations (30)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040024619A1 (en) * 2002-05-15 2004-02-05 Dibella Joseph Patrick System and method for facilitating the determination of property and casualty insurance rates
US8660876B2 (en) 2003-06-30 2014-02-25 Idocuments, Llc Document management system
US20150317290A1 (en) 2005-08-31 2015-11-05 Zahid N. Ahmed System and method to transform results of client requests using client uploaded presentation formats
US9811576B2 (en) 2007-03-02 2017-11-07 Oath Inc. Digital asset management system (DAMS)
US8392419B2 (en) 2008-05-19 2013-03-05 Roche Diagnostics International Ag Computer research tool for the organization, visualization and analysis of metabolic-related clinical data and method thereof
US9208474B2 (en) 2008-10-15 2015-12-08 Adp, Llc Performance driven compensation for enterprise-level human capital management
CN102081664A (en) 2011-01-20 2011-06-01 深圳市科陆电子科技股份有限公司 Method for processing information data in automatic system of transformer substation
US8606624B2 (en) 2011-04-01 2013-12-10 Caterpillar Inc. Risk reports for product quality planning and management
US10169311B2 (en) 2011-07-12 2019-01-01 Inkling Systems, Inc. Workflow system and method for creating, distributing and publishing content
US9553860B2 (en) 2012-04-27 2017-01-24 Intralinks, Inc. Email effectivity facility in a networked secure collaborative exchange environment
US20140181021A1 (en) * 2012-12-21 2014-06-26 Zetta, Inc. Back up using locally distributed change detection
US20150346938A1 (en) * 2013-02-04 2015-12-03 Visible Spectrum, Inc. Variable Data Video
US20170147956A1 (en) 2013-05-09 2017-05-25 Optymyze PTE, Ltd. Method and system for configuring and processing requests through workflow applications
US20160350721A1 (en) 2013-08-22 2016-12-01 Core De Vie, Llc Behaviorally informed scheduling systems and methods
US20170116373A1 (en) 2014-03-21 2017-04-27 Leonard Ginsburg Data Command Center Visual Display System
US9613190B2 (en) 2014-04-23 2017-04-04 Intralinks, Inc. Systems and methods of secure data exchange
US20170185754A1 (en) 2014-07-08 2017-06-29 Hewlett-Packard Development Company, L.P. Composite document access
US20160019628A1 (en) 2014-07-16 2016-01-21 My Virtual Mall, LLC Method, system, and article for facilitating online commerce
US20160171434A1 (en) 2014-11-21 2016-06-16 Deliveright Logistics, Inc. Delivery management systems and methods for zero-inventory distribution
CN105094852A (en) 2015-09-07 2015-11-25 浪潮软件集团有限公司 Tool for importing and exporting data EXCEL
US20170223068A1 (en) * 2016-02-01 2017-08-03 Level 3 Communications, Llc Bulk job provisioning system
US20180157468A1 (en) 2016-12-03 2018-06-07 Thomas STACHURA Spreadsheet-Based Software Application Development
WO2018111588A1 (en) 2016-12-14 2018-06-21 Rfpio, Inc. Method to automatically convert proposal documents
CN108153550A (en) 2017-06-16 2018-06-12 广东网金数据服务有限公司 A kind of Excel data lead-in methods, device and user terminal
US20190243911A1 (en) * 2018-02-05 2019-08-08 Commvault Systems, Inc. On-demand metadata extraction and re-indexing of clinical image data using configurable schema
CN109408783A (en) 2018-09-06 2019-03-01 广州城市信息研究所有限公司 Electronic document online editing method and system
CN109189849A (en) 2018-10-16 2019-01-11 浪潮天元通信信息系统有限公司 A kind of standardization, the data entry method of procedure and system
CN109710237A (en) 2019-01-10 2019-05-03 厦门商集网络科技有限责任公司 A kind of online modification method of calibration and equipment based on customized two-dimentional report
CN110196971A (en) 2019-04-23 2019-09-03 平安科技(深圳)有限公司 Online document edit methods, device, terminal device and storage medium
US11470143B2 (en) * 2020-01-23 2022-10-11 The Toronto-Dominion Bank Systems and methods for real-time transfer failure detection and notification

Non-Patent Citations (6)

* Cited by examiner, † Cited by third party
Title
First Search Report for Chinese Application No. 201910922815.8 dated Mar. 6, 2023.
International Preliminary Report on Patentability Chapter I for PCT Application No. PCT/CN2020/116695 dated Apr. 7, 2022.
Ramey et al., "High-Tech Publications Need Old-Fashioned Editing," IEEE IPCC 2000 / ACM 18th International Conference on Systems Documentation, Sep. 24, 2000.
Search Report for Chinese Application No. 201910922815.8 mailed on Jan. 8, 2024.
Written Opinion of the International Searching Authority and International Search Report for PCT Application No. PCT/CN2020/116695 dated Dec. 2, 2020.
Xu et al., "Design and Implementation of Online Editing in Jangsu Oil Field," Science Technology and Engineering, vol. 9, No. 14, Jul. 2009, abstract provided.

Also Published As

Publication number Publication date
US20220214996A1 (en) 2022-07-07
CN112579589A (en) 2021-03-30
CN112579589B (en) 2024-02-27
CN118193521A (en) 2024-06-14
WO2021057695A1 (en) 2021-04-01

Similar Documents

Publication Publication Date Title
US12001388B2 (en) Information importing method and apparatus
US10437428B2 (en) Scatter copy supporting partial paste functionality
US10693971B2 (en) Identifying the best suitable application to open a file shared via a link
US20170250930A1 (en) Interactive content recommendation personalization assistant
US20150100509A1 (en) Systems and methods for enhancing user engagement
US20190108486A1 (en) System and method for intelligent and automatic electronic communication support and routing
US20130067039A1 (en) System and method of suggesting supplemental contact data to a computing device
US20130339870A1 (en) Software localization through user contribution
US8620913B2 (en) Information management through a single application
US12001801B2 (en) Question answering using dynamic question-answer database
US20210326528A1 (en) Language analysis platform based on target recipient profile data
CN112016290A (en) Automatic document typesetting method, device, equipment and storage medium
US20230325587A1 (en) Table column operations for spreadsheets
US20250069428A1 (en) Enabling Electronic Loan Documents
US11997168B2 (en) Connecting devices for communication sessions
CN115185573A (en) Configuration method, apparatus, computer equipment and storage medium for application configuration information
CN119312792A (en) Text annotation method, system and computer device
US20240414151A1 (en) Classifying form and inputs for password autofill
US20250208883A1 (en) Task association method and apparatus, and electronic device
HK40045090A (en) Information import method and device
US11301458B2 (en) Automated content generation
TW202113619A (en) Information importing method and apparatus verifying, by the server, the information included in an information import document
US12353825B2 (en) Updating autofill templates for password autofill
US20200167421A1 (en) Self-learning and adaptable mechanism for tagging documents
US12008601B2 (en) Methods and systems for generating and managing electronic communication campaigns

Legal Events

Date Code Title Description
AS Assignment

Owner name: DINGTALK HOLDING (CAYMAN) LIMITED, CAYMAN ISLANDS

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:GUO, JIA;ZHANG, YUAN;XU, KE;SIGNING DATES FROM 20220125 TO 20220215;REEL/FRAME:059405/0857

FEPP Fee payment procedure

Free format text: ENTITY STATUS SET TO UNDISCOUNTED (ORIGINAL EVENT CODE: BIG.); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY

STPP Information on status: patent application and granting procedure in general

Free format text: DOCKETED NEW CASE - READY FOR EXAMINATION

STPP Information on status: patent application and granting procedure in general

Free format text: NON FINAL ACTION MAILED

STPP Information on status: patent application and granting procedure in general

Free format text: RESPONSE TO NON-FINAL OFFICE ACTION ENTERED AND FORWARDED TO EXAMINER

STPP Information on status: patent application and granting procedure in general

Free format text: NOTICE OF ALLOWANCE MAILED -- APPLICATION RECEIVED IN OFFICE OF PUBLICATIONS

STPP Information on status: patent application and granting procedure in general

Free format text: AWAITING TC RESP., ISSUE FEE NOT PAID

STPP Information on status: patent application and granting procedure in general

Free format text: NOTICE OF ALLOWANCE MAILED -- APPLICATION RECEIVED IN OFFICE OF PUBLICATIONS

STPP Information on status: patent application and granting procedure in general

Free format text: PUBLICATIONS -- ISSUE FEE PAYMENT VERIFIED

STCF Information on status: patent grant

Free format text: PATENTED CASE