CN118152336A - Heterogeneous system file conversion method and device, medium and equipment - Google Patents
Heterogeneous system file conversion method and device, medium and equipment Download PDFInfo
- Publication number
- CN118152336A CN118152336A CN202410187599.8A CN202410187599A CN118152336A CN 118152336 A CN118152336 A CN 118152336A CN 202410187599 A CN202410187599 A CN 202410187599A CN 118152336 A CN118152336 A CN 118152336A
- Authority
- CN
- China
- Prior art keywords
- source
- template
- worksheet
- target
- 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.)
- Pending
Links
- 238000006243 chemical reaction Methods 0.000 title claims abstract description 138
- 238000000034 method Methods 0.000 title claims abstract description 41
- 230000006870 function Effects 0.000 claims description 22
- 238000004364 calculation method Methods 0.000 claims description 4
- 238000012216 screening Methods 0.000 claims description 3
- 238000004590 computer program Methods 0.000 claims description 2
- 230000009466 transformation Effects 0.000 claims 1
- 230000005540 biological transmission Effects 0.000 abstract description 5
- 238000007726 management method Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 5
- 230000009286 beneficial effect Effects 0.000 description 3
- 230000002776 aggregation Effects 0.000 description 2
- 238000004220 aggregation Methods 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 230000008676 import Effects 0.000 description 2
- 238000002955 isolation Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000009472 formulation Methods 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/11—File system administration, e.g. details of archiving or snapshots
- G06F16/116—Details of conversion of file system types or formats
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/13—File access structures, e.g. distributed indices
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- 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
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a heterogeneous system file conversion method and device, a medium and equipment. The method comprises the following steps: acquiring a template file uploaded by a user, wherein the template file comprises a source template and a target template; identifying the worksheet information of each worksheet in the template file and the data structure in each worksheet, and respectively storing the worksheet information and the data structure in different dictionary tables; providing a rule making page to enable making of conversion rules between the worksheets in the source template and the worksheets in the target template; reminding a user to upload a source file with the same data structure as the source template; and converting the source file into a target file with the same data structure as the target template according to the conversion rule. The embodiment of the invention solves the problems of different Excel formats and different data sources in cross-network transmission of different heterogeneous systems.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method, an apparatus, a medium, and a device for converting heterogeneous system files.
Background
Under the limitation of a plurality of physical isolation environments, each data sub-center is isolated to form an information island, different systems are distributed, data are scattered, and a group company is difficult to know the operation condition of each unit, so that the data reporting and decision support are not facilitated. With the continuous development of group companies, the method has higher requirements on the informatization of the business data. The informatization means is needed to be utilized, an informatization platform for supporting the landing of the group management and control system is established from the unified group management informatization system, and a tamping foundation is built for timely starting informatization of the group management and control means in other aspects in the future. That is, in the scenes of collecting financial report data, interacting business data, collecting edges and the like, data is often required to be obtained from a plurality of business systems or a plurality of different hardware servers, but at present, enterprises or central enterprises in China generally deploy business systems or equipment of a plurality of different manufacturers on mutually isolated networks, and at this time, the problem of cross-network data transmission of heterogeneous systems is involved.
For physical isolation networks such as private networks, data transmission, import and export are required to pass through special data ferrying, and for cross-network data collection of a plurality of heterogeneous systems, the exported Excel data formats are inconsistent, so that group companies often perform data aggregation from a plurality of excels with inconsistent formats, and the data aggregation work is greatly influenced by the format inconsistency.
Disclosure of Invention
Aiming at least one technical problem, the embodiment of the invention provides a heterogeneous system file conversion method, a heterogeneous system file conversion device, a heterogeneous system file conversion medium and heterogeneous system file conversion equipment.
According to a first aspect, the heterogeneous system file conversion method provided by the embodiment of the invention includes:
Acquiring a template file uploaded by a user, wherein the template file comprises a source template and a target template;
identifying the worksheet information of each worksheet in the template file and the data structure in each worksheet, and respectively storing the worksheet information and the data structure in different dictionary tables;
Providing a rule making page, wherein the rule making page is provided with a target template selection item, a target worksheet selection item, a source template selection item, a source worksheet selection item and a conversion rule detail table, so that a user can select a target worksheet in each worksheet of the designated target template through the target worksheet selection item, select a source worksheet in each worksheet of the designated source template through the source template selection item, select a source worksheet in each worksheet of the designated source template through the source worksheet selection item, and respectively designate corresponding conversion modes for each column in the selected target worksheet on the conversion rule detail table to achieve making of conversion rules between the worksheets in the source template and the worksheets in the target template;
reminding a user to upload a source file with the same data structure as the source template;
And converting the source file into a target file with the same data structure as the target template according to the conversion rule.
According to a second aspect, a heterogeneous system file conversion device provided by an embodiment of the present invention includes:
The template acquisition module is used for acquiring a template file uploaded by a user, wherein the template file comprises a source template and a target template;
The information identification module is used for identifying the worksheet information of each worksheet in the template file and the data structure in each worksheet, and respectively storing the worksheet information and the data structure in different dictionary tables;
A rule making module, configured to provide a rule making page, where the rule making page has a target template selection item, a target worksheet selection item, a source template selection item, a source worksheet selection item, and a conversion rule detail table, so that a user specifies a target template through the target template selection item, selects a target worksheet in each worksheet of the specified target template through the target worksheet selection item, specifies a source worksheet in each worksheet of the specified source template through the source template selection item, and specifies a corresponding conversion mode on the conversion rule detail table for each column in the selected target worksheet, so as to implement making of a conversion rule between the worksheet in the source template and the worksheet in the target template;
the file uploading module is used for reminding a user to upload a source file with the same data structure as the source template;
And the file conversion module is used for converting the source file into a target file with the same data structure as the target template according to the conversion rule.
According to a third aspect, embodiments of the present invention provide a computer-readable storage medium having stored thereon a computer program which, when executed in a computer, causes the computer to perform the method provided by the first aspect.
According to a fourth aspect, a computing device provided by an embodiment of the present invention includes a memory and a processor, where the memory stores executable code, and the processor implements the method provided by the first aspect when executing the executable code.
According to the heterogeneous system file conversion method, device, medium and equipment provided by the embodiment of the invention, the template file is uploaded, then the conversion rule is formulated based on the template file, the source file is uploaded, and the source file is converted by utilizing the conversion rule to obtain the target file. According to the method provided by the embodiment of the invention, the business data scattered in each heterogeneous system can be exported, collected, converted and processed, reported to a unified data centralized library of a group, and from the centralization and sharing of the data, the conversion of the data in the Excel files of different heterogeneous systems into the Excel files with the unified format can be realized, so that the problems of different Excel formats and different data sources in the cross-network transmission of different heterogeneous systems are solved, and the workload brought by the conversion of the data formats is greatly reduced.
Drawings
FIG. 1 is a flow chart illustrating a method for converting heterogeneous system files according to an embodiment of the present invention;
FIG. 2 is a schematic diagram showing a page in an embodiment of the present invention;
FIG. 3 is a schematic diagram of a module management page according to an embodiment of the invention;
FIG. 4 is a diagram illustrating a conversion log query page according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of a source file upload window popped up on a rule making page in an embodiment of the present invention;
FIG. 6 is a block diagram illustrating a heterogeneous system file conversion device according to an embodiment of the present invention.
Detailed Description
In a first aspect, an embodiment of the present invention provides a heterogeneous system file conversion method, referring to fig. 1, the method includes steps S110 to S150 as follows:
S110, acquiring a template file uploaded by a user, wherein the template file comprises a source template and a target template;
It is understood that the source template and the source file have the same data structure and the target template and the target file have the same data structure. The source template, the source file, the target file and the target template are excel files, and at least one worksheet is provided in the excel. The data structure is understood to be a column field, and there is a column field in the template file, but the column field in the template file is not filled with actual data, and the column fields of the source file and the target file are filled with actual data.
In one embodiment, before the obtaining the template file uploaded by the user, the method may further include: and providing a template management page to enable a user to upload a template file and specify the category of the template file, wherein the category comprises a source template, a target template and a general template, and the general template can be used as the source template and the target template.
Referring to fig. 3, a user may upload a template file on a template management page, and may designate whether the template file is a source template, a target template, or a generic template, which may be used as either a source template or a target template, when uploading a template file.
In an actual scenario, the user may set the name of the uploaded template file on the template management page.
S120, identifying the worksheet information of each worksheet in the template file and the data structure in each worksheet, and respectively storing the worksheet information and the data structure in different dictionary tables;
That is, after uploading the template file, the system may parse the uploaded template file to obtain the worksheet information of each worksheet in the template file, or may obtain the data structure in each worksheet, and then store the worksheet information and the data structure respectively. For example, the worksheet information is stored in a sheet table dictionary table, and the data structure is stored in a sheet column dictionary table.
In one embodiment, the method provided by the embodiment of the invention can further include:
Displaying the information of the worksheets identified by each worksheet as one piece of data in a worksheet attribute tab, wherein the worksheet attribute tab is also provided with a setting item whether to enable or not corresponding to each piece of data, the setting item defaults to enable, the worksheets corresponding to the representation are enabled to participate in the formulating operation and the data conversion of the conversion rules, and the worksheets corresponding to the representation are not enabled to participate in the formulating operation and the data conversion of the conversion rules; the worksheet information includes a name of the worksheet and a header line number.
That is, the sheet information of one sheet is taken as one piece of data, and if there are a plurality of sheets in one template file, a plurality of pieces of data are obtained after recognition for the template file. Pieces of data are presented in a worksheet properties tab. In particular, the worksheet information may include the name of the worksheet, the header line number.
In the worksheet properties tab, there is also a corresponding whether or not a setting item is enabled for each piece of data, which is enabled by default. If enabled, the worksheet corresponding to the piece of data participates in the following rule making and conversion of the source file into the target file. If not, the worksheet corresponding to the corresponding piece of data does not participate in the following rule making and conversion of the source file into the target file.
The header row number defaults from the sequence number 1, and if the parallel combination exists, the header row numbers are combined into one row.
S130, providing a rule making page, wherein the rule making page is provided with a target template selection item, a target worksheet selection item, a source template selection item, a source worksheet selection item and a conversion rule detail table, so that a user can select a target worksheet in each worksheet of the designated target template through the target template selection item, select a source worksheet in each worksheet of the designated source template through the source template selection item, respectively designate corresponding conversion modes for each column in the selected target worksheet on the conversion rule detail table, and make conversion rules between the worksheets in the source template and the worksheets in the target template;
That is, the rule formulation page has a target template selection item, a target worksheet selection item, a source template selection item, a source worksheet selection item, and a conversion rule detail table thereon. The user may specify a target template through the target template selection. After designating a target template, the user may select a target worksheet in the designated target template via a target worksheet selection item. The user may specify a source template through a source template selection. After designating a source template, the user may select a source worksheet in the designated source template via a source worksheet selection item. The worksheets in the target templates are target worksheets, and the worksheets in the source templates are source worksheets. The columns in the target worksheet are target columns and the columns in the source worksheet are source columns.
Of course, the user may also set the name of the conversion rule on the rule specification page, specify the start line and the end line of the source worksheet, which can be converted, the start line defaults to 2, and the end line defaults to the last line in the source worksheet. On the rule specification page, one target worksheet may be selected, a plurality of target worksheets may be set, one source worksheet may be selected, or a plurality of source worksheets may be selected.
Then, the user designates a corresponding conversion method for the target column, which is a column in the target worksheet, on the conversion rule list.
In one embodiment, the conversion means may include at least one of a constant, a source column field, and an expression, wherein:
The constant conversion mode is a mode of filling columns in the selected target worksheet with fixed constant values;
the conversion mode of the source column field is a mode of filling columns in the selected target worksheet into source column fields in the selected source worksheet; if the column in the selected target worksheet is designated as the conversion mode of the source column field, the source column name item in the conversion rule detail table is in an editable state, so that a user selects the source column field in the selected source worksheet;
The conversion mode of the expression refers to a mode of filling the source column field in the selected source worksheet into the column in the selected target worksheet according to the data obtained by the calculation of the expression; if the column in the selected target worksheet is designated as the conversion mode of the expression, the expression item in the conversion rule detail table is in an editable state, so that a user edits the corresponding expression in an expression editor.
It can be seen that the user may set a corresponding conversion manner for each target column in the conversion rule list, for example, a conversion manner of a certain target column is constant, which means that the target column is filled with a fixed constant value. For example, if a certain target column is converted into a source column field, the source column name item of the target column is in an editable state, and the user can select the source column field from the source column name item corresponding to the target column, where the source column field is derived from the source worksheet selected before, and the target column is equal to the data of the selected source column field, that is, the target column is filled into the selected source column field. For example, if the conversion mode of a certain target column is an expression, the expression item corresponding to the target column is in an editable state, and a user can edit the expression in an expression editor, a source column field may be required when the expression is edited, so that the source column field is introduced, and then data obtained by calculating the source column field according to the expression is filled in the target column.
It will be appreciated that after the rule specification is completed, one piece of data shown in the conversion rule detail table is one conversion rule. In an actual scene, a user can add, insert, delete and copy conversion rules in the conversion rule list, and can also perform an up-shift and down-shift operation.
Specifically, the conversion mode of the expression can be also divided into attribute value, system variable, function value and the like. The system variable is to acquire the login name, date, user and other page parameters as the filling data of the target column field, and the function value is to convert the data of the source column field into characters which can be understood by the user through a preset script and display the characters to the user.
More specifically, the attribute takes the form of: the method of defining the expression is needed first, the actual column value of the source file can be obtained in the expression editor, and the fetch rule is { Data: excel. Examples: { Data: EXCEL.H }, then the Data can be processed inside the editor using js syntax.
More specifically, the expression of the system variable: for example, page parameters are obtained using general.
More specifically, the expression of the function value: support calculation of the value of the target column using a function: the functions include formatting functions, computing functions, sub-table functions, string functions, and other functions, and the functions can be filled into the expression editor by double clicking.
S140, reminding a user to upload a source file with the same data structure as the source template;
s150, converting the source file into a target file with the same data structure as the target template according to the conversion rule.
Specifically, a conversion button is arranged on the rule making page, when the user triggers the conversion button, if the source file is not uploaded at the moment, a source file uploading window is popped up, so that the source file is provided for the user to upload, and when the source file is uploaded by the user, the source file is converted into a target file according to the conversion rule. After the conversion to the target file, the user may download the target file.
That is, in one embodiment, the prompting the user to upload the source file having the same data structure as the source template may specifically include: and responding to the triggering operation of the user on the conversion button in the rule making page, and ejecting a source file uploading window to remind the user to upload the source file with the same data structure as the source template. For example, referring to FIG. 5, a window is popped up on the rule making page for uploading the source file.
In one embodiment, the method provided by the embodiment of the invention can further include:
Responding to screening operation of a user on a preset target template, and displaying each target working page under the preset target template and a source working page corresponding to each target working page on a display page; the source file uploading item corresponding to each source working page is displayed on the display page;
Responding to the triggering operation of the user on any source file uploading item, and providing a source file uploading window so that the user uploads the source file with the same data structure as the source template to which the corresponding source work page belongs;
And executing the data conversion work of the at least one target working page when the user selects the at least one target working page on the display page and triggers a conversion button on the display page.
That is, the user may input the name of the preset target template in the filtering input box, so that each target working page in the preset target template may be displayed on the display surface, and the source working page and the source file uploading item corresponding to the target working pages one by one may also be displayed, and the names of the source files corresponding to one by one may be displayed. The user can trigger any at least one source file uploading item, so that a corresponding source file uploading window is popped up, and the user can upload the corresponding source file.
Referring to fig. 2, a plurality of pieces of data are shown on a presentation page, where one piece of data is a target working page, a corresponding source file uploading item, and a corresponding source file name obtained after a filtering operation. After the user selects at least one piece of data, the conversion button is triggered, and the source file in the selected at least one piece of data can be converted into a corresponding target file, so that simultaneous conversion of a plurality of target files is realized.
Specifically, after clicking the conversion button, checking the source file of the selected data, if the selected data is not transmitted to stop conversion, giving an uploading prompt, and if the uploading is completed, checking whether the required template columns are all contained or not is needed. If not, a pop-up prompt is required. And if the verification is completely passed, inquiring a conversion rule, and converting Excel data according to the conversion rule.
In one embodiment, referring to FIG. 4, the results of each Excel conversion can be viewed by a log query function, and source and destination document names can be clicked on corresponding pages to download source and destination files.
It will be appreciated that in embodiments of the present invention, data storage is referred to as storing data in a corresponding dictionary. For example, the document dictionary is used to store document information of a template file, the sheet list dictionary is used to store worksheet information of worksheets in the template file, the sheet list dictionary is used to store data structures, the conversion rule main table is used to store information such as target worksheets, source worksheets and the like related to conversion rules, the conversion rule detail table is used to store information such as conversion modes related to conversion rules, and the conversion log table is used to store log related information.
It can be understood that the embodiment of the invention can solve the format conversion problem of Excel files when Excel import and export among different heterogeneous systems are used for data exchange. Specifically, for Excel files exported by other heterogeneous systems, before importing the Excel files into the system, uploading template files, then formulating conversion rules based on the template files, importing the source files into the system, and converting the source files by using the conversion rules to obtain target files.
It can be understood that the embodiment of the invention can realize the conversion of the data in the Excel files of different heterogeneous systems into the Excel files with uniform format, so as to solve the problems of different Excel formats and different data sources in the cross-network transmission of different heterogeneous systems. The method provided by the embodiment of the invention can lead out, gather, convert and process the business data scattered in each heterogeneous system, report the business data to a data centralized library with unified groups, and greatly reduce the workload brought by data format conversion from the centralization and sharing of the data.
In a second aspect, an embodiment of the present invention provides a heterogeneous system file conversion device, referring to fig. 6, the device includes:
The template acquisition module is used for acquiring a template file uploaded by a user, wherein the template file comprises a source template and a target template;
The information identification module is used for identifying the worksheet information of each worksheet in the template file and the data structure in each worksheet, and respectively storing the worksheet information and the data structure in different dictionary tables;
A rule making module, configured to provide a rule making page, where the rule making page has a target template selection item, a target worksheet selection item, a source template selection item, a source worksheet selection item, and a conversion rule detail table, so that a user specifies a target template through the target template selection item, selects a target worksheet in each worksheet of the specified target template through the target worksheet selection item, specifies a source worksheet in each worksheet of the specified source template through the source template selection item, and specifies a corresponding conversion mode on the conversion rule detail table for each column in the selected target worksheet, so as to implement making of a conversion rule between the worksheet in the source template and the worksheet in the target template;
the file uploading module is used for reminding a user to upload a source file with the same data structure as the source template;
And the file conversion module is used for converting the source file into a target file with the same data structure as the target template according to the conversion rule.
In one embodiment, the template acquisition module is further configured to, prior to acquiring the template file uploaded by the user: and providing a template management page to enable a user to upload a template file and specify the category of the template file, wherein the category comprises a source template, a target template and a general template, and the general template can be used as the source template and the target template.
In one embodiment, the apparatus further comprises:
The information display module is used for displaying the information of the worksheets identified by each worksheet as one piece of data in a worksheet attribute tab, wherein the worksheet attribute tab is also provided with a setting item whether to enable or not corresponding to each piece of data, the setting item defaults to enable, the worksheets corresponding to the enabled representation participate in the formulating operation and the data conversion of the conversion rules, and the worksheets corresponding to the non-enabled representation do not participate in the formulating operation and the data conversion of the conversion rules; the worksheet information includes a name of the worksheet and a header line number.
In one embodiment, the conversion means includes at least one of a constant, a source column field, and an expression, wherein: the constant conversion mode is a mode of filling columns in the selected target worksheet with fixed constant values; the conversion mode of the source column field is a mode of filling columns in the selected target worksheet into source column fields in the selected source worksheet; if the column in the selected target worksheet is designated as the conversion mode of the source column field, the source column name item in the conversion rule detail table is in an editable state, so that a user selects the source column field in the selected source worksheet; the conversion mode of the expression refers to a mode of filling the source column field in the selected source worksheet into the column in the selected target worksheet according to the data obtained by the calculation of the expression; if the column in the selected target worksheet is designated as the conversion mode of the expression, the expression item in the conversion rule detail table is in an editable state, so that a user edits the corresponding expression in an expression editor.
In one embodiment, the conversion mode of the expression comprises attribute value, system variable or function value; wherein: the system variable is to acquire page parameters as filling data of a target column field; the function value is that the data of the source column field is converted into the understandable text of the user through a preset script and is displayed to the user; the attribute value is a mode that an expression method is required to be defined firstly, an actual column value of a source file is obtained in an expression editor, and then data are processed by js grammar in the expression editor.
In one embodiment, the file upload module is specifically configured to: and responding to the triggering operation of the user on the conversion button in the rule making page, and ejecting a source file uploading window to remind the user to upload the source file with the same data structure as the source template.
In one embodiment, the apparatus further comprises:
The multi-file operation module is used for responding to the screening operation of a user on a preset target template and displaying each target working page under the preset target template and a source working page corresponding to each target working page on a display page; the source file uploading item corresponding to each source working page is displayed on the display page; responding to the triggering operation of the user on any source file uploading item, and providing a source file uploading window so that the user uploads the source file with the same data structure as the source template to which the corresponding source work page belongs; and executing the data conversion work of the at least one target working page when the user selects the at least one target working page on the display page and triggers a conversion button on the display page.
It may be understood that, for explanation, specific implementation, beneficial effects, examples, etc. of the content in the apparatus provided by the embodiment of the present invention, reference may be made to corresponding parts in the method provided in the first aspect, which are not repeated herein.
In a third aspect, embodiments of the present invention provide a computer readable medium having stored thereon computer instructions which, when executed by a processor, cause the processor to perform the method provided in the first aspect.
Specifically, a system or apparatus provided with a storage medium on which a software program code realizing the functions of any of the above embodiments is stored, and a computer (or CPU or MPU) of the system or apparatus may be caused to read out and execute the program code stored in the storage medium.
In this case, the program code itself read from the storage medium may realize the functions of any of the above-described embodiments, and thus the program code and the storage medium storing the program code form part of the present invention.
Examples of storage media for providing program code include floppy disks, hard disks, magneto-optical disks, optical disks (e.g., CD-ROMs, CD-R, CD-RWs, DVD-ROMs, DVD-RAMs, DVD-RWs, DVD+RWs), magnetic tapes, nonvolatile memory cards, and ROMs. Alternatively, the program code may be downloaded from a server computer by a communication network.
Further, it should be apparent that the functions of any of the above-described embodiments may be implemented not only by executing the program code read out by the computer, but also by causing an operating system or the like operating on the computer to perform part or all of the actual operations based on the instructions of the program code.
Further, it is understood that the program code read out by the storage medium is written into a memory provided in an expansion board inserted into a computer or into a memory provided in an expansion module connected to the computer, and then a CPU or the like mounted on the expansion board or the expansion module is caused to perform part and all of actual operations based on instructions of the program code, thereby realizing the functions of any of the above embodiments.
It may be appreciated that, for explanation, specific implementation, beneficial effects, examples, etc. of the content in the computer readable medium provided by the embodiment of the present invention, reference may be made to corresponding parts in the method provided in the first aspect, and details are not repeated herein.
In a fourth aspect, one embodiment of the present specification provides a computing device comprising a memory having executable code stored therein and a processor that, when executing the executable code, performs the method of any one of the embodiments of the specification.
It may be appreciated that, for explanation, specific implementation, beneficial effects, examples, etc. of the content in the computing device provided by the embodiment of the present invention, reference may be made to corresponding parts in the method provided in the first aspect, which are not repeated herein.
In this specification, each embodiment is described in a progressive manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for the device embodiments, since they are substantially similar to the method embodiments, the description is relatively simple, and reference is made to the description of the method embodiments in part.
Those skilled in the art will appreciate that in one or more of the examples described above, the functions described in the present invention may be implemented in hardware, software, a pendant, or any combination thereof. When implemented in software, these functions may be stored on or transmitted over as one or more instructions or code on a computer-readable medium.
The foregoing embodiments have been provided for the purpose of illustrating the general principles of the present invention in further detail, and are not to be construed as limiting the scope of the invention, but are merely intended to cover any modifications, equivalents, improvements, etc. based on the teachings of the invention.
Claims (10)
1. A heterogeneous system file conversion method, comprising:
Acquiring a template file uploaded by a user, wherein the template file comprises a source template and a target template;
identifying the worksheet information of each worksheet in the template file and the data structure in each worksheet, and respectively storing the worksheet information and the data structure in different dictionary tables;
Providing a rule making page, wherein the rule making page is provided with a target template selection item, a target worksheet selection item, a source template selection item, a source worksheet selection item and a conversion rule detail table, so that a user can select a target worksheet in each worksheet of the designated target template through the target worksheet selection item, select a source worksheet in each worksheet of the designated source template through the source template selection item, select a source worksheet in each worksheet of the designated source template through the source worksheet selection item, and respectively designate corresponding conversion modes for each column in the selected target worksheet on the conversion rule detail table to achieve making of conversion rules between the worksheets in the source template and the worksheets in the target template;
reminding a user to upload a source file with the same data structure as the source template;
And converting the source file into a target file with the same data structure as the target template according to the conversion rule.
2. The method of claim 1, wherein prior to the obtaining the template file uploaded by the user, the method further comprises: and providing a template management page to enable a user to upload a template file and specify the category of the template file, wherein the category comprises a source template, a target template and a general template, and the general template can be used as the source template and the target template.
3. The method as recited in claim 1, further comprising:
Displaying the information of the worksheets identified by each worksheet as one piece of data in a worksheet attribute tab, wherein the worksheet attribute tab is also provided with a setting item whether to enable or not corresponding to each piece of data, the setting item defaults to enable, the worksheets corresponding to the representation are enabled to participate in the formulating operation and the data conversion of the conversion rules, and the worksheets corresponding to the representation are not enabled to participate in the formulating operation and the data conversion of the conversion rules; the worksheet information includes a name of the worksheet and a header line number.
4. The method of claim 1, wherein the transformation means comprises at least one of a constant, a source column field, and an expression, wherein:
The constant conversion mode is a mode of filling columns in the selected target worksheet with fixed constant values;
the conversion mode of the source column field is a mode of filling columns in the selected target worksheet into source column fields in the selected source worksheet; if the column in the selected target worksheet is designated as the conversion mode of the source column field, the source column name item in the conversion rule detail table is in an editable state, so that a user selects the source column field in the selected source worksheet;
The conversion mode of the expression refers to a mode of filling the source column field in the selected source worksheet into the column in the selected target worksheet according to the data obtained by the calculation of the expression; if the column in the selected target worksheet is designated as the conversion mode of the expression, the expression item in the conversion rule detail table is in an editable state, so that a user edits the corresponding expression in an expression editor.
5. The method of claim 4, wherein the conversion mode of the expression includes attribute value, system variable or function value; wherein:
the system variable is to acquire page parameters as filling data of a target column field;
the function value is that the data of the source column field is converted into the understandable text of the user through a preset script and is displayed to the user;
The attribute value is a mode that an expression method is required to be defined firstly, an actual column value of a source file is obtained in an expression editor, and then data are processed by js grammar in the expression editor.
6. The method of claim 1, wherein the prompting the user to upload the source file having the same data structure as the source template comprises:
and responding to the triggering operation of the user on the conversion button in the rule making page, and ejecting a source file uploading window to remind the user to upload the source file with the same data structure as the source template.
7. The method as recited in claim 1, further comprising:
Responding to screening operation of a user on a preset target template, and displaying each target working page under the preset target template and a source working page corresponding to each target working page on a display page; the source file uploading item corresponding to each source working page is displayed on the display page;
Responding to the triggering operation of the user on any source file uploading item, and providing a source file uploading window so that the user uploads the source file with the same data structure as the source template to which the corresponding source work page belongs;
And executing the data conversion work of the at least one target working page when the user selects the at least one target working page on the display page and triggers a conversion button on the display page.
8. A heterogeneous system file conversion apparatus, comprising:
The template acquisition module is used for acquiring a template file uploaded by a user, wherein the template file comprises a source template and a target template;
The information identification module is used for identifying the worksheet information of each worksheet in the template file and the data structure in each worksheet, and respectively storing the worksheet information and the data structure in different dictionary tables;
A rule making module, configured to provide a rule making page, where the rule making page has a target template selection item, a target worksheet selection item, a source template selection item, a source worksheet selection item, and a conversion rule detail table, so that a user specifies a target template through the target template selection item, selects a target worksheet in each worksheet of the specified target template through the target worksheet selection item, specifies a source worksheet in each worksheet of the specified source template through the source template selection item, and specifies a corresponding conversion mode on the conversion rule detail table for each column in the selected target worksheet, so as to implement making of a conversion rule between the worksheet in the source template and the worksheet in the target template;
the file uploading module is used for reminding a user to upload a source file with the same data structure as the source template;
And the file conversion module is used for converting the source file into a target file with the same data structure as the target template according to the conversion rule.
9. A computer readable storage medium, characterized in that a computer program is stored thereon, which, when executed in a computer, causes the computer to perform the method of any of the claims 1-7.
10. A computing device comprising a memory and a processor, the memory having executable code stored therein, the processor, when executing the executable code, implementing the method of any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410187599.8A CN118152336A (en) | 2024-02-20 | 2024-02-20 | Heterogeneous system file conversion method and device, medium and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410187599.8A CN118152336A (en) | 2024-02-20 | 2024-02-20 | Heterogeneous system file conversion method and device, medium and equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN118152336A true CN118152336A (en) | 2024-06-07 |
Family
ID=91292736
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410187599.8A Pending CN118152336A (en) | 2024-02-20 | 2024-02-20 | Heterogeneous system file conversion method and device, medium and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN118152336A (en) |
-
2024
- 2024-02-20 CN CN202410187599.8A patent/CN118152336A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20200167350A1 (en) | Loading queries using search points | |
| CN109739934B (en) | Difference set account checking method, medium, computer equipment and system | |
| CN109582647B (en) | Unstructured evidence file oriented analysis method and system | |
| CN110032604B (en) | Data storage device, translation device and database access method | |
| CN106708480A (en) | Management platform realization method and apparatus | |
| US20050223325A1 (en) | Document structure-editing program, document structure-editing method, document structure-editing apparatus, and computer-readable recording medium having document structure-editing program recorded thereon | |
| CN106469140A (en) | A kind of report generating system and its method | |
| US20130191328A1 (en) | Standardized framework for reporting archived legacy system data | |
| CN112232047A (en) | Method, system, equipment and medium for multi-dimensional data acquisition and automatic summarization | |
| CN116468010A (en) | Report generation method, device, terminal and storage medium | |
| US8099663B2 (en) | Apparatus and method for document synchronization | |
| CN114417012A (en) | Method for generating knowledge graph and electronic equipment | |
| CN118152336A (en) | Heterogeneous system file conversion method and device, medium and equipment | |
| CN113515926B (en) | Automatic file publishing method for plug-in development system model information based on Office Word | |
| US20240037325A1 (en) | Ability to add non-direct ancestor columns in child spreadsheets | |
| CN113010588B (en) | Data form processing method | |
| CN116257656A (en) | Python-based telemetry page format conversion system | |
| CN111782608B (en) | File automatic generation method and device, electronic equipment and storage medium | |
| CN116737698B (en) | Distributed database configuration comparison method, device, equipment and storage medium | |
| JPWO2006046664A1 (en) | Time sharing management device, document creation device, document browsing device, time sharing management method, document creation method, and document browsing method | |
| CN118035060B (en) | Method for dynamically generating buried point standard basic data model | |
| CN116611418B (en) | Report processing method and device based on online editing, electronic equipment and medium | |
| US12061860B2 (en) | Uniform hierarchical view over diverse data formats | |
| CN111488729B (en) | Data processing system and method | |
| CN116303462A (en) | Report processing method and device, storage medium and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |