Export "label" instead "name" or do a batch find/replace word

Support
1

Hello ODKers,

I've few questions that would be great to hear from you.

The first question is:

I'm writing my form on Excel, so for instance, I do have this:

type - name - label
select_one city - city_name - What's your city?

the answer is:
name - label
new_york - New York

When I export the data from Aggregate to CSV file, the CSV file is exported
only with the "name" column, for example:

city_name
new_york

Is there a way to export the data with the "label" column instead "name"
column? For example:

What's your city?
New York

Make sense? Sorry if it's confusing.

If there is no way to do that, do you know how to do a batch find/replace
on Excel? For example:

find: new_york
replace: New York

Let me know if you need something else, I hope you can understand my
question!

Thank you!

2

Hi Gustavo, could you share your XLSForm so that everyone can have a look
at your form clearly to help you?

Thanks,
Abbas

··· On Saturday, June 25, 2016 at 2:45:29 AM UTC+5, Gustavo Zanfra Paitch wrote: > > Hello ODKers, > > I've few questions that would be great to hear from you. > > The first question is: > > I'm writing my form on Excel, so for instance, I do have this: > > type - name - label > select_one city - city_name - What's your city? > > the answer is: > name - label > new_york - New York > > > When I export the data from Aggregate to CSV file, the CSV file is > exported only with the "name" column, for example: > > city_name > new_york > > Is there a way to export the data with the "label" column instead "name" > column? For example: > > What's your city? > New York > > Make sense? Sorry if it's confusing. > > If there is no way to do that, do you know how to do a batch find/replace > on Excel? For example: > > find: new_york > replace: New York > > > Let me know if you need something else, I hope you can understand my > question! > > Thank you! >
3

Hello Abbas,

Of course, thank you for your attention, although the XLSForm is in
Brazilian Portuguese, I hope it won't be a problem.

Let me know if you need something else!

Regards,
Gustavo

planilha_desembarque.xlsx (91.1 KB)

··· Em sexta-feira, 24 de junho de 2016 20:48:31 UTC-3, abba...@gmail.com escreveu: > > Hi Gustavo, could you share your XLSForm so that everyone can have a look > at your form clearly to help you? > > Thanks, > Abbas > > On Saturday, June 25, 2016 at 2:45:29 AM UTC+5, Gustavo Zanfra Paitch wrote: >> >> Hello ODKers, >> >> I've few questions that would be great to hear from you. >> >> The first question is: >> >> I'm writing my form on Excel, so for instance, I do have this: >> >> type - name - label >> select_one city - city_name - What's your city? >> >> the answer is: >> name - label >> new_york - New York >> >> >> When I export the data from Aggregate to CSV file, the CSV file is >> exported only with the "name" column, for example: >> >> city_name >> new_york >> >> Is there a way to export the data with the "label" column instead "name" >> column? For example: >> >> What's your city? >> New York >> >> Make sense? Sorry if it's confusing. >> >> If there is no way to do that, do you know how to do a batch find/replace >> on Excel? For example: >> >> find: new_york >> replace: New York >> >> >> Let me know if you need something else, I hope you can understand my >> question! >> >> Thank you! >> >
4

I don't think It is possible to import data by variable labels. After
downloading data you can merge variable names XLSForm with imported data by
your variable names.

Thanks,
Abbas

··· On Saturday, June 25, 2016 at 6:18:04 AM UTC+5, Gustavo Zanfra Paitch wrote: > > Hello Abbas, > > Of course, thank you for your attention, although the XLSForm is in > Brazilian Portuguese, I hope it won't be a problem. > > Let me know if you need something else! > > Regards, > Gustavo > > > > Em sexta-feira, 24 de junho de 2016 20:48:31 UTC-3, abba...@gmail.com escreveu: >> >> Hi Gustavo, could you share your XLSForm so that everyone can have a >> look at your form clearly to help you? >> >> Thanks, >> Abbas >> >> On Saturday, June 25, 2016 at 2:45:29 AM UTC+5, Gustavo Zanfra Paitch wrote: >>> >>> Hello ODKers, >>> >>> I've few questions that would be great to hear from you. >>> >>> The first question is: >>> >>> I'm writing my form on Excel, so for instance, I do have this: >>> >>> type - name - label >>> select_one city - city_name - What's your city? >>> >>> the answer is: >>> name - label >>> new_york - New York >>> >>> >>> When I export the data from Aggregate to CSV file, the CSV file is >>> exported only with the "name" column, for example: >>> >>> city_name >>> new_york >>> >>> Is there a way to export the data with the "label" column instead "name" >>> column? For example: >>> >>> What's your city? >>> New York >>> >>> Make sense? Sorry if it's confusing. >>> >>> If there is no way to do that, do you know how to do a batch >>> find/replace on Excel? For example: >>> >>> find: new_york >>> replace: New York >>> >>> >>> Let me know if you need something else, I hope you can understand my >>> question! >>> >>> Thank you! >>> >>
5

How can I do that?
Thanks!

··· Em sábado, 25 de junho de 2016 04:09:33 UTC-3, abba...@gmail.com escreveu: > > I don't think It is possible to import data by variable labels. After > downloading data you can merge variable names XLSForm with imported data by > your variable names. > > Thanks, > Abbas > > On Saturday, June 25, 2016 at 6:18:04 AM UTC+5, Gustavo Zanfra Paitch wrote: >> >> Hello Abbas, >> >> Of course, thank you for your attention, although the XLSForm is in >> Brazilian Portuguese, I hope it won't be a problem. >> >> Let me know if you need something else! >> >> Regards, >> Gustavo >> >> >> >> Em sexta-feira, 24 de junho de 2016 20:48:31 UTC-3, abba...@gmail.com escreveu: >>> >>> Hi Gustavo, could you share your XLSForm so that everyone can have a >>> look at your form clearly to help you? >>> >>> Thanks, >>> Abbas >>> >>> On Saturday, June 25, 2016 at 2:45:29 AM UTC+5, Gustavo Zanfra Paitch wrote: >>>> >>>> Hello ODKers, >>>> >>>> I've few questions that would be great to hear from you. >>>> >>>> The first question is: >>>> >>>> I'm writing my form on Excel, so for instance, I do have this: >>>> >>>> type - name - label >>>> select_one city - city_name - What's your city? >>>> >>>> the answer is: >>>> name - label >>>> new_york - New York >>>> >>>> >>>> When I export the data from Aggregate to CSV file, the CSV file is >>>> exported only with the "name" column, for example: >>>> >>>> city_name >>>> new_york >>>> >>>> Is there a way to export the data with the "label" column instead >>>> "name" column? For example: >>>> >>>> What's your city? >>>> New York >>>> >>>> Make sense? Sorry if it's confusing. >>>> >>>> If there is no way to do that, do you know how to do a batch >>>> find/replace on Excel? For example: >>>> >>>> find: new_york >>>> replace: New York >>>> >>>> >>>> Let me know if you need something else, I hope you can understand my >>>> question! >>>> >>>> Thank you! >>>> >>>