codes and labels from collect to .csv file

  • Asked
  • Active
  • Viewed 7004 times
0

Hi, I have a survey with a lot of codes. When I export it to a .csv file I want to export not only the codes but the labels. Is it possible? Thanks

0

Accepted answer

Hi Migonser,

If you use the export button in the code list editor this should alreadt create a CSV file with the values, labels and descriptions of the codes...

See the result of exporting the list :

alt text

After clicking the export button the CSV generated contaisn all of the data *with labels and descriptions for english and spanish, even if the spanish has not been translated yet)!

Example :

"item_code","item_label_es","item_label_en","item_description_es","item_description_en"
"41","Ba","Ba","Boreal coniferous forest","Boreal coniferous forest"
"43","BM","BM","Boreal mountain system","Boreal mountain system"
"42","Bb","Bb","Boreal tundra woodland","Boreal tundra woodland"
"50","P","P","Polar","Polar"
"24","SBWh","SBWh","Subtropical desert","Subtropical desert"
"22","SCs","SCs","Subtropical dry forest","Subtropical dry forest"
"21","SCf","SCf","Subtropical humid forest","Subtropical humid forest"
"25","SM","SM","Subtropical mountain system","Subtropical mountain system"
"23","SBSh","SBSh","Subtropical steppe","Subtropical steppe"
"32","TeDc","TeDc","Temperate continental forest","Temperate continental forest"
"34","TeBWk","TeBWk","Temperate desert","Temperate desert"
"35","TeM","TeM","Temperate mountain system","Temperate mountain system"
"31","TeDo","TeDo","Temperate oceanic forest","Temperate oceanic forest"
"33","TeBSk","TeBSk","Temperate steppe","Temperate steppe"
"15","TBWh","TBWh","Tropical desert","Tropical desert"
"13","TAwb","TAwb","Tropical dry forest","Tropical dry forest"
"12","TAwa","TAwa","Tropical moist forest","Tropical moist forest"
"16","TM","TM","Tropical mountain system","Tropical mountain system"
"11","TAr","TAr","Tropical rainforest","Tropical rainforest"
"14","TBSh","TBSh","Tropical shrubland","Tropical shrubland"
"90","Water","Water","Water","Water"
"0","No data","No data","No data","No data"
0

Accepted answer

Hi, That's an option, but what we need is the possibility to include a column in the CSV data export showing the label of every Code list value. Thanks,

0

Accepted answer

Hello,

I misunderstood the issue. We will add this feature in the coming version of Collect Earth!

/Alfonso

0

Accepted answer

Also in Collect 3.11.9 there is the possibility to export data to CSV including a column with the code list item label, you just have to open the Additional options box and check the relative option for that (the last one in the list).

alt text

Many thanks,
Open Foris Team

0

Accepted answer

Dear Migonser,

This feature has been added to Collect Earth (version 1.4.5).

You will need to update your Collect Earth by going to the main menu Help->Check for updates of Collect Earth

In this new version, when you choose if you want labels or not after you click on the CSV export!

Thank you for the feature request and let us know if there are other features you are missing!

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.