Problem with state field

I'm having problems with importing the "State" when importing subscribers into Membership Pro.

I have the state in the CSV file but the entries in subscriber admin are blank. This is causing problems as the entry prompts you for the state when you save it as it's a required field.

When looking at the MySQL data base the table osmembership_subscribers has the State with all the valid entries as "NULL" My imported entries have the actual state in the database but as I said it doesn't show up.

How can I get the state to show? Also if I try re-importing the data it creates a duplicate entry.

Jeff

I don't think the table holds the full state name but a two letter code. I'm in the UK and England (which is not a state but Memb Pro think is) appears as EN. What you trying to save in state?

Hi Jeff

If you look at the database table and see the data is NULL, then the state was not imported at all. I think it might happens because the header of the csv file which you use to import has wrong name? Maybe instead of writing state you wrote State... or something like that

Could you please check your csv file (the header row which contains name of the fields) and make sure it is correct?

Regards,

Tuan

Yes that was it, used the wrong filed header. Thanks

Great. Thanks for the update

Tuan