CN108460068A - Method, apparatus, storage medium and the terminal that report imports and exports - Google Patents
Method, apparatus, storage medium and the terminal that report imports and exports Download PDFInfo
- Publication number
- CN108460068A CN108460068A CN201711215119.0A CN201711215119A CN108460068A CN 108460068 A CN108460068 A CN 108460068A CN 201711215119 A CN201711215119 A CN 201711215119A CN 108460068 A CN108460068 A CN 108460068A
- Authority
- CN
- China
- Prior art keywords
- report
- file
- report file
- importing
- distribution platform
- 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
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/13—File access structures, e.g. distributed indices
-
- 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
- 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/46—Multiprogramming arrangements
- G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
- G06F9/5005—Allocation of resources, e.g. of the central processing unit [CPU] to service a request
- G06F9/5027—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2209/00—Indexing scheme relating to G06F9/00
- G06F2209/50—Indexing scheme relating to G06F9/50
- G06F2209/5018—Thread allocation
Abstract
The present invention is suitable for field of communication technology, provides a kind of method that report imports and exports, including：The user name and password for obtaining Report Form Design person, are sent to distribution platform, to log in the distribution platform by the user name and password；When report imports, the Report Form Design person is obtained at least one report file to be imported locally chosen, importing thread identical with the report file quantity to be imported is opened, the report file is directed by the distribution platform according to the store path of the report file distributed by the importing thread；When report exports, obtain that the Report Form Design person chooses from the distribution platform at least one waits for derived report file, export thread identical with report file quantity derived from described wait for is opened, the report file is exported from the distribution platform according to the store path of the report file distributed by the export thread；The present invention is realized imports and exports operation to the batch of report file, solves the problems, such as that prior art efficiency when importing and exporting report file is low, process is cumbersome.
Description
Technical field
The invention belongs to field of communication technology more particularly to a kind of method, apparatus that report imports and exports, storage medium and
Terminal.
Background technology
Pentaho is current most popular business intelligence software of increasing income, and is using workflow as core, emphasizes towards solution party
The BI external members of case rather than tool assembly have gathered a large amount of machine learning algorithms that can undertake data mining task, including to data
It pre-processed, classified, being returned, being clustered, Association Rule Analysis, and visualizing data on interactive interface.It is existing
Pentaho frames are mainly made of three parts, respectively resolver, designer, distribution platform.The designer is Computer Aided Design
Person creates the edit tool of cube (data cube), and the resolver is a set of report generation work using JFreeReport
Tool, the distribution platform are the Pentaho BI of a set of simplified configuration, use Pentaho Sequence Flow and Pentaho
The parsing of the components indirect application resolver such as Report Compoent generates report.Wherein, it the cube, i.e. data cube, stands
Cube file is a kind of multi-dimensional matrix, can be encapsulated the multidimensional meta data from database or file, facilitate use
Data set is explored and analyzed from multiple angles in family.After design data cube selects store path, data cube load
It can be a file using mdc filenames as ending afterwards, be denoted as report file here, the data analysis subsequently carried out is all straight
This report file is asked in receiving.However, existing Pentaho when importing or exporting report file, only supports to locate one by one
Reason, imports or derived efficiency is low, and process is cumbersome.In addition, the Schema-workbench components in existing Pentaho also limit
The modification operation to report file is made, modification operation every time can only carry out a report file, and efficiency is low.Encountering batch
In the case of modification, it is easy to cause the problem of leakage changes.
Invention content
An embodiment of the present invention provides a kind of method, apparatus that report imports and exports, storage medium and terminals, to solve
The prior art problem that efficiency is low, process is cumbersome in importing, export, modification report file.
An embodiment of the present invention provides a kind of method that report imports and exports, the method includes：
The user name and password for obtaining Report Form Design person, distribution platform is sent to by the user name and password, to log in
The distribution platform；
When report imports, the Report Form Design person is obtained in the destination folder locally chosen, the destination folder
Include at least one report file to be imported, open importing thread identical with the report file quantity to be imported,
The report file to be imported is distributed one by one to the importing thread, by the importing thread according to the report distributed
The report file is directed into the distribution platform by the store path of file；
When report exports, obtain that the Report Form Design person chooses from the distribution platform at least one waits for derived report
List file is opened and waits for the identical export thread of derived report file quantity with described, by report file derived from described wait for by
One distribution is to the export thread, by the export thread according to the store path of the report file distributed from the publication
The report file is exported on platform.
Further, the method further includes：
Before report importing, start monitoring task, passes through the company between monitoring task test and the distribution platform
Connect state；
When connection status is in connection, creates this report and import corresponding journal file, pass through the monitoring task
The abnormal problem in importing process is captured, and the abnormal problem is written in the journal file.
Further, according to the store path of the report file distributed that the report is literary by the importing thread
Part is directed into after the distribution platform, and the method further includes：
The distributed corresponding verification sentence of report file is read by the importing thread；
Checking command is generated according to the verification sentence, the checking command is sent to the distribution platform, so that
The distribution platform verifies whether the report file has imported according to the checking command；
If receiving the importing success message that the distribution platform returns, wait leading to importing thread distribution is next
The report file entered；
If receiving the importing failed message that the distribution platform returns, distributes to import to the importing thread again and lose
The report file lost.
Further, flat from the publication according to the store path of the report file distributed by the export thread
After exporting the report file on platform, the method further includes：
Obtain the interior content perhaps to be added to be modified in the report file；
Lookup is mutually related report file, according to it is described it is to be modified in content perhaps to be added be mutually related to described
Report file carries out unified modification.
Further, the interior content perhaps to be added to be modified obtained in the report file includes：
Report file derived from parsing institute, obtains multiple keywords；
Modification table is generated using the keyword as table condition, shows that the modification table supplies the Report Form Design person
It checks and modifies operation；
Content perhaps to be added in be modified is obtained by the modification table, display is described to be modified interior perhaps to be added
Content is to prompt the Report Form Design person to confirm.
The embodiment of the present invention additionally provides a kind of device that report imports and exports, and described device includes：
Login module, the user name for obtaining Report Form Design person and password, the user name and password are sent to
Cloth platform, to log in the distribution platform；
Import modul, for when report imports, obtaining the Report Form Design person in the destination folder locally chosen, institute
It includes at least one report file to be imported to state destination folder, is opened identical as the report file quantity to be imported
Importing thread, the report file to be imported is distributed one by one to the importing thread, by the importing thread according to
The report file is directed into the distribution platform by the store path of the report file distributed；
Export module is chosen at least for when report exports, obtaining the Report Form Design person from the distribution platform
One is waited for derived report file, is opened export thread identical with report file quantity derived from described wait for, is waited leading by described
The report file gone out is distributed one by one to the export thread, by the export thread according to the storage of the report file distributed
Path exports the report file from the distribution platform.
Further, described device further includes：
Module is monitored, for before report importing, starting monitoring task, passes through monitoring task test and the publication
Connection status between platform；When connection status is in connection, creates this report and import corresponding journal file, pass through institute
The abnormal problem in monitoring task capture importing process is stated, and the abnormal problem is written in the journal file.
Further, described device further includes：
Correction verification module, for reading the distributed corresponding verification sentence of report file by the importing thread, according to
The verification sentence generates checking command, the checking command is sent to the distribution platform, so that the distribution platform
Verify whether the report file has imported according to the checking command；
Distribution module, if the importing success message returned for receiving the distribution platform, to the importing thread
Distribute next report file to be imported；If the importing failed message that the distribution platform returns is received, again to institute
It states and imports the report file that thread distribution imports failure.
The embodiment of the present invention additionally provides a kind of computer readable storage medium, is stored thereon with computer program, the journey
The step described in method that report as described above imports and exports is realized when sequence is executed by processor.
The embodiment of the present invention additionally provides a kind of terminal, and the terminal includes memory, processor and is stored in memory
Computer program that is upper and can running on a processor, the processor are realized as described above when executing the computer program
The step of method that report imports and exports.
Compared with prior art, the embodiment of the present invention is obtained by increasing multiple threads mechanism when report imports first
Take the Report Form Design person in the destination folder locally chosen, the destination folder includes at least one report to be imported
List file is then turned on importing thread identical with the report file quantity to be imported, by the report text to be imported
Part is distributed one by one to the importing thread, will be described according to the store path of the report file distributed by the importing thread
Report file is directed into the distribution platform；When report exports, the Report Form Design person is obtained first from the distribution platform
At least one of selection waits for derived report file, is then turned on export line identical with report file quantity derived from described wait for
Journey waits for that derived report file is distributed one by one to the export thread by described, by the export thread according to being distributed
The store path of report file exports the report file from the distribution platform；Wherein, one imports thread/mono- export
One report file of thread alignment processing；Batch to realize to report file imports and exports operation, can once import
Or the multiple report files of export, solve the problems, such as that prior art efficiency when importing, exporting report file is low, process is cumbersome.
Description of the drawings
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technology description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention for those of ordinary skill in the art without creative efforts, can be with
Other accompanying drawings can also be obtained according to these attached drawings.
Fig. 1 is the first implementation flow chart for the method that report provided in an embodiment of the present invention imports and exports；
Fig. 2 is the second implementation flow chart of the method that report provided in an embodiment of the present invention imports and exports；
Fig. 3 is the third implementation flow chart for the method that report provided in an embodiment of the present invention imports and exports；
Fig. 4 is the 4th implementation flow chart of the method that report provided in an embodiment of the present invention imports and exports；
Fig. 5 is the implementation flow chart of step S404 in the method that report provided in an embodiment of the present invention imports and exports；
Fig. 6 is the composite structural diagram for the device that report provided in an embodiment of the present invention imports and exports；
Fig. 7 is the schematic diagram of terminal provided in an embodiment of the present invention.
Specific implementation mode
In order to make the purpose , technical scheme and advantage of the present invention be clearer, with reference to the accompanying drawings and embodiments, right
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
Embodiment 1
Fig. 1 shows the first implementation flow for the method that report provided in an embodiment of the present invention imports and exports.
In embodiments of the present invention, the method that the report imports and exports be applied to terminal, including but not limited to computer,
Server etc..The report is the report file for generating cube, i.e., using mdc filenames as the file of ending.
Refering to fig. 1, the method that the report imports and exports includes：
In step S101, the user name and password of Report Form Design person are obtained, the user name and password are sent to
Cloth platform, to log in the distribution platform.
In embodiments of the present invention, when importing and exporting operation of report is being carried out, Report Form Design person is needed first to log in publication
Platform obtains operating right.The username and password that Report Form Design person is obtained when login, then sends out the username and password
It send to distribution platform, login authentication is carried out by distribution platform.If distribution platform is verified, show to login successfully, in terminal sheet
Ground shows Report Operations interface to Report Form Design person, imports and exports operating right with opening, behaviour is imported and exported to improve report
The safety of work.
In step s 102, when report imports, the Report Form Design person is obtained in the destination folder locally chosen, institute
It includes at least one report file to be imported to state destination folder, is opened identical as the report file quantity to be imported
Importing thread, the report file to be imported is distributed one by one to the importing thread, by the importing thread according to
The report file is directed into the distribution platform by the store path of the report file distributed.
Herein, when if desired importing multiple report files simultaneously, need Report Form Design person when developing report file, often
A report file is completed in exploitation, then report file to be imported is stored in same file folder, and each report is arranged
The configuration parameter of list file.The configuration parameter includes the guarantor of the link url, the report file of distribution platform on distribution platform
Deposit path, publication format.
The distribution platform is pentaho platforms, the importing source generation that the embodiment of the present invention passes through deciphering pentaho platforms
Code identifies the importing instruction that pentaho platforms provide, and is packaged importing instruction using java language, exploitation batch
Amount generates, executes the program for importing instruction.When carrying out import operation, the file that terminal is chosen according to user, i.e. target text
Part presss from both sides, and obtains the report file involved by this import operation.Mass production imports instruction, is instructed and is opened according to the importing
Multiple importing threads distribute the report file involved by this import operation to each importing thread.Wherein, it leads for one
Enter a thread report file per treatment, each imports thread independent operating, obtains the storage of distributed report file
Then the report file is directed into the distribution platform, to realize report file by path according to the store path
Batch import function.
In step s 103, it when report exports, obtains the Report Form Design person and is chosen at least from the distribution platform
One is waited for derived report file, is opened export thread identical with report file quantity derived from described wait for, is waited leading by described
The report file gone out is distributed one by one to the export thread, by the export thread according to the storage of the report file distributed
Path exports the report file from the distribution platform.
Similar to exporting in batches, the embodiment of the present invention also by understanding the export source code of pentaho platforms, identifies
Export instruction is packaged by the export instruction that pentaho platforms provide using java language, and exploitation Mass production is held
The program of row export instruction.
If carrying out export operation, obtain that the Report Form Design person chooses from the distribution platform at least one waits exporting
Report file.Wait for that derived report file number, Mass production export instruction are instructed according to the importing selected by statistics
Open multiple importing threads.The involved report file of this export operation is distributed to each export thread, institute is passed through
The store path that export thread obtains distributed report file is stated, then according to the store path from the distribution platform
The report file is downloaded, to realize the batch export function of report file.
In conclusion the embodiment of the present invention, by increasing multiple threads mechanism, when report imports, unlatching is waited for described
The identical importing thread of report file quantity of importing, by the importing thread according to the storage road of the report file distributed
The report file is directed into the distribution platform by diameter；When report exports, opens and wait for derived report file number with described
Identical export thread is measured, it is flat from the publication according to the store path of the cube file distributed by the export thread
The report file is exported on platform；Batch to realize to report file imports and exports operation, once can be with simultaneous selection
Multiple report files are imported or are exported, and the efficiency for importing and exporting report is effectively improved, and are solved the prior art and are being led
The problem that efficiency is low when entering, exporting report file, process is cumbersome.
Further, on the basis of the first implementation flow of the method imported and exported based on Fig. 1 reports provided, this is proposed
Second implementation process of the method that the report that inventive embodiments provide imports and exports.
As shown in Fig. 2, be the second implementation flow chart of the method that report provided in an embodiment of the present invention imports and exports, it is described
Method includes：
In step s 201, the user name and password for obtaining Report Form Design person, hair is sent to by the user name and password
Cloth platform, to log in the distribution platform.
Wherein, step S201 is identical as the step S101 described in Fig. 1 embodiments, specifically refers to chatting for above-described embodiment
It states, details are not described herein again.
In step S202, before report importing, start monitoring task, passes through monitoring task test and the publication
Connection status between platform.
In step S203, when connection status is in connection, creates this report and import corresponding journal file, pass through
The monitoring task captures the abnormal problem in importing process, and the abnormal problem is written in the journal file.
Herein, the embodiment of the present invention creates journal file according to the connection status between terminal and distribution platform.It is reporting
Before table imports, starts monitoring task first, the connection status between terminal and distribution platform is tested by monitoring task.When even
When connecing state as in connection, shows to be to import report to be ready work between terminal and distribution platform, then create daily record text
Part loses problem to record the file occurred in importing process.
During report imports, abnormal problem is captured by the monitoring task in real time, and be recorded and created
Journal file in.Herein, abnormal problem refers to a kind of instruction stream for causing report to import program interrupt operation, if not right
Exception is captured and is handled, and program interrupt may be caused to execute, and report is caused to import error.It is right that the embodiment of the present invention passes through
Abnormal problem is recorded, and can be got the problem of file occurred in importing process is lost, be realized to importing process
Error correction ensure that the accuracy that report imports.
In step S204, when report imports, the Report Form Design person is obtained in the destination folder locally chosen, institute
It includes at least one report file to be imported to state destination folder, is opened identical as the report file quantity to be imported
Importing thread, the report file to be imported is distributed one by one to the importing thread, by the importing thread according to
The report file is directed into the distribution platform by the store path of the report file distributed.
In step S205, when report exports, obtains the Report Form Design person and chosen at least from the distribution platform
One is waited for derived report file, is opened export thread identical with report file quantity derived from described wait for, is waited leading by described
The report file gone out is distributed one by one to the export thread, by the export thread according to the storage of the report file distributed
Path exports the report file from the distribution platform.
Wherein, step S204, S205 is identical as step S102, S103 described in Fig. 1 embodiments, specifically refers to above-mentioned
The narration of embodiment, details are not described herein again.
Further, on the basis of the first implementation flow of the method imported and exported based on Fig. 2 reports provided, this is proposed
The third implementation process for the method that the report that inventive embodiments provide imports and exports.
As shown in figure 3, be the third implementation flow chart for the method that report provided in an embodiment of the present invention imports and exports, including
Step S301 to step S303, wherein step S101 described in step S301 to step S303 and Fig. 1 embodiments to S103 phases
Together, the narration of above-described embodiment is specifically referred to, details are not described herein again.
The report file is directed into according to the store path of the report file distributed by the importing thread
After the distribution platform, the method further includes：
In step s 304, the distributed corresponding verification sentence of report file is read by the importing thread.
In embodiments of the present invention, each imports thread and the report file distributed is directed into the distribution platform
Afterwards, continue to read the corresponding verification sentence of the report file.Herein, the verification sentence is SQL statement.
In step S305, checking command is generated according to the verification sentence, the checking command is sent to the hair
Cloth platform, so that the distribution platform verifies whether the report file has imported according to the checking command.
The embodiment of the present invention generates checking command after obtaining verification sentence.Wherein, the verification sentence includes described
The key message of report file.The checking command generated defines the conditional information of verification, the conditional information, that is, pass
Key information.Based on the checking command, the distribution platform inquiry whether there is the corresponding report file of the key message, from
And determine whether the report file imported handled by thread has successfully imported, it realizes and result is imported really to report file
Recognize, ensure that the validity that report file imports.
In step S306, if the importing success message that the distribution platform returns is received, to the importing thread
Distribute next report file to be imported.
In step S307, if the importing failed message that the distribution platform returns is received, again to the importing
Thread distribution imports the report file of failure
Optionally, the method further includes：If the distribution platform is inquired, there are the corresponding reports of the key message
When file, shows that the report file that the importing thread is distributed successfully imports, is returned to the terminal and import success message,
Terminal distributes next report file to be imported according to the importing success message to the importing thread；If the distribution platform
When inquiring report file corresponding there is no the key message, show that the report file that the importing thread is distributed imports mistake
It loses, is returned to the terminal and import failed message, terminal distributes institute to the importing thread again according to the importing failed message
Report file is stated, to be imported again, the batch to realize report file imports.
Further, when being related to new business and needing to change report file, the prior art can be from distribution platform
Announced report file is downloaded, is issued again again after modifying.However, when modifying to report file, repair every time
Change and only support to modify to single report file, modification efficiency is low.In order to solve the above-mentioned technical problem, it is provided based on Fig. 1
On the basis of the first implementation flow for the method that report imports and exports, propose what report provided in an embodiment of the present invention imported and exported
4th implementation process of method.
As shown in figure 4, being the 4th implementation flow chart of the method that report provided in an embodiment of the present invention imports and exports.It is described
Method includes：
Step S401 to step S403, wherein step S401 to the step S403 and step S101 described in Fig. 1 embodiments
It is identical to step S103, the narration of above-described embodiment is specifically referred to, details are not described herein again.
The method further includes：
In step s 404, the interior content perhaps to be added to be modified in the report file is obtained.
Optionally, in order to promote the experience sense of user, Fig. 5 shows that step S404's provided in an embodiment of the present invention is specific
Implementation process.Refering to Fig. 5, the step S404 obtains the interior content perhaps to be added to be modified in the report file and includes：
In step S501, report file derived from parsing institute obtains multiple keywords.
In embodiments of the present invention, parsing is synchronized to report file derived from institute, obtains the pass that report file includes
Keyword, the keyword are the inscape of report file.Herein, indicate that 3 spaces are created with X, Y, the Z coordinate axis in mathematics
Establish that cube is the same, the cube generated according to the report file is the business intelligence for establishing at different business visual angles as dimension
The cube of energy analysis, therefore, the keyword include but not limited to table (table), DimensionUsage (dimensions
Degree), Level (layer), Categories (classification), Measure (index), CalculatedMember (calculating parameter),
Formula (calculation formula).Wherein, dimension refers to the angle that is used for analyzing when carrying out data analysis, for example, the time, things,
Place；Layer refers to the hierarchical relationship of dimension data in logic, for example, time dimension can be divided into the first quarter, the second quarter,
Four third season, fourth quarter grades；Classification refers to independent data element on the layer being located in a dimension；Index is to use
In the data for weighing business effect, for determining the successful quantized result of business operation or Key Performance Indicator, such as income,
Cost, increase and decrease volume.As it can be seen that including at least one content under each keyword.
In step S502, modification table is generated using the keyword as table condition, shows that the modification table supplies
The Report Form Design person checks and modifies operation.
Wherein, for the modification table using the keyword as table condition, each table condition corresponds to one or more
A modification window is supplied to Report Form Design person to check and content included under keyword is added or is modified.
In step S503, content perhaps to be added in be modified is obtained by the modification table, display is described to be repaired
Content perhaps to be added is to prompt the Report Form Design person to confirm in changing.
Report Form Design person can carry out input operation on the modification window of the modification table, to complete to keyword institute
Including content modify or add.Terminal obtains table condition to be modified and/or to be added depending on the user's operation
Table condition, obtain content to be modified and/or to be added, the front and back content of display modification, to prompt user to confirm modification
It is whether correct.Herein, the embodiment of the present invention shows revisable keyword and modification or addition by visualization interface
Content facilitates the verification operation of user.
In step S405, the report file that is mutually related is searched, according to the interior content pair perhaps to be added to be modified
The report file that is mutually related carries out unified modification.
Herein, the embodiment of the present invention identifies pentaho platforms by the modification source code of deciphering pentaho platforms
The modification of offer instructs, and is packaged modification instruction using java language, develops Mass production, executes modification instruction
Program.
Wherein, when getting content to be modified, inquiry includes the report text of the corresponding keyword of the content to be modified
Part obtains the report file that is mutually related, and modifies to the keyword of the report file that is mutually related.Work as acquisition
When to content to be added, the corresponding keyword of the content to be added is obtained, lookup includes the report file of the keyword, is obtained
To the report file that is mutually related, it is mutually related described in together in report file and adds the content.Illustratively, one
In the project development process of a little insurance businesses, addition user alias information is generally required, the user alias information belongs to user
Information dimension is a level of user information dimension, then searches other report files with user information dimension, obtain phase
The user alias information to be added is added to the report file that is mutually related by the report file of mutual correlation, to
It realizes to report file batch addition of users name, improves the efficiency of modification, avoid the case where leakage changes.
It should be understood that in the above-described embodiments, the size of the serial number of each step is not meant that the order of the execution order, it is each to walk
Rapid execution sequence should be determined by its function and internal logic, and the implementation process without coping with the embodiment of the present invention constitutes any limit
It is fixed.
Embodiment 2
Fig. 6 shows the composite structural diagram for the device that report provided in an embodiment of the present invention imports and exports, for the ease of saying
It is bright, it illustrates only and the relevant part of the embodiment of the present invention.
In embodiments of the present invention, the device that the report imports and exports is for realizing above-mentioned Fig. 1, Fig. 2, Fig. 3, Fig. 4, figure
The method that report described in 5 embodiments imports and exports can be the software unit, hardware cell, software and hardware for being built in terminal
In conjunction with unit, the terminal includes but not limited to computer, server etc..
Refering to Fig. 6, the device that the report imports and exports includes：
Login module 61, the user name for obtaining Report Form Design person and password, the user name and password are sent to
Distribution platform, to log in the distribution platform.
Import modul 62 obtains the Report Form Design person in the destination folder locally chosen for when report imports,
The destination folder includes at least one report file to be imported, is opened and the report file quantity phase to be imported
Same importing thread, the report file to be imported is distributed one by one to the importing thread, the importing thread root is passed through
The report file is directed into the distribution platform according to the store path of the report file distributed.
Export module 63, for when report exports, obtain that the Report Form Design person chooses from the distribution platform to
Few one is waited for derived report file, opens export thread identical with the quantity of report file derived from described wait for, will be described
Wait for that derived report file is distributed one by one to the export thread, by the export thread according to the report file distributed
Store path exports the report file from the distribution platform.
Wherein, one imports thread/mono- export thread one report file of alignment processing.
Optionally, described device further includes：
Module 64 is monitored, for before report importing, starting monitoring task, passes through monitoring task test and the hair
Connection status between cloth platform；When connection status is in connection, creates this report and import corresponding journal file, pass through
The monitoring task captures the abnormal problem in importing process, and the abnormal problem is written in the journal file.
Optionally, described device further includes：
Correction verification module 65, for reading the distributed corresponding verification sentence of report file, root by the importing thread
Checking command is generated according to the verification sentence, the checking command is sent to the distribution platform, so that the publication is flat
Platform verifies whether the report file has imported according to the checking command.
Distribution module 66, if the importing success message returned for receiving the distribution platform, to the lead-in wire
Journey distributes next report file to be imported；If receiving the importing failed message that the distribution platform returns, again to
The report file for importing thread distribution and importing failure.
Optionally, described device further includes：
Acquisition module 67, for obtaining the interior content perhaps to be added to be modified in the report file.
Modified module 68, for searching the report file that is mutually related, according to the interior content perhaps to be added to be modified
Unified modification is carried out to the report file that is mutually related.
Further, the acquisition module 67 further includes：
Resolution unit 671 obtains multiple keywords for report file derived from parsing institute；
Generation unit 672 shows the modification table for generating modification table using the keyword as table condition
It checks and modifies for the Report Form Design person operation；
Display unit 673 is waited for for obtaining content perhaps to be added in be modified by the modification table described in display
Content perhaps to be added is to prompt the Report Form Design person to confirm in modification.
It should be noted that each module/unit in the embodiment of the present invention can be used to implement in above method embodiment
Whole technical solutions, specific work process can refer to corresponding processes in the foregoing method embodiment, no longer superfluous herein
It states.
In the above-described embodiments, it all emphasizes particularly on different fields to the description of each embodiment, is not described in detail or remembers in some embodiment
The part of load may refer to the associated description of other embodiments.
Embodiment 3
The present embodiment provides a computer readable storage medium, computer journey is stored on the computer readable storage medium
Sequence realizes the method that report imports and exports in embodiment 1, to avoid repeating, here when the computer program is executed by processor
It repeats no more.Alternatively, realizing each mould in the device that report imports and exports in embodiment 2 when the computer program is executed by processor
The function of block/unit, to avoid repeating, which is not described herein again.
Embodiment 4
Fig. 7 is a kind of schematic diagram of terminal provided in an embodiment of the present invention, and the terminal includes but not limited to server, moves
Dynamic terminal.As shown in fig. 7, the terminal 7 of the embodiment includes：Processor 70, memory 71 and it is stored in the memory 71
In and the computer program 72 that can be run on the processor 70.The processor 70 executes real when the computer program 72
Step in the embodiment of the method that existing above-mentioned report imports and exports, such as step S101 shown in FIG. 1 is to S103, Fig. 2 embodiment
Described in step S201 to S205, Fig. 3 embodiment described in step S301 to S307, Fig. 4 embodiment described in step
Step S501 to S503 described in S401 to S405 and Fig. 5 embodiments；Alternatively, the processor 70 executes the computer journey
Realize the function of each module/unit in the device embodiment that above-mentioned report imports and exports when sequence 72, for example, module 61 shown in Fig. 6 to
68 function.
Illustratively, the computer program 72 can be divided into one or more module/units, it is one or
Multiple module/units are stored in the memory 71, and are executed by the processor 70, to complete the present invention.Described one
A or multiple module/units can be the series of computation machine program instruction section that can complete specific function, which is used for
Implementation procedure of the computer program 72 in the terminal 7 is described.For example, the computer program 72 can be divided into
Login module, import modul, export module, each module concrete function are as follows：
Login module, the user name for obtaining Report Form Design person and password, the user name and password are sent to
Cloth platform, to log in the distribution platform；
Import modul, for when report imports, obtaining the Report Form Design person in the destination folder locally chosen, institute
It includes at least one report file to be imported to state destination folder, is opened identical as the report file quantity to be imported
Importing thread, the report file to be imported is distributed one by one to the importing thread, by the importing thread according to
The report file is directed into the distribution platform by the store path of the report file distributed；
Export module is chosen at least for when report exports, obtaining the Report Form Design person from the distribution platform
One is waited for derived report file, is opened export thread identical with report file quantity derived from described wait for, is waited leading by described
The report file gone out is distributed one by one to the export thread, by the export thread according to the storage of the report file distributed
Path exports the report file from the distribution platform；
Wherein, one imports thread/mono- export thread one report file of alignment processing.
Optionally, the computer program 72 further includes：
Module is monitored, for before report importing, starting monitoring task, passes through monitoring task test and the publication
Connection status between platform；When connection status is in connection, creates this report and import corresponding journal file, pass through institute
The abnormal problem in monitoring task capture importing process is stated, and the abnormal problem is written in the journal file.
Optionally, the computer program 72 further includes：
Correction verification module, for reading the distributed corresponding verification sentence of report file by the importing thread, according to
The verification sentence generates checking command, the checking command is sent to the distribution platform, so that the distribution platform
Verify whether the report file has imported according to the checking command；
Distribution module, if the importing success message returned for receiving the distribution platform, to the importing thread
Distribute next report file to be imported；If the importing failed message that the distribution platform returns is received, again to institute
It states and imports the report file that thread distribution imports failure.
The terminal 7 can be the computing devices such as desktop PC, notebook, palm PC and cloud server.Institute
It states terminal may include, but is not limited only to, processor 70, memory 71.It will be understood by those skilled in the art that Fig. 7 is only eventually
The example at end 7, the not restriction of structure paired terminal 7 may include than illustrating more or fewer components, or the certain portions of combination
Part or different components, such as the terminal can also include input-output equipment, network access equipment, bus etc..
Alleged processor 70 can be central processing unit (Central Processing Unit, CPU), can also be
Other general processors, digital signal processor (Digital Signal Processor, DSP), application-specific integrated circuit
(Application Specific Integrated Circuit, ASIC), field programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor can also be any conventional processor
Deng the processor is the control centre of the terminal, utilizes the various pieces of various interfaces and the entire terminal of connection.
The memory 71 can be used for storing the computer program and/or module, and the processor is by running or holding
Row stores computer program and/or module in the memory, and calls the data being stored in memory, realizes institute
State the various functions of terminal.The memory can include mainly storing program area and storage data field, wherein storing program area can
Application program (such as sound-playing function, image player function etc.) needed for storage program area, at least one function etc.；It deposits
Storage data field can be stored uses created data etc. according to terminal.It is deposited in addition, memory may include high random access
Reservoir can also include nonvolatile memory, such as hard disk, memory, plug-in type hard disk, intelligent memory card (Smart Media
Card, SMC), safe digital card (Secure Digital, SD), flash card (Flash Card), at least one magnetic disk storage
Part, flush memory device or other volatile solid-state parts.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, it can also
It is that each unit physically exists alone, it can also be during two or more units be integrated in one unit.Above-mentioned integrated list
The form that hardware had both may be used in member is realized, can also be realized in the form of SFU software functional unit.
If the integrated module/unit be realized in the form of SFU software functional unit and as independent product sale or
In use, can be stored in a computer readable storage medium.Based on this understanding, the present invention realizes above-described embodiment
All or part of flow in method can also instruct relevant hardware to complete, the calculating by computer program
Machine program can be stored in a computer readable storage medium, and the computer program is when being executed by processor, it can be achieved that above-mentioned
The step of each embodiment of the method.Wherein, the computer program includes computer program code, the computer program code
Can be source code form, object identification code form, executable file or certain intermediate forms etc..The computer-readable storage medium
Matter may include：Can carry the computer program code any entity or device, recording medium, USB flash disk, mobile hard disk,
Magnetic disc, CD, computer storage, read-only memory (ROM, Read-Only Memory), random access memory (RAM,
Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium etc..It should be noted that described
It is appropriate that the content that computer readable storage medium includes can be carried out according to legislation in jurisdiction and the requirement of patent practice
Increase and decrease, such as in certain jurisdictions, according to legislation and patent practice, computer readable storage medium do not include be electric load
Wave signal and telecommunication signal.
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations；Although with reference to aforementioned reality
Applying example, invention is explained in detail, it will be understood by those of ordinary skill in the art that：It still can be to aforementioned each
Technical solution recorded in embodiment is modified or equivalent replacement of some of the technical features；And these are changed
Or replace, the spirit and scope for various embodiments of the present invention technical solution that it does not separate the essence of the corresponding technical solution should all
It is included within protection scope of the present invention.
Claims (10)
1. a kind of method that report imports and exports, which is characterized in that the method includes：
The user name and password for obtaining Report Form Design person, are sent to distribution platform, described in login by the user name and password
Distribution platform；
When report imports, obtains the Report Form Design person and wrapped in the destination folder locally chosen, the destination folder
At least one report file to be imported is included, importing thread identical with the report file quantity to be imported is opened, by institute
It states report file to be imported to be distributed one by one to the importing thread, by the importing thread according to the report file distributed
Store path the report file is directed into the distribution platform；
When report exports, obtain that the Report Form Design person chooses from the distribution platform at least one waits for derived report text
Part opens export thread identical with report file quantity derived from described wait for, waits for that derived report file divides one by one by described
It is assigned to the export thread, by the export thread according to the store path of the report file distributed from the distribution platform
The upper export report file.
2. the method that report as described in claim 1 imports and exports, which is characterized in that the method further includes：
Before report importing, start monitoring task, passes through the connection shape between monitoring task test and the distribution platform
State；
When connection status is in connection, creates this report and import corresponding journal file, captured by the monitoring task
Abnormal problem in importing process, and the abnormal problem is written in the journal file.
3. the method that report as described in claim 1 imports and exports, which is characterized in that by the importing thread according to institute
After the report file is directed into the distribution platform by the store path of the report file of distribution, the method further includes：
The distributed corresponding verification sentence of report file is read by the importing thread；
Checking command is generated according to the verification sentence, the checking command is sent to the distribution platform, so that described
Distribution platform verifies whether the report file has imported according to the checking command；
If receiving the importing success message that the distribution platform returns, distributed to the importing thread next to be imported
Report file；
If receiving the importing failed message that the distribution platform returns, failure is imported to the importing thread distribution again
The report file.
4. the method that report as described in any one of claims 1 to 3 imports and exports, which is characterized in that passing through the export
After thread exports the report file according to the store path of the report file distributed from the distribution platform, the side
Method further includes：
Obtain the interior content perhaps to be added to be modified in the report file；
Lookup is mutually related report file, according to it is described it is to be modified in content perhaps to be added to the report that is mutually related
File carries out unified modification.
5. the method that report as claimed in claim 4 imports and exports, which is characterized in that described to obtain in the report file
Content perhaps to be added includes in be modified：
Report file derived from parsing institute, obtains multiple keywords；
Modification table is generated using the keyword as table condition, shows that the modification table is checked for the Report Form Design person
And operation of modifying；
Content perhaps to be added in be modified, the display interior content perhaps to be added to be modified are obtained by the modification table
To prompt the Report Form Design person to confirm.
6. a kind of device that report imports and exports, which is characterized in that described device includes：
It is flat to be sent to publication by login module, the user name for obtaining Report Form Design person and password for the user name and password
Platform, to log in the distribution platform；
Import modul, for when report imports, obtaining the Report Form Design person in the destination folder locally chosen, the mesh
It includes at least one report file to be imported to mark file, opens lead identical with the report file quantity to be imported
Enter thread, the report file to be imported is distributed one by one to the importing thread, by the importing thread according to dividing
The report file is directed into the distribution platform by the store path for the report file matched；
Export module, for when report exports, obtain the Report Form Design person chosen from the distribution platform it is at least one
It waits for derived report file, export thread identical with report file quantity derived from described wait for is opened, derived from described wait for
Report file is distributed one by one to the export thread, by the export thread according to the store path of the report file distributed
The report file is exported from the distribution platform.
7. the device that report as claimed in claim 6 imports and exports, which is characterized in that described device further includes：
Module is monitored, for before report importing, starting monitoring task, passes through monitoring task test and the distribution platform
Between connection status；When connection status is in connection, creates this report and import corresponding journal file, pass through the prison
It listens task to capture the abnormal problem in importing process, and the abnormal problem is written in the journal file.
8. the device that report as claimed in claim 6 imports and exports, which is characterized in that described device further includes：
Correction verification module, for reading the distributed corresponding verification sentence of report file by the importing thread, according to described
Verify sentence generate checking command, the checking command is sent to the distribution platform so that the distribution platform according to
The checking command verifies whether the report file has imported；
Distribution module, if the importing success message returned for receiving the distribution platform, is distributed to the importing thread
Next report file to be imported；If receiving the importing failed message that the distribution platform returns, led again to described
Enter the report file that thread distribution imports failure.
9. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is held by processor
The step described in method that report described in any one of claim 1 to 5 imports and exports is realized when row.
10. a kind of terminal, the terminal includes memory, processor and storage on a memory and can run on a processor
Computer program, which is characterized in that the processor realizes such as the claims 1 to 5 when executing the computer program
The step of method that report described in one imports and exports.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711215119.0A CN108460068B (en) | 2017-11-28 | 2017-11-28 | Method, device, storage medium and terminal for importing and exporting report |
| PCT/CN2018/077360 WO2019104891A1 (en) | 2017-11-28 | 2018-02-27 | Method and device for importing and exporting report, storage medium, and terminal |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711215119.0A CN108460068B (en) | 2017-11-28 | 2017-11-28 | Method, device, storage medium and terminal for importing and exporting report |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108460068A true CN108460068A (en) | 2018-08-28 |
| CN108460068B CN108460068B (en) | 2021-03-12 |
Family
ID=63221143
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711215119.0A Active CN108460068B (en) | 2017-11-28 | 2017-11-28 | Method, device, storage medium and terminal for importing and exporting report |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN108460068B (en) |
| WO (1) | WO2019104891A1 (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109241074A (en) * | 2018-09-28 | 2019-01-18 | 中国平安财产保险股份有限公司 | Check data automatic processing method, device, computer equipment and storage medium |
| CN109359282A (en) * | 2018-09-25 | 2019-02-19 | 北京海数宝科技有限公司 | Listings data introduction method, device, computer equipment and storage medium |
| CN112417012A (en) * | 2020-04-29 | 2021-02-26 | 上海哔哩哔哩科技有限公司 | Data processing method and system |
| CN113378520A (en) * | 2021-04-20 | 2021-09-10 | 北京灵伴即时智能科技有限公司 | Text editing method and system |
| CN114546971A (en) * | 2022-01-26 | 2022-05-27 | 北京元年科技股份有限公司 | Data file format conversion method, device, equipment and readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120072391A1 (en) * | 2010-09-22 | 2012-03-22 | Alkiviadis Simitsis | Apparatus and method for an automatic information integration flow optimizer |
| CN104866599A (en) * | 2015-06-01 | 2015-08-26 | 北京京东尚科信息技术有限公司 | Production method and system of visual report |
| CN106708925A (en) * | 2016-11-11 | 2017-05-24 | 山东浪潮云服务信息科技有限公司 | Form business realization method and system, and business terminal |
| CN106911765A (en) * | 2017-01-23 | 2017-06-30 | 北京思特奇信息技术股份有限公司 | A kind of report file method for down loading and device |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140100787A1 (en) * | 2012-10-09 | 2014-04-10 | Aakash Jha | Assay Analysis, Tracking and Reporting System (AATR) |
| CN103235807A (en) * | 2013-04-19 | 2013-08-07 | 浪潮集团山东通用软件有限公司 | Data extracting and processing method supporting high-concurrency large-volume data |
| CN103927338A (en) * | 2014-03-26 | 2014-07-16 | 网神信息技术（北京）股份有限公司 | Log information storage processing method and log information storage processing device |
| CN107145537B (en) * | 2017-04-21 | 2021-06-18 | 深圳市天天来玩科技有限公司 | Table data importing method and system |
-
2017
- 2017-11-28 CN CN201711215119.0A patent/CN108460068B/en active Active
-
2018
- 2018-02-27 WO PCT/CN2018/077360 patent/WO2019104891A1/en active Application Filing
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120072391A1 (en) * | 2010-09-22 | 2012-03-22 | Alkiviadis Simitsis | Apparatus and method for an automatic information integration flow optimizer |
| CN104866599A (en) * | 2015-06-01 | 2015-08-26 | 北京京东尚科信息技术有限公司 | Production method and system of visual report |
| CN106708925A (en) * | 2016-11-11 | 2017-05-24 | 山东浪潮云服务信息科技有限公司 | Form business realization method and system, and business terminal |
| CN106911765A (en) * | 2017-01-23 | 2017-06-30 | 北京思特奇信息技术股份有限公司 | A kind of report file method for down loading and device |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109359282A (en) * | 2018-09-25 | 2019-02-19 | 北京海数宝科技有限公司 | Listings data introduction method, device, computer equipment and storage medium |
| CN109241074A (en) * | 2018-09-28 | 2019-01-18 | 中国平安财产保险股份有限公司 | Check data automatic processing method, device, computer equipment and storage medium |
| CN109241074B (en) * | 2018-09-28 | 2023-09-26 | 中国平安财产保险股份有限公司 | Automatic auditing data processing method and device, computer equipment and storage medium |
| CN112417012A (en) * | 2020-04-29 | 2021-02-26 | 上海哔哩哔哩科技有限公司 | Data processing method and system |
| CN113378520A (en) * | 2021-04-20 | 2021-09-10 | 北京灵伴即时智能科技有限公司 | Text editing method and system |
| CN113378520B (en) * | 2021-04-20 | 2024-04-09 | 北京灵伴即时智能科技有限公司 | Text editing method and system |
| CN114546971A (en) * | 2022-01-26 | 2022-05-27 | 北京元年科技股份有限公司 | Data file format conversion method, device, equipment and readable storage medium |
| CN114546971B (en) * | 2022-01-26 | 2022-11-08 | 北京元年科技股份有限公司 | Data file format conversion method, device, equipment and readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108460068B (en) | 2021-03-12 |
| WO2019104891A1 (en) | 2019-06-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108268253B (en) | Interface code generation method and terminal equipment | |
| US10769228B2 (en) | Systems and methods for web analytics testing and web development | |
| CN108460068A (en) | Method, apparatus, storage medium and the terminal that report imports and exports | |
| US8874479B2 (en) | Systems and methods for testing a financial trading system | |
| CN108459957A (en) | Test method, device, equipment and the storage medium of fund system test case | |
| CN108628748B (en) | Automatic test management method and automatic test management system | |
| Washizaki et al. | Software-engineering design patterns for machine learning applications | |
| CN111563016B (en) | Log collection and analysis method and device, computer system and readable storage medium | |
| CN108255479B (en) | Creation method, device, storage medium and the terminal of cube file | |
| CN111562965B (en) | Page data verification method and device based on decision tree | |
| CN112860777B (en) | Data processing method, device and equipment | |
| CN110287002A (en) | A kind of ether mill virtual machine defect inspection method and system | |
| CN114372006A (en) | Method and system for automatically generating test case, computer equipment and storage medium | |
| CN104657274A (en) | Method and device for testing software interface | |
| CN114116496A (en) | Automatic testing method, device, equipment and medium | |
| CN111813739A (en) | Data migration method and device, computer equipment and storage medium | |
| CN112035350A (en) | Test method and device for block chain system and computer equipment | |
| CN107679423A (en) | Partition integrity inspection method and device | |
| Safonova | On one approach to modeling enterprise-wide function-oriented computer networks | |
| CN110443044A (en) | Block chain client bug excavation method, device, equipment and storage medium | |
| CN110362294A (en) | Development task executes method, apparatus, electronic equipment and storage medium | |
| CN109669829A (en) | A kind of diagnosis adjustment method, device and server based on BMC | |
| CN109542890A (en) | Data modification method, device, computer equipment and storage medium | |
| CN115268847A (en) | Block chain intelligent contract generation method and device and electronic equipment | |
| CN112035366B (en) | Test case generation method, device and equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |