CN114356864A - Method and system for importing excel files in batch in domestic environment - Google Patents
Method and system for importing excel files in batch in domestic environment Download PDFInfo
- Publication number
- CN114356864A CN114356864A CN202111499905.4A CN202111499905A CN114356864A CN 114356864 A CN114356864 A CN 114356864A CN 202111499905 A CN202111499905 A CN 202111499905A CN 114356864 A CN114356864 A CN 114356864A
- Authority
- CN
- China
- Prior art keywords
- file
- service
- files
- import
- business
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a system for importing excel files in batches in a domestic environment, belongs to the technical field of electronic government affairs, and aims to solve the technical problem of how to solve the problems of low efficiency of data entry and large occupation of time of office workers in the current domestic office environment. The method comprises the following steps: establishing and exporting different file templates based on different service types in a service system, and establishing an association relation between the file templates and a database table based on the service types; selecting an adaptive file template according to different service scenes, and summarizing service data to fill the file template; classifying and storing the service files according to the service types, and storing the service files of the same type into corresponding folders; compressing the file folders after the processing; and importing the compressed folder into a business system for decompression and extracting business data based on the business scene, and storing the business data into a corresponding database table based on the incidence relation.
Description
Technical Field
The invention relates to the technical field of electronic government affairs, in particular to a method and a system for importing excel files in batches in a domestic environment.
Background
With the trend of informatization of electronic government offices, more and more various business data need to be input into an information system. At present, in a domestic office environment, a data entry method is common, and data to be imported is manually filled in by an office worker operating a corresponding service interface and then stored in an office system for further processing. When a large amount of data is encountered, office workers must manually and repeatedly enter the data, so that the operation speed is low, the efficiency is low, more time is occupied, and the aim of informatization of an office system is not met.
The technical problem to be solved is how to solve the phenomena and the defects that the data entry is low in efficiency and a large amount of office worker time is occupied under the current domestic office environment.
Disclosure of Invention
The technical task of the invention is to provide a method and a system for importing excel files in batches in a domestic environment aiming at the defects, so as to solve the technical problems of low efficiency of data entry and large occupation of time of office workers in the current domestic office environment.
In a first aspect, the method for importing excel files in bulk in a domestic environment of the present invention imports excel files in bulk into a service system based on a compressed package technology in a domestic office environment of a domestic CPU and OS, and the method includes the following steps:
establishing and exporting different file templates based on different service types in a service system, and establishing an association relation between the file templates and a database table based on the service types, wherein the file templates are in an Excel format;
selecting an adaptive file template according to different service scenes, and summarizing service data to fill the file template to obtain a service file;
classifying and storing the service files according to the service types, and storing the service files of the same type into corresponding folders to obtain sorted folders;
compressing the file folders after the file folders are arranged, so as to obtain compressed file folders;
and importing the compressed folder into a business system for decompression and extracting business data based on the business scene, and storing the business data into a corresponding database table based on the incidence relation.
Preferably, the files are compressed based on a preset compression mode;
and after the compressed folder is imported into a business system based on a business scene, judging whether the imported compressed file is a compressed file in a corresponding compression format, if so, decompressing the compressed file, keeping a directory structure before compression of the decompressed business file, and reading the business file through the POI according to the directory structure.
Preferably, the compressed file is imported into the business system by a WEB guide mode.
Preferably, in the process of importing the compressed files into the service system in batches, a batch import log is recorded, wherein the batch import log comprises the number of import records, the number of import success records, the number of import failure records and the failure reason.
In a second aspect, the system for importing excel files in bulk in a domestic environment of the present invention imports excel files in bulk into a service system by executing the method for importing excel files in bulk in a domestic environment according to any one of the first aspects, and the system for importing excel files in bulk comprises:
the template creating module is used for creating and exporting different file templates based on different service types in a service system, and establishing an association relation between the file templates and a database table based on the service types, wherein the file templates are in an Excel format;
the data filling module is used for selecting an adaptive file template according to different service scenes and summarizing service data to fill the file template to obtain a service file;
the compression module is used for compressing the files after being sorted to obtain compressed files;
the import module is used for importing the compressed folder into a business system for decompression and extracting business data based on a business scene, and storing the business data into a corresponding database table based on an incidence relation;
and the log importing module is used for recording a batch import log in the process of importing the compressed files into the service system in batches, wherein the batch import log comprises an import record number, an import success record number, an import failure record number and a failure reason.
Preferably, the compression module is configured with a preset compression mode and is used for compressing the files after being processed based on the preset compression mode;
the import module is used for judging whether the imported compressed file is a compressed file in a corresponding compression format or not after the compressed folder is imported into the business system based on the business scene, and if so, decompressing the compressed file, keeping a directory structure before compression of the decompressed business file, and reading the business file through the POI according to the directory structure.
Preferably, the import module is configured to import the compressed file into the business system by means of WEB guidance.
In a third aspect, the apparatus of the present invention comprises: at least one memory and at least one processor;
the at least one memory to store a machine readable program;
the at least one processor, configured to invoke the machine readable program to perform the method of any of claims 1 to 4.
In a fourth aspect, the computer readable medium of the present invention has stored thereon computer instructions which, when executed by a processor, cause the processor to perform the method of any one of claims 1 to 4.
The method and the import system for importing excel files in batches in the domestic environment have the following advantages:
(1) under a home-made operating system, based on a method for importing Excel format (suffix name is xls, xlsx, xlsm and etc) files in batches based on a compressed packet, office staff can directly export the Excel format files for generating corresponding service modules under a home-made environment, corresponding service data file templates are not required to be manually manufactured under a line, and the working intensity of the office staff is effectively reduced;
(2) under a home-made operating system, based on a method for importing Excel format (suffix name is xls, xlsx, xlsm and etc) files in batch by a compressed package, office staff can directly import the compressed package files in one key under a home-made environment so as to import the Excel format files in batch;
(3) under a home-made operating system, the invention is based on a method for importing a compressed package into Excel format (suffix name is xls, xlsx, xlsm and etc) files in batch, a system can generate a log file in the process of uploading the compressed package, and the log file can record import state and some basic information: the information comprises success information, failure reasons and the like, and the history is convenient to check;
(5) under the homemade operating system, the complete user autonomous operation is realized, extra guidance of an administrator is not needed, office workers can directly realize one-key import according to own business needs, the business data entry accuracy and the work efficiency of the office workers are improved, a large amount of time is saved, and the user experience is improved.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed for the embodiments or the prior art descriptions will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on the drawings without creative efforts.
The invention is further described below with reference to the accompanying drawings.
Fig. 1 is a block flow diagram of a method for importing excel files in bulk in a domestic environment in embodiment 1.
Detailed Description
The present invention is further described in the following with reference to the drawings and the specific embodiments so that those skilled in the art can better understand the present invention and can implement the present invention, but the embodiments are not to be construed as limiting the present invention, and the embodiments and the technical features of the embodiments can be combined with each other without conflict.
The embodiment of the invention provides a method and an importing system for importing excel files in batches in a domestic environment, which are used for solving the technical problems of low efficiency of data entry and large occupation of time of office workers in the current domestic office environment.
Example 1:
the method for importing the excel files in batch under the domestic environment of the invention imports the excel files in batch into a service system based on a compressed packet technology under the domestic office environment of a domestic CPU and OS.
The method comprises the following steps:
s100, creating and exporting different file templates based on different service types in a service system, and establishing an association relation between the file templates and a database table based on the service types, wherein the file templates are in an Excel format;
s200, selecting an adaptive file template according to different service scenes, summarizing service data, and filling the file template to obtain a service file;
s300, classifying and storing the service files according to the service types, and storing the service files of the same type into corresponding folders to obtain sorted folders;
s400, compressing the files after being sorted to obtain compressed files;
and S500, importing the compressed folder into a business system for decompression and extracting business data based on the business scene, and storing the business data into a corresponding database table based on the incidence relation.
In step S100 of this embodiment, an Excel format (suffix name is xls, xlsx, xlsm, etc.) template file is created and exported from a business system according to different business types, that is, a corresponding mapping relationship is established between data listed in an exported template file and attributes of configuration items, so as to obtain mapped data.
Step S200 uses different template files to summarize service data according to different service scenarios, i.e. filling template files according to different template data model rules.
And step S300, after the service data are summarized, the template files are classified and stored according to the service types, namely the template files of the same type are summarized and summarized into related folders.
Step S400 compresses the sorted folders to generate corresponding compressed files to be processed, i.e. the folders are compressed into final compressed files to be uploaded by using a compression tool, including but not limited to Zip format files.
Step S500 is to import the sorted compressed files according to the corresponding service attributes, the system will determine whether the uploaded files are files in the corresponding compressed format, if the determination is successful, the system will perform corresponding decompression and data reading according to the compressed package file format, that is, decompress the compressed files after being imported into the system, the decompressed files will maintain the directory structure before compression, then read the Excel format file template by using POI according to a certain directory structure, and store the data according to the column data mapping relationship. If the system judges that the uploaded file is not the required compressed file, the system prompts the end of the import process and prompts that the file format does not meet the requirements. When the compressed file is uploaded in the batch import process, the batch import log is recorded, and the batch import log comprises the number of import records, the number of import success records, the number of import failure records and the failure reason.
In this embodiment, the method for importing Excel files in bulk based on the compression package under the domestic CPU and the operating system is completed through a WEB-guided graphical interface.
The method of the embodiment can lead the excel files into the service system in batch. During specific execution, office staff firstly derive corresponding file templates according to the business attributes, classify and arrange the file templates after finishing data operation processing, then compress a certain number of files with the same business attributes, and finally perform one-key import operation according to the corresponding business attributes. The method greatly improves the business data entry accuracy and the working efficiency of office workers in a domestic environment and saves a large amount of time.
Example 2:
the invention relates to an import system for importing Excel files in batches in a domestic environment, which comprises a template creating module, a data filling module, a compression module, an import module and an import log module, wherein the template creating module is used for creating and exporting different file templates based on different service types in a service system, and establishing an association relation between the file templates and a database table based on the service types, and the file templates are in an Excel format; the data filling module is used for selecting an adaptive file template according to different service scenes, summarizing service data and filling the file template to obtain a service file; the compression module is used for compressing the files after being sorted to obtain compressed files; the import module is used for importing the compressed folder into a business system for decompression and extracting business data based on a business scene, and storing the business data into a corresponding database table based on an incidence relation; the import log module is used for recording a batch import log in the process of importing the compressed files into the service system in batches, wherein the batch import log comprises an import record number, an import success record number, an import failure record number and a failure reason.
In this embodiment, the compression module is configured with a preset compression method, and is configured to compress the sorted folders based on the preset compression method. Correspondingly, the import module is used for judging whether the imported compressed file is a compressed file in a corresponding compression format or not after the compressed folder is imported into the business system based on the business scene, and if so, decompressing the compressed file, keeping a directory structure before compression of the decompressed business file, and reading the business file through the POI according to the directory structure.
And the import module is used for importing the compressed files into the business system in a WEB guide mode.
The system of the present embodiment can perform the method disclosed in embodiment 1.
Example 3:
the apparatus of the present invention comprises: at least one memory and at least one processor;
the at least one memory to store a machine readable program;
the at least one processor is used for calling the machine readable program and executing the method disclosed in the embodiment 1.
Example 4:
a computer readable medium of the present invention, having computer instructions stored thereon, which, when executed by a processor, cause the processor to perform the method disclosed in embodiment 1. Specifically, a system or an apparatus equipped with a storage medium on which software program codes that realize the functions of any of the above-described embodiments are stored may be provided, and a computer (or a CPU or MPU) of the system or the apparatus is caused to read out and execute the program codes stored in the storage medium.
In this case, the program code itself read from the storage medium can realize the functions of any of the above-described embodiments, and thus the program code and the storage medium storing the program code constitute a part of the present invention.
Examples of the storage medium for supplying the program code include a floppy disk, a hard disk, a magneto-optical disk, an optical disk (e.g., CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-RAM, DVD-RW, DVD + RW), a magnetic tape, a nonvolatile memory card, and a ROM. Alternatively, the program code may be downloaded from a server computer via a communications network.
Further, it should be clear that the functions of any one of the above-described embodiments may be implemented not only by executing the program code read out by the computer, but also by causing an operating system or the like operating on the computer to perform a part or all of the actual operations based on instructions of the program code.
Further, it is to be understood that the program code read out from the storage medium is written to a memory provided in an expansion board inserted into the computer or to a memory provided in an expansion unit connected to the computer, and then causes a CPU or the like mounted on the expansion board or the expansion unit to perform part or all of the actual operations based on instructions of the program code, thereby realizing the functions of any of the above-described embodiments.
It should be noted that not all steps and modules in the above flows and system structure diagrams are necessary, and some steps or modules may be omitted according to actual needs. The execution order of the steps is not fixed and can be adjusted as required. The system structure described in the above embodiments may be a physical structure or a logical structure, that is, some modules may be implemented by the same physical entity, or some modules may be implemented by a plurality of physical entities, or some components in a plurality of independent devices may be implemented together.
In the above embodiments, the hardware unit may be implemented mechanically or electrically. For example, a hardware element may comprise permanently dedicated circuitry or logic (such as a dedicated processor, FPGA or ASIC) to perform the corresponding operations. The hardware elements may also comprise programmable logic or circuitry, such as a general purpose processor or other programmable processor, that may be temporarily configured by software to perform the corresponding operations. The specific implementation (mechanical, or dedicated permanent, or temporarily set) may be determined based on cost and time considerations.
While the invention has been shown and described in detail in the drawings and in the preferred embodiments, it is not intended to limit the invention to the embodiments disclosed, and it will be apparent to those skilled in the art that various combinations of the code auditing means in the various embodiments described above may be used to obtain further embodiments of the invention, which are also within the scope of the invention.
Claims (9)
1. A method for importing excel files in batch in a domestic environment is characterized in that the excel files are imported into a service system in batch based on a compressed package technology in the domestic office environment of a domestic CPU and an OS, and the method comprises the following steps:
establishing and exporting different file templates based on different service types in a service system, and establishing an association relation between the file templates and a database table based on the service types, wherein the file templates are in an Excel format;
selecting an adaptive file template according to different service scenes, and summarizing service data to fill the file template to obtain a service file;
classifying and storing the service files according to the service types, and storing the service files of the same type into corresponding folders to obtain sorted folders;
compressing the file folders after the file folders are arranged, so as to obtain compressed file folders;
and importing the compressed folder into a business system for decompression and extracting business data based on the business scene, and storing the business data into a corresponding database table based on the incidence relation.
2. The method for importing excel files in batches in a domestic environment according to claim 1, characterized in that the folders after being managed are compressed based on a preset compression mode;
and after the compressed folder is imported into a business system based on a business scene, judging whether the imported compressed file is a compressed file in a corresponding compression format, if so, decompressing the compressed file, keeping a directory structure before compression of the decompressed business file, and reading the business file through the POI according to the directory structure.
3. The method for importing excel files in bulk under domestic environment according to claim 1, characterized in that compressed files are imported into a business system by means of WEB booting.
4. The method for importing excel files in bulk under the domestic environment according to any one of claims 1 to 3, wherein in the process of importing the compressed files into the service system in bulk, a bulk import log is recorded, and the bulk import log comprises an import record number, an import success record number, an import failure record number and a failure reason.
5. An import system for importing excel files in bulk in a domestic environment, characterized in that the excel files are imported in bulk into a service system by executing the method for importing excel files in bulk in a domestic environment according to any one of claims 1 to 4, the import system comprising:
the template creating module is used for creating and exporting different file templates based on different service types in a service system, and establishing an association relation between the file templates and a database table based on the service types, wherein the file templates are in an Excel format;
the data filling module is used for selecting an adaptive file template according to different service scenes and summarizing service data to fill the file template to obtain a service file;
the compression module is used for compressing the files after being sorted to obtain compressed files;
the import module is used for importing the compressed folder into a business system for decompression and extracting business data based on a business scene, and storing the business data into a corresponding database table based on an incidence relation;
and the log importing module is used for recording a batch import log in the process of importing the compressed files into the service system in batches, wherein the batch import log comprises an import record number, an import success record number, an import failure record number and a failure reason.
6. The import system for importing excel files in batches in the domestic environment according to claim 5, wherein the compression module is configured with a preset compression mode for compressing the managed folders based on the preset compression mode;
the import module is used for judging whether the imported compressed file is a compressed file in a corresponding compression format or not after the compressed folder is imported into the business system based on the business scene, and if so, decompressing the compressed file, keeping a directory structure before compression of the decompressed business file, and reading the business file through the POI according to the directory structure.
7. The import system for importing excel files in bulk under domestic environment according to claim 5, wherein the import module is configured to import the compressed files into the business system by means of WEB booting.
8. An apparatus, comprising: at least one memory and at least one processor;
the at least one memory to store a machine readable program;
the at least one processor, configured to invoke the machine readable program to perform the method of any of claims 1 to 4.
9. Computer readable medium, characterized in that it has stored thereon computer instructions which, when executed by a processor, cause the processor to carry out the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111499905.4A CN114356864A (en) | 2021-12-09 | 2021-12-09 | Method and system for importing excel files in batch in domestic environment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111499905.4A CN114356864A (en) | 2021-12-09 | 2021-12-09 | Method and system for importing excel files in batch in domestic environment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114356864A true CN114356864A (en) | 2022-04-15 |
Family
ID=81097405
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111499905.4A Pending CN114356864A (en) | 2021-12-09 | 2021-12-09 | Method and system for importing excel files in batch in domestic environment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114356864A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115495499A (en) * | 2022-09-22 | 2022-12-20 | 生态环境部南京环境科学研究所 | Integration statistical method based on mass data of same medium in multiple batches in polluted site |
| CN116307663A (en) * | 2023-02-16 | 2023-06-23 | 广州力麒智能科技有限公司 | Intelligent self-service government affair service system, government affair service general method and terminal |
-
2021
- 2021-12-09 CN CN202111499905.4A patent/CN114356864A/en active Pending
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115495499A (en) * | 2022-09-22 | 2022-12-20 | 生态环境部南京环境科学研究所 | Integration statistical method based on mass data of same medium in multiple batches in polluted site |
| CN115495499B (en) * | 2022-09-22 | 2023-05-30 | 生态环境部南京环境科学研究所 | Integrated statistical method based on contaminated site same-medium multi-batch mass data |
| CN116307663A (en) * | 2023-02-16 | 2023-06-23 | 广州力麒智能科技有限公司 | Intelligent self-service government affair service system, government affair service general method and terminal |
| CN116307663B (en) * | 2023-02-16 | 2023-09-08 | 广州力麒智能科技有限公司 | Intelligent self-service government affair service system, government affair service general method and terminal |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN114356864A (en) | Method and system for importing excel files in batch in domestic environment | |
| CN113079072B (en) | Vehicle data acquisition method and system, computer equipment and storage medium | |
| CN109901888B (en) | Design method of automatic configuration file generation tool | |
| CN111400246B (en) | Asynchronous file import method, device, computer equipment and storage medium | |
| CN111367976A (en) | Method and device for exporting EXCEL file data based on JAVA reflection mechanism | |
| CN113672204A (en) | Interface document generation method, system, electronic equipment and storage medium | |
| CN111143434A (en) | Intelligent data checking method, device, equipment and storage medium | |
| CN110022287A (en) | A kind of asynchronous distributed document transmission method, terminal device and storage medium | |
| CN112765112A (en) | Installation package packing and unpacking method | |
| CN112765270A (en) | Block chain data processing method and device, computer equipment and medium | |
| WO2023116104A1 (en) | Configuration parameter updating method and apparatus, and related device | |
| CN113934710B (en) | Data acquisition method and device | |
| CN111324645A (en) | Data processing method and device for block chain | |
| CN114895880A (en) | Code generation method and device and computer readable medium | |
| WO2021087662A1 (en) | Memory allocation method and apparatus, terminal, and computer readable storage medium | |
| CN110334047B (en) | System and method for collecting equipment data, frequency converter and computer readable medium | |
| CN114154020A (en) | Large-capacity data processing method and device based on dynamic label mapping | |
| CN108415814B (en) | Method for automatically recording field change, application server and computer readable storage medium | |
| CN112202873B (en) | Data issuing method and device, computer and computer readable medium | |
| CN111444194A (en) | Method, device and equipment for clearing indexes in block chain type account book | |
| CN102347772B (en) | Compression processing method and equipment for base station files | |
| WO2011020259A1 (en) | Method for users to self-define fonts | |
| CN112052026B (en) | Method and device for determining interaction relation between systems | |
| CN116305309A (en) | Seal application system and method based on online template | |
| CN115827565A (en) | Method for transmitting, storing and applying dynamic type data |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230306 Address after: S02 Building, 1036 Langchao Road, High-tech Zone, Jinan, Shandong Province, 250000 Applicant after: INSPUR GROUP Co.,Ltd. Address before: 250100 No. 1036 Tidal Road, Jinan High-tech Zone, Shandong Province, S01 Building, Tidal Science Park Applicant before: Inspur cloud Information Technology Co.,Ltd. |
|
| TA01 | Transfer of patent application right |