CN110955715B - Data conversion method and device for ERP system and target platform and electronic device - Google Patents

Data conversion method and device for ERP system and target platform and electronic device Download PDF

Info

Publication number
CN110955715B
CN110955715B CN201911219101.7A CN201911219101A CN110955715B CN 110955715 B CN110955715 B CN 110955715B CN 201911219101 A CN201911219101 A CN 201911219101A CN 110955715 B CN110955715 B CN 110955715B
Authority
CN
China
Prior art keywords
order information
target platform
metadata
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.)
Active
Application number
CN201911219101.7A
Other languages
Chinese (zh)
Other versions
CN110955715A (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

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management
    • YGENERAL 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
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Entrepreneurship & Innovation (AREA)
  • General Physics & Mathematics (AREA)
  • Operations Research (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Quality & Reliability (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • General Engineering & Computer Science (AREA)
  • Information Transfer Between Computers (AREA)

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; when order information, which is created by the ERP system and comprises at least one second metadata, of a user is detected, the order information is converted based on the mapping relation, and the converted order information is uploaded to a target platform. The method and the device can improve the accuracy of the entered order information.

Description

Data conversion method and device for ERP system and target platform and electronic device
Technical Field
The application relates to the technical field of computers, in particular to a data conversion method and device for an ERP system and a target platform and electronic equipment.
Background
An enterprise resource planning system (Enterprise Resource Planning, ERP) is a management platform that provides a decision-making means for an enterprise with a systematic management concept that integrates customer needs with manufacturing activities within the enterprise and manufacturing resources of suppliers to form a complete supply chain for the enterprise.
In daily life, the same order is often required to be established in an ERP system and other systems when finishing a purchasing process, and because the two systems are mutually independent, the purchasing order is required to be recorded in the two systems, so that labor is wasted, data information of the same material between the two systems is inconsistent due to easy recording errors, and finally, the accuracy of recording the order information is low.
Disclosure of Invention
In order to solve at least one of the problems in the prior art, the embodiment of the application provides a data conversion method, a data conversion device and electronic equipment of an ERP system and a target platform, and the technical scheme provided by the embodiment of the application is as follows:
a first aspect of the present application provides a data conversion method of an ERP system and a target platform, the method being performed by the data conversion 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;
when order information, which is created by the ERP system and comprises at least one second metadata, of a user is detected, the order information is converted based on the mapping relation, and the converted order information is uploaded to a target platform.
A second aspect of the present application provides a data conversion device of 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;
the conversion module is used for converting the order information based on the mapping relation when detecting the order information which is created by the ERP system and comprises at least one second metadata, and uploading the converted order information to the target platform.
Optionally, the conversion module is specifically configured to, when converting order information based on the mapping relationship:
converting the at least one second metadata into at least one first metadata corresponding to one by one based on the mapping relation to obtain converted order information comprising the at least one first metadata;
the conversion module is specifically configured to, when uploading the converted order information to the target platform:
obtaining 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;
the intermediate system establishes communication connection with the ERP system, and the intermediate system establishes communication connection with the target platform.
Optionally, if the data synchronization system is an intermediate system;
the conversion module is specifically configured to, when converting order information based on a mapping relationship:
and calling an order conversion interface of the intermediate system, and converting order information based on the mapping relation.
Optionally, a trigger is set in the ERP system, and the conversion module is specifically configured to, when detecting order information created by a user in the ERP system:
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 used for converting order information based on a mapping relation when calling an order conversion interface of the intermediate system:
calling an order conversion interface of the intermediate system based on the trigger instruction, and converting order information based on the mapping relation;
the conversion module is specifically configured to, when uploading the converted order information to the target platform:
and uploading the converted order information to a target platform through an order conversion interface.
Optionally, the device further comprises a first transceiver module and a second transceiver module;
the acquisition module is used for transmitting a verification information acquisition request to the target platform before acquiring each first metadata in the target platform; the second transceiver module is used for receiving verification information returned by the target platform;
the acquisition module is specifically configured to, when acquiring each first metadata in the target platform
Based on the verification information, each first metadata of the target platform is obtained.
In a third aspect of the present application, there is provided an electronic device, including:
the electronic device includes a memory and a processor;
a memory having a computer program stored therein;
a processor for performing the method of any of the first aspects when the computer program is run.
In a fourth aspect of the present application, there is provided a computer readable medium having stored thereon a computer program which, when executed by a processor, is capable of performing the method of any of the first aspects.
The application has the following advantages:
the method and the system can acquire the first metadata of the target platform, and determine the one-to-one mapping relation between the first metadata and the second metadata in the ERP system, so that when the order information comprising at least one second metadata, which is created by a user in the ERP system, 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 conversion of the order information is automatically carried out by the system based on the mapping relation, the condition that the 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 meanwhile, 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 that are required to be used in the description of the embodiments of the present application will be briefly described below.
FIG. 1 is a schematic diagram of one embodiment of a data conversion method of an ERP system and a target platform of the present application;
FIG. 2 is a schematic diagram of another embodiment of a data conversion method of the ERP system and target platform of the present application;
FIG. 3 is a schematic diagram of another embodiment of a data conversion method of the ERP system and target platform of the present application;
FIG. 4 is a schematic structural diagram of a data conversion device of the ERP system and the target platform of the present application;
fig. 5 is a schematic structural diagram of the electronic device of the present application.
Detailed Description
Embodiments of the present application are described in detail below, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to like or similar elements or elements having like or similar functions throughout. The embodiments described below by referring to the drawings are exemplary only for the purpose of illustrating 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 expressly stated otherwise, as understood by those skilled in the art. 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. The term "and/or" as used herein includes all or any element and all combination of one or more of the associated listed items.
For the purpose of making the objects, technical solutions and advantages of the present application more apparent, the 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 the technical solutions of the present application solve the above technical problems in detail with specific embodiments. The following embodiments may be combined with each other, and the same or similar concepts or processes may not be described in detail 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 of an ERP system and a target platform, where the method specifically includes:
step S101, acquiring 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 is maintained in the target platform, a large amount of second metadata is maintained in the ERP system, the same metadata can be interpreted differently in different systems, order information is formed based on the metadata, and the purpose of the application is to realize conversion of the order information between the two systems.
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 interpretations of the same metadata in the two systems are corresponding, and the method is specific: for example, the metadata a is called first metadata A1 in the target platform and called second metadata A2 in the ERP system, the corresponding relationship between A1 and A2 needs to be established, and similarly, for other first metadata in the target platform, the unique corresponding second metadata can also be found in the ERP system so as to establish the mapping relationship.
Step S103, converting the order information based on the mapping relation when the order information including at least one second metadata, which is created by the ERP system, is detected, and uploading the converted order information to the target platform.
The data conversion system detects order information created by a user in the ERP system, the order information comprises at least one second metadata and specific data information corresponding to the second metadata, the specific form of the order can be a form, a table, a chart and the like, the order information is taken as a form or a table as an example, the order information comprises at least one second metadata, and specific numerical values input by the user in a control box corresponding to the second metadata aiming at the second metadata, for example, the second metadata is a model, the user inputs specific model "xxx" in the corresponding control box, and it can be understood that the second metadata in the order information are different based on different orders required to be established by the user.
The data conversion system can convert the definition of metadata in the order information into the definition of 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, thereby completing the conversion of the order information between the two systems.
In this embodiment, taking the example that 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 applicable to the target platform, actually, the second metadata of the target platform may also be obtained and then convert the order information of the target platform into the order information applicable to the ERP system, and the implementation principle of the scheme is the same, which can be understood that the scheme shown in the embodiment of the present application may be applicable as long as the order information of one system is converted into the order information of another system.
In the implementation, each first metadata of the target platform can be acquired, and a one-to-one mapping relation between each first metadata and each second metadata in the ERP system is determined, so that when order information comprising at least one second metadata, which is created by a user in the ERP system, 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 conversion of the order information is automatically performed by the system based on the mapping relation, the condition that the 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 meanwhile, the speed of inputting the order information is accelerated.
In this embodiment, to complete the conversion of the order information between two systems, the conversion of the order format between two systems is also completed, specifically:
optionally, converting the order information based on the mapping relationship includes:
converting the at least one second metadata into at least one first metadata corresponding to one by one based on the mapping relation to obtain converted order information comprising the at least one first metadata;
uploading the converted order information to a target platform, including:
obtaining 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 order information into the definition of metadata maintained by the target platform based on the mapping relationship refers to: at least one second metadata in the order information is converted into at least one first metadata corresponding to one by one, the specific data information of the first metadata is changed into the data information corresponding to the corresponding second metadata, so that the converted order information comprising the at least one first metadata can be obtained, meanwhile, the converted order information also comprises the specific data information corresponding to the first metadata, and for a form or a table, the specific data information corresponding to the first metadata is 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 identical with the specific data information of the corresponding second metadata.
The data conversion system also needs to acquire a format template of the target platform, namely 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 that the order information with the adjusted format is uploaded to the target platform.
In the embodiment of the application, the conversion of order information can be completed by modifying the ERP system, but the mode needs to depend on developers of the ERP system, and some ERP systems can also find out the developers to perform secondary development, so that the difficulty is high, and even some ERP systems cannot perform secondary development. Thus, the present application may add an intermediate system (or docking system) that may directly access the ERP database.
Optionally, the data conversion system is any one of an ERP system and an intermediate system;
the intermediate system establishes communication connection with the ERP system, and the intermediate system establishes communication connection with the target platform.
In this embodiment, if the data conversion system is an ERP system, the ERP system may complete conversion of order information between two systems by executing the steps of the embodiment and the alternative embodiment described in fig. 1; if the data conversion system is an intermediate system, the intermediate system is a system which establishes communication connection with both the ERP system and the target platform, and the same intermediate system can also complete conversion of order information between two systems by executing the steps of the embodiment and the alternative embodiment of fig. 1, and the intermediate system is used for completing conversion of order information, specifically, calling an order conversion interface of the intermediate system to complete conversion of order information, specifically:
optionally, if the data synchronization system is an intermediate system;
converting order information based on the mapping relationship, including:
and calling an order conversion interface of the intermediate system, and converting order information based on the mapping relation.
Optionally, a trigger is set in the ERP system, and detecting order information created by the 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 to convert order information based on the mapping relation, wherein the method comprises the following steps:
calling an order conversion interface of the intermediate system based on the trigger instruction, and converting order information based on the mapping relation;
uploading the converted order information to a target platform, including:
and uploading the converted order information to a target platform through an order conversion interface.
In this embodiment, a trigger is provided in the ERP system, and when the ERP system receives an operation of a user to newly build an order in the ERP system, the trigger enters a working state, and the trigger sends a trigger instruction to an intermediate system, so that an order conversion interface of the intermediate system is invoked to convert order information based on the mapping relationship, and the intermediate system also uploads the converted order information to a 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 conversion of the order information can be completed without secondary development of the ERP system, and the difficulty in realizing the conversion of the order information is reduced.
Optionally, before each first metadata in the target platform is acquired, the method further includes:
sending a verification information acquisition request to a target platform;
receiving verification information returned by a target platform;
acquiring first metadata in a target platform, including
Based on the verification information, each first metadata of the target platform is obtained.
In this embodiment, the data conversion system may invoke 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 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 and the device can be applied to the scene of centralized purchase of medical consumables, the target platform can be a centralized bidding purchase platform (called as a centralized collection platform for short) in the medical field, and for the scheme that the data conversion system is an ERP system, please refer to FIG. 2 for explaining the whole process of the scheme:
the ERP system requests to acquire the token from the collection platform, the collection platform returns the token, the ERP system sends the token to the collection platform for verification so as to acquire collection materials (namely, all first metadata of the collection platform), the ERP system receives the collection materials returned by the collection platform and stores the collection materials in a database (namely, the ERP database) of the ERP system, the ERP system establishes a material mapping relation (namely, one-to-one mapping relation of the first metadata and the second metadata) by receiving instructions of a manager, and when the ERP system detects an order newly established by a user, the ERP system can convert the order into a collection order suitable for the collection platform based on the mapping relation and upload the converted order to the collection platform, and the collection platform returns an uploading result to the ERP system.
For a scheme in which the data conversion system is a docking system, please refer to fig. 3, the overall process of the scheme will be described:
the docking system requests to acquire the token from the collection platform, the collection platform returns the token, the docking system sends the token to the collection platform for verification so as to acquire collection materials (namely, each first metadata of the collection platform), the docking system receives the collection materials returned by the collection platform and stores the collection materials in the ERP database, the docking system receives instructions of management personnel to establish a material mapping relation (namely, a one-to-one mapping relation of the first metadata and the second metadata), when the ERP system detects an order newly established by a user, a 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 a collection order suitable for the collection platform based on the mapping relation, the order converted by the order conversion interface is uploaded to the collection platform, and the collection platform returns an uploading result to the docking system.
Fig. 1 to fig. 3 above introduce 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 device of an ERP system and a target platform, referring to fig. 4, where the device 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;
and the conversion module 403 is configured to, when detecting order information including at least one second metadata created by the ERP system, convert the order information based on the mapping relationship, and upload the converted order information to the target platform.
Optionally, the conversion module 403 is specifically configured to, when converting order information based on the mapping relationship:
converting the at least one second metadata into at least one first metadata corresponding to one by one based on the mapping relation to obtain converted order information comprising the at least one first metadata;
the conversion module 403 is specifically configured to, when uploading the converted order information to the target platform:
obtaining 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;
the intermediate system establishes communication connection with the ERP system, and the intermediate system establishes communication connection with the target platform.
Optionally, if the data synchronization system is an intermediate system;
the conversion module 403 is specifically configured to, when converting order information based on the mapping relationship:
and calling an order conversion interface of the intermediate system, and converting order information based on the mapping relation.
Optionally, a trigger is set in the ERP system, and the conversion module 403 is specifically configured to, when detecting order information created by a user in the ERP system:
when a trigger instruction sent by a trigger is received, determining that a user creates order information in an ERP system;
the conversion module 403 is specifically configured to, when calling an order conversion interface of the intermediate system and converting order information based on the mapping relationship:
calling an order conversion interface of the intermediate system based on the trigger instruction, and converting order information based on the mapping relation;
the conversion module 403 is specifically configured to, when uploading the converted order information to the target platform:
and uploading the converted order information to a target platform through an order conversion interface.
Optionally, the device further comprises a first transceiver module and a second transceiver module;
the acquiring module 401 is configured to, before acquiring each first metadata in the target platform, send a verification information acquiring request to the target platform; the second transceiver module is used for receiving verification information returned by the target platform;
the obtaining module 401 is specifically configured to, when obtaining each first metadata in the target platform
Based on the verification information, each first metadata of the target platform is obtained.
Since the apparatus provided in the embodiments of the present application is an apparatus capable of performing the corresponding method in the embodiments of the present application, based on the method provided in the embodiments of the present application, a person skilled in the art can understand the specific implementation of the apparatus in the embodiments of the present application and various modifications thereof, so how the apparatus implements the method in the embodiments of the present application will not be described in detail herein. The means employed by those skilled in the art to practice the methods of the embodiments of the present application are within the intended scope of the present application.
Based on the same principle as the method provided by the embodiment of the application, the embodiment of the application also provides electronic equipment, which comprises a memory and a processor; a memory having a computer program stored therein; the processor is configured to perform the methods provided in any of the alternative embodiments of the present application when the computer program is run.
Embodiments of the present application also provide a computer readable storage medium having a computer program stored thereon, which when executed by a processor, can implement a method provided in any of the alternative embodiments 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, or may be another device, and the electronic device 8000 includes a memory 8003 and a processor 8001, where 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. Specifically, 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 limiting to the embodiments of the present application.
Processor 8001 is coupled to memory 8003, such as via bus 8002. Optionally, electronic device 8000 may also include a transceiver 8004. In practice, the transceiver 8004 is not limited to one, and the transceiver 8004 may be specifically used for the electronic device 8000 to communicate with other devices.
The processor 8001 may be a CPU (Central Processing Unit ), general purpose processor, DSP (Digital Signal Processor, data Signal processor), ASIC
(Application Specific Integrated Circuit ), FPGA (Field Programmable Gate Array, field programmable gate array) or other programmable logic device, transistor logic device, hardware components, or any combination thereof. Which may implement or perform the various exemplary logic blocks, modules and circuits described in connection with the subject application. The processor 8001 may also be a combination that implements computing functionality, e.g., comprising one or more microprocessor combinations, a combination of DSP and microprocessor, etc.
Bus 8002 may include a path to transfer information between the components. Bus 8002 may be a PCI (Peripheral Component Interconnect, peripheral component interconnect standard) bus or an EISA (Extended Industry Standard Architecture ) bus, etc. 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 not only one bus or one type of bus.
Memory 8003 may be, but is not limited to, ROM (Read Only Memory) or other type of static storage device that can store static information and instructions, RAM (Random Access Memory ) or other type of dynamic storage device that can store information and instructions, EEPROM (Electrically Erasable Programmable Read Only Memory ), CD-ROM (Compact Disc Read Only Memory, compact disc Read Only Memory) or other optical disk storage, optical disk storage (including compact discs, laser discs, optical discs, digital versatile discs, blu-ray discs, etc.), magnetic disk storage media or other magnetic storage devices, 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.
The memory 8003 is used to store application code for executing the present application and is controlled by the processor 8001 to execute. Processor 8001 is used to execute application 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, these steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited in order and may be performed in other orders, unless explicitly stated herein. Moreover, at least some of the steps in the flowcharts of the figures may include a plurality of sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, the order of their execution not necessarily being sequential, but may be performed in turn or alternately with other steps or at least a portion of the other steps or stages.
The foregoing is only a partial embodiment of the present application and it should be noted that, for a person skilled in the art, several improvements and modifications can be made without departing from the principle of the present application, and these improvements and modifications should also be considered as the protection scope of the present application.

Claims (7)

1. A method of data conversion for an ERP system and a target platform, the method performed by a data conversion 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;
when order information, which is created by a user in an 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;
the data conversion system is any one of an ERP system and an intermediate system;
the intermediate system establishes communication connection with the ERP system, and establishes communication connection with the target platform;
if the data synchronization system is an intermediate system;
converting the order information based on the mapping relationship, including:
calling an order conversion interface of an intermediate system, and converting the order information based on the mapping relation;
the ERP system is provided with a trigger, and the detection of the order information created by the user in the ERP system comprises the following steps:
when a trigger instruction sent by the trigger is received, determining that the user creates order information in an ERP system;
the order conversion interface of the calling intermediate system converts the order information based on the mapping relation, and the method comprises the following steps:
based on the trigger instruction, calling an order conversion interface of an intermediate system, and converting the order information based on the mapping relation;
the uploading the converted order information to the target platform comprises the following steps:
and uploading the converted order information to the target platform through the order conversion interface.
2. The method of claim 1, wherein converting the order information based on the mapping relationship comprises:
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 the converted order information comprising the at least one first metadata;
the uploading the converted order information to the target platform comprises the following steps:
obtaining 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 any one of claims 1 to 2, wherein prior to the obtaining each 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;
each first metadata in the target platform comprises
And acquiring each first metadata of the target platform based on the verification information.
4. A data conversion device for an ERP system and a target platform, the device 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;
the conversion module is used for converting the order information based on the mapping relation when detecting the order information which is created by the ERP system and comprises at least one piece of second metadata, and uploading the converted order information to the target platform;
optionally, the data conversion system is any one of an ERP system and an intermediate system;
the intermediate system establishes communication connection with the ERP system, and establishes communication connection with the target platform;
if the data synchronization system is an intermediate system;
the conversion module is specifically configured to, when converting the order information based on the mapping relationship:
calling an order conversion interface of an intermediate system, and converting the order information based on the mapping relation;
the ERP system is provided with a trigger, and the conversion module is specifically used for when detecting order information created by a user in the ERP system:
when a trigger instruction sent by the trigger is received, determining that the user creates order information in an ERP system;
the conversion module is specifically configured to, when calling an order conversion interface of an intermediate system and converting the order information based on the mapping relationship:
based on the trigger instruction, calling an order conversion interface of an intermediate system, and converting the order information based on the mapping relation;
the conversion module is specifically configured to, when uploading the converted order information to the target platform:
and uploading the converted order information to the target platform through the order conversion interface.
5. The apparatus of claim 4, 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 relation, and obtaining the converted order information comprising the at least one first metadata;
the conversion module is specifically configured to, when uploading the converted order information to the target platform:
obtaining a format template of a target platform;
and uploading the converted order information to the target platform based on the format template.
6. An electronic device, comprising:
the electronic device includes a memory and a processor;
the memory stores a computer program;
the processor for performing the method of any of claims 1-3 when the computer program is run.
7. A computer readable medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements the method of any of claims 1-3.
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 CN110955715A (en) 2020-04-03
CN110955715B true 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)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111914011B (en) * 2020-08-06 2024-07-05 上海智众医疗科技有限公司 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

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

Also Published As

Publication number Publication date
CN110955715A (en) 2020-04-03

Similar Documents

Publication Publication Date Title
CN110955715B (en) Data conversion method and device for ERP system and target platform and electronic device
CN102983999B (en) Method for parameter configuration, the system of a kind of monitor supervision platform system and device cluster
US10425295B1 (en) Transformation platform
US20170039298A1 (en) Model driven computational platform for integrated design of products, materials and manufacturing processes
CN109086476B (en) Data processing method for drawing design, PLM plug-in and computing equipment
CN110990048A (en) Method and system for monitoring resource loss of Unity project
CN114594927A (en) Low code development method, device, system, server and storage medium
US20120324379A1 (en) Generating information on application tasks for component objects grouped in a composite object
CN109978512A (en) The control method of project management system, electronic equipment, storage medium
CN113268229A (en) Code generation method and code generation device
Mervyn et al. Fixture design information support for integrated design and manufacturing
CN111324470A (en) Method and device for generating information
CN108763127B (en) Method for realizing Modbus adapter capable of realizing interconversion of source data and target data
CN109840246A (en) It is a kind of for calculating the method and device of the historical data of target signature
JP2005346280A (en) Traceability system, trace information management method, trace information management program and recording medium
CN109150993B (en) Method for obtaining network request tangent plane, terminal device and storage medium
US20170286181A1 (en) Deployment and execution of sensing and computational tasks in a network of computing devices
CN113313492A (en) Electronic certificate generation method and related device
CN112395575A (en) Authority management method, device, equipment and storage medium
CN111224977A (en) Process configuration method and system
KR20200123624A (en) Cloud-based application development platform
US11270459B2 (en) Enterprise system augmented reality detection
CN111274051B (en) Data processing method and device, electronic equipment and computer readable storage medium
JP7386777B2 (en) Work instruction device and work instruction method
CN109445964B (en) Method and device for data transmission with SAP system in external system

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