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

Method for exporting data of optical spectrum analyzer to SQL database

A spectrum analyzer, data export technology, applied in material excitation analysis, electrical digital data processing, special data processing applications, etc., can solve the problem of inability to analyze data trend management, save labor costs, save time, and reduce operations effect of time

Inactive Publication Date: 2010-06-23
SHANGHAI BAOSTEEL IND TECHNOLOGICAL SERVICE
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The present invention can solve the defect that the OilMWindows application software of the SPECTROIL M spectrometer cannot carry out analysis data tendency management, and expand the function of the OilMWindows application software

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] A method for exporting data from a spectral analyzer to an SQL database, comprising the following steps of using the "spectral data transfer tool" program:

[0018] Step 1, read the TXT file generated by the own software of the spectrum analyzer;

[0019] The OilMWindows application software that comes with the SPECTROIL M spectrometer can save the data of each analysis in a TXT file, which records the value of each element, the date of analysis DATE and the ID of the oil sample. Each analysis data format is fixed, as follows:

[0020] Fe: 0.18: Cu: 0.18: Cr: 0.28: Ni: 0.42: Sn: 1.56: Pb: 0.77: Sb: 0.00: Mn: 0.22: Mo: 0.47: Al: 0.22: Mg: 0.02: Ag: 0.06: Ti: 0.20: B: 0.17: Si: 2.98: Ca: 0.14: Ba: 0.00: Zn: 0.30: P: 144.80: V: 0.57: Na: 0.00: DATE: 03 / 02 / 2005: ID: NY-270101B1-0503:

[0021] Fe: 0.00: Cu: 0.13: Cr: 0.23: Ni: 0.32: Sn: 0.97: Pb: 0.00: Sb: 0.00: Mn: 0.10: Mo: 0.34: Al: 0.05: Mg: 0.01: Ag: 0.04: Ti: 0.15: B: 0.08: Si: 2.96: Ca: 0.00: Ba: 0.00: Zn: 0.17: P:...

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 relates to a method for exporting data of an optical spectrum analyzer to a database, in particular to a method for exporting data of an optical spectrum analyzer with no data management capacity to a database. The method for exporting data of the optical spectrum analyzer to the SQL database comprises the following operation steps by using a 'spectroscopic data transmission tool' program: step one: TXT file generated by software self-contained by the optical spectrum analyzer is read; step two: the TXT file is complied to binary codes; step three: binary codes of helpful numerical values are written in a 'input datasheet' and a 'calculation result sheet' in Microsoft Access for data processing, display and confirmation; and step four: data processed and confirmed by the user is written in the SQL database of a designated server through TCP / IP communication protocols. The invention solves the defect that the application software self-contained by the optical spectrum analyzer cannot conduct analysis data trend management and expands the functions of the application software.

Description

technical field [0001] The invention relates to a method for exporting spectrometer analysis data to a database, in particular to a method for exporting data of a spectrometer without data management capability to a database. Background technique [0002] SPECTROIL M type is an emission spectrometer specially designed and produced by Chaopu Company for lubricating oil component analysis and impurity analysis. Regularly take out oil samples from a system, and analyze the samples to obtain the metal content of moving parts and the concentration of impurities and additive elements. By comparing the obtained data with the previous analysis results, it can be judged whether the mechanical equipment is in normal wear and tear, or Potentially serious problems can be indicated early on. Because of the functions of the SPECTROIL M spectrometer, it is widely used in the state monitoring of mechanical equipment in many production, air and rail transportation enterprises, military, and...

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/30G01N21/62
Inventor 朱磊胡申辉曹新村
Owner SHANGHAI BAOSTEEL IND TECHNOLOGICAL SERVICE