CN114090672A - Business data import and export method, system, computer equipment and medium - Google Patents
Business data import and export method, system, computer equipment and medium Download PDFInfo
- Publication number
- CN114090672A CN114090672A CN202111394635.0A CN202111394635A CN114090672A CN 114090672 A CN114090672 A CN 114090672A CN 202111394635 A CN202111394635 A CN 202111394635A CN 114090672 A CN114090672 A CN 114090672A
- Authority
- CN
- China
- Prior art keywords
- data
- business
- model
- excel
- export
- 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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44505—Configuring for program initiating, e.g. using registry, configuration files
- G06F9/4451—User profiles; Roaming
Abstract
The invention provides a business data import/export method, a system, computer equipment and a medium, wherein the method comprises the steps of establishing an Excel data model corresponding to a business model, respectively obtaining business data to be imported/exported, a business model to be imported/exported and the Excel data model according to business data import and export requests, and integrating the business data to be imported/exported according to the business model to be imported/exported and the Excel data model to generate a business import/export file. The method and the system have the advantages that the business data are quickly converted into the compact and normalized Excel model data through the user-defined data model and the business model to generate the import and export file, the universality and the expansibility are high, the performance problem of business data batch import and export can be effectively solved, the requirements of enterprise system Excel data batch query and database insertion are met, the user experience is improved, and meanwhile, the enterprise labor cost is effectively saved.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a service data import and export method and system based on an Excel data model, computer equipment and a storage medium.
Background
Excel files are widely used in various industries because of the convenience in making various electronic forms and the advantage of supporting formula functions to effectively process data in the forms. In addition, for companies with more business data, a large amount of business data is often imported and exported, so that the business data in the Excel file is imported into the enterprise system database for statistics and query, or the queried business data content is exported from the enterprise system database for use.
At present, when a service data file is imported and exported in the prior art, a generated service modeling import and export function interface needs to be modified to support the application of a complex service data scene (service data needs to be calculated), and a performance problem exists due to slow system response caused by the fact that the amount of service data needing to be imported and exported is too large (tens of millions).
Disclosure of Invention
The invention aims to provide a business data import and export method based on an Excel data model, which can effectively solve the performance problem of business data import and export in batch of business databases by quickly converting Excel files and data models into Excel model data and combining the business model data to conveniently, concisely and standardly generate Excel files, and meet the requirements of enterprise system Excel data batch query and database insertion, thereby saving the enterprise labor cost.
In order to achieve the above object, it is necessary to provide a method, a system, a computer device and a storage medium for importing and exporting business data in response to the above technical problems.
In a first aspect, an embodiment of the present invention provides a method for importing and exporting service data, where the method includes the following steps:
according to the business modeling requirements, creating an Excel data model corresponding to the business model;
responding and analyzing a service data import request to obtain service data to be imported, a service model to be imported and an Excel data model, integrating the service data to be imported according to the service model to be imported and the Excel data model to generate a service import file, and storing the service import file in a database;
responding and analyzing a business data export request to obtain business data to be exported, a business model to be exported and an Excel data model, integrating the business data to be exported according to the business model to be exported and the Excel data model to generate a business export file, and returning export address information of the business export file.
Further, the Excel data model is used for defining a business data import rule and a business data export rule, and carrying out analysis conversion on the business model according to the business data import rule or the business data export rule.
Further, the step of creating an Excel data model corresponding to the business model according to the business modeling requirement includes:
according to the business modeling requirement, a corresponding Excel template file is configured in advance;
responding to a request for creating an Excel data model, loading the Excel template file, and generating a corresponding Excel data model;
and storing the Excel data model in the database.
Further, the step of creating an Excel data model corresponding to the business model according to the business modeling requirement includes:
setting a sheet workbook title and a worksheet list title according to the business modeling requirement;
responding to a request for creating an Excel data model, and generating a corresponding Excel data model according to the sheet workbook title and the worksheet list title;
and storing the Excel data model in the database.
Further, the step of creating an Excel data model corresponding to the business model according to the business modeling requirement comprises:
acquiring a corresponding business data relation table according to the business modeling requirement;
responding to a request for creating an Excel data model, and generating a corresponding Excel data model according to the business data relation table;
and storing the Excel data model in the database.
Further, the step of responding and analyzing the service data import request to obtain service data to be imported, a service model to be imported and an Excel data model, and generating a service import file by integrating the service data to be imported according to the service model to be imported and the Excel data model comprises:
analyzing the business data import request to obtain business data to be imported and the type of the business data to be imported;
obtaining a corresponding business model to be imported according to the business data to be imported and the type of the business data to be imported;
inquiring a database according to the service model to be imported to obtain the corresponding Excel data model;
analyzing and converting the to-be-imported service model by adopting the Excel data model according to a service data import rule to generate a data import template;
and importing the service data to be imported into the data import template to generate the service import file.
Further, the step of responding and analyzing the service data export request to obtain the service data to be exported, the service model to be exported and the Excel data model, and integrating the service data to be exported according to the service model to be exported and the Excel data model to generate a service export file comprises:
analyzing the business data export request to obtain the type of the business data to be exported;
obtaining a corresponding business model to be exported according to the type of the business data to be exported;
inquiring a database according to the business model to be exported to obtain the corresponding Excel data model and the business data to be exported;
according to a business data export rule, adopting the Excel data model to carry out analysis conversion on the business model to be exported to generate a data export template;
and importing the service data to be exported into the data export template to generate the service export file.
In a second aspect, an embodiment of the present invention provides a service data import/export system, where the system includes:
the model creating module is used for creating an Excel data model corresponding to the business model according to business modeling requirements;
the data import module is used for responding and analyzing a service data import request to obtain service data to be imported, a service model to be imported and an Excel data model, integrating the service data to be imported according to the service model to be imported and the Excel data model to generate a service import file, and storing the service import file in a database;
and the data export module is used for responding and analyzing the business data export request to obtain business data to be exported, a business model to be exported and an Excel data model, integrating the business data to be exported according to the business model to be exported and the Excel data model to generate a business export file, and returning export address information of the business export file.
In a third aspect, an embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor implements the steps of the method when executing the computer program.
In a fourth aspect, the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program is executed by a processor to implement the steps of the above method.
The application provides a business data import and export method, a business data import and export system, computer equipment and a storage medium, and by the method, the technical scheme that an Excel data model corresponding to a business model is created according to business modeling requirements, the business data to be imported, the business model to be imported and the Excel data model are obtained through analysis in response to a business data import request, the business data to be imported, the business model to be imported and the Excel data model are integrated according to the business model to be imported and the Excel data model to generate a business import file and are stored in a database, the business data to be exported, the business model to be exported and the Excel data model are obtained through analysis in response to the business data export request, the business data to be exported are integrated according to the business model to be exported and the Excel data model to be exported to generate a business export file, and corresponding export address information is returned. Compared with the prior art, the Excel file and the data model are quickly converted into Excel model data, and the Excel file is conveniently, concisely and standardly generated by combining the service model data, so that the Excel file has stronger universality and expansibility, the performance problem of batch import and export of service data into and out of the service database can be effectively solved, the requirements of batch query and database insertion of Excel data of an enterprise system are met, the user experience is improved, and the labor cost of an enterprise is effectively saved.
Drawings
Fig. 1 is a schematic flow chart of a service data import/export method according to an embodiment of the present invention;
fig. 2 is a schematic flow chart of the service data import in step S12 in fig. 1;
fig. 3 is a schematic flow chart of the service data import in step S13 in fig. 1;
fig. 4 is a schematic structural diagram of a service data import and export system in an embodiment of the present invention;
fig. 5 is an internal structural diagram of a computer device in the embodiment of the present invention.
Detailed Description
In order to make the purpose, technical solution and advantages of the present invention more clearly apparent, the present invention is further described in detail below with reference to the accompanying drawings and embodiments, and it is obvious that the embodiments described below are part of the embodiments of the present invention, and are used for illustrating the present invention only, but not for limiting the scope of the present invention. All other embodiments, which can be obtained by a person skilled in the art without inventive step based on the embodiments of the present invention, are within the scope of protection of the present invention.
The business data import and export method provided by the invention is suitable for enterprise systems with overlarge business data volume and batch business data import and export requirements, such as scenes that equipment information of the internet of things needs to be imported into a database in a large batch, or the equipment information of the internet of things needs to be exported from the database into an Excel file in a large batch, and the like. The method adapts the import and export of all service data in the system in a self-defined Excel data model mode, so that a system user can meet the requirements of system Excel data batch query and database insertion only by simple configuration, the method has stronger universality and expansibility, can effectively solve the performance problem of business data batch import and export of the service database, improves the user experience, and further saves the enterprise labor cost. The following embodiments will explain the service data import/export method of the present invention in detail.
In one embodiment, as shown in fig. 1, a method for importing and exporting service data is provided, which includes the following steps:
s11, creating an Excel data model corresponding to the business model according to the business modeling requirement;
the service model can be understood as a relation model between service data obtained by screening, combining and calculating the service data, can be automatically created according to table structure management provided in a system, is a link for realizing import and export functions, processes the service data depending on a logic algorithm provided by an Excel data model, dynamically generates Excel file contents or reads the Excel file contents for downloading the service data import and export functions and the Excel file, and a specific construction method of the service model can be realized by adopting the prior art, and is not particularly limited herein.
The Excel data model is a data model which is used for defining a business data import rule and a business data export rule, analyzing and converting the business model according to the business data import rule or the business data export rule and butting with an Excel file template. The business data import rule and the business data export rule can be understood as the format of the business data, the combination relationship between the data, the calculation formula required by data processing, and the like. Specifically, the method for creating the Excel data model can be divided into the following three types:
(1) configuring an Excel template file according to requirements, directly reading the content of the Excel template file to generate an Excel data model, and specifically comprising the following steps:
according to the business modeling requirement, a corresponding Excel template file is configured in advance;
responding to a request for creating an Excel data model, loading the Excel template file, and generating a corresponding Excel data model;
and storing the Excel data model in the database.
(2) A user generates an Excel data model by adding sheet data, Excel column header data and the like of an Excel file on a system configuration page in a self-defined mode, and the method specifically comprises the following steps:
setting a sheet workbook title and a worksheet list title according to the business modeling requirement;
responding to a request for creating an Excel data model, and generating a corresponding Excel data model according to the sheet workbook title and the worksheet list title;
and storing the Excel data model in the database.
A user automatically generates Excel data for modeling through a self-contained table structure management function in the system, and the method specifically comprises the following steps:
acquiring a corresponding business data relation table according to the business modeling requirement;
responding to a request for creating an Excel data model, and generating a corresponding Excel data model according to the business data relation table;
and storing the Excel data model in the database.
S12, responding and analyzing a service data import request to obtain service data to be imported, a service model to be imported and an Excel data model, integrating the service data to be imported according to the service model to be imported and the Excel data model to generate a service import file, and storing the service import file in a database;
before the service data import request is sent, a user needs to send an upload file request on a system import data page, that is, after a background file address to which service data fed back by the system needs to be uploaded is obtained, the user initiates the service data import request according to the background file address. After receiving the corresponding business data import request, analyzing the data import request, acquiring the business data to be imported and the corresponding business data type, inquiring to obtain a business model and an Excel data model for integrating the business data, processing the business data to be imported based on the business model and the Excel data model, and generating a business import file. Specifically, as shown in fig. 2, the step S12 of responding and analyzing the service data import request to obtain service data to be imported, a service model to be imported, and an Excel data model, and performing integration processing on the service data to be imported according to the service model to be imported and the Excel data model to generate a service import file includes:
s121, analyzing the service data import request to obtain service data to be imported and a service data type to be imported;
the type of the service data to be imported can be obtained by analyzing the service data import request, and different service data types correspond to different service models.
S122, obtaining a corresponding business model to be imported according to the business data to be imported and the type of the business data to be imported;
the service model to be imported can be understood as a service model which is matched with the type of the service data to be imported and is created in advance according to service modeling requirements, and can be inquired and obtained according to the actual type of the imported service data.
S123, inquiring a database according to the service model to be imported to obtain the corresponding Excel data model;
after the Excel data model is created by the method steps, the Excel data model is stored in system data for subsequent data import and export, a pairing relation exists between the Excel data model and the service model and between the Excel data model and the service data type, and the Excel data model which can be analyzed and converted by a user can be inquired and obtained according to the service model to be imported, wherein the service model to be imported is required to be used.
S124, according to a business data import rule, analyzing and converting the to-be-imported business model by adopting the Excel data model to generate a data import template;
the data import template can be understood as an SQL (structured query language) file used by the database, and the SQL file needs to be filled with the to-be-imported service data filled with the model data obtained by converting the to-be-imported service model according to the Excel data model. In this embodiment, the process of analyzing and converting the service model to be imported by using the Excel data model may be understood as mapping the participation Excel data model of the service model to be imported, and freely matching the participation relation between the Excel data model and the service model to be imported.
And S125, importing the service data to be imported into the data import template to generate the service import file.
In the embodiment, the mode that the Excel data model is adopted to analyze and convert the service model to be imported to import the service data is adopted, and the service model to be imported is multiplexed to realize that batch service data is efficiently and quickly inserted into the database.
S13, responding and analyzing the business data export request to obtain business data to be exported, a business model to be exported and an Excel data model, integrating the business data to be exported according to the business model to be exported and the Excel data model to generate a business export file, and returning export address information of the business export file.
The business data export request is sent by a user on a system export data page, after the system background receives the corresponding business data export request, the data export request is firstly analyzed, the corresponding business data type to be exported is obtained, a business model and an Excel data model used for integrating the business data to be exported are obtained through inquiry, the business data to be exported are processed based on the business model and the Excel data model, and a business export file is generated. Specifically, as shown in fig. 3, the step S13 of responding and analyzing the service data export request to obtain service data to be exported, a service model to be exported, and an Excel data model, and performing integration processing on the service data to be exported according to the service model to be exported and the Excel data model to generate a service export file includes:
s131, analyzing the business data exporting request to obtain the type of the business data to be exported;
s132, obtaining a corresponding business model to be exported according to the type of the business data to be exported;
s133, inquiring a database according to the service model to be exported to obtain the corresponding Excel data model and the service data to be exported;
the business data to be exported is business data which is imported and stored in the database before, and can be inquired and acquired from the database according to the corresponding business data export request.
S134, according to a business data exporting rule, adopting the Excel data model to carry out analysis conversion on the business model to be exported to generate a data exporting template;
the data export template can be understood as a service data Excel template meeting a certain model rule, and corresponding format conversion or data processing can be performed on the obtained service data to be exported so as to generate an export file meeting service requirements. In this embodiment, the process of analyzing and converting the service model to be exported by using the Excel data model may be understood as mapping the participation Excel data model of the service model to be exported, and freely matching the participation relation between the Excel data model and the service model to be exported, that is, the batch service data can be efficiently and quickly exported from the database by multiplexing the service model to be exported.
And S135, importing the service data to be exported into the data export template to generate the service export file.
According to the method, the Excel data model corresponding to the service model is created, the service data to be imported/exported, the service model to be imported/exported and the Excel data model which are obtained according to the service data import and export requests are respectively adopted, and the service data to be imported/exported is integrated according to the service model to be imported/exported and the Excel data model to generate the service import/export file, so that the Excel file and the data model are quickly converted into Excel model data, the Excel file is conveniently, compactly and standardly generated by combining the service model, the service data are efficiently and quickly imported/exported into the database in batches by multiplexing the service model and the Excel data model, the method has the advantages of strong universality and expansibility, the performance problem of batch import and export of the existing service data into the database can be effectively solved, and the user experience can be improved, The labor cost of enterprises is saved.
It should be noted that, although the steps in the above-described flowcharts are shown in sequence as indicated by arrows, the steps are not necessarily executed in sequence as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise.
In one embodiment, as shown in fig. 4, a service data import and export system is provided, which includes:
the model creating module 1 is used for creating an Excel data model corresponding to the business model according to business modeling requirements;
the data import module 2 is used for responding and analyzing a service data import request to obtain service data to be imported, a service model to be imported and an Excel data model, integrating the service data to be imported according to the service model to be imported and the Excel data model to generate a service import file, and storing the service import file in a database;
and the data export module 3 is used for responding and analyzing the business data export request to obtain business data to be exported, a business model to be exported and an Excel data model, integrating the business data to be exported according to the business model to be exported and the Excel data model to generate a business export file, and returning export address information of the business export file.
It should be noted that, for specific limitations of the service data import and export system, reference may be made to the above limitations on the service data import and export method, which is not described herein again. All or part of each module in the service data import and export system can be realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
Fig. 5 shows an internal structure diagram of a computer device in one embodiment, and the computer device may be a terminal or a server. As shown in fig. 5, the computer apparatus includes a processor, a memory, a network interface, a display, and an input device, which are connected through a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a business data import and export method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those of ordinary skill in the art that the architecture shown in FIG. 5 is a block diagram of only a portion of the architecture associated with the subject application, and is not intended to limit the computing devices to which the subject application may be applied, as a particular computing device may include more or less components than those shown in the figures, or a combination of certain components, or an arrangement of components in common.
In one embodiment, a computer device is provided, comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the steps of the above method being performed when the computer program is executed by the processor.
In an embodiment, a computer-readable storage medium is provided, on which a computer program is stored, which computer program, when being executed by a processor, carries out the steps of the above-mentioned method.
In summary, the business data import and export method, system, computer device and storage medium provided by the embodiments of the present invention realizes a technical solution of creating an Excel data model corresponding to a business model according to business modeling requirements, parsing to obtain business data to be imported, the business model to be imported and the Excel data model in response to a business data import request, integrating the business data to be imported according to the business model to be imported and the Excel data model to generate a business import file and storing the business import file in a database, parsing to obtain the business data to be exported, the business model to be exported and the Excel data model in response to the business data export request, integrating the business data to be exported according to the business model to be exported and the Excel data model to generate a business export file and returning corresponding export address information, and rapidly converting the Excel file and the data model into Excel model data, the Excel file is conveniently, concisely and normatively generated by combining the service model data, so that the method has stronger universality and expansibility, can effectively solve the performance problem of batch import and export of the service data into and out of the service database, meets the requirements of batch query and database insertion of Excel data of an enterprise system, and effectively saves the labor cost of enterprises while improving the user experience.
The embodiments in this specification are described in a progressive manner, and all the same or similar parts of the embodiments are directly referred to each other, and each embodiment is described with emphasis on differences from other embodiments. In particular, for the system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment. It should be noted that, the technical features of the embodiments may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express some preferred embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for those skilled in the art, various modifications and substitutions can be made without departing from the technical principle of the present invention, and these should be construed as the protection scope of the present application. Therefore, the protection scope of the present patent application shall be subject to the protection scope of the claims.
Claims (10)
1. A method for importing and exporting service data, the method comprising the steps of:
according to the business modeling requirements, creating an Excel data model corresponding to the business model;
responding and analyzing a service data import request to obtain service data to be imported, a service model to be imported and an Excel data model, integrating the service data to be imported according to the service model to be imported and the Excel data model to generate a service import file, and storing the service import file in a database;
responding and analyzing a business data export request to obtain business data to be exported, a business model to be exported and an Excel data model, integrating the business data to be exported according to the business model to be exported and the Excel data model to generate a business export file, and returning export address information of the business export file.
2. The business data import and export method according to claim 1, wherein the Excel data model is used to define business data import rules and business data export rules, and the business model is parsed and converted according to the business data import rules or the business data export rules.
3. The business data import/export method according to claim 1, wherein the step of creating an Excel data model corresponding to the business model according to the business modeling requirement comprises:
according to the business modeling requirement, a corresponding Excel template file is configured in advance;
responding to a request for creating an Excel data model, loading the Excel template file, and generating a corresponding Excel data model;
and storing the Excel data model in the database.
4. The business data import/export method according to claim 1, wherein the step of creating an Excel data model corresponding to the business model according to the business modeling requirement comprises:
setting a sheet workbook title and a worksheet list title according to the business modeling requirement;
responding to a request for creating an Excel data model, and generating a corresponding Excel data model according to the sheet workbook title and the worksheet list title;
and storing the Excel data model in the database.
5. The business data import/export method according to claim 1, wherein the step of creating an Excel data model corresponding to the business model according to the business modeling requirements comprises:
acquiring a corresponding business data relation table according to the business modeling requirement;
responding to a request for creating an Excel data model, and generating a corresponding Excel data model according to the business data relation table;
and storing the Excel data model in the database.
6. The method for importing and exporting business data according to claim 2, wherein the step of responding and analyzing the business data importing request to obtain the business data to be imported, the business model to be imported and the Excel data model, and generating the business importing file by integrating the business data to be imported according to the business model to be imported and the Excel data model comprises:
analyzing the business data import request to obtain business data to be imported and the type of the business data to be imported;
obtaining a corresponding business model to be imported according to the business data to be imported and the type of the business data to be imported;
inquiring a database according to the service model to be imported to obtain the corresponding Excel data model;
analyzing and converting the to-be-imported service model by adopting the Excel data model according to a service data import rule to generate a data import template;
and importing the service data to be imported into the data import template to generate the service import file.
7. The business data import/export method according to claim 2, wherein the step of responding to and analyzing the business data export request to obtain the business data to be exported, the business model to be exported, and the Excel data model, and generating the business export file by integrating the business data to be exported according to the business model to be exported and the Excel data model comprises:
analyzing the business data export request to obtain the type of the business data to be exported;
obtaining a corresponding business model to be exported according to the type of the business data to be exported;
inquiring a database according to the business model to be exported to obtain the corresponding Excel data model and the business data to be exported;
according to a business data export rule, adopting the Excel data model to analyze and convert the business model to be exported to generate a data export template;
and importing the business data to be exported into the data export template to generate the business export file.
8. A service data import/export system, comprising:
the model creating module is used for creating an Excel data model corresponding to the business model according to business modeling requirements;
the data import module is used for responding and analyzing a service data import request to obtain service data to be imported, a service model to be imported and an Excel data model, integrating the service data to be imported according to the service model to be imported and the Excel data model to generate a service import file, and storing the service import file in a database;
and the data export module is used for responding and analyzing the business data export request to obtain business data to be exported, a business model to be exported and an Excel data model, integrating the business data to be exported according to the business model to be exported and the Excel data model to generate a business export file, and returning export address information of the business export file.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method of any of claims 1 to 7 are implemented when the computer program is executed by the processor.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111394635.0A CN114090672A (en) | 2021-11-23 | 2021-11-23 | Business data import and export method, system, computer equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111394635.0A CN114090672A (en) | 2021-11-23 | 2021-11-23 | Business data import and export method, system, computer equipment and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114090672A true CN114090672A (en) | 2022-02-25 |
Family
ID=80303567
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111394635.0A Pending CN114090672A (en) | 2021-11-23 | 2021-11-23 | Business data import and export method, system, computer equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114090672A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117056337A (en) * | 2023-08-15 | 2023-11-14 | 湖南企企通科技有限公司 | Service data sorting method, device, equipment and medium |
| CN117520432A (en) * | 2023-11-30 | 2024-02-06 | 广州方舟信息科技有限公司 | Template-based data transmission method, device, equipment and storage medium |
-
2021
- 2021-11-23 CN CN202111394635.0A patent/CN114090672A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117056337A (en) * | 2023-08-15 | 2023-11-14 | 湖南企企通科技有限公司 | Service data sorting method, device, equipment and medium |
| CN117520432A (en) * | 2023-11-30 | 2024-02-06 | 广州方舟信息科技有限公司 | Template-based data transmission method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108519967B (en) | Chart visualization method and device, terminal and storage medium | |
| CN108021710B (en) | Dynamic interface conversion method, device, terminal equipment and storage medium | |
| CN110162544B (en) | Heterogeneous data source data acquisition method and device | |
| CN114090672A (en) | Business data import and export method, system, computer equipment and medium | |
| CN110351325B (en) | Data processing method and related equipment | |
| US10516791B2 (en) | Information processing system, information processing apparatus, and information processing method for executing an iteration of one or more processes | |
| CN110557284A (en) | data aggregation method and device based on client gateway | |
| EP3279816A1 (en) | Data analysis processing method, apparatus, computer device, and storage medium | |
| US20200204688A1 (en) | Picture book sharing method and apparatus and system using the same | |
| CN111694572A (en) | Code format conversion method, device, computer equipment and storage medium | |
| CN111782652B (en) | Data calling method, device, computer equipment and storage medium | |
| CN112256772A (en) | Data service method, device and readable storage medium | |
| CN111818175A (en) | Enterprise service bus configuration file generation method, device, equipment and storage medium | |
| CN111901383B (en) | Data request processing method, device, computer equipment and storage medium | |
| CN109871354B (en) | File processing method and device | |
| CN116594958A (en) | Graph dataset loading method, system, electronic device and medium | |
| CN116303622A (en) | Database query method, device, equipment and storage medium | |
| CN110888901B (en) | System management method, device, computer equipment and storage medium | |
| CN113742385A (en) | Data query method and device | |
| CN112118136B (en) | Multi-cloud configuration conversion method and device, computer equipment and storage medium | |
| CN112835573A (en) | Data query method and device, electronic equipment and storage medium | |
| CN109814916B (en) | IVR flow configuration method, device, storage medium and server | |
| CN114358596A (en) | Index calculation method and device | |
| CN114218904A (en) | Configurable report export design method and system | |
| CN113965599A (en) | Equipment management system and method based on universal management service model |
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 |