Multi-Worksheet Field Data Export for Organized Editor Mapping
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In industrial process control systems, extracting and managing data from multiple sources is cumbersome and time-consuming, often resulting in unorganized and confusing export files due to duplicate information and differing data formats, requiring manual manipulation and multiple export files.
Innovation Solution
A data processing system that allows concurrent caching and filtering of data from multiple source files, generating organized export files with intact data associations, enabling efficient export and import of data for testing or other purposes, and allowing additional source files to be added conveniently.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of information
If data is extracted from multiple source files using conventional methods, then data can be obtained from different editors, but the export files become unorganized and confusing with duplicate information and differing data formats
Solution Approach 1:
The patent segments data from multiple source files into separate worksheets within a single export file. Each worksheet contains data from a specific source file with intact data associations, preventing confusion and duplication while maintaining organizational structure.
Solution Approach 2:
The patent introduces an intermediary processing system that receives data from multiple editors, filters and consolidates it according to specified conditions, and exports organized results. This intermediary layer manages the complexity of multiple data sources without requiring manual manipulation.
2Ease of operation
If manual manipulation is used to organize data from multiple sources, then data can be sorted and filtered, but the process becomes time-consuming and cumbersome
Solution Approach 1:
The system performs automated filtering and consolidation of data from multiple source files based on specified conditions, eliminating the need for manual data manipulation. The process serves itself by automatically organizing data into worksheets with intact associations.
Solution Approach 2:
The patent applies filtering conditions to data before export, pre-organizing it into the desired structure. This preliminary action eliminates the need for subsequent manual sorting and filtering, saving time and effort.
3Reliability
If multiple export files are created from different sources, then all data can be preserved, but the files require separate management and manipulation
Solution Approach 1:
The patent merges data from multiple source files into a single export file with multiple worksheets. Each worksheet preserves data from its source file with intact associations, maintaining completeness while simplifying management through a unified file structure.
Data Source
Figure 1
Figure 2
Figure 3
AI summary
A data processing system and method include processing circuitry configured to receive sensor data from a plurality of field devices and convert the sensor data to field data, receive a first source file having first field data exported from a first editor, receive a second source file having second field data exported from a second editor, filter the first and second field data according to one or more conditions, generate multiple worksheets based upon the one or more conditions of the filtered first and second field data, extract the filtered first and second field data from source fields of the first source file and the second source file and map the extracted first and second field data into related worksheet fields of the multiple worksheets, and export the multiple worksheets having the mapped and extracted first and second field data in an export file.