cst_surplus

Hi,
I would think that if you have your wp installed then the database exist already. Which means there’s an admin which you can use to manage database.
(mysql, phpmyadmin)
I haven’t worked with google cloud server yet. Not sure how it works exactly, but if it’s hosting your website, then they should have all the necessary info for “Control Panel” login as well as phpmyadmin (database).
I work mostly with one.com. cPanel and database access is standard there (like most hosts), you can manage everything you need with your account there.

For CSV guidelines check my post above.
Good Luck. )
grtz

Thanks again for a Great Plug-in!
Everything looks and works nicely! Fast support! )

It might not be ultra-customisable in comparison to other popular versions but it has all the needed settings for a good “store locator” and just does what you want. For FREE. (Just like most plugs for WP)

Yes, popular plugs for Store Locator are also free,
BUT… They fail to mention that unless you pay 200-300$ or even more! for an ADD-ON, they don’t really function.
(check for ex: https://www.viadat.com/products-page/
Few small or starting businesses can afford that. And a few will. Especially if presented with good alternatives.

Hi,

Thanks for the swift reply and input! Appreciate it!
However, I’ve been at it for some time now and eventually it DID WORK!:)
I’ve just exported the addresses that were done in WordPress as “CSV for Excel” in phpAdmin (to get a basic mark-up of the fields)
and just replaced the info in Excel with some “test addresses” and info from “Batch Geocode”.
Saved as => CSV (comma delimited) (utf-8)
and imported the whole thing as CSV (not CSV LOAD DATA)

BUT! One thing to note: `
If you use Mac Excel to save as CSV, it uses “;” instead of “,”.
You need to correct it for “Columns separated with” before import.
And put “\” for “Columns escaped with”.

Then just hit “GO” and it should work like a charm!:)

Hi,

Have tried the above method but can’t seem to make it work. My CSV upload results every-time in NULL values or not getting validated at all. I admit I’ve never worked closely with admin, but steps and tutorials are not that hard to understand actually. It’s just I need a little help with a proper CSV.

Can someone please give me a link to a proper CSV file? or show me an image of the proper file structure that’s accepted by phpAdmin tables pls?

Thanks!