Missing states

Hi Tuan,

I am missing some states in Membership pro, example France & Portugal have no states in the database.

I can add these back in manually, but what are the state-3-codes and state-2-codes? what are these fields used for in membershippro?

thanks
Jim

Hi Jim

Feel free to enter it the same with the name of the state.

However, to save time, I think you can submit a support ticket sending us super admin account of your site. I believe we have states database for these countries from our other extensions, so we can import it for you and you won't have to enter it manually

Regards,

Tuan

Hi Tuan,

Thank you, i have written some sql to copy the state names from OSProperty OSRS_States table so should be ok, and have altered the osmembership_states table fields "state_3_code" & "state_2_code" fields so they are not distinct
Then added FR & FRA for all code fields (for France states).

I just didn't know if this would cause a problem as I didn't know where these state_2_code fields are used. Are they used to send to Paypal?

If you have any data for the real state_3_code & state_2_code would it be possible for you to send them to me?

I am missing France, Portugal, Croatia & Turkey
thanks
Jim

Hi Jim

I don't have that information. It is just needed to pass to Paypal (and infact, it is only important if you are using Paypal Pro).

For now, I think you just need to set it the same with the name of state and it will be OK

Tuan

Thanks for the information.

the fields are char 3 &char 2, so would it be better changing those and import the state_name to both fields, OR, leave the fields and import the ISO country codes FR & FRA to both.

Or doesn't it make any difference?

Jim

state_3_code is not used, so don't worry about it. For state_2_code, I think you can change data type to varchar(50) for example, and then set it to be the same with state_name.

Tuan

Thanks Tuan, that's what i will do.

All the best

Jim