CN115310944A - Online ledger management method, system, device and medium - Google Patents
Online ledger management method, system, device and medium Download PDFInfo
- Publication number
- CN115310944A CN115310944A CN202211018820.4A CN202211018820A CN115310944A CN 115310944 A CN115310944 A CN 115310944A CN 202211018820 A CN202211018820 A CN 202211018820A CN 115310944 A CN115310944 A CN 115310944A
- Authority
- CN
- China
- Prior art keywords
- excel
- filling
- file
- rule
- online
- 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.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Human Computer Interaction (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses an online standing book management method, a system, equipment and a medium, wherein the online standing book management system comprises a file management subsystem, a data processing module and a normalization subsystem, and the method comprises the following steps: acquiring an Excel file through a file management subsystem, carrying out rule identification on the Excel file through a data processing module to determine a filling rule of the Excel file, and carrying out data normalization on the Excel file through a normalization subsystem to convert the Excel file into an online data table; the Excel filling information is obtained through the file management subsystem, the Excel filling information is filed, and the filed Excel filling information is subjected to rule examination through the data processing module so as to determine whether the Excel filling information meets the filling rule. The application provides a machine account management scheme with functions of online importing, filling, summarizing, intelligent association and the like.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method, a system, a device, and a medium for managing online ledgers.
Background
With the continuous development of society, the basic data governance taking areas, streets, communities and cells as units is more and more concerned. In a traditional mode, most basic workers use traditional modes such as file tables and electronic tables to collect data, the data collection needs the workers to go offline for collection, and after all data collection is finished, the data collection is carried out layer by layer upwards to finally form data information of the whole area. If the change of the data content is involved in the process, the update needs to be declared step by step, which is very labor-consuming and is easy to make mistakes.
With the rise of mobile internet and government affair informatization, online statistics based on Web becomes a mainstream, and the system can collect and file layer by layer according to the grade of a user only by inputting collected information into the system by a basic worker. Workers can be helped to save much labor at this stage, but the functions of data collection, statistical distribution, statistical summary, data sharing, auxiliary filling and the like have obvious defects.
Disclosure of Invention
In order to solve the above problem, the present application provides an online standing book management method, which is applied to an online standing book management system, where the online standing book management system includes a file management subsystem, a data processing module, and a normalization subsystem, and the method includes: acquiring an Excel file through the file management subsystem, carrying out rule identification on the Excel file through the data processing module to determine a filling rule of the Excel file, and carrying out data normalization on the Excel file through the normalization subsystem to convert the Excel file into an online data sheet; acquiring Excel filling information through the file management subsystem, filing the Excel filling information, and performing rule examination on the filed Excel filling information through the data processing module to determine whether the Excel filling information meets the filling rule; if the Excel filling information conforms to the filling rule, writing the Excel filling information into the online data table according to the filling rule; and if the Excel filling information does not accord with the filling rule, determining an error message of the Excel filling information according to the filling rule, and sending the error message to a user corresponding to the Excel filling information.
In one example, the online ledger management system further comprises an intelligent recommendation subsystem, the method comprising: receiving a query table of the user through the file management subsystem, determining query contents according to the query table, and sending the query contents to the intelligent recommendation subsystem; and matching the online data table through the intelligent recommendation subsystem according to the query content so as to supplement and fill the query table according to the online data table.
In one example, before matching the online data table by the intelligent recommendation subsystem according to the query content, the method further comprises: determining all data characteristics in the online data table, and cleaning the online data table according to the data characteristics to obtain sample data; performing model training according to the sample data to obtain a prediction model; matching the online data table through the intelligent recommendation subsystem according to the query content, specifically comprising: and matching the online data table through the prediction model to obtain a matching result, and sending the matching result to the user.
In one example, before writing the Excel filling information into the online data table according to filling rules, the method further comprises: determining a filling file according to the Excel filling information, and merging the filling file and the Excel file to write the Excel filling information into the online data table; after writing the Excel filling information into the online data table according to filling rules, the method further comprises the following steps: acquiring a withdrawal application through the file management subsystem, determining corresponding withdrawal files according to the withdrawal application, and merging all table files except the withdrawal files.
In one example, the method further comprises: determining the file authority of the user, and sharing the file of the online data table according to the file authority; and receiving the management application of the user through the file management subsystem, and auditing the management application according to the file authority so as to determine the management authority of the user, wherein the management authority at least comprises an editing authority, an export authority and a downloading authority.
On the other hand, the application also provides an online standing book management system, which comprises: the file management subsystem is used for acquiring an Excel file and Excel filling information and filing the Excel filling information; the data processing module is connected with the file management subsystem and used for carrying out rule identification on the Excel file so as to determine a filling rule of the Excel file; and the normalization subsystem is connected with the data processing module and is used for carrying out data normalization on the Excel file so as to convert the Excel file into an online data table.
In one example, the data processing module is further configured to perform rule review on the archived Excel filling information to determine whether the Excel filling information conforms to the filling rule; if the Excel filling information conforms to the filling rule, writing the Excel filling information into the online data table according to the filling rule; and if the Excel filling information does not accord with the filling rule, determining an error message of the Excel filling information according to the filling rule, and sending the error message to a user corresponding to the Excel filling information.
In one example, the file management subsystem is further configured to receive a lookup table of a user, and determine query contents according to the lookup table; the online standing book management system further comprises: and the intelligent recommendation subsystem is connected with the file management subsystem, is in data connection with the online data table, and is used for acquiring the query content, matching the online data table according to the query content, and supplementing and filling the query table according to the online data table.
On the other hand, the application also provides an online standing book management device, which comprises: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the online ledger administration device to perform: acquiring an Excel file through a file management subsystem, carrying out rule identification on the Excel file through a data processing module to determine a filling rule of the Excel file, and carrying out data normalization on the Excel file through a normalization subsystem to convert the Excel file into an online data table; acquiring Excel filling information through the file management subsystem, filing the Excel filling information, and performing rule examination on the filed Excel filling information through the data processing module to determine whether the Excel filling information meets the filling rule; if the Excel filling information conforms to the filling rule, writing the Excel filling information into the online data table according to the filling rule; and if the Excel filling information does not accord with the filling rule, determining an error message of the Excel filling information according to the filling rule, and sending the error message to a user corresponding to the Excel filling information.
In another aspect, the present application further provides a non-volatile computer storage medium storing computer-executable instructions configured to: acquiring an Excel file through a file management subsystem, carrying out rule identification on the Excel file through a data processing module to determine a filling rule of the Excel file, and carrying out data normalization on the Excel file through a normalization subsystem to convert the Excel file into an online data table; acquiring Excel filling information through the file management subsystem, filing the Excel filling information, and performing rule examination on the filed Excel filling information through the data processing module to determine whether the Excel filling information meets the filling rule; if the Excel filling information conforms to the filling rule, writing the Excel filling information into the online data table according to the filling rule; and if the Excel filling information does not accord with the filling rule, determining an error message of the Excel filling information according to the filling rule, and sending the error message to a user corresponding to the Excel filling information.
In the solution of the standing book system based on online Excel, a double collection scheme of online filling and local Excel uploading is adopted for seamless access to a basic level staff statistics form, and the system can support data content collected by local Excel. After uploading, the system can carry out preprocessing and pre-cleaning on data, and then the data is converted into online Excel filling operation, so that the conventional operations such as seamless copying, pasting and the like with local Excel can be realized. In the distribution and summarization stage, the statistical template is distributed layer by designing the form of the statistical template, then the statistics is reported layer by layer, the data is rapidly archived in a layer by layer summarization mode, the withdrawal function of submitted contents is supported, and the withdrawer is allowed to resubmit the statistics and archive the resubmission. The basic level units often relate to sharing and governance of content, content data of a certain organization can be quickly authorized to be shared to other organizations, and whether editing and copying operations can be performed or not can be achieved accurately. Data formed by basic level summarization can be counted into a large virtual table, in the process of filling and reporting by basic level personnel, all contents of the information are quickly associated through certain keywords such as names, identity cards, mobile phone numbers and the like, the working personnel are helped to quickly fill in the data, and sharing and co-treatment of the data are really realized.
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 embodiment(s) of the application and together with the description serve to explain the application and not to limit the application. In the drawings:
fig. 1 is a schematic flowchart of an online ledger management method in an embodiment of the present application;
fig. 2 is a schematic structural diagram of an online ledger management system in an embodiment of the present application;
fig. 3 is a schematic diagram of an online ledger management apparatus in an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the technical solutions of the present application will be described in detail and completely with reference to the following specific embodiments of the present application and the accompanying drawings. It should be apparent that the described embodiments are only some of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The technical solutions provided by the embodiments of the present application are described in detail below with reference to the accompanying drawings.
As shown in fig. 1, to solve the above problem, an online ledger management method provided in an embodiment of the present application is applied to an online ledger management system, as shown in fig. 2, the online ledger management system includes a file management subsystem, a data processing module, and a normalization subsystem, and the method includes:
s101, an Excel file is obtained through the file management subsystem, rule identification is conducted on the Excel file through the data processing module to determine filling rules of the Excel file, and data normalization is conducted on the Excel file through the normalization subsystem to convert the Excel file into an online data sheet.
The online standing book management system provides an online Excel form editing scheme compatible with office Excel, supports functions of uploading, copying, pasting and the like of local Excel files, and meanwhile, the online Excel form can be exported to be local Excel.
And after the file is uploaded to the file management subsystem, triggering the data processing module to perform simple data processing, and then performing rule identification on the local Excel file to obtain a filling rule. For example, the user designs the header of each filling item, and sets a certain rule, for example, A1 is set as an identity card number, and the rule is selected as a rule for checking the identity card; a2 is set as the mobile phone number, and meanwhile, the rule is selected as the rule for checking the mobile phone number. The rule identification is carried out by the data processing module, the module needs to distinguish the rule area and the content area, and records the rule according to the file, so that the later calling is facilitated.
Then, the data is sent to a normalization subsystem for data normalization processing, wherein the normalization processing at least comprises cleaning, classification, distribution and writing. And finally converting the file data into an online Excel data table of one table.
S102, obtaining Excel filling information through the file management subsystem, filing the Excel filling information, and carrying out rule examination on the filed Excel filling information through the data processing module to determine whether the Excel filling information accords with the filling rule.
When a user performs filling, the file management subsystem acquires Excel filling information, and the system can automatically detect whether the filling information input by the user meets the rules or not based on the stored filling rules. When the user downloads the template to the local for filling, the template is uploaded to the system again, the template is delivered to the file management subsystem for filing processing, and then the data processing module is triggered to carry out rule identification.
S103, if the Excel filling information conforms to the filling rule, writing the Excel filling information into the online data table according to the filling rule.
S104, if the Excel filling information does not accord with the filling rule, determining an error message of the Excel filling information according to the filling rule, and sending the error message to a user corresponding to the Excel filling information.
In one embodiment, the aggregated data needs to be fed back to the base layer to help the base layer staff to perform data reporting work more quickly. Therefore, the online ledger management system also includes an intelligent recommendation subsystem. The file management subsystem receives a query table of a user, the intelligent recommendation subsystem matches the online data table based on certain query content input in the query table, complete information corresponding to the content is automatically queried, basic level workers are helped to quickly fill in the information, and repeated labor and error rate are reduced.
In one embodiment, the implementation of assisted population requires using the stored data of one table, determining all data characteristics in the online data table, and cleaning the online data table according to the data characteristics to obtain sample data. And calculating the sample data through the recommendation system, wherein the calculation method comprises the modes of logic matching, machine learning, real-time calculation and the like. For example, the house data related to one table is subjected to service cleaning and feature extraction, the naive Bayes algorithm is used for training sample data to obtain a trained prediction model, and the prediction model is applied to a real service scene for prediction and recommendation. And recommending the matched result to a user, and acquiring the content of the selected result from a table by the background once after the user selects a certain recommended result.
In one embodiment, the user performs corresponding content filling, and the system supports an online mode and an offline mode, wherein the two modes both need corresponding entity files in the background, namely, the files are uniformly processed as files by the file management subsystem. Before writing Excel filling information into an online data table according to filling rules, determining a filling file according to the Excel filling information, and merging the filling file and the Excel file to write the Excel filling information into the online data table; after writing the Excel filling information into the online data sheet according to the filling rule, submitting the filled file, and combining the contents of the submitted file by the system to generate a new file data content. Every time one person submits, the merging action can be triggered, meanwhile, the system supports submission of a withdrawal application, after the withdrawal application of a certain user passes, the corresponding withdrawal file is determined according to the withdrawal application, and the system can carry out the merging action on all submitted files except the withdrawal file again and then delivers the files to the file management system.
In one embodiment, the aggregation of data is for a better service base layer, so sharing of aggregated data is critical. Therefore, the online standing book management system supports sharing and co-processing of any level of summarized data, and the owner of the table can choose to share or even co-process the data with other people. The file has the concept of organization attribution, and the organization has a superior-subordinate relation, so that the file has characteristics of different levels in the sharing process, and the system controls the level of the file through the authority of a user or the organization. The system determines the file authority of the user and shares the file with the online data table according to the file authority; the file management subsystem receives a management application of a user, and the management application is checked according to file authority so as to determine the management authority of the user, wherein the management authority at least comprises editing authority, exporting authority and downloading authority. For example, a street manager may have certain administrative rights to community files belonging to the organization. In the process, the authority of whether the file is editable, exportable, downloadable and the like can be accurately controlled. The sharing of data is distributed and accessed in a mode controlled by users or organization authorities, and the data files also need to be controlled by an authority system. The co-processing of the data is based on a shared authority system, so that the increase, deletion, modification and check of the data by an accessor are controlled, an accurate log of operation needs to be recorded, and the problem tracking in the later period is facilitated.
As shown in fig. 2, an embodiment of the present application further provides an online ledger management system, including: the file management subsystem is used for acquiring an Excel file and Excel filling information and filing the Excel filling information; the data processing module is connected with the file management subsystem and used for carrying out rule identification on the Excel file so as to determine a filling rule of the Excel file; and the normalization subsystem is connected with the data processing module and is used for carrying out data normalization on the Excel file so as to convert the Excel file into an online data table.
In one embodiment, the data processing module is further configured to perform rule review on the archived Excel filling information to determine whether the Excel filling information meets the filling rule; if the Excel filling information accords with the filling rule, writing the Excel filling information into an online data table according to the filling rule; and if the Excel filling information does not accord with the filling rule, determining an error message of the Excel filling information according to the filling rule, and sending the error message to a user corresponding to the Excel filling information.
In one embodiment, the file management subsystem is further configured to receive a look-up table of the user, and determine the query content according to the look-up table; the online standing book management system further comprises: and the intelligent recommendation subsystem is connected with the file management subsystem, is in data connection with the online data table, and is used for acquiring query contents, matching the online data table according to the query contents and supplementing and filling the query table according to the online data table.
As shown in fig. 3, an embodiment of the present application further provides an online ledger management apparatus, including:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the online ledger administration device to perform:
acquiring an Excel file through a file management subsystem, carrying out rule identification on the Excel file through a data processing module to determine a filling rule of the Excel file, and carrying out data normalization on the Excel file through a normalization subsystem to convert the Excel file into an online data sheet;
acquiring Excel filling information through the file management subsystem, filing the Excel filling information, and performing rule examination on the filed Excel filling information through the data processing module to determine whether the Excel filling information meets the filling rule;
if the Excel filling information accords with the filling rule, writing the Excel filling information into the online data sheet according to the filling rule;
and if the Excel filling information does not accord with the filling rule, determining an error message of the Excel filling information according to the filling rule, and sending the error message to a user corresponding to the Excel filling information.
An embodiment of the present application further provides a non-volatile computer storage medium storing computer-executable instructions, where the computer-executable instructions are configured to:
acquiring an Excel file through a file management subsystem, carrying out rule identification on the Excel file through a data processing module to determine a filling rule of the Excel file, and carrying out data normalization on the Excel file through a normalization subsystem to convert the Excel file into an online data sheet;
acquiring Excel filling information through the file management subsystem, filing the Excel filling information, and performing rule examination on the filed Excel filling information through the data processing module to determine whether the Excel filling information meets the filling rule;
if the Excel filling information accords with the filling rule, writing the Excel filling information into the online data sheet according to the filling rule;
and if the Excel filling information does not accord with the filling rule, determining an error message of the Excel filling information according to the filling rule, and sending the error message to a user corresponding to the Excel filling information.
The embodiments in the present application are described in a progressive manner, and the same and similar parts among the embodiments can be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the device and media embodiments, the description is relatively simple, as it is substantially similar to the method embodiments, and reference may be made to some description of the method embodiments for relevant points.
The device and the medium provided by the embodiment of the application correspond to the method one to one, so the device and the medium also have the similar beneficial technical effects as the corresponding method, and the beneficial technical effects of the method are explained in detail above, so the beneficial technical effects of the device and the medium are not repeated herein.
As will be appreciated by one skilled in the art, 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 so forth) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams 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 a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.
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 computer storage media 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 Disks (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. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
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 phrases "comprising one of 8230; \8230;" 8230; "does not exclude the presence of additional like elements in a process, method, article, or apparatus that comprises that element.
The above description is only an example of the present application and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement or the like made within the spirit and principle of the present application shall be included in the scope of the claims of the present application.
Claims (10)
1. An online standing book management method is characterized by being applied to an online standing book management system, wherein the online standing book management system comprises a file management subsystem, a data processing module and a normalization subsystem, and the method comprises the following steps:
acquiring an Excel file through the file management subsystem, carrying out rule identification on the Excel file through the data processing module to determine a filling rule of the Excel file, and carrying out data normalization on the Excel file through the normalization subsystem to convert the Excel file into an online data sheet;
acquiring Excel filling information through the file management subsystem, filing the Excel filling information, and performing rule examination on the filed Excel filling information through the data processing module to determine whether the Excel filling information meets the filling rule;
if the Excel filling information conforms to the filling rule, writing the Excel filling information into the online data table according to the filling rule;
and if the Excel filling information does not accord with the filling rule, determining an error message of the Excel filling information according to the filling rule, and sending the error message to a user corresponding to the Excel filling information.
2. The method of claim 1, wherein the online ledger management system further comprises an intelligent recommendation subsystem, the method comprising:
receiving a query table of the user through the file management subsystem, determining query contents according to the query table, and sending the query contents to the intelligent recommendation subsystem;
and matching the online data table through the intelligent recommendation subsystem according to the query content so as to supplement and fill the query table according to the online data table.
3. The method of claim 2, wherein prior to matching the online data table by the intelligent recommendation subsystem based on the query content, the method further comprises:
determining all data characteristics in the online data table, and cleaning the online data table according to the data characteristics to obtain sample data;
performing model training according to the sample data to obtain a prediction model;
matching the online data table through the intelligent recommendation subsystem according to the query content, specifically comprising:
and matching the online data table through the prediction model to obtain a matching result, and sending the matching result to the user.
4. The method of claim 1, wherein before writing the Excel fill information to the online data table according to fill rules, the method further comprises:
determining a filling file according to the Excel filling information, and merging the filling file and the Excel file to write the Excel filling information into the online data table;
after writing the Excel filling information into the online data table according to filling rules, the method further comprises the following steps:
acquiring a withdrawal application through the file management subsystem, determining a corresponding withdrawal file according to the withdrawal application, and merging all table files except the withdrawal file.
5. The method of claim 1, further comprising:
determining the file authority of the user, and sharing the file of the online data table according to the file authority;
and receiving the management application of the user through the file management subsystem, and auditing the management application according to the file authority so as to determine the management authority of the user, wherein the management authority at least comprises an editing authority, an export authority and a downloading authority.
6. An online ledger management system, characterized by comprising:
the file management subsystem is used for acquiring an Excel file and Excel filling information and filing the Excel filling information;
the data processing module is connected with the file management subsystem and used for carrying out rule identification on the Excel file so as to determine a filling rule of the Excel file;
and the normalization subsystem is connected with the data processing module and is used for carrying out data normalization on the Excel file so as to convert the Excel file into an online data table.
7. The online ledger management system of claim 6, wherein the data processing module is further configured to perform rule review on the archived Excel fill-in information to determine whether the Excel fill-in information meets the fill-in rule;
if the Excel filling information accords with the filling rule, writing the Excel filling information into the online data sheet according to the filling rule;
and if the Excel filling information does not accord with the filling rule, determining an error message of the Excel filling information according to the filling rule, and sending the error message to a user corresponding to the Excel filling information.
8. The online ledger management system of claim 6, wherein the file management subsystem is further configured to receive a look-up table of a user, determine query contents from the look-up table;
the online standing book management system further comprises:
and the intelligent recommendation subsystem is connected with the file management subsystem, is in data connection with the online data table, and is used for acquiring the query content, matching the online data table according to the query content, and supplementing and filling the query table according to the online data table.
9. An online ledger management apparatus characterized by comprising:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the online ledger administration device to perform:
acquiring an Excel file through a file management subsystem, carrying out rule identification on the Excel file through a data processing module to determine a filling rule of the Excel file, and carrying out data normalization on the Excel file through a normalization subsystem to convert the Excel file into an online data table;
acquiring Excel filling information through the file management subsystem, filing the Excel filling information, and performing rule examination on the filed Excel filling information through the data processing module to determine whether the Excel filling information meets the filling rule;
if the Excel filling information conforms to the filling rule, writing the Excel filling information into the online data table according to the filling rule;
and if the Excel filling information does not accord with the filling rule, determining an error message of the Excel filling information according to the filling rule, and sending the error message to a user corresponding to the Excel filling information.
10. A non-transitory computer storage medium storing computer-executable instructions, the computer-executable instructions configured to:
acquiring an Excel file through a file management subsystem, carrying out rule identification on the Excel file through a data processing module to determine a filling rule of the Excel file, and carrying out data normalization on the Excel file through a normalization subsystem to convert the Excel file into an online data sheet;
acquiring Excel filling information through the file management subsystem, filing the Excel filling information, and performing rule examination on the filed Excel filling information through the data processing module to determine whether the Excel filling information meets the filling rule;
if the Excel filling information conforms to the filling rule, writing the Excel filling information into the online data table according to the filling rule;
and if the Excel filling information does not accord with the filling rule, determining an error message of the Excel filling information according to the filling rule, and sending the error message to a user corresponding to the Excel filling information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211018820.4A CN115310944A (en) | 2022-08-24 | 2022-08-24 | Online ledger management method, system, device and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211018820.4A CN115310944A (en) | 2022-08-24 | 2022-08-24 | Online ledger management method, system, device and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115310944A true CN115310944A (en) | 2022-11-08 |
Family
ID=83864245
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211018820.4A Pending CN115310944A (en) | 2022-08-24 | 2022-08-24 | Online ledger management method, system, device and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115310944A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115660611A (en) * | 2022-12-28 | 2023-01-31 | 广东信通通信有限公司 | Intelligent management and control method for power transmission standing book |
-
2022
- 2022-08-24 CN CN202211018820.4A patent/CN115310944A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115660611A (en) * | 2022-12-28 | 2023-01-31 | 广东信通通信有限公司 | Intelligent management and control method for power transmission standing book |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110008270B (en) | Method and system for realizing engineering electronic file | |
| CN106897340A (en) | A kind of data table updating method and device | |
| CN114004694A (en) | Public opinion information-based enterprise risk early warning method, equipment and medium | |
| CN115310944A (en) | Online ledger management method, system, device and medium | |
| CN115881106A (en) | Intelligent form filling method, equipment and medium based on multi-scene semantic analysis | |
| CN112330266A (en) | Document generation method, device and medium | |
| CN113239400A (en) | Asset management method, device and system and electronic equipment | |
| CN115982429B (en) | Knowledge management method and system based on flow control | |
| CN103778231A (en) | Method and system for managing operation record information, of databank | |
| CN111160681A (en) | Method, device and storage medium for evaluating user income level based on user income and expenditure data | |
| CN114997109A (en) | Receipt conversion method and device, computer equipment and storage medium | |
| CN110941952A (en) | Method and device for perfecting audit analysis model | |
| CN114138787A (en) | Bar code identification method, equipment and medium | |
| CN114564501A (en) | Database data storage and query methods, devices, equipment and medium | |
| CN110457332B (en) | Information processing method and related equipment | |
| CN109783559B (en) | Method and device for acquiring real estate transaction data, electronic equipment and storage medium | |
| CN111986009A (en) | Financial inquiry report generation method, device and medium based on elastic domain | |
| CN112613988A (en) | Method and device for generating credit investigation index information | |
| CN115496411A (en) | Method, device and medium for managing basic level data | |
| CN115496044A (en) | Online table data generation method, equipment and medium | |
| Aragabye et al. | Pivotal role of Information Communication Technology in Record and Archive Management | |
| CN115328919A (en) | Metadata management method, system, equipment and medium for primary treatment | |
| CN117033789A (en) | Method and device for determining service recommendation scheme, processor and electronic equipment | |
| CN116541396A (en) | Bill data processing method, device and system | |
| CN115426355A (en) | Method and device for generating push information, storage medium and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |