With Short answer : value saved in database are Y for checked and [empty] for not checked.

No reason to export N in my opinion.

It makes a difference for proper and easy calculations in reports. For multiple choice, empty means that a user didn't see the question, "N" means that he didn't select the subquestion which is a huge difference...

Also, when I export long answers "No" is provided.

@c_schmitz thoughts?

Hi, I have noticed that this new feature has been released: https://github.com/LimeSurvey/LimeSurvey/pull/2843

I have tried to export the responses with the R library including the new options mentioned in the release, e.g. like this "aAdditionalOptions= c('convertY'=TRUE,'yValue'=1,'convertN'=TRUE,'nValue'=0)" but nothing changed. The export result still shows only the "Y" answers. Do I do anything wrong?

Well, maybe there is a confussion.
07641 is for converting Y values to a custom value, like '1'.

The export result still shows only the "Y" answers

This is not addressed by 07641, but should be addressed by this current ticket (18568)

Am I missing something?

Ok, thanks, but I am still confused :-) What is the purpose of 07641 then?

07641: Update API to support the Y/N conversion feature which was only available in frontend.

But this is what I tried to achieve: Convert answercodes from 'Y' or 'N' to another character with the remote control API-function export_responses and it didn't work out for me.

Can you please paste the piece of your code related to the API call?

sure:

library(limer)
options(lime_api = 'https://xxx')
options(lime_username = 'xxx')
options(lime_password = 'xxx')
get_session_key()
answers195486 <- call_limer(method = 'export_responses',
params = list(iSurveyID = 195486,
sDocumentType = 'csv',
sLanguageCode= 'en',
sCompletionStatus='all',
sHeadingType='code',
sResponseType='short',
aAdditionalOptions= c('convertY'=TRUE,'yValue'=1,'convertN'=TRUE,'nValue'=0)))
release_session_key()

I will move all these to the 07641.
Let me know if it is ok to remove the notes from this ticket