Store Locator Plus® for WordPress Forums Premier Support Need help importing csv file to create a brewery locator

Tagged: 

  • This topic has 1 reply, 2 voices, and was last updated 4 years ago by Cici.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #78964
    Igor De Lima
    Participant

    <span style=”color: #232425; font-family: ‘Open Sans’, ‘Helvetica Neue’, Helvetica, Arial, sans-serif; font-size: 15.4px;”> 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: </span>

    <span style=”color: #232425; font-family: ‘Open Sans’, ‘Helvetica Neue’, Helvetica, Arial, sans-serif; font-size: 15.4px;”>https://docs.google.com/spreadsheets/d/1AZsZW_Kxtpf5ua9CA7Nd6VVfcOUc3MHdRmggObepdcg/edit?usp=sharing</span><br style=”box-sizing: border-box; color: #232425; font-family: ‘Open Sans’, ‘Helvetica Neue’, Helvetica, Arial, sans-serif; font-size: 15.4px; font-style: italic;” /><br style=”box-sizing: border-box; color: #232425; font-family: ‘Open Sans’, ‘Helvetica Neue’, Helvetica, Arial, sans-serif; font-size: 15.4px; font-style: italic;” /><span style=”color: #232425; font-family: ‘Open Sans’, ‘Helvetica Neue’, Helvetica, Arial, sans-serif; font-size: 15.4px;”>This is my first time using this plugin. I want the site to be able to search by PREMISE TYPE, BRAND, and LOCATION.</span>

     
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>Store Locator Plus®:</span>5.3.2</p>
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>Experience:</span>5.3.2</p>
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>Power:</span>5.3.2</p>
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>Premier:</span>5.3.2</p>
     
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>Site URL:</span>http://fcbrewing.staging.wpengine.com</p&gt;
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>This Info Cached:</span>1583168871</p>
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>Network Active:</span>No</p>
     
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>WordPress Version:</span>5.3.2</p>
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>PHP Version:</span>7.3.14-6+ubuntu18.04.1+deb.sury.org+1</p>
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>MySQL Version:</span>5.7.28</p>
     
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>PHP Limit:</span>512M</p>
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>WordPress General Limit:</span>40M</p>
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>WordPress Admin Limit:</span>512M</p>
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>PHP Peak RAM:</span>2 MB</p>
    <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;”><span class=”label” style=”color: #607895; display: inline-block; padding: 4px; text-align: right; width: 180px; margin-right: 6px;”>PHP Post Max Size:</span>100M</p>
     

     

    #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

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.