CN116306537A

CN116306537A - Data acquisition method, device, equipment and storage medium

Info

Publication number: CN116306537A
Application number: CN202310147640.4A
Authority: CN
Inventors: 敖宇钢; 杨波; 邱炜远; 张大鹏; 郑翀; 江张鹏; 秦艺文; 陈鹏
Original assignee: Peoples Insurance Company of China
Current assignee: Peoples Insurance Company of China
Priority date: 2023-02-20
Filing date: 2023-02-20
Publication date: 2023-06-23

Abstract

The application discloses a data acquisition method, which is used for solving the problems that when data acquisition is carried out based on an electronic form, the development process of a custom form is complex, the electronic form is single in structure, and the electronic form cannot be flexibly modified according to business requirements. The method comprises the following steps: responding to a template downloading instruction uploaded by a data entry side, and searching a first JSON character string corresponding to the template downloading instruction in a template library; generating a spreadsheet template according to the first JSON character string, and generating the spreadsheet template to the data entry party; receiving an electronic form uploaded by the data entry party after editing the electronic form template, and checking the electronic form; after the verification of the electronic form is passed, analyzing the electronic form to obtain a second JSON character string corresponding to the electronic form; and storing the second JSON character string according to the second identifier corresponding to the electronic form, so as to complete data acquisition.

Description

Data acquisition method, device, equipment and storage medium

Technical Field

The present disclosure relates to the field of computer technologies, and in particular, to a data acquisition method, apparatus, device, and storage medium.

Background

With the continuous development of computer technology, electronic forms represented by Excel gradually replace traditional paper registration forms, and are widely applied to enterprise business operations.

Enterprises often require that the electronic forms can take on different formats for different business needs. In the existing electronic form software development, a fixed-format electronic form template is usually customized and developed according to service requirements, and is stored in a specific system code package in a background mode, and then a developer designs the table structure of the Excel template. In a JAVA environment, the operation on Excel related files is generally implemented by parsing and loading a concise version of fuzzy implementation class (Poor Obfuscation Implementation, POI).

The existing mode has large workload and cannot be operated and completed by users independently, and the existing electronic form template is set up in a format when being developed, and cannot be modified and customized according to service changes and requirements later, and the structure is dead and limited because the codes are designed and designed only for a form with a certain fixed format. By adopting the existing electronic form development method, if the electronic form template is required to be modified and adjusted according to the actual service requirement, a developer is required to perform function development and database transformation, the code universality is poor, and the automation degree is low.

Therefore, the existing scheme for acquiring data by using the electronic form is complex in process of developing the custom form, high in skill requirement on a user, single in structure of the developed electronic form, high in modification difficulty, and extremely poor in universality of the developed electronic form.

Therefore, there is a need for a method for efficiently developing a spreadsheet template and collecting data using a spreadsheet.

Disclosure of Invention

The embodiment of the application provides a data acquisition method, which is used for solving the problems that when data acquisition is carried out based on an electronic form, the development process of a custom form is complex, the developed electronic form is single in structure and cannot be flexibly modified according to service requirements, so that the universality of the developed electronic form is extremely poor, and the data acquisition efficiency is low.

The embodiment of the application also provides a data acquisition device, which is used for solving the problems that when data acquisition is carried out based on the electronic form, the development process of the custom form is complex, the developed electronic form is single in structure and cannot be flexibly modified according to service requirements, so that the universality of the developed electronic form is extremely poor, and the data acquisition efficiency is low.

The embodiment of the application also provides data acquisition equipment, which is used for solving the problems that when data acquisition is carried out based on the electronic form, the development process of the custom form is complex, the developed electronic form is single in structure and cannot be flexibly modified according to service requirements, so that the universality of the developed electronic form is extremely poor, and the data acquisition efficiency is low.

The embodiment of the application also provides a computer readable storage medium, which is used for solving the problems that when data acquisition is performed based on the electronic form, the development process of the custom form is complex, the developed electronic form is single in structure and cannot be flexibly modified according to service requirements, so that the universality of the developed electronic form is extremely poor, and the data acquisition efficiency is low.

The embodiment of the application adopts the following technical scheme:

a data acquisition method comprising: responding to a template downloading instruction uploaded by a data input party, searching a first JSON character string corresponding to the template downloading instruction in a template library, wherein the template downloading instruction carries a first identifier of an electronic form template to be downloaded, and the first JSON character string stores identification information of each cell in the electronic form template; generating a spreadsheet template according to the first JSON character string, and generating the spreadsheet template to the data entry party; receiving an electronic form uploaded by the data entry party after editing the electronic form template, and checking the electronic form; after the verification of the electronic form is passed, analyzing the electronic form to obtain a second JSON character string corresponding to the electronic form; and storing the second JSON character string according to a second identifier corresponding to the electronic form to finish data acquisition.

A data acquisition device, comprising: the electronic form downloading device comprises a searching unit, a data input side and a data input side, wherein the searching unit is used for responding to a template downloading instruction uploaded by the data input side and searching a first JSON character string corresponding to the template downloading instruction in a template library, the template downloading instruction carries a first identifier of an electronic form template to be downloaded, and the first JSON character string stores the identifier information of each cell in the electronic form template; the table generation unit is used for analyzing the first JSON character string, generating a spreadsheet template and generating the spreadsheet template to the data entry party; the verification unit is used for receiving the electronic form uploaded by the data entry party after the electronic form template is edited, and verifying the electronic form; the analysis unit is used for analyzing the electronic table after the verification of the electronic table is passed, so as to obtain a second JSON character string corresponding to the electronic table; and the storage unit is used for storing the second JSON character string according to the second identifier corresponding to the electronic form so as to complete data acquisition.

A data acquisition device comprising:

a processor; and a memory arranged to store computer executable instructions that, when executed, cause the processor to: responding to a template downloading instruction uploaded by a data input party, searching a first JSON character string corresponding to the template downloading instruction in a template library, wherein the template downloading instruction carries a first identifier of an electronic form template to be downloaded, and the first JSON character string stores identification information of each cell in the electronic form template; generating a spreadsheet template according to the first JSON character string, and generating the spreadsheet template to the data entry party; receiving an electronic form uploaded by the data entry party after editing the electronic form template, and checking the electronic form; after the verification of the electronic form is passed, analyzing the electronic form to obtain a second JSON character string corresponding to the electronic form; and storing the second JSON character string according to a second identifier corresponding to the electronic form to finish data acquisition.

A computer-readable storage medium storing one or more programs that, when executed by an electronic device comprising a plurality of application programs, cause the electronic device to: responding to a template downloading instruction uploaded by a data input party, searching a first JSON character string corresponding to the template downloading instruction in a template library, wherein the template downloading instruction carries a first identifier of an electronic form template to be downloaded, and the first JSON character string stores identification information of each cell in the electronic form template; generating a spreadsheet template according to the first JSON character string, and generating the spreadsheet template to the data entry party; receiving an electronic form uploaded by the data entry party after editing the electronic form template, and checking the electronic form; after the verification of the electronic form is passed, analyzing the electronic form to obtain a second JSON character string corresponding to the electronic form; and storing the second JSON character string according to a second identifier corresponding to the electronic form to finish data acquisition.

The above-mentioned at least one technical scheme that this application embodiment adopted can reach following beneficial effect:

by adopting the data acquisition method provided by the embodiment of the application, the data acquisition party can design and develop the electronic form template for carrying out business data statistics according to business requirements, and upload the template to the data acquisition system, and after the received electronic form template is checked, the data acquisition system analyzes and dynamically splices the electronic form template into a JSON character string which accords with the specification, and stores the JSON character string in a template library; when data acquisition is needed, the data acquisition party can send the preset mark (such as a form name) of the electronic form template to the data entry party, the data entry party can send a template downloading instruction carrying the template mark to the data acquisition system, the data acquisition system responds to the template downloading instruction uploaded by the data entry party, a first JSON character string corresponding to the template downloading instruction is searched in a template library, a corresponding electronic form can be generated by dynamically splicing the first JSON character string, the electronic form is sent to the data entry party, the data entry party can fill in corresponding data according to the received electronic form template and the requirements of the data acquisition party, and the filled electronic form is uploaded to the data acquisition system again; the data acquisition system checks the received electronic form template to ensure that the data content filled in by the data entry party accords with the format and the content required by the data acquisition party, so that unified storage statistics can be carried out on the data in the follow-up process; after the verification of the electronic form is passed, the data acquisition system analyzes the electronic form to obtain a second JSON character string corresponding to the electronic form, and stores the second JSON character string according to the unique identifier (such as the name) of the electronic form in the template library to complete data acquisition. By adopting the data acquisition method provided by the embodiment of the application, the data acquisition party can rapidly complete the development and design process aiming at the electronic form template in a mode of inputting the appointed template rule in the specific cell of the electronic form, the electronic form development process is simple, the requirement on the professional skill of a developer is low, and the data acquisition efficiency is greatly improved. In addition, according to the data acquisition method provided by the scheme, as the developed electronic forms are stored in the form of the JSON character strings in the template library, the data acquisition system can dynamically splice the JSON character strings at any time according to the requirements of a data acquisition party to obtain corresponding electronic form templates, and visually display the pre-designed electronic form templates to the data acquisition party, so that the data acquisition party can flexibly modify and adjust the electronic form templates according to service requirements, and the universality of the electronic forms is greatly improved.

Drawings

The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiments of the application and together with the description serve to explain the application and do not constitute an undue limitation to the application. In the drawings:

fig. 1 is a specific flow diagram of a data acquisition method according to an embodiment of the present application;

fig. 2 is a schematic diagram of a specific structure of a data acquisition device according to an embodiment of the present application;

fig. 3 is a schematic specific structural diagram of a data acquisition device according to an embodiment of the present application.

Detailed Description

For the purposes, technical solutions and advantages of the present application, the technical solutions of the present application will be clearly and completely described below with reference to specific embodiments of the present application and corresponding drawings. It will be apparent that the described embodiments are only some, but not all, of the embodiments of the present application. All other embodiments, which can be made by one of ordinary skill in the art without undue burden from the present disclosure, are within the scope of the present disclosure.

The execution subject of the data collection method provided in the embodiments of the present application may be, but is not limited to, at least one of a data collection server, a data management server, a database management device, a financial management system, or an operation and maintenance management server.

For convenience of description, embodiments of the method will be described below by taking an execution body of the method as an example of a data acquisition system. It will be appreciated that the subject of the method is merely an exemplary illustration of a data acquisition system and should not be construed as limiting the method.

Specifically, a schematic diagram of a specific implementation flow of the data acquisition method provided in the present application is shown in fig. 1, and mainly includes the following steps:

step 11, responding to a template downloading instruction uploaded by a data entry side, and searching a first JSON character string corresponding to the template downloading instruction in a template library;

the first identifier of the electronic form template to be downloaded is carried in the template downloading instruction, and the identifier of the electronic form template can be a template name set for the electronic form template when the template is developed for data acquisition, or can be a unique identifier automatically generated for the template when the electronic form template is stored by a data acquisition system. The first JSON string stores identification information of each cell in the spreadsheet template.

In one embodiment, the electronic form templates stored in the data acquisition system template library are designed and developed in advance for the data acquisition party according to the service requirements. In the embodiment of the present application, before executing step 11, the data acquisition system may receive and store the spreadsheet template uploaded by the data acquirer according to the following sub-steps:

Sub-step 1101, receiving a spreadsheet template uploaded by a data collector;

taking the electronic form for data collection as an example, in one embodiment, a data collector may locally create an excel form according to the rule of the electronic form template, and create an excel form template for data collection by entering specific information into each cell of the excel form.

In one embodiment, the data collector may enter the content to be collected in each cell of the first row in the first sheet page of the newly created excel sheet, for example: address, quarter, month, date, amount, name, sex, age, etc. The type of the input data corresponding to the content to be collected may be input into the corresponding cell of the second row in the first sheet of the excel table, for example, the type of the input data may be a character string, or may be a number, etc., in an embodiment, the type of the input data may be represented by 1 as a character string, and the type of the input data may be represented by 2 as a number.

Assuming that an excel table template set by the data acquisition party is shown in table 1, it indicates that the data acquisition party needs to acquire five types of data, which are respectively: address, name, amount, gender and age, and the data types that five data need to be collected respectively are: address-character string, namely, aiming at the content to be collected, the data input party needs to input the character string to express; similarly, name-string, amount-number, gender-string, age-number.

TABLE 1excel form template

Address of	Name of name	Amount of money	Sex (sex)	Age of
					1	1	2	1	2

After the data acquisition party completes the creation of the excel form template, the excel form is named and uploaded to a data acquisition system.

A substep 1102, the data acquisition system performs format verification on the received spreadsheet template;

in order to avoid the problem that the electronic form template is abnormal due to filling errors of the data acquisition party, in the embodiment of the application, before the received excel form template is analyzed and stored, the data acquisition system can firstly check the format of the excel form template, and send an error prompt to the data acquisition party when the second row of cells exist and the first row of corresponding cells are the situation that the first row of corresponding cells do not exist, so as to inform the data acquisition party that the electronic form template uploaded by the data acquisition party has errors, and the electronic form template is uploaded again after being modified; for the case that the first row of cells has content and the second row of corresponding cells does not have content, the data acquisition system can also send an error reminding message to the data acquisition party, or the data acquisition system can automatically add information to the cells according to a preset rule, for example, for the second row of unfilled cells, the data acquisition system can set the cells to be 1 by default, namely, the data type is a character string.

Sub-step 1103, when the spreadsheet model is determined to pass through the verification by executing sub-step 1102, the data acquisition system may parse the spreadsheet template and generate a JSON string corresponding to the spreadsheet template;

specifically, the data acquisition system may be sequentially named for the cells of the first row: "col1, col2, col3 … coln", and the respective cells of the second row are sequentially named: "col1 Type, col2 Type, col3 Type … coln Type", and then the data acquisition system through traversing the spreadsheet template, discerns the content that each cell corresponds in this spreadsheet template, and then generates the JSON string that this spreadsheet model corresponds.

Taking the excel table template shown in table 1 as an example, JSON strings obtained by parsing the excel table template are as follows:

where "excel_module_name_n" represents the name of the spreadsheet template.

Sub-step 1104 stores the JSON string generated by performing sub-step 1103 in a template library.

Before storing, the data acquisition system can set a number for the JSON character string according to the number of the templates in the current template library, and uses the number and the name set by the data acquisition party for the template as the unique identifier of the JSON character string in the template library. Meanwhile, the data acquisition system also associates and stores the unique identifier of the data acquisition party uploading the electronic form template and the uploading time of the electronic form template with the JSON character string of the electronic form template in a template library for later use.

In addition, it should be noted that after the data acquisition party uploads the electronic form template with the set electronic form template to the data acquisition system, the data acquisition party may preview the uploaded electronic form template through the data acquisition system, and may modify and adjust the electronic form template.

In the embodiment of the application, the uploaded electronic form can be previewed and modified through the following steps:

step 11-a, receiving a template inquiry instruction sent by a data acquisition party;

the template query instruction carries a third identifier of the electronic form template to be queried, such as a template file name.

Step 11-b, searching a third JSON character string corresponding to the third identifier in the template library in response to the query instruction;

meanwhile, in order to ensure the safety of each electronic form template in the template library, after the data acquisition system inquires the corresponding JSON character string in response to the inquiry command, before the previous follow-up operation, the data acquisition system firstly performs identity authentication on the data acquisition party sending the inquiry command, specifically, the data acquisition system can acquire the unique identification of the data acquisition party sending the inquiry command, and by comparing the unique identification of the data acquisition party corresponding to the JSON character string, whether the user needing to perform template inquiry at present is the data acquisition party generating the electronic form template or not is determined, and when the judgment result is yes, the follow-up operation can be continuously performed.

Step 11-c, generating a corresponding electronic form template according to the third JSON character string, and feeding back the electronic form template to the data acquisition party for visual display;

sub-step 11-d, the receiving data acquisition party is based on the modification template uploaded after modifying the spreadsheet template;

after checking the form, the data acquisition party can flexibly modify and adjust the spreadsheet template displayed in the current visualization mode according to the current service requirement, such as adding, deleting, subtracting, modifying and the like the data content to be acquired, or modifying the type of the data to be acquired, and after completing the template adjustment, the data acquisition party can re-upload the updated spreadsheet template to the data acquisition system.

Sub-step 11-e, analyzing the modified template to generate a modified character string;

and a substep 11-f, modifying and updating the original JSON character string stored in the template library according to the modified character string.

Through the substeps, after the development and uploading of the electronic form template are finished for the first time, the data acquisition party can update and adjust the uploaded electronic form template through the data acquisition system at any time according to the change of the service requirement, so that the application range and flexibility of the electronic form template are greatly improved.

Step 12, generating a spreadsheet template according to the first JSON character string inquired by executing the step 11, and generating the spreadsheet template to the data entry party;

step 13, receiving the electronic form uploaded by the data entry party after editing the electronic form template, and checking the electronic form;

in order to ensure that the data input by the data entry party meets the requirements of the data acquisition party, in one embodiment, after receiving the electronic form uploaded by the data entry party, the data acquisition system firstly checks the electronic form, specifically, in the embodiment of the present application, the data acquisition system may perform the checking of the electronic form according to the following substeps:

sub-step 1301, determining a second identifier corresponding to the electronic form, and judging whether a JSON character string corresponding to the second identifier exists in the template library according to the second identifier;

in order to ensure the efficiency of data collection and data statistics, when data recording is performed, the name of the electronic form is generally not allowed to be modified by a data recording party, namely, the name of the electronic form needs to be ensured to be consistent with the name of the electronic form template corresponding to the template library.

After receiving the electronic form uploaded by the data entry party, the data acquisition system can firstly acquire the file name of the electronic form, find whether an electronic form template exists in a template library according to the file name, and when the judgment result is negative, indicate that the data entry party changes the file name of the electronic form or the data entry party uploads the electronic form with errors, and then send an error prompt to the data entry party; and when the determination is yes, sub-step 1302 is performed;

sub-step 1302, when the judgment result is yes, determining cell data of the electronic form template corresponding to the JSON character string according to the JSON character string;

the cell data comprise data types and data formats corresponding to the cells in the spreadsheet template, and the data types and the data formats corresponding to the data types can be determined through the cell data, wherein the data types and the data formats correspond to the data types, and the data types need to be collected by a data collector.

Sub-step 1303, checking the electronic form according to the cell data.

And the data acquisition system checks the data type and the data format recorded in the electronic form by the data recording party according to the cell data.

Step 14, after the verification of the electronic form is passed, analyzing the electronic form to obtain a second JSON character string corresponding to the electronic form;

the data acquisition system identifies the content corresponding to each cell in the electronic table by traversing the electronic table, and further generates a JSON character string corresponding to the electronic table.

If the verification is not passed, the data acquisition system sends an error prompt to the data entry party to remind the data entry party to download the correct spreadsheet template again, and the data entry is performed according to the correct format.

And 15, storing the second JSON character string according to the second identifier corresponding to the electronic form, and completing data acquisition.

In one embodiment, the data collection system may generate an entity class corresponding to a file name (i.e., a certain spreadsheet template) according to the file name corresponding to the spreadsheet, and store the parsed JSON string in the entity class. The subsequent data acquisition system can store the JSON character strings corresponding to the received electronic forms with the same file names in the entity class, so that data acquisition is completed.

In an implementation manner, the embodiment of the application further provides a data acquisition device, which is used for solving the problems that when data acquisition is performed based on the electronic form, the development process of the self-defined form is complex, the developed electronic form is single in structure and cannot be flexibly modified according to service requirements, so that the universality of the developed electronic form is extremely poor, and the data acquisition efficiency is low. The specific structural schematic diagram of the data acquisition device is shown in fig. 2, and comprises: a search unit 21, a table generation unit 22, a verification unit 23, an analysis unit 24 and a storage unit 25.

The searching unit 21 is configured to respond to a template downloading instruction uploaded by a data entry side, and search a first JSON string corresponding to the template downloading instruction in a template library, where the template downloading instruction carries a first identifier of a spreadsheet template to be downloaded, and the first JSON string stores identifier information of each cell in the spreadsheet template;

a form generating unit 22, configured to parse the first JSON string, generate a spreadsheet template, and generate the spreadsheet template to the data entry party;

A verification unit 23, configured to receive an electronic form uploaded by the data entry party after editing the electronic form template, and verify the electronic form;

an parsing unit 24, configured to parse the electronic form after the verification of the electronic form is passed, so as to obtain a second JSON string corresponding to the electronic form;

and the storage unit 25 is configured to store the second JSON string according to the second identifier corresponding to the electronic form, so as to complete data acquisition.

In one embodiment, the verification unit 23 is specifically configured to: determining a second identifier corresponding to the electronic form; judging whether a JSON character string corresponding to the second identifier exists in the template library according to the second identifier; when the judgment result is yes, determining cell data of a spreadsheet template corresponding to the JSON character string according to the JSON character string, wherein the cell data comprises data types and data formats corresponding to all cells in the spreadsheet template; and verifying the electronic table according to the cell data.

In one embodiment, the method further comprises a template storage unit, specifically configured to: receiving an electronic form template uploaded by a data acquisition party, and performing format verification on the electronic form template; after the format verification of the electronic form template is passed, analyzing the electronic form template to generate a JSON character string corresponding to the electronic form template, and storing the JSON character string in a template library.

In one embodiment, the system further comprises a query unit, specifically configured to: receiving a template query instruction sent by a data acquisition party, wherein the template query instruction carries a third identifier of a to-be-queried electronic form template; responding to the query instruction, and searching a third JSON character string corresponding to the third identifier in the template library; and generating a corresponding electronic form template according to the third JSON character string, and feeding back the electronic form template to the data acquisition party for visual display.

In one embodiment, the query unit is further configured to: the receiving data acquisition party is based on a modification template uploaded after modifying the spreadsheet template; analyzing the modification template to generate a modification character string; and modifying and updating the original JSON character string stored in the template library according to the modification character string.

By adopting the data acquisition device provided by the embodiment of the application, the data acquisition party can design and develop a spreadsheet template for carrying out business data statistics according to business requirements, and upload the template to a data acquisition system, and after the received spreadsheet template is checked by the data acquisition system, the spreadsheet template is analyzed and dynamically spliced into a JSON character string which accords with the specification, and the JSON character string is stored in a template library; when data acquisition is needed, the data acquisition party can send the preset mark (such as a form name) of the electronic form template to the data entry party, the data entry party can send a template downloading instruction carrying the template mark to the data acquisition system, the data acquisition system responds to the template downloading instruction uploaded by the data entry party, a first JSON character string corresponding to the template downloading instruction is searched in a template library, a corresponding electronic form can be generated by dynamically splicing the first JSON character string, the electronic form is sent to the data entry party, the data entry party can fill in corresponding data according to the received electronic form template and the requirements of the data acquisition party, and the filled electronic form is uploaded to the data acquisition system again; the data acquisition system checks the received electronic form template to ensure that the data content filled in by the data entry party accords with the format and the content required by the data acquisition party, so that unified storage statistics can be carried out on the data in the follow-up process; after the verification of the electronic form is passed, the data acquisition system analyzes the electronic form to obtain a second JSON character string corresponding to the electronic form, and stores the second JSON character string according to the unique identifier (such as the name) of the electronic form in the template library to complete data acquisition. By adopting the data acquisition method provided by the embodiment of the application, the data acquisition party can rapidly complete the development and design process aiming at the electronic form template in a mode of inputting the appointed template rule in the specific cell of the electronic form, the electronic form development process is simple, the requirement on the professional skill of a developer is low, and the data acquisition efficiency is greatly improved. In addition, according to the data acquisition method provided by the scheme, as the developed electronic forms are stored in the form of the JSON character strings in the template library, the data acquisition system can dynamically splice the JSON character strings at any time according to the requirements of a data acquisition party to obtain corresponding electronic form templates, and visually display the pre-designed electronic form templates to the data acquisition party, so that the data acquisition party can flexibly modify and adjust the electronic form templates according to service requirements, and the universality of the electronic forms is greatly improved.

Fig. 3 is a schematic structural diagram of an electronic device according to an embodiment of the present application. Referring to fig. 3, at the hardware level, the electronic device includes a processor, and optionally an internal bus, a network interface, and a memory. The Memory may include a Memory, such as a Random-Access Memory (RAM), and may further include a non-volatile Memory (non-volatile Memory), such as at least 1 disk Memory. Of course, the electronic device may also include hardware required for other services.

The processor, network interface, and memory may be interconnected by an internal bus, which may be an ISA (Industry Standard Architecture ) bus, a PCI (Peripheral Component Interconnect, peripheral component interconnect standard) bus, or EISA (Extended Industry Standard Architecture ) bus, among others. The buses may be classified as address buses, data buses, control buses, etc. For ease of illustration, only one bi-directional arrow is shown in FIG. 3, but not only one bus or type of bus.

And the memory is used for storing programs. In particular, the program may include program code including computer-operating instructions. The memory may include memory and non-volatile storage and provide instructions and data to the processor.

The processor reads the corresponding computer program from the nonvolatile memory to the memory and then runs, and the data acquisition device is formed on a logic level. The processor is used for executing the programs stored in the memory and is specifically used for executing the following operations:

responding to a template downloading instruction uploaded by a data input party, searching a first JSON character string corresponding to the template downloading instruction in a template library, wherein the template downloading instruction carries a first identifier of an electronic form template to be downloaded, and the first JSON character string stores identification information of each cell in the electronic form template; generating a spreadsheet template according to the first JSON character string, and generating the spreadsheet template to the data entry party; receiving an electronic form uploaded by the data entry party after editing the electronic form template, and checking the electronic form; after the verification of the electronic form is passed, analyzing the electronic form to obtain a second JSON character string corresponding to the electronic form; and storing the second JSON character string according to a second identifier corresponding to the electronic form to finish data acquisition.

The method performed by the data acquisition electronic device disclosed in the embodiment of fig. 3 of the present application may be applied to a processor or implemented by a processor. The processor may be an integrated circuit chip having signal processing capabilities. In implementation, the steps of the above method may be performed by integrated logic circuits of hardware in a processor or by instructions in the form of software. The processor may be a general-purpose processor, including a central processing unit (Central Processing Unit, CPU), a network processor (Network Processor, NP), etc.; but also digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), field programmable gate arrays (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components. The disclosed methods, steps, and logic blocks in the embodiments of the present application may be implemented or performed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of a method disclosed in connection with the embodiments of the present application may be embodied directly in hardware, in a decoded processor, or in a combination of hardware and software modules in a decoded processor. The software modules may be located in a random access memory, flash memory, read only memory, programmable read only memory, or electrically erasable programmable memory, registers, etc. as well known in the art. The storage medium is located in a memory, and the processor reads the information in the memory and, in combination with its hardware, performs the steps of the above method.

Of course, other implementations, such as a logic device or a combination of hardware and software, are not excluded from the electronic device of the present application, that is, the execution subject of the following processing flow is not limited to each logic unit, but may be hardware or a logic device.

The present embodiments also provide a computer readable storage medium storing one or more programs, the one or more programs comprising instructions, which when executed by a portable electronic device comprising a plurality of application programs, enable the portable electronic device to perform the method of the embodiment of fig. 1, and in particular to:

It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.

The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

In one typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.

The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.

Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.

It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article or apparatus that comprises the element.

It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.

The foregoing is merely exemplary of the present application and is not intended to limit the present application. Various modifications and changes may be made to the present application by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc. which are within the spirit and principles of the present application are intended to be included within the scope of the claims of the present application.

Claims

1. A method of data acquisition, comprising:

responding to a template downloading instruction uploaded by a data input party, searching a first JSON character string corresponding to the template downloading instruction in a template library, wherein the template downloading instruction carries a first identifier of an electronic form template to be downloaded, and the first JSON character string stores identification information of each cell in the electronic form template;

Generating a spreadsheet template according to the first JSON character string, and generating the spreadsheet template to the data entry party;

receiving an electronic form uploaded by the data entry party after editing the electronic form template, and checking the electronic form;

after the verification of the electronic form is passed, analyzing the electronic form to obtain a second JSON character string corresponding to the electronic form;

and storing the second JSON character string according to a second identifier corresponding to the electronic form to finish data acquisition.

2. The method according to claim 1, wherein the verifying the electronic form specifically comprises:

determining a second identifier corresponding to the electronic form;

judging whether a JSON character string corresponding to the second identifier exists in the template library according to the second identifier;

when the judgment result is yes, determining cell data of a spreadsheet template corresponding to the JSON character string according to the JSON character string, wherein the cell data comprises data types and data formats corresponding to all cells in the spreadsheet template;

And verifying the electronic table according to the cell data.

3. The method according to claim 1, wherein the method further comprises:

receiving a spreadsheet template uploaded by a data acquisition party, and performing format verification on the spreadsheet template, wherein the spreadsheet template is generated by the data acquisition party by inputting a specific template rule into a specific cell of a spreadsheet;

after the format verification of the electronic form template is passed, analyzing the electronic form template to generate a JSON character string corresponding to the electronic form template, and storing the JSON character string in a template library.

4. A method according to claim 3, further comprising:

receiving a template query instruction sent by a data acquisition party, wherein the template query instruction carries a third identifier of a to-be-queried electronic form template;

responding to the query instruction, and searching a third JSON character string corresponding to the third identifier in the template library;

and generating a corresponding electronic form template according to the third JSON character string, and feeding back the electronic form template to the data acquisition party for visual display.

5. The method of claim 4, wherein after feeding back the spreadsheet template to the data collector for visual presentation, the method further comprises:

the receiving data acquisition party is based on a modification template uploaded after modifying the spreadsheet template;

analyzing the modification template to generate a modification character string;

and modifying and updating the original JSON character string stored in the template library according to the modification character string.

6. A data acquisition device, comprising:

the electronic form downloading device comprises a searching unit, a data input side and a data input side, wherein the searching unit is used for responding to a template downloading instruction uploaded by the data input side and searching a first JSON character string corresponding to the template downloading instruction in a template library, the template downloading instruction carries a first identifier of an electronic form template to be downloaded, and the first JSON character string stores the identifier information of each cell in the electronic form template;

the table generation unit is used for analyzing the first JSON character string, generating a spreadsheet template and generating the spreadsheet template to the data entry party;

the verification unit is used for receiving the electronic form uploaded by the data entry party after the electronic form template is edited, and verifying the electronic form;

The analysis unit is used for analyzing the electronic table after the verification of the electronic table is passed, so as to obtain a second JSON character string corresponding to the electronic table;

and the storage unit is used for storing the second JSON character string according to the second identifier corresponding to the electronic form so as to complete data acquisition.

7. The apparatus according to claim 6, wherein the verification unit is specifically configured to:

determining a second identifier corresponding to the electronic form;

and verifying the electronic table according to the cell data.

8. The apparatus of claim 6, further comprising a template storage unit, specifically configured to:

receiving an electronic form template uploaded by a data acquisition party, and performing format verification on the electronic form template;

9. A data acquisition device comprising:

a processor; and

a memory arranged to store computer executable instructions that, when executed, cause the processor to:

10. A computer readable storage medium storing one or more programs, which when executed by an electronic device comprising a plurality of application programs, cause the electronic device to perform the method of any of claims 1-5.