CN117312347A - Data batch updating method, device, medium and equipment - Google Patents

Data batch updating method, device, medium and equipment Download PDF

Info

Publication number
CN117312347A
CN117312347A CN202311343972.6A CN202311343972A CN117312347A CN 117312347 A CN117312347 A CN 117312347A CN 202311343972 A CN202311343972 A CN 202311343972A CN 117312347 A CN117312347 A CN 117312347A
Authority
CN
China
Prior art keywords
data
uploaded
information
excel
categories
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
Application number
CN202311343972.6A
Other languages
Chinese (zh)
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.)
Beijing Arc Information Technology Co ltd
Original Assignee
Beijing Arc Information 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 Beijing Arc Information Technology Co ltd filed Critical Beijing Arc Information Technology Co ltd
Priority to CN202311343972.6A priority Critical patent/CN117312347A/en
Publication of CN117312347A publication Critical patent/CN117312347A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Information Transfer Between Computers (AREA)

Abstract

The invention discloses a data batch updating method, a device, a medium and equipment. The method comprises the following steps: acquiring data information to be uploaded; extracting preset text information of a plurality of categories from the data information; adding the text information of the multiple categories into a preset Excel table containing the multiple categories, and generating an Excel table to be uploaded; judging whether an Excel form to be uploaded accords with a preset rule, and identifying parameters required by a data generation submitting interface in the Excel form to be uploaded and submitting the parameters to a back-end server under the condition that the Excel form to be uploaded accords with the preset rule; and traversing all data of the Excel form to be uploaded, and displaying an uploading result.

Description

Data batch updating method, device, medium and equipment
Technical Field
The present invention relates to the field of data updating technologies, and in particular, to a method, an apparatus, a medium, and a device for batch updating of data.
Background
At present, the quantity of cargoes is greatly increased, under the condition that data is added in the background, if a large quantity of data (such as a manifest of cargoes) is added at one time, the cargoes are submitted one by one, the trouble and the effort are wasted, the data are uploaded in batches at one time, and under the condition that the quantity of the data is large, the clamping can occur, and the technical problem that missing data cannot be checked exists.
Disclosure of Invention
Aiming at the defects of the prior art, the invention provides a data batch updating method, a device, a medium and equipment.
According to one aspect of the present invention, there is provided a data batch update method, including:
acquiring data information to be uploaded;
extracting preset text information of a plurality of categories from the data information;
adding the text information of the multiple categories into a preset Excel table containing the multiple categories, and generating an Excel table to be uploaded;
judging whether an Excel form to be uploaded accords with a preset rule, and identifying parameters required by a data generation submitting interface in the Excel form to be uploaded and submitting the parameters to a back-end server under the condition that the Excel form to be uploaded accords with the preset rule;
and traversing all data of the Excel form to be uploaded, and displaying an uploading result.
Optionally, the data information includes text information, picture information, and form information.
Optionally, extracting text information of a plurality of preset categories from the data information includes:
extracting characters from the data information by utilizing an optical character recognition technology, and determining character data;
text information corresponding to a plurality of categories is extracted from text data.
Optionally, the uploading result includes the number of successful data uploading, the number of error data uploading and the error reason.
Optionally, the method further comprises: and carrying out integrity adjustment on the error data displayed by the uploading result to re-upload.
Optionally, the method further comprises: in the case that the integrity adjustment of the error data is not possible, the error data is deleted.
According to another aspect of the present invention, there is provided a data batch updating apparatus including:
the acquisition module is used for acquiring data information to be uploaded;
the extraction module is used for extracting preset text information of a plurality of categories from the data information;
the generation module is used for adding the text information of the multiple categories into a preset Excel table containing the multiple categories to generate an Excel table to be uploaded;
the submitting module is used for judging whether the Excel form to be uploaded accords with a preset rule, identifying parameters required by a data generation submitting interface in the Excel form to be uploaded and submitting the parameters to a back-end server under the condition that the Excel form to be uploaded accords with the preset rule;
and the display module is used for displaying the uploading result after traversing all the data of the Excel form to be uploaded.
According to a further aspect of the present invention there is provided a computer readable storage medium storing a computer program for performing the method according to any one of the above aspects of the present invention.
According to still another aspect of the present invention, there is provided an electronic device including: a processor; a memory for storing the processor-executable instructions; the processor is configured to read the executable instructions from the memory and execute the instructions to implement the method according to any of the above aspects of the present invention.
Therefore, the application provides a data batch updating method, which is characterized in that data information is arranged into an Excel form, and after the data is uploaded in batches, the processing of the data which is not uploaded is carried out according to the uploading result. The time is saved, the repeated operation is avoided, and the technical effect of uneasiness in omission is achieved.
Drawings
Exemplary embodiments of the present invention may be more completely understood in consideration of the following drawings:
FIG. 1 is a flow chart of a method for batch update of data according to an exemplary embodiment of the present invention;
FIG. 2 is a schematic diagram of a data batch update apparatus according to an exemplary embodiment of the present invention;
fig. 3 is a structure of an electronic device provided in an exemplary embodiment of the present invention.
Detailed Description
Hereinafter, exemplary embodiments according to the present invention will be described in detail with reference to the accompanying drawings. It should be apparent that the described embodiments are only some embodiments of the present invention and not all embodiments of the present invention, and it should be understood that the present invention is not limited by the example embodiments described herein.
It should be noted that: the relative arrangement of the components and steps, numerical expressions and numerical values set forth in these embodiments do not limit the scope of the present invention unless it is specifically stated otherwise.
It will be appreciated by those of skill in the art that the terms "first," "second," etc. in embodiments of the present invention are used merely to distinguish between different steps, devices or modules, etc., and do not represent any particular technical meaning nor necessarily logical order between them.
It should also be understood that in embodiments of the present invention, "plurality" may refer to two or more, and "at least one" may refer to one, two or more.
It should also be appreciated that any component, data, or structure referred to in an embodiment of the invention may be generally understood as one or more without explicit limitation or the contrary in the context.
In addition, the term "and/or" in the present invention is merely an association relationship describing the association object, and indicates that three relationships may exist, for example, a and/or B may indicate: a exists alone, A and B exist together, and B exists alone. In the present invention, the character "/" generally indicates that the front and rear related objects are an or relationship.
It should also be understood that the description of the embodiments of the present invention emphasizes the differences between the embodiments, and that the same or similar features may be referred to each other, and for brevity, will not be described in detail.
Meanwhile, it should be understood that the sizes of the respective parts shown in the drawings are not drawn in actual scale for convenience of description.
The following description of at least one exemplary embodiment is merely exemplary in nature and is in no way intended to limit the invention, its application, or uses.
Techniques, methods, and apparatus known to one of ordinary skill in the relevant art may not be discussed in detail, but where appropriate, the techniques, methods, and apparatus should be considered part of the specification.
It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further discussion thereof is necessary in subsequent figures.
Embodiments of the invention are operational with numerous other general purpose or special purpose computing system environments or configurations with electronic devices, such as terminal devices, computer systems, servers, etc. Examples of well known terminal devices, computing systems, environments, and/or configurations that may be suitable for use with the terminal device, computer system, server, or other electronic device include, but are not limited to: personal computer systems, server computer systems, thin clients, thick clients, hand-held or laptop devices, microprocessor-based systems, set-top boxes, programmable consumer electronics, network personal computers, small computer systems, mainframe computer systems, and distributed cloud computing technology environments that include any of the foregoing, and the like.
Electronic devices such as terminal devices, computer systems, servers, etc. may be described in the general context of computer system-executable instructions, such as program modules, being executed by a computer system. Generally, program modules may include routines, programs, objects, components, logic, data structures, etc., that perform particular tasks or implement particular abstract data types. The computer system/server may be implemented in a distributed cloud computing environment in which tasks are performed by remote processing devices that are linked through a communications network. In a distributed cloud computing environment, program modules may be located in both local and remote computing system storage media including memory storage devices.
Exemplary method
Fig. 1 is a flowchart of a data batch update method according to an exemplary embodiment of the present invention. The embodiment can be applied to an electronic device, as shown in fig. 1, the data batch update method 100 includes the following steps:
step 101, obtaining data information to be uploaded;
102, extracting preset text information of a plurality of categories from data information;
in the case that the uploaded data information is cargo information, the plurality of categories may be cargo serial numbers, cargo identifications, cargo names, cargo numbers, and the like.
Step 103, adding the text information of the multiple categories into a preset Excel table containing the multiple categories, and generating an Excel table to be uploaded;
wherein, a plurality of categories form the header of the Excel table to be uploaded. Wherein the unidentified category may be set to a default form such as null.
Step 104, judging whether the Excel form to be uploaded accords with a preset rule, and identifying parameters required by a data generation and submission interface in the Excel form to be uploaded and submitting the parameters to a back-end server under the condition that the Excel form to be uploaded accords with the preset rule;
step 105, after traversing all data to be uploaded to the Excel table, displaying the uploading result.
Optionally, the data information includes text information, picture information, and form information.
Optionally, extracting text information of a plurality of preset categories from the data information includes:
extracting characters from the data information by utilizing an optical character recognition technology, and determining character data;
text information corresponding to a plurality of categories is extracted from text data.
Optionally, the uploading result includes the number of successful data uploading, the number of error data uploading and the error reason.
Optionally, the method further comprises: and carrying out integrity adjustment on the error data displayed by the uploading result to re-upload.
Optionally, the method further comprises: in the case that the integrity adjustment of the error data is not possible, the error data is deleted.
Specifically, according to the operation of clicking the uploading data by the user (i.e. obtaining EXCEL), there is a header (serial number, name, age, xxx) of the uploading data in the table, the user uploads multiple types of information in the EXCEL header according to own requirements, after EXCELs of the multiple types of headers are set, clicks an upload EXCEL table button, and uploads the EXCEL table.
After uploading, the EXCEL file is transferred to the background through the interface, the background can circularly traverse each item of data to judge whether the rule is met, if the rule is met, the corresponding data list is directly returned, if the rule is not met, the corresponding error information is returned, the xx data of the serial number XXX does not meet the rule, and the rule is XXX.
Therefore, the data information is arranged into the form of an Excel table, and after the data are uploaded in batches, the processing of the data which are not uploaded is performed according to the uploading result. The time is saved, the repeated operation is avoided, and the technical effect of uneasiness in omission is achieved.
Exemplary apparatus
Fig. 2 is a schematic structural diagram of a data batch update apparatus according to an exemplary embodiment of the present invention. As shown in fig. 2, the apparatus 200 includes:
an obtaining module 210, configured to obtain data information to be uploaded;
an extracting module 220, configured to extract text information of a plurality of preset categories from the data information;
the generating module 230 is configured to add text information of a plurality of categories to a preset Excel table containing the plurality of categories, and generate an Excel table to be uploaded;
the submitting module 240 is configured to determine whether the Excel form to be uploaded meets a preset rule, identify parameters required by a data generation submitting interface in the Excel form to be uploaded and submit the parameters to the back-end server if the Excel form to be uploaded meets the preset rule;
the display module 250 is configured to display an uploading result after traversing all the data of the Excel table to be uploaded.
Optionally, the data information includes text information, picture information, and form information.
Optionally, the extracting module 220 includes:
the first extraction submodule is used for extracting characters from the data information by utilizing an optical character recognition technology and determining character data;
and the second extraction sub-module is used for extracting the text information corresponding to the plurality of categories from the text data.
Optionally, the uploading result includes the number of successful data uploading, the number of error data uploading and the error reason.
Optionally, the apparatus 200 further comprises: and the adjusting module is used for carrying out integrity adjustment on the error data displayed by the uploading result and uploading the error data again.
Optionally, the apparatus 200 further comprises: and the deleting module is used for deleting the error data under the condition that the integrity of the error data cannot be adjusted.
Exemplary electronic device
Fig. 3 is a structure of an electronic device provided in an exemplary embodiment of the present invention. As shown in fig. 3, the electronic device 30 includes one or more processors 31 and memory 32.
The processor 31 may be a Central Processing Unit (CPU) or other form of processing unit having data processing and/or instruction execution capabilities, and may control other components in the electronic device to perform desired functions.
Memory 32 may include one or more computer program products that may include various forms of computer-readable storage media, such as volatile memory and/or non-volatile memory. The volatile memory may include, for example, random Access Memory (RAM) and/or cache memory (cache), and the like. The non-volatile memory may include, for example, read Only Memory (ROM), hard disk, flash memory, and the like. One or more computer program instructions may be stored on the computer readable storage medium that can be executed by the processor 31 to implement the methods of the software programs of the various embodiments of the present invention described above and/or other desired functions. In one example, the electronic device may further include: an input device 33 and an output device 34, which are interconnected by a bus system and/or other forms of connection mechanisms (not shown).
In addition, the input device 33 may also include, for example, a keyboard, a mouse, and the like.
The output device 34 can output various information to the outside. The output device 34 may include, for example, a display, speakers, a printer, and a communication network and remote output devices connected thereto, etc.
Of course, only some of the components of the electronic device that are relevant to the present invention are shown in fig. 3 for simplicity, components such as buses, input/output interfaces, etc. being omitted. In addition, the electronic device may include any other suitable components depending on the particular application.
Exemplary computer program product and computer readable storage Medium
In addition to the methods and apparatus described above, embodiments of the invention may also be a computer program product comprising computer program instructions which, when executed by a processor, cause the processor to perform steps in a method according to various embodiments of the invention described in the "exemplary methods" section of this specification.
The computer program product may write program code for performing operations of embodiments of the present invention in any combination of one or more programming languages, including an object oriented programming language such as Java, C++ or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device, partly on a remote computing device, or entirely on the remote computing device or server.
Furthermore, embodiments of the present invention may also be a computer-readable storage medium, having stored thereon computer program instructions which, when executed by a processor, cause the processor to perform the steps in a method of mining history change records according to various embodiments of the present invention described in the "exemplary methods" section above in this specification.
The computer readable storage medium may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. The readable storage medium can include, for example, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, or device, or a combination of any of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium would include the following: an electrical connection having one or more wires, a portable disk, a hard disk, random Access Memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
The basic principles of the present invention have been described above in connection with specific embodiments, however, it should be noted that the advantages, benefits, effects, etc. mentioned in the present invention are merely examples and not intended to be limiting, and these advantages, benefits, effects, etc. are not to be considered as essential to the various embodiments of the present invention. Furthermore, the specific details disclosed herein are for purposes of illustration and understanding only, and are not intended to be limiting, as the invention is not necessarily limited to practice with the above described specific details.
In this specification, each embodiment is described in a progressive manner, and each embodiment is mainly described in a different manner from other embodiments, so that the same or similar parts between the embodiments are mutually referred to. For system embodiments, the description is relatively simple as it essentially corresponds to method embodiments, and reference should be made to the description of method embodiments for relevant points.
The block diagrams of the devices, systems, apparatuses, systems according to the present invention are merely illustrative examples and are not intended to require or imply that the connections, arrangements, configurations must be made in the manner shown in the block diagrams. As will be appreciated by one of skill in the art, the devices, systems, apparatuses, systems may be connected, arranged, configured in any manner. Words such as "including," "comprising," "having," and the like are words of openness and mean "including but not limited to," and are used interchangeably therewith. The terms "or" and "as used herein refer to and are used interchangeably with the term" and/or "unless the context clearly indicates otherwise. The term "such as" as used herein refers to, and is used interchangeably with, the phrase "such as, but not limited to.
The method and system of the present invention may be implemented in a number of ways. For example, the methods and systems of the present invention may be implemented by software, hardware, firmware, or any combination of software, hardware, firmware. The above-described sequence of steps for the method is for illustration only, and the steps of the method of the present invention are not limited to the sequence specifically described above unless specifically stated otherwise. Furthermore, in some embodiments, the present invention may also be embodied as programs recorded in a recording medium, the programs including machine-readable instructions for implementing the methods according to the present invention. Thus, the present invention also covers a recording medium storing a program for executing the method according to the present invention.
It is also noted that in the systems, devices and methods of the present invention, components or steps may be disassembled and/or assembled. Such decomposition and/or recombination should be considered as equivalent aspects of the present invention. The previous description of the disclosed aspects is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these aspects will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other aspects without departing from the scope of the invention. Thus, the present invention is not intended to be limited to the aspects shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
The foregoing description has been presented for purposes of illustration and description. Furthermore, this description is not intended to limit embodiments of the invention to the form disclosed herein. Although a number of example aspects and embodiments have been discussed above, a person of ordinary skill in the art will recognize certain variations, modifications, alterations, additions, and subcombinations thereof.

Claims (10)

1. A method for batch updating of data, comprising:
acquiring data information to be uploaded;
extracting preset text information of a plurality of categories from the data information;
adding the text information of the multiple categories into a preset Excel table containing the multiple categories, and generating an Excel table to be uploaded;
judging whether the Excel form to be uploaded accords with a preset rule, and identifying parameters required by a data generation submitting interface in the Excel form to be uploaded and submitting the parameters to a back-end server under the condition that the Excel form to be uploaded accords with the preset rule;
and traversing all the data of the Excel form to be uploaded, and displaying an uploading result.
2. The method of claim 1, wherein the data information comprises text information, picture information, and form information.
3. The method according to claim 2, wherein extracting text information of a plurality of predetermined categories from the data information comprises:
performing word extraction from the data information by utilizing an optical character recognition technology, and determining word data;
and extracting text information corresponding to the plurality of categories from the text data.
4. The method of claim 1, wherein the upload result comprises an upload success data amount, an upload error data amount, and an error cause.
5. The method as recited in claim 4, further comprising: and carrying out integrity adjustment on the error data displayed by the uploading result to re-upload.
6. The method as recited in claim 5, further comprising: and deleting the error data under the condition that the integrity of the error data cannot be adjusted.
7. A data batch update apparatus, comprising:
the acquisition module is used for acquiring data information to be uploaded;
the extraction module is used for extracting preset text information of a plurality of categories from the data information;
the generation module is used for adding the text information of the multiple categories into a preset Excel table containing the multiple categories to generate an Excel table to be uploaded;
the submitting module is used for judging whether the Excel form to be uploaded accords with a preset rule or not, and identifying parameters required by a data generation submitting interface in the Excel form to be uploaded and submitting the parameters to a back-end server under the condition that the Excel form to be uploaded accords with the preset rule;
and the display module is used for displaying the uploading result after traversing all the data of the Excel form to be uploaded.
8. The apparatus of claim 7, wherein the data information comprises text information, picture information, and form information.
9. A computer readable storage medium, characterized in that the storage medium stores a computer program for executing the method of any of the preceding claims 1-6.
10. An electronic device, the electronic device comprising:
a processor;
a memory for storing the processor-executable instructions;
the processor is configured to read the executable instructions from the memory and execute the instructions to implement the method of any of the preceding claims 1-6.
CN202311343972.6A 2023-10-17 2023-10-17 Data batch updating method, device, medium and equipment Pending CN117312347A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202311343972.6A CN117312347A (en) 2023-10-17 2023-10-17 Data batch updating method, device, medium and equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202311343972.6A CN117312347A (en) 2023-10-17 2023-10-17 Data batch updating method, device, medium and equipment

Publications (1)

Publication Number Publication Date
CN117312347A true CN117312347A (en) 2023-12-29

Family

ID=89255119

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202311343972.6A Pending CN117312347A (en) 2023-10-17 2023-10-17 Data batch updating method, device, medium and equipment

Country Status (1)

Country Link
CN (1) CN117312347A (en)

Similar Documents

Publication Publication Date Title
CN113627168B (en) Method, device, medium and equipment for checking component packaging conflict
CN111681087B (en) Information processing method, information processing device, computer readable storage medium and electronic equipment
CN110647832A (en) Method and device for acquiring information in certificate, electronic equipment and storage medium
US10664697B1 (en) Dynamically generating system-compatible transaction requests derived from external information
CN110704025A (en) Method and device for generating coding specification tool, storage medium and electronic equipment
CN111078764B (en) Data processing method, data processing device, computer readable storage medium and electronic equipment
CN110704273B (en) Processing method and device of configuration information, electronic equipment and storage medium
CN117312347A (en) Data batch updating method, device, medium and equipment
CN116362216A (en) Form data processing method, device, electronic equipment and storage medium
CN112395517B (en) House source searching and displaying method and device and computer readable storage medium
CN115687717A (en) Method, device and equipment for acquiring hook expression and computer readable storage medium
CN114189709A (en) Method and device for auditing video, storage medium and electronic equipment
CN116562954A (en) User channel attribution identification method, device, storage medium and program product
CN111324707A (en) User interaction method and device, computer-readable storage medium and electronic equipment
CN116578799A (en) Method, device and medium for realizing association of applet and third party platform
CN112016081B (en) Method, device, medium and electronic equipment for realizing identifier mapping
CN113420037B (en) Asset data real-time changing method and device
CN111597205B (en) Template configuration method, information extraction device, electronic equipment and medium
CN116562955A (en) Multi-loop throttle management method and apparatus, and computer readable storage medium
CN113609407B (en) Regional consistency verification method and device
CN117591167A (en) Method and device for rapidly analyzing and warehousing messages in multiple formats
CN117931117A (en) Automatic audio playing method, device and medium for WeChat browser
CN117573190A (en) Front-end configuration management method and device based on configuration center and container mirror image
CN115934151A (en) Method and device for building multi-terminal small program
CN116701608A (en) Automatic response method, device and medium for universal social platform

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