URL Import Issues

New home Forums Gold Add-on Troubleshooting URL Import Issues

This topic contains 8 replies, has 2 voices, and was last updated by  MrCodingRobot 1 month ago.

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #51550

    Hello WP Google Maps Team,

    I have found similar issues in forums but most of them do not elaborate on how to resolve the issue.
    Similar forums that do not resolve my issue:
    1. https://www.wpgmaps.com/forums/topic/import-data-fails/
    2. https://www.wpgmaps.com/forums/topic/csv-import-fails/

    I am currently trying to upload a URL Google Sheets but I keep getting two different errors. Ultimately, I have to get the URL importing working because my project requires automatic importing; therefore, local and manual importing won’t work. I get this error even with the Example.csv file provided in the importing/exporting documentation page, link provided: https://www.wpgmaps.com/documentation/exporting-and-importing-your-markers/

    Error #1:
    If I open the Google Sheets file and publish the file, I get this link:

    https://docs.google.com/spreadsheets/d/e/2PACX-1vSKjkNaZFS0waMaMuditfVERGYhcnogAfd4t8aSfUWIFOgwCEuEnxeonx7Vm4_aifRjpkJqzwkOdHTs/pub?output=csv

    If I use this link, I obtain the following error message when attempting to import the URL file:

    We couldn't establish what kind of data you are trying to import (is the header row missing?)

    Error #2:
    If I just use the shareable link by right-clicking on the CSV file, I get this error instead.

    Shareable Link: https://drive.google.com/open?id=115cooXHs7bDHhJzCfzwv-hNNXAYB2MD8

    Error Message:

    Error parsing JSON: Syntax error

    Conclusion:

    If someone could help me resolve this issue, that would be greatly appreciated. Thank you for your time.

    Warm Regards,
    Eduardo D.

    Attachments:
    You must be logged in to view attached files.
    #51558

    Perry
    Moderator

    Hi Eduardo

    Thank you for getting in touch, sorry to hear you are experiencing issues with the plugin.

    Regarding #1 – your CSV is correctly formatted, so we would have to have FTP access to your site in order to debug this. This would allow us to add a line of code to dump the data your server is receiving as it’s clearly not seeing the CSV as we are at our end.

    Regarding #2, your server is attempting to parse the CSV as JSON. Again, we’d need FTP access to look into this, as it’s likely not receiving CSV data and therefore trying to parse in the default format, which is JSON.

    Would access be permissible?

    Kind regards
    – Perry

    #52569
    This reply has been marked as private.
    #52594

    Perry
    Moderator

    Hi Eduardo

    That’s great, thank you, however we will need the hostname and/or URL to your page as well, please.

    Kind regards
    – Perry

    #53001

    Hello,

    My website’s URL is
    http://southtexashrc.com/
    and the hostname is Bluehost.

    Thank you for your time!

    #53010

    Perry
    Moderator

    Hi Eduardo

    Your server is receiving the following from Google:

    Sorry, the file you have requested does not exist.

    Make sure that you have the correct URL and the file exists.

    It looks like your server is unable to access that sheet.

    Perhaps it works locally because we are both logged in to our respective Google accounts?

    Could you try making the sheet publicly visible to anyone?

    Kind regards
    – Perry

    #53034

    Hello Jerry,

    Sorry for not having the CSV files public, I mistakenly deleted the files and forgot to reupload them. Here is the link:

    https://docs.google.com/spreadsheets/d/e/2PACX-1vS5VV8MUbMqSfDzu3Vh-_oxlNzjiiFY6dbdBrRdzqo6paZNohFGYWmLIhdED71DBuhyQvUMGLup34_X/pub?output=csv

    This the error message I get when using the link:

    We couldn’t establish what kind of data you are trying to import (is the header row missing?)

    #53038

    Perry
    Moderator

    Hi there

    This happens because your server is receiving a “Page not found” from Google, as opposed to the CSV data.

    You’ll need to fix that in order for the server to be able to access your spreadsheet.

    Please can you review your sharing settings for this spreadsheet to ensure your server can access the data, and not receive the “Not found” page?

    Kind regards
    – Perry

    #53304

    Hello,

    *facepalm*
    I figured it out. I tried multiple sharing options but I must have missed the right setting options. Thank you Perry.

    Warm regards,
    Eduardo

    #53307

    Perry
    Moderator

    Hi Eduardo

    We’re really glad to hear it, thanks again for your feedback – we’ll be adding a debugging feature to the Sheets integration so you can see what your server is seeing, so that this becomes easier to deal with in the future.

    Is there anything else we can help you with?

    Kind regards
    – Perry

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

You must be logged in to reply to this topic.