Need help importing csv file to create a brewery locator

Tagged: import csv

This topic has 1 reply, 2 voices, and was last updated 4 years, 9 months ago by Cici.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts
March 2, 2020 at 4:52 PM #78964

Igor De Lima
Participant

 I’m having trouble uploading a large csv file to my store locator and getting it all to work. Here is the csv file that I am trying to import: 

https://docs.google.com/spreadsheets/d/1AZsZW_Kxtpf5ua9CA7Nd6VVfcOUc3MHdRmggObepdcg/edit?usp=sharing This is my first time using this plugin. I want the site to be able to search by PREMISE TYPE, BRAND, and LOCATION.

<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>Store Locator Plus®:5.3.2
<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>Experience:5.3.2
<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>Power:5.3.2
<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>Premier:5.3.2

<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>Site URL:http://fcbrewing.staging.wpengine.com
<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>This Info Cached:1583168871
<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>Network Active:No

<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>WordPress Version:5.3.2
<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>PHP Version:7.3.14-6+ubuntu18.04.1+deb.sury.org+1
<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>MySQL Version:5.7.28

<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>PHP Limit:512M
<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>WordPress General Limit:40M
<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>WordPress Admin Limit:512M
<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>PHP Peak RAM:2 MB
<p class=”envinfo” style=”font-size: 13px; line-height: 1.5; margin: 0px; padding: 0px; color: #444444; font-family: -apple-system, system-ui, ‘Segoe UI’, Roboto, Oxygen-Sans, Ubuntu, Cantarell, ‘Helvetica Neue’, sans-serif;”>PHP Post Max Size:100M

March 2, 2020 at 5:01 PM #78968

Cici
Keymaster

This post is all garbled. we cannot access that Google Sheet. Did you save it as a csv file? Please refer to the docs about importing.

https://docs.storelocatorplus.com/q-how-does-store-locator-plus-handle-large-location-list-imports/

Are you seeing any error messages when you import?

Did you use header file names in your sheets which is required to import.

(All field names can drop the leading “sl_” for readability. For example sl_address can become address.)

Any of the links in the back end should redirect you to the docs regarding importing. You may also search the docs site using keywords. If you send a small sample sheet of the csv file you are trying to import , i.e. few rows, we will review for you. ( we will not attempt to import or review hundreds of lines in a spreadsheet)

Please let us know what error message you are seeing in WPSLP, we can sometimes decipher them, check to make sure WPSLP is not restricted by your host security. Also check the other suggestions under the Doc Import troubleshooting.

Thanks
Author

Posts

Viewing 2 posts - 1 through 2 (of 2 total)

The topic ‘Need help importing csv file to create a brewery locator’ is closed to new replies.