CN110955715A - ERP system, data conversion method and device of target platform and electronic equipment - Google Patents

ERP system, data conversion method and device of target platform and electronic equipment Download PDF

Info

Publication number
CN110955715A
CN110955715A CN201911219101.7A CN201911219101A CN110955715A CN 110955715 A CN110955715 A CN 110955715A CN 201911219101 A CN201911219101 A CN 201911219101A CN 110955715 A CN110955715 A CN 110955715A
Authority
CN
China
Prior art keywords
order information
metadata
target platform
erp system
converting
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201911219101.7A
Other languages
Chinese (zh)
Other versions
CN110955715B (en
Inventor
陈子明
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Wanghai Kangxin Beijing Technology Co Ltd
Original Assignee
Wanghai Kangxin Beijing Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Wanghai Kangxin Beijing Technology Co Ltd filed Critical Wanghai Kangxin Beijing Technology Co Ltd
Priority to CN201911219101.7A priority Critical patent/CN110955715B/en
Publication of CN110955715A publication Critical patent/CN110955715A/en
Application granted granted Critical
Publication of CN110955715B publication Critical patent/CN110955715B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/258—Data format conversion from or to a database
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • G06Q10/103—Workflow collaboration or project management
    • 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

Abstract

The application provides a data conversion method and device of an ERP system and a target platform and electronic equipment, and relates to the technical field of computers. The method comprises the following steps: acquiring first metadata of a target platform; determining a one-to-one mapping relation between each first metadata and each second metadata in the ERP system; and when order information which is created by a user in the ERP system and comprises at least one piece of second metadata is detected, converting the order information based on the mapping relation, and uploading the converted order information to a target platform. The method and the device can improve the accuracy of the entered order information.

Description

ERP system, data conversion method and device of target platform and electronic equipment
Technical Field
The application relates to the technical field of computers, in particular to a data conversion method, a data conversion device and electronic equipment for an ERP system and a target platform.
Background
Enterprise Resource Planning (ERP) is a management platform that provides decision-making operation means for an Enterprise by using a systematic management idea, and integrates customer requirements, manufacturing activities inside the Enterprise and manufacturing resources of suppliers together to form a complete supply chain of the Enterprise.
In daily life, the same order is often required to be established in an ERP system and other systems when a purchasing process is completed, and the purchasing order is required to be input in the two systems because the two systems are mutually independent, so that manpower is wasted, data information of the same material between the two systems is inconsistent due to errors in input easily, and the accuracy of the finally input order information is low.
Disclosure of Invention
In order to solve at least one of the problems in the prior art, embodiments of the present application provide a data conversion method, an apparatus, and an electronic device for an ERP system and a target platform, and a technical solution provided by embodiments of the present application is as follows:
a first aspect of the present application provides a data conversion method for an ERP system and a target platform, where the method is performed by a data conversion system, and the method includes:
acquiring first metadata of a target platform;
determining a one-to-one mapping relation between each first metadata and each second metadata in the ERP system;
and when order information which is created by a user in the ERP system and comprises at least one piece of second metadata is detected, converting the order information based on the mapping relation, and uploading the converted order information to a target platform.
A second aspect of the present application provides a data conversion apparatus for an ERP system and a target platform, including:
the acquisition module is used for acquiring each first metadata of the target platform;
the determining module is used for determining a one-to-one mapping relation between each first metadata and each second metadata in the ERP system;
and the conversion module is used for converting the order information based on the mapping relation and uploading the converted order information to the target platform when the order information which is created by the ERP system and comprises at least one piece of second metadata by the user is detected.
Optionally, when the conversion module converts the order information based on the mapping relationship, the conversion module is specifically configured to:
converting the at least one second metadata into at least one first metadata corresponding to one another on the basis of the mapping relation, and obtaining converted order information comprising the at least one first metadata;
when uploading the converted order information to the target platform, the conversion module is specifically configured to:
acquiring a format template of a target platform;
and uploading the converted order information to a target platform based on the format template.
Optionally, the data conversion system is any one of an ERP system and an intermediate system;
and the intermediate system establishes communication connection with the ERP system, and establishes communication connection with the target platform.
Optionally, if the data synchronization system is an intermediate system;
when the conversion module converts the order information based on the mapping relationship, the conversion module is specifically configured to:
and calling an order conversion interface of the intermediate system, and converting the order information based on the mapping relation.
Optionally, a trigger is set in the ERP system, and when detecting order information created by the user in the ERP system, the conversion module is specifically configured to:
when a trigger instruction sent by a trigger is received, determining that a user creates order information in an ERP system;
the conversion module is specifically configured to, when an order conversion interface of the intermediate system is called and order information is converted based on the mapping relationship:
based on the trigger instruction, calling an order conversion interface of the intermediate system, and converting order information based on the mapping relation;
when uploading the converted order information to the target platform, the conversion module is specifically configured to:
and uploading the converted order information to a target platform through an order conversion interface.
Optionally, the apparatus further includes a first transceiver module and a second transceiver module;
before the acquisition module acquires each first metadata in the target platform, the first transceiver module is used for sending a verification information acquisition request to the target platform; the second transceiver module is used for receiving the verification information returned by the target platform;
the obtaining module is specifically configured to obtain each first metadata in the target platform
And acquiring each first metadata of the target platform based on the verification information.
In a third aspect of the present application, an electronic device is provided, including:
the electronic device comprises a memory and a processor;
the memory has a computer program stored therein;
a processor for performing the method of any of the first aspects when running the computer program.
In a fourth aspect of the present application, a computer-readable medium is provided, on which a computer program is stored, which program, when being executed by a processor, is adapted to carry out the method of any one of the first aspect.
The application has the following advantages:
the method can obtain the first metadata of the target platform, determine the one-to-one mapping relation between the first metadata and the second metadata in the ERP system, convert the order information based on the mapping relation when the order information which is created by a user in the ERP system and comprises at least one piece of second metadata is detected, and upload the converted order information to the target platform, so that the order information of the ERP system can be converted into the order information of the target platform, the system automatically converts the order information based on the mapping relation, the condition that data information of the same material between the two systems is inconsistent due to manual operation input errors is avoided, the accuracy of the input order information is improved, and the speed of inputting the order information is accelerated.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings used in the description of the embodiments of the present application will be briefly described below.
FIG. 1 is a schematic diagram of an embodiment of a data transformation method of an ERP system and a target platform according to the present application;
FIG. 2 is a schematic diagram of another embodiment of a data transformation method of the ERP system and the target platform according to the present application;
FIG. 3 is a schematic diagram of another embodiment of a data transformation method for an ERP system and a target platform according to the present application;
FIG. 4 is a schematic structural diagram of an ERP system and a data conversion device of a target platform according to the present application;
fig. 5 is a schematic structural diagram of an electronic device according to the present application.
Detailed Description
Reference will now be made in detail to the embodiments of the present application, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are exemplary only for the purpose of explaining the present application and are not to be construed as limiting the present application.
As used herein, the singular forms "a", "an" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms "comprises" and/or "comprising," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof. It will be understood that when an element is referred to as being "connected" or "coupled" to another element, it can be directly connected or coupled to the other element or intervening elements may also be present. Further, "connected" or "coupled" as used herein may include wirelessly connected or wirelessly coupled. As used herein, the term "and/or" includes all or any element and all combinations of one or more of the associated listed items.
To make the objects, technical solutions and advantages of the present application more clear, embodiments of the present application will be described in further detail below with reference to the accompanying drawings.
The following describes the technical solutions of the present application and how to solve the above technical problems with specific embodiments. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
Referring to fig. 1, the present application provides a data conversion method for an ERP system and a target platform, where the method may specifically include the data conversion system, and the method includes:
s101, acquiring each first metadata of a target platform;
step S102, determining a one-to-one mapping relation between each first metadata and each second metadata in the ERP system;
the target platform and the ERP system are two different service systems, a large amount of first metadata are maintained in the target platform, a large amount of second metadata are maintained in the ERP system, the same metadata can be interpreted differently in different systems, and order information is formed based on the metadata.
The data conversion system acquires each first metadata of the target platform, and establishes a one-to-one mapping relation between each first metadata and each second metadata in the ERP system, so that different definitions or explanations about the same metadata in the two systems are corresponded, specifically: for example, the metadata a is called as first metadata a1 in the target platform, and is called as second metadata a2 in the ERP system, a corresponding relationship between a1 and a2 needs to be established, and similarly, for other first metadata in the target platform, unique corresponding second metadata can be found in the ERP system to establish a mapping relationship.
And step S103, when order information which is created by a user in the ERP system and comprises at least one piece of second metadata is detected, converting the order information based on the mapping relation, and uploading the converted order information to a target platform.
The data conversion system detects order information created by a user in the ERP system, where the order information includes at least one piece of second metadata and specific data information corresponding to the second metadata, and a specific form of the order may be a form, a table, a diagram, and the like, and taking the order information as the form or the table as an example, the order information includes at least one piece of second metadata, and a specific numerical value input by the user in a control box corresponding to the second metadata for the second metadata, for example, the second metadata is a model, and the user inputs a specific model "xxx" in the corresponding control box.
The data conversion system can convert the definition of the metadata in the order information into the definition of the metadata maintained by the target platform based on the mapping relation, so that the order information of the ERP system can be converted into the order information of the target platform, and the converted order information is uploaded to the target platform, so that the conversion of the order information between the two systems is completed.
In this embodiment, for example, the data conversion system obtains the first metadata of the target platform and then converts the order information of the ERP system into the order information suitable for the target platform, and actually, the second metadata of the target platform may also be obtained and then the order information of the target platform may be converted into the order information suitable for the ERP system.
In the implementation, the first metadata of the target platform can be obtained, the one-to-one mapping relation between the first metadata and the second metadata in the ERP system is determined, so that when order information which is created by a user in the ERP system and comprises at least one piece of second metadata is detected, the order information can be converted based on the mapping relation, and the converted order information is uploaded to the target platform, so that the order information of the ERP system can be converted into the order information of the target platform, the order information is automatically converted by the system based on the mapping relation, the condition that data information of the same material between the two systems is inconsistent due to manual operation entry errors is avoided, the accuracy of the entered order information is improved, and the speed of entering the order information is accelerated.
In this implementation, to complete the conversion of the order information between the two systems, the conversion of the order format between the two systems is also completed, specifically:
optionally, the converting the order information based on the mapping relationship includes:
converting the at least one second metadata into at least one first metadata in one-to-one correspondence based on the mapping relation, and obtaining converted order information comprising the at least one first metadata;
uploading the converted order information to a target platform, comprising:
acquiring a format template of a target platform;
and uploading the converted order information to a target platform based on the format template.
In this embodiment, converting the definition of metadata in the order information into the definition of metadata maintained by the target platform based on the mapping relationship refers to: converting at least one second metadata in the order information into at least one first metadata corresponding to one another, wherein specific data information of the first metadata becomes data information corresponding to the corresponding second metadata, so that converted order information including at least one first metadata can be obtained, meanwhile, the converted order information further includes specific data information corresponding to the first metadata, for a form or a table, the specific data information corresponding to the first metadata is a specific numerical value for the first metadata in a control box corresponding to the first metadata, and the specific data information of the first metadata is the same as the specific data information of the corresponding second metadata.
The data conversion system also needs to acquire a format template of the target platform, that is, an order format supported by the target platform, and adjust the converted order information into order information conforming to the format supported by the target platform, so as to upload the order information with the adjusted format to the target platform.
In the embodiment of the application, the conversion of the order information can be completed by modifying the ERP system, but the method needs to depend on a developer of the ERP system, some ERP systems can find the developer for secondary development, the difficulty is high, and even some ERP systems cannot carry out secondary development. Therefore, the method can add an intermediate system (or a docking system) which can directly access the ERP database.
Optionally, the data conversion system is any one of an ERP system and an intermediate system;
and the intermediate system establishes communication connection with the ERP system, and establishes communication connection with the target platform.
In this embodiment, if the data conversion system is an ERP system, the ERP system may complete the conversion of the order information between the two systems by performing the steps of the embodiment and the alternative embodiment of fig. 1; if the data conversion system is an intermediate system, the intermediate system is a system that establishes communication connection with both the ERP system and the target platform, the same intermediate system may also complete the conversion of the order information between the two systems by executing the steps of the embodiment and the optional embodiment of fig. 1, and the completing of the conversion of the order information by using the intermediate system specifically calls an order conversion interface of the intermediate system to complete the conversion of the order information, specifically:
optionally, if the data synchronization system is an intermediate system;
converting the order information based on the mapping relation, including:
and calling an order conversion interface of the intermediate system, and converting the order information based on the mapping relation.
Optionally, a trigger is set in the ERP system, and detecting order information created by a user in the ERP system includes:
when a trigger instruction sent by a trigger is received, determining that a user creates order information in an ERP system;
calling an order conversion interface of the intermediate system, and converting order information based on the mapping relation, wherein the conversion comprises the following steps:
based on the trigger instruction, calling an order conversion interface of the intermediate system, and converting order information based on the mapping relation;
uploading the converted order information to a target platform, comprising:
and uploading the converted order information to a target platform through an order conversion interface.
In this embodiment, the ERP system is provided with a trigger, when the ERP system receives an operation of a user to newly create an order in the ERP system, the trigger enters a working state, and the trigger sends a trigger instruction to the intermediate system, so that an order conversion interface of the intermediate system is called to convert order information based on the mapping relationship, and the intermediate system also uploads the converted order information to the target platform through the order conversion interface.
In the implementation, the order information can be converted through the order conversion interface of the intermediate system, so that the order information can be converted without secondary development of the ERP system, and the difficulty in realizing the order information conversion is reduced.
Optionally, before acquiring each first metadata in the target platform, the method further includes:
sending a verification information acquisition request to a target platform;
receiving verification information returned by the target platform;
obtaining first metadata in the target platform, including
And acquiring each first metadata of the target platform based on the verification information.
In this embodiment, the data conversion system may call an interface provided by the target platform to send a verification information obtaining request, so as to obtain verification information returned by the target platform, where the verification information may be a token (token) or a key, and the data conversion system sends the verification information to the target platform for verification, so as to obtain each first metadata of the target platform.
The method can be applied to the scene of centralized purchasing of medical consumables, the target platform can be a centralized bidding purchasing platform (short for: a centralized acquisition platform) in the medical field, and for the scheme that the data conversion system is an ERP system, please refer to FIG. 2, and the whole process of the scheme is explained:
the method comprises the steps that an ERP system requests an acquisition platform to acquire a token, the acquisition platform returns the token, the ERP system sends the token to the acquisition platform for verification so as to acquire acquisition materials (namely first metadata of the acquisition platform), the ERP system receives the acquisition materials returned by the acquisition platform and stores the acquisition materials in a database of the ERP system (namely the ERP database), the ERP system establishes a material mapping relation (namely a one-to-one mapping relation of the first metadata and the second metadata) by receiving an instruction of a manager, when the ERP system detects an order newly built by a user, the order can be converted into an acquisition order suitable for the acquisition platform based on the mapping relation, the converted order is uploaded to the acquisition platform, and the acquisition platform uploads a result to the ERP system.
For the solution that the data conversion system is a docking system, please refer to fig. 3, the overall process of the solution is described:
the docking system requests the acquisition platform to acquire the token, the acquisition platform returns the token, the docking system sends the token to the acquisition platform for verification to obtain acquisition materials (i.e. the first metadata of the acquisition platform), the docking system receives the collected materials returned by the collection platform, and stores the collected materials in an ERP database, the docking system receives an instruction of a manager to establish a material mapping relationship (i.e. a one-to-one mapping relationship between the first metadata and the second metadata), when the ERP system detects a newly-built order from a user, the trigger of the ERP system enters a working state, the trigger sends a trigger instruction to an order conversion interface of the docking system, the order conversion interface can convert the order into an acquisition order suitable for the acquisition platform based on the mapping relation, the order conversion interface uploads the converted order to the collection platform, and the collection platform returns an uploading result to the docking system.
Fig. 1 to fig. 3 describe a data conversion method of an ERP system and a target platform provided in the present application, and the present application further provides a data conversion apparatus of an ERP system and a target platform, please refer to fig. 4, where the apparatus includes:
an obtaining module 401, configured to obtain each first metadata of the target platform;
a determining module 402, configured to determine a one-to-one mapping relationship between each first metadata and each second metadata in the ERP system;
the conversion module 403 is configured to, when detecting that the order information that is created by the user in the ERP system and includes at least one piece of second metadata, convert the order information based on the mapping relationship, and upload the converted order information to the target platform.
Optionally, when the conversion module 403 converts the order information based on the mapping relationship, it is specifically configured to:
converting the at least one second metadata into at least one first metadata corresponding to one another on the basis of the mapping relation, and obtaining converted order information comprising the at least one first metadata;
when uploading the converted order information to the target platform, the conversion module 403 is specifically configured to:
acquiring a format template of a target platform;
and uploading the converted order information to a target platform based on the format template.
Optionally, the data conversion system is any one of an ERP system and an intermediate system;
and the intermediate system establishes communication connection with the ERP system, and establishes communication connection with the target platform.
Optionally, if the data synchronization system is an intermediate system;
when converting the order information based on the mapping relationship, the converting module 403 is specifically configured to:
and calling an order conversion interface of the intermediate system, and converting the order information based on the mapping relation.
Optionally, a trigger is set in the ERP system, and when detecting order information created by the user in the ERP system, the conversion module 403 is specifically configured to:
when a trigger instruction sent by a trigger is received, determining that a user creates order information in an ERP system;
when the conversion module 403 invokes the order conversion interface of the intermediate system and converts the order information based on the mapping relationship, it is specifically configured to:
based on the trigger instruction, calling an order conversion interface of the intermediate system, and converting order information based on the mapping relation;
when uploading the converted order information to the target platform, the conversion module 403 is specifically configured to:
and uploading the converted order information to a target platform through an order conversion interface.
Optionally, the apparatus further includes a first transceiver module and a second transceiver module;
before the obtaining module 401 obtains each first metadata in the target platform, the first transceiver module is configured to send a verification information obtaining request to the target platform; the second transceiver module is used for receiving the verification information returned by the target platform;
the obtaining module 401 is specifically configured to obtain each first metadata in the target platform
And acquiring each first metadata of the target platform based on the verification information.
Since the apparatus provided in the embodiments of the present application is an apparatus capable of executing the corresponding method in the embodiments of the present application, a specific implementation manner of the apparatus provided in the embodiments of the present application and various modifications thereof can be known to those skilled in the art based on the method provided in the embodiments of the present application, and therefore, a detailed description of how to implement the method in the embodiments of the present application by the apparatus is not provided herein. The apparatus used by those skilled in the art to implement the method in the embodiments of the present application is within the scope of the present application.
Based on the same principle as the method provided by the embodiment of the present application, the embodiment of the present application also provides an electronic device, which includes a memory and a processor; the memory has a computer program stored therein; the processor is adapted to perform the method provided in any of the alternative embodiments of the present application when executing the computer program.
Embodiments of the present application further provide a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the computer program can implement the method provided in any optional embodiment of the present application.
As an example, fig. 5 shows a schematic structural diagram of an electronic device to which the present application may be applied, where the electronic device may specifically be the data conversion system described above, and may also be another device, the electronic device 8000 includes a memory 8003 and a processor 8001, the memory 8003 stores a computer program, and the processor 8001 is configured to execute any one of the methods described above when the computer program is executed. In particular, fig. 5 shows only an alternative schematic structure of the electronic device. The structure of the electronic device 8000 shown in fig. 5 is not limited to the embodiment of the present application.
Processor 8001 is coupled to memory 8003, such as via bus 8002. Optionally, the electronic device 8000 may also include a transceiver 8004. It should be noted that the transceiver 8004 is not limited to one in practical applications, and the transceiver 8004 may be specifically used for communication between the electronic device 8000 and other devices.
Processor 8001 may be a CPU (Central Processing Unit), general purpose Processor, DSP (Digital Signal Processor), ASIC
An Application Specific Integrated Circuit (asic), an FPGA (field programmable Gate Array) or other programmable logic device, a transistor logic device, a hardware component, or any combination thereof. Which may implement or perform the various illustrative logical blocks, modules, and circuits described in connection with the disclosure of the present application. Processor 8001 may also be a combination that implements computing functionality, e.g., comprising one or more microprocessor combinations, DSP and microprocessor combinations, and so forth.
Bus 8002 may include a path to transfer information between the aforementioned components. The bus 8002 may be a PCI (Peripheral Component Interconnect) bus, an EISA (extended industry Standard Architecture) bus, or the like. The bus 8002 may be divided into an address bus, a data bus, a control bus, and the like. For ease of illustration, only one thick line is shown in FIG. 5, but this is not intended to represent only one bus or type of bus.
The Memory 8003 may be a ROM (Read Only Memory) or other type of static storage device that can store static information and instructions, a RAM (Random Access Memory) or other type of dynamic storage device that can store information and instructions, an EEPROM (Electrically erasable programmable Read Only Memory), a CD-ROM (Compact Read Only Memory) or other optical disk storage, optical disk storage (including Compact disk, laser disk, optical disk, digital versatile disk, blu-ray disk, etc.), a magnetic disk storage medium or other magnetic storage device, or any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a computer, but is not limited to this.
The memory 8003 is used for storing application program codes for executing the scheme of the present application, and the execution is controlled by the processor 8001. Processor 8001 is configured to execute application program code stored in memory 8003 to implement what is shown in any of the method embodiments above.
It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and may be performed in other orders unless explicitly stated herein. Moreover, at least a portion of the steps in the flow chart of the figure may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed alternately or alternately with other steps or at least a portion of the sub-steps or stages of other steps.
The foregoing is only a partial embodiment of the present application, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present application, and these modifications and decorations should also be regarded as the protection scope of the present application.

Claims (10)

1. A data transformation method for an ERP system and a target platform, the method being performed by a data transformation system, the method comprising:
acquiring first metadata of a target platform;
determining a one-to-one mapping relation between each first metadata and each second metadata in the ERP system;
and when order information which is created by a user in the ERP system and comprises at least one piece of second metadata is detected, converting the order information based on the mapping relation, and uploading the converted order information to the target platform.
2. The method of claim 1, wherein converting the order information based on the mapping comprises:
converting the at least one second metadata into at least one first metadata in one-to-one correspondence based on the mapping relation, so as to obtain the converted order information including the at least one first metadata;
the uploading the converted order information to the target platform includes:
acquiring a format template of a target platform;
and uploading the converted order information to the target platform based on the format template.
3. The method according to claim 1 or 2, wherein the data conversion system is any one of an ERP system and an intermediate system;
and the intermediate system establishes communication connection with the ERP system, and establishes communication connection with the target platform.
4. The method of claim 3, wherein if the data synchronization system is an intermediate system;
converting the order information based on the mapping relationship, including:
and calling an order conversion interface of the intermediate system, and converting the order information based on the mapping relation.
5. The method according to claim 4, wherein a trigger is set in the ERP system, and the detecting the order information created by the user in the ERP system comprises:
when a trigger instruction sent by the trigger is received, determining that the user creates order information in an ERP system;
the step of calling an order conversion interface of the intermediate system and converting the order information based on the mapping relation comprises the following steps:
based on the trigger instruction, calling an order conversion interface of the intermediate system, and converting the order information based on the mapping relation;
the uploading the converted order information to the target platform includes:
and uploading the converted order information to the target platform through the order conversion interface.
6. The method of any of claims 1 to 5, wherein prior to obtaining the respective first metadata in the target platform, the method further comprises:
sending a verification information acquisition request to the target platform;
receiving verification information returned by the target platform;
the obtaining of each first metadata in the target platform comprises
And acquiring each first metadata of the target platform based on the verification information.
7. A data conversion apparatus for an ERP system and a target platform, the apparatus comprising:
the acquisition module is used for acquiring each first metadata of the target platform;
the determining module is used for determining a one-to-one mapping relation between each first metadata and each second metadata in the ERP system;
and the conversion module is used for converting the order information based on the mapping relation and uploading the converted order information to the target platform when the order information which is created by the ERP system and comprises at least one piece of second metadata by a user is detected.
8. The apparatus according to claim 7, wherein the conversion module, when converting the order information based on the mapping relationship, is specifically configured to:
converting the at least one second metadata into at least one first metadata in one-to-one correspondence based on the mapping relationship to obtain the converted order information including the at least one first metadata;
when uploading the converted order information to the target platform, the conversion module is specifically configured to:
acquiring a format template of a target platform;
and uploading the converted order information to the target platform based on the format template.
9. An electronic device, comprising:
the electronic device comprises a memory and a processor;
the memory has stored therein a computer program;
the processor, when running the computer program, is configured to perform the method of any of claims 1-6.
10. A computer-readable medium, on which a computer program is stored which, when being executed by a processor, carries out the method of any one of claims 1 to 6.
CN201911219101.7A 2019-12-03 2019-12-03 Data conversion method and device for ERP system and target platform and electronic device Active CN110955715B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911219101.7A CN110955715B (en) 2019-12-03 2019-12-03 Data conversion method and device for ERP system and target platform and electronic device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911219101.7A CN110955715B (en) 2019-12-03 2019-12-03 Data conversion method and device for ERP system and target platform and electronic device

Publications (2)

Publication Number Publication Date
CN110955715A true CN110955715A (en) 2020-04-03
CN110955715B CN110955715B (en) 2023-04-28

Family

ID=69979551

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911219101.7A Active CN110955715B (en) 2019-12-03 2019-12-03 Data conversion method and device for ERP system and target platform and electronic device

Country Status (1)

Country Link
CN (1) CN110955715B (en)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111914011A (en) * 2020-08-06 2020-11-10 上海智众医疗科技有限公司 Cross-platform data conversion method and system
CN112347177A (en) * 2020-11-11 2021-02-09 天津汇商共达科技有限责任公司 Data docking equipment based on human-computer interaction behavior
CN112347176A (en) * 2020-11-11 2021-02-09 天津汇商共达科技有限责任公司 Data docking method and device based on human-computer interaction behavior
CN112506958A (en) * 2020-11-18 2021-03-16 青岛海尔科技有限公司 Information processing method, information processing apparatus, storage medium, and electronic apparatus
CN112686623A (en) * 2020-12-23 2021-04-20 云汉芯城（上海）互联网科技股份有限公司 Product information management method, system and computer storage medium
CN115883648A (en) * 2021-08-09 2023-03-31 中移物联网有限公司 Data integration method, device, equipment and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103778154A (en) * 2012-10-24 2014-05-07 金蝶软件（中国）有限公司 Form property reverse writing method and device
WO2017021186A1 (en) * 2015-08-03 2017-02-09 Philip Morris Products S.A. A computerized database management system
CN106408222A (en) * 2016-11-29 2017-02-15 用友网络科技股份有限公司 Apparatus and method for realizing docking of platform
CN106709697A (en) * 2016-11-29 2017-05-24 用友网络科技股份有限公司 ERP system form data conversion method and conversion system

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103778154A (en) * 2012-10-24 2014-05-07 金蝶软件（中国）有限公司 Form property reverse writing method and device
WO2017021186A1 (en) * 2015-08-03 2017-02-09 Philip Morris Products S.A. A computerized database management system
CN106408222A (en) * 2016-11-29 2017-02-15 用友网络科技股份有限公司 Apparatus and method for realizing docking of platform
CN106709697A (en) * 2016-11-29 2017-05-24 用友网络科技股份有限公司 ERP system form data conversion method and conversion system

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111914011A (en) * 2020-08-06 2020-11-10 上海智众医疗科技有限公司 Cross-platform data conversion method and system
CN112347177A (en) * 2020-11-11 2021-02-09 天津汇商共达科技有限责任公司 Data docking equipment based on human-computer interaction behavior
CN112347176A (en) * 2020-11-11 2021-02-09 天津汇商共达科技有限责任公司 Data docking method and device based on human-computer interaction behavior
CN112506958A (en) * 2020-11-18 2021-03-16 青岛海尔科技有限公司 Information processing method, information processing apparatus, storage medium, and electronic apparatus
CN112686623A (en) * 2020-12-23 2021-04-20 云汉芯城（上海）互联网科技股份有限公司 Product information management method, system and computer storage medium
CN115883648A (en) * 2021-08-09 2023-03-31 中移物联网有限公司 Data integration method, device, equipment and storage medium

Also Published As

Publication number Publication date
CN110955715B (en) 2023-04-28

Similar Documents

Publication Publication Date Title
CN110955715A (en) ERP system, data conversion method and device of target platform and electronic equipment
US20170351723A1 (en) Managing data format of data received from devices in an internet of things network
CN103714129A (en) Device and method for buildingg dynamic data structures and relationships based on condition rules
US20110145308A1 (en) System to improve numereical conversions and associated methods
CN111026063A (en) Digital twin construction method and device, computer equipment and storage medium
CN114116065B (en) Method and device for acquiring topological graph data object and electronic equipment
CN110990048A (en) Method and system for monitoring resource loss of Unity project
CN111596927B (en) Service deployment method and device and electronic equipment
CN107133233B (en) Processing method and device for configuration data query
CN114564294A (en) Intelligent service arranging method and device, computer equipment and storage medium
CN112631751A (en) Task scheduling method and device, computer equipment and storage medium
CN111324470B (en) Method and device for generating information
CN113485697A (en) Model construction operation service method and system under artificial intelligence framework
CN108763127B (en) Method for realizing Modbus adapter capable of realizing interconversion of source data and target data
CN103914304B (en) Method for converting different structure type parameters on basis of SAP (service access point) platforms
CN110019538A (en) A kind of tables of data switching method and device
CN114925105A (en) Method for making number of insurance business and related equipment
CN114925120A (en) Insurance business information query method and related equipment
US11327471B2 (en) Building and tracking of an automation engineering environment
US20170286181A1 (en) Deployment and execution of sensing and computational tasks in a network of computing devices
CN113515271A (en) Service code generation method and device, electronic equipment and readable storage medium
CN107368321B (en) Software version evolution method and system
CN111262727A (en) Service capacity expansion method, device, equipment and storage medium
CN116560722B (en) Operation and maintenance flow processing method and device, electronic equipment and storage medium
CN112506944B (en) Data standard conversion access method, device, equipment and medium between service systems

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant