state abbreviation

[island1 +]

In the showlistings.tpl i'm wondering if this:

 {if $sDisState == "Y"}
	     <td{if $entry.class<>""} class="{$entry.class}"{/if}>{$entry.state}</td>
	     {/if}

can be altered to reflect the State Abbreviation insted of the full state name.

I know the data is already stored, just don't know the "name".

Thanks.

[Lhotch +]

Not sure I understand wht you are asking.

Are you saying you want to display the whole state name and not the abbreviation?

Since you have the designer edition you cant do anything at the code level so whats probably easiest would be for you to log into your sites admin, goto settings and "edit states", then edit each state and in the abbreviation field just put in the states full name.

[Mike-N-Tosh +]

Yes, the database table has both the full name and the abbreviation. The abbreviation field is called "abbrev" which is in the {$PREFIX}_state table.

The bigger question would be is the abbrev field available to the template?
It seems that the listings are from the users table which does not store the abbreviation only the full name. So to be able to do what you want you would have to modify several things in order have that available and display in that template. None of which can be done with the Designer version as Larry states.

-Mike

[JP2 Designs +]

Originally Posted by Mike-N-Tosh

So to be able to do what you want you would have to modify several things in order have that available and display in that template.

Hi,
so what do I need to modify for me to be able to do this?

Thanks

[JP2 Designs +]

Can anyone help me hear?
What I am after is the states to be abbreviated instead of the full state. I can change the settings in the admin area but it will only change the state for new listings, i want all new and current to be changed.
http://www.tradinghub.com.au/categor...a8daf535366f19

In other forum topics I have seen you need to add the abbrev table in the sql or something. Any help on what fies i edit etc?

Thanks

[seymourjames +]

You will probably need to edit your database using a tool like phpadmin. However, unless you are proficient, I would not advise you try to do this. The only other way which is safe is to start editing your listings manually using the 68C admin control panel. I believe this is possible and may only be practical if you have a modest number of listings.

[JP2 Designs +]

Yeah not really an option as we have over 700 items already (in just 3 months)...

In looking at past threads, there once was a bit of talk about State Abbreviations and Mike made a comment about editing a few files, I tried this but it did not work. Would this work and what would I need to do?

Adding Provinces and States by country

[Eric Barnes +]

Honestly if this is a must I would either do it one of three ways.

1. Create a custom smarty plugin that pulls out the abbreviation by the state name.
2. Create an include file with an array or state names and abbreviations. Then do some sort of replacement on that. This method would prevent multiple calls to the db.
3. Manually alter the registration and edit pages to use the code then do a manual search and replace in the db.

None of those options would be very simple but should point you in the right direction.

[Lhotch +]

Originally Posted by Eric Barnes

Honestly if this is a must I would either do it one of three ways.

1. Create a custom smarty plugin that pulls out the abbreviation by the state name.
2. Create an include file with an array or state names and abbreviations. Then do some sort of replacement on that. This method would prevent multiple calls to the db.
3. Manually alter the registration and edit pages to use the code then do a manual search and replace in the db.

None of those options would be very simple but should point you in the right direction.

And this is the exact reason VERY careful planning and preparation is needed before taking a site live. Its a lot easier to set your site up right the first time than it is to have to redo things AND mess with a load of data as well.

[seymourjames +]

It happens to to of us Larry - need a Zen Cart genius at the moment that can make it speak French properly. LOL