Export data from multilingual form in Umbraco Forms
I created a multilingual form using Umbraco Forms 4.1.3 for a survey and I am able to translate each question and corresponding answer using dictionaries like this:
I don't think you can access that information via the XML part of the API as that doesn't output the keys, however, the information that you're after should be in the database, you might just have to query that instead.
You could use the RecordsViewer to loop through the records? It hits the database though, and it can be quite slow if you have a lot of records, but that should allow you to get the keys. There's documentation for this in the Contour Developer docs.
Export data from multilingual form in Umbraco Forms
I created a multilingual form using Umbraco Forms 4.1.3 for a survey and I am able to translate each question and corresponding answer using dictionaries like this:
I found that when collecting survey answers they are a mix of actual translated values of the options like this: (Pseudo csv output)
However, I would like to export analyze the data for both languages together and the mixed language data complicates this a bit.
Is it possible to somehow store the key of the KVP intead of the translated value? (Or perhaps store a numerical answer value instead.)
Any hints are highly appreciated.
Hiya,
I don't think you can access that information via the XML part of the API as that doesn't output the keys, however, the information that you're after should be in the database, you might just have to query that instead.
Thanks Tim. I was hoping for an undocumented feature. I haven't found a schema for the db.
You could use the RecordsViewer to loop through the records? It hits the database though, and it can be quite slow if you have a lot of records, but that should allow you to get the keys. There's documentation for this in the Contour Developer docs.
:)
Thanks I found it in the mean time!:)
is working on a reply...