Home » DataWarrior » Bug Reports » Macros (Only some of the tasks in the macro run)
Macros [message #124] Wed, 09 December 2015 18:18 Go to next message
Messages: 1
Registered: December 2015
Junior Member
I have saved a macro to incorporate all the tasks I'd like to do with project data - pivot data, show the mean IC50 value for each assay, set the background colour for the mean IC50 values, insert a column showing selectivity for one assay over another and show all the data rounded to 2 significant figures.

On running the macro, only the pivot and calculated column insertion work. The background colour gets added for the last column. Multiple values are not shown as the mean and none of the data is rounded. Saving each task as a separate macro and then using the macro editor to combine them into one macro only pivots the data - all the other macros result in errors (the rounding macros say: macro does not have any tasks, the background colour macros say: column not found, the calculate new column macro says: unrecognised symbol and the rounding macros say: macro does not have any tasks).

I've also tried recording a macro sequence from already pivoted data but this results in the same output as the first macro I recorded. Is it possible to set up a macro to combine these tasks?
Re: Macros [message #127 is a reply to message #124] Sat, 12 December 2015 14:54 Go to previous message
thomas is currently offline  thomas
Messages: 179
Registered: June 2014
Senior Member
Macro tasks in general belong architecturally to the trickiest, least tested and newest functionality. As you have discovered, there is still some functionality that cannot be done in a macro. If you try recording some of these and the following task depend on the oputcome of the non-existing tasks, you get errors as you describe. Still missing tasks are mainly the 'append file', 'combichem library' and some column related tasks. Despite macros are rarely used, I believe that macros have a huge potential and since the last public release I have already fixed lots of macro related issues.

If you can send me a small example, e.g. source file (can be a mockup) and one how it should look like after running the macro, then I promise you that I will make sure that all the needed macro tasks will exist and work well for the next public release. Altogether, most of it should work already. Do you want the mean() function to calculate the mean value of all values of a particular column? This does not yet exist, but could be easily implemented as sum(), median(), max(), min(). Depending on the logMode of the column, the mean would be a normal or an geometrical one.

Previous Topic: Stereo issue?
Next Topic: Name to structure - Triple bonds are not parsed
Goto Forum:

Current Time: Fri Feb 22 16:58:24 CET 2019

Total time taken to generate the page: 0.00368 seconds