CN110019034A - Formfile loading method and device - Google Patents
Formfile loading method and device Download PDFInfo
- Publication number
- CN110019034A CN110019034A CN201710915247.XA CN201710915247A CN110019034A CN 110019034 A CN110019034 A CN 110019034A CN 201710915247 A CN201710915247 A CN 201710915247A CN 110019034 A CN110019034 A CN 110019034A
- Authority
- CN
- China
- Prior art keywords
- list
- source
- target
- data
- mapping relations
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
- G06F16/168—Details of user interfaces specifically adapted to file systems, e.g. browsing and visualisation, 2d or 3d GUIs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44568—Immediately runnable code
- G06F9/44578—Preparing or optimising for loading
Abstract
The invention discloses a kind of formfile loading method and devices.Wherein, this method comprises: obtaining the source list that file to be loaded includes;Determine target list corresponding with source list;Determine the mapping relations between the corresponding target list field of source list;Its corresponding target list is written into the data in the list of source according to mapping relations.The present invention solves the technical issues of can not intelligently loading formfile in the prior art.
Description
Technical field
The present invention relates to data load domains, in particular to a kind of formfile loading method and device.
Background technique
During formfile load, each step of the clear file load of user oneself is needed, user needs elder generation
Table is created, then completes file load and data cover etc. again.If user not enough understands these steps, it is unable to complete table
Monofile load, causes to affect user experience.
For above-mentioned problem, currently no effective solution has been proposed.
Summary of the invention
The embodiment of the invention provides a kind of formfile loading method and devices, at least to solve in the prior art can not
The technical issues of intelligence load formfile.
According to an aspect of an embodiment of the present invention, a kind of formfile loading method is provided, comprising: obtain to be loaded
The source list that file includes;Determine target list corresponding with the source list;Determine the corresponding target of the source list
Mapping relations between form fields;Its corresponding object table is written into the data in the source list according to the mapping relations
It is single.
Further, it is determined that target list corresponding with the source list, comprising: search database in the source list
The identical list of title;If finding list identical with the title of the source list in the database, will look into
The list found is as target list corresponding with the source list.
Further, its corresponding target list is written into the data in the source list according to the mapping relations, wrapped
It includes: receiving the selection information for selecting data writing mode;According to the selection information and the mapping relations by the source
Data in target list described in data cover in list, alternatively, the data in the source list are added to the target
In list.
Further, in searching database after list identical with the title of the source list, the method is also wrapped
It includes: if list identical with the title of the source list can not be found in the database, creating list;Using institute
The title for stating source list is named newly-built list;Newly-built list after name is completed is as the object table
It is single.
Further, its corresponding target list is written into the data in the source list according to the mapping relations, wrapped
It includes: the data in the source list being added in target list corresponding with the source list according to the mapping relations.
Further, it is determined that the mapping relations between the corresponding target list field of the source list;According to described
Its corresponding target list is written in data in the source list by mapping relations, comprising: by the source list and the target
List obtains the mapping relations with being mapped between the column of same column name;According to the mapping relations by the source table
Target data in list is written in the target column of the target list, wherein the title of the target column and the target data
The title of locating column is identical in the source list.
According to an aspect of an embodiment of the present invention, a kind of formfile loading device is provided, comprising: acquiring unit,
The source list for including for obtaining file to be loaded;First determination unit, for determining object table corresponding with the source list
It is single;Second determination unit, for determining the mapping relations between the corresponding target list field of the source list;Write-in is single
Member, for its corresponding target list to be written in the data in the source list according to the mapping relations.
Further, first determination unit includes: lookup subelement, for search in database with the source list
The identical list of title;First determines subelement, if for finding the name with the source list in the database
Claim identical list, then using the list found as target list corresponding with the source list.
Further, said write unit includes: receiving subelement, for receiving the choosing for selecting data writing mode
Select information;First write-in subelement, for according to the selection information and the mapping relations by the data in the source list
The data in the target list are covered, alternatively, the data in the source list are added in the target list.
Further, first determination unit further include: newly-built subelement is used in searching database and the source
After the identical list of the title of list, if can not find in the database identical with the title of the source list
List then creates list;Subelement is named, for being named using the title of the source list to newly-built list;Second
Subelement is determined, for the newly-built list after completing will to be named as the target list.
Further, said write unit includes: the second write-in subelement, for according to the mapping relations by the source
Data in list are added in target list corresponding with the source list.
Further, second determination unit is used to the source list and the target list having same column name
It is mapped between column, obtains the mapping relations;Said write unit is used for the source list according to the mapping relations
In target data be written in the target column of the target list, wherein the title of the target column and the target data exist
The title of locating column is identical in the source list.
According to an aspect of an embodiment of the present invention, a kind of storage medium is provided, the storage medium includes storage
Program, wherein described program executes above-mentioned formfile loading method.
According to an aspect of an embodiment of the present invention, a kind of processor is provided, the processor is used to run program,
In, described program executes above-mentioned formfile loading method when running.
In embodiments of the present invention, file to be loaded is formfile, and the list that file to be loaded includes is known as source list,
Comprising one or more sources lists in one file to be loaded, determine target list corresponding with source list, each source list and
There are mapping relations between the field of its corresponding target list, its correspondence is written into the data in the list of source according to mapping relations
Target list, the load of formfile can be completed in each step that user is not necessarily to understand file load, reached intelligence plus
The effect of formfile is carried, and then solves the technical issues of can not intelligently loading formfile in the prior art.
Detailed description of the invention
The drawings described herein are used to provide a further understanding of the present invention, constitutes a part of the invention, this hair
Bright illustrative embodiments and their description are used to explain the present invention, and are not constituted improper limitations of the present invention.In the accompanying drawings:
Fig. 1 is a kind of flow chart of formfile loading method according to an embodiment of the present invention;
Fig. 2 is a kind of schematic diagram of loading page according to an embodiment of the present invention;
Fig. 3 is the schematic diagram of another loading page according to an embodiment of the present invention;
Fig. 4 is the schematic diagram of another loading page according to an embodiment of the present invention;
Fig. 5 is the schematic diagram of another loading page according to an embodiment of the present invention;
Fig. 6 is the schematic diagram of another loading page according to an embodiment of the present invention;
Fig. 7 is the schematic diagram of another loading page according to an embodiment of the present invention;
Fig. 8 is the schematic diagram of another loading page according to an embodiment of the present invention;
Fig. 9 is the schematic diagram of another loading page according to an embodiment of the present invention;
Figure 10 is the flow chart of another formfile loading method according to an embodiment of the present invention;
Figure 11 is the flow chart of another formfile loading method according to an embodiment of the present invention;
Figure 12 is a kind of schematic diagram of formfile loading device according to an embodiment of the present invention.
Specific embodiment
In order to enable those skilled in the art to better understand the solution of the present invention, below in conjunction in the embodiment of the present invention
Attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is only
The embodiment of a part of the invention, instead of all the embodiments.Based on the embodiments of the present invention, ordinary skill people
The model that the present invention protects all should belong in member's every other embodiment obtained without making creative work
It encloses.
It should be noted that description and claims of this specification and term " first " in above-mentioned attached drawing, "
Two " etc. be to be used to distinguish similar objects, without being used to describe a particular order or precedence order.It should be understood that using in this way
Data be interchangeable under appropriate circumstances, so as to the embodiment of the present invention described herein can in addition to illustrating herein or
Sequence other than those of description is implemented.In addition, term " includes " and " having " and their any deformation, it is intended that cover
Cover it is non-exclusive include, for example, the process, method, system, product or equipment for containing a series of steps or units are not necessarily limited to
Step or unit those of is clearly listed, but may include be not clearly listed or for these process, methods, product
Or other step or units that equipment is intrinsic.
According to embodiments of the present invention, a kind of embodiment of formfile loading method is provided, it should be noted that attached
The step of process of figure illustrates can execute in a computer system such as a set of computer executable instructions, though also,
So logical order is shown in flow charts, but in some cases, it can be to be different from shown by sequence execution herein
Or the step of description.
Fig. 1 is a kind of flow chart of optional formfile loading method according to an embodiment of the present invention.
As shown in Figure 1, this method comprises the following steps:
Step S102 obtains the source list that file to be loaded includes.
Step S104 determines target list corresponding with source list.
Step S106 determines the mapping relations between the corresponding target list field of source list.
According to mapping relations its corresponding target list is written in data in the list of source by step S108.
In embodiments of the present invention, file to be loaded is formfile, and the list that file to be loaded includes is known as source list,
Comprising one or more sources lists in one file to be loaded, determine target list corresponding with source list, each source list and
There are mapping relations between the field of its corresponding target list, its correspondence is written into the data in the list of source according to mapping relations
Target list, each step that user is not necessarily to understand file load can be completed the load of formfile, solves existing skill
The problem of formfile can not be intelligently loaded in art, intelligent load formfile is achieved the effect that.
Optionally, list identical with the title of source list in database is searched;If found in the database and source
The identical list of the title of list, then using the list found as target list corresponding with source list.Searching database
In after list identical with the title of source list, if table identical with the title of source list can not be found in the database
It is single, then create list;Newly-built list is named using the title of source list;Newly-built list after name is completed
As target list.
Optionally, its corresponding target list is written into the data in the list of source according to mapping relations, comprising: reception is used for
Select the selection information of data writing mode;According to selection information and mapping relations by the data cover target list in the list of source
In data, alternatively, the data in the list of source are added in target list.
If finding list identical with the title of source list in the database, using the list found as with source
The corresponding target list of list.Prompt user inputs the selection information for selecting data writing mode, user can choose by
The data in data cover target list in the list of source, alternatively, the data in the list of source are added in target list.
After the data in the data cover target list in the list of source, original data are all deleted in target list
It removes.
After data in the list of source are added in target list, original data are all remained in target list.
Optionally, its corresponding target list is written into the data in the list of source according to mapping relations, comprising: according to mapping
Data in the list of source are added in target list corresponding with source list by relationship.
If list identical with the title of source list can not be found in the database, list is created;Use source table
Single title is named newly-built list;Newly-built list after name is completed is as target list.In this feelings
Under condition, target list is an empty list, is added to the data in the list of source according to mapping relations corresponding with source list
In target list.Column name of the column name of source list respectively as target list.
Optionally it is determined that the mapping relations between the corresponding target list field of source list;It will according to mapping relations
Its corresponding target list is written in data in the list of source, comprising: by source list and target list have same column name column it
Between mapped, obtain mapping relations;Target data in the list of source is written to the target column of target list according to mapping relations
In, wherein the title of target column is identical as the target data title of column locating in the list of source.
For example, it is assumed that source list has 3 column, from the 1st column to the 3rd column, the title of column is respectively: click volume, light exposure, click
Rate.Assuming that target list has 3 column, from the 1st column to the 3rd column, the title of column is respectively: light exposure, click volume, clicking rate.Then source
1st column of list have mapping relations with the 2nd column of target list;2nd column of source list have with the 1st column of target list to be reflected
Penetrate relationship;3rd column of source list have mapping relations with the 3rd column of target list.Target is written in the data that source list the 1st is arranged
2nd column of list;1st column of the data write-in target list that source list the 2nd is arranged;Mesh is written in the data that source list the 3rd is arranged
Mark the 3rd column of list.
The advantage of the embodiment of the present invention has: the title of the table based on user's input judges automatically the desired behavior of user: new
It builds tables of data and still updates available data;For covering available data function, selection is to carry out whole coverings or increase data;
Can intelligent adaptation data source whether include top-of-form.
In the embodiment of the present invention, user, which first uploads, needs local file to be loaded, and reselection file includes data form (source
List) the correspondence tables of data to be operated (target list), then the mapping of tables of data and original document form fields is set, followed by
User executes upload operation after determining summary information.
It is described as follows step by step:
1. file selects: directly being uploaded after needing the file uploaded as shown in Fig. 2, user determines, after uploading successfully directly
Into " data manipulation " page.Upload it is unsuccessful rest on this page, show error message.
2. setting object table: as shown in figure 3, successively loading all data sources, (only one source csv, excel load are all
sheet).Table name there is no then " newly-built table ', there is then optional " addition " or " covering ".Object table (library name+table name) can not weigh
It is multiple.The input frame of object table provides automatic prompting function, i.e., does keyword match according to current input, show successful match item
Mesh.
3. table structure is arranged: providing int, string, long, double, boolean data type.Column name is if there is big
Small letter can uniformly switch to small letter.
A) " newly-built table " configures column information, and Fig. 4 and Fig. 5 respectively correspond the newly-built table of csv and excel file.
B) " addition " or " covering " enumerates all column of object table, and provides the column mapping in target and source.Source can not be selected,
Null value (null) is inserted into object table in the source that do not select.Fig. 6 and Fig. 7 respectively corresponds the update operation of csv and excel.
4. operation summarizes: as shown in figure 8, summarizing all data manipulations.
5. execution and log: as shown in figure 9, record log information, including upper successor, uplink time.
It needs to increase the control to concurrent operations, i.e., is successively handled when there are concurrent according to the sequencing for starting to execute
User's request.
In the prior art, it needs client to understand and completes which step is local data upload operation need, if user is to this
A little steps are not known about, and are difficult to smoothly complete desired result.
The embodiment of the present invention specifies each step of local file upload by graphic interface, and guidance user splits text
It is multiple steps that part, which uploads task, is finally completed desired effect.This method can support common file to upload scene, be torn open
It is divided into corresponding several steps, user only need to execute corresponding operating according to step, so that it may realize its demand, it is easy to operate, it mentions
User experience is risen.
The advantage of the embodiment of the present invention has: the title of the table based on user's input judges automatically the desired behavior of user: new
It builds tables of data and still updates available data;For covering available data function, selection is to carry out whole coverings or increase data;
Can intelligent adaptation data source whether include top-of-form.
Figure 10 is the flow chart of another formfile loading method according to an embodiment of the present invention.As shown in Figure 10, it uses
Family directly uploads after determining the file that needs upload, and " selection target table " page is directly entered after uploading successfully.If can not upload
Function then rests on the file selection page, prompts error message.Successively load all data sources.Table name there is no then " newly-built table ',
In the presence of then optional " addition " or " covering ".Object table (library name+table name) is not reproducible.The input frame of object table provides automatic prompt
Function does keyword match according to current input, shows successful match project.
Figure 11 is the flow chart of another formfile loading method according to an embodiment of the present invention.As shown in figure 11, it looks into
Look for list identical with the title of source list in database;If finding table identical with the title of source list in the database
It is single, then using the list found as target list corresponding with source list.In this case, it receives for selecting data to write
Enter the selection information of mode;According to selection information and mapping relations by the data in the data cover target list in the list of source,
Alternatively, the data in the list of source are added in target list.The list identical with the title of source list in searching database
Later, if list identical with the title of source list can not be found in the database, list is created;Use source list
Title is named newly-built list;Newly-built list after name is completed is as target list.In this case,
The data in the list of source are added in target list corresponding with source list according to mapping relations.According to the column name in the list of source
The column name updated in target list then prompts column name repetitive error if it find that the column name in target list has repetition.For having
In the case where multiple source lists, each source list is successively operated according to above-mentioned steps, until active list number
According to being written in the corresponding target list of each source list.
The embodiment of the invention also provides a kind of formfile loading devices.The formfile loading device is for executing table
Monofile loading method.
Figure 12 is a kind of schematic diagram of optional formfile loading device according to an embodiment of the present invention, such as Figure 12 institute
Show, which includes: acquiring unit 10, the first determination unit 20, the second determination unit 30, writing unit 40.
Acquiring unit 10, the source list for including for obtaining file to be loaded.
First determination unit 20, for determining target list corresponding with source list.
Second determination unit 30, for determining the mapping relations between the corresponding target list field of source list.
Writing unit 40, for its corresponding target list to be written in the data in the list of source according to mapping relations.
Optionally, the first determination unit 20 includes: to search subelement, the first determining subelement.Subelement is searched, for looking into
Look for list identical with the title of source list in database.First determine subelement, if for find in the database with
The identical list of the title of source list, then using the list found as target list corresponding with source list.
Optionally, writing unit 40 includes: receiving subelement, the first write-in subelement.Receiving subelement is used for receiving
In the selection information of selection data writing mode.First write-in subelement, for according to selection information and mapping relations by source table
The data in data cover target list in list, alternatively, the data in the list of source are added in target list.
Optionally, the first determination unit 20 further include: newly-built subelement, name subelement, second determine subelement.It is newly-built
Subelement, after the list identical with the title of source list in searching database, if can not search in the database
To list identical with the title of source list, then list is created.Subelement is named, for using the title of source list to newly-built
List is named.Second determines subelement, for the newly-built list after completing will to be named as target list.
Optionally, writing unit 40 includes: the second write-in subelement.Second write-in subelement, for according to mapping relations
Data in the list of source are added in target list corresponding with source list.
Optionally, the second determination unit 30 is reflected between the column of same column name for source list and target list to have
It penetrates, obtains mapping relations.Writing unit 40 is used to that target list to be written in the target data in the list of source according to mapping relations
In target column, wherein the title of target column is identical as the target data title of column locating in the list of source.
Formfile loading device includes processor and memory, above-mentioned acquiring unit 10, the first determination unit 20, second
Determination unit 30, writing unit 40 etc. store in memory as program unit, are stored in memory by processor execution
In above procedure unit realize corresponding function.
Include kernel in processor, is gone in memory to transfer corresponding program unit by kernel.Kernel can be set one
Or more, formfile loading method is executed by adjusting kernel parameter.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/
Or the forms such as Nonvolatile memory, if read-only memory (ROM) or flash memory (flash RAM), memory include that at least one is deposited
Store up chip.
The embodiment of the invention provides a kind of storage mediums, are stored thereon with program, real when which is executed by processor
Existing formfile loading method.
The embodiment of the invention provides a kind of processor, processor is for running program, wherein program executes table when running
Monofile loading method.
The embodiment of the invention provides a kind of equipment, equipment include processor, memory and storage on a memory and can
The program run on a processor, processor perform the steps of when executing program
Obtain the source list that file to be loaded includes;Determine target list corresponding with source list;Determine source list and its
Mapping relations between corresponding target list field;Its corresponding target is written into the data in the list of source according to mapping relations
List.
Search list identical with the title of source list in database;If finding the name with source list in the database
Claim identical list, then using the list found as target list corresponding with source list.
Receive the selection information for selecting data writing mode;It will be in the list of source according to selection information and mapping relations
Data in data cover target list, alternatively, the data in the list of source are added in target list.
In searching database after list identical with the title of source list, if can not find in the database with
The identical list of the title of source list then creates list;Newly-built list is named using the title of source list;It will name
Newly-built list after completion is as target list.
The data in the list of source are added in target list corresponding with source list according to mapping relations.
It is mapped between the column that source list and target list are had to same column name, obtains mapping relations;According to mapping
Relationship will be in the target column of the target data write-in target list in the list of source, wherein the title and target data of target column exist
The title of locating column is identical in the list of source.
Equipment herein can be server, PC, PAD, mobile phone etc..
Present invention also provides a kind of computer program products, when executing on data processing equipment, are adapted for carrying out just
The program of beginningization there are as below methods step:
Obtain the source list that file to be loaded includes;Determine target list corresponding with source list;Determine source list and its
Mapping relations between corresponding target list field;Its corresponding target is written into the data in the list of source according to mapping relations
List.
Search list identical with the title of source list in database;If finding the name with source list in the database
Claim identical list, then using the list found as target list corresponding with source list.
Receive the selection information for selecting data writing mode;It will be in the list of source according to selection information and mapping relations
Data in data cover target list, alternatively, the data in the list of source are added in target list.
In searching database after list identical with the title of source list, if can not find in the database with
The identical list of the title of source list then creates list;Newly-built list is named using the title of source list;It will name
Newly-built list after completion is as target list.
The data in the list of source are added in target list corresponding with source list according to mapping relations.
It is mapped between the column that source list and target list are had to same column name, obtains mapping relations;According to mapping
Relationship will be in the target column of the target data write-in target list in the list of source, wherein the title and target data of target column exist
The title of locating column is identical in the list of source.
It should be understood by those skilled in the art that, embodiments herein can provide as method, system or computer program
Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the application
Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the application, which can be used in one or more,
The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) produces
The form of product.
The application is referring to method, the process of equipment (system) and computer program product according to the embodiment of the present application
Figure and/or block diagram describe.It should be understood that every one stream in flowchart and/or the block diagram can be realized by computer program instructions
The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs
Instruct the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices to produce
A raw machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for real
The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates,
Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or
The function of being specified in multiple boxes.
These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting
Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or
The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one
The step of function of being specified in a box or multiple boxes.
In a typical configuration, calculating equipment includes one or more processors (CPU), input/output interface, net
Network interface and memory.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/
Or the forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM).Memory is computer-readable Jie
The example of matter.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method
Or technology come realize information store.Information can be computer readable instructions, data structure, the module of program or other data.
The example of the storage medium of computer includes, but are not limited to phase change memory (PRAM), static random access memory (SRAM), moves
State random access memory (DRAM), other kinds of random access memory (RAM), read-only memory (ROM), electric erasable
Programmable read only memory (EEPROM), flash memory or other memory techniques, read-only disc read only memory (CD-ROM) (CD-ROM),
Digital versatile disc (DVD) or other optical storage, magnetic cassettes, tape magnetic disk storage or other magnetic storage devices
Or any other non-transmission medium, can be used for storage can be accessed by a computing device information.As defined in this article, it calculates
Machine readable medium does not include temporary computer readable media (transitory media), such as the data-signal and carrier wave of modulation.
It should also be noted that, the terms "include", "comprise" or its any other variant are intended to nonexcludability
It include so that the process, method, commodity or the equipment that include a series of elements not only include those elements, but also to wrap
Include other elements that are not explicitly listed, or further include for this process, method, commodity or equipment intrinsic want
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including element
There is also other identical elements in process, method, commodity or equipment.
It will be understood by those skilled in the art that embodiments herein can provide as method, system or computer program product.
Therefore, complete hardware embodiment, complete software embodiment or embodiment combining software and hardware aspects can be used in the application
Form.It is deposited moreover, the application can be used to can be used in the computer that one or more wherein includes computer usable program code
The shape for the computer program product implemented on storage media (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.)
Formula.
The above is only embodiments herein, are not intended to limit this application.To those skilled in the art,
Various changes and changes are possible in this application.It is all within the spirit and principles of the present application made by any modification, equivalent replacement,
Improve etc., it should be included within the scope of the claims of this application.
Claims (10)
1. a kind of formfile loading method characterized by comprising
Obtain the source list that file to be loaded includes;
Determine target list corresponding with the source list;
Determine the mapping relations between the corresponding target list field of the source list;
Its corresponding target list is written into the data in the source list according to the mapping relations.
2. the method according to claim 1, wherein determining target list corresponding with the source list, comprising:
Search list identical with the title of the source list in database;
If finding list identical with the title of the source list in the database, using the list found as
Target list corresponding with the source list.
3. according to the method described in claim 2, it is characterized in that, according to the mapping relations by the data in the source list
Its corresponding target list is written, comprising:
Receive the selection information for selecting data writing mode;
According to the selection information and the mapping relations by the number in target list described in the data cover in the source list
According to alternatively, the data in the source list are added in the target list.
4. according to the method described in claim 2, it is characterized in that, identical as the title of the source list in searching database
List after, the method also includes:
If list identical with the title of the source list can not be found in the database, list is created;
Newly-built list is named using the title of the source list;
Newly-built list after name is completed is as the target list.
5. according to the method described in claim 4, it is characterized in that, according to the mapping relations by the data in the source list
Its corresponding target list is written, comprising:
The data in the source list are added in target list corresponding with the source list according to the mapping relations.
6. the method according to claim 1, wherein determining the corresponding target list field of the source list
Between mapping relations;Its corresponding target list is written into the data in the source list according to the mapping relations, comprising:
It is mapped between the column that the source list and the target list are had to same column name, obtains the mapping relations;
The target data in the source list is written in the target column of the target list according to the mapping relations, wherein
The title of the target column is identical as the target data title of column locating in the source list.
7. a kind of formfile loading device characterized by comprising
Acquiring unit, the source list for including for obtaining file to be loaded;
First determination unit, for determining target list corresponding with the source list;
Second determination unit, for determining the mapping relations between the corresponding target list field of the source list;
Writing unit, for its corresponding target list to be written in the data in the source list according to the mapping relations.
8. device according to claim 7, which is characterized in that first determination unit includes:
Subelement is searched, for searching list identical with the title of the source list in database;
First determines subelement, if for finding list identical with the title of the source list in the database,
Then using the list found as target list corresponding with the source list.
9. a kind of storage medium, which is characterized in that the storage medium includes the program of storage, wherein described program right of execution
Benefit require any one of 1 to 6 described in formfile loading method.
10. a kind of processor, which is characterized in that the processor is for running program, wherein right of execution when described program is run
Benefit require any one of 1 to 6 described in formfile loading method.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710915247.XA CN110019034A (en) | 2017-09-29 | 2017-09-29 | Formfile loading method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710915247.XA CN110019034A (en) | 2017-09-29 | 2017-09-29 | Formfile loading method and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110019034A true CN110019034A (en) | 2019-07-16 |
Family
ID=67186439
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710915247.XA Pending CN110019034A (en) | 2017-09-29 | 2017-09-29 | Formfile loading method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110019034A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110765747A (en) * | 2019-10-31 | 2020-02-07 | 浪潮云信息技术有限公司 | Project construction project service declaration and tabulation method |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105095327A (en) * | 2014-05-23 | 2015-11-25 | 深圳市珍爱网信息技术有限公司 | Distributed ELT system and scheduling method |
CN106528821A (en) * | 2016-11-16 | 2017-03-22 | 济南浪潮高新科技投资发展有限公司 | Method for importing change column data into database |
CN106598977A (en) * | 2015-10-15 | 2017-04-26 | 北京国双科技有限公司 | Data migration method and device |
-
2017
- 2017-09-29 CN CN201710915247.XA patent/CN110019034A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105095327A (en) * | 2014-05-23 | 2015-11-25 | 深圳市珍爱网信息技术有限公司 | Distributed ELT system and scheduling method |
CN106598977A (en) * | 2015-10-15 | 2017-04-26 | 北京国双科技有限公司 | Data migration method and device |
CN106528821A (en) * | 2016-11-16 | 2017-03-22 | 济南浪潮高新科技投资发展有限公司 | Method for importing change column data into database |
Non-Patent Citations (3)
Title |
---|
中华人民共和国审计署《AO》研发项目组: "《现场审计实施系统实用手册》", 30 April 2006 * |
佚名: "Excel中的表格数据怎么导入数据库中", 《HTTPS://WWW.JB51.NET/OFFICE/EXCEL/410784.HTML》 * |
学习啦: "怎么将Excel中的数据传到数据库中", 《HTTPS://WWW.XUEXILA.COM/DIANNAO/WANGLUO/JUYUWANG/1895442.HTML》 * |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110765747A (en) * | 2019-10-31 | 2020-02-07 | 浪潮云信息技术有限公司 | Project construction project service declaration and tabulation method |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US9348563B1 (en) | Bi-directional editing between visual screen designer and source code | |
CN106569783B (en) | Method and device for executing task script | |
CN105426223B (en) | Using loading method and device | |
US10656907B2 (en) | Translation of natural language into user interface actions | |
CN109446570B (en) | Business process display method, device, computer equipment and storage medium | |
CN104731589A (en) | Automatic generation method and device of user interface (UI) | |
CN111443912B (en) | Component-based page rendering method, device, computer equipment and storage medium | |
CN105573734B (en) | method and equipment for providing SDK file | |
US20230085750A1 (en) | Code generator platform for data transformation | |
EP2965492B1 (en) | Selection of data storage settings for an application | |
CN104423961A (en) | Method and system for generating testing script | |
US11610155B2 (en) | Data processing system and data processing method | |
CN110442826B (en) | Cross-layer page jumping method, device and system based on page identification | |
CN103984554A (en) | Software design document generating method and device | |
US20130091448A1 (en) | Transformative user interfaces | |
CN112235132B (en) | Method, device, medium and server for dynamically configuring service | |
US10042638B2 (en) | Evaluating documentation coverage | |
US11262986B2 (en) | Automatic software generation for computer systems | |
CN105739717B (en) | Data inputting method and device | |
US11221923B2 (en) | Performing selective backup operations | |
CN110019034A (en) | Formfile loading method and device | |
CN103678687A (en) | Project establishment method and device based on configuration system | |
CN111142990A (en) | WeChat applet page display method and device and storage medium | |
CN111191795B (en) | Method, device and system for training machine learning model | |
CN109683887A (en) | A kind of construction method and device for supporting the customized web project of multi-scheme |
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 | ||
CB02 | Change of applicant information |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Applicant after: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A Applicant before: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. |
|
CB02 | Change of applicant information | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190716 |
|
RJ01 | Rejection of invention patent application after publication |