CN110580334A - Target table template uploading method and device, storage medium and electronic device - Google Patents
Target table template uploading method and device, storage medium and electronic device Download PDFInfo
- Publication number
- CN110580334A CN110580334A CN201910860058.6A CN201910860058A CN110580334A CN 110580334 A CN110580334 A CN 110580334A CN 201910860058 A CN201910860058 A CN 201910860058A CN 110580334 A CN110580334 A CN 110580334A
- Authority
- CN
- China
- Prior art keywords
- target table
- template
- uploading
- target
- table template
- 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.)
- Withdrawn
Links
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/06—Protocols specially adapted for file transfer, e.g. file transfer protocol [FTP]
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Stored Programmes (AREA)
Abstract
The invention provides a target table template uploading method and device, a storage medium and an electronic device, wherein the method comprises the following steps: acquiring a format of a first target table to be uploaded and field information in the first target table; filling the field information into a first target table template according to the format of the first target table; the first target table template is uploaded to background equipment under the triggering of a specified event, and by adopting the technical scheme, the problems that a large amount of labor cost is required to be invested in a mode of manually establishing the target table in the related technology, the efficiency is low and the like are solved.
Description
Technical Field
The invention relates to the field of communication, in particular to a target table template uploading method and device, a storage medium and an electronic device.
Background
With the application of tables, in the related art, in the data governance stage, the establishment of the target table is always a complex and monotonous stage which requires a patience configuration and a great deal of labor, and the manual method for establishing the target table requires a great deal of labor cost and is very inefficient.
Aiming at the problems that in the related art, a large amount of labor cost is required to be invested in a mode of manually establishing a target table, the efficiency is low and the like, an effective technical scheme is not provided.
disclosure of Invention
The embodiment of the invention provides a target table template uploading method and device, a storage medium and an electronic device, and aims to at least solve the problems that a large amount of labor cost is required to be invested in a mode of manually establishing a target table in the related technology, the efficiency is low and the like.
According to an embodiment of the invention, there is provided a target table template uploading method, including: acquiring a format of a first target table to be uploaded and field information in the first target table; filling the field information into a first target table template according to the format of the first target table; and uploading the first target table template to background equipment under the triggering of a specified event.
In this embodiment of the present invention, after the first target table template is uploaded to a background device, the method further includes: and under the condition that the background equipment detects that the designated field in the field information has a relationship or event relation with a second target table, establishing the relationship or event relation between the second target table and the designated field when uploading a second target template of the second target table to the background equipment.
In this embodiment of the present invention, the first target table template includes a plurality of working pages, where each working page corresponds to one target table, and the target table includes at least one of the following: the first target table and the second target table.
In this embodiment of the present invention, uploading the first target table template to a background device under the trigger of a specific event includes: and uploading the first target table template to background equipment under the condition that a target object is detected to click a preset button for uploading the target table template.
According to another embodiment of the present invention, there is also provided an apparatus for uploading a target table template, including: the device comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring the format of a first target table to be uploaded and field information in the first target table; the filling module is used for filling the field information into the first target table template according to the format of the first target table; and the uploading module is used for uploading the first target table template to background equipment under the triggering of a specified event.
In an embodiment of the present invention, the apparatus further includes: the establishing module is used for establishing the relation or the event relation between the second target table and the designated field when the background equipment detects that the designated field in the field information has the relation or the event relation with the second target table and the second target table is uploaded to the background equipment.
in this embodiment of the present invention, the first target table template includes a plurality of working pages, where each working page corresponds to one target table, and the target table includes at least one of the following: the first target table and the second target table.
In the embodiment of the present invention, the uploading module is further configured to upload the first target table template to the background device when it is detected that the target object clicks a preset upload target table template button.
According to a further embodiment of the present invention, there is also provided a storage medium having a computer program stored therein, wherein the computer program is arranged to perform the steps of any of the above method embodiments when executed.
according to yet another embodiment of the present invention, there is also provided an electronic device, including a memory in which a computer program is stored and a processor configured to execute the computer program to perform the steps in any of the above method embodiments.
according to the invention, the format of the first target table to be uploaded and the field information in the first target table are acquired; filling the field information into a first target table template according to the format of the first target table; the method and the device have the advantages that the first target table template is uploaded to the background device under the triggering of the specified event, the problems that a large amount of labor cost is needed and the efficiency is low in a mode that a target table needs to be established manually can be solved, the target table is established through the target table template, and the target table template filled with the target table is uploaded to the background device.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
Fig. 1 is a block diagram of a hardware structure of a mobile terminal of an uploading method of a target table template according to an embodiment of the present invention;
FIG. 2 is a flow diagram of a method for uploading a target table template according to an embodiment of the invention;
FIG. 3 is a block diagram of an uploading apparatus of a target table template according to an embodiment of the present invention;
FIG. 4 is another block diagram of an apparatus for uploading a target table template according to an embodiment of the present invention;
FIG. 5 is a flowchart of the processing of a target table template in accordance with a preferred embodiment of the present invention.
Detailed Description
the invention will be described in detail hereinafter with reference to the accompanying drawings in conjunction with embodiments. It should be noted that the embodiments and features of the embodiments in the present application may be combined with each other without conflict.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order.
the method provided by the embodiment 1 of the present application can be executed in a mobile terminal, a computer terminal or a similar computing device. Taking the example of running on a mobile terminal, fig. 1 is a hardware structure block diagram of the mobile terminal of an uploading method of a target table template according to an embodiment of the present invention. As shown in fig. 1, the mobile terminal 10 may include one or more (only one shown in fig. 1) processors 102 (the processor 102 may include, but is not limited to, a processing device such as a microprocessor MCU or a programmable logic device FPGA) and a memory 104 for storing data, and optionally may also include a transmission device 106 for communication functions and an input-output device 108. It will be understood by those skilled in the art that the structure shown in fig. 1 is only an illustration, and does not limit the structure of the mobile terminal. For example, the mobile terminal 10 may also include more or fewer components than shown in FIG. 1, or have a different configuration with equivalent functionality to that shown in FIG. 1 or more functionality than that shown in FIG. 1.
The memory 104 may be used to store computer programs, for example, software programs and modules of application software, such as a computer program corresponding to the uploading method of the target table template in the embodiment of the present invention, and the processor 102 executes various functional applications and data processing by running the computer programs stored in the memory 104, so as to implement the above-mentioned method. The memory 104 may include high speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some instances, the memory 104 may further include memory located remotely from the processor 102, which may be connected to the mobile terminal 10 via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The transmission device 106 is used for receiving or transmitting data via a network. Specific examples of the network described above may include a wireless network provided by a communication provider of the mobile terminal 10. In one example, the transmission device 106 includes a Network adapter (NIC), which can be connected to other Network devices through a base station so as to communicate with the internet. In one example, the transmission device 106 may be a Radio Frequency (RF) module, which is used for communicating with the internet in a wireless manner.
In this embodiment, a method for uploading a target table template running on the mobile terminal is provided, and fig. 2 is a flowchart of the method for uploading a target table template according to the embodiment of the present invention, as shown in fig. 2, the flowchart includes the following steps:
Step S202, acquiring a format of a first target table to be uploaded and field information in the first target table;
Step S204, filling the field information into a first target table template according to the format of the first target table;
And step S206, uploading the first target table template to background equipment under the trigger of a specified event.
According to the invention, the format of the first target table to be uploaded and the field information in the first target table are acquired; filling the field information into a first target table template according to the format of the first target table; the method and the device have the advantages that the first target table template is uploaded to the background device under the triggering of the specified event, the problems that a large amount of labor cost is needed and the efficiency is low in a mode that a target table needs to be established manually can be solved, the target table is established through the target table template, and the target table template filled with the target table is uploaded to the background device.
In this embodiment of the present invention, after the first target table template is uploaded to a background device, the method further includes: and under the condition that the background equipment detects that the designated field in the field information has a relationship or event relation with a second target table, establishing the relationship or event relation between the second target table and the designated field when uploading a second target template of the second target table to the background equipment.
In this embodiment of the present invention, the first target table template includes a plurality of working pages, where each working page corresponds to one target table, and the target table includes at least one of the following: the first target table and the second target table.
in this embodiment of the present invention, uploading the first target table template to a background device under the trigger of a specific event includes: and uploading the first target table template to background equipment under the condition that a target object is detected to click a preset button for uploading the target table template.
In this embodiment of the present invention, filling the field information into the first target table template according to the format of the first target table includes: selecting a first target table template from a plurality of target table templates; and filling the field information into the first target table template according to the format of the first target table.
In this embodiment of the present invention, after the first target table template is uploaded to a background device under the trigger of a specific event, the method further includes: displaying the first target table template on a display device in the form of a knowledge graph; or directly displaying the first target table template on a display interface of the display equipment.
The following, in conjunction with an example, is a process of uploading the target table template: and uploading a key to generate a target table in a target table template mode, and generating a knowledge graph to establish events and relations among the entities.
In order to better understand the technical solutions of the following examples, the following terms involved in the examples of the present invention are explained:
Target table: and the treatment result output table is divided into entities, events and relations according to the service information.
entity: refers to a class of objects that are not further segmented in reality.
The relationship is as follows: a class of objects that characterize various associations between entities.
Event: the subject must be an entity and the object can be an entity, which describes a class of objects of the relationship between the subject and the object in a specific space-time dimension (such as an internet cafe, a station and the like).
Knowledge graph: and the map is used for showing the target table entities, events and relations.
An example of the invention comprises the steps of:
step 1, preparing a target table template (Excel format) table T, and filling contents according to the format.
And 2, selecting the table T to upload by clicking a button for rapidly adding the target table field.
Note that, the table T includes a field a, a field b, and a field c.
And 3, the background inserts the table T and the fields in the table T into the library, and if the fields in the table have other configurations, such as the relation or the event between the field a and other tables O, the relation or the event is automatically established when the table O is uploaded.
Alternatively, the data can be uploaded in batch through working pages in the target table template, wherein each working page is a table.
The flow of uploading the target table template is described below with reference to another alternative example.
step A, editing a target table to be uploaded in a template, wherein the target table comprises field information in the target table.
And B, clicking a 'quick uploading target table field' button, selecting a target table template, and clicking to upload.
and step C, checking the uploading result on the knowledge graph or the target table page after uploading.
through the above description of the embodiments, those skilled in the art can clearly understand that the method according to the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but the former is a better implementation mode in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
In this embodiment, an apparatus for uploading a target table template is further provided, and the apparatus is used to implement the foregoing embodiments and preferred embodiments, and the description already made is not repeated. As used below, the term "module" may be a combination of software and/or hardware that implements a predetermined function. Although the means described in the embodiments below are preferably implemented in software, an implementation in hardware, or a combination of software and hardware is also possible and contemplated.
Fig. 3 is a block diagram illustrating a structure of an apparatus for uploading a target table template according to an embodiment of the present invention, and as shown in fig. 3, the apparatus includes:
An obtaining module 30, configured to obtain a format of a first target table to be uploaded and field information in the first target table;
A filling module 32, configured to fill the field information into the first target table template according to the format of the first target table;
and the uploading module 34 is configured to upload the first target table template to a background device under the trigger of a specified event.
According to the invention, the format of the first target table to be uploaded and the field information in the first target table are acquired; filling the field information into a first target table template according to the format of the first target table; the method and the device have the advantages that the first target table template is uploaded to the background device under the triggering of the specified event, the problems that a large amount of labor cost is needed and the efficiency is low in a mode that a target table needs to be established manually can be solved, the target table is established through the target table template, and the target table template filled with the target table is uploaded to the background device.
fig. 4 is a block diagram illustrating a structure of an apparatus for uploading a target table template according to an embodiment of the present invention, and as shown in fig. 4, the apparatus includes, in addition to all modules shown in fig. 3:
The establishing module 36 is configured to, when it is detected by the background device that a relationship or an event relationship exists between a specified field in the field information and a second target table, upload a second target template of the second target table to the background device, and establish the relationship or the event relationship between the second target table and the specified field.
In this embodiment of the present invention, the first target table template includes a plurality of working pages, where each working page corresponds to one target table, and the target table includes at least one of the following: the first target table and the second target table.
In this embodiment of the present invention, the uploading module 34 is further configured to upload the first target table template to a background device when it is detected that the target object clicks a preset upload target table template button.
in this embodiment of the present invention, the populating module 32 is further configured to select a first target table template from the plurality of target table templates; and filling the field information into the first target table template according to the format of the first target table.
as shown in fig. 4, the apparatus further includes: a display module 38, configured to display the first target table template on a display device in a form of a knowledge graph; or directly displaying the first target table template on a display interface of the display equipment.
It should be noted that, the above modules may be implemented by software or hardware, and for the latter, the following may be implemented, but not limited to: the modules are all positioned in the same processor; alternatively, the modules are respectively located in different processors in any combination.
FIG. 5 is a flowchart of the processing of a target table template according to the preferred embodiment of the present invention, as shown in FIG. 5, including:
And step S502, editing a target table template, and uploading through a function of quickly adding a target table field.
Step S504, the template content is analyzed, whether events/relations are related to other tables is found, and the data are inserted into the database in batches at the later date.
and step S506, displaying on a target table page or a knowledge graph page.
Embodiments of the present invention also provide a storage medium having a computer program stored therein, wherein the computer program is arranged to perform the steps of any of the above method embodiments when executed.
Alternatively, in the present embodiment, the storage medium may be configured to store a computer program for executing the steps of:
S1, acquiring the format of a first target table to be uploaded and the field information in the first target table;
S2, filling the field information into the first target table template according to the format of the first target table;
And S3, uploading the first target table template to a background device under the trigger of a specified event.
Optionally, in this embodiment, the storage medium may include, but is not limited to: various media capable of storing computer programs, such as a usb disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic disk, or an optical disk.
Embodiments of the present invention also provide an electronic device comprising a memory having a computer program stored therein and a processor arranged to run the computer program to perform the steps of any of the above method embodiments.
optionally, the electronic apparatus may further include a transmission device and an input/output device, wherein the transmission device is connected to the processor, and the input/output device is connected to the processor.
Optionally, in this embodiment, the processor may be configured to execute the following steps by a computer program:
S1, acquiring the format of a first target table to be uploaded and the field information in the first target table;
s2, filling the field information into the first target table template according to the format of the first target table;
And S3, uploading the first target table template to a background device under the trigger of a specified event.
Optionally, the specific examples in this embodiment may refer to the examples described in the above embodiments and optional implementation manners, and this embodiment is not described herein again.
it will be apparent to those skilled in the art that the modules or steps of the present invention described above may be implemented by a general purpose computing device, they may be centralized on a single computing device or distributed across a network of multiple computing devices, and alternatively, they may be implemented by program code executable by a computing device, such that they may be stored in a storage device 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 above description is only a preferred embodiment of the present invention and is not intended to limit the present invention, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, or improvement made within the principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. An uploading method of a target table template, comprising:
Acquiring a format of a first target table to be uploaded and field information in the first target table;
filling the field information into a first target table template according to the format of the first target table;
And uploading the first target table template to background equipment under the triggering of a specified event.
2. The method of claim 1, wherein after uploading the first target table template to a backend device, the method further comprises:
And under the condition that the background equipment detects that the designated field in the field information has a relationship or event relation with a second target table, establishing the relationship or event relation between the second target table and the designated field when uploading a second target template of the second target table to the background equipment.
3. The method of claim 1, wherein the first target table template comprises a plurality of working pages, wherein each working page corresponds to a target table, and wherein the target table comprises at least one of: the first target table and the second target table.
4. The method of claim 1, wherein uploading the first target table template to a backend device triggered by a specified event comprises:
And uploading the first target table template to background equipment under the condition that a target object is detected to click a preset button for uploading the target table template.
5. an apparatus for uploading a target table template, comprising:
the device comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring the format of a first target table to be uploaded and field information in the first target table;
the filling module is used for filling the field information into the first target table template according to the format of the first target table;
And the uploading module is used for uploading the first target table template to background equipment under the triggering of a specified event.
6. The apparatus of claim 5, further comprising:
The establishing module is used for establishing the relation or the event relation between the second target table and the designated field when the background equipment detects that the designated field in the field information has the relation or the event relation with the second target table and the second target table is uploaded to the background equipment.
7. The apparatus of claim 5, wherein the first target table template comprises a plurality of working pages, wherein each working page corresponds to a target table, and wherein the target table comprises at least one of: the first target table and the second target table.
8. the apparatus of claim 5, wherein the upload module is further configured to upload the first target table template to a backend device if it is detected that a target object clicks a preset upload target table template button.
9. A computer-readable storage medium, in which a computer program is stored, wherein the computer program is configured to carry out the method of any one of claims 1 to 4 when executed.
10. an electronic device comprising a memory and a processor, wherein the memory has stored therein a computer program, and wherein the processor is arranged to execute the computer program to perform the method of any of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910860058.6A CN110580334A (en) | 2019-09-11 | 2019-09-11 | Target table template uploading method and device, storage medium and electronic device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910860058.6A CN110580334A (en) | 2019-09-11 | 2019-09-11 | Target table template uploading method and device, storage medium and electronic device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110580334A true CN110580334A (en) | 2019-12-17 |
Family
ID=68811213
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910860058.6A Withdrawn CN110580334A (en) | 2019-09-11 | 2019-09-11 | Target table template uploading method and device, storage medium and electronic device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110580334A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN108920452A (en) * | 2018-06-08 | 2018-11-30 | 北京明略软件系统有限公司 | A kind of information processing method and device |
| CN109284463A (en) * | 2018-08-15 | 2019-01-29 | 山东鲁能软件技术有限公司 | A kind of method of data capture and system based on dynamic template |
| CN109657214A (en) * | 2018-09-27 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Report form generation method, device, terminal and storage medium |
| CN109766338A (en) * | 2018-11-28 | 2019-05-17 | 杭州云为科技有限公司 | Self-defined report design method, electronic equipment, storage medium and system |
| WO2019109518A1 (en) * | 2017-12-08 | 2019-06-13 | 平安科技（深圳）有限公司 | Data list uploading method and terminal thereof |
-
2019
- 2019-09-11 CN CN201910860058.6A patent/CN110580334A/en not_active Withdrawn
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| WO2019109518A1 (en) * | 2017-12-08 | 2019-06-13 | 平安科技（深圳）有限公司 | Data list uploading method and terminal thereof |
| CN108920452A (en) * | 2018-06-08 | 2018-11-30 | 北京明略软件系统有限公司 | A kind of information processing method and device |
| CN109284463A (en) * | 2018-08-15 | 2019-01-29 | 山东鲁能软件技术有限公司 | A kind of method of data capture and system based on dynamic template |
| CN109657214A (en) * | 2018-09-27 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Report form generation method, device, terminal and storage medium |
| CN109766338A (en) * | 2018-11-28 | 2019-05-17 | 杭州云为科技有限公司 | Self-defined report design method, electronic equipment, storage medium and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111176976B (en) | Test data generation method and device, storage medium and electronic device | |
| CN108062367B (en) | Data list uploading method and terminal thereof | |
| CN108255847B (en) | Page generation method and device | |
| CN110245128B (en) | Meta-model establishing method and device, storage medium and electronic device | |
| CN111177243B (en) | Data export method and device, storage medium and electronic device | |
| CN112632420A (en) | Interface skipping method and device, storage medium and electronic device | |
| CN111782317A (en) | Page testing method and device, storage medium and electronic device | |
| CN115526160A (en) | Rich text processing method, device and equipment and storage medium | |
| CN110532559B (en) | Rule processing method and device | |
| CN110941634A (en) | Data processing method and device, storage medium and electronic device | |
| CN116827774A (en) | Service analysis method, device, equipment and storage medium | |
| CN106557419B (en) | Program testing method and device | |
| CN110569129A (en) | Resource allocation method and device, storage medium and electronic device | |
| CN110990381B (en) | Processing method and device of server, storage medium and electronic device | |
| CN112214701A (en) | Page display method and system, storage medium and electronic device | |
| CN111026047B (en) | Software configuration method and device | |
| CN110580334A (en) | Target table template uploading method and device, storage medium and electronic device | |
| CN110532267A (en) | Determination method, apparatus, storage medium and the electronic device of field | |
| CN113190565B (en) | Data updating method and device, storage medium and electronic device | |
| CN113110982B (en) | Data access layer verification method and device, storage medium and electronic device | |
| CN113934591A (en) | Data monitoring method and device, storage medium and electronic device | |
| CN113934552A (en) | Method and device for determining function code, storage medium and electronic device | |
| CN110673879A (en) | One-key adjustment method and device for element style of configuration software | |
| CN108874553B (en) | Message pushing method, device and system, storage medium and processor | |
| CN111008220A (en) | Dynamic identification method and device of data source, storage medium and electronic device |
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 | ||
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20191217 |