Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

ERP data and Excel document data exchange method

A data exchange and excel technology, applied in the computer field, can solve the problems of inconvenient inspection and review of the final inspection report filing operation by the quality management department, and achieve the effect of easy promotion, strong reliability and strong practicability

Active Publication Date: 2016-11-09
INSPUR COMMON SOFTWARE
View PDF4 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Due to the wide variety of records that need to be recorded in the research and development of new drugs, and they are scattered, such a large number of forms is inconvenient for the inspection and audit of the quality management department and the filing of the final inspection report

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • ERP data and Excel document data exchange method
  • ERP data and Excel document data exchange method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] The present invention will be further described below in conjunction with specific examples.

[0018] A kind of method of ERP data of the present invention and Excel document data exchange, its specific implementation process is:

[0019] First, you need to define the data source of the current table area;

[0020] According to the above data source, define the configuration table of the system table area, which is used to identify the table including the area number, name information and its corresponding data source;

[0021] Select an existing EXCEL document form template in the system, and use the online editing function of the OFFICE document editor to manually set identifiable system record information for different positions of the EXCEL document form in the system, save the form and location information for future use, and jump after saving Mapping function to system table area and EXCEL table area;

[0022] Complete the mapping between the system table area a...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses an ERP data and Excel document data exchange method. The method includes the specific steps that the data source of a current table area is defined first; according to the data source, a configuration table of a system table area is defined; an EXCEL document table template existing in a system is selected, recognizable system record information is manually set for different positions of an EXCEL document table in the system in cooperation with the online editing function of an OFFICE document editor, the table and position information are saved for use, and after saving, the current interface skips to a system table area and EXCEL table area mapping function; system table area and EXCEL table area mapping is completed; EPR document setting is carried out finally. Compared with the prior art, the ERP data and Excel document data exchange method has the advantages of being high in data exchange efficiency and reliability and the like, and is high in practicability, wide in application range and easy to popularize.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to a method for exchanging ERP data and Excel document data. Background technique [0002] The quality management of new drug research and development is the foundation of the entire drug quality system, and its level determines the final drug quality. Good document and record management is the basic element of R&D quality management and the basic element of drug quality system, which can ensure the orderly and standardized development of drug R&D. The documents in the new drug research and development stage include the systems, procedures, standards, operating procedures involved in the drug research and development process, and the records, reports, and maps generated during the process. The effective operation of a research and development laboratory (institution or department) should be both soft and hard. While improving the laboratory facilities, equipment hardware level an...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/93
Inventor 车向明张国升
Owner INSPUR COMMON SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com