Hello. I wanted to see if anyone has come across or written a macro to export a batch of files into csv natively within Openlab C.01.10? There was a macro created for this purpose in older versions of ChemStation that was very useful.
Hello. I wanted to see if anyone has come across or written a macro to export a batch of files into csv natively within Openlab C.01.10? There was a macro created for this purpose in older versions of ChemStation that was very useful.
To output just the x,y signal data from ChemStation I know of two options at least. One is given in this community post with links to the original macro posting.
Another solution is attached. This is an older user contributed macro that I have modified. To use the attached macro, first unzip and rename the extracted file to CSVxport.mac. Copy the macro to the CORE ChemStation folder. Load the macro by entering
Macro “csvxport.mac”
at the ChemStation command line.
Then open the sequence container/data set that contains the data you would like to reprocess. My icon looks different because I manually created this one, but it will work on a standard data set as well.
Make certain you are in reprocessing mode and that the loaded method shows (sequence) after it, as outlined above.
Go to Method->Run Time Checklist. Make certain that Standard Data analysis is checked. This is required for the individual file naming to work. Enable the Customized Data Analysis Macro. Hit the drop down and choose Set up Custom Command template…
On that screen choose Add… For the command simply enter SA_SigCSV. You can make the display name anything you like, I made mine Export signal to CSV. Leave everything else checked.
Choose Done in the Custom Command Template window. Now you should be able to choose Export signal to CSV as a custom data analysis macro.
Save the changes to your method and choose Sequence->Start Reprocessing.
The sequence should begin processing from the beginning. Once it has completed you should have a CSV folder with a .csv file for each signal that is loaded for each data file.