CN105488052A - Method and system for converting structural data into layout form file - Google Patents
Method and system for converting structural data into layout form file Download PDFInfo
- Publication number
- CN105488052A CN105488052A CN201410475294.3A CN201410475294A CN105488052A CN 105488052 A CN105488052 A CN 105488052A CN 201410475294 A CN201410475294 A CN 201410475294A CN 105488052 A CN105488052 A CN 105488052A
- Authority
- CN
- China
- Prior art keywords
- form fields
- data
- report
- format
- file
- 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
Abstract
The invention discloses a method and system for converting structural data into a layout form file. According to the method and the system, a step of converting the structural data into the layout form file is optimized, and the structural data is converted on a technical platform; and structuration of the data in the layout form file is kept through the form field defined data obtained by parsing and the generated layout form file and the converted layout form file has interactive capability. The method comprises the following steps of utilizing a reporting tool to determine a form template according to the display requirements of the layout form file; parsing the form template and determining the form field defined data according to a parsing result; utilizing the form template and the structural data to generate a layout file; generating a layout form file template through the form field defined data and the layout file; and filling the structural data into the layout form file template and determining the layout form file.
Description
Technical field
The present invention relates to e-file technical field, particularly relate to method and system structural data being transferred to format formfile.
Background technology
At present, structural data stores in a database mostly, and its display depends on proprietary system, for ease of independence display and the utilization of data, need structural data to be converted to independently e-file, and the structuring of data can be retained, be convenient to extract structural data and carry out data recycle.On the other hand, the electronic document call after structural data conversion possesses interaction capabilities to a certain degree, as some data of adding or in amendment file, adds a cover E-seal etc.
Existing disposal route is generally take format the form tool and report tool two kinds of technology to carry out implementing structured data to be converted to e-file, change for not needing the e-file of interaction capabilities, general employing report tool realizes the report output of structural data, then by format e-files such as PDF that interface conversion is general.For needing mutual e-file, be generally generate form templat by format the form tool, then carry out form data filling by form filling interface, form technique ensure that the interaction capabilities of file.
Existing subject matter structural data being converted to the disposal route of format e-file is as follows:
Problem one, the file generated by report tool are non-structured, being not easy to the recycling of data, as needed structural data to carry out data recycle, also needing to reoffer a structurized data file, and causing file transfer and exchanging complexity increases;
The space of a whole page descriptive power of problem two, electronic spreadsheet is more weak, cannot meet the requirement of complex data.At present, it is have nothing to do with data that the design of electronic spreadsheet template generates, and the Show Styles of many structural datas is associated with the data, has the feature of form, as formulae discovery, complicated typesetting, automatically increases table row, content packet etc. according to content; Existing form design method cannot meet the conversion requirements of this kind of data;
Problem three, at present, structural data being converted to format e-file disposal route is electronic spreadsheet and report tool, but the technology path that these two kinds of conversion process methods adopt has larger difference, namely from the design of template, the filling of data, the extraction of data be all adopt diverse disposal route, format formfile is converted to as needed implementing structured data, two kinds of conversion process methods will be used respectively at two technology platforms, thus causing the complexity of total data conversion system to increase, cost also significantly increases.
In sum, prior art is to the method for structural data conversion process, can not meet the mutual demand of format e-file, with the structurized demand to data in format e-file, and at two technology platforms, structural data is changed respectively, also significantly will increase complexity and the cost of structural data converting system.
Summary of the invention
Embodiments provide method and system structural data being transferred to format formfile, optimize the switch process of structural data to format formfile, achieve and on a technology platform, structural data is changed; According to resolution table single domain definition data, the format formfile of generation, thus maintain the structuring of data in format formfile, and make the format formfile after conversion possess interaction capabilities.
A kind of method structural data being converted to format formfile that the embodiment of the present invention provides, comprising:
According to the display requirement of format formfile, utilize report tool determination form templat;
Resolve described form templat, and according to analysis result determination form fields definition data;
Utilize described form templat and structural data, generate layout files;
By described form fields definition data, and described layout files, generate format formfile template;
Structural data is filled in described format formfile template, determines format formfile.
By the method, optimize the switch process of structural data to format formfile, achieve and on a technology platform, structural data is changed; According to resolution table single domain definition data, the format formfile of generation, thus maintain the structuring of data in format formfile, the format formfile obtained after making interstitital texture data possesses interaction capabilities.
Preferably, described form templat comprises: form fields occupy-place control; Wherein, described form fields occupy-place control comprises: form fields attribute, and described form fields attribute is the attribute of the form fields determined by described form fields occupy-place control;
Resolve described form templat, and according to analysis result determination form fields definition data, comprising:
Resolve the list occupy-place control in described form templat, and according to analysis result determination form fields definition data, wherein, described form fields definition data comprise: described form fields attribute.
Preferably, also comprise in described form templat: for the formula calculated structural data;
Utilize described form templat and structural data, generate layout files, comprising:
Structural data is filled in described form templat, obtains the first report file;
By described formula, obtain the result of calculation of described structural data, and described result of calculation is cured in described first report file, obtain Secondary Report list file;
Delete the structural data of filling in described Secondary Report list file, obtain the 3rd report file;
Utilize described report tool to change described 3rd report file, obtain layout files.
Pass through the method, utilize that in form templat, to add what preset take structural data as the computing formula of parameter, achieve the process operation of the formulae discovery that traditional form template cannot realize, by being cured the result of calculation of structural data, thus when achieving in form templat the data variation participating in calculating, the data of result of calculation position display are no longer along with change.
Preferably, also comprise in described form templat: generate the pretreatment operation information before layout files;
Utilize described form templat and structural data, generate layout files, comprising:
Described structural data is filled in described form templat, obtains the first report file;
According to described pretreatment operation information, utilize described report tool to process described first report file, obtain Secondary Report list file;
Delete the structural data of filling in described Secondary Report list file, obtain the 3rd report file;
Utilize described report tool to change described 3rd report file, obtain layout files;
By described form fields definition data, and described layout files, generate format formfile template, comprising:
According to Secondary Report list file, adjust described form fields definition data, obtain the second form fields definition data;
By described second form fields definition data, and described layout files, generate format formfile template.
Preferably, described form fields occupy-place control also comprises form fields occupy-place control property, and described form fields occupy-place control property comprises: typesetting attribute, repeated rows attribute and packet attributes;
Utilize described form templat and structural data, generate layout files, comprising:
According to described structural data, adjust described form templat, obtain the first report file;
Described structural data is filled in described first report file, obtains Secondary Report list file;
According to the typesetting attribute in described form fields occupy-place control property, adjust described Secondary Report list file, obtain the 3rd report file;
Delete the structural data of filling in described 3rd report file, obtain the 4th report file;
Utilize described report tool to change described 4th report file, obtain layout files;
By described form fields definition data, and described layout files, generate format formfile template, comprising:
According to described structural data, adjust described form fields definition data, obtain the second form fields definition data;
According to described 3rd report file, adjust described second form fields definition data, obtain the 3rd form fields definition data;
By described 3rd form fields definition data, and described layout files, generate format formfile template.
Pass through the method, utilize in form templat, add form fields occupy-place control property, achieve the complicated list comprising complicated typesetting, automatically expand row, content packet etc. that traditional form template cannot realize, effectively expand the range of application of form and list, and the present invention is by being unified in form design of the prior art and Report Form Design on a platform, thus reduce construction and maintenance cost structural data being converted to format formfile equipment.
Preferably, described form fields attribute comprises: could edit properties;
Utilize described form templat and structural data, after generating layout files, define data by described form fields, and described layout files, before generating format formfile template, the method also comprises:
According to described could edit properties, determine that the form fields in the format formfile template needing to generate could be edited.
Pass through the method, achieve, on same technology platform, structural data is converted into format e-file, thus meet the file transform of labyrinth data and simple structure data, achieve the format formfile after conversion and possess mutual demand, and ensure that the structuring of the data in the format formfile after conversion.
A kind of system structural data being converted to format formfile that the embodiment of the present invention provides, comprising:
Determine form templat unit, for the display requirement according to format formfile, utilize report tool determination form templat;
Determine form fields definition data cell, for resolving described form templat, and according to analysis result determination form fields definition data;
Generating layout files unit, for utilizing described form templat and structural data, generating layout files;
Generate format form templat unit, for defining data by described form fields, and described layout files, generate format formfile template;
Interstitital texture data cell, for being filled into by structural data in described format formfile template, determines format formfile.
By this system, optimize the switch process of structural data to format formfile, achieve and on a technology platform, structural data is changed; According to resolution table single domain definition data, the format formfile of generation, thus maintain the structuring of data in format formfile, the format formfile obtained after making interstitital texture data possesses interaction capabilities.
Preferably, described form templat comprises: form fields occupy-place control; Wherein, described form fields occupy-place control comprises: form fields attribute, and described form fields attribute is the attribute of the form fields determined by described form fields occupy-place control;
Described determine form fields definition data cell, specifically for:
Resolve the list occupy-place control in described form templat, and according to analysis result determination form fields definition data, wherein, described form fields definition data comprise: described form fields attribute.
Preferably, also comprise in described form templat: for the formula calculated structural data;
Described generation layout files unit, specifically for:
According to described form templat, described structural data is filled in described form templat, obtains the first report file;
By described formula, obtain the result of calculation of described structural data, and described result of calculation is cured in described first report file, obtain Secondary Report list file;
Delete the structural data of filling in described Secondary Report list file, obtain the 3rd report file;
Utilize described report tool to change described 3rd report file, obtain layout files.
By this system, utilize that in form templat, to add what preset take structural data as the computing formula of parameter, achieve the process operation of the formulae discovery that traditional form template cannot realize, by being cured the result of calculation of structural data, thus when achieving in form templat the data variation participating in calculating, the data of result of calculation position display are no longer along with change.
Preferably, also comprise in described form templat: generate the pretreatment operation information before layout files;
Described generation layout files unit, specifically for:
Described structural data is filled in described form templat, obtains the first report file;
According to described pretreatment operation information, utilize described report tool to process described first report file, obtain Secondary Report list file;
Delete the structural data of filling in described Secondary Report list file, obtain the 3rd report file;
Utilizing described report tool by changing described 3rd report file, obtaining layout files;
Described generation format form templat unit, specifically for:
According to Secondary Report list file, adjust described form fields definition data, obtain the second form fields definition data;
By described second form fields definition data, and described layout files, generate format formfile template.
Preferably, described form fields occupy-place control also comprises form fields occupy-place control property, and described form fields occupy-place control property comprises: typesetting attribute, repeated rows attribute and packet attributes;
Described generation layout files unit, specifically for:
According to described structural data, adjust described form templat, obtain the first report file;
Described structural data is filled in described first report file, obtains Secondary Report list file;
According to the typesetting attribute in described form fields occupy-place control property, adjust described Secondary Report list file, obtain the 3rd report file;
Delete the structural data of filling in described 3rd report file, obtain the 4th report file;
Utilize described report tool to change described 4th report file, obtain layout files;
Described generation format form templat unit, specifically for:
According to described structural data, adjust described form fields definition data, obtain the second form fields definition data;
According to described 3rd report file, adjust described second form fields definition data, obtain the 3rd form fields definition data;
By described 3rd form fields definition data, and described layout files, generate format formfile template.
By this system, utilize in form templat, add form fields occupy-place control property, achieve the complicated list comprising complicated typesetting, automatically expand row, content packet etc. that traditional form template cannot realize, effectively expand the range of application of form and list, and the present invention is by being unified in form design of the prior art and Report Form Design on a platform, thus reduce construction and maintenance cost structural data being converted to format formfile equipment.
Preferably, described form fields attribute comprises: could edit properties;
Generate format form templat unit by described form fields definition data and described layout files, before generation format formfile template, also for:
According to described could edit properties, determine that the form fields in the format formfile template needing to generate could be edited.
By this system, achieve, on same technology platform, structural data is converted into format e-file, thus meet complicated structural data and the file transform of simple structural data, achieve the format formfile after conversion and possess mutual demand, and ensure that the structuring of the data in the format formfile after conversion.
Accompanying drawing explanation
Schematic flow sheet structural data being converted to the method for format formfile that Fig. 1 provides for the embodiment of the present invention;
Fig. 2 for the embodiment of the present invention provide for the situation comprising with structural data the computing formula being parameter in form templat, structural data is converted to the schematic flow sheet of format formfile method;
What Fig. 3 provided for the embodiment of the present invention carries out pretreated situation for before conversion layout files to form templat, structural data is converted to the schematic flow sheet of format formfile method;
The situation that the special typesetting for format formfile that Fig. 4 provides for the embodiment of the present invention, repeated rows and grouping etc. require, is converted to the schematic flow sheet of format formfile method by structural data;
Schematic flow sheet structural data being converted to the entire protocol of the method for format formfile that Fig. 5 provides for the embodiment of the present invention;
A kind of structural representation structural data being converted to the system of format formfile that Fig. 6 provides for the embodiment of the present invention.
Embodiment
Embodiments provide a kind of method and system structural data being converted to format formfile, achieve, on a technology platform, structural data is converted to format e-file, keep data structured and e-file after making conversion possesses interaction capabilities.
See Fig. 1, a kind of method structural data being converted to format formfile that the embodiment of the present invention provides, comprising:
S101, display requirement according to format formfile, utilize report tool determination form templat;
S102, resolve described form templat, and according to analysis result determination form fields definition data;
S103, utilize described form templat and structural data, generate layout files;
S104, by described form fields definition data, and described layout files, generates format formfile template;
S105, structural data to be filled in described format formfile template, to determine format formfile.
Wherein, described form templat comprises: form fields occupy-place control; Wherein, described form fields occupy-place control comprises: form fields occupy-place control property and form fields attribute;
Wherein, described form fields attribute is the attribute of the form fields determined by described form fields occupy-place control;
Wherein, described form fields occupy-place control property comprises: special typesetting attribute, repeated rows attribute and packet attributes; Described form fields attribute comprises: field type attribute, data source property, form fields position attribution and could edit properties.
Preferably, described form templat, also comprises: for the formula that calculates structural data and pretreatment operation information before generating layout files, wherein, the parameter of the described formula for calculating structural data is the structural data of filling.
Preferably, the format formfile template that S104 generates can reuse, and for the structural data of isomorphism, and the conversion that the Show Styles of format formfile and data have nothing to do, directly can use the format formfile template that form templat in S104 generates in advance.
Preferably, resolve the list occupy-place control in described form templat in S102, and according to the analysis result to described form fields occupy-place control, determine form fields definition data, wherein, described form fields definition data comprise: described form fields attribute;
Wherein, described form fields definition data can be that empty list defines data, and namely described form fields definition data can not comprise the form fields participating in display, thus realize being embedded into by structural data in the conventional layout files of additive method generation.
The method a kind of structural data provided the embodiment of the present invention being converted to layout files is below specifically described.
First, due to the problem utilizing the form templat generated in prior art cannot solve complicated typesetting, therefore embodiments provide and a kind of support complicated typesetting, row is expanded, grouping and the generation method of form templat that automatically calculates, the method comprises the steps:
Step one, according to the display requirement of form templat to structural data, utilize report tool determination form templat, wherein, described form templat comprises, for the formula part calculated structural data, and show irrelevant form templat part with structural data.Wherein, described all-purpose financial statements instrument, need support complicated typesetting required for the present invention, row expansion, formula, self-defining function operation.
Step 2, on form templat, form fields occupy-place control is added in the position of structured data.
The form of form fields occupy-place control is relevant with the report tool generating form templat, as used Excel or Word as report tool, the ActiveX control that form fields occupy-place control both can carry for report tool, such as text box TextBox, frames images ImageBox also can be the ActiveX of customized development.
Step 3, form fields belonging to form fields occupy-place control specify form fields attribute and form fields occupy-place control property, and wherein, described form fields attribute comprises, field type attribute, data source property, form fields position attribution and could edit properties.
Wherein, described field type attribute is the type of form fields, and namely form fields can be text box, combobox, multiselect frame, radio box, frames images or official seal control etc.
Described data source property is the data of filling in this form fields descriptions at structural data interior joint, such as, extend markup language (ExtensibleMarkupLanguage, XML), in the path language XPath "/patent innovation registration/update date/" in, " patent innovation registration " and " update date " is the node of XML data.
Described could edit properties, whether be the data of filling in this form fields in format formfile can by interactive editing.
Preferably, described form fields occupy-place control property comprises, special typesetting attribute, repeated rows attribute and packet attributes etc.Wherein, the definition of repeated rows attribute, packet attributes can be realized by the expansion of data source property.
Wherein, described special typesetting attribute, whether have special typesetting requirement, such as, according to the data of the filling in this form fields, adjust form fields size if being this form fields.
Described repeated rows attribute, is the design to the Show Styles in this form fields of the duplicate node in data source.And, in order to final format formfile is known attractive in appearance, also may be required in the repeat number of structural data node less time, for file retains minimum line number.Such as, repeated rows definition is realized by specifying the form fields data source property "/patent innovation registration/patent [1..a|n]/title " of repeated rows, wherein, a represents minimum line number, n represents that format formfile finally shows line number, when the number of nodes n in data "/patent innovation registration/patent " is greater than a; Repeated rows is then by this form fields is expert at and n-1 is capable continuously downwards.The structural data that the row at form fields place are filled derive from respectively "/patent innovation registration/patent [1]/title ", "/patent innovation registration/patent [2]/title " ..., "/patent innovation registration/patent [n]/title ".
Described packet attributes, is and divides into groups to the duplicate node in data source according to the Show Styles of format formfile, and wherein, the number of grouping and the number often organize interior repeated rows determine by the Show Styles of structural data and format formfile.Grouping comprises repeated rows definition in grouping definition and grouping.During form templat expansion, first carry out the expansion of dividing into groups according to grouping definition, and then realize the expansion in every group according to repeated rows definition in grouping.
Described grouping definition, for the minimum line number defining the data source of grouping, each grouping comprises, can carry out packet expansion according to the data in structural data during templates-Extension.Such as, by specifying form fields data source property "/expense list/bill [1..m] * b/ bill title " to realize grouping definition, wherein, b represents the minimum line number of each grouping, and m represents packet count; Wherein, m is determined by the number of nodes in structural data "/expense list/bill/", and b determines according to the Show Styles of formfile, is the display line number of each grouping when repetition line number is 1 in group.As above described in example, the display of format formfile carries out grouping form according to " bill ", to expand on form during templates-Extension and generate m group null, often group comprises b null, wherein each grouping definition control location display data derive from respectively " expense list/bill [1]/bill title ", " expense list/bill [2]/bill title " ..., " expense list/bill [m]/bill title ".
Repeated rows definition in described grouping, for defining data source in every group and repeated rows.Such as, by the data source of repeated rows in designated packet be "/expense list/bill [1..m]/fee item [1..n]/expense title " realize grouping in repeated rows definition, wherein, m is packet count, n is for repeating line number in grouping, during form templat expansion, the data line of this grouping is expanded by according to the number of repeated rows in this group, in kth (k ∈ [1..m]) individual grouping, the number of data line depends on the number of "/expense list/bill [k]/fee item " node, during data stuffing, in this grouping, this form fields occupy-place control is expert at downwards, and n is capable continuously, the data of form fields column derive from "/expense list/bill [k]/fee item [1]/expense title " in XML data respectively, "/expense list/bill [k]/fee item [2]/expense title ", "/expense list/bill [k]/fee item [n]/expense title ".
Step 4, display requirement according to format formfile, determine the pretreatment operation information before changing layout files, and be stored in form templat by this operation information, can be used for the special structural data highlighting filling.Support that as used Excel or Word of grand (Macro) is as report tool, the pretreatment operation information before conversion layout files may be defined as grand.
Step 5, Resuming form template.
Secondly, the generation method of the complicated form templat utilizing the embodiment of the present invention to provide, after completing form templat definition, is specifically described by four embodiments a kind of method structural data being converted to format formfile provided by the invention below.
See Fig. 2, for the situation comprising with structural data the computing formula being parameter in form templat, structural data is converted to the concrete steps of format formfile:
Step one, display requirement according to format formfile, by defining the method determination form templat of form templat, wherein, form templat comprises form fields occupy-place control and the formula for calculating structural data; Form fields occupy-place control comprises: the attribute of form fields occupy-place control and the attribute of form fields determined by form fields occupy-place control;
The report tool that step 2, utilization use when defining the form templat determined, reads the form templat determined, resolves the attribute that this form templat obtains the form fields that form fields occupy-place control is determined, and according to the form fields attribute determination form fields definition data obtained;
Step 3, utilize the read-write interface of report tool, structural data to be filled in formfile to obtain report file;
Step 4, according in form templat preset computing formula, the structural data of filling is calculated automatically, determine the result of calculation of the computing formula in report file, and described result of calculation is cured in report file, thus ensure when the Parameters variation of the computing formula in report file, the result of calculation of solidification no longer changes along with the change of the position of result of calculation;
The structural data of filling in step 5, deletion report file, thus avoid the structural data redundancy in the format formfile generated;
Step 6, utilize the interface of report tool and layout files, the report file obtained in step 5 is converted to layout files;
Step 7, add in the layout files that step 6 is converted to by the form fields obtained in step 2 definition data, generate format formfile template, wherein, described format formfile template is the format e-file of band form fields;
Step 8, structural data to be filled in format formfile template that step 7 generates, to determine format formfile.
See Fig. 3, for before conversion layout files, pretreated situation is carried out to form templat, structural data is converted to the concrete steps of format formfile:
Step one, display requirement according to format formfile, by defining the method determination form templat of form templat, wherein, described form templat comprises: the pretreatment operation information before form fields occupy-place control and conversion layout files; Form fields occupy-place control comprises: the attribute of form fields occupy-place control and the attribute of form fields determined by described form fields occupy-place control;
Step 2, the report tool that uses when utilizing the form templat determined, read the form templat determined, resolve the attribute that this form templat obtains the form fields that form fields occupy-place control is determined, and according to the form fields attribute determination form fields definition data obtained;
Step 3, utilize the read-write interface of report tool, structural data to be filled in formfile to obtain report file;
Step 4, change the pretreatment operation information before layout files according to form templat transfer, report file is processed.As report file transfer change the pretreatment operation before layout files for process report tool in predefined grand, then can call SDK (Software Development Kit) (SoftwareDevelopmentKit, SDK) perform conversion layout files before grand;
Step 5, according to the report file obtained in step 4, set-up procedure two determine form fields definition data;
The structural data of filling in the report file obtained in step 6, delete step four, thus the structural data avoiding the format formfile of generation is stacked, redundancy;
Step 7, utilize the interface of report tool and layout files, the report file obtained in step 6 is converted to layout files;
Step 8, add in the layout files that step 7 is converted to by the form fields definition data after adjustment in step 5, generate format formfile template, wherein, described format formfile template is the format e-file of band form fields;
Step 9, structural data to be filled in the format formfile template that obtains in step 8, to determine format formfile.
See Fig. 4, for the situation that the special typesetting of format formfile, repeated rows and grouping etc. require, structural data is converted to the concrete steps of format formfile:
Step one, display requirement according to format formfile, by defining the method determination form templat of form templat, wherein, described form templat comprises: form fields occupy-place control; Form fields occupy-place control comprises: the attribute of form fields occupy-place control and the attribute of form fields determined by described form fields occupy-place control; Wherein, the attribute of form fields occupy-place control comprises special typesetting attribute, repeated rows attribute and packet attributes;
The report tool used when step 2, utilization definition form templat, reads the form templat determined, resolves the attribute that this form templat obtains the form fields that form fields occupy-place control is determined, and according to the form fields attribute determination form fields definition data obtained;
Step 3, according to structural data, expand the repeated rows in the repeated rows in form templat, grouping, grouping and form fields control, generating report forms file, and the form fields definition data that set-up procedure two is determined;
Step 4, utilize the read-write interface of report tool, structural data is filled in report file;
Step 5, according to the special typesetting attribute in form fields occupy-place control property, to fill after report file carry out corresponding space of a whole page adjustment;
The position of form fields in report file in step 6, calculation procedure five after adjustment, adjustment form single domain definition data;
The structural data of filling in the report file in step 7, delete step five after adjustment, thus avoid the structural data redundancy of the format formfile of generation;
Step 8, utilize the interface of report tool and layout files, the report file obtained in step 7 is converted to layout files;
Step 9, add in the layout files be converted in step 8 by the form fields obtained in step 6 definition data, generate format formfile template, wherein, described format formfile template is the format e-file of band form fields;
Step 10, structural data to be filled in format formfile template that step 8 generates, to determine format formfile.
In addition, the present invention is not limited to the method for these three kinds of structural data conversions in the embodiment of the present invention.The Show Styles of format formfile whether along with structural data adjustment, format formfile whether relate to structural data be parameter computing formula, whether format formfile relates to the requirements such as special typesetting, repeated rows and grouping, whether format formfile relates to carries out the pretreatment operation before changing layout files to form templat, all can require carry out combination selection according to the display of format formfile.
Due to the Show Styles of format formfile be whether the computing formula of parameter along with whether structural data adjustment, format formfile relate to structural data, whether format formfile relate to special typesetting, format formfile has fixing processing sequence when whether relating to the combination that the display of carrying out the format formfiles such as the pretreatment operation before changing layout files to form templat requires, therefore complete step structural data being converted to the method for format formfile that provides of the embodiment of the present invention, see Fig. 5, the step of this complete method specifically comprises:
Step one, display requirement according to format formfile, all-purpose financial statements determines form templat, wherein, in form templat structured data position on, add form fields occupy-place control; And determine form fields occupy-place control property, form fields attribute and take structural data as the pretreatment operation information before the computing formula of parameter, conversion layout files; Wherein, the attribute of form fields occupy-place control comprises special typesetting attribute, repeated rows attribute and packet attributes; Wherein, comprise could edit properties for form fields attribute;
The report tool that step 2, utilization use when defining the form templat determined, utilize the report tool used during definition form templat, the form templat determined in read step one, resolve the attribute that this form templat obtains the form fields that form fields occupy-place control is determined, and according to the form fields attribute determination form fields definition data obtained;
Step 3, according to structural data, expand the repeated rows in the repeated rows in form templat, grouping, grouping and form fields control, generating report forms file, and the form fields definition data that set-up procedure two is determined;
Step 4, utilize the read-write interface of form templat, structural data is filled in report file;
Step 5, according in form templat preset computing formula, determine the result of calculation of the computing formula in report file, and described result of calculation be cured in the report file obtained in step 4;
Step 6, according to the special typesetting attribute in described form fields attribute, the report file obtained in set-up procedure five;
Step 7, according in described form templat preset conversion layout files before pretreatment operation information, the report file obtained in step 6 is processed;
Step 8, position according to form fields in the report file obtained in step 7, the form fields obtained in set-up procedure three definition data;
The structural data of filling in the report file in step 9, delete step seven after adjustment;
Step 10, utilize the interface of report tool and layout files, the report file obtained in step 9 is converted to layout files;
Step 11, adding adjusting the form fields definition data obtained in step 8 the layout files obtained in step 10 to, generating format formfile template;
Step 12, according in form fields definition data could edit properties, the form fields in the format formfile template that determining step 11 obtains could be edited;
Step 13, structural data to be filled in format formfile template that step 11 obtains, to determine format formfile.
See Fig. 6, a kind of system structural data being converted to format formfile that the embodiment of the present invention provides, comprising:
Determine form templat unit 601, for the display requirement according to format formfile, all-purpose financial statements determines form templat;
Determine form fields definition data cell 602, for resolving described form templat, and according to analysis result determination form fields definition data;
Generate layout files unit 603, for according to described form templat and structural data, be converted to layout files;
Generate format form templat unit 604, for defining data by described form fields, and described layout files, generate format formfile template;
Interstitital texture data cell 605, for being filled into by structural data in described format formfile template, determines format formfile.
Preferably, described form templat comprises: form fields occupy-place control; Wherein, described form fields occupy-place control comprises: form fields occupy-place control property and form fields attribute, and wherein, described form fields attribute comprises: field type attribute, data source property and form fields position attribution;
Described determine form fields definition data cell 602, specifically for:
Resolve the list occupy-place control in described form templat, and according to analysis result determination form fields definition data, wherein, described form fields definition data comprise: described form fields attribute.
Preferably, also comprise in described form templat: described structural data is as the computing formula of parameter;
Described generation layout files unit 603, specifically for:
According to described form templat, described structural data is filled in described form templat, obtains the first report file;
According to described computing formula, determine the result of calculation of the computing formula in described first report file, and described result of calculation is cured in described first report file, obtain Secondary Report list file;
Delete the structural data of filling in described Secondary Report list file, obtain the 3rd report file;
By changing described 3rd report file, obtain layout files.
Preferably, also comprise in described form templat: the pretreatment operation information before conversion layout files;
Described generation layout files unit 603, specifically for:
According to described form templat, described structural data is filled in described form templat, obtains the first report file;
According to the pretreatment operation information before described conversion layout files, described first report file is processed, obtains Secondary Report list file;
According to Secondary Report list file, adjust described form fields definition data, obtain the second form fields definition data;
Delete the structural data of filling in described Secondary Report list file, obtain the 3rd report file;
By changing described 3rd report file, obtain layout files;
Described generation format form templat unit 604, specifically for:
By described second form fields definition data, and described layout files, generate format formfile template.
Preferably, described form fields occupy-place control property comprises: special typesetting attribute, repeated rows attribute and packet attributes;
Described generation layout files unit 603, specifically for:
According to described structural data, adjust described form templat, obtain the first report file, and adjust described form fields definition data, obtain the second form fields definition data;
Described structural data is filled in described first report file, obtains Secondary Report list file;
According to the special typesetting attribute in described form fields attribute, adjust described Secondary Report list file, obtain the 3rd report file;
According to described 3rd report file, adjust described second form fields definition data, obtain the 3rd form fields definition data;
Delete the structural data of filling in described 3rd report file, obtain the 4th report file;
By changing described 4th report file, obtain layout files;
Described generation format form templat unit 604, specifically for:
By described 3rd form fields definition data, and described layout files, generate format formfile template.
Preferably, described form fields attribute also comprises: could edit properties;
Generate format form templat unit 604 according to described form fields definition data and described layout files, before generating format formfile template, also for:
According in described form fields definition data could edit properties, determine that the form fields in described format formfile template could be edited.
Preferably, determine described in the embodiment of the present invention form templat unit 601, described determine form fields definition data cell 602, described generation layout files unit 603, described generation format form templat unit 604, described interstitital texture data cell 605, all can be realized by processor.
In sum, the invention provides method and system structural data being transferred to format formfile, form templat is generated based on report tool, according to the display requirement of format formfile to structural data, add form fields definition data, generate form templat, when structural data being converted to format formfile, interstitital texture data on form templat, generating report forms file, and according to the display requirement to structural data of final format formfile, report file completes row expand, grouping, repeated rows, formulae discovery, the complex operations such as special typesetting, then the report file after process is converted to layout files, layout files is added form fields definition data genaration format formfile template, then structural data is filled in format formfile template, final generation format formfile, achieve, on same technology platform, structural data is converted to format formfile, meet the file transform of complex data and simple data, and the format formfile after conversion remains the characteristic of structural data, be conducive to extraction and the recycling of structural data, and possess list to fill in, the interaction capabilities such as to stamp an offical seal, and the format formfile template generated in advance can be utilized due to the present invention, thus ensure that the conversion efficiency of simple data and prior art are in same level.
Those skilled in the art should understand, embodiments of the invention can be provided as method, system or computer program.Therefore, the present invention can adopt the form of complete hardware embodiment, completely software implementation or the embodiment in conjunction with software and hardware aspect.And the present invention can adopt in one or more form wherein including the upper computer program implemented of computer-usable storage medium (including but not limited to magnetic disk memory and optical memory etc.) of computer usable program code.
The present invention describes with reference to according to the process flow diagram of the method for the embodiment of the present invention, equipment (system) and computer program and/or block scheme.Should understand can by the combination of the flow process in each flow process in computer program instructions realization flow figure and/or block scheme and/or square frame and process flow diagram and/or block scheme and/or square frame.These computer program instructions can being provided to the processor of multi-purpose computer, special purpose computer, Embedded Processor or other programmable data processing device to produce a machine, making the instruction performed by the processor of computing machine or other programmable data processing device produce device for realizing the function of specifying in process flow diagram flow process or multiple flow process and/or block scheme square frame or multiple square frame.
These computer program instructions also can be stored in can in the computer-readable memory that works in a specific way of vectoring computer or other programmable data processing device, the instruction making to be stored in this computer-readable memory produces the manufacture comprising command device, and this command device realizes the function of specifying in process flow diagram flow process or multiple flow process and/or block scheme square frame or multiple square frame.
These computer program instructions also can be loaded in computing machine or other programmable data processing device, make on computing machine or other programmable devices, to perform sequence of operations step to produce computer implemented process, thus the instruction performed on computing machine or other programmable devices is provided for the step realizing the function of specifying in process flow diagram flow process or multiple flow process and/or block scheme square frame or multiple square frame.
Obviously, those skilled in the art can carry out various change and modification to the present invention and not depart from the spirit and scope of the present invention.Like this, if these amendments of the present invention and modification belong within the scope of the claims in the present invention and equivalent technologies thereof, then the present invention is also intended to comprise these change and modification.
Claims (12)
1. structural data is converted to a method for format formfile, it is characterized in that, the method comprises:
According to the display requirement of format formfile, utilize report tool determination form templat;
Resolve described form templat, and according to analysis result determination form fields definition data;
Utilize described form templat and structural data, generate layout files;
By described form fields definition data, and described layout files, generate format formfile template;
Structural data is filled in described format formfile template, determines format formfile.
2. method according to claim 1, is characterized in that, described form templat comprises: form fields occupy-place control; Wherein, described form fields occupy-place control comprises: form fields attribute, and described form fields attribute is the attribute of the form fields determined by described form fields occupy-place control;
Resolve described form templat, and according to analysis result determination form fields definition data, comprising:
Resolve the list occupy-place control in described form templat, and according to analysis result determination form fields definition data, wherein, described form fields definition data comprise: described form fields attribute.
3. method according to claim 2, is characterized in that, also comprises in described form templat: for the formula calculated structural data;
Utilize described form templat and structural data, generate layout files, comprising:
Structural data is filled in described form templat, obtains the first report file;
By described formula, obtain the result of calculation of described structural data, and described result of calculation is cured in described first report file, obtain Secondary Report list file;
Delete the structural data of filling in described Secondary Report list file, obtain the 3rd report file;
Utilize described report tool to change described 3rd report file, obtain layout files.
4. method according to claim 2, is characterized in that, also comprises in described form templat: generate the pretreatment operation information before layout files;
Utilize described form templat and structural data, generate layout files, comprising:
Described structural data is filled in described form templat, obtains the first report file;
According to described pretreatment operation information, utilize described report tool to process described first report file, obtain Secondary Report list file;
Delete the structural data of filling in described Secondary Report list file, obtain the 3rd report file;
Utilize described report tool to change described 3rd report file, obtain layout files;
By described form fields definition data, and described layout files, generate format formfile template, comprising:
According to Secondary Report list file, adjust described form fields definition data, obtain the second form fields definition data;
By described second form fields definition data, and described layout files, generate format formfile template.
5. method according to claim 2, is characterized in that, described form fields occupy-place control also comprises form fields occupy-place control property, and described form fields occupy-place control property comprises: typesetting attribute, repeated rows attribute and packet attributes;
Utilize described form templat and structural data, generate layout files, comprising:
According to described structural data, adjust described form templat, obtain the first report file;
Described structural data is filled in described first report file, obtains Secondary Report list file;
According to the typesetting attribute in described form fields occupy-place control property, adjust described Secondary Report list file, obtain the 3rd report file;
Delete the structural data of filling in described 3rd report file, obtain the 4th report file;
Utilize described report tool to change described 4th report file, obtain layout files;
By described form fields definition data, and described layout files, generate format formfile template, comprising:
According to described structural data, adjust described form fields definition data, obtain the second form fields definition data;
According to described 3rd report file, adjust described second form fields definition data, obtain the 3rd form fields definition data;
By described 3rd form fields definition data, and described layout files, generate format formfile template.
6. method according to claim 2, is characterized in that, described form fields attribute comprises: could edit properties;
Utilize described form templat and structural data, after generating layout files, define data by described form fields, and described layout files, before generating format formfile template, the method also comprises:
According to described could edit properties, determine that the form fields in the format formfile template needing to generate could be edited.
7. structural data is converted to a system for format formfile, it is characterized in that, this system comprises:
Determine form templat unit, for the display requirement according to format formfile, utilize report tool determination form templat;
Determine form fields definition data cell, for resolving described form templat, and according to analysis result determination form fields definition data;
Generating layout files unit, for utilizing described form templat and structural data, generating layout files;
Generate format form templat unit, for defining data by described form fields, and described layout files, generate format formfile template;
Interstitital texture data cell, for being filled into by structural data in described format formfile template, determines format formfile.
8. system according to claim 7, is characterized in that, described form templat comprises: form fields occupy-place control; Wherein, described form fields occupy-place control comprises: form fields attribute, and described form fields attribute is the attribute of the form fields determined by described form fields occupy-place control;
Described determine form fields definition data cell, specifically for:
Resolve the list occupy-place control in described form templat, and according to analysis result determination form fields definition data, wherein, described form fields definition data comprise: described form fields attribute.
9. system according to claim 8, is characterized in that, also comprises in described form templat: for the formula calculated structural data;
Described generation layout files unit, specifically for:
According to described form templat, described structural data is filled in described form templat, obtains the first report file;
By described formula, obtain the result of calculation of described structural data, and described result of calculation is cured in described first report file, obtain Secondary Report list file;
Delete the structural data of filling in described Secondary Report list file, obtain the 3rd report file;
Utilize described report tool to change described 3rd report file, obtain layout files.
10. system according to claim 8, is characterized in that, also comprises in described form templat: generate the pretreatment operation information before layout files;
Described generation layout files unit, specifically for:
Described structural data is filled in described form templat, obtains the first report file;
According to described pretreatment operation information, utilize described report tool to process described first report file, obtain Secondary Report list file;
Delete the structural data of filling in described Secondary Report list file, obtain the 3rd report file;
Utilizing described report tool by changing described 3rd report file, obtaining layout files;
Described generation format form templat unit, specifically for:
According to Secondary Report list file, adjust described form fields definition data, obtain the second form fields definition data;
By described second form fields definition data, and described layout files, generate format formfile template.
11. systems according to claim 8, is characterized in that, described form fields occupy-place control also comprises form fields occupy-place control property, and described form fields occupy-place control property comprises: typesetting attribute, repeated rows attribute and packet attributes;
Described generation layout files unit, specifically for:
According to described structural data, adjust described form templat, obtain the first report file;
Described structural data is filled in described first report file, obtains Secondary Report list file;
According to the typesetting attribute in described form fields occupy-place control property, adjust described Secondary Report list file, obtain the 3rd report file;
Delete the structural data of filling in described 3rd report file, obtain the 4th report file;
Utilize described report tool to change described 4th report file, obtain layout files;
Described generation format form templat unit, specifically for:
According to described structural data, adjust described form fields definition data, obtain the second form fields definition data;
According to described 3rd report file, adjust described second form fields definition data, obtain the 3rd form fields definition data;
By described 3rd form fields definition data, and described layout files, generate format formfile template.
12. methods according to claim 8, is characterized in that, described form fields attribute comprises: could edit properties;
Generate format form templat unit by described form fields definition data and described layout files, before generation format formfile template, also for:
According to described could edit properties, determine that the form fields in the format formfile template needing to generate could be edited.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410475294.3A CN105488052B (en) | 2014-09-17 | 2014-09-17 | Structural data is switched to the method and system of format formfile |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410475294.3A CN105488052B (en) | 2014-09-17 | 2014-09-17 | Structural data is switched to the method and system of format formfile |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105488052A true CN105488052A (en) | 2016-04-13 |
| CN105488052B CN105488052B (en) | 2019-09-24 |
Family
ID=55675033
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410475294.3A Active CN105488052B (en) | 2014-09-17 | 2014-09-17 | Structural data is switched to the method and system of format formfile |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105488052B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105701073A (en) * | 2015-12-31 | 2016-06-22 | 北京中科江南信息技术股份有限公司 | Layout file generation method and device |
| CN107451103A (en) * | 2016-03-31 | 2017-12-08 | 阿里巴巴集团控股有限公司 | Template for displaying and amending method and equipment |
| CN108460008A (en) * | 2018-03-20 | 2018-08-28 | 深圳中兴网信科技有限公司 | Document generation method, system, computer equipment and readable storage medium storing program for executing |
| WO2021253979A1 (en) * | 2020-06-16 | 2021-12-23 | 北京奎牛科技有限公司 | Method and apparatus for processing electronic form files capable of recording log data |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101676910A (en) * | 2008-09-19 | 2010-03-24 | 北京大学 | A page generation method facing to Web application system |
| CN102135990A (en) * | 2011-03-11 | 2011-07-27 | 北京神舟航天软件技术有限公司 | Java server page (JSP) template-based intelligent table system capable of being defined freely and generating method |
| CN102360290A (en) * | 2011-09-29 | 2012-02-22 | 用友软件股份有限公司 | Form building device and form building method |
| US8381095B1 (en) * | 2011-11-07 | 2013-02-19 | International Business Machines Corporation | Automated document revision markup and change control |
-
2014
- 2014-09-17 CN CN201410475294.3A patent/CN105488052B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101676910A (en) * | 2008-09-19 | 2010-03-24 | 北京大学 | A page generation method facing to Web application system |
| CN102135990A (en) * | 2011-03-11 | 2011-07-27 | 北京神舟航天软件技术有限公司 | Java server page (JSP) template-based intelligent table system capable of being defined freely and generating method |
| CN102360290A (en) * | 2011-09-29 | 2012-02-22 | 用友软件股份有限公司 | Form building device and form building method |
| US8381095B1 (en) * | 2011-11-07 | 2013-02-19 | International Business Machines Corporation | Automated document revision markup and change control |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105701073A (en) * | 2015-12-31 | 2016-06-22 | 北京中科江南信息技术股份有限公司 | Layout file generation method and device |
| CN107451103A (en) * | 2016-03-31 | 2017-12-08 | 阿里巴巴集团控股有限公司 | Template for displaying and amending method and equipment |
| CN107451103B (en) * | 2016-03-31 | 2022-04-22 | 阿里巴巴集团控股有限公司 | Template display and modification method and device |
| CN108460008A (en) * | 2018-03-20 | 2018-08-28 | 深圳中兴网信科技有限公司 | Document generation method, system, computer equipment and readable storage medium storing program for executing |
| CN108460008B (en) * | 2018-03-20 | 2022-05-06 | 深圳中兴网信科技有限公司 | Bill generation method, system, computer equipment and readable storage medium |
| WO2021253979A1 (en) * | 2020-06-16 | 2021-12-23 | 北京奎牛科技有限公司 | Method and apparatus for processing electronic form files capable of recording log data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105488052B (en) | 2019-09-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101676910B (en) | A page generation method facing to Web application system | |
| CN110096689A (en) | Template type legal documents information fill method and device | |
| CN102663103B (en) | Configurable method for automatically generating database and accessing data | |
| CN102360291B (en) | Service-oriented business rule design method based on business rule engine | |
| CN103309904B (en) | A kind of method and device generating data warehouse ETL code | |
| CN105447253B (en) | A kind of integrated approach of three-dimensional process data | |
| CN103135976A (en) | Code automatic generation method and device | |
| CN104035754A (en) | XML (Extensible Markup Language)-based custom code generation method and generator | |
| CN103092890A (en) | System and method for automatic generation and sending of reports | |
| CN102360290A (en) | Form building device and form building method | |
| CN1454357A (en) | XML-robot | |
| CN103049251B (en) | A kind of data base persistence layer device and database operation method | |
| CN105488052A (en) | Method and system for converting structural data into layout form file | |
| CN102215126B (en) | The generation method and device of performance report | |
| CN102968307A (en) | Java-based web development middleware | |
| CN104484419A (en) | Test case document conversion system and test case document conversion method | |
| CN101146281A (en) | A GUI creation model for mobile terminal | |
| CN103823793A (en) | Realizing method for dynamic report based on Excel template | |
| JP2008234370A (en) | Document processor and document processing method | |
| CN107392998A (en) | A kind of process design method and system based on threedimensional model | |
| CN109783886A (en) | Emerging system and method for GIM model and IFC model | |
| CN101350028A (en) | XML data XPath search method based on SQL structured search language | |
| CN102857949A (en) | Method and device for planning data consistency guarantees | |
| CN103425692A (en) | Data exporting method and data exporting device | |
| CN102929853A (en) | DCS (Data Communication System) project data generating system and method based on Excel sheet association |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | 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 |