3 Replies Latest reply on Sep 28, 2017 4:01 PM by ryoboyle

Sample Export File

cwevenson Sep 28, 2017 2:53 PM

We are currently working on a proposal to assist a client to transport their HPLC data into a Data historian for reference in other calculations and reports. However, this work is not without a great deal of uncertainly as we do not have any examples of Export files in order to prepare the import software and test it. The client is testing samples from fermentation process and they filter out the active yeast in the sample. They prepare 6 test vials which consist of 3 samples from the prior fermenter running to completion and 3 vials on the currently filling fermenter. They then initiate testing which takes about 2 hours to process the vials. The concern on our end is that we can read in the data but we have no way currently of indexing the data with reference to the Batch IDs for each fermenter running. And thus we require files to determine how to index these files as well as a solid plan on how to import the times.

Would anyone have sample files?

Re: Sample Export File

valentinrusu Sep 28, 2017 3:05 PM (in response to cwevenson)

This will matter greatly on the software and its revision. Is this ChemStation, OpenLAB ChemStation, OpenLAB EZChrome, MassHunter – to name a few?

As far as the sample files, perhaps I'm misunderstanding something, but can your client not provide a few sample files?
Like Show 0 Likes(0)

Actions
- Re: Sample Export File
  
  cwevenson Sep 28, 2017 3:11 PM (in response to valentinrusu)
  
  They use: OpenLAB ChemStation
  
  And no they do not have the knowledge nor the configuration to provide a file. This would be what we would have to turn on during the project and configure.
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Sample Export File
    
    ryoboyle Sep 28, 2017 4:01 PM (in response to cwevenson)
    
    As discussed in your previous post OpenLab API, there are a couple ways to export results from OpenLAB ChemStation. The layout of .XLS results generated from an intelligent report will vary widely depending on the format of that .rdl report template.
    
    For .XML exports the OpenLAB CDS ChemStation XML Connectivity Guide has an example result file that begins on page 55 and a breakdown of the export file schema beginning on page 73.
    1 person found this helpful
    
    Like Show 0 Likes(0)
    
    Actions

Go to original post