Agilent ChemStation. Those macros are files grouping a set of commands. These files possess a.mac extension. ChemStation can import analysis lists and export result files in XML by adding new lines to the ChemStation.ini configuration file. This is a feature to implement the connection with a Laboratory information management system (LIMS). Jul 30, 2011 Replies (4) . Then it is easy to manipulate the data. In MSD Chemstation's data analysis program you can create a custom report which allows you to generate a CRD file which can be opened in Excel, or in my case I use an XLS to CSV converter and parse out all of the in the CRD file. At this point, one can simply create an Excel sheet.
Izzy,
I have faced situations where I have had to export data automated and routinely from chemstation software. My first question is which version of chemstation are you running? There is a difference between MSD Chemstation and Chemstation (i.e. Flash actionscript 3.0 download. for HPLC etc.). Also, I have found it to be much more efficient to use chemstation's built in capabilities to export data and then manage the data in other ways. I have a set up where every time my GCMS runs, chemstation runs a series of macros that basically export all the data about the run into a MySQL DB, and execute a bunch of housecleaning stuff. Then it is easy to manipulate the data. In MSD Chemstation's data analysis program you can create a custom report which allows you to generate a CRD file which can be opened in Excel, or in my case I use an XLS to CSV converter and parse out all of the ____ in the CRD file. At this point, one can simply create an Excel sheet that uses the csv file as it's datasource. This can be formatted any way Excel is capable. This will work, but it is not the best way. Better to import the csv file into a database. Now you have power and manipulate the data in any direction imaginable. Anyway, I might be able to help with more information about your system. I use both types of chemstation. I am not an expert in the macro language. I have found documentation lacking on it, and I have no time to take a class. I have had some success reverse engineering the existing macros (chemstation seems to run entirely on macros). Really though, I like to get the data away from chemstation as fast as possible. It's just old technology that is only good for interfacing the the instruments. IMHO
Good Luck..
Dave
Posted by4 years ago
Archived
I am currently working as an analyst using an Agilent GC-MS.
I was wondering how I could learn how to write macros for automating some of the work in terms of compiling and organizing data in different formats. Are there ways I can learn this stuff for free? Can this knowledge be applied elsewhere, and is it a good/lucrative skill to have?
There is a lot of doom and gloom around the chemistry field, and I thought I would hit two birds with one stone - make my work more efficient and improve some processes, as well as expand my skill-set.
Agilent Hplc Software
Agilent Chemstation Macros
6 comments