Unlock instant, AI-driven research and patent intelligence for your innovation.

Report data exporting method

A technology for reporting data and reporting, which is applied in electrical digital data processing, special data processing applications, instruments, etc., and can solve problems such as unfavorable viewing by users, only being able to be saved in multiple times, and poor user experience.

Active Publication Date: 2016-06-15
CHONGQING CHUANYI AUTOMATION
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Originally, when querying report data and exporting the report data to CSV files, the maximum cache space created by the data is 128Kb. If the report data in the query period is too large, only a part of the report data can be saved. Therefore, if the user wants to To save large-capacity report data, you can only save it multiple times; in addition, commas are regarded as separators in the local database, that is, the queried report data will not contain commas, so that after the report data is saved to the CSV file, it cannot Realize automatic sorting, which is not conducive to user viewing and poor user experience

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
  • Report data exporting method
  • Report data exporting method
  • Report data exporting method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] The core of the present invention is to provide A method for exporting report data , no matter how large the report data is, it can be saved at one time, that is, it can be completely exported, and the automatic sorting of CSV files is realized by deleting duplicate report data and adding CSV file column identification processing to the report data, which is convenient The user's view is improved, and the user experience is improved; another core of the present invention is to provide another method for exporting report data.

[0051] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the following will combine the Attached picture , clearly and completely describe the technical solutions in the embodiments of the present invention, obviously, the described embodiments are part of the embodiments of the present invention, but not all of the embodiments. Based on the embodiments of the present inventio...

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 present invention discloses a report data exporting method. The report data exporting method comprises the steps of reading report data found in a local database according to screening information in a reverse chronological order to a data cache where space is limited; performing repeated report data deleting processing and adding CSV file columnar identification processing on the report data in the data cache, and obtaining columnar report data; saving the columnar report data to an assigned report file, and obtaining a CSV file; and if the report data are not completely read, using the time corresponding to the last record in the report data last read in the data cache as a new finish time, and continuing to read the report data in the reverse chronological order by data cache and performing subsequent processing until all the report data are saved as the CSV file. The report data can be completed exported for one time, automatic column arrangement of the CSV file is achieved, and user experience is improved, thereby facilitating checking by users. The present invention also discloses another report data exporting method.

Description

technical field [0001] The invention relates to the technical field of report data export, in particular to a report data export method. Background technique [0002] In the prior art, the PcVue configuration is usually used as the upper computer, and the local database in the configuration is used to save reports. Originally, when querying report data and exporting the report data to CSV files, the maximum cache space created by the data is 128Kb. If the report data in the query period is too large, only a part of the report data can be saved. Therefore, if the user wants to To save large-capacity report data, you can only save it multiple times; in addition, commas are regarded as separators in the local database, that is, the queried report data will not contain commas, so that after the report data is saved to the CSV file, it cannot Automatic sorting is not conducive to user viewing, and the user experience is poor. [0003] Therefore, how to provide a method for expo...

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
IPC IPC(8): G06F17/30
CPCG06F16/24539G06F16/2457
Inventor 刘先振徐光建马乾
Owner CHONGQING CHUANYI AUTOMATION