Post-run Macro to export Signal Raw Data to ASCII

Question

Dear All,

I'm using a GC system 7890A and controlling it with Chem-Station software.

I was wondering if anyone can help me in finding a way to automatically export the signal raw data to an ASCII file, ideally also with the option of choosing the folder destination.

I have already tried to modify the report output, however I managed to produce only a .txt file containing the integrated peaks' area, but not the signal raw data (X and Y values).

I think the answer lies in writing a post-run command/macro to be inserted when I edit the method that I use, however I am really unfamiliar with macro running and would be grateful if you could help me in this, or any other solutions I am not aware of.

Thanks in advance for your time

Best Regards,

Amedeo

hebgent · Accepted Answer

I've attached an updated macro. The exported data files are now called DAD1A.txt, FLD1A.txt, FID1B.txt....and so on. The FLD data does get loaded into the ChromReg register but only if its added in the Signal details. So I've added a LoadFile command at the beginning of the macro which loads all the signals for the current sample and then it can export them all. It will open a "Current Chromatogram(s)" window for them and I can't figure out how to automatically close that window when it's done. Its not a big deal because it will continue to use that one window for every sample in a sequence, leaving you with one window open at the end. Anyway, give this one a try. Tim

hebgent · Answer

I got it fixed. Attached is a new user.mac file. Just replace the other 1 with this 1 and then shutdown and restart Chemstation to load the new macro. Tim

hebgent · Answer

I don't have a FLD and I'm not sure about the register structure. It should be similar to all LC register objects so it might be an easy fix. Would you be able to attach a FLD signal file so I can test the macro? Thanks Tim

hebgent · Answer

Hi Amedeo, Attached is a more complete macro for you. It will export multiple signals and place the ASCII file in the samples data directory. Just put the user.mac file in the C:\Chem32\Core directory and add the "EXPORTSIGNALS" macro to the post run macro in the runtime checklist. Let me know if you have any problems. Tim

hebgent · Answer

Ignore the short macro I posted called EXPORTSIGNAL. That was just a proof of concept and would only export 1 signal to a predetermined location. The user.mac file I post should be left as is and placed in the CORE directory. When you start Chemstation and it initializes it will automatically load any macro in the user.mac file. Then just put EXPORTSIGNALS (no.mac) into the runtime checklist as the post run macro. The macro name inside the user.mac file is EXPORTSIGNALS. Tim FYI, from the commandline you can type SHOW and you will get a dialog box with a bunch of Chemstation parameters / Function and even user macros.

hebgent · Answer

Hi Amedeo,

Here is a quick proof of concept for exporting the signal.

Is this what your looking for? How would you want to choose a folder destination?

Do you know how to load macros at system initialization?

NAME EXPORTSIGNAL

Local TimeSignal !Number of x axis data points

Open "C:\Chem32\Report.txt" for output as #3

TimeSignal = DataCols(ChromReg[1])

for i = 1 to TimeSignal

print #3, Data(ChromReg[1], 0, i), "," , Data(ChromReg[1],1,i)

next i

Close #3

ENDMACRO

Attached is what the macro generated.

Tim

Post-run Macro to export Signal Raw Data to ASCII

Top Replies