CN101923538B - Application of configurable batch report in lyophilizer - Google Patents
Application of configurable batch report in lyophilizer Download PDFInfo
- Publication number
- CN101923538B CN101923538B CN2010102587854A CN201010258785A CN101923538B CN 101923538 B CN101923538 B CN 101923538B CN 2010102587854 A CN2010102587854 A CN 2010102587854A CN 201010258785 A CN201010258785 A CN 201010258785A CN 101923538 B CN101923538 B CN 101923538B
- Authority
- CN
- China
- Prior art keywords
- data
- report
- batch report
- configurable
- excel
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Landscapes
- Drying Of Solid Materials (AREA)
Abstract
The invention provides application of a configurable batch report in a lyophilizer. The main technical means is as follows: using reporting software of the configurable batch report on PC in a control system of the lyophilizer, using an SQL database to store the data and accessing IntellutioniFIX historical data and real time data, Excel and PDF printer applications via the COM interface. Through application of the configurable batch report in the lyophilizer, the contents and the format of the report can be flexibly set to adapt to the variation of the process, the PDF report can be established and the process formula, process data, fault alarm, periodic events, operating records, etc can be reported. The configurable batch report can be used in all the periods of the lyophilizer and a plurality of report templates can be configured in the same period, thus facilitating evaluation of the effectiveness of the production process.
Description
Technical field
The present invention relates to the application of configurable batch report on freeze dryer, that is, and the method for configuration batch report in the process cycle of freeze dryer.
Background technology
Conventional form kind tool (like CrystalReport, XLReporter) etc. can not provide configuration feature, and leads to errors easily to the logic alternative of project.Further, these conventional form kind tools can not provide more dirigibilities to adapt to the variation of technological process.Be not easy to select data recorded in the form, add operations such as trend map shows, modification reporting format.In the process cycle of freeze dryer; For the validity to production run is assessed; Statement form recording process prescription, process data, fault alarm, periodic event and operation note etc. need be set easily and flexibly, and conventional report tool has satisfied not such requirement.So the application process of a kind of configurable batch report on freeze dryer need be provided so that can be applied to all cycles of freeze dryer, make the identical cycle can dispose a plurality of report form templates, satisfy to the validity of production run assess demand.
Summary of the invention
In view of this, the invention provides the application of configurable batch report on freeze dryer.
Configurable batch report provided by the invention in the major technique means of the application on the freeze dryer is: the form software that in the freeze dryer control system, uses configurable batch report on the PC; Use SQL database storage data, through com interface visit Intellution iFIX historical data and real time data, Excel and PDF printer application.
Specify below and in the framework of technique scheme, can select each concrete operations step of implementing.
The form software of said configurable batch report is the form software that uses the high-level programming language exploitation under the Window environment; Concrete way can for: according to the design of the standard of data Layer, interface accessing layer, operation layer and presentation layer; Use open data layout and function interface, be convenient to system maintenance and upgrading.
Through the form software of said configurable batch report, set up the PDF report, recording process prescription, process data, fault alarm, periodic event and operation note are used for the validity of production run is assessed.
Interface through Excel is provided with table content and form, creates the trend map template that shows curve through padding data.
Create the ADO data set of QueryTable object padding data library inquiry in Microsoft Excel.
Use historical data interface accessing iFIX data, transfer to data in the interim form of Excel, the data and the form of operation form; Keep watch on the state variation of the process cycle of freeze dryer, when process cycle finishes, call the batch report processing logic.
The beneficial effect of the application of configurable batch report provided by the invention on freeze dryer is: content and form that form can be set flexibly are to adapt to the variation of technological process; Can set up the PDF report; Recording process prescription, process data, fault alarm, periodic event and operation note etc.; Configurable batch report can be used for all cycles of freeze dryer, and the identical cycle can be disposed a plurality of report form templates, thereby is convenient to the validity of production run is assessed.
Embodiment
Through embodiment the present invention is further specified below.
The freeze dryer configurable batch report is the form software that uses the high-level programming language exploitation under the Window environment; Use SQL database storage data, through com interface visit Intellution iFIX historical data and real time data, Excel and PDF printer application.
Interface through Excel can be provided with table content and form, comprises header, footer, cell font and text etc.Create the trend map template, padding data just can show curve in the data field of trend map association, and the size of insertion and self-defined picture can show Logo information.
For improving the transmission speed of Large Volume Data, use array to fill form fast.Create the ADO data set of QueryTable object padding data library inquiry in form, with conventional method mutually specific energy increase substantially read or write speed.
Use historical data interface accessing iFIX data, transfer to data in the interim form of Excel, the data and the form of operation form.The state variation of monitoring period is called the batch report processing logic in the time of end cycle.
Batch report requires data accurate, complete, uses PDF file protection data not to be modified.Selected arbitrarily from 1 minute to 30 minutes the interval time of process data, and short interval makes data more accurate, and long interval is used for the record in cycle more than 3 days.In form, can add a plurality of trend maps, comprise a plurality of parameters in each trend map.Can be arranged in together the easy-to-read periodic process to warning and process data according to time sequencing.
In the Windows forms, realize whole operations of configuration, the interface is simple, orderliness is clear.Form after the configuration is kept in the template, can revise the template that has disposed, also can save as new template.In workstation PC start-up period, select template, export batch report during end cycle automatically.
Further specify as follows in the face of technical essentials more of the present invention down.
The iFIX historical data is kept in the encrypt file, must change after reading and could use.Complete lyophilization cycle data recorded surpasses up to ten thousand, requires slewing rate faster.Use SQL data access service DTS, definition of data connection, querying condition in script by background process inquiry back return results, are saved 60% query time.
Report form template is kept in the Excel file, comprises form and graph object in the template, and software begins automatic padding data according to the position of object oriented anchored object from the cell reference position, carries out font, col width, the adjustment of header forms such as (pin) afterwards.Elder generation in interim form, according to data field size in the capacity adjustment master meter lattice, avoids blocking the white space between the form to deposit data in the time of padding data.Because the process data content difference that the process cycle of freeze dryer comprises is bigger, software is adjusted page layout (laterally/vertically) automatically, and the programming personnel has preestablished operating parameter, and software reads after the parameter according to algorithm process page formatting.If the user has adjusted report form template, program is accomplished similar operation according to new configuration.
The format manipulation of the content influence contiguous data areas of special format in the Excel uses snapshot functions to change into picture to the data field, and can normally show and print.If delegation's cell can hold any more required content, software is filled into the adjacent cells lattice after being split into a plurality of clauses and subclauses to text automatically.Do to guarantee that layout is unified like this, produce unnecessary null when avoiding paging.
The multilingual function that configurable batch report comprises can be exported the batch report of different language, and the report of every kind of language preserves independently pdf document, in the freeze-dry process end cycle, creates.Except the language translation, also want the time format and the unit difference of deal with data.In order to meet the requirement of GAMP4, need to guarantee the unification in the source of data in these reports, avoid hack, the software checking data comprises contents such as cycle length, process data interval and integrality.
Claims (1)
1. the application of configurable batch report on freeze dryer; It is characterized in that; In the freeze dryer control system, use the form software of configurable batch report on the PC; Use SQL database storage data, through com interface visit Intellution iFIX historical data and real time data, Excel and PDF printer application
The form software of said configurable batch report is the form software that uses the high-level programming language exploitation under the Window environment; This form software is according to the standard design of data Layer, interface accessing layer, operation layer and presentation layer; Use open data layout and function interface; Be convenient to system maintenance and upgrading
Through the form software of said configurable batch report, set up the PDF report, recording process prescription, process data, fault alarm, periodic event and operation note are used for the validity of production run is assessed,
Interface through Excel is provided with table content and form, creates the trend map template that shows curve through padding data,
Create the ADO data set of QueryTable object padding data library inquiry in Microsoft Excel,
Use historical data interface accessing iFIX data, transfer to data in the interim form of Excel, the data and the form of operation form; Keep watch on the state variation of the process cycle of freeze dryer, when process cycle finishes, call the batch report processing logic.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102587854A CN101923538B (en) | 2010-08-20 | 2010-08-20 | Application of configurable batch report in lyophilizer |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102587854A CN101923538B (en) | 2010-08-20 | 2010-08-20 | Application of configurable batch report in lyophilizer |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101923538A CN101923538A (en) | 2010-12-22 |
| CN101923538B true CN101923538B (en) | 2012-02-29 |
Family
ID=43338481
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010102587854A Active CN101923538B (en) | 2010-08-20 | 2010-08-20 | Application of configurable batch report in lyophilizer |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101923538B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102663209A (en) * | 2012-04-28 | 2012-09-12 | 楚天科技股份有限公司 | Application of configurable statement on rubber plug or aluminium cap cleaning device |
| CN104035342A (en) * | 2013-03-06 | 2014-09-10 | 中国石油天然气股份有限公司 | Real-time alarm intelligent auxiliary analysis system and method based on IFIX platform |
| CN103955546A (en) * | 2014-05-22 | 2014-07-30 | 山东新华医疗器械股份有限公司 | Configurable batch report generation method for film blowing machine |
| CN108181857B (en) * | 2018-01-22 | 2020-07-28 | 珠海格力电器股份有限公司 | Method and device for controlling operation of equipment unit, display panel and equipment unit |
| US20240202223A1 (en) * | 2022-12-12 | 2024-06-20 | Becton, Dickinson And Company | Methods for iterative batching of figures via user set parameters and systems for same |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070016561A1 (en) * | 2005-07-03 | 2007-01-18 | Research Innovation Aps | Electronic report generator |
| CN101661460B (en) * | 2009-09-18 | 2014-09-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
| CN101777079B (en) * | 2010-03-11 | 2011-11-09 | 浙江鸿程计算机系统有限公司 | Realization method for fast generating electronic report forms |
-
2010
- 2010-08-20 CN CN2010102587854A patent/CN101923538B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN101923538A (en) | 2010-12-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101923538B (en) | Application of configurable batch report in lyophilizer | |
| CN102663103B (en) | Configurable method for automatically generating database and accessing data | |
| CN101661460B (en) | Method and device for generating management system report | |
| CN103324731A (en) | Method and device for converting spreadsheet file into web format file | |
| CN104899384A (en) | Structural health monitoring visualization system based on Revit | |
| CN101634833B (en) | Open type configuration method and system for IO parameters of field device | |
| CN103559184A (en) | Form page display method and device | |
| CN114201090B (en) | Product production abnormality early warning system, method, computer device and storage medium | |
| US20050144615A1 (en) | Modularized custom-developed software package producing method and system | |
| KR101942289B1 (en) | System and method for management electronic testing report, recording medium having program thereof | |
| CN102467534A (en) | Display method and display device for multi-field database | |
| CN102779092B (en) | Quote check system and quote inspection method | |
| Faybishenko et al. | Phenomenological model of nonlinear dynamics and deterministic chaotic gas migration in bentonite: experimental evidence and diagnostic parameters | |
| CN107610738A (en) | A kind of efficient out of memory analysis method | |
| CN110008281A (en) | Method and device for processing visualized data based on Redis database | |
| CN100483428C (en) | RAM listing method and device in logic circuit design | |
| Elrefai et al. | Inhouse design and implementation of well integrity database management system | |
| CN100403322C (en) | Method for realizing random storage package | |
| Radakovic-Guzina et al. | Efficient Multi-Scale, Thermo-Hydro-Mechanical Numerical Model for Simulation of Long-Term Stability of Rooms for Nuclear Waste Disposal | |
| WO2024065338A1 (en) | Electronic kanban determining method and apparatus | |
| KR101866033B1 (en) | Method for Rendering a Grid in a Web Browser and Computing System applying the same | |
| CN105741035A (en) | ERP system data integration method and device | |
| CN117076528A (en) | Visual configuration type data filling method and system | |
| Ingraham | EGS Collab-Hydraulic Fracturing Test Measurements on the 4100L of SURF | |
| King et al. | 6. Interoperability and Integration with EXPRESS |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |