Alignment of multiple modifiers in excel

[cristina1883]

Hi! I am facing the following issue. I have different behaviors with multiple modifiers for each behavior that are not necessarily the same for each behavior. When I export the observations the name of each modifier I had originally set is replaced with a name such as "Modifier1", "Modifier2" and the modifier values are not aligned properly. I have to set the same set of modifiers (even if not applicable to certain behaviors) to get the excel table properly aligned. Am I doing something wrong when I set up the ethogram?
Thank you in advance

[olivierfriard]

Hi,
what BORIS version are you using?
What kind of export did you use?

[cristina1883]

Hi, thank you for your prompt reply.
I use v 7.13.6. I have tried exporting aggregated events as tsv, csv, xlsx (but the same problem persists) and I get one column named "Modifiers" and then the values of the modifiers separated by a vertical bar.
When I export them as tabulat events I get multiple columns named "Modifier1", "Modifier2" etc

[cristina1883]

Hi again!
I am not sure whether you saw my previous reply.

I use v 7.13.6. I have tried exporting aggregated events as tsv, csv, xlsx (but the same problem persists) and I get one column named "Modifiers" and then the values of the modifiers separated by a vertical bar.
When I export them as tabular events I get multiple columns named "Modifier1", "Modifier2" etc, whereas I would expect the name of each modifier to appear instead and get no data if a given modifier is not considered for a specific behaviour type.

Thank you in advance for your time and help

[CesarUsername]

Hi Cristina,

I have the same problem with the alignment of the modifiers, independent of the type of export I use.
I see you comment is from some time ago, I just would like to know if in the end, you found a way to solve it or if there is anything I am missing.

Thanks in advance

[olivierfriard]

Hi,
can you try the last version (8.27.7) and let me know if the issue is fixed or not?

[CesarUsername]

Hello Olivier,

Thank you for your fast reaction. I removed the old version of Boris, installed the latest version (8.72.7), and did test observation, however the result is the same:

In this example, for both behaviours Modifier 1 corresponds to individuals within 2 meters, but modifier 2, for the case of "Feed", is "Type of food" : "Natural" or "Anthropogenic", but for "Play" and "Receive.groom" , Modifier 2 is "Social partner".

Thanks in advance

[olivierfriard]

Hi,
maybe I did not understand what was the problem...
Could you please send me a table with the modifiers as you'd like them to be and your ethogram?

[CesarUsername]

Hello Olivier,

No problem, I may have not explained it very clearly. Additionally, It may be a feature that would be nice, but not essential because it can be solved easily by working with Excel.

The top is how the observation looks when exported from BORIS, the bottom is how I would prefer it to look with the modifiers with different names separated in columns. But this can be a personal preference, and I completely understand if it is not implemented.

Here I add the ethogram.
Ethogram Cesar.xlsx

Thanks