Chromatography Forum

We will be upgrading from our current Access based LIMS system, and our IT guys have asked us to find a way to change the data produced by Chemstation. We currently use the default system of .csv files saved for each sample, which the LIMS can parse. IT would like all samples in a sequence to be transferred to a single file, preferably PDF, for the new LIMS to read.

Does anyone know a way for Chemstation to perform this? It looks like Agilent would recommend ChemStore/OpenLab database to dump the data into, and then query to pull the data from there. I'd like to avoid that route, we only have 6 MSs and would hate to see what that costs!
Thanks

Hi, as I understand, a pdf printer would solve your problem by generating pdf reports for the LIMS to parse. There might be complete freeware PDF printer, but for a company it usally costs. For instance try bullzip with PDF/A format and then buy its commercial variant (biopdf) if more than 10 users - seems to be resonably priced and the commercial version can be intalled on the printserver. Hope it helps.

Csaba has a good solution - we currently use one for clients that need reviewable data. We wrote our own macro to export the data to the LIMS, but your IT folks should be able to get what they need from the PDF solution Csaba suggests.

I believe Chemstation can produce PDF output as well, but I never figured that out.

In ChemStation take a look at Sequence Output. You can print a sequence summary with all the sequence data into a single pdf report

This information will be helpful for those using chem-station for MSD. LIMSLink can be a better option to integrate chemstation with LIMS. LIMSLink configuration capabilities can be used in such a method that it starts meeting your need for laboratory data management.

hope this information helps
Thank You!

Yes, should have specified we are using Chemstation for MSD. I see there is a way to put selected data into a database such as Excel, but we're not sure that will work either.