In Europe, the postcode mostly precedes the town name. I could not find any options for changing the order of the columns for these fields, particularly on the constituent report.
Add a comment
|
3 Answers
Have you tried making adjustments under Administer > Localisation > Address Settings?
-
Unfortunately this mechanism allows the layout of labels and displays to be changed, but importantly NOT the ordering of columns in the report: there it is only possible to choose fields, but not to specify their ordering Commented Jun 1, 2015 at 20:36
-
I see -- it wasn't clear to me what you meant. I've updated the question to try to clarify where you need to rearrange things.– LarynCommented Jun 1, 2015 at 20:39
I guess there are 2 routes:
- you switch on the address parsing setting that splits the address line into street_name, number and unit. You then have to develop an extension that builds the street_address into the sequence you want (which is then used throughout the system). We have done this for some Dutch installations, check https://github.com/CiviCooP/org.civicoop.streetformatnl
- leave CiviCRM to do what it does but customize the report where you need it to be in a different sequence.
-
It isn't necessary to parse the address in order to reverse the order of the City and Postal Code fields. Though perhaps @David Christie wants to change more than that.– Joe Murray ♦Commented Jun 3, 2015 at 12:50
-
Actually I just want to use the typical continental European ordering (and not the typical US or UK one!) Commented Jun 3, 2015 at 20:09
-
I've discovered in the meanwhile that one can override the PHP code that is used to build up the data, but it was not so easy to understand how to refer to particular fields in the database. This way, it was possible to swap two fields around relatively easily. Needs programming skills, though Commented Sep 8, 2015 at 19:34
To modify the column order in the Constituent Report you will need to do some development (you can hire a CiviCRM partner to make these sorts of minor modifications for you).
The developer might want to override the function select() and move the fields around as desired, since these are later used to build an array in the same order.
answered Jun 2, 2015 at 21:30
-
I need this feature, it's kind of insane that we can't have the UI re-arrange the order of the fields in the report? Maybe I'm just entitled.– ZacharyCommented Jan 25, 2019 at 22:01