CN113642308A - Data import method, system, equipment and storage medium based on data variability - Google Patents

Data import method, system, equipment and storage medium based on data variability Download PDF

Info

Publication number
CN113642308A
CN113642308A CN202111005671.3A CN202111005671A CN113642308A CN 113642308 A CN113642308 A CN 113642308A CN 202111005671 A CN202111005671 A CN 202111005671A CN 113642308 A CN113642308 A CN 113642308A
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.)
Granted
Application number
CN202111005671.3A
Other languages
Chinese (zh)
Other versions
CN113642308B (en
Inventor
甘燎源
罗义
曹中余
穆靖
刘欢
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Chongqing Yunfeng Technology Co ltd
Original Assignee
Chongqing Yuncheng Internet Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Chongqing Yuncheng Internet Technology Co Ltd filed Critical Chongqing Yuncheng Internet Technology Co Ltd
Priority to CN202111005671.3A priority Critical patent/CN113642308B/en
Publication of CN113642308A publication Critical patent/CN113642308A/en
Application granted granted Critical
Publication of CN113642308B publication Critical patent/CN113642308B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/16File or folder operations, e.g. details of user interfaces specifically adapted to file systems
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/174Form filling; Merging
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

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 data import method and the data import device can select the data import mode according to actual needs, meet different requirements of customers while improving the data import efficiency, and improve the use experience of users.

Description

Data import method, system, equipment and storage medium based on data variability
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 method for realizing batch import of data mainly adopts an ORM framework to import table data into a system at one time. After the data is imported into the system, the system traverses the table, traverses the data in each line in the table, verifies the data at the same time, and uniformly outputs the verification result after all data traverse is finished. 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; when the data is unqualified in verification, 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 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.
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 imported file modification module is used for modifying the initial imported file according to the verification result and the data import mode to obtain a target imported 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, the invention can directly realize data revision at the front end, is rapid and convenient, can ensure the validity of the data, avoids the problem of complex data modification process, and has convenient and efficient operation.
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 in 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 diagram 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 are not intended to 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 form import with small data volume and simple data, the operation flow 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, the front end performs series data verification and feeds back verification results, and a user can directly correct abnormal data in the front end and then submit the corrected data 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 a mandatory field is set in an import template, corresponding data cannot be null; the field format can be correspondingly input according to the numerical value, time or text, for example, the contents of the numerical value format must be input into the 'warehousing amount' 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 codes and formula calculation, for example, the assignment rule of 'warehousing entry number' is 'RK' + year, month, day + 4-bit flow codes, and the assignment rule of 'amount' is 'unit price'. times 'warehousing quantity'. The data filling rule can match fields in the import template according to fields in the material list, so as to perform data filling on the import template, for example, the value of the 'warehousing material' 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 the import template with the fields of the 'material name', 'material code' and 'unit price'.
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 the data import mode is import based, directly submitting the initial import file to a server, and performing data verification on the initial import file by the back end according to a preset verification rule; when the data import mode is high-level import, the data cannot directly enter the server, but the initial import file is processed by the front end according to a preset verification rule, the field data is automatically assigned firstly, and then verification is carried out.
And step S105, modifying the initial import file according to the verification result and the data import mode, and acquiring 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 based on, 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 is not verified 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 submitting the target import file stored in the local page in the high-level import to the system, wherein unrepaired abnormal data cannot be submitted, and the system can prompt the number of normal and abnormal data when importing the data so as to remind a user that the abnormal data exists, avoid missing modification and confirm whether to give up the modification.
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 complex data flow modification is avoided, and the operation is convenient and efficient.
Wherein, step S103 specifically includes: 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; 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 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 to the server, and after the initial import file is successfully uploaded, prompt information that the data is 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 verification rule in the field verification rules, 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, carrying out corresponding verification on each field of each piece of data in the initial import file according to a high-level verification rule.
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.
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 used for performing data checking on the initial import file according to the data import mode and displaying 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 the import result display module 26 is 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; 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.
In an embodiment, the import file verification module 24 is specifically configured to: 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.
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; 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.
In one embodiment, a device is provided, which may be a server, and its internal structure diagram may be as shown in fig. 3. The device 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 storing a computer program, the computer program comprising program instructions, which when executed by a computer, the computer may be a part of the above-mentioned data variable-based data import system, cause the computer to perform 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 invention described above may be implemented in a general purpose computing device, they may be centralized on a single computing device or distributed across a network of computing devices, and optionally 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 disks, optical disks) and executed by a computing device, and in some cases, the steps shown or described may be performed in an order different than that described herein, or they may be separately fabricated into individual integrated circuit modules, or multiple ones of them may be fabricated into 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 that is presented in conjunction with specific embodiments, and the practice of the invention is not to be considered limited to those descriptions. 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 (10)

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 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.
2. The data import method based on the data variability of claim 1, wherein the field check rule comprises: 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.
3. The data import method based on the data variability of claim 2, wherein the advanced verification rules further comprise default rules and data filling rules, and the default rules comprise rules of constant assignment, automatic coding 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.
4. 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.
5. The data import method based on the data variability according to claim 1, wherein 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.
6. The data import method based on the data variability of claim 5, 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.
7. The data import method based on the data variability of claim 6, 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.
8. 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 imported file modification module is used for modifying the initial imported file according to the verification result and the data import mode to obtain a target imported 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.
9. An apparatus 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 storage medium having a computer program stored thereon, the computer program, when being executed by a processor, realizing the steps of the method of any one of claims 1 to 7.
CN202111005671.3A 2021-08-30 2021-08-30 Data import method, system, device and storage medium based on data variability Active CN113642308B (en)

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 true CN113642308A (en) 2021-11-12
CN113642308B 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)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115905269A (en) * 2023-01-06 2023-04-04 深圳市明源云科技有限公司 Data import method, system, device and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103631966A (en) * 2013-12-18 2014-03-12 用友软件股份有限公司 Configurable multiple-valued matching field analysis method
CN108595597A (en) * 2018-04-19 2018-09-28 平安科技(深圳)有限公司 Data lead-in method, device, computer equipment and storage medium
CN111414739A (en) * 2020-02-27 2020-07-14 北京中亦安图科技股份有限公司 Excel data entry component, entry method and device
WO2020186783A1 (en) * 2019-03-21 2020-09-24 平安国际智慧城市科技股份有限公司 Data importing method and apparatus, and computer device and storage medium

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103631966A (en) * 2013-12-18 2014-03-12 用友软件股份有限公司 Configurable multiple-valued matching field analysis method
CN108595597A (en) * 2018-04-19 2018-09-28 平安科技(深圳)有限公司 Data lead-in method, device, computer equipment and storage medium
WO2020186783A1 (en) * 2019-03-21 2020-09-24 平安国际智慧城市科技股份有限公司 Data importing method and apparatus, and computer device and storage medium
CN111414739A (en) * 2020-02-27 2020-07-14 北京中亦安图科技股份有限公司 Excel data entry component, entry method and device

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115905269A (en) * 2023-01-06 2023-04-04 深圳市明源云科技有限公司 Data import method, system, device and storage medium

Also Published As

Publication number Publication date
CN113642308B (en) 2022-07-22

Similar Documents

Publication Publication Date Title
CN103999047B (en) repair delivery system
CN104317618B (en) A kind of firmware partition treating method and apparatus
CN111222070B (en) Data processing method, device, equipment and storage medium
CN109634941B (en) Medical data processing method and device, electronic equipment and storage medium
CN108509344B (en) Daily cutting batch test method, equipment and readable storage medium
US11887723B2 (en) Dental practice scheduling efficiencies and operational issue trainings
CA2973381A1 (en) Hybrid human and computer-assisted coding workflow
CN112380255A (en) Service processing method, device, equipment and storage medium
US20230092559A1 (en) Systems and methods for unstructured data processing
CN113642308B (en) Data import method, system, device and storage medium based on data variability
CN110647523A (en) Data quality analysis method and device, storage medium and electronic equipment
US20140180949A1 (en) System and method for automated coding and testing of benefits
CN112418813B (en) AEO qualification intelligent rating management system and method based on intelligent analysis and identification and storage medium
CN111367982B (en) Method, device, computer equipment and storage medium for importing TRRIGA basic data
CN110211006B (en) Contract risk analysis method and device and storage medium
CN112650424A (en) Information prompting method and device, electronic equipment and storage medium
CN110413279B (en) Data loading method and device
US20170004265A1 (en) Encounter management
CN110717315A (en) System data batch modification method and device, storage medium and electronic equipment
CN113158988B (en) Financial statement processing method, device and computer readable storage medium
CN111400245B (en) Art resource migration method and device
CN111274128A (en) Test method, test device, computer equipment and computer readable storage medium
CN110716855B (en) Processor instruction set testing method and device
US11809308B2 (en) System and framework for testing of application performance with real-time scaled simulation
CN115187411A (en) Insurance applicability automatic analysis method and system and computer 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