CN113642308B - Data import method, system, device and storage medium based on data variability - Google Patents
Data import method, system, device and storage medium based on data variability Download PDFInfo
- Publication number
- CN113642308B CN113642308B CN202111005671.3A CN202111005671A CN113642308B CN 113642308 B CN113642308 B CN 113642308B CN 202111005671 A CN202111005671 A CN 202111005671A CN 113642308 B CN113642308 B CN 113642308B
- Authority
- CN
- China
- Prior art keywords
- import
- data
- file
- initial
- mode
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Artificial Intelligence (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Human Computer Interaction (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a data import method, a system, equipment and a storage medium based on data variability, wherein the method comprises the following steps: determining a data import mode, wherein the data import mode comprises basic import and advanced import; acquiring a data import template, transmitting information in a material table to the import template according to a field check rule, and acquiring an initial import file; uploading the initial import file according to the data import mode; according to the data import mode, carrying out data verification on the initial import file, and displaying a verification result; modifying the initial import file according to the verification result and the data import mode to obtain a target import file; and carrying out data import according to the target import file, and displaying an import result. The method and the device can select the data importing mode according to actual needs, meet different requirements of customers while improving the data importing efficiency, and improve the user experience.
Description
Technical Field
The invention relates to the technical field of industrial internet, in particular to a data import method, a data import system, data import equipment and a storage medium based on data variability.
Background
The industrial internet platform is an industrial cloud platform, is a module system for acquiring, storing, analyzing and applying industrial data based on application requirements, and is used for assisting industrial production, improving the efficiency of industrial production and reducing the industrial management cost. The premise for guiding industrial production and management by data analysis is that a data base exists, for example, when material management of industrial production needs to be realized, the data of the material needs to be imported onto a cloud platform.
In the prior art, a way of batch importing data is mainly to import table data into a system at one time by using an ORM framework. After the data are imported into the system, the system traverses the table, traverses the data in each row in the table, verifies the data at the same time, and uniformly outputs the verification result after all the data are traversed. However, when the amount of data to be imported is large, the data import method takes a long time and the import efficiency is low; and when the data verification is unqualified, the data needs to be revised, and after the revision is completed, the system performs traversal and verification on the revised data again, so that the efficiency of data import is low, and the data revision operation is complex.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a data import method, system, device and storage medium based on data variability, which address the above technical problems.
A data import method based on data variability comprises the following steps: determining a data import mode, wherein the data import mode comprises basic import and advanced import; acquiring a data import template, transmitting information in a material table to the import template according to a field check rule, and acquiring an initial import file; uploading the initial import file according to the data import mode; according to the data import mode, carrying out data verification on the initial import file, and displaying a verification result; modifying the initial import file according to the verification result and the data import mode to obtain a target import file; and carrying out data import according to the target import file, and displaying an import result.
In one embodiment, the field check rule includes: the system comprises a basic check rule and an advanced check rule, wherein the basic check rule and the advanced check rule are provided with check rules of mandatory fields, field formats, field content legality and data repeatability.
In one embodiment, the advanced verification rules further include default rules and data population rules, and the default rules include rules for constant assignment, automatic encoding and formula calculation; and the data filling rule is to match fields in the import template according to the fields in the material list and fill data corresponding to the fields in the import template.
In one embodiment, the uploading the initial import file according to the data import mode specifically includes: when the data import mode is imported based, after the initial import file is uploaded, directly importing the data in the initial import file into a server, and prompting that the uploading is successful; and when the data import mode is advanced import, uploading the initial import file, performing front-end processing on the initial import file, and displaying the initial import file in a list.
In one embodiment, the performing data verification on the initial import file according to the data import mode specifically includes: when the data import mode is imported based on the field check rule, checking the initial import file, storing the data passing the check, and recording the check result, wherein the check result comprises successful data content, failed data and a failure reason; and when the data import mode is high-level import, automatically assigning fields to the initial import file, wherein the automatic field assignment comprises data filling and default values, the data filling is prior to the default values, and after the assignment is completed, checking the initial import file according to the field checking rule.
In one embodiment, the presenting the verification result specifically includes: the initial import file comprises a plurality of pieces of data, the data corresponds to a unique data number, and when the data in the initial import file is normal, the corresponding data number is displayed to be black; and when the data in the initial import file is abnormal, displaying the corresponding data number as red, and displaying an error prompt when the cursor moves into the floating frame.
In one embodiment, the modifying the initial import file according to the verification result and the data import mode to obtain the target import file specifically includes: when an error prompt exists in the verification result and the data import mode is high-level import, displaying the error prompt of each piece of abnormal data according to the current page, removing the abnormal data in a deleting or editing and correcting mode to obtain a corrected import file, verifying the corrected import file according to the field verification rule, and obtaining a target import file after the verification is passed; and when the data import mode is imported based on, taking the successful data content in the verification result as a target import file, and acquiring an import result by combining the target import file, the failure data and the failure reason.
A data import system based on data variability, comprising: the system comprises an import mode determining module, a data import mode determining module and a data import mode determining module, wherein the data import mode comprises basic import and high-level import; the information import module is used for acquiring a data import template, transmitting information in the material list to the import template according to a field check rule and acquiring an initial import file; the import file uploading module is used for uploading the initial import file according to the data import mode; the imported file checking module is used for carrying out data checking on the initial imported file according to the data import mode and displaying a checking result; the import file modification module is used for modifying the initial import file according to the verification result and the data import mode to obtain a target import file; and the import result display module is used for carrying out data import according to the target import file and displaying an import result.
An apparatus comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor executes the program to implement the steps of the data variable-based data import method described in the above embodiments.
A storage medium on which a computer program is stored, the program, when executed by a processor, implementing the steps of the data import method based on data variability described in the various embodiments above.
Compared with the prior art, the invention has the advantages and beneficial effects that:
1. the invention is provided with two data import modes, the data import mode can be selected according to actual needs, the data import efficiency is improved, meanwhile, different requirements of customers are met, and the user experience is improved.
2. When data abnormity exists, data revision can be directly realized at the front end, the method is rapid and convenient, the validity of the data can be ensured, the problem of complex data revision process is avoided, and the method is convenient and efficient to operate.
3. According to the method and the device, the data content input by the user is reduced through automatic assignment of the data, so that the data input time before the data is input is shortened, and the data input efficiency is improved.
Drawings
FIG. 1 is a schematic flow chart illustrating a data import method based on data variability according to an embodiment;
FIG. 2 is a block diagram of a data import system based on data variability, according to an embodiment;
fig. 3 is a schematic view of the internal structure of the apparatus in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings by way of specific embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and do not limit the invention.
In one embodiment, as shown in fig. 1, a data import method based on data variability is provided, which includes the following steps:
step S101, determining a data import mode, wherein the data import mode comprises basic import and advanced import.
Specifically, when data import is needed, a data import mode is determined first, and the data import mode includes basic import and advanced import.
The basic import is suitable for the import of the forms with small data volume and simple data, the operation process is simple, after the form data is imported into a system or a server, the system or the server checks and directly stores the form data, and then the check result is displayed. The high-level import is suitable for the table import with large data volume and complex data logic. After the form is imported, the data is temporarily stored in the front end, serial data verification is carried out by the front end, a verification result is fed back, a user can directly correct abnormal data in the front end, and then the corrected data are submitted to a server or a system.
And S102, acquiring a data import template, transmitting information in the material list to the import template according to the field check rule, and acquiring an initial import file.
Specifically, when data of the material list is imported, a data import template is arranged, the import template is downloaded, and data information in the material list is input into the import template, so that an initial import file is obtained. When the information is input to the import template, the input data needs to be verified according to the preset field verification rule.
Wherein, the field check rule includes: the system comprises a basic check rule and an advanced check rule, wherein the basic check rule and the advanced check rule are provided with check rules of mandatory fields, field formats, field content legality and data repeatability.
Specifically, when the mandatory fields are set in the import template, the corresponding data cannot be null; the field format can be correspondingly input according to numerical values, time, texts or the like, for example, the contents of the numerical value format must be input into the 'warehousing sum' field; the validity of field content, that is, the filled data, needs to conform to the actual conditions of the enterprise, for example, "warehouse entry personnel", "warehouse entry", and the like need to be personnel and storehouses existing in the current enterprise system; data repeatability can be set to a unique check field, e.g., "warehouse entry number" cannot be repeated.
The advanced verification rules further comprise default value rules and data filling rules, and the default value rules comprise rules of constant assignment, automatic coding and formula calculation; the data filling rule is that according to the fields in the material list, the fields in the import template are matched, and the data corresponding to the fields are filled into the import template.
Specifically, when high-level import is carried out, two kinds of data assignment are carried out, so that data are automatically generated, and specific assignment rules comprise default value rules and data filling rules. The default value rules comprise constant assignment, walking encoding and formula calculation, for example, the assignment rule of 'warehousing bill number' is 'RK' + year, month, day + 4-bit serial code, and the assignment rule of 'amount' is 'unit price'. refers to 'warehousing quantity'. The data filling rule can match fields in the imported template according to fields in the material list, so that data filling is performed on the imported template, for example, the value of 'warehousing materials' is a certain piece of data selected from the material list, and the 'name', 'code', 'unit price' of the piece of data can be filled in the fields of 'material name', 'material code' and 'unit price' in the fields of the imported template.
And step S103, uploading the initial import file according to the data import mode.
Specifically, the initial import file is uploaded according to the import mode of the data. The file uploading mode can be selected uploading or dragging uploading.
And step S104, performing data verification on the initial import file according to the data import mode, and displaying a verification result.
Specifically, data verification is respectively performed on the initial import file according to the basic import or the advanced import by using the data import mode, and a verification result is displayed.
Specifically, when a data import mode is imported based on the data import mode, an initial import file is directly submitted to a server, and the back end performs data verification on the initial import file according to a preset verification rule; when the data import mode is advanced import, the data can not directly enter the server, but the initial import file is processed by the front end according to the preset check rule, the field data is automatically assigned firstly, and then the check is carried out.
And S105, modifying the initial import file according to the verification result and the data import mode to obtain a target import file.
Specifically, when an error prompt exists in the verification result, the initial import file is modified according to the verification result and the data import mode, and the target import file is obtained. When the data import mode is high-level import, the initial import file is displayed at the front end, so that when the initial import file has an error prompt, the current page of the front end can be directly modified to obtain a modified target import file. When the data import mode is imported as a basis, the initial import file is stored in the server, so that the data which is used for verification can be used as the target import file, and the data which does not pass the verification and the reason for failure can be separately shown.
And step S106, carrying out data import according to the target import file, and displaying an import result.
Specifically, data import is performed to the server according to the obtained target import file, and an import result is displayed. The import result includes the target import file which is successfully imported, the data which is not verified, and the failure reason. And when the system imports the data, the system can prompt the number of normal and abnormal data so as to remind a user that the abnormal data exists, avoid missing modification and confirm whether to give up correction.
In the embodiment, a data import template is obtained by determining a data import mode, information in a material list is transmitted to the import template according to a field check rule, an initial import file is obtained, the initial import file is uploaded according to the data import mode, data check is performed on the initial import file according to the data import mode, a check result is displayed, the initial import file is modified according to the check result and the data import mode, a target import file is obtained, data import is performed according to the target import file, the import result is displayed, the data import mode can be selected according to actual needs, different requirements of customers are met while the data import efficiency is improved, the user experience is improved, meanwhile, data revision can be directly realized at the front end when data abnormity exists, the method is rapid and convenient, and the validity of the data can be ensured, the problem of complicated data flow modification is avoided, and the operation is convenient and efficient.
Wherein, step S103 specifically includes: when the data import mode is imported, after the initial import file is uploaded, directly importing the data in the initial import file into a server, and prompting that the uploading is successful; and when the data import mode is high-level import, uploading the initial import file, performing front-end processing on the initial import file, and displaying the initial import file in the list.
Specifically, when the data import mode is imported based on the data import mode, after the initial import file is uploaded, the data in the initial import file is directly imported into the server, and after the initial import file is successfully uploaded, prompt information that the data are uploaded can be prompted; when the data import mode is high-level import, after the initial import file is uploaded, the data is not imported to the server, the initial import file is subjected to front-end processing, the accuracy of the data is ensured, and then the data is displayed in the list.
Wherein, step S104 specifically includes: when the data import mode is imported based on the field check rule, checking the initial import file, storing the data passing the check, and recording the check result, wherein the check result comprises successful data content, failed data and failure reason; and when the data import mode is high-level import, automatically assigning fields to the initial import file, wherein the automatic field assignment comprises data filling and default values, the data filling is prior to the default values, and after the assignment is finished, checking the initial import file according to field checking rules.
Specifically, when the data import mode is import based, the initial import file is verified according to the basic check rule in the field check rule, the data passing the verification is stored, and the verification result is recorded, wherein the verification result comprises successful data content, failed data and failure reasons. When the data import mode is high-level import, firstly, automatically assigning fields, such as 'warehousing entry number', 'material name', 'amount', and the like, to an initial import file according to the default value rule and the data filling rule, and when two assignment rules exist in one field at the same time, preferentially assigning according to the data filling rule and then assigning by adopting the default value rule; and after the assignment is completed, correspondingly checking each field of each piece of data in the initial import file according to a high-level check rule.
Wherein, the displaying the verification result specifically comprises: the initial import file comprises a plurality of pieces of data, the data corresponds to a unique data number, and when the data in the initial import file is normal, the corresponding data number is displayed to be black; when the data in the initial import file is abnormal, the corresponding data number is displayed in red, and an error prompt is displayed when the cursor moves into the floating frame.
Specifically, after the initial import file is verified and a verification result is obtained, because the initial import file comprises a plurality of pieces of data and the data corresponds to a unique data number, when the data in the initial import file is normal, the corresponding data number is displayed as black; when data abnormality exists in the initial import file, the corresponding data number is displayed in red, and an error prompt is displayed when the cursor moves into the floating frame, so that the data can be modified in a targeted manner. And the processing result of the front end is temporarily stored in the local page.
Wherein, step S105 specifically includes: when an error prompt exists in a verification result and the data import mode is high-level import, displaying the error prompt of each abnormal data according to a current page, removing the abnormal data in a deleting or editing and correcting mode to obtain a corrected import file, verifying the corrected import file according to a field verification rule, and obtaining a target import file after the verification is passed; and when the data import mode is imported based on, taking the successful data content in the verification result as a target import file, and acquiring an import result by combining the target import file, the failure data and the failure reason.
Specifically, when an error prompt exists in the verification result and the data import mode is advanced import, each piece of abnormal data is displayed on the current page of the front end, when the cursor moves to a red data number, the corresponding error prompt can be displayed, all abnormal data are corrected in a mode of deleting the abnormal data or editing the corrected abnormal data, so that a corrected import file is obtained, the front end verifies the corrected import file according to the field verification rule again, and after the verification is passed, the target import file is obtained. And when the data import mode is imported based on, taking the successful data content in the obtained verification result as a target import file, and combining the target import file, the failure data and the failure reason to obtain an import result.
As shown in fig. 2, there is provided a data import system 20 based on data variability, including: an import mode determining module 21, an information import module 22, an import file uploading module 23, an import file checking module 24, an import file modifying module 25, and an import result displaying module 26, where:
an import mode determining module 21, configured to determine a data import mode, where the data import mode includes basic import and advanced import;
the information import module 22 is used for acquiring a data import template, transmitting information in the material list to the import template according to the field check rule, and acquiring an initial import file;
an import file upload module 23, configured to upload an initial import file according to a data import manner;
the import file checking module 24 is configured to perform data checking on the initial import file according to a data import mode, and display a checking result;
the imported file modification module 25 is configured to modify data of the initial imported file according to an error prompt when the error prompt exists in the verification result, and acquire a target imported file;
and an import result display module 26, configured to perform data import according to the target import file, and display an import result.
In an embodiment, the import file upload module 23 is specifically configured to: when the data is imported based on the data import mode, after the initial import file is uploaded, directly importing the data in the initial import file into the server, and prompting that the uploading is successful; when the data import mode is high-level import, uploading the initial import file, performing front-end processing on the initial import file, and displaying the initial import file in a list.
In an embodiment, the import file verification module 24 is specifically configured to: when the data import mode is imported as a basis, verifying the initial import file according to a field verification rule, storing the data passing the verification, and recording a verification result, wherein the verification result comprises successful data content, failed data and a failure reason; and when the data import mode is high-level import, automatically assigning fields to the initial import file, wherein the automatic field assignment comprises data filling and default values, the data filling is prior to the default values, and after the assignment is finished, checking the initial import file according to field checking rules.
In an embodiment, the import file modification module 25 is specifically configured to: when an error prompt exists in a verification result and the data import mode is high-level import, displaying the error prompt of each abnormal data according to a current page, removing the abnormal data in a deleting or editing and correcting mode to obtain a corrected import file, verifying the corrected import file according to a field verification rule, and obtaining a target import file after the verification is passed; when the data import mode is imported as a basis, the successful data content in the verification result is used as a target import file, and the import result is obtained by combining the target import file, the failure data and the failure reason.
In one embodiment, a device is provided, which may be a server, the internal structure of which may be as shown in fig. 3. The apparatus includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the device is configured to provide computing and control capabilities. The memory of the device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the device is used for storing configuration templates and also can be used for storing target webpage data. The network interface of the device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a data import method based on data variability.
Those skilled in the art will appreciate that the configuration shown in fig. 3 is a block diagram of only a portion of the configuration associated with the present application and does not constitute a limitation on the devices to which the present application may be applied, and that a particular device may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a storage medium may be further provided, the storage medium stores a computer program, the computer program includes program instructions, when executed by a computer, the computer may be a part of the above-mentioned data variable based data import system, the computer program causes the computer to execute the method according to the foregoing embodiment.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), or the like.
It will be apparent to those skilled in the art that the modules or steps of the present invention described above may be implemented in a general purpose computing device, they may be centralized in a single computing device or distributed across a network of multiple computing devices, and alternatively, they may be implemented in program code executable by a computing device, such that they may be stored on a computer storage medium (ROM/RAM, magnetic disk, optical disk) for execution by a computing device, and in some cases, the steps shown or described may be performed in an order different from that described herein, or they may be separately fabricated as individual integrated circuit modules, or multiple ones of them may be fabricated as a single integrated circuit module. Thus, the present invention is not limited to any specific combination of hardware and software.
The foregoing is a more detailed description of the present invention with reference to specific embodiments thereof, and it is not intended to limit the invention to the specific embodiments thereof. For those skilled in the art to which the invention pertains, several simple deductions or substitutions can be made without departing from the spirit of the invention, and all shall be considered as belonging to the protection scope of the invention.
Claims (7)
1. A data import method based on data variability is characterized by comprising the following steps:
determining a data import mode, wherein the data import mode comprises basic import and advanced import;
acquiring a data import template, transmitting information in a material list to the import template according to a field check rule, and acquiring an initial import file, wherein the field check rule comprises the following steps: the system comprises a basic check rule and an advanced check rule, wherein the basic check rule and the advanced check rule are provided with check rules of mandatory fields, field formats, field content legality and data repeatability, the advanced check rule further comprises a default value rule and a data filling rule, and the default value rule comprises rules of constant assignment, automatic coding and formula calculation; the data filling rule is that the fields in the import template are matched according to the fields in the material table, and the data corresponding to the fields are filled in the import template;
uploading the initial import file according to the data import mode;
according to the data import mode, carrying out data verification on the initial import file, and displaying a verification result, specifically comprising: when the data import mode is imported based, verifying the initial import file according to the field verification rule, storing the data passing the verification, and recording the verification result, wherein the verification result comprises successful data content, failed data and failure reasons; when the data import mode is high-level import, automatically assigning fields to the initial import file, wherein the automatic field assignment comprises data filling and default values, the data filling is prior to the default values, and after the assignment is completed, checking the initial import file according to the field checking rule;
modifying the initial import file according to the verification result and the data import mode to obtain a target import file;
and carrying out data import according to the target import file, and displaying an import result.
2. The data import method based on the data variability according to claim 1, wherein uploading the initial import file according to the data import mode specifically includes:
when the data import mode is imported based, after the initial import file is uploaded, directly importing the data in the initial import file into a server, and prompting that the uploading is successful;
and when the data import mode is advanced import, uploading the initial import file, performing front-end processing on the initial import file, and displaying the initial import file in a list.
3. The data import method based on the data variability according to claim 1, wherein the displaying the verification result specifically comprises:
the initial import file comprises a plurality of pieces of data, the data correspond to a unique data number, and when the data in the initial import file are normal, the corresponding data number is displayed to be black;
and when the data in the initial import file is abnormal, displaying the corresponding data number as red, and displaying an error prompt when the cursor moves into the floating frame.
4. The data import method based on the data variability according to claim 3, wherein the modifying the initial import file according to the verification result and the data import mode to obtain the target import file specifically comprises:
when an error prompt exists in the verification result and the data import mode is high-level import, displaying the error prompt of each piece of abnormal data according to the current page, removing the abnormal data in a deleting or editing and correcting mode to obtain a corrected import file, verifying the corrected import file according to the field verification rule, and obtaining a target import file after the verification is passed;
and when the data import mode is imported based on, taking the successful data content in the verification result as a target import file, and acquiring an import result by combining the target import file, the failure data and the failure reason.
5. A data import system based on data variability, comprising:
the system comprises an import mode determining module, a data import mode determining module and a data import mode determining module, wherein the data import mode comprises basic import and high-level import;
the information import module is used for acquiring a data import template, transmitting information in a material list to the import template according to a field check rule, and acquiring an initial import file, wherein the field check rule comprises: the high-level verification rules also comprise default value rules and data filling rules, and the default value rules comprise rules of constant assignment, automatic coding and formula calculation; the data filling rule is that the fields in the import template are matched according to the fields in the material table, and the data corresponding to the fields are filled in the import template;
the import file uploading module is used for uploading the initial import file according to the data import mode;
the imported file checking module is configured to perform data checking on the initial imported file according to the data import manner, and display a checking result, and specifically includes: when the data import mode is imported based, verifying the initial import file according to the field verification rule, storing the data passing the verification, and recording the verification result, wherein the verification result comprises successful data content, failed data and failure reasons; when the data import mode is high-level import, automatically assigning fields to the initial import file, wherein the automatic field assignment comprises data filling and default values, the data filling is prior to the default values, and after the assignment is completed, checking the initial import file according to the field checking rule;
the import file modification module is used for modifying the initial import file according to the verification result and the data import mode to obtain a target import file;
and the import result display module is used for carrying out data import according to the target import file and displaying an import result.
6. 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 4 are implemented when the computer program is executed by the processor.
7. A 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 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111005671.3A CN113642308B (en) | 2021-08-30 | 2021-08-30 | Data import method, system, device and storage medium based on data variability |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111005671.3A CN113642308B (en) | 2021-08-30 | 2021-08-30 | Data import method, system, device and storage medium based on data variability |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113642308A CN113642308A (en) | 2021-11-12 |
| CN113642308B true CN113642308B (en) | 2022-07-22 |
Family
ID=78424389
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111005671.3A Active CN113642308B (en) | 2021-08-30 | 2021-08-30 | Data import method, system, device and storage medium based on data variability |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113642308B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115047836A (en) * | 2022-06-27 | 2022-09-13 | 中国核动力研究设计院 | Test case generation and loading method and system based on DCS system periodic test |
| CN115905269A (en) * | 2023-01-06 | 2023-04-04 | 深圳市明源云科技有限公司 | Data import method, system, device and storage medium |
| CN117575128A (en) * | 2023-10-18 | 2024-02-20 | 启朔(深圳)科技有限公司 | SoC array server product life cycle management system |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103631966B (en) * | 2013-12-18 | 2017-10-10 | 用友网络科技股份有限公司 | A kind of method of configurable parsing multivalue matching field |
| CN108595597A (en) * | 2018-04-19 | 2018-09-28 | 平安科技（深圳）有限公司 | Data lead-in method, device, computer equipment and storage medium |
| CN110046334A (en) * | 2019-03-21 | 2019-07-23 | 平安国际智慧城市科技股份有限公司 | Data lead-in method, device, computer equipment and storage medium |
| CN111414739B (en) * | 2020-02-27 | 2023-04-14 | 北京中亦安图科技股份有限公司 | Excel data entry component, entry method and device |
-
2021
- 2021-08-30 CN CN202111005671.3A patent/CN113642308B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN113642308A (en) | 2021-11-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113642308B (en) | Data import method, system, device and storage medium based on data variability | |
| CN103999047B (en) | repair delivery system | |
| CN111222070B (en) | Data processing method, device, equipment and storage medium | |
| US9037549B2 (en) | System and method for testing data at a data warehouse | |
| CN104317618B (en) | A kind of firmware partition treating method and apparatus | |
| CN108509344B (en) | Daily cutting batch test method, equipment and readable storage medium | |
| CN108388515A (en) | Test data generating method, device, equipment and computer readable storage medium | |
| CN110837356B (en) | Data processing method and device | |
| CN106326116B (en) | The method and apparatus of product test | |
| CN112380255A (en) | Service processing method, device, equipment and storage medium | |
| CN112418813B (en) | AEO qualification intelligent rating management system and method based on intelligent analysis and identification and storage medium | |
| CN111667231B (en) | Automatic tax return method, device, system, computer equipment and storage medium | |
| US20230092559A1 (en) | Systems and methods for unstructured data processing | |
| CN111367982A (en) | Method and device for importing TRIRIGA basic data, computer equipment and storage medium | |
| CN113128168A (en) | Pad parameter checking and correcting method and device, computer equipment and storage medium | |
| CN113158988A (en) | Financial statement processing method and device and computer readable storage medium | |
| CN111274128A (en) | Test method, test device, computer equipment and computer readable storage medium | |
| CN110717315A (en) | System data batch modification method and device, storage medium and electronic equipment | |
| CN114253642B (en) | System information processing method, device, electronic equipment and medium | |
| CN111400245B (en) | Art resource migration method and device | |
| CN110321124B (en) | Text layout optimization method and device and electronic equipment | |
| CN113868210A (en) | Validity verification method, system, equipment and storage medium for imported data | |
| CN112884475A (en) | Test method and system of intelligent contract resource loss monitoring system | |
| CN116010349B (en) | Metadata-based data checking method and device, electronic equipment and storage medium | |
| CN117573082B (en) | Flow driving method and device based on business individual case 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20230602 Address after: Room 1-1-18, Unit 1, Building 4, No. 1580 Zhiyun Avenue, Yudong Street, Banan District, Chongqing, 401320 Patentee after: Chongqing Yunfeng Technology Co.,Ltd. Address before: 408300 building a, 59 Chaoyang Road, Dianjiang Industrial Park, Chongqing Patentee before: Chongqing Yuncheng Internet Technology Co.,Ltd. |
|
| TR01 | Transfer of patent right |