CN103729337B - report conversion method and device - Google Patents
report conversion method and device Download PDFInfo
- Publication number
- CN103729337B CN103729337B CN201310740376.1A CN201310740376A CN103729337B CN 103729337 B CN103729337 B CN 103729337B CN 201310740376 A CN201310740376 A CN 201310740376A CN 103729337 B CN103729337 B CN 103729337B
- Authority
- CN
- China
- Prior art keywords
- field
- local
- reference format
- report
- mapping table
- 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.)
- Active
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A kind of report conversion method, including：Local form and the reference format form chosen is obtained, extracts the form header of the local form and reference format form；Obtain the field of local form and the field of corresponding reference format form chosen in the form header；Generate the mapping table of the field of the local form of the selection and the field of the reference format form and storage；Data are extracted from the field of the local form according to the mapping table, and write in the field of corresponding reference format form.In addition, additionally provide a kind of form conversion equipment.Above-mentioned report conversion method and device can improve the convenience of operation.
Description
Technical field
The present invention relates to ERP technical fields, more particularly to a kind of report conversion method and device.
Background technology
It is usually the system of mutual isomery, the i.e. database of data storage and table structure in conventional art, between ERP system
Different, when needing according to unified form output report, then the elder generation for needing staff manual extracts from its ERP system
Go out data, be then filled up to again in the form of unified form.For example, ERP system is generating XBRL according to its data
（Extensible Business Reporting Language, Extensible Business Reporting Language）During form, then need to manage
Member extracts data in ERP system, and then according to the form collator data of XBRL forms, therefore operating efficiency is relatively low.
The content of the invention
Based on this, it is necessary to provide a kind of report conversion method that can improve operating efficiency.
A kind of report conversion method, including：
Local form and the reference format form chosen is obtained, extracts the form of the local form and reference format form
Header；
Obtain the field of local form chosen in the form header and corresponding reference format form
Field；
Generate the mapping table of the field of the local form of the selection and the field of the reference format form and storage；
Data are extracted from the field of the local form according to the mapping table, and write corresponding reference format form
Field in.
In one of the embodiments, also wrapped before described the step of obtaining local form and the reference format form chosen
Include：
Obtain local Report List and reference format Report List and show.
In one of the embodiments, also wrapped before described the step of obtaining local form and the reference format form chosen
Include：
The querying condition of input is obtained, according to the querying condition to the local Report List and/or reference format report
Table list is screened.
In one of the embodiments, the reference format form is the form for meeting XBRL forms.
In one of the embodiments, the field of the local form of the generation selection and the reference format form
Field mapping table the step of also include：
Obtain query statement/arithmetic statement of input and the field of corresponding reference format form and be added to mapping
The field for the local form chosen is included in table, and in the query statement/arithmetic statement.
A kind of form conversion equipment that can improve operating efficiency is provided in addition, there is a need to.
A kind of form conversion equipment, including：
Report heading acquisition module, for obtaining local form and the reference format form chosen, extract the local form
With the form header of reference format form；
Field acquisition module, for obtaining the field of local form chosen in the form header and corresponding
Reference format form field；
Mapping table generation module, for the field and the word of the reference format form of the local form for generating the selection
The mapping table of section and storage；
Data migration module, for extracting data from the field of the local form according to the mapping table, and write
In the field of corresponding reference format form.
In one of the embodiments, described device also includes form display module, for obtain local Report List and
Reference format Report List is simultaneously shown.
In one of the embodiments, the form display module is additionally operable to obtain the querying condition of input, according to described
Querying condition screens to the local Report List and/or reference format Report List.
In one of the embodiments, the reference format form is the form for meeting XBRL forms.
In one of the embodiments, the mapping table generation module is additionally operable to obtain query statement/computing language of input
The field of sentence and corresponding reference format form is simultaneously added in mapping table, and is wrapped in the query statement/arithmetic statement
The field of local form containing selection.
In above-mentioned report conversion method and device, user can be by choosing local form and reference format form, so in advance
Corresponding field is selected to be mapped to generate mapping table in its form header afterwards.Subsequently in generation reference format form
When, then it can find that corresponding field in local form reads data automatically and to write reference format form corresponding according to mapping table
In field, so as to improve the convenience of operation.
Meanwhile user can be in the ERP system of each isomery by selecting field to generate corresponding mapping table.According to each
During the ERP system generation reference format form of individual isomery, then data can be read according to corresponding mapping table so that change form
Mode is independent of specific ERP system, so as to improve autgmentability.
Brief description of the drawings
Fig. 1 is the flow chart of report conversion method in one embodiment；
Fig. 2 is the structural representation of form conversion equipment in one embodiment.
Embodiment
As shown in figure 1, in one embodiment, a kind of report conversion method, the execution of this method depends on computer journey
Sequence, it can run in the computer system based on Von Neumann system, the computer system can be the meter for having gateway function
Calculate machine equipment.
This method includes：
Step S102, local form and the reference format form chosen is obtained, extracts local form and reference format form
Form header.
Local form is the tables of data in the ERP system of each isomery, and reference format form as needs the report generated
Table.In the present embodiment, annotation formatting form is the form for meeting XBRL forms.XBRL is to be based on internet, cross-platform operation,
It is in the world by accounting standard and computer language phase dedicated for financial report establishment, the computer language for disclosing and using
With reference to the newest recognised standard and technology exchanged for unstructured data, especially financial information.XBRL forms are to meet
《Extensible Business Reporting Language（XBRL）Technical specification》With《Accounting standards for enterprises universal classification standard》Reference format report
Table.
Form header is the field letter of respective definition cell attribute type in local form and reference format form
Breath, including row element information（Field i.e. in form in horizontal gauge outfit）With column element information（I.e. in form in longitudinal gauge outfit
Field）.
In the present embodiment, also include before the step of obtaining local form and the reference format form chosen：Obtain this
Ground Report List and reference format Report List are simultaneously shown.
Can be first using the local Report List in the ERP system of local and the reticle as reference format report definition sample
Formula form shows user respectively, and user can single choice one or more in local Report List and reference format Report List respectively
Select several local forms.That is, due to generally having multiple forms, user in such as XBRL forms table in reference format form
One or more local forms can be chosen in local ERP system, then accordingly choose a species in XBRL Report Lists again
Type（Such as one kind in the financial table of reference format）XBRL forms.
Further, the querying condition of input is obtained, according to querying condition to local Report List and/or reference format report
Table list is screened.
For example, user can be by inputting Business Name, time（The timing statisticses of local form, such as financial table in 2013,
In March, 2012 finance table）, the querying condition such as report form type.Because usual local form quantity is more in local ERP system, because
This adds querying condition and carries out screening the scope that can reduce user's selection, so as to facilitate user to choose.
Step S104, obtain the field for the local form chosen in form header and corresponding reference format report
The field of table.
In the present embodiment, the field for the local form chosen in form header and corresponding reticle are obtained
It can will can be shown in the form of cell after the field of formula form.For example, have in form header row element information and
Column element information, then includes transversely arranged cell corresponding with each field in row element information, in column element information then
Cell comprising from clump corresponding with each field to arrangement.
User can choose the field of local form and reference format form by clicking cell.
Step S106, generate mapping table and the storage of the field of the local form of selection and the field of reference format form.
For example, if user have chosen a3 cells in local form A, b2 units are have chosen in reference format form B
Lattice, then the field of local form A corresponding to a3 cells is that the field in reference format form B corresponding with b2 cells is formed
Mapping, the mapping are recordable in mapping table and stored.
Step S108, data are extracted from the field of local form according to mapping table, and write corresponding reference format report
In the field of table.
If desired according to the local report generation reference format form of the ERP system, then can first obtain and the ERP system pair
The mapping table answered, the title and field of the corresponding local form in the mapping table of each field in reference format form are found,
Then the digital independent in local form under the field and write in reference format form in corresponding field.
As above in example, reference format form B is generated to the ERP system according to corresponding to local form A, then can be obtained corresponding
Mapping table, local form A field a3 is then found according to mapping table, the data stored under a3 is read, is then written into
In reference format form B b2 fields.
In the present embodiment, the step of the mapping table of the field of the local form of selection and the field of reference format form is generated
Suddenly also include：
Obtain query statement/arithmetic statement of input and the field of corresponding reference format form and be added to mapping
The field for the local form chosen is included in table, and in query statement/arithmetic statement.
As above in example, user can have chosen a1 cells and a2 cells in local form A, in reference format form B
In have chosen b1 cells, and define arithmetic statement and be added with a2 for a1, then the arithmetic statement that the a1 is added with a2 is mono- i.e. with b1
Field in reference format form B corresponding to first lattice forms mapping, and the mapping is recordable in mapping table and stored.
Subsequently when generating reference format form B, then a1 and a2 in local form A can be read, calculate it and write afterwards
In reference format form B b1 fields.
For another example user can input SQL（Structured Query Language, SQL）Sentence, should
A4, a5 and a6 cell and partial query condition in local form A can be included in sql like language, then chooses b3 units again
Lattice, then the SQL statement is that the field in reference format form B corresponding with b3 cells forms mapping, and the mapping is i.e. recordable
Stored in the mapping table.
Subsequently when generating reference format form B, then the SQL statement first can be read according to mapping table, then in local report
The SQL statement relevant with a4, a5, a6 is performed in Table A, and the result for performing SQL statement return is write into reference format form B
B3 fields in.
In one embodiment, as shown in Fig. 2 a kind of form conversion equipment, including report heading acquisition module 102, field
Acquisition module 104, mapping table generation module 106 and data migration module 108, wherein：
Report heading acquisition module 102, for obtaining local form and the reference format form chosen, extract local form and
The form header of reference format form.
Field acquisition module 104, for obtaining the field of local form chosen in form header and corresponding
Reference format form field.
Mapping table generation module 106, for the field and the field of reference format form of the local form for generating selection
Mapping table simultaneously stores.
Data migration module 108, for extracting data from the field of local form according to mapping table, and write corresponding
In the field of reference format form.
In one embodiment, form conversion equipment also includes form display module 110, for obtaining local Report List
With reference format Report List and show.
In one embodiment, form display module 110 is additionally operable to obtain the querying condition of input, according to querying condition pair
Local Report List and/or reference format Report List is screened.
In one embodiment, reference format form is the form for meeting XBRL forms.
In one embodiment, mapping table generation module 106 be additionally operable to obtain input query statement/arithmetic statement and with
The field of its corresponding reference format form is simultaneously added in mapping table, and the sheet chosen is included in query statement/arithmetic statement
The field of ground form.
In above-mentioned report conversion method and device, user can be by choosing local form and reference format form, so in advance
Corresponding field is selected to be mapped to generate mapping table in its form header afterwards.Subsequently in generation reference format form
When, then it can find that corresponding field in local form reads data automatically and to write reference format form corresponding according to mapping table
In field, so as to improve the convenience of operation.
Meanwhile user can be in the ERP system of each isomery by selecting field to generate corresponding mapping table.According to each
During the ERP system generation reference format form of individual isomery, then data can be read according to corresponding mapping table so that change form
Mode is independent of specific ERP system, so as to improve autgmentability.
One of ordinary skill in the art will appreciate that realize all or part of flow in above-described embodiment method, being can be with
The hardware of correlation is instructed to complete by computer program, described program can be stored in a computer read/write memory medium
In, the program is upon execution, it may include such as the flow of the embodiment of above-mentioned each method.Wherein, described storage medium can be magnetic
Dish, CD, read-only memory（Read-Only Memory, ROM）Or random access memory（Random Access
Memory, RAM）Deng.
Embodiment described above only expresses the several embodiments of the present invention, and its description is more specific and detailed, but simultaneously
Therefore the limitation to the scope of the claims of the present invention can not be interpreted as.It should be pointed out that for one of ordinary skill in the art
For, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to the guarantor of the present invention
Protect scope.Therefore, the protection domain of patent of the present invention should be determined by the appended claims.
Claims (10)
1. a kind of report conversion method, including：
Local form and the reference format form chosen is obtained, extracts the report heading letter of the local form and reference format form
Breath, wherein, the local form is the tables of data in the ERP system of multiple isomeries, and the reference format form is one selected
XBRL forms form；
Obtain the field of local form chosen in the form header of the local form and reference format form and and its
The field of corresponding reference format form；
The mapping table of the field of the local form of the selection and the field of the reference format form and storage are generated, to pass through
Field is selected to generate mapping table corresponding to the ERP system of each isomery；
Data are extracted from the field of the local form in corresponding ERP system according to the mapping table, and write corresponding
Reference format form field in.
2. report conversion method according to claim 1, it is characterised in that described to obtain the local form chosen and standard
Also include before the step of form form：
Obtain local Report List and reference format Report List and show.
3. report conversion method according to claim 2, it is characterised in that described to obtain the local form chosen and standard
Also include before the step of form form：
The querying condition of input is obtained, the local Report List and/or reference format form are arranged according to the querying condition
Table is screened.
4. report conversion method according to claim 1, it is characterised in that the reference format form is to meet XBRL lattice
The form of formula.
5. report conversion method according to claim 1, it is characterised in that the local form of the generation selection
The step of mapping table of field and the field of the reference format form, also includes：
Obtain query statement/arithmetic statement of input and the field of corresponding reference format form and be added to mapping table
In, and the field of the local form comprising selection in the query statement/arithmetic statement.
A kind of 6. form conversion equipment, it is characterised in that including：
Report heading acquisition module, for obtaining local form and the reference format form chosen, extract the local form and mark
The form header of quasiconfiguaration form, wherein, the local form for multiple isomeries ERP system in tables of data, the mark
Quasiconfiguaration form is the form of a selected XBRL form；
Field acquisition module, for obtaining the local chosen in the form header of the local form and reference format form
The field of the field of form and corresponding reference format form；
Mapping table generation module, for the field and the field of the reference format form of the local form for generating the selection
Mapping table simultaneously stores, with by selecting field to generate mapping table corresponding to the ERP system of each isomery；
Data migration module, for being carried according to the mapping table from the field of the local form in corresponding ERP system
Access evidence, and write in the field of corresponding reference format form.
7. form conversion equipment according to claim 6, it is characterised in that described device also includes form display module,
For obtaining local Report List and reference format Report List and showing.
8. form conversion equipment according to claim 7, it is characterised in that the form display module is additionally operable to obtain defeated
The querying condition entered, the local Report List and/or reference format Report List are screened according to the querying condition.
9. form conversion equipment according to claim 6, it is characterised in that the reference format form is to meet XBRL lattice
The form of formula.
10. form conversion equipment according to claim 6, it is characterised in that the mapping table generation module is additionally operable to obtain
Take query statement/arithmetic statement of input and the field of corresponding reference format form and be added in mapping table, and institute
State the field that the local form chosen is included in query statement/arithmetic statement.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310740376.1A CN103729337B (en) | 2013-12-27 | 2013-12-27 | report conversion method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310740376.1A CN103729337B (en) | 2013-12-27 | 2013-12-27 | report conversion method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103729337A CN103729337A (en) | 2014-04-16 |
| CN103729337B true CN103729337B (en) | 2018-01-12 |
Family
ID=50453416
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310740376.1A Active CN103729337B (en) | 2013-12-27 | 2013-12-27 | report conversion method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103729337B (en) |
Families Citing this family (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104268244B (en) * | 2014-09-28 | 2018-08-21 | 广州华多网络科技有限公司 | Handle the method and device of list |
| CN104408030B (en) * | 2014-10-28 | 2018-01-05 | 用友网络科技股份有限公司 | XBRL examples generation method and XBRL example generating means |
| CN104618490B (en) * | 2015-02-09 | 2018-06-19 | 深圳市联新移动医疗科技有限公司 | The data sharing method and system of communicating terminal in medical system |
| CN105320744B (en) * | 2015-09-24 | 2019-03-26 | 四川长虹电器股份有限公司 | The analytic method in XBRL classification standard custom link library |
| CN105335462A (en) * | 2015-09-24 | 2016-02-17 | 四川长虹电器股份有限公司 | Visual mapping method for data relation of XBRL application platform |
| JP7064128B2 (en) * | 2017-12-08 | 2022-05-10 | 富士通株式会社 | Judgment program, judgment device and judgment method |
| CN108509485B (en) * | 2018-02-07 | 2021-06-22 | 深圳壹账通智能科技有限公司 | Data preprocessing method and device, computer equipment and storage medium |
| CN109189769A (en) * | 2018-08-14 | 2019-01-11 | 平安医疗健康管理股份有限公司 | Data standardization processing method, device, computer equipment and storage medium |
| CN109284488B (en) * | 2018-09-06 | 2021-11-19 | 郑州云海信息技术有限公司 | Method, device and medium for modifying front-end table column data based on local storage |
| CN109299234B (en) * | 2018-09-19 | 2022-03-15 | 北京明略软件系统有限公司 | Information query method and device and computer readable storage medium |
| CN109558440B (en) * | 2018-10-18 | 2023-12-15 | 平安科技（深圳）有限公司 | Data batch processing method and device, computer equipment and storage medium |
| CN109636350A (en) * | 2018-12-17 | 2019-04-16 | 深圳壹账通智能科技有限公司 | Document structure tree method, apparatus, computer equipment and storage medium |
| CN110991150B (en) * | 2019-12-16 | 2023-10-03 | 中国铁塔股份有限公司 | Data format conversion method, device and account reporting system |
| CN114417802B (en) * | 2022-03-22 | 2022-06-10 | 创意信息技术股份有限公司 | Intelligent report generation system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101615177A (en) * | 2009-07-21 | 2009-12-30 | 深圳市科陆电子科技股份有限公司 | At structural self-defined report implementation method of server/browser and device |
| CN101652774A (en) * | 2007-04-03 | 2010-02-17 | 微软公司 | System for financial documentation conversion |
| CN101689259A (en) * | 2007-06-08 | 2010-03-31 | 埃森哲环球服务有限公司 | Migration of legacy applications |
| US8055997B2 (en) * | 2006-06-26 | 2011-11-08 | Lexmark International Technology, S.A. | System and method for implementing dynamic forms |
-
2013
- 2013-12-27 CN CN201310740376.1A patent/CN103729337B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8055997B2 (en) * | 2006-06-26 | 2011-11-08 | Lexmark International Technology, S.A. | System and method for implementing dynamic forms |
| CN101652774A (en) * | 2007-04-03 | 2010-02-17 | 微软公司 | System for financial documentation conversion |
| CN101689259A (en) * | 2007-06-08 | 2010-03-31 | 埃森哲环球服务有限公司 | Migration of legacy applications |
| CN101615177A (en) * | 2009-07-21 | 2009-12-30 | 深圳市科陆电子科技股份有限公司 | At structural self-defined report implementation method of server/browser and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103729337A (en) | 2014-04-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103729337B (en) | report conversion method and device | |
| US10354002B2 (en) | Interaction relationship building and explorer for dashboard | |
| US20110153611A1 (en) | Extracting data from a report document | |
| US20080306983A1 (en) | Mapping hierarchical data from a query result into a tabular format with jagged rows | |
| US9069831B2 (en) | Retrieving data objects | |
| CN101609460B (en) | Searching method of supporting isomeric geoscientific data resources and searching system | |
| CN104965886B (en) | Data dimension processing method | |
| TW201250492A (en) | Method and system of extracting web page information | |
| CN105760290B (en) | The problem of being tested based on webpage front-end localization method and relevant apparatus, system | |
| CN100444591C (en) | Method for acquiring front-page keyword and its application system | |
| CN104598462B (en) | Extract the method and device of structural data | |
| CN103955538B (en) | HBase data persistence and query methods and HBase system | |
| US8314798B2 (en) | Dynamic generation of contextual charts based on personalized visualization preferences | |
| KR20170098854A (en) | Building reports | |
| CN104063365B (en) | The method that object is inserted into PDF document | |
| US20030200501A1 (en) | Computer-implemented system and method for tagged and rectangular data processing | |
| US20070088731A1 (en) | Method and apparatus for improved processing and analysis of complex hierarchic data | |
| CN104881275A (en) | Electronic spreadsheet generating method and device | |
| JP2013507712A (en) | Excel-based analysis report creation system and method | |
| US20170161926A1 (en) | Rendering data visualizations in different analytical applications | |
| US20070299860A1 (en) | System and method for comparative analysis of business intelligence data | |
| CN108009145A (en) | Report form generation method and device | |
| US20090187552A1 (en) | System and Methods for Generating Data Analysis Queries from Modeling Constructs | |
| CN109408502A (en) | A kind of data standard processing method, device and its storage medium | |
| CN108628604A (en) | The parameter value generation method and system of SOA request messages |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |