Edit bulk of listing location?

Hi! I need some tips on how to bulk/edit listings locations, hope you can help me.

I imported from another installation many listings and places, but I noticed that many listings are not set properly the location. For example, in phpmyadmin, I see that many listings have the table “geodir_gd_place_detail”
in field “post_locations” has
[],[],[Italy] instead of [name-of-city],[name-of-region],[Italy]

and the field “post_city” is empty

I know I can fix by editing each one through /wp-admin , but since they are tons of listings, I’d like to know best alternatives

A) if I edit them directly on phpmyadmin, editing inline the fields post_locations and post_city is enough? Or other fields need to be also edited (I don’t know when we edit listing locations through wp-admin which tables/fields the script changes) (see attached)

B) if A is not possible, what the alternative? Export all listings via phpmyadmin into a .csv file similar to the sample you provided in /wp-admin –> csv-import? And then re-import after fixing on the .csv offline?

Thank you for help!