Automated Fueling Data Sorting via Filename Parsing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current methods for processing, sorting, and archiving fueling station data are inefficient and time-consuming, often requiring manual intervention and specialized software, which can be impractical due to access limitations and the complexity of file information.
Innovation Solution
A system comprising a vehicle with fuel sensors, a database for storing fueling station data, and a server that converts and processes vehicle fueling data to generate a fueling data file, which is then sorted and stored automatically based on extracted metadata and lookup tables.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If manual processing methods are used to sort and archive fueling station data, then data can be organized, but the process is inefficient and time-consuming
Solution Approach 1:
The system enables self-service automation where the server automatically processes, sorts, and archives fueling station data files without requiring manual user intervention. The server extracts metadata from filenames, queries the database for sorting information, and automatically moves files to appropriate directories, making the system serve itself rather than requiring human operators to handle each file manually.
Solution Approach 2:
The patent replaces the mechanical manual process of opening, reading, and sorting files with an automated electronic system. The server uses script-based automation to parse filenames, extract metadata, query databases, and move files automatically, substituting human mechanical actions with automated computational processes that significantly improve efficiency and reduce time loss.
2Reliability
If specialized software is required to access and process fueling data files, then accurate data processing can be achieved, but access limitations reduce ease of operation
Solution Approach 1:
The server acts as an intermediary between the fueling data files and the user. Instead of requiring users to directly access specialized processing software and open individual files, the server automatically processes the files in the background, extracting necessary information and organizing data. This intermediary approach maintains data processing accuracy while eliminating the need for users to have direct access to specialized software.
Solution Approach 2:
The system creates and processes copies of the fueling data files automatically. The server receives files, creates processed versions with extracted metadata and organized structures, and stores these copies in appropriate locations. This copying mechanism allows accurate data processing to occur automatically without requiring users to directly manipulate the original files or access specialized software interfaces.
3Productivity
If files are processed manually to extract sorting information, then data can be organized correctly, but the complexity of file information makes the process impractical
Solution Approach 1:
The server extracts only the necessary metadata information from the filenames rather than requiring manual analysis of entire files. By parsing filenames to extract key identifying information and querying the database for additional sorting criteria, the system takes out only the essential data needed for sorting, avoiding the complexity of manually processing complete file contents while maintaining accurate organization.
Solution Approach 2:
The patent replaces the complex manual process of analyzing file information with automated script-based processing. The server uses programming scripts to automatically parse filenames, extract metadata, query databases, and determine sorting criteria, substituting the complex mechanical task of manual file analysis with automated computational processes that handle complexity efficiently and scale to large numbers of files.
Data Source
AI summary
Methods, systems, and devices for generating, sorting and/or storing fueling station data. A method may include storing a fueling data file in a temporary location on a memory. The method may include parsing a filename of the fueling data file to obtain a file number and scanning one or more rows of a table for the obtained file number. The method may include extracting one or more strings from a row of the one or more rows that includes the obtained file number. The method may include determining one or more directory names based on the extracted one or more strings and one or more lookup tables. The method may include generating a directory path based on the determined one or more directory names, and moving and storing the fueling data file from the temporary location to a destination location based on the determined directory path.