Can you have semi-colons in the choice labels for multiple choice questions that will export to csv/Excel?

For context: We’re trying to use Commcare for our field teams to track info
from their field visits, which we’d like to import into Salesforce. This
works great for the most part BUT multi-select items in Salesforce are
separated by semicolons ex “Server_broken; Networking_broken;
Solar_panels_broken.” However, for multiple choice questions in Commcare,
they export as “Server_broken Networking_broken Solar_panels_broken.” We
tried adding the semi-colons to the choice labels themselves so they were
things like “Server_broken;” but the semi-colon seems to get removed when
exporting to excel/CSV. Wondering if you might any
thoughts/work-arounds/solutions.

Thanks Cory I will do that!

··· On Thursday, February 26, 2015 at 9:55:05 AM UTC-5, Meg North wrote: > > For context: We're trying to use Commcare for our field teams to track > info from their field visits, which we'd like to import into Salesforce. > This works great for the most part BUT multi-select items in Salesforce are > separated by semicolons ex "Server_broken; Networking_broken; > Solar_panels_broken." However, for multiple choice questions in Commcare, > they export as "Server_broken Networking_broken Solar_panels_broken." We > tried adding the semi-colons to the choice labels themselves so they were > things like "Server_broken;" but the semi-colon seems to get removed when > exporting to excel/CSV. Wondering if you might any > thoughts/work-arounds/solutions. >

Hey Meg,

I don’t know offhand of any reason why those should be getting stripped.
Could you report an issue on HQ and link to a form and the export you’re
looking at? Someone on our team will then take a look and follow up.

Cory

··· On Thu, Feb 26, 2015 at 9:55 AM, Meg North wrote:

For context: We’re trying to use Commcare for our field teams to track
info from their field visits, which we’d like to import into Salesforce.
This works great for the most part BUT multi-select items in Salesforce are
separated by semicolons ex “Server_broken; Networking_broken;
Solar_panels_broken.” However, for multiple choice questions in Commcare,
they export as “Server_broken Networking_broken Solar_panels_broken.” We
tried adding the semi-colons to the choice labels themselves so they were
things like “Server_broken;” but the semi-colon seems to get removed when
exporting to excel/CSV. Wondering if you might any
thoughts/work-arounds/solutions.


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.