CN101923538A - Application of configurable batch report in lyophilizer - Google Patents
Application of configurable batch report in lyophilizer Download PDFInfo
- Publication number
- CN101923538A CN101923538A CN 201010258785 CN201010258785A CN101923538A CN 101923538 A CN101923538 A CN 101923538A CN 201010258785 CN201010258785 CN 201010258785 CN 201010258785 A CN201010258785 A CN 201010258785A CN 101923538 A CN101923538 A CN 101923538A
- Authority
- CN
- China
- Prior art keywords
- data
- batch report
- report
- application
- freeze dryer
- 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.)
- Granted
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 class instrument (as CrystalReport, XLReporter) etc. can not provide configuration feature, and leads to errors easily at the logic alternative of project.Furthermore, these conventional form class instruments can not provide more dirigibilities to adapt to the variation of technological process.The data, the interpolation trend map that are not easy to select to write down in the form show, revise operations such as 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 does not satisfy 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 uses configurable batch report in the freeze dryer control system on the PC, use SQL database storage data, by 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 described 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.
By the form software of described 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 by Excel is provided with table content and form, creates the trend map template that shows curve by padding data.
Create the ADO data set of QueryTable object padding data library inquiry in Microsoft Excel.
Use historical data interface accessing iFIX data, data are transferred in the interim form of Excel, the data and the form of operation form; Monitor 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: the content of form and form can be set flexibly 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, the identical cycle can be disposed a plurality of report form templates, thereby is convenient to the validity of production run is assessed.
Embodiment
Below by embodiment the present invention is further specified.
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, by com interface visit Intellution iFIX historical data and real time data, Excel and PDF printer application.
Interface by 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, data are transferred 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.
Realize whole operations of configuration in the Windows forms, 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.
Below technical essentials more of the present invention are carried out following further specifying.
The iFIX historical data is kept in the encrypt file, must change after reading and could use.The data of complete lyophilization cycle record surpass up to ten thousand, require 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, header form adjustment such as (pin) afterwards.Elder generation in interim form, adjusts data field size in the master meter lattice to deposit data according to capacity, avoids blocking the white space between the form 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 finished 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 that the data field is changed into picture, 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 automatically text being split into a plurality of clauses and subclauses.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, creates in the freeze-dry process end cycle.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 (6)
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, by com interface visit Intellution iFIX historical data and real time data, Excel and PDF printer application.
2. the application of configurable batch report according to claim 1 on freeze dryer, it is characterized in that, the form software of described 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.
3. the application of configurable batch report according to claim 1 on freeze dryer, it is characterized in that, form software by described 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.
4. the application of configurable batch report according to claim 1 on freeze dryer is characterized in that, the interface by Excel is provided with table content and form, creates the trend map template that shows curve by padding data.
5. the application of configurable batch report according to claim 1 on freeze dryer is characterized in that, creates the ADO data set of QueryTable object padding data library inquiry in Microsoft Excel.
6. the application of configurable batch report according to claim 1 on freeze dryer is characterized in that, uses historical data interface accessing iFIX data, data transferred in the interim form of Excel the data and the form of operation form; Monitor 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 true CN101923538A (en) | 2010-12-22 |
CN101923538B 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) |
Cited By (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 |
CN103955546A (en) * | 2014-05-22 | 2014-07-30 | 山东新华医疗器械股份有限公司 | Configurable batch report generation method for film blowing machine |
CN104035342A (en) * | 2013-03-06 | 2014-09-10 | 中国石油天然气股份有限公司 | Real-time alarm intelligent auxiliary analysis system and method based on IFIX platform |
CN108181857A (en) * | 2018-01-22 | 2018-06-19 | 珠海格力电器股份有限公司 | Method and device for controlling operation of equipment unit, display panel and equipment unit |
WO2024129704A1 (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 |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070016561A1 (en) * | 2005-07-03 | 2007-01-18 | Research Innovation Aps | Electronic report generator |
CN101661460A (en) * | 2009-09-18 | 2010-03-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
CN101777079A (en) * | 2010-03-11 | 2010-07-14 | 浙江鸿程计算机系统有限公司 | System structural frame for fast generating electronic report forms and realization method thereof |
-
2010
- 2010-08-20 CN CN2010102587854A patent/CN101923538B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070016561A1 (en) * | 2005-07-03 | 2007-01-18 | Research Innovation Aps | Electronic report generator |
CN101661460A (en) * | 2009-09-18 | 2010-03-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
CN101777079A (en) * | 2010-03-11 | 2010-07-14 | 浙江鸿程计算机系统有限公司 | System structural frame for fast generating electronic report forms and realization method thereof |
Cited By (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 |
CN108181857A (en) * | 2018-01-22 | 2018-06-19 | 珠海格力电器股份有限公司 | Method and device for controlling operation of equipment unit, display panel and equipment unit |
WO2024129704A1 (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 |
Also Published As
Publication number | Publication date |
---|---|
CN101923538B (en) | 2012-02-29 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101923538B (en) | Application of configurable batch report in lyophilizer | |
EP3961464A1 (en) | Nuclear-grade safety display apparatus and configuration-parsing system therefor | |
CN101661460B (en) | Method and device for generating management system report | |
CN109948134A (en) | A kind of report automatic generation method, system and electronic equipment and storage medium | |
US20040133854A1 (en) | Persistent document object model | |
JP2007536640A (en) | Method and apparatus for modifying process control data | |
CN102663103A (en) | Configurable method for automatically generating database and accessing data | |
CN103324731A (en) | Method and device for converting spreadsheet file into web format file | |
ApS | Mosek optimization suite | |
US11063998B2 (en) | System and method for energy management information system reliability assurance | |
CN103559184A (en) | Form page display method and device | |
CN101634833A (en) | Open type configuration method and system for IO parameters of field device | |
CN104298705A (en) | Converting method of relational data and unstructured data | |
US20050144615A1 (en) | Modularized custom-developed software package producing method and system | |
US20050267899A1 (en) | System, method and apparatus for loading text data in a database | |
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 | |
CN104573176A (en) | AutoCAD (computer -aided design) based electrical system data management unit | |
CN102779092B (en) | Quote check system and quote inspection method | |
JP7120268B2 (en) | Work support system, work support device, work support method, work support program, and recording medium | |
CN107610738A (en) | A kind of efficient out of memory analysis method | |
JP4472557B2 (en) | Program creation device | |
Elrefai et al. | Inhouse design and implementation of well integrity database management system | |
CN100483428C (en) | RAM listing method and device in logic circuit design | |
Ortloff et al. | A systematic approach towards reproducibility and tracking of mems process development |
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 |