Exporting State Abbreviation instead of ID?

[nutbuster]

Hi, when I go to export a list of participants for an event to excel/csv, everything exports fine, but the State is exported as the State ID, not the State abbreviation or state name, which is rather useless to a person viewing the spreadsheet.

Is there any way to modify it so it exports the state abbreviation instead?  What files/lines would I need to modify?

Thanks!

[Dave Greenberg]

Hmm - what version of CiviCRM are you running? I just did a quick test on our 2.0 demo - CiviEvent >> Find Participants >> Export - and the output CSV gave me State Abbreviations...

You can try this at...
http://drupal.demo.civicrm.org/civicrm/event/search?reset=1&force=1&event=1

and then click the Export action.

[nutbuster]

its the latest version, 2.02 i think? sorry i should have mentioned, its with joomla.  Its for the event registration section.  When I go to a particular event, and want to export a list of the participants/attendees that registered, the state field exports the state ID.

And I just tried it on the demo site you linked to, and that worked...perhaps its something w/ the joomla install of civicrm?

[Dave Greenberg]

What's the URL path you're going to for the export. I just tried on a 1.0.14 Joomla / CiviCRM 2.0.2 install - with these steps:

CiviEvent >> click "show" participants from the dashboard listing for an event
that takes me to http://<joomla_site>/administrator/index2.php?option=com_civicrm&task=civicrm/event/search&reset=1&force=1&event=1

and selected Export Participants from the 'more actions' drop-down.

Is that what you're doing?

[nutbuster]

This is what I did:

CiviEvent >> Then where it lists the events right on that page, I clicked the link "15 (show)" >> Selected export participants from the dropdown, selected the all records radio button >> clicked go >> clicked export participants

URL is http://<joomla_site>/administrator/index2.php?option=com_civicrm&task=civicrm/event/search&reset=1&force=1&event=5

[nutbuster]

Hmm, does anyone know what file has the sql queries that export to the csv? Ive been hunting around and cant seem to find the right place to edit this so I could at least make a temporary fix.

[Donald Lobo]

All the query code is is: CRM/Contact/BAO/Query.php, CRM/Event/BAO/Query.php

the logic is fairly complicated, and the sql is stitched together across quite a few different functions

lobo