CN111444691B - Method for rapidly processing Word form data import form - Google Patents
Method for rapidly processing Word form data import form Download PDFInfo
- Publication number
- CN111444691B CN111444691B CN202010207422.1A CN202010207422A CN111444691B CN 111444691 B CN111444691 B CN 111444691B CN 202010207422 A CN202010207422 A CN 202010207422A CN 111444691 B CN111444691 B CN 111444691B
- Authority
- CN
- China
- Prior art keywords
- data
- allocation
- information
- word
- row
- 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
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application provides a method for rapidly processing a Word form data import form, which provides a method for realizing the Word data import form and aims at solving the problem of importing the form from a Word. The method firstly identifies Word form data, sets corresponding rules of form and database fields, and then places the data into form fields according to the corresponding rules, and comprises the following steps: s1, defining a form and related field information, wherein the form cannot be changed due to the increase of the form, and the form name and the field information of the form are stored in a data form configuration form; s2, defining Word form data information, and storing the Word form information in a Word form configuration table; s3, defining the association information of the data form and the Word form. The workload of operators is reduced, and the accuracy of data input is improved.
Description
Technical Field
The application relates to an implementation method for rapidly processing a Word import form, which is applied to conversion of an information system from Word data to a database system.
Background
With the popularity of information system applications, much user data needs to be imported into the background database. The client will use Word to fill in the data. If the information is imported into the information system, the user is often required to enter the information manually, so that the operation is time-consuming and labor-consuming, and is easy to make mistakes, and particularly when the number of words is relatively large, the workload is huge.
The application provides a method for realizing a Word data importing form, which aims to solve the problem of importing forms from words.
Disclosure of Invention
The technical task of the application is to solve the defects of the prior art and provide a method for rapidly processing Word form data import forms.
The technical scheme adopted for solving the technical problems is as follows:
a method for fast processing Word form data leading-in form includes such steps as recognizing Word form data, setting up the correspondent rule of form and database field, and putting data in form correspondent field according to correspondent rule, including the following steps:
s1, defining a form and related field information, wherein the form cannot be changed due to the increase of the form, and the form name and the field information of the form are stored in a data form configuration form;
s2, defining Word form data information, and storing the Word form information in a Word form configuration table;
s3, defining the association information of the data form and the Word form.
Optionally, the data form configuration in step S1 specifically includes:
s1.1, one configuration table data stores one row of data in the data;
s1.2, each field information of the configuration table field stores one row of data in the data, and the field type needs to be configured;
s1.3, the configuration field lines are increased and decreased according to the requirement.
Optionally, in step S2, the Word form configuration specifically includes:
s2.1, a Word table stores one row of data in the data;
s2.2, storing each field information of the configuration table field in data into one row of data;
s2.3, the configuration field lines are increased and decreased according to the requirement.
Optionally, the configuration of the association information in step S3 specifically includes:
one relationship configuration information is stored in one line of data.
Optionally, the method further comprises the following steps:
s4, reading data form data configuration information and obtaining field types;
s5, reading corresponding information of the form and the Word form relation.
Optionally, in step S5,
s5.1, organizing the data in a character string format, and converting according to the type of the configuration field;
s5.2, some characters cannot be stored in the database and need to be replaced before being imported.
Optionally, the rules include an intra-period allocation rule.
Optionally, the period allocation rule is executed as follows:
firstly, during reading, a rule information main table row A101 is shared, and whether a rule A102 is customized by the sharing type is read;
if A102 judges yes, reading data information of the allocation rows, and reading a proportion value A103 of each allocation row;
if the judgment of A102 is negative, according to the fixed rule value, inquiring the corresponding index value A104 according to the cost source pointed by the rule, accumulating the index value A105, and simultaneously according to each apportionment row, calculating the corresponding duty ratio A113;
then, according to the ratio value in A103 and A113, multiplying the ratio value by the cost number of the allocation item to obtain the actual cost A114 during the period of the allocation item;
finally, the period allocation result information is stored in the period allocation result table a115.
Optionally, the intra-period allocation flow is executed as follows:
firstly, a rule information main table row A201 is allocated in a reading period, and whether a rule A202 is customized by an allocation type is read;
if A202 judges yes, reading data information of the allocation rows, and reading a proportion value A203 of each allocation row;
if the judgment of A202 is negative, according to the fixed rule value, inquiring the corresponding index value A204 according to the cost source pointed by the rule, accumulating the index value A205, and simultaneously according to each apportionment row, calculating the corresponding duty ratio A206;
then, the period allocation rule table a207 is read, and whether the period allocation exists in the allocation item is judged;
if the judgment of A207 is yes, reading the cost numbers of all the allocation items in the period allocation result table, accumulating, and multiplying the accumulated number with the own cost value of the allocation item and the proportion of A206 to obtain an allocation number A208;
if the A202 is judged to be negative, directly multiplying the self cost value of the allocation item by the proportion of the A206 to obtain an allocation number A209;
finally, the apportionment numbers calculated by A208 and A209 are stored in the intra-period apportionment result table.
Optionally, the step in step S3 is:
s3.1 setting local File Source Attribute
The Word is provided with a plurality of tables, and the number of the tables to be imported into the Word needs to be determined;
s3.2, setting table attributes, including:
setting column information of a tab (sheet) of an Excel data source, including: column number, title name;
compared with the prior art, the method for rapidly processing the Word form data import form has the beneficial effects that:
the workload of operators is reduced, and the accuracy of data input is improved.
Drawings
In order to more clearly describe the working principle of a method for rapidly processing Word form data import forms according to the present application, a schematic diagram will be further described below.
FIG. 1 is a schematic diagram of a period allocation flow arrangement execution of the present application;
FIG. 2 is a schematic diagram of the intra-period distributed flow sort execution of the present application.
Detailed Description
The following description of the embodiments of the present application will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
The application relates to a method for rapidly processing Word form data to import form, which comprises the following steps of firstly identifying Word form data, setting corresponding rules of form and database fields, and then putting the data into form fields according to the corresponding rules:
s1, defining a form and related field information, wherein the form cannot be changed due to the increase of the form, and the form name and the field information of the form are stored in a data form configuration form;
s2, defining Word form data information, and storing the Word form information in a Word form configuration table;
s3, defining the association information of the data form and the Word form.
Optionally, the data form configuration in step S1 specifically includes:
s1.1, one configuration table data stores one row of data in the data;
s1.2, each field information of the configuration table field stores one row of data in the data, and the field type needs to be configured;
s1.3, the configuration field lines are increased and decreased according to the requirement.
Optionally, in step S2, the Word form configuration specifically includes:
s2.1, a Word table stores one row of data in the data;
s2.2, storing each field information of the configuration table field in data into one row of data;
s2.3, the configuration field lines are increased and decreased according to the requirement.
Optionally, the configuration of the association information in step S3 specifically includes:
one relationship configuration information is stored in one line of data.
Optionally, the method further comprises the following steps:
s4, reading data form data configuration information and obtaining field types;
s5, reading corresponding information of the form and the Word form relation.
Optionally, in step S5,
s5.1, organizing the data in a character string format, and converting according to the type of the configuration field;
s5.2, some characters cannot be stored in the database and need to be replaced before being imported.
Optionally, the rules include an intra-period allocation rule.
In connection with fig. 1, the period allocation rule is executed as follows:
firstly, during reading, a rule information main table row A101 is shared, and whether a rule A102 is customized by the sharing type is read;
if A102 judges yes, reading data information of the allocation rows, and reading a proportion value A103 of each allocation row;
if the judgment of A102 is negative, according to the fixed rule value, inquiring the corresponding index value A104 according to the cost source pointed by the rule, accumulating the index value A105, and simultaneously according to each apportionment row, calculating the corresponding duty ratio A113;
then, according to the ratio value in A103 and A113, multiplying the ratio value by the cost number of the allocation item to obtain the actual cost A114 during the period of the allocation item;
finally, the period allocation result information is stored in the period allocation result table a115.
With reference to fig. 2, the intra-period allocation flow is implemented as follows:
firstly, a rule information main table row A201 is allocated in a reading period, and whether a rule A202 is customized by an allocation type is read;
if A202 judges yes, reading data information of the allocation rows, and reading a proportion value A203 of each allocation row;
if the judgment of A202 is negative, according to the fixed rule value, inquiring the corresponding index value A204 according to the cost source pointed by the rule, accumulating the index value A205, and simultaneously according to each apportionment row, calculating the corresponding duty ratio A206;
then, the period allocation rule table a207 is read, and whether the period allocation exists in the allocation item is judged;
if the judgment of A207 is yes, reading the cost numbers of all the allocation items in the period allocation result table, accumulating, and multiplying the accumulated number with the own cost value of the allocation item and the proportion of A206 to obtain an allocation number A208;
if the A202 is judged to be negative, directly multiplying the self cost value of the allocation item by the proportion of the A206 to obtain an allocation number A209;
finally, the apportionment numbers calculated by A208 and A209 are stored in the intra-period apportionment result table.
Optionally, the step in step S3 is:
s3.1 setting local File Source Attribute
The Word is provided with a plurality of tables, and the number of the tables to be imported into the Word needs to be determined;
s3.2, setting table attributes, including:
setting column information of a tab (sheet) of an Excel data source, including: column number, title name;
while preferred embodiments of the present application have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. It is therefore intended that the following claims be interpreted as including the preferred embodiments and all such alterations and modifications as fall within the scope of the application.
It will be apparent to those skilled in the art that various modifications and variations can be made to the present application without departing from the spirit or scope of the application. Thus, it is intended that the present application also include such modifications and alterations insofar as they come within the scope of the appended claims or the equivalents thereof.
Other than the technical features described in the specification, all are known to those skilled in the art.
Claims (5)
1. A method for rapidly processing Word form data import forms is characterized in that the method firstly identifies Word form data, sets corresponding rules of form and database fields, and then places the data into the form corresponding fields according to the corresponding rules, and comprises the following steps:
s1, defining a form and related field information, wherein the form cannot be changed due to the increase of the form, and the form name and the field information of the form are stored in a data form configuration form;
s2, defining Word form data information, and storing the Word form information in a Word form configuration table;
s3, defining the association information of the data form and the Word form;
the data form configuration in step S1 specifically includes:
s1.1, one configuration table data stores one row of data in the data;
s1.2, each field information of the configuration table field stores one row of data in the data, and the field type needs to be configured;
s1.3, configuring field rows to be increased or decreased according to requirements;
in step S2, the Word form configuration specifically includes:
s2.1, a Word table stores one row of data in the data;
s2.2, storing each field information of the configuration table field in data into one row of data;
s2.3, configuring field rows to be increased or decreased according to requirements;
the configuration of the associated information in step S3 is specifically as follows:
one relationship configuration information is stored in one row of data;
the method also comprises the following steps:
s4, reading data form data configuration information and obtaining field types;
s5, reading corresponding information of the relation of the forms and the Word forms;
in the step S5 of the process,
s5.1, organizing the data in a character string format, and converting according to the type of the configuration field;
s5.2, some characters cannot be stored in the database and need to be replaced before being imported.
2. The method for quickly processing Word form data import forms according to claim 1, wherein the rules include period allocation rules and period allocation rules.
3. The method for quickly processing Word form data import forms according to claim 2, wherein the period allocation rule is executed as follows:
firstly, during reading, a rule information main table row A101 is shared, and whether a rule A102 is customized by the sharing type is read;
if A102 judges yes, reading data information of the allocation rows, and reading a proportion value A103 of each allocation row;
if the judgment of A102 is negative, according to the fixed rule value, inquiring the corresponding index value A104 according to the cost source pointed by the rule, accumulating the index value A105, and simultaneously according to each apportionment row, calculating the corresponding duty ratio A113;
then, according to the ratio value in A103 and A113, multiplying the ratio value by the cost number of the allocation item to obtain the actual cost A114 during the period of the allocation item;
finally, the period allocation result information is stored in the period allocation result table a115.
4. The method for rapidly processing Word form data import forms according to claim 3, wherein the intra-period allocation process is performed as follows:
firstly, a rule information main table row A201 is allocated in a reading period, and whether a rule A202 is customized by an allocation type is read;
if A202 judges yes, reading data information of the allocation rows, and reading a proportion value A203 of each allocation row;
if the judgment of A202 is negative, according to the fixed rule value, inquiring the corresponding index value A204 according to the cost source pointed by the rule, accumulating the index value A205, and simultaneously according to each apportionment row, calculating the corresponding duty ratio A206;
then, the period allocation rule table a207 is read, and whether the period allocation exists in the allocation item is judged;
if the judgment of A207 is yes, reading the cost numbers of all the allocation items in the period allocation result table, accumulating, and multiplying the accumulated number with the own cost value of the allocation item and the proportion of A206 to obtain an allocation number A208;
if the A202 is judged to be negative, directly multiplying the self cost value of the allocation item by the proportion of the A206 to obtain an allocation number A209;
finally, the apportionment numbers calculated by A208 and A209 are stored in the intra-period apportionment result table.
5. The method for rapidly processing Word form data import forms according to claim 4, wherein the step S3 comprises the steps of:
s3.1 setting local File Source Attribute
The Word is provided with a plurality of tables, and the number of the tables to be imported into the Word needs to be determined;
s3.2, setting table attributes, including:
setting column information of a tab (sheet) of an Excel data source, including: column number, title name;
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010207422.1A CN111444691B (en) | 2020-03-23 | 2020-03-23 | Method for rapidly processing Word form data import form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010207422.1A CN111444691B (en) | 2020-03-23 | 2020-03-23 | Method for rapidly processing Word form data import form |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111444691A CN111444691A (en) | 2020-07-24 |
| CN111444691B true CN111444691B (en) | 2023-10-13 |
Family
ID=71629402
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010207422.1A Active CN111444691B (en) | 2020-03-23 | 2020-03-23 | Method for rapidly processing Word form data import form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111444691B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106528821A (en) * | 2016-11-16 | 2017-03-22 | 济南浪潮高新科技投资发展有限公司 | Method for importing change column data into database |
| CN109189835A (en) * | 2018-08-21 | 2019-01-11 | 北京京东尚科信息技术有限公司 | The method and apparatus of the wide table of data are generated in real time |
| WO2019179021A1 (en) * | 2018-03-22 | 2019-09-26 | 平安科技（深圳）有限公司 | Method and apparatus for importing excel data into database, and computer device and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10642838B2 (en) * | 2017-09-28 | 2020-05-05 | Sap Se | Real-time or event-based analysis of process data |
-
2020
- 2020-03-23 CN CN202010207422.1A patent/CN111444691B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106528821A (en) * | 2016-11-16 | 2017-03-22 | 济南浪潮高新科技投资发展有限公司 | Method for importing change column data into database |
| WO2019179021A1 (en) * | 2018-03-22 | 2019-09-26 | 平安科技（深圳）有限公司 | Method and apparatus for importing excel data into database, and computer device and storage medium |
| CN109189835A (en) * | 2018-08-21 | 2019-01-11 | 北京京东尚科信息技术有限公司 | The method and apparatus of the wide table of data are generated in real time |
Non-Patent Citations (1)
| Title |
|---|
| 游樱 ; .电子表格在财务信息整理中的应用及控制.烟台职业学院学报.2008,(03),全文. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111444691A (en) | 2020-07-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104572783A (en) | Webpage click condition displaying method and device | |
| US10963144B2 (en) | Graphically organizing content in a user interface to a software application | |
| CN106844324B (en) | Method for exporting variable column data into Excel format | |
| CN101446962A (en) | Data conversion method, device thereof and data processing system | |
| CN107291745B (en) | Data index management method and device | |
| CN107909068A (en) | A kind of big data image curve reverse resolution method and system | |
| CN112115145A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN113239106A (en) | Excel file export method and device, electronic equipment and storage medium | |
| CN106855862A (en) | A kind of quick comparative approach and device | |
| CN106649210A (en) | Data conversion method and device | |
| CN106599291A (en) | Method and device for grouping data | |
| CN111444691B (en) | Method for rapidly processing Word form data import form | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| CN116757886B (en) | Data analysis method and analysis device | |
| CN111291543B (en) | Data display method and device, storage medium and processor | |
| CN111858617A (en) | User searching method and device, computer readable storage medium and electronic equipment | |
| CN111523174A (en) | Automatic drawing method, system, equipment and storage medium for holes in ship drawing | |
| CN110826845A (en) | Multidimensional combination cost allocation device and method | |
| CN105930323A (en) | File generating method and apparatus | |
| CN115905397A (en) | Visual display method, device, system and medium for business data | |
| CN106021349A (en) | A foreign exchange data submitting method and device | |
| CN112818223B (en) | User portrait query processing method, device, equipment, program product and medium | |
| CN104809143A (en) | Method and device for implanting table information into information base | |
| CN107301239A (en) | A kind of database converter and conversion method | |
| CN111858610A (en) | Data line number distribution method and device, storage medium and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230907 Address after: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong Applicant after: Inspur Genersoft Co.,Ltd. Address before: 250100 No. 2877 Kehang Road, Sun Village Town, Jinan High-tech District, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |