Title: cst_surplus's Replies | WordPress.org

---

# cst_surplus

  [  ](https://wordpress.org/support/users/cst_surplus/)

 *   [Profile](https://wordpress.org/support/users/cst_surplus/)
 *   [Topics Started](https://wordpress.org/support/users/cst_surplus/topics/)
 *   [Replies Created](https://wordpress.org/support/users/cst_surplus/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/cst_surplus/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/cst_surplus/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/cst_surplus/engagements/)
 *   [Favorites](https://wordpress.org/support/users/cst_surplus/favorites/)

 Search replies:

## Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Store Locator] CSV upload?](https://wordpress.org/support/topic/csv-upload-1/)
 *  [cst_surplus](https://wordpress.org/support/users/cst_surplus/)
 * (@cst_surplus)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/csv-upload-1/#post-4911053)
 * 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
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Store Locator] CSV upload?](https://wordpress.org/support/topic/csv-upload-1/)
 *  [cst_surplus](https://wordpress.org/support/users/cst_surplus/)
 * (@cst_surplus)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/csv-upload-1/#post-4911049)
 * 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: [http://www.viadat.com/products-page/](http://www.viadat.com/products-page/)
   Few small or starting businesses can afford that. And a few will. Especially 
   if presented with good alternatives.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Store Locator] CSV upload?](https://wordpress.org/support/topic/csv-upload-1/)
 *  [cst_surplus](https://wordpress.org/support/users/cst_surplus/)
 * (@cst_surplus)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/csv-upload-1/#post-4911048)
 * 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!:)
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Store Locator] CSV upload?](https://wordpress.org/support/topic/csv-upload-1/)
 *  [cst_surplus](https://wordpress.org/support/users/cst_surplus/)
 * (@cst_surplus)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/csv-upload-1/#post-4911046)
 * 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!

Viewing 4 replies - 1 through 4 (of 4 total)