Failure in importing Chinese city names:upload was successful, but filed form showed nothing and preview was blank

[arthurcrh]

china.csv

I was uploading cities with chinese names. The verification was successful, but nothing came out: "city name" "state name" "country name" in preview was blank , and the actual field form showed nothing "no country". I assume that something went wrong in the importing function ,using '' instead of "" , resulting in chinese words not loaded.

[Beee4life]

I opened the attached file in a plain text editor and this showed

so not really a surprise.

[arthurcrh]

I said ,it was written in CHINESE. Nothing surprise to me either. It looks totally normal on my computer. I wonder if there is a way to transcode?

[Beee4life]

I'm not sure what the solution is, if there is one... never used non-roman characters.

[arthurcrh]

It seems that I found a possible solution: make a UTF-8 format .csv file change into bgk format, which supports chinese contents.

I`m going to test it on my website later. If it work, I will mark this issue solved then.

[arthurcrh]

Nope. Using bgk is a closer approach, but it did not do as expected. Can you tell me where to find the source code relating to importing csv files into plugin data? I think I can find the clue there once the importing procedure is exposed. Thanks!

[arthurcrh]

Update ： Using notepad, I changed the csv into utf-8 format and saved,uploaded. Now the preview version looks fine. china_1.csv But another problem came out. Although I imported 30+"countries" , and numerous "state/province" (specified by column name), only one item showed up in "country" and "state/province drop down". And the only showed up item in "country" is no even the first input from my file.see it below.

The dropdown gave me 1 item to select from in "country", 1 item to select from in "state/province" , and "city" work seems to be normal .I was checking other issues posted by users here, and found some similar problem like :https://github.com/Beee4life/acf-city-selector/issues/111

What could lead to such porblem? Limited usage of page resources of some kind?

[arthurcrh]

Alright. I just assigned some different values to country code and state code, suddenly some country and state showed up accordingly. It seems that same code somehow jammed the plugins inner logic. The thing is, country and state code is really useless for me (and for a whole lot of people, of which I am certain). Where should I look into and modify some codes so that those two rows are not read by the plugin anymore, not interfering with the end result of dropdown?

[Beee4life]

Using notepad, I changed the csv into utf-8 format and saved,uploaded. Now the preview version looks fine.

Good to hear...

The dropdown gave me 1 item to select from in "country", 1 item to select from in "state/province" , and "city" work seems to be normal.

I'm not sure if I understand. I downloaded your UTF-8 formatted csv and will have to import locally to see what happens.

[arthurcrh]

Using notepad, I changed the csv into utf-8 format and saved,uploaded. Now the preview version looks fine.

Good to hear...

The dropdown gave me 1 item to select from in "country", 1 item to select from in "state/province" , and "city" work seems to be normal.

I'm not sure if I understand. I downloaded your UTF-8 formatted csv and will have to import locally to see what happens.

Thank you. As I wrote in previous two replies, I was assuming that this problem is because of me issuing "AA" for every country code and state code. But after a short test of me issuing different codes to them, more options were displayed in the dropdown, but a lot of selections were still missing.

[Beee4life]

I just imported your csv file successfully but I can't replicate your issue (yet).

I can see multiple countries as you can see.

[Beee4life]

The dropdown gave me 1 item to select from in "country", 1 item to select from in "state/province" , and "city" work seems to be normal.

Your csv contains 1 country and 1 state, so that is correct.

As you can see I can see various cities.

[doocii]

建议还是购买他的插件扩展包，修改城市代码这样的工作方式对于我有些愚蠢。不过是成功了

[Beee4life]

I don't speak chinese, sorry

[Beee4life]

@arthurcrh I updated the plugin, which also includes a for ordering in states. I hope this will also fix your issue (although not sure).

[Beee4life]

Closing due to inactivity.