acf-city-selector icon indicating copy to clipboard operation
acf-city-selector copied to clipboard

Doesn't import new city via CSV

Open jlb-1985 opened this issue 10 months ago • 8 comments

Hi,

I found another little problem. I want to import a new city via CSV like this "Theux;LK;Luik;BE;Belgium. After I have done this, it says 'Congratulations, you've imported a new city". But the city is not visible in the list.

I've included a debug report. image

jlb-1985 avatar Apr 23 '24 13:04 jlb-1985

Never seen this before, I will check.

Importing is not done through ajax, so wondering why this would pop up

Beee4life avatar Apr 23 '24 14:04 Beee4life

Did you make sure you used the correct separator ?

It makes a difference if you use , or ;.

Beee4life avatar Apr 23 '24 16:04 Beee4life

Yes I did, I used ; I run the debug log manager again and this is the result. It only comes up if the ACF city selector plugin is activated.

image

jlb-1985 avatar May 09 '24 14:05 jlb-1985

Do you know what to do to solve this problem or maybe what I can do?

jlb-1985 avatar May 19 '24 22:05 jlb-1985

I've been out of the country for a while, will try took look into it asap.

Beee4life avatar May 26 '24 19:05 Beee4life

The error mentioned for ACF ajax has to do with the value being passed to it. It looks like an array is passed whereas it should be a string, but I can't reproduce it.

I created a csv with 1 line, like yours. Importing it gave no errors and I saw it correctly in the database as well.

When I tried to search for it in the admin, there was a SQL error, so had to optimise those queries first.

I'm working on a new version, which you can download here to test, if you're interested.

I get no errors in this version yet, when importing and searching.

Beee4life avatar May 26 '24 20:05 Beee4life

Hi,

It's working. If I add a city it isn't visible instantly, but it takes some time.

jlb-1985 avatar Jun 09 '24 15:06 jlb-1985

Hi, i'm happy to hear that.

I think why it doesn't show immediately can be related to this issue, which I still need to fix.

Beee4life avatar Jun 10 '24 12:06 Beee4life