CN118277464A - Digital delivery multi-standard mapping conversion method, system, medium and equipment - Google Patents
Digital delivery multi-standard mapping conversion method, system, medium and equipment Download PDFInfo
- Publication number
- CN118277464A CN118277464A CN202410228177.0A CN202410228177A CN118277464A CN 118277464 A CN118277464 A CN 118277464A CN 202410228177 A CN202410228177 A CN 202410228177A CN 118277464 A CN118277464 A CN 118277464A
- Authority
- CN
- China
- Prior art keywords
- conversion
- data
- mapping
- source data
- format
- 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 147
- 238000013507 mapping Methods 0.000 title claims abstract description 103
- 238000000034 method Methods 0.000 title claims abstract description 54
- 230000008569 process Effects 0.000 claims abstract description 20
- 238000011426 transformation method Methods 0.000 claims description 12
- 238000012795 verification Methods 0.000 claims description 12
- 238000004590 computer program Methods 0.000 claims description 11
- 230000002159 abnormal effect Effects 0.000 claims description 9
- 230000000007 visual effect Effects 0.000 claims description 7
- 230000009466 transformation Effects 0.000 claims description 3
- 238000012800 visualization Methods 0.000 claims description 2
- 238000013506 data mapping Methods 0.000 abstract description 4
- 230000010354 integration Effects 0.000 abstract description 4
- 230000003993 interaction Effects 0.000 abstract description 3
- 238000005516 engineering process Methods 0.000 description 9
- 238000010276 construction Methods 0.000 description 8
- 230000006870 function Effects 0.000 description 8
- 238000010586 diagram Methods 0.000 description 7
- 238000012545 processing Methods 0.000 description 7
- 238000013461 design Methods 0.000 description 5
- 230000007774 longterm Effects 0.000 description 5
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000002688 persistence Effects 0.000 description 2
- 239000007787 solid Substances 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 230000000739 chaotic effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000001737 promoting effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000004088 simulation Methods 0.000 description 1
- 239000000126 substance Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a digital delivery multi-standard mapping conversion method, a system, a medium and equipment, wherein the method comprises the following steps: reading source data; configuring a mapping conversion relation based on the source data and a target field in a preset database; converting the source data into target format data based on the mapping conversion relation; and exporting the target format data after the format conversion, and synchronously generating a conversion report. The invention realizes that the delivery result can be mapped and converted according to various delivery standards by utilizing the configuration of various delivery standard standards in the engineering digital delivery process, thereby realizing the conversion of the delivery result into the delivery form suitable for various digital delivery standards, supporting the data mapping among various specifications such as international, domestic and enterprise standards and the like, and facilitating the data interaction and integration between the future delivery result data and a third party system.
Description
Technical Field
The present invention relates to the field of data mapping and data conversion technologies, and in particular, to a method, a system, a medium, and a device for digitally delivering multiple standard mapping and conversion.
Background
With the development and application of information technology, engineering digital delivery has become an important trend in the field of modern engineering construction. The engineering digital delivery refers to integrating, managing and interacting data of engineering construction projects in various stages of design, construction, operation and the like by utilizing information technology means, so as to realize digital transmission and sharing of engineering data. A data base is built for a factory or a facility in the aspects of data acquisition, information management, collaborative design, simulation and the like.
In the process of making engineering digital delivery, digital delivery standards are important guideline documents that instruct the delivery party and the recipient how to make the digital delivery. The relationship between digital delivery and digital delivery standards can be analogically to the relationship between construction and construction specifications in the construction industry. Digital delivery involves the process of creating, managing, sharing, and utilizing data at various stages of an engineering project (e.g., design, construction, operation, etc.) using digital technology and tools. And the digital delivery criteria provide an explicit, unified specification and guidance for this process. In the field of engineering digital delivery, there are many other standards, which may be international, national or enterprise standards. In general, standards in the digital delivery field are diverse, providing framework and guidance for various phases of engineering projects, ensuring consistency, interoperability and long-term value of data. Different criteria may be applicable to different fields, projects or requirements, so that the selection and implementation of appropriate criteria is critical. For example, in a conventional digital delivery process, delivery is performed according to a digital delivery standard, and the software system, electronic device and medium adopted can only adapt to the configuration of the delivery standard required for the project. When the same digital asset needs to be handed over to a different owner or a modified delivery standard of the owner, or applied to other business forms, the information of the delivery will not meet the new delivery requirements.
Disclosure of Invention
The invention aims to provide a digital delivery multi-standard mapping conversion method, a system, a medium and equipment, which are used for solving the problem of digital delivery multi-standard mapping conversion.
In a first aspect, the present application provides a digital delivery multi-standard mapping transformation method, the method comprising:
Reading source data;
configuring a mapping conversion relation based on the source data and a target field in a preset database;
converting the source data into target format data based on the mapping conversion relation;
And exporting the target format data after the format conversion, and synchronously generating a conversion report.
In one possible implementation manner of the present application, the reading source data specifically includes:
reading the source data based on a data analyzer, wherein a data interface of the data analyzer supports a plurality of data input modes;
And identifying the file format of the source data based on the data analyzer, and analyzing the source data to obtain attribute information, wherein the attribute information at least comprises a field name and a data type.
In one possible implementation of the present application, the method further includes: and verifying the integrity and the accuracy of the source data, and outputting a verification result, wherein when the verification result is error-free, the source data is successfully read.
In one possible implementation manner of the present application, the configuring the mapping conversion relationship based on the source data and the target field in the preset database specifically includes:
Calling a conversion engine to automatically recommend and configure the mapping conversion relation between the current source data and the target field;
and storing the current mapping conversion relation and verifying, wherein the mapping conversion relation with the error of the mapping logic is removed during verification.
In one possible implementation of the present application, the method further includes providing an editable visual mapping interface including at least displaying, modifying, and deleting the mapping conversion relationship.
In one possible implementation manner of the present application, the converting the source data into the target format data based on the mapping conversion relationship specifically includes:
performing data type conversion on the source data based on the mapping conversion relation, wherein the data type conversion at least comprises character string to number conversion and date format conversion;
Recording error information and/or abnormal information in the conversion process to obtain conversion abnormal information;
a conversion preview is generated for viewing by a user based on the visualization mapping interface.
In one possible implementation manner of the present application, the exporting the target format data after converting the format and synchronously generating the conversion report specifically includes:
extracting target format data after converting the data types based on the user demand format to obtain target data;
Exporting the target data based on a user export format, wherein the export mode at least comprises downloading to a local area and storing to a cloud and/or a specific database;
The conversion anomaly information is extracted to synchronously generate a conversion report, wherein the conversion report is generated in a list format.
In a second aspect, the present application provides a digital delivery multi-standard mapping conversion system, the system comprising:
In a third aspect, the present application provides a computer readable storage medium as described above, having stored thereon a computer program which, when executed by a processor, implements the digital delivery multi-standard mapping transformation method.
In a fourth aspect, the present application provides an electronic device as described above, including: a processor and a memory; the memory is used for storing a computer program, and the processor is used for loading and executing the computer program so as to enable the electronic equipment to execute the digital delivery multi-standard mapping conversion method.
As described above, the digital delivery multi-standard mapping conversion method, system, medium and equipment of the invention realize mapping conversion of delivery results according to various delivery standards by utilizing the configuration of various delivery standard standards in engineering digital delivery process, thereby realizing conversion of delivery results into delivery forms suitable for various digital delivery standards, supporting data mapping between various specifications such as international, domestic and enterprise standards, and facilitating data interaction and integration between future delivery result data and third party systems.
Drawings
FIG. 1 is a diagram showing steps of a digital delivery multi-standard mapping transformation method according to an embodiment of the present invention;
FIG. 2 is a diagram showing steps of a digital delivery multi-standard mapping transformation method according to an embodiment of the present invention;
FIG. 3 is a diagram showing steps of a digital delivery multi-standard mapping transformation method according to an embodiment of the present invention;
FIG. 4 is a diagram showing steps of a digital delivery multi-standard mapping transformation method according to an embodiment of the present invention;
FIG. 5 is a diagram showing steps of a digital delivery multi-standard mapping transformation method according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of a digital delivery multi-standard mapping transformation system according to an embodiment of the present invention;
Fig. 7 is a schematic structural diagram of an electronic device according to an embodiment of the invention.
Description of element reference numerals
S102-S108 steps
S202-S204 steps
S302 to S304 steps
S402 to S406 steps
S502 to S506 steps
60. Digital delivery multi-standard mapping conversion system
61. Reading module
62. Configuration module
63. Conversion module
64. Export module
Detailed Description
Other advantages and effects of the present invention will become apparent to those skilled in the art from the following disclosure, which describes the embodiments of the present invention with reference to specific examples. The invention may be practiced or carried out in other embodiments that depart from the specific details, and the details of the present description may be modified or varied from the spirit and scope of the present invention. It should be noted that the following embodiments and features in the embodiments may be combined with each other without conflict.
It should be noted that the illustrations provided in the following embodiments merely illustrate the basic concept of the present invention by way of illustration, and only the components related to the present invention are shown in the drawings and are not drawn according to the number, shape and size of the components in actual implementation, and the form, number and proportion of the components in actual implementation may be arbitrarily changed, and the layout of the components may be more complicated.
Digital delivery involves the process of creating, managing, sharing, and utilizing data at various stages of an engineering project (e.g., design, construction, operation, etc.) using digital technology and tools. And the digital delivery criteria provide an explicit, unified specification and guidance for this process. The following is a detailed description of the relationship between the two: guiding function: the digital delivery standard provides a framework and guidance for digital delivery, ensuring that all participants follow the same method and flow, using the same data format and structure. Ensuring interoperability: since digital delivery involves multiple teams, tools and systems, digital delivery standards ensure interoperability between them, enabling smooth data sharing and exchange. Enhancing efficiency and quality: standardized methods and tools mean that teams can work more efficiently while reducing errors and omissions, thereby improving the overall quality of the project. Providing a long-term viewing angle: digital delivery standards often allow for long-term management and utilization of data, which is particularly important to ensure the value of an engineering asset throughout its lifecycle. Promoting industry development: with the progress of technology, the digital delivery standard is updated and perfected continuously, so that the development of technology and methods in the whole industry is promoted. Guaranteeing legal and commercial interests: digital delivery standards may also involve legal and business issues of ownership, access, intellectual property, etc. of the data, thereby providing security to the parties.
In summary, digital delivery is a practical application and operation, and digital delivery standards provide a clear specification and framework for these applications and operations, ensuring their efficiency, quality, and long-term value. The two are closely related, without explicit criteria, digital delivery may become chaotic and inefficient; without practical application, the standard loses its meaning of existence. Typical digital delivery standards, such as ISO15926, provide consistency, structure and guidance for the use of digital technology and tools in the engineering industry. This standard was created specifically for processing engineering data in the process industry, particularly the oil, gas and chemical industries. The method mainly solves the problems of data interoperability and data persistence in the engineering digital delivery field. Comprising the following steps: data interoperability: ensuring that data can be shared and exchanged seamlessly between different software applications, particularly at different stages of the factory lifecycle. Data persistence: over time and with changes in technology, long-term availability and consistency of engineering data is ensured. In the field of engineering digital delivery, there are many other standards besides ISO15926, which may be international, national or enterprise standards. When the same digital asset needs to be handed over to a different owner or a modified delivery standard of the owner, or applied to other business forms, the information of the delivery will not meet the new delivery requirements. There is therefore a need for a method that can assist in the engineering digital delivery process to achieve multi-standard mapping. Namely, on the basis of the same digital delivery content, the data organization and interoperability meeting the requirements of various digital delivery standards are automatically realized. For this purpose, the digital delivery multi-standard mapping conversion method, system, medium and device of the application are provided.
Referring to fig. 1, in an embodiment of the invention, the digital delivery multi-standard mapping transformation method of the invention includes the following steps:
Step S102, reading source data;
step S104, configuring a mapping conversion relation based on the source data and a target field in a preset database;
Step S106, converting the source data into target format data based on the mapping conversion relation;
step S108, exporting the target format data after the format conversion, and synchronously generating a conversion report.
It should be noted that, as shown in fig. 2, the reading of the source data specifically includes the following steps:
Step S202, reading the source data based on a data analyzer, wherein a data interface of the data analyzer supports a plurality of data input modes;
step S204, identifying a file format of the source data based on the data parser, and parsing the source data to obtain attribute information, where the attribute information at least includes a field name and a data type.
It should be noted that, when reading data, the data may be read through a user-friendly input interface, where the interface allows a user to upload a data file or directly transmit data or connect databases through an API interface, where in this embodiment, a data parser is used to read, and the data parser of the present application may read and identify multiple data standards and formats (e.g. CSV, XML, JSON, etc.), and meanwhile, when the data parser in this embodiment reads source data, information describing a structure, a type, a relationship, etc. of the data is also read to obtain the attribute information, where correspondingly, the attribute information includes at least a field name and a data type.
Further, in an embodiment of the invention, the method further includes: and verifying the integrity and the accuracy of the source data, and outputting a verification result, wherein when the verification result is error-free, the source data is successfully read.
It should be noted that, when verifying the source data, in order to ensure that there is no missing value or format error, it is necessary to check the integrity and accuracy of the source data, where when the verification result indicates that there is no missing value or format error, the source data is successfully read, so that the subsequent steps can be started.
Further, in an embodiment of the invention, as shown in fig. 3, the mapping conversion relationship is configured based on the source data and a target field in a preset database, and specifically includes the following steps:
Step S302, calling a conversion engine to automatically recommend and configure the mapping conversion relation between the current source data and the target field;
Step S304, the current mapping conversion relation is saved and verified, wherein the mapping conversion relation with the wrong mapping logic is removed during verification.
It should be noted that, in this embodiment, regarding configuration of a mapping conversion relationship, automatic mapping recommendation and mapping saving and loading are described, where specifically, a call conversion engine uses a mapping rule to automatically recommend and configure a mapping conversion relationship corresponding to a current source data and a target field, so that user efficiency is enabled, and after the mapping conversion relationship is obtained, the current mapping conversion relationship may be saved so as to be directly and repeatedly invoked in a subsequent conversion task, further, after the mapping conversion relationship is obtained, verification is also required to be performed to check validity of the mapping relationship, and specifically, when verification is performed, a mapping conversion relationship with a wrong mapping logic needs to be removed so as to ensure that the mapping logic between the source data and the target data is correct.
Further, in an embodiment of the invention, the method further includes providing an editable visual mapping interface, the visual mapping interface including at least displaying, modifying, and deleting the mapping conversion relationship.
It should be noted that in this embodiment, it is described that, when converting a format, a user may view, edit, modify and delete a mapping conversion relationship, where in this embodiment, an editable visual mapping interface is provided, and the interface is used to display the mapping conversion relationship between data, and meanwhile, the interface also provides a modifying and deleting function, so that the user edits the mapping conversion relationship.
Further, in an embodiment of the invention, as shown in fig. 4, the step of converting the source data into the target format data based on the mapping conversion relationship specifically includes the following steps:
Step S402, performing data type conversion on the source data based on the mapping conversion relation, wherein the data type conversion at least comprises character string conversion number conversion and date format conversion;
Step S404, error information and/or abnormal information in the conversion process are recorded to obtain conversion abnormal information;
Step S406, generating a conversion preview for viewing by a user based on the visual mapping interface.
It should be noted that, in this embodiment, when mapping, the mapping rule may be used to convert the data in the intermediate format into a format of any target standard, so that data type conversion may be performed on the source data based on the mapping conversion relationship, where the data type conversion includes at least conversion of a character string to a number and conversion of a date format, and in the conversion process, error information and abnormal information encountered are recorded to obtain conversion abnormal information, where in actual application, corresponding prompts and processing suggestions of a user may be provided according to the conversion abnormal information, and further, before and after actual conversion, a preview function may be provided for the user by using a visual mapping interface, so that the user may view the conversion result, where before conversion, the user may continue to modify and after conversion, the user may view.
Accordingly, all mapping rules are stored and managed in advance in the conversion engine described in the present application, and a version update function is supported, so that it can be ensured that all the mapping rules can be updated and version traced, wherein the mapping rules are utilized to perform opportunistic data conversion, so that it can be ensured that a large amount of data is quickly converted, thereby optimizing performance.
Further, in an embodiment of the invention, as shown in fig. 5, the method for exporting the target format data after the conversion format and synchronously generating the conversion report specifically includes the following steps:
Step S502, extracting target format data after converting the data types based on the user demand format to obtain target data;
Step S504, exporting the target data based on a user export format, wherein the export mode at least comprises downloading to the local and storing to a cloud and/or a specific database;
In step S506, conversion abnormality information is extracted to generate a conversion report in synchronization, wherein the conversion report is generated in a list format.
It should be noted that, in this embodiment, the converted data may be output into a specific format (such as CSV, XML, JSON, etc.) required by the user, where, specifically, the target format data after the conversion data type is extracted based on the format required by the user to obtain the target data, that is, the target data in a format meeting the requirement of the user, and then the target data is exported based on the export format of the user, where the export mode includes at least downloading to the cloud and/or a specific database, and at the time of exporting, encrypting and compressing the data to ensure safe and efficient transmission of the data, and further, extracting the conversion anomaly information to synchronously generate a conversion report, where, in the above embodiment, the conversion report is generated in a list format, specifically, in the conversion process, error information and anomaly information encountered are recorded to obtain the conversion anomaly information, and a prompt and a processing suggestion corresponding to the conversion anomaly information are provided for the user, so, when exporting to the user, the conversion anomaly information is required to synchronously generate the conversion report in advance, and when applying, the corresponding prompt and the processing suggestion are synchronously added to the conversion report for the user to view.
The embodiment of the application also provides a digital delivery multi-standard mapping conversion system, which can realize the digital delivery multi-standard mapping conversion method of the application, but the realization device of the digital delivery multi-standard mapping conversion method of the application comprises but is not limited to the structure of the digital delivery multi-standard mapping conversion system listed in the embodiment, and all the structural variations and substitutions of the prior art according to the principles of the application are included in the protection scope of the application.
Referring to fig. 6, in one embodiment, a digital delivery multi-standard mapping transformation system 60 is provided, which includes:
a reading module 61 for reading the source data;
a configuration module 62, configured to configure a mapping conversion relationship based on the source data and a target field in a preset database;
A conversion module 63, configured to convert the source data into target format data based on the mapping conversion relationship;
And the export module 64 is used for exporting the source data after the conversion format and synchronously generating a conversion report.
Since the specific implementation manner of this embodiment corresponds to the foregoing method embodiment, the same details will not be repeated herein, and it should also be understood by those skilled in the art that the division of each module in the embodiment of fig. 6 is merely a division of a logic function, and all or part of the modules may be integrated onto one or more physical entities in actual implementation, and all of the modules may be implemented in a form of calling by a processing element through software, or may be implemented in a form of hardware, or may be implemented in a form of calling by a processing element through part of the modules, or may be implemented in a form of hardware.
Referring to fig. 7, the present embodiment provides an electronic device, which includes at least: the system comprises a memory and a processor, wherein the memory is used for storing a computer program, and the processor is used for executing the computer program stored in the memory so as to execute all or part of the steps in the embodiment of the method.
In summary, the invention realizes that the delivery result can be mapped and converted according to various delivery standards by utilizing the configuration of various delivery standard standards in the engineering digital delivery process, thereby realizing the conversion of the delivery result into the delivery form suitable for various digital delivery standards, supporting the data mapping among various standards such as international, domestic and enterprise standards, and facilitating the data interaction and integration between the future delivery result data and a third party system.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus, or method may be implemented in other manners. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of modules/units is merely a logical function division, and there may be additional divisions when actually implemented, e.g., multiple modules or units may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or modules or units, which may be in electrical, mechanical or other forms.
The modules/units illustrated as separate components may or may not be physically separate, and components shown as modules/units may or may not be physical modules, i.e., may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules/units may be selected according to actual needs to achieve the objectives of the embodiments of the present application. For example, functional modules/units in various embodiments of the application may be integrated into one processing module, or each module/unit may exist alone physically, or two or more modules/units may be integrated into one module/unit.
Those of ordinary skill would further appreciate that the elements and algorithm steps of the examples described in connection with the embodiments disclosed herein may be embodied in electronic hardware, in computer software, or in a combination of the two, and that the elements and steps of the examples have been generally described in terms of function in the foregoing description to clearly illustrate the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
The embodiment of the application also provides a computer readable storage medium. Those of ordinary skill in the art will appreciate that all or part of the steps in a method implementing the above embodiments may be implemented by a program to instruct a processor, where the program may be stored in a computer readable storage medium, where the storage medium is a non-transitory (non-transitory) medium, such as a random access memory, a read only memory, a flash memory, a hard disk, a solid state disk, a magnetic tape (MAGNETIC TAPE), a floppy disk (floppy disk), a compact disk (optical disk), and any combination thereof. The storage media may be any available media that can be accessed by a computer or a data storage device such as a server, data center, or the like that contains an integration of one or more available media. The usable medium may be a magnetic medium (e.g., a floppy disk, a hard disk, a magnetic tape), an optical medium (e.g., a digital video disc (digital video disc, DVD)), or a semiconductor medium (e.g., a Solid State Drive (SSD)), or the like.
Embodiments of the present application may also provide a computer program product comprising one or more computer instructions. When the computer instructions are loaded and executed on a computing device, the processes or functions in accordance with embodiments of the present application are fully or partially developed. The computer instructions may be stored in a computer-readable storage medium or transmitted from one computer-readable storage medium to another computer-readable storage medium, for example, the computer instructions may be transmitted from one website, computer, or data center to another website, computer, or data center by a wired (e.g., coaxial cable, fiber optic, digital Subscriber Line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.).
The computer program product is executed by a computer, which performs the method according to the preceding method embodiment. The computer program product may be a software installation package, which may be downloaded and executed on a computer in case the aforementioned method is required.
The descriptions of the processes or structures corresponding to the drawings have emphasis, and the descriptions of other processes or structures may be referred to for the parts of a certain process or structure that are not described in detail.
The above embodiments are merely illustrative of the principles of the present application and its effectiveness, and are not intended to limit the application. Modifications and variations may be made to the above-described embodiments by those skilled in the art without departing from the spirit and scope of the application. Accordingly, it is intended that all equivalent modifications and variations of the application be covered by the claims, which are within the ordinary skill of the art, be within the spirit and scope of the present disclosure.
Claims (10)
1. A digital delivery multi-standard mapping transformation method, comprising:
Reading source data;
configuring a mapping conversion relation based on the source data and a target field in a preset database;
converting the source data into target format data based on the mapping conversion relation;
And exporting the target format data after the format conversion, and synchronously generating a conversion report.
2. The digital delivery multi-standard mapping conversion method according to claim 1, wherein the reading source data specifically comprises:
reading the source data based on a data analyzer, wherein a data interface of the data analyzer supports a plurality of data input modes;
And identifying the file format of the source data based on the data analyzer, and analyzing the source data to obtain attribute information, wherein the attribute information at least comprises a field name and a data type.
3. The digital delivery multi-standard mapping transformation method of claim 2, further comprising: and verifying the integrity and the accuracy of the source data, and outputting a verification result, wherein when the verification result is error-free, the source data is successfully read.
4. The digital delivery multi-standard mapping conversion method according to claim 1, wherein the mapping conversion relation is configured based on the source data and a target field in a preset database, and specifically comprises:
Calling a conversion engine to automatically recommend and configure the mapping conversion relation between the current source data and the target field;
and storing the current mapping conversion relation and verifying, wherein the mapping conversion relation with the error of the mapping logic is removed during verification.
5. The digital delivery multi-standard mapping transformation method of claim 4, further comprising providing an editable visual mapping interface including at least displaying, modifying, and deleting the mapping transformation relationship.
6. The digital delivery multi-standard mapping conversion method according to claim 5, wherein the converting the source data into the target format data based on the mapping conversion relation specifically comprises:
performing data type conversion on the source data based on the mapping conversion relation, wherein the data type conversion at least comprises character string to number conversion and date format conversion;
Recording error information and/or abnormal information in the conversion process to obtain conversion abnormal information;
a conversion preview is generated for viewing by a user based on the visualization mapping interface.
7. The digital delivery multi-standard mapping conversion method according to claim 6, wherein the target format data after the conversion format is exported and the conversion report is synchronously generated, specifically comprising:
extracting target format data after converting the data types based on the user demand format to obtain target data;
Exporting the target data based on a user export format, wherein the export mode at least comprises downloading to a local area and storing to a cloud and/or a specific database;
The conversion anomaly information is extracted to synchronously generate a conversion report, wherein the conversion report is generated in a list format.
8. A digital delivery multi-standard mapping conversion system, comprising:
The reading module is used for reading the source data;
the configuration module is used for configuring a mapping conversion relation based on the source data and a target field in a preset database;
the conversion module is used for converting the source data into target format data based on the mapping conversion relation;
and the export module is used for exporting the source data after the conversion format and synchronously generating a conversion report.
9. A computer readable storage medium having stored thereon a computer program, characterized in that the program, when executed by a processor, implements the digital delivery multi-standard mapping transformation method of any of claims 1 to 7.
10. An electronic device, the electronic device comprising: a processor and a memory; wherein the memory is configured to store a computer program, and the processor is configured to execute the computer program stored in the memory, to cause the electronic device to perform the digital delivery multi-standard mapping conversion method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410228177.0A CN118277464A (en) | 2024-02-29 | 2024-02-29 | Digital delivery multi-standard mapping conversion method, system, medium and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410228177.0A CN118277464A (en) | 2024-02-29 | 2024-02-29 | Digital delivery multi-standard mapping conversion method, system, medium and equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN118277464A true CN118277464A (en) | 2024-07-02 |
Family
ID=91647533
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410228177.0A Pending CN118277464A (en) | 2024-02-29 | 2024-02-29 | Digital delivery multi-standard mapping conversion method, system, medium and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN118277464A (en) |
-
2024
- 2024-02-29 CN CN202410228177.0A patent/CN118277464A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109118347B (en) | Automatic cooperation method and system | |
| EP2485147B1 (en) | Operations management using communications and collaboration platform | |
| US20130332899A1 (en) | System for Developing Custom Data Transformations for System Integration Application Programs | |
| US10354343B2 (en) | Automated process control hardware engineering using schema-represented requirements | |
| CN110795147A (en) | Interface protocol file management method and device | |
| CN104102489A (en) | Third-party database APP (Application) construction system and construction method | |
| CN110738038A (en) | Contract text generation method, device, equipment and computer readable storage medium | |
| CN105791178A (en) | Message assembly method and device | |
| CN113971037A (en) | Application processing method and device, electronic equipment and storage medium | |
| CN114201718A (en) | Dynamically configurable form instance generation method and device | |
| CN107436785B (en) | Revit software information interaction system and interaction method based on information system | |
| US20230005509A1 (en) | Systems and methods for processing video data | |
| CN101136780A (en) | Method, system to obtain user command information, and user command registered device | |
| CN117873597A (en) | Method and system for realizing API arrangement through visual configuration mode | |
| CN118277464A (en) | Digital delivery multi-standard mapping conversion method, system, medium and equipment | |
| CN115062084B (en) | Method and device for constructing API (application programming interface) based on database metadata | |
| CN116737662A (en) | Method, device, electronic equipment and storage medium for processing business data | |
| US10147061B2 (en) | Integrating a construction jobsite system with external tools | |
| WO2020155167A1 (en) | Application of cross-organizational transactions to blockchain | |
| CN110221827B (en) | Data processing method and related device | |
| CN113987277A (en) | Contract data processing method and device, electronic equipment and storage medium | |
| CN113064987A (en) | Data processing method, apparatus, electronic device, medium, and program product | |
| CN112579165A (en) | Batch operation execution method and device, readable medium and electronic equipment | |
| CN112785421A (en) | Real-time configurable online transaction processing method and processing system | |
| CN102203756B (en) | Client terminal device, server unit and framing program used in information processing system |
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 |