CN110737636A - data importing method, device and equipment - Google Patents

data importing method, device and equipment Download PDF

Info

Publication number
CN110737636A
CN110737636A CN201910906522.0A CN201910906522A CN110737636A CN 110737636 A CN110737636 A CN 110737636A CN 201910906522 A CN201910906522 A CN 201910906522A CN 110737636 A CN110737636 A CN 110737636A
Authority
CN
China
Prior art keywords
file
files
markup language
extensible markup
different structures
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201910906522.0A
Other languages
Chinese (zh)
Other versions
CN110737636B (en
Inventor
黄永刚
沈毅
柯文朴
姚思明
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Xiamen Information Group Big Data Operation Co Ltd
Original Assignee
Xiamen Information Group Big Data Operation 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 Xiamen Information Group Big Data Operation Co Ltd filed Critical Xiamen Information Group Big Data Operation Co Ltd
Priority to CN201910906522.0A priority Critical patent/CN110737636B/en
Publication of CN110737636A publication Critical patent/CN110737636A/en
Application granted granted Critical
Publication of CN110737636B publication Critical patent/CN110737636B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/16File or folder operations, e.g. details of user interfaces specifically adapted to file systems

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Human Computer Interaction (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses data importing method, device and equipment, wherein the method comprises the steps of selecting and reading files under a file transmission protocol directory for placing extensible markup language data files, analyzing extensible markup language data files with different structures into a file format matched with the files under the file transmission protocol directory, creating a table structure for the analyzed extensible markup language data files, obtaining quantitative data of the extensible markup language data files after the table structure is created, carrying out accuracy verification on the extensible markup language data files after the table structure is created according to the quantitative data to obtain a verification result, importing the extensible markup language data files with different structures, the verification result of which passes the accuracy verification, into the files under the same file transmission protocol directory, and placing the extensible markup language data files with different data structures into the files under the same file transmission protocol directory.

Description

data importing method, device and equipment
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a data importing method, apparatus and device.
Background
XML (Extensible Markup Language), which is a cross-platform, content-dependent technology in a network environment, is a powerful tool for processing structured document information at present, XML is the most common simple data storage Language today, which can describe data using series of simple custom tags.
In the conventional data import scheme, generally requires that files placed in an FTP (File Transfer Protocol) directory are XML data files, and the data structures of the XML data files placed in the File Transfer Protocol FTP directory need to be the same, so that it is impossible to place XML data files with different data structures in the File Transfer Protocol directory .
Disclosure of Invention
In view of the above, the present invention aims to provide data importing methods, apparatuses, and devices, which are capable of implementing placing xml data files with different data structures into files in the same file transfer protocol directory.
According to aspects of the invention, data importing methods are provided, which comprise:
selecting and reading files in a file transfer protocol directory for placing extensible markup language data files;
analyzing extensible markup language data files with different structures into a file format matched with the selected and read file under the file transmission protocol directory;
creating a table structure for the XML data files with different structures which are analyzed to be matched with the file formats of the files under the selected and read file transmission protocol directory;
acquiring quantitative data of the extensible markup language data files with different structures after the table structures are created;
according to the obtained quantitative data, carrying out accuracy verification on the extensible markup language data files with different structures after the table structures are created to obtain verification results;
and importing the extensible markup language data files with different structures, the verification results of which pass the accuracy verification, into files under the same file transfer protocol directory.
The parsing of the extensible markup language data files with different structures into a file format matching the file under the selected and read file transfer protocol directory comprises the following steps:
and analyzing the extensible markup language data files with different structures simultaneously or respectively to obtain the same or different file formats matched with the selected and read files under the file transmission protocol directory.
Wherein the creating a table structure for the XML data files of different structures that are parsed into file formats that match the selected and read files under the file transfer protocol directory comprises:
and creating a table structure for the extensible markup language data file which is analyzed into different structures matched with the file format of the file under the selected and read file transmission protocol directory in a mode of adding fields in the table structure.
After the extensible markup language data files with different structures and the verification result of which passes the accuracy verification are imported into the file under the same file transfer protocol directory, the method further comprises the following steps:
and generating a blood margin view by the extensible markup language data files with different structures imported into the files under the same file transmission protocol directory, wherein the generated blood margin view comprises a source node, an intermediate node and a storage node of the extensible markup language data files.
According to another aspects of the present invention, there are provided data importing apparatuses, including:
the system comprises a selection module, an analysis module, a creation module, an acquisition module, a verification module and an import module;
the selection module is used for selecting and reading files in a file transfer protocol directory for placing extensible markup language data files;
the analysis module is used for analyzing the extensible markup language data files with different structures into a file format matched with the selected and read file under the file transmission protocol directory;
the creation module is used for creating a table structure for the extensible markup language data files which are analyzed into different structures which are matched with the file formats of the files under the selected and read file transmission protocol directory;
the acquisition module is used for acquiring quantitative data of the extensible markup language data files with different structures after the table structures are created;
the verification module is used for carrying out accuracy verification on the extensible markup language data files with different structures after the table structures are created according to the obtained quantitative data to obtain verification results;
the import module is used for importing extensible markup language data files with different structures, the verification results of which pass the accuracy verification, into files in the same file transfer protocol directory.
Wherein, the analysis module is specifically configured to:
and analyzing the extensible markup language data files with different structures simultaneously or respectively to obtain the same or different file formats matched with the selected and read files under the file transmission protocol directory.
Wherein the creating module is specifically configured to:
and creating a table structure for the extensible markup language data file which is analyzed into different structures matched with the file format of the file under the selected and read file transmission protocol directory in a mode of adding fields in the table structure.
Wherein, the data import device further comprises:
a generation module;
the generating module is used for generating the blood margin view of the extensible markup language data files with different structures which are imported into the files under the same file transmission protocol directory, wherein the generated blood margin view comprises a source node, an intermediate node and a storage node of the extensible markup language data files.
According to still another aspects of the present invention, there are provided kinds of data import apparatuses, including:
at least processors, and,
a memory communicatively coupled to the at least processors, wherein,
the memory stores instructions executable by the at least processors to enable the at least processors to perform a data import method as in any of above.
According to still aspects of the present invention, there are provided computer-readable storage media storing a computer program, wherein the computer program when executed by a processor implements the data import method as recited in any of above.
It can be found that, according to the above solution, the file under the file transfer protocol directory for placing the xml data file can be selected and read, and the xml data files with different structures can be analyzed to be matched with the file format of the file under the selected and read file transfer protocol directory, and a table structure can be created for the xml data files with different structures, which are analyzed to be matched with the file format of the file under the selected and read file transfer protocol directory, and the quantitative data of the xml data files with different structures after the table structure is created can be obtained, and the xml data files with different structures after the table structure is created can be accurately checked according to the obtained quantitative data to obtain the check result, and the xml data files with different structures, which pass the check result and are accurately checked, can be imported into the file under the same file transfer protocol directory , so that the xml data files with different data structures can be placed into the file under the same file transfer protocol directory .
, the above solution can parse the xml data files with different structures into the same or different file formats matching the file in the selected and read file transfer protocol directory simultaneously or separately, which is advantageous for placing the xml data files with different structures into the file in the same file transfer protocol directory .
, the above solution can create a table structure for the xml data file parsed into different structures matching the file format of the file under the selected and read file transfer protocol directory by adding fields in the table structure, which has the advantage of being able to conveniently record and manage the xml data file corresponding to the created table structure through the added fields.
, according to the above scheme, the blood margin view can be generated for the xml data files with different structures imported into the file under the file transmission protocol directory of the same , wherein the generated blood margin view includes the source node, the intermediate node, the storage node, and the like of the xml data files, which is beneficial for conveniently classifying and managing the xml data files with different structures imported into the file under the file transmission protocol directory of the same , and improving the management efficiency.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts.
FIG. 1 is a flow chart illustrating an embodiment of a data import method of the present invention;
FIG. 2 is a schematic flow chart diagram illustrating another embodiment of a data import method according to the present invention;
FIG. 3 is a schematic structural diagram of an embodiment of the data import device of the present invention;
FIG. 4 is a schematic structural diagram of another embodiment of the data import apparatus;
fig. 5 is a schematic structural diagram of an embodiment of the data import apparatus of the present invention.
Detailed Description
The present invention is described in further detail with reference to the drawings and examples, it is to be expressly understood that the following examples are illustrative only and are not intended to limit the scope of the invention.
The invention provides data importing methods, which can realize that extensible markup language data files with different data structures are placed in files in the same file transfer protocol directory.
Referring to FIG. 1, FIG. 1 is a flow chart illustrating an embodiment of a data importing method of the present invention, it should be noted that the method of the present invention is not limited to the flow chart shown in FIG. 1 if substantially the same result is obtained, and as shown in FIG. 1, the method includes the following steps:
s101: and selecting and reading files in a file transfer protocol directory for placing the extensible markup language data files.
In this embodiment, the FTP file transfer Protocol is which is a Protocol in the TCP/IP (Transmission Control Protocol/Internet Protocol) Protocol group the FTP Protocol may comprise two components, wherein may be an FTP server, wherein another may be FTP clients, wherein the FTP servers are used to store files and resources located on the FTP servers may be accessed via the FTP Protocol using the FTP clients.
S102: and analyzing the extensible markup language data files with different structures into a file format matched with the selected and read file under the file transmission protocol directory.
The parsing of the xml data files with different structures into a file format matching the file under the selected and read file transfer protocol directory may include:
the extensible markup language data files with different structures are analyzed simultaneously or respectively into the same or different file formats matched with the files under the selected and read file transfer protocol directory, so that the extensible markup language data files with different data structures can be conveniently placed into the files under the same file transfer protocol directory.
In this embodiment, an XML card may be added to the portal pop-up window, which may be added after TXT (text document), and the import page into the graphical interface may be clicked.
In this embodiment, it may be required that the field structure in each XML file is different, or it may be required that the field structure in each XML file is the same, and only the file format of the XML file is required to match the file in the selected and read file transfer protocol directory, and the field structure form in each XML file is not limited.
In this embodiment, an entry may be newly added, an XML is newly added in the entry popup, and a mouse may be required to move into a hover (suspension) effect by clicking to enter an XML import task page.
In this embodiment, the XML import task page may include:
data source name: only XML data sources can be selected to support fuzzy search;
file path: displaying a path under the selected data source and supporting fuzzy search;
storing to a partition: only the partition of Kudu (open source storage engine) can be selected to support fuzzy search;
previewing an imported file: when no XML file exists, the previewable file is displayed temporarily, and when the file exists, all XML files under the selected path are displayed, and the file name and the XML can be displayed.
S103: creating a table structure for the XML data file parsed into different structures that match the file format of the file under the selected and read file transfer protocol directory.
Wherein the creating a table structure for the xml data file having different structures that are parsed into the file format matching the file under the selected and read file transfer protocol directory may include:
by adding fields in the table structure, the table structure is created for the extensible markup language data files with different structures which are analyzed into the file formats matched with the files under the selected and read file transmission protocol directory, so that the extensible markup language data files corresponding to the created table structure can be conveniently recorded and managed through the added fields.
In this embodiment, the XML data files create table structures, each of which differs from one another.
In this embodiment, a field may be added to the created table structure, and the added field facilitates recording and managing the xml data file corresponding to the created table structure, for example, what file the xml data file corresponding to the created table structure comes from, and the like.
In this embodiment, the data structure in a single XML file may require that the data structure in each single XML file requires that the structure of each row (column) is the same, or may require that the data structure in each single XML file requires that the structure of each column is different, which is not limited in the present invention.
In this embodiment, the header of the xml data file may not include a special character or start with a number, or may include a special character or start with a number, and the present invention is not limited thereto.
S104: and acquiring quantitative data of the extensible markup language data files with different structures after the table structures are created.
In this embodiment, the quantitative data may be the data that exists in the form of quantity and thus can be measured, and the present invention is not limited thereto.
S105: and according to the acquired quantitative data, carrying out accuracy verification on the extensible markup language data files with different structures after the table structures are created to obtain verification results.
In this embodiment, the accuracy of the xml data files with different structures after the table structure is created may be checked according to the preset file standards of the xml data files with different structures to obtain the check result, which is not limited in the present invention.
And S106, importing the extensible markup language data files with different structures, the verification results of which pass the accuracy verification, into files in the same file transfer protocol directory.
After the extensible markup language data files with different structures and with verification results passing the accuracy verification are imported into the file under the same file transfer protocol directory, the method may further include:
the extensible markup language data files with different structures imported into the files under the same file transmission protocol directory generate the blood-level views, wherein the generated blood-level views comprise source nodes, intermediate nodes, storage nodes and the like of the extensible markup language data files, and the method has the advantages that the extensible markup language data files with different structures imported into the files under the same file transmission protocol directory are conveniently classified and managed, and the management efficiency is improved.
It can be found that, in this embodiment, files under the file transfer protocol directory for placing the xml data file can be selected and read, and xml data files with different structures can be parsed to match the file format of the selected and read file under the file transfer protocol directory, a table structure can be created for the xml data files with different structures parsed to match the file format of the selected and read file under the file transfer protocol directory, quantitative data of the xml data files with different structures after the table structure is created can be obtained, and according to the obtained quantitative data, the xml data files with different structures after the table structure is created can be subjected to accuracy verification to obtain a verification result, and the xml data files with different structures whose verification result passes the accuracy verification can be imported into the file under the file transfer protocol directory of the same , so that xml data files with different data structures can be placed into the file under the file transfer protocol directory of the same .
, in this embodiment, the XML data files with different structures can be parsed simultaneously or separately into the same or different file formats matching the file under the selected and read file transfer protocol directory, which is advantageous in that it is convenient to place the XML data files with different data structures into the file under the same file transfer protocol directory .
Further , in this embodiment, a table structure can be created for the xml data file parsed into different structures matching the file format of the file under the selected and read file transfer protocol directory by adding fields in the table structure, which has the advantage that the xml data file corresponding to the created table structure can be conveniently recorded and managed by the added fields.
Referring to fig. 2, fig. 2 is a schematic flow chart diagram of another embodiment of the data importing method of the present invention, in this embodiment, the method includes the following steps:
s201: and selecting and reading files in a file transfer protocol directory for placing the extensible markup language data files.
As described above in S101, further description is omitted here.
S202: and analyzing the extensible markup language data files with different structures into a file format matched with the selected and read file under the file transmission protocol directory.
As described above in S102, further description is omitted here.
S203: creating a table structure for the XML data file parsed into different structures that match the file format of the file under the selected and read file transfer protocol directory.
As described above in S103, which is not described herein.
S204: and acquiring quantitative data of the extensible markup language data files with different structures after the table structures are created.
As described above in S104, and will not be described herein.
S205: and according to the acquired quantitative data, carrying out accuracy verification on the extensible markup language data files with different structures after the table structures are created to obtain verification results.
As described above in S105, which is not described herein.
And S206, importing the extensible markup language data files with different structures, the verification results of which pass the accuracy verification, into files in the same file transfer protocol directory.
As described above in S106, and will not be described herein.
And S207, generating a blood margin view by the extensible markup language data files with different structures imported into the files under the same file transmission protocol directory, wherein the generated blood margin view comprises a source node, an intermediate node, a storage node and the like of the extensible markup language data files.
It can be found that, in this embodiment, the extensible markup language data files with different structures imported into the files under the same file transfer protocol directory can be used to generate the consanguinity view, where the generated consanguinity view includes a source node, an intermediate node, a storage node, and the like of the extensible markup language data files, which is advantageous in facilitating the classification management of the extensible markup language data files with different structures imported into the files under the same file transfer protocol directory, and improving the management efficiency.
The invention also provides data importing devices, which can realize that extensible markup language data files with different data structures are placed in files under the same file transfer protocol directory.
Referring to fig. 3, fig. 3 is a schematic structural diagram of an embodiment of a data importing apparatus of the present invention, in this embodiment, the data importing apparatus 30 includes a selecting module 31, a parsing module 32, a creating module 33, an obtaining module 34, a verifying module 35, and an importing module 36.
The selecting module 31 is configured to select and read a file in a file transfer protocol directory for placing an xml data file.
The parsing module 32 is configured to parse xml data files with different structures into a file format matching the selected and read file under the file transfer protocol directory.
The creating module 33 is configured to create a table structure for the xml data file parsed into different structures matching the file format of the file under the selected and read file transfer protocol directory.
The obtaining module 34 is configured to obtain quantitative data of the xml data file with different structures after the table structure is created.
The checking module 35 is configured to perform accuracy checking on the xml data files with different structures after the table structure is created according to the obtained quantitative data to obtain a checking result.
The import module 36 is configured to import the xml data files with different structures, whose verification results pass the accuracy verification, into the file under the file transfer protocol directory of .
Optionally, the parsing module 32 may be specifically configured to:
and analyzing the extensible markup language data files with different structures simultaneously or respectively into the same or different file formats matched with the selected and read files under the file transfer protocol directory.
Optionally, the creating module 33 may be specifically configured to:
and creating a table structure for the extensible markup language data file which is analyzed into different structures matched with the file format of the file under the selected and read file transfer protocol directory in a mode of adding fields in the table structure.
Referring to fig. 4, fig. 4 is a schematic structural diagram of another embodiment of the data importing apparatus of the present invention, different from the embodiment, the data importing apparatus 40 of the present embodiment further includes a generating module 41.
The generating module 41 is configured to generate a consanguinity view for the xml data files with different structures imported into the file under the same file transfer protocol directory, where the generated consanguinity view includes a source node, an intermediate node, and a storage node of the xml data file.
Each unit module of the data importing apparatus 30/40 may respectively execute the corresponding steps in the above method embodiments, and therefore, the detailed description of each unit module is omitted here, and please refer to the description of the corresponding steps above.
The invention further provides data importing equipment, as shown in fig. 5, comprising at least processors 51 and a memory 52 communicatively connected to at least processors 51, wherein the memory 52 stores instructions executable by at least processors 51, and the instructions are executed by at least processors 51 to enable at least processors 51 to execute the above data importing method.
Wherein the memory 52 and the processor 51 are connected by a bus, which may comprise any number of interconnected buses and bridges, the bus connecting or more of the various circuits of the processor 51 and the memory 52 together the bus may also connect together various other circuits such as peripherals, voltage regulators, power management circuits, etc., which are well known in the art and therefore not described further herein .
The processor 51 is responsible for managing the bus and general processing and may also provide various functions including timing, peripheral interfaces, voltage regulation, power management, and other control functions. And the memory 52 may be used to store data used by the processor 51 in performing operations.
The present invention further provides computer-readable storage media storing a computer program which, when executed by a processor, implements the above-described method embodiments.
It can be found that, according to the above solution, the file under the file transfer protocol directory for placing the xml data file can be selected and read, and the xml data files with different structures can be analyzed to be matched with the file format of the file under the selected and read file transfer protocol directory, and a table structure can be created for the xml data files with different structures, which are analyzed to be matched with the file format of the file under the selected and read file transfer protocol directory, and the quantitative data of the xml data files with different structures after the table structure is created can be obtained, and the xml data files with different structures after the table structure is created can be accurately checked according to the obtained quantitative data to obtain the check result, and the xml data files with different structures, which pass the check result and are accurately checked, can be imported into the file under the same file transfer protocol directory , so that the xml data files with different data structures can be placed into the file under the same file transfer protocol directory .
, the above solution can parse the xml data files with different structures into the same or different file formats matching the file in the selected and read file transfer protocol directory simultaneously or separately, which is advantageous for placing the xml data files with different structures into the file in the same file transfer protocol directory .
, the above solution can create a table structure for the xml data file parsed into different structures matching the file format of the file under the selected and read file transfer protocol directory by adding fields in the table structure, which has the advantage of being able to conveniently record and manage the xml data file corresponding to the created table structure through the added fields.
, according to the above scheme, the blood margin view can be generated for the xml data files with different structures imported into the file under the file transmission protocol directory of the same , wherein the generated blood margin view includes the source node, the intermediate node, the storage node, and the like of the xml data files, which is beneficial for conveniently classifying and managing the xml data files with different structures imported into the file under the file transmission protocol directory of the same , and improving the management efficiency.
For example, the above-described embodiments of the apparatus are merely illustrative, e.g., a module or a unit may be divided into only logical functions, and may be implemented in other ways, e.g., a plurality of units or components may be combined or integrated with another systems, or features may be omitted or not executed, and in another point, the shown or discussed mutual coupling or direct coupling or communication connection may be through interfaces, indirect coupling or communication connection of the apparatuses or units, and may be electrical, mechanical or other forms.
The units described as separate parts may or may not be physically separate, and the parts displayed as units may or may not be physical units, that is, may be located in places, or may also be distributed on a plurality of network units.
In addition, the functional units in the embodiments of the present invention may be integrated into processing units, or each unit may exist alone physically, or two or more units are integrated into units.
Based on the understanding, the technical solution of the present invention, which is essentially or partially contributed to by the prior art, or all or part of the technical solution, may be embodied in the form of a software product stored in storage media, which includes several instructions for causing computer devices (which may be personal computers, servers, or network devices, etc.) or processors (processors) to execute all or part of the steps of the methods according to the embodiments of the present invention.
The above description is only a part of the embodiments of the present invention, and not intended to limit the scope of the present invention, and all equivalent devices or equivalent processes performed by the present invention through the contents of the specification and the drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.

Claims (10)

1, A data import method, comprising:
selecting and reading files in a file transfer protocol directory for placing extensible markup language data files;
analyzing extensible markup language data files with different structures into a file format matched with the selected and read file under the file transmission protocol directory;
creating a table structure for the XML data files with different structures which are analyzed to be matched with the file formats of the files under the selected and read file transmission protocol directory;
acquiring quantitative data of the extensible markup language data files with different structures after the table structures are created;
according to the obtained quantitative data, carrying out accuracy verification on the extensible markup language data files with different structures after the table structures are created to obtain verification results;
and importing the extensible markup language data files with different structures, the verification results of which pass the accuracy verification, into files under the same file transfer protocol directory.
2. The data importing method according to claim 1, wherein the parsing the xml data files with different structures into a file format matching the file under the selected and read file transfer protocol directory includes:
and analyzing the extensible markup language data files with different structures simultaneously or respectively to obtain the same or different file formats matched with the selected and read files under the file transmission protocol directory.
3. The data import method of claim 1, wherein the creating a table structure for the XML data file parsed into different structures that match the file format of the file under the selected and read file transfer protocol directory comprises:
and creating a table structure for the extensible markup language data file which is analyzed into different structures matched with the file format of the file under the selected and read file transmission protocol directory in a mode of adding fields in the table structure.
4. The data import method according to claim 1, wherein after importing the xml data file with different structure whose verification result passes the accuracy verification into the file under the file transfer protocol directory of , the method further comprises:
and generating a blood margin view by the extensible markup language data files with different structures imported into the files under the same file transmission protocol directory, wherein the generated blood margin view comprises a source node, an intermediate node and a storage node of the extensible markup language data files.
The data importing apparatus of , comprising:
the system comprises a selection module, an analysis module, a creation module, an acquisition module, a verification module and an import module;
the selection module is used for selecting and reading files in a file transfer protocol directory for placing extensible markup language data files;
the analysis module is used for analyzing the extensible markup language data files with different structures into a file format matched with the selected and read file under the file transmission protocol directory;
the creation module is used for creating a table structure for the extensible markup language data files which are analyzed into different structures which are matched with the file formats of the files under the selected and read file transmission protocol directory;
the acquisition module is used for acquiring quantitative data of the extensible markup language data files with different structures after the table structures are created;
the verification module is used for carrying out accuracy verification on the extensible markup language data files with different structures after the table structures are created according to the obtained quantitative data to obtain verification results;
the import module is used for importing extensible markup language data files with different structures, the verification results of which pass the accuracy verification, into files in the same file transfer protocol directory.
6. The data import apparatus of claim 5, wherein the parsing module is specifically configured to:
and analyzing the extensible markup language data files with different structures simultaneously or respectively to obtain the same or different file formats matched with the selected and read files under the file transmission protocol directory.
7. The data importing device of claim 5, wherein the creating module is specifically configured to:
and creating a table structure for the extensible markup language data file which is analyzed into different structures matched with the file format of the file under the selected and read file transmission protocol directory in a mode of adding fields in the table structure.
8. The data import apparatus according to claim 5, wherein the data import apparatus further comprises:
a generation module;
the generating module is used for generating the blood margin view of the extensible markup language data files with different structures which are imported into the files under the same file transmission protocol directory, wherein the generated blood margin view comprises a source node, an intermediate node and a storage node of the extensible markup language data files.
The data import apparatus of type 9, , comprising:
at least processors, and,
a memory communicatively coupled to the at least processors, wherein,
the memory stores instructions executable by the at least processors to enable the at least processors to perform the data import method of any of claims 1-4 .
10, computer-readable storage medium, storing a computer program, wherein the computer program, when executed by a processor, implements the data import method of any of claims 1 to 4.
CN201910906522.0A 2019-09-24 2019-09-24 Data import method, device and equipment Active CN110737636B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910906522.0A CN110737636B (en) 2019-09-24 2019-09-24 Data import method, device and equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910906522.0A CN110737636B (en) 2019-09-24 2019-09-24 Data import method, device and equipment

Publications (2)

Publication Number Publication Date
CN110737636A true CN110737636A (en) 2020-01-31
CN110737636B CN110737636B (en) 2022-07-22

Family

ID=69269459

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910906522.0A Active CN110737636B (en) 2019-09-24 2019-09-24 Data import method, device and equipment

Country Status (1)

Country Link
CN (1) CN110737636B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112883692A (en) * 2020-10-23 2021-06-01 广州超深信息技术有限公司 Automatic generation method of PPT data report

Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040172592A1 (en) * 2003-02-28 2004-09-02 Microsoft Corporation Importing and exporting markup language data in a spreadsheet application document
US20050097128A1 (en) * 2003-10-31 2005-05-05 Ryan Joseph D. Method for scalable, fast normalization of XML documents for insertion of data into a relational database
US20060112116A1 (en) * 2002-06-28 2006-05-25 Microsoft Corporation XML storage solution and data interchange file format structure
JP2007018029A (en) * 2005-07-05 2007-01-25 Ricoh Co Ltd Network device
US8402001B1 (en) * 2002-10-08 2013-03-19 Symantec Operating Corporation System and method for archiving data
CN102999329A (en) * 2012-11-05 2013-03-27 浙江吉利汽车研究院有限公司杭州分公司 Active directory interface developing method based on extensive markup language mapping configuration
CN103428202A (en) * 2013-07-24 2013-12-04 浙江大学 Automatic monitored storage method of remote sensing data product based on file transfer protocol (FTP) and extensible markup language (XML)
CN103577599A (en) * 2013-11-15 2014-02-12 北京邮电大学 Method and device for storing local data through mobile terminal
US20150278386A1 (en) * 2014-03-25 2015-10-01 Syntel, Inc. Universal xml validator (uxv) tool
CN109614159A (en) * 2017-09-30 2019-04-12 北京国双科技有限公司 Plan target distribution, introduction method and device
CN109670328A (en) * 2018-12-25 2019-04-23 北京城市网邻信息技术有限公司 A kind of data processing method and device

Patent Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20060112116A1 (en) * 2002-06-28 2006-05-25 Microsoft Corporation XML storage solution and data interchange file format structure
US8402001B1 (en) * 2002-10-08 2013-03-19 Symantec Operating Corporation System and method for archiving data
US20040172592A1 (en) * 2003-02-28 2004-09-02 Microsoft Corporation Importing and exporting markup language data in a spreadsheet application document
US20050097128A1 (en) * 2003-10-31 2005-05-05 Ryan Joseph D. Method for scalable, fast normalization of XML documents for insertion of data into a relational database
JP2007018029A (en) * 2005-07-05 2007-01-25 Ricoh Co Ltd Network device
CN102999329A (en) * 2012-11-05 2013-03-27 浙江吉利汽车研究院有限公司杭州分公司 Active directory interface developing method based on extensive markup language mapping configuration
CN103428202A (en) * 2013-07-24 2013-12-04 浙江大学 Automatic monitored storage method of remote sensing data product based on file transfer protocol (FTP) and extensible markup language (XML)
CN103577599A (en) * 2013-11-15 2014-02-12 北京邮电大学 Method and device for storing local data through mobile terminal
US20150278386A1 (en) * 2014-03-25 2015-10-01 Syntel, Inc. Universal xml validator (uxv) tool
CN109614159A (en) * 2017-09-30 2019-04-12 北京国双科技有限公司 Plan target distribution, introduction method and device
CN109670328A (en) * 2018-12-25 2019-04-23 北京城市网邻信息技术有限公司 A kind of data processing method and device

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
PESSEMIER,WIM等: "Knowledge-based engineering of a PLC controlled telescope", 《SOFTWARE AND CYBERINFRASTRUCTURE FOR ASTRONOMY IV》 *
曹洪文: "基于数据仓库技术的农行信息管理***设计", 《中国优秀硕士学位论文全文数据库(电子期刊)》 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112883692A (en) * 2020-10-23 2021-06-01 广州超深信息技术有限公司 Automatic generation method of PPT data report
CN112883692B (en) * 2020-10-23 2024-04-09 广州超深信息技术有限公司 Automatic generation method of PPT data report

Also Published As

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

Similar Documents

Publication Publication Date Title
US11294968B2 (en) Combining website characteristics in an automatically generated website
CN108156022B (en) Service calling method and device and electronic equipment
US8601438B2 (en) Data transformation based on a technical design document
US7240067B2 (en) System and methodology for extraction and aggregation of data from dynamic content
US20140108373A1 (en) System for deep linking and search engine support for web sites integrating third party application and components
CN110287069B (en) ESB interface automatic test method, server and computer readable storage medium
CN110321154B (en) Micro-service interface information display method and device and electronic equipment
CN110019116B (en) Data tracing method, device, data processing equipment and computer storage medium
CN105589959A (en) Form processing method and form processing system
CN109766206A (en) A kind of log collection method and system
CN110347573B (en) Application program analysis method, device, electronic equipment and computer readable medium
US7600001B1 (en) Method and computer system for unstructured data integration through a graphical interface
JP2019040260A (en) Information processing apparatus and program
CN110737636B (en) Data import method, device and equipment
CN108694172B (en) Information output method and device
CN112632419A (en) Domain name pre-resolution configuration method and device, computer equipment and storage medium
US8938520B2 (en) Methods and systems for smart adapters in a social media content analytics environment
CN106796591B (en) Method and apparatus for unifying information and tools from multiple information sources
CN109710634B (en) Method and device for generating information
CN101145936B (en) A method and system for adding tags in Web pages
JP2006065467A5 (en)
US8856152B2 (en) Apparatus and method for visualizing data
KR20070062800A (en) Method for transforming of electronic document based on mapping rule and system thereof
CN115759029A (en) Document template processing method and device, electronic equipment and storage medium
CN114047999A (en) Page configuration method, system, electronic equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant